The other day I was reading the 11g Database VLDB and Partitioning Guide and came across the below execution plan for a partial partition-wise join between sales and customers. --------------------------------------------------------------------------- | Id | Operation | Name | Pstart| Pstop | --------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | | 1 | PX...
How to Display HIGH_VALUE/LOW_VALUE Columns from USER_TAB_COL_STATISTICS
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
Oracle OpenWorld 2007: The Real-World Performance Group (2)
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...
Oracle 11g: Enhancements to DBMS_STATS
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 of the Oracle 11g Database...
Oracle OpenWorld 2007: The Real-World Performance Group
For those of you who will be attending Oracle OpenWorld 2007 and have interests in the database performance area, I would recommend to you to try and attend the Real-World Performance Group Roundtable session. The session starts with a brief “Hot List” of performance issues that have been predominant in the field over the...
Oracle Analytic Functions
Recently, I’ve been quite busy with performance projects and haven’t had the spare time I would like to keep up on my blog. Now that those projects are behind me, I wanted to blog about the use of one feature that made a significant difference in performance on a number of queries for this...
Oracle Database 11g Launch Set For July 11
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 scalability. Stay tuned!
Upscaling Your Database Application Performance: The Array Interface
Personally I believe the array interface is one of the most overlooked methods to increase database application scalability. Any time an application is selecting or inserting more than a single row, performance benefits are generally observed by using the array interface. The Oracle array interface exists for Oracle Call Interface (OCI), PL/SQL, and JDBC....
Upscaling Your Database Application Performance: Cursor Management
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...
Upscaling Your Database Application Performance: Bind Variables
Recently I’ve had several encounters with issues that I would consider to be part of basic scalable application design. These aren’t design issues that are new. Most of them have been addressed many times over the past years, however, they are issues that continually seem to appear. My guess is that it’s not the...
Got Root Cause?
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...
The First Post
Up until this point the only public information sharing I have done has been via the Real-World Performance Round-table discussions at Oracle OpenWorld and, most recently, at the NoCOUG Winter Conference. Going forward I would like to use this blog as an additional channel for discussions with the Oracle user community. Just a bit...
Recent Comments