摘要:
Oracle 数据库运行在linux6/7中,启用大页之后,我们经常在/var/log/messages里面会看到类似这样的记录: Jul 31 09:46:27 p1erpdb01 kernel: oracle (6444): Using mlock ulimits for SHM_HUGETLB 阅读全文
摘要:
In this Document Goal Solution References APPLIES TO: Oracle Database - Enterprise Edition - Version 12.2.0.1 and later Information in this document a 阅读全文
摘要:
In this Document Goal Solution References APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later Oracle Database Cloud Schema 阅读全文
摘要:
Patch35074478信息 patch35074478 补丁(ORA-800 / Set Priority / DB Performance Merge Patch for 19.19 (Requires Root Access) - 34286265 34318125) ORA-00800: 阅读全文
摘要:
19c RAC在线替换OCR ASM磁盘 1.目标 ASM磁盘组EAP_OCR 要替换一块磁盘 NEW: /dev/EAP_OCR_02_03 OLD: /dev/EAP_OCR_02_01 --> name: EAP_OCR_0001 使用新的磁盘/dev/EAP_OCR_02_03 替换 ASM 阅读全文
摘要:
19.19 RAC安装 35074478 补丁(ORA-800 / Set Priority / DB Performance Merge Patch for 19.19 (Requires Root Access) - 34286265 34318125) Oracle Database 19 R 阅读全文
摘要:
(IV) Bugs Fixed by This Patch 35074478 The following are the bugs fixed by this patch: 34286265: SAGEASM-E HIT ORA 800 [SET PRIORITY FAILED] WHEN STAR 阅读全文
摘要:
禁用HAIP。 注意:禁用HAIP后,在线加节点在执行root.sh步骤会失败,需要在新节点也禁用HAIP。 若ora.cluster_interconnect.haip为online状态,私有网卡上会虚拟出169.254.*.*的地址出来。 若ora.cluster_interconnect.ha 阅读全文
该文被密码保护。 阅读全文
摘要:
1、 查看表 和 索引的历史统计信息 select * from WRI$_OPTSTAT_TAB_HISTORY ; (1) 历史统计信息保存在以下几张表中: WRI$_OPTSTAT_TAB_HISTORY 表的统计信息 WRI$_OPTSTAT_IND_HISTORY 索引的统计信息 WRI$ 阅读全文