Search

Top 60 Oracle Blogs

Recent comments

Home » Monthly archive

March 2010

calculating the SQL_ID hash from the SQL_TEXT

Submitted by khailey on Wed, 2010-03-31 22:07

This really cool:

he explains a how to calculate the sql_id from the SQL_TEXT. The SQL_ID is just a hash of the text.

Analyze this

Submitted by Jonathan Lewis on Wed, 2010-03-31 19:50

Here’s a little script I wrote a few years ago to make a point about using the dbms_stats package. I’ve just re-run it on 10.2.0.3 to see if it still behaves the way it used to – and it does. If you want to be just a little bit baffled, set up a database with [...]

Oracle Plan Stability (Stored Outlines) in PeopleSoft Global Payroll

Submitted by davidkurtz on Wed, 2010-03-31 19:25

A longer version of this posting, with experimental results, is available on my website.

In PeopleSoft for the Oracle DBA, I wrote a page (p. 291) explaining why stored outlines were not suitable for use in PeopleSoft.  Five years later, my view has not significantly changed.  Essentially, stored outlines work best with shared SQL, and there isn't much shared SQL in PeopleSoft, because a lot of it is dynamically generated.

Kevin Closson's Oracle Blog: Platform, Storage & Clustering Topics Related to Oracle Databases

Submitted by kevinclosson on Wed, 2010-03-31 18:13

Calculate SQL_ID and SQL_HASH_VALUE from SQL text

Submitted by tanelpoder on Wed, 2010-03-31 17:39

Some time ago I wrote an article about the 10g+ SQL_ID being just a hash value of the SQL statement text. It’s just like the “old” SQL_HASH_VALUE, only twice longer (8 last bytes instead of 4 last bytes of the MD5 hash value of SQL text).
Slavik Markovich has written a nice python script for calculating SQL_IDs and SQL hash values from SQL text using that approach.
Slavik’s article is available here:

Calculate SQL_ID and SQL_HASH_VALUE from SQL text

Submitted by tanelpoder on Wed, 2010-03-31 17:39

Some time ago I wrote an article about the 10g+ SQL_ID being just a hash value of the SQL statement text. It’s just like the “old” SQL_HASH_VALUE, only twice longer (8 last bytes instead of 4 last bytes of the MD5 hash value of SQL text).

Slavik Markovich has written a nice python script for calculating SQL_IDs and SQL hash values from SQL text using that approach.

Slavik’s article is available here:

http://www.slaviks-blog.com/2010/03/30/oracle-sql_id-and-hash-value/

Share/Bookmark

Calculate SQL_ID and SQL_HASH_VALUE from SQL text

Submitted by tanelpoder on Wed, 2010-03-31 17:39

Some time ago I wrote an article about the 10g+ SQL_ID being just a hash value of the SQL statement text. It’s just like the “old” SQL_HASH_VALUE, only twice longer (8 last bytes instead of 4 last bytes of the MD5 hash value of SQL text).
Slavik Markovich has written a nice python script for calculating SQL_IDs and SQL hash values from SQL text using that approach.
Slavik’s article is available here:

You Buy a NUMA System, Oracle Says Disable NUMA! What Gives? Part III.

Submitted by kevinclosson on Wed, 2010-03-31 05:11

By The Way, How Many NUMA Nodes Is Your AMD Opteron 6100-Based Server?
In my on-going series about Oracle Database 11g configuration for NUMA systems I’ve spoken of the enabling parameter and how it changed from _enable_NUMA_optimization (11.1) to _enable_NUMA_support (11.2). For convenience sake I’ll point to the other two posts in the series for folks [...]

PeopleSoft for the Oracle DBA

Book: 

A PeopleSoft Survival Guide for DBAs and other technicians

A part of the OakTable Press series, PeopleSoft for the Oracle DBA, will teach you a range of techniques for maintaining a PeopleSoft system. You will then become able to implement techniques like indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. It provides answers to common questions that arise when using PeopleSoft on an Oracle database.

The book begins with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. Subsequent chapters explain database structures, connectivity, keys and indexing, the PeopleSoft DDL generation, tablespaces organisation, performance metrics, performance monitoring utilities, and SQL optimization techniques.

Submitted by davidkurtz on Tue, 2010-03-30 21:23

Unconventional Oracle Installs - Part II (Nosejob 2)

Media: 
See video
Submitted by mno on Tue, 2010-03-30 20:51