Oracle:getUserSession

Gets information about current user sessions.

Type

SYNC, IMPACT_INFO

None.

Name	Type	Description
SID	Integer	The database session identifier. Table is indexed on the SID.
Username	String	The name of the user.
Command	Integer	The code number of the command currently being executed. A value of `0` means this session is a system session. For descriptions of other values, refer to your Oracle documentation.
Status	String	The status of the session. Possible values are ACTIVE, INACTIVE, or KILLED.
Process ID	Integer	The operating system process identifier (PID).
Program	String	The operating system program name.

This method provides basic information about current database sessions. Invoke this method only when needed.

Did you find this helpful?

Yes No