ITPub博客

inventory_loc用来提定oracle的inventory指向的目录，inventory里存放着安装oracle相关软件的清单，但多个操作系统用户安装不同的软件时会在了权限问题，这个配置存放在/etc/oraInst.loc这个文件中。遇到问题会报以...

Different Upgrade Methods For Upgrading Your Database (Doc ID 419550.1)Things to Consider Before Upgrading to 11.2.0.3 Grid Infrastructure/ASM (Doc ID 1363369.1)Complete Checklist to Upgrade the D...

$ ps -ef |grep $ORACLE_SID|grep -v grep|awk '{print $2}' | xargs kill -9$ ipcs -m | grep oracle | awk '{print $2}' | xargs ipcrm shm

PurposeThis article describes similarities and differences between different features available for high availability and distributed systems. It contains comparison between multiple features...

表:alter table_name move tablespace new_tablespace;重建索引表分区:ALTER TABLE PART_TAB MOVE PARTITION "P_412823" TABLESPACE "HROLTPDATA412823" UPDATE INDEXES;索引:alter index indexname rebuild online;...

发现一个用户下统计信息没有生成,查询user_tab_modifications 发现变动信息也超过10%没有警告日志执行exec dbms_stats.gather_schema_stats(ownname => 'test',granularity => 'ALL',cascade => true);还是没有生成...

1. 采用高速的存储设备,提高读写能力，如：EMC 和NetApp， 2. 假如tab1表中的没有数据的话 DROP   TABLE   TAB1;CREATE   TABLE   TAB1   AS   SELECT   *   FRO...

In this DocumentPurposeScopeDetails Description Cause Expected behavior. Block Corruption. Overlapped Extents. Overlapped ASM extent. Oracle defect. Identify th...

在Oracle9i里，Oracle提供了一个内部事件，用以强制刷新Buffer Cache，其语法为:alter session set events 'immediate trace name flush_cache level 1';或者:alter session set events = 'immediate trace name...

In this DocumentSymptomsCauseSolutionReferencesApplies to:Oracle Server - Enterprise Edition - Version 8.1.7.4 and laterInformation in this document applies to any platform.Applies to 8.1.7.4 onwards....

http://blog.csdn.net/tianlesoftware/article/details/4717318

1.restore archivelog all   恢复全部归档日志文件2 restore archivelog from logseq 5 until logseq 8;3  restore archivelog from logseq 5;4 restore archivelog from time 'sysdate-7';5 restore arch...

1  RMAN> BACKUP CHECK LOGICAL VALIDATE DATAFILE n ;select * from v?$database_block_corruption;2 dbv file=EYGLE.DBF blocksize=8192

SELECT NAME_,       MAX(DECODE(CLASS, '语文', T.SCORE, 0)) 语文,       MAX(DECODE(CLASS, '数学', T.SCORE, 0)) 数学,       MAX(DECODE(CLASS, ...

You have following choices to free up space from flash recovery area:1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,then consider changing RMAN ARCHIVELOG DELETION POLICY.2. B...

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2Information in this document applies to any platform.Symptoms-- Problem Statement:On 10.2.0.3...

ALTER INDEX &index_name  REBUILD PARTITION &PARTITION_NAME;ALTER INDEX &index_name  REBUILD SUBPARTITION &PARTITION_NAME;

Parallel技术对于一个大的任务，一般的做法是利用一个进程，串行的执行，如果系统资源足够，可以采用parallel技术，把一个大的任务分成若干个小的任务，同时启用n个进程/线程，并行的处理这些小的任务，这些并发的进...

dump 命令dump命令模仿oracle的”alter system dump datafile”命令，解析并显示oracle的块格式。目前支持的块包括文件头（只有部分信息）、数据段头、表和索引数据块，其他的块只显示块头。这已经足够大部分情况的...

In this DocumentPurposeTroubleshooting StepsReferencesApplies to:Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.1.0.6 [Release 10.1 to 11.1]Information in this document applies to any pla...