Link to home
Start Free TrialLog in
Avatar of hussainkhan22
hussainkhan22Flag for United States of America

asked on

Oracle session ID

Hey guys how can i find the session id for any particular SQL is running with it. I appreciate your help and time in advance.
ASKER CERTIFIED SOLUTION
Avatar of sindhuxyz
sindhuxyz

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

check out v$session.  This had the sid and serial# of the connection.  It also gives you the SQL_ADDRESS.