Know more about RAC GES STATISTICS

原创

maclean_007 2010-09-08 20:45:15 ©著作权

©著作权归作者所有：来自51CTO博客作者maclean_007的原创作品，请联系作者获取转载授权，否则将追究法律责任

GES 全称为Global Enqueue Services是RAC中重要的全局队列锁服务，V$GES_STATISTICS 动态性能视图汇聚了主要的GES STATISTICS 统计信息。为了更好地理解GES STATISTICS ，我们可以通过下表理解这些统计项的含义：

V$GES_STATISTICS Reference (10.2.0.1.0)

赞

收藏

评论

分享

举报

上一篇：Another ORA-00600 internal error

下一篇：[转帖]如何使用nmap扫描工具

提问和评论都可以，用心的回复会被更多人看到评论

发布评论

全部评论 () 最热最新

相关文章

19C RAC RedHat 8.8

Oracle 19c RAC 安装

oracle

centos7.8搭建Oracle11g RAC

centos7.8搭建Oracle11g RAC

oracle VMware bc

All about IPv6：CDN、PCDN、NAT、IIoT、DNS

IPv6 和 CDN（内容分发网络）IPv6 的引入为 CDN 提供了新的技术优势。随着互联网流量的增长和 IPv4 地址的枯竭，IPv6 在 CDN 中的部署解决了地址短缺问题，同时提升了性能、安全性和可扩展性。IPv6 CDN 是未来互联网发展的重要方向，尤其在支持移动设备和物联网设备上具有重要意义。IPv6 CDN 的关键优势海量地址支持：IPv6 提供了 2¹²⁸ 的地址空间，可以为每个

NAT DNS 地址空间

Know more about RAC statistics and wait event

以下列出了RAC中的主要统计信息和等待事件： 1. Statistics:1.1 V$SYSSTAT, V$SESSTAT (join to V$STATNAME) gc cr blocks served gc cr block build time gc cr block flush time gc cr block send time gc current blo

Oracle event wait RAC statistics

Know more about AWR Parse Statistics

Parse CPU to Parse Elapsed%是一个我们在分析AWR报告时常会看到的解析性能指标，该指标反映了快照内解析CPU时间和总的解析时间的比值(Parse CPU Time/ Parse Elapsed Time)；若该指标水平很低，那么说明在整个解析过程中实际在CPU上运算的时间是很短的，而主要的解析时间都耗费在各种其他非空闲的等待事件上了(如latch:shared po

Oracle SQL cursor AWR Parse

Know more about commit

COMMIT操作是RDBMS中事务结束的标志，在Oracle中与commit紧密相关的是SCN(System Change Number)。引入SCN的最根本目的在于：为读一致性所用为redolog中的记录排序，以及恢复SCN由SCN Base和Scn Wrap组成，是一种6个字节的结构(structure)。其中SCN Base占用4个字节，而SCN wrap占用2个字节。但在

Oracle redo commit ITL Lock锁机制 rollback

Know more about DML

The change vectors as constructed by the transaction layer are used by the cache layer to apply the physical block changes.Redo log ordering and recovery as well as read consistency are the fundamen

oracle kernel redo dml block ITL

Know more about Oracle Latches

Two purposes of latches were:Serialize Execution,Serialize AccessMatch the characteristics with latches and enqueues.Several modes of access

Oracle 数据库 internal latch

Know more about Oracle Nologging

The NOLOGGING clause doesn't prevent redo on all operations, but rather only on a subset. I searched the documentation for examples of this...http://st-doc.us.oracle.com/11/112/server.112/e16541/par

Oracle 数据库 nologging

Know about Oracle RAC Heartbeat

Oracle CRS的心跳主要分为Disk和Network Heartbeat，不同种类的心跳超时会对RAC造成不同的影响。Heartbeat MechanismsDisk Heartbeat ( Voting device ) – IOTNetwork Heartbeat ( across the interconnect ) – misscountMisscount – max ti

heartbeat split CRS brain disktimeout misscount

Know More about Oracle PGA Memory

Question : 1. How can we know available PGA and temporary tablespace before we issue a huge operation?2. Can we estimate PGA and temporary tablespace for a huge operation?3. As we know, the

Oracle pga memory PGA_AGGREGATE_TARGET workarea

Know More About Oracle Row Lock

我们都知道在Oracle中实现了细粒度的行锁row lock，且在ORACLE的内部实现中没有使用基于内存的行锁管理器，row lock是依赖于数据块本身实现的。换句话说判定一行数据究竟有没有没锁住，要求Server Process去pin住相应的block buffer并检查才能够发现。但是试想一个场景，若process A 通过update语句锁定了数据表 Z数据块上的一行数据，并长时间

- row TX lock contention enq:

Know more about Enqueue Deadlock Detection

今天在 ORACLE ALLSTAR群里讨论了一个关于队列锁死锁检测的问题，原帖子在这里。有同学指出对于enqueue lock的死锁检测应当是每3 秒钟检测一次，这样说的依据是通过一个简单可重复的实验可以证明在实际出现ora-00060 dead lock错前process等待了3s: SQL> select * from v$version;BANNER-----

Deadlock lock Detection enqueue _enqueue_deadlock_ti

Know more about shared pool subpool

有同学在T.askmaclean.com上求助Shared Pool里SubPool子分区问题，这里我们来搞清楚_kghdsidx_count 与 subpool 以及subpool中的分区( 实际是duration)的关系： SQL> select * from v$version;BANNER-------------------------------------

Oracle 数据库

Know more about Buffer Cache and Latch

We can examine X$BH table to obtain buffer header information,The BH stands for buffer header.Structures that maintain a list of data buffer headers are called:Hash buckets.Hash buckets are groupe

Oracle buffer cache internal latch

Know more about _in_memory_undo

set parameter _in_memory_undo = FALSE to disable IMUWorkaround: Disable IMU (set _in_memory_undo=FALSE)PLEASE NOTE: This bug applies to single instance databases and not RAC as IMU is not enabl

Oracle 数据库 parameter hidden

Know more about CBO Index Cost

近日偶读Joze Senegacnik(他是一名ACE)在OOW 2011上做的《Getting The Best From The Cost Based Optimizer》Presentation(这里可以下载)，发现他总结的索引Unique Scan和Range Scan成本计算公式总结地很不错，贴出来共享： Index Unique Scan CostINDEX UNI

cbo optimizer range scan cost Oracle索引index

Know More About Libarary Cache and Latches

Stored objects And Transient objects are stored in the library cache, neither Temporary objects nor Permanent objects.The library cache is structured as a Hash table .But Library cache objects are

Oracle 数据库 cache library latch

Know more about Cache Buffer Handle

在之前的文章《latch free:cache buffer handles造成的SQL性能问题》中我介绍了cache buffer handle latch的一些知识，在这里我们复习一下："当会话需要pin住buffer header时它首先要获去buffer handle，得到buffer handle的过程中首先要抢占cache buffer handles栓，为了避免对于cache b

Oracle buffer cache handle kcbrls

Know about RAC Clusterware Process OPROCD

OPROCD introduced in 10.2.0.4 Linux and other Unix platform. Fencing Cluster handling of nodes that should not have access to shared resources STONITH – Power cycle the node PCW – nodes fence th

Oracle 数据库 RAC Clusterware oprocd