| || |
Oracle Performance Monitoring!!!!
I have been gone through some articles of Oracle performance monitoring. I need some guidance if anybody has experienced this.
1). What are the important tables which must be monitored, currently we are monitoring two tables SYSSTAT & SESSSTAT. Both are data dictionary tables.
2). What are the important parameters which need to be selected to measure the performance of a DB server. Can we filter only specific parameters from the whole list for this purpose.
Any other article or knowledge base which can help in this regard.
Re: Oracle Performance Monitoring!!!!
this is true that you have to monitor 2 sys tables,
you can run stats pack. this depends on your requirements
what need to be collected.