gyc5268的博客

SPM SQL PLAN BASEline MANUAL 1、 var temp number; exec :temp:=dbms_spm.load_plans_from_cursor_cache(sql_id=>‘原目标SQLid’,plan_hash_value=> ‘原目标sql 的plan hash value’); 2、改写远目标sql 的sql 文本，加入hint 等，生...

ogg 12.3.0.14 oracle版本12.2.0.1 一、静默安装 配置文件 /home/oracle/ggs/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp ############################## INSTALL_OPTION=ORA12c SOFTWARE_LOCATION=/home/oracle/o...

一、主库全备份 rman target / run { backup as compressed backupset filesperset 1 format ‘/home/oracle/dg/full_db_%d_%s_%t’ database ; } 二、备份控制文件 sql>alter database create standby controlfile as ‘/home/ora...