{"id":159,"date":"2008-11-13T09:30:00","date_gmt":"2008-11-13T11:30:00","guid":{"rendered":"http:\/\/www.soudba.com.br\/?p=159"},"modified":"2008-11-13T09:30:00","modified_gmt":"2008-11-13T11:30:00","slug":"obtendo-informacoes-de-uma-sessao-usando-o-sys_context","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=159","title":{"rendered":"Obtendo informa\u00e7\u00f5es de uma sess\u00e3o usando o SYS_CONTEXT"},"content":{"rendered":"

O select abaixo mostra muitas informa\u00e7\u00f5es da sess\u00e3o sem que seja necess\u00e1rio ler a vis\u00e3o v$session.<\/p>\n

SELECT
SYS_CONTEXT(‘USERENV’,’TERMINAL’) terminal,
SYS_CONTEXT(‘USERENV’,’LANGUAGE’) language,
SYS_CONTEXT(‘USERENV’,’SESSIONID’) sessionid,
SYS_CONTEXT(‘USERENV’,’INSTANCE’) instance,
SYS_CONTEXT(‘USERENV’,’ENTRYID’) entryid,
SYS_CONTEXT(‘USERENV’,’ISDBA’) isdba,
SYS_CONTEXT(‘USERENV’,’NLS_TERRITORY’) nls_territory,
SYS_CONTEXT(‘USERENV’,’NLS_CURRENCY’) nls_currency,
SYS_CONTEXT(‘USERENV’,’NLS_CALENDAR’) nls_calendar,
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’,’CURRENT_USER’) current_user,
SYS_CONTEXT(‘USERENV’,’CURRENT_USERID’) current_userid,
SYS_CONTEXT(‘USERENV’,’SESSION_USER’) session_user,
SYS_CONTEXT(‘USERENV’,’SESSION_USERID’) session_userid,
SYS_CONTEXT(‘USERENV’,’PROXY_USER’) proxy_user,
SYS_CONTEXT(‘USERENV’,’PROXY_USERID’) proxy_userid,
SYS_CONTEXT(‘USERENV’,’DB_DOMAIN’) db_domain,
SYS_CONTEXT(‘USERENV’,’DB_NAME’) db_name,
SYS_CONTEXT(‘USERENV’,’HOST’) host,
SYS_CONTEXT(‘USERENV’,’OS_USER’) os_user,
SYS_CONTEXT(‘USERENV’,’EXTERNAL_NAME’) external_name,
SYS_CONTEXT(‘USERENV’,’IP_ADDRESS’) ip_address,
SYS_CONTEXT(‘USERENV’,’NETWORK_PROTOCOL’) network_protocol,
SYS_CONTEXT(‘USERENV’,’BG_JOB_ID’) bg_job_id,
SYS_CONTEXT(‘USERENV’,’FG_JOB_ID’) fg_job_id,
SYS_CONTEXT(‘USERENV’,’AUTHENTICATION_TYPE’) authentication_type,
SYS_CONTEXT(‘USERENV’,’AUTHENTICATION_DATA’) vauthentication_data,
SYS_CONTEXT(‘USERENV’,’CURRENT_SQL’) current_sql,
SYS_CONTEXT(‘USERENV’,’CLIENT_IDENTIFIER’) client_identifier,
SYS_CONTEXT(‘USERENV’,’GLOBAL_CONTEXT_MEMORY’) global_context_memory
FROM dual;<\/p>\n","protected":false},"excerpt":{"rendered":"

O select abaixo mostra muitas informa\u00e7\u00f5es da sess\u00e3o sem que seja necess\u00e1rio ler a vis\u00e3o v$session. SELECT SYS_CONTEXT(‘USERENV’,’TERMINAL’) terminal, SYS_CONTEXT(‘USERENV’,’LANGUAGE’) language, SYS_CONTEXT(‘USERENV’,’SESSIONID’) sessionid, SYS_CONTEXT(‘USERENV’,’INSTANCE’) instance, SYS_CONTEXT(‘USERENV’,’ENTRYID’) entryid, SYS_CONTEXT(‘USERENV’,’ISDBA’) isdba, SYS_CONTEXT(‘USERENV’,’NLS_TERRITORY’) nls_territory, SYS_CONTEXT(‘USERENV’,’NLS_CURRENCY’) nls_currency, SYS_CONTEXT(‘USERENV’,’NLS_CALENDAR’) nls_calendar, SYS_CONTEXT(‘USERENV’,’NLS_DATE_FORMAT’) nls_date_format, SYS_CONTEXT(‘USERENV’,’NLS_DATE_LANGUAGE’) nls_date_language, SYS_CONTEXT(‘USERENV’,’NLS_SORT’) … Continue lendo →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[121,275,295],"tags":[],"class_list":["post-159","post","type-post","status-publish","format-standard","hentry","category-informacoes-da-sessao","category-sessao-corrente-oracle","category-sys_context"],"_links":{"self":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=159"}],"version-history":[{"count":0,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/159\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}