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