-
编辑 删除
11g Adaptive Cursor Sharing
11g之前的绑定变量偷窥，带来一些绑定变量导致执行计划问题。研究下11g的Adaptive Cursor SharingSQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - ProductionPL/SQL Rele...
-
编辑 删除
BUG Kewastunpackstats(): Bad Magic 1 （xxx，0）
ALERT日志出现：kewastUnPackStats(): bad magic 1 (0x7f3521c489a0, 0)kewastUnPackStats(): bad magic 1 (0x7f3521c489a0, 0)kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)kewastUnPackStats(): bad magic 1 (0x7f3521c458e0, 0)kewastUnPack...
-
编辑 删除
存储镜像导致rac数据库hang
DMESG查看日志，发现设备问题。nf_conntrack version 0.5.0 (16384 buckets, 65536 max)device-mapper: table: 253:27: multipath: error getting devicedevice-mapper: ioctl: error adding target to tabledevice-mapper: table: 253:27: multipath: error getting devicedevice-mapper: ioctl: error adding targe...
-
编辑 删除
SCAN VIP/Listener do not fail back after public network recovered
由于网络闪断，2节点rac，出现sanlistener 飘逸到一个节点的情况： [grid@hq-d-rac0201 ~]$ srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is running on node hq-d-rac0201SCAN Listener LISTENER_SCAN2 is enabledSCAN listener LISTENER_SCAN2 is running on n...
-
编辑 删除
11.2.0.3 rac path16670704遇到的问题
问题现象：[root@hq-d-cordys02 dbhome_1]# su - oracle[oracle@hq-d-cordys02 ~]$ opatch lsinventoryOracle Interim Patch Installer version 11.2.0.3.0Copyright (c) 2012, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1Central Inventory : /u01/gri...
-
编辑 删除
Bug 10419984--FOR oracle 11.2.0.1 adg ora-600[kcbr_apply_change_11]
1:standby database :SQL> select * from v$version;BANNER------------------------------------------------------------------------------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionPL/SQL...
-
编辑 删除
Bug 13496250 : SQL NO LONGER WORKING AFTER UPGRADE 11.2.0.3 ORA-00976
mos 上例举此bug 是当树在作为子查询的时候，父查询使用了 on ansci语法字句，导致报错 ora-00976再次显示bug如下：SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database...
-
编辑 删除
了解Oracle补丁知识
oracle 补丁知识学习
-
编辑 删除
high VERSION_COUNT案例1
点击(此处)折叠或打开SQL> set pages 2000 lines 100 SQL> SELECT b.* 2 FROM v$sqlarea a , 3 TABLE(version_rpt(a.sql_id)) b 4 WHERE loaded_versions >=100;COLUMN_VA...
