ITPub博客

Purpose本文档提供了关于自动维护任务或 AUTOTASK 作业的更多信息，这些作业是 11g 系统自动生成的新设置。本文档介绍了 10g 和 11g 之间关于维护任务的一些主要差异。Scope本文档与 Oracle 11g 相关，目标受众是 Oracle DBA 和支持分析人员。DetailsIntroductionOracle 11g 数据库有三个...

今天在一张大表(分区表)上创建bitmap 索引,执行一段时间后就hang在那里 等待事件为row cache lock查询得知:SQL>select event,p1 from v$session a wherea.username is not null and a.status='ACTIVE'EVENT                      &nb...

APPLIES TO:Oracle Server - Enterprise Edition - Version 10.2.0.3 to 10.2.0.4 [Release 10.2]Information in this document applies to any platform.SYMPTOMSAfter creating materialized view logs on two very active tables, many sessions doing DML on those base tables were showing 'DFS L...

在线重定义过程中如果使用DBMS_REDEFINITION.copy_table_dependents进行对依赖对象进行拷贝在线重定义后会发现列not null没有copy过来,执行sql alter table modify column not null报如下错误ORA-01442: column to be modified to NOT NULL is already NOT NULL 通过sql查询发现select constraint_name,constraint_ty...

Error:  ORA-314  Text:   log <name> of thread <num>,expected sequence # <num> does not match         <num> -------------------------------------------------------------------------------Cause:  The online log is out of se...

Oracle Server - Enterprise Edition - Version 9.2.0.1 and laterInformation in this document applies to any platform.***Checked for relevance on 27-Jun-2012***SYMPTOMSInsert on a table reports: ORA-01536.01536, 00000, "space quota exceeded for tablespace '%s'"// *Cause:  The space quo...

症状:数据库可以mountAlter databaseopen 的时候报如下错误:ORA-00600: internal error code, arguments:[3705], [1], [2], [2], [0], [], [], [] 解决办法1      startupmount2      alterdatabase backup control...

官方解释如下:ORA-12838 cannot read/modify an object aftermodifying it in parallelCause: Within thesame transaction, an attempt was made to add read or modification statements ona table after it had been modified in parallel or with direct load. This is notpermitted.Action: Rewrite thetr...

以下命令使用sys用户执行1.       创建修复表DBMS_REPAIR.ADMIN_TABLES SQL>BEGIN  2   DBMS_REPAIR.ADMIN_TABLES (  3   TABLE_NAME => 'REPAIR_TABLE',  4   ...

ORA-1578错误，出现的场景不同，解决办法也不相同，以下是各种场景下的解决办法一、    Database in ARCHIVELOG mode(归档并有备份):使用RMAN Block Mediarecovery进行恢复Mos相关文章Note 342972.1 How to perform Block Media Recovery(BMR) ...

Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterInformation in this document applies to any platform.***Checked for relevance on 21-Jan-2014***SYMPTOMSOn : 10.2.0.4 version, STORAGEASM failed to start after server reboot, the disk group can not mount,If you try t...

ORA-1122:database file %s failed verification checkORA-1110 : datafile : ORA-1207: ORA 1207 file is more recent thancontrol file 该错误表明:数据文件头部信息与控制文件信息部一致,数据文件头部CHECKPOINT大于controlfileCHECKPOINT,需要重建控制文件...

APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]Information in this document applies to any platform.SYMPTOMS1. ASM diskgroups in single instance environment will not be mounted with the following similar error in sqlplus screen. SQL> a...

检测undo使用情况SQL> select sum(bytes)/1024/1024 MB from dba_free_space wheretablespace_name='UNDOTBS1';         MB---------- 22128.625 SQL> select sum(bytes)/1024/1024 MB from dba_data_files wh...

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 ...

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

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

 1   启动报ORA-01157 ORA-01110状态2   启动数据库到mount 状态3   alter database datafile offline drop;4   alterdatabase open5   创建新的u...