there is SO much info in report.txt. check out the book 'Oracle Performance Tuning' by Rich Niemic. it is very good for many reasons.

the big hits in report.txt are

(first section) are library (data dictionary) hit ratio

(second section with a list of stats) check consistent gets, db block gets, and physical reads to determine your data hit ratio (this corresponds to init.ora parameter db_block_buffers). physical reads should be a fraction (10-20%) of the gets.

(second section) check that "sorts (disk)" are 10% or less than "sorts (memory)". this corresponds to init.ora parameter sort_area_size.

the goals for these ratios will differ by type of database--OLTP or DSS/warehouse.

the documentation is scattered far & wide for this report. do you have a specific performance problem to address, or were just checking out the database?

d.

[Edited by DBAtrix on 02-22-2001 at 05:59 PM]