Recovery Made Simple: Oracle Flashback Query
From:http://www.orafaq.com/node/50Sometimes it is a rouge query, sometimes a simple data clean up effort by the users, whatever may the cause be, inadvertent data-loss is a very common phen...
About DBMS_METADATA
From:http://www.orafaq.com/node/57http://www.orafaq.com/node/59http://yangtingkun.itpub.net/post/468/262772http://www.eygle.com/archives/2004/12/oracle9iaioeoeo.html
Oracle Data Pump - Part III
From:http://www.orafaq.com/node/74On our quest to learn about Oracle's Data Pump utility it has often been compared to the old export and import (exp & imp) utilities that we have all grown...
How to Re-Organize a Table Online
From:http://**/viewthread.php?tid=64887=============================================MOVE在线处理move table 和 rebuild index的方法=============================================In Orac...
Oracle 10g New Features: Flashback and RMAN
From:http://www.orafaq.com/node/31
On-line Table Reorganization and Redefinition
From:http://www.orafaq.com/node/4Tables can be reorganized and redefined (evolved) on-line with the DBMS_REDEFINITION package. The process is similar to on-line rebuilds of indexes, in that the ...
Oracle RAC与第三方集群
http://www.itpub.net/thread-1143438-1-3.html
restoring the controlfile from the flash recovery area
restore controlfile from autobackup recovery area = '/home/oracle/oradata/flash';
转:analyze table compute statistics
http://www.cnblogs.com/rootq/archive/2009/02/01/1382197.html观察analyze table compute statistics 都对什么对象统计了信息analyze table compute statistics = analyze table compute statistics for table for...
ORACLE 9I, 10G, AND 11G RAC ON LINUX所需要的HANGCHECK-TIMER MODULE介绍
http://zhang41082.itpub.net/post/7167/467614此文档摘自METALINK:726833.1,所适用的ORACLE版本为:Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 11.1.0.7从9.2.0.2版本开始,ORACLE...
RAC Frequently Asked Questions
http://blog.naver.com/PostView.nhn?blogId=beatles0&logNo=140063599142
Tips–How to configure Asynchronous i/o on HP-UX
http://blog.vongates.com/?p=8Subject:HP-UX: Asynchronous i/o Doc ID :Note:139272.1Type:BULLETIN Last Revision Date:21-JUL-2004Status:PUBLISHED startup ORA-00445: back...
How to set EVENTS in the SPFILE (from metalink)
文档 ID:注释:160178.1类型:BULLETIN 上次修订日期:02-MAY-2006状态:PUBLISHEDPurpose=======This
ttrtyrt
yrtyrty
转:Oracle临时表空间问题解答
转:Oracle临时表空间问题解答查看Oracle回滚段的周详情况,连同对性能的影响: select a.name, b.extents, b.rssize,b.xacts,b.waits,b.gets,b.optsize,b.status from v$rollname a,v$rollstat b whe...
Upgrading to Oracle 10g with a Logical Standby in Place
Upgrading to Oracle 10g with a Logical Standby in Place The procedures below contain information for upgrading your current release of Oracle to the new 10g release when a logical standby da...
Upgrading to Oracle 10g with a Physical Standby in place
Upgrading to Oracle 10g with a Physical Standby in place The procedures below contain information about upgrading your current release of Oracle to the new 10g release for a configuration that i...
转:创建Oracle 10gR2的local stream和downstream real-time apply 流复制
http://wenaini.itpub.net/post/24510/469940
managed recovery - redo is inconsistent with data block
http://www.orafaq.com/forum/t/59863/0/
How to Dump Redo Log File Information
How to Dump Redo Log File InformationPURPOSEThis article explain how to obtain a dump of the header information in the online redo log file(s), as well as obtaining selected information from the&...