ITPub博客

From:http://www.orafaq.com/node/66

Fromhttp://vongates.itpub.net/post/2553/462828Oerr--ORA-02174: Missing required thread number上周一同事到客户处为现有的RAC环境新增一节点,前面工作都很顺利,但最后用DBCA增加Instance是遇到 ORA-02174: Miss...

From:http://www.orafaq.com/node/758

From:http://www.oracle.com/technology/pub/articles/vasiliev-oracle-jdbc.html

清内存对象及转储命令(zt)清buffer cache清shared pool转储sga转储library cache转储控制文件、日志文件、数据文件Ref: http://haochunpeng.itpub.net/post/385/786309i清buffer cachealter session set events...

alter session set timed_statistics=true;alter session set sql_trace=true;alter session set  events '10046 trace name context  forever,level 12';alter session set tracefile...

download site:http://www.oracle.com/technology/tech/oci/instantclient/index.htmlphp+instant clienthttp://www.oracle.com/technology/global/cn/pub/notes/technote_php_instant.htmlhttp://www.oracle.c...

From:metalink note 60545.1How to extract controlfiles, datafiles, and archived logs from SMR backupsets without using RMAN Introduction: When using RMAN to restore objects (d...

From:http://www.orafaq.com/wiki/Oracle_database_Backup_and_Recovery_FAQ#Can_one_restore_RMAN_backups_without_a_CONTROLFILE_and_RECOVERY_CATALOG.3F另见如何使用DBMS_BACKUP_RESTORE包http://www.dbanot...

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

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

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

From:http://**/viewthread.php?tid=64887=============================================MOVE在线处理move table  和 rebuild index的方法=============================================In Orac...

From:http://www.orafaq.com/node/31

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

http://www.itpub.net/thread-1143438-1-3.html

restore controlfile from autobackup recovery area = '/home/oracle/oradata/flash';

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

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

http://blog.naver.com/PostView.nhn?blogId=beatles0&logNo=140063599142