WORKLOAD REPOSITORY report for

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

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dm01db01.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	1099	6.8
End Snap:	12007	16-4月 -14 22:00:10	1091	6.9
Elapsed:		59.50 (mins)
DB Time:		14.41 (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.2	0.0	0.00	0.00
DB CPU(s):	0.2	0.0	0.00	0.00
Redo size:	177,366.4	3,792.4
Logical reads:	7,812.3	167.0
Block changes:	873.6	18.7
Physical reads:	200.3	4.3
Physical writes:	30.6	0.7
User calls:	1,578.7	33.8
Parses:	101.3	2.2
Hard parses:	0.9	0.0
W/A MB processed:	2.2	0.1
Logons:	4.1	0.1
Executes:	505.4	10.8
Rollbacks:	30.5	0.7
Transactions:	46.8

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.52	In-memory Sort %:	100.00
Library Hit %:	99.60	Soft Parse %:	99.14
Execute to Parse %:	79.96	Latch Hit %:	99.94
Parse CPU to Parse Elapsd %:	44.77	% Non-Parse CPU:	98.65

Shared Pool Statistics

	Begin	End
Memory Usage %:	86.99	87.04
% SQL with executions>1:	97.02	97.41
% Memory for SQL w/exec>1:	90.27	90.55

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.97	0.73	1.7	0.8	0.0	97.4

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
1.1	43.7	0.0

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):	2,903.0	2,942.6
% Host Mem used for SGA+PGA:	55.93	55.97

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	20.59	0.44
Global Cache blocks served:	23.06	0.49
GCS/GES messages received:	84.74	1.81
GCS/GES messages sent:	84.66	1.81
DBWR Fusion writes:	3.69	0.08
Estd Interconnect traffic (KB)	382.27

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

