Discussion on Oracle Performance Tools

Today we are going to discuss with you the Oracle performance tool. I saw the information about the Oracle performance tool on the relevant website two days ago and thought it was good. I will share it with you. If you are interested, you can click the following articles to view them.

I accidentally saw a Metalink Note (438452.1): Performance Tools Quick Reference Guide mentioned by Tanel Poder. This document is indeed quite new, and there are several tools worth noting.

 
 

  
  
LTOM：The Lite Onboard Monitor  
 
 

Java program, positioned as "real-time Diagnosis Platform ". It has the automatic Session tracking feature. In addition, it has functions such as automatic Hang detection and automatic data collection. This tool should be of great help to small and medium-sized users with less skills in Oracle. However, I am afraid I am not at ease running a Java program on the database for key systems.

 
 

  
  
OPDG：Oracle Performance Diagnostic Guide 
 
 

A tool similar to the decision tree should open a Java Virtual Machine during access, so that the access speed is not as high as my speed (22% will stop ). I don't know what kind of user is waiting for to use this tool.

 
 

  
  
TRCANLZR：Trace Analyzer 
 
 

Format the original SQL Trace data and display it in HTML format.

 
 

  
  
HANGFG ：Hang file generator 
 
 

Used to collect status information when the system Hang is in use. It seems that when there are many Oracle problems, it is still the system Hang :)

In addition to these, STACKX is used to analyze the content of Core files, and OS Watcher, which we all know before, has also made some improvements. This package is basically a traditional Unix performance tool with good Chart display scripts.

It should be said that with the development and opening of more performance-related tools in Oracle, it will be helpful for experienced DBAs. For users who are not experienced enough, they do not lack tools, but do not know how to analyze or locate performance data.

The above content is a description of the Oracle performance tool, hoping to help you in this regard.