WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
YYDB	2034896727	yydb1	1	28-Sep-13 00:09	11.2.0.3.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
rac01	Linux x86 64-bit	24	12	2	62.78

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	8827	26-May-14 08:00:30	77	2.0
End Snap:	8828	26-May-14 09:00:39	79	2.8
Elapsed:		60.16 (mins)
DB Time:		205.91 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	28,800M	28,800M	Std Block Size:	8K
Shared Pool Size:	9,856M	9,856M	Log Buffer:	76,796K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	3.4	0.0	0.00	0.14
DB CPU(s):	2.8	0.0	0.00	0.12
Redo size:	4,554,616.7	6,158.2
Logical reads:	68,161.1	92.2
Block changes:	32,027.1	43.3
Physical reads:	280.5	0.4
Physical writes:	744.4	1.0
User calls:	24.4	0.0
Parses:	3.3	0.0
Hard parses:	0.2	0.0
W/A MB processed:	1.6	0.0
Logons:	0.2	0.0
Executes:	7,523.3	10.2
Rollbacks:	0.0	0.0
Transactions:	739.6

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.60	In-memory Sort %:	100.00
Library Hit %:	99.99	Soft Parse %:	94.13
Execute to Parse %:	99.96	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	87.84	% Non-Parse CPU:	99.90

Shared Pool Statistics

	Begin	End
Memory Usage %:	78.39	78.30
% SQL with executions>1:	97.04	93.67
% Memory for SQL w/exec>1:	94.72	73.20

Top 5 Timed Foreground Events

Host CPU (CPUs: 24 Cores: 12 Sockets: 2)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
3.76	4.74	12.0	0.7	4.2	87.1

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
12.3	95.7	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	64,290.6	64,290.6
SGA use (MB):	40,064.0	40,064.0
PGA use (MB):	616.0	803.4
% Host Mem used for SGA+PGA:	63.28	63.57

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	89.32	0.12
Global Cache blocks served:	54.57	0.07
GCS/GES messages received:	611.31	0.83
GCS/GES messages sent:	785.86	1.06
DBWR Fusion writes:	2.20	0.00
Estd Interconnect traffic (KB)	1,424.01

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %:	99.47
Buffer access - remote cache %:	0.13
Buffer access - disk %:	0.40

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	0.8
Avg global cache current block receive time (ms):	0.8
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	26.8
Avg global cache cr block flush time (ms):	5.3
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.2
Avg global cache current block flush time (ms):	5.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.1
Avg message sent queue time on ksxp (ms):	3.3
Avg message received queue time (ms):	0.1
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	88.08
% of indirect sent messages:	11.03
% of flow controlled messages:	0.89

Cluster Interconnect

• if IP/Public/Source at End snap is different a '*' is displayed

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

More RAC Statistics

• RAC Report Summary
• Global Messaging Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats
• Interconnect Stats
• Dynamic Remastering Statistics

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): 12354.9s
• 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 100.2% of Total DB time 12,354.89 (s)
• Total FG Wait Time: 2,218.45 (s) DB CPU time: 10,157.36 (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)

No data exists for this section of the report.

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
• SQL ordered by Cluster Wait Time
• 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 79.0% of Total DB Time (s): 12,355
• Captured PL/SQL account for 41.1% of Total DB Time (s): 12,355

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 90.4% of Total CPU Time (s): 10,157
• Captured PL/SQL account for 28.5% of Total CPU Time (s): 10,157

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 23.1% of Total User I/O Wait Time (s): 1,975
• Captured PL/SQL account for 99.5% of Total User I/O Wait Time (s): 1,975

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: 246,033,664
• Captured SQL account for 94.5% 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,012,321
• Captured SQL account for 76.9% 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: 991,086
• Captured SQL account for 70.4% of Total
• Total UnOptimized Read Requests: 991,086
• Captured SQL account for 70.4% 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: 27,155,913
• Captured SQL account for 99.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 11,736
• Captured SQL account for 30.2% 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

SQL ordered by Cluster Wait Time

