RMAN CURSOR_SHARING=EXACT脚本

2011/12/11 by admin 2 Comments


CREATE OR REPLACE TRIGGER RMAN_CURSOR_SHARING
  AFTER LOGON ON DATABASE
BEGIN
  if (upper(sys_context('USERENV', 'MODULE')) like '%RMAN%')
   THEN
    execute immediate ' alter session set cursor_sharing=EXACT';
  END IF;
END;

Filed Under: Oracle, Oracle脚本script

Comments

Srain says

2013/12/26 at 09:58

exp/imp使用的是类似查询,不能用similar感觉rman不是使用的redo流吗，好像不怎么用查询吧，

回复
- Ask_Maclean_liu_Oracle says
  
  2013/12/26 at 11:31
  
  rman内部是调用PL/SQL包，这些包也会递归使用SQL
  
  回复

Comment 取消回复

沪ICP备14014813号-2