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 allows you to monitor the...
Richard Foote has recently started blogging (as of December 11th) and one of his recent posts discusses Oracle Myths and Information Pollution. I find this topic very interesting as I’m always amazed at the number of people who make changes to their production database based on the results from their favorite Internet search engine,...
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. Some people feel this shroud...
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. While changing parameters or analyzing a 10053...
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 blog posts. I just have a few...
Here is some code to display the HIGH_VALUE/LOW_VALUE columns from USER_TAB_COL_STATISTICS which are stored as RAW datatypes. COLUMN_NAME LOW_VAL HIGH_VAL DATA_TYPE -------------------- ---------------- ---------------- --------- ORGANIZATION_ID 00D000000000062 00D300000000tgk CHAR UG_ID 00500000000008U 00GD0000000mBda CHAR USERS_ID 005000000000063 00G30000000mBcq CHAR IS_TRANSITIVE 0 1 CHAR SUPPRESS_RULES 0 1 CHAR
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 Technology. Full session details are...
In my previous post, Bind Variables, I discussed why using bind variables is one of the most important fundamentals in engineering scalable database applications. I briefly touch on the point that cursor management is also very important. In this post I will go into why this is important, demonstrating by example. As a precursor...
Many of us have been in a situation where the performance of our Oracle database has degraded. Ultimately, we are looking to correctly diagnose the root cause and resolve the performance issue. This is frequently easier said than done. I’d like to offer a few thoughts on the topic that hopefully will make correctly...
Recent Comments