Periodic performance stats to be collected
Hi, We are planning to collect performance stats periodically (once in a week/month) and store it in a table.
At some point of time, we can review this history data to check the load/performance change in the database.
Also, this can be used to identify if there is any bottle neck or if any particular area require tuning.
Few of the stats which strikes in mind are hit ratios (dictionary/data cache), top n sqls (CPU usage, execution time, I/O etc.), wait events (no. of buffer busy waits, checkpoint incomplete etc.).
Based on your experience, could you suggest the stats that can be collected on weekly / monthly basis which would be helpful to compare the performance of database in present and past.
At some point of time, we can review this history data to check the load/performance change in the database.
Also, this can be used to identify if there is any bottle neck or if any particular area require tuning.
Few of the stats which strikes in mind are hit ratios (dictionary/data cache), top n sqls (CPU usage, execution time, I/O etc.), wait events (no. of buffer busy waits, checkpoint incomplete etc.).
Based on your experience, could you suggest the stats that can be collected on weekly / monthly basis which would be helpful to compare the performance of database in present and past.
0