Various session parameters of SYS_CONTEXT in Oracle

Various session parameters of  SYS_CONTEXT in Oracle


select sys_context('USERENV','IP_ADDRESS') FROM DUAL
select sys_context('USERENV','ACTION') FROM DUAL    
select sys_context('USERENV','AUDITED_CURSORID') FROM DUAL    
select sys_context('USERENV','AUTHENTICATED_IDENTITY') FROM DUAL     
select sys_context('USERENV','AUTHENTICATION_DATA') FROM DUAL   
select sys_context('USERENV','AUTHENTICATION_METHOD') FROM DUAL   
select sys_context('USERENV','BG_JOB_ID') FROM DUAL   
select sys_context('USERENV','CLIENT_IDENTIFIER') FROM DUAL   
select sys_context('USERENV','CLIENT_INFO') FROM DUAL   
select sys_context('USERENV','CURRENT_BIND') FROM DUAL  
select sys_context('USERENV','CURRENT_SCHEMA') FROM DUAL   
select sys_context('USERENV','CURRENT_SCHEMAID') FROM DUAL  
select sys_context('USERENV','CURRENT_SQL') FROM DUAL   
select sys_context('USERENV','CURRENT_SQLn') FROM DUAL   
select sys_context('USERENV','CURRENT_SQL_LENGTH') FROM DUAL   
select sys_context('USERENV','DB_DOMAIN') FROM DUAL   
select sys_context('USERENV','DB_NAME') FROM DUAL   
select sys_context('USERENV','DB_UNIQUE_NAME') FROM DUAL   
select sys_context('USERENV','ENTRYID') FROM DUAL   
select sys_context('USERENV','ENTERPRISE_IDENTITY') FROM DUAL   
select sys_context('USERENV','FG_JOB_ID') FROM DUAL   --0
select sys_context('USERENV','GLOBAL_CONTEXT_MEMORY') FROM DUAL   
select sys_context('USERENV','GLOBAL_UID') FROM DUAL   
select sys_context('USERENV','HOST') FROM DUAL     
select sys_context('USERENV','IDENTIFICATION_TYPE') FROM DUAL   
select sys_context('USERENV','INSTANCE') FROM DUAL  --1 
select sys_context('USERENV','INSTANCE_NAME') FROM DUAL   -
select sys_context('USERENV','IP_ADDRESS') FROM DUAL     
select sys_context('USERENV','ISDBA') FROM DUAL   
select sys_context('USERENV','LANG') FROM DUAL   
select sys_context('USERENV','LANGUAGE') FROM DUAL  
select sys_context('USERENV','MODULE') FROM DUAL   -- TOAD 10.1.1.8 
select sys_context('USERENV','NETWORK_PROTOCOL') FROM DUAL   -- TCP
select sys_context('USERENV','NLS_CALENDAR') FROM DUAL   --GREGORIAN
select sys_context('USERENV','NLS_CURRENCY') FROM DUAL    --$
select sys_context('USERENV','NLS_DATE_FORMAT') FROM DUAL   --DD-MON-RR
select sys_context('USERENV','NLS_DATE_LANGUAGE') FROM DUAL   --AMERICAN
select sys_context('USERENV','NLS_SORT') FROM DUAL   --BINARY
select sys_context('USERENV','NLS_TERRITORY') FROM DUAL   --AMERICA
select sys_context('USERENV','OS_USER') FROM DUAL   -- Lenovo   
select sys_context('USERENV','POLICY_INVOKER') FROM DUAL   
select sys_context('USERENV','PROXY_ENTERPRISE_IDENTITY') FROM DUAL   
select sys_context('USERENV','PROXY_GLOBAL_UID') FROM DUAL   
select sys_context('USERENV','PROXY_USER') FROM DUAL   
select sys_context('USERENV','PROXY_USERID') FROM DUAL   
select sys_context('USERENV','SERVER_HOST') FROM DUAL   --abcd
select sys_context('USERENV','SERVICE_NAME') FROM DUAL   --fms123
select sys_context('USERENV','SESSION_USER') FROM DUAL   --scott
select sys_context('USERENV','SESSION_USERID') FROM DUAL   --112
select sys_context('USERENV','SESSIONID') FROM DUAL   --20858450
select sys_context('USERENV','SID') FROM DUAL   --197   
select sys_context('USERENV','STATEMENTID') FROM DUAL   
select sys_context('USERENV','TERMINAL') FROM DUAL   

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post