|
|
| |
 |
|
Diving
Into the Shared Pool - An In Depth Look at Tuning the Shared Pool (Part 1)
Oracle Tips by Mike Ault |
Monitoring and Tuning the Shared Pool
SEE CODE DEPOT FOR FULL SCRIPTS
GROUP BY b.username
UNION
SELECT DISTINCT|
b.username users,
TO_NUMBER(null) garbage,
SUM(c.sharable_mem+c.persistent_mem) Good
FROM
Remote DBA_users b, sys.v_$sqlarea c
SEE CODE DEPOT FOR FULL SCRIPTS
GROUP BY b.username;
Figure 9: Example Script to Create the
SQL_GARBAGE View
 |
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. |
 |
|
|
|
|
