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

Thread: ds server

  1. #1
    Join Date
    Jun 2001
    Posts
    316

    db server

    hi
    I just installed toad on my system and in the server analysis part i get the following:

    Buffer cache hit ratio : 48.2746 may need to increase db_block_buffers

    library cache get hit ratio : 83.0791 dynamic or unsharable SQL

    library cache pin hit ratio : 83.7397 shared pool area too small

    redo space wait ratio : 4.0190 unknown


    chaned fetch ratio 0.0981 pctfree too low for a table

    parse to execute ratio 75.4294 high parse to execute ratio


    DBWR average scan depth 1.430.6494 no of db_files too high?

    what does all thse mean...are all thse some kinda errors on the server
    if yes..is there anyway to get 'bout this.....?

    thanx

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    I think that is 2 much information.i suggest you plaese read the oracle docs on tuning.and preferably this book oracle sql high performance tuning by guy harrisson.

    regards
    Hrishy

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