Oracle 10gs the Cats Meow, Says the IOUG

Movers and shakers at the International Oracle Users Group took a shine to 10g, including its new automated tuning features and a 5-hour install described as "thrilling."

Whether its company flaks, the media or users, everybodys talking about the forthcoming 10g products from Oracle. With Oracle Application Server 10g already out and Oracle Database 10g on the threshold of release, I turned to the International Oracle Users Group to get an update on what early users like and dont like in the new products.

For her part, IOUG President Kim Floss, a database expert who works in the food manufacturing industry, is a self-described tuning nut and is looking forward to diving into 10gs automated SQL tuning. "[Tuning is] a personal passion of mine," she said. "Any new tools and features Oracle comes out with to make my job easier, Im excited to get out and play with."

Normally, when Floss goes through a tuning exercise, she evaluates a boatload of alternatives using manual analysis to work through the proof output. With 10gs new automated SQL tuning features, much of that will be delivered to her in a report.


Click here to read more about 10g automation.

Tuning aficionados will appreciate the significance of automating this work. In previous DBA jobs, Floss said, she has regularly been in situations where a business will try to close its books at months end or years end. The financial side of the house needs to analyze certain reports to get that work done, and it makes a big difference if those reports come out in three days or in 10, or even in 10 minutes versus one minute.


The lineup of sessions in the IOUGs upcoming conference, IOUG Live! 2004, reflect the fact that the IOUGs members share Floss preoccupation with tuning and code optimization.

Heres the lineup of 10g sessions:

  • Welcome to the Oracle10g Data Dictionary and Initialization Parameters
  • Oracle 10g—New SQL Features and Demos
  • 10g Tuning: Tuning Oracle has Radically Changed
  • Quick Web Development using JDeveloper 10g
  • Getting Portal Working With Application Server 10g
  • Application Server 10g—New Features
  • Oracle 10g RAC on Linux—A Practical Perspective
  • Oracle 10g New Features for DBAs
  • SQL Self Management Features in Oracle 10g
  • Discoverer 10g or BI Beans—Which Is Right for You?
  • New Floating Point Number Data Types in Oracle10g
  • Advanced SQL Tips Through Oracle 10g
  • SQL Optimization in Oracle 10g
  • New Features in Oracle 10g Real Application Clusters (RAC)
  • Performance Impact – Using Statistics and Database Features in Oracle8i, Oracle9i R2 & Oracle 10g
  • Feel the Power of Oracle9i and 10g PL/SQL Packages!
  • Expand to the PL/SQL Grid—New Oracle10g and 9iR2 PL/SQL Features
  • Oracle 10g Backup and Recovery New Features
  • Oracle Application Server 10g: Basic Administration
  • Key 10g Features that Oracle9i DBAs Need to Know
  • Oracle 10g ASM vs. VxVM—A Scientific Comparison
  • Embracing the Grid—What Does This Really Mean?
  • Expand to the PL/SQL Grid—New Oracle10g and 9iR2 PL/SQL Features
  • Become a "Grid Aware DBA"—GADBA
  • Transitioning to Oracle Grid – An Architectural Roadmap

Next page: Application Server 10gs thrilling ride.