共計 3571 個字符，預計需要花費 9 分鐘才能閱讀完成。
這篇文章主要介紹了 oratop 工具怎么用，具有一定借鑒價值，感興趣的朋友可以參考下，希望大家閱讀完這篇文章之后大有收獲，下面讓丸趣 TV 小編帶著大家一起了解一下。
Doc ID 1500864.1
下載即可以使用，不需要特操作
oratop -h
登錄
./oratop -i 5 -b -d / as sysdba
使用交互界面查看幫助
Oratop 源自 MOS 的一篇文章和工具鏈接（oratop – utility for near real-time monitoring of databases, RAC and Single Instance [ID 1500864.1]）。
從名稱上看，Oratop 最大特點是支持實時輕量級監控。在 Oracle 12c 的 EM Express 之前，OEM 還是一個重體積的組件。
相比之下，oratop 完全適合那些想使用數據庫實時監控功能，但是又不愿意啟動 OEM 的用戶需要。
主要功能
監控當前的數據庫活動；
監控數據庫性能；
識別當前阻塞會話和瓶頸
增強功能
SQL 監控
數據庫服務
多租戶
ADG
共四部分
1、全局數據庫信息
2、數據庫實例活動
3、前五等待事件
4、進程和 SQL 信息
遠程連接
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
動態幫助命令
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:
[N/B]: 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
[m/s]: 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)
每部分參數的意思
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 [c,N]: total user sessions (active/inactive)
us [c,N]: number of distinct users
mt [s,N]: global database memory total (sga+pga)
% db [s,N]: database time as %(dbtime/cpu) (red if 99%)
Section 2 – instance
Top 5 Instance(s) Activity
o Ordered by Database time desc
ID [c,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 [c,N]: active Sessions Waiting, non-ASI (red if ASC+ASI)
AST [c,N]: Active user Sessions Total (ASC+ASI+ASW)
IOPS [m,N]: i/o requests per second
%FR [s,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 [c,m,T]: sql service response time (T/call)
%DBT [s,N]: instance %Database Time (e.g. non-rac shows 100%)
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
E/T [T]: session elapsed time (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)
感謝你能夠認真閱讀完這篇文章，希望丸趣 TV 小編分享的“oratop 工具怎么用”這篇文章對大家有幫助，同時也希望大家多多支持丸趣 TV，關注丸趣 TV 行業資訊頻道，更多相關知識等著你來學習!
