Help needed with BRtools/sapdba!!!
Hi SAP gurus!!
We have to perform reorganization as part of archiving post processing activity.
pls refer the following link:
It says" If data has been archived or simply deleted and the associated tables were accessed via an index, then index should be reorganized"
1) How we come to know that data is accessed via index?
2)Which is the less time consuming among the below ?
1- table space reorg ; 2- index reorg; 3- table reorg
3) After performing the delete action in archiving will the space gain shows automatically in DB02 or do we need to do a "refresh action" .I heard about update statistics is this is that refresh action (assumed). and how to do this from SAP level( Any Tcode)?
4)We have 4.7kernel rel 640 and oracle 10.2 on AIX , Which is the best applicable? A)BRTOOLS B)sapdba.
5)Which one can be used online(Avoiding downtime) i mean SAPDBA/Brtools
and if downtime is necessary . How to roughly estimate the needed downtime?
6)Can this(reorg) be done through any Tcode and is it(doing with Tcode) good than using SAPDBA/Brtools?
Your responses are highly appreciated
Points would be liberally rewarded.
Thanks a lot in advance!!