how to improve tablespace reads efficiency?

From: <carlo.tomassone_at_csi.it>
Date: Thu, 10 Jun 93 09:30:58 +0100
Message-ID: <9306100830.AA25080_at_csiux1.csi.it>


Hi netters,

In Oracle Magazine (summer 1992) Kevin M.Loney indroduces in article 'Lies,Damned Lies, and Hit Ratio' a measure for tablespace reads efficiency, defined as PhyRds/PhyBlkRds.
I put it in my daily statistics and got the following results:

 tablespace      read eff.
 ----------      ---------
 system          25-36%
 rollback        100%
 user indexes    100%
 user tables     33-69%

The questions are:
- why has the tablespace system an efficiency so low?
  • how is it possible to achieve a higher efficiency?

Thanks,
Carlo Tomassone Received on Thu Jun 10 1993 - 10:30:58 CEST

Original text of this message