Re: SAP Reorgs
- From: Jared Still <jkstill@xxxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 13 Jun 2004 10:07:29 -0700
Hi Dan,
First thing to ask is "Why are you doing this?"
"Have you identified transaction that will benefit
from this?"
SAP Basis admins often have it drummed into their
heads that Oracle databases ( or indeed, any database)
must be regularly reorganized.
They do not however have any reason for doing so, other
than "It improves performance", which is a nebulous claim.
If however they identify some processes that they would
like to speed up, perhaps you could talk them them into
some specific tuning targets?
Jared
On Sun, 2004-06-13 at 07:03, Dan Hotka wrote:
> Hi,
>
> I have a gig where they have a rather large SAP database...they want to reorg
> it...then
> periodically reorg it. I'll find out this next week all the specifics.
>
> I am wondering if anyone has any experience in doing reorgs on SAP databases.
> What I should
> look for...what I should look out for...SAP specific things...which objects
> needs periodic
> reorgs...which objects needs a better storage parameters... Any
> help/comments would be most
> appreciated.
>
> Thank you in advance.
>
> Dan Hotka
>
>
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
