How Can I Tell Who I am in V$SESSION, When Everyone Uses the Same Login ID?
(Doc ID 133138.1)
Last updated on MAY 31, 2023
Applies to:
SQL*Plus - Version 8.1.7.0 to 10.2.0.5 [Release 8.1.7 to Oracle10g]Oracle Database - Enterprise Edition - Version 8.1.7.0 to 10.2.0.5.0 [Release 8.1.7 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Goal
This is for administrators and users who wish to isolate unique sessions from V$SESSION when a number of users utilize the same login name.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |