oracle sub share pool简介以及共享sql实现实质(六)
a4178,0x6d6a4178]
LoadLock=0x6d6a41f0[0x6d6a41f0,0x6d6a41f0]
ReferenceList:
Reference: Address=0x6add29a0 Handle=0x7d188328 Flags=CHL[02]
LibraryObject: Address=0x6af290b0 HeapMask=0000-0001-0001-0000 Flags=EXS[0000] Flags2=[0000] PublicFlags=[0000]
Dependencies: count='2' size='16' table='0x6af29ee8'
Dependency: num='0'
Reference=0x6af29668 Position=0 Flags=DEP[0001]
Handle=0x6d688488 Type=NONE(255) Parent=SCOTT
Dependency: num='1'
Reference=0x6af29708 Position=14 Flags=DEP[0001]
Handle=0x6d7a1388 Type=TABLE(02) Parent=SCOTT.EMP
ReadOnlyDependencies: count='1' size='16'
ReadDependency: num='0' Table=0x6af29f80 Reference=0x6af29568 Handle=0x6d687200 Flags=DEP/ROD/KPP[61]
Accesses: count='1' size='16'
Dependency: num='1' Type=0009
Translations: count='1' size='16'
Translation: num='0' Original=0x6d7a1388 Final=0x6d7a1388
DataBlocks:
Block: #='0' name=KGLH0^680d47a7 pins=0 Change=NONE
Heap=0x6d797f20 Pointer=0x6af29150 Extent=0x6af29030 Flags=I/-/-/A/-/-
FreedLocation=0 Alloc=2.421875 Size=3.937500 LoadTime=4294571240
Block: #='6' name=SQLA^680d47a7 pins=0 Change=NONE
Heap=0x6add2770 Pointer=0x6b0bcbd0 Extent=0x6b0bbf90 Flags=I/-/-/A/-/E
FreedLocation=0 Alloc=9.132812 Size=11.859375 LoadTime=0
NamespaceDump:
Child Cursor: Heap0=0x6af29150 Heap6=0x6b0bcbd0 Heap0 Load Time=10-22-2013 00:17:48 Heap6 Load Time=10-22-2013 00:17:48
Child: childNum='1'
LibraryHandle: Address=0x6d5f4820 Hash=0 LockMode=0 PinMode=0 LoadLockMode=0 Status=VALD
Name: Namespace=SQL AREA(00) Type=CURSOR(00)
Statistics: InvalidationCount=0 ExecutionCount=1 LoadCount=2 ActiveLocks=0 TotalLockCount=3 TotalPinCount=5
Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0
Concurrency: DependencyMutex=0x6d5f48d0(0, 1, 0, 0) Mutex=0x7d188468(1, 126, 0, 6)
Flags=RON/PIN/PN0/EXP/CHD/[10012111]
WaitersLists:
Lock=0x6d5f48b0[0x6d5f48b0,0x6d5f48b0]
Pin=0x6d5f4890[0x6d5f4890,0x6d5f4890]
LoadLock=0x6d5f4908[0x6d5f4908,0x6d5f4908]
ReferenceList:
Reference: Address=0x6add2ce8 Handle=0x7d188328 Flags=CHL[02]
LibraryObject: Address=0x6cf1d0b0 HeapMask=0000-0001-0001-0000 Flags=EXS[0000] Flags2=[0000] PublicFlags=[0000]
Dependencies: count='2' size='16' table='0x6cf1dee8'
Dependency: num='0'
Reference=0x6cf1d668 Position=0 Flags=DEP[0001]
Handle=0x6d7f37d0 Type=NONE(255) Parent=RHYS
Dependency: num='1'
Reference=0x6cf1d708 Position=14 Flags=DEP[0001]
Handle=0x6d688bb8 Type=TABLE(02) Parent=RHYS.EMP
ReadOnlyDependencies: count='1' size='16'
ReadDependency: num='0' Table=0x6cf1df80 Reference=0x6cf1d568 Handle=0x6d7b9910 Flags=DE