Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> how to find the most resource intensive sql?
assuming you can't use statspack? Is there a query for this? I was asked the following and I'm not sure how to answer it:
'A user comes to you and says they get to a point in the application and hit a button. It's slow. You do not have any access to the application. How do you find the problem query in the database'
![]() |
![]() |