WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORCL	1307126963	orcl2	2	29-Dec-13 12:12	11.2.0.3.0	YES

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

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	16711	26-Feb-14 15:59:59	75	3.5
End Snap:	16712	26-Feb-14 17:00:38	70	2.7
Elapsed:		60.65 (mins)
DB Time:		72.04 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	3,536M	3,536M	Std Block Size:	8K
Shared Pool Size:	1,696M	1,696M	Log Buffer:	9,504K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	1.2	0.2	0.01	0.00
DB CPU(s):	0.2	0.0	0.00	0.00
Redo size:	42,411.3	8,709.4
Logical reads:	28,273.7	5,806.1
Block changes:	81.6	16.8
Physical reads:	1,482.1	304.4
Physical writes:	8.1	1.7
User calls:	679.2	139.5
Parses:	2.7	0.6
Hard parses:	0.1	0.0
W/A MB processed:	1.5	0.3
Logons:	0.0	0.0
Executes:	177.3	36.4
Rollbacks:	0.0	0.0
Transactions:	4.9

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.71	In-memory Sort %:	100.00
Library Hit %:	99.79	Soft Parse %:	96.61
Execute to Parse %:	98.47	Latch Hit %:	99.88
Parse CPU to Parse Elapsd %:	49.75	% Non-Parse CPU:	99.37

Shared Pool Statistics

	Begin	End
Memory Usage %:	74.40	74.46
% SQL with executions>1:	93.66	93.50
% Memory for SQL w/exec>1:	82.49	83.66

Top 5 Timed Foreground Events

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

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.00	1.45	1.8	1.0	0.7	97.2

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
0.6	22.2	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	15,616.0	15,616.0
SGA use (MB):	5,328.0	5,328.0
PGA use (MB):	518.6	467.1
% Host Mem used for SGA+PGA:	37.44	37.11

RAC Statistics

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	85.43	17.54
Global Cache blocks served:	261.97	53.80
GCS/GES messages received:	465.87	95.67
GCS/GES messages sent:	284.39	58.40
DBWR Fusion writes:	0.68	0.14
Estd Interconnect traffic (KB)	2,925.70

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

