Oracle Database Tools and Utilities

Licensed Tools

• Toad, by Quest Software

http://www.quest.com/toad/

• PL/SQL Developer, by Allround Automations

http://www.allroundautomations.com/plsqldev.html

Free Tools

• Oracle SQL Developer, by Oracle

http://www.oracle.com/technetwork/developer-tools/sql-developer

• Snapper, by Tanel Poder, is a quick and easy ad-hoc performance troubleshooting tool.

http://tech.e2sn.com/oracle-scripts-and-tools/session-snapper

• Hammerora is the open source Oracle load test tool.

http://hammerora.sourceforge.net/

• Swingbenach is a free load generator (and benchmarks) designed to stress test an Oracle database.

http://www.dominicgiles.com/swingbench.html

• ASH Viewer provides a graphical view of active session history data within the Oracle instance (versions supported: 8i/9i/10g/11g).

http://sourceforge.net/projects/ashv/

• Mumbai is a freeware Windows application targeted at Oracle DBAs and consultants, with a special focus on performance analysis.

http://marcusmonnig.wordpress.com/mumbai/

• Oracle ORION, by Oracle, is a standalone tool for calibration the I/O performance for storage systems.

http://www.oracle.com/technetwork/topics/index-089595.html

• Many scripts from oracle-developer.net including MOATS - tuning and diagnostics utility.

http://www.oracle-developer.net/utilities.php

• ASM Metrics

http://bdrouvot.wordpress.com/2013/10/04/asm-metrics-are-a-gold-mine-welcome-to-asm_metrics-pl-a-new-utility-to-extract-and-to-manipulate-them-in-real-time/

• oratop - Utility for Near Real-time Monitoring of Databases, RAC and Single Instance

MOS ID 1500864.1

• SQLT (SQLTXPLAIN) - Tool that helps to diagnose a SQL statement performing poorly or one that produces wrong results

MOS ID 215187.1

• RACcheck - RAC Configuration Audit Tool (Doc ID 1268927.1)

See Also

• http://wiki.oracle.com/page/Database+Benchmarking