Re: Re-organising a database?

From: Joel Garry <joel-garry_at_home.com>
Date: 16 Apr 2003 15:10:22 -0700
Message-ID: <91884734.0304161410.6bef374b@posting.google.com>

tim.kearsley_at_milton-keynes.gov.uk (Tim Kearsley) wrote in message news:<725736ef.0304150203.4633e426_at_posting.google.com>...
> joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0304141559.10555173_at_posting.google.com>...
>
> Thanks very much to those who responded to my original post.
>
> Joel, I'm doing some trials on import time using multiple dump files
> rather than one large, compressed file.

Many of us out here breathlessly await your findings! :-)

select name||' = '||value||chr(10)
from v$sysstat
where name = 'redo log space requests'
/

(repeat and see if it is increasing)

set head on

select name,          gets,              misses,
       immediate_gets,  immediate_misses,  sleeps

from v$latch
where name in ('redo allocation', 'redo copy') /

set head off

select 'Ratio of MISSES to GETS: '||

        round((sum(misses)/(sum(gets)+0.00000000001) * 100),2)||'%' from v$latch
where name in ('redo allocation', 'redo copy') /

select 'Ratio of IMMEDIATE_MISSES to IMMEDIATE_GETS: '||

        round((sum(immediate_misses)/
       (sum(immediate_misses+immediate_gets)+0.00000000001) *

100),2)||'%'
from v$latch
where name in ('redo allocation', 'redo copy') /

Just 'cause I've seen these things well-tuned for production but off for large exp/imp.

jg

--
@home.com is bogus.
Guess it's time for extreme deflation in the antiquities market.

Received on Wed Apr 16 2003 - 17:10:22 CDT