Difference between revisions of "Oracle Database Tools and Utilities"
Jump to navigation
Jump to search
(One intermediate revision by the same user not shown) | |||
Line 35: | Line 35: | ||
* '''oratop''' - Utility for Near Real-time Monitoring of Databases, RAC and Single Instance | * '''oratop''' - Utility for Near Real-time Monitoring of Databases, RAC and Single Instance | ||
− | MOS 1500864.1 | + | 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 == | == 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
- 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
- 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)