团队执行官
E.S.T核心成员 社区主管
整理一个链接列表，分专题的，这样大家遇到问题有个快速的入口，并且有丰富的链接!不断的维护，这样慢慢的就可以丰富起来!大家跟帖，要求提出一个专题和至少一个连接，然后由斑竹负责整理！不知大家意下如何!
查看详细资料
TOP
Statspack相关文档: 关于Statspack，以下是我收集的一些连接otn文档:http://otn.oracle.com/deploy/perfor...f/statspack.pdf http://otn.oracle.com/deploy/perfor...NG_dialeris.pdf 采用Statspack进行高级调优http://www.oracle.com/global/cn/ora...?o13expert.htmlhttp://otn.oracle.com/deploy/perfor...ing_otn_new.pdf Installing and Running Statspack(for 8.0 8.1.5的扩展版本)http://www.oracle.com/oramag/oracle...pack-other.htmlDiagnosing Performance with Statspack:http://www.oracle.com/oramag/oracle/00-Mar/o20tun.htmlAdvanced Tuning with Statspack http://otn.oracle.com/oramag/oracle.../o13expert.htmlItpub精华: STATSPACK,刚刚解决的一个问题,请大家注意!http://www.itpub.net/showthread.php?s=&threadid=72037StatsPack在数据库优化中的使用http://www.itpub.net/showthread.php?s=&threadid=73500Metalink文档(需要metalink帐号访问): FAQ- Statspack Complete Referencehttp://metalink.oracle.com/metalink...OT&p_id=94224.1What is StatsPack and where are the READMEs?http://metalink.oracle.com/metalink...database_id=NOTInstalling and Configuring StatsPack Package http://metalink.oracle.com/metalink...database_id=NOTCreating a StatsPack performance reporthttp://metalink.oracle.com/metalink...database_id=NOTOthers whitepaper: http://www.osborne.com/products/007...133783_ch15.pdfhttp://www.dbatoolbox.com/WP2002_06/statspack_01.pdf http://my.oraperf.com/download/yapp_anjo_kolk.pdfstatspack分析实例Statspack专题http://www.eygle.com/statspack/statspack_list.htm求助 oracle 吃cpuhttp://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=106156db file scattered read-DB文件分散读取http://www.eygle.com/statspack/statspack12.htm
Oracle等待事件 Oracle Wait Analysis Techniques http://www.dbazine.com/burleson8.html"log file sync" 等待事件 http://www.eygle.com/statspack/stat...LogFileSync.htmEnqueue http://www.eygle.com/statspack/statspack13.htmFAQ ORACLE技术问题专家问答五则 http://www.tongyi.net/article/20011...111182617.shtmlOracle Internal How to simulate block corruption with BBED? http://www.itpub.net/showthread.php?s=&threadid=422260How to repair corruption block use BBED? http://www.eygle.com/archives/2005/..._with_bbed.html读ORACLE脱机文件 http://www.itpub.net/showthread.php?s=&threadid=350018Oracle10g Release 2 New Feature Oracle 10g Release 2 new tools:asmcmd http://www.itpub.net/showthread.php?s=&threadid=420217Oracle 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.Ora...Veritas.EMC.htmP4上安装oracle8i的解决方法http://www.itpub.net/showthread.php...%BE%B3%FDoraclewindows上彻底删除oracle的方法http://www.itpub.net/showthread.php...%BE%B3%FDoracleORACLE8.17在RH7.x/RH8上的安装http://www.itpub.net/showthread.php...cle%B0%B2%D7%B0Oracle，HA在Unix上双机环境的安装指南http://www.itpub.net/showthread.php...cle%B0%B2%D7%B0Oracle 9i 在Red Hat Linux 7.3下的安装 http://www.itpub.net/showthread.php...cle%B0%B2%D7%B0redhat7.2下安装oracle9i文档http://www.itpub.net/showthread.php...cle%B0%B2%D7%B0在Solaris8 for x86上安装Oracle8.1.7手册http://www.itpub.net/showthread.php...cle%B0%B2%D7%B0
性能调整 Database Performance Tuning on AIX http://www.redbooks.ibm.com/pubs/pd...ks/sg245511.pdfOracle Expert Tuning Secrets to reduce disk I/O http://www.dbazine.com/burleson6.htmlMonitoring and Improving Application Performance http://otn.oracle.com/docs/products.../a96532/ch2.htm诊断案例 Oracle诊断案例-Sql_trace之一 http://www.eviloctal.com/forum/read.php?tid=19463&fpage=1Oracle诊断案例-Sql_trace之二 http://www.eviloctal.com/forum/read.php?tid=19464&fpage=1
Oracle诊断案例-Spfile案例一则 http://www.eviloctal.com/forum/read.php?tid=19470&fpage=1
Oracle诊断案例-如何捕获问题SQL解决过度CPU消耗问题 http://www.eviloctal.com/forum/read.php?tid=19461&fpage=1
Oracle诊断案例-如何诊断和解决CPU高度消耗(100%)的数据库问题http://www.eviloctal.com/forum/read.php?tid=19462&fpage=1Oracle诊断案例-SGA与Swap之二 http://www.eviloctal.com/forum/read.php?tid=19467&fpage=1Oracle诊断案例-SGA与Swap http://www.eviloctal.com/forum/read.php?tid=19469&fpage=1
DBA Oracle9i Database Administration Best Practices: http://otn.oracle.com/products/mana...Practices9i.pdf关于排序、sort_area_size、临时表空间 http://www.itpub.net/showthread.php?s=&threadid=84823A Beginners Guide to the Oracle Data Dictionaryhttp://www.dbatoolbox.com/WP2001/be...s/beg1_dict.pdfTop 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=103134LMT下表FREELIST的初步探索 http://www.itpub.net/showthread.php?s=&threadid=96041
SQL优化与分析 一次分析的全过程,和大家交流! http://www.itpub.net/showthread.php?s=&threadid=91642Rule 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=126541MTS配置管理 Configuring Shared Server Oracle9i Net Services Administrator's Guide Release 2 (9.2)http://otn.oracle.com/docs/products.../a96580/mts.htmConfiguring Oracle for the Multi-Threaded ServerOracle8i Administrator's Guide Release 2 (8.1.6)http://download-west.oracle.com/doc...nproc.htm#12009如何验证起用了多线程服务器 http://www.itpub.net/showthread.php?s=&threadid=128035
备份恢复以及高可用性 数据恢复及高可用性http://www.eygle.com/index-ha.htmOracle数据库的备份方法 http://www.itpub.net/showthread.php?s=&threadid=12023Oracle高级复制冲突解决机制的研究 http://www.itpub.net/388099.htmlOracle高级复制的创建配置步骤-Step by Step http://www.eygle.com/archives/2005/...essoeaeaeo.htmlHow to simulate block corruption with BBED? http://www.itpub.net/422260.html使用Oracle10g新特性,跨越Resetlogs时间点进行恢复 http://www.itpub.net/343876.htmldbms_rectifier_diff解决高级复制中的数据冲突问题的研究 http://www.itpub.net/313807.htmlDataGuard - 利用Cascaded Redo Log Destinations避免WAN稳定性问题 http://www.itpub.net/311731.htmlDataguard配置Step by Step http://www.eygle.com/ha/dataguard-step-by-step.htm站点推荐 Oracle, NT and Linux command reference http://www.SS64.com
Oracle Multi-Threaded Server and Shared Server 14 Configuring Shared ServerOracle9i Net Services Administrator's Guide Release 2 (9.2)http://otn.oracle.com/docs/products.../a96580/mts.htmConfiguring Oracle for the Multi-Threaded ServerOracle8i Administrator's Guide Release 2 (8.1.6)http://download-west.oracle.com/doc...nproc.htm#12009Oracle数据库管理>如何验证起用了多线程服务器？http://www.itpub.net/showthread.php?s=&threadid=128035
存储管理 Oracle9i的自动分段空间管理改善了分段存储的本质 http://www.zdnet.com.cn/developer/t...39107983,00.htmhttp://www.dba-oracle.com/art_builder_assm.htm
Automatic UNDO Internalshttp://www.evdbt.com/AutomaticUndoInternals.pdfCats, Dogs, and ORA-01555http://www.evdbt.com/CatsDogsORA01555.doc
CursorEfficient use of bind variables, cursor_sharing and related cursor ...http://miracleas.dk/tools/Miracle_2_cursor.pdf关于Oracle9i的Peeking of User-Defined Bind Variables http://www.itpub.net/showthread.php?s=&threadid=174952关于cursor open 的时候到底做了些什么 http://www.itpub.net/showthread.php?s=&threadid=197416
