Oracle Database’ Optimization Criteria
Hi ALL,
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.
Thanks,
Regards,
- R
Software/Hardware used:
Software/Hardware used:
ASKED:
August 6, 2008 9:05 PM
UPDATED:
August 7, 2008 5:38 AM
Answer Wiki:
1. A very good article on techrepublic.com on “<a href="http://articles.techrepublic.com.com/5100-10878_11-5159055.html">Database Optimization: Measuring Oracle disk I/O speed</a>” by Donald Burleson, link is: http://articles.techrepublic.com.com/5100-10878_11-5159055.html will help you on this.
2. On this link just go down to “<a href="http://www.artofprogramming.net/development/oracle-tips.html">Oracle Database Optimization and Performance</a>” and there are 17 links below that to hit the desired area: http://www.artofprogramming.net/development/oracle-tips.html
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
