WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
MCSDB	2372875213	MCSDB2	2	12-8月 -13 10:08	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:	10340	06-2月 -14 02:00:21	1146	10.2
End Snap:	10341	06-2月 -14 11:34:59	1173	10.1
Elapsed:		574.63 (mins)
DB Time:		151.52 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	13,568M	13,568M	Std Block Size:	8K
Shared Pool Size:	10,752M	10,752M	Log Buffer:	194,412K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.3	0.0	0.00	0.00
DB CPU(s):	0.2	0.0	0.00	0.00
Redo size:	243,313.5	5,883.1
Logical reads:	5,691.6	137.6
Block changes:	1,212.5	29.3
Physical reads:	186.4	4.5
Physical writes:	41.4	1.0
User calls:	1,481.6	35.8
Parses:	74.9	1.8
Hard parses:	0.4	0.0
W/A MB processed:	3.0	0.1
Logons:	1.7	0.0
Executes:	446.0	10.8
Rollbacks:	28.6	0.7
Transactions:	41.4

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	98.50	In-memory Sort %:	100.00
Library Hit %:	99.77	Soft Parse %:	99.52
Execute to Parse %:	83.21	Latch Hit %:	99.88
Parse CPU to Parse Elapsd %:	64.28	% Non-Parse CPU:	98.50

Shared Pool Statistics

	Begin	End
Memory Usage %:	77.81	76.89
% SQL with executions>1:	99.43	92.67
% Memory for SQL w/exec>1:	96.62	87.26

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.48	0.27	1.4	0.8	0.0	97.8

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.9	41.4	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	96,738.8	96,738.8
SGA use (MB):	30,464.0	30,464.0
PGA use (MB):	3,036.2	3,067.6
% Host Mem used for SGA+PGA:	34.63	34.66

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	19.04	0.46
Global Cache blocks served:	15.13	0.37
GCS/GES messages received:	74.66	1.81
GCS/GES messages sent:	98.48	2.38
DBWR Fusion writes:	1.62	0.04
Estd Interconnect traffic (KB)	307.23

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

