-
编辑 删除
ogg状态检查，并重启
#!/bin/bash # by ray# 2016-06-06. ~/.bash_profilegglog=/tmp/.ggslog.logstatuslog=/home/oracle/shell/check_ogg_extractstatus.logcd /u01/oggwhile truedoecho "info all"|./ggsci > ${gglog}array=(`gre...
-
编辑 删除
ora-1652_solvent.sh
#!/bin/bash# by ray# 2016-05-19export ORACLE_BASE=/u01/oracleexport ORACLE_HOME=$ORACLE_BASE/11gexport ORACLE_SID=RACDB1export PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:$ORACLE_HOME/li...
-
编辑 删除
ORA-00245 RMAN-08132解决
ChangesRAC Database release 11.2 CauseThe error description is:00245, 00000, "control file backup failed; target is likely on a local file system" // *Cause: Failed to create a control file backup because some process // si...
-
编辑 删除
Oracle11g ORA-609 TNS 12537 TNS 12560
###################alter_oraSID.log####################Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for Linux: Version 11.2.0.1.0 - Production Oracle Bequeat...
-
编辑 删除
事务压缩 对表的影响 compress for oltp
1 创建测试表并对添加数据 ………...省略2 修改表的属性为事务型压缩SQL> alter table TH_VEHICLE_ALARM_comp compress for oltp;Table altered.3 查询速度的对比非压缩表275 rows selected.Elapsed: 00:00:00.17...
