Difference between revisions of "Oracle Database Tools and Utilities"
Jump to navigation
Jump to search
(Created page with " * 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/ * Mu...") |
|||
(11 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | == Licensed Tools == | ||
+ | * '''Toad''', by Quest Software | ||
+ | http://www.quest.com/toad/ | ||
− | * ASH Viewer provides a graphical view of active session history data within the Oracle instance (versions supported: 8i/9i/10g/11g). | + | * '''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/ | http://sourceforge.net/projects/ashv/ | ||
− | * Mumbai | + | * '''Mumbai''' is a freeware Windows application targeted at Oracle DBAs and consultants, with a special focus on performance analysis. |
http://marcusmonnig.wordpress.com/mumbai/ | 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 | ||
[[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)