WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
TEST1	3165260276	TEST1	1	10.2.0.3.0	NO	labj201

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1085	21-Jun-07 06:00:35	58	2.5
End Snap:	1097	21-Jun-07 18:00:33	61	4.7
Elapsed:		719.96 (mins)
DB Time:		83.63 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	416M	416M	Std Block Size:	8K
Shared Pool Size:	784M	784M	Log Buffer:	14,356K

Load Profile

	Per Second	Per Transaction
Redo size:	10,905.37	13,913.18
Logical reads:	830.11	1,059.06
Block changes:	62.42	79.63
Physical reads:	71.30	90.97
Physical writes:	1.72	2.20
User calls:	7.48	9.54
Parses:	11.63	14.84
Hard parses:	0.79	1.00
Sorts:	3.07	3.91
Logons:	0.03	0.04
Executes:	19.60	25.01
Transactions:	0.78

% Blocks changed per Read:	7.52	Recursive Call %:	93.87
Rollback per transaction %:	0.03	Rows per Sort:	187.31

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.85	Redo NoWait %:	100.00
Buffer Hit %:	91.42	In-memory Sort %:	100.00
Library Hit %:	92.60	Soft Parse %:	93.24
Execute to Parse %:	40.65	Latch Hit %:	99.21
Parse CPU to Parse Elapsd %:	19.74	% Non-Parse CPU:	92.83

Shared Pool Statistics

	Begin	End
Memory Usage %:	63.93	49.37
% SQL with executions>1:	96.81	97.22
% Memory for SQL w/exec>1:	96.75	96.02

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		1,509		30.1
db file scattered read	154,959	841	5	16.8	User I/O
latch: library cache	1,707	416	244	8.3	Concurrency
latch: shared pool	1,965	389	198	7.8	Concurrency
db file sequential read	112,975	368	3	7.3	User I/O

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Buffer Pool Statistics
• Advisory Statistics
• Wait Statistics
• Undo Statistics
• Latch Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Memory Statistics
• Streams Statistics
• Resource Limit Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Wait Class
• Wait Events
• Background Wait Events
• Operating System Statistics
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 5017.7s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Wait Class

• s - second
• cs - centisecond - 100th of a second
• ms - millisecond - 1000th of a second
• us - microsecond - 1000000th of a second
• ordered by wait time desc, waits desc

Back to Wait Events Statistics
Back to Top

Wait Events

• s - second
• cs - centisecond - 100th of a second
• ms - millisecond - 1000th of a second
• us - microsecond - 1000000th of a second
• ordered by wait time desc, waits desc (idle events last)

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in centisecond (100th of a second)

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• Total Buffer Gets: 35,858,706
• Captured SQL account for 90.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 3,080,040
• Captured SQL account for 92.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 846,761
• Captured SQL account for 51.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 502,551
• Captured SQL account for 56.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0my7d3vw6q68k	INSERT INTO SYSTEM.AQ$_INTERNET_AGENTS (AGENT_NAME, PROTOCOL, SPARE1) VALUES (:B2 , :B1 , NULL)
1sdncrnq37hjm	/* OracleOEM */ SELECT /*+ INDEX(ts) */ o.object_type, u.name, o.object_name, o.partition, o.lob_column, o.seg_type, ts.name, 4 FROM ( SELECT 1 "OBJECT_TYPE", o.owner# "USER_NAME#", o.name "OBJECT_NAME", ' ' "PARTITION", ' ' "LOB_COLUMN", 1 "SEG_TYPE", t.ts# "TABLESPACE#" FROM sys.obj$ o, sys.tab$ t, sys.seg$ s WHERE o.obj# = t.obj# AND t.ts# in (:1, :2) AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND decode (bitand (t.property, 1), 1, 1, 0) = 0 AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 AND decode (bitand (t.property, 1024), 1024, 1, 0) = 0 UNION ALL SELECT 2, o.owner#, o.name, ' ', ' ', 2, i.ts# FROM sys.obj$ o, sys.ind$ i, sys.seg$ s WHERE o.obj# = i.obj# AND i.ts# in (:1, :2) AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# not in (4, 8) UNION ALL SELECT 3, o.owner#, o.name, ' ', ' ', 12, c.ts# FROM sys.obj$ o, sys.clu$ c, sys.seg$ s WHERE o.obj# = c.obj# AND c.ts# IN (:1, :2) AND c.file# = s.file# AND c.block# = s.block# AND c.ts# = s.ts# UNION ALL SELECT 1, o.owner#, tn.name, ' ', ' ', 1, i.ts# FROM sys.obj$ o, sys.seg$ s, sys.tab$ t, sys.obj$ tn, sys.ind$ i WHERE o.obj# = i.obj# AND i.ts# IN ( :1, :2) AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND i.bo# = tn.obj# AND tn.obj# = t.obj# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# = 4 UNION ALL SELECT 1, o.owner#, o.name, o.subname, ' ', 3, tp.ts# FROM sys.obj$ o, sys.seg$ s, sys.tab$ t, sys.tabpart$ tp WHERE o.obj# = tp.obj# AND tp.ts# IN (:1, :2) AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 UNION ALL SELECT 2, o.owner#, o.name, o.subname, ' ', 4, ip.ts# FROM sys.obj$ o, sys.seg$ s, sys.ind$ i, sys.indpart$ ip WHERE o.obj# = ip.obj# AND ip.ts# IN (:1, :2) AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# not in (4, 8) UNION ALL SELECT 1, o.owner#, tn.name, ' ', ' ', 5, t.ts# FROM sys.obj$ o, sys.seg$ s, sys.tab$ t, sys.obj$ tn, sys.tab$ iot WHERE o.obj# = t.obj# AND t.ts# IN (:1, :2) AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND tn.obj# = t.bobj# AND tn.obj# = iot.obj# AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 UNI ON ALL SELECT 1, tn.owner#, tn.name, ' ', decode(bitand(c.property, 1), 1, ac.name, c.name), 8, l.ts# FROM sys.seg$ s, sys.obj$ tn, sys.attrcol$ ac, sys.col$ c, sys.lob$ l WHERE tn.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.ts# IN (:1, :2) AND l.file# = s.file# AND l.block# = s.block# AND l.ts# = s.ts# AND c.obj# = ac.obj#(+) AND c.intcol# = ac.intcol#(+) AND bitand(c.property, 32768) != 32768 UNION ALL SELECT 1, o.owner#, tn.name, o.subname, ' ', 3, ip.ts# FROM sys.seg$ s, sys.obj$ o, sys.ind$ i, sys.obj$ tn, sys.indpart$ ip WHERE o.obj# = ip.obj# AND ip.ts# IN (:1, :2) AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# = 4 AND i.bo# = tn.obj# UNION ALL SELECT 1, o.owner#, tbo.name, o.subname, ' ', 13, tp.ts# FROM sys.seg$ s, sys.obj$ o, sys.obj$ tbo, sys.tab$ t, sys.tabpart$ tp WHERE o.obj# = tp.obj# AND tp.ts# IN (:1, :2) AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 32), 32, 1, 0) = 1 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 AND tbo.obj# = t.bobj# UNION ALL SELECT 1, tbo.owner#, tbo.name, po.subname, decode(bitand(c.property, 1), 1, a.name , c.name), 8, lf.ts# FROM sys.seg$ s, sys.obj$ tbo, sys.attrcol$ a, sys.col$ c, sys.lob$ l, sys.obj$ po, sys.partobj$ pobj, sys.lobfrag$ lf WHERE pobj.obj# = tbo.obj# AND lf.ts# IN (:1, :2) AND lf.file# = s.file# AND lf.block# = s.block# AND lf.ts# = s.ts# AND mod(pobj.spare2, 256) = 0 AND tbo.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.lobj# = lf.parentobj# AND lf.tabfragobj# = po.obj# AND bitand(c.property, 32768) != 32768 AND c.obj# = a.obj#(+) AND c.intcol# = a.intcol#(+) UNION ALL SELECT 1, o.owner#, bo.name, o.subname, ' ', 9, tsp.ts# FROM sys.seg$ s, sys.obj$ o, sys.obj$ bo, sys.tabsubpart$ tsp WHERE o.obj# = tsp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 2 AND tsp.file# = s.file# AND tsp.block# = s.block# AND tsp.ts# IN (:1, :2) UNION ALL SELECT 2, o.owner#, bo.name, o.subname, ' ', 10, isp.ts# FROM sys.seg$ s, sys.obj$ o, sys.obj$ bo, sys.indsubpart$ isp WHERE o.obj# = isp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 1 AND isp.file# = s.file# AND isp.block# = s.block# AND isp.ts# IN (:1, :2) ) o, sys.ts$ ts, sys.user$ u WHERE o.USER_NAME# = u.user# AND u.name NOT IN ('SYS', 'SYSTEM', 'SYSMAN', 'CTXSYS', 'MDSYS', 'ORDSYS', 'ORDPLUGINS', 'OLAPSYS', 'DBSNMP', 'MGMT_VIEW', 'OUTLN', 'ANONYMOUS', 'DMSYS', 'EXFSYS', 'LBACSYS', 'SI_INFORMTN_SCHEMA', 'SYSMAN', 'WKPROXY', 'WKSYS', 'WK_TEST', 'WMSYS', 'XDB', 'TRACESVR', 'SCOTT', 'ADAMS', 'BLAKE', 'CLARK', 'JONES', 'HR', 'TSMSYS') AND o.TABLESPACE# = ts.ts# AND ts.ts# IN (:1, :2) AND rownum < 201
1xjy321by1vz6	SELECT A.PRCSINSTANCE FROM PS_CDM_LIST A, PSPRCSQUE Q WHERE A.DISTSTATUS = :1 AND A.TRANSFERINSTANCE = 0 AND A.PRCSINSTANCE = Q.PRCSINSTANCE AND Q.SERVERNAMERUN = :2
1z1cgxqh3b878	begin sys.dbms_stats.gather_dictionary_stats('EM'); end;
34cf2xyy8ubzx	BEGIN emd_database.set_default_metric_preferences( mgmt_user.wildcard_user_name_alias, mgmt_user.user_created_callback); MGMT_TARGET.register_target_type(MGMT_GLOBAL.G_DATABASE_TARGET_TYPE, 'Database Instance', 'name', NULL, 'oracle.sysman.db.rsc'); MGMT_TARGET.register_target_type(MGMT_GLOBAL.G_RAC_DATABASE_TARGET_TYPE, 'Cluster Database', 'rac_database_name', NULL, 'oracle.sysman.db.rsc'); END;
3xua7cgdv0ghr	SELECT /*+ ordered */ 'TABLE' OBJ_TYPE, U.NAME OWN, O.NAME TAB, NULL PART, NULL SPART, BITAND(T.TRIGFLAG, 67108864 + 134217728) LOCK_FLAGS FROM SYS.TAB$ T, SYS.OBJ$ O, SYS.USER$ U WHERE (:B5 IS NOT NULL) AND ((:B4 IS NULL) OR (U.NAME = :B4 )) AND ((:B3 IS NOT NULL) OR (U.NAME != 'SYS')) AND BITAND(T.PROPERTY, 512) != 512 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.PROPERTY, 2147483648) != 2147483648 AND BITAND(O.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME = 'SUMDELTA$') AND ((:B2 IS NOT NULL) OR (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608)) AND BITAND(T.FLAGS, 16) != 16 AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND (:B1 = 0 OR BITAND(T.TRIGFLAG, :B1 ) != :B1 ) UNION ALL SELECT /*+ ordered */ 'TABLE' OBJ_TYPE, U.NAME OWN, O.NAME TAB, O.SUBNAME PART, NULL SPART, BITAND(T.TRIGFLAG, 67108864 + 134217728) LOCK_FLAGS FROM (SELECT OBJ#, BO#, FLAGS FROM SYS.TABPART$ WHERE BITAND(FLAGS, 2) != 2 AND (:B1 = 0 OR BITAND(FLAGS, 32) != 32) UNION ALL SELECT OBJ#, BO#, FLAGS FROM SYS.TABCOMPART$ TCP WHERE BITAND(FLAGS, 2) != 2 AND (:B1 = 0 OR BITAND(FLAGS, 32) != 32) ) TP, SYS.OBJ$ O, SYS.USER$ U, SYS.TAB$ T, SYS.OBJ$ OT WHE RE (:B6 IS NOT NULL) AND ((:B4 IS NULL) OR (U.NAME = :B4 )) AND ((:B3 IS NOT NULL) OR (U.NAME != 'SYS')) AND TP.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TP.BO# = T.OBJ# AND T.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND BITAND(T.PROPERTY, 512) != 512 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND (:B1 = 0 OR BITAND(T.TRIGFLAG, :B1 ) != :B1 ) UNION ALL SELECT /*+ ordered */ 'TABLE' OBJ_TYPE, U.NAME OWN, O.NAME TAB, OP.SUBNAME PART, O.SUBNAME SPART, BITAND(T.TRIGFLAG, 67108864 + 134217728) LOCK_FLAGS FROM SYS.TABSUBPART$ TSP, SYS.OBJ$ O, SYS.USER$ U, SYS.OBJ$ OP, SYS.TABCOMPART$ TCP, SYS.TAB$ T, SYS.OBJ$ OT, SYS.PARTOBJ$ PO WHERE ((:B4 IS NULL) OR (U.NAME = :B4 )) AND ((:B3 IS NOT NULL) OR (U.NAME != 'SYS')) AND BITAND(TSP.FLAGS, 2) != 2 AND T.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND TSP.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TSP.POBJ# = OP.OBJ# AND TCP.OBJ# = TSP.POBJ# AND TCP.BO# = T.OBJ# AND PO.OBJ# = T.OBJ# AND ((:B8 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND (:B1 = 0 OR (BITAND(TCP.FLAGS, 32) != 32 AND BITAND(T.TRIGFLAG, :B1 ) != :B1 )) UNION ALL SELECT * FROM ( SELECT /*+ ordered */ 'INDEX' OBJ_TYPE, U.NAME OWN, O.NAME TAB, NULL PART, NULL SPART, CASE WHEN I. TYPE# = 3 THEN (SELECT /*+ index(t) */ DECODE(SUM(BITAND(TRIGFLAG, 67108864)), 0, 0, 67108864) + DECODE(SUM(BITAND(TRIGFLAG, 134217728)), 0, 0, 134217728) FROM SYS.TAB$ T WHERE T.BOBJ# = I.BO#) ELSE (SELECT /*+ index(t) */ BITAND(TRIGFLAG, 67108864 + 134217728) FROM SYS.TAB$ T WHERE T.OBJ# = I.BO#) END LOCK_FLAGS FROM SYS.IND$ I, SYS.OBJ$ O, SYS.USER$ U WHERE (:B9 IS NOT NULL) AND (:B5 IS NOT NULL) AND ((:B4 IS NULL) OR (U.NAME = :B4 )) AND ((:B3 IS NOT NULL) OR (U.NAME != 'SYS')) AND ((:B2 IS NOT NULL) OR BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64) AND BITAND(I.FLAGS, 2) != 2 AND BITAND(O.FLAGS, 128) != 128 AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') AND I.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 ) WHERE :B1 = 0 OR BITAND(LOCK_FLAGS, :B1 ) != :B1 UNION ALL SELECT /*+ ordered */ 'INDEX' OBJ_TYPE, U.NAME OWN, O.NAME TAB, O.SUBNAME PART, NULL SPART, BITAND(T.TRIGFLAG, 67108864 + 134217728) LOCK_FLAGS FROM (SELECT OBJ#, BO#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) IP, SYS.OBJ$ O, SYS.USER$ U, SYS.IND$ I, SYS.OBJ$ OI, SYS.TAB$ T WHERE (:B9 IS NOT NULL) AND (:B6 IS NOT NULL) AND ((:B4 IS NULL) OR (U.NAME = :B4 )) AND ((:B3 IS NOT NULL) OR (U.NAME != 'SYS')) AND I.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 AND IP.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND IP.BO# = I.OBJ# AND I.BO# = T.OBJ# AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND (:B1 = 0 OR BITAND(T.TRIGFLAG, :B1 ) != :B1 ) UNION ALL SELECT /*+ ordered */ 'INDEX' OBJ_TYPE, U.NAME OWN, O.NAME TAB, OP.SUBNAME PART, O.SUBNAME SPART, BITAND(T.TRIGFLAG, 67108864 + 134217728) LOCK_FLAGS FROM SYS.INDSUBPART$ ISP, SYS.OBJ$ O, SYS.USER$ U, SYS.OBJ$ OP, SYS.INDCOMPART$ ICP, SYS.IND$ I, SYS.OBJ$ OI, SYS.TAB$ T, SYS.PARTOBJ$ PO WHERE (:B9 IS NOT NULL) AND ((:B4 IS NULL) OR (U.NAME = :B4 )) AND ((:B3 IS NOT NULL) OR (U.NAME != 'SYS')) AND BITAND(ISP.FLAGS, 2) != 2 AND I.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 AND ISP.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND ISP.POBJ# = OP.OBJ# AND ISP.POBJ# = ICP.OBJ# AND ICP.BO# = I.OBJ# AND I.BO# = T.OBJ# AND PO.OBJ# = T.OBJ# AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND ((:B8 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND (:B1 = 0 OR BITAND(T.TRIGFLAG, :B1 ) != :B1 ) UNION ALL SELECT /*+ use_hash(fxt, fobj) */ 'TABLE' OBJ_TYPE, 'SYS' OWN, FXT.KQFTANAM TAB, NULL PART, NULL SPART, BITAND(FOBJ.FLAGS, 67108864 + 134217728) LOCK_FLAGS FROM SYS.X$KQFTA FXT, FIXED_OBJ$ FOBJ, X$KQFOPT OPT WHERE :B10 IS NOT NULL AND ((:B4 IS NULL) OR (:B4 = 'SYS')) AND FOBJ.OBJ# = FXT.KQFTAOBJ AND BITAND(FOBJ.FLAGS, 1) != 1 AND (:B1 = 0 OR BITAND(FOBJ.FLAGS, :B1 ) != :B1 ) AND FOBJ.OBJ# = OPT.KQFOPTOBJ(+) AND (OPT.KQFOPTFLAGS IS NULL OR BITAND(OPT.KQFOPTFLAGS, 16+32) = 0) ORDER BY 1 DESC, 2, 3, 4 DESC, 5 DESC
52zszr0crb9dt	INSERT INTO MGMT_COLLECTION_PROPERTIES(COLL_NAME, METRIC_GUID, PROPERTY_NAME, PROPERTY_VALUE, TARGET_GUID) VALUES ( NVL(:1, ' '), :2, :3, :4, :5)
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5g1j4107kftk4	SELECT "PROJECTNAME", "OBJECTTYPE", "OBJECTVALUE1", "OBJECTVALUE2", "OBJECTVALUE3", "OBJECTVALUE4" FROM "PSPROJECTITEM" "A" WHERE SUBSTR("PROJECTNAME", 4, 4)=:1 AND SUBSTR("PROJECTNAME", 1, 3) LIKE 'CMR%' AND "OBJECTTYPE"<>22
5t480bb4uh8hw	delete from source$ where obj#=:1
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6hvaxy5704uxz	UPDATE PS_CM_DEPLETE SET VCHR_BUILD_STATUS = 'I', PROC_INSTANCE_AP = 1014397 WHERE VCHR_BUILD_STATUS IN ('T', 'E') AND EXISTS ( SELECT 'X' FROM PS_VCHR_BLD_BUAP BUAP WHERE PS_CM_DEPLETE.BUSINESS_UNIT = BUAP.BUSINESS_UNIT_IN AND BUAP.PROCESS_INSTANCE = 1014397)
6twr6365nakgn	SELECT DISTINCT B.TREE_NODE , Z.RECDESCR FROM PSTREEDEFN A , PSTREENODE B , PS_SCRTY_ACC_GRP C , PSTREENODE E , PSROLECLASS X , PSROLEUSER Y , PSRECDEFN Z WHERE A.SETID=' ' AND A.TREE_STRCT_ID='ACCESS_GROUP' AND A.EFF_STATUS='A' AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSTREEDEFN D WHERE D.SETID=' ' AND D.TREE_NAME=A.TREE_NAME AND D.EFFDT<=TO_DATE(TO_CHAR(SYSDATE, 'YYYY-MM-DD'), 'YYYY-MM-DD')) AND Y.ROLEUSER='SPULCHEO' AND Y.ROLENAME=X.ROLENAME AND X.CLASSID = C.CLASSID AND C.TREE_NAME=A.TREE_NAME AND C.ACCESSIBLE='Y' AND B.SETID=' ' AND B.TREE_NAME=E.TREE_NAME AND B.EFFDT=E.EFFDT AND B.TREE_NODE_TYPE='R' AND B.TREE_NODE=Z.RECNAME AND Z.RECTYPE IN (0, 1, 6) AND E.SETID=' ' AND E.TREE_NAME=A.TREE_NAME AND E.EFFDT=A.EFFDT AND E.TREE_NODE_TYPE='G' AND B.TREE_NODE_NUM BETWEEN E.TREE_NODE_NUM AND E.TREE_NODE_NUM_END AND C.ACCESS_GROUP=E.TREE_NODE AND ((NOT EXISTS ( SELECT 'X' FROM PS_SCRTY_ACC_GRP F WHERE F.CLASSID=X.CLASSID AND F.TREE_NAME=A.TREE_NAME AND F.ACCESSIBLE='N')) OR (E.TREE_NODE_NUM = ( SELECT MAX(G.TREE_NODE_NUM) FROM PSTREENODE G , PS_SCRTY_ACC_GRP H WHERE G.SETID=' ' AND G.TREE_NAME=A.TREE_NAME AND G.EFFDT=A.EFFDT AND G.TREE_NODE_TYPE='G' AND B.TREE_NODE_NUM BETWEEN G.TREE_NODE_NUM AND G.TREE_NODE_NUM_END AND H.CLASSID=X.CLASSID AND H.TREE_NAME=A.TREE_NAME AND H.ACCESS_GROUP=G.TREE_NODE)))
6w76kmm9k6rry	INSERT INTO MGMT_TARGET_TYPES (TARGET_TYPE, TYPE_DISPLAY_NAME, TYPE_DISPLAY_NLSID, TYPE_RESOURCE_BUNDLE) VALUES (:B4 , :B3 , :B2 , :B1 )
7gtztzv329wg0	select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
83c1surm0xhcg	select u.name, o.name, o.obj# from obj$ o, user$ u, ind$ i where o.owner#=:1 and o.owner#=u.user# and o.obj#=i.obj# and i.type#=9
84xjjg8y1auqs	SELECT TRANSFERINSTANCE, TRANSFERATTEMPTCNT, TRANSFERSTATUS FROM PS_CDM_TRANSFER WHERE SERVERNAMERUN = :1 AND TRANSFERSTATUS NOT IN ('0', '2') AND NEXTTRANSFERDTTM <= SYSDATE AND TRANSFERATTEMPTCNT <= :2 UNION SELECT TRANSFERINSTANCE, TRANSFERATTEMPTCNT, TRANSFERSTATUS FROM PS_CDM_TRANSFER WHERE SERVERNAMERUN = :3 AND TRANSFERSTATUS IN ('0', '2') AND NEXTTRANSFERDTTM <= TO_DATE(SUBSTR(:4, 0, 19), 'YYYY-MM-DD-HH24.MI.SS')
89qyn4bbt03jq	SELECT /*+ USE_HASH(f a) */ SUM(NVL(F.BYTES - NVL(A.BYTES, 0), 0)/1024/1024), SUM(NVL(F.BYTES, 0)/1024/1024) FROM (SELECT DISTINCT TABLESPACE_NAME FROM USER_TABLES) U, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) F, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) A WHERE A.TABLESPACE_NAME = U.TABLESPACE_NAME AND F.TABLESPACE_NAME = U.TABLESPACE_NAME
8a1pvy4cy8hgv	insert into histgrm$(obj#, intcol#, row#, bucket, endpoint, col#, epvalue) values(:1, :2, :3, :4, :5, :6, :7)
8p23kcbgfqnk4	select file#, block#, ts# from seg$ where type# = 3
8txwj6xpfk41s	INSERT INTO PS_SERVERACTVTY (SERVERNAME, SERVERACTIVITYTYPE, SERVERSTATE, LASTUPDDTTM) VALUES (:1, :2, :3, SYSDATE)
8uxr3scz9bmxd	/* OracleOEM */ BEGIN :succ_sub := 0; dbms_aqadm.create_aq_agent(:subscriber); :succ_sub := 1; EXCEPTION WHEN OTHERS THEN IF SQLCODE = -24089 THEN NULL; ELSE RAISE; END IF; END;
8zphhf7nj64th	select name, type#, obj#, remoteowner, linkname, namespace, subname from obj$ where owner#=:1 and type# = 13
92aqp0tx358gy	SELECT TRANSFERINSTANCE, TRANSFERATTEMPTCNT, TRANSFERSTATUS FROM PS_CDM_TRANSFER WHERE SERVERNAMERUN = :1 AND TRANSFERSTATUS IN ('2') AND NEXTTRANSFERDTTM <= SYSDATE AND TRANSFERATTEMPTCNT <= :2
95pp6np95g679	INSERT INTO PS_PST_VCHR2_TAO4 (PROCESS_INSTANCE, BUSINESS_UNIT, VOUCHER_ID, ENTRY_STATUS, DOC_TYPE, DOC_SEQ_DATE, DOC_SEQ_NBR, DOC_SEQ_STATUS, INVOICE_ID, INVOICE_DT, VENDOR_ID, VENDOR_SETID, VOUCHER_TYPE, ADDRESS_SEQ_NUM, REMIT_ADDR_SEQ_NUM, GRP_AP_ID, ORIGIN, CNTRCT_ID, OPRID, CLOSE_STATUS, ACCOUNTING_DT, POST_VOUCHER, POST_STATUS_AP, BUSINESS_UNIT_GL, PROCESS_MAN_CLOSE, DST_CNTRL_ID, GROSS_AMT, PAY_AMT, PAY_AMT_BASE, GROSS_AMT_BSE, FOREIGN_CURRENCY, RT_TYPE, RATE_MULT, RATE_DIV, CUR_RT_SOURCE, BASE_CURRENCY, MERCHANDISE_AMT, MERCH_AMT_BSE, DSCNT_AMT, DSCNT_AMT_BSE, DSCNT_PRORATE_FLG, USETAX_CD, USETAX_AMT, USETAX_AMT_BSE, USETAX_PRORATE_FLG, SALETX_CD, SALETX_AMT, SALETX_AMT_BSE, SALETX_PRORATE_FLG, FREIGHT_AMT, FREIGHT_AMT_BSE, FRGHT_PRORATE_FLG, MISC_AMT, MISC_AMT_BSE, VAT_BASIS_AMT, VAT_BASIS_AMT_BSE, VAT_CALC_AMT, VAT_CALC_AMT_BSE, VAT_INV_AMT, VAT_INV_AMT_BSE, VAT_NONINV_AMT, VAT_NONINV_AMT_BSE, VAT_RCVRY_AMT, VAT_RCVRY_AMT_BSE, BCM_HDR_STATUS, MANUAL_CLOSE_DT, TAX_CD_VAT, VAT_DCLRTN_POINT, VAT_CALC_TYPE, VAT_TXN_TYPE_CD, VAT_RECOVERY_PCT, VAT_CALC_GROSS_NET, VAT_RECALC_FLG, VAT_CALC_FRGHT_FLG, VAT_NRCVR_PRO_FLG, VAT_ENTITY, VAT_CF_ANLSYS_TYPE, VAT_DCLRTN_DT, DESCR254_MIXED, VNDR_AFFILIATE, CSD_NRCVRY_AMT, CSD_NRCVRY_AMT_BSE, CSD_RCVRY_AMT, CSD_RCVRY_AMT_BSE, EXD_RCVRY_AMT, EXD_RCVRY_AMT_BSE, EXD_NRCVRY_AMT, EXD_NRCVRY_AMT_BSE, FREIGHT_AMT_NP, FREIGHT_AMT_NP_BSE, MISC_AMT_NP, MI SC_AMT_NP_BSE, SALETX_AMT_NP, SALETX_AMT_NP_BSE, STX_NRCVRY_AMT, STX_NRCVRY_AMT_BSE, STX_RCVRY_AMT_BSE, STX_RCVRY_AMT, USETAX_AMT_NP, USETAX_AMT_NP_BSE) SELECT 1014398, BUSINESS_UNIT, VOUCHER_ID, ENTRY_STATUS, DOC_TYPE, DOC_SEQ_DATE, DOC_SEQ_NBR, DOC_SEQ_STATUS, INVOICE_ID, INVOICE_DT, VENDOR_ID, VENDOR_SETID, VOUCHER_TYPE, ADDRESS_SEQ_NUM, REMIT_ADDR_SEQ_NUM, GRP_AP_ID, ORIGIN, CNTRCT_ID, OPRID, CLOSE_STATUS, ACCOUNTING_DT, POST_VOUCHER, POST_STATUS_AP, BUSINESS_UNIT_GL, PROCESS_MAN_CLOSE, DST_CNTRL_ID, GROSS_AMT, PAY_AMT, PAY_AMT_BASE, GROSS_AMT_BSE, TXN_CURRENCY_CD, RT_TYPE, RATE_MULT, RATE_DIV, CUR_RT_SOURCE, BASE_CURRENCY, MERCHANDISE_AMT, MERCH_AMT_BSE, DSCNT_AMT, DSCNT_AMT_BSE, DSCNT_PRORATE_FLG, ' ', USETAX_AMT, USETAX_AMT_BSE, USETAX_PRORATE_FLG, ' ', SALETX_AMT, SALETX_AMT_BSE, SALETX_PRORATE_FLG, FREIGHT_AMT, FREIGHT_AMT_BSE, FRGHT_PRORATE_FLG, MISC_AMT, MISC_AMT_BSE, VAT_BASIS_AMT, VAT_BASIS_AMT_BSE, VAT_CALC_AMT, VAT_CALC_AMT_BSE, VAT_INV_AMT, VAT_INV_AMT_BSE, VAT_NONINV_AMT, VAT_NONINV_AMT_BSE, VAT_RCVRY_AMT, VAT_RCVRY_AMT_BSE, BCM_HDR_STATUS, MANUAL_CLOSE_DT, ' ', VAT_DCLRTN_POINT, VAT_CALC_TYPE, ' ', VAT_RECOVERY_PCT, VAT_CALC_GROSS_NET, VAT_RECALC_FLG, VAT_CALC_FRGHT_FLG, VAT_NRCVR_PRO_FLG, VAT_ENTITY, VAT_CF_ANLSYS_TYPE, VAT_DCLRTN_DT, DESCR254_MIXED, VNDR_AFFILIATE, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 FROM PS_VOUCHER WHERE BUSINE SS_UNIT = 'NGTEL' AND IN_PROCESS_FLG = 'N' AND ENTRY_STATUS = 'P' AND POST_VOUCHER IN ('P', 'D') AND (POST_STATUS_AP = 'U' OR PROCESS_MAN_CLOSE = 'Y') AND BUDGET_HDR_STATUS = 'V' AND BUDGET_MISC_STATUS = 'V' AND DOC_TOL_HDR_STATUS = 'V' AND VCHR_LINE_APPR IN ('0', '1') AND GRP_AP_ID NOT IN ( SELECT GRP_AP_ID FROM PS_GRP_AP WHERE BUSINESS_UNIT = 'NGTEL' AND POST_ACTION_AP = 'N') AND ACCOUNTING_DT <= TO_DATE('2006-12-31', 'YYYY-MM-DD')
96g93hntrzjtr	select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9qghv30224j0z	SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD-HH24.MI.SS."000000"') FROM PSCLOCK
9sk0xrz5kgfxc	select name, type#, obj#, remoteowner, linkname, namespace, subname from obj$ where owner#=:1 and type# = 10
9y7s2afnkqs9d	delete from idl_ub2$ where obj#=:1 and part=:2
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
bdntyxtax2smq	SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
cfz686a6qp0kg	select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#
cqunu31r51swu	SELECT R.PRCSINSTANCE , R.ORIGPRCSINSTANCE , R.JOBINSTANCE , R.MAINJOBINSTANCE , R.MAINJOBNAME , R.PRCSITEMLEVEL , R.PRCSJOBSEQ , R.PRCSJOBNAME , R.PRCSTYPE , R.PRCSNAME , R.PRCSPRTY , TO_CHAR(R.RUNDTTM, 'YYYY-MM-DD-HH24.MI.SS."000000"') , R.GENPRCSTYPE , R.OUTDESTTYPE , R.RETRYCOUNT , R.RESTARTENABLED , R.SERVERNAMERQST, R.OPSYS, R.SCHEDULENAME, R.PRCSCATEGORY, R.P_PRCSINSTANCE, C.PRCSPRIORITY , S.PRCSPRIORITY , R.PRCSWINPOP , R.MCFREN_URL_ID FROM PSPRCSQUE R , PS_SERVERCLASS S , PS_SERVERCATEGORY C WHERE R.RUNDTTM <= SYSDATE AND R.SERVERASSIGN = :1 AND R.RUNSTATUS = :2 AND S.SERVERNAME = :3 AND R.PRCSTYPE = S.PRCSTYPE AND R.PRCSCATEGORY = C.PRCSCATEGORY AND S.SERVERNAME = C.SERVERNAME AND C.MAXCONCURRENT > 0 AND R.PRCSTYPE NOT IN ('PSJob') ORDER BY C.PRCSPRIORITY DESC, R.PRCSPRTY DESC, S.PRCSPRIORITY DESC, R.RUNDTTM ASC
d2ctga5psbdfq	SELECT B.CURRENCY_CD, G.NG_SPEND_VNDR_GRP, G.NG_SPEND_VNDR_CAT, G.NG_SPEND_VNDR_DESC, D.NAME1, E.DEPTID || ' - ' || E.DESCR , ' ', E.DESCR, SUM( B.MONETARY_AMOUNT), SUM( B.USETAX_AMT_BSE), D.VENDOR_ID, SUBSTR(TO_CHAR( TO_CHAR(A.FROM_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(A.FROM_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(A.FROM_DATE, 'YYYY-MM-DD')), 1, 4) , SUBSTR(TO_CHAR( TO_CHAR(A.THRU_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(A.THRU_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(A.THRU_DATE, 'YYYY-MM-DD')), 1, 4) , MAX( B.UNPOST_SEQ) FROM PS_NG_RUN_CNTL_AP A, PS_VCHR_ACCTG_LINE B, PS_VOUCHER C, PS_VENDOR D, PS_DEPT_TBL E, PS_NG_VNDR_SPEND F, PS_NG_SPEND_CATGRY G WHERE A.OPRID = 'SPULCHEO' AND ( A.OPRID = :1 AND A.RUN_CNTL_ID = :2 AND B.ACCOUNTING_DT BETWEEN A.FROM_DATE AND A.THRU_DATE AND B.DST_ACCT_TYPE NOT IN ('APA', 'CAS') AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.VOUCHER_ID = C.VOUCHER_ID AND C.CLOSE_STATUS = 'O' AND C.POST_STATUS_AP = 'P' AND C.VENDOR_ID = D.VENDOR_ID AND E.DEPTID = B.DEPTID AND E.EFFDT = (SELECT MAX(E_ED.EFFDT) FROM PS_DEPT_TBL E_ED WHERE E.SETID = E_ED.SETID AND E.DEPTID = E_ED.DEPTID AND E_ED.EFFDT <= SYSDATE) AND D.VENDOR_ID = F.VENDOR_ID(+) AND F.NG_UNIQUE_ID = G.NG_UNIQUE_ID(+) AND ( B.VOUCHER_ID NOT IN ('00015261' , '00055965', '00055969', '00056589', '00056590', '00057709', '00060539', '00366457', '00373781', '00378401', '00378413', '00378420', '00378498', '00393617', '00393635') AND B.ACCOUNT <> '9999999') ) GROUP BY B.CURRENCY_CD, G.NG_SPEND_VNDR_GRP, G.NG_SPEND_VNDR_CAT, G.NG_SPEND_VNDR_DESC, D.NAME1, E.DEPTID || ' - ' || E.DESCR , ' ', E.DESCR, D.VENDOR_ID, SUBSTR(TO_CHAR( TO_CHAR(A.FROM_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(A.FROM_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(A.FROM_DATE, 'YYYY-MM-DD')), 1, 4) , SUBSTR(TO_CHAR( TO_CHAR(A.THRU_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(A.THRU_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(A.THRU_DATE, 'YYYY-MM-DD')), 1, 4) UNION SELECT I.CURRENCY_CD, N.NG_SPEND_VNDR_GRP, N.NG_SPEND_VNDR_CAT, N.NG_SPEND_VNDR_DESC, K.NAME1, ' ', L.PRODUCT || ' - ' || L.DESCR , L.DESCR, SUM( I.MONETARY_AMOUNT), SUM( I.USETAX_AMT_BSE), K.VENDOR_ID, SUBSTR(TO_CHAR( TO_CHAR(H.FROM_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(H.FROM_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(H.FROM_DATE, 'YYYY-MM-DD')), 1, 4) , SUBSTR(TO_CHAR( TO_CHAR(H.THRU_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(H.THRU_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(H.THRU_DATE, 'YYYY-MM-DD')), 1, 4) , MAX( I.UNPOST_SEQ) FROM PS_NG_RUN_CNTL_AP H, PS_VCHR_ACCTG_LINE I, PS_ VOUCHER J, PS_VENDOR K, PS_PRODUCT_TBL L, PS_NG_VNDR_SPEND M, PS_NG_SPEND_CATGRY N WHERE H.OPRID = 'SPULCHEO' AND ( H.OPRID = :3 AND H.RUN_CNTL_ID = :4 AND I.ACCOUNTING_DT BETWEEN H.FROM_DATE AND H.THRU_DATE AND I.DST_ACCT_TYPE NOT IN ('APA', 'CAS') AND I.BUSINESS_UNIT = J.BUSINESS_UNIT AND I.VOUCHER_ID = J.VOUCHER_ID AND J.CLOSE_STATUS = 'O' AND J.POST_STATUS_AP = 'P' AND J.VENDOR_ID = K.VENDOR_ID AND I.DEPTID = ' ' AND L.PRODUCT = I.PRODUCT AND L.EFFDT = (SELECT MAX(L_ED.EFFDT) FROM PS_PRODUCT_TBL L_ED WHERE L.SETID = L_ED.SETID AND L.PRODUCT = L_ED.PRODUCT AND L_ED.EFFDT <= SYSDATE) AND K.VENDOR_ID = M.VENDOR_ID(+) AND M.NG_UNIQUE_ID = N.NG_UNIQUE_ID(+) AND ( I.VOUCHER_ID NOT IN ('00015261', '00055965', '00055969', '00056589', '00056590', '00057709', '00060539', '00366457', '00373781', '00378401', '00378413', '00378420', '00378498', '00393617', '00393635') AND I.ACCOUNT <> '9999999') ) GROUP BY I.CURRENCY_CD, N.NG_SPEND_VNDR_GRP, N.NG_SPEND_VNDR_CAT, N.NG_SPEND_VNDR_DESC, K.NAME1, ' ', L.PRODUCT || ' - ' || L.DESCR , L.DESCR, K.VENDOR_ID, SUBSTR(TO_CHAR( TO_CHAR(H.FROM_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(H.FROM_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(H.FROM_DATE, 'YYYY-MM-DD')), 1, 4) , SUBSTR(TO_CHAR( TO_CHAR(H.THRU_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(H.THRU_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(H.THRU_DATE, 'YYYY-MM-DD')), 1, 4) UNION SELECT P.CURRENCY_CD, T.NG_SPEND_VNDR_GRP, T.NG_SPEND_VNDR_CAT, T.NG_SPEND_VNDR_DESC, R.NAME1, ' ', ' ', ' ', SUM( P.MONETARY_AMOUNT), SUM( P.USETAX_AMT_BSE), R.VENDOR_ID, SUBSTR(TO_CHAR( TO_CHAR(O.FROM_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(O.FROM_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(O.FROM_DATE, 'YYYY-MM-DD')), 1, 4) , SUBSTR(TO_CHAR( TO_CHAR(O.THRU_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(O.THRU_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(O.THRU_DATE, 'YYYY-MM-DD')), 1, 4) , MAX( P.UNPOST_SEQ) FROM PS_NG_RUN_CNTL_AP O, PS_VCHR_ACCTG_LINE P, PS_VOUCHER Q, PS_VENDOR R, PS_NG_VNDR_SPEND S, PS_NG_SPEND_CATGRY T WHERE O.OPRID = 'SPULCHEO' AND ( O.OPRID = :5 AND O.RUN_CNTL_ID = :6 AND P.ACCOUNTING_DT BETWEEN O.FROM_DATE AND O.THRU_DATE AND P.DST_ACCT_TYPE NOT IN ('APA', 'CAS') AND P.BUSINESS_UNIT = Q.BUSINESS_UNIT AND P.VOUCHER_ID = Q.VOUCHER_ID AND Q.CLOSE_STATUS = 'O' AND Q.POST_STATUS_AP = 'P' AND Q.VENDOR_ID = R.VENDOR_ID AND P.DEPTID = ' ' AND P.PRODUCT = ' ' AND R.VENDOR_ID = S.VENDOR_ID(+) AND S.NG_UNIQUE_ID = T.NG_UNIQUE_ID(+) AND ( P.VOUCHER_ID NOT IN ('00015261', '00055965', '00055969', '00056589', '00056590', '00057709', '00060539', '00366457', '00373781', '00378401', '00378413', '00378420', '00378498', '00393617', '00393635') AND P.ACCOUNT <> '9999999') ) GROUP BY P.CURRENCY_CD, T.NG_SPEND_VNDR_GRP, T.NG_SPEND_VNDR_CAT, T.NG_SPEND_VNDR_DESC, R.NAME1, ' ', ' ', ' ', R.VENDOR_ID, SUBSTR(TO_CHAR( TO_CHAR(O.FROM_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(O.FROM_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(O.FROM_DATE, 'YYYY-MM-DD')), 1, 4) , SUBSTR(TO_CHAR( TO_CHAR(O.THRU_DATE, 'YYYY-MM-DD')), 6, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(O.THRU_DATE, 'YYYY-MM-DD')), 9, 2) || '/' || SUBSTR(TO_CHAR( TO_CHAR(O.THRU_DATE, 'YYYY-MM-DD')), 1, 4) ORDER BY 1, 2, 3, 5, 4, 8
d5jd9b2xct7xz	delete from idl_char$ where obj#=:1 and part=:2
d71ys4n7xctmy	SELECT Q.PRCSINSTANCE , Q.JOBINSTANCE , Q.MAINJOBINSTANCE , Q.SESSIONIDNUM , Q.OPRID , Q.OUTDESTTYPE , Q.GENPRCSTYPE, Q.PRCSTYPE, Q.TUXSVCID, P.PRCSOUTPUTDIR FROM PSPRCSQUE Q , PSPRCSPARMS P WHERE Q.RUNSTATUS = :1 AND Q.SERVERNAMERUN = :2 AND Q.PRCSINSTANCE = P.PRCSINSTANCE
d9s82xybmgdm2	insert into argument$( obj#, procedure$, procedure#, overload#, position#, sequence#, level#, argument, type#, default#, in_out, length, precision#, scale, radix, charsetid, charsetform, properties, type_owner, type_name, type_subname, type_linkname, pls_type) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23)
dp5hxgsszdnuk	BEGIN dbms_registry.loaded('EM'); END;
dvpfc386d6dmm	delete from idl_sb4$ where obj#=:1 and part=:2
f72wug53yw45k	SELECT /*+ ordered full(t) use_hash(t) */ U.NAME OWN, O.NAME TAB, NULL PART, NULL SPART, BITAND(T.TRIGFLAG, 67108864 + 134217728) LOCK_FLAGS FROM SYS.MON_MODS_ALL$ M, SYS.TAB$ T, SYS.OBJ$ O, SYS.USER$ U WHERE (:B4 IS NOT NULL) AND ((:B3 IS NULL) OR (U.NAME = :B3 )) AND ((:B2 IS NOT NULL) OR (U.NAME != 'SYS')) AND M.OBJ# = T.OBJ# AND BITAND(T.PROPERTY, 512) != 512 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME = 'SUMDELTA$') AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * T.ROWCNT))) AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND (:B1 = 0 OR BITAND(T.TRIGFLAG, :B1 ) != :B1 ) UNION ALL SELECT /*+ ordered use_hash(tp) use_nl(o) use_nl(u) */ U.NAME OWN, O.NAME TAB, O.SUBNAME PART, NULL SPART, BITAND(T.TRIGFLAG, 67108864 + 134217728) LOCK_FLAGS FROM SYS.MON_MODS_ALL$ M, SYS.TABPART$ TP, SYS.OBJ$ O, SYS.USER$ U, SYS.TAB$ T, SYS.OBJ$ OT WHERE (:B5 IS NOT NULL) AND ((:B3 IS NULL) OR (U.NAME = :B3 )) AND ((:B2 IS NOT NULL) OR (U.NAME != 'SYS')) AND M.OBJ# = TP.OBJ# AND BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * TP.ROWCNT))) AND TP.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TP.BO# = T.OBJ# AND OT.OBJ# = T.OBJ# AND BITAND(T.PROPERTY, 512) != 512 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND (:B1 = 0 OR (BITAND(TP.FLAGS, 32) != 32 AND BITAND(T.TRIGFLAG, :B1 ) != :B1 )) UNION ALL SELECT /*+ ordered use_hash(tcp) use_nl(o) use_nl(u) */ U.NAME OWN, O.NAME TAB, O.SUBNAME PART, NULL SPART, BITAND(T.TRIGFLAG, 67108864 + 134217728) LOCK_FLAGS FROM SYS.MON_MODS_ALL$ M, SYS.TABCOMPART$ TCP, SYS.OBJ$ O, SYS.USER$ U, SYS.TAB$ T, SYS.OBJ$ OT WHERE (:B5 IS NOT NULL) AND ((:B3 IS NULL) OR (U.NAME = :B3 )) AND ((:B2 IS NOT NULL) OR (U.NAME != 'SYS')) AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND M.OBJ# = TCP.OBJ# AND BITAND(TCP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * TCP.ROWCNT))) AND TCP.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TCP.BO# = T.OBJ# AND OT.OBJ# = T.OBJ# AND (:B1 = 0 OR (BITAND(TCP.FLAGS, 32) != 32 AND BITAND(T.TRIGFLAG, :B1 ) != :B1 )) UNION ALL SELECT /*+ ordered use_hash(tsp) use_nl(o) use_nl(u) use_nl(op) */ U.NAME OWN, O.NAME TAB, OP.SUBNAME PART, O.SUBNAME SPART, BITAND(T.TRIGFLAG, 67108864 + 134217728) LOCK_FLAGS FROM SYS.MON_MODS_ALL$ M, SYS.TABSUBPART$ TSP, SYS.OBJ$ O, SYS.USER$ U, SYS.OBJ$ OP, SYS.TABCOMPART$ TCP, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OT WHERE ((:B3 IS NULL) OR (U.NAME = :B3 )) AND ((:B2 IS NOT NULL) OR (U.NAME != 'SYS')) AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND M.OBJ# = TSP.OBJ# AND BITAND(TSP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > (.1 * TSP.ROWCNT))) AND TSP.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TSP.POBJ# = OP.OBJ# AND TCP.OBJ# = TSP.POBJ# AND TCP.BO# = T.OBJ# AND PO.OBJ# = T.OBJ# AND OT.OBJ# = T.OBJ# AND ((:B7 IS NOT NULL AND BITAND(PO.SPARE2, 255) = 2) OR (:B6 IS NOT NULL AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND (:B1 = 0 OR (BITAND(TCP.FLAGS, 32) != 32 AND BITAND(T.TRIGFLAG, :B1 ) != :B1 )) UNION ALL SELECT /*+ use_hash(fxt, fobj) */ 'SYS', FXT.KQFTANAM TAB, NULL PART, NULL SPART, BITAND(FOBJ.FLAGS, 67108864 + 134217728) LOCK_FLAGS FROM SYS.X$KQFTA FXT, FIXED_OBJ$ FOBJ, X$KQFOPT OPT WHERE :B8 IS NOT NULL AND ((:B3 IS NULL) OR (:B3 = 'SYS')) AND FOBJ.OBJ# = FXT.KQFTAOBJ AND BITAND(FOBJ.FLAGS, 1) = 1 AND (:B1 = 0 OR BITAND(FOBJ.FLAGS, :B1 ) != :B1 ) AND FOBJ.OBJ# = OPT.KQFOPTOBJ(+) AND (OPT.KQFOPTFLAGS IS NULL OR BITAND(OPT.KQFOPTFLAGS, 16+32) = 0) ORDER BY 1, 2, 3 DESC, 4 DESC
frmr0udxggmzz	SELECT 'X' FROM PS_INSTALLATION WHERE EXISTS ( SELECT 'X' FROM PS_CM_DEPLETE WHERE PROC_INSTANCE_AP = 1014397)
g70s06b3hhfgn	select o.name, o.type#, o.obj#, o.remoteowner, o.linkname, o.namespace, o.subname from obj$ o, tab$ t where o.owner#=:1 and o.type# !=11 and o.type# !=13 and o.type# !=14 and o.type# !=10 and o.type# !=33 and o.type# !=32 and o.type# !=8 and o.type# !=9 and o.type# != 7 and o.type# != 38 and o.type# != 22 and o.type# != 28 and o.type# != 29 and o.type# != 30 and o.type# != 55 and o.obj#=t.obj#(+) and (t.property is null or (bitand(t.property, 8192)!=8192 and bitand(t.property, 512)!=512 and bitand(t.flags, 536870912)!=536870912))order by o.type# desc
gdhz78y24tvnz	delete from ncomp_dll$ where obj#=:1 returning dllname into :2
gsqxm6zz3w2by	delete from idl_ub1$ where obj#=:1 and part=:2

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• Tablespace IO Stats
• File IO Stats

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Top

Advisory Statistics

• Instance Recovery Stats
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin snapshot, E: End snapshot

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

• B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
• Auto PGA Target - actual workarea memory target
• W/A PGA Used - amount of memory used for all Workareas (manual + auto)
• %PGA W/A Mem - percentage of PGA memory allocated to workareas
• %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
• %Man W/A Mem - percentage of workarea memory under manual control

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
• Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Wait Statistics
Back to Top

Enqueue Activity

• only enqueues with waits are shown
• Enqueue stats gathered prior to 10g should not be compared with 10g data
• ordered by Wait Time desc, Waits desc

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

• Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
• STO - Snapshot Too Old count, OOS - Out of Space count
• Undo segment block stats:
• uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
• eS - expired Stolen, eR - expired Released, eU - expired reUsed

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc