WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
MCSDB	2372875213	MCSDB2	2	08-2月 -14 20:02	11.2.0.3.0	YES

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dm01db02.mcsdb.com	Linux x86 64-bit	24	12	2	94.47

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	12006	16-4月 -14 21:00:40	1109	8.0
End Snap:	12008	16-4月 -14 23:00:28	1091	8.2
Elapsed:		119.80 (mins)
DB Time:		14.70 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	35,840M	35,840M	Std Block Size:	8K
Shared Pool Size:	12,928M	12,928M	Log Buffer:	156,956K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.1	0.0	0.00	0.00
DB CPU(s):	0.1	0.0	0.00	0.00
Redo size:	52,454.0	1,615.4
Logical reads:	4,127.6	127.1
Block changes:	249.7	7.7
Physical reads:	53.4	1.6
Physical writes:	17.5	0.5
User calls:	1,164.8	35.9
Parses:	63.7	2.0
Hard parses:	0.4	0.0
W/A MB processed:	1.5	0.0
Logons:	1.7	0.1
Executes:	330.5	10.2
Rollbacks:	24.7	0.8
Transactions:	32.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	99.69	Soft Parse %:	99.45
Execute to Parse %:	80.73	Latch Hit %:	99.40
Parse CPU to Parse Elapsd %:	56.21	% Non-Parse CPU:	98.08

Shared Pool Statistics

	Begin	End
Memory Usage %:	86.86	86.80
% SQL with executions>1:	99.21	98.58
% Memory for SQL w/exec>1:	93.02	94.10

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.77	3.50	11.7	0.6	0.0	87.7

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
11.1	89.9	0.1

Memory Statistics

	Begin	End
Host Mem (MB):	96,738.8	96,738.8
SGA use (MB):	51,200.0	51,200.0
PGA use (MB):	4,085.0	3,917.5
% Host Mem used for SGA+PGA:	57.15	56.98

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	23.03	0.71
Global Cache blocks served:	237.95	7.33
GCS/GES messages received:	2,020.90	62.24
GCS/GES messages sent:	1,126.20	34.68
DBWR Fusion writes:	8.96	0.28
Estd Interconnect traffic (KB)	2,702.54

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

