Oracle Applications
Sunday, 22 October 2017
Query to find the current running sql query of the concurrent program
select hash_value,sql_text
from v$sqltext
where hash_value in (select vs.sql_hash_value
from v$session vs
where vs.module like '%CONC_PRGO_SHORT_NAME%')
order by hash_value,piece;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment