Question

4
Replies
39
Views
spoorthic Member since 2013 9 posts
UHG
Posted: 1 year ago
Last activity: 1 year 7 months ago
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
Share this page LinkedIn