Difference between revisions of "Oracle Database Tools and Utilities"

From Ittichai Chammavanijakul's Wiki
Jump to navigation Jump to search
 
Line 39: Line 39:
 
* '''SQLT (SQLTXPLAIN)''' - Tool that helps to diagnose a SQL statement performing poorly or one that produces wrong results  
 
* '''SQLT (SQLTXPLAIN)''' - Tool that helps to diagnose a SQL statement performing poorly or one that produces wrong results  
 
MOS ID 215187.1
 
MOS ID 215187.1
 +
 +
* '''RACcheck''' - RAC Configuration Audit Tool (Doc ID 1268927.1)
  
 
== See Also ==
 
== See Also ==
 
* http://wiki.oracle.com/page/Database+Benchmarking
 
* http://wiki.oracle.com/page/Database+Benchmarking
 
[[Category:Oracle_Database]]
 
[[Category:Oracle_Database]]

Latest revision as of 15:39, 9 October 2013

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