 |
|
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
DCARS:column hash_value
format 99999999999
DCARS:set echo on
DCARS: select distinct
a.hash_value from v$sqlarea a, v$sqlarea b,
2 Remote DBA_users c
3 where a.hash_value=b.hash_value
and
4 a.parsing_user_id =
c.user_id
5 and c.username='DCARS'
and
6* a.FIRST_LOAD_TIME !=
b.FIRST_LOAD_TIME
HASH_VALUE
------------
-1595172473
-1478772040
-1344554312
-941902153
-807684425
-507978165
-270812489
441376718
784076104
979296206
1765990350
1945885214
Figure 7: Example Hash Select Output
 |
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. |
 |
|
