Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SAP database Reorg - How to group tables??

Status
Not open for further replies.

stratford2000

IS-IT--Management
Nov 19, 2001
2
US
Can anyone give me a good strategy for reorganizing an SAP database (Oracle) and grouping tables into new tablespaces?

I am already planning the "uniform extent" approach endorsed by Oracle (Whitepaper #711), but any thoughts on grouping tables by function or application? And, if so, what should be the groupings?

Thanks.

Charles
 
to find out whether it's senseful to reorganize the tables in new tablespaces : what harddrive-system are you using ?
raid ? harddrive access could be already heuristically optimized and no manual reorg would make sense...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top