Re: Trying to find good candidate / objects for re-org in SAP Databases --Weekly objects list, Monthly Objects list and Once in a while ( six month once )

> I am trying to find the good candidate / objects for reorg in SAP
> databases. We are planning to do,
>
> We are planning to do weekly reorg, monthly once and every six month once.
> Accordingly we need to identify the objects and schedule the re-org. Any
> one in the group, provide assistance on that.

Unlike some database platforms (like MSSQL), I would question the need for any reorg in Oracle. The only time I do reorgs are in special cases, like for our upcoming data archival project, where a table's average size (and, most likely, that of its associated indexes) will be permanently reduced. Tom Kyte has a great writeup on the how and the why for reorgs:

http://asktom.oracle.com/pls/askto/f?p=100:11:::::P11_QUESTION_ID:35336203098853

If that URL gets mangled, try: http://tinyurl.com/asktomreorg

GL!

Rich

--
http://www.freelists.org/webpage/oracle-l