早就有这样一个想法，整理一个链接列表，分专题的，这样大家遇到问题有个快速的入口，并且有丰富的链接!

不断的维护，这样慢慢的就可以丰富起来!

大家跟帖，要求提出一个专题和至少一个连接，然后由斑竹负责整理！

不知大家意下如何!

最近更新 2005-10-16 by Eygle

[ 本帖最后由 eygle 于 2007-12-10 22:03 编辑 ]

学习经验谈:

如何学习Oracle-eygle的方法经验谈
http://www.eygle.com/archives/2005/08/ecinieoracleouo.html

junsansi 之 我想对初学oracle的朋友们说~~
http://www.itpub.net/viewthread.php?tid=976678

Statspack相关文档:

关于Statspack，以下是我收集的一些连接

otn文档:

http://otn.oracle.com/deploy/performance/pdf/statspack.pdf

http://otn.oracle.com/deploy/per ... TUNING_dialeris.pdf

采用Statspack进行高级调优
http://www.oracle.com/global/cn/ ... html?o13expert.html

http://otn.oracle.com/deploy/per ... _tuning_otn_new.pdf

Installing and Running Statspack(for 8.0 8.1.5的扩展版本)
http://www.oracle.com/oramag/ora ... tatspack-other.html

Diagnosing Performance with Statspack:
http://www.oracle.com/oramag/oracle/00-Mar/o20tun.html

Advanced Tuning with Statspack
http://otn.oracle.com/oramag/oracle/03-jan/o13expert.html

Itpub精华:

STATSPACK,刚刚解决的一个问题,请大家注意!
http://www.itpub.net/showthread.php?s=&threadid=72037

StatsPack在数据库优化中的使用
http://www.itpub.net/showthread.php?s=&threadid=73500

Metalink文档(需要metalink帐号访问):

FAQ- Statspack Complete Reference
http://metalink.oracle.com/metal ... OT&p_id=94224.1

What is StatsPack and where are the READMEs?
http://metalink.oracle.com/metal ... p;p_database_id=NOT

Installing and Configuring StatsPack Package
http://metalink.oracle.com/metal ... p;p_database_id=NOT

Creating a StatsPack performance report
http://metalink.oracle.com/metal ... p;p_database_id=NOT


Others whitepaper:

http://www.osborne.com/products/0072133783/0072133783_ch15.pdf

http://www.dbatoolbox.com/WP2002_06/statspack_01.pdf

http://my.oraperf.com/download/yapp_anjo_kolk.pdf

statspack分析实例

Statspack专题
http://www.eygle.com/statspack/statspack_list.htm

求助 oracle 吃cpu
http://www.itpub.net/showthread.php?s=&threadid=92560

看一下spreport，有什么建议啊
http://www.itpub.net/showthread.php?s=&threadid=105361

关于statspack的报告
http://www.itpub.net/showthread.php?s=&threadid=85180

各位班主和高手请留意!
http://www.itpub.net/showthread.php?s=&threadid=106156

db file scattered read-DB文件分散读取
http://www.eygle.com/statspack/statspack12.htm

[ 本帖最后由 eygle 于 2008-7-5 09:08 编辑 ]

Oracle等待事件

Oracle Wait Analysis Techniques
http://www.dbazine.com/burleson8.html

"log file sync" 等待事件
http://www.eygle.com/statspack/statspack14-LogFileSync.htm

Enqueue
http://www.eygle.com/statspack/statspack13.htm

FAQ
ORACLE技术问题专家问答五则
http://www.tongyi.net/article/20011118/200111182617.shtml

Oracle Internal
How to simulate block corruption with BBED?
http://www.itpub.net/showthread.php?s=&threadid=422260

How to repair corruption block use BBED?  
http://www.eygle.com/archives/20 ... lock_with_bbed.html

读ORACLE脱机文件
http://www.itpub.net/showthread.php?s=&threadid=350018


Oracle10g Release 2 New Feature
Oracle 10g Release 2 new tools:asmcmd
http://www.itpub.net/showthread.php?s=&threadid=420217

Oracle 10gR2 Study Notes:New View V$FLASH_RECOVERY_AREA_USAGE
http://www.itpub.net/showthread.php?s=&threadid=420672

Oracle安装与卸载

在Solaris9+Vcs4.0+Vxvm4.0+EMC Cx500上安装Oracle9i Rac的说明
http://www.eygle.com/ha/Install.Oracle9iRac.On.Veritas.EMC.htm

