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

Thread: Waiting time

  1. #1
    Join Date
    Apr 2002
    Posts
    29
    Recently we are finding that users are having to wait for a longer time to get results (from the front-end application) .The query results are from the same table and all the users are getting same kind of problems (more waiting time ) what could be the possible reason for this .I feel that two things need to be checked
    1)What are the major sqls running on these database
    2)How many times is these particular table being accessed
    could any one please give me some suggestions on how to proceed and what to look

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Depending on your database version, run utlbstat/utlestat or statspack to get some performance data. Then use that information to assist in tuning.

    There are too many potential causes of poor performance to be able to offer direct advice. With the information provided by the above utilities you will be able to pin-point specific causes.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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