|
-
Hi
This query will return results if there are transactions in your session:
select t.*,s.*
from v$transaction t, v$session s
where t.addr=s.taddr
and audsid= (select userenv('sessionid') from dual)
if you get no result after this query, then you are not running any transactions at the moment the statment was issued.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|