Skip to Main Content
Ted Struik - Oracle
Home
Ted Struik - Oracle
Search
Site Map
Statistics
Page Errors
Apex
General
Autocomplete
Conditions
Errors
Items used in PL/SQL
Validations
Dynamic Actions
Logs
Version
App-wide Items
Error Handling
Apex Views
Apex Upgrade 4.2 to 5.1
Database Dependencies
Show Source Code
URLs
Authorization
Modal Dialogs
Apex Office Print (AOP)
Apex-Sert
Reports
Checkboxes
Download
Errors
Nowrap Columns
Substitution Strings
Use IR results in pl/sql
Clickable Row
Row Highlight
Translate Filters etc.
Bar Charts
Column Usage
Reset Pagination
Hide IR Actions menu items
Get Classic Report query
Interactive Grid
ORA-20987
ERR-1002
Copying Text
IG Info
Images & Fonts
Standard Icons & Fonts
WebDav
Font Awesome
Icons/image popup LOV
Lists
Hierarchy
LOVs
Definition Bug
Set 1-item LOV to Disabled
With Clause Errors
Modal LOV Plugin
HTML / CSS / JavaScript
Vertical Align
Legend CSS
Geolocation
Apex.confirm
Pie Charts
Codemirror
Theme Roller
Catching Key Strokes
Browser Cache
Locale
RequireJS
Collapsible Regions
Import / Export
Dynamic Translations
Translated Pages
APEXExport (java)
apex_export (pl/sql)
Component Settings
Charts
Translate Charts
[Reports] Bar Charts
Shuttles
Shuttle Sorting
Disable Shuttle Items
Menus
Accordion-Like
Scroll bug
Authorization
Session State
About Session State
Rollback & Commit
Performance of v()
Apex Clone Session
Request
Collections
ORA-20101 & ORA-20104
ORA-00001
Max Row Count
(PL)SQL
External Tables
SQL Plus
Conditions
Long
ORDImage
Date & Timestamp
CGI environment
Sys_context
Rounding percentages
Apex_string.split in SQL
Dbms_metadata
Instr
Regular Expressions
Rollback to Savepoint
Use table aliases
(Pipelined) Bulk Collect
JSON
Source Code Search (PL/SQL)
Source Code Search (SQL)
Format Models
Pipelined Table Functions
Hint no_unnest
Listagg
DBA
Backup & Restore
Users
Export & Import
DBMS Jobs
Tablespaces
Table Size
Flush cache
Access Control List (ACL)
Locks
Java
Constraints
Object Dependencies
Package Dependencies 1
Package Dependencies 2
Grants
SQL History
Startup Errors
ORDS
Miscellaneous
Holidays
E-mail
NLExtract
Windows
VPN
VMware
Links
Google
Visualization Orgchart
Hide Search Results
Reverse Proxy
To-do List
Cytoscape
Graphics
Upscaling
Amazon Prices
Domoticz
DDoS
Hobbies
Motorcycles
'95 Kawasaki ZZR 600
'94 Kawasaki ZZR 1100
'91 Honda CBR 600 F2
'95 Kawasaki ZZR 1100
'99 Honda CBR 1100 XX
'00 Honda CBR 1100 XX
'02 Kawasaki ZX-12R (NL)
'05 Ducati 999 (NL)
'08 Honda Fireblade
'07 Suzuki Bandit 1250A
'18 Suzuki GSX-S 1000 F
MotoGP
Garfield
Lyrics
Skydive
Woodworking
Pantorouter
16 inch Bandsaw
Introduction
Frame
Wheels
Wheel mounts
Blade guides
Trunions and table
Enclosure
Alignment and more
Box Joint Jig
Foldable Sawhorses
Strip Sander XL
Photography
Sony RX10 IV
Search For
Sys_context
Go
Actions
Name
Val
ACTION
Processes - point: BEFORE_BOX_BO
AUDITED_CURSORID
-
AUTHENTICATED_IDENTITY
APEX_PUBLIC_USER
AUTHENTICATION_DATA
-
AUTHENTICATION_METHOD
NONE
BG_JOB_ID
-
CLIENT_IDENTIFIER
:
CLIENT_INFO
1680771009338522:
CURRENT_BIND
-
CURRENT_EDITION_ID
134
CURRENT_EDITION_NAME
ORA$BASE
CURRENT_SCHEMA
TEDSTRUIK
CURRENT_SCHEMAID
121
CURRENT_SQL
-
CURRENT_SQLN
-
CURRENT_SQL_LENGTH
-
CURRENT_USER
TEDSTRUIK
CURRENT_USERID
121
DATABASE_ROLE
PRIMARY
DBLINK_INFO
-
DB_DOMAIN
-
DB_NAME
XEPDB1
DB_UNIQUE_NAME
XE
ENTERPRISE_IDENTITY
-
ENTRYID
-
FG_JOB_ID
0
GLOBAL_CONTEXT_MEMORY
2424
GLOBAL_UID
-
HOST
dmz-db-10
IDENTIFICATION_TYPE
LOCAL
INSTANCE
1
INSTANCE_NAME
XE
IP_ADDRESS
127.0.0.1
ISDBA
FALSE
LANG
US
LANGUAGE
AMERICAN_AMERICA.AL32UTF8
MODULE
TEDSTRUIK/APEX:APP 25384:1051
NETWORK_PROTOCOL
tcp
NLS_CALENDAR
GREGORIAN
NLS_CURRENCY
$
NLS_DATE_FORMAT
YYYY-MM-DD
NLS_DATE_LANGUAGE
AMERICAN
NLS_SORT
BINARY
NLS_TERRITORY
AMERICA
OS_USER
tomcat
POLICY_INVOKER
-
PROXY_ENTERPRISE_IDENTITY
-
PROXY_USER
ORDS_PUBLIC_USER
PROXY_USERID
117
SERVER_HOST
dmz-db-10
SERVICE_NAME
xepdb1
SESSIONID
11652701
SESSION_EDITION_ID
134
SESSION_EDITION_NAME
ORA$BASE
SESSION_USER
APEX_PUBLIC_USER
SESSION_USERID
111
SID
269
STATEMENTID
-
TERMINAL
unknown
1 - 59
Column Actions
Search
Info
Report with sys_context/user_env context values.
Source:
http://stackoverflow.com/questions/8114453/read-all-parameters-from-sys-context-userenv
Code
Page
Name
Page ID
1051
Name
(PL)SQL - Sys_context
Region
Identification
Sequence
10
Title
Sys_context
Type
Interactive Report
Source
Source Type
DYNAMIC_QUERY
Region Source
select res.* from ( select * from ( select sys_context ('userenv','ACTION') ACTION, sys_context ('userenv','AUDITED_CURSORID') AUDITED_CURSORID, sys_context ('userenv','AUTHENTICATED_IDENTITY') AUTHENTICATED_IDENTITY, sys_context ('userenv','AUTHENTICATION_DATA') AUTHENTICATION_DATA, sys_context ('userenv','AUTHENTICATION_METHOD') AUTHENTICATION_METHOD, sys_context ('userenv','BG_JOB_ID') BG_JOB_ID, sys_context ('userenv','CLIENT_IDENTIFIER') CLIENT_IDENTIFIER, sys_context ('userenv','CLIENT_INFO') CLIENT_INFO, sys_context ('userenv','CURRENT_BIND') CURRENT_BIND, sys_context ('userenv','CURRENT_EDITION_ID') CURRENT_EDITION_ID, sys_context ('userenv','CURRENT_EDITION_NAME') CURRENT_EDITION_NAME, sys_context ('userenv','CURRENT_SCHEMA') CURRENT_SCHEMA, sys_context ('userenv','CURRENT_SCHEMAID') CURRENT_SCHEMAID, sys_context ('userenv','CURRENT_SQL') CURRENT_SQL, sys_context ('userenv','CURRENT_SQLn') CURRENT_SQLn, sys_context ('userenv','CURRENT_SQL_LENGTH') CURRENT_SQL_LENGTH, sys_context ('userenv','CURRENT_USER') CURRENT_USER, sys_context ('userenv','CURRENT_USERID') CURRENT_USERID, sys_context ('userenv','DATABASE_ROLE') DATABASE_ROLE, sys_context ('userenv','DB_DOMAIN') DB_DOMAIN, sys_context ('userenv','DB_NAME') DB_NAME, sys_context ('userenv','DB_UNIQUE_NAME') DB_UNIQUE_NAME, sys_context ('userenv','DBLINK_INFO') DBLINK_INFO, sys_context ('userenv','ENTRYID') ENTRYID, sys_context ('userenv','ENTERPRISE_IDENTITY') ENTERPRISE_IDENTITY, sys_context ('userenv','FG_JOB_ID') FG_JOB_ID, sys_context ('userenv','GLOBAL_CONTEXT_MEMORY') GLOBAL_CONTEXT_MEMORY, sys_context ('userenv','GLOBAL_UID') GLOBAL_UID, sys_context ('userenv','HOST') HOST, sys_context ('userenv','IDENTIFICATION_TYPE') IDENTIFICATION_TYPE, sys_context ('userenv','INSTANCE') INSTANCE, sys_context ('userenv','INSTANCE_NAME') INSTANCE_NAME, sys_context ('userenv','IP_ADDRESS') IP_ADDRESS, sys_context ('userenv','ISDBA') ISDBA, sys_context ('userenv','LANG') LANG, sys_context ('userenv','LANGUAGE') LANGUAGE, sys_context ('userenv','MODULE') MODULE, sys_context ('userenv','NETWORK_PROTOCOL') NETWORK_PROTOCOL, sys_context ('userenv','NLS_CALENDAR') NLS_CALENDAR, sys_context ('userenv','NLS_CURRENCY') NLS_CURRENCY, sys_context ('userenv','NLS_DATE_FORMAT') NLS_DATE_FORMAT, sys_context ('userenv','NLS_DATE_LANGUAGE') NLS_DATE_LANGUAGE, sys_context ('userenv','NLS_SORT') NLS_SORT, sys_context ('userenv','NLS_TERRITORY') NLS_TERRITORY, sys_context ('userenv','OS_USER') OS_USER, sys_context ('userenv','POLICY_INVOKER') POLICY_INVOKER, sys_context ('userenv','PROXY_ENTERPRISE_IDENTITY') PROXY_ENTERPRISE_IDENTITY, sys_context ('userenv','PROXY_USER') PROXY_USER, sys_context ('userenv','PROXY_USERID') PROXY_USERID, sys_context ('userenv','SERVER_HOST') SERVER_HOST, sys_context ('userenv','SERVICE_NAME') SERVICE_NAME, sys_context ('userenv','SESSION_EDITION_ID') SESSION_EDITION_ID, sys_context ('userenv','SESSION_EDITION_NAME') SESSION_EDITION_NAME, sys_context ('userenv','SESSION_USER') SESSION_USER, sys_context ('userenv','SESSION_USERID') SESSION_USERID, sys_context ('userenv','SESSIONID') SESSIONID, sys_context ('userenv','SID') SID, sys_context ('userenv','STATEMENTID') STATEMENTID, sys_context ('userenv','TERMINAL') TERMINAL from dual -- where sys_context ('userenv','SESSIONID') NOT in ('SYS', 'XDB') -- <<<<< filter by user ) unpivot include nulls ( val for name in (action, audited_cursorid, authenticated_identity, authentication_data, authentication_method, bg_job_id, client_identifier, client_info, current_bind, current_edition_id, current_edition_name, current_schema, current_schemaid, current_sql, current_sqln, current_sql_length, current_user, current_userid, database_role, db_domain, db_name, db_unique_name, dblink_info, entryid, enterprise_identity, fg_job_id, global_context_memory, global_uid, host, identification_type, instance, instance_name, ip_address, isdba, lang, language, module, network_protocol, nls_calendar, nls_currency, nls_date_format, nls_date_language, nls_sort, nls_territory, os_user, policy_invoker, proxy_enterprise_identity, proxy_user, proxy_userid, server_host, service_name, session_edition_id, session_edition_name, session_user, session_userid, sessionid, sid, statementid, terminal) ) ) res