How to set context in a SQL session in Oracle Apps
How to set context in a SQL session in Oracle Apps
Posted by Abhijit November 14, 2013
As Oracle SQL Developer doesn’t require an Oracle client, it doesn’t look at the Oracle registry settings to get your default NLS settings (where TOAD looks). It picks up defaults from the OS (i.e. Regional and Language Settings on Windows).
To fix this (i.e.to make the Oracle function, USERENV (‘lang’), and return language as US, change your SQL Developer NLS settings (Tools > Preferences > Database > NLS Parameters) to have Language = AMERICAN and Territory = AMERICA
For Toad you need to go to -> Access NLS Parameters, from the Database menu, select Administer|NLS Parameters
Setting the organization/profile on the SQL session in a Multi Org instance
There some times org specific tables for that you need to setup org_id, you can use any of the following
Oracle 11i script to set the profile for a responsibility associated to a user
BEGIN
fnd_global.apps_initialize (user_id => 101, resp_id => 123, resp_appl_id => 234 );
END;
OR
Oracle 11i script to set the operating unit
BEGIN
fnd_client_info.set_org_context (CONTEXT => '779'); -- org_id END;
Oracle r12 equivalent
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...
热门文档