select SQL_TEXT
from SESSION S, V$SQLTEXT T
where S.SQL_ADDRESS= T.ADDRESS
AND S.SQL_HASH_VALUE=T.HASH_VALUE
AND AUDSID=<add correct value here>
ORDER BY ADDRESS, PIECE
Then you may use EXPLAIN PLAN and get plan for these statements.
Recreating indexes is not very good idea, because you loose statistics thus making your CBO blind.
You may also investigate V$LOCK view to check whether those reports don't wait for locked resources.
Thanks, but I am not getting any row returned with your query. I double-checked the audsid to verify it is still in v$session but nothing is coming back.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.