padava+mysql启动失败_Oracle

10g

SELECT t1.ksllasnam "parent_name",

t2.ksllwnam "location"

FROM x$ksllw t2, x$kslwsc t1

WHERE t2.indx = t1.indx

AND ksllasnam like '%library cache%'

parent_name location

-------------------------------------------------- ----------------------------------------------------------------

library cache kqlftc

library cache kqlmbfre: parent

library cache kqlmbpil: parent

library cache kqlmbinv: parent

library cache kqlmbfre: child: in loop

library cache kqlmbfre: child: no obj to free

library cache pin kqlmbpil: child

library cache pin kqlmbpil: child: free and continue

library cache pin kqlmbp: child

library cache pin kqlmbpil: child: post parent after timeout

library cache kgluka: parent

library cache kglScanDependency

library cache kglscn: parent

library cache kglsca: parent

library cache kglLockCursor

library cache kgldrp: child

library cache kgldrx: child

library cache kgldmc: parent

library cache kglhdiv: child

library cache kglivl: parent

library cache kglidp: child

library cache kgldtld: parent

library cache kgldte: parent

library cache kglilf: parent

library cache kglmvsca: parent

library cache kgldte: child 0

library cache kglget: KGLDSBYA

library cache kglget: set reserved lock

library cache kglget: hash collision

library cache kglget: unpin heap 0

library cache kglpin: child: KGLMX

library cache kglupi: child: outside loop

library cache kglkep: child

library cache kglukp: child

library cache kglupc: child

library cache kglgfc: child

library cache kglalt: child

library cache kglupd: child

library cache kglsts: child

library cache kglpur: child

library cache kglprg: child

library cache kglini: child

library cache kglver: child

library cache kglivl: child

library cache kglivr: child

library cache kgldte: child

library cache kglhdbrnl: child

library cache kglobr: child

library cache kglpnc: child

library cache kglati

library cache kglpim

library cache kglupkp

library cache kgllfr

library cache kglnti

library cache kglic

library cache kglpnp: child

library cache kglhfr: child

library cache kglrtl

library cache kglpin

library cache kglswp

library cache kgldti: 2child

library cache kgldtld: 2child

library cache kgl 2child pad56

library cache kgllkal: parent

library cache kglhdal: parent

library cache kglhdunp: parent: flush

library cache kglhdiv0: parent: invalidate

library cache kglhdbr0: parent: invalidate

library cache kgllldl: child:

library cache kglhdbr: child

library cache kgl parent pad2132

library cache kglhdgn: child:

library cache kglhdgc: child:

library cache kglhdgh: child:

library cache kglobpn: child:

library cache kglpndl: child: before processing

library cache kglhdiv0: child

library cache kglpndl: child: after processing

library cache kglobld

library cache kglpin: child: heap processing

library cache kglpnal: 2child

library cache load lock kglllal: llatch

library cache lock kglget: un-set reserved lock

library cache lock kgllkal: child: multiinstance

library cache lock kgllkal: child: in loop

library cache lock kgllkal: child: deadlk det: error

library cache lock kgllkdl: free heap 0

library cache lock kgllkdl: child: cleanup

library cache lock kgllkdl: child: multiinstance

library cache lock kgllkdl: child: no lock handle

library cache lock kgllkc: child

library cache lock kglpsl: child

library cache lock kglhdbrnl: child

library cache lock kglhdcb: child

library cache lock ksucallcbksafely: kqllhng

library cache pin ksucallcbksafely: kqlphng

library cache load lock ksucallcbksafely: kqldlhn

library cache pin kglobld: child:

library cache pin kgllkdl: child: free pin

library cache pin kglpnal: child: alloc space

library cache pin kglpnal: child: check granted

library cache pin kglpndl: child: multiinstance

library cache pin kglpnck

library cache pin kglupc

library cache pin kglpin: child: KGLMS

library cache pin kglupi: child: within loop

library cache pin kgldnp: child

library cache pin kglpnc: child

library cache pin kglpnp: child

library cache pin kglobf0

library cache pin kglpndl

library cache pin dummy

library cache pin kglivl0

library cache hash chains kglpnrel

library cache hash chains kglpnget

library cache hash chains spare

library cache pin allocation kglpnrel

library cache pin allocation kglpnget

library cache pin allocation spare1

library cache pin allocation spare2

library cache lock allocation kgllkrel

library cache lock allocation kgllkget

library cache lock allocation spare1

library cache lock allocation spare2

library cache load lock kglllal: llatch: in loop

library cache load lock kgllldl: llatch

library cache kgl 2child pad2137

library cache kgl 2child pad2138

library cache kksftc

11g

SELECT t1.ksllasnam "parent_name",

t2.ksllwnam "location"

FROM x$ksllw t2, x$kslwsc t1

WHERE t2.indx = t1.indx

AND ksllasnam like '%library cache%'

parent_name location

--------------------------------------- ---------------------------------------------

library cache load lock kglllal: llatch

library cache load lock ksucallcbksafely: kqldlhn

library cache load lock kglllal: llatch: in loop

library cache load lock kglllal: llatch: in loop 2

library cache load lock kgllldl: llatch

latch:

library cache lock

library cache lock allocation

library cache pin

library cache pin allocation

library cache

ALL above latches have gone(latch library cache load lock left), library cache lock/pin don't need acquire library cache any more in 11g ;

library cache lock/pin structure now are protected by Library cache type mutex also.

But We can not find out how kglpin/kgllkdl and else function are utlized with mutex from any V$/X$ dynamic views.

Mutex is more black-box than Latch.

SQL> select mutex_type ,location from v$mutex_sleep_history group by mutex_type,location;

MUTEX_TYPE LOCATION

-------------------------------- ---------------------------------------------

Library Cache kglhdgn2 106

Library Cache kglget1 1

Cursor Pin kksfbc [KKSCHLCREA]

Cursor Parent kksfbc [KKSPRTLOC1]

Library Cache kglrfcl1 79

Library Cache kgllkal1 80

Library Cache kgllkdl1 85

Cursor Pin kkslce [KKSCHLPIN2]

Library Cache kglhdgh1 64

Library Cache kglpin1 4

Library Cache kglpndl1 95

Cursor Pin kksfbc [KKSCHLPIN1]

Library Cache kglhdgn1 62

Library Cache kglpur1 28

Library Cache kglpnal1 90

Library Cache kglobpn1 71

Library Cache kglpnal2 91