Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to use oratop tools, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Doc ID 1500864.1

Download and use it without special operation

Oratop-h

Log in

. / oratop-I 5-b-d / as sysdba

Use the interactive interface to view help

Oratop comes from an article and tool link from MOS (oratop-utility for near real-time monitoring of databases, RAC and Single Instance [ID 1500864.1]).

In terms of name, the most important feature of Oratop is its support for real-time lightweight monitoring. Before the EM Express of Oracle 12c, OEM was a heavy component.

By contrast, oratop is perfect for users who want to use the database real-time monitoring feature, but are reluctant to start OEM.

Main function

Monitor current database activity

Monitor database performance

Identify current blocking sessions and bottlenecks

Enhanced function

SQL monitoring

Database service

Multi-tenant

ADG

There are four parts

1. Global database information

2. Database instance activity

3. The first five waiting events

4. Process and SQL information

Remote connection

Using Easy Connect (EZConnect)

Non-default port

Oratop system/manager@dbhost:4800/db1.domain.com

Default port (1521):

Oratop system/manager@dbhost/db1.domain.com

Dynamic help command

Interactive Keys: [default]

D: toggle between [Cumulative (C)] & Real-Time (RT) (section 3)

K: toggle between [EVENT/LATCH] & object FILE#:BLOCK# (proc section 4)

M: Toggle between [USERNAME/PROGRAM] & MODULE/ACTION (proc section 4)

S: switch to SQL mode (section 4)

F: toggle between [standard] & detailed format (long)

P: switch to [process] mode (section 4)

T: tablespace information

A: ASM diskgroup information

X: basic SQL plan table (requires sql_id input)

I: refresh interval, requires value in seconds [5s]

Q: quit/ exit program (also, {Q | Esc | function keys})

Abbreviations:

[NCPB]: count (N) / Byte (B)-(k) illo, (M) ega, (G) iga, (T) erra, [PEZY]

[t]: Time-(u) micro, (m) illi, (s) econd, (h) our, (d) ay, (y) ear

[stats interval size]: (M) 1 minute, (s) 15s, else, Real Time

[c]: database service centric

Acronym Help Menu:

Section 1-DATABASE.. [1]

Section 2-INSTANCE.. [2]

Section 3-DB WAIT EVENTS.. [3]

Section 4-PROCESS.. [4]

Quit Help.. (Q | Q)

The meaning of each parameter

Section 1-database

Global Database information

Version: Oracle major version

Db name: db_unique_name

Time [s]: time as of the most recent stats (hh34:mi:ss)

Up [T]: database uptime

Ins [N]: total number of instance (s)

Sn [cMagne N]: total user sessions (active/inactive)

Us [c,N]: number of distinct users

Mt [sMagne]: global database memory total (sga+pga)

% db [dbtime/cpu N]: database time as% (dbtime/cpu) (red if > 99%)

Section 2-instance

Top 5 Instance (s) Activity

O Ordered by Database time desc

ID [cMagne N]: inst_id (instance id)

% CPU [m < N]: host cpu busy% (busy/busy+idle). (red if > 90%)

LOAD [m,N]: current os load. (red if > 2*#cpu & high cpu)

% DCU [m < N]: db cpu otusef as% host cpu. (red if > 99% & high AAS)

AAS [s,N]: Average Active Sessions. (red if > # cpu)

ASC [c,N]: active Sessions on CPU

ASI [c,N]: active Sessions waiting on user I/O

ASW [cMagne N]: active Sessions Waiting, non-ASI (red if > ASC+ASI)

AST [cMagne N]: Active user Sessions Total (ASC+ASI+ASW)

IOPS [m,N]: i/o requests per second

% FR [sQuery N]: shared pool free%

PGA [s,N]: total pga allocated

UTPS [s,N]: user transactions per sec

UCPS [c,m,N]: user calls per sec

SSRT [cmam T]: sql service response time (T/call)

% DBT [s non-rac shows N]: instance% Database Time (e.g.

Section 3-db wait events

Top 5 Timed Events

O Cluster-wide, non-idle

O Ordered by wait time desc

EVENT: wait event name. (red if active)

(C): Cumulative since instance startup

WAITS: total waits

TIME (s): total wait time in seconds)

AVG_MS: average wait time in milliseconds

PCT: percent of wait time (all events)

WAIT_CLASS: name of the wait class

Section 4-process

O Non-Idle processes

O Ordered by event wait time desc

ID [N]: inst_id. (red if blocking)

SID [N]: session identifier. (red if blocking)

SPID [N]: server process os id

USR: user name

PROG: process program name

S: SERVER (dedicated, shared, etc.)

PGA [N]: pga_used_mem. (red if continuously growing)

SQL_ID/BLOCKER: sql_id or the final blocker's (inst:sid, in red)

OPN: operation name, e.g. Select

Session elapsed time T [T]: Emot (active/inactive)

STA: ACTive | INActive | KILled | CAChed | SNIped

STE: process state, e.g. On CPU or user I/O or WAIting

EVENT/*LA: session wait event name. Auto toggle with (* latch name)

(red if process is hung/spin)

W/T [T]: event wait time. (red if > 1s)

Thank you for reading this article carefully. I hope the article "how to use oratop tools" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.