I want to know -
- What are the Criteria upon which one can say that Oracle Database is Designed, Set Up and is Running Optimally ?
- Beside BRTOOLS ( in SAP on Oracle Db), is there any other Tool through which we can Validate the Oracle Database Structure ?
( Any Specific Parameters to Mention in init<SID>.sap file - while Using BRTOOLS for the Database Structure Validation ? )
- Is there any Specific Standards Regarding Object Data Store, Load Times, LOBs, Tablespace Locations, Read Write Objects etc ?
- I know the ADDM Utility which would Report the Datablocks with High Concurrent Activities of Read / Write. I am looking for similar tool / utility through which I can find out if there's anything wrong in the Above Mentioned Aspects of Oracle DB and also, the Possible Remedies for it.
Sincerely Appreciate your
time and the valuable inputs.