随笔分类 - oracle性能优化,故障处理
摘要：How to Identify ORA-00060 Deadlock Types Using Deadlock Graphs in Trace (Doc ID 1507093.1) To Bottom Oracle Database - Enterprise Edition - Version 9.
阅读全文
摘要：监控平台收集不到wrh$_tablespace_space_usage表数据。 awr报告没有任何快照信息。 alter日志发现报错：Suspending MMON slave action kewrmafsa_ for 82800 seconds MMON进程trace文件报错如下： Unable
阅读全文
摘要：APPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Oracle Database - Enterprise Edition - Version 1
阅读全文
摘要：APPLIES TO: Oracle Database Exadata Express Cloud Service - Version N/A and laterOracle Database Backup Service - Version N/A and laterOracle Database
阅读全文
摘要：APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform. SYMPTOMS RMAN backu
阅读全文
摘要：In this Document Symptoms Cause Solution References APPLIES TO: Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this d
阅读全文
摘要：APPLIES TO: Oracle Database Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Clou
阅读全文
摘要：APPLIES TO: Oracle Hospitality OPERA 5 Property Services - Version 5.4.0 and laterInformation in this document applies to any platform. GOAL The docum
阅读全文
摘要：Document Display Give Feedback... Search: ORA-20001:sTATISTIC aDVISOR Restore Pane Copyright (c) 2022, Oracle. All rights reserved. Oracle Confidentia
阅读全文
摘要：事故描述： 6月1日，10点40分，出现general error: 1114 The table 'xxx' is full异常报错。 11:05定位问题，发现由于xxx表数据量过大，磁盘对应的ibd文件大小达到2T。 由于文件系统使用的是ext2格式(单个文件大小不能超过2T)，所以导致该表对应
阅读全文
摘要：In single instance environment, when a deadlock happens, it often reports ORA-60, see Document 15476.1 FAQ: Detecting and Resolving Locking Conflicts
阅读全文
摘要：Export: Release 12.2.0.1.0 - Production on Wed Nov 4 14:35:20 2020 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Connec
阅读全文
摘要：APPLIES TO: Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle Database - Standard Edition - Version 12.2.0.1 and laterInformatio
阅读全文
摘要：In this Document Symptoms Changes Cause Solution References APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.4 and later Oracle Datab
阅读全文
摘要：AWR Report shows contention for 'row cache objects' as the top wait: Top 5 Timed Foreground Events Event Waits Time(s) Avg wait (ms) DB time Wait Clas
阅读全文
摘要：SYMPTOMS DataPump shows following errors : Starting "<LOGIN_SCHEMA>"."SYS_IMPORT_FULL_14": <LOGIN>/******** parfile=<PARFILE_NAME>.par logfile=<LOG_NA
阅读全文
摘要：症状 Datapump导出和导入（expdp和impdp）可能会遇到突然严重的性能问题，因为DW和DM进程经常等待 "StreamsAQ: enqueue blocked on low memory"。 以下是expdp logtime = all命令的示例症状。 (logtime 参数在 12.1
阅读全文
摘要：PURPOSE Purpose In some situations it may happen that your session is hanging and is waiting for a 'Library cache lock'. This document describes how t
阅读全文
摘要：Step by step to resolve ORA-600 4194 4193 4197 on database crash (Doc ID 1428786.1) To Bottom In this Document Symptoms Changes Cause Solution Referen
阅读全文
摘要：三节点的rac环境。 asm磁盘组为+DATA5 由于运维人员疏忽，在加表空间时，少写了一个加号，表空间创建的位置变为$ORACLE_HOME/dbs，使用12c新特性在线移动数据文件，将数据文件移动至asm磁盘组， 2-3节点访问表空间出现ora-1157错误，一节点正常。 解决思路： 将表空间内
阅读全文
