Difference between revisions of "Oracle Database Tools and Utilities"
Jump to navigation
Jump to search
(6 intermediate revisions by the same user not shown) | |||
Line 28: | Line 28: | ||
http://www.oracle.com/technetwork/topics/index-089595.html | http://www.oracle.com/technetwork/topics/index-089595.html | ||
− | * '''Many scripts from oracle-developer.net''' including MOATS | + | * '''Many scripts from oracle-developer.net''' including MOATS - tuning and diagnostics utility. |
http://www.oracle-developer.net/utilities.php | 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 == | == 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)