Archive for the ‘Performance’ 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, December 5th, 2007
Since the introduction of the Cost Based Optimizer (CBO) in Oracle 7.0, people have been both fascinated and terrified by it and the statistics that feed it. There has long been a belief that a degree in witchcraft or black magic is required to successfully work with the CBO. ...
Posted in Execution Plans, Optimizer, Oracle, Performance, Statistics, Troubleshooting | 8 Comments »
Wednesday, November 21st, 2007
One of the most common performance issues DBAs encounter are bad execution plans. Many try to resolve bad executions plans by setting optimizer related parameters or even hidden underscore parameters. Some even try to decipher a long and complex 10053 trace in hopes to find an answer. ...
Posted in Execution Plans, Optimizer, Oracle, Performance, SQL Tuning, Statistics, Troubleshooting | 23 Comments »
Monday, November 19th, 2007
Oracle OpenWorld 2007 has come and gone and from the Real-World Performance Group's perspective we'd consider it a successful one. The content of this year's presentations seems to have gone over quite well as shown by the number of hallway comments and emails we received. At least two ...
Posted in Data Warehousing, Execution Plans, Optimizer, Oracle, Performance, SQL Tuning, Statistics, VLDB | 3 Comments »
Friday, October 26th, 2007
From time to time I get a little writer's block and sometime search for topics to blog about. I thought, what better way to get ideas for blog posts than to ask the readers of this blog. Here is your chance to influence the topic of upcoming ...
Posted in Oracle, Performance, Troubleshooting | 2 Comments »
Monday, October 1st, 2007
Andrew Holdsworth, the Senior Director of the Real-World Performance Group, will be having two presentation sessions at Oracle OpenWorld 2007, in addition to the Real-World Performance Group Roundtable session. The first presentation is Current Trends in Database Performance and the second one is When to Use the Appropriate Database ...
Posted in Oracle, Performance, Troubleshooting | No 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 »