January 15, 2013

详解dbms_stats.gather_fixed_objects_stats

作者 · 阅读 16 分钟

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

这位作者还没有填写简介。

查看所有文章

1 条评论

Ask_Maclean_liu_Oracle August 16, 2013

/* 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*/

Reply

ASKMACLEAN

详解dbms_stats.gather_fixed_objects_stats

1 条评论

发表评论取消回复

【Oracle RAC调优】RAC多节点使用不同的gcs_server_processes参数可能导致gc cr multi block request等待事件

Oracle ACE谈ACE的价值

Oracle Recover Database until SCN小窍门

1 条评论

发表评论 取消回复

发表评论取消回复