Application and feature description of Oracle tools

I'm reading a Metalink Note (438452.1) mentioned in Tanel Poder about the Performance Tools Quick Reference Guide. This document is indeed quite new. It includes several Oracle tools and is 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.

An Oracle tool similar to decision tree needs to open a Java Virtual Machine during access, so that the access speed is not as high as 22% ). I don't know what kind of users are waiting to use this Oracle 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 experienced users, it is not a lack of Oracle tools, but even if there is performance data, they do not know how to analyze and locate.

Article by: http://database.51cto.com/art/200703/43583.htm