12.oracle的dump理解十二 dump library_cache_object
欢迎转载,转载请标明出处:http://blog.csdn.net/notbaron/article/details/51284578
Dump单独一个库对象,地址是x$kglob.kglhdadr 或者 v$sql.address
随便找一个对象如下:
SQL> select sql_text,address from v$sql whererownum <2;
SQL_TEXT------------------------------------------------ADDRESS
select inst_id,hxfil, decode(hxerr,0,decode(bitand(fhsta, 1), 0,'NOT ACTIVE','A
CTIVE'), 1,'FILE MISSING', 2,'OFFLINENORMAL', 3,'NOT VERIFIED', 4,'FILE NOT FOU
ND', 5,'CANNOT OPEN FILE', 6,'CANNOT READHEADER', 7,'CORRUPT HEADER', 8,'WRONG
FILE TYPE', 9,'WRONG DATABASE', 10,'WRONGFILE NUMBER', 11,'WRONG FILE CREATE',
12,'WRONG FILE CREATE', 16,'DELAYED OPEN','UNKNOWN ERROR'), to_number(fhbsc),
to_date(fhbti,'MM/DD/RRHH24:MI:SS','NLS_CALENDAR=Gregorian'), con_id from x$kcv
fhonl
000007FF034C1000
支持3个等级DUMP。
命令如下:
SQL> oradebug dump library_cache_object 00x000007FF034C1000
得到内容如下:
Processing Oradebug command 'dumplibrary_cache_object 0 0x000007FF034C1000'
LibraryHandle: Address=000007FF034C1000 Hash=2c64004aLockMode=0 PinMode=0 LoadLockMode=0 Status=VALD
ObjectName: Name=selectinst_id,hxfil, decode(hxerr, 0,decode(bitand(fhsta, 1), 0,'NOTACTIVE','ACTIVE'), 1,'FILE MISSING', 2,'OFFLINE NORMAL', 3,'NOT VERIFIED', 4,'FILENOT FOUND', 5,'CANNOT OPEN FILE', 6,'CANNOT READ HEADER', 7,'CORRUPT HEADER',8,'WRONG FILE TYPE', 9,'WRONG DATABASE', 10,'WRONG FILE NUMBER', 11,'WRONG FILECREATE', 12,'WRONG FILE CREATE', 16,'DELAYED OPEN', 'UNKNOWN ERROR'),to_number(fhbsc), to_date(fhbti,'MM/DD/RRHH24:MI:SS','NLS_CALENDAR=Gregorian'), con_id from x$kcvfhonl
FullHashValue=33b1a2229e4e8f3b1d71048b2c64004a Namespace=SQL AREA(00)Type=CURSOR(00) ContainerId=0 ContainerUid=0 Identifier=744751178 OwnerIdn=0
Statistics: InvalidationCount=0ExecutionCount=0 LoadCount=2 ActiveLocks=0 TotalLockCount=1 TotalPinCount=1
Counters: BrokenCount=1RevocablePointer=1 KeepDependency=1 Version=0 BucketInUse=0 HandleInUse=0HandleReferenceCount=0
Concurrency: DependencyMutex=000007FF034C10B0(0, 19, 0, 0)Mutex=000007FF034C1148(251, 195, 0, 6)
Flags=RON/PIN/TIM/PN0/DBN/[10012841] Flags2=[0000]
WaitersLists:
Lock=000007FF034C1090[000007FF034C1090,000007FF034C1090]
Pin=000007FF034C1070[000007FF034C1070,000007FF034C1070]
LoadLock=000007FF034C10E8[000007FF034C10E8,000007FF034C10E8]
Timestamp: Current=04-24-201623:00:18
HandleReference: Address=000007FF034C13A0 Handle=0000000000000000 Flags=[00]
LibraryObject: Address=000007FF0433DD08 HeapMask=0000-0001-0001-0000 Flags=EXS[0000]Flags2=[0000] PublicFlags=[0000]
ChildTable: size='16'
Child: id='0'Table=000007FF0433EB88 Reference=000007FF0433E618 Handle=000007FF026E0380
NamespaceDump:
ParentCursor: sql_id=1uw84jcq6802aparent=000007FF0433DDD0 maxchild=1 plk=n ppn=n
该对象相关的信息都可以找到了。