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?