P4上安装oracle8i的解决方法
http://www.itpub.net/showthread. ... =%C9%BE%B3%FDoracle

windows上彻底删除oracle的方法
http://www.itpub.net/showthread. ... =%C9%BE%B3%FDoracle

ORACLE8.17在RH7.x/RH8上的安装
http://www.itpub.net/showthread. ... =oracle%B0%B2%D7%B0

Oracle，HA在Unix上双机环境的安装指南
http://www.itpub.net/showthread. ... =oracle%B0%B2%D7%B0

Oracle 9i 在Red Hat Linux 7.3下的安装
http://www.itpub.net/showthread. ... =oracle%B0%B2%D7%B0

redhat7.2下安装oracle9i文档
http://www.itpub.net/showthread. ... =oracle%B0%B2%D7%B0

在Solaris8 for x86上安装Oracle8.1.7手册
http://www.itpub.net/showthread. ... =oracle%B0%B2%D7%B0

这些都是我在坛子里找到的一些关于安装方面的文档，可能不全，大家共同努力吧

性能调整

Database Performance Tuning on AIX
http://www.redbooks.ibm.com/pubs/pdfs/redbooks/sg245511.pdf

Oracle Expert Tuning Secrets to reduce disk I/O
http://www.dbazine.com/burleson6.html

Monitoring and Improving Application Performance
http://otn.oracle.com/docs/produ ... .920/a96532/ch2.htm

诊断案例

Oracle诊断案例-Sql_trace之一
http://www.itpub.net/showthread.php?s=&threadid=220850

Oracle诊断案例-Sql_trace之二
http://www.itpub.net/showthread.php?s=&threadid=226246

Oracle诊断案例-Spfile案例一则
http://www.itpub.net/showthread.php?s=&threadid=211984

Oracle诊断案例-如何捕获问题SQL解决过度CPU消耗问题
http://www.itpub.net/showthread.php?s=&threadid=280190

Oracle诊断案例-如何诊断和解决CPU高度消耗(100%)的数据库问题
http://www.itpub.net/showthread.php?s=&threadid=273418

Oracle诊断案例-SGA与Swap之二
http://www.itpub.net/showthread.php?s=&threadid=215452

Oracle诊断案例-SGA与Swap   
http://www.itpub.net/showthread.php?s=&threadid=213582

ORACLE9.2.0所有官方文档
http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage

ORACLE9.0.1所有官方文档
http://otn.oracle.com/pls/db901/db901.docindex?remark=homepage

ORACLE8。1。7所有官方文档
http://otn.oracle.com/pls/tahiti/tahiti.docindex

DBA

Oracle9i Database Administration Best Practices:
http://otn.oracle.com/products/m ... BestPractices9i.pdf

关于排序、sort_area_size、临时表空间
http://www.itpub.net/showthread.php?s=&threadid=84823

A Beginners Guide to the Oracle Data Dictionary
http://www.dbatoolbox.com/WP2001/beginners/beg1_dict.pdf

Top Ten Mistakes Found in Oracle Systems
http://www.itpub.net/showthread.php?s=&threadid=107263

关于SGA的设置和调整


关于SGA设置的一点总结
http://www.itpub.net/showthread.php?s=&threadid=109787

数据库结构

关于checkpoint
http://www.itpub.net/showthread.php?s=&threadid=91109

关于HWM的一点研究!
http://www.itpub.net/showthread.php?s=&threadid=103134

LMT下表FREELIST的初步探索
http://www.itpub.net/showthread.php?s=&threadid=96041

SQL优化与分析

一次分析的全过程,和大家交流!
http://www.itpub.net/showthread.php?s=&threadid=91642


Rule Based Optimizer is to be Desupported in Oracle10i
http://www.itpub.net/showthread.php?s=&threadid=88905

为什么做过分析后，运行反倒慢了？
http://www.itpub.net/showthread.php?s=&threadid=120144

关于CBO对于执行计划的影响,一个实际分析的过程!
http://www.itpub.net/showthread.php?s=&threadid=126541


MTS配置管理

Configuring Shared Server   
Oracle9i Net Services Administrator's Guide  Release 2 (9.2)
http://otn.oracle.com/docs/produ ... .920/a96580/mts.htm

Configuring Oracle for the Multi-Threaded Server
   
Oracle8i Administrator's Guide Release 2 (8.1.6)
http://download-west.oracle.com/ ... 6/manproc.htm#12009

如何验证起用了多线程服务器   
http://www.itpub.net/showthread.php?s=&threadid=128035