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@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 7 Sep 2012 17:04:01 +0530
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@xxxxxxxxx>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@xxxxxxxxx>
>
>> 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
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
