Home > Oracle Database / Applications News > DBAs differ on Oracle's automation efforts
Oracle Database / Applications News:
EMAIL THIS

DBAs differ on Oracle's automation efforts

By Mark Brunelli, News Editor
19 May 2005 | SearchOracle.com

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

The highly anticipated Oracle Database 10g release 2 comes out this summer and promises to address the DBA skills gap by delivering more automated features than any previous version. But some database management professionals think those very features will create an even greater amount of work in the end.

The new and the improved

Oracle is promising several enhancements and new features with Database 10g release 2. Here are some highlights:

  • Automatic Storage Management (ASM) includes multiple disk operations and a non-ASM database migration utility

  • Enhancements to data provisioning and Oracle Streams designed to make it easier to archive, move, and copy large data sets

  • New Fast-Start Failover for automatic fail over to standby databases

  • Integrated data encryption and key management in the database

  • Automated statistics collection directly from memory designed to eliminate the need to execute SQL queries

  • New administrative reports include automatic database workload repository comparison

Source: Oracle Corp.

"Every time we see a new tool come out, we end up having to figure out how to fix the tool," said Ron LaShaw, a DBA with Wachovia Bank in Burlington, N.C. "It will just create new work for the DBA."

LaShaw was among a roomful of other DBAs who got a chance to learn all about Database 10g release 2 during a presentation at the recent International Oracle Users' Group conference in Orlando. But not everyone expressed skepticism over Oracle's automation efforts.

"I'm actually excited about this for about the first time I've ever been excited about a new release of a database," said Blake Wilson, a DBA with SRI International, a research and development company in Menlo Park, Calif.

One thing that those interviewed did agree on is that more automated features won't necessarily lead to fewer jobs for DBAs.

"If you're a DBA worth half his weight in salt, then you ought to evolve along with the industry and become more robust in your skill set," Wilson said. "And, to tell you the truth, there will never be elimination of the DBA. There is just stuff that DBAs do that can't be done by people who don't have our skill set."

The first version of Oracle Database 10g debuted in January of last year and was billed by Oracle as a 'self-healing' database that is designed for grid computing. Oracle says that 10g release 2 will continue the focus on automation and grid computing by enhancing automatic server and disk load balancing and other features.

Release 2 will offer features geared toward developers as well. Application development enhancements include Xquery for queries and mapping of XML results inside the database. And HTML DB has been enhanced with the goal of making it easier for IT pros to deploy Web-based applications.

"I'm kind of in a flux trying to decide if HTML DB is the way to go, or Oracle Portal, in developing user interfaces for our clients," said Brad Nance, a developer with the Oak Ridge National Laboratory in Oak Ridge, Tenn. "Right now I don't know enough to really make a decision."

Despite some misgivings, everyone interviewed at the conference is eagerly anticipating at least one new feature, including the skeptical LaShaw.

"I understand [release 2] has more XML features than 9i. I look forward to that," he said. "Our group believes that XML is where the direction is headed."

Tags: Oracle database design and architectureVIEW ALL TAGS

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Oracle database design and architecture
Why am I receiving Oracle memory allocation errors?
How to join two tables with unique keys in Oracle
Can I check an Oracle instance without logging into the Oracle server?
How does the Oracle LGWR write to online redo log files?
How to determine your SQL database through needs analysis
Breaking down the contenders in the SQL database market
The MySQL open source database in the enterprise
Diving deeper into the SQL database features
What managers should consider when starting a database scaling project
How to use V$SEGMENT_STATISTICS to find the most accessed Oracle table

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
E. F. Codd  (SearchOracle.com)
extent  (SearchOracle.com)
flexfield  (SearchOracle.com)
foreign key  (SearchOracle.com)
multidimensional database  (SearchOracle.com)
object-oriented database management system  (SearchOracle.com)
quad tree  (SearchOracle.com)
relational online analytical processing  (SearchOracle.com)
row  (SearchOracle.com)
splay tree  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Oracle News, Oracle Training, Oracle Management
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts