Archive for the ‘11gR1’ Category
Sunday, January 6th, 2008
Many times a DBA wants to know where a SQL statement is in its execution plan and where the time is being spent. There are a few ways to find out this information, but an 11g new feature makes gathering this information extremely easy. Oracle 11g Real-Time SQL Monitoring ...
Posted in 11gR1, Execution Plans, Oracle, Performance, SQL Tuning, Troubleshooting | 11 Comments »
Wednesday, January 2nd, 2008
I've been working on a few test cases and I'm in search of some real-world data. If your production Oracle database uses system statistics, either Workload Statistics or Noworkload Statistics, and you are willing to share them, please post a comment with the output from the following two ...
Posted in 10gR2, 11gR1, Execution Plans, Optimizer, Oracle, Performance, SQL Tuning, Statistics | 29 Comments »
Wednesday, November 21st, 2007
Oracle Database 11g Release 1 (11.1.0.6.0) was released for HP-UX PA-RISC today (11/21). Grab it from the Oracle Database Software Downloads on OTN.
Posted in 11gR1, Oracle | No Comments »
Monday, November 12th, 2007
Oracle Database 11g Release 1 (11.1.0.6.0) was released for Windows x64 on Friday (11/9) and on Solaris (SPARC 64-bit), AIX and HP-UX Itanium today (11/12). Grab it from the Oracle Database Software Downloads on OTN.
Posted in 11gR1, Oracle | No Comments »
Wednesday, October 31st, 2007
In the Real-World Performance Roundtable, Part 2: The Optimizer, Schema Statistics, SQL Tuning at Oracle OpenWorld 2006, I worked an example of how the optimizer can have difficulty estimating the correct cardinality when there is data correlation. (The Zodiac example can be found on pages 46-49 of the presentation.) ...
Posted in 11gR1, Data Warehousing, Execution Plans, Optimizer, Oracle, SQL Tuning, Statistics, VLDB | 8 Comments »
Monday, September 17th, 2007
Many of you are aware of the Oracle 11g Database New Features and while some may be generally interested in new features, one area that I focus on is new features that yield gains in performance. Some of these features can be found in the General Server Performance section ...
Posted in 10gR2, 11gR1, Data Warehousing, Optimizer, Oracle, Performance, Statistics | 15 Comments »
Wednesday, June 6th, 2007
Today Oracle announced that the Oracle Database 11g launch will take place in New York City on July 11th. I'm quite excited about what 11g will bring to the table and after the public release I'll be blogging about the features and options I feel yield added performance and ...
Posted in 11gR1, Oracle | 1 Comment »