RMAN CURSOR_SHARING=EXACT脚本

RMAN CURSOR_SHARING=EXACT脚本

 

 


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;

Posted

in

by

Tags:

Comments

2 responses to “RMAN CURSOR_SHARING=EXACT脚本”

  1. Srain Avatar
    Srain

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

    1. Ask_Maclean_liu_Oracle Avatar

      rman内部是调用PL/SQL包,这些包也会递归使用SQL

Leave a Reply to Srain Cancel reply

Your email address will not be published. Required fields are marked *