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 |
今后还会不断更新！
Leave a Reply