Oracle lightweight real-time monitoring tool oratop

Time:2022-5-3

Today, let’s talk about Oracle’s own oratop lightweight real-time monitoring gadget!

As we all know, Oracle’s # most powerful monitoring tool isEM (Enterprise Manager) enterprise manager.This is the most well-known and probably the most exposed monitoring product. However, there are more powerful monitoring tools: emdc, emgc, emdc, EMCC.

  • EMDC:Database Control
  • EMGC:Grid Control
  • EMDC:EM Database Express 12c
  • EMCC:Cloud Control

But today’s protagonists are not these. Each of the above introductions requires a lot of space to describe, installation, uninstall, application and so on. Interested friends can view the official documents and read them by themselves. They will not be discussed here for the time being.

docs.oracle.com -> Database -> Enterprise Manager
https://docs.oracle.com/en/enterprise-manager/index.html
https://docs.oracle.com/en/enterprise-manager/earlier.html

It happens that the company also uses EMCC for backup related work. When you have the opportunity to introduce this knowledge, the screenshot here is as follows:

The topic we want to talk about today is: Oracle lightweight real-time monitoring tool:oratop。

Oratop lightweight real-time monitoring tool does not need to be installed on the monitored database server. As long as there is an Oracle client, it can connect the monitored database in a way similar to sqlplus. Oratop is applicable to 12cr2 – 21C and can be used only by configuring environment variables. However, 11gr2 and 12cr1 need to be installed separately. At least 11gr2 (11.2.0.3, 11.2.0.4) is supported. The oratop tool allows privileged users to monitor Oracle database activity. It runs dynamically almost in real time and provides an active window for the running database.

In my Oracle 19C, you only need to configure environment variables to use it without additional installation.


export ORACLE_SID=JiekeCDB
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/suptools/oratop:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

When using, use oratop -h# to get more help,oratop / as sysdbaDirectly log in to the current host for simple monitoring. Of course, it can also be used as a client for remote monitoring. The methods are as follows:


oratop sys/[email protected]:Prot/service_names as sysdba。

The minimum version supported by Oracle is 11gr2, which is provided in MOS note (DOC ID 1500864.1)
12cr1 is an independent download version of oratop compatible with Oracle version. For Oracle versions after 12cr2, it is located in the folder $oracle_ Home / suptools / oratop. In addition, it is bundled with Oracle trace file analyzer (TFA).

Key initiatives include:

  • Monitoring current database activities,
  • Monitor database performance,
  • Identify contentions and bottlenecks. Identifying contentions and bottleneck

Features highlights

  • Process & SQL monitoring
  • Real time wait events
  • Support ADG monitoring} active data guard support
  • Support for multi tenant database (CDB) (seed level only)

Oratop has now been released and integrated with trace file analyzer collector (TFA) and other tools in the support toolkit. Therefore, the preferred way to get oratop is not to download oratop alone, but to download the latest version of TFA. This way of integration with the latest version of TFA toolkit will be supported at any time. If the GI version is 11.2.0.4 or 12.1.0.2, TFA will be installed automatically. In either case, we suggest that TFA installation is to upgrade from TFA Collector – enhanced diagnostic collection tool (DOC ID 1513912.1) to the latest version, so as to obtain the bundle that the support tool binds to TFA version 12.1.2.3.0 for the first time, as well as various other new features, bug fixes and optimizations. In a word, it means that the gadget oratop is available only after 12.1.2.3.0. However, I also downloaded the 11gr2 version: 11gr2 on Linux x86-64 , oratop RDBMS_ 11.2_ LINUX_ X64, click this link to download https://www.modb.pro/download/39702 Or reply to [oratop] in the background of this official account to obtain the 11gr2 version.

The following is my personal stand-alone 11gr2 environment. Upload this file and simply configure the environment variables. It is simple, convenient and easy to use. You can see that the version is 14.2, which has been updated in 19C, and the version is 15.0.


[[email protected] ~]$ export ORACLE_SID=JiekeXu
[[email protected] ~]$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/suptools/oratop:$PATH
[[email protected] ~]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
[[email protected] ~]$ 
[[email protected] ~]$ ll oratop.RDBMS_11.2_LINUX_X64 
-rwxr-xr-x 1 oracle oinstall 132K Nov 24 03:48 oratop.RDBMS_11.2_LINUX_X64
[[email protected] ~]$ 
[[email protected] ~]$ ./oratop.RDBMS_11.2_LINUX_X64 -h
oratop: Release 14.1.2
Usage: 
  oratop [ [Options] [Logon] ]
 
  Logon:
  {username[/password][@connect_identifier] | / }
  [AS {SYSDBA|SYSOPER}]
 
  connect_identifier:
   o Net Service Name, (TNS) or
   o Easy Connect (host[:port]/[service_name])
  Options:
  -d : real-time (RT) wait events, p 3 (default is Cumulative)
  -k : FILE#:BLOCK#, p 4 lt is (EVENT/LATCH)
  -m : MODULE/ACTION, p 4 (default is USERNAME/PROGRAM)
  -s : SQL mode, p 4 (default is process mode)
  -c : database service mode (default is connect string) 
  -f : detailed format, 132 columns (default: standard, 80 columns)
  -b : batch mode (default is text-based user interface)
  -n : maximum number of iterations (requires number)
  -i : interval delay, requires value in seconds (default: 5s)
  -v : oratop release version number
  -h : this help


[[email protected] ~]$ ./oratop.RDBMS_11.2_LINUX_X64 / as sysdba
 
oratop: Release 14.1.2 Production on Tue Nov 24 04:02:17 2020
Copyright (c) 2011, Oracle. All rights reserved.
 
Connecting ...
Oracle 11g - Jie 04:02:47 up: 59s, 1 ins, 0 sn, 0 us, 644M mt, 2.2% db
ID %CPU LOAD %DCU AAS ASC ASI ASW AST IOPS %FR PGA UTPS UCPS SSRT %DBT
 
EVENT (C)   TOT WAITS TIME(s) AVG_MS PCT WAIT_CLASS
db file sequential read  5305 59 11.3 66 User I/O
DB CPU      14  16  
db file scattered read   418  7 18.9 9 User I/O
log file parallel write  183  4 25.2 5 System I/O
control file heartbeat   1  4 4000.5 4  Other
 
ID SID SPID USR PROG S PGA SQLID/BLOCKER OPN E/T STA STE EVENT/*LA W/T
[[email protected] ~]$

For more information, please refer to the MOS documentation: oratop – utility for near real time monitoring of databases, Rac and single instance (DOC ID 1500864.1), and follow the official account【Java technology fan】Background reply【210330】This document can be obtained together.

Finally, orachk tool is also a very good tool. If you have time to learn and use it together next time, interested partners can check the official documents for more information.

Autonomous Health Framework (AHF) – Including TFA and ORAchk/EXAChk (Doc ID 2550798.1)

Get Proactive with Oracle Database Diagnostic Tools (Doc ID 1459344.1)
Best Practices
Best practices

ORAchk — Take Action
ORAchk replaces the popular RACcheck tool, extending the coverage based on prioritization of top issues reported by users, to proactively scan for known problems including Database area. ORAchk scans and provides a high level report showing your system health risks with the ability to drill down into specific problems and understand their resolutions.

Orachk replaces the popular raccheck tool, expands the coverage based on the priority of the most important issues reported by users, and can actively scan known issues, including database areas. Orachk scans and provides a high-level report showing your system health risks, and has the ability to deeply study specific problems and understand their solutions.

This is the end of this article about Oracle lightweight real-time monitoring tool oratop. For more information about Oracle monitoring tool oratop, please search the previous articles of developeppaer or continue to browse the relevant articles below. I hope you will support developeppaer in the future!