Structured Data
Oracle Database Real-World Performance & Scalability Blog
- Last build:
- Language:
- en
- Feed URL:
- http://structureddata.org/feed
RSS FEED IDEMS: Structured Data
- Oracle 11g: Real-Time SQL Monitoring Using DBMS_SQLTUNE.REPORT_SQL_MONITOR
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 [...]
Mon, 07 Jan 2008 00:00:13 +0000 - What Are Your System Statistics?
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 queries: select version from v$instance; select pname, [...]
Wed, 02 Jan 2008 23:00:55 +0000 - Oracle Myth Busting: Show, Don’t Tell
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, [...]
Mon, 17 Dec 2007 07:30:48 +0000 - Oracle Optimizer Development Team Starts A Blog
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 [...]
Wed, 05 Dec 2007 18:30:56 +0000 - Oracle Database 11g Release 1 (11.1.0.6.0) for HP-UX PA-RISC
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.
Thu, 22 Nov 2007 01:30:27 +0000 - Troubleshooting Bad Execution Plans
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 [...]
Wed, 21 Nov 2007 10:00:12 +0000 - The Real-World Performance Group: Oracle OpenWorld 2007 Recap
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 Oracle bloggers have put up [...]
Mon, 19 Nov 2007 23:15:14 +0000 - Oracle Database 11g Release 1 (11.1.0.6.0) for Windows x64, Solaris, AIX, HP-UX
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.
Mon, 12 Nov 2007 15:30:57 +0000 - Oracle 11g: Extended Statistics
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.) In Oracle 11g, there has [...]
Wed, 31 Oct 2007 16:00:31 +0000 - Ideas For Oracle Performance Topics
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 [...]
Sat, 27 Oct 2007 01:00:15 +0000
