Archive for the ‘11gR1’ Category
Wednesday, July 16th, 2008
Previously I blogged about the new and improved DBMS_STATS.AUTO_SAMPLE_SIZE used to calculate NDV in Oracle 11g and now I wanted to touch on another new feature of DBMS_STATS in 11g: Incremental Global Statistics On Partitioned Tables.
Before Incremental Global Stats (Two-Pass Method)
When DBMS_STATS.GATHER_TABLE_STATS collects statistics on a partitioned table, ...
Posted in 11gR1, Data Warehousing, Optimizer, Oracle, Statistics, VLDB | 4 Comments »
Thursday, May 29th, 2008
Recently I was reading this thread, "Trying to make use of bitmap indexes" on the Oracle Forum. Before I had finished a working example, Jonathan Lewis had posted his response which was on par with my thoughts. Since this is a topic I see frequently, I thought ...
Posted in 10gR2, 11gR1, Data Warehousing, Execution Plans, Optimizer, Performance, SQL Tuning, Statistics, Troubleshooting, VLDB | 6 Comments »
Thursday, May 22nd, 2008
Recently someone showed me a query execution plan with an operation of HASH JOIN ANTI NA. At first, it was thought maybe it was a bug and the operation had a type-o in it, but after further research it was discovered it was a valid operation and a new ...
Posted in 10gR2, 11gR1, Data Warehousing, Execution Plans, Optimizer, Oracle, Performance | 7 Comments »
Wednesday, March 5th, 2008
I recently came across a query in which the Optimizer was making a poor cardinality estimate, which in turn caused inefficient join type, which in turn caused the query to run excessively long. This post is a reenactment of my troubleshooting.
The Suspect SQL
The original SQL was quite large ...
Posted in 10gR2, 11gR1, Data Warehousing, Execution Plans, Optimizer, Oracle, Performance, SQL Tuning, Statistics, VLDB | 11 Comments »
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 | 5 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 »