create or replace trigger test.after_logon_trg after logon on test.schema begin execute immediate 'alter session set cursor_sharing=force'; end; / CURSOR_SHARING_EXACT Hint When cursor sharing is enabled all literals are converted to bind variables. If there is a reason you don't want this...
- 变通方案:如果可能,在开始 Export Data Pump 作业之前先设置 CURSOR_SHARING=EXACT - 原因:将 cursor_sharing 设置为 similar 时,基于成本的优化器(Cost Base Optimizer,CBO)中出现查询优化问题 - 跟踪:Data Pump Worker 跟踪显示“SELECT NVL((SELECT /*+ NESTED_TABLE_GET_REFS */ :”SYS_B_0″ FROM ...
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x61afe929, pid=7356, tid=7248 # # JRE version: 6.0_21-b07 # Java VM: Java HotSpot(TM) Client VM (17.0-b17 mixed mode, sharing windows-x86 ) # Problematic frame: # C [oracommon11.dll+0x14e929] # # An error report file with m...