|
|
| |
 |
|
Diving
Into the Shared Pool - An In Depth Look at Tuning the Shared Pool (Part 2)
Oracle Tips by Mike Ault |
What to
Pin
rem
rem FUNCTION: Report Stored Object Statistics
rem
column owner format a11 heading Schema
column name format a30 heading Object|Name
column namespace heading Name|Space
column type heading Object|Type
column kept format a4 heading Kept
column sharable_mem format 999,999 heading
Shared|Memory
column executions format 999,999 heading Executes
set lines 132 pages 47 feedback off
@title132 'Oracle Objects Report'
break on owner on namespace on type
spool rep_out/&db/o_stat
select
OWNER,
NAMESPACE,
TYPE,
NAME,
SHARABLE_MEM,
LOADS,
EXECUTIONS,
LOCKS,
PINS,
KEPT
from
v$db_object_cache
SEE CODE DEPOT FOR FULL SCRIPTS
and executions>0 and loads>1 and kept='NO'
order by owner,namespace,type,executions desc;
spool off
set lines 80 pages 22 feedback on
clear columns
clear breaks
ttitle off
Figure 2: Script to Show Objects Which
Should Be Kept
 |
For more information on this topic, I recommend Don
Burleson's latest book "Oracle
Tuning: The Definitive Reference".
You can buy it direct from the publisher for 50%-off and get
instant access to the code depot of Oracle tuning scripts: |
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm
 |
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. |
 |
|
|
|
|
