| |
 |
|
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
REM
Script to report on shared pool usage
REM
column shared_pool_used format 9,999.99
column shared_pool_size format 9,999.99
column shared_pool_avail format 9,999.99
column shared_pool_pct format 999.99
@title80 'Shared Pool Summary'
spool rep_out\&db\shared_pool
select
sum(a.bytes)/(1024*1024) shared_pool_used,
max(b.value)/(1024*1024) shared_pool_size,
(max(b.value)/(1024*1024))-(sum(a.bytes)/(1024*1024))
shared_pool_avail,
(sum(a.bytes)/max(b.value))*100 shared_pool_pct
from v$sgastat a, v$parameter b
SEE CODE DEPOT FOR FULL SCRIPTS
'table definiti',
'dictionary cache',
'library cache',
'sql area',
'PL/SQL DIANA',
'SEQ S.O.') and
b.name='shared_pool_size';
spool off
ttitle off
Figure 2: Example Script
to Show SGA Usage
 |
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. |
 |
|
