Friday, May 29, 2020

Predefined Parameters of Namespace USERENV in Oracle 19c

select sys_context('userenv','action') from dual;
select sys_context('userenv','is_application_root') from dual;
select sys_context('userenv','is_application_pdb') 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','cdb_name') from dual;
select sys_context('userenv','client_identifier') from dual;
select sys_context('userenv','client_info') from dual;
select sys_context('userenv','client_program_name') from dual;
select sys_context('userenv','con_id') from dual;
select sys_context('userenv','con_name') from dual;
select sys_context('userenv','current_bind') from dual;
select sys_context('userenv','current_edition_id') from dual;
select sys_context('userenv','current_edition_name') 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_sql_length') from dual;
select sys_context('userenv','current_user') from dual;
select sys_context('userenv','current_userid') from dual;
select sys_context('userenv','database_role') from dual;
select sys_context('userenv','db_domain') from dual;
select sys_context('userenv','db_name') from dual;
select sys_context('userenv','db_supplemental_log_level') from dual;
select sys_context('userenv','db_unique_name') from dual;
select sys_context('userenv','dblink_info') 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;
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;
select sys_context('userenv','instance_name') from dual;
select sys_context('userenv','ip_address') from dual;
select sys_context('userenv','is_apply_server') from dual;
select sys_context('userenv','is_dg_rolling_upgrade') 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','ldap_server_type') from dual;
select sys_context('userenv','module') from dual;
select sys_context('userenv','network_protocol') from dual;
select sys_context('userenv','nls_calendar') from dual;
select sys_context('userenv','nls_currency') from dual;
select sys_context('userenv','nls_date_format') from dual;
select sys_context('userenv','nls_date_language') from dual;
select sys_context('userenv','nls_sort') from dual;
select sys_context('userenv','nls_territory') from dual;
select sys_context('userenv','oracle_home') from dual;
select sys_context('userenv','os_user') from dual;
select sys_context('userenv','platform_slash') from dual;
select sys_context('userenv','policy_invoker') from dual;
select sys_context('userenv','proxy_enterprise_identity') from dual;
select sys_context('userenv','proxy_user') from dual;
select sys_context('userenv','proxy_userid') from dual;
select sys_context('userenv','scheduler_job') from dual;
select sys_context('userenv','server_host') from dual;
select sys_context('userenv','service_name') from dual;
select sys_context('userenv','session_default_collation') from dual;
select sys_context('userenv','session_edition_id') from dual;
select sys_context('userenv','session_edition_name') from dual;
select sys_context('userenv','session_user') from dual;
select sys_context('userenv','session_userid') from dual;
select sys_context('userenv','sessionid') from dual;
select sys_context('userenv','sid') from dual;
select sys_context('userenv','statementid') from dual;
select sys_context('userenv','terminal') from dual;
select sys_context('userenv','unified_audit_sessionid') from dual;


