 |
|
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
The script in Figure 4 produces a report similar to that shown in
Figure 5. The report in Figure 5 shows which users are generating
SQL that hashes to the same values. Once you have a user isolated
you can then run the script in figure 7 to find the bad SQL
statements.
Date:
11/20/98 Page: 1
Time: 11:40 AM
Shared Hash Value Report AULTM
DCARS database
Total Hash SQL With SQL Sharing
USERNAME Values Same Hash Hash
------------------------------ ---------- --------- -----------
AULTM
129 0 100.000
DCARS
6484 58 99.105
MCNAIRT
20 0 100.000
PASSMAP
2 0 100.000
QRemote DBA
109 0 100.000
RCAPS
270 0 100.000
RCOM
342 7 97.953
REPORTS1
28 0 100.000
SECURITY_ADMIN
46 0 100.000
SYS 134 0 100.000
---------- ---------
sum
7564 65
Figure 5: Hash Report
 |
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. |
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
