Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
라이브 도움말 보기
등록 완료
로그인
가격 산정 요청
영업 담당자에게 문의
제품 번들을 선택했습니다. 귀하의 요청에 더 적합한 서비스를 제공해 드릴 수 있도록 개별 제품을 선택해 주십시오. *
지금은 채팅에 회신할 수 있는 기술 지원 엔지니어가 없습니다. 즉각적인 서비스를 받으려면 당사의 서비스 요청 양식을 사용하여 요청을 제출하십시오.
다음 문서의 설명에 따라 문제를 해결할 수 있습니다.
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
계열사 지원 사이트에서 Quest *제품*에 대한 온라인 지원 도움말을 볼 수 있습니다. 올바른 *제품* 지원 콘텐츠 및 지원에 연결하려면 계속을 클릭하십시오.
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을 계속 사용할 경우 당사가 제공하는 뛰어난 셀프서비스 기능 모두를 최대한으로 활용하실 수 없습니다.