暂时无法在支持网站上提交享有定期维护的产品表单。 如果您需要我们立即提供帮助,请与技术支持部门联系。 对于由此给您带来的不便,我们深表歉意。
获得即时帮助
完成注册
登录
请求定价
联系销售人员
您已选择一个产品捆绑包。 您能否选择单个产品以便我们更好地满足您的请求。 *
技术支持工程师目前正忙,无法回应您的消息。 如果需要即时服务,请通过我们的服务请求表提交请求。
以下文章可根据您的描述解决您的问题。
The Latches Activity collection collects latches activity-related data.
Oracle
Realtime Collection
20
Online
60
Offline
300
Cache Buffer Chain Latch
This latch is acquired whenever a block in the buffer cache is accessed (pinned)
Cache Buffer LRU Chain Latch
This latch is acquired in order to introduce a new block into the buffer cache and when writing a buffer back to disk, specifically when trying to scan the LRU chain that contains all of the dirty blocks in the buffer cache
Latch Free Waits
Number of waits for a latch that is currently busy (held by another process)
Library Cache Latch
This latch is acquired in order to add a new statement to the library cache. During a parse, Oracle searches the library cache for a matching statement. If one is not found, then Oracle will parse the SQL statement, obtain the library cache latch and insert the new SQL.
Library Cache Pin Latch
This latch is acquired when a statement in the library cache is re-executed
Redo Allocation Latch
This latch is acquired in order to allocate space within the redo log buffer. There is one redo allocation latch per instance.
Redo Copy Latch
This latch is acquired in order to write redo records into the redo log buffer. There may be up to LOG_SIMULTANEOUS_COPIES allocation latches.
Shared Pool Latch
This Latch is acquired when allocating and freeing memory in the shared pool
Total Active Time
Total amount of time waited for the event (in seconds)
The Locks Activity collection provides locks activity-related data.
Average Lock Duration
The average time (in milliseconds) that a resource was locked (held in contention).
High values of lock duration may indicate aggressive lock incidence which may be improved through tuning.
The metric is calculated as follows:
100 * (Lock Wait)
Enqueue Waits
The total number of times an enqueue request or conversion resulted in a wait.
Enqueue Waits Ratio
The percentage of enqueue wait events (waits resulting from enqueue requests or conversions) within the total time consumed by enqueue operations.
Gets
The total number of enqueue requests or enqueue conversions for this type of enqueue.
Gets Pct
The percentage of lock requests of this type within the total number of lock requests
Lock Efficiency
The percentage of lock requests that did not escalate to a blocking lock.
Lock Name
The name of the lock.
Lock Wait
The total amount of time spent waiting for the enqueue or enqueue conversion.
Waits Pct
The percentage of waits for this type of lock, of all the locks.
The Locks Breakdown collection provides lock requests and wait information, including the percentage of time spent on locks of the following types: system, TX, TM, User-defined.
PDB
In multitenant architectures, the name of the pluggable database.
System Locks Percentage
The percentage of time the sessions spent waiting on System locks, out of the entire time spent waiting on locks.
System Locks Wait Time
The percentage of time the sessions spent waiting on System locks.
TM Locks Wait Time
The amount of time the sessions spent waiting on TM locks.
TM Percentage
The percentage of time the sessions spent waiting on TM locks, out of the entire time spent waiting on locks.
Total Lock Wait
The total time the sessions spent waiting on locks.
TX Locks Wait Time
The amount of time the sessions spent waiting on TX locks.
TX Percentage
The percentage of time the sessions spent waiting on TX locks, out of the entire time spent waiting on locks.
UL Locks Wait Time
The amount of time the sessions spent waiting on user-defined lock types.
UL Percentage
The percentage of time the sessions spent waiting on user-defined locks, out of the entire time spent waiting on locks.
The Locks Instance collection provides summarized lock requests and application efficiency information.
Balance Enqueue Waits
The extent, in percents, to which enqueue wait events are balanced across RAC nodes
Balance Lock Efficiency
The extent, in percents, to which lock efficiency is balanced across RAC nodes
Balance Lock Wait
The extent, in percents, to which lock wait events are balanced across RAC nodes
Total number of waits on enqueues
The percentage of total locks waits within the total lock requests
您可以在附属支持站点上查找适用于戴尔*产品*的在线支持帮助。单击“继续”,转至适用于*产品*的正确支持内容和帮助。
The document was helpful.
选择评级
I easily found the information I needed.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center
Quest Software门户不再支持IE 8、9和10,建议将您的浏览器升级到最新版本的Internet Explorer或Chrome。
要升级到IE 11,请单击此处
要升级到Chrome,请单击此处
如果继续使用IE 8、9和10,您将无法充分利用我们所有出色的自助服务功能。