Buffer access - local cache %:	99.39
Buffer access - remote cache %:	0.32
Buffer access - disk %:	0.29

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.9
Avg global cache current block receive time (ms):	1.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 %:	0.2
Avg global cache cr block flush time (ms):	6.9
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):	5.6

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.3
Avg message received queue time (ms):	0.1
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	31.68
% of indirect sent messages:	67.78
% of flow controlled messages:	0.53

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): 4322.3s
• 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 92.7% of Total DB time 4,322.33 (s)
• Total FG Wait Time: 3,367.22 (s) DB CPU time: 637.72 (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 38.7% of Total DB Time (s): 4,322
• Captured PL/SQL account for 0.0% of Total DB Time (s): 4,322

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

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 33.2% of Total User I/O Wait Time (s): 2,609
• Captured PL/SQL account for 0.0% of Total User I/O Wait Time (s): 2,609

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: 102,884,812
• Captured SQL account for 90.1% 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: 5,393,274
• Captured SQL account for 76.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: 1,414,745
• Captured SQL account for 12.3% of Total
• Total UnOptimized Read Requests: 1,414,745
• Captured SQL account for 12.3% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 645,062
• Captured SQL account for 50.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 9,841
• Captured SQL account for 37.3% 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): 70
• Captured SQL account for 89.8% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
04dqt9cjr9ja6	SELECT * FROM Fxd_HousePayStateQueryInFo WHERE RegiID like :param0 Order By RegiID
04ugnsxhcw18p	SELECT Guid, ShortTitle, MainTitle, KeyWords, PubDate, TypeID, IsShow FROM Pub_QueryAll WHERE (IsShow = :param0 ) AND IsDelete = :param1 AND ((ShortTitle like '%·¿µØ²úÖнé%' OR MainTitle like '%·¿µØ²úÖнé%' OR KeyWords like '%·¿µØ²úÖнé%' OR Content like '%·¿µØ²úÖнé%')) Order By PubDate desc
05gj6wtqumw10	SELECT Fxd_AllHouse.* FROM Fxd_AllHouse WHERE Fxd_AllHouse.CantonCode like :param0 Order By Fxd_AllHouse.PropertyCode
079udkcpzvr1p	SELECT Count(*) FROM Pub_ArticleItem I left join Pub_ArticleItemOther D on D.ArticleID=I.Guid WHERE (D.DepartID like :param0 ) AND (I.ClassID like :param1 ) AND (I.IsShow like :param2 ) AND IsDelete = :param3
08qpghs7y4q2f	UPDATE SYS.WRI$_ADV_TASKS SET MTIME = SYSDATE, LAST_EXEC_NAME = :B5 , STATUS = NVL(:B4 , STATUS), CLEANUP = NVL(:B3 , CLEANUP), VERSION = NVL(:B2 , VERSION) WHERE ID = :B1
0as3vn890wvc6	SELECT Guid , ShortTitle , MainTitle , DeputyTitle , Source , Writer , KeyWords , PubName , ClassID , PicUrl , IsPicNews , IsHasPic , IsShowCritique , PubDate , SortDate , ReadCount FROM Pub_ArticleItem WHERE (IsShow = :param0 ) AND IsDelete = :param1 AND (ClassID like '|000001002%' or ClassID like '|004001%' or ClassID like '|005001%' or ClassID like '|005004001%' or ClassID like '|006001%' or ClassID like '|007001%' or ClassID like '|008001%' or ClassID like '|009001%' or ClassID like '|010001%' or ClassID like '|016001%' or ClassID like '|011002001%' or ClassID like '|011001002%' or ClassID like '|011003001%') Order By OnTop Desc , SortDate Desc
0shksdzxpp4bh	select snap_interval, retention, most_recent_snap_time, most_recent_snap_id, status_flag, most_recent_purge_time, most_recent_split_id, most_recent_split_time, mrct_snap_time_num, mrct_purge_time_num, snapint_num, retention_num, swrf_version, registration_status, mrct_baseline_id, topnsql, mrct_bltmpl_id from wrm$_wr_control where dbid = :dbid
0ypyzy4qdfyvp	SELECT count(*) FROM OA_Message WHERE Status = :param0 AND Receiver like :param1 AND isDelete = :param2
15rbgh4d2ku4u	insert into WRM$_SNAPSHOT (snap_id, dbid, instance_number, startup_time, begin_interval_time, end_interval_time, snap_level, status, error_count, bl_moved, snap_flag, snap_timezone) values (:snap_id, :dbid, :instance_number, :startup_time, :begin_interval_time, :end_interval_time, :snap_level, :status, 0, 0, :bind1, :bind2)
171bpphqpdxmq	SELECT OA_Message.* FROM OA_Message WHERE SendTime >= :param0 AND Receiver like :param1 AND isDelete = :param2 AND ( Status=3 or Status=4) Order By SendTime desc
19vqp50jtyp7x	SELECT * FROM OA_NNextTask WHERE (TaskID = :param0 )
1gt0sw0nr4sfn	select * from ( select act.workstate, ntask.TYPE, ntask.RUNNER, ntask.ID, ntask.WORKID, ntask.STATE, ntask.SUBMITOR, ntask.CREATETIME, ntask.finishtime endtime, ar.ARCHIVEID, ar.CREATOR, ar.CREATEDATE, ar.PIGEONHOLEDATE, ar.TITLE, ar.ARCHIVECONTENT, ar.reason, ar.DOCNO, ar.WORKNO, ar.ARCHIVETYPE, ar.PROJECT, ar.DEVELOPER, ar.PRESALEAREA, ar.ArchiveLevel, ar.ReceiveDate from (select a.id, a.state as workstate , a.parameters, t_1.finishtime finishtime from oa_nworkinstance a, (select workid, max(finishtime) as finishtime from oa_ntaskinstance where runner = :param0 and state in (2, 4) And finishtime> :param1 group by workid ) t_1 where a.id = t_1.workid ) act, oa_ntaskinstance ntask, oa_archive ar where act.parameters = ar.archiveid and act.finishtime = ntask.finishtime and ntask.workid = act.id and ntask.runner = :param0 And ArchiveType = :param2 Order By decode(act.workstate, 2, 1, 4, 2, 3), ntask.createtime desc ) t where rownum <= 300
1zmc53qqak419	select * from ( select act.workstate, ntask.TYPE, ntask.RUNNER, ntask.ID, ntask.WORKID, ntask.STATE, ntask.SUBMITOR, ntask.CREATETIME, ntask.finishtime endtime, ar.ARCHIVEID, ar.CREATOR, ar.CREATEDATE, ar.PIGEONHOLEDATE, ar.TITLE, ar.ARCHIVECONTENT, ar.reason, ar.DOCNO, ar.WORKNO, ar.ARCHIVETYPE, ar.PROJECT, ar.DEVELOPER, ar.PRESALEAREA, ar.ArchiveLevel, ar.ReceiveDate from (select a.id, a.state as workstate , a.parameters, t_1.finishtime finishtime from oa_nworkinstance a, (select workid, max(finishtime) as finishtime from oa_ntaskinstance where runner = :param0 and state in (2, 4) And finishtime> :param1 group by workid ) t_1 where a.id = t_1.workid ) act, oa_ntaskinstance ntask, oa_archive ar where act.parameters = ar.archiveid and act.finishtime = ntask.finishtime and ntask.workid = act.id and ntask.runner = :param0 And ArchiveType = :param2 Order By ntask.finishTime desc ) t where rownum <= 300
23nad9x295gkf	SELECT (m.current_size / 1048576) as sizemb, case when cast(m.last_oper_time as timestamp) > s.end_interval_time then 1 else 0 end as changed, decode( m.component , 'shared pool', 1, 'streams pool', 2, 'DEFAULT buffer cache', 3, 'DEFAULT 2K buffer cache', 4, 'DEFAULT 4K buffer cache', 5, 'DEFAULT 8K buffer cache', 6, 'DEFAULT 16K buffer cache', 7, 'DEFAULT 32K buffer cache', 8, 'SGA Target', 9, 'PGA Target', 10, 'memory target', 11 , 255) as comp_id FROM WRH$_MEM_DYNAMIC_COMP m , WRM$_SNAPSHOT s WHERE m.dbid = :dbid AND m.instance_number = :inst_num AND m.snap_id = :end_snap_id AND s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id = :begin_snap_id
25fcnrfp9052w	UPDATE Pub_JZXX SET Guid = :param0, Title = :param1, TitleClass = :param2, WriterName = :param3, WriteDate = :param4, AccessCount = :param5, TitleContent = :param6, ReportDate = :param7, ReportContent = :param8, DepartmentID = :param9, SortDate = :param10, OnTop = :param11, Work = :param12, EMail = :param13, Phone = :param14, Address = :param15, PostCode = :param16, IsFamiliar = :param17, IsReport = :param18, WorkFlowStatus = :param19, IsShow = :param20, Submiter = :param21, SubmitDate = :param22, Auditer = :param23, AuditDate = :param24, AuditContent = :param25, ModifyContent = :param26, OutDate = :param27, SubmitCS = :param28, Type = :param29, GZFS = :param30, IsDelete = :param31, PostDate = :param32, GetWirteGuid = :param33, GetNum = :param34, Satisfaction = :param35, ComplaintPerson = :param36, WorkNO = :param37, WindowNO = :param38, OfficeRoom = :param39, OccurrenceTime = :param40 WHERE Guid = :param0
2724rk7sq9krh	UPDATE Fxd_BuildDistrictDoc SET Guid = :param0, SerialNumber = :param1, TransDocNo = :param2, BankCode = :param3, BankName = :param4, State = :param5, PubDate = :param6, IsTemp = :param7, IsOldHouse= :param8, Remark= :param9, Filler = :param10, CantonCode = :param11, DistGUID = :param12, NotifyNo = :param13, Summary = :param14, FlowID = :param15, FlowStatus = :param16, FinishDate= :param17, EstateAreaItem = :param18, ParentAccountCode = :param19, BankConfirmInfo = :param20, EstateAccountCode = :param21, ManagerGUID = :param22, ManagerName = :param23 WHERE Guid = :param0
29f4z79dy4qtk	SELECT * FROM OA_Message WHERE Status = :param0 AND SaveInOutBox = :param1 AND isDelete = :param2 Order By SendTime desc
2bwbt8m6w68n0	SELECT Count(*) FROM Pub_ArticleItem WHERE (IsShow = :param0 ) AND IsDelete = :param1 AND (ClassID like '|000001002%' or ClassID like '|004001%' or ClassID like '|005001%' or ClassID like '|005004001%' or ClassID like '|006001%' or ClassID like '|007001%' or ClassID like '|008001%' or ClassID like '|009001%' or ClassID like '|010001%' or ClassID like '|016001%' or ClassID like '|011002001%' or ClassID like '|011001002%' or ClassID like '|011003001%')
2bx59huq7rvyc	SELECT * FROM Fxd_FlowOpinion WHERE DocGUID like :param0 Order By RunTime desc
2c1qcns49ng1u	SELECT Count(*) FROM Pub_ArticleItem WHERE (IsShow = :param0 ) AND IsDelete = :param1 AND (ClassID like '|002001%' or ClassID like '|006010%' or ClassID like '|008002%' or ClassID like '|004009%' or ClassID like '|004006%')
2f2qtqnf5ysbu	SELECT COUNT(*) FROM OA_QUERYTASKVIEWEX WHERE ArchiveType = :param0 AND Runner like :param1 AND State = :param2
2gp01xhdx1s6j	SELECT count(*) FROM Pub_Sequences WHERE Sequence_Name like :param0
2prkvjjrsyqpd	select count(b.id) from oa_archivetaskparam a, oa_ntaskinstance b, oa_archive c where a.flowid = b.id and b.parameters = c.archiveid and b.state = 1 And b.Runner = :param0 AND c.ArchiveType = :param1
2vjxt8tm7rnf4	SELECT * FROM PUB_WorkInstance WHERE EngineId = :param0 AND Status = :param1
2w5984t67qccn	SELECT * FROM OA_AttachmentFile WHERE (FileId = :param0 )
2yvf9p0fj10hu	UPDATE Fxd_WorkTask SET WorkID = :param0, TaskID = :param1, Name = :param2, Class = :param3, Operators = :param4, TimeLimite = :param5, OpLevel = :param6, Action = :param7, ActionPara = :param8, EventHandler = :param9, NodeType = :param10, NextTasks = :param11, NextTaskSelector = :param12, PreTasks = :param13, PreTaskSelector = :param14, Memo = :param15, StartTime = :param16, EndTime = :param17, Runner = :param18, MainParaIn = :param19, MainParaOut = :param20, TaskStatus = :param21, RunCount = :param22, LocationX = :param23, LocationY = :param24 WHERE TaskID = :param1
317v5hnvvd49h	UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat)
33j9bpx602rxz	SELECT Count(*) FROM Pub_ArticleItem WHERE (IsShow = :param0 ) AND (ClassID like :param1 ) AND IsDelete = :param2
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
3aw5p4x0mf6v4	SELECT * FROM Pub_JZXX WHERE Title like :param0 AND IsShow = :param1 AND Type = :param2 AND IsDelete = :param3 Order By WriteDate desc
3dnvk1kth5bja	SELECT * FROM oa_MessageReceiver WHERE MessageID like :param0
3xud9agjbz2x6	SELECT Guid , ShortTitle , MainTitle , DeputyTitle , Source , Writer , KeyWords , PubName , ClassID , PicUrl , IsPicNews , IsHasPic , IsShowCritique , PubDate , SortDate , ReadCount FROM Pub_ArticleItem WHERE (IsShow = :param0 ) AND IsDelete = :param1 AND (ClassID like '|002001%' or ClassID like '|006010%' or ClassID like '|008002%' or ClassID like '|004009%' or ClassID like '|004006%') Order By OnTop Desc , SortDate Desc
441rg4g8gv9h1	UPDATE OA_Archive SET ArchiveId = :param0, ArchiveType = :param1, Urgency = :param2, BelongYear = :param3, ArchiveNo = :param4, StepLimit = :param5, Creator = :param6, CreateDate = :param7, PigeonholeDate = :param8, Title = :param9, ArchiveContent = :param10, Remark = :param11, Status = :param12, RecordNo = :param13, ArchiveLevel = :param14, OriginalArchiveID = :param15, WorkNo = :param16, SecretLevel = :param17, IsSecret = :param18, ReceiveDate = :param19, DocNo = :param20, SendUnit = :param21, DocType = :param22, OwnDept = :param23 WHERE ArchiveId = :param0
45bv8pz1znkhr	UPDATE WRI$_ADV_RECOMMENDATIONS SET FILTERED = 'Y' WHERE TASK_ID = :B1 AND ID IN (SELECT REC_ID FROM (SELECT A.REC_ID AS REC_ID, COUNT(*) AS TOTAL_CNT, SUM(CASE WHEN A.FILTERED = 'Y' THEN 1 ELSE 0 END) AS FILT_CNT FROM DBA_ADVISOR_ACTIONS A WHERE A.TASK_ID = :B1 GROUP BY A.REC_ID) WHERE TOTAL_CNT = FILT_CNT)
53wcm1wmzss2w	SELECT count(*) FROM OA_Message WHERE Status = :param0 AND SendTime >= :param1 AND isDelete = :param2
5g194gj8yjwv8	UPDATE TERMITE_WorkTask SET WorkID = :param0, TaskID = :param1, Name = :param2, Class = :param3, Operators = :param4, TimeLimite = :param5, OpLevel = :param6, Action = :param7, ActionPara = :param8, EventHandler = :param9, NodeType = :param10, NextTasks = :param11, NextTaskSelector = :param12, PreTasks = :param13, PreTaskSelector = :param14, Memo = :param15, StartTime = :param16, EndTime = :param17, Runner = :param18, MainParaIn = :param19, MainParaOut = :param20, TaskStatus = :param21, RunCount = :param22, LocationX = :param23, LocationY = :param24 WHERE TaskID = :param1
5ms1dhxbadq64	update wrm$_snapshot set status = 0, flush_elapsed = greatest((cast(SYSDATE as TIMESTAMP) - end_interval_time), interval '00.10' second) where snap_id = :snap_id and dbid = :dbid and instance_number = :instance_number
5s34t44u10q4g	SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1
5zwg8arwd85g9	UPDATE OA_Attachment SET AttachmentId = :param0, CreateTime = :param1, Creator = :param2, FileName = :param3, FileSize = :param4, RefID = :param5, RefType = :param6, FileId = :param7 WHERE AttachmentId = :param0
668cgwth6n3qn	SELECT * FROM Pub_ArticleItem WHERE (Guid = :param0 )
6agt7ga1f4x55	UPDATE OA_Message SET MessageId = :param0, Status = :param1, Title = :param2, MessageContent = :param3, Sender = :param4, SendTime = :param5, Receiver = :param6, MessageSourceId = :param7, SaveInOutBox = :param8, ReadTime = :param9, isDelete = :param10, DeleteTime = :param11, ImmediatelyRemindIsDealt = :param12, ImmediatelyRemindOption = :param13 WHERE MessageId = :param0
6d4vw6zhhhk18	UPDATE OA_NTaskInstance SET Name = :param0, GroupName = :param1, Type = :param2, Runner = :param3, ID = :param4, WorkID = :param5, State = :param6, Submitor = :param7, Parameters = :param8, Step = :param9, PreTaskIndexs = :param10, CreateTime = :param11, FinishTime = :param12 WHERE ID = :param4
6fjpch71x53ba	SELECT * FROM FundsRecord_DefrayArea WHERE ProDeclareGuid like :param0 Order By Code
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
73jbku2jyvfvc	SELECT count(*) FROM OA_RiskEduReceiver WHERE ReceiverID like :param0 AND Status = :param1
7bcw8frwf8rhk	SELECT Count(*) FROM Pub_QueryAll WHERE (IsShow = :param0 ) AND IsDelete = :param1 AND ((ShortTitle like '%·¿µØ²úÖнé%' OR MainTitle like '%·¿µØ²úÖнé%' OR KeyWords like '%·¿µØ²úÖнé%' OR Content like '%·¿µØ²úÖнé%'))
80uq19wq2q1p4	select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid, time_manager_info, sender_name, sender_address, sender_protocol from "SYSMAN"."MGMT_TASK_QTABLE" where time_manager_info <= :1 and state <> :2 for update skip locked
85v30trjrf5r4	UPDATE FundsRecord_WorkInstance SET EngineId = :param0 WHERE Status = :param1
8f02b6hjfgpxg	UPDATE TERMITE_WorkInstance SET EngineId = :param0 WHERE Status = :param1
8n9uqxrc5tasj	SELECT Guid , ShortTitle , MainTitle , DeputyTitle , Source , Writer , KeyWords , PubName , ClassID , PicUrl , IsPicNews , IsHasPic , IsShowCritique , PubDate , SortDate , ReadCount FROM Pub_ArticleItem WHERE (IsShow = :param0 ) AND (ClassID like :param1 ) AND IsDelete = :param2 Order By OnTop Desc , SortDate Desc
8nsb8bu5qx3ku	DELETE FROM OA_NNextTask WHERE (TaskID = :param0 )
8s4f46j882h3x	select t.schema, t.name, t.flags, q.name, t.timezone, a.owner_instance owner from system.aq$_queue_tables t, system.aq$_queues q, sys.aq$_queue_table_affinities a where t.objno = :1 and q.table_objno = t.objno and a.table_objno = t.objno and q.usage = 0 and NOT ( t.name in ('DEF$_AQCALL' , 'DEF$_AQERROR') and t.schema = 'SYSTEM')
96cp8wgp8pb5a	SELECT * FROM FundsRecord_WorkInstance WHERE EngineId = :param0 AND Status = :param1
984088hpg3318	SELECT WorkNo, Title, Urgency, CreateTime, ArchiveId, Submitor, Runner, Type, FlowType, FlowID, ID, WorkID, State, Status, ArchiveType, TransactLimit, FinishTime, ArchiveLevel, Name, ArchiveContent, Reason, Project, PresaleArea, ReceiveDate FROM OA_QUERYTASKVIEWEX WHERE ArchiveType = :param0 AND Runner like :param1 AND State = :param2 Order By CreateTime desc
9c8ywtfaktb0y	SELECT count(*) FROM Fxd_TradeingObjects INNER JOIN Fxd_AllTransDoc ON Fxd_TradeingObjects.TransDocGUID = Fxd_AllTransDoc.Guid WHERE ((Fxd_AllTransDoc.State = 0) OR (Fxd_AllTransDoc.State = 1)) AND (Fxd_AllTransDoc.IsTemp = 0) AND Fxd_TradeingObjects.ObjGUID like :param0 AND (Fxd_TradeingObjects.TransType in ('0004', '0026', '0011', '0025', '0019'))
9dhn1b8d88dpf	select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID
9m0zq8zxsbd1w	SELECT count(*) FROM Fxd_AllTransDoc WHERE TransDocNo like :param0 AND IsTemp = :param1 AND (CantonCode in ('04', '05', '06', '07', '08', '09', '12', '13', '14', '15', '21', '22', '23', '24', '29', '32', '34', '42', '81', '82', '83', '84'))
aqtdc3shqw77u	SELECT count(*) FROM Fxd_TradeingObjects INNER JOIN Fxd_AllTransDoc ON Fxd_TradeingObjects.TransDocGUID = Fxd_AllTransDoc.Guid WHERE ((Fxd_AllTransDoc.State = 0) OR (Fxd_AllTransDoc.State = 1)) AND (Fxd_AllTransDoc.IsTemp = 0) AND Fxd_TradeingObjects.ObjGUID like :param0 AND (Fxd_TradeingObjects.TransType in ('0020', '0019', '0004', '0018', '0026', '0031'))
b2gnxm5z6r51n	lock table sys.col_usage$ in exclusive mode nowait
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
c8gnrhxma4tas	SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1
c8xa47ky6yuwk	UPDATE OA_ArchiveTaskParam SET ParamId = :param0, Attitude = :param1, Sender = :param2, ReceivePersonId = :param3, FlowType = :param4, FlowID = :param5, TransactLimit = :param6, ImmediatelyRemindOption = :param7, ImmediatelyRemindIsDealt = :param8, TimelyRemindOption = :param9, TimelyRemindIsDealt = :param10, StartTime = :param11, EndTime = :param12 WHERE ParamId = :param0
cmtvxkk6z9n45	SELECT * FROM OA_RiskEduReceiver WHERE RiskEduID like :param0 AND ReceiverID like :param1
cnm5vh1ykxhzz	select count(1) from dual where exists (select 1 from oa_archiveattitude where refid = :param0 and type = 2 and State = 1 and archivecontent is not null and archivecontent != 'ÒÑÔÄ')
cq7dm0cgpfqrh	select count(1) from dual where exists(select 1 from oa_attachment where refid = :param0 )
csxdpdk14w2s3	SELECT * FROM OA_Attachment WHERE (AttachmentId = :param0 )
cwm3x5dfc5hzr	SELECT * FROM Verify_Login WHERE (LoginName = :param0 )
d7mwk6uzzyu2s	SELECT * FROM fxd_attach.FundsRecord_Accessories WHERE DeclareGuid like :param0 Order By Type
d9j3w0821xraa	SELECT * FROM TERMITE_WorkInstance WHERE EngineId = :param0 AND Status = :param1
dagyc8fq0b4sg	SELECT Count(*) FROM Pub_QueryAll WHERE (IsShow = :param0 ) AND IsDelete = :param1 AND ((ShortTitle like '%·¿ÎÝËùÓÐȨ֤²éѯ%' OR MainTitle like '%·¿ÎÝËùÓÐȨ֤²éѯ%' OR KeyWords like '%·¿ÎÝËùÓÐȨ֤²éѯ%' OR Content like '%·¿ÎÝËùÓÐȨ֤²éѯ%'))
df74yx4yff632	SELECT * FROM OA_Message WHERE Status = :param0 AND MessageSourceId like :param1
dkk609vcjh094	SELECT Count(*) FROM Pub_ArticleItem I left join Pub_ArticleItemOther D on D.ArticleID=I.Guid WHERE (I.IsShow like :param0 ) AND IsDelete = :param1 AND D.IsAffairs = :param2 AND (ClassID like '|000001002%' or ClassID like '|004001%' or ClassID like '|005001%' or ClassID like '|005004001%' or ClassID like '|006001%' or ClassID like '|007001%' or ClassID like '|008001%' or ClassID like '|009001%')
f83u41ysg4m0t	UPDATE PUB_WorkInstance SET EngineId = :param0 WHERE Status = :param1
fdhx78anrrdhq	SELECT count(*) FROM OA_Message WHERE SendTime >= :param0 AND Receiver like :param1 AND isDelete = :param2 AND ( Status=3 or Status=4)
ffm1rpqjrj55q	select min(time_manager_info) from "SYSMAN"."MGMT_TASK_QTABLE"
fjjahpfag4r05	SELECT * FROM Verify_RoleLinkRight WHERE RoleCode like :param0
fkk2kpjf7sy0f	SELECT * FROM Fxd_AllTransDoc WHERE Guid like :param0 Order By PubDate desc
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
fupb5j5bugy2z	SELECT * FROM FXD_Account WHERE IdenitfyCode like :param0 Order By AccountNumber
fzawq76xv779v	SELECT * FROM OA_Message WHERE (MessageId = :param0 )
g4aqkrcbyfjvv	UPDATE Pub_Sequences SET Sequence_Name = :param0, Sequence_NextId = :param1 WHERE Sequence_Name = :param0
gdn3ysuyssf82	SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gm9t6ycmb1yu6	delete from smon_scn_time where scn = (select min(scn) from smon_scn_time)
gqs0gt0nyunv3	SELECT count(*) FROM Fxd_AllTransDoc WHERE (State in ('0', '1')) AND IsTemp = :param0 AND Filler like :param1
grhtj3x8442zj	INSERT /*+ LEADING(@SEL$5DA710D3 K@SEL$1 R@SEL$2) INDEX(@SEL$5DA710D3 R@SEL$2 (WRI$_SQLTEXT_REFCOUNT.DBID WRI$_SQLTEXT_REFCOUNT.SQL_ID)) */ INTO wri$_sqltext_refcount (dbid, sql_id, ref_count) SELECT :dbid, sqlid_kewrsie, 1 FROM x$kewrsqlidtab k WHERE NOT EXISTS (SELECT 1 FROM wri$_sqltext_refcount r WHERE r.dbid = :dbid AND r.sql_id = k.sqlid_kewrsie)
gtj082yry5dxs	SELECT * FROM HR_Department WHERE SFSC = :param0 AND ParentID like :param1 AND ListHide = :param2 Order By PXH
gtm18mfr7gy29	SELECT Guid, ShortTitle, MainTitle, KeyWords, PubDate, TypeID, IsShow FROM Pub_QueryAll WHERE (IsShow = :param0 ) AND IsDelete = :param1 AND ((ShortTitle like '%·¿ÎÝËùÓÐȨ֤²éѯ%' OR MainTitle like '%·¿ÎÝËùÓÐȨ֤²éѯ%' OR KeyWords like '%·¿ÎÝËùÓÐȨ֤²éѯ%' OR Content like '%·¿ÎÝËùÓÐȨ֤²éѯ%')) Order By PubDate desc
gunsnf4wgrhc2	SELECT * FROM Fxd_AllTransDoc WHERE TransDocNo like :param0 AND IsTemp = :param1 AND (CantonCode in ('04', '05', '06', '07', '08', '09', '12', '13', '14', '15', '21', '22', '23', '24', '29', '32', '34', '42', '81', '82', '83', '84')) Order By PubDate desc
gw93sakgffayg	select * from (select a.EndTime, b.id, b.CreateTime, b.State, c.ArchiveId, c.Title, c.archivecontent, c.ArchiveType, c.archivelevel, c.Reason, c.FinishTime from oa_archivetaskparam a, oa_ntaskinstance b, oa_archive c where a.flowid = b.id and b.parameters = c.archiveid and b.state = 1 And b.Runner = :param0 order by b.createtime desc) WHERE rownum <= :param1

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