Question

4
Replies
44
Views
spoorthi c (spoorthic)
UHG

UHG
IN
spoorthic Member since 2013 9 posts
UHG
Posted: February 15, 2019
Last activity: February 21, 2019
Posted: 15 Feb 2019 17:51 EST
Last activity: 21 Feb 2019 10:41 EST
Closed

How to pass client_identifier to Database to see the long running transaction details

Below query is used to get the running transactions in our application however client_identifier is coming as blank which is important in understanding the useridentifier of a particular transaction.

select * from gv$session

CLIENT_IDENTIFIER is not available in Database when searched for a particular SID.

Could someone help us in how to pass this information to store in the database?

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.