WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
WZSB	2354576666	wzsb	1	11-Feb-12 17:02	11.2.0.3.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
db1	AIX-Based Systems (64-bit)	32	8		30.88

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2394	16-May-12 10:00:45	103	2.1
End Snap:	2396	16-May-12 12:00:53	92	2.1
Elapsed:		120.13 (mins)
DB Time:		126.01 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	3,744M	3,744M	Std Block Size:	8K
Shared Pool Size:	5,600M	5,600M	Log Buffer:	19,900K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.1	3.9	0.01	0.01
DB CPU(s):	0.0	0.1	0.00	0.00
Redo size:	21,203.4	79,643.2
Logical reads:	2,068.5	7,769.7
Block changes:	131.1	492.6
Physical reads:	193.3	726.2
Physical writes:	3.3	12.4
User calls:	173.5	651.6
Parses:	10.1	38.1
Hard parses:	0.4	1.6
W/A MB processed:	0.3	1.0
Logons:	0.2	0.8
Executes:	95.1	357.3
Rollbacks:	0.1	0.3
Transactions:	0.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	94.79	In-memory Sort %:	100.00
Library Hit %:	98.88	Soft Parse %:	95.89
Execute to Parse %:	89.34	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	56.90	% Non-Parse CPU:	96.56

Shared Pool Statistics

	Begin	End
Memory Usage %:	35.43	35.86
% SQL with executions>1:	93.41	88.83
% Memory for SQL w/exec>1:	90.06	86.95

Top 5 Timed Foreground Events

Host CPU (CPUs: 32 Cores: 8 Sockets: )

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.17	0.20	0.2	0.2	0.1	99.7

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.1	30.0	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	31,616.0	31,616.0
SGA use (MB):	9,504.0	9,504.0
PGA use (MB):	271.5	239.0
% Host Mem used for SGA+PGA:	30.92	30.82

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
• Shared Server Statistics
• init.ora Parameters

Wait Events Statistics

• Time Model Statistics
• Operating System Statistics
• Operating System Statistics - Detail
• Foreground Wait Class
• Foreground Wait Events
• Background Wait Events
• Wait Event Histogram
• Wait Event Histogram Detail (64 msec to 2 sec)
• Wait Event Histogram Detail (4 sec to 2 min)
• Wait Event Histogram Detail (4 min to 1 hr)
• Service Statistics
• Service Wait Class Stats

Time Model Statistics

• Total time in database user-calls (DB Time): 7560.4s
• 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

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 99.7% of Total DB time 7,560.39 (s)
• Total FG Wait Time: 7,316.61 (s) DB CPU time: 223.15 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond - 1000th of a second
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Background Wait Events

• ordered by wait time desc, waits desc (idle events last)
• Only events with Total Wait Time (s) >= .001 are shown
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
• % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
• Ordered by Event (idle events last)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

• Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
• Units for % of Total Waits: m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) h is 4096*1024 milliseconds (approximately 70 minutes or 1.17 hours)
• % of Total Waits: total waits for all wait classes, including Idle
• % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
• Ordered by Event (only non-idle events are displayed)

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 seconds

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• 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
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 174.1% of Total DB Time (s): 7,560
• Captured PL/SQL account for 84.8% of Total DB Time (s): 7,560

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 - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 29.8% of Total CPU Time (s): 223
• Captured PL/SQL account for 21.3% of Total CPU Time (s): 223

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 20.8% of Total User I/O Wait Time (s): 151
• Captured PL/SQL account for 6.2% of Total User I/O Wait Time (s): 151

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 as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 14,910,006
• Captured SQL account for 72.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 1,393,482
• Captured SQL account for 38.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 46,362
• Captured SQL account for 21.6% of Total
• Total UnOptimized Read Requests: 46,362
• Captured SQL account for 21.6% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 685,659
• Captured SQL account for 48.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 73,123
• Captured SQL account for 33.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0b0vcuynqbcax	Insert Into SBDS_LOG values(sb_opseno.nextval, 1, 'ORA$PIPE$00FE2B510001')
0d6wc2as7nsu9	UPDATE WZSB.SYNC_BTBL_GLO_DATA SET BEE_ISUPDATE = '1', BEE_ISSYNC = '0', BEE_UPDATETIME = :B1 WHERE TABLE_NAME = 'SBDA_PSMDPYDTTEMP'
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0skcn22jj1xqd	SELECT HSTYPE FROM SBDC_MDPYHOSP WHERE HSCODE = :B1 AND CDFLAG = '0'
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1071td87xbwd6	Insert Into SBDS_LOG values(sb_opseno.nextval, 1, 'ORA$PIPE$008326A70001')
10wyqhtg4t4up	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."SBDS_YDLOG_YD".* FROM "WZSB"."SBDS_YDLOG_YD"
15rbgh4d2ku4u	insert into WRM$_SNAPSHOT (snap_id, dbid, instance_number, startup_time, begin_interval_time, end_interval_time, snap_level, status, error_count, bl_moved, snap_flag, snap_timezone) values (:snap_id, :dbid, :instance_number, :startup_time, :begin_interval_time, :end_interval_time, :snap_level, :status, 0, 0, :bind1, :bind2)
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1ty1cd109q3z1	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."SBDS_FTRANS".* FROM "WZSB"."SBDS_FTRANS"
25fu98m3hw2ts	SELECT VALUE FROM MGMT_CURRENT_METRICS A, MGMT_METRICS B, MGMT_TARGETS C WHERE B.TARGET_TYPE = :B3 AND A.METRIC_GUID = B.METRIC_GUID AND B.METRIC_COLUMN = :B2 AND B.METRIC_NAME = :B1 AND C.TYPE_META_VER = B.TYPE_META_VER AND (B.CATEGORY_PROP_1 = C.CATEGORY_PROP_1 OR B.CATEGORY_PROP_1 = ' ') AND (B.CATEGORY_PROP_2 = C.CATEGORY_PROP_2 OR B.CATEGORY_PROP_2 = ' ') AND (B.CATEGORY_PROP_3 = C.CATEGORY_PROP_3 OR B.CATEGORY_PROP_3 = ' ') AND (B.CATEGORY_PROP_4 = C.CATEGORY_PROP_4 OR B.CATEGORY_PROP_4 = ' ') AND (B.CATEGORY_PROP_5 = C.CATEGORY_PROP_5 OR B.CATEGORY_PROP_5 = ' ')
2775803kszx95	UPDATE SBDA_PSMDACDT_MID SET ACFLAG='1' WHERE PRSENO=:B1
29arury5k445z	update sbds_log set ordnum = abs(ordnum) + 1 where userflag = 'ORA$PIPE$02F096D90001'
2cxb8shvxfbt4	SELECT COLNAME, INTCOL, DISTCOUNT, LOWVAL, HIVAL, DENSITY, NULLCOUNT, AVGCLN, CFLAGS, PROPERTY FROM SYS.EXU10ASCU WHERE TOBJID = :1 AND POBJID = :2
2rq8p9b3f1n82	SELECT COUNT(BROKEN) FROM USER_JOBS WHERE WHAT = 'EMD_NOTIFICATION.CHECK_FOR_SEVERITIES'
2svb3tts00va6	select tablespace_name, sum(bytes)/1024/1024 mb from dba_free_space group by tablespace_name
2wuxsvgst612h	SELECT NVL(AVG(VALUE), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME=:B2 AND NAME=:B1 AND TIME>(SYSDATE-(1/24))
2zmrurk71bvdn	SELECT COUNT(*) FROM SBDB_PECLSARCH WHERE LSTYPE='1' AND OPFLAG='0' AND DLFLAG='0' AND PSSENO=:B1 AND (EDDATE IS NULL OR TRUNC(EDDATE, 'dd')>=TRUNC(SYSDATE, 'dd'))
317v5hnvvd49h	UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)
38c4mb0a5b3f3	SELECT TO_CHAR(ADD_MONTHS(TO_DATE(:B2 , 'yyyymm'), :B1 ), 'yyyymm') FROM DUAL
394zwwvb1quhn	SELECT A.PRSENO PRSENO, A.PSSENO PSSENO, A.CPSENO CPSENO, A.PDCODE PDCODE, B.BDATE BDATE, B.PSTYPE PSTYPE, B.MDTYPE MDTYPE, A.PSINFO PSINFO, A.CPINFO CPINFO, (A.REWAGE*A.REMONS*A.CPRATE) ARCPFD, (A.REWAGE*A.REMONS*A.PSRATE) ARPSFD, A.REWAGE REWAGE, A.REMONS REMONS, A.REYMN REYMN, A.SYMN SYMN, A.EYMN EYMN, B.MDTYPE OMDTYPE FROM SBDA_PSMDFTAC A, SBDB_PSARCH B WHERE A.PSSENO = B.PSSENO AND B.PSTYPE='0' AND A.PDCODE = '03' AND (A.ACFLAG='0' OR A.ACFLAG IS NULL) AND A.FTFLAG='1' AND A.MDTYPE NOT IN('4', '5', '6') AND B.BDATE IS NOT NULL AND ( A.PSINFO<>0 OR A.CPINFO<>0) AND B.BDATE > TO_DATE('19000101', 'yyyymmdd') AND B.BDATE < TRUNC(SYSDATE, 'dd') UNION ALL SELECT A.PRSENO PRSENO, A.PSSENO PSSENO, A.CPSENO CPSENO, A.PDCODE PDCODE, B.BDATE BDATE, B.PSTYPE PSTYPE, DECODE(C.RTCODE, '30', 'B', B.MDTYPE) MDTYPE, A.PSINFO PSINFO, A.CPINFO CPINFO, (A.REWAGE*A.REMONS*(A.CPRATE+A.PSRATE-0.02)) ARCPFD, (A.REWAGE*A.REMONS*0.02) ARPSFD, A.REWAGE REWAGE, A.REMONS REMONS, A.REYMN REYMN, A.SYMN SYMN, A.EYMN EYMN, B.MDTYPE OMDTYPE FROM SBDA_PSMDFTAC A, SBDB_PSARCH B, SBDB_RTARCH C WHERE A.PSSENO = B.PSSENO AND B.PSSENO=C.PSSENO AND B.PSTYPE='1' AND C.CDFLAG='0' AND A.PDCODE = '03' AND (A.ACFLAG='0' OR A.ACFLAG IS NULL) AND A.FTFLAG='1' AND A.MDTYPE NOT IN('4', '5', '6') AND B.BDATE IS NOT NULL AND ( A.PSINFO<>0 OR A.CPINFO<>0) AND B.BDATE > TO_DATE('19000101', 'yyyymmdd') AND B.BDATE < TRUNC(SYSDATE, 'dd')
3fx1d101b9s3v	update sbds_log set opseno = sb_opseno.nextval, ordnum=1 where userflag = 'ORA$PIPE$004E069D0001'
3gubxp5js3tbn	SELECT CUTYPE, CUNAME, SUM(SUMFD) SUMFD, SUM(PSBPFD) PSBPFD, SUM(PSBDFD) PSBDFD FROM KCI7 WHERE MDSENO = :B1 GROUP BY CUTYPE, CUNAME
3jy13qrh3zxfr	SELECT COUNT(*) FROM SBDA_PSMDFTAC WHERE PSSENO=:B2 AND PDCODE='03' AND SYMN<=:B1 AND EYMN>=:B1 AND RDCNT=0 AND OPFLAG='0' AND REMONS>0 AND ARCHFLAG='0' AND FTFLAG='1' AND ARKIND IN('01', '02', '05', '19', '49', '50', '57', '59', '75', '77') AND ROWNUM=1
3uhwu8qpsgwf1	begin sbk_mdsquac.sbp_allmdacct(2012, 05); end;
3uw91bsr1x59v	select max ( length ( rtrim ( ltrim ( sname ) ) ) ) from sbdc_code where rtrim ( ltrim ( stype ) ) =:1
3xq12h85knzr8	BEGIN un_ps_pb.un_ps_do; END;
3xsf7q14zh213	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."SBDA_MDMETL".* FROM "WZSB"."SBDA_MDMETL"
4275vcmfkfq7n	SELECT COUNT(*) FROM SBDA_PSMDFTAC WHERE PSSENO=:B2 AND PDCODE='03' AND SYMN<=:B1 AND EYMN>=:B1 AND RDCNT=0 AND OPFLAG='0' AND REMONS>0 AND ARCHFLAG='0' AND FTFLAG='0' AND ARKIND IN('01', '02', '05', '19', '49', '50', '57', '59', '75', '77') AND ROWNUM=1
42cfrr6x5t75c	SELECT MAX(DB_NAME), MAX(VERSION) FROM WRM$_DATABASE_INSTANCE WHERE DBID = :B1 AND STARTUP_TIME = (SELECT MAX(STARTUP_TIME) FROM WRM$_DATABASE_INSTANCE WHERE DBID = :B1 AND STARTUP_TIME <= :B2 )
4413ds8jy8hq7	update sbds_log set opseno = sb_opseno.nextval, ordnum=1 where userflag = 'ORA$PIPE$017AB0D90001'
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
481srsacy4bps	SELECT TO_NUMBER(PAFLAG) FROM SBDS_CONSINI WHERE UPPER(PACODE)='IGNORE_OWE_MONTHS'
4c8sch6xnumzp	update sbdb_psgttaxno Set iscode =:1 , dttype ='1' , opymn =:2 , opcode =:3 , opdate =:4 Where psseno =:5
509yg53qnzrqa	UPDATE WZSB.SYNC_BTBL_GLO_DATA SET BEE_ISUPDATE = '1', BEE_ISSYNC = '0', BEE_UPDATETIME = :B1 WHERE TABLE_NAME = 'SBDA_PSMDACDT'
5p34p9afvgt0k	SELECT /*+ USE_MERGE(B, A) */ A.*, A.ROWID FROM SBDA_MDMETLYZ A, SBDC_MEDRUG B WHERE A.MECODE = B.MECODE AND A.REGSENO = :B2 AND UPPER(B.AKE001) = UPPER(:B1 ) ORDER BY A.HIOPDATE
5r9dtcqn4c4c7	INSERT INTO SBDA_PSMDPYDT ( MDSENO, PSSENO, CPSENO, PSTYPE, PSMDATTR, MDTYPE, MISPTYPE, DYFLAG, MIPYTYPE, MIFLAG, REGSENO, HSCODE, HSNAME, HSLEVEL, MDCODE, INDATE, OUTDATE, HIDEPART, DCNAME, ILCODE, ILNAME, SPILCODE, OUTOPCODE, OUTOPDATE, HIFLAG, STCONT, CYHICONT, CYHIMDFD, CYSPMDFD, CYSPCONT, CYSIMDFD, CYOFHPFD, CYSIHPFD, CYACLFFD, LYACLFFD, CCBEFD, YEARNO, SUMFD, ELIMFD, PSBPFD, PSBDFD, BERATE, BEFD, MDFD, ADDRATE, CCBEPYFD, PSCYACFD, PSCYACADJ, PSLYACFD, SIMDFD, SIHPFD, OFHPFD, SPFD, PSFD, PSPYFD, PYFLAG, PYSENO, FTDATE, PYOPFLAG, ATCODE, ECCODE, SBCODE, DPCODE, REDATE, RECODE, CREDATE, CDFLAG, NOTES, SACODE, SIAREA, OPCODE, OPDATE, OPSACODE, OPSIAREA, OPYMN, DLFLAG, DLCODE, DLDATE, PRSENO, PRCOUNT, PRDATE, PROPCODE, CPREMIT, TRCODE, CYHPMDFD, HPMDFD, CYCNMDFD, AAA027, AKE024, AKE008, TFMDSENO, AKC197, AKC198 ) SELECT MDSENO, PSSENO, CPSENO, PSTYPE, PSMDATTR, MDTYPE, MISPTYPE, DYFLAG, MIPYTYPE, MIFLAG, REGSENO, HSCODE, HSNAME, HSLEVEL, MDCODE, INDATE, OUTDATE, HIDEPART, DCNAME, ILCODE, ILNAME, SPILCODE, OUTOPCODE, OUTOPDATE, HIFLAG, STCONT, CYHICONT, CYHIMDFD, CYSPMDFD, CYSPCONT, CYSIMDFD, CYOFHPFD, CYSIHPFD, CYACLFFD, LYACLFFD, CCBEFD, YEARNO, SUMFD, ELIMFD, PSBPFD, PSBDFD, BERATE, BEFD, MDFD, ADDRATE, CCBEPYFD, PSCYACFD, PSCYACADJ, PSLYACFD, SIMDFD, SIHPFD, OFHPFD, SPFD, PSFD, PSPYFD, PYFLAG, PYSENO, FTDATE, PYOPFLAG, ATCODE, ECCODE, SBCODE, DPCODE, REDATE, RECODE, CREDATE, CDFLAG, NOTES, SACODE, SIAREA, OPCODE, OPDATE, OPSACODE, OPSIAREA, OPYMN, DLFLAG, DLCODE, DLDATE, PRSENO, PRCOUNT, PRDATE, PROPCODE, CPREMIT, TRCODE, CYHPMDFD, HPMDFD, CYCNMDFD, AAA027, AKE024, AKE008, TFMDSENO, AKC197, AKC198 FROM SBDA_PSMDPYDTTEMP WHERE MDSENO=:B1
5rygsj4dbw6jt	insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7)
5s34t44u10q4g	SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1
5ugs0qbbad5gb	SELECT COUNT(1) FROM SBDA_PSMDACDT WHERE PSSENO=:B2 AND SYMN=:B1 AND INFLAG='1'
5upn6hvq6kdnm	UPDATE SBDA_PSDMFTAC SET ACFLAG='1' WHERE PSSENO=:B2 AND PRSENO = :B1 AND FTFLAG='1'
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
5wc1h6m20b806	SELECT A.AAZ231, A.MECODE , A.CUTYPE FROM SBDC_MEDRUG A , SBDC_MECUMATCH B WHERE A.AAZ231=B.AAZ231 AND B.HSCODE =:B4 AND B.HIMECODE=:B3 AND DECODE(B.MEFLAG, '4', '1', B.MEFLAG)=DECODE(:B2 , '4', '1', :B2 ) AND A.CDFLAG ='0' AND B.UDFLAG ='0' AND A.AAE030 <= TO_NUMBER(TO_CHAR(:B1 , 'yyyymmdd')) AND TO_NUMBER(TO_CHAR(:B1 , 'yyyymmdd')) <= NVL(A.AAE031, '99999999')
61xzsbawykhc1	BEGIN glog.cutab; END;
65vv67yaqg5rs	Insert Into SBDS_LOG values(sb_opseno.nextval, 1, 'ORA$PIPE$009C5C110001')
6b55h2qtk2w22	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."SBDA_PSMDFTAC".* FROM "WZSB"."SBDA_PSMDFTAC"
6gyufzw0vn6c3	Insert Into SBDS_LOG values(sb_opseno.nextval, 1, 'ORA$PIPE$02DB87D50001')
6m6g29ds58wb2	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."SBDA_PSAGFTAC".* FROM "WZSB"."SBDA_PSAGFTAC"
6q8c8hcv9xcvx	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."S_B_SBDA_PSAGFTAC".* FROM "WZSB"."S_B_SBDA_PSAGFTAC"
6w3zq6qxgttrw	UPDATE WZSB.SYNC_BTBL_GLO_DATA SET BEE_ISUPDATE = '1', BEE_ISSYNC = '0', BEE_UPDATETIME = :B1 WHERE TABLE_NAME = 'SBDA_MDMETLMZ'
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
6y0tb6wcmczp8	SELECT BUCKET, ENDPTHASH, ENDPTVAL, UTL_RAW.CAST_TO_RAW(ENDPTVAL) ENDPTVAL_RAW FROM SYS.EXU8HSTU WHERE POBJID = :1 AND INTCOL = :2 ORDER BY BUCKET
70c5u0b6t1tdy	UPDATE WZSB.SYNC_BTBL_GLO_DATA SET BEE_ISUPDATE = '1', BEE_ISSYNC = '0', BEE_UPDATETIME = :B1 WHERE TABLE_NAME = 'SBDS_LOG'
75u7czskb4954	Insert Into SBDS_LOG values(sb_opseno.nextval, 1, 'ORA$PIPE$006ADAA90001')
77wpgvy3z1uzx	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."S_B_SBDA_PSMDPYDT".* FROM "WZSB"."S_B_SBDA_PSMDPYDT"
7aw21806wpgzp	select null from all_synonyms where 1=0
7m3npa6xn1whq	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."SBDB_TAXDATAEXCHANGE".* FROM "WZSB"."SBDB_TAXDATAEXCHANGE"
7msxd2qjtsw05	SELECT /*+ INDEX(tasks mgmt_collection_tasks_pk) */ * FROM MGMT_COLLECTION_TASKS TASKS WHERE TASK_ID = :B1 FOR UPDATE
86brtncmju33d	SELECT a.SCODE, a.SNAME, a.OPFLAG FROM SBDC_CODE a, SBDC_CDTYPE b WHERE a.STYPE=B.STYPE AND rtrim(ltrim(a.STYPE)) = :as_type AND a.cdflag='0' and b.cdflag='0'
8f1sjvfxuup9w	select t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null
8jwzqbx9qzra0	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."MLOG$_SBDA_MDMETL".* FROM "WZSB"."MLOG$_SBDA_MDMETL"
8mfjgswmfg1u2	UPDATE WZSB.SYNC_BTBL_GLO_DATA SET BEE_ISUPDATE = '1', BEE_ISSYNC = '0', BEE_UPDATETIME = :B1 WHERE TABLE_NAME = 'SBDA_PSMDPYDT'
8px1cbu6usp98	INSERT INTO SBDA_PSMDACDT (YEARNO, PSSENO, CPSENO, PDCODE, ACYM, SYMN, EYMN, INMONS, PSTYPE, MDTYPE, MISPTYPE, ARINFD, ARCPINFD, ARPSINFD, INFLAG, PYFLAG, REFSENO, OPDATE, OPCODE, NOTES, TRSENO, PRSENO) SELECT :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, :B4 , :B3 , :B2 , :B1 FROM DUAL
8vwv6hx92ymmm	UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1
91k4w10zgrg4m	select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
99q1kfdz8fpja	select c.menuname, c.tpgname, c.muexplain, c.menucode, c.opflag1, c.opflag2, c.auflag, c.menuflag, c.rolflag from sbds_mupopulate a, sbds_roledetl b, sbds_submenu c, sbds_usrole d where a.menucode = b.menucode and b.menucode = c.menucode and b.rlcode = d.rlcode and b.cdflag = '0' and d.cdflag = '0' and a.syscode = :al_syscode and d.opcode=:as_opcode union select c.menuname, c.tpgname, c.muexplain, c.menucode, c.opflag1, c.opflag2, c.auflag, c.menuflag, c.rolflag from sbds_mupopulate a, sbds_usmenu b, sbds_submenu c where a.menucode = b.menucode and b.menucode = c.menucode and a.syscode = :al_syscode and b.opcode=:as_opcode and b.cdflag = '0'
9dhn1b8d88dpf	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
9nmah7jb00bu0	UPDATE MGMT_TARGET_ROLLUP_TIMES SET ROLLUP_TIMESTAMP = :B2 WHERE ROWID = :B1
9p5tvdmjymwx7	UPDATE MGMT_POLICY_ASSOC_EVAL_SUMM SET LAST_EVALUATION_DATE = NVL(:B12 , SYSDATE), ROWS_EVALUATED = NVL(:B11 , 0), TOTAL_VIOLATIONS_LOGGED = NVL(:B10 , TOTAL_VIOLATIONS_LOGGED), NON_EXEMPT_VIOLATIONS_LOGGED = NVL(:B9 , :B8 ), MAX_VIOLATION_LEVEL = NVL(:B7 , :B6 ), COMPLIANCE_SCORE = NVL(:B5 , :B4 ) WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND COLL_NAME = :B1
9srztwq5v7187	update sbds_log set opseno = sb_opseno.nextval, ordnum=1 where userflag = 'ORA$PIPE$0131BB110001'
a5w5080aj4nh1	INSERT INTO KCI3 VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 )
amgdyhr9pf1z9	SELECT COUNT(1) FROM SBDA_PSMDACDT_MID WHERE PSSENO=:B2 AND SYMN=:B1 AND INFLAG='1'
bd502nbh9abbs	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
bgd0c7sa3abz0	SELECT NVL(SUM(ARINFD), 0) FROM SBDA_PSMDACDT WHERE YEARNO < :B2 AND PSSENO = :B1
bkvd6ymnmf7yh	SELECT (SUMFD), (PSBPFD), (PSBDFD), (MDFD), (BEFD), (CCBEPYFD), NVL((PSPYFD) - (PSFD), 0), (PSFD), (PSPYFD), (PSCYACFD + PSCYACADJ + PSLYACFD + SIMDFD + SIHPFD + OFHPFD + SPFD), (PSLYACFD), (PSCYACFD), (SIMDFD), (SIHPFD), (OFHPFD), DECODE(MDTYPE, '6', 0, (SPFD)), DECODE(MDTYPE, '6', (SPFD), 0), 0, 0, 0, 0, 0, (CYACLFFD - PSCYACFD - PSCYACADJ), (LYACLFFD - PSLYACFD), (MDFD), 0, 0, 0, 0, 0 FROM SBDA_PSMDPYDTTEMP WHERE MDSENO = :B1
bmskwxr1b498c	INSERT INTO SBDA_PSMDACDT_MID (YEARNO, PSSENO, CPSENO, PDCODE, ACYM, SYMN, EYMN, INMONS, PSTYPE, MDTYPE, MISPTYPE, ARINFD, ARCPINFD, ARPSINFD, INFLAG, PYFLAG, REFSENO, OPDATE, OPCODE, NOTES, TRSENO, PRSENO) SELECT :B14 , :B13 , :B12 , :B11 , :B10 *100+:B9 , :B8 , :B8 , 1, :B7 , DECODE(:B5 , 'B', :B6 , :B5 ), '01', :B4 , :B3 , :B2 , '1', '0', 0, SYSDATE, 'WZSB', NULL, 0, :B1 FROM DUAL
bn4b3vjw2mj3u	SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.schedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1
brhj0tz3mukqd	BEGIN glog.reopseno; END;
byt3gq6r9d1uy	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."SBDA_PSOTHFTAC".* FROM "WZSB"."SBDA_PSOTHFTAC"
byw9yn1hgu3bp	call SIM_UserPack.OraTransmit(:b0, :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21)
c63fy3v9xp21u	Insert Into SBDS_LOG values(sb_opseno.nextval, 1, 'ORA$PIPE$0211B5E70001')
c8khjbn635s3c	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cnm3bx3ry4ckr	SELECT COUNT(*) FROM SBDA_PSMDPYDTTEMP WHERE PSSENO=:B2 AND MDSENO>:B1
crwtm662ycm4w	select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))
cumjq42201t37	select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
d39a9gpw7wdu8	SELECT TOWNER, TNAME, NAME, LENGTH, PRECISION, SCALE, TYPE, ISNULL, CONNAME, COLID, INTCOLID, SEGCOLID, COMMENT$, DEFAULT$, DFLTLEN, ENABLED, DEFER, FLAGS, COLPROP, ADTNAME, ADTOWNER, CHARSETID, CHARSETFORM, FSPRECISION, LFPRECISION, CHARLEN, TFLAGS, 100 FROM SYS.EXU8COLU WHERE TOBJID = :1 ORDER BY INTCOLID
d790ufhwv3z7z	INSERT INTO SBDA_PSMDACDT ( YEARNO, PSSENO, CPSENO, PDCODE, ACYM, INMONS, PSTYPE, MDTYPE, MISPTYPE, ARINFD, ARCPINFD, ARPSINFD, INFLAG, PYFLAG, REFSENO, OPDATE, OPCODE, NOTES, TRSENO, PRSENO, SYMN, EYMN ) VALUES ( :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , (-1)*(:B10 ), 0.00, 0.00, :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , SB_PRSENO.NEXTVAL, :B2 , :B1 )
dcvnnc6bjqshc	SELECT TASK_ID, TASK_CLASS FROM MGMT_COLLECTION_TASKS C WHERE FREQUENCY_CODE != 7 AND NOT EXISTS (SELECT 1 FROM MGMT_TASK_QTABLE Q WHERE Q.USER_DATA.TASK_ID = C.TASK_ID) FOR UPDATE
f1fm2h512nbnk	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."SBDA_PSMDWGAC".* FROM "WZSB"."SBDA_PSMDWGAC"
f4m0c6u6gp3aa	UPDATE WZSB.SYNC_BTBL_GLO_DATA SET BEE_ISUPDATE = '1', BEE_ISSYNC = '0', BEE_UPDATETIME = :B1 WHERE TABLE_NAME = 'SBDB_PSARCH'
fhw2qjm168nwy	SELECT SB_PRSENO.NEXTVAL FROM DUAL
fsn35zyxmf1uy	SELECT WHAT, NEXT_DATE NEXT_TIME, DECODE(NVL(BROKEN, 'Y'), 'Y', 'DOWN', 'UP') BROKEN FROM USER_JOBS WHERE WHAT LIKE '%EXECUTE_EM_DBMS_JOB%'
fx36hzdt3q4jp	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."SJ_JF_ZGYB".* FROM "WZSB"."SJ_JF_ZGYB"
g8v524vr0bvs6	UPDATE SBDB_PSARCH SET MDTYPE = (SELECT MAX(MDTYPE) FROM SBDB_PSARCH WHERE PSSENO IN (:B2 , :B1 )) WHERE PSSENO = :B1
gd6xbssmawc3k	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."TAB_FTRANS_STATELOG".* FROM "WZSB"."TAB_FTRANS_STATELOG"
gdzdj2c6hr6hn	SELECT /*+NESTED_TABLE_GET_REFS+*/ "WZSB"."YKT_SBDA_MDMETL_20110714".* FROM "WZSB"."YKT_SBDA_MDMETL_20110714"
ggcgsubm781ap	Select count ( *) From user_triggers Where status <> 'ENABLED'
gucp6bjynpt2f	UPDATE WZSB.SYNC_BTBL_GLO_DATA SET BEE_ISUPDATE = '1', BEE_ISSYNC = '0', BEE_UPDATETIME = :B1 WHERE TABLE_NAME = 'SBDA_PSMDACDT_MID'
gx3v0agt82qtb	UPDATE SBDA_PSMDFTAC SET ACFLAG='1' WHERE PSSENO=:B2 AND PRSENO = :B1 AND FTFLAG='1'

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

• Ordered by statistic name

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

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Ordered by (Data Read + Write) desc for each function

Back to IO Stats
Back to Top

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

• Buffer Pool Statistics
• Checkpoint Activity

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 Buffer Pool Statistics
Back to Top

Checkpoint Activity

• Total Physical Writes: 23,812

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

• Instance Recovery Stats
• MTTR Advisory
• 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

MTTR Advisory

No data exists for this section of the report.

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

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

Back to Undo Statistics
Back to Top

Latch Statistics

• Latch Activity
• Latch Sleep Breakdown
• Latch Miss Sources
• Mutex Sleep Summary
• Parent Latch Statistics
• Child Latch Statistics

Latch Activity

• "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
• "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
• "Pct Misses" for both should be very close to 0.0