Oracle当中用户参数

1、 USERENV(OPTION)  
　　返回当前的会话信息.  
　　OPTION&＃61;&＃39;ISDBA&＃39;若当前是DBA角色,则为TRUE,否则FALSE.  
　　OPTION&＃61;&＃39;LANGUAGE&＃39;返回数据库的字符集.  
　　OPTION&＃61;&＃39;SESSIONID&＃39;为当前会话标识符.  
　　OPTION&＃61;&＃39;ENTRYID&＃39;返回可审计的会话标识符.  
　　OPTION&＃61;&＃39;LANG&＃39;返回会话语言名称的ISO简记.  
　　OPTION&＃61;&＃39;INSTANCE&＃39;返回当前的实例.  
    OPTION&＃61;&＃39;terminal&＃39;返回当前计算机名  
　　SELECT USERENV(&＃39;LANGUAGE&＃39;) FROM DUAL;
2、sys_context

 代码如下:

select   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;TERMINAL&＃39;) terminal,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;LANGUAGE&＃39;) language,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;SESSIONID&＃39;) sessionid,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;INSTANCE&＃39;) instance,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;ENTRYID&＃39;) entryid,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;ISDBA&＃39;) isdba,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;NLS_TERRITORY&＃39;) nls_territory,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;NLS_CURRENCY&＃39;) nls_currency,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;NLS_CALENDAR&＃39;) nls_calendar,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;NLS_DATE_FORMAT&＃39;) nls_date_format,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;NLS_DATE_LANGUAGE&＃39;) nls_date_language,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;NLS_SORT&＃39;) nls_sort,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;CURRENT_USER&＃39;) current_user,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;CURRENT_USERID&＃39;) current_userid,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;SESSION_USER&＃39;) session_user,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;SESSION_USERID&＃39;) session_userid,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;PROXY_USER&＃39;) proxy_user,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;PROXY_USERID&＃39;) proxy_userid,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;DB_DOMAIN&＃39;) db_domain,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;DB_NAME&＃39;) db_name,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;HOST&＃39;) host,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;OS_USER&＃39;) os_user,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;EXTERNAL_NAME&＃39;) external_name,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;IP_ADDRESS&＃39;) ip_address,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;NETWORK_PROTOCOL&＃39;) network_protocol,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;BG_JOB_ID&＃39;) bg_job_id,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;FG_JOB_ID&＃39;) fg_job_id,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;AUTHENTICATION_TYPE&＃39;) authentication_type,   
SYS_CONTEXT(&＃39;USERENV&＃39;,&＃39;AUTHENTICATION_DATA&＃39;) authentication_data   
from dual 

3.与系统视图v$session组合使用可以获得更多信息(客户端所使用的应用程序等) 

 代码如下:

select * 
  from v$session se, 
       (select SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;TERMINAL&＃39;) terminal, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;LANGUAGE&＃39;) language, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;SESSIONID&＃39;) sessionid, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;INSTANCE&＃39;) instance, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;ENTRYID&＃39;) entryid, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;ISDBA&＃39;) isdba, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;NLS_TERRITORY&＃39;) nls_territory, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;NLS_CURRENCY&＃39;) nls_currency, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;NLS_CALENDAR&＃39;) nls_calendar, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;NLS_DATE_FORMAT&＃39;) nls_date_format, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;NLS_DATE_LANGUAGE&＃39;) nls_date_language, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;NLS_SORT&＃39;) nls_sort, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;CURRENT_USER&＃39;) current_user, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;CURRENT_USERID&＃39;) current_userid, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;SESSION_USER&＃39;) session_user, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;SESSION_USERID&＃39;) session_userid, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;PROXY_USER&＃39;) proxy_user, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;PROXY_USERID&＃39;) proxy_userid, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;DB_DOMAIN&＃39;) db_domain, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;DB_NAME&＃39;) db_name, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;HOST&＃39;) host, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;OS_USER&＃39;) os_user, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;EXTERNAL_NAME&＃39;) external_name, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;IP_ADDRESS&＃39;) ip_address, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;NETWORK_PROTOCOL&＃39;) network_protocol, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;BG_JOB_ID&＃39;) bg_job_id, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;FG_JOB_ID&＃39;) fg_job_id, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;AUTHENTICATION_TYPE&＃39;) authentication_type, 
               SYS_CONTEXT(&＃39;USERENV&＃39;, &＃39;AUTHENTICATION_DATA&＃39;) authentication_data 
          from dual) base 
 where se.AUDSID &＃61; base.sessionid;