详解dbms_stats.gather_fixed_objects_stats

2013/01/15 by 1 Comment

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_name Num_rows Last_analyzed
X$XS_SESSION_NS_ATTRIBUTES 0 2013/8/16 9:34
X$XS_SESSION_ROLES 0 2013/8/16 9:34
X$XS_SESSIONS 0 2013/8/16 9:34
X$ZASAXTAB 0 2013/8/16 9:34
X$XSOQOPLU 0 2013/8/16 9:34
X$XSOQSEHI 0 2013/8/16 9:34
X$XSOQOJHI 0 2013/8/16 9:34
X$XSOQOPHI 0 2013/8/16 9:34
X$XSSINFO 0 2013/8/16 9:34
X$XPLTON 141 2013/8/16 9:34
X$XPLTOO 188 2013/8/16 9:34
X$XML_AUDIT_TRAIL 0 2013/8/16 9:34
X$VINST 0 2013/8/16 9:34
X$XSAWSO 16 2013/8/16 9:34
X$XSAGOP 29 2013/8/16 9:34
X$XSOBJECT 0 2013/8/16 9:34
X$XSLONGOPS 0 2013/8/16 9:34
X$XSOQMEHI 0 2013/8/16 9:34
X$XSAGGR 0 2013/8/16 9:34
X$SKGXPIA 0 2013/8/16 9:34
X$TRACE 5810 2013/8/16 9:34
X$TRACE_EVENTS 1000 2013/8/16 9:34
X$TIMEZONE_NAMES 2226 2013/8/16 9:34
X$TIMEZONE_FILE 1 2013/8/16 9:34
X$VERSION 5 2013/8/16 9:34
X$UNFLUSHED_DEQUEUES 0 2013/8/16 9:34
X$RXS_SESSION_ROLES 0 2013/8/16 9:34
X$UNIFIED_AUDIT_RECORD_FORMAT 93 2013/8/16 9:34
X$TEMPORARY_LOB_REFCNT 8 2013/8/16 9:34
X$UGANCO 0 2013/8/16 9:34
X$RULE_SET 1 2013/8/16 9:34
X$TARGETRBA 1 2013/8/16 9:34
X$QUIESCE 1 2013/8/16 9:34
X$QKSMMWDS 1209 2013/8/16 9:34
X$QKSHT 314 2013/8/16 9:34
X$QKSXA_REASON 353 2013/8/16 9:34
X$RULE 1 2013/8/16 9:34
X$RFMP 1 2013/8/16 9:34
X$RFMTE 0 2013/8/16 9:34
X$RFAHIST 0 2013/8/16 9:34
X$RFAFO 0 2013/8/16 9:34
X$RO_USER_ACCOUNT 0 2013/8/16 9:34
X$QKSCESYS 415 2013/8/16 9:34
X$QKSCESES 21165 2013/8/16 9:34
X$QKSBGSYS 884 2013/8/16 9:34
X$QKSBGSES 45084 2013/8/16 9:34
X$QKSCR_RSN 0 2013/8/16 9:34
X$QKSFMPRT 1001 2013/8/16 9:34
X$QKSFMDEP 996 2013/8/16 9:34
X$QKSCR 0 2013/8/16 9:34
X$QKSFM 996 2013/8/16 9:34
X$PROPS 38 2013/8/16 9:34
X$POLICY_HISTORY 0 2013/8/16 9:34
X$OPTIM_CALIB_STATS 25 2013/8/16 9:34
X$ORAFN 188 2013/8/16 9:34
X$PRMSLTYX 26 2013/8/16 9:34
X$PERSISTENT_PUBLISHERS 0 2013/8/16 9:34
X$OPVERSION 1008 2013/8/16 9:34
X$QERFXTST 10 2013/8/16 9:34
X$PERSISTENT_QUEUES 0 2013/8/16 9:34
X$PERSISTENT_SUBSCRIBERS 0 2013/8/16 9:34
X$OPTION 82 2013/8/16 9:34
X$OFS_STATS 0 2013/8/16 9:34
X$OFS_RW_LATENCY_STATS 0 2013/8/16 9:34
X$OBJECT_POLICY_STATISTICS 0 2013/8/16 9:34
X$OFSMOUNT 0 2013/8/16 9:34
X$OPARG 589 2013/8/16 9:34
X$NSV 0 2013/8/16 9:34
X$OPERATORS 1008 2013/8/16 9:34
X$OPDESC 1008 2013/8/16 9:34
X$OCT 242 2013/8/16 9:34
X$MESSAGES 416 2013/8/16 9:34
X$NLS_PARAMETERS 20 2013/8/16 9:34
X$MODACT_LENGTH 1 2013/8/16 9:34
X$MUTEX_SLEEP_HISTORY 77 2013/8/16 9:34
X$MUTEX_SLEEP 14 2013/8/16 9:34
X$MSGBM 0 2013/8/16 9:34
X$NONDURSUB 0 2013/8/16 9:34
X$NONDURSUB_LWM 0 2013/8/16 9:34
X$NFSCLIENTS 0 2013/8/16 9:34
X$NFSOPENS 0 2013/8/16 9:34
X$NFSLOCKS 0 2013/8/16 9:34
X$MESSAGE_CACHE 0 2013/8/16 9:34
X$LOGMNR_TAB$ 0 2013/8/16 9:34
X$LOGMNR_TS$ 0 2013/8/16 9:34
X$LOGMNR_USER$ 0 2013/8/16 9:34
X$LOGMNR_TABPART$ 0 2013/8/16 9:34
X$LOGMNR_TABSUBPART$ 0 2013/8/16 9:34
X$LOGMNR_SESSION 0 2013/8/16 9:34
X$LOGMNR_TYPE$ 0 2013/8/16 9:34
X$LOGMNR_UET$ 0 2013/8/16 9:34
X$LOGMNR_UNDO$ 0 2013/8/16 9:34
X$LOGMNR_SUBCOLTYPE$ 0 2013/8/16 9:34
X$LOGMNR_TABCOMPART$ 0 2013/8/16 9:34
X$LOGMNR_LOGS 0 2013/8/16 9:34
X$LOGMNR_PARAMETERS 0 2013/8/16 9:34
X$LOGMNR_ROOT$ 0 2013/8/16 9:34
X$LOGMNR_OBJ$ 0 2013/8/16 9:34
X$LOGMNR_SEG$ 0 2013/8/16 9:34
X$LOGMNR_PROCESS 0 2013/8/16 9:34
X$LOGMNR_OPQTYPE$ 0 2013/8/16 9:34
X$LOGMNR_PARTOBJ$ 0 2013/8/16 9:34
X$LOGMNR_PROPS$ 0 2013/8/16 9:34
X$LOGMNR_REFCON$ 0 2013/8/16 9:34
X$LOGMNR_NTAB$ 0 2013/8/16 9:34
X$LOGMNR_INDPART$ 0 2013/8/16 9:34
X$LOGMNR_INDSUBPART$ 0 2013/8/16 9:34
X$LOGMNR_LOB$ 0 2013/8/16 9:34
X$LOGMNR_LOBFRAG$ 0 2013/8/16 9:34
X$LOGMNR_LOG 0 2013/8/16 9:34
X$LOGMNR_KOPM$ 0 2013/8/16 9:34
X$LOGMNR_LATCH 0 2013/8/16 9:34
X$LOGMNR_LOGFILE 0 2013/8/16 9:34
X$LOGMNR_KTFBUE 0 2013/8/16 9:34
X$LOGMNR_DICTIONARY 0 2013/8/16 9:34
X$LOGMNR_COL$ 0 2013/8/16 9:34
X$LOGMNR_IND$ 0 2013/8/16 9:34
X$LOGMNR_COLTYPE$ 0 2013/8/16 9:34
X$LOGMNR_ENCRYPTION_PROFILE$ 0 2013/8/16 9:34
X$LOGMNR_DICTIONARY_LOAD 0 2013/8/16 9:34
X$LOGMNR_ENC$ 0 2013/8/16 9:34
X$LOGMNR_CLU$ 0 2013/8/16 9:34
X$LOGMNR_FILE$ 0 2013/8/16 9:34
X$LOGMNR_INDCOMPART$ 0 2013/8/16 9:34
X$LOGMNR_ENCRYPTED_OBJ$ 0 2013/8/16 9:34
X$LOBSTATHIST 18 2013/8/16 9:34
X$LOBSTAT 3 2013/8/16 9:34
X$LOBSEGSTAT 0 2013/8/16 9:34
X$LOGMNR_ATTRIBUTE$ 0 2013/8/16 9:34
X$LE 0 2013/8/16 9:34
X$LOGMNR_CDEF$ 0 2013/8/16 9:34
X$LOGMNR_CALLBACK 0 2013/8/16 9:34
X$LOGBUF_READHIST 16 2013/8/16 9:34
X$LOGMNR_ATTRCOL$ 0 2013/8/16 9:34
X$KZDOS 0 2013/8/16 9:34
X$KZSRO 2 2013/8/16 9:34
X$KZSPR 393 2013/8/16 9:34
X$KZSRT 6 2013/8/16 9:34
X$KZRTPD 0 2013/8/16 9:34
X$KZEKMENCWAL 1 2013/8/16 9:34
X$KZDPSUPSF 3 2013/8/16 9:34
X$KZCKMCS 0 2013/8/16 9:34
X$KZPOPR 99 2013/8/16 9:34
X$KZAJOBS 0 2013/8/16 9:34
X$KZAPARAMS 0 2013/8/16 9:34
X$KZATS 0 2013/8/16 9:34
X$KZCKMEK 0 2013/8/16 9:34
X$KYWMPCTAB 0 2013/8/16 9:34
X$KXSREPLAYLOB 0 2013/8/16 9:34
X$KYWMCLTAB 0 2013/8/16 9:34
X$KYWMNF 0 2013/8/16 9:34
X$KYWMPCMN 0 2013/8/16 9:34
X$KZAHIST 0 2013/8/16 9:34
X$KXTTSTETS 0 2013/8/16 9:34
X$KXTTSTECS 0 2013/8/16 9:34
X$KXTTSTEHS 0 2013/8/16 9:34
X$KXTTSTEIS 0 2013/8/16 9:34
X$KXSREPLAYTIME 0 2013/8/16 9:34
X$KXSREPLAYDATE 0 2013/8/16 9:34
X$KXSREPLAYGUID 0 2013/8/16 9:34
X$KXSREPLAYSEQ 0 2013/8/16 9:34
X$KYWMWRCTAB 0 2013/8/16 9:34
X$KXFSOURCE 0 2013/8/16 9:34
X$KXFTASK 0 2013/8/16 9:34
X$KXSREPLAY 0 2013/8/16 9:34
X$KXSBD 64 2013/8/16 9:34
X$KXSCC 64 2013/8/16 9:34
X$KXFPSMS 70 2013/8/16 9:34
X$KXFPYS 20 2013/8/16 9:34
X$KXFPSST 13 2013/8/16 9:34
X$KXFRSVCHASH 0 2013/8/16 9:34
X$KXFQSROW 0 2013/8/16 9:34
X$KXFPCST 26 2013/8/16 9:34
X$KXFPCMS 70 2013/8/16 9:34
X$KXFPNS 20 2013/8/16 9:34
X$KXFPPIG 0 2013/8/16 9:34
X$KXFPIG 0 2013/8/16 9:34
X$KXFPINSTLOAD 1 2013/8/16 9:34
X$KXFPDP 16 2013/8/16 9:34
X$KXFPPFT 100 2013/8/16 9:34
X$KXFPBS 5 2013/8/16 9:34
X$KXDRS 0 2013/8/16 9:34
X$KXFPCDS 47 2013/8/16 9:34
X$KXFPSDS 47 2013/8/16 9:34
X$KXFPREMINSTLOAD 0 2013/8/16 9:34
X$KXDBIO_STATS 0 2013/8/16 9:34
X$KWSCPJOBSTAT 0 2013/8/16 9:34
X$KWSBGAQPCSTAT 1 2013/8/16 9:34
X$KWSBGQMNSTAT 1 2013/8/16 9:34
X$KWQMNTASKSTAT 23 2013/8/16 9:34
X$KWSBJCSQJIT 0 2013/8/16 9:34
X$KWQPS 0 2013/8/16 9:34
X$KWQPD 0 2013/8/16 9:34
X$KWRSNV 13 2013/8/16 9:34
X$KWSBSMSLVSTAT 2 2013/8/16 9:34
X$KVII 12 2013/8/16 9:34
X$KVIS 0 2013/8/16 9:34
X$KVIT 18 2013/8/16 9:34
X$KUPVJ 0 2013/8/16 9:34
X$KWDDEF 2089 2013/8/16 9:34
X$KWQDLSTAT 32 2013/8/16 9:34
X$KWQBPMT 1 2013/8/16 9:34
X$KWQMNC 1 2013/8/16 9:34
X$KWQMNSCTX 2 2013/8/16 9:34
X$KWQMNTASK 2 2013/8/16 9:34
X$KWQMNJIT 12 2013/8/16 9:34
X$KWQITCX 1 2013/8/16 9:34
X$KTUGD 1 2013/8/16 9:33
X$KTUXE 438 2013/8/16 9:33
X$KTUSMST 7 2013/8/16 9:33
X$KTUSMST2 3 2013/8/16 9:33
X$KTUSUS 10 2013/8/16 9:33
X$KTTETS 11 2013/8/16 9:33
X$KTUTST 0 2013/8/16 9:33
X$KTURHIST 0 2013/8/16 9:33
X$KTUMASCN 1 2013/8/16 9:33
X$KUPVA 0 2013/8/16 9:33
X$KTTVS 11 2013/8/16 9:33
X$KTUCUS 0 2013/8/16 9:33
X$KTSTSSD 1 2013/8/16 9:33
X$KTSSO 1 2013/8/16 9:33
X$KTSTFC 0 2013/8/16 9:33
X$KTSTUSC 8 2013/8/16 9:33
X$KTSLCHUNK 0 2013/8/16 9:33
X$KTSTUSG 8 2013/8/16 9:33
X$KTSPSTAT 1 2013/8/16 9:33
X$KTTEFINFO 11 2013/8/16 9:33
X$KTSSPU 0 2013/8/16 9:33
X$KTSTUSS 8 2013/8/16 9:33
X$KTFTHC 1 2013/8/16 9:33
X$KTFTME 0 2013/8/16 9:33
X$KTPRXRS 0 2013/8/16 9:33
X$KTPRXRT 0 2013/8/16 9:33
X$KTPRHIST 0 2013/8/16 9:33
X$KTSKSTAT 0 2013/8/16 9:33
X$KTIFP 51 2013/8/16 9:33
X$KTIFF 21 2013/8/16 9:33
X$KTIFB 16 2013/8/16 9:33
X$KTIFV 0 2013/8/16 9:33
X$KTRSO 0 2013/8/16 9:33
X$KTCNREGQUERY 0 2013/8/16 9:33
X$KTFBNSTAT 0 2013/8/16 9:33
X$KTFBHC 10 2013/8/16 9:33
X$KTFSTAT 0 2013/8/16 9:33
X$KTFSIMSTAT 0 2013/8/16 9:33
X$KTFSAN 1 2013/8/16 9:33
X$KTFSBI 0 2013/8/16 9:33
X$KTFSRI 0 2013/8/16 9:33
X$KTCXB 517 2013/8/16 9:33
X$KTCSP 0 2013/8/16 9:33
X$KTCNREG 0 2013/8/16 9:33
X$KTFTBTXNMODS 0 2013/8/16 9:33
X$KTFTBTXNGRAPH 0 2013/8/16 9:33
X$KTCNQUERY 0 2013/8/16 9:33
X$KTCNQROW 0 2013/8/16 9:33
X$KTFBFE 32 2013/8/16 9:33
X$KSXRMSG 0 2013/8/16 9:33
X$KSXRREPQ 0 2013/8/16 9:33
X$KSXRCONQ 0 2013/8/16 9:33
X$KSXRSG 1 2013/8/16 9:33
X$KTATL 8 2013/8/16 9:33
X$KTCNINBAND 0 2013/8/16 9:33
X$KTADM 2112 2013/8/16 9:33
X$KTATRFIL 8 2013/8/16 9:33
X$KTATRFSL 8 2013/8/16 9:33
X$KTCNCLAUSES 0 2013/8/16 9:33
X$KSXPPING 0 2013/8/16 9:33
X$KSXPCLIENT 0 2013/8/16 9:33
X$KSXPIF 0 2013/8/16 9:33
X$KSXPIA 0 2013/8/16 9:33
X$KSXAFA 11 2013/8/16 9:33
X$KSWSEVTAB 1792 2013/8/16 9:33
X$KSWSCRSTAB 0 2013/8/16 9:33
X$KSXM_DFT 0 2013/8/16 9:33
X$KSXRCH 0 2013/8/16 9:33
X$KSWSCRSSVCTAB 0 2013/8/16 9:33
X$KSWSASTAB 4 2013/8/16 9:33
X$KSWSCLSTAB 52 2013/8/16 9:33
X$KSUSEX 472 2013/8/16 9:33
X$KSUSGSTA 839 2013/8/16 9:33
X$KSUTM 1 2013/8/16 9:33
X$KSUSGIF 1 2013/8/16 9:33
X$KSWSAFTAB 0 2013/8/16 9:33
X$KSUSIO 472 2013/8/16 9:33
X$KSUVMSTAT 2 2013/8/16 9:33
X$KSUSM 472 2013/8/16 9:33
X$KSUXSINST 1 2013/8/16 9:33
X$KSUSESTA 396008 2013/8/16 9:33
X$KSUSE 472 2013/8/16 9:33
X$KSUSECON 476 2013/8/16 9:33
X$KSUSECST 472 2013/8/16 9:33
X$KSUPR 300 2013/8/16 9:33
X$KSUPRLAT 0 2013/8/16 9:33
X$KSURLMT 27 2013/8/16 9:33
X$KSUPL 10 2013/8/16 9:33
X$KSUPGS 0 2013/8/16 9:33
X$KSURU 4720 2013/8/16 9:33
X$KSUSD 839 2013/8/16 9:33
X$KSUINSTSTAT 0 2013/8/16 9:33
X$KSUMYSTA 839 2013/8/16 9:33
X$KSULOP 8 2013/8/16 9:33
X$KSUPGP 53 2013/8/16 9:33
X$KSUCF 10 2013/8/16 9:33
X$KSUCLNDPCC 0 2013/8/16 9:33
X$KSUCPUSTAT 13 2013/8/16 9:33
X$KSUNETSTAT 0 2013/8/16 9:33
X$KSUPDBSES 254 2013/8/16 9:33
X$KSTEX 0 2013/8/16 9:33
X$KSULV 556 2013/8/16 9:33
X$KSULL 1 2013/8/16 9:33
X$KSQEQTYP 241 2013/8/16 9:33
X$KSQRS 2304 2013/8/16 9:33
X$KSQST 419 2013/8/16 9:33
X$KSRPCIOS 3 2013/8/16 9:33
X$KSRMSGO 0 2013/8/16 9:33
X$KSRCCTX 253 2013/8/16 9:33
X$KSRMSGDES 95 2013/8/16 9:33
X$KSRMPCTX 95 2013/8/16 9:33
X$KSRCHDL 94 2013/8/16 9:33
X$KSRCDES 253 2013/8/16 9:33
X$KSQDN 1 2013/8/16 9:33
X$KSPPI 3341 2013/8/16 9:33
X$KSPPSV 3341 2013/8/16 9:33
X$KSPPSV2 3346 2013/8/16 9:33
X$KSQEQ 5872 2013/8/16 9:33
X$KSPSPFH 1 2013/8/16 9:33
X$KSPVLD_VALUES 701 2013/8/16 9:33
X$KSPPO 133 2013/8/16 9:33
X$KSPSPFILE 3342 2013/8/16 9:33
X$KSMSTRS 4 2013/8/16 9:33
X$KSMUP 3323 2013/8/16 9:33
X$KSMSST 0 2013/8/16 9:33
X$KSMSSINFO 0 2013/8/16 9:33
X$KSOLTD 0 2013/8/16 9:33
X$KSPPCV2 3346 2013/8/16 9:33
X$KSOLSSTAT 22 2013/8/16 9:33
X$KSOLSFTS 24464 2013/8/16 9:33
X$KSO_SCHED_DELAY_HISTORY 902 2013/8/16 9:33
X$KSPPCV 3341 2013/8/16 9:33
X$KSMLRU 10 2013/8/16 9:33
X$KSMSPR 117 2013/8/16 9:33
X$KSMPP 437 2013/8/16 9:33
X$KSMSP_DSNEW 1 2013/8/16 9:33
X$KSMSP_NWEX 22 2013/8/16 9:33
X$KSMSGMEM 12 2013/8/16 9:33
X$KSMLS 5 2013/8/16 9:33
X$KSMPGDST 0 2013/8/16 9:33
X$KSMPGDP 0 2013/8/16 9:33
X$KSMSD 4 2013/8/16 9:33
X$KSMSS 1079 2013/8/16 9:33
X$KSMNS 0 2013/8/16 9:33
X$KSMNIM 0 2013/8/16 9:33
X$KSMPGST 1800 2013/8/16 9:33
X$KSLWSC 6581 2013/8/16 9:33
X$KSLWH 331 2013/8/16 9:33
X$KSLWT 35 2013/8/16 9:33
X$KSMFS 5 2013/8/16 9:33
X$KSMJS 4 2013/8/16 9:33
X$KSMGE 103 2013/8/16 9:33
X$KSMHP 0 2013/8/16 9:33
X$KSMJCH 0 2013/8/16 9:33
X$KSMDD 354 2013/8/16 9:33
X$KSMDUT1 320 2013/8/16 9:33
X$KSMFSV 16387 2013/8/16 9:33
X$KSLPO 458 2013/8/16 9:33
X$KSLLTR 703 2013/8/16 9:33
X$KSLHOT 10 2013/8/16 9:33
X$KSLLCLASS 8 2013/8/16 9:33
X$KSLLD 703 2013/8/16 9:33
X$KSLSCS 13 2013/8/16 9:33
X$KSLES 211456 2013/8/16 9:33
X$KSLSESHIST 943 2013/8/16 9:33
X$KSLLW 6581 2013/8/16 9:33
X$KSI_REUSE_STATS 415 2013/8/16 9:33
X$KSLECLASS 125 2013/8/16 9:33
X$KSLEMAP 1567 2013/8/16 9:33
X$KSLED 1567 2013/8/16 9:33
X$KSLEPX 9 2013/8/16 9:33
X$KSIRPINFO 0 2013/8/16 9:33
X$KSLEI 1567 2013/8/16 9:33
X$KSKPLW 1 2013/8/16 9:33
X$KSKQVFT 0 2013/8/16 9:33
X$KSKQDFT 0 2013/8/16 9:33
X$KSIRGD 0 2013/8/16 9:33
X$KSLCS 6136 2013/8/16 9:33
X$KSIRESTYP 241 2013/8/16 9:33
X$KSIMSI 0 2013/8/16 9:33
X$KSFQP 0 2013/8/16 9:33
X$KSFQDVNT 1 2013/8/16 9:33
X$KSFVQST 192 2013/8/16 9:33
X$KSFVSTA 32 2013/8/16 9:33
X$KSIMAT 5 2013/8/16 9:33
X$KSFMLIB 0 2013/8/16 9:33
X$KSFMIOST 0 2013/8/16 9:33
X$KSFMFILE 0 2013/8/16 9:33
X$KSFMFILEEXT 0 2013/8/16 9:33
X$KSFMSUBELEM 0 2013/8/16 9:33
X$KSIMAV 0 2013/8/16 9:33
X$KSFVSL 0 2013/8/16 9:33
X$KSFDSTCG 96 2013/8/16 9:33
X$KSFDSTCMP 1764 2013/8/16 9:33
X$KSFDSTFILE 53 2013/8/16 9:33
X$KSFDSTBLK 0 2013/8/16 9:33
X$KSFMCOMPL 0 2013/8/16 9:33
X$KSFDSTTHIST 1 2013/8/16 9:33
X$KSFDSTLL 65 2013/8/16 9:33
X$KSFMELEM 0 2013/8/16 9:33
X$KSFMEXTELEM 0 2013/8/16 9:33
X$KSFDSTHIST 13 2013/8/16 9:33
X$KSBDPNEEDED 1 2013/8/16 9:33
X$KSBFT 76 2013/8/16 9:33
X$KSBSRVDT 124 2013/8/16 9:33
X$KSBTABACT 3210 2013/8/16 9:33
X$KSFDFTYP 37 2013/8/16 9:33
X$KSFDSSCLONEINFO 0 2013/8/16 9:33
X$KSDAFT 0 2013/8/16 9:33
X$KSFDKLL 0 2013/8/16 9:33
X$KSDHNG_CHAINS 1 2013/8/16 9:33
X$KSDHNG_SESSION_BLOCKERS 0 2013/8/16 9:33
X$KSDHNG_CACHE_HISTORY 20 2013/8/16 9:33
X$KSDAF 0 2013/8/16 9:33
X$KSBDP 402 2013/8/16 9:33
X$KSBDD 402 2013/8/16 9:33
X$KSAST 300 2013/8/16 9:33
X$KRVXDTA 45 2013/8/16 9:33
X$KRVXTX 0 2013/8/16 9:33
X$KRVXISPLCR 0 2013/8/16 9:33
X$KRVXOP 0 2013/8/16 9:33
X$KRVXTHRD 0 2013/8/16 9:33
X$KRVXWARNV 0 2013/8/16 9:33
X$KRVXISPCHK 0 2013/8/16 9:33
X$KRVXSV 0 2013/8/16 9:33
X$KRVXDKA 32 2013/8/16 9:33
X$KRVSLV 0 2013/8/16 9:33
X$KRVSLVS 0 2013/8/16 9:33
X$KRVSLVPG 0 2013/8/16 9:33
X$KRVSLVST 0 2013/8/16 9:33
X$KRSTALG 13 2013/8/16 9:33
X$KRSTAPPSTATS 1055 2013/8/16 9:33
X$KRSTDGC 0 2013/8/16 9:33
X$KRSTDEST 31 2013/8/16 9:33
X$KRSTPVRS 0 2013/8/16 9:33
X$KRVSLVTHRD 0 2013/8/16 9:33
X$KRSSMS 4 2013/8/16 9:33
X$KRFSTHRD 0 2013/8/16 9:33
X$KRDRSBROV 0 2013/8/16 9:33
X$KRDEVTHIST 0 2013/8/16 9:33
X$KRDMMIRA 0 2013/8/16 9:33
X$KRCGFE 0 2013/8/16 9:33
X$KRCSTAT 1 2013/8/16 9:33
X$KRFBLOG 0 2013/8/16 9:33
X$KRFGSTAT 0 2013/8/16 9:33
X$KRCFH 0 2013/8/16 9:33
X$KRBPHEAD 0 2013/8/16 9:33
X$KRBPDIR 0 2013/8/16 9:33
X$KRCEXT 0 2013/8/16 9:33
X$KRCCDE 0 2013/8/16 9:33
X$KRBZA 3 2013/8/16 9:33
X$KRCCDR 0 2013/8/16 9:33
X$KRCFDE 0 2013/8/16 9:33
X$KRCFBH 0 2013/8/16 9:33
X$KRCBIT 0 2013/8/16 9:33
X$KRCCDS 0 2013/8/16 9:33
X$KRBPDATA 0 2013/8/16 9:33
X$KRBAFF 10 2013/8/16 9:33
X$KRBMSFT 0 2013/8/16 9:33
X$KRBMRST 0 2013/8/16 9:33
X$KRASGA 1 2013/8/16 9:33
X$KRBMCA 6 2013/8/16 9:33
X$KQRST 69 2013/8/16 9:33
X$KQRPD 59 2013/8/16 9:33
X$KQRSD 14 2013/8/16 9:33
X$KRBMROT 0 2013/8/16 9:33
X$KQFTA 1107 2013/8/16 9:33
X$KQFVI 1261 2013/8/16 9:33
X$KQFVT 1261 2013/8/16 9:33
X$KQFDT 37 2013/8/16 9:33
X$KQFCO 18145 2013/8/16 9:33
X$KQFTVRTTST0 1 2013/8/16 9:33
X$KQRFP 7719 2013/8/16 9:33
X$KQRFS 1948 2013/8/16 9:33
X$KQFSZ 45 2013/8/16 9:33
X$KQFP 37 2013/8/16 9:33
X$KQFOPT 129 2013/8/16 9:33
X$KQDPG 1 2013/8/16 9:33
X$KPOQSTA 0 2013/8/16 9:33
X$KPONESTAT 0 2013/8/16 9:33
X$KPONJSTAT 1 2013/8/16 9:33
X$KPPLCONN_INFO 0 2013/8/16 9:33
X$KPONDESTAT 0 2013/8/16 9:33
X$KPPLCC_INFO 0 2013/8/16 9:33
X$KPPLCC_STATS 0 2013/8/16 9:33
X$KPPLCP_STATS 0 2013/8/16 9:33
X$KPONDCONSTAT 0 2013/8/16 9:33
X$KNSTMVR 0 2013/8/16 9:33
X$KNSTCAPS 0 2013/8/16 9:33
X$KNSTRQU 1 2013/8/16 9:33
X$KNSTTXN 0 2013/8/16 9:33
X$KNSTRPP 0 2013/8/16 9:33
X$KNSTXSTS 0 2013/8/16 9:33
X$KNSTOGGC 4 2013/8/16 9:33
X$KNSTSESS 3 2013/8/16 9:33
X$KOCST 1 2013/8/16 9:33
X$KNSTMT 0 2013/8/16 9:33
X$KNSTCAP 0 2013/8/16 9:33
X$KNSTCAPCACHE 0 2013/8/16 9:33
X$KNSTANR 0 2013/8/16 9:33
X$KNSTASL 0 2013/8/16 9:33
X$KNSTACR 0 2013/8/16 9:33
X$KNGFL 0 2013/8/16 9:33
X$KNGFLE 0 2013/8/16 9:33
X$KNLAROW 0 2013/8/16 9:33
X$KNLASG 1 2013/8/16 9:33
X$KMPSRV 8 2013/8/16 9:33
X$KMPCP 4 2013/8/16 9:33
X$KMPCSO 1 2013/8/16 9:33
X$KMPDH 4 2013/8/16 9:33
X$KMPCMON 4 2013/8/16 9:33
X$KMMSI 16 2013/8/16 9:33
X$KMGSTFR 800 2013/8/16 9:33
X$KMGSOP 22 2013/8/16 9:33
X$KMMDI 2 2013/8/16 9:33
X$KMMSG 1 2013/8/16 9:33
X$KMMNV 2 2013/8/16 9:33
X$KMMRD 192 2013/8/16 9:33
X$KMMSAS 1 2013/8/16 9:33
X$KMMHST 1 2013/8/16 9:33
X$KMMDP 1 2013/8/16 9:33
X$KMGSCT 17 2013/8/16 9:33
X$KMGSBSADV 7 2013/8/16 9:33
X$KMGSBSMEMADV 0 2013/8/16 9:33
X$KKOCS_HISTOGRAM 150 2013/8/16 9:33
X$KMCVC 0 2013/8/16 9:33
X$KKOCS_STATISTICS 0 2013/8/16 9:33
X$KLPT 0 2013/8/16 9:33
X$KLCIE 0 2013/8/16 9:33
X$KMCQS 6 2013/8/16 9:33
X$KKOCS_SELECTIVITY 0 2013/8/16 9:33
X$KJZSIWTEVT 0 2013/8/16 9:33
X$KJZNHANGSES 0 2013/8/16 9:33
X$KJZNWLMPCRANK 0 2013/8/16 9:33
X$KJZNRSLNRC 0 2013/8/16 9:33
X$KJZNHNGSTATS 0 2013/8/16 9:33
X$KKOAR_HINT 17 2013/8/16 9:33
X$KKKICR 1 2013/8/16 9:33
X$KKAEET 11 2013/8/16 9:33
X$KKCNRSTAT 0 2013/8/16 9:33
X$KKCNEREG 0 2013/8/16 9:33
X$KKCNEREGSTAT 0 2013/8/16 9:33
X$KJZNHNGMGRSTS 0 2013/8/16 9:33
X$KJR_FREEABLE_CHUNKS 0 2013/8/16 9:33
X$KJXM 0 2013/8/16 9:33
X$KJMSDP 0 2013/8/16 9:33
X$KJMDDP 0 2013/8/16 9:33
X$KJR_CHUNK_STATS 0 2013/8/16 9:33
X$KJZNHANGS 0 2013/8/16 9:33
X$KJZNCBHANGS 0 2013/8/16 9:33
X$KJREQFP 0 2013/8/16 9:33
X$KJRTBCFP 0 2013/8/16 9:33
X$KJPNPX 0 2013/8/16 9:33
X$KJLEQFP 0 2013/8/16 9:33
X$KJISFT 0 2013/8/16 9:33
X$KJILFT 0 2013/8/16 9:33
X$KJKMKGA 0 2013/8/16 9:33
X$KJIRFT 0 2013/8/16 9:33
X$KJITRFT 0 2013/8/16 9:33
X$KJIDT 1 2013/8/16 9:33
X$KJILKFT 0 2013/8/16 9:33
X$KJICVT 0 2013/8/16 9:32
X$KJFMHBACL 0 2013/8/16 9:32
X$KJDRPCMPF 0 2013/8/16 9:32
X$KJDDDEADLOCKS 0 2013/8/16 9:32
X$KJDDDEADLOCKSES 0 2013/8/16 9:32
X$KJCTFS 0 2013/8/16 9:32
X$KJCTFR 0 2013/8/16 9:32
X$KJCTFRI 0 2013/8/16 9:32
X$KJDRMREQ 0 2013/8/16 9:32
X$KJDRPCMHV 0 2013/8/16 9:32
X$KJDRMAFNSTATS 1 2013/8/16 9:32
X$KJDRMREADMOSTLYSTATS 1 2013/8/16 9:32
X$KJDRMHVSTATS 1 2013/8/16 9:32
X$KJDRHV 0 2013/8/16 9:32
X$KGSKVFT 34 2013/8/16 9:32
X$KJCISOT 7 2013/8/16 9:32
X$KJCISPT 2 2013/8/16 9:32
X$KJBR 0 2013/8/16 9:32
X$KJAC_CONFIG 1 2013/8/16 9:32
X$KJBL 0 2013/8/16 9:32
X$KJBLFX 0 2013/8/16 9:32
X$KJAC_ID 0 2013/8/16 9:32
X$KJAC_MY_ID 0 2013/8/16 9:32
X$KJBRFX 0 2013/8/16 9:32
X$KGSKTE 0 2013/8/16 9:32
X$KGSKTO 0 2013/8/16 9:32
X$KGSKCP 2 2013/8/16 9:32
X$KGSKPP 2 2013/8/16 9:32
X$KGSKASP 1 2013/8/16 9:32
X$KGSKSCS 0 2013/8/16 9:32
X$KGSKQUEP 1 2013/8/16 9:32
X$KGSKCFT 2 2013/8/16 9:32
X$KGSKNCFT 2 2013/8/16 9:32
X$KGSKPFT 1 2013/8/16 9:32
X$KGSKDOPP 1 2013/8/16 9:32
X$KGHLU 1 2013/8/16 9:32
X$KGSCC 1 2013/8/16 9:32
X$KGICS 1 2013/8/16 9:32
X$KFVOL 0 2013/8/16 9:32
X$KFVOLSTAT 0 2013/8/16 9:32
X$KFVACFSV 0 2013/8/16 9:32
X$KFZPBLK 0 2013/8/16 9:32
X$KFVACFSTAG 0 2013/8/16 9:32
X$KFVACFSRULESET 0 2013/8/16 9:32
X$KFVACFSRULESETRULE 0 2013/8/16 9:32
X$KFZUDR 0 2013/8/16 9:32
X$KFZGDR 0 2013/8/16 9:32
X$KFZUAGR 0 2013/8/16 9:32
X$KFVACFSS 0 2013/8/16 9:32
X$KFTMTA 0 2013/8/16 9:32
X$KFVACFS 0 2013/8/16 9:32
X$KFVACFSREALM 0 2013/8/16 9:32
X$KFVACFSENCR 0 2013/8/16 9:32
X$KFVACFSRULE 0 2013/8/16 9:32
X$KFVACFSREALMS 0 2013/8/16 9:32
X$KFVACFSREPLTAG 0 2013/8/16 9:32
X$KFVACFSREALMGROUP 0 2013/8/16 9:32
X$KFVACFSREALMFILTER 0 2013/8/16 9:32
X$KFVACFSCMDRULE 0 2013/8/16 9:32
X$KFVACFSADMIN 0 2013/8/16 9:32
X$KFVACFSREPL 0 2013/8/16 9:32
X$KFVACFSREALMUSER 0 2013/8/16 9:32
X$KFRC 0 2013/8/16 9:32
X$KFNSDSKIOST 0 2013/8/16 9:32
X$KFKID 0 2013/8/16 9:32
X$KFKLIB 0 2013/8/16 9:32
X$KFNRCL 0 2013/8/16 9:32
X$KFMDGRP 0 2013/8/16 9:32
X$KFNCL 0 2013/8/16 9:32
X$KFKLSOD 0 2013/8/16 9:32
X$KFGRP_STAT 0 2013/8/16 9:32
X$KFGXP 0 2013/8/16 9:32
X$KFIAS_FILE 0 2013/8/16 9:32
X$KFIAS_PROC 0 2013/8/16 9:32
X$KFIAS_CLNT 0 2013/8/16 9:32
X$KFGRP 0 2013/8/16 9:32
X$KFGMG 0 2013/8/16 9:32
X$KFGBRB 0 2013/8/16 9:32
X$KFGBRW 0 2013/8/16 9:32
X$KFFOF 0 2013/8/16 9:32
X$KFGBRC 0 2013/8/16 9:32
X$KFFXP 0 2013/8/16 9:32
X$KFGBRS 0 2013/8/16 9:32
X$KFFIL 0 2013/8/16 9:32
X$KFENV 0 2013/8/16 9:32
X$KFDSK_STAT 0 2013/8/16 9:32
X$KFDSR 0 2013/8/16 9:32
X$KFDXEXT 0 2013/8/16 9:32
X$KFDSK 0 2013/8/16 9:32
X$KFDFS 0 2013/8/16 9:32
X$KFDSD 0 2013/8/16 9:32
X$KFDPARTNER 0 2013/8/16 9:32
X$KFDDD 0 2013/8/16 9:32
X$KFCBH 0 2013/8/16 9:32
X$KFCCE 0 2013/8/16 9:32
X$KFBH 0 2013/8/16 9:32
X$KFCLLE 0 2013/8/16 9:32
X$KFDAT 0 2013/8/16 9:32
X$KFDAP 0 2013/8/16 9:32
X$KFCSTAT 0 2013/8/16 9:32
X$KFALS 0 2013/8/16 9:32
X$KEWSSVCV 112 2013/8/16 9:32
X$KEWRTB 125 2013/8/16 9:32
X$KEWX_SEGMENTS 0 2013/8/16 9:32
X$KEWX_LOBS 0 2013/8/16 9:32
X$KEWMWPCMV 0 2013/8/16 9:32
X$KEWRATTRSTALE 0 2013/8/16 9:32
X$KEWSSMAP 269 2013/8/16 9:32
X$KEWSSYSV 34 2013/8/16 9:32
X$KEWSSESV 38704 2013/8/16 9:32
X$KEWRSQLCRIT 0 2013/8/16 9:32
X$KEWMRWMV 28761 2013/8/16 9:32
X$KEWMSEMV 70 2013/8/16 9:32
X$KEWMFLMV 30 2013/8/16 9:32
X$KEWMIOFMV 420 2013/8/16 9:32
X$KEWMSMDV 161 2013/8/16 9:32
X$KEWMWCRMV 0 2013/8/16 9:32
X$KEWMRSM 219 2013/8/16 9:32
X$KEWMGSM 14 2013/8/16 9:32
X$KEWMRMGMV 0 2013/8/16 9:32
X$KEWMDRMV 31148 2013/8/16 9:32
X$KEWEFXT 0 2013/8/16 9:32
X$KEWESMS 0 2013/8/16 9:32
X$KEWMAFMV 0 2013/8/16 9:32
X$KEWEPCS 0 2013/8/16 9:32
X$KEWMEVMV 3524 2013/8/16 9:32
X$KEWMDSM 283 2013/8/16 9:32
X$KEWESMAS 0 2013/8/16 9:32
X$KEWECLS 0 2013/8/16 9:32
X$KEWASH 325 2013/8/16 9:32
X$KEWAM 1 2013/8/16 9:32
X$KESWXMON_STATNAME 75 2013/8/16 9:32
X$KETOP 15 2013/8/16 9:32
X$KETCL 7 2013/8/16 9:32
X$KESWXMON_PLAN 2 2013/8/16 9:32
X$KETTG 15 2013/8/16 9:32
X$KELTSD 175 2013/8/16 9:32
X$KESSPAMET 9 2013/8/16 9:32
X$KESPLAN 0 2013/8/16 9:32
X$KERPISTATS 1 2013/8/16 9:32
X$KEOMNMON_SESSTAT 0 2013/8/16 9:32
X$KERPIREPREQ 0 2013/8/16 9:32
X$KESWXMON 5 2013/8/16 9:32
X$KELTOSD 28 2013/8/16 9:32
X$KELTGSD 7 2013/8/16 9:32
X$KELRTD 129 2013/8/16 9:32
X$KELRXMR 3 2013/8/16 9:32
X$KELRSGA 1 2013/8/16 9:32
X$KEHR 82 2013/8/16 9:32
X$KEHPRMMAP 24 2013/8/16 9:32
X$KEHRP 38 2013/8/16 9:32
X$KEHSQT 63 2013/8/16 9:32
X$KEHSYSMAP 10 2013/8/16 9:32
X$KEHOSMAP 9 2013/8/16 9:32
X$KEHTIMMAP 19 2013/8/16 9:32
X$KEHR_CHILD 86 2013/8/16 9:32
X$KDNSSF 472 2013/8/16 9:32
X$KDXST 0 2013/8/16 9:32
X$KDXHS 16 2013/8/16 9:32
X$KEAOBJT 26 2013/8/16 9:32
X$KEACMDN 49 2013/8/16 9:32
X$KEHETSX 9 2013/8/16 9:32
X$KEHF 119 2013/8/16 9:32
X$KEHEVTMAP 105 2013/8/16 9:32
X$KEHECLMAP 12 2013/8/16 9:32
X$KECPDENTRY 0 2013/8/16 9:32
X$KECPRT 0 2013/8/16 9:32
X$KEAFDGN 84 2013/8/16 9:32
X$KCVFH 10 2013/8/16 9:32
X$KCVFHTMP 1 2013/8/16 9:32
X$KDLU_STAT 216 2013/8/16 9:32
X$KDLT 1 2013/8/16 9:32
X$KCVDF 10 2013/8/16 9:32
X$KCTICW 1 2013/8/16 9:32
X$KCTLAX 0 2013/8/16 9:32
X$KCRMF 0 2013/8/16 9:32
X$KCRMT 0 2013/8/16 9:32
X$KCRMX 0 2013/8/16 9:32
X$KCRRDSTAT 31 2013/8/16 9:32
X$KCRFX 0 2013/8/16 9:32
X$KCRRLNS 0 2013/8/16 9:32
X$KCRRNHG 3050 2013/8/16 9:32
X$KCRRASTATS 31 2013/8/16 9:32
X$KCRRARCH 30 2013/8/16 9:32
X$KCMSCN 1 2013/8/16 9:32
X$KCRFWS 1 2013/8/16 9:32
X$KCRFSTRAND 53 2013/8/16 9:32
X$KCPDBINC 0 2013/8/16 9:32
X$KCLQN 0 2013/8/16 9:32
X$KCLRCVST 1 2013/8/16 9:32
X$KCPXPL 20 2013/8/16 9:32
X$KCRFDEBUG 1 2013/8/16 9:32
X$KCFTIO 200 2013/8/16 9:32
X$KCLFX 0 2013/8/16 9:32
X$KCLLS 0 2013/8/16 9:32
X$KCLCRST 1 2013/8/16 9:32
X$KCFISTCAP 0 2013/8/16 9:32
X$KCLCURST 1 2013/8/16 9:32
X$KCLDELTAST 0 2013/8/16 9:32
X$KCFISTSA 11 2013/8/16 9:32
X$KCLPINGPIN 2048 2013/8/16 9:32
X$KCCRSP 0 2013/8/16 9:32
X$KCCRSR 9 2013/8/16 9:32
X$KCFIOHIST 28 2013/8/16 9:32
X$KCFIOFCHIST 0 2013/8/16 9:32
X$KCFIO 200 2013/8/16 9:32
X$KCCRS 42 2013/8/16 9:32
X$KCCRT 1 2013/8/16 9:32
X$KCCTIR 8 2013/8/16 9:32
X$KCCSL 0 2013/8/16 9:32
X$KCCTF 1 2013/8/16 9:32
X$KCCTS 11 2013/8/16 9:32
X$KCFISOSS 0 2013/8/16 9:32
X$KCFISOSSN 0 2013/8/16 9:32
X$KCFISOSSL 0 2013/8/16 9:32
X$KCFISOSST 0 2013/8/16 9:32
X$KCFISOSSC 0 2013/8/16 9:32
X$KCFISCAP 5 2013/8/16 9:32
X$KCCIC 2 2013/8/16 9:32
X$KCCRDI 1 2013/8/16 9:32
X$KCCIRT 1 2013/8/16 9:32
X$KCCNRS 0 2013/8/16 9:32
X$KCCPDB 0 2013/8/16 9:32
X$KCCLE 99 2013/8/16 9:32
X$KCCPA 0 2013/8/16 9:32
X$KCCRM 1 2013/8/16 9:32
X$KCCLH 70 2013/8/16 9:32
X$KCCOR 0 2013/8/16 9:32
X$KCCRL 0 2013/8/16 9:32
X$KCCPD 0 2013/8/16 9:32
X$KCCFN 18 2013/8/16 9:32
X$KCCBI 1 2013/8/16 9:32
X$KCCDL 1 2013/8/16 9:32
X$KCCDFHIST 0 2013/8/16 9:32
X$KCCBLKCOR 0 2013/8/16 9:32
X$KCCCP 8 2013/8/16 9:32
X$KCCCF 2 2013/8/16 9:32
X$KCCDI 1 2013/8/16 9:32
X$KCCDI2 1 2013/8/16 9:32
X$KCCFE 10 2013/8/16 9:32
X$KCCAL 3 2013/8/16 9:32
X$KCCBS 2 2013/8/16 9:32
X$KCCBP 2 2013/8/16 9:32
X$KCCBF 2 2013/8/16 9:32
X$KCCBL 0 2013/8/16 9:32
X$KCCDC 0 2013/8/16 9:32
X$KCCFC 0 2013/8/16 9:32
X$KCCCC 0 2013/8/16 9:32
X$KCCFLE 0 2013/8/16 9:32
X$KCCAGF 1 2013/8/16 9:32
X$KCCACM 9 2013/8/16 9:32
X$KCCADFC 0 2013/8/16 9:32
X$KCBWDS 32 2013/8/16 9:32
X$KCBVBL 0 2013/8/16 9:32
X$KCBWH 1300 2013/8/16 9:32
X$KCBUWHY 1300 2013/8/16 9:32
X$KCBWAIT 19 2013/8/16 9:32
X$KCBWBPD 9 2013/8/16 9:32
X$KCBSW 1300 2013/8/16 9:32
X$KCBTEK 11 2013/8/16 9:32
X$KCBMKID 1 2013/8/16 9:32
X$KCBPRFH 0 2013/8/16 9:32
X$KCBOBH 31016 2013/8/16 9:32
X$KCBMMAV 0 2013/8/16 9:32
X$KCBLSC 64 2013/8/16 9:32
X$KCBPINTIME 2048 2013/8/16 9:32
X$KCBSC 21 2013/8/16 9:32
X$KCBSDS 32 2013/8/16 9:32
X$KCBOQH 1849 2013/8/16 9:32
X$KCBBHS 0 2013/8/16 9:32
X$KCBBES 19 2013/8/16 9:32
X$KCBKWRL 1 2013/8/16 9:32
X$KCBKPFS 400 2013/8/16 9:32
X$KCBBF 3000 2013/8/16 9:32
X$KCBFWAIT 400 2013/8/16 9:32
X$KAUVRSTAT 1 2013/8/16 9:32
X$KBRPSTAT 5 2013/8/16 9:32
X$KCBLDRHIST 1000 2013/8/16 9:32
X$K2GTE2 0 2013/8/16 9:32
X$KCBDWS 1 2013/8/16 9:32
X$KCBDWOBJ 0 2013/8/16 9:32
X$KCBFCIO 0 2013/8/16 9:32
X$KCBDBK 1 2013/8/16 9:32
X$K2GTE 0 2013/8/16 9:32
X$IR_RS_PARAM 0 2013/8/16 9:32
X$JSKJOBQ 1 2013/8/16 9:32
X$JSKSLV 0 2013/8/16 9:32
X$JSKMIMRT 0 2013/8/16 9:32
X$IR_WR_PARAM 0 2013/8/16 9:32
X$IR_WORKING_FAILURE_SET 0 2013/8/16 9:32
X$IR_WORKING_REPAIR_SET 0 2013/8/16 9:32
X$IR_REPAIR_OPTION 0 2013/8/16 9:32
X$IR_REPAIR_STEP 0 2013/8/16 9:32
X$IR_WF_PARAM 0 2013/8/16 9:32
X$JSKMIMMD 0 2013/8/16 9:32
X$GIMSA 24 2013/8/16 9:32
X$INSTANCE_CACHE_TRANSFER 0 2013/8/16 9:32
X$ESTIMATED_MTTR 1 2013/8/16 9:32
X$GLOBALCONTEXT 0 2013/8/16 9:32
X$HEATMAPSEGMENT 19 2013/8/16 9:32
X$IR_MANUAL_OPTION 0 2013/8/16 9:32
X$HOFP 0 2013/8/16 9:32
X$IEE 0 2013/8/16 9:32
X$IEE_ORPIECE 0 2013/8/16 9:32
X$IEE_CONDITION 0 2013/8/16 9:32
X$DURABLE_SHARDED_SUBS 0 2013/8/16 9:32
X$HS_SESSION 0 2013/8/16 9:32
X$DRM_HISTORY 0 2013/8/16 9:32
X$DRM_HISTORY_STATS 0 2013/8/16 9:32
X$DNFS_STATS 0 2013/8/16 9:32
X$DUAL 1 2013/8/16 9:32
X$DRA_FAILURE 75 2013/8/16 9:32
X$DRA_FAILURE_PARAM 189 2013/8/16 9:32
X$DRA_FAILURE_REPAIR_MAP 116 2013/8/16 9:32
X$DRA_REPAIR_PARAM 73 2013/8/16 9:32
X$DRA_FAILURE_REPAIR 264 2013/8/16 9:32
X$DRA_FAILURE_CHECK 53 2013/8/16 9:32
X$DRA_FAILURE_CHECK_MAP 107 2013/8/16 9:32
X$DRA_FAILURE_PARENT_MAP 11 2013/8/16 9:32
X$DRA_REPAIR 112 2013/8/16 9:32
X$DNFS_FILES 0 2013/8/16 9:32
X$DNFS_CHANNELS 0 2013/8/16 9:32
X$DNFS_HIST 0 2013/8/16 9:32
X$DNFS_SERVERS 0 2013/8/16 9:32
X$DNFS_META 1 2013/8/16 9:32
X$DIAG_INFO 11 2013/8/16 9:32
X$DGLPARAM 36 2013/8/16 9:32
X$DGLXDAT 0 2013/8/16 9:32
X$DBKRECO 0 2013/8/16 9:32
X$DBKRUN 6 2013/8/16 9:32
X$DIR 15 2013/8/16 9:32
X$DBKINCMETCFG 1 2013/8/16 9:32
X$DBKINCMETSUMMARY 1 2013/8/16 9:32
X$DBKINCMETINFO 0 2013/8/16 9:32
X$DBKEFEFC 18 2013/8/16 9:32
X$DBKH_CHECK_PARAM 63 2013/8/16 9:32
X$DBKFDG 20 2013/8/16 9:32
X$DBKFSET 0 2013/8/16 9:32
X$DBKINFO 51 2013/8/16 9:32
X$DBKH_CHECK 38 2013/8/16 9:32
X$DBKEFIEFC 512 2013/8/16 9:32
X$CON_KSLSCS 13 2013/8/16 9:32
X$CON_KSLEI 1567 2013/8/16 9:32
X$CON_KSUSGSTA 839 2013/8/16 9:32
X$CKPTBUF 25664 2013/8/16 9:32
X$CONTEXT 0 2013/8/16 9:32
X$CON 1 2013/8/16 9:32
X$CON_KEWSSYSV 34 2013/8/16 9:32
X$DBKEFAFC 7 2013/8/16 9:32
X$DBKEFDEAFC 0 2013/8/16 9:32
X$DBKECE 40 2013/8/16 9:32
X$CELL_NAME 0 2013/8/16 9:32
X$BUFFERED_SUBSCRIBERS 0 2013/8/16 9:32
X$BH 33749 2013/8/16 9:32
X$BMAPNONDURSUB 32 2013/8/16 9:32
X$BUFFER 0 2013/8/16 9:32
X$BUFFERED_PUBLISHERS 0 2013/8/16 9:32
X$BUFFER2 0 2013/8/16 9:32
X$BUFFERED_QUEUES 0 2013/8/16 9:32
X$AUD_OBJ_ACTIONS 19 2013/8/16 9:32
X$AUD_XS_ACTIONS 48 2013/8/16 9:32
X$AUD_OLS_ACTIONS 19 2013/8/16 9:32
X$ASH 581 2013/8/16 9:32
X$AUD_DP_ACTIONS 4 2013/8/16 9:32
X$AUD_DPAPI_ACTIONS 3 2013/8/16 9:32
X$AUD_DV_OBJ_EVENTS 14 2013/8/16 9:32
X$ACTIVECKPT 9 2013/8/16 9:32
X$ABSTRACT_LOB 1 2013/8/16 9:32
X$AQ_SUBSCRIBER_LOAD 0 2013/8/16 9:32
X$QESRSTATALL 7137 2013/8/16 9:32
X$QESRSTAT 0 2013/8/16 9:32
X$QESRCOBJ 0 2013/8/16 9:32
X$QESRCMEM 0 2013/8/16 9:32
X$QESRCDEP 0 2013/8/16 9:32
X$QESRCMSG 0 2013/8/16 9:32
X$QESRCDR 0 2013/8/16 9:32
X$QESRCSTA 13 2013/8/16 9:32
X$QESRCRR 0 2013/8/16 9:32
X$QESMMSGA 38 2013/8/16 9:32
X$QESMMIWT 0 2013/8/16 9:32
X$QESMMIWH 33 2013/8/16 9:32
X$QESMMAPADV 14 2013/8/16 9:32
X$QESRCRD 0 2013/8/16 9:32
X$KQLSET 2689 2013/8/16 9:32
X$QESBLSTAT 20 2013/8/16 9:32
X$QESMMAHIST 462 2013/8/16 9:32
X$KQLFXPL 7099 2013/8/16 9:32
X$KQLFSQCE 714215 2013/8/16 9:32
X$KKSSRD 1720 2013/8/16 9:32
X$KKSSQLSTAT 2956 2013/8/16 9:32
X$KQLFBC 2281 2013/8/16 9:32
X$KKSAI 0 2013/8/16 9:32
X$KKSCS 1704 2013/8/16 9:32
X$KKSBV 2281 2013/8/16 9:32
X$KGLXS 4253 2013/8/16 9:32
X$KGLTR 750 2013/8/16 9:32
X$KGLSIM 18 2013/8/16 9:32
X$KGLOB 15849 2013/8/16 9:32
X$KGLRD 6578 2013/8/16 9:32
X$KGLST 269 2013/8/16 9:32
X$KGLSN 37 2013/8/16 9:32
X$KGLPN 29 2013/8/16 9:32
X$KGLNA1 53213 2013/8/16 9:32
X$KGLLK 436 2013/8/16 9:32
X$KGLAU 478 2013/8/16 9:32
X$KGLDP 5312 2013/8/16 9:32
X$KGLNA 53196 2013/8/16 9:32
X$KGLJSIM 10 2013/8/16 9:32
X$KGLMEM 126 2013/8/16 9:32
X$KGLJMEM 126 2013/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
Filed Under: Oracle, Oracle SQL性能调优

