DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: HELP ME decipher report.txt

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Exclamation

    I want to be able to read and decipher report.txt. I have a note from Oracle Note 62161.1 but it doesnt help that much. Is there another article out there?

    thanks
    Jigar

  2. #2
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    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]

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Do a search on performance tuning at [url]http://technet.oracle.com[/url] and that would give you more details. Also check the site of oracle magazine and sep/oct and nov/dec issues talks on how to read and use the oracle stats pack. These would be another set of free good resources for your reference.

    Good luck,
    sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width