How to set context in a SQL session in Oracle Apps
BEGIN
mo_global.set_policy_context (p_access_mode => 'S', p_org_id => '779');
END;
OR
BEGIN
DBMS_APPLICATION_INFO.set_client_info (client_info => '779'); -- org_id
END;
Tables that contain Multiple Organizations data can be identified by the suffix “_ALL” in the table name. These tables include a column called ORG_ID, which partitions Multiple Organizations data by organization. Every Multiple Organizations table has a corresponding view that
partitions the table’s data by operating unit. Multiple Organizations views partition data by including a DECODE on the internal variable CLIENT_INFO. This variable is set by the security system to the operating unit designated for the responsibility. It operates is a similar way to the LANGUAGE variable, which returns the language of the current session. Note: If accessing data from a Multiple Organizations partitioned object when CLIENT.INFO has not been set (for example, from SQL*Plus), you must use the _ALL table, not the view.
SO_HEADERS_ALL, with its corresponding view SO_HEADERS, is an example of a Multiple Organizations partitioned object.
Multi Language context
In Oracle E-Business, the tables that end with _TL or views that end with _VL are multi language enabled. By default the language that is set is US English denoted as US within the tables. These tables have an entry for each language.
E.g. if you query for the concurrent program, Analyze All Index Column Statistics, you will find as many entries in the table,
fnd_concurrent_programs_tl, as there are languages installed in the instance.
SELECT *
FROM fnd_concurrent_programs_tl
Oracle-SQL跟踪SQL_TRACE_IT/计算机_专业资料。教你如何设置Oracle的SQL跟踪...SQL> alter session set events '10046 trace name context off'; Session ...
ORACLE查看执行计划及SQL TRACE_计算机软件及应用_IT/计算机_专业资料。ORACLE...SQL> alter session set events '10046 trace name context off'; Session ...
oracle sql 优化与提高讲义(三)_IT/计算机_专业资料。Oracle Database : SQL...SQL> alter session set events ‘10046 trace name context forever, l l 4...
Oracle9i(Version 9.2)SYS_CONTEXT 函数的用法 用法...session if it was established by an Oracle ...SQL> 可以明显地看出这个认证明明是应该通过 DATABASE...
Oracle session表和process表字段描述_IT认证_资格考试/认证_教育专区。Oracle ...Oracle内部进程的username为空。 COMMAND: session正在执行的SQL Id。1代表create...
修改 Oracle 字符集的方法 步骤如下: SQL> shutdown...name context forever,level 12'; Session altered....How to Recreate the DB Control Repository ...
Oracle SQL 培训编制:邓小斌 版本:V1.0 1 Copyright ? Infore Holding , ...grant create session to apps ? grant dba to apps ? CREATE PUBLIC SYNONYM...
SQL_TRACE是Oracle数据库提供的用于进行SQL跟踪的手段, 在某种意义上讲,可以说...alter session set events '10046 trace name context off'; How To Get ...
(select SQL_HASH_VALUE from v$session where paddr in (select addr from v$process where spid = (select b.oracle_process_id from apps.fnd_concurrent_...
LOGO ORACLE数据库会话跟踪方法四川成享软件—刘德鹏...SESSION SET EVENTS '10053 trace name context ...explain=apps/<password> 3200 sort='(prsela,exee...
热门文档