DBA在性能调优或诊断过程中多少会使用一些成品工具,以下列出一些我工作中使用较为频繁的工具:
Programplatformdownload URL
nmonAIX POWERhttp://www.ibm.com/developerworks/wikis/download/attachments/53871937/nmon4aix12e.zip?version=1
nmon Linuxhttp://nmon.sourceforge.net/docs/MPG_nmon_for_Linux_14a_binaries.zip
sarmonSolarishttp://sourceforge.net/projects/sarmon/files/
puttyInterl x86http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe
OS watcherNon Windowshttps://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=REFERENCE&id=301137.1
ProcwatcherNon Windowshttps://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=459694.1
SQLTXPLAINALLhttps://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=TROUBLESHOOTING&id=215187.1
TRCANLZR ALLhttps://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=TROUBLESHOOTING&id=224270.1
STRMMON Non Windowshttps://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=290605.1
Oracle Cluster Verification UtilityALLhttp://www.oracle.com/technetwork/database/clustering/downloads/cvu-download-homepage-099973.html
Oracle Cluster Health Monitor (CHM) Linux and Windowshttp://www.oracle.com/technetwork/database/clustering/downloads/ipd-download-homepage-087212.html
RDA 4ALLhttps://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=DIAGNOSTIC%20TOOLS&id=250262.1
Latest OpatchALLhttps://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=BULLETIN&id=224346.1
RAC Diagnostic Information (racdiag.sql)ALLhttp://www.oracledatabase12g.com/archives/script-to-collect-rac-diagnostic-information-racdiag-sql.html
ass.awk ALLhttp://www.oracledatabase12g.com/archives/oracle-systemstate-dump-analytic-tool-ass-awk-v1-09.html
LTOM ALLhttps://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=DIAGNOSTIC%20TOOLS&id=352363.1
今后还会不断更新!