惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

AI
AI
TaoSecurity Blog
TaoSecurity Blog
H
Heimdal Security Blog
Help Net Security
Help Net Security
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
Microsoft Azure Blog
Microsoft Azure Blog
www.infosecurity-magazine.com
www.infosecurity-magazine.com
Google DeepMind News
Google DeepMind News
爱范儿
爱范儿
The Cloudflare Blog
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
人人都是产品经理
人人都是产品经理
大猫的无限游戏
大猫的无限游戏
N
News | PayPal Newsroom
V2EX - 技术
V2EX - 技术
博客园 - 【当耐特】
D
Darknet – Hacking Tools, Hacker News & Cyber Security
S
Secure Thoughts
C
CERT Recently Published Vulnerability Notes
罗磊的独立博客
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
P
Privacy & Cybersecurity Law Blog
有赞技术团队
有赞技术团队
S
Schneier on Security
S
SegmentFault 最新的问题
Google Online Security Blog
Google Online Security Blog
H
Hacker News: Front Page
The Last Watchdog
The Last Watchdog
Schneier on Security
Schneier on Security
PCI Perspectives
PCI Perspectives
IT之家
IT之家
Project Zero
Project Zero
博客园 - 司徒正美
P
Privacy International News Feed
Recent Commits to openclaw:main
Recent Commits to openclaw:main
Jina AI
Jina AI
Security Latest
Security Latest
Hacker News - Newest:
Hacker News - Newest: "LLM"
腾讯CDC
C
CXSECURITY Database RSS Feed - CXSecurity.com
阮一峰的网络日志
阮一峰的网络日志
C
Check Point Blog
aimingoo的专栏
aimingoo的专栏
V
Vulnerabilities – Threatpost
W
WeLiveSecurity
NISL@THU
NISL@THU
Webroot Blog
Webroot Blog
N
Netflix TechBlog - Medium
L
Lohrmann on Cybersecurity

博客园 - killkill

jar 冲突、class 冲突的检测脚本 Oracle User Calls 和 Executions 两个概念的区别 使用 dbms_xplan.display 按照 plan_hash_value 查执行计划的方法 [转] sql_id VS hash_value lsattr/chattr [转]节约内存:Instagram的Redis实践 [原]佛山-杭州自驾路书 [原] insert into … on duplicate key update / replace into 多行数据 [摘] python url decoder 一条霸气的分析binlog的命令 一句命令完成MySQL的数据迁移(轻量级) [转]Linux下SSH Session复制 使用taskset命令来限制进程的CPU MySQL重复记录删除 使用Screen抵御杯具 [摘]Oracle 11g Flashback_transaction_query的undo_sql为空? Duplicate Active Database 遇到 ORA-01017 invalid username/password [摘]如何抓住蝴蝶效应中的那只蝴蝶 [原]将Oracle 中的blob导出到文件中
oratop 各个指标项说明
killkill · 2016-02-19 · via 博客园 - killkill

Section 1- oratop and database/instance specifics

   spid       :oratop's server SPID connected to instance,
   SID        :instance name (First 4 letters), 
   clock      :Time of current stats collected (hh24:mi:ss)
   time       :uptime since this instance startup,
   ins        :Total number of active database instance(s),
   MT         :database total memory (sum Memory_Target),
   ses        :Total user's sessions,
   usr        :Total distinct database foreground (F/G) users,
   %DB      :%database Active, 0 0ndicate idle db

Section 2- Cluster-wide "Top 5 instances activity" ordered by Wait Time 
   ID         :instance id,
   %HC        :Host CPU Utilization, %(busy/busy+idle),
   HLD        :Current Host Load,
   MBPS       :throughput, 'I/O Megabytes per Second',
   %FR        :Shared Pool Free %,
   PGAU       :total PGA inuse,
   IORL       :Avg Synchronous Single-Block Read Latency,
   PQS        :PQ Slave Session Count,
   ASC        :Active Sessions on CPU,
   ASI        :Active Sessions waiting on user i/o,
   ASW        :Active Sessions waiting/sleeping,
   AST        :Total Active Sessions,
   ASB        :Active Sessions blocked,
   AAS        :Average Active Sessions,
   CTPS       :(CPS) User Calls Per Sec, OR,                (TPS) User Transactions Per Sec (appears in RED),
   SSRT       :SQl service Response time,
   DBC        :database cpu time ratio,
   DBW        :database wait time ratio.

Section 3- Cluster-wide "Top 5 Timed Events" ordered by Wait Time 
   EVENT      :database wait event,
   WAITS      :cluster average Total waits,
   TIME(s)    :cluster average Total wait time in seconds),
   AVG_MS     ::cluster Average wait time in milliseconds,
   PCT        :Percent of wait time,
   WAIT_CLASS :Name of the wait class corresponding to the event.

Section 4- Session/process none-idle ordered by Wait Time desc.
   ID         :instance id,
   SID        :session id,
   SPID       :server process os pid,
   USR        :user name (abbreviated),
   PROG       :program name (abbreviated),
   PGA        :process pga used,
   OPN        :OPERATION name, e.g. SELECT,
   SQLID      :SQL identifier if no blocker, else,
   /BLOCKR    :final blocking instance:session:ospid,
   E/T        :Elapsed Time since the session has become active. Units: (s)econds, (M)inutes, (h)our, (d)ay.
   STATUS     :ACTIVE | INACTIVE | KILLED | CACHED | SNIPED,
   STE        :Process STATE: ON CPU or USR I/O or WAITING,
   WAIT_EVENT :process wait event name,
   W/T        :Wait Time. Units: (u)-micro second, (m)illi second, (s)econds, (M)inutes, (h)our, (d)ay.