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

Home -> Community -> Mailing Lists -> Oracle-L -> "CHILDREN" in lib cache dump

"CHILDREN" in lib cache dump

From: Rahul <rahul_at_ratelindo.co.id>
Date: Mon, 31 Jul 2000 12:11:00 +0700
Message-Id: <10574.113335@fatcity.com>


List,
i did a lib cache dump to examine the latch contention.. i can see all the objects latched by a particular latch by looking at 'latch=' line..
almost every handle entry also has "CHILDREN" paragraph which i do not understant...
could anyone explain the output of lib cache dump ??

a sample entry looks like this...


  1. library object handle = address of the object handle in hex..
  2. name = library object... sql or some object name
  3. hash = why this hash number is in hex ???
  4. flags = RON/TIM/PN0/[10010000] ???
  5. kk-dd-aa-l l= 00-01-00-01 lock=N ???
  6. lwt, ltm, pwt, ptm, ref ???
  7. library object = hex address , why different from lib object handle (1) ??
  8. CHILDREN : size 16 ???
  9. child#, table, reference, handle
Received on Mon Jul 31 2000 - 00:11:00 CDT

Original text of this message

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