RE: LMTS with SAP 4.0B

You also should check the performance a few days later, after the
index has had time to split a few blocks due to insert DML.
 
--Yes, you can run the automated SAP check jobs to check this...
 

Thanks! 

 

________________________________

From: Jared Still [mailto:jkstill@xxxxxxxxx] 
Sent: Tuesday, August 02, 2005 1:17 PM
To: Khemmanivanh, Somckit
Cc: Oracle-L@Freelists. Org (E-mail)
Subject: Re: LMTS with SAP 4.0B


On 8/2/05, Khemmanivanh, Somckit <somckit.khemmanivanh@xxxxxxxxxxxxxxxx>
wrote: 

         
        What is your definition of entire? The other SAP tablespaces can
consume up to 100 GB of space.


What I meant was the space consumed by Tablespaces other than BTAB[D|I]
is 
rather small in comparison.  Leaving them out of the reorg would not
greatly reduce
the time or effort required to reorg. 



        Also note in my experience, you do want to pay attention to the
indexes that sapdba or brconnect is flagging as needing to be 
        re-organized (especially in a DMT setup).
         
        I have read Tom Kytes and other's view on index reorgs and I
agree with them for the most part -- but I was suprised to find that
re-organizing the
        indexes suggested by SAP's tools nearly halved the response
time. I ran tests before the re-org and after the re-org...



You also should check the performance a few days later, after the
index has had time to split a few blocks due to insert DML.



-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: