RE: SAP Reorgs
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Jun 2004 09:32:07 -0400
The version 8 DB2 UDB manual and the SQL Server 2000 training materials I
have been using both recommend object reorganization for performance
purposes. The emphasis is on index reorganizations and in a multi-database
organization what is a good idea in one db may seem to be a good idea in the
others.
There is no substitute for in-depth knowledge of your tool set, but
knowledge takes time to accumulate and it can be an uphill battle to
convince co-workers to change procedures.
IMHO -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Michael Fontana
Sent: Monday, June 14, 2004 5:28 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: SAP Reorgs
Because of what are mainly RDBMS architectural differences, SAP
recommends frequent reorgs, and even offers programs to do so, for their
DB2 implementations. When I was a db2/Oracle database consultant for a
major oil company, the manager of the group read a document by SAP and
IBM recommending frequent reorgs. Because of that fact, to this day, my
comrades at this company spend one full weekend a month reorging the
Oracle implementations of SAP, even though, in fact, the vendor does not
specifically recommend it for Oracle, nor do they measure to determine
if they receive any gains from the exercise.
I think this falls amound the category of "urban legend" - that a Reorg
of all tablespaces will actually help SAP Oracle performance has never
been proved.
Michael Fontana
Sr. DBA
NTT/Verio
----------------------------------------------------------------
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:
