FAQ
Ron,

Check need_reorg.sql in the DBA tool kit on the Oriole site. Basically
it compares the number of used blocks to the number of blocks
theoretically required to hold the number of rows we have. Pretty
heuristic and assumes that stats are more or less up-to-date, but a good
indicator.

--
Regards,

Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
I have a lot of tables that get loaded and then MOST of the data gets
deleted on a daily basis. Does anyone have a script that will tell me
which
tables need to be reloaded due to a high high-water mark and a low number
of
used blocks?

Ron Smith
Database Administration
rlsmith_at_kmg.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 11, '00 at 8:03a
activeOct 11, '00 at 1:51p
posts2
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase