Re: AutoTrace

From: Pierre <proussin_at_tactik.com>
Date: Fri, 24 Jul 1998 15:34:44 GMT
Message-ID: <oQ1u1.2649$g41.628824@198.235.216.4>

Hi,

Hi,

    Why would you want to decrease the consistent gets ?

    Consistent gets are the blocks retrieved from an undo segment (RBS)     The before image data of a table being modified.

    What you want to decrease in a database are the physical reads.

    To see your hit ratio:
select username,

       v$session.sid,
       consistent_gets,
       block_gets,
       physical_reads,
       100*(consistent_gets+block_gets-physical_reads)/
           (consistent_gets+block_gets) hit_ratio

from v$session, v$sess_io
where v$session.sid = v$sess_io.sid
and (consistent_gets + block_gets)>0
and username is not null;

        CIAO Pierre Roussin
Certified Oracle DBA
Bell Emergis/ UniConseil/ Admora
4 Place Ville-Marie
Suite 300
Montreal, Quebec, Canada
Tel: (514) 391 6473
fax: (514) 393 0123
e-mail: proussin_at_tactik.com

Huwski wrote in message <35b85a3e.11171193_at_news.geccs.gecm.com>...
>consistent gets in Autotrace - what does this statistic correspond to
>and how do I reduce it?
>
>Thankz.
Received on Fri Jul 24 1998 - 10:34:44 CDT