| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Dead slow count(*)
Rich,
That's true in the DMT world. As most folks should be using LMTs by = now, the concern over dropping objects with lots of extents are = mitigated.
-Mark
-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse_at_quadtechworld.com]
Sent: Monday, February 09, 2004 5:27 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: RE: Dead slow count(*)
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.=20
http://www.quest-pipelines.com/newsletter-v3/0302_F.htm
I think Niall Litchfield wrote a newer one?=20
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |