Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> OMLET 4.2: Added Wait statistics -- http://www.omlet.org

OMLET 4.2: Added Wait statistics -- http://www.omlet.org

From: omlet v4 <teraknowledgesystems_at_yahoo.com>
Date: 17 Nov 2004 04:08:20 -0800
Message-ID: <fc85c159.0411170408.10a3d113@posting.google.com>

OMLET 4.2 now tracks nested waits, i.e if a wait for one event
involves a wait for another event, using ksubst, ksuest, kslwtb,
kslwte kernel modules and x$ksled, x$ksles, x$kslei, and x$traces.

Simply add
_trace_buffers_per_process = 1, _trace_enabled = true to init.ora and bounce your instance.

Events tracked:

Kernel module: Event

misc.        : Null event 
misc.        : secondary event (event #, wait time)
kgl          : library cache pin (handle address, pin address,
10*mode+namespace)
kgl          : library cache lock (handle address, lock address,
10*mode+namespace)
kgl          : library cache load lock (object address, lock address,
10*mask+namespace)
psdknl       : PL/SQL lock timer (duration)
sgadef       : single-task message
sgadef       : SQL*Net message to client (driver id, #bytes)
sgadef       : SQL*Net message more data to client (driver id, #bytes)
sgadef       : SQL*Net message from client (driver id, #bytes)
sgadef       : SQL*Net message more data from client (driver id,

#bytes)
sgadef : SQL*Net message break/reset to client (driver id, break?) sgadef : SQL*Net message to dblink (driver id, #bytes) sgadef : SQL*Net message more data to dblink (driver id, #bytes) sgadef : SQL*Net message from dblink (driver id, #bytes) sgadef : SQL*Net message more data from dblink (driver id,
#bytes)
sgadef : SQL*Net message break/reset to dblink (driver id, break?) k2i : pending global transaction(s) (scans) k2i : free global transaction table entry (tries) kcb : free buffer waits (file#, block#, set-id#) kcb : checkpoint completed kcb : buffer for checkpoint (buffer#, dba, state*10+mode) kcb : buffer deadlock (dba, class*10+mode, flag) kcb : buffer latch (latch addr, chain#) kcb : write complete waits (file#, block#, id) kcb : buffer read retry (file#, block#) kcb : buffer busy waits (file#, block#, id) kcb : SCAFS flush buffer kcbl : direct access I/O (descriptor address, first dba, block cnt) kcbl : queue wait kcc : control file sequential read (file#, block#, blocks) kcc : control file single write (file#, block#, blocks) kcc : control file parallel write (files, blocks, requests) kcf : DFS db file lock (file#) kcf : conversion file read (file#, block#, blocks) kcf : db file sequential read (file#, block#, blocks) kcf : db file scattered read (file#, block#, blocks) kcf : db file single write (file#, block#, blocks) kcf : db file parallel write (files, blocks, requests) kcl : kcl bg acks (count, loops) kcl : lock element waits (file#, block#, lenum) kcl : lock element cleanup (file#, block#, lenum) kcm : batched allocate scn lock request kcm : batched allocate scn request kcrf : log file sequential read (log#, block#, blocks) kcrf : log file single write (log#, block#, blocks) kcrf : log file parallel write (files, blocks, requests) kcrfh : log file space/switch kcrfh : log file sync (buffer#) kcrr : log switch/archive (thread#) kdc : dupl. cluster key (dba) kdis : index block split (rootdba, level, childdba) kkm : inactive mid (mid, immediate, active) kkxp : pipe get (handle address, buffer length, timeout) kkxp : pipe put (handle address, record length, timeout) kmc : virtual circuit status (circuit#, status) kmd : dispatcher timer (sleep time) kmmcts : dispatcher shutdown (waited) kqr : row cache lock (cache id, mode, request) ksa : rdbms ipc message block ksa : rdbms ipc reply (from_process, timeout) ksa : rdbms ipc message (timeout) ksb : process startup (type, process#, waited) ksdx : debugger command ksicts : DFS lock request cancellation (options) ksicts : DFS lock release (options) ksicts : DFS lock convert (mode, options) ksicts : DFS lock acquisition (type|mode, id1, id2) ksicts : DFS lock handle (type|mode, id1, id2) ksl : latch activity (address, number, process#) ksl : latch free (address, number, tries) ksq : enqueue (name|mode, id1, id2) ksq : DFS enqueue lock acquisition (name|mode, id1, id2) ksq : DFS enqueue lock handle (name|mode, id1, id2) ksq : DFS enqueue request cancellation (name|mode, id1, id2) kst : trace writer flush kst : trace writer I/O kst : trace unfreeze kst : trace continue (delay time) ksu : free process state object ksu : pmon timer ksu : inactive session (session#, waited) ktccts : transaction (undo seg#|slot#, wrap#, count) ktm : instance recovery (undo segment#) ktm : instance state change (layer, value, waited) ktm : smon timer (sleep time, failed) ktucts : undo segment recovery (segment#, tx flags) ktucts : undo segment extension (segment#) ktucts : undo segment tx slot (segment#) kxfp : parallel query qref latch (function, sleeptime, qref) kxfp : parallel query dequeue wait (reason, sleeptime, passes) kxfp : parallel query server shutdown (nalive, sleeptime, loop) kxfp : parallel query create server (nservers, sleeptime, enqueue) kxfp : parallel query signal server (serial, error, nbusy) swake : WMON goes to sleep sksa : timer in sksawat scg : scginq AST call
Received on Wed Nov 17 2004 - 06:08:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US