Database Administration (MOSC)

MOSC Banner

catch the trouble query

edited Mar 24, 2009 2:54AM in Database Administration (MOSC) 6 commentsAnswered
 I have a user using third party tool via odbc to the database. However, the access time to get the data is very long. I want to catch the trouble query that is causing all of time. Is there a good way to do this? Maybe join v$session with v$sql_area?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center