DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: How to limit the nymber of sessions that can be opened from a terminal?

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    do hit ratios show the database load....?

  2. #12
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Originally posted by pando
    do hit ratios show the database load....?
    Hit ratios doesn't show the overall database load but, gives SGA utilization before and after init parms changes which gives an idea of Memory usage upon increasing number of processes.
    Reddy,Sam

  3. #13
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Never believe in * Hit Ratios *
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #14
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Never believe in * Hit Ratios *
    The only one I believe in is Mr.H's 100% Hit Ratio on developers

  5. #15
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont believe in hit ratios anyways, seen many damn slow databases with 99% hit ratios, the funny thing is hit ratio is always 99% even the peeps who are in charge decrease or increase the SGA so they always think big is good hehehe

    Once I saw a guy put 4gb data block buffer, his argument was to achive e99% hit ratio, I decreased to 300mb and he asked, why you get 99% hit ratio too?

  6. #16
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by pando
    I dont believe in hit ratios anyways, seen many damn slow databases with 99% hit ratios, the funny thing is hit ratio is always 99% even the peeps who are in charge decrease or increase the SGA so they always think big is good hehehe

    Once I saw a guy put 4gb data block buffer, his argument was to achive e99% hit ratio, I decreased to 300mb and he asked, why you get 99% hit ratio too?

    Run some 10 F** queries 10 times a day you can see hit ratio shoot up 95+ ( I think, the guy whose argument and moto to achieve 99% hit ratio should be given noble prize )
    Last edited by abhaysk; 07-22-2004 at 05:10 AM.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #17
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I should have been little clear in my posting(Hope its clear for JMac now), Anyway, I didn't say go by Hit ratios for Database Performance or databse load. I know, I had similar situations of poor database performance with 90+ hit ratios.

    Just to get relative comparision of where memory usage for the same database with same kinda queries running before and after incrementing processes. Simple and Dirty way of finding how resources(memory, cpu, i/o) utilized when number of processes(sessions) increased.
    Reddy,Sam

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