exec dbms_stats.gather_fixed_objects_stats;


该gather_fixed_objects_stats存储过程收集的X$基表对象如下，一般建议在系统高峰时段收集 例如大量session登陆之后，以保证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('NO_INVALIDATE')));
--
-- 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('NO_INVALIDATE')),
     detail_level varchar2 default 'TYPICAL',
     format varchar2 default 'TEXT')
  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('NO_INVALIDATE')),
        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('NO_INVALIDATE')),
        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