Re: Tool for collecting performance data

My favorite way is with a shell script. It works on any UNIX I've tried as well as under shell on NT.

There are two scripts you need  

   collect.sh
   utlstat.sh

These are available on:   

http://www.geocities.com/oraperf/seminar/scripts.html

Examples of running them:

To collect you run

 $ collect.sh 900 86400

and this will sample all the typical tables once every 15 minutes for 24 hours. It also samples v$session_wait every 15 seconds. It puts the output in files under $MON_LOG or ./LOG/date if the enviroment variable MON_LOG is not set. The script logs in using the enviroment variable SYS, so set it like

   export SYS=sys/change_on_install_at_MYDB

You can then produce report.txt files like:

   utlstat.sh > report.txt #full bstat/estat kind of report    utlstat.sh sevt 10:00_12:00 #wait events between 10 am and noon

You can also diff full report files (as well as utlbstat/utlestat report.txt file - they all have the same structure). See

http://www.geocities.com/oraperf/seminar/utlstat_dif.html

for diffing the report.txt from different days. Its neat to see what is changing and how.

Best Wishes
Kyle Hailey Received on Thu Mar 15 2001 - 06:04:57 CST