FAQ
Dan:

I am surprised at the responses you are receiving about doing
Reorgs. Everyone seems to think it's dumb and unnecessary.

We use SAP here at Guidant. It's our 900-lb gorilla application.
As goes SAP, so goes most if not all of the other systems and
databases.

We reorg regularly. We see a palpable return on several levels
from performing this activity. We archive data on a active
schedule, and reorging the tables/tablespaces that have just been
archived brings down the tablespace size, rebuilds the indexes
for improved performance, and allows us better management of our
disk space.

It is for performance and savings that we reorg. We do not need to
buy as much disk every year, and the performance remains acceptable
to the users. I know...everybody says disk is cheap; try telling
my manglement when we submit a purchase req for more EMC disk.
Cheap? Not from our budget!

With that off my chest, we use Quest Live Reorg to perform our
reorgs. Basically, LR does a CTAS, and then mines the redo
logs to keep the current table and the reorged table in sync
until 'cutover', which is when the new table becomes the main
table and the former main table becomes baggage. We cutover
late on Saturday night, when we can safely take SAP down without
impacting too many users - Quest claims to the contrary, SAP does
notice (and complains bitterly) when the cutover happens if you
try it with SAP up. But cutover only takes minutes, and we've
not yet (hear the sound of me knocking on wood, crossing myself,
and lighting a candle) had an issue with the cutover that was
not recoverable.

Cheers,
Mike

-----Original Message-----
From: Dan Hotka
Sent: Sunday, June 13, 2004 7:04 AM
To: oracle-l_at_freelists.org
Subject: SAP Reorgs

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
-----------------------------------------------------------------

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

People

Translate

site design / logo © 2022 Grokbase