12.oracle的dump理解十二 dump library_cache_object

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

该对象相关的信息都可以找到了。