• reads output files from
  • generates bstat/estat style report
  • does some over all calculations
for more info

Questions or comments ? Send a note to Kyle Hailey and and basically provide the same information as utlbstat.sql and utlestat.sql sql scripts. The sql scripts bstat/estat generate a report that is "large granularity", that is it is usually taken over a long period of time say between 5 minutes to 12 hours. Often we'd like to know what the highs and lows were between the start and stop period. One solution would be to run bstat/estat numerous times over the period. For one this would be very costly in database resources since bstat/estat does alot of object creation and deletion as well as calculations. Also if one wanted to have a resume report.txt that was an summary of all the other short period report.txts generated over the full period, it would take alot of calculation to generate this report.

The scritps and are one solution to this problem.

The script takes all the data used by bstat/estat and spools it into files. This operation is very efficient since there is no calculations and no generation of objects in the database.

The script reads the files generated by and generates a report.txt file for any period with the collect period.

	To use:

		1) choose a directory for the OUTPUT ( ./LOG is the default )

			$ export MON_LOG=`pwd`/log

		2) run to collect performance data

			$ &

		3) run to see result of performance data



			$ systat
		wait events

			$ sevt

		file io

			$ fstat


		you can also specify the interval of time

			$ all 0_60        # first 60 seconds
			$ all end         # last sample period
			$ all -600_end    # last 10 minutes
			$ all 0_600       # first 10 minutes
			$ all 10:15_10:20 # 10:15 to 10:20
			$ all 10:15_+300  # 10:15 to 10:20

		4) to  stop the collect remove the file  *.end in log

			$ end

		5) otherwise the collect stops in 12 hours

extra stuff

  • - generates output file useful in excel etc for charting the progress of wait events and statistics
    . usage: stats_hist.txt [sevt|systat]
    . outputs: $MON_LOG/type_hist
    . output contains: statname : val_time_1 val_time_2 ... val_time_N : max min
  • waits graph - example of output viewed with excel

      same as uses a C backend

    • - generates output file useful in excel etc for
    • calc.c - used by , compile with 'cc -o calc calc.c geetopt.o'
    • geetop.c - compile with 'cc -c geetopt.c'