Question

4
Replies
40
Views
Close popover
spoorthi c (spoorthic)
UHG

UHG
IN
spoorthic Member since 2013 9 posts
UHG
Posted: February 15, 2019
Last activity: February 21, 2019
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