Results 1 to 7 of 7
  1. #1
    Join Date
    May 2009
    Location
    US
    Posts
    29

    Unanswered: Identifying poor queries?

    Hi Guys

    I'm trying to get a quick 'heads up' regarding an aspect of performance tuning ...

    Let's just say that I get complaints that the database is performing poorly.

    My question is:

    How can I determine whether or not there is a poorly performing query running which may be the culprit?

    And if there is one, how can I identify it?

    Many thanks in advance to all you guys out there who take the trouble to help other people out there!

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking Stats

    Statspack report.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    If it's a specific user complaining you could try SQL Trace.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Nov 2003
    Posts
    76
    If you are using 10g, on the grid control it will tell you the top 10, 20 querries.
    Most database enterprises have an event log /control log structure which times executions. Check the processes with the longest running times.

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Also ADDM, ASH

    Statspack report and/or the OEM reports: ADDM and ASH
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >If you are using 10g, on the grid control it will tell you the top 10, 20 querries.
    Does this mean that all queries reported (above) identify problems to be fixed?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You can also look at the v$session_longops view. Use google to find out how to use it.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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