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

Thread: whats worng ?

  1. #1
    Join Date
    Mar 2002
    Posts
    2
    Oracle 81.17 on solaris ..
    I my app at 100 users load ... I have following stats
    each users fires 7 similar queries on db
    db response time for single user - 160 millis
    avg db resposnse at 100 - 2 secs
    queries on average result 100 rows ...

    Library cache get hit ratio ; 96 .60
    redo spacce wait ratio ; 0.6429
    rows from index/total rows; 2.0659
    buffer cache hit ratio ; 99.9702
    directory cache hit rate ; 98.3299
    directory gets ; 71315
    directory misses ; 1191

    where s the bottleneck ?

  2. #2
    Join Date
    Jan 2002
    Posts
    48
    OS performance maybe ? Have you checked CPU load ? Paging/swapping activity ?

  3. #3
    Join Date
    May 2002
    Posts
    2

    Talking

    Actually the problem was not with Oracle . You may consult a hardware vendor.

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