RE: RE: Dead slow count(*)

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Mon, 9 Feb 2004 16:26:55 -0600
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E936B7@qtiexch2.qgraph.com>

Note one caveat listed in the paper of "so long as the extents are sized as a multiple of (DB_FILE_MULTIBLOCK_READ_COUNT * DB_BLOCK_SIZE)". This can go out the window if PCTINCREASE is used.

One other caveat not mentioned is potential problems in dropping the object. I seem to have a 10-watt bulb in my head dimly glowing that thinks it has to do with the recursive SQL required to manage the TS in the dictionary. Of course, this has nothing to do with COUNT(*), but thought it may be worth mentioning.

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA

-----Original Message-----

From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net] Sent: Monday, February 09, 2004 4:22 PM
To: oracle-l_at_freelists.org
Subject: RE: RE: Dead slow count(*)

here is an old one by Gaja Vaidyanatha. He is a co-auther of perf tuning 101.

http://www.quest-pipelines.com/newsletter-v3/0302_F.htm

I think Niall Litchfield wrote a newer one?

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Mon Feb 09 2004 - 16:26:55 CST