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

推荐订阅源

S
Security Affairs
美团技术团队
量子位
Google DeepMind News
Google DeepMind News
P
Proofpoint News Feed
小众软件
小众软件
Microsoft Azure Blog
Microsoft Azure Blog
Apple Machine Learning Research
Apple Machine Learning Research
MongoDB | Blog
MongoDB | Blog
H
Hackread – Cybersecurity News, Data Breaches, AI and More
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
博客园 - 叶小钗
N
Netflix TechBlog - Medium
大猫的无限游戏
大猫的无限游戏
J
Java Code Geeks
CTFtime.org: upcoming CTF events
CTFtime.org: upcoming CTF events
C
Cyber Attacks, Cyber Crime and Cyber Security
Recent Announcements
Recent Announcements
Cisco Talos Blog
Cisco Talos Blog
L
LangChain Blog
Threat Intelligence Blog | Flashpoint
Threat Intelligence Blog | Flashpoint
博客园 - 三生石上(FineUI控件)
U
Unit 42
T
Tenable Blog
Security Latest
Security Latest
Scott Helme
Scott Helme
B
Blog
C
Cybersecurity and Infrastructure Security Agency CISA
NISL@THU
NISL@THU
L
Lohrmann on Cybersecurity
A
Arctic Wolf
S
Schneier on Security
C
CXSECURITY Database RSS Feed - CXSecurity.com
酷 壳 – CoolShell
酷 壳 – CoolShell
I
Intezer
Know Your Adversary
Know Your Adversary
云风的 BLOG
云风的 BLOG
有赞技术团队
有赞技术团队
雷峰网
雷峰网
The Cloudflare Blog
Cloudbric
Cloudbric
Latest news
Latest news
Project Zero
Project Zero
S
Secure Thoughts
V
Visual Studio Blog
博客园 - Franky
Application and Cybersecurity Blog
Application and Cybersecurity Blog
Exploit-DB.com RSS Feed
Exploit-DB.com RSS Feed
W
WeLiveSecurity

博客园 - 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.