Buffer access - local cache %:	98.16
Buffer access - remote cache %:	0.34
Buffer access - disk %:	1.50

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.2
Avg global cache current block receive time (ms):	0.2
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 %:	2.1
Avg global cache cr block flush time (ms):	1.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 %:	1.1
Avg global cache current block flush time (ms):	0.4

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.1
Avg message received queue time (ms):	0.8
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	57.56
% of indirect sent messages:	42.17
% of flow controlled messages:	0.27

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): 9091s
• 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 94.9% of Total DB time 9,090.96 (s)
• Total FG Wait Time: 1,900.40 (s) DB CPU time: 6,729.70 (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 35.9% of Total DB Time (s): 9,091
• Captured PL/SQL account for 27.7% of Total DB Time (s): 9,091

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 23.8% of Total CPU Time (s): 6,730
• Captured PL/SQL account for 17.4% of Total CPU Time (s): 6,730

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

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: 196,234,227
• Captured SQL account for 39.4% 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: 6,425,417
• Captured SQL account for 31.1% 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: 2,072,220
• Captured SQL account for 91.7% of Total
• Total UnOptimized Read Requests: -700,849
• Captured SQL account for -0.3% of Total
• Total Optimized Read Requests: 2,773,069
• Captured SQL account for 68.4% 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: 15,376,467
• Captured SQL account for 51.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 2,581,835
• Captured SQL account for 30.1% 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): 128
• Captured SQL account for 27.7% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
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
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')
11y3zqvxv1f3a	UPDATE MGMT_CURRENT_VIOLATION SET COLLECTION_TIMESTAMP = NVL(:B23 , COLLECTION_TIMESTAMP), VIOLATION_GUID = NVL(:B22 , VIOLATION_GUID), VIOLATION_LEVEL = NVL(:B21 , VIOLATION_LEVEL), VIOLATION_TYPE = NVL(:B20 , VIOLATION_TYPE), ANNOTATED_FLAG = NVL(:B19 , ANNOTATED_FLAG), VALUE = NVL(:B18 , VALUE), STRING_VALUE = NVL(:B17 , STRING_VALUE), MESSAGE = NVL(:B16 , MESSAGE), MESSAGE_NLSID = NVL(:B15 , MESSAGE_NLSID), MESSAGE_PARAMS = NVL(:B14 , MESSAGE_PARAMS), ACTION_MESSAGE = NVL(:B13 , ACTION_MESSAGE), ACTION_MESSAGE_NLSID = NVL(:B12 , ACTION_MESSAGE_NLSID), ACTION_MESSAGE_PARAMS = NVL(:B11 , ACTION_MESSAGE_PARAMS), ADVISORY_ID = NVL(:B10 , ADVISORY_ID), EXEMPT_CODE = NVL(:B9 , EXEMPT_CODE), EXEMPT_UNTIL = NVL(:B8 , EXEMPT_UNTIL), EXEMPT_BY = NVL(:B7 , EXEMPT_BY), CFG_COLL_NAME=NVL(:B6 , CFG_COLL_NAME), CFG_KEY_VALUE=NVL(:B5 , CFG_KEY_VALUE), CFG_KEY_OPERATOR=NVL(:B4 , CFG_KEY_OPERATOR) WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND KEY_VALUE = :B1
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
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
1a19n674n5rpa	BEGIN :rv := FNC_GPS_GETDISTANCE (:1, :2, :3, :4) ; END;
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
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
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
2zczc66zgvsv4	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 (47) 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))
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;
37j1y73phdwj4	UPDATE retail_station_info_dim a SET a.station_capacity= (SELECT v.station_t_capacity FROM VIEW_STATION_OILTANK_CAPACITY v WHERE a.station_code=v.station_code)
39ax31acw29z6	WITH MET AS (SELECT DISTINCT METRIC_GUID METRIC_GUID FROM MGMT_METRICS WHERE KEYS_FROM_MULT_COLLS = 0 ), CM AS (SELECT TARGET_GUID, METRIC_GUID, MAX(COLLECTION_TIMESTAMP) MAX_TIME FROM MGMT_CURRENT_METRICS GROUP BY TARGET_GUID, METRIC_GUID HAVING MAX(COLLECTION_TIMESTAMP) != MIN(COLLECTION_TIMESTAMP)) SELECT CM.TARGET_GUID TARGET_GUID, CM.METRIC_GUID METRIC_GUID, CM. MAX_TIME MAX_TIME FROM MET, CM WHERE CM.METRIC_GUID = MET.METRIC_GUID
3am9cfkvx7gq1	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values)
3qpgvj39g3nsj	SELECT ATTR_ID, ATTR_VALUE, LINE_NO, INSTANCE_ID, WIDGET_ID, WIDGET_TYPE FROM OPB_WIDGET_ATTR WHERE MAPPING_ID = :1 AND INSTANCE_ID <> 0 AND VERSION_NUMBER = :2 AND SESSION_ID = 0 AND SESSION_TASK_ID = 0 AND PARTITION_ID = 0 ORDER BY INSTANCE_ID, WIDGET_ID, ATTR_ID, LINE_NO ASC
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
46fykrj6nnm5k	INSERT INTO p1_CT_orcleventtime (attrvalue, attrtype, entryid ) VALUES( :batValue, :batSubType, :bEntryId )
4748x1sb6pg2h	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_station_lo_sale; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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
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
51k9tr3qgmybx	SELECT UN_ALARM_TIME_LAST, UN_ALARM_TIME, UN_ALARM_ID, TRAFFIC_MONITOR_ID FROM FCT_TRAFFIC_UN_ALARM WHERE un_alarm_type = '02' and to_char(un_alarm_time_last, 'yyyymmdd') = '20140206' ORDER BY TRAFFIC_MONITOR_ID, UN_ALARM_TIME_LAST, UN_ALARM_TIME, UN_ALARM_ID
51s8t9n25w51r	INSERT INTO QRTZ92_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 )
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
5u96qzj5zwuuf	INSERT INTO OPB_WFLOW_CACHE (WORKFLOW_ID, WORKLET_ID, WORKFLOW_RUN_ID, INSTANCE_ID, TASK_ID, TASK_TYPE, INSTANCE_NAME) VALUES (:1, :2, :3, :4, :5, :6, :7)
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
5xxy9tq9q4ydw	select /*+ FIRST_ROWS(1) PARALLEL("VEHICLE_GPS_HIS", 1) */ 1 from "GIS"."VEHICLE_GPS_HIS" PARTITION ("PART_MAX") where ( ( ( ( "MSG_REC_TIME" < TO_DATE(' 2014-02-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') ) ) ) ) and rownum < 2
65n74bvx3vs46	SELECT OBJECT_TYPE, OBJECT_SUBTYPE, OS_TYPE, LIBRARY_NAME, LIB_TYPE FROM OPB_MMD_LIBS WHERE COMPONENT_ID = :1 AND COMPONENT_TYPE = 1
66dvqnwvpwftt	INSERT INTO GIS.OS_LO_SALE_DAY (STATION_ID, OIL_ID, SALE_DATE, COM_ID, AREA_ID, SALE_MONEY, SALE_QUANTITY, PURE_QUANTITY, NPURE_QUANTITY, ANALYSE) SELECT OS.STATION_ID AS STATION_ID, SUBSTR(ERP.LUBE_ID, -8) AS OIL_ID, BILL_DAY AS SALE_DATE, OS.COM_ID, OS.AREA_ID, SUM(TOTALVALUE) AS SALE_MONEY, SUM(BILL_COUNT) AS SALE_QUANTITY, SUM(BILL_COUNT) AS PURE_QUANTITY, 0 AS NPURE_QUANTITY, '' AS ANALYSE FROM ERPDATAEXADMIN.OIL_SALES_DETAIL@ERP.REPORTLINK.COM ERP, OS_ERP_REFLECT OER, OS_BASE_INFO OS WHERE ERP.STATION = OER.SALE_GROUP AND OS.STATION_CODE = OER.STATION_CODE AND ERP.TYPER IN ('ZS11', 'ZS16', 'ZS34') GROUP BY OS.STATION_ID, ERP.LUBE_ID, BILL_DAY, OS.COM_ID, OS.AREA_ID
69k5bhm12sz98	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE _INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
6czjb86bzfr4y	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PROC_ADD_GPS_TABLE_PARTITION; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6dv0dpznx0dg9	select VALUE from NLS_SESSION_PARAMETERS where PARAMETER='NLS_LENGTH_SEMANTICS'
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
6h0w6paahk39x	SELECT TRAFFIC_QTY, TRAFFIC_QTY_M, TRAFFIC_QTY_L, TRAFFIC_QTY_M_L, TRAFFIC_DATE, DEPOT_ID, OIL_ID, STATION_ID, VEHICLE_ID FROM ECPS_TRAFFIC_DAY ORDER BY TRAFFIC_DATE, DEPOT_ID, OIL_ID, STATION_ID, VEHICLE_ID
6h5t2wyax3cx0	SELECT ltrim(rtrim(accept_gsmhm)) accept_gsmhm, accept_e, accept_n, accept_time FROM tank_gps_yyyymmdd where accept_time>trunc(sysdate)
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
72d2scq4hh174	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 (49) 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))
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
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#
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
85fjxf46f23pw	select faultnumber, case when faultlevel = '1' then '一级' when faultlevel = '2' then '二级' when faultlevel = '3' then '三级' end as faultlevel, warn, tel, username, fp_time, deptname from (select faultnumber, tel, case when faultlevel = '1' and (select code from eacode u where u.field = 'ZJ_FAULTLEVEL_WARNTIME' and u.fieldname = '1') - timer <= 0 then 'warning' when faultlevel = '2' and (select code from eacode u where u.field = 'ZJ_FAULTLEVEL_WARNTIME' and u.fieldname = '2') - timer <= 0 then 'warning' when faultlevel = '3' and (select code from eacode u where u.field = 'ZJ_FAULTLEVEL_WARNTIME' and u.fieldname = '3') - timer <= 0 then 'warning' end as warn, username, faultlevel, fp_time, deptname from ( select faultnumber, faultlevel, (fp_time - now_time) * -1 * 24 as timer, tel, username, fp_time, deptname from ( select a.faultnumber, a.faultlevel, b.dassign_to_date as fp_time, sysdate as now_time, d.tel, d.username, dep.deptname from yw_zj_stationservice a inner join eadept dep on a.faultsite = dep.deptid inner join yw_zj_xxfbassign b on a.faultnumber = b.dfaultid left join yw_zj_operatorinfo c on a.faultnumber = c.ofaultid inner join eauser d on b.dassign_to2 = d.deptid left join us_pub_supportuser e on e.deptid = a.department where (a.state = '3' or a.state = '7' or a.state = '8' or a.state = '9') and c.ofaultid is null and d.account = e.user_account and ((a.faultnumber not in (select faultnumber from zj_sms_warn)) or (a.faultnumber in (select faultnumber from zj_sms_warn where (sysdate - send_time) * 24 >= (select code from eacode u where u.field = 'ZJ_WARNTIME_INTERVAL' and u.fieldname = '1') and faultlevel = '1')) or (a.faultnumber in (select faultnumber from zj_sms_warn where (sysdate - send_time) * 24 >= (select code from eacode u where u.field = 'ZJ_WARNTIME_INTERVAL' and u.fieldname = '2') and a.faultlevel = '2')) or (a.faultnumber in (select faultnumber from zj_sms_warn where (sysdate - send_time) * 24 >= (select code from eacode u where u.field = 'ZJ_WARNTIME_INTERVAL' and u.fieldname = '3') and a.faultlevel = '3'))) ))) where warn = 'warning'
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
8bqpq08bpfr93	UPDATE QRTZ92_TRIGGERS SET TRIGGER_STATE = :1 WHERE JOB_NAME = :2 AND JOB_GROUP = :3 AND TRIGGER_STATE = :4
8uq946u6nr116	INSERT INTO P1_DS_ATTRSTORE ( ENTRYID, ATTRNAME, ATTRSTYPE, ATTRVAL, ATTRKIND, ATTRVER) VALUES( :B6 , :B1 , :B2 , :B3 , :B5 , :B4 )
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
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
9gkq7rruycsjp	select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :1
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
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
a9u0s3g93f47z	select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property, 16)=0 and bitand(property, 8)=0 order by o.obj#
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
bhqk6t84ydtzp	INSERT INTO VEHICLE_GPS_HIS(GPS_ID, GPS_VENDER, VEHICLE_NUM, LONGITUDE, LATITUDE, KPM, MSG_REC_TIME, ANGLE, INTOOIL1, OUTOIL1, INTOOIL2, OUTOIL2, INTOOIL3, OUTOIL3, DISTANCE, TRANS_CODE, TRANS_NAME, LONGITUDE_HIS, LATITUDE_HIS, MSG_REC_TIME_HIS, INSERT_TIME, VEHICLE_GPS_RT_UPDATE_TIME, VEHICLE_ID) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23)
bjstq78pprd24	SELECT DECODE(ELEMENT_SUBSTITUTABLE, ' Y', 1, 0) FROM SYS.ALL_NESTED_TABLES WHERE TABLE_NAME = :tname AND OWNER = :owner
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
bs0amr1pnyvrr	DELETE OAM_SESSION WHERE EXPIRY_TIME < CURRENT_TIMESTAMP AND ROWNUM < :1
c3hhngpbpvvmk	SELECT MARKER_TIMESTAMP FROM MGMT_AVAILABILITY_MARKER WHERE TARGET_GUID = :B1
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cnumpcz520unc	SELECT COUNT(*) FROM ALL_OBJECT_TABLES OT, ALL_XML_TABLES XT WHERE OT.OWNER = XT.OWNER AND OT.TABLE_NAME = XT.TABLE_NAME AND XT.STORAGE_TYPE = 'CLOB' AND OT.OWNER = :OWN AND OT.TABLE_NAME = :TAB
cqruwka6zw7a9	INSERT INTO p1_CT_objectclass (attrvalue, attrtype, entryid ) VALUES( :batValue, :batSubType, :bEntryId )
crxzqmmwn9m06	DELETE GIS.ALARM_VEHICLE_SEAL
cta9cgqbcvk5h	DELETE GIS.OS_LO_SALE_DAY_BY_TYPE WHERE 1 = 1
cu6c32rsh27c0	INSERT INTO p1_CT_orclldapinstanceid (attrvalue, attrtype, entryid ) VALUES( :batValue, :batSubType, :bEntryId )
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
d88rb926ypqs2	INSERT INTO OPB_SWIDGINST_LOG (WORKFLOW_ID, WORKFLOW_RUN_ID, WORKLET_RUN_ID, SESSION_ID, TASK_INSTANCE_ID, PARTITION_ID, PARTITION_NAME, SESSWIDG_INST_ID, WIDGET_TYPE, INSTANCE_NAME, WIDGET_NAME, MAPPLET_INST_NAME, GROUP_ID, GROUP_NAME, APPLIED_ROWS, AFFECTED_ROWS, REJECTED_ROWS, THRUPUT, LAST_ERR_MSG, LAST_ERR_CODE, START_TIME, END_TIME) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
d8mayxqw0wnpv	SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER'
dhfxbk10dhgrn	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN proc_alarm_vehicle; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
drg4kxzh2u8kr	INSERT INTO GIS.ALARM_VEHICLE_SEAL (ALARMVEHICLEID, VEHICLE_ID, ALARMTIME, ALARMREMARK1, LONGITUDE, LATITUDE, LOCATION, RN, RSNUM, VEHICLENUM) SELECT RESULT0.*, NVL(MDV.RSNUM, 0) AS RSNUM, VB.VEHICLE_NUM AS VEHICLENUM FROM (SELECT AV.ALARM_VEHICLE_ID AS ALARMVEHICLEID, AV.VEHICLE_ID, AV.ALARM_TIME AS ALARMTIME, AV.ALARM_INFO AS ALARMREMARK1, AV.LONGITUDE, AV.LATITUDE, (NVL(AV.LONGITUDE, '') || ' ' || NVL(AV.LATITUDE, '')) AS LOCATION, ROWNUM AS RN FROM ALARM_VEHICLE AV WHERE AV.VEHICLE_ID IS NOT NULL ORDER BY AV.VEHICLE_ID, AV.ALARM_TIME DESC) RESULT0 LEFT JOIN MCS_DELIVERY_VIEW MDV ON RESULT0.VEHICLE_ID = MDV.VEHICLE_ID AND MDV.CHECK_TIME < TO_DATE(RESULT0.ALARMTIME, 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(RESULT0.ALARMTIME, 'yyyy-mm-dd hh24:mi:ss') < MDV.LEAVE_TIME LEFT JOIN GIS.VEHICLE_BASE VB ON RESULT0.VEHICLE_ID = VB.VEHICLE_ID
dsu00pzsv7s95	INSERT INTO GIS.OS_LO_SALE_DAY_BY_TYPE (STATION_ID, OIL_ID, SALE_DATE, OST_ID, COM_ID, AREA_ID, SALE_QUANTITY, SALE_RATE) SELECT OS.STATION_ID AS STATION_ID, SUBSTR(ERP.LUBE_ID, -8) AS OIL_ID, BILL_DAY AS SALE_DATE, TYPER AS OST_ID, OS.COM_ID, OS.AREA_ID, BILL_COUNT AS SALE_QUANTITY, 0 AS SALE_RATE FROM ERPDATAEXADMIN.OIL_SALES_DETAIL@ERP.REPORTLINK.COM ERP, OS_ERP_REFLECT OER, OS_BASE_INFO OS WHERE ERP.STATION = OER.SALE_GROUP AND OS.STATION_CODE = OER.STATION_CODE
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
famsvzkq20x7j	select distinct equipment_name, point_name, point_value, point_unit, descr from yw_jf_synchro where point_id in(select distinct point_id from yw_jf_synchro where equipment_name like'%温湿度%' and point_unit='度' and point_id!=65) and ( (point_value <= 10) or (point_value >= max_value))
fcb5u7n0r523m	SELECT NVL(AVG((VALUE*1000.0)/DURATION), 0), NVL((((SUM(DURATION)/(60*1000))/60)*100), 0) FROM MGMT_SYSTEM_PERFORMANCE_LOG A, MGMT_PERFORMANCE_NAMES B WHERE :B1 = B.DISPLAY_NAME AND A.JOB_NAME = B.JOB_NAME AND A.TIME > (SYSDATE-(1/24)) AND A.IS_TOTAL='Y' AND A.DURATION > 0
fw6w4dt4nh1ag	INSERT INTO p1_CT_orclhostname (attrvalue, attrtype, entryid ) VALUES( :batValue, :batSubType, :bEntryId )
fwzf0mmdwszf8	select * from eadept pt left join eauser ea on ea.deptid=pt.deptid where pt.customid = :1
g54xjchjm3gwc	INSERT INTO p1_CT_orclldapprocessid (attrvalue, attrtype, entryid ) VALUES( :batValue, :batSubType, :bEntryId )
gcph0kd36arc6	SELECT /*+ ORDERED PUSH_SUBQ */ DISTINCT D.PROFILE_NAME, D.DEVICE_NAME, D.TYPE, D.STATUS, D.PROGRAM, CFG.OWNER, CFG.RULE_NAME, DECODE(D.TYPE, :B29 , D.PROFILE_NAME, :B28 , D.PROFILE_NAME, CFG.OWNER) CHECKUSER FROM (SELECT RULE_NAME, OWNER FROM MGMT_NOTIFY_RULE_CONFIGS C WHERE ((:B26 LIKE C.TARGET_TYPE ESCAPE :B21 AND :B25 LIKE C.TARGET_NAME ESCAPE :B21 ) OR (C.TARGET_GUID IS NOT NULL AND EXISTS (SELECT 1 FROM MGMT_FLAT_TARGET_ASSOC A, MGMT_TARGETS T WHERE A.SOURCE_TARGET_GUID = C.TARGET_GUID AND A.IS_MEMBERSHIP = 1 AND A.ASSOC_TARGET_GUID = T.TARGET_GUID AND T.TARGET_TYPE = C.TARGET_TYPE AND T.TARGET_NAME = :B25 ))) AND :B24 LIKE C.METRIC_NAME ESCAPE :B21 AND :B23 LIKE C.METRIC_COLUMN ESCAPE :B21 AND ((:B22 LIKE C.KEY_VALUE ESCAPE :B21 ) OR (C.KEY_VALUE <> ' ' AND EXISTS (SELECT 1 FROM MGMT_METRICS_COMPOSITE_KEYS K WHERE K.COMPOSITE_KEY = :B22 AND NVL(K.KEY_PART1_VALUE, ' ') LIKE C.KEY_PART_1 ESCAPE :B21 AND NVL(K.KEY_PART2_VALUE, ' ') LIKE C.KEY_PART_2 ESCAPE :B21 AND NVL(K.KEY_PART3_VALUE, ' ') LIKE C.KEY_PART_3 ESCAPE :B21 AND NVL(K.KEY_PART4_VALUE, ' ') LIKE C.KEY_PART_4 ESCAPE :B21 AND NVL(K.KEY_PART5_VALUE, ' ') LIKE C.KEY_PART_5 ESCAPE :B21 AND K.TARGET_GUID = :B27 ))) AND ((:B4 = -1 AND ( (:B2 = :B20 AND WANT_TARGET_UNREACHABLE_START = 1) OR (:B2 = :B19 AND WANT_TARGET_UNREACHABLE_END = 1) OR (:B2 = :B18 AND WANT_TARGET_BLACKOUT_START = 1) OR (:B2 = :B17 AND WANT_TARGET_BLACKOUT_END = 1) OR (:B2 = :B16 AND ((WANT_TARGET_METRIC_ERR_START = 1 AND :B12 = 1) OR (WANT_TARGET_METRIC_ERR_START = 2 AND :B12 = 0) OR (WANT_TARGET_METRIC_ERR_START = 3))) OR (:B2 = :B15 AND ((WANT_TARGET_METRIC_ERR_END = 1 AND :B12 = 1) OR (WANT_TARGET_METRIC_ERR_END = 2 AND :B12 = 0) OR (WANT_TARGET_METRIC_ERR_END = 3))) OR (:B2 = :B1 AND WANT_CLEARS = 1 AND :B14 <> 1) OR (:B2 = :B1 AND WANT_TARGET_UP = 1 AND :B14 = 1) OR (:B2 = :B6 AND WANT_WARNINGS = 1) OR (:B2 = :B5 AND WANT_CRITICAL_ALERTS = 1 AND :B14 <> 1) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 0) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 1 AND :B12 = 1 AND IGNORE_RCA = 1 AND :B11 NOT IN (:B10 , :B9 )) OR (:B2 = :B5 AND WANT_TARGET_DOWN = 1 AND :B14 = 1 AND :B13 = 1 AND :B12 = 1 AND IGNORE_RCA = 0 AND :B11 IN (:B10 , :B9 )) OR ((:B2 = :B8 OR :B2 = :B6 OR :B2 = :B5 ) AND WANT_POLICY_VIOLATIONS = 1 ) OR (:B2 = :B1 AND WANT_POLICY_CLEARS = 1 ) ) ) OR (:B4 <> -1 AND ( (:B4 = :B7 AND :B2 = :B6 AND WANT_WARNING_JOB_SUCCEEDED = 1) OR (:B4 = :B7 AND :B2 = :B5 AND WANT_CRITICAL_JOB_SUCCEEDED = 1) OR (:B4 = :B7 AND :B2 <> :B1 AND WANT_POLICY_JOB_SUCCEEDED = 1) OR (:B4 = :B3 AND :B2 = :B6 AND WANT_WARNING_JOB_PROBLEMS = 1) OR (:B4 = :B3 AND :B2 = :B5 AND WANT_CRITICAL_JOB_PROBLEMS = 1) OR (:B4 = :B3 AND :B2 <> :B1 AND WANT_POLICY_JOB_PROBLEMS = 1) ) ) )) CFG, MGMT_NOTIFY_NOTIFYEES N, MGMT_NOTIFY_DEVICES D WHERE N.RULE_NAME = CFG.RULE_NAME AND N.OWNER = CFG.OWNER AND ((D.DEVICE_NAME = N.DEVICE_NAME AND D.PROFILE_NAME = N. PROFILE_NAME) OR (N.DEVICE_NAME = ' ' AND D.PROFILE_NAME = N.PROFILE_NAME AND D.TYPE IN (:B29 , :B28 ) ) ) ORDER BY CHECKUSER
gdxm55c5pr008	UPDATE GPS_YYYYMMDD_TEMP SET ACCEPT_E = :1, ACCEPT_N = :2 WHERE ACCEPT_GSMHM = :3
gfdn12rn0fg3m	SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND TARGET_TYPE = :B1
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)
gttqnywz350jw	SELECT EXPR_ID, OUTPUT_FIELD_ID, EXPR_TYPE, COMMENTS FROM OPB_WIDGET_EXPR WHERE WIDGET_ID = :1 AND VERSION_NUMBER = :2
gwmckhcxysd5r	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PROC_GASCARD_INFO_TRANS; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

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