/*
[oracle@db19c ~]$ sqlplus donghua3_connect[donghua3]/NeverGuexx1@apppdb1

SQL*Plus: Release 19.0.0.0.0 - Production on Fri May 29 14:21:37 2020
Version 19.7.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0

SQL> select sys_context('userenv','action') from dual;

SYS_CONTEXT('USERENV','ACTION')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','is_application_root') from dual;

SYS_CONTEXT('USERENV','IS_APPLICATION_ROOT')
--------------------------------------------------------------------------------
NO

SQL> select sys_context('userenv','is_application_pdb') from dual;

SYS_CONTEXT('USERENV','IS_APPLICATION_PDB')
--------------------------------------------------------------------------------
NO

SQL> select sys_context('userenv','audited_cursorid') from dual;

SYS_CONTEXT('USERENV','AUDITED_CURSORID')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','authenticated_identity') from dual;

SYS_CONTEXT('USERENV','AUTHENTICATED_IDENTITY')
--------------------------------------------------------------------------------
DONGHUA3

SQL> select sys_context('userenv','authentication_data') from dual;

SYS_CONTEXT('USERENV','AUTHENTICATION_DATA')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','authentication_method') from dual;

SYS_CONTEXT('USERENV','AUTHENTICATION_METHOD')
--------------------------------------------------------------------------------
NONE

SQL> select sys_context('userenv','bg_job_id') from dual;

SYS_CONTEXT('USERENV','BG_JOB_ID')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','cdb_name') from dual;

SYS_CONTEXT('USERENV','CDB_NAME')
--------------------------------------------------------------------------------
ORCL

SQL> select sys_context('userenv','client_identifier') from dual;

SYS_CONTEXT('USERENV','CLIENT_IDENTIFIER')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','client_info') from dual;

SYS_CONTEXT('USERENV','CLIENT_INFO')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','client_program_name') from dual;

SYS_CONTEXT('USERENV','CLIENT_PROGRAM_NAME')
--------------------------------------------------------------------------------
sqlplus@db19c (TNS V1-V3)

SQL> select sys_context('userenv','con_id') from dual;

SYS_CONTEXT('USERENV','CON_ID')
--------------------------------------------------------------------------------
4

SQL> select sys_context('userenv','con_name') from dual;

SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------
APPPDB1

SQL> select sys_context('userenv','current_bind') from dual;

SYS_CONTEXT('USERENV','CURRENT_BIND')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','current_edition_id') from dual;

SYS_CONTEXT('USERENV','CURRENT_EDITION_ID')
--------------------------------------------------------------------------------
134

SQL> select sys_context('userenv','current_edition_name') from dual;

SYS_CONTEXT('USERENV','CURRENT_EDITION_NAME')
--------------------------------------------------------------------------------
ORA$BASE

SQL> select sys_context('userenv','current_schema') from dual;

SYS_CONTEXT('USERENV','CURRENT_SCHEMA')
--------------------------------------------------------------------------------
DONGHUA3

SQL> select sys_context('userenv','current_schemaid') from dual;

SYS_CONTEXT('USERENV','CURRENT_SCHEMAID')
--------------------------------------------------------------------------------
107

SQL> select sys_context('userenv','current_sql') from dual;

SYS_CONTEXT('USERENV','CURRENT_SQL')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','current_sql_length') from dual;

SYS_CONTEXT('USERENV','CURRENT_SQL_LENGTH')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','current_user') from dual;

SYS_CONTEXT('USERENV','CURRENT_USER')
--------------------------------------------------------------------------------
DONGHUA3

SQL> select sys_context('userenv','current_userid') from dual;

SYS_CONTEXT('USERENV','CURRENT_USERID')
--------------------------------------------------------------------------------
107

SQL> select sys_context('userenv','database_role') from dual;

SYS_CONTEXT('USERENV','DATABASE_ROLE')
--------------------------------------------------------------------------------
PRIMARY

SQL> select sys_context('userenv','db_domain') from dual;

SYS_CONTEXT('USERENV','DB_DOMAIN')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','db_name') from dual;

SYS_CONTEXT('USERENV','DB_NAME')
--------------------------------------------------------------------------------
APPPDB1

SQL> select sys_context('userenv','db_supplemental_log_level') from dual;

SYS_CONTEXT('USERENV','DB_SUPPLEMENTAL_LOG_LEVEL')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','db_unique_name') from dual;

SYS_CONTEXT('USERENV','DB_UNIQUE_NAME')
--------------------------------------------------------------------------------
ORCL

SQL> select sys_context('userenv','dblink_info') from dual;

SYS_CONTEXT('USERENV','DBLINK_INFO')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','entryid') from dual;

SYS_CONTEXT('USERENV','ENTRYID')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','enterprise_identity') from dual;

SYS_CONTEXT('USERENV','ENTERPRISE_IDENTITY')
--------------------------------------------------------------------------------
DONGHUA3

SQL> select sys_context('userenv','fg_job_id') from dual;

SYS_CONTEXT('USERENV','FG_JOB_ID')
--------------------------------------------------------------------------------
0

SQL> select sys_context('userenv','global_context_memory') from dual;

SYS_CONTEXT('USERENV','GLOBAL_CONTEXT_MEMORY')
--------------------------------------------------------------------------------
0

SQL> select sys_context('userenv','global_uid') from dual;

SYS_CONTEXT('USERENV','GLOBAL_UID')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','host') from dual;

SYS_CONTEXT('USERENV','HOST')
--------------------------------------------------------------------------------
db19c

SQL> select sys_context('userenv','identification_type') from dual;

SYS_CONTEXT('USERENV','IDENTIFICATION_TYPE')
--------------------------------------------------------------------------------
NONE

SQL> select sys_context('userenv','instance') from dual;

SYS_CONTEXT('USERENV','INSTANCE')
--------------------------------------------------------------------------------
1

SQL> select sys_context('userenv','instance_name') from dual;

SYS_CONTEXT('USERENV','INSTANCE_NAME')
--------------------------------------------------------------------------------
ORCL

SQL> select sys_context('userenv','ip_address') from dual;

SYS_CONTEXT('USERENV','IP_ADDRESS')
--------------------------------------------------------------------------------
10.0.1.2

SQL> select sys_context('userenv','is_apply_server') from dual;

SYS_CONTEXT('USERENV','IS_APPLY_SERVER')
--------------------------------------------------------------------------------
FALSE

SQL> select sys_context('userenv','is_dg_rolling_upgrade') from dual;

SYS_CONTEXT('USERENV','IS_DG_ROLLING_UPGRADE')
--------------------------------------------------------------------------------
FALSE

SQL> select sys_context('userenv','isdba') from dual;

SYS_CONTEXT('USERENV','ISDBA')
--------------------------------------------------------------------------------
FALSE

SQL> select sys_context('userenv','lang') from dual;

SYS_CONTEXT('USERENV','LANG')
--------------------------------------------------------------------------------
US

SQL> select sys_context('userenv','language') from dual;

SYS_CONTEXT('USERENV','LANGUAGE')
--------------------------------------------------------------------------------
AMERICAN_AMERICA.AL32UTF8

SQL> select sys_context('userenv','ldap_server_type') from dual;

SYS_CONTEXT('USERENV','LDAP_SERVER_TYPE')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','module') from dual;

SYS_CONTEXT('USERENV','MODULE')
--------------------------------------------------------------------------------
SQL*Plus

SQL> select sys_context('userenv','network_protocol') from dual;

SYS_CONTEXT('USERENV','NETWORK_PROTOCOL')
--------------------------------------------------------------------------------
tcp

SQL> select sys_context('userenv','nls_calendar') from dual;

SYS_CONTEXT('USERENV','NLS_CALENDAR')
--------------------------------------------------------------------------------
GREGORIAN

SQL> select sys_context('userenv','nls_currency') from dual;

SYS_CONTEXT('USERENV','NLS_CURRENCY')
--------------------------------------------------------------------------------
$

SQL> select sys_context('userenv','nls_date_format') from dual;

SYS_CONTEXT('USERENV','NLS_DATE_FORMAT')
--------------------------------------------------------------------------------
DD-MON-RR

SQL> select sys_context('userenv','nls_date_language') from dual;

SYS_CONTEXT('USERENV','NLS_DATE_LANGUAGE')
--------------------------------------------------------------------------------
AMERICAN

SQL> select sys_context('userenv','nls_sort') from dual;

SYS_CONTEXT('USERENV','NLS_SORT')
--------------------------------------------------------------------------------
BINARY

SQL> select sys_context('userenv','nls_territory') from dual;

SYS_CONTEXT('USERENV','NLS_TERRITORY')
--------------------------------------------------------------------------------
AMERICA

SQL> select sys_context('userenv','oracle_home') from dual;

SYS_CONTEXT('USERENV','ORACLE_HOME')
--------------------------------------------------------------------------------
/u01/db

SQL> select sys_context('userenv','os_user') from dual;

SYS_CONTEXT('USERENV','OS_USER')
--------------------------------------------------------------------------------
oracle

SQL> select sys_context('userenv','platform_slash') from dual;

SYS_CONTEXT('USERENV','PLATFORM_SLASH')
--------------------------------------------------------------------------------
/

SQL> select sys_context('userenv','policy_invoker') from dual;

SYS_CONTEXT('USERENV','POLICY_INVOKER')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','proxy_enterprise_identity') from dual;

SYS_CONTEXT('USERENV','PROXY_ENTERPRISE_IDENTITY')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','proxy_user') from dual;

SYS_CONTEXT('USERENV','PROXY_USER')
--------------------------------------------------------------------------------
DONGHUA3_CONNECT

SQL> select sys_context('userenv','proxy_userid') from dual;

SYS_CONTEXT('USERENV','PROXY_USERID')
--------------------------------------------------------------------------------
108

SQL> select sys_context('userenv','scheduler_job') from dual;

SYS_CONTEXT('USERENV','SCHEDULER_JOB')
--------------------------------------------------------------------------------
N

SQL> select sys_context('userenv','server_host') from dual;

SYS_CONTEXT('USERENV','SERVER_HOST')
--------------------------------------------------------------------------------
db19c

SQL> select sys_context('userenv','service_name') from dual;

SYS_CONTEXT('USERENV','SERVICE_NAME')
--------------------------------------------------------------------------------
apppdb1

SQL> select sys_context('userenv','session_default_collation') from dual;

SYS_CONTEXT('USERENV','SESSION_DEFAULT_COLLATION')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','session_edition_id') from dual;

SYS_CONTEXT('USERENV','SESSION_EDITION_ID')
--------------------------------------------------------------------------------
134

SQL> select sys_context('userenv','session_edition_name') from dual;

SYS_CONTEXT('USERENV','SESSION_EDITION_NAME')
--------------------------------------------------------------------------------
ORA$BASE

SQL> select sys_context('userenv','session_user') from dual;

SYS_CONTEXT('USERENV','SESSION_USER')
--------------------------------------------------------------------------------
DONGHUA3

SQL> select sys_context('userenv','session_userid') from dual;

SYS_CONTEXT('USERENV','SESSION_USERID')
--------------------------------------------------------------------------------
107

SQL> select sys_context('userenv','sessionid') from dual;

SYS_CONTEXT('USERENV','SESSIONID')
--------------------------------------------------------------------------------
220096

SQL> select sys_context('userenv','sid') from dual;

SYS_CONTEXT('USERENV','SID')
--------------------------------------------------------------------------------
276

SQL> select sys_context('userenv','statementid') from dual;

SYS_CONTEXT('USERENV','STATEMENTID')
--------------------------------------------------------------------------------


SQL> select sys_context('userenv','terminal') from dual;

SYS_CONTEXT('USERENV','TERMINAL')
--------------------------------------------------------------------------------
pts/0

SQL> select sys_context('userenv','unified_audit_sessionid') from dual;

SYS_CONTEXT('USERENV','UNIFIED_AUDIT_SESSIONID')
--------------------------------------------------------------------------------
1194230081
*/

No comments:

Post a Comment