oracleesrst,详解dbms_stats.gather_fixed_objects_stats

exec dbms_stats.gather_fixed_objects_stats;

该gather_fixed_objects_stats存储过程收集的X$基表对象如下&＃xff0c;一般建议在系统高峰时段收集 例如大量session登陆之后&＃xff0c;以保证v$SESSION、V$PROCESS、V$LOCK等常用视图相关的SQL语句执行计划恰当。

select table_name,num_rows,last_analyzed from dba_tab_statistics where last_analyzed is not null order by last_analyzed desc

Table_nameNum_rowsLast_analyzed

X$XS_SESSION_NS_ATTRIBUTES02013/8/16 9:34

X$XS_SESSION_ROLES02013/8/16 9:34

X$XS_SESSIONS02013/8/16 9:34

X$ZASAXTAB02013/8/16 9:34

X$XSOQOPLU02013/8/16 9:34

X$XSOQSEHI02013/8/16 9:34

X$XSOQOJHI02013/8/16 9:34

X$XSOQOPHI02013/8/16 9:34

X$XSSINFO02013/8/16 9:34

X$XPLTON1412013/8/16 9:34

X$XPLTOO1882013/8/16 9:34

X$XML_AUDIT_TRAIL02013/8/16 9:34

X$VINST02013/8/16 9:34

X$XSAWSO162013/8/16 9:34

X$XSAGOP292013/8/16 9:34

X$XSOBJECT02013/8/16 9:34

X$XSLONGOPS02013/8/16 9:34

X$XSOQMEHI02013/8/16 9:34

X$XSAGGR02013/8/16 9:34

X$SKGXPIA02013/8/16 9:34

X$TRACE58102013/8/16 9:34

X$TRACE_EVENTS10002013/8/16 9:34

X$TIMEZONE_NAMES22262013/8/16 9:34

X$TIMEZONE_FILE12013/8/16 9:34

X$VERSION52013/8/16 9:34

X$UNFLUSHED_DEQUEUES02013/8/16 9:34

X$RXS_SESSION_ROLES02013/8/16 9:34

X$UNIFIED_AUDIT_RECORD_FORMAT932013/8/16 9:34

X$TEMPORARY_LOB_REFCNT82013/8/16 9:34

X$UGANCO02013/8/16 9:34

X$RULE_SET12013/8/16 9:34

X$TARGETRBA12013/8/16 9:34

X$QUIESCE12013/8/16 9:34

X$QKSMMWDS12092013/8/16 9:34

X$QKSHT3142013/8/16 9:34

X$QKSXA_REASON3532013/8/16 9:34

X$RULE12013/8/16 9:34

X$RFMP12013/8/16 9:34

X$RFMTE02013/8/16 9:34

X$RFAHIST02013/8/16 9:34

X$RFAFO02013/8/16 9:34

X$RO_USER_ACCOUNT02013/8/16 9:34

X$QKSCESYS4152013/8/16 9:34

X$QKSCESES211652013/8/16 9:34

X$QKSBGSYS8842013/8/16 9:34

X$QKSBGSES450842013/8/16 9:34

X$QKSCR_RSN02013/8/16 9:34

X$QKSFMPRT10012013/8/16 9:34

X$QKSFMDEP9962013/8/16 9:34

X$QKSCR02013/8/16 9:34

X$QKSFM9962013/8/16 9:34

X$PROPS382013/8/16 9:34

X$POLICY_HISTORY02013/8/16 9:34

X$OPTIM_CALIB_STATS252013/8/16 9:34

X$ORAFN1882013/8/16 9:34

X$PRMSLTYX262013/8/16 9:34

X$PERSISTENT_PUBLISHERS02013/8/16 9:34

X$OPVERSION10082013/8/16 9:34

X$QERFXTST102013/8/16 9:34

X$PERSISTENT_QUEUES02013/8/16 9:34

X$PERSISTENT_SUBSCRIBERS02013/8/16 9:34

X$OPTION822013/8/16 9:34

X$OFS_STATS02013/8/16 9:34

X$OFS_RW_LATENCY_STATS02013/8/16 9:34

X$OBJECT_POLICY_STATISTICS02013/8/16 9:34

X$OFSMOUNT02013/8/16 9:34

X$OPARG5892013/8/16 9:34

X$NSV02013/8/16 9:34

X$OPERATORS10082013/8/16 9:34

X$OPDESC10082013/8/16 9:34

X$OCT2422013/8/16 9:34

X$MESSAGES4162013/8/16 9:34

X$NLS_PARAMETERS202013/8/16 9:34

X$MODACT_LENGTH12013/8/16 9:34

X$MUTEX_SLEEP_HISTORY772013/8/16 9:34

X$MUTEX_SLEEP142013/8/16 9:34

X$MSGBM02013/8/16 9:34

X$NONDURSUB02013/8/16 9:34

X$NONDURSUB_LWM02013/8/16 9:34

X$NFSCLIENTS02013/8/16 9:34

X$NFSOPENS02013/8/16 9:34

X$NFSLOCKS02013/8/16 9:34

X$MESSAGE_CACHE02013/8/16 9:34

X$LOGMNR_TAB$02013/8/16 9:34

X$LOGMNR_TS$02013/8/16 9:34

X$LOGMNR_USER$02013/8/16 9:34

X$LOGMNR_TABPART$02013/8/16 9:34

X$LOGMNR_TABSUBPART$02013/8/16 9:34

X$LOGMNR_SESSION02013/8/16 9:34

X$LOGMNR_TYPE$02013/8/16 9:34

X$LOGMNR_UET$02013/8/16 9:34

X$LOGMNR_UNDO$02013/8/16 9:34

X$LOGMNR_SUBCOLTYPE$02013/8/16 9:34

X$LOGMNR_TABCOMPART$02013/8/16 9:34

X$LOGMNR_LOGS02013/8/16 9:34

X$LOGMNR_PARAMETERS02013/8/16 9:34

X$LOGMNR_ROOT$02013/8/16 9:34

X$LOGMNR_OBJ$02013/8/16 9:34

X$LOGMNR_SEG$02013/8/16 9:34

X$LOGMNR_PROCESS02013/8/16 9:34

X$LOGMNR_OPQTYPE$02013/8/16 9:34

X$LOGMNR_PARTOBJ$02013/8/16 9:34

X$LOGMNR_PROPS$02013/8/16 9:34

X$LOGMNR_REFCON$02013/8/16 9:34

X$LOGMNR_NTAB$02013/8/16 9:34

X$LOGMNR_INDPART$02013/8/16 9:34

X$LOGMNR_INDSUBPART$02013/8/16 9:34

X$LOGMNR_LOB$02013/8/16 9:34

X$LOGMNR_LOBFRAG$02013/8/16 9:34

X$LOGMNR_LOG02013/8/16 9:34

X$LOGMNR_KOPM$02013/8/16 9:34

X$LOGMNR_LATCH02013/8/16 9:34

X$LOGMNR_LOGFILE02013/8/16 9:34

X$LOGMNR_KTFBUE02013/8/16 9:34

X$LOGMNR_DICTIONARY02013/8/16 9:34