Buffer access - local cache %:	99.42
Buffer access - remote cache %:	0.57
Buffer access - disk %:	0.02

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.0
Avg global cache cr block receive time (ms):	0.1
Avg global cache current block receive time (ms):	0.1
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 %:	5.6
Avg global cache cr block flush time (ms):	0.4
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.3
Avg global cache current block flush time (ms):	0.4

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.1
Avg message sent queue time on ksxp (ms):	0.0
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:	28.38
% of indirect sent messages:	71.33
% of flow controlled messages:	0.29

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): 881.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

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 114.6% of Total DB time 881.74 (s)
• Total FG Wait Time: 116.26 (s) DB CPU time: 893.91 (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 29.3% of Total DB Time (s): 882
• Captured PL/SQL account for 5.2% of Total DB Time (s): 882

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 17.6% of Total CPU Time (s): 894
• Captured PL/SQL account for 3.3% of Total CPU Time (s): 894

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 36.9% of Total User I/O Wait Time (s): 17
• Captured PL/SQL account for 13.3% of Total User I/O Wait Time (s): 17

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: 29,669,997
• Captured SQL account for 44.7% 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: 383,639
• Captured SQL account for 98.7% 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: 8,391
• Captured SQL account for 28.8% of Total
• Total UnOptimized Read Requests: -33,853
• Captured SQL account for -0.6% of Total
• Total Optimized Read Requests: 42,244
• Captured SQL account for 5.2% 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: 2,375,359
• Captured SQL account for 62.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 457,746
• Captured SQL account for 32.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

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): 24
• Captured SQL account for 18.8% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
0az7czjdw8z7j	declare lbRec dbms_rcvman.lbRec_t; lbCursor dbms_rcvman.lbCursor_t; first boolean := FALSE; ret boolean; begin if (:first > 0) then first := TRUE; end if; <<next_row>> ret := dbms_rcvman.listBackup( lbRecOut => lbRec, firstCall => first, only_obsolete => TRUE, redundancy => :redundancy, piped_call => FALSE, lbCursor => lbCursor, lbState => dbms_rcvman.lbStatePck, extRlKeepSCN => NULL); if (not ret) then raise no_data_found; elsif (lbRec.pkey is not null and lbRec.is_rdf = 'YES') then :backup_type := lbRec.backup_type; :file_type := lbRec.file_type; :key := lbRec.pkey; else first := FALSE; goto next_row; end if; end;
0h9q31bxn3xjq	SELECT VARIABLE_ID, VAR_NAME, VAR_TYPE, VAR_DESC, VAR_DATATYPE, VAR_DEFAULT, LAST_SAVED, TASK_INST_ID, TASK_INST_NAME, OPB_OBJECT_ID, BIT_OPTIONS FROM OPB_WFLOW_VAR WHERE WORKFLOW_ID = :1 AND SUBJECT_ID = :2 AND VERSION_NUMBER = :3
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0qjqs2v8xx40a	SELECT RULESET_ID FROM OPB_PROF_RULESET WHERE MAPPING_ID = :1
0shksdzxpp4bh	select snap_interval, retention, most_recent_snap_time, most_recent_snap_id, status_flag, most_recent_purge_time, most_recent_split_id, most_recent_split_time, mrct_snap_time_num, mrct_purge_time_num, snapint_num, retention_num, swrf_version, registration_status, mrct_baseline_id, topnsql, mrct_bltmpl_id from wrm$_wr_control where dbid = :dbid
0usufbcmyzurv	SELECT S.MAPPING_ID, S.BIT_OPTIONS, S.SORT_ORDER, S.IS_PARTITIONED, S.IS_RECOVERY, T.IS_INVALIDATED, S.OPB_OBJECT_ID FROM OPB_SESSION S, OPB_TASK T WHERE S.SESSION_ID = :1 AND S.VERSION_NUMBER = :2 AND S.SESSION_ID = T.TASK_ID AND S.VERSION_NUMBER = T.VERSION_NUMBER
0v6s91manuhz8	/* OracleOEM */ SELECT blocking_sid, num_blocked FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked FROM ( SELECT l.id1, l.id2, MAX(DECODE(l.block, 1, i.instance_name||'-'||l.sid, 2, i.instance_name||'-'||l.sid, 0 )) blocking_sid, SUM(DECODE(l.request, 0, 0, 1 )) num_blocked FROM gv$lock l, gv$instance i WHERE ( l.block!= 0 OR l.request > 0 ) AND l.inst_id = i.inst_id GROUP BY l.id1, l.id2) GROUP BY blocking_sid ORDER BY num_blocked DESC) WHERE num_blocked != 0 AND blocking_sid != '0'
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')
10tu9q0t9x5df	SELECT LOMN_DLVPLANINFO.CODE, LOMN_DLVPLANINFO.OILDEPOT, LOMN_DLVPLANINFO.PLANQTY, LOMN_DLVPLANINFO.RESPLANCODE FROM LOMN_DLVPLANINFO WHERE LOMN_DLVPLANINFO.ETLUPDATETIME>=to_date('2014-04-16 19:57:01', 'yyyy-mm-dd hh24:mi:ss') OR LOMN_DLVPLANINFO.RESPLANCODE IN(SELECT LOMN_TRSPLANINFO.RESPLANCODE FROM LOMN_DLVPLANINFO, LOMN_TRSPLANINFO WHERE LOMN_DLVPLANINFO.CODE = LOMN_TRSPLANINFO.DLVPLANCODE AND LOMN_DLVPLANINFO.RESPLANCODE = LOMN_TRSPLANINFO.RESPLANCODE AND LOMN_TRSPLANINFO.ETLUPDATETIME >= TO_DATE('2014-04-16 19:57:01', 'yyyy-mm-dd hh24:mi:ss'))
127jctf32srap	SELECT METAEXT_NAME, VENDOR_ID, DOMAIN_ID, DATA_TYPE, PERMISSIONS, PM_VALUE, LINE_NO, OBJECT_TYPE, OBJECT_ID, MAX_LENGTH, METAEXT_DESC, BIT_OPTIONS, COMP_VERSION FROM OPB_METAEXT_VAL WHERE SUBJECT_ID = :1 AND OBJECT_ID = :2 AND OBJECT_TYPE = :3 AND VERSION_NUMBER = :4 ORDER BY OBJECT_TYPE, OBJECT_ID, VENDOR_ID, DOMAIN_ID, METAEXT_NAME, LINE_NO ASC
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)
16waf5s3dvfr2	SELECT PSD.* FROM GIS.MCS_TRAFFIC_REPORT PSD WHERE PSD.VEHICLE_ID= CAST(:B1 AS NUMBER)
17zfwmqaf3c6d	UPDATE VEHICLE_GPS_RT SET KPM = GetKPM(LONGITUDE_HIS, LATITUDE_HIS, LONGITUDE, LATITUDE, MSG_REC_TIME_HIS, MSG_REC_TIME), ANGLE = GetAngle(LONGITUDE_HIS, LATITUDE_HIS, LONGITUDE, LATITUDE), DISTANCE = GetDistance(LONGITUDE_HIS, LATITUDE_HIS, LONGITUDE, LATITUDE)*1000
1a19n674n5rpa	BEGIN :rv := FNC_GPS_GETDISTANCE (:1, :2, :3, :4) ; END;
1cq3qr774cu45	insert into WRH$_IOSTAT_FILETYPE (snap_id, dbid, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error) (select :snap_id, :dbid, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large_write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum (small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id)
1mcuj158m6wt7	SELECT SHORTCUT_NAME, REPOSITORY_NAME, REPOSITORY_ID, REFERENCE_TYPE, CREATION_TIME, OPB_SHORTCUT.COMMENTS, PARENT_ID, OBJECT_SUBTYPE, UTC_LAST_SAVED, IS_VISIBLE, VERSION_STATUS, UTC_REF_TIME, CHECKOUT_USER_ID, TEMPLATE_ID FROM OPB_SHORTCUT WHERE OBJECT_ID = :1 AND OBJECT_TYPE = :2 AND SUBJECT_ID = :3 AND VERSION_NUMBER = :4
2a99kfa1dykuy	update wrh$_seg_stat_obj sso set (index_type, base_obj#, base_object_name, base_object_owner) = (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 from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = sso.obj# and ind.dataobj# = sso.dataobj# and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#) where sso.dbid = :dbid and (ts#, obj#, dataobj#) in (select tsn_kewrseg, objn_kewrseg, objd_kewrseg from x$kewrtsegstat ss1 where objtype_kewrseg = 1) and sso.snap_id = :lah_snap_id and sso.object_type = 'INDEX'
2b064ybzkwf1y	BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2h9drc884789n	SELECT MACRO_ID, MACRO_NAME, MACRO_TYPE FROM OPB_WIDG_MCR_DEP WHERE WIDGET_ID = :1 AND VERSION_NUMBER = :2 AND INSTANCE_ID = 0 AND MAPPING_ID = 0
2jtv52vuv30ac	delete from mcsods.fct_traffic_un_alarm ft where ft.un_alarm_id in( select un_alarm_id from (select m.vehicle_gsmhm, m.times, m.outdepot_time, t.un_alarm_time, t.un_alarm_id, t.longitude, t.latitude from mcsods.fct_traffic_un_alarm t, mcsods.fct_traffic_monitor m where trunc(t.un_alarm_time) = to_date('20140416', 'yyyymmdd') and t.un_alarm_type = '02' and t.traffic_monitor_id = m.traffic_monitor_id) x inner join (select im.vehicle_gsmhm, im.times, im.outdepot_time, im.arrival_time, im.station_address_e, im.station_address_n from mcsods.fct_traffic_monitor im where im.stime = to_date('20140416', 'yyyymmdd')) y on x.vehicle_gsmhm=y.vehicle_gsmhm and x.times=y.times and x.outdepot_time=y.outdepot_time and mcsods.fnc_gps_getdistance(longitude, latitude, station_address_e, station_address_n)*1000<100)
2wuxsvgst612h	SELECT NVL(AVG(VALUE), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG WHERE JOB_NAME=:B2 AND NAME=:B1 AND TIME>(SYSDATE-(1/24))
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, 'LO B', 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)
334v05ngyyyzm	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_vehicle_seal_alarm; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
35y2u24f4rxqm	insert into wrh$_seg_stat_obj ( snap_id , dbid , ts# , obj# , dataobj# , owner , object_name , subobject_name , partition_type , object_type , tablespace_name) select :lah_snap_id , :dbid , ss1.tsn_kewrseg , ss1.objn_kewrseg , ss1.objd_kewrseg , ss1.ownername_kewrseg , ss1.objname_kewrseg , ss1.subobjname_kewrseg , decode(po.parttype, 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN') , sys.dbms_swrf_internal.awr_decode_object_type(ss1.objtype_kewrseg) , ss1.tsname_kewrseg from x$kewrattrnew at, x$kewrtsegstat ss1, (select tp.obj#, pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# union all select ip.obj#, pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj#) po where at.num1_kewrattr = ss1.objn_kewrseg and at.num2_kewrattr = ss1.objd_kewrseg and at.num1_kewrattr = po.obj#(+) and (ss1.objtype_kewrseg not in (1 /* INDEX - handled below */, 10 /* NON-EXISTENT */) or (ss1.objtype_ke wrseg = 1 and 1 = (select 1 from ind$ i where i.obj# = ss1.objn_kewrseg and i.type# in (1, 2, 3, 4, 5, 6, 7, 8, 9)))) and ss1.objname_kewrseg != '_NEXT_OBJECT' and ss1.objname_kewrseg != '_default_auditing_options_'
3mp0znhgacysm	SELECT P.USER_ID, P.COMMENTS, P.SAVED_FROM, P.LAST_SAVED, P.OBJECT_NAME, P.GROUP_NAME, P.OBJECT_SUBTYPE, P.IS_SHORTCUT, P.UTC_LAST_SAVED, P.PURGED_BY_USERID, P.UTC_CHECKOUT, P.UTC_CHECKIN, S.SUBJ_NAME, U.NAME FROM OPB_VERSION_PROPS P , OPB_SUBJECT S, OPB_USER_GROUP U WHERE P.SUBJECT_ID = S.SUBJ_ID AND P.USER_ID = U.ID AND U.TYPE = 1 AND P.OBJECT_ID = :1 AND P.OBJECT_TYPE = :2 AND P.VERSION_NUMBER = :3 AND P.SUBJECT_ID = :4
3sf7q4fxuzwhf	SELECT DISTINCT M.MAPPING_ID, M.SUBJECT_ID FROM OPB_MAPPING M, OPB_WIDGET_INST I, OPB_VALIDATE V, OPB_WIDGET W WHERE M.IS_VISIBLE = :1 AND M.MAPPING_ID = I.MAPPING_ID AND M.VERSION_NUMBER = I.VERSION_NUMBER AND M.REF_WIDGET_ID = 0 AND M.MAPPING_ID IN (186) AND I.WIDGET_TYPE = W.WIDGET_TYPE AND I.WIDGET_ID = W.WIDGET_ID AND V.SUBJECT_ID = W.SUBJECT_ID AND V.OBJECT_TYPE = I.WIDGET_TYPE AND V.OBJECT_ID = I.WIDGET_ID AND V.VERSION_NUMBER = W.VERSION_NUMBER AND V.INV_UTC > M.UTC_LAST_SAVED AND M.IS_VALID = 1 AND W.IS_REUSABLE = 1 AND (W.IS_VISIBLE <> 2 OR (W.IS_VISIBLE = 2 AND W.CHECKOUT_USER_ID = :2))
415urv6x9mf8w	SELECT /*+ RULE */ STEP_ID FROM MGMT_JOB_EXECUTION E, MGMT_JOB J WHERE E.JOB_ID=J.JOB_ID AND STEP_STATUS IN (:B8 , :B7 , :B6 , :B5 , :B4 , :B3 ) AND STEP_TYPE=:B2 AND J.EXECUTION_TIMEOUT > 0 AND (:B1 -E.START_TIME) > (J.EXECUTION_TIMEOUT/24)
41rghgddknhkf	SELECT /*+ordered*/ FE.FENUM DFNUMBER, FE.FECRC_SCN DFCREATIONSCN, TO_DATE(FE.FECRC_TIM, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') DFCREATIONTIME, FN.FNNAM FILENAME, TS.TSNAM TSNAME, FE.FETSN TSNUMBER, FE.FESTA STATUS, FH.FHFSZ BLOCKS, FE.FEBSZ BLOCKSIZE, FH.FHFSZ*FE.FEBSZ/1024 KBYTES, FE.FEURS UNRECOVSCN, DECODE(BITAND(FE.FESTA, (4096+128)), 0, NULL, FE.FECPS) STOPSCN, DECODE(BITAND(FE.FESTA, (4096+128 +4 )), 4096+4, 1, 128+4, 1, 0) READONLY, FE.FERFN RFNUMBER, DECODE(BITAND(TS.TSFLG, 2), 2, 0, 1) INBACKUP, DECODE(FE.FEPAX, 0 , NULL, 65535, NULL, FNAUX.FNNAM) AUXNAME, TO_NUMBER(NULL) DBINCKEY, TO_NUMBER(FE.FEOFS) DFOFFLINESCN, TO_NUMBER(FE.FEONC_SCN) DFONLINESCN, TO_DATE(NVL(FE.FEONC_TIM, '01/01/88 00:01:01'), 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') DFONLINETIME, DECODE(BITAND(TS.TSFLG, 16+32), 16, 1, 32, 2, 3) ENCRYPT, FE.FEPDI FOREIGNDBID, FE.FEFDB PLUGGEDRONLY, FE.FEPLUS PLUGINSCN, FE.FEPRLS PLUGINRLGSCN, FE.FEPR LT PLUGINRLGTIME, TO_NUMBER(NULL) NEWDFCREATIONSCN, FE.FECRC_THR CREATION_THREAD, FE.FECSZ CREATION_SIZE FROM X$KCCTS TS, X$KCCFE FE, X$KCCFN FN, X$KCCFN FNAUX, X$KCVFH FH WHERE FE.FETSI=TS.TSRNO AND FE.FEPAX=FNAUX.FNNUM(+) AND FNAUX.FNTYP(+)=22 AND FN.FNFNO=FE.FENUM AND FN.FNFNO=FH.HXFIL AND FE.FEFNH=FN.FNNUM AND (:B4 = :B1 OR FE.FEDUP!=0) AND FN.FNTYP=4 AND FN.FNNAM IS NOT NULL AND BITAND(FN.FNFLG, 4) != 4 AND DECODE(FE.FEPLUS, 0, TO_NUMBER(FE.FECRC_SCN), FE.FEPLUS) <= :B3 AND TO_NUMBER(FE.FECRC_SCN) > 0 AND (:B2 = :B1 OR FE.FEFDB = 0) AND (FE.FEFDB = 0 OR FE.FEPRLS != 0) ORDER BY FE.FENUM
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 )
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
476gvjkmumnt4	SELECT DOMAIN_NAME, DOMAIN_KEY, DOMAIN_USAGE, DOMAIN_DESC, LAST_SAVED, DOMAIN_VERSION, DOMAIN_PROP, OPB_OBJECT_ID, OBJVERSION FROM OPB_MMD_DOMAIN WHERE VENDOR_ID = :1 AND DOMAIN_ID = :2
4j15qzcw47wuk	/* OracleOEM */ select r.apply_name apply_name, total_messages_dequeued, total_messages_spilled from gv$streams_apply_reader r, dba_apply a, dba_queues q, dba_queue_tables t where r.apply_name = a.apply_name and a.queue_name = q.name and a.queue_owner = q.owner and q.queue_table = t.queue_table and q.owner=t.owner and r.inst_id = t.owner_instance
4jrfrtx4u6zcx	SELECT TASK_TGT.TARGET_GUID TARGET_GUID, LEAD(TASK_TGT.TARGET_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_TARGET_GUID, POLICY.POLICY_GUID POLICY_GUID, LEAD(POLICY.POLICY_GUID, 1) OVER (ORDER BY TASK_TGT.TARGET_GUID, POLICY.POLICY_GUID, CFG.EVAL_ORDER) NEXT_POLICY_GUID, POLICY.POLICY_NAME, POLICY.POLICY_TYPE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE, POLICY.MESSAGE), :B9 , CFG.MESSAGE, NULL) MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.MESSAGE_NLSID, POLICY.MESSAGE_NLSID), :B9 , CFG.MESSAGE_NLSID, NULL) MESSAGE_NLSID, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE, POLICY.CLEAR_MESSAGE), :B9 , CFG.CLEAR_MESSAGE, NULL) CLEAR_MESSAGE, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CLEAR_MESSAGE_NLSID, POLICY.CLEAR_MESSAGE_NLSID), :B9 , CFG.CLEAR_MESSAGE_NLSID, NULL) CLEAR_MESSAGE_NLSID, POLICY.REPO_TIMING_ENABLED, TASK_TGT.COLL_NAME , POLICY.VIOLATION_LEVEL, DECODE(POLICY.POLICY_TYPE, :B3 , :B10 , 0) VIOLATION_TYPE, POLICY.CONDITION_TYPE, POLICY.CONDITION, DECODE(POLICY.POLICY_TYPE, :B3 , NVL(CFG.CONDITION_OPERATOR, POLICY.CONDITION_OPERATOR), :B9 , CFG.CONDITION_OPERATOR, 0) CONDITION_OPERATOR, CFG.KEY_VALUE, CFG.KEY_OPERATOR, CFG.IS_EXCEPTION, CFG.NUM_OCCURRENCES, NULL EVALUATION_DATE, DECODE(CFG.IS_EXCEPTION, :B1 , MGMT_POLICY_PARAM_VAL_ARRAY(), CAST(MULTISET( SELECT MGMT_POLICY_PARAM_VAL.NEW(PARAM_NAME, CRIT_THRESHOLD, WARN_THRESHOLD, INFO_THRESHOLD) FROM MGMT_POLICY_ASSOC_CFG_PARAMS PARAM WHERE PARAM.OBJECT_GUID = CFG.OBJECT_GUID AND PARAM.POLICY_GUID = CFG.POLICY_GUID AND PARAM.COLL_NAME = CFG.COLL_NAME AND PARAM.KEY_VALUE = CFG.KEY_VALUE AND PARAM.KEY_OPERATOR = CFG.KEY_OPERATOR ) AS MGMT_POLICY_PARAM_VAL_ARRAY)) PARAMS, DECODE(POLICY.CONDITION_TYPE, :B8 , CAST(MULTISET(SELECT MGMT_NAMEVALUE_OBJ.NEW(BIND_COLUMN_NAME, BIND_COLUMN_TYPE) FROM MGMT_POLICY_BIND_VARS BINDS WHERE BINDS.POLICY_GUID = POLICY.POLICY_GUID ) AS MGMT_NAMEVALUE_ARRAY), M GMT_NAMEVALUE_ARRAY()) BINDS, DECODE(:B7 , 0, MGMT_MEDIUM_STRING_ARRAY(), 1, MGMT_MEDIUM_STRING_ARRAY(CFG.KEY_VALUE), CAST( (SELECT MGMT_MEDIUM_STRING_ARRAY( KEY_PART1_VALUE, KEY_PART2_VALUE, KEY_PART3_VALUE, KEY_PART4_VALUE, KEY_PART5_VALUE) FROM MGMT_METRICS_COMPOSITE_KEYS COMP_KEYS WHERE COMP_KEYS.COMPOSITE_KEY = CFG.KEY_VALUE AND COMP_KEYS.TARGET_GUID = CFG.OBJECT_GUID ) AS MGMT_MEDIUM_STRING_ARRAY) ) KEY_VALUES FROM MGMT_POLICIES POLICY, MGMT_POLICY_ASSOC ASSOC, MGMT_POLICY_ASSOC_CFG CFG, MGMT_COLLECTION_METRIC_TASKS TASK_TGT WHERE TASK_TGT.TASK_ID = :B6 AND POLICY.METRIC_GUID = :B5 AND ASSOC.OBJECT_GUID = TASK_TGT.TARGET_GUID AND POLICY.POLICY_TYPE != :B4 AND ( POLICY.POLICY_TYPE = :B3 OR ASSOC.COLL_NAME = TASK_TGT.COLL_NAME ) AND ASSOC.POLICY_GUID = POLICY.POLICY_GUID AND ASSOC.OBJECT_TYPE = :B2 AND ASSOC.IS_ENABLED = :B1 AND CFG.OBJECT_GUID = ASSOC.OBJECT_GUID AND CFG.COLL_NAME = ASSOC.COLL_NAME AND CFG.POLICY_GUID = ASSOC.POLICY_GUID ORDER BY TASK_TGT.TARGET_GUID, POL ICY.POLICY_GUID, CFG.EVAL_ORDER , CFG.KEY_VALUE DESC
4m9bapf9sj3sf	SELECT mgmt_metric_value_obj.new(target_guid, null, null, mgmt_namevalue_array(mgmt_namevalue_obj.new('privTransferRate', privTransferRate))) from ( SELECT ta.source_target_guid target_guid, SUM(c.value) privTransferRate FROM mgmt_current_metrics c, mgmt_current_availability a, mgmt_targets t2, mgmt_target_assocs ta, mgmt_target_assoc_defs td, mgmt_ha_cls_intr_conn i, mgmt_ecm_gen_snapshot s WHERE c.metric_guid = HEXTORAW('F77CC469F1DBA385991ACF69FEB4E329') AND c.target_guid = t2.target_guid AND a.target_guid = t2.target_guid AND a.current_status > 0 AND t2.target_guid = ta.assoc_target_guid AND ta.assoc_guid = td.assoc_guid AND td.assoc_def_name = 'contains' AND td.scope_target_type = ' ' AND (i.ic_node = 'global' or i.ic_node = t2.target_name) AND i.ic_public = 'NO' AND i.ecm_snapshot_id = s.snapshot_guid AND s.snapshot_type = 'ha_cls_intrconn' AND s.is_current = 'Y' AND s.target_guid = ta.source_target_guid AND i.ic_name = c.key_value AND t2.target_type = 'host' GROUP BY ta.source_target_guid ) WHERE target_guid IN (SELECT target_guid FROM MGMT_COLLECTION_METRIC_TASKS WHERE TASK_ID = :task_id) order by target_guid
4zr1vaxacqxqx	SELECT STA_STATION_OILCAN_INFO.OILCAN_ID, STA_STATION_OILCAN_INFO.STATION_ID FROM STA_STATION_OILCAN_INFO
5a9pu2q3tgqwm	SELECT CZY_GW, CZY_DWDM, CZY_ID FROM TANK_GPS_CZY ORDER BY CZY_ID
5fk0v8km2f811	select propagation_name, 'BUFFERED', num_msgs ready, 0 from gv$buffered_subscribers b, dba_propagation p, dba_queues q, dba_queue_tables t where b.subscriber_name = p.propagation_name and b.subscriber_address = p.destination_dblink and b.queue_schema = p.source_queue_owner and b.queue_name = p.source_queue_name and p.source_queue_name = q.name and p.source_queue_owner = q.owner and q.queue_table = t.queue_table and b.inst_id=t.owner_instance
5fwkqja3jckh0	SELECT EXPRESSION, EXPR_ID, LINE_NO FROM OPB_EXPRESSION WHERE WIDGET_ID = :1 AND VERSION_NUMBER = :2 ORDER BY EXPR_ID, LINE_NO ASC
5k5v1ah25fb2c	BEGIN EMD_LOADER.UPDATE_CURRENT_METRICS(:1, :2, :3, :4, :5, :6); END;
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
65n74bvx3vs46	SELECT OBJECT_TYPE, OBJECT_SUBTYPE, OS_TYPE, LIBRARY_NAME, LIB_TYPE FROM OPB_MMD_LIBS WHERE COMPONENT_ID = :1 AND COMPONENT_TYPE = 1
6dv0dpznx0dg9	select VALUE from NLS_SESSION_PARAMETERS where PARAMETER='NLS_LENGTH_SEMANTICS'
6h5t2wyax3cx0	SELECT ltrim(rtrim(accept_gsmhm)) accept_gsmhm, accept_e, accept_n, accept_time FROM tank_gps_yyyymmdd where accept_time>trunc(sysdate)
6njfzcrbkqsna	SELECT SERVER_STORE_RT.OPERATION_ID, SERVER_STORE_RT.DEPOT_ID, SERVER_STORE_RT.COMPANY_ID, SERVER_STORE_RT.TANKID, SERVER_STORE_RT.TANKNAME, SERVER_STORE_RT.PRODUCTNAME, SERVER_STORE_RT.PRODUCTSPEC, SERVER_STORE_RT.LOCALTIME, SERVER_STORE_RT.OILLEVEL, SERVER_STORE_RT.LEVELSTATUS, SERVER_STORE_RT.DISPLACERLEVEL, SERVER_STORE_RT.WATERLEVEL, SERVER_STORE_RT.WATERSTATUS, SERVER_STORE_RT.TEMPERATURE, SERVER_STORE_RT.TEMPSTATUS, SERVER_STORE_RT.GASAVERAGETEMP, SERVER_STORE_RT.PRODUCTAVERAGETEMP, SERVER_STORE_RT.TC, SERVER_STORE_RT.TAMBIENT, SERVER_STORE_RT.CTSH, SERVER_STORE_RT.TREFSHELL, SERVER_STORE_RT.VAPOURTEMP, SERVER_STORE_RT.VAPOURTEMPSTATUS, SERVER_STORE_RT.OBSTEMPERATURE, SERVER_STORE_RT.TREF, SERVER_STORE_RT.OBSDENSITY, SERVER_STORE_RT.OBSDENSITYSTATUS, SERVER_STORE_RT.REFDENSITY, SERVER_STORE_RT.REFDENSITYSTATUS, SERVER_STORE_RT.CURRENTDENSITY, SERVER_STORE_RT.HIMSDENSITY, SERVER_STORE_RT.VCF, SERVER_STORE_RT.AVAIABLEROOM, SERVER_STORE_RT.AVAIABLEP RODUCT, SERVER_STORE_RT.GTOV, SERVER_STORE_RT.TOV, SERVER_STORE_RT.TOVSTATUS, SERVER_STORE_RT.GOV, SERVER_STORE_RT.GOVSTATUS, SERVER_STORE_RT.GSV, SERVER_STORE_RT.GSVSTATUS, SERVER_STORE_RT.NSV, SERVER_STORE_RT.NSVSTATUS, SERVER_STORE_RT.TGSV, SERVER_STORE_RT.TGSVSTATUS, SERVER_STORE_RT.MASSINAIR, SERVER_STORE_RT.MANDATORYMASS, SERVER_STORE_RT.MASSINAIRSTATUS, SERVER_STORE_RT.TOTALMASS, SERVER_STORE_RT.TOTALMASSSTATUS, SERVER_STORE_RT.MASSCORRECTION, SERVER_STORE_RT.WATERVOLUME, SERVER_STORE_RT.HYCORRECTIONVOL, SERVER_STORE_RT.FLOW, SERVER_STORE_RT.TIMETOFILLEMPTY, SERVER_STORE_RT.LISTMASS, SERVER_STORE_RT.TRENSSTATUS, SERVER_STORE_RT.INSERT_TIME FROM SERVER_STORE_RT WHERE operation_id in (select max(t.operation_id) from dep.server_store_rt t where t.insert_time>sysdate-30 group by t.depot_id, t.tankid)
6ss9jsrba6g2z	SELECT METAEXT_NAME, DATA_TYPE, MAX_LENGTH, OBJECT_TYPE, DBTYPE, SUBTYPE, PERMISSIONS, DEFAULT_VALUE, METAEXT_DESC, METAEXT_PROP, OPB_OBJECT_ID, OBJVERSION, LINE_NO FROM OPB_MMD_METAEXT WHERE VENDOR_ID = :1 AND DOMAIN_ID = :2 ORDER BY OBJECT_TYPE, DBTYPE, METAEXT_NAME, LINE_NO ASC
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_WINGR OUP_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 WH ERE 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
73629tmfbjzrh	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN BEGIN ORACLE_OCM.MGMT_DB_LL_METRICS.COLLECT_CONFIG_METRICS('ORACLE_OCM_CONFIG_DIR'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
772s25v1y0x8k	select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice
7hwb0mssc3jry	UPDATE ISP_MASTER_ELECTION SET LAST_REFRESH_TIME = :v0 , ELECTION_STATUS = :v1 WHERE DOMAIN_NAME = :v2 AND NODE_NAME = :v3
7jfvtx5a4svff	UPDATE OPB_TASK_INST_RUN SET END_TIME=:1, RUN_STATUS_CODE=:2, RUN_ERR_CODE =:3, RUN_ERR_MSG = :4, SERVER_NODE_NAME = :5 WHERE WORKFLOW_ID = :6 AND WORKFLOW_RUN_ID = :7 AND WORKLET_RUN_ID = :8 AND INSTANCE_ID = :9 AND FRAGMENT_ID = -1
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7uawq904fr6qc	DELETE FROM OPB_MAP_PERSISVAL WHERE SESSION_INST_ID = :1 AND RUNINST_NAME = :2
80cqc24ntgmf8	SELECT DESCRIPTION, PM_VALUE, EXEC_ORDER, VAL_NAME, TASK_ID, SESSION_ID, WORKFLOW_ID, INSTANCE_ID, LINE_NO, BIT_OPTION FROM OPB_TASK_VAL_LIST WHERE TASK_ID = :1 AND TASK_TYPE = :2 AND COMPONENT_TYPE = :3 AND SESSION_ID = 0 AND INSTANCE_ID = 0 AND VERSION_NUMBER = :4 ORDER BY TASK_ID, EXEC_ORDER, LINE_NO ASC
85fbq1b55c07d	SELECT TRAFFIC_MONITOR_ID, PLAN_QTY, REAL_QTY, INSERT_TIME, RSNUM, OIL_ID FROM FCT_TRAFFIC_MONITOR ORDER BY RSNUM, OIL_ID
85ja7fnp61tu5	SELECT SESS_WIDG_INST_ID, RESOURCE_TYPE, RESOURCE_NAME FROM OPB_TASK_RES_REFS WHERE TASK_ID = :1 AND TASK_INST_ID = :2 AND WORKFLOW_ID = :3 AND VERSION_NUMBER = :4
86kwhy1f0bttn	SELECT /*+ ALL_ROWS */ COUNT(*) FROM DBA_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (V.POLICY_NAME LIKE '%xdbrls%' OR V.POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1
8c55f8xqf0x92	UPDATE FCT_RESERVED_ORDER SET MATNR = :1, WERKS = :2, UMWRK = :3, UMLGO = :4, LGORT = :5, ERFME = :6, RSDAT = :7, BDTER = :8, OIB_BLTIME = :9, BDMNG = :10, ENMNG = :11, WEMPF = :12, SGTXT = :13, ABLAD = :14, BWART = :15, ERFME_EUN = :16, MEINS = :17, XLOEK = :18, ETL_TIME = :19 WHERE RSNUM = :20 AND RSPOS = :21
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
8wy6a0y7k22zn	SELECT SUBJECT_ID FROM OPB_WIDGET WHERE WIDGET_ID = :1
96jf0smpc5nbh	SELECT COUNT(*) FROM OPB_SWIDGINST_LOG WHERE WORKFLOW_ID = :1 AND WORKFLOW_RUN_ID = :2 AND WORKLET_RUN_ID = :3 AND SESSION_ID = :4 AND TASK_INSTANCE_ID = :5 AND PARTITION_ID = :6 AND SESSWIDG_INST_ID = :7
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.nex t_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.cla ss_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
9snsz2u0532qa	INSERT INTO TEST_GPS_BB(ACCEPT_NUM, ACCEPT_GSMHM, ACCEPT_E, ACCEPT_N, ACCEPT_TIME, ACCEPT_CZY_ID, ACCEPT_QF_STATE, ACCEPT_ZYK1_STATE, ACCEPT_XYK1_STATE, ACCEPT_ZYK2_STATE, ACCEPT_XYK2_STATE, ACCEPT_ZYK3_STATE, ACCEPT_XYK3_STATE, CLBJ, DYBJ, DYCL, CREATE_TIME) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
a0r18jnk4frap	SELECT WIDGET_NAME, WIDGET_TYPE, IS_REUSABLE, SUBJECT_ID, VERSION_STATUS, COMMENTS, WIDGET_PROP, LAST_SAVED, CREATE_INFO, OBJVERSION, UTC_LAST_SAVED, IS_VISIBLE, UTC_REF_TIME, CHECKOUT_USER_ID, TEMPLATE_ID, RU_PARENT_ID, RU_VERSION_NUMBER, FILE_ID, COMP_VERSION FROM OPB_WIDGET WHERE WIDGET_ID = :1 AND VERSION_NUMBER = :2 AND SUBJECT_ID = :3
a5mmhrrnpwjsc	SELECT OBJOID, CLSOID, (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, DECODE(INST, :1, -1, 1))), WT, INST, DECODE(BITAND(STATUS, 8388608), 0, 0, 1), SCHLIM, ISLW, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.job_status STATUS, a.flags FLAGS, a.priority PRI, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, a.schedule_id SCHOID, a.last_start_date LSDATE, a.last_enabled_time LETIME, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, 0 ISLW, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) union all select c.obj#, c.class_oid, c.job_status, c.flags, d.priority, d.job_weight, decode(c.running_instance, NULL, 0, c.running_instance), c.schedule_id, c.last_start_ date, c.last_enabled_time, d.schedule_limit, 1, c.instance_id from sys.scheduler$_lightweight_job c, sys.scheduler$_program d where c.program_oid = d.obj# and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(FLAGS, 4096) = 4096 AND BITAND(STATUS, 515) = 1 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND (SCHOID = :4 OR SCHOID IN (select wm.oid from sys.scheduler$_wingrp_member wm, sys.scheduler$_window_group wg where wm.member_oid = :5 and wm.oid = wg.obj# and bitand(wg.flags, 1) <> 0) ) AND (LSDATE IS NULL OR (LSDATE IS NOT NULL AND (BITAND(STATUS, 16384) <> 0 OR LSDATE < :6))) AND LETIME < :7 AND INST_ID IS NULL AND (CLSOID IS NULL OR (CLSOID IS NOT NULL AND (CLSOID IN (select e.obj# from sys.scheduler$_class e where e.affinity is null)))) ORDER BY 2, 3, 4 DESC
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
arbrvpxtcuacm	INSERT INTO EM_adaptive_thresholds(HAS_ACTIVE_BASELINE, KEY_VALUE, METRIC_COLUMN, METRIC_NAME, TARGET_GUID, TARGET_TYPE) VALUES ( :1, :2, :3, :4, :5, :6)
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b0d86bn8ncths	SELECT STEP_ID FROM MGMT_JOB_EXECUTION WHERE STEP_ID = :B1 FOR UPDATE NOWAIT
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
bdksv7pr12g07	delete from fct_traffic_un_alarm where un_alarm_id in (select un_alarm_id from (select traffic_monitor_id, outdepot_time, arrival_time from fct_traffic_monitor where stime = to_date('20140416', 'yyyymmdd')) a inner join (select un_alarm_id, traffic_monitor_id, un_alarm_time from fct_traffic_un_alarm where trunc(un_alarm_time) = to_date('20140416', 'yyyymmdd') and un_alarm_type = '02') b on a.traffic_monitor_id = b.traffic_monitor_id where a.outdepot_time >= b.un_alarm_time or a.arrival_time <= b.un_alarm_time)
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
braagrttdf7zn	SELECT LOMN_RESPLANINFO.CODE, LOMN_RESPLANINFO.FACTORY, LOMN_RESPLANINFO.OILCODE, LOMN_RESPLANINFO.PLANQTY, LOMN_RESPLANINFO.CREATER, LOMN_RESPLANINFO.CREATETIME, LOMN_RESPLANINFO.UPDATETIME FROM LOMN_RESPLANINFO WHERE (LOMN_ResPlanInfo.PLANTYPE='配置计划' and LOMN_ResPlanInfo.etlupdatetime>=to_date('2014-04-16 19:57:01', 'yyyy-mm-dd hh24:mi:ss')) OR LOMN_ResPlanInfo.code IN ( SELECT DISTINCT LOMN_DLVPLANINFO.RESPLANCODE FROM LOMN_RESPLANINFO, LOMN_DLVPLANINFO WHERE LOMN_RESPLANINFO.CODE = LOMN_DLVPLANINFO.RESPLANCODE AND LOMN_ResPlanInfo.PLANTYPE='配置计划' AND LOMN_DLVPLANINFO.ETLUPDATETIME >= TO_DATE('2014-04-16 19:57:01', 'yyyy-mm-dd hh24:mi:ss')) OR LOMN_ResPlanInfo.code IN ( SELECT DISTINCT LOMN_TRSPLANINFO.RESPLANCODE FROM LOMN_RESPLANINFO, LOMN_DLVPLANINFO, LOMN_TRSPLANINFO WHERE LOMN_RESPLANINFO.CODE = LOMN_TRSPLANINFO.RESPLANCODE AND LOMN_RESPLANINFO.CODE = LOMN_DLVPLANINFO.RESPLANCODE AND LOMN_DLVPLANINFO.CODE = LOMN_TRSPLANINFO.DLVPLANCODE AND LOMN_ResPlanInfo.PLANTY PE='配置计划' AND LOMN_TRSPLANINFO.ETLUPDATETIME >= TO_DATE('2014-04-16 19:57:01', 'yyyy-mm-dd hh24:mi:ss'))
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cuts5q3rc7rp5	SELECT t0.JPS_ATTRS_ID, t0.ATTRVAL, t0.ATTRNAME, t0.JPS_DN_ENTRYID FROM JPS_ATTRS t0, JPS_DN t1 WHERE ((t0.JPS_DN_ENTRYID = t1.ENTRYID) AND (t1.PARENTDN = :1 ))
cxjzbma42ckb5	SELECT ATTR_ID, ATTR_VALUE, LINE_NO FROM OPB_WIDGET_ATTR WHERE WIDGET_ID = :1 AND WIDGET_TYPE = :2 AND VERSION_NUMBER = :3 AND MAPPING_ID = 0 AND INSTANCE_ID = 0 AND SESSION_ID = 0 AND SESSION_TASK_ID = 0 AND PARTITION_ID = 0 ORDER BY ATTR_ID, LINE_NO ASC
d8mayxqw0wnpv	SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'
d8nsxxzp777gs	UPDATE OS_YWY_RT SET STATION_ID = :1, TANK_ID = :2, DEVICE_BRAND = :3, UPLOAD_TIME = :4, TANK_STATE = :5, OIL_ID = :6, OIL_VOLUME = :7, STANDARD_VOLUME = :8, EMPTY_VOLUME = :9, OIL_HEIGHT = :10, WATER_HEIGHT = :11, TEMPERATURE = :12, WATER_VOLUME = :13, APPARENT_DENSITY = :14, STANDARD_DENSITY = :15, UPDATE_TIME = :16, ETL_TIME = :17 WHERE OPERATION_ID = :18
dvjxjgjdtj8g9	delete from fct_traffic_un_alarm t where trunc(t.un_alarm_time) = to_date('20140416', 'yyyymmdd') and t.un_alarm_type = '02' and trunc(t.un_alarm_time) != trunc(t.un_alarm_time_last)
f0jxh8d6b5af2	/* OracleOEM */ select a.capture_name capture_name, total_messages_captured, total_messages_enqueued from gv$streams_capture a, dba_capture b, dba_queues c, dba_queue_tables d where a.capture_name = b.capture_name and b.queue_name=c.name and b.queue_owner=c.owner and c.queue_table=d.queue_table and c.owner=d.owner and d.owner_instance=a.inst_id
f3u6vd210afnt	SELECT FIELD_NAME, FIELD_ID, WGT_PREC, WGT_SCALE, WGT_DATATYPE, PORTTYPE, FIELD_ORDER, COMMENTS, WIDGET_FLD_PROP, DEFAULT_VALUE, SRC_FIELD_ID, GROUP_ID, WIDGET_FLD_PROP2, OUTGROUP_ID, PICTXT FROM OPB_WIDGET_FIELD WHERE WIDGET_ID = :1 AND VERSION_NUMBER = :2
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
gdxm55c5pr008	UPDATE GPS_YYYYMMDD_TEMP SET ACCEPT_E = :1, ACCEPT_N = :2 WHERE ACCEPT_GSMHM = :3
gjm43un5cy843	SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)
gs42wyktj2aj1	SELECT INV_UTC, INV_COMMENTS, INV_TYPE, LINE_NO, VERSION_NUMBER FROM OPB_VALIDATE WHERE SUBJECT_ID = :1 AND OBJECT_TYPE = :2 AND OBJECT_ID = :3 AND VERSION_NUMBER <= :4 ORDER BY VERSION_NUMBER DESC, LINE_NO
gttqnywz350jw	SELECT EXPR_ID, OUTPUT_FIELD_ID, EXPR_TYPE, COMMENTS FROM OPB_WIDGET_EXPR WHERE WIDGET_ID = :1 AND VERSION_NUMBER = :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

• Ordered by statistic name