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 23: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 20: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 20: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 19:13

Calculate SQL_ID and SQL_HASH_VALUE from SQL text

Submitted by tanelpoder on Wed, 2010-03-31 18: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 18: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 18: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 18: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 18: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 06: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 [...]