| prompt 10.0 Investigation
prompt The Ideal Percent Blocks Coalesced should be 100%
prompt Use "ALter Tablespace <Name> coalesce" to coalesce
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt
ttitle off
prompt
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 11.0 Latch Contention +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt
ttitle left "******** Latch Information ******" Skip 1
column "Redo Type" format A20
column gets format 9,999,990
column WILLING_TO_WAIT format 9,999,990
column misses format 9,999,990
column "IMMEDIATE" FORMAT 999.99
select Name "Redo Type", gets , misses,
decode(gets,0,0,(100*(misses/(gets + misses)))) WILLING_TO_WAIT,
sleeps,immediate_gets,immediate_misses,
decode(immediate_gets,0,0,(100*(immediate_misses/(immediate_gets + immediate_misses)))) "IMMEDIATE"
from v$latch
where name like 'redo%'
order by name
/
prompt
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt 11.0 Investigation
prompt If Willing_to_wait and Immediate is greater than 1%,
prompt increase Log_Simultaneous_copies to twice # of CPUs,
prompt and decrease Log_Small_Entry_Max_Size in init.ora file
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt
ttitle off
prompt
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 11.1 Latch Contention (Reveal Net) +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt
ttitle left "******** Latch Information ******" Skip 1
SELECT a.name,
100. * b.sleeps / b.gets ratio1,
100. * b.immediate_misses / DECODE ( (b.immediate_misses + b.immediate_gets), 0, 1) ratio2
FROM v$latchname a, v$latch b
WHERE a.latch# = b.latch#
AND b.sleeps > 0
/
prompt
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt 11.1 Investigation
prompt
prompt <<<<<<<<<<<<<<<<<<< NOTE: >>>>>>>>>>>>>>>>>>>>>>
prompt
ttitle off
prompt
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 12.0 Tablespace Usage +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
上一页 [1] [2] [3] [4] [5] [6] 下一页 | 