X$LOGMNR_COL$02013/8/16 9:34

X$LOGMNR_IND$02013/8/16 9:34

X$LOGMNR_COLTYPE$02013/8/16 9:34

X$LOGMNR_ENCRYPTION_PROFILE$02013/8/16 9:34

X$LOGMNR_DICTIONARY_LOAD02013/8/16 9:34

X$LOGMNR_ENC$02013/8/16 9:34

X$LOGMNR_CLU$02013/8/16 9:34

X$LOGMNR_FILE$02013/8/16 9:34

X$LOGMNR_INDCOMPART$02013/8/16 9:34

X$LOGMNR_ENCRYPTED_OBJ$02013/8/16 9:34

X$LOBSTATHIST182013/8/16 9:34

X$LOBSTAT32013/8/16 9:34

X$LOBSEGSTAT02013/8/16 9:34

X$LOGMNR_ATTRIBUTE$02013/8/16 9:34

X$LE02013/8/16 9:34

X$LOGMNR_CDEF$02013/8/16 9:34

X$LOGMNR_CALLBACK02013/8/16 9:34

X$LOGBUF_READHIST162013/8/16 9:34

X$LOGMNR_ATTRCOL$02013/8/16 9:34

X$KZDOS02013/8/16 9:34

X$KZSRO22013/8/16 9:34

X$KZSPR3932013/8/16 9:34

X$KZSRT62013/8/16 9:34

X$KZRTPD02013/8/16 9:34

X$KZEKMENCWAL12013/8/16 9:34

X$KZDPSUPSF32013/8/16 9:34

X$KZCKMCS02013/8/16 9:34

X$KZPOPR992013/8/16 9:34

X$KZAJOBS02013/8/16 9:34

X$KZAPARAMS02013/8/16 9:34

X$KZATS02013/8/16 9:34

X$KZCKMEK02013/8/16 9:34

X$KYWMPCTAB02013/8/16 9:34

X$KXSREPLAYLOB02013/8/16 9:34

X$KYWMCLTAB02013/8/16 9:34

X$KYWMNF02013/8/16 9:34

X$KYWMPCMN02013/8/16 9:34

X$KZAHIST02013/8/16 9:34

X$KXTTSTETS02013/8/16 9:34

X$KXTTSTECS02013/8/16 9:34

X$KXTTSTEHS02013/8/16 9:34

X$KXTTSTEIS02013/8/16 9:34

X$KXSREPLAYTIME02013/8/16 9:34

X$KXSREPLAYDATE02013/8/16 9:34

X$KXSREPLAYGUID02013/8/16 9:34

X$KXSREPLAYSEQ02013/8/16 9:34

X$KYWMWRCTAB02013/8/16 9:34

X$KXFSOURCE02013/8/16 9:34

X$KXFTASK02013/8/16 9:34

X$KXSREPLAY02013/8/16 9:34

X$KXSBD642013/8/16 9:34

X$KXSCC642013/8/16 9:34

X$KXFPSMS702013/8/16 9:34

X$KXFPYS202013/8/16 9:34

X$KXFPSST132013/8/16 9:34

X$KXFRSVCHASH02013/8/16 9:34

X$KXFQSROW02013/8/16 9:34

X$KXFPCST262013/8/16 9:34

X$KXFPCMS702013/8/16 9:34

X$KXFPNS202013/8/16 9:34

X$KXFPPIG02013/8/16 9:34

X$KXFPIG02013/8/16 9:34

X$KXFPINSTLOAD12013/8/16 9:34

X$KXFPDP162013/8/16 9:34

X$KXFPPFT1002013/8/16 9:34

X$KXFPBS52013/8/16 9:34

X$KXDRS02013/8/16 9:34

X$KXFPCDS472013/8/16 9:34

X$KXFPSDS472013/8/16 9:34

X$KXFPREMINSTLOAD02013/8/16 9:34

X$KXDBIO_STATS02013/8/16 9:34

X$KWSCPJOBSTAT02013/8/16 9:34

X$KWSBGAQPCSTAT12013/8/16 9:34

X$KWSBGQMNSTAT12013/8/16 9:34

X$KWQMNTASKSTAT232013/8/16 9:34

X$KWSBJCSQJIT02013/8/16 9:34

X$KWQPS02013/8/16 9:34

X$KWQPD02013/8/16 9:34

X$KWRSNV132013/8/16 9:34

X$KWSBSMSLVSTAT22013/8/16 9:34

X$KVII122013/8/16 9:34

X$KVIS02013/8/16 9:34

X$KVIT182013/8/16 9:34

X$KUPVJ02013/8/16 9:34

X$KWDDEF20892013/8/16 9:34

X$KWQDLSTAT322013/8/16 9:34

X$KWQBPMT12013/8/16 9:34

X$KWQMNC12013/8/16 9:34

X$KWQMNSCTX22013/8/16 9:34

X$KWQMNTASK22013/8/16 9:34

X$KWQMNJIT122013/8/16 9:34

X$KWQITCX12013/8/16 9:34

X$KTUGD12013/8/16 9:33

X$KTUXE4382013/8/16 9:33

X$KTUSMST72013/8/16 9:33

X$KTUSMST232013/8/16 9:33

X$KTUSUS102013/8/16 9:33

X$KTTETS112013/8/16 9:33

X$KTUTST02013/8/16 9:33

X$KTURHIST02013/8/16 9:33

X$KTUMASCN12013/8/16 9:33

X$KUPVA02013/8/16 9:33

X$KTTVS112013/8/16 9:33

X$KTUCUS02013/8/16 9:33

X$KTSTSSD12013/8/16 9:33

X$KTSSO12013/8/16 9:33

X$KTSTFC02013/8/16 9:33

X$KTSTUSC82013/8/16 9:33

X$KTSLCHUNK02013/8/16 9:33

X$KTSTUSG82013/8/16 9:33

X$KTSPSTAT12013/8/16 9:33

X$KTTEFINFO112013/8/16 9:33

X$KTSSPU02013/8/16 9:33

X$KTSTUSS82013/8/16 9:33

X$KTFTHC12013/8/16 9:33

X$KTFTME02013/8/16 9:33

X$KTPRXRS02013/8/16 9:33

X$KTPRXRT02013/8/16 9:33

X$KTPRHIST02013/8/16 9:33

X$KTSKSTAT02013/8/16 9:33

X$KTIFP512013/8/16 9:33

X$KTIFF212013/8/16 9:33

X$KTIFB162013/8/16 9:33

X$KTIFV02013/8/16 9:33

X$KTRSO02013/8/16 9:33

X$KTCNREGQUERY02013/8/16 9:33

X$KTFBNSTAT02013/8/16 9:33

X$KTFBHC102013/8/16 9:33

X$KTFSTAT02013/8/16 9:33

X$KTFSIMSTAT02013/8/16 9:33

X$KTFSAN12013/8/16 9:33

X$KTFSBI02013/8/16 9:33

X$KTFSRI02013/8/16 9:33

X$KTCXB5172013/8/16 9:33

X$KTCSP02013/8/16 9:33

X$KTCNREG02013/8/16 9:33

X$KTFTBTXNMODS02013/8/16 9:33

X$KTFTBTXNGRAPH02013/8/16 9:33

X$KTCNQUERY02013/8/16 9:33

X$KTCNQROW02013/8/16 9:33

X$KTFBFE322013/8/16 9:33

X$KSXRMSG02013/8/16 9:33

X$KSXRREPQ02013/8/16 9:33

X$KSXRCONQ02013/8/16 9:33

X$KSXRSG12013/8/16 9:33

X$KTATL82013/8/16 9:33

X$KTCNINBAND02013/8/16 9:33

X$KTADM21122013/8/16 9:33

X$KTATRFIL82013/8/16 9:33

X$KTATRFSL82013/8/16 9:33

X$KTCNCLAUSES02013/8/16 9:33

X$KSXPPING02013/8/16 9:33

X$KSXPCLIENT02013/8/16 9:33

X$KSXPIF02013/8/16 9:33

X$KSXPIA02013/8/16 9:33

X$KSXAFA112013/8/16 9:33

X$KSWSEVTAB17922013/8/16 9:33

X$KSWSCRSTAB02013/8/16 9:33

X$KSXM_DFT02013/8/16 9:33

X$KSXRCH02013/8/16 9:33

X$KSWSCRSSVCTAB02013/8/16 9:33

X$KSWSASTAB42013/8/16 9:33

X$KSWSCLSTAB522013/8/16 9:33

X$KSUSEX4722013/8/16 9:33

X$KSUSGSTA8392013/8/16 9:33

X$KSUTM12013/8/16 9:33

X$KSUSGIF12013/8/16 9:33

X$KSWSAFTAB02013/8/16 9:33

X$KSUSIO4722013/8/16 9:33

X$KSUVMSTAT22013/8/16 9:33

X$KSUSM4722013/8/16 9:33

X$KSUXSINST12013/8/16 9:33

X$KSUSESTA3960082013/8/16 9:33

X$KSUSE4722013/8/16 9:33

X$KSUSECON4762013/8/16 9:33

X$KSUSECST4722013/8/16 9:33

X$KSUPR3002013/8/16 9:33

X$KSUPRLAT02013/8/16 9:33

X$KSURLMT272013/8/16 9:33

X$KSUPL102013/8/16 9:33

X$KSUPGS02013/8/16 9:33

X$KSURU47202013/8/16 9:33

X$KSUSD8392013/8/16 9:33

X$KSUINSTSTAT02013/8/16 9:33

X$KSUMYSTA8392013/8/16 9:33

X$KSULOP82013/8/16 9:33

X$KSUPGP532013/8/16 9:33

X$KSUCF102013/8/16 9:33

X$KSUCLNDPCC02013/8/16 9:33

X$KSUCPUSTAT132013/8/16 9:33

X$KSUNETSTAT02013/8/16 9:33

X$KSUPDBSES2542013/8/16 9:33

X$KSTEX02013/8/16 9:33

X$KSULV5562013/8/16 9:33

X$KSULL12013/8/16 9:33

X$KSQEQTYP2412013/8/16 9:33

X$KSQRS23042013/8/16 9:33

X$KSQST4192013/8/16 9:33

X$KSRPCIOS32013/8/16 9:33

X$KSRMSGO02013/8/16 9:33

X$KSRCCTX2532013/8/16 9:33

X$KSRMSGDES952013/8/16 9:33

X$KSRMPCTX952013/8/16 9:33

X$KSRCHDL942013/8/16 9:33

X$KSRCDES2532013/8/16 9:33

X$KSQDN12013/8/16 9:33

X$KSPPI33412013/8/16 9:33

X$KSPPSV33412013/8/16 9:33

X$KSPPSV233462013/8/16 9:33

X$KSQEQ58722013/8/16 9:33

X$KSPSPFH12013/8/16 9:33

X$KSPVLD_VALUES7012013/8/16 9:33

X$KSPPO1332013/8/16 9:33

X$KSPSPFILE33422013/8/16 9:33

X$KSMSTRS42013/8/16 9:33

X$KSMUP33232013/8/16 9:33

X$KSMSST02013/8/16 9:33

X$KSMSSINFO02013/8/16 9:33

X$KSOLTD02013/8/16 9:33

X$KSPPCV233462013/8/16 9:33

X$KSOLSSTAT222013/8/16 9:33

X$KSOLSFTS244642013/8/16 9:33

X$KSO_SCHED_DELAY_HISTORY9022013/8/16 9:33

X$KSPPCV33412013/8/16 9:33

X$KSMLRU102013/8/16 9:33

X$KSMSPR1172013/8/16 9:33

X$KSMPP4372013/8/16 9:33

X$KSMSP_DSNEW12013/8/16 9:33

X$KSMSP_NWEX222013/8/16 9:33

X$KSMSGMEM122013/8/16 9:33

X$KSMLS52013/8/16 9:33

X$KSMPGDST02013/8/16 9:33

X$KSMPGDP02013/8/16 9:33

X$KSMSD42013/8/16 9:33

X$KSMSS10792013/8/16 9:33

X$KSMNS02013/8/16 9:33

X$KSMNIM02013/8/16 9:33

X$KSMPGST18002013/8/16 9:33

X$KSLWSC65812013/8/16 9:33

X$KSLWH3312013/8/16 9:33

X$KSLWT352013/8/16 9:33

X$KSMFS52013/8/16 9:33

X$KSMJS42013/8/16 9:33

X$KSMGE1032013/8/16 9:33

X$KSMHP02013/8/16 9:33

X$KSMJCH02013/8/16 9:33

X$KSMDD3542013/8/16 9:33

X$KSMDUT13202013/8/16 9:33

X$KSMFSV163872013/8/16 9:33

X$KSLPO4582013/8/16 9:33

X$KSLLTR7032013/8/16 9:33

X$KSLHOT102013/8/16 9:33

X$KSLLCLASS82013/8/16 9:33

X$KSLLD7032013/8/16 9:33

X$KSLSCS132013/8/16 9:33

X$KSLES2114562013/8/16 9:33

X$KSLSESHIST9432013/8/16 9:33

X$KSLLW65812013/8/16 9:33

X$KSI_REUSE_STATS4152013/8/16 9:33

X$KSLECLASS1252013/8/16 9:33

X$KSLEMAP15672013/8/16 9:33

X$KSLED15672013/8/16 9:33

X$KSLEPX92013/8/16 9:33

X$KSIRPINFO02013/8/16 9:33

X$KSLEI15672013/8/16 9:33

X$KSKPLW12013/8/16 9:33

X$KSKQVFT02013/8/16 9:33

X$KSKQDFT02013/8/16 9:33

X$KSIRGD02013/8/16 9:33

X$KSLCS61362013/8/16 9:33

X$KSIRESTYP2412013/8/16 9:33

X$KSIMSI02013/8/16 9:33

X$KSFQP02013/8/16 9:33

X$KSFQDVNT12013/8/16 9:33

X$KSFVQST1922013/8/16 9:33

X$KSFVSTA322013/8/16 9:33

X$KSIMAT52013/8/16 9:33

X$KSFMLIB02013/8/16 9:33

