RE: Time for a reorg?

Wow - does nobody reorg databases anymore? ;P

Thanks for all your help guys.. I'll take that as a cue to put some time aside..;0P

-----Original Message-----
Sent: 12 March 2002 11:43
To: Multiple recipients of list ORACLE-L

Does anyone have any "set limits" to know when it would be time for object reorgs?

Firstly, I *know* that the reorg issue is viciously guarded on two sides - those that say reorgs should be done, and those that argue that they are unnecessary in todays environments. I agree with both sides ;P And don't intend this to break out the debate for the nth time..

What I am really after is guidelines from people to their own views of when a reorg is deemed necessary. Things such as percentage of rows that are chained/migrated, or number of extents, or number of extents as a percentage of maxextents or whatever..

Anybody come up with a really cool script that evaluates this - instead of me re-inventing the wheel? I could do this - I just don't really have the time at the moment - so your input is greatly appreciated!

Thanks in advance

Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).