WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
YCOAPRD	3315331458	YCOAPRD	1	10-Jan-13 12:01	11.2.0.1.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
OA-ORADB01	Linux x86 64-bit	2			5.82

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	16244	10-Jan-13 13:00:53	69	5.6
End Snap:	16339	14-Jan-13 10:13:37	260	7.5
Elapsed:		5,592.74 (mins)
DB Time:		4,464.01 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	1,312M	1,280M	Std Block Size:	8K
Shared Pool Size:	272M	304M	Log Buffer:	18,960K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.8	1.6	0.01	0.01
DB CPU(s):	0.1	0.2	0.00	0.00
Redo size:	8,301.6	16,881.9
Logical reads:	9,728.8	19,784.3
Block changes:	27.2	55.4
Physical reads:	1,350.1	2,745.6
Physical writes:	2.7	5.6
User calls:	76.0	154.6
Parses:	37.5	76.3
Hard parses:	2.2	4.6
W/A MB processed:	0.4	0.8
Logons:	0.1	0.2
Executes:	66.4	134.9
Rollbacks:	0.0	0.0
Transactions:	0.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	99.34	In-memory Sort %:	100.00
Library Hit %:	91.29	Soft Parse %:	94.03
Execute to Parse %:	43.46	Latch Hit %:	99.51
Parse CPU to Parse Elapsd %:	79.91	% Non-Parse CPU:	89.18

Shared Pool Statistics

	Begin	End
Memory Usage %:	77.84	75.51
% SQL with executions>1:	86.32	80.25
% Memory for SQL w/exec>1:	92.14	86.09

Top 5 Timed Foreground Events

Host CPU (CPUs: 2 Cores: Sockets: )

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.42	1.02	4.1	0.9	7.9	94.7

Instance CPU

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
4.4	84.0	0.0

Memory Statistics

	Begin	End
Host Mem (MB):	5,963.7	5,963.7
SGA use (MB):	1,664.0	1,664.0
PGA use (MB):	226.5	684.9
% Host Mem used for SGA+PGA:	31.70	39.39

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

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): 267840.9s
• Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
• Ordered by % or DB time desc, Statistic name

Back to Wait Events Statistics
Back to Top

Operating System Statistics

