Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HELP: Scripts to get "historical" tuning data
Hi,
I would like to know if anyone of you have any good script that can be used to output tuning data in a way that it can easily used to plot graphs with another tool (GNUPlot, excel, RDRTOOL, etc..)
I already have a whole toolkit of scripts that I run on a regular basic to check the health of my databases, but I lack scripts that collect data at regular time intervals so I can EASILY compare current figures with historical data.
This would be useful to determine if the tuning effort was worth it, to do capacity planning, to cross reference wioth OS level historical data and so on.
What I need are the "usual" statistics (I/O's, free space, waits, hit ratios, number of users, etc....)
If anyone has a good script to do this, please point me in the right direction, I don't want to have to reinvent the wheel.
Thanks Received on Tue May 16 2000 - 00:00:00 CDT