oratop
A text-based user interface utility using Oracle Call Interface (OCI) API that resembles Unix “top”
utility in appearance. Its data gathering is solely from the database using internal views. The
utility can be run against Real Application Cluster (RAC) or non-RAC databases. It provides a
user the ability to monitor the database in near real time and it is not intended to replace Unix
“top”, EMGC, EM Database Express, or server manageability tools like ASH, AWR, ADDM, etc.,
that provides in-depth and granular details.
oratop v15.0.0
INTRODUCTION............................................................................................................................ 3
VISUAL LAYOUT........................................................................................................................... 3
I. COMMAND LINE MODE............................................................................................................. 4
II. INTERACTIVE MODE................................................................................................................ 6
TECHNICAL DETAILS................................................................................................................... 8
CONCLUSION................................................................................................................................ 8
Abstract
oratop can be used to monitor Oracle databases on any platform but the executable
must run on supported Unix platforms with an Oracle compatible client. To monitor
databases on other platforms like Windows, simply define an alias in tnsnames.ora on
a Unix client and connect to the remote database as you would with sqlplus.
Minimum supported Oracle release is 11gR2. A standalone oratop compatible with 11gR2
and 12cR1 Oracle releases is available in MOS Note (Doc ID 1500864.1). For later Oracle
releases it is available under the folder $ORACLE_HOME/suptools/oratop. Also, it is bundled
with Oracle Trace File Analyzer (TFA).
Release 15.0.0
In addition to some bug fixes, some minor columns name, placement, replacement and new
addition changes mostly in the instance section, section2.
Obsoleted Features: Multitenant’s pluggable database (pdb container level) monitoring and
RAC service-based monitoring. Reason is the limited server stats available to the tool.
Security: Login with visible password on the command line or redirection (FIFO pipe) is no
longer permissible, its allowed only at the prompt (hidden).
评论