Sunday, March 23, 2014

Performance Recommendations for an EBS system

We all are happy working on our EBS Setups.. But do we really know if its setup in the best way ?

The least we can do is to check if the tables are fragmented , if yes how do we defrag them?

Refer to the notes below to get a quick help :

Various Aspects of Fragmentation (Doc ID 186826.1)
Script to Detect Tablespace Fragmentation (Doc ID 1020182.6)
Script to Report Table Fragmentation (Doc ID 1019716.6)



Cheers
Orafolks :)

No comments:

Post a Comment