Database session using V$SESSION in Oracle
V$SESSION This view lists session information for each current session. Column Datatype Description SADDR RAW(4 | 8) Session address SID NUMBER Session identifier SERIAL# NUMBER Session serial number. Used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID. AUDSID NUMBER Auditing session ID PADDR RAW(4 | 8) Address of the process that owns the session USER# NUMBER Oracle user identifier USERNAME VARCHAR2(30) Oracle username COMMAND NUMBER Command in progress (last statement parsed); for a list of values, see Table 7-5 . These values also appear in the AUDIT_ACTIONS table. OWNERID NUMBER The column contents are invalid if the value is 2147483644 . Otherwise, this column contains the identifier of the user who owns the migratable session. For operations using Parallel Slaves, inte...