Table 17-5: SYS_SESSION attributes and values
Attribute
|
Value
|
|---|
username
|
Login name
|
hostname
|
Host name from which the client has connected
|
applname
|
Name of the application as set by the
client
|
suserid
|
User ID of the user in the current database
|
groupid
|
Group ID of the user in the current database
|
dbid
|
ID of the user’s current database
|
dbname
|
Current database
|
spid
|
Server process ID
|
proxy_suserid
|
The server user ID of the proxy
|
client_name
|
Client name set by the middle-tier application,
using the set client_name command
|
client_applname
|
Client application name set by the middle-tier
application, using the set client_applname command
|
client_hostname
|
Client host name set by the middle-tier
application, using the set client_hostname command
|
language
|
Current language the client is using
by default or after using the set language command
(@@language)
|
character_set
|
Character set the client is using (@@client_csname)
|
dateformat
|
Date expected by the client, set using
the set dateformat command
|
is_showplan_on
|
Returns YES if set showplan is
on, NO if it is off
|
is_noexec_on
|
Returns YES if set no exec is
on, NO if it is off
|
