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 )

From: Raja Subramaniyan <raja.s28_at_gmail.com>
Date: Fri, 7 Sep 2012 17:04:01 +0530
Message-ID: <CACxKW=RyCws5bpqJcH5+JZe4eGpYir=dXhkt3_oTAOj_tDSr6Q_at_mail.gmail.com>

Scheduled in the sense that, we are trying to segregate the object list, which is good candidate for regular re-org ( weekly once ) , and candidate for short term reorg objects ( monthly once ) and long time re-org objects ( 6 months once ).

It's not scheduled job....

Regards
Raja

On Fri, Sep 7, 2012 at 4:23 PM, pier paolo Bruno <pbrunoster_at_gmail.com>wrote:

> you could have no object that need reorg ...
> use dbms_space.asa_recommendations ... and control the report.
> Are you sure you need scheduled reorg ? is it not better to make reorg
> when you really need it ?
> Bye
> Pier
>
> 2012/9/7 Raja Subramaniyan <raja.s28_at_gmail.com>
>
>> Hi,
>> 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.
>>
>> Note : Databases are SAP Instances. ( ECC, SCM and CRM products )
>>
>> Regards,
>> Raja
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

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

Received on Fri Sep 07 2012 - 06:34:01 CDT