• *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
• ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 100.6% of Total DB time 267,840.90 (s)
• Total FG Wait Time: 240,893.11 (s) DB CPU time: 28,597.75 (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
• 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 45.5% of Total DB Time (s): 267,841
• Captured PL/SQL account for 0.6% of Total DB Time (s): 267,841

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 40.6% of Total CPU Time (s): 28,598
• Captured PL/SQL account for 3.4% of Total CPU Time (s): 28,598

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 46.8% of Total User I/O Wait Time (s): 234,005
• Captured PL/SQL account for 0.2% of Total User I/O Wait Time (s): 234,005

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: 3,264,639,069
• Captured SQL account for 70.6% 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: 453,060,160
• Captured SQL account for 10.2% 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: 20,646,132
• Captured SQL account for 20.0% of Total
• Total UnOptimized Read Requests: 20,646,132
• Captured SQL account for 20.0% 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: 22,263,365
• Captured SQL account for 70.1% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 12,587,188
• Captured SQL account for 65.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

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

Complete List of SQL Text

SQL Id	SQL Text
06bjuj49kynjf	select count(*) as siblings from (select VC_UUID from WF_REMIND Where 1=1 and VC_USERID=:1 and (VC_TAG!=1 or VC_TAG is null) UNION select VC_UUID from OUT_REMIND Where 1=1 and VC_USERID=:2 and (VC_TAG!=1 or VC_TAG is null) ) temptable
07ast8jw29j9y	Select VC_UNID, VC_PROCESSID, VC_SEQUENCE, VC_NAME, VC_LEVEL, VC_TYPE, VC_ROUTEMODE, VC_ROUTETYPE, NU_LIMIT, vc_description from activity Where VC_UNID=:1
0rffwu3fg3y9d	select * from (select temptable.*, rownum rnum from ( select * from ( select * from (SELECT hts.* , tan.VC_UNID, tan.VC_WFID, tan.VC_PARENTID, tan.VC_PROCESSID, tan.VC_WFTSTATUS, tan.DT_CREATE, tan.DT_END as TEND , tan.VC_CREATER, tan.VC_CREATERNAME, tan.VC_DEPARTMENTID, tan.VC_DEPARTMENTNAME , tan.VC_NODEID, tan.VC_NODENAME, tan.VC_WFTSUBJECT, tan.NU_LIMIT as limits, tan.VC_ISOVERDUE as isOverdue, tan.VC_URL, tan.CL_ATTRIBUTE as attribues , tan.VC_TAG as tags , tan.VC_FLOWID, tan.VC_FLOWNAME, tan.VC_FLOWTYPE FROM ( select * from (select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from ( select tab.* from (select wh.* from wf_history wh where wh.vc_wftid in( (select t.vc_unid from wf_transaction t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.Vc_Creater=:1 ) )) tab order by tab.dt_end desc ) ht ) where r=1 ) hts, (select * from wf_transaction t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.Vc_Creater=:2 ) tan WHERE 1=1 and hts.vc_wftid=tan.vc_unid )startTrans union all select * from (select h.* , t.VC_UNID, t.VC_WFID, t.VC_PARENTID, t.VC_PROCESSID, t.VC_WFTSTATUS, t.DT_CREATE, t.DT_END as TEND , t.VC_CREATER, t.VC_CREATERNAME, t.VC_DEPARTMENTID, t.VC_DEPARTMENTNAME , t.VC_NODEID, t.VC_NODENAME, t.VC_WFTSUBJECT, t.NU_LIMIT as limits, t.VC_ISOVERDUE as isOverdue, t.VC_URL, t.CL_ATTRIBUTE as attribues , t.VC_TAG as tags , t.VC_FLOWID, t.VC_FLOWNAME, t.VC_FLOWTYPE from ( select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from wf_history ht where ht.vc_wftid is null) h , wf_transaction t where 1=1 and (t.VC_TAG is null or t.VC_TAG!=1 ) and t.vc_creater=:3 and t.vc_wftstatus < 1 and h.vc_wftid(+) = t.vc_unid) draftTrans) Trans WHERE 1=1 order by Trans.DT_create desc) temptable )tt where rnum between 1 and 101
16vuqjzn27fd4	Insert into WF_PENDING( VC_WFTID, VC_WFAID, VC_WFANAME, VC_USERID, VC_USERNAME, VC_USERDEPTID, VC_USERDEPTNAME, VC_USERNODEID, VC_USERNODENAME, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, DT_WFPSTART, NU_LIMIT, VC_WFTSUBJECT, VC_URL, CL_ATTRIBUTE, VC_TAG, VC_FLOWID, VC_FLOWNAME, VC_FLOWTYPE ) Values(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 )
1apx6u3vq10as	Select CL_ATTRIBUTE from WF_TRANSACTION Where VC_UNID= :1
1b8kbhcxfmh5w	Select vc_unid, vc_processid, vc_sequence, vc_name, vc_from, vc_to, vc_condition, vc_description from transition Where vc_from=:1 and vc_to=:2
1sgqm7hvgrks5	select count(*) as con from ( select t.vc_wftsubject from WF_TRANSACTION t where 1=1 and (VC_TAG is null or VC_TAG!=1 ) and t.vc_unid in (select h.vc_wftid from wf_history h where h.vc_userid=:1) order by t.dt_create desc )temptable
1wqv9k20q959w	SELECT count(*) FROM wf_transaction t WHERE t.vc_unid in (SELECT h.vc_wftid FROM wf_history h WHERE h.vc_userid=:1 ) AND (t.VC_TAG IS NULL OR t.VC_TAG!=1)
24h18hs8ukud7	Select CL_ATTRIBUTE from PROCESS Where vc_unid= :1
2b064ybzkwf1y	BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
2dndq6gsk8v8u	select * from (select temptable.*, rownum rnum from ( select * from ( select * from (SELECT hts.* , tan.VC_UNID, tan.VC_WFID, tan.VC_PARENTID, tan.VC_PROCESSID, tan.VC_WFTSTATUS, tan.DT_CREATE, tan.DT_END as TEND , tan.VC_CREATER, tan.VC_CREATERNAME, tan.VC_DEPARTMENTID, tan.VC_DEPARTMENTNAME , tan.VC_NODEID, tan.VC_NODENAME, tan.VC_WFTSUBJECT, tan.NU_LIMIT as limits, tan.VC_ISOVERDUE as isOverdue, tan.VC_URL, tan.CL_ATTRIBUTE as attribues , tan.VC_TAG as tags , tan.VC_FLOWID, tan.VC_FLOWNAME, tan.VC_FLOWTYPE FROM ( select * from (select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from ( select tab.* from (select wh.* from wf_history wh where wh.vc_wftid in( (select t.vc_unid from wf_transaction t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.Vc_Creater=:1) )) tab order by tab.dt_end desc ) ht ) where r=1 ) hts, (select * from wf_transaction t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.Vc_Creater=:2) tan WHERE 1=1 and hts.vc_wftid=tan.vc_unid )startTrans union all select * from (select h.* , t.VC_UNID, t.VC_WFID, t.VC_PARENTID, t.VC_PROCESSID, t.VC_WFTSTATUS, t.DT_CREATE, t.DT_END as TEND , t.VC_CREATER, t.VC_CREATERNAME, t.VC_DEPARTMENTID, t.VC_DEPARTMENTNAME , t.VC_NODEID, t.VC_NODENAME, t.VC_WFTSUBJECT, t.NU_LIMIT as limits, t.VC_ISOVERDUE as isOverdue, t.VC_URL, t.CL_ATTRIBUTE as attribues , t.VC_TAG as tags , t.VC_FLOWID, t.VC_FLOWNAME, t.VC_FLOWTYPE from ( select ht.* , row_number() over(partition by ht.vc_wftid o rder by 1) r from wf_history ht where ht.vc_wftid is null) h , wf_transaction t where 1=1 and (t.VC_TAG is null or t.VC_TAG!=1 ) and t.vc_creater=:3 and t.vc_wftstatus < 1 and h.vc_wftid(+) = t.vc_unid) draftTrans) Trans WHERE 1=1 order by Trans.DT_create desc) temptable )tt where rnum between 1 and 101
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2v2gff09swnh8	Select VC_UNID, VC_WFID, VC_PARENTID, VC_PROCESSID, VC_WFTSTATUS, DT_CREATE, DT_END, VC_CREATER, VC_NODEID, VC_WFTSUBJECT, VC_DEPARTMENTID, VC_DEPARTMENTNAME, VC_NODENAME, VC_URL, VC_FLOWID, VC_FLOWNAME, VC_FLOWTYPE, NU_LIMIT, VC_ISOVERDUE, VC_CREATERNAME from WF_TRANSACTION Where VC_UNID=:1
301nr4s0sggya	Select VC_UNID, VC_PROCESSID, VC_SEQUENCE, VC_NAME, VC_LEVEL, VC_TYPE, VC_ROUTEMODE, VC_ROUTETYPE, NU_LIMIT, vc_description from activity Where VC_UNID=:1
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3nkd3g3ju5ph1	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
3w4qs0tbpmxr6	select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1
3y36pxj67q17j	Select VC_UNID, VC_PROCESSID, VC_SEQUENCE, VC_NAME, VC_LEVEL, VC_TYPE, VC_ROUTEMODE, VC_ROUTETYPE, NU_LIMIT, vc_description from activity Where VC_PROCESSID=:1 and VC_TYPE='0'
49hyv0arryxja	Select * from WF_TRANSACTION Where vc_unid=:1
4c53tbt52b3ar	Insert into WF_HISTORY(VC_WFTID, VC_WFAID, VC_WFANAME, VC_WFAIDPREV, VC_WFANAMEPREV, VC_USERID, VC_USERNAME, VC_USERNODEID, VC_USERNODENAME, VC_USERDEPTID, VC_USERDEPTNAME, DT_WFASTART, DT_END, VC_ISOVERDUE, NU_LIMIT, VC_SUBMITTYPE, VC_LEVEL, VC_TYPE, CL_ATTRIBUTE, VC_SUBMITACTION, VC_NOTION, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, VC_SIMPLENOTION) values(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 )
4r414jzfaz1qf	Update WF_ACTIVITY Set VC_WFANAME=:1 , VC_STATUS=:2 , VC_WFAIDPREV=:3 , VC_WFANAMEPREV=:4 , VC_LEVEL=:5 , VC_TYPE=:6 , NU_LIMIT=:7 , VC_USERIDS=:8 , VC_USERNAMES=:9 , VC_USERDEPTIDS=:10 , VC_USERDEPTNAMES=:11 , VC_USERNODEIDS=:12 , VC_USERNODENAMES=:13 , VC_ORIUSERIDS=:14 , VC_ORIUSERNAMES=:15 , VC_ORIUSERDEPTIDS=:16 , VC_ORIUSERDEPTNAMES=:17 , VC_ORIUSERNODEIDS=:18 , VC_ORIUSERNODENAMES=:19 , VC_WFAATTNIDPREV=:20 , CL_ATTRIBUTE=:21 , DT_WFASTART=:22 , VC_ROUTEMODE=:23 , VC_ROUTETYPE=:24 Where VC_WFTID=:25 and VC_WFAID=:26
4ttmr1z2hcrjr	select * from (select temptable.*, rownum rnum from( select t.vc_wftsubject, t.dt_create, t.vc_wftstatus, t.vc_url, t.vc_unid, t.VC_FLOWTYPE from WF_TRANSACTION t where 1=1 and (t.VC_TAG is null or t.VC_TAG!=1 ) and t.vc_unid in (select h.vc_wftid from wf_history h where h.vc_userid=:1 ) order by t.dt_create desc )temptable )tt where rnum between 1 and 1
51xmwq6yc59t7	Select CL_ATTRIBUTE from ACTIVITY Where vc_unid= :1
53pr7m50z7cjz	SELECT * FROM (SELECT t.VC_WFTSTATUS, t.DT_CREATE, t.VC_CREATERNAME, t.VC_WFTSUBJECT, t.VC_URL, t.VC_FLOWTYPE, t.VC_UNID, nvl(wfa.dt_wfastart, t.dt_end) dt_end, wfa.vc_wfaname, row_number() over (Order by nvl(wfa.dt_wfastart, t.dt_end) desc) rnum FROM wf_transaction t LEFT JOIN wf_activity wfa ON t.vc_unid=wfa.vc_wftid WHERE t.vc_unid in (SELECT h.vc_wftid FROM wf_history h WHERE h.vc_userid=:1) AND (t.VC_TAG IS NULL OR t.VC_TAG!=1) AND upper(t.vc_wftsubject) like upper(:2) ORDER BY nvl(wfa.dt_wfastart, t.dt_end) desc) h WHERE rnum BETWEEN 1 AND 101
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
59v4zh1ac3v2a	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; BEGIN DECLARE ename VARCHAR2(30); BEGIN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
5wrmx1ughthw6	select VC_WFTID, VC_WFAID, VC_WFANAME, VC_STATUS, VC_WFAIDPREV, VC_WFANAMEPREV, VC_LEVEL, VC_TYPE, NU_LIMIT, VC_USERIDS, VC_USERNAMES, VC_USERDEPTIDS, VC_USERDEPTNAMES, VC_USERNODEIDS, VC_USERNODENAMES, VC_ORIUSERIDS, VC_ORIUSERDEPTIDS, VC_ORIUSERDEPTNAMES, VC_ORIUSERNODEIDS, VC_ORIUSERNODENAMES, VC_ORIUSERNAMES, DT_WFASTART, VC_WFAATTNIDPREV, VC_ROUTEMODE, VC_ROUTETYPE from WF_ACTIVITY Where 1=1 and (vc_tag!=1 or vc_tag is null) and VC_WFTID=:1
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6dy9dtuz106mt	Select VC_WFTID, VC_WFAID, VC_WFANAME, VC_WFAIDPREV, VC_WFANAMEPREV, VC_USERID, VC_USERNAME, VC_USERNODEID, VC_USERDEPTID, VC_USERDEPTNAME, DT_WFASTART, DT_END, VC_ISOVERDUE, NU_LIMIT, VC_SUBMITTYPE, VC_LEVEL, VC_TYPE, VC_NOTION, VC_USERNODENAME, VC_SUBMITACTION, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, VC_SIMPLENOTION from wf_history where vc_wftid=:1 and vc_level=:2 and vc_submitaction=:3 and DT_END in( select ss from ( select VC_WFTID, VC_WFAID , max(DT_END) ss from ( Select VC_WFTID, VC_WFAID, DT_END , rownum rnum from wf_history where vc_wftid=:4 and vc_level=:5 and vc_submitaction=:6 order by dt_end DESC)pp group by VC_WFTID, VC_WFAID )tt ) order by dt_end DESC
6gha3km2x1vvk	select * from (select temptable.*, rownum rnum from ( select * from (select * from ( select * from (SELECT hts.* , pen.VC_WFTID as penwfid , pen.VC_WFAID as penWfaid, pen.VC_WFANAME as penWfaName, pen.VC_USERID as penUserId, pen.VC_USERNAME as penUsername, pen.VC_USERDEPTID as penUserDepid, pen.VC_USERDEPTNAME as penuserDepName, pen.VC_USERNODEID as penUserNoneId, pen.VC_USERNODENAME as penUserNonename, pen.VC_ORIUSERID as penOriUserId, pen.VC_ORIUSERNAME as penOriUserName, pen.VC_ORIUSERDEPTID as penOriUserDepId, pen.VC_ORIUSERDEPTNAME as penOriDepName, pen.VC_ORIUSERNODEID as penOriUserNodeid, pen.VC_ORIUSERNODENAME as penOriUserNodeName, pen.DT_WFPSTART as penWfpstart, pen.NU_LIMIT as penNulimit, (select vc_wftsubject from wf_transaction where vc_unid=pen.VC_WFTID) VC_WFTSUBJECT , pen.VC_URL, pen.CL_ATTRIBUTE as penAttribute, pen.VC_TAG as penTag, pen.VC_FLOWID, pen.VC_FLOWNAME, pen.VC_FLOWTYPE FROM (select * from (select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from ( select tab.* from (select wh.* from wf_history wh where wh.vc_wftid in(( select t.vc_unid from wf_transaction t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.vc_unid in ( select vc_wftid from wf_pending p where p.VC_userID = :1 and (p.VC_TAG is null or p.VC_TAG!=1 ) ))) ) tab order by tab.dt_end desc ) ht ) where r=1 ) hts, (select * from wf_pending t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.VC_userID=:2) pen WHERE 1=1 and hts.vc_wftid=pen.vc_wftid order b y pen.DT_WFPSTART )startTrans union all select * from (select h.* , pe.VC_WFTID as penwfid , pe.VC_WFAID as penWfaid, pe.VC_WFANAME as penWfaName, pe.VC_USERID as penUserId, pe.VC_USERNAME as penUsername, pe.VC_USERDEPTID as penUserDepid, pe.VC_USERDEPTNAME as penuserDepName, pe.VC_USERNODEID as penUserNoneId, pe.VC_USERNODENAME as penUserNonename, pe.VC_ORIUSERID as penOriUserId, pe.VC_ORIUSERNAME as penOriUserName, pe.VC_ORIUSERDEPTID as penOriUserDepId, pe.VC_ORIUSERDEPTNAME as penOriDepName, pe.VC_ORIUSERNODEID as penOriUserNodeid, pe.VC_ORIUSERNODENAME as penOriUserNodeName, pe.DT_WFPSTART as penWfpstart, pe.NU_LIMIT as penNulimit, (select vc_wftsubject from wf_transaction where vc_unid=pe.VC_WFTID) VC_WFTSUBJECT , pe.VC_URL, pe.CL_ATTRIBUTE as penAttribute, pe.VC_TAG as penTag, pe.VC_FLOWID, pe.VC_FLOWNAME, pe.VC_FLOWTYPE from ( select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from wf_history ht where ht.vc_wftid is null) h , wf_pending pe where 1=1 and (pe.VC_TAG is null or pe.VC_TAG!=1 ) and pe.vc_wftid in(select t.vc_unid from wf_transaction t where t.vc_unid in ( select p.vc_wftid from wf_pending p where p.VC_userID = :3 and (p.VC_TAG is null or p.VC_TAG!=1 ) ) and t.vc_wftstatus < 1 ) and h.vc_wftid(+) = pe.vc_wftid order by pe.DT_WFPSTART ) draftTrans) pending where 1=1 union all select * from ( select * from (SELECT hts.* , pen.VC_WFTID as penwfid , pen.VC_WFAID as penWfaid, pen.VC_WFANAME as penWfaName, pen .VC_USERID as penUserId, pen.VC_USERNAME as penUsername, pen.VC_USERDEPTID as penUserDepid, pen.VC_USERDEPTNAME as penuserDepName, pen.VC_USERNODEID as penUserNoneId, pen.VC_USERNODENAME as penUserNonename, pen.VC_ORIUSERID as penOriUserId, pen.VC_ORIUSERNAME as penOriUserName, pen.VC_ORIUSERDEPTID as penOriUserDepId, pen.VC_ORIUSERDEPTNAME as penOriDepName, pen.VC_ORIUSERNODEID as penOriUserNodeid, pen.VC_ORIUSERNODENAME as penOriUserNodeName, pen.DT_WFPSTART as penWfpstart, pen.NU_LIMIT as penNulimit, (select vc_wftsubject from wf_transaction where vc_unid=pen.VC_WFTID) VC_WFTSUBJECT , pen.VC_URL, pen.CL_ATTRIBUTE as penAttribute, pen.VC_TAG as penTag, pen.VC_FLOWID, pen.VC_FLOWNAME, pen.VC_FLOWTYPE FROM ( select * from (select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from ( select tab.* from ( select wh.* from wf_history wh where wh.vc_wftid in(( select t.vc_unid from wf_transaction t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.vc_unid in ( select vc_wftid from wf_pending p where p.VC_userID = :4 and (p.VC_TAG is null or p.VC_TAG!=1 ) ) ) ) ) tab order by tab.dt_end desc ) ht ) where r=1 ) hts, (select * from out_pending t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.VC_userID=:5 ) pen WHERE 1=1 and hts.vc_wftid=pen.vc_wftid order by pen.DT_WFPSTART)startTrans union all select * from (select h.* , pe.VC_WFTID as penwfid , pe.VC_WFAID as penWfaid, pe.VC_WFANAME as penWfaName, pe.VC_USERID as penUserId, pe.VC _USERNAME as penUsername, pe.VC_USERDEPTID as penUserDepid, pe.VC_USERDEPTNAME as penuserDepName, pe.VC_USERNODEID as penUserNoneId, pe.VC_USERNODENAME as penUserNonename, pe.VC_ORIUSERID as penOriUserId, pe.VC_ORIUSERNAME as penOriUserName, pe.VC_ORIUSERDEPTID as penOriUserDepId, pe.VC_ORIUSERDEPTNAME as penOriDepName, pe.VC_ORIUSERNODEID as penOriUserNodeid, pe.VC_ORIUSERNODENAME as penOriUserNodeName, pe.DT_WFPSTART as penWfpstart, pe.NU_LIMIT as penNulimit, (select vc_wftsubject from wf_transaction where vc_unid=pe.VC_WFTID) VC_WFTSUBJECT , pe.VC_URL, pe.CL_ATTRIBUTE as penAttribute, pe.VC_TAG as penTag, pe.VC_FLOWID, pe.VC_FLOWNAME, pe.VC_FLOWTYPE from ( select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from wf_history ht where ht.vc_wftid is null) h , out_pending pe where 1=1 and (pe.VC_TAG is null or pe.VC_TAG!=1 ) and pe.vc_wftid in(select t.vc_unid from wf_transaction t where t.vc_unid in ( select p.vc_wftid from out_pending p where 1=1 And p.VC_userID = :6 and (p.VC_TAG is null or p.VC_TAG!=1 ) ) and t.vc_wftstatus < 1 ) and h.vc_wftid(+) = pe.vc_wftid order by pe.DT_WFPSTART desc ) draftTrans ) outpending WHERE¡¡1=1 )pendAndhend order by penWfpstart desc ) temptable )tt where rnum between 1 and 101
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;
6mcpb06rctk0x	call dbms_space.auto_space_advisor_job_proc ( )
6qz82dptj0qr7	select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc
7dxuuhzp62v7n	SELECT * FROM (SELECT t.VC_WFTSTATUS, t.DT_CREATE, t.VC_CREATERNAME, t.VC_WFTSUBJECT, t.VC_URL, t.VC_FLOWTYPE, t.VC_UNID, nvl(wfa.dt_wfastart, t.dt_end) dt_end, wfa.vc_wfaname, row_number() over (Order by nvl(wfa.dt_wfastart, t.dt_end) desc) rnum FROM wf_transaction t LEFT JOIN wf_activity wfa ON t.vc_unid=wfa.vc_wftid WHERE t.vc_unid in (SELECT h.vc_wftid FROM wf_history h WHERE h.vc_userid=:1) AND (t.VC_TAG IS NULL OR t.VC_TAG!=1) ORDER BY nvl(wfa.dt_wfastart, t.dt_end) desc) h WHERE rnum BETWEEN 1 AND 101
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
87gaftwrm2h68	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname from obj$ o where o.obj#=:1
8d4p54mtdj3mr	select * from (select temptable.*, rownum rnum from (select * from (select VC_WFTID, VC_WFAID, VC_WFANAME, VC_USERID, VC_USERNAME, VC_USERDEPTID, VC_USERDEPTNAME, VC_USERNODEID, VC_USERNODENAME, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, DT_WFPSTART, NU_LIMIT, (select vc_wftsubject from wf_transaction where vc_unid=p.vc_wftid) VC_WFTSUBJECT, VC_URL, VC_FLOWID, VC_FLOWNAME, VC_FLOWTYPE , '' as VC_APPNAME , '' as VC_APPID from WF_PENDING p Where 1=1 and (VC_TAG!=1 or VC_TAG is null) and VC_USERID=:1 UNION select VC_WFTID, VC_WFAID, VC_WFANAME, VC_USERID, VC_USERNAME, VC_USERDEPTID, VC_USERDEPTNAME, VC_USERNODEID, VC_USERNODENAME, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, DT_WFPSTART, NU_LIMIT, VC_WFTSUBJECT, VC_URL, VC_FLOWID, VC_FLOWNAME, VC_FLOWTYPE, VC_APPNAME , VC_APPID from out_pending where 1=1 and (VC_TAG!=1 or VC_TAG is null) and VC_USERID=:2 ) temptable1 order by DT_WFPSTART desc) temptable )tt where rnum between 1 and 1
8mn93gvj2txxd	Select CL_ATTRIBUTE from WF_ACTIVITY Where VC_WFTID= :1 and VC_WFAID= :2 and (vc_tag!=1 or vc_tag is null)
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtr	select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
99k43564nmgh2	select count(*) as siblings from ( select VC_UNID from WF_TRANSACTION Where 1=1 and (VC_TAG is null or VC_TAG!=1 ) and VC_CREATER=:1 ) temptable
99u9zt0w694mh	Insert into WF_ACTIVITY(VC_WFTID, VC_WFAID, VC_WFANAME, VC_STATUS, VC_WFAIDPREV, VC_WFANAMEPREV, VC_LEVEL, VC_TYPE, NU_LIMIT, VC_USERIDS, VC_USERNAMES, VC_USERDEPTIDS, VC_USERDEPTNAMES, VC_USERNODEIDS, VC_USERNODENAMES, VC_ORIUSERIDS, VC_ORIUSERDEPTIDS, VC_ORIUSERDEPTNAMES, VC_ORIUSERNODEIDS, VC_ORIUSERNODENAMES, VC_ORIUSERNAMES, DT_WFASTART, VC_WFAATTNIDPREV, CL_ATTRIBUTE, VC_ROUTEMODE, VC_ROUTETYPE) Values(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 )
9rhpg577wugyu	Select CL_ATTRIBUTE from TRANSITION Where vc_unid= :1
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
a0aa984j8m3hq	select * from (select temptable.*, rownum rnum from ( select * from (select * from ( select * from (SELECT hts.* , pen.VC_WFTID as penwfid , pen.VC_WFAID as penWfaid, pen.VC_WFANAME as penWfaName, pen.VC_USERID as penUserId, pen.VC_USERNAME as penUsername, pen.VC_USERDEPTID as penUserDepid, pen.VC_USERDEPTNAME as penuserDepName, pen.VC_USERNODEID as penUserNoneId, pen.VC_USERNODENAME as penUserNonename, pen.VC_ORIUSERID as penOriUserId, pen.VC_ORIUSERNAME as penOriUserName, pen.VC_ORIUSERDEPTID as penOriUserDepId, pen.VC_ORIUSERDEPTNAME as penOriDepName, pen.VC_ORIUSERNODEID as penOriUserNodeid, pen.VC_ORIUSERNODENAME as penOriUserNodeName, pen.DT_WFPSTART as penWfpstart, pen.NU_LIMIT as penNulimit, (select vc_wftsubject from wf_transaction where vc_unid=pen.VC_WFTID) VC_WFTSUBJECT , pen.VC_URL, pen.CL_ATTRIBUTE as penAttribute, pen.VC_TAG as penTag, pen.VC_FLOWID, pen.VC_FLOWNAME, pen.VC_FLOWTYPE FROM (select * from (select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from ( select tab.* from (select wh.* from wf_history wh where wh.vc_wftid in(( select t.vc_unid from wf_transaction t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.vc_unid in ( select vc_wftid from wf_pending p where p.VC_userID = :1 and (p.VC_TAG is null or p.VC_TAG!=1 ) ))) ) tab order by tab.dt_end desc ) ht ) where r=1 ) hts, (select * from wf_pending t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.VC_userID=:2 ) pen WHERE 1=1 and hts.vc_wftid=pen.vc_wftid order by pen.DT_WFPSTART )startTrans union all select * from (select h.* , pe.VC_WFTID as penwfid , pe.VC_WFAID as penWfaid, pe.VC_WFANAME as penWfaName, pe.VC_USERID as penUserId, pe.VC_USERNAME as penUsername, pe.VC_USERDEPTID as penUserDepid, pe.VC_USERDEPTNAME as penuserDepName, pe.VC_USERNODEID as penUserNoneId, pe.VC_USERNODENAME as penUserNonename, pe.VC_ORIUSERID as penOriUserId, pe.VC_ORIUSERNAME as penOriUserName, pe.VC_ORIUSERDEPTID as penOriUserDepId, pe.VC_ORIUSERDEPTNAME as penOriDepName, pe.VC_ORIUSERNODEID as penOriUserNodeid, pe.VC_ORIUSERNODENAME as penOriUserNodeName, pe.DT_WFPSTART as penWfpstart, pe.NU_LIMIT as penNulimit, (select vc_wftsubject from wf_transaction where vc_unid=pe.VC_WFTID) VC_WFTSUBJECT , pe.VC_URL, pe.CL_ATTRIBUTE as penAttribute, pe.VC_TAG as penTag, pe.VC_FLOWID, pe.VC_FLOWNAME, pe.VC_FLOWTYPE from ( select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from wf_history ht where ht.vc_wftid is null) h , wf_pending pe where 1=1 and (pe.VC_TAG is null or pe.VC_TAG!=1 ) and pe.vc_wftid in(select t.vc_unid from wf_transaction t where t.vc_unid in ( select p.vc_wftid from wf_pending p where p.VC_userID = :3 and (p.VC_TAG is null or p.VC_TAG!=1 ) ) and t.vc_wftstatus < 1 ) and h.vc_wftid(+) = pe.vc_wftid order by pe.DT_WFPSTART ) draftTrans) pending where 1=1 union all select * from ( select * from (SELECT hts.* , pen.VC_WFTID as penwfid , pen.VC_WFAID as penWfaid, pen.VC_WFANAME as penWfaName, pen.VC_USERID as penUserId, pen.VC_USERNAME as penUsername, pen.VC_USERDEPTID as penUserDepid, pen.VC_USERDEPTNAME as penuserDepName, pen.VC_USERNODEID as penUserNoneId, pen.VC_USERNODENAME as penUserNonename, pen.VC_ORIUSERID as penOriUserId, pen.VC_ORIUSERNAME as penOriUserName, pen.VC_ORIUSERDEPTID as penOriUserDepId, pen.VC_ORIUSERDEPTNAME as penOriDepName, pen.VC_ORIUSERNODEID as penOriUserNodeid, pen.VC_ORIUSERNODENAME as penOriUserNodeName, pen.DT_WFPSTART as penWfpstart, pen.NU_LIMIT as penNulimit, (select vc_wftsubject from wf_transaction where vc_unid=pen.VC_WFTID) VC_WFTSUBJECT , pen.VC_URL, pen.CL_ATTRIBUTE as penAttribute, pen.VC_TAG as penTag, pen.VC_FLOWID, pen.VC_FLOWNAME, pen.VC_FLOWTYPE FROM ( select * from (select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from ( select tab.* from ( select wh.* from wf_history wh where wh.vc_wftid in(( select t.vc_unid from wf_transaction t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.vc_unid in ( select vc_wftid from wf_pending p where p.VC_userID = :4 and (p.VC_TAG is null or p.VC_TAG!=1 ) ) ) ) ) tab order by tab.dt_end desc ) ht ) where r=1 ) hts, (select * from out_pending t where (t.VC_TAG is null or t.VC_TAG!=1 ) and t.VC_userID=:5 ) pen WHERE 1=1 and hts.vc_wftid=pen.vc_wftid order by pen.DT_WFPSTART)startTrans union all select * from (select h.* , pe.VC_WFTID as penwfid , pe.VC_WFAID as penWfaid, pe.VC_WFANAME as penWfaName, pe.VC_USERID as penUserId, pe.VC_USERNAME as penUsername, pe.VC_USERDEPTID as penUserDepid, pe.VC_USERDEPTNAME as penuserDepName, pe.VC_USERNODEID as penUserNoneId, pe.VC_USERNODENAME as penUserNonename, pe.VC_ORIUSERID as penOriUserId, pe.VC_ORIUSERNAME as penOriUserName, pe.VC_ORIUSERDEPTID as penOriUserDepId, pe.VC_ORIUSERDEPTNAME as penOriDepName, pe.VC_ORIUSERNODEID as penOriUserNodeid, pe.VC_ORIUSERNODENAME as penOriUserNodeName, pe.DT_WFPSTART as penWfpstart, pe.NU_LIMIT as penNulimit, (select vc_wftsubject from wf_transaction where vc_unid=pe.VC_WFTID) VC_WFTSUBJECT , pe.VC_URL, pe.CL_ATTRIBUTE as penAttribute, pe.VC_TAG as penTag, pe.VC_FLOWID, pe.VC_FLOWNAME, pe.VC_FLOWTYPE from ( select ht.* , row_number() over(partition by ht.vc_wftid order by 1) r from wf_history ht where ht.vc_wftid is null) h , out_pending pe where 1=1 and (pe.VC_TAG is null or pe.VC_TAG!=1 ) and pe.vc_wftid in(select t.vc_unid from wf_transaction t where t.vc_unid in ( select p.vc_wftid from out_pending p where 1=1 And p.VC_userID = :6 and (p.VC_TAG is null or p.VC_TAG!=1 ) ) and t.vc_wftstatus < 1 ) and h.vc_wftid(+) = pe.vc_wftid order by pe.DT_WFPSTART desc ) draftTrans ) outpending WHERE¡¡1=1 )pendAndhend order by penWfpstart desc ) temptable )tt where rnum between 1 and 101
a64y9rd03vy63	select * from (select temptable.*, rownum rnum from (select * from (select VC_WFTID, VC_WFAID, VC_WFANAME, VC_USERID, VC_USERNAME, VC_USERDEPTID, VC_USERDEPTNAME, VC_USERNODEID, VC_USERNODENAME, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, DT_WFPSTART, NU_LIMIT, (select vc_wftsubject from wf_transaction where vc_unid=p.vc_wftid) VC_WFTSUBJECT, VC_URL, VC_FLOWID, VC_FLOWNAME, VC_FLOWTYPE , '' as VC_APPNAME , '' as VC_APPID from WF_PENDING p Where 1=1 and (VC_TAG!=1 or VC_TAG is null) and VC_USERID=:1 UNION select VC_WFTID, VC_WFAID, VC_WFANAME, VC_USERID, VC_USERNAME, VC_USERDEPTID, VC_USERDEPTNAME, VC_USERNODEID, VC_USERNODENAME, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, DT_WFPSTART, NU_LIMIT, VC_WFTSUBJECT, VC_URL, VC_FLOWID, VC_FLOWNAME, VC_FLOWTYPE, VC_APPNAME , VC_APPID from out_pending where 1=1 and (VC_TAG!=1 or VC_TAG is null) and VC_USERID=:2 ) temptable1 order by DT_WFPSTART desc) temptable )tt where rnum between 1 and 5
a860tcwbk9hg9	select VC_WFTID, VC_WFAID, VC_WFANAME, VC_STATUS, VC_WFAIDPREV, VC_WFANAMEPREV, VC_LEVEL, VC_TYPE, NU_LIMIT, VC_USERIDS, VC_USERNAMES, VC_USERDEPTIDS, VC_USERDEPTNAMES, VC_USERNODEIDS, VC_USERNODENAMES, VC_ORIUSERIDS, VC_ORIUSERDEPTIDS, VC_ORIUSERDEPTNAMES, VC_ORIUSERNODEIDS, VC_ORIUSERNODENAMES, VC_ORIUSERNAMES, DT_WFASTART, VC_WFAATTNIDPREV, VC_ROUTEMODE, VC_ROUTETYPE from WF_ACTIVITY Where VC_WFTID=:1 and VC_WFAID=:2 and (vc_tag!=1 or vc_tag is null)
a8b80jvkz856w	Select VC_WFTID, VC_WFAID, VC_WFANAME, VC_WFAIDPREV, VC_WFANAMEPREV, VC_USERID, VC_USERNAME, VC_USERNODEID, VC_USERDEPTID, VC_USERDEPTNAME, DT_WFASTART, DT_END, VC_ISOVERDUE, NU_LIMIT, VC_SUBMITTYPE, VC_LEVEL, VC_TYPE, VC_NOTION, VC_USERNODENAME, VC_SUBMITACTION, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, VC_SIMPLENOTION from WF_HISTORY Where 1=1 and (vc_tag!=1 or vc_tag is null) and VC_WFTID=:1 order by dt_end
an1vw74gtf7x0	select * from (select temptable.*, rownum rnum from (select * from (select VC_WFTID, VC_WFAID, VC_WFANAME, VC_USERID, VC_USERNAME, VC_USERDEPTID, VC_USERDEPTNAME, VC_USERNODEID, VC_USERNODENAME, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, DT_WFPSTART, NU_LIMIT, (select vc_wftsubject from wf_transaction where vc_unid=p.vc_wftid) VC_WFTSUBJECT, VC_URL, VC_FLOWID, VC_FLOWNAME, VC_FLOWTYPE , '' as VC_APPNAME , '' as VC_APPID from WF_PENDING p Where 1=1 and (VC_TAG!=1 or VC_TAG is null) and VC_USERID=:1 UNION select VC_WFTID, VC_WFAID, VC_WFANAME, VC_USERID, VC_USERNAME, VC_USERDEPTID, VC_USERDEPTNAME, VC_USERNODEID, VC_USERNODENAME, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, DT_WFPSTART, NU_LIMIT, VC_WFTSUBJECT, VC_URL, VC_FLOWID, VC_FLOWNAME, VC_FLOWTYPE, VC_APPNAME , VC_APPID from out_pending where 1=1 and (VC_TAG!=1 or VC_TAG is null) and VC_USERID=:2 ) temptable1 order by DT_WFPSTART desc) temptable )tt where rnum between 1 and 5
b6usrg82hwsa3	call dbms_stats.gather_database_stats_job_proc ( )
c7zv8pvyz66jx	Select vc_unid, vc_sheetid, vc_name, vc_version, dt_create, nu_limit, cl_attribute, vc_description from process Where VC_UNID=:1
ccx48f2qq75kh	select count(*) as siblings from (select VC_WFTID, VC_WFAID from WF_PENDING Where 1=1 and VC_USERID=:1 and (VC_TAG!=1 or VC_TAG is null) UNION select VC_WFTID, VC_WFAID from out_pending Where 1=1 and (VC_TAG!=1 or VC_TAG is null) and VC_USERID=:2 ) temptable
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cqr64k68dv53t	SELECT * FROM (SELECT t.VC_WFTSTATUS, t.DT_CREATE, t.VC_CREATERNAME, t.VC_WFTSUBJECT, t.VC_URL, t.VC_FLOWTYPE, t.VC_UNID, nvl(wfa.dt_wfastart, t.dt_end) dt_end, wfa.vc_wfaname, row_number() over (Order by nvl(wfa.dt_wfastart, t.dt_end) desc) rnum FROM wf_transaction t LEFT JOIN wf_activity wfa ON t.vc_unid=wfa.vc_wftid WHERE t.vc_unid in (SELECT h.vc_wftid FROM wf_history h WHERE h.vc_userid=:1 ) AND (t.VC_TAG IS NULL OR t.VC_TAG!=1) ORDER BY nvl(wfa.dt_wfastart, t.dt_end) desc) h WHERE rnum BETWEEN 1 AND 101
cy7h4f4upfd16	Select CL_ATTRIBUTE from wf_history Where VC_WFTID= :1 and VC_WFAID= :2 and vc_userid=:3 and vc_oriuserid=:4 and dt_end=:5 and (vc_tag!=1 or vc_tag is null)
d15cdr0zt3vtp	SELECT TO_CHAR(current_timestamp AT TIME ZONE 'GMT', 'YYYY-MM-DD HH24:MI:SS TZD') AS curr_timestamp, COUNT(username) AS failed_count FROM sys.dba_audit_session WHERE returncode != 0 AND TO_CHAR(timestamp, 'YYYY-MM-DD HH24:MI:SS') >= TO_CHAR(current_timestamp - TO_DSINTERVAL('0 0:30:00'), 'YYYY-MM-DD HH24:MI:SS')
d9qnrazcttcmh	select count(*) as siblings from (select VC_WFTID, VC_WFAID from WF_PENDING Where 1=1 and VC_USERID=:1 and (VC_TAG!=1 or VC_TAG is null) UNION select VC_WFTID, VC_WFAID from out_pending Where 1=1 and (VC_TAG!=1 or VC_TAG is null) and VC_USERID=:2 ) temptable
db78fxqxwxt7r	select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dft7u5uwbmy12	Select VC_UNID, VC_PROCESSID, VC_SEQUENCE, VC_NAME, VC_LEVEL, VC_TYPE, VC_ROUTEMODE, VC_ROUTETYPE, NU_LIMIT, vc_description from activity Where VC_PROCESSID=:1 and VC_TYPE='0'
dydtuuqtq89py	Select * from WF_ACTIVITY Where VC_WFTID=:1 and VC_WFAID=:2 and (vc_tag!=1 or vc_tag is null)
fdsasqfujy8hn	Select vc_unid, vc_processid, vc_sequence, vc_name, vc_from, vc_to, vc_condition, vc_description from transition Where vc_from=:1 and vc_to=:2
fk7jumtc54gvz	select count(*) as con from ( select t.vc_wftsubject from WF_TRANSACTION t where 1=1 and (VC_TAG is null or VC_TAG!=1 ) and t.vc_unid in (select h.vc_wftid from wf_history h where h.vc_userid=:1 ) order by t.dt_create desc )temptable
fs97byujs3d6k	Update WF_TRANSACTION Set VC_WFID=:1 , VC_PARENTID=:2 , VC_PROCESSID=:3 , VC_WFTSTATUS=:4 , VC_NODEID=:5 , CL_ATTRIBUTE=:6 , VC_WFTSUBJECT=:7 , VC_DEPARTMENTID=:8 , VC_DEPARTMENTNAME=:9 , VC_NODENAME=:10 , dt_end=:11 , VC_URL=:12 , VC_FLOWID=:13 , VC_FLOWNAME=:14 , VC_FLOWTYPE=:15 , NU_LIMIT=:16 , VC_ISOVERDUE=:17 , VC_CREATERNAME=:18 Where VC_UNID=:19
g1nv018vx3rhj	Select VC_WFTID, VC_WFAID, VC_WFANAME, VC_WFAIDPREV, VC_WFANAMEPREV, VC_USERID, VC_USERNAME, VC_USERNODEID, VC_USERDEPTID, VC_USERDEPTNAME, DT_WFASTART, DT_END, VC_ISOVERDUE, NU_LIMIT, VC_SUBMITTYPE, VC_LEVEL, VC_TYPE, VC_NOTION, VC_USERNODENAME, VC_SUBMITACTION, VC_ORIUSERID, VC_ORIUSERNAME, VC_ORIUSERDEPTID, VC_ORIUSERDEPTNAME, VC_ORIUSERNODEID, VC_ORIUSERNODENAME, VC_SIMPLENOTION from WF_HISTORY Where 1=1 and (vc_tag!=1 or vc_tag is null) and VC_WFTID=:1 order by dt_end
g3g9mdyfjq5j6	select count(*) as siblings from ( select VC_UNID from WF_TRANSACTION Where 1=1 and (VC_TAG is null or VC_TAG!=1 ) and VC_CREATER=:1 ) temptable
g7dspp89w51mu	Select CL_ATTRIBUTE from ACTIVITY Where vc_unid= :1
gcgnh2kth2rra	insert into CASLOG (ID, USERNAME, USERIP, CLIENTHTTP, LOGINDATE, LOGOUTDATE, TICKETID, RESULT) Values (:1, :2, :3, :4, :5, :6, :7, :8)
gwr48zy7nffaq	Select CL_ATTRIBUTE from wf_history Where VC_WFTID= :1 and VC_WFAID= :2 and vc_userid=:3 and vc_oriuserid=:4 and dt_end=:5 and (vc_tag!=1 or vc_tag is null)
gx4mv66pvj3xz	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1

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

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times, in milliseconds
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top