-
编辑 删除
AWR报ORA-6502临时解决办法
用sys更新awr相关报表：update WRH$_SQLTEXT set sql_text = SUBSTR(sql_text, 1, 2000);
-
编辑 删除
oracle DG管理命令备忘录
1、 启动和停止日志应用服务SQL> ALTER DATABASE START LOGICAL STANDBY APPLY INITIAL;### SQL> ALTER DATABASE STOP LOGICAL STANDBYAPPLY; ### SQL> ALTER DATABASE START LOGICALSTANDBY APPLY; 2、 查看DG的状态? v$dataguard_statsApply lag：表明解决standby和p...
-
编辑 删除
dbms_stats包的几个用法举例
记录常用的几个，备查[@more@]SQL> exec dbms_stats.create_stat_table('PVG_WH1_HL','temp_stat');PL/SQL procedure successfully completed.SQL> exec dbms_stats.export_table_stats(ownname=>'PVG_WH1_HL',tabname=>'LAGI',STATTAB=>'TEMP_STAT',CASCADE=>TRUE);PL/SQL procedure successfully completed.SQL> exec dbms_stats.import_table_stats(ownname=>'PVG_WH1_HL',tabname=>'LAGI',STATTAB=>'TEMP_STAT',CASCADE=>TRUE);PL/SQL procedure successfully completed.SQL> exec dbms_stats.LO
-
编辑 删除
从MySQL同步数据到oracle的小脚本
export ORACLE_BASE=/home/app/oracleexport ORACLE_HOME=/home/app/oracle/product/11.2.0/db_1export ORACLE_SID=tfsxindaidbexport PATH=/home/app/oracle/product/11.2.0/db_1/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/home/oracle/binexport L...