• %Total - Cluster Time as a percentage of Total Cluster Wait Time
• %Clu - Cluster Time as a percentage of Elapsed Time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Only SQL with Cluster Wait Time > .005 seconds is reported
• Total Cluster Wait Time (s): 180
• Captured SQL account for 49.0% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
02hjz6g48sth1	INSERT INTO "FOHOW"."SYS_EXPORT_SCHEMA_01" (object_type_path, object_path_seqno, dump_fileid, dump_position, dump_length, dump_orig_length, dump_allocation, process_order, duplicate, object_row, object_type, object_schema, original_object_schema, object_name, object_long_name, original_object_name, partition_name, subpartition_name, object_tablespace, grantor, flags, processing_state, processing_status, base_process_order, base_object_type, base_object_schema, base_object_name, domain_process_order, xml_clob, ancestor_process_order, property, trigflag, size_estimate, creation_level, parent_process_order, value_n, object_int_oid, metadata_io) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :13, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38)
0ctk7jpux5chm	WITH RECINFO AS ( SELECT /*+ NO_MERGE */ FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE ), F_CURR AS ( SELECT /*+ NO_MERGE */ DISTINCT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ), TASKS AS ( SELECT /*+ NO_MERGE */ T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ), F_ALL AS ( SELECT /*+ NO_MERGE */ COUNT(FA.TASK_ID) FINDING_COUNT, FA.FINDING_NAME FROM TASKS, DBA_ADVISOR_FINDINGS FA WHERE FA.TASK_ID=TASKS.TASK_ID AND FA.TYPE<>'INFORMATION' AND FA.TYPE<>'WARNING' AND FA.PARENT=0 GROUP BY FA.FINDING_NAME ), HISTORY AS ( SELECT /*+ NO_MERGE */ FINDING_NAME, FINDING_COUNT FROM F_ALL JOIN F_CURR USING (FINDING_NAME) ) SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_CHAR(TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') START_TIME, TO_CHAR(TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, RECINFO, HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID
0d68h5pbk1c2u	SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('CLUSTER_T', '7')), KU$.OBJ_NUM , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'CLUSTER' , KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_CLUSTER_VIEW KU$ WHERE NOT (BITAND (KU$.SCHEMA_OBJ.FLAGS, 16)=16) AND KU$.SCHEMA_OBJ.OWNER_NAME IN ('FOHOW') AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='CLUSTER' AND A.NAME=KU$.SCHEMA_OBJ.NAME AND A.SCHEMA=KU$.SCHEMA_OBJ.OWNER_NAME) AND NOT EXISTS (SELECT 1 FROM SYS.KU$NOEXP_TAB A WHERE A.OBJ_TYPE='SCHEMA' AND A.NAME=KU$.SCHEMA_OBJ.OWNER_NAME)
0d8qqajhctpbx	SELECT COUNT(1) FROM MI_TEMP_TREE T WHERE T.QTY_MEMBER=:B1 AND T.S_TYPE=1
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0kwk7211pw296	SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'INDEX' , KU$.PROPERTY , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , to_char(KU$.TYPE_NUM) , decode(cardinality(KU$.COL_LIST), 0, '1', '0') FROM SYS.KU$_INDEX_VIEW KU$ WHERE NOT KU$.FOR_PKOID=1 AND NOT KU$.FOR_REFPAR=1 AND NOT (KU$.TYPE_NUM=1 AND KU$.INTCOLS=1 AND KU$.OID_OR_SETID!=0) AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4)=4 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%' AND KU$.TYPE_NUM NOT IN (2, 4, 8, 9) AND BITAND(KU$.PROPERTY, 16)!=16 ORDER BY KU$.SCHEMA_OBJ.OWNER_NUM, KU$.SCHEMA_OBJ.DATAOBJ_NUM
0qjwvbbzvyfyq	UPDATE MI_MEMBER_RIGHT A SET A.LEVEL_TYPE=:B6 , A.CICLES=:B5 , A.STAGE=:B4 , A.LEFT_POINT=:B3 , A.RIGHT_POINT=:B2 WHERE A.RIGHT_NO=:B1
12ajzj85jmfyq	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_generate_period; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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)
1dqnujsswkgp4	SELECT COUNT(1) FROM MI_TEMP_TREE T WHERE T.QTY_MEMBER=:B1 AND T.S_TYPE=0
1fzj71h9hfw0c	SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , 'TABLE' , to_char(KU$.BYTES_ALLOC) , KU$.SCHEMA_OBJ.CTIME , KU$.DATAOBJ_NUM , to_char(KU$.ET_PARALLEL) , KU$.FGAC , KU$.LONGCOL , KU$.NONSCOPED_REF , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.NAME , KU$.NAME , 'TABLE_DATA' , KU$.PART_NAME , KU$.PARTTYPE , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.SCHEMA_OBJ.NAME , NULL , KU$.TRIGFLAG , decode(KU$.SCHEMA_OBJ.TYPE_NUM, 2, decode(bitand(KU$.PROPERTY, 8224), 8224, 'NESTED PARTITION', 8192, 'NESTED TABLE', 'TABLE'), 19, decode(bitand(KU$.PROPERTY, 8224), 8224, 'NESTED PARTITION', 'PARTITION'), 20, 'PARTITION', 'SUBPARTITION') , to_char(KU$.UNLOAD_METHOD) , KU$.XMLTYPE_FMTS FROM SYS.KU$_TABLE_DATA_VIEW KU$ WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT (BITAND (KU$.BASE_OBJ.FLAGS, 16)=16) AND NOT XML_OUTOFLINE='Y' AND KU$.BASE_OBJ.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(100001)))
1r753qqbqh2p9	SELECT * FROM MI_TEMP_TREE WHERE QTY_MEMBER=:B1 AND S_TYPE=1 ORDER BY ID
1w7fv5knjzasm	BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_01', 'FOHOW', 0); END;
263b131s04ds5	SELECT COUNT(1) FROM MI_TEMP_TREE T WHERE T.LINK_NO=:B2 AND T.QTY_MEMBER=:B1 AND T.STATUS=1 AND T.S_TYPE=0
2f3candgy4kxz	SELECT TIMEZONE_REGION , TARGET_TYPE, EMD_URL, MONITORING_MODE FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
2jfqzrxhrm93b	select /*+ rule */ 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#
2wuxsvgst612h	SELECT NVL(AVG(VALUE), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME=:B2 AND NAME=:B1 AND TIME>(SYSDATE-(1/24))
3fktvz8ssnwyr	SELECT COUNT(1) FROM MI_TEMP_TREE T WHERE T.LINK_NO=:B2 AND T.QTY_MEMBER=:B1 AND T.STATUS=1 AND T.S_TYPE=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 )
45tg25j85snzc	SELECT VIOLATION_LEVEL, COLLECTION_TIMESTAMP FROM (SELECT VIOLATION_LEVEL, COLLECTION_TIMESTAMP FROM MGMT_VIOLATIONS, (SELECT MAX(COLLECTION_TIMESTAMP) AS MAX_TS FROM MGMT_VIOLATIONS WHERE TARGET_GUID = :B5 AND POLICY_GUID = :B4 AND KEY_VALUE = :B3 AND COLLECTION_TIMESTAMP > :B2 AND COLLECTION_TIMESTAMP <= :B1 ) TS WHERE TARGET_GUID = :B5 AND POLICY_GUID = :B4 AND KEY_VALUE = :B3 AND COLLECTION_TIMESTAMP = TS.MAX_TS ORDER BY DECODE(VIOLATION_LEVEL, :B11 , 1, :B10 , 2, :B9 , 3, :B8 , 4, :B7 , 5, :B6 , 6, 9)) WHERE ROWNUM = 1
45wng0c0dnbmw	UPDATE MGMT_LAST_VIOLATION SET COLLECTION_TIMESTAMP = :B2 WHERE ROWID = :B1
47a50dvdgnxc2	update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
4c6hn50sn1mwf	UPDATE MI_TEMP_TREE A SET A.STATUS=0 WHERE A.RIGHT_NO=:B2 AND A.QTY_MEMBER=:B1 AND A.S_TYPE=1
4g46czps3t55u	SELECT sum(case when snap_id = :begin_snap_id then value else 0 end) as begin_sga, sum(case when snap_id = :end_snap_id then value else 0 end) as end_sga FROM WRH$_SGA sga WHERE sga.dbid = :dbid AND sga.instance_number = :inst_num AND (sga.snap_id = :begin_snap_id OR sga.snap_id = :end_snap_id )
4gjq0xf0rw497	SELECT /*+ cardinality(d 20) */ MAX(MGMT_GLOBAL.ADJUST_TZ(MARKER_TIMESTAMP, T.TIMEZONE_REGION, :B3 )) FROM MGMT_AVAILABILITY_MARKER M, MGMT_TARGETS T, TABLE(CAST(:B1 AS MGMT_METRIC_DETAILS_ARRAY)) D WHERE T.TARGET_GUID = M.TARGET_GUID AND T.TARGET_GUID = D.TARGET_GUID AND M.MARKER_AVAIL_STATUS = :B2
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4r4spntz1mvbm	UPDATE MI_TEMP_TREE A SET A.STATUS=0 WHERE A.RIGHT_NO=:B2 AND A.QTY_MEMBER=:B1 AND A.S_TYPE=0
4zaqzu3gjk3us	UPDATE MI_TEMP_TREE T SET T.LEFT_MEM=CASE WHEN T.LEFT_MEM=:B3 THEN NULL ELSE T.LEFT_MEM END, T.RIGHT_MEM=CASE WHEN T.RIGHT_MEM=:B3 THEN NULL ELSE T.RIGHT_MEM END WHERE T.RIGHT_NO=:B2 AND T.QTY_MEMBER=:B1 AND T.S_TYPE=1
5r8jah3jm5au2	SELECT TARGETS.TARGET_NAME, TARGETS.TARGET_TYPE, TARGETS.TIMEZONE_REGION, TARGETS.EMD_URL, NVL(CAST(SYSTIMESTAMP AT TIME ZONE TARGETS.TIMEZONE_REGION AS DATE), :B2 ) FROM MGMT_TARGETS TARGETS WHERE TARGETS.TARGET_GUID = :B1
62jfzru1s1mz1	SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.SPARE1 , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'TABLE' , KU$.PARENT_OBJ.NAME , KU$.PARENT_OBJ.OWNER_NAME , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.TRIGFLAG FROM SYS.KU$_FHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY, 8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 128)!=0 AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND (BITAND(KU$.FLAGS, 536870912)=0)
6mr85amnfxgw5	select * from ( select mimemberri0_.ID as ID135_, mimemberri0_.ACTIVE_DATE as ACTIVE2_135_, mimemberri0_.CANNO_LINK as CANNO3_135_, mimemberri0_.CICLES as CICLES135_, mimemberri0_.CREATE_TIME as CREATE5_135_, mimemberri0_.LEFT_MEM as LEFT6_135_, mimemberri0_.LEFT_POINT as LEFT7_135_, mimemberri0_.LEVEL_TYPE as LEVEL8_135_, mimemberri0_.LINK_INDEX as LINK9_135_, mimemberri0_.LINK_LAYER as LINK10_135_, mimemberri0_.LINK_NO as LINK11_135_, mimemberri0_.MEMBER_NO as MEMBER12_135_, mimemberri0_.PRIM_RIGHT as PRIM13_135_, mimemberri0_.PV as PV135_, mimemberri0_.PV_LIMIT as PV15_135_, mimemberri0_.RIGHT_MEM as RIGHT16_135_, mimemberri0_.RIGHT_NO as RIGHT17_135_, mimemberri0_.RIGHT_POINT as RIGHT18_135_, mimemberri0_.STAGE as STAGE135_ from MI_MEMBER_RIGHT mimemberri0_ where upper(mimemberri0_.RIGHT_NO)=:"SYS_B_0" ) where rownum <= :1
6vz8hq2s1r7q2	UPDATE MI_TEMP_TREE T SET T.LEFT_MEM=CASE WHEN T.LEFT_MEM=:B3 THEN NULL ELSE T.LEFT_MEM END, T.RIGHT_MEM=CASE WHEN T.RIGHT_MEM=:B3 THEN NULL ELSE T.RIGHT_MEM END WHERE T.RIGHT_NO=:B2 AND T.QTY_MEMBER=:B1 AND T.S_TYPE=0
74fn1rxxbzafj	SELECT * FROM MI_TEMP_TREE WHERE QTY_MEMBER=:B1 AND S_TYPE=0 ORDER BY ID
7f5pj3jtqavnn	SELECT A.DATABASE_TIME, ( CAST(A.END_TIME AS DATE) - CAST(A.BEGIN_TIME AS DATE) ) * 86400, A.ACTUAL_ANALYSIS, A.PERC_FLUSH_TIME FROM WRI$_ADV_ADDM_TASKS A WHERE A.TASK_ID = :B1
7gfrxtzn9aj48	SELECT MAX(A.LEFT_MEM), MAX(A.RIGHT_MEM), MAX(A.LINK_NO), MAX(A.MEMBER_NO), MAX(A.PRIM_RIGHT) FROM MI_MEMBER_RIGHT A WHERE A.RIGHT_NO=:B1
7zv0mgby4ypst	SELECT A.* , B.LEFT_POINT, B.RIGHT_POINT, B.LEVEL_TYPE FROM (SELECT R.*, LEVEL LEVEL_NUM FROM (SELECT * FROM MI_TEMP_TREE R WHERE STATUS = 1 AND QTY_MEMBER = :B1 AND S_TYPE = 0) R START WITH RIGHT_NO = :B2 CONNECT BY PRIOR RIGHT_NO = LINK_NO ) A LEFT JOIN MI_MEMBER_RIGHT B ON A.RIGHT_NO=B.RIGHT_NO WHERE A.LEVEL_NUM<=:B3 ORDER BY LEVEL_NUM
89sdz401dc5uf	select program_oid, schedule_expr, schedule_id, queue_owner, queue_name, queue_agent, event_rule, mxdur_msgid, last_enabled_time, class_oid, next_run_date, last_start_date, last_end_date, retry_count, run_count, failure_count, running_instance, running_slave, flags, job_status, creator, client_id, guid, char_env, start_date, end_date, instance_id, fw_name, fw_oid, destination, credential_name, credential_owner, credential_oid, dest_oid, job_dest_id, run_invoker, program_action, schedule_limit, priority, job_weight, number_of_args, max_runs, max_failures, max_run_duration, comments, user_callback, user_callback_ctx, nls_env, source, env, database_role, owner_udn, dist_flags from sys.scheduler$_job where obj# = :1
8s4f46j882h3x	select t.schema, t.name, t.flags, q.name, t.timezone, a.owner_instance owner from system.aq$_queue_tables t, system.aq$_queues q, sys.aq$_queue_table_affinities a where t.objno = :1 and q.table_objno = t.objno and a.table_objno = t.objno and q.usage = 0 and NOT ( t.name in ('DEF$_AQCALL' , 'DEF$_AQERROR') and t.schema = 'SYSTEM')
8x0funf899dka	INSERT INTO wri$_adv_addm_inst ( TASK_ID, INSTANCE_NUMBER, INSTANCE_NAME, HOST_NAME, STATUS, DATABASE_TIME, ACTIVE_SESSIONS, PERC_ACTIVE_SESS, METER_LEVEL, LOCAL_TASK_ID) VALUES ( :tid, :inst_num, :inst_name, :host_name, :st, NULL, NULL, NULL, NULL, NULL)
99zgubwpmt6du	select a.link_no, a.left_mem, a.right_mem, a.right_no, a.link_layer-to_number(:"SYS_B_0")as link_layer, a.level_type , to_char(b.register_date, :"SYS_B_1") as register_date, to_char(a.create_time, :"SYS_B_2") as create_time, b.member_no, b.name, b.pet_name, a.link_index from MI_MEMBER_RIGHT a left join Mi_Member b on a.member_no=b.member_no where a.link_index like :"SYS_B_3" and a.link_layer <= :"SYS_B_4" order by a.link_layer, a.LINK_INDEX
9bnq0p35szvc7	SELECT COUNT(1) FROM MI_MEMBER T WHERE T.MEMBER_NO=:B2 AND T.CARD_TYPE>=:B1
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
9f5w5w3rg742y	BEGIN Pack_BD.Proc_BONUS_Send(I_WEEK=>:1, I_USER_CODE=>:2, I_USER_NAME=>:3, O_STATUS=>:4, O_MSG=>:5); END;
9g7a43gqdap1t	insert into WRH$_PERSISTENT_QUEUES (snap_id, dbid, instance_number, queue_schema, queue_name, queue_id, first_activity_time, enqueued_msgs, dequeued_msgs, browsed_msgs, elapsed_enqueue_time, elapsed_dequeue_time, enqueue_cpu_time, dequeue_cpu_time, avg_msg_age, dequeued_msg_latency, elapsed_transformation_time, elapsed_rule_evaluation_time, enqueued_expiry_msgs, enqueued_delay_msgs, msgs_made_expired, msgs_made_ready, last_enqueue_time, last_dequeue_time, last_tm_expiry_time, last_tm_ready_time, enqueue_transactions, dequeue_transactions, execution_count) select * from (select :snap_id, :dbid, :instance_number, qs.queue_schema, qs.queue_name, qs.queue_id, qs.first_activity_time, qs.enqueued_msgs, qs.dequeued_msgs, qs.browsed_msgs, qs.elapsed_enqueue_time, qs.elapsed_dequeue_time, qs.enqueue_cpu_time, qs.dequeue_cpu_time, qs.avg_msg_age, qs.dequeued_msg_latency, qs.elapsed_transformation_time, qs.elapsed_rule_evaluation_time, qs.enqueued_expiry_msgs, qs.enqueued_delay_msgs, qs.msgs_made_expired, qs.msgs_made_ready, qs.last_enqueue_time, qs.last_dequeue_time, qs.last_tm_expiry_time, qs.last_tm_ready_time, qs.enqueue_transactions, qs.dequeue_transactions, qs.execution_count from v$persistent_queues qs order by qs.enqueued_msgs desc) where rownum <= 25
9qd75yuctp7f9	DELETE FROM MI_TEMP_TREE T WHERE T.QTY_MEMBER=:B1 AND T.S_TYPE=0
adm3ba32apxjg	select * from ( select sysvisitlo0_.LOG_ID as LOG1_119_, sysvisitlo0_.MODULE_CODE as MODULE2_119_, sysvisitlo0_.QUERY_STRING as QUERY3_119_, sysvisitlo0_.USER_CODE as USER4_119_, sysvisitlo0_.VISIT_TIME as VISIT5_119_, sysvisitlo0_.VISIT_URL as VISIT6_119_ from SYS_VISIT_LOG sysvisitlo0_ where sysvisitlo0_.USER_CODE=:"SYS_B_0" and sysvisitlo0_.MODULE_CODE=:"SYS_B_1" and sysvisitlo0_.VISIT_URL=:"SYS_B_2" ) where rownum <= :1
afs7xvpbqcjmz	SELECT TARGET_NAME , TARGET_TYPE FROM MGMT_TARGETS WHERE TARGET_GUID = :B1
aktbxfjwnzgmu	update WRM$_DATABASE_INSTANCE set last_ash_sample_id = :last_ash_sample_id where instance_number = :instance_number and dbid = :dbid and startup_time = (select max(startup_time) from WRM$_DATABASE_INSTANCE where instance_number = :instance_number2 and dbid = :dbid2 )
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
axwhjvvjc279c	SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('VIEW_T', '7')), KU$.OBJ_NUM , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'VIEW' , KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_VIEW_VIEW KU$ WHERE KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001)))
aymwrjd8thcp9	UPDATE MI_TEMP_TREE SET LINK_NO=:B3 WHERE RIGHT_NO=:B2 AND QTY_MEMBER=:B1 AND S_TYPE=1
b41wak2bb7atw	SELECT sum(delta_cpu_time) as total_cpu, sum(case when session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' ) then delta_cpu_time else 0 end) as logmr_cpu, sum(case when session_type in ( 'STREAMS Capture' ) then delta_cpu_time else 0 end) as captr_cpu, sum(case when session_type in ( 'Propagation Sender' , 'Propagation Receiver' ) then delta_cpu_time else 0 end) as prpgt_cpu, sum(case when session_type in ( 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' ) then delta_cpu_time else 0 end) as apply_cpu, sum(case when session_type in ( 'QMON Slaves' , 'QMON Coordinator' ) then delta_cpu_time else 0 end) as qmon_cpu FROM ( SELECT b.session_type, (case when b.min_logon_time = e.min_logon_time then e.sum_cpu_time - b.sum_cpu_time else e.sum_cpu_time end) as delta_cpu_time FROM wrh$_sess_time_stats b, wrh$_sess_time_stats e WHERE b.dbid = :dbid AND b.instance_number = :inst_num AND b.snap_id = :begin_snap_id AND e.dbid = :dbid AND e.instance_number = :inst_num AND e.snap_id = :end_snap_id AND e.session_type = b.session_type AND e.session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' , 'STREAMS Capture' , 'Propagation Sender' , 'Propagation Receiver' , 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' , 'QMON Slaves' , 'QMON Coordinator' ) ) all_types
b4vj25ffhkkcw	SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('CONSTRAINT_T', '7')), 0 , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.NAME , KU$.NAME , 'CONSTRAINT' , KU$.OWNER_NAME FROM SYS.KU$_CONSTRAINT_VIEW KU$ WHERE NOT (KU$.CON1.CONTYPE=3 AND KU$.CON1.INTCOLS=1 AND KU$.CON1.OID_OR_SETID!=0) AND NOT (KU$.CON1.CONTYPE=2 AND BITAND(KU$.CON1.PROPERTY, 64+4096)!=0) AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.OWNER_NAME IN ('FOHOW') AND (KU$.CON1.CONTYPE NOT IN (5) OR KU$.CON1.IND.TYPE_NUM NOT IN (4, 8, 9))
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
c8ykmx98xf3qp	BEGIN Pack_BD.Proc_BONUS_SEAS_Send(I_WEEK=>:1, I_USER_CODE=>:2, I_USER_NAME=>:3, O_STATUS=>:4, O_MSG=>:5); END;
cjgjaw0jj7a0t	UPDATE "FOHOW"."SYS_EXPORT_SCHEMA_01" SET last_update = sysdate, object_number = :1, object_schema = :2, object_name = :3, object_long_name = :4, object_type_path = :5, partition_name = DECODE(partition_name, NULL, NULL, :6), subpartition_name = DECODE(subpartition_name, NULL, NULL, :7), total_bytes = :8, completed_rows = :9, metadata_io = :10, cumulative_time = :11, parallelization = :12 WHERE process_order = :13 AND duplicate = :14
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
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
cxzm9sm10xx7c	DELETE FROM MI_TEMP_TREE T WHERE T.QTY_MEMBER=:B1 AND T.S_TYPE=1
df102877pydz6	SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('INDEX_T', '7')), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , 'INDEX' , KU$.PROPERTY , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , to_char(KU$.TYPE_NUM) , decode(cardinality(KU$.COL_LIST), 0, '1', '0') FROM SYS.KU$_INDEX_VIEW KU$ WHERE NOT KU$.FOR_PKOID=1 AND NOT KU$.FOR_REFPAR=1 AND NOT BITAND(KU$.BASE_OBJ.FLAGS, 128)!=0 AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, 4)=4 AND KU$.BASE_OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001))) AND KU$.SCHEMA_OBJ.OWNER_NAME LIKE '%' AND KU$.TYPE_NUM NOT IN (2, 9) AND BITAND(KU$.PROPERTY, 16)=16 ORDER BY KU$.SCHEMA_OBJ.OWNER_NUM, KU$.SCHEMA_OBJ.DATAOBJ_NUM
dhckjqk6m93k4	UPDATE MI_MEMBER A SET A.CARD_TYPE=(CASE WHEN :B2 <>:B3 THEN :B2 ELSE A.CARD_TYPE END) , A.ACTIVE_TIME=(CASE WHEN :B2 >=1 AND A.ACTIVE_TIME IS NULL THEN (SELECT MIN(B.ACTIVE_DATE) FROM MI_MEMBER_RIGHT B WHERE B.MEMBER_NO=A.MEMBER_NO AND B.LEVEL_TYPE>=2 AND B.ACTIVE_DATE IS NOT NULL) ELSE A.ACTIVE_TIME END ) WHERE A.MEMBER_NO=:B1
dqz9cqz6by5q4	SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2(:"SYS_B_0", :"SYS_B_1")), KU$.OBJ_NUM , KU$.ANC_OBJ.NAME , KU$.ANC_OBJ.OWNER_NAME , KU$.ANC_OBJ.TYPE_NAME , KU$.BASE_OBJ.NAME , KU$.BASE_OBJ.OWNER_NAME , KU$.BASE_OBJ.TYPE_NAME , KU$.SPARE1 , KU$.TSTZ_COLS , KU$.XMLSCHEMACOLS , KU$.SCHEMA_OBJ.NAME , KU$.SCHEMA_OBJ.NAME , :"SYS_B_2" , KU$.PARENT_OBJ.NAME , KU$.PARENT_OBJ.OWNER_NAME , KU$.PROPERTY , KU$.REFPAR_LEVEL , KU$.SCHEMA_OBJ.OWNER_NAME , KU$.TS_NAME , KU$.TRIGFLAG FROM SYS.KU$_HTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY, :"SYS_B_3")=:"SYS_B_4") AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS, :"SYS_B_5")!=:"SYS_B_6" AND KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(:"SYS_B_7"))) AND (BITAND(KU$.FLAGS, :"SYS_B_8")=:"SYS_B_9")
du06j3n768535	INSERT INTO BD_BONUS_HIS_RIGHT_SEAS (ID, W_WEEK, BONUS_TYPE, RIGHT_NO, MEMBER_NO, LINK_NO, PRIM_RIGHT, ACTIVE_DATE, LEVEL_TYPE, PER_SELL, POINT_START, POINT_ADD, POINT, CREATE_TIME, PV_LIMIT, PV, LINK_INDEX, BONUS_LEVEL, LINK_LAYER, NEW_LEVEL_TYPE, REG_PV, NEW_REG_PV, LAST_POINT, PRE_LAST_POINT) SELECT ID, W_WEEK, BONUS_TYPE, RIGHT_NO, MEMBER_NO, LINK_NO, PRIM_RIGHT, ACTIVE_DATE, LEVEL_TYPE, PER_SELL, POINT_START, POINT_ADD, POINT, CREATE_TIME, PV_LIMIT, PV, LINK_INDEX, BONUS_LEVEL, LINK_LAYER, NEW_LEVEL_TYPE, REG_PV, NEW_REG_PV, LAST_POINT, PRE_LAST_POINT FROM BD_BONUS_CALC_RIGHT_SEAS WHERE W_WEEK=:B1
fyza0rwfw1j03	INSERT INTO MI_TEMP_TREE (ID, MEMBER_NO, RIGHT_NO, LINK_NO, QTY_MEMBER, LEFT_MEM, RIGHT_MEM, S_TYPE, OLD_LEFT_MEM, OLD_RIGHT_MEM, OLD_LINK_NO, PRIM_RIGHT) SELECT SEQ_MI_TEMP_TREE.NEXTVAL, :B8 , :B7 , :B2 , :B6 , :B4 , :B3 , :B5 , :B4 , :B3 , :B2 , :B1 FROM DUAL

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