Oracle-L: RE: consistent gets

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Wed, 08 Oct 2003 00:54:26 -0800
Message-ID: <F001.005D24F0.20031008005426@fatcity.com>

yeah rite, i just test u....

-----Original Message-----
Sent: 08 October 2003 16:29
To: Multiple recipients of list ORACLE-L

Hi,

Consistent gets means the blocks oracle have to visit , it means the real cost of the SQL.(consisteng gets + db block gets) Reduce SGA size has nothing to do with Consistent gets. TO reduce consistent gets, only Tune the SQL or create proper index etc can help.

Zhu Chao.
----- Original Message -----
To: Multiple recipients of list ORACLE-L Sent: Wednesday, October 08, 2003 3:34 PM

If you want to reduce your consistent gets, you can reduce your sga size

-----Original Message-----
Sent: 08 October 2003 14:14
To: Multiple recipients of list ORACLE-L

Hi,

What does the meaning for this consistent gets. Some time my statement return more consistent gets in statistics. How I can reduce this Consistent gets.

Thanks in advance.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: zhu chao
INET: chao_ping_at_vip.163.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sinardy Xing
INET: SinardyXing_at_bkgcomsvc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------