Comments

  1. Ask_Maclean_liu_Oracle says
    2013/08/16 at 10:17

    /* Formatted on 2013/8/16 10:16:25 (QP5 v5.163.1008.3004) *//* SQL Analyze(0) */SELECT /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl no_substrb_pad */ TO_CHAR ( COUNT (“ADDR”)), TO_CHAR (SUBSTRB (DUMP (MIN (“ADDR”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“ADDR”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“INDX”)), TO_CHAR (SUBSTRB (DUMP (MIN (“INDX”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“INDX”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“INST_ID”)), TO_CHAR (SUBSTRB (DUMP (MIN (“INST_ID”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“INST_ID”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“CON_ID”)), TO_CHAR (SUBSTRB (DUMP (MIN (“CON_ID”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“CON_ID”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“OBJ#_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“OBJ#_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“OBJ#_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“COL#_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“COL#_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“COL#_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“BUCKET_CNT_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“BUCKET_CNT_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“BUCKET_CNT_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“ROW_CNT_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“ROW_CNT_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“ROW_CNT_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“CACHE_CNT_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“CACHE_CNT_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“CACHE_CNT_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“NULL_CNT_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“NULL_CNT_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“NULL_CNT_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“TIMESTAMP#_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“TIMESTAMP#_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“TIMESTAMP#_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“SAMPLE_SIZE_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“SAMPLE_SIZE_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“SAMPLE_SIZE_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“MINIMUM_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“MINIMUM_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“MINIMUM_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“MAXIMUM_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“MAXIMUM_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“MAXIMUM_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“DISTCNT_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“DISTCNT_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“DISTCNT_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“LOWVAL_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“LOWVAL_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“LOWVAL_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“HIVAL_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“HIVAL_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“HIVAL_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“DENSITY_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“DENSITY_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“DENSITY_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“INTCOL#_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“INTCOL#_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“INTCOL#_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“SPARE1_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“SPARE1_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“SPARE1_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“SPARE2_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“SPARE2_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“SPARE2_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (COUNT (“AVGCLN_KXTTST_CS”)), TO_CHAR (SUBSTRB (DUMP (MIN (“AVGCLN_KXTTST_CS”), 16, 0, 64), 1, 240)), TO_CHAR (SUBSTRB (DUMP (MAX (“AVGCLN_KXTTST_CS”), 16, 0, 64), 1, 240)) FROM “SYS”.”X$KXTTSTECS” t /* NDV,NIL,NIL,ACL,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL*/

    回复

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号