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: pier paolo Bruno <pbrunoster_at_gmail.com>
Date: Fri, 7 Sep 2012 13:02:33 +0200
Message-ID: <CA+dM1yM8dwP79KeteOe6xvYXj1wu3aYgv9868-7ofrLMu0ZLuA_at_mail.gmail.com>
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
2012/9/7 Raja Subramaniyan <raja.s28_at_gmail.com>
Date: Fri, 7 Sep 2012 13:02:33 +0200
Message-ID: <CA+dM1yM8dwP79KeteOe6xvYXj1wu3aYgv9868-7ofrLMu0ZLuA_at_mail.gmail.com>
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
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-lReceived on Fri Sep 07 2012 - 06:02:33 CDT