ITPub博客

Definition:Versions:7.0 - 10.2 Documentation: 9.0This wait happens when a session wants to access a database block in the buffer cache but it cannot as the buffer is "busy". The two main cas...

This wait event usually occurs when you have tried to dynamically resize a component of the SGA such as the buffer cache.The "buffer exterminate" waits can only happen if part of the buffer cache is b...

 常用的fdisk命令只可以格式化小于2TB的磁盘，大于2TB的磁盘需要使用parted进行磁盘分区，磁盘为GPT格式。使用fidks –l 报如下警告[root@jkkdbserveru01]# fdisk -l Disk/dev/cciss/c0d0: 56...

SQL> desc dbms_monitorElement                    Type      -------------------------- --------- ALL_MODULES     &nbs...

PURPOSE-------The purpose of this note is to provide a method for taking system state dumpson the very rare occasions when connect internal is not possible. SCOPE & APPLICATION----------------...

Collection commands for Hanganalyze and Systemstate: Non-RAC:Sometimes, database may actually just be very slow and not actually hanging. It is therefore recommended,  where possible to ...

Wait event 'asynch descriptor resize' is waited for when the number of asynchronous descriptors reserved inside the OS kernel is being re-adjusted.When the number of asynchronous I/O's submitted ...

1 创建目录mkdir -p /u01/app/11.2.0/gridchown –R oracle:oinstall /u01/app/11.2.0/grid 2 Backup the database:使用rman全备数据库 3 Backup the OCR file Backu...

(Doc ID 1233505.1)APPLIES TO:Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]Information in this document applies to an...

--row lock contention 阻塞进程查询select *  from v$session a where a.SID in (select BLOCKING_SESSION                   from v$session m&nbsp...

In this Document (Doc ID 289690.1)Purpose File Formats for Data Uploaded to Oracle SupportTroubleshooting Steps 1. Data Gathering for All Oracle Clusterware Issues 2. Data Gatherin...

Oracle Error:  ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below  ORA-01152: file 1&nb...

【RAC工具】cluvfy 一、CVU介绍Cluster Verification Utilit(CVU)是Oracle所推荐的一种集群检验工具,CVU可以验证在主群集组件在运作阶段或时期。组件可以是基本的，如免费的磁盘空间，或者也可以是复杂的，...

Oracle Server - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]Information in this document applies to any platform.SYMPTOMSCTSSD runs in observer mode even though no time sync softwa...

 select distinct   ses.ksusenum sid, ses.ksuseser serial#, ses.ksuudlna username,KSUSEMNM module,   ob.kglnaown obj_owner, ob.kglnaobj obj_name   ,lk.kgllkc...

--  select distinct   ses.ksusenum sid, ses.ksuseser serial#, ses.ksuudlna username,ses.ksuseunm machine,   ob.kglnaown obj_owner, ob.kglnaobj obj_name   ,pn.kg...

 RACcheck介绍RACcheck 是一个rac的审计工具,审计rac,crs,asm,GI中各种重要的配置,审计内容如下: OS kernel parameters OS packages Many other OS configuration settings important to RAC....

Instance Recovery: Instance recovery is done automatically by SMON. it is reqd in case of abonormal shutdown such as shutdown abort or any such reason.Instance recovery is recovery of a single da...

OracleDatabase - Enterprise Edition - Version 7.3.4.0 and laterInformation in this document applies to anyplatform.PURPOSEThis article explainshow to perform. a BASIC Health Check on th...

========Script. tfstsfgm========SET ECHO off REM NAME:TFSTSFRM.SQL REM USAGE:"@path/tfstsfgm" REM ------------------------------------------------------------------------ REM...