| |
 |
|
Diving
Into the Shared Pool - An In Depth Look at Tuning the Shared Pool (Part 2)
Oracle Tips by Mike Ault |
A Matter
Of Hashing
Once you have the hash value you can
pull the problem SQL statements from either V$SQLAREA or V$SQLTEXT
very easily, look at Figure 8.
DCARS:select sql_text from
v$sqlarea where hash_value='441376718';
SQL_TEXT
-----------------------------------------------------------------------
SELECT region_code,
region_dealer_num, consolidated_dealer_num,
dealer_name,
dealer_status_code, dealer_type_code, mach_credit_code,
parts_credit_code FROM
dealer
SEE CODE DEPOT FOR FULL SCRIPT
SELECT region_code,
region_dealer_num, consolidated_dealer_num,
dealer_name,
dealer_status_code, dealer_type_code, mach_credit_code,
parts_credit_code FROM
dealer
SEE CODE DEPOT FOR FULL SCRIPT
Figure 8: Example of Statements With Identical Hash Values But
Different SQL
 |
If you like Oracle tuning, you may enjoy the book
Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning
tips & scripts.
You can buy it directly from the publisher and save 30%, and get
instant access to the code depot of Oracle tuning scripts. |
|