Buffer access - local cache %:	99.25
Buffer access - remote cache %:	0.27
Buffer access - disk %:	0.48

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 %:	1.5
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 %:	2.5
Avg global cache current block flush time (ms):	0.5

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.2
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	78.15
% of indirect sent messages:	21.74
% of flow controlled messages:	0.12

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): 864.8s
• 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 111.7% of Total DB time 864.81 (s)
• Total FG Wait Time: 112.02 (s) DB CPU time: 853.61 (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 30.3% of Total DB Time (s): 865
• Captured PL/SQL account for 10.9% of Total DB Time (s): 865

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

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

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: 27,889,569
• Captured SQL account for 34.0% 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: 715,005
• Captured SQL account for 70.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: 19,277
• Captured SQL account for 10.6% of Total
• Total UnOptimized Read Requests: -16,707
• Captured SQL account for -1.9% of Total
• Total Optimized Read Requests: 35,984
• Captured SQL account for 4.8% 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: 1,804,181
• Captured SQL account for 39.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 361,484
• Captured SQL account for 36.4% 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): 12
• Captured SQL account for 14.9% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
05xcf43d9psvm	SELECT NVL(SUM(FAILURES), 0) FROM SYS.DBA_QUEUE_SCHEDULES
08p5tcgjsff66	SELECT DSQ_INST_ID, VAR_NAME, FLD_NAME, PORT_ID FROM OPB_SAP_DSQ_OPRT WHERE SUBJECT_ID = :1 AND MAPPING_ID = :2 AND VERSION_NUMBER = :3
0drvc2yxhdvv7	SELECT COUNT(TARGET_NAME) FROM MGMT_TARGETS
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')
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
181xzty42kz4v	SELECT UPLOAD_TIME FROM SERVER_INVENTORY_RT WHERE STATION_ID =:B2 AND TANK_ID =:B1
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)
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
1nx1518vff191	UPDATE MGMT_COLLECTION_TASKS SET TASK_TYPE=NVL(:B14 , TASK_TYPE), PRIORITY=NVL(:B13 , PRIORITY), NEXT_COLLECTION_TIMESTAMP=NVL(:B12 , NEXT_COLLECTION_TIMESTAMP), LAST_COLLECTION_TIMESTAMP=NVL(:B11 , LAST_COLLECTION_TIMESTAMP), ERROR_MESSAGE=:B10 , FAILURES=NVL(:B9 , FAILURES), TOTAL_RUNS=NVL(:B8 , TOTAL_RUNS), MIN_WAIT_TIME=NVL(:B7 , MIN_WAIT_TIME), MAX_WAIT_TIME=NVL(:B6 , MAX_WAIT_TIME), AVG_WAIT_TIME=NVL(:B5 , AVG_WAIT_TIME), MIN_RUN_TIME=NVL(:B4 , MIN_RUN_TIME), MAX_RUN_TIME=NVL(:B3 , MAX_RUN_TIME), AVG_RUN_TIME=NVL(:B2 , AVG_RUN_TIME) WHERE TASK_ID = :B1 RETURNING FREQUENCY_CODE, PRIORITY, TASK_TYPE, NEXT_COLLECTION_TIMESTAMP, TASK_CLASS INTO :O0 , :O1 , :O2 , :O3 , :O4
1um3hu75qftvu	DELETE GIS.EASYJOY_SALE_DATESUM_BYCITY
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)
2tdrhvv6rg8fm	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 (189) 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))
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;
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
3gputsqv4u1j3	SELECT endsn.filetype_id as filetype_id, max(filetypename.filetype_name) as filetype_name, endsn.function_id as function_id, max(funcname.function_name) as function_name, sum(endsn.small_read_megabytes - nvl(startsn.small_read_megabytes, 0)) as small_read_megs, sum(endsn.small_write_megabytes - nvl(startsn.small_write_megabytes, 0)) as small_write_megs, sum(endsn.large_read_megabytes - nvl(startsn.large_read_megabytes, 0)) as large_read_megs, sum(endsn.large_write_megabytes - nvl(startsn.large_write_megabytes, 0)) as large_write_megs, sum(endsn.small_read_reqs - nvl(startsn.small_read_reqs, 0)) as small_read_reqs, sum(endsn.small_write_reqs - nvl(startsn.small_write_reqs, 0)) as small_write_reqs, sum(endsn.large_read_reqs - nvl(startsn.large_read_reqs, 0)) as large_read_reqs, sum(endsn.large_write_reqs - nvl(startsn.large_write_reqs, 0)) as large_write_reqs, sum(endsn.number_of_waits - nvl(startsn.number_of_waits, 0)) as num_waits, sum(endsn.wait_time - nvl(start sn.wait_time, 0)) as wait_time FROM WRH$_IOSTAT_DETAIL endsn, WRH$_IOSTAT_DETAIL startsn, WRH$_IOSTAT_FUNCTION_NAME funcname, WRH$_IOSTAT_FILETYPE_NAME filetypename WHERE startsn.filetype_id(+) = endsn.filetype_id AND startsn.function_id(+) = endsn.function_id AND endsn.dbid = funcname.dbid AND endsn.function_id = funcname.function_id AND endsn.dbid = filetypename.dbid AND endsn.filetype_id = filetypename.filetype_id AND endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid(+) = :dbid AND startsn.instance_number(+) = endsn.instance_number AND startsn.snap_id(+) = :bid GROUP BY endsn.filetype_id, endsn.function_id ORDER BY endsn.filetype_id ASC, endsn.function_id ASC
3jgrfa79mn517	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PROC_EASYJOY_SALE; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
3m7q92wtp699z	UPDATE QRTZ92_TRIGGERS SET TRIGGER_STATE = :1 WHERE TRIGGER_NAME = :2 AND TRIGGER_GROUP = :3 AND TRIGGER_STATE = :4
3wrrjm9qtr2my	SELECT T.CLIENT_ID, T.OPERATION_ID, T.TARGET_TYPE, T.TARGET_NAME, T.CURR_JOB_NAME, TO_NUMBER(BITAND(T.ATTRIBUTES, 131072)), CASE NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'RUNNING' THEN 1 WHEN 'DISABLED' THEN 2 WHEN 'SCHEDULED' THEN 3 WHEN 'RETRY SCHEDULED' THEN 99 WHEN 'COMPLETED' THEN 99 WHEN 'BROKEN' THEN 99 WHEN 'FAILED' THEN 99 WHEN 'REMOTE' THEN 99 WHEN 'SUCCEEDED' THEN 99 WHEN 'STOPPED' THEN 99 WHEN 'CHAIN_STALLED' THEN 99 ELSE 99 END AS CONSOLIDATED_STATE, CASE NVL(JRD.STATUS, 'MISSING') WHEN 'MISSING' THEN 4 WHEN 'SUCCEEDED' THEN 10 WHEN 'FAILED' THEN 11 WHEN 'STOPPED' THEN CASE WHEN JRD.ADDITIONAL_INFO LIKE '%called by user%' THEN 12 WHEN JRD.ADDITIONAL_INFO LIKE '%window was closed%' THEN 13 WHEN JRD.ADDITIONAL_INFO LIKE 'ORA-01014%' THEN 14 ELSE 15 END ELSE 99 END AS STATUS, NVL(JRD.RUN_DURATION, INTERVAL '0' SECOND), NVL(JRD.CPU_USED, INTERVAL '0' SECOND), NVL(JRD.ERROR#, 0), NVL (JRD.STATUS, 'NO LOG ENTRY') || '(jrd)' AS DBG_STATUS, NVL((SELECT J.STATE FROM DBA_SCHEDULER_JOBS J WHERE T.CURR_JOB_NAME = J.JOB_NAME), 'MISSING') ||'(jobs)' AS DBG_STATE, NVL(JRD.LOG_DATE, TIMESTAMP '2001-01-01 01:01:01.01 +01:01'), NVL(JRD.LOG_ID, 0) FROM KET$_CLIENT_TASKS T, DBA_SCHEDULER_JOB_RUN_DETAILS JRD WHERE T.CURR_JOB_NAME IS NOT NULL AND T.CURR_JOB_NAME = JRD.JOB_NAME(+) AND 'SYS' = JRD.OWNER(+)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
47j049cqcp58j	SELECT OWNER, SEGMENT_NAME, PARTITION_NAME, SEGMENT_TYPE, TABLESPACE_NAME, TABLESPACE_ID FROM SYS_DBA_SEGS WHERE SEGMENT_OBJD = :B1 AND SEGMENT_TYPE <> 'ROLLBACK' AND SEGMENT_TYPE <> 'TYPE2 UNDO' AND SEGMENT_TYPE <> 'DEFERRED ROLLBACK' AND SEGMENT_TYPE <> 'TEMPORARY' AND SEGMENT_TYPE <> 'CACHE' AND SEGMENT_TYPE <> 'SPACE HEADER' AND SEGMENT_TYPE <> 'UNDEFINED' AND TABLESPACE_NAME NOT IN ('SYSAUX' , 'SYSTEM')
4cwvptqf55v42	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 (826) 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))
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
53pkuyc2acm21	/* OracleOEM */ SELECT * FROM ( SELECT /*+ ordered */ 1 "OBJECT_TYPE", u.name "USER_NAME", o.name "OBJECT_NAME", ' ' "PARTITION", ' ' "LOB_COLUMN", 1 "SEG_TYPE", tts.name "TABLESPACE", decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) "PROBLEM" FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tab$ t, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = t.obj# AND t.ts# = tts.ts# AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) AND decode (bitand (t.property, 1), 1, 1, 0) = 0 AND decode (b itand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 AND decode (bitand (t.property, 1024), 1024, 1, 0) = 0 UNION ALL SELECT /*+ ordered */ 2, u.name, o.name, ' ', ' ', 2, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.ind$ i, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = i.obj# AND i.ts# = tts.ts# AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AN D i.type# not in (4, 8) UNION ALL SELECT /*+ ordered */ 3, u.name, o.name, ' ', ' ', 12, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.clu$ c, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = c.obj# AND c.ts# = tts.ts# AND c.file# = s.file# AND c.block# = s.block# AND c.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tn.name, ' ', ' ', 1, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.ind$ i, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" tn, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = i.obj# AND i.ts# = tts.ts# AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND i.bo# = tn.obj# AND tn.obj# = t.obj# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# = 4 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, o.name, o.subname, ' ', 3, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND na me != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tabpart$ tp, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = tp.obj# AND tp.ts# = tts.ts# AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 2, u.name, o.name, o.subname, ' ', 4, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.indpart$ ip, sys.seg$ s, sys.ind$ i, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = ip.obj# AND ip.ts# = tts.ts# AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# not in (4, 8) AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tn.name, ' ', ' ', 5, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tab$ t, sys.seg$ s, sys.tab$ iot, sys."_CURRENT_EDITION_OBJ" tn, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# A ND u.type# !=2 AND o.obj# = t.obj# AND t.ts# = tts.ts# AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND tn.obj# = t.bobj# AND tn.obj# = iot.obj# AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tn.name, ' ', decode(bitand(c.property, 1), 1, substr(ac.name, 0, 500), c.name), 8, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.lob$ l, sys.seg$ s, sys.col$ c, sys.attrcol$ ac, sys."_CURRENT_EDITION_OBJ" tn, sys.user$ u WHERE tn.owner# = u.user# AND u.type# !=2 AND tn.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.ts# = tts.ts# AND l.file# = s.file# AND l.block# = s.block# AND l.ts# = s.ts# AND c.obj# = ac.obj#(+) AND c.intcol# = ac.intcol#(+) AND bitand(c.property, 32768) != 32768 AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tn.name, o.subname, ' ', 3, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.indpart$ ip, sys.seg$ s, sys.ind$ i, sys."_CURRENT_EDITION_OBJ" tn, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = ip.obj# AND ip.ts# = tts.ts# AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# = 4 AND i.bo# = tn.obj# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tbo.name, o.subname, ' ', 13, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tabpart$ tp, sys.seg$ s, sys.tab$ t, sys."_CURRENT_EDITION_OBJ" tbo, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = tp.obj# AND tp.ts# = tts.ts# AND tp.file# = s.file# AND tp.block# = s. block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 32), 32, 1, 0) = 1 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 AND tbo.obj# = t.bobj# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, tbo.name, po.subname, decode(bitand(c.property, 1), 1, substr(a.name, 0, 500), c.name), 8, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.lobfrag$ lf, sys.seg$ s, sys.lob$ l, sys.partobj$ pobj, sys."_CURRENT_EDITION_OBJ" po, sys."_CURRENT_EDITION_OBJ" tbo, sys.attrcol$ a, sys.col$ c, sy s.user$ u WHERE tbo.owner# = u.user# AND u.type# !=2 AND pobj.obj# = tbo.obj# AND lf.ts# = tts.ts# AND lf.file# = s.file# AND lf.block# = s.block# AND lf.ts# = s.ts# AND mod(pobj.spare2, 256) = 0 AND tbo.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.lobj# = lf.parentobj# AND lf.tabfragobj# = po.obj# AND bitand(c.property, 32768) != 32768 AND c.obj# = a.obj#(+) AND c.intcol# = a.intcol#(+) AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 1, u.name, bo.name, o.subname, ' ', 9, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.tabsubpart$ tsp, sys.seg$ s, sys."_CURRENT_EDITION_OBJ" bo, sys."_CURRENT_EDITION_OBJ" o, sys.user$ u WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = tsp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 2 AND tsp.ts# = tts.ts# AND tsp.file# = s.file# AND tsp.block# = s.block# AND tsp.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) UNION ALL SELECT /*+ ordered */ 2, u.name, bo.name, o.subname, ' ', 10, tts.name, decode (s.extpct, 0, 0, 1) + decode(mod(s.extsize, s.iniexts), 0, 0, 2) FROM (SELECT ts#, name FROM sys.ts$ WHERE (bitmapped = 0 OR (bitmapped != 0 AND bitand(flags, 3)=0)) AND bitand(flags, 2048) != 2048 AND online$ != 3 AND name != 'SYSTEM' AND name != 'SYSAUX' AND dflextpct = 0 AND (dflinit = 0 OR MOD(dflincr, dflinit) = 0)) tts, sys.indsubpart$ isp, sys.seg$ s, sys.user$ u, sys."_CURRENT_EDITION_OBJ" o, sys."_CURRENT_EDITION_OBJ" bo WHERE o.owner# = u.user# AND u.type# !=2 AND o.obj# = isp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 1 AND isp.ts# = tts.ts# AND isp.file# = s.file# AND isp.block# = s.block# AND isp.ts# = s.ts# AND (s.extpct > 0 OR (s.iniexts > 0 AND (mod(s.extsize, s.iniexts) != 0) ) ) ) where rownum < 201 AND LENGTH(lob_column) <= 30
59ppxxwtgq5t7	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 (952) 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))
5u2054rnpm0qy	DELETE FROM OAM_SESSION_SP_LIST WHERE SESSIONID = :1
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
63n9pwutt8yzw	MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_cdn(ST) */ INTO STATS_TARGET$ ST USING (SELECT STALENESS, OSIZE, OBJ#, TYPE#, AFLAGS, STATUS, SID, SERIAL#, PART#, BO# FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN T.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 5 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, 32 + CASE WHEN ((BITAND(T.FLAGS, 16) = 16 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 16) != 16) THEN 0 ELSE 128 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T, SYS.MON_MODS_ALL$ M, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND O.TYPE# = 2 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE#(+) AND T.BLOCK# = S.BLOCK#(+) AND T.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.PROPERTY, 64+512) = 0 AND BITAND(T.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(O.FLAGS, 128) != 128 AND (BITAND(T.PROPERTY, 4194304) != 4194304 AND BITAND(T.PROPERTY, 8388608) != 8388608) AND BITAND(T.PROPERTY, 4294967296) != 4294967296 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND NOT (U.NAME = 'SYS' AND O.NAME IN ('SUMDELTA$', 'SNAP_XCMT$')) AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (U.NAME, O.NAME) NOT IN (SELECT /*+ unnest */ * FROM (SELECT MOWNER, LOG FROM MLOG$ UNION ALL SELECT MOWNER, TEMP_LOG FROM MLOG$ WHERE TEMP_LOG IS NOT NULL)) AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM ( SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.I NSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND B ITAND(TAB.PROPERTY, 512) != 512 AND BITAND(TAB.FLAGS, 536870912) != 536870912 AND BITAND(T.FLAGS, 2097152) != 2097152 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2)) UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.GET_TABLE_BLOCK_COUNT(U.NAME, O.NAME, O.SUBNAME, NULL, 'TRUE') * :B6 OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.PART# PART#, T.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.OBJ$ O, SYS.USER$ U, SYS.TABCOMPART$ T, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 19 AND T.OBJ# = O.OBJ# AND O.OWNER# = U.USER# AND TAB.OBJ# = T.BO# AND M.OBJ#(+) = T.OBJ# AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 32) != 32 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR ( BITAND(T.FLAGS, 2) != 2)) ) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 64 ELSE 0 END + CASE WHEN ROW_NUMBER() OVER (PARTITION BY (SELECT TCP0.BO# FROM TABCOMPART$ TCP0 WHERE TCP0.OBJ#=ST0.BO#) ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(T.TS#, T.FILE#, T.BLOCK#, S.TYPE#, S.CACHEHINT, NVL (S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# TYPE#, T.SUBPART# PART#, T.POBJ# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(T.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.TABSUBPART$ T, SYS.TABCOMPART$ TCP, SYS.TAB$ TAB, SYS.OBJ$ OT, SYS.MON_MODS_ALL$ M, SYS.PARTOBJ$ PO, SYS.OPTSTAT_USER_PREFS$ P WHERE O.TYPE# = 34 AND S.TYPE# = 5 AND T.OBJ# = O.OBJ# AND M.OBJ#(+) = T.OBJ# AND T.FILE# = S.FILE# AND T.BLOCK# = S.BLOCK# AND T.TS# = S.TS# AND TS.TS# = S.TS# AND TCP.OBJ# = T.POBJ# AND TCP.BO# = TAB.OBJ# AND PO.OBJ# = TAB.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B8 ) <> 0 ) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND BITAND(TAB.TRIGFLAG, 67108864) != 67108864 AND TAB.OBJ# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND NOT (BITAND(O.FLAGS, 16) = 16 AND (O.NAME LIKE 'DR$%' OR O.NAME LIKE 'DR#%')) AND BITAND(TCP.FLAGS, 32) != 32 AND TAB.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 5) != 0) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(T.FLAGS, 2) != 2))) ST0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(I.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(CM.TRUNC, 1, GREATEST(CM.ROWCNT, CM.INSERTS), CM.TOT_MODS/(CM.ROWCNT + 0.01))))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), O.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, O.OBJ# OBJ#, O.TYPE# T YPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.SEG$ S, SYS.TS$ TS, SYS.OBJ$ O, SYS.IND$ I, SYS.OPTSTAT_USER_PREFS$ P, (SELECT BOBJ#, SUM(BITAND(T.TRIGFLAG, 67108864)/67108864) LOCKED, SUM(BITAND(M.FLAGS, 1))/COUNT(M.FLAGS) TRUNC, SUM(M.INSERTS+M.DELETES) TOT_MODS, SUM(M.INSERTS) INSERTS, SUM(T.ROWCNT) ROWCNT FROM MON_MODS_ALL$ M, TAB$ T WHERE M.OBJ#(+) = T.OBJ# AND T.CLUCOLS IS NOT NULL GROUP BY BOBJ#) CM WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(CM.BOBJ#, :B10 ) IS NOT NULL) AND O.TYPE# = 1 AND S.TYPE# = 6 AND I.TYPE# = 3 AND I.OBJ# = O.OBJ# AND I.BO# = CM.BOBJ#(+) AND I.FILE# = S.FILE# AND I.BLOCK# = S.BLOCK# AND I.TS# = S.TS# AND TS.TS# = S.TS# AND BITAND(O.FLAGS, 128) != 128 AND O.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND (BITAND(I.FLAGS, 2) = 0 OR (BITAND(I.FLAGS, 2) != 0 AND (CM.TRUNC > 0 OR CM.TOT_MODS > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * CM.ROWCNT))) AND CM.LOCKED = 0 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 UNION ALL SELECT /*+ no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ DECODE(BITAND(T.FLAGS, 16), 16, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(T.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(T.ROWCNT, (T.ROWCNT + M.INSERTS - M.DELETES)))) / (T.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, CASE WHEN I.FILE# = 0 THEN DBMS_STATS_INTERNAL.GET_INDEX_BLOCK_COUNT(U.NAME, OI.NAME, NULL, NULL, 'TRUE') WHEN S.TYPE# = 6 THEN DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(I.TS#, I.FILE#, I.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), I.DATAOBJ#, S.BLOCKS, 'TRUE') ELSE NULL END * NVL(TS.BLOCKSIZE, :B6 ) OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, 32 + CASE WHEN ((BITAND(T.FLAGS, 16) = 16 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT)) OR BITAND(T.FLAGS, 16) != 16) THEN 0 EL SE 128 END AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, NULL BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OBJ$ OI, OPTSTAT_USER_PREFS$ P WHERE (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(T.OBJ#, :B3 ), :B2 ) <> 0) AND I.TYPE# = 4 AND I.BO# = OT.OBJ# AND BITAND(OT.FLAGS, 128) != 128 AND OT.OWNER# = U.USER# AND M.OBJ#(+) = OT.OBJ# AND I.FILE# = S.FILE#(+) AND I.BLOCK# = S.BLOCK#(+) AND I.TS# = S.TS#(+) AND TS.TS#(+) = S.TS# AND T.OBJ# = OT.OBJ# AND I.OBJ# = OI.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND OT.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(T.FLAGS, 16) = 16 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * T.ROWCNT))) OR (BITAND(M.FLAGS, 4) = 4) OR (BITAND(T.FLAGS, 16) != 16)) UNION ALL SELECT /*+ leading(i t) no_expand dynamic_sampling(4) dynamic_sampling_est_cdn */ STALENESS, OSIZE, OBJ#, TYPE#, CASE WHEN ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY STALENESS, OSIZE, OBJ#) = 1 THEN 32 ELSE 0 END + 64 + AFLAGS AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, PART#, BO#, LOC_STALE_PCT FROM (SELECT DECODE(BITAND(TP.FLAGS, 2), 2, ROUND( LOG(0.01, NVL( LEAST( 100, GREATEST( 0.01, (DECODE(BITAND(M.FLAGS, 1), 1, GREATEST(TP.ROWCNT, M.INSERTS), LEAST((M.INSERTS + M.DELETES + M.UPDATES), GREATEST(TP.ROWCNT, (TP.ROWCNT + M.INSERTS - M.DELETES)))) / (TP.ROWCNT + 0.01)))), 0.01)), 1), -100.0) STALENESS, DBMS_STATS_INTERNAL.SEGMENT_NUMBER_BLOCKS(IP.TS#, IP.FILE#, IP.BLOCK#, S.TYPE#, S.CACHEHINT, NVL(S.SPARE1, 0), IP.DATAOBJ#, S.BLOCKS, 'TRUE') * TS.BLOCKSIZE OSIZE, OT.OBJ# OBJ#, OT.TYPE# TYPE#, TP.PART# PART#, TP.BO# BO#, TO_NUMBER(P.VALCHAR) LOC_STALE_PCT, CASE WHEN ((BITAND(TP.FLAGS, 2) = 2 AND (BITAND(M.FLAGS, 1) != 0 OR (M.INS ERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT)) OR BITAND(TP.FLAGS, 2) != 2) THEN 0 ELSE 128 END AFLAGS FROM SYS.USER$ U, SYS.OBJ$ OT, SYS.IND$ I, SYS.INDPART$ IP, SYS.TABPART$ TP, SYS.SEG$ S, SYS.MON_MODS_ALL$ M, SYS.TS$ TS, SYS.TAB$ T, SYS.OPTSTAT_USER_PREFS$ P WHERE I.TYPE# = 4 AND S.TYPE# = 6 AND OT.OWNER# = U.USER# AND I.OBJ# = IP.BO# AND IP.PART# = TP.PART# AND TP.OBJ# = OT.OBJ# AND I.BO# = TP.BO# AND BITAND(OT.FLAGS, 128) != 128 AND M.OBJ#(+) = OT.OBJ# AND IP.FILE# = S.FILE# AND IP.BLOCK# = S.BLOCK# AND IP.TS# = S.TS# AND TS.TS# = S.TS# AND I.BO# = T.OBJ# AND NOT (BITAND(OT.FLAGS, 16) = 16 AND (OT.NAME LIKE 'DR$%' OR OT.NAME LIKE 'DR#%')) AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(TP.FLAGS, 32) != 32 AND T.OBJ# = P.OBJ#(+) AND P.PNAME(+) = 'STALE_PERCENT' AND ((BITAND(TP.FLAGS, 2) = 2 AND ((BITAND(M.FLAGS, 1) = 1) OR ((M.INSERTS + M.UPDATES + M.DELETES) > NVL(TO_NUMBER(P.VALCHAR), :B1 )/100 * TP.ROWCNT))) OR (BITA ND(M.FLAGS, 4) = 4) OR (BITAND(TP.FLAGS, 2) != 2))) WHERE BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(BO#, :B3 ), :B7 ) <> 0 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 1 TYPE#, 32 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, NULL PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM SYS.IND$ I, SYS.TAB$ T, SYS.OBJ$ O, USER$ U WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B2 ) <> 0) AND BITAND(I.PROPERTY, 32) != 32 AND BITAND(I.PROPERTY, 64) != 64 AND BITAND(I.FLAGS, 2) != 2 AND I.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND BITAND(T.FLAGS, 16) = 16 AND I.OBJ# = O.OBJ# AND I.TYPE# != 4 AND I.TYPE# != 8 AND BITAND(I.FLAGS, 1+8+16+1024+4096) = 0 AND BITAND(O.FLAGS, 128) != 128 AND O.OWNER# = U.USER# AND NOT (U.NAME = 'SYS' AND O.NAME = 'I_SUMDELTA$') UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 20 TYPE#, 64 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.PART# PART#, I.BO# BO#, NULL LOC_STALE_PCT FROM (SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDPART$ WHERE BITAND(FLAGS, 2) != 2 UNION ALL SELECT OBJ#, BO#, PART#, FLAGS FROM SYS.INDCOMPART$ WHERE BITAND(FLAGS, 2) != 2 ) I, SYS.IND$ IND, SYS.TAB$ T, SYS.OBJ$ OI WHERE (DBMS_STATS_INTERNAL.GATHER_INDEX(I.BO#, :B10 ) IS NOT NULL) AND (BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(I.BO#, :B3 ), :B7 ) <> 0) AND I.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 UNION ALL SELECT /*+ ordered */ -99 STALENESS, 100*:B6 OSIZE, I.OBJ# OBJ#, 35 TYPE#, 0 AFLAGS, 0 STATUS, :B5 SID, :B4 SERIAL#, I.SUBPART# PART#, I.POBJ# BO#, NULL LOC_STALE_PCT FROM SYS.INDSUBPART$ I, SYS.INDCOMPART$ ICP, SYS.IND$ IND, SYS.TAB$ T, SYS.PARTOBJ$ PO, SYS.OBJ$ OI WHERE ( DBMS_STATS_INTERNAL.GATHER_INDEX(IND.BO#, :B10 ) IS NOT NULL) AND BITAND(I.FLAGS, 2) != 2 AND I.POBJ# = ICP.OBJ# AND ICP.BO# = IND.OBJ# AND IND.TYPE# != 4 AND IND.TYPE# != 8 AND BITAND(IND.FLAGS, 1+8+16+1024+4096) = 0 AND IND.BO# = T.OBJ# AND BITAND(T.TRIGFLAG, 67108864) != 67108864 AND IND.OBJ# = PO.OBJ# AND (((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B9 ) <> 0) AND BITAND(PO.SPARE2, 255) = 2) OR ((BITAND(DBMS_STATS_INTERNAL.DECODE_GRANULARITY(IND.BO#, :B3 ), :B8 ) <> 0) AND BITAND(PO.SPARE2, 255) NOT IN (0, 2))) AND IND.OBJ# = OI.OBJ# AND BITAND(OI.FLAGS, 128) != 128 ) WHERE OSIZE IS NOT NULL ) NEW ON (ST.OBJ# = NEW.OBJ#) WHEN MATCHED THEN UPDATE SET ST.STALENESS = CASE WHEN BITAND(ST.FLAGS, 7) > 1 THEN GREATEST(NEW.STALENESS, -0.5) + ROUND(BITAND(ST.FLAGS, 7)*0.15, 1) ELSE NEW.STALENESS END, ST.OSIZE = NEW.OSIZE * DECODE(BITAND(ST.FLAGS, 7), 0, 1, 2), ST.FLAGS = ST.FLAGS - BITAND(ST.FLAGS, 32+64+128) + NEW.AFLAGS, ST.STATUS = 0, ST.TYPE# = NEW.TYPE#, ST.PART# = NEW.PART#, ST.BO# = NEW.BO#, ST.SID = NEW.SID, ST.SERIAL# = NEW.SERIAL# WHEN NOT MATCHED THEN INSERT (ST.STALENESS, ST.OSIZE, ST.OBJ#, ST.TYPE#, ST.FLAGS, ST.STATUS, ST.SID, ST.SERIAL#, ST.PART#, ST.BO#) VALUES (NEW.STALENESS, NEW.OSIZE, NEW.OBJ#, NEW.TYPE#, NEW.AFLAGS, NEW.STATUS, :B5 , :B4 , NEW.PART#, NEW.BO#)
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'
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;
6h5t2wyax3cx0	SELECT ltrim(rtrim(accept_gsmhm)) accept_gsmhm, accept_e, accept_n, accept_time FROM tank_gps_yyyymmdd where accept_time>trunc(sysdate)
6k5agh28pr3wp	select propagation_name streams_name, 'PROPAGATION' streams_type, '"'||destination_queue_owner||'"."'||destination_queue_name||'"@'||destination_dblink address, queue_table, owner, source_queue_name from dba_queues, dba_propagation where owner=SOURCE_QUEUE_OWNER and SOURCE_QUEUE_NAME=name
6mcpb06rctk0x	call dbms_space.auto_space_advisor_job_proc ( )
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
6tpaxtb3m676v	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 (825) 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))
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
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
7wt7phk4xns75	select a.capture_name streams_process_name, a.status streams_process_status, 'CAPTURE' streams_process_type, COUNT(a.error_message) from dba_capture a group by a.capture_name, a.status union all select a.propagation_name streams_process_name, a.status streams_process_status, 'PROPAGATION' streams_process_type, COUNT(a.error_message) from dba_propagation a group by a.propagation_name, a.status union all select a.apply_name streams_process_name, a.status streams_process_status, 'APPLY' streams_process_type, COUNT(a.error_message) from dba_apply a group by a.apply_name, a.status
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
86521pa77y28j	SELECT (case when snap_id = :begin_snap_id then 1 else 0 end) as start_snap, (case when name = 'maximum PGA allocated' then 1 when name = 'total PGA allocated' then 2 when name = 'over allocation count' then 3 when name = 'recompute count (total)' then 4 else 0 end) as stat_id, value FROM WRH$_PGASTAT pga WHERE pga.dbid = :dbid AND pga.instance_number = :inst_num AND (pga.snap_id = :begin_snap_id OR pga.snap_id = :end_snap_id ) AND pga.name IN ( 'maximum PGA allocated' , 'total PGA allocated' , 'over allocation count' , 'recompute count (total)' ) ORDER BY snap_id, stat_id
86w49kdq48gk9	SELECT STATUS#, HOW_CREATED, LAST_EXECUTION FROM SYS.DBA_ADVISOR_TASKS WHERE TASK_ID = :B1 FOR UPDATE
88juhgrgf4zqa	SELECT DISTINCT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDINGCOUNT FINDINGCOUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS, INSTANCES.INSTANCE_COUNT INSTCOUNT FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(DISTINCT F_ALL.TASK_ID) FINDINGCOUNT, F_CURR.FINDING_NAME FROM (SELECT DISTINCT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 AND TYPE<>'INFORMATION' AND TYPE<>'WARNING' AND PARENT=0) F_CURR, (SELECT TASK_ID, END_TIME FROM DBA_ADDM_TASKS WHERE END_TIME>SYSDATE -1 AND REQUESTED_ANALYSIS='DATABASE') TASKS, (SELECT DISTINCT FINDING_NAME , TASK_ID FROM DBA_ADVISOR_FINDINGS) F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME GROUP BY F_CURR.FINDING_NAME) HISTORY, (SELECT F.TASK_ID, F.FINDING_ID, COUNT(B.INSTANCE_NUMBER) INSTANCE_COUNT FROM DBA_ADDM_FDG_BREAKDOWN B, DBA_ADDM_FINDINGS F WHERE B.TASK_ID= :B1 AND B.TASK_ID=F.TASK_ID AND B.FINDING_ID =F.FINDING_ID AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.PARENT=0 GROUP BY F.FINDING_ID, F.TASK_ID ORDER BY F.FINDING_ID ) INSTANCES WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME(+) AND F.TASK_ID=INSTANCES.TASK_ID(+) AND F.FINDING_ID=INSTANCES.FINDING_ID (+) ORDER BY F.FINDING_ID
8f1sjvfxuup9w	select t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null
8szmwam7fysa3	insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
8wy6a0y7k22zn	SELECT SUBJECT_ID FROM OPB_WIDGET WHERE WIDGET_ID = :1
9juw6s4yy5pzp	/* OracleOEM */ SELECT SUM(broken), SUM(failed) FROM (SELECT DECODE(STATE, 'BROKEN', 1, 0) broken, DECODE(STATE, 'FAILED', 1, 0) failed FROM DBA_SCHEDULER_JOBS )
9p5tvdmjymwx7	UPDATE MGMT_POLICY_ASSOC_EVAL_SUMM SET LAST_EVALUATION_DATE = NVL(:B12 , SYSDATE), ROWS_EVALUATED = NVL(:B11 , 0), TOTAL_VIOLATIONS_LOGGED = NVL(:B10 , TOTAL_VIOLATIONS_LOGGED), NON_EXEMPT_VIOLATIONS_LOGGED = NVL(:B9 , :B8 ), MAX_VIOLATION_LEVEL = NVL(:B7 , :B6 ), COMPLIANCE_SCORE = NVL(:B5 , :B4 ) WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND COLL_NAME = :B1
9v8vzvh90mdjq	SELECT SERVER_INVENTORY_RT.OPERATION_ID, SERVER_INVENTORY_RT.STATION_ID, SERVER_INVENTORY_RT.TANK_ID, SERVER_INVENTORY_RT.DEVICE_BRAND, SERVER_INVENTORY_RT.UPLOAD_TIME, SERVER_INVENTORY_RT.TANK_STATE, SERVER_INVENTORY_RT.OIL_VOLUME, SERVER_INVENTORY_RT.STANDARD_VOLUME, SERVER_INVENTORY_RT.EMPTY_VOLUME, SERVER_INVENTORY_RT.OIL_HEIGHT, SERVER_INVENTORY_RT.WATER_HEIGHT, SERVER_INVENTORY_RT.TEMPERATURE, SERVER_INVENTORY_RT.WATER_VOLUME, SERVER_INVENTORY_RT.UPDATE_TIME, SERVER_INVENTORY_RT.APPARENT_DENSITY, SERVER_INVENTORY_RT.STANDARD_DENSITY FROM SERVER_INVENTORY_RT
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
a5pyncg7v0bw3	/* OracleOEM */ SELECT PROPAGATION_NAME, MESSAGE_DELIVERY_MODE, TOTAL_NUMBER, TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE='BUFFERED' AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%'
a8j39qb13tqkr	SELECT :B1 TASK_ID, F.FINDING_ID FINDING_ID, DECODE(RECINFO.TYPE, NULL, 'Uncategorized', RECINFO.TYPE) REC_TYPE, RECINFO.RECCOUNT REC_COUNT, F.PERC_ACTIVE_SESS IMPACT_PCT, F.MESSAGE MESSAGE, TO_DATE(:B3 , 'MM-DD-YYYY HH24:MI:SS') START_TIME, TO_DATE(:B2 , 'MM-DD-YYYY HH24:MI:SS') END_TIME, HISTORY.FINDING_COUNT FINDING_COUNT, F.FINDING_NAME FINDING_NAME, F.ACTIVE_SESSIONS ACTIVE_SESSIONS FROM DBA_ADDM_FINDINGS F, (SELECT FINDING_ID, COUNT(R.REC_ID) RECCOUNT, R.TYPE FROM DBA_ADVISOR_RECOMMENDATIONS R WHERE TASK_ID=:B1 GROUP BY R.FINDING_ID, R.TYPE) RECINFO, (SELECT COUNT(F_ALL.TASK_ID) FINDING_COUNT, F_CURR.FINDING_NAME FROM (SELECT FINDING_NAME FROM DBA_ADVISOR_FINDINGS WHERE TASK_ID=:B1 ) F_CURR, (SELECT T.TASK_ID, I.LOCAL_TASK_ID, T.END_TIME, T.BEGIN_TIME FROM DBA_ADDM_TASKS T, DBA_ADDM_INSTANCES I WHERE T.END_TIME>SYSDATE -1 AND T.TASK_ID=I.TASK_ID AND I.INSTANCE_NUMBER=SYS_CONTEXT('USERENV', 'INSTANCE') AND T.REQUESTED_ANALYSIS='INSTANCE' ) TASKS, DBA_ADVISOR_F INDINGS F_ALL WHERE F_ALL.TASK_ID=TASKS.TASK_ID AND F_ALL.FINDING_NAME=F_CURR.FINDING_NAME AND F_ALL.TYPE<>'INFORMATION' AND F_ALL.TYPE<>'WARNING' AND F_ALL.PARENT=0 GROUP BY F_CURR.FINDING_NAME) HISTORY WHERE F.TASK_ID=:B1 AND F.TYPE<>'INFORMATION' AND F.TYPE<>'WARNING' AND F.FILTERED<>'Y' AND F.PARENT=0 AND F.FINDING_ID=RECINFO.FINDING_ID (+) AND F.FINDING_NAME=HISTORY.FINDING_NAME ORDER BY F.FINDING_ID
aq8yqxyyb40nn	update sys.job$ set this_date=:1 where job=:2
atuahy45wt11t	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 (188) 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))
b2u9kspucpqwy	SELECT COUNT(*) FROM SYS.DBA_PROPAGATION WHERE ERROR_MESSAGE IS NOT NULL
b6usrg82hwsa3	call dbms_stats.gather_database_stats_job_proc ( )
bd502nbh9abbs	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
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)
bqjpcb6ty7j29	UPDATE OPB_WIDGET SET LAST_SAVED = :1 WHERE WIDGET_ID = :2 AND VERSION_NUMBER = :3
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
ctn8bh6bz4mzu	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 18: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 18: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 18:57:01', 'yyyy-mm-dd hh24:mi:ss'))
cxjqbfn0d3yqq	SELECT COUNT(*) FROM SYS.DBA_PROPAGATION
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
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
dmr7x58mt4gsz	INSERT INTO GIS.EASYJOY_SALE_DATESUM_BYCITY (CITY, AN_DATE, COMM_SNAME, XSJE, XSML, KCJE) SELECT EJOY.CITY, NEBA.AN_DATE, NEBA.COMM_SNAME, SUM(NEBA.COM_SUM) AS XSJE, SUM(NEBA.GROSS_PROFIT) AS XSML, SUM(INVENTORY_VALUE) AS KCJE FROM MCSDW.NOLB_EASYJOY_BUSINESS_ANALYSE NEBA, GIS.EASYJOY_BASE_INFO EJOY WHERE NEBA.STORE_ID = EJOY.STORE_ID GROUP BY NEBA.COMM_SNAME, EJOY.CITY, NEBA.AN_DATE ORDER BY EJOY.CITY
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
fjvwzpxbpch0h	/* OracleOEM */ select capture_name streams_name, 'capture' streams_type , (available_message_create_time- capture_message_create_time)*86400 latency, nvl(total_messages_enqueued, 0) total_messages from gv$streams_capture union all select propagation_name streams_name, 'propagation' streams_type, last_lcr_latency latency , total_msgs total_messages from gv$propagation_sender where propagation_name is not null union all select server_name streams_name, 'apply' streams_type, (send_time-last_sent_message_create_time)*86400 latency, nvl(total_messages_sent, 0) total_messages from gv$xstream_outbound_server where committed_data_only='NO' union all SELECT distinct apc.apply_name as STREAMS_NAME, 'apply' as STREAMS_TYPE, CASE WHEN aps.state != 'IDLE' THEN nvl((aps.apply_time - aps.create_time)*86400, -1) WHEN apc.state != 'IDLE' THEN nvl((apc.apply_time - apc.create_time)*86400, -1) WHEN apr.state != 'IDLE' THEN nvl((apr.apply_time - apr.create_time)*86400, -1) ELSE 0 END as STR EAMS_LATENCY, nvl(aps.TOTAL_MESSAGES_APPLIED, 0) as TOTAL_MESSAGES FROM ( SELECT apply_name, state, apply_time, applied_message_create_time as create_time, total_messages_applied FROM ( SELECT apply_name, state, apply_time, applied_message_create_time, MAX(applied_message_create_time) OVER (PARTITION BY apply_name) as max_create_time, SUM(total_messages_applied) OVER (PARTITION BY apply_name) as total_messages_applied FROM gv$streams_apply_server ) WHERE MAX_CREATE_TIME||'X' = APPLIED_MESSAGE_CREATE_TIME||'X' ) aps, ( SELECT c.apply_name, state, -- This is the XOUT case c.hwm_time as apply_time, hwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name in (select server_name from dba_xstream_outbound) union SELECT c.apply_name, state, -- This is non-XOUT case c.lwm_time as apply_time, lwm_message_create_time as create_time, total_applied FROM gv$streams_apply_coordinator c, dba_apply p WHERE p.apply_name = c.apply_name and p.apply_name not in (select server_name from dba_xstream_outbound) ) apc, ( SELECT apply_name, state, dequeue_time as apply_time, dequeued_message_create_time as create_time FROM gv$streams_apply_reader ) apr WHERE apc.apply_name = apr.apply_name AND apr.apply_name = aps.apply_name
frky6qxh68bk7	SELECT NVL(TO_NUMBER(VALUE), 0) FROM MGMT_OMS_PARAMETERS WHERE NAME='loaderFileCount' AND HOST_URL = :B1
fsbqktj5vw6n9	select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and p.instance_id is NULL and (p.class_oid is null or (p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.instance_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ( (bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and q.instance_id is NULL and (q.class_oid is null or (q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where c.affinity is null))) UNION ALL select j.job, 0, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), NULL, 0 from sys.job$ j where (j.field1 is null or j.field1 = 0) and j.this_date is null) a order by 1) where rownum = 1
ftkb9du07bavb	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 (830) 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))
fzjn0um9rz17t	SELECT HOST_URL, VALUE FROM MGMT_OMS_PARAMETERS WHERE NAME = :B1
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
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)

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