| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SAP Reorgs
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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Sun Jun 13 2004 - 11:52:57 CDT
 |
 |