Oracle Database Tools and Utilities

From Ittichai Chammavanijakul's Wiki
(Redirected from Oracle Database Tools)
Jump to: navigation, search

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