Service graphs

daily graph weekly graph
monthly graph yearly graph

Graph Information

Oracle Wait Events Concurrency

Field Internal name Type Warn Crit Info
Cube Build Master Wait for Jobs Cube_Build_Master_Wait_for_Jobs derive      
IM buffer busy IM_buffer_busy derive      
IM buffer busy SHR IM_buffer_busy_SHR derive      
IM buffer busy TXN IM_buffer_busy_TXN derive      
Inmemory Populate: get loadscn Inmemory_Populate__get_loadscn derive      
LCK0 row cache object free LCK0_row_cache_object_free derive      
REPL Apply: dependency REPL_Apply__dependency derive      
SecureFile mutex SecureFile_mutex derive      
Shared IO Pool Memory Shared_IO_Pool_Memory derive      
Unpin a recreatable chunk Unpin_a_recreatable_chunk derive      
buffer busy waits buffer_busy_waits derive      
cursor: mutex S cursor__mutex_S derive      
cursor: mutex X cursor__mutex_X derive      
cursor: pin S cursor__pin_S derive      
cursor: pin S wait on X cursor__pin_S_wait_on_X derive      
cursor: pin X cursor__pin_X derive      
db flash cache invalidate wait db_flash_cache_invalidate_wait derive      
enq: BE - Critical Block Allocation enq__BE___Critical_Block_Allocation derive      
enq: CB - role operation enq__CB___role_operation derive      
enq: HV - contention enq__HV___contention derive      
enq: IV - cross instance invalidation enq__IV___cross_instance_invalidation derive      
enq: KV - IMA key vector access enq__KV___IMA_key_vector_access derive      
enq: RI - Reader Farm SQL Isolation enq__RI___Reader_Farm_SQL_Isolation derive      
enq: TG - IMCDT global resource enq__TG___IMCDT_global_resource derive      
enq: TI - IMCDT object HT enq__TI___IMCDT_object_HT derive      
enq: TX - index contention enq__TX___index_contention derive      
enq: WG - lock fso enq__WG___lock_fso derive      
latch: In memory undo latch latch__In_memory_undo_latch derive      
latch: MGA asr alloc latch latch__MGA_asr_alloc_latch derive      
latch: MGA heap latch latch__MGA_heap_latch derive      
latch: MGA pid alloc latch latch__MGA_pid_alloc_latch derive      
latch: MGA shared context latch latch__MGA_shared_context_latch derive      
latch: MGA shared context root latch latch__MGA_shared_context_root_latch derive      
latch: MQL Tracking Latch latch__MQL_Tracking_Latch derive      
latch: Undo Hint Latch latch__Undo_Hint_Latch derive      
latch: cache buffers chains latch__cache_buffers_chains derive      
latch: row cache objects latch__row_cache_objects derive      
latch: shared pool latch__shared_pool derive      
libcache interrupt action by LCK libcache_interrupt_action_by_LCK derive      
library cache load lock library_cache_load_lock derive      
library cache lock library_cache_lock derive      
library cache pin library_cache_pin derive      
library cache: bucket mutex X library_cache__bucket_mutex_X derive      
library cache: dependency mutex X library_cache__dependency_mutex_X derive      
library cache: mutex S library_cache__mutex_S derive      
library cache: mutex X library_cache__mutex_X derive      
log file sync: SCN ordering log_file_sync__SCN_ordering derive      
logout restrictor logout_restrictor derive      
pipe put pipe_put derive      
resmgr:internal state change resmgr_internal_state_change derive      
resmgr:sessions to exit resmgr_sessions_to_exit derive      
result cache lock wait result_cache_lock_wait derive      
row cache lock row_cache_lock derive      
row cache mutex row_cache_mutex derive      
row cache read row_cache_read derive      
securefile chain update securefile_chain_update derive