X$KSFMIOST02013/8/16 9:33

X$KSFMFILE02013/8/16 9:33

X$KSFMFILEEXT02013/8/16 9:33

X$KSFMSUBELEM02013/8/16 9:33

X$KSIMAV02013/8/16 9:33

X$KSFVSL02013/8/16 9:33

X$KSFDSTCG962013/8/16 9:33

X$KSFDSTCMP17642013/8/16 9:33

X$KSFDSTFILE532013/8/16 9:33

X$KSFDSTBLK02013/8/16 9:33

X$KSFMCOMPL02013/8/16 9:33

X$KSFDSTTHIST12013/8/16 9:33

X$KSFDSTLL652013/8/16 9:33

X$KSFMELEM02013/8/16 9:33

X$KSFMEXTELEM02013/8/16 9:33

X$KSFDSTHIST132013/8/16 9:33

X$KSBDPNEEDED12013/8/16 9:33

X$KSBFT762013/8/16 9:33

X$KSBSRVDT1242013/8/16 9:33

X$KSBTABACT32102013/8/16 9:33

X$KSFDFTYP372013/8/16 9:33

X$KSFDSSCLONEINFO02013/8/16 9:33

X$KSDAFT02013/8/16 9:33

X$KSFDKLL02013/8/16 9:33

X$KSDHNG_CHAINS12013/8/16 9:33

X$KSDHNG_SESSION_BLOCKERS02013/8/16 9:33

X$KSDHNG_CACHE_HISTORY202013/8/16 9:33

X$KSDAF02013/8/16 9:33

X$KSBDP4022013/8/16 9:33

X$KSBDD4022013/8/16 9:33

X$KSAST3002013/8/16 9:33

X$KRVXDTA452013/8/16 9:33

X$KRVXTX02013/8/16 9:33

X$KRVXISPLCR02013/8/16 9:33

X$KRVXOP02013/8/16 9:33

X$KRVXTHRD02013/8/16 9:33

X$KRVXWARNV02013/8/16 9:33

X$KRVXISPCHK02013/8/16 9:33

X$KRVXSV02013/8/16 9:33

X$KRVXDKA322013/8/16 9:33

X$KRVSLV02013/8/16 9:33

X$KRVSLVS02013/8/16 9:33

X$KRVSLVPG02013/8/16 9:33

X$KRVSLVST02013/8/16 9:33

X$KRSTALG132013/8/16 9:33

X$KRSTAPPSTATS10552013/8/16 9:33

X$KRSTDGC02013/8/16 9:33

X$KRSTDEST312013/8/16 9:33

X$KRSTPVRS02013/8/16 9:33

X$KRVSLVTHRD02013/8/16 9:33

X$KRSSMS42013/8/16 9:33

X$KRFSTHRD02013/8/16 9:33

X$KRDRSBROV02013/8/16 9:33

X$KRDEVTHIST02013/8/16 9:33

X$KRDMMIRA02013/8/16 9:33

X$KRCGFE02013/8/16 9:33

X$KRCSTAT12013/8/16 9:33

X$KRFBLOG02013/8/16 9:33

X$KRFGSTAT02013/8/16 9:33

X$KRCFH02013/8/16 9:33

X$KRBPHEAD02013/8/16 9:33

X$KRBPDIR02013/8/16 9:33

X$KRCEXT02013/8/16 9:33

X$KRCCDE02013/8/16 9:33

X$KRBZA32013/8/16 9:33

X$KRCCDR02013/8/16 9:33

X$KRCFDE02013/8/16 9:33

X$KRCFBH02013/8/16 9:33

X$KRCBIT02013/8/16 9:33

X$KRCCDS02013/8/16 9:33

X$KRBPDATA02013/8/16 9:33

X$KRBAFF102013/8/16 9:33

X$KRBMSFT02013/8/16 9:33

X$KRBMRST02013/8/16 9:33

X$KRASGA12013/8/16 9:33

X$KRBMCA62013/8/16 9:33

X$KQRST692013/8/16 9:33

X$KQRPD592013/8/16 9:33

X$KQRSD142013/8/16 9:33

X$KRBMROT02013/8/16 9:33

X$KQFTA11072013/8/16 9:33

X$KQFVI12612013/8/16 9:33

X$KQFVT12612013/8/16 9:33

X$KQFDT372013/8/16 9:33

X$KQFCO181452013/8/16 9:33

X$KQFTVRTTST012013/8/16 9:33

X$KQRFP77192013/8/16 9:33

X$KQRFS19482013/8/16 9:33

X$KQFSZ452013/8/16 9:33

X$KQFP372013/8/16 9:33

X$KQFOPT1292013/8/16 9:33

X$KQDPG12013/8/16 9:33

X$KPOQSTA02013/8/16 9:33

X$KPONESTAT02013/8/16 9:33

X$KPONJSTAT12013/8/16 9:33

X$KPPLCONN_INFO02013/8/16 9:33

X$KPONDESTAT02013/8/16 9:33

X$KPPLCC_INFO02013/8/16 9:33

X$KPPLCC_STATS02013/8/16 9:33

X$KPPLCP_STATS02013/8/16 9:33

X$KPONDCONSTAT02013/8/16 9:33

X$KNSTMVR02013/8/16 9:33

X$KNSTCAPS02013/8/16 9:33

X$KNSTRQU12013/8/16 9:33

X$KNSTTXN02013/8/16 9:33

X$KNSTRPP02013/8/16 9:33

X$KNSTXSTS02013/8/16 9:33

X$KNSTOGGC42013/8/16 9:33

X$KNSTSESS32013/8/16 9:33

X$KOCST12013/8/16 9:33

X$KNSTMT02013/8/16 9:33

X$KNSTCAP02013/8/16 9:33

X$KNSTCAPCACHE02013/8/16 9:33

X$KNSTANR02013/8/16 9:33

X$KNSTASL02013/8/16 9:33

X$KNSTACR02013/8/16 9:33

X$KNGFL02013/8/16 9:33

X$KNGFLE02013/8/16 9:33

X$KNLAROW02013/8/16 9:33

X$KNLASG12013/8/16 9:33

X$KMPSRV82013/8/16 9:33

X$KMPCP42013/8/16 9:33

X$KMPCSO12013/8/16 9:33

X$KMPDH42013/8/16 9:33

X$KMPCMON42013/8/16 9:33

X$KMMSI162013/8/16 9:33

X$KMGSTFR8002013/8/16 9:33

X$KMGSOP222013/8/16 9:33

X$KMMDI22013/8/16 9:33

X$KMMSG12013/8/16 9:33

X$KMMNV22013/8/16 9:33

X$KMMRD1922013/8/16 9:33

X$KMMSAS12013/8/16 9:33

X$KMMHST12013/8/16 9:33

X$KMMDP12013/8/16 9:33

X$KMGSCT172013/8/16 9:33

X$KMGSBSADV72013/8/16 9:33

X$KMGSBSMEMADV02013/8/16 9:33

X$KKOCS_HISTOGRAM1502013/8/16 9:33

X$KMCVC02013/8/16 9:33

X$KKOCS_STATISTICS02013/8/16 9:33

X$KLPT02013/8/16 9:33

X$KLCIE02013/8/16 9:33

X$KMCQS62013/8/16 9:33

X$KKOCS_SELECTIVITY02013/8/16 9:33

X$KJZSIWTEVT02013/8/16 9:33

X$KJZNHANGSES02013/8/16 9:33

X$KJZNWLMPCRANK02013/8/16 9:33

X$KJZNRSLNRC02013/8/16 9:33

X$KJZNHNGSTATS02013/8/16 9:33

X$KKOAR_HINT172013/8/16 9:33

X$KKKICR12013/8/16 9:33

X$KKAEET112013/8/16 9:33

X$KKCNRSTAT02013/8/16 9:33

X$KKCNEREG02013/8/16 9:33

X$KKCNEREGSTAT02013/8/16 9:33

X$KJZNHNGMGRSTS02013/8/16 9:33

X$KJR_FREEABLE_CHUNKS02013/8/16 9:33

X$KJXM02013/8/16 9:33

X$KJMSDP02013/8/16 9:33

X$KJMDDP02013/8/16 9:33

X$KJR_CHUNK_STATS02013/8/16 9:33

X$KJZNHANGS02013/8/16 9:33

X$KJZNCBHANGS02013/8/16 9:33

X$KJREQFP02013/8/16 9:33

X$KJRTBCFP02013/8/16 9:33

X$KJPNPX02013/8/16 9:33

X$KJLEQFP02013/8/16 9:33

X$KJISFT02013/8/16 9:33

X$KJILFT02013/8/16 9:33

X$KJKMKGA02013/8/16 9:33

X$KJIRFT02013/8/16 9:33

X$KJITRFT02013/8/16 9:33

X$KJIDT12013/8/16 9:33

X$KJILKFT02013/8/16 9:33

X$KJICVT02013/8/16 9:32

X$KJFMHBACL02013/8/16 9:32

X$KJDRPCMPF02013/8/16 9:32

X$KJDDDEADLOCKS02013/8/16 9:32

X$KJDDDEADLOCKSES02013/8/16 9:32

X$KJCTFS02013/8/16 9:32

X$KJCTFR02013/8/16 9:32

X$KJCTFRI02013/8/16 9:32

X$KJDRMREQ02013/8/16 9:32

X$KJDRPCMHV02013/8/16 9:32

X$KJDRMAFNSTATS12013/8/16 9:32

X$KJDRMREADMOSTLYSTATS12013/8/16 9:32

X$KJDRMHVSTATS12013/8/16 9:32

X$KJDRHV02013/8/16 9:32

X$KGSKVFT342013/8/16 9:32

X$KJCISOT72013/8/16 9:32

X$KJCISPT22013/8/16 9:32

X$KJBR02013/8/16 9:32

X$KJAC_CONFIG12013/8/16 9:32

X$KJBL02013/8/16 9:32

X$KJBLFX02013/8/16 9:32

X$KJAC_ID02013/8/16 9:32

X$KJAC_MY_ID02013/8/16 9:32

X$KJBRFX02013/8/16 9:32

X$KGSKTE02013/8/16 9:32

X$KGSKTO02013/8/16 9:32

X$KGSKCP22013/8/16 9:32

X$KGSKPP22013/8/16 9:32

X$KGSKASP12013/8/16 9:32

X$KGSKSCS02013/8/16 9:32

X$KGSKQUEP12013/8/16 9:32

X$KGSKCFT22013/8/16 9:32

X$KGSKNCFT22013/8/16 9:32

X$KGSKPFT12013/8/16 9:32

X$KGSKDOPP12013/8/16 9:32

X$KGHLU12013/8/16 9:32

X$KGSCC12013/8/16 9:32

X$KGICS12013/8/16 9:32

X$KFVOL02013/8/16 9:32

X$KFVOLSTAT02013/8/16 9:32

X$KFVACFSV02013/8/16 9:32

X$KFZPBLK02013/8/16 9:32

X$KFVACFSTAG02013/8/16 9:32

X$KFVACFSRULESET02013/8/16 9:32

X$KFVACFSRULESETRULE02013/8/16 9:32

X$KFZUDR02013/8/16 9:32

X$KFZGDR02013/8/16 9:32

X$KFZUAGR02013/8/16 9:32

X$KFVACFSS02013/8/16 9:32

X$KFTMTA02013/8/16 9:32

X$KFVACFS02013/8/16 9:32

X$KFVACFSREALM02013/8/16 9:32

X$KFVACFSENCR02013/8/16 9:32

X$KFVACFSRULE02013/8/16 9:32

X$KFVACFSREALMS02013/8/16 9:32

X$KFVACFSREPLTAG02013/8/16 9:32

X$KFVACFSREALMGROUP02013/8/16 9:32

X$KFVACFSREALMFILTER02013/8/16 9:32

X$KFVACFSCMDRULE02013/8/16 9:32

X$KFVACFSADMIN02013/8/16 9:32

X$KFVACFSREPL02013/8/16 9:32

X$KFVACFSREALMUSER02013/8/16 9:32

X$KFRC02013/8/16 9:32

X$KFNSDSKIOST02013/8/16 9:32

X$KFKID02013/8/16 9:32

X$KFKLIB02013/8/16 9:32

X$KFNRCL02013/8/16 9:32

X$KFMDGRP02013/8/16 9:32

X$KFNCL02013/8/16 9:32

X$KFKLSOD02013/8/16 9:32

X$KFGRP_STAT02013/8/16 9:32

X$KFGXP02013/8/16 9:32

X$KFIAS_FILE02013/8/16 9:32

X$KFIAS_PROC02013/8/16 9:32

X$KFIAS_CLNT02013/8/16 9:32

X$KFGRP02013/8/16 9:32

X$KFGMG02013/8/16 9:32

X$KFGBRB02013/8/16 9:32

X$KFGBRW02013/8/16 9:32

X$KFFOF02013/8/16 9:32

X$KFGBRC02013/8/16 9:32

X$KFFXP02013/8/16 9:32

X$KFGBRS02013/8/16 9:32

X$KFFIL02013/8/16 9:32

X$KFENV02013/8/16 9:32

X$KFDSK_STAT02013/8/16 9:32

X$KFDSR02013/8/16 9:32

X$KFDXEXT02013/8/16 9:32

X$KFDSK02013/8/16 9:32

X$KFDFS02013/8/16 9:32

X$KFDSD02013/8/16 9:32

X$KFDPARTNER02013/8/16 9:32

X$KFDDD02013/8/16 9:32

X$KFCBH02013/8/16 9:32

X$KFCCE02013/8/16 9:32

X$KFBH02013/8/16 9:32

X$KFCLLE02013/8/16 9:32

X$KFDAT02013/8/16 9:32

X$KFDAP02013/8/16 9:32

X$KFCSTAT02013/8/16 9:32

X$KFALS02013/8/16 9:32

X$KEWSSVCV1122013/8/16 9:32

X$KEWRTB1252013/8/16 9:32

X$KEWX_SEGMENTS02013/8/16 9:32

X$KEWX_LOBS02013/8/16 9:32

X$KEWMWPCMV02013/8/16 9:32

X$KEWRATTRSTALE02013/8/16 9:32

X$KEWSSMAP2692013/8/16 9:32

X$KEWSSYSV342013/8/16 9:32

X$KEWSSESV387042013/8/16 9:32

X$KEWRSQLCRIT02013/8/16 9:32

X$KEWMRWMV287612013/8/16 9:32

X$KEWMSEMV702013/8/16 9:32

X$KEWMFLMV302013/8/16 9:32

X$KEWMIOFMV4202013/8/16 9:32

X$KEWMSMDV1612013/8/16 9:32

X$KEWMWCRMV02013/8/16 9:32

X$KEWMRSM2192013/8/16 9:32

X$KEWMGSM142013/8/16 9:32

X$KEWMRMGMV02013/8/16 9:32

X$KEWMDRMV311482013/8/16 9:32

X$KEWEFXT02013/8/16 9:32

X$KEWESMS02013/8/16 9:32

X$KEWMAFMV02013/8/16 9:32

X$KEWEPCS02013/8/16 9:32

X$KEWMEVMV35242013/8/16 9:32

X$KEWMDSM2832013/8/16 9:32

X$KEWESMAS02013/8/16 9:32

X$KEWECLS02013/8/16 9:32

X$KEWASH3252013/8/16 9:32

X$KEWAM12013/8/16 9:32

X$KESWXMON_STATNAME752013/8/16 9:32

X$KETOP152013/8/16 9:32

X$KETCL72013/8/16 9:32

X$KESWXMON_PLAN22013/8/16 9:32

X$KETTG152013/8/16 9:32

X$KELTSD1752013/8/16 9:32

X$KESSPAMET92013/8/16 9:32

X$KESPLAN02013/8/16 9:32

X$KERPISTATS12013/8/16 9:32

X$KEOMNMON_SESSTAT02013/8/16 9:32

X$KERPIREPREQ02013/8/16 9:32

X$KESWXMON52013/8/16 9:32

X$KELTOSD282013/8/16 9:32

X$KELTGSD72013/8/16 9:32

X$KELRTD1292013/8/16 9:32

X$KELRXMR32013/8/16 9:32

X$KELRSGA12013/8/16 9:32

X$KEHR822013/8/16 9:32

X$KEHPRMMAP242013/8/16 9:32

X$KEHRP382013/8/16 9:32

X$KEHSQT632013/8/16 9:32

X$KEHSYSMAP102013/8/16 9:32

X$KEHOSMAP92013/8/16 9:32

X$KEHTIMMAP192013/8/16 9:32

X$KEHR_CHILD862013/8/16 9:32

X$KDNSSF4722013/8/16 9:32

X$KDXST02013/8/16 9:32

X$KDXHS162013/8/16 9:32

X$KEAOBJT262013/8/16 9:32

X$KEACMDN492013/8/16 9:32

X$KEHETSX92013/8/16 9:32

X$KEHF1192013/8/16 9:32

X$KEHEVTMAP1052013/8/16 9:32

X$KEHECLMAP122013/8/16 9:32

X$KECPDENTRY02013/8/16 9:32

X$KECPRT02013/8/16 9:32

X$KEAFDGN842013/8/16 9:32

X$KCVFH102013/8/16 9:32

X$KCVFHTMP12013/8/16 9:32

X$KDLU_STAT2162013/8/16 9:32

X$KDLT12013/8/16 9:32

X$KCVDF102013/8/16 9:32

X$KCTICW12013/8/16 9:32

X$KCTLAX02013/8/16 9:32

X$KCRMF02013/8/16 9:32

X$KCRMT02013/8/16 9:32

X$KCRMX02013/8/16 9:32

X$KCRRDSTAT312013/8/16 9:32

X$KCRFX02013/8/16 9:32

X$KCRRLNS02013/8/16 9:32

X$KCRRNHG30502013/8/16 9:32

X$KCRRASTATS312013/8/16 9:32

X$KCRRARCH302013/8/16 9:32

X$KCMSCN12013/8/16 9:32

X$KCRFWS12013/8/16 9:32

X$KCRFSTRAND532013/8/16 9:32

X$KCPDBINC02013/8/16 9:32

X$KCLQN02013/8/16 9:32

X$KCLRCVST12013/8/16 9:32

X$KCPXPL202013/8/16 9:32

X$KCRFDEBUG12013/8/16 9:32

X$KCFTIO2002013/8/16 9:32

X$KCLFX02013/8/16 9:32

X$KCLLS02013/8/16 9:32

X$KCLCRST12013/8/16 9:32

X$KCFISTCAP02013/8/16 9:32

X$KCLCURST12013/8/16 9:32

X$KCLDELTAST02013/8/16 9:32

X$KCFISTSA112013/8/16 9:32

X$KCLPINGPIN20482013/8/16 9:32

X$KCCRSP02013/8/16 9:32

X$KCCRSR92013/8/16 9:32

X$KCFIOHIST282013/8/16 9:32

X$KCFIOFCHIST02013/8/16 9:32

X$KCFIO2002013/8/16 9:32

X$KCCRS422013/8/16 9:32

X$KCCRT12013/8/16 9:32

X$KCCTIR82013/8/16 9:32

X$KCCSL02013/8/16 9:32

X$KCCTF12013/8/16 9:32

X$KCCTS112013/8/16 9:32

X$KCFISOSS02013/8/16 9:32

X$KCFISOSSN02013/8/16 9:32

X$KCFISOSSL02013/8/16 9:32

X$KCFISOSST02013/8/16 9:32

X$KCFISOSSC02013/8/16 9:32

X$KCFISCAP52013/8/16 9:32

X$KCCIC22013/8/16 9:32

X$KCCRDI12013/8/16 9:32

X$KCCIRT12013/8/16 9:32

X$KCCNRS02013/8/16 9:32

X$KCCPDB02013/8/16 9:32

X$KCCLE992013/8/16 9:32

X$KCCPA02013/8/16 9:32

X$KCCRM12013/8/16 9:32

X$KCCLH702013/8/16 9:32

X$KCCOR02013/8/16 9:32

X$KCCRL02013/8/16 9:32

X$KCCPD02013/8/16 9:32

X$KCCFN182013/8/16 9:32

X$KCCBI12013/8/16 9:32

X$KCCDL12013/8/16 9:32

X$KCCDFHIST02013/8/16 9:32

X$KCCBLKCOR02013/8/16 9:32

X$KCCCP82013/8/16 9:32

X$KCCCF22013/8/16 9:32

X$KCCDI12013/8/16 9:32

X$KCCDI212013/8/16 9:32

X$KCCFE102013/8/16 9:32

X$KCCAL32013/8/16 9:32

X$KCCBS22013/8/16 9:32

X$KCCBP22013/8/16 9:32

X$KCCBF22013/8/16 9:32

X$KCCBL02013/8/16 9:32

X$KCCDC02013/8/16 9:32

X$KCCFC02013/8/16 9:32

X$KCCCC02013/8/16 9:32

X$KCCFLE02013/8/16 9:32

X$KCCAGF12013/8/16 9:32

X$KCCACM92013/8/16 9:32

X$KCCADFC02013/8/16 9:32

X$KCBWDS322013/8/16 9:32

X$KCBVBL02013/8/16 9:32

X$KCBWH13002013/8/16 9:32

X$KCBUWHY13002013/8/16 9:32

X$KCBWAIT192013/8/16 9:32

X$KCBWBPD92013/8/16 9:32

X$KCBSW13002013/8/16 9:32

X$KCBTEK112013/8/16 9:32

X$KCBMKID12013/8/16 9:32

X$KCBPRFH02013/8/16 9:32

X$KCBOBH310162013/8/16 9:32

X$KCBMMAV02013/8/16 9:32

X$KCBLSC642013/8/16 9:32

X$KCBPINTIME20482013/8/16 9:32

X$KCBSC212013/8/16 9:32

X$KCBSDS322013/8/16 9:32

X$KCBOQH18492013/8/16 9:32

X$KCBBHS02013/8/16 9:32

X$KCBBES192013/8/16 9:32

X$KCBKWRL12013/8/16 9:32

X$KCBKPFS4002013/8/16 9:32

X$KCBBF30002013/8/16 9:32

X$KCBFWAIT4002013/8/16 9:32

X$KAUVRSTAT12013/8/16 9:32

X$KBRPSTAT52013/8/16 9:32

X$KCBLDRHIST10002013/8/16 9:32

X$K2GTE202013/8/16 9:32

X$KCBDWS12013/8/16 9:32

X$KCBDWOBJ02013/8/16 9:32

X$KCBFCIO02013/8/16 9:32

X$KCBDBK12013/8/16 9:32

X$K2GTE02013/8/16 9:32

X$IR_RS_PARAM02013/8/16 9:32

X$JSKJOBQ12013/8/16 9:32

X$JSKSLV02013/8/16 9:32

X$JSKMIMRT02013/8/16 9:32

X$IR_WR_PARAM02013/8/16 9:32

X$IR_WORKING_FAILURE_SET02013/8/16 9:32

X$IR_WORKING_REPAIR_SET02013/8/16 9:32

X$IR_REPAIR_OPTION02013/8/16 9:32

X$IR_REPAIR_STEP02013/8/16 9:32

X$IR_WF_PARAM02013/8/16 9:32

X$JSKMIMMD02013/8/16 9:32

X$GIMSA242013/8/16 9:32

X$INSTANCE_CACHE_TRANSFER02013/8/16 9:32

X$ESTIMATED_MTTR12013/8/16 9:32

X$GLOBALCONTEXT02013/8/16 9:32

X$HEATMAPSEGMENT192013/8/16 9:32

X$IR_MANUAL_OPTION02013/8/16 9:32

X$HOFP02013/8/16 9:32

X$IEE02013/8/16 9:32

X$IEE_ORPIECE02013/8/16 9:32

X$IEE_CONDITION02013/8/16 9:32

X$DURABLE_SHARDED_SUBS02013/8/16 9:32

X$HS_SESSION02013/8/16 9:32

X$DRM_HISTORY02013/8/16 9:32

X$DRM_HISTORY_STATS02013/8/16 9:32

X$DNFS_STATS02013/8/16 9:32

X$DUAL12013/8/16 9:32

X$DRA_FAILURE752013/8/16 9:32

X$DRA_FAILURE_PARAM1892013/8/16 9:32

X$DRA_FAILURE_REPAIR_MAP1162013/8/16 9:32

X$DRA_REPAIR_PARAM732013/8/16 9:32

X$DRA_FAILURE_REPAIR2642013/8/16 9:32

X$DRA_FAILURE_CHECK532013/8/16 9:32

X$DRA_FAILURE_CHECK_MAP1072013/8/16 9:32

X$DRA_FAILURE_PARENT_MAP112013/8/16 9:32

X$DRA_REPAIR1122013/8/16 9:32

X$DNFS_FILES02013/8/16 9:32

X$DNFS_CHANNELS02013/8/16 9:32

X$DNFS_HIST02013/8/16 9:32

X$DNFS_SERVERS02013/8/16 9:32

X$DNFS_META12013/8/16 9:32

X$DIAG_INFO112013/8/16 9:32

X$DGLPARAM362013/8/16 9:32

X$DGLXDAT02013/8/16 9:32

X$DBKRECO02013/8/16 9:32

X$DBKRUN62013/8/16 9:32

X$DIR152013/8/16 9:32

X$DBKINCMETCFG12013/8/16 9:32

X$DBKINCMETSUMMARY12013/8/16 9:32

X$DBKINCMETINFO02013/8/16 9:32

X$DBKEFEFC182013/8/16 9:32

X$DBKH_CHECK_PARAM632013/8/16 9:32

X$DBKFDG202013/8/16 9:32

X$DBKFSET02013/8/16 9:32

X$DBKINFO512013/8/16 9:32

X$DBKH_CHECK382013/8/16 9:32

X$DBKEFIEFC5122013/8/16 9:32

X$CON_KSLSCS132013/8/16 9:32

X$CON_KSLEI15672013/8/16 9:32

X$CON_KSUSGSTA8392013/8/16 9:32

X$CKPTBUF256642013/8/16 9:32

X$CONTEXT02013/8/16 9:32

X$CON12013/8/16 9:32

X$CON_KEWSSYSV342013/8/16 9:32

X$DBKEFAFC72013/8/16 9:32

X$DBKEFDEAFC02013/8/16 9:32

X$DBKECE402013/8/16 9:32

X$CELL_NAME02013/8/16 9:32

X$BUFFERED_SUBSCRIBERS02013/8/16 9:32

X$BH337492013/8/16 9:32

X$BMAPNONDURSUB322013/8/16 9:32

X$BUFFER02013/8/16 9:32

X$BUFFERED_PUBLISHERS02013/8/16 9:32

X$BUFFER202013/8/16 9:32

X$BUFFERED_QUEUES02013/8/16 9:32

X$AUD_OBJ_ACTIONS192013/8/16 9:32

X$AUD_XS_ACTIONS482013/8/16 9:32

X$AUD_OLS_ACTIONS192013/8/16 9:32

X$ASH5812013/8/16 9:32

X$AUD_DP_ACTIONS42013/8/16 9:32

X$AUD_DPAPI_ACTIONS32013/8/16 9:32

X$AUD_DV_OBJ_EVENTS142013/8/16 9:32

X$ACTIVECKPT92013/8/16 9:32

X$ABSTRACT_LOB12013/8/16 9:32

X$AQ_SUBSCRIBER_LOAD02013/8/16 9:32

X$QESRSTATALL71372013/8/16 9:32

X$QESRSTAT02013/8/16 9:32

X$QESRCOBJ02013/8/16 9:32

X$QESRCMEM02013/8/16 9:32

X$QESRCDEP02013/8/16 9:32

X$QESRCMSG02013/8/16 9:32

X$QESRCDR02013/8/16 9:32

X$QESRCSTA132013/8/16 9:32

X$QESRCRR02013/8/16 9:32

X$QESMMSGA382013/8/16 9:32

X$QESMMIWT02013/8/16 9:32

X$QESMMIWH332013/8/16 9:32

X$QESMMAPADV142013/8/16 9:32

X$QESRCRD02013/8/16 9:32

X$KQLSET26892013/8/16 9:32

X$QESBLSTAT202013/8/16 9:32

X$QESMMAHIST4622013/8/16 9:32

X$KQLFXPL70992013/8/16 9:32

X$KQLFSQCE7142152013/8/16 9:32

X$KK×××D17202013/8/16 9:32

X$KKSSQLSTAT29562013/8/16 9:32

X$KQLFBC22812013/8/16 9:32

X$KKSAI02013/8/16 9:32

X$KKSCS17042013/8/16 9:32

X$KKSBV22812013/8/16 9:32

X$KGLXS42532013/8/16 9:32

X$KGLTR7502013/8/16 9:32

X$KGLSIM182013/8/16 9:32

X$KGLOB158492013/8/16 9:32

X$KGLRD65782013/8/16 9:32

X$KGLST2692013/8/16 9:32

X$KGLSN372013/8/16 9:32

X$KGLPN292013/8/16 9:32

X$KGLNA1532132013/8/16 9:32

X$KGLLK4362013/8/16 9:32

X$KGLAU4782013/8/16 9:32

X$KGLDP53122013/8/16 9:32

X$KGLNA531962013/8/16 9:32

X$KGLJSIM102013/8/16 9:32

X$KGLMEM1262013/8/16 9:32

X$KGLJMEM1262013/8/16 9:32

procedure gather_fixed_objects_stats

(stattab varchar2 default null, statid varchar2 default null,

statown varchar2 default null,

no_invalidate boolean default

to_no_invalidate_type(get_param(&＃39;NO_INVALIDATE&＃39;)));

--

-- Gather statistics for fixed tables.

-- To run this procedure, you must have the SYSDBA or ANALYZE ANY DICTIONARY

-- system privilege.

--

-- Input arguments:

-- stattab - The user stat table identifier describing where to save

-- the current statistics.

-- statid - The (optional) identifier to associate with these statistics

-- within stattab.

-- statown - The schema containing stattab (if different then ownname)

-- no_invalidate - Do not invalide the dependent cursors if set to TRUE.

-- The procedure invalidates the dependent cursors immediately

-- if set to FALSE.

-- Use DBMS_STATS.AUTO_INVALIDATE to have oracle decide when to

-- invalidate dependend cursors. This is the default. The default

-- can be changed using set_param procedure.

-- Exceptions:

-- ORA-20000: insufficient privileges

-- ORA-20001: Bad input value

-- ORA-20002: Bad user statistics table, may need to upgrade it

--

function report_gather_fixed_obj_stats

(stattab varchar2 default null, statid varchar2 default null,

statown varchar2 default null,

no_invalidate boolean default

to_no_invalidate_type(get_param(&＃39;NO_INVALIDATE&＃39;)),

detail_level varchar2 default &＃39;TYPICAL&＃39;,

format varchar2 default &＃39;TEXT&＃39;)

return clob;

--

-- This procedure runs gather_fixed_objects_stats in reporting mode. That is,

-- stats are not actually collected, but all the objects that will be

-- affected when gather_fixed_objects_stats is invoked are reported.

-- The detail level for the report is defined by the detail_level

-- input parameter. Please see the comments for report_single_stats_operation

-- on possible values for detail_level and format.

-- For all other input parameters, please see the comments on

-- gather_fixed_objects_stats.

procedure delete_fixed_objects_stats(

stattab varchar2 default null, statid varchar2 default null,

statown varchar2 default null,

no_invalidate boolean default

to_no_invalidate_type(get_param(&＃39;NO_INVALIDATE&＃39;)),

force boolean default FALSE);

--

-- Deletes statistics for fixed tables

-- To run this procedure, you must have the SYSDBA or ANALYZE ANY DICTIONARY

-- system privilege.

--

-- Input arguments:

-- stattab - The user stat table identifier describing from where

-- to delete the statistics. If stattab is null, the statistics

-- will be deleted directly in the dictionary.

-- statid - The (optional) identifier to associate with these statistics

-- within stattab (Only pertinent if stattab is not NULL).

-- statown - The schema containing stattab (if different then ownname)

-- no_invalidate - Do not invalide the dependent cursors if set to TRUE.

-- The procedure invalidates the dependent cursors immediately

-- if set to FALSE.

-- Use DBMS_STATS.AUTO_INVALIDATE to have oracle decide when to

-- invalidate dependend cursors. This is the default. The default

-- can be changed using set_param procedure.

-- force - Ignores the statistics lock on objects and delete

-- the statistics if set to TRUE.

--

-- Exceptions:

-- ORA-20000: insufficient privileges

-- ORA-20002: Bad user statistics table, may need to upgrade it

--

procedure export_fixed_objects_stats(

stattab varchar2, statid varchar2 default null,

statown varchar2 default null);

--

-- Retrieves statistics for fixed tables and stores them in the user

-- stat table identified by stattab

-- To run this procedure, you must have the SYSDBA or ANALYZE ANY DICTIONARY

-- system privilege.

--

-- Input arguments:

-- stattab - The user stat table identifier describing where

-- to store the statistics.

-- statid - The (optional) identifier to associate with these statistics

-- within stattab.

-- statown - The schema containing stattab (if different then ownname)

--

-- Exceptions:

-- ORA-20000: insufficient privileges

-- ORA-20002: Bad user statistics table, may need to upgrade it

--

procedure import_fixed_objects_stats(

stattab varchar2, statid varchar2 default null,

statown varchar2 default null,

no_invalidate boolean default

to_no_invalidate_type(get_param(&＃39;NO_INVALIDATE&＃39;)),

force boolean default FALSE);

--

-- Retrieves statistics for fixed tables from the user stat table and

-- stores them in the dictionary

-- To run this procedure, you must have the SYSDBA or ANALYZE ANY DICTIONARY

-- system privilege.

-- The statistics will be imported as pending in case PUBLISH preference

-- is set to FALSE.

--

-- Input arguments:

-- stattab - The user stat table identifier describing from where

-- to retrieve the statistics.

-- statid - The (optional) identifier to associate with these statistics

-- within stattab.

-- statown - The schema containing stattab (if different then ownname)

-- no_invalidate - Do not invalide the dependent cursors if set to TRUE.

-- The procedure invalidates the dependent cursors immediately

-- if set to FALSE.

-- Use DBMS_STATS.AUTO_INVALIDATE to have oracle decide when to

-- invalidate dependend cursors. This is the default. The default

-- can be changed using set_param procedure.

-- force - Override statistics lock.

-- TRUE- Ignores the statistics lock on objects and import

-- the statistics.

-- FALSE-The statistics of an object will be imported only if it

-- is not locked.

--

-- Exceptions:

-- ORA-20000: insufficient privileges

-- if ORA-20000 shows "no statistics are imported", several

-- possible reasons are: (1) user specified statid does not

-- exist; (2) statistics are locked; (3) objects in the

-- stattab no longer exist in the current database

-- ORA-20001: Invalid or inconsistent values in the user stat table

-- ORA-20002: Bad user statistics table, may need to upgrade it