WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
HTDB 1840233104 htdb 1 10.2.0.5.0 NO ECMora01

Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 25446 14-10ÔÂ-13 12:00:15 1375 13.6
End Snap: 25447 14-10ÔÂ-13 13:00:16 816 12.3
Elapsed:   60.02 (mins)    
DB Time:   233.48 (mins)    

Report Summary

Cache Sizes

Begin End
Buffer Cache: 48,480M 48,400M Std Block Size: 8K
Shared Pool Size: 3,808M 3,888M Log Buffer: 14,236K

Load Profile

Per Second Per Transaction
Redo size: 60,566.13 2,106.69
Logical reads: 101,687.32 3,537.02
Block changes: 219.10 7.62
Physical reads: 57.39 2.00
Physical writes: 26.32 0.92
User calls: 601.02 20.91
Parses: 143.55 4.99
Hard parses: 2.81 0.10
Sorts: 184.92 6.43
Logons: 0.14 0.00
Executes: 308.71 10.74
Transactions: 28.75  

% Blocks changed per Read: 0.22 Recursive Call %: 19.19
Rollback per transaction %: 63.18 Rows per Sort: 138.60

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.95 In-memory Sort %: 100.00
Library Hit %: 98.04 Soft Parse %: 98.04
Execute to Parse %: 53.50 Latch Hit %: 99.11
Parse CPU to Parse Elapsd %: 21.64 % Non-Parse CPU: 99.65

Shared Pool Statistics

Begin End
Memory Usage %: 74.39 74.85
% SQL with executions>1: 78.25 76.72
% Memory for SQL w/exec>1: 73.03 70.18

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
SQL*Net message from dblink 23,423,989 6,967 0 49.7 Network
CPU time   6,788   48.5  
db file sequential read 79,958 387 5 2.8 User I/O
db file scattered read 20,676 81 4 .6 User I/O
log file sync 40,742 25 1 .2 Commit

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
sql execute elapsed time 13,776.65 98.34
DB CPU 6,788.31 48.46
parse time elapsed 276.66 1.97
hard parse elapsed time 222.12 1.59
PL/SQL execution elapsed time 5.49 0.04
hard parse (sharing criteria) elapsed time 2.18 0.02
hard parse (bind mismatch) elapsed time 2.16 0.02
connection management call elapsed time 1.99 0.01
repeated bind elapsed time 0.48 0.00
sequence load elapsed time 0.04 0.00
failed parse elapsed time 0.03 0.00
PL/SQL compilation elapsed time 0.03 0.00
DB time 14,008.84  
background elapsed time 397.51  
background cpu time 30.68  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) %Total Call Time
Network 48,673,541   7,011 0 50.05
CPU time     6,788   48.46
User I/O 116,678   477 4 3.40
System I/O 81,179   56 1 0.40
Commit 40,742 0 25 1 0.18
Concurrency 7,714 8 10 1 0.07
Other 953 4 2 2 0.02
Configuration 27 4 2 76 0.01
Application 18   0 1 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
SQL*Net message from dblink 23,423,989   6,967 0 226.24
db file sequential read 79,958   387 5 0.77
db file scattered read 20,676   81 4 0.20
log file sync 40,742 0 25 1 0.39
SQL*Net more data from dblink 41,668   24 1 0.40
log file parallel write 41,799   24 1 0.40
db file parallel write 4,776   18 4 0.05
SQL*Net message to dblink 23,423,978   11 0 226.24
log file sequential read 25,225   8 0 0.24
cursor: pin S wait on X 606 98 6 10 0.01
direct path sync 6,225   6 1 0.06
LNS wait on SENDREQ 289   5 19 0.00
Log archive I/O 508   4 9 0.00
SQL*Net more data from client 42,243   3 0 0.41
read by other session 376   2 7 0.00
latch: shared pool 131   2 19 0.00
log file switch completion 12   2 155 0.00
kksfbc child completion 36 100 2 49 0.00
control file parallel write 1,711   1 1 0.02
SQL*Net message to client 1,707,975   1 0 16.50
latch: library cache 78   1 10 0.00
os thread startup 29   1 23 0.00
direct path write 6,313   1 0 0.06
SQL*Net more data to client 29,087   0 0 0.28
control file sequential read 7,158   0 0 0.07
enq: CF - contention 1   0 236 0.00
db file parallel read 26   0 8 0.00
direct path read 3,104   0 0 0.03
latch: cache buffers chains 1,504   0 0 0.01
buffer busy waits 79   0 1 0.00
enq: HW - contention 13   0 8 0.00
undo segment extension 2 50 0 49 0.00
latch: session allocation 5   0 13 0.00
SQL*Net more data to dblink 4,312   0 0 0.04
LGWR wait for redo copy 630   0 0 0.01
rdbms ipc reply 266   0 0 0.00
enq: TX - index contention 9   0 3 0.00
latch: row cache objects 126   0 0 0.00
SQL*Net break/reset to client 18   0 1 0.00
latch: redo allocation 4   0 2 0.00
latch free 6   0 1 0.00
log file single write 2   0 2 0.00
cursor: mutex S 2,668   0 0 0.03
cursor: mutex X 2,484   0 0 0.02
latch: enqueue hash chains 2   0 0 0.00
buffer deadlock 3 100 0 0 0.00
SQL*Net message from client 1,708,929   1,667,103 976 16.51
Streams AQ: qmn slave idle wait 295   7,059 23928 0.00
Streams AQ: qmn coordinator idle wait 385 34 3,529 9167 0.00
LNS ASYNC end of log 358,036 100 3,503 10 3.46
jobq slave wait 1,197 97 3,500 2924 0.01
virtual circuit status 120 100 3,497 29144 0.00
Streams AQ: waiting for time management or cleanup tasks 21 71 3,228 153692 0.00
single-task message 13   0 33 0.00
class slave wait 8   0 0 0.00
SGA: MMAN sleep for component shrink 1   0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
log file parallel write 41,790   24 1 0.40
db file parallel write 4,776   18 4 0.05
log file sequential read 25,226   8 0 0.24
LNS wait on SENDREQ 289   5 19 0.00
Log archive I/O 508   4 9 0.00
control file parallel write 1,711   1 1 0.02
os thread startup 29   1 23 0.00
events in waitclass Other 903   0 0 0.01
control file sequential read 6,206   0 0 0.06
undo segment extension 2 50 0 49 0.00
db file sequential read 10   0 7 0.00
buffer busy waits 19   0 3 0.00
direct path read 76   0 0 0.00
latch: shared pool 1   0 35 0.00
direct path write 58   0 0 0.00
log file single write 2   0 2 0.00
latch: cache buffers chains 1   0 5 0.00
rdbms ipc message 58,524 26 66,729 1140 0.57
Streams AQ: qmn slave idle wait 295   7,059 23928 0.00
Streams AQ: qmn coordinator idle wait 385 34 3,529 9167 0.00
pmon timer 1,218 100 3,510 2882 0.01
LNS ASYNC end of log 358,027 100 3,502 10 3.46
smon timer 39 5 3,500 89753 0.00
Streams AQ: waiting for time management or cleanup tasks 21 71 3,228 153692 0.00
SGA: MMAN sleep for component shrink 1   0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 24,432
AVG_IDLE_TIME 335,458
AVG_IOWAIT_TIME 2,715
AVG_SYS_TIME 4,363
AVG_USER_TIME 19,949
BUSY_TIME 785,764
IDLE_TIME 10,738,506
IOWAIT_TIME 90,846
SYS_TIME 143,384
USER_TIME 642,380
LOAD 2
OS_CPU_WAIT_TIME 755,900
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 2,998,190,080
VM_OUT_BYTES 1,878,122,496
PHYSICAL_MEMORY_BYTES 1.3E+11
NUM_CPUS 32
NUM_CPU_CORES 16

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
SYS$USERS 13,947.30 6,750.00 148,728 365,664,446
htdb 99.20 59.10 55,902 1,171,788
SYS$BACKGROUND 0.00 0.00 2,056 102,142
htdbXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
SYS$USERS 110329 433 7653 9 0 0 48673427 7006
htdb 4000 40 4 0 0 0 1022 0
SYS$BACKGROUND 2348 5 62 1 0 0 289 5

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
3,508 548 0   25.04 8pmax79k781p7   select count(*) from (select r...
2,237 382 3 745.54 15.97 0hvd7h9dqm8kd   select * from ( select * from ...
1,102 166 0   7.86 dfx1uagtscq1u   select count(distinct id) from...
544 108 2 271.85 3.88 4zykt02mkfxb7   select count(distinct id) from...
464 459 1,103 0.42 3.31 cppqs92bv0t2v   update cuecm.t_cloud_reading s...
337 337 182 1.85 2.41 g6qdf8b80sg7y   select id from T_CONTRACT_CONT...
258 256 39 6.60 1.84 0y1sm5f0mnnq0   select count(distinct id) from...
256 253 385 0.66 1.82 7tv0gpd6r6ry0   insert into T_RULE_INSTANCE(ID...
228 227 134 1.70 1.63 5v8t25x0s39aq   SELECT distinct(StaffID) FROM ...
213 211 339 0.63 1.52 akz2wnkz1mmkh   select ID , RULEID, SN, CURREN...
195 189 1,303 0.15 1.39 1b90jf6ad9q7c   select count(*) from T_MSG_Use...
181 180 26 6.95 1.29 g1zhchw2v548c   select * from ( select distinc...
176 175 158 1.11 1.26 ah2hgzyr5ygy8   select contract.lastApproverNa...
175 170 774 0.23 1.25 35b3cs58d15aa   select t.id as id, t.affairId ...
156 138 621 0.25 1.12 2g01qvjauajsy   UPDATE T_CONTRACT_CONTENT SET ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total % Total DB Time SQL Id SQL Module SQL Text
548 3,508 0   8.08 25.04 8pmax79k781p7   select count(*) from (select r...
459 464 1,103 0.42 6.76 3.31 cppqs92bv0t2v   update cuecm.t_cloud_reading s...
382 2,237 3 127.26 5.62 15.97 0hvd7h9dqm8kd   select * from ( select * from ...
337 337 182 1.85 4.97 2.41 g6qdf8b80sg7y   select id from T_CONTRACT_CONT...
256 258 39 6.57 3.78 1.84 0y1sm5f0mnnq0   select count(distinct id) from...
253 256 385 0.66 3.72 1.82 7tv0gpd6r6ry0   insert into T_RULE_INSTANCE(ID...
227 228 134 1.69 3.34 1.63 5v8t25x0s39aq   SELECT distinct(StaffID) FROM ...
211 213 339 0.62 3.11 1.52 akz2wnkz1mmkh   select ID , RULEID, SN, CURREN...
189 195 1,303 0.14 2.78 1.39 1b90jf6ad9q7c   select count(*) from T_MSG_Use...
180 181 26 6.93 2.65 1.29 g1zhchw2v548c   select * from ( select distinc...
175 176 158 1.11 2.58 1.26 ah2hgzyr5ygy8   select contract.lastApproverNa...
170 175 774 0.22 2.50 1.25 35b3cs58d15aa   select t.id as id, t.affairId ...
166 1,102 0   2.45 7.86 dfx1uagtscq1u   select count(distinct id) from...
138 156 621 0.22 2.03 1.12 2g01qvjauajsy   UPDATE T_CONTRACT_CONTENT SET ...
137 139 170 0.80 2.01 0.99 32qm4hssp9chn   UPDATE T_REPORT_STATUSCHANGE S...
118 123 771 0.15 1.73 0.88 56bynvhuns08a   select t.id as id, t.affairId ...
109 111 440 0.25 1.61 0.79 bsjgcnt113f44   select t.DEPTID as deptId, t.D...
108 544 2 54.09 1.59 3.88 4zykt02mkfxb7   select count(distinct id) from...
103 108 1,021 0.10 1.52 0.77 b7pguzqb199u2   select PREBILLID prebillid, PR...
102 102 18 5.65 1.50 0.73 dj9cqfrmvgfa0   select a.id as id , a.affairId...
94 95 109 0.86 1.39 0.68 1rpx65rvf7hd6   select l.* from T_APPROVE_LOG ...
76 79 558 0.14 1.12 0.57 19k07g153405z   select * from ( select r.id, m...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
44,541,801 1,103 40,382.41 12.16 458.71 464.12 cppqs92bv0t2v   update cuecm.t_cloud_reading s...
21,211,752 385 55,095.46 5.79 252.86 255.57 7tv0gpd6r6ry0   insert into T_RULE_INSTANCE(ID...
20,093,332 774 25,960.38 5.49 169.70 174.87 35b3cs58d15aa   select t.id as id, t.affairId ...
19,961,337 771 25,890.19 5.45 117.69 122.96 56bynvhuns08a   select t.id as id, t.affairId ...
19,492,224 134 145,464.36 5.32 226.93 228.11 5v8t25x0s39aq   SELECT distinct(StaffID) FROM ...
18,675,139 339 55,088.91 5.10 210.95 212.99 akz2wnkz1mmkh   select ID , RULEID, SN, CURREN...
13,543,320 18 752,406.67 3.70 101.72 102.45 dj9cqfrmvgfa0   select a.id as id , a.affairId...
11,174,560 440 25,396.73 3.05 109.15 110.83 bsjgcnt113f44   select t.DEPTID as deptId, t.D...
10,589,666 1,303 8,127.14 2.89 188.72 195.27 1b90jf6ad9q7c   select count(*) from T_MSG_Use...
9,796,653 621 15,775.61 2.68 137.53 156.25 2g01qvjauajsy   UPDATE T_CONTRACT_CONTENT SET ...
9,720,500 170 57,179.41 2.65 136.76 138.81 32qm4hssp9chn   UPDATE T_REPORT_STATUSCHANGE S...
9,352,995 39 239,820.38 2.55 256.42 257.57 0y1sm5f0mnnq0   select count(distinct id) from...
9,098,099 182 49,989.55 2.48 337.09 337.22 g6qdf8b80sg7y   select id from T_CONTRACT_CONT...
8,547,720 158 54,099.49 2.33 175.23 175.88 ah2hgzyr5ygy8   select contract.lastApproverNa...
7,159,451 8,983 797.00 1.96 23.08 62.30 ggb8rzqbq0xj7   SELECT id , relationId , targe...
6,475,377 26 249,052.96 1.77 180.15 180.82 g1zhchw2v548c   select * from ( select distinc...
4,954,926 1,021 4,853.01 1.35 103.44 108.42 b7pguzqb199u2   select PREBILLID prebillid, PR...
4,811,046 189 25,455.27 1.31 48.82 49.38 a47a7yny6bdjv   select count(*) from T_APPROVE...
4,596,929 558 8,238.22 1.26 76.06 79.22 19k07g153405z   select * from ( select r.id, m...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
67,936 3 22,645.33 32.87 7.63 40.45 gckrhq51a6757   update t_contract_content cnt ...
25,913 18 1,439.61 12.54 28.09 63.14 39qkfcm7998kk   SELECT l.ID, p.REQUESTER, l.WO...
6,282 7,364 0.85 3.04 4.43 21.86 a9mq5sjz83fb2   INSERT INTO CUECM.T_INTERFACE_...
3,746 0   1.81 548.39 3508.08 8pmax79k781p7   select count(*) from (select r...
2,855 7,327 0.39 1.38 0.38 27.14 0x1wx5qjhayqp   SELECT count(distinct l.compan...
2,194 2,062 1.06 1.06 2.86 28.88 gaqyz76td58dn   SELECT COUNT(ID) FROM T_APPROV...
1,574 621 2.53 0.76 137.53 156.25 2g01qvjauajsy   UPDATE T_CONTRACT_CONTENT SET ...
983 10,193 0.10 0.48 0.13 7.40 90j3hhq0sz6fd   select * from T_FILE_LIBRARY w...
424 3,321 0.13 0.21 0.11 5.64 dgvq7yup0tkkc   select doc.id, CLASSIFY, doc.R...
353 3 117.67 0.17 381.78 2236.62 0hvd7h9dqm8kd   select * from ( select * from ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
289,306 288,794 1.00 0.00 0.00 7vtbsjxmu0trr   select id, pid, seq, hrCode, h...
64,322 30,339 0.47 0.00 0.00 bbg1cdtpuyhs6   select t.id, t.paramid, t.data...
36,807 36,755 1.00 0.00 0.00 820b94rxtc2rq   select id, seq, userid, displa...
34,138 10,736 0.31 0.00 0.00 a7wk0m5j6fcy0   select t.id, t.paramid, t.data...
14,498 315,493 21.76 0.00 0.00 cypbpr80qsj6y   SELECT NAME, VALUE, COMMENTS F...
13,329 13,329 1.00 0.00 0.00 bjwrstsj8js0n   select c.ID as id, c.AffairID ...
12,673 12,673 1.00 0.00 0.00 fy8q0ju5a26r6   select count(1) from t_block_c...
10,193 15,774 1.55 0.00 0.00 90j3hhq0sz6fd   select * from T_FILE_LIBRARY w...
9,959 9,959 1.00 0.00 0.00 7xuy2tu79xybm   SELECT MGR_SN.NEXTVAL as id FR...
9,559 9,045 0.95 0.00 0.00 3u7g76wsqd21c   select processDefId, actDefId,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
31,160 289,306 6.03 7vtbsjxmu0trr   select id, pid, seq, hrCode, h...
18,906 64,322 3.66 bbg1cdtpuyhs6   select t.id, t.paramid, t.data...
13,867 34,138 2.68 a7wk0m5j6fcy0   select t.id, t.paramid, t.data...
12,175 36,807 2.36 820b94rxtc2rq   select id, seq, userid, displa...
10,899 13,329 2.11 bjwrstsj8js0n   select c.ID as id, c.AffairID ...
9,652 12,673 1.87 fy8q0ju5a26r6   select count(1) from t_block_c...
7,584 9,959 1.47 7xuy2tu79xybm   SELECT MGR_SN.NEXTVAL as id FR...
6,911 6,911 1.34 23txcp69tfpw5   select id, seq, userid, displa...
6,132 6,132 1.19 grwydz59pu6mc   select text from view$ where r...
6,106 9,559 1.18 3u7g76wsqd21c   select processDefId, actDefId,...
6,088 6,204 1.18 ggw6y1mv9x1b7   select t.ID as id, t.CONTRACTI...
5,775 7,364 1.12 a9mq5sjz83fb2   INSERT INTO CUECM.T_INTERFACE_...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
1,091,343 1 0.03 8f1sjvfxuup9w PL/SQL Developer select t.*, o.*, m.comments fr...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL Id SQL Module SQL Text
46 60 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
25 24 5u0cauu9rz06g   update t_contract_arrair set c...
24 650 6xq5pfm5bqcvf   INSERT INTO CUECM.T_INTERFACE_...
23 7,364 a9mq5sjz83fb2   INSERT INTO CUECM.T_INTERFACE_...
23 3 axmdf8vq7k1rh   select increment$, minvalue, m...
23 1 f8kugz1xpukbr   SELECT MAX(A.ORGCODE) FROM T_M...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text
0hvd7h9dqm8kd select * from ( select * from ( select rank() over(partition by vf.afarid order by vf.workitemid desc) rowseq, null as pendingcode, vf.BUSSINESSTYPE, vf.workflowid, to_char(vf.flowendtime, 'yyyy-MM-dd HH24:mi:ss') as flowendtime, vf.currentactivityname, vf.acceptername, vf.afarid, appt.name as workflowtype, vf.sendername, vf.processinstid, vf.title, vf.approvelevel, to_char(vf.DELIVERTIME, 'yyyy-MM-dd HH24:mi:ss') as starttime, vf.creator, vf.creatorname, vf.deptid, vf.deptname from v_finishexecutableworktask vf left join T_DATA_ITEM appt on appt.value=vf.bussinesstype and appt.deleted=0 and appt.cataid = 1101 where 1 = 1 and vf.title like '%'||:1||'%' and vf.globalID in ('P{209240553}', 'O{36146075201}', 'O{36146}', 'O{36065}') union all select 1 as rowseq, t1.pendingcode, t1.businessTypeId, null, t1.dealtime, null, null, null, t1.businessTypeName, null, null, t1.title, null, t1.starttime, null, null, null, null from( select tab1.pendingcode, tab1.title, tab1.type as businessTypeId, tab2.name as businessTypeName, to_char(tab1.createtime, 'yyyy-MM-dd HH24:mi:ss') as starttime, to_char(tab1.dealdate, 'yyyy-MM-dd HH24:mi:ss') as dealtime from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 where flag=3 and ta b1.dealdate> add_months(sysdate, -3) and tab1.recieverid = :2 )t1 where 1=1 and t1.title like '%'||:3||'%' ) WHERE rowseq = 1 order by flowendtime desc, starttime desc ) where rownum<=:4
0x1wx5qjhayqp SELECT count(distinct l.companyid) FROM T_APPROVE_LOG l left join T_APPROVE_PROCESS p on p.workflowid=l.workflowid WHERE p.approveid=:1 and proposal is not null
0y1sm5f0mnnq0 select count(distinct id) from ( select ve.workflowid||'' as id from v_executableworktask ve left join T_DATA_ITEM appt on appt.value=ve.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1 = 1 and ve.globalID in ('P{205694453}', 'O{511800100}', 'O{5118}', 'G{236378350}', 'G{236377821}') and ve.BUSINESSID in ( SELECT C.id FROM T_CONTRACT_CONTENT C WHERE INSTR(C.GLOBALSN, :1) >0 UNION SELECT E.ID FROM T_CONTRACT_CONTENT C, CUECM.T_CONTRACT_DONE E WHERE E.AFFAIRID = C.AFFAIRID AND INSTR(C.GLOBALSN, :2) >0 UNION SELECT L.RELATIONID FROM T_CONTRACT_CONTENT C, T_APPROVE_LIST L WHERE L.DENYSIGN = 0 AND L.TARGETID = C.ID AND INSTR(C.GLOBALSN, :3) >0 UNION SELECT F.id FROM t_contract_file f, T_CONTRACT_CONTENT C WHERE f.contractId = C.ID AND INSTR(C.GLOBALSN, :4) >0 UNION SELECT d.id FROM t_contract_dissension d, T_CONTRACT_CONTENT C WHERE c.id=d.contractid AND INSTR(C.GLOBALSN, :5) >0 ) union select t.pend ingcode as id from ( select tab1.pendingcode, tab1.type as businessTypeId, tab2.name businessTypeName, tab1.senddate as starttime , tab1.seandername, tab1.title from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 where tab1.flag=0 and tab1.recieverid = :6 and TAB1.BUSSINESSID in ( SELECT C.id FROM T_CONTRACT_CONTENT C WHERE INSTR(C.GLOBALSN, :7) >0 UNION SELECT E.ID FROM T_CONTRACT_CONTENT C, CUECM.T_CONTRACT_DONE E WHERE E.AFFAIRID = C.AFFAIRID AND INSTR(C.GLOBALSN, :8) >0 UNION SELECT L.RELATIONID FROM T_CONTRACT_CONTENT C, T_APPROVE_LIST L WHERE L.DENYSIGN = 0 AND L.TARGETID = C.ID AND INSTR(C.GLOBALSN, :9) >0 UNION SELECT F.id FROM t_contract_file f, T_CONTRACT_CONTENT C WHERE f.contractId = C.ID AND INSTR(C.GLOBALSN, :10) >0 UNION SELECT d.id FROM t_contract_dissension d, T_CONTRACT_CONTENT C WHERE c.id=d.contractid AND INSTR(C.GLOBALSN, :11) & gt;0 ) )t where 1=1 )
19k07g153405z select * from ( select r.id, m.id as mailId, senderName, title, mailType, d.name as mailTypeName, receiveTime from T_MSG_UserMail m, T_MSG_MailRECEIVER r, t_data_item d where m.id=r.mailid and r.receiverId=:1 and r.isRead=:2 and d.cataid=:3 and d.value=m.mailType order by receiveTime desc ) where rownum<=:4
1b90jf6ad9q7c select count(*) from T_MSG_UserMail m, T_MSG_MailRECEIVER r, t_data_item d where m.id=r.mailid and r.receiverId=:1 and r.isRead=:2 and d.cataid=:3 and d.value=m.mailType
1rpx65rvf7hd6 select l.* from T_APPROVE_LOG l , t_wfext_activity wa where l.processdefid=wa.processdefid and l.prevactdefid =wa.actdefid and wa.activitytype=0 and l.workflowid in ( select ap.workflowid from t_approve_process ap where ap.requester = (select t.requester from t_approve_process t where t.workflowid = (select max(p.workflowid) from t_approve_process p where p.parentworkflowid = :1)))
23txcp69tfpw5 select id, seq, userid, displayName, positionId, positionName, companyId, companyName, provinceId, provinceName, deptId, deptName, positionStatus, hrType, hrStatus, HRCODE, email from T_UAM_STAFF where locked=0 and id=:1
2g01qvjauajsy UPDATE T_CONTRACT_CONTENT SET ContractStatus=:1 WHERE ID = :2
32qm4hssp9chn UPDATE T_REPORT_STATUSCHANGE SCC SET SCC.RESERVER1 = (SELECT MAX(A.WORKFLOWID) FROM T_APPROVE_AFFAIR A WHERE A.BUSSINESSTYPE=21 AND A.BUSINESSID=:B1 ) WHERE SCC.CONTRACTSTATUS=202 AND SCC.RESERVER1 IS NULL
35b3cs58d15aa select t.id as id, t.affairId as affairId, t.classify as classify, t.templateId as templateId, t.LocalSN as localSn, t.globalsn as globalSn, t.name as name, t.contractStatus as contractStatus, t.professionalType as professionalType, t.changeType as changeType, t.relationId as relationId, t.relationName as relationName, t.we as we, t.otherSide as otherSide, t.frameWorkMode as frameWorkMode, t.degree as degree, t.priority as priority, t.precondition as precondition, t.cnt as cnt, t.watermark as watermark, t.fixed as fixed, t.printed as printed, t.archived as archived, t.comments as comments, t.mobile as mobile, t.takerId as takerId, t.takerName as takerName, t.deptid as deptId, t.deptname as deptName, t.companyId as companyId, t.creator as creator, t.creatorname as creatorName, t.provinceid as provinceId, t.createtime as createTime, t.updatetime as updateTime, t.deleted as deleted, t.signer as signer, t.isBatch as isBatch, t.requireName as requireName, t.signDate as signDate, t.comeFrom as comeFrom, t.signcnt as signcnt, t.locked as locked, t.companyname as companyName, t.overView as overView, t.configResultID as configResultID, t.classifyName as classifyName, t.conjunction as conjunction, (select max(fin.MONEY) from T_CONTRACT_FINANCE fin where fin.contractid=t.id) as sum from T_CONTRACT_CONTENT t where t.oldArrairId = :1 and t.isrenew = 1 and t.contractStatus != 207 and t.contractStatus != 210 and t.del eted = 0 and t.provinceId = :2
39qkfcm7998kk SELECT l.ID, p.REQUESTER, l.WORKFLOWID, l.CURRENTACTIVITY, l.CURRENTACTIVITYID, l.PREVACTIVITY, l.ACCEPTER, l.STATUS, l.SENDER, l.SENDERNAME, l.CREATETIME, l.PROPOSAL, l.companyid, l.companyname FROM T_APPROVE_LOG l left join T_APPROVE_PROCESS p on p.workflowid=l.workflowid WHERE p.PARENTWORKFLOWID=:1 and p.PARENTWORKFLOWID>0 order by p.workflowid, l.id
3u7g76wsqd21c select processDefId, actDefId, pageURL, actionURL, bizPermission, extbizPermission, extfield, ideaType, activityType, hqbizPermission from t_wfext_activity where processDefId=:1 and actDefId=:2
4zykt02mkfxb7 select count(distinct id) from ( select vf.workflowid||'' as id from v_finishexecutableworktask vf left join T_DATA_ITEM appt on appt.value=vf.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1 = 1 and vf.title like '%'||:1||'%' and vf.globalID in ('P{2237649}', 'O{350500905}', 'O{350500900}', 'O{3505}') union all select t.pendingcode as id from ( select tab1.pendingcode, tab1.title, tab1.type as businessTypeId, tab2.name as businessTypeName, tab1.dealdate, tab1.seandername from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 where flag=3 and tab1.dealdate> add_months(sysdate, -3) and tab1.recieverid = :2 )t where 1=1 and t.title like '%'||:3||'%' )
56bynvhuns08a select t.id as id, t.affairId as affairId, t.classify as classify, t.templateId as templateId, t.LocalSN as localSn, t.globalsn as globalSn, t.name as name, t.contractStatus as contractStatus, t.professionalType as professionalType, t.changeType as changeType, t.relationId as relationId, t.relationName as relationName, t.we as we, t.otherSide as otherSide, t.frameWorkMode as frameWorkMode, t.degree as degree, t.priority as priority, t.precondition as precondition, t.cnt as cnt, t.watermark as watermark, t.fixed as fixed, t.printed as printed, t.archived as archived, t.comments as comments, t.mobile as mobile, t.takerId as takerId, t.takerName as takerName, t.deptid as deptId, t.deptname as deptName, t.companyId as companyId, t.creator as creator, t.creatorname as creatorName, t.provinceid as provinceId, t.createtime as createTime, t.updatetime as updateTime, t.deleted as deleted, t.signer as signer, t.isBatch as isBatch, t.requireName as requireName, t.signDate as signDate, t.comeFrom as comeFrom, t.signcnt as signcnt, t.locked as locked, t.companyname as companyName, t.overView as overView, t.configResultID as configResultID, t.classifyName as classifyName, t.conjunction as conjunction, (select max(fin.MONEY) from T_CONTRACT_FINANCE fin where fin.contractid=t.id) as sum from T_CONTRACT_CONTENT t where t.relationId = :1 and t.isrenew = 2 and t.contractStatus != 207 and t.contractStatus != 210 and t.dele ted = 0 and t.provinceId = :2
5u0cauu9rz06g update t_contract_arrair set contractId=:1, ouId=:2, ratio=:3, sum=:4, money=:5, gbk4sum=:6, sum4Origin=:7, ratio4Origin=:8, money4Origin=:9, gbk4Origin=:10, vaTax=:11, updatetime=sysdate where id=:12
5v8t25x0s39aq SELECT distinct(StaffID) FROM T_APPROVE_ACCESS WHERE approveID=:1
6xq5pfm5bqcvf INSERT INTO CUECM.T_INTERFACE_LOGS ( ID, EXTERNALSYSTEM, ERRORFLAG, ERRORTYPE, CREATETIME, INTERFACENAME, PROVINCEID, BATCHID, LOGID, CREATOR, CREATORID, FUNCTIONPOINT, CONTRACTID, STATUS, EXTMSG, EINTERFACENAME, MSG, STEP ) VALUES ( :1, :2, :3, :4, sysdate, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17 )
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#
7tv0gpd6r6ry0 insert into T_RULE_INSTANCE(ID , RULEID, SN, CURRENTVALUE, DEPTID, COMPANYID, PROVINCEID, YEAR, legalPerson) VALUES(:1, :2, (select nvl(max(b.SN), 0)+1 from T_RULE_INSTANCE b where b.COMPANYID=:3 and b.Year =:4 and b.RULEID=:5 and b.provinceId=:6 and b.legalPerson=:7), :8, :9, :10, :11, :12, :13)
7vtbsjxmu0trr select id, pid, seq, hrCode, hrpCode, companyId, provinceId, orgName, displayName, type, orgStatus, isAdmin, isVirtual from T_UAM_ORG where id=:1
7xuy2tu79xybm SELECT MGR_SN.NEXTVAL as id FROM DUAL
820b94rxtc2rq select id, seq, userid, displayName, positionId, positionName, companyId, companyName, provinceId, provinceName, deptId, deptName, positionStatus, hrType, hrStatus, HRCODE, email from T_UAM_STAFF where locked=0 and id=:1
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
8pmax79k781p7 select count(*) from (select rank() over(partition by vh.workflowid order by vh.workitemid desc) rowseq, null as pendingcode, vh.BUSSINESSTYPE, vh.workflowid, vh.parentworkflowid, vh.approvelevel, vh.processcreator, vh.accepted, vh.workitemid, replace(vh.currentactivityname, 'N/A', '') as currentactivityname, replace(vh.acceptername, 'N/A', '') as acceptername, vh.accepterid, vh.afarid, appt.name as workflowtype, to_char(vh.endtime, 'yyyy-MM-dd HH24:mi:ss') as starttime , vh.sendername, vh.senderid, vh.processinstid, vh.title, to_char(vh.createtime, 'yyyy-MM-dd HH24:mi:ss') as createtime, vh.creator, vh.creatorname, vh.deptid, vh.deptname from v_hasexecutableworktask vh left join T_DATA_ITEM appt on appt.value=vh.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1 = 1 and vh.globalID in ('P{208973982}', 'O{230511074}', 'O{230500069}', 'O{2305}') and vh.BUSSINESSTYPE = :1 union select 1 as rowseq, t1.pendingcode, t1.businessTypeId, null, null, null, null, null, null, t1.currentactivityname, t1.recievername, null, null, t1.businessTypeName, t1.starttime, null, null, null, t1.title, null, null, null, null, null from( select tab1.pendingcode, tab1.title, tab1.type as businessTypeId, tab2.name as currentactivityname, tab2.name as businessTypeName, to_char(tab1.createtime, 'yyyy-MM-dd HH24:mi:ss') as starttime, tab1.recievername from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 left join (select bussinessId, max(no1.createtime) as createtime, max(no1.type)as type, max(id) as id from t_approve_notify no1 where no1.flag = 1 and no1.type in(38, 39, 40, 41) and no1.recieverid = :2 group by no1.bussinessId ) tab3 on tab1.id = tab3.id where tab1.flag = 1 and (tab1.type not in(38, 39, 40, 41) or (tab1.id = tab3.id)) and tab1.recieverid = :3 ) t1 where 1=1 and t1.businessTypeId = :4 )WHERE rowseq = 1 order by starttime desc
90j3hhq0sz6fd select * from T_FILE_LIBRARY where DESCID = :1 and Deleted=0 and provinceId = :2
a47a7yny6bdjv select count(*) from T_APPROVEBATCH_COMMENTS t where t.DELETED=0 and t.SAVETMP=1 and t.BUSINESSID = :1 and t.ACTDEFID = :2 and t.APPROVERID = :3 and t.DEPTID = :4 and t.COMMENTS = :5 and t.APPROVECOUNT = :6
a7wk0m5j6fcy0 select t.id, t.paramid, t.data, t.comments, t.creator, t.companyid, t.provinceid, t.createtime, t.updatetime, t.lvl from T_CUSTOM_ITEM t where t.paramid=:1 and t.lvl=:2 and t.deleted=0
a9mq5sjz83fb2 INSERT INTO CUECM.T_INTERFACE_LOGS ( ID, EXTERNALSYSTEM, ERRORFLAG, ERRORTYPE, CREATETIME, INTERFACENAME, PROVINCEID, BATCHID, LOGID, CREATOR, CREATORID, FUNCTIONPOINT, CONTRACTID, STATUS, EXTMSG, EINTERFACENAME, MSG, STEP , xmlmessage ) VALUES ( :1, :2, :3, :4, sysdate, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17 , :18 )
ah2hgzyr5ygy8 select contract.lastApproverName, contract.CONTRACTNAME AS name, contract.CONTRACTID AS id , contract.CURRENTID AS currentid, contract.ORIGINID AS originID, contract.GLOBALSN AS globalSn, contract.LOCALSN AS localSn, contract.CLASSIFY AS classify, contract.CLASSIFYNAME AS classifyName, contract.CLASSIFYFULLNAME AS classifyFullName, contract.CONTRACTSTATUS AS contractStatus, contract.DEPTID AS deptId, contract.COMPANYID AS companyId, contract.COMPANYNAME AS signedOrgName, contract.PROVINCEID AS provinceId, contract.TAKERID AS takerId, contract.TAKERNAME AS takerName, contract.DEPTNAME AS takerDeptName, contract.SIGNDATE AS signDate, contract.SIGNDATE AS signedDate, contract.affairSUM AS sum, contract.sum4Audit AS sum4Audit, contract.STARTDATE AS startdate, contract.ENDDATE AS enddate, contract.AFFAIRID AS affairId, contract.OTHERSIDE AS otherSide, contract.WE AS we, contract.CREATETIME AS createTime, contract.CHANGETYPE AS changeType, contract.DEGREE AS degree, contract.priority AS priority, contract.CONJUNCTION AS conjunction, contract.MONEYTYPE AS moneytype, contract.MONEYNAME AS moneytypeName, contract.RMBMONEY AS rmbMoney, contract.contractsn AS contractSN, nvl(contract.PLANPAY, 0) AS planPay, nvl(contract.ACTUALPAY , 0)AS actualPay, contract.FRAMEWORKMODE AS frameWorkMode, contract.archived AS archived, contract.PERFORMTIMELIMIT as performTimeLimit, contract.SENDAPPROVALDATE as se ndApprovalDate, contract.datacomefrom, contract.isimport, contract.ENTERPERFORMTIME as enterPerformTime, contract.SIGNEDMETHODS, contract.CONTRACTPAYMETHOD from ( SELECT¡¡ROWNUM NO, ID FROM (SELECT idx.id FROM ( SELECT CONTRACT.ID FROM T_CONTRACT_CONTENT CONTRACT WHERE 1 = 2 UNION SELECT CONTENT.ID FROM T_CONTRACT_PERFORMER PERFORMER, T_CONTRACT_ARRAIR AFFAIR, T_CONTRACT_CONTENT CONTENT WHERE PERFORMER.DELETED = 0 AND PERFORMER.PERFORMERID = :1 AND PERFORMER.AFFAIRID = AFFAIR.ID AND AFFAIR.DELETED= 0 AND AFFAIR.ID = CONTENT.AFFAIRID AND CONTENT.DELETED = 0 AND PERFORMER.PROVINCEID in(:2, 1000) UNION SELECT contract.id FROM T_CONTRACT_CONTENT contract WHERE contract.takerId=:3 AND contract.PROVINCEID = :4 UNION SELECT distinct(t.businessid) as id FROM T_APPROVE_ACCESS t WHERE exists(select null from t_approve_affair a where a.batch=0 and t.businessid=a.businessid) AND (t.BussinessType = 21 or t.BussinessType = 27) AND t.staffid = :5 UNION ( select distinct(targetid) as id from ( SELECT distinct(t.businessid) as packId FROM T_APPROVE_ACCESS t WHERE exists(select null from t_approve_affair a where a.batch=1 and t.businessid=a.businessid) AND t.BussinessType = 21 AND t.staffid = :6 ) a, t_approve_list b where b.businesstype=2 and b.denysign=0 and b.relationid=a. packId ) ) idx , T_CONTRACT_CONTENT contract, T_CONTRACT_ARRAIR AFFAIR, t_external_payorder h where idx.id = contract.ID AND contract.DELETED = 0 AND contract.id = h.ContractID(+) and contract.PROVINCEID IN (:7, 1000 , :8 , :9 ) and AFFAIR.PROVINCEID IN (:10, 1000 , :11 , :12 ) AND AFFAIR.ID = contract.AFFAIRID AND AFFAIR.DELETED = 0 AND (contract.contractStatus IN ( :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 )) AND (contract.name LIKE replace('%'||:25||'%', ' ', '%')) ORDER BY contract.SIGNDATE DESC nulls last, contract.GlobalSn DESC nulls last ) WHERE ROWNUM<=(:26*:27) ) A, mv_contract_list contract where NO >((:28-1)*:29) AND contract.CONTRACTID = A.id order by a.no asc
akz2wnkz1mmkh select ID , RULEID, SN, CURRENTVALUE, DEPTID, COMPANYID, PROVINCEID, YEAR, legalPerson from T_RULE_INSTANCE a where a.ruleid=:1 and a.sn=:2 and a.companyid=:3 and a.provinceid=:4 and a.year=:5 and legalPerson=:6
axmdf8vq7k1rh select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b7pguzqb199u2 select PREBILLID prebillid, PREBILLNO prebillno, ISPREBILL isprebill, ISRENEW isrenew, CONTRACTID contractid, CONTRACTNO contractno, BILLTYPE billtype, ISNEW isnew, ISPAUSE ispause, PREBILLSTATUS prebillstatus, ADJUSTTYPE adjusttype, PREBILLARRAIRID prebillarrairid, VERSION version, ADJUSTRESON adjustreson, NOBILLRESON nobillreson, TOTALCONTRIBUTION totalcontribution, TOTALCOUNTAMOUNT totalcountamount, TOTALCONTRIBLANCE totalcontriblance, TOTALOFFSETAMOUNT totaloffsetamount, TOTALRENEWALMONEY totalrenewalmoney, ORGID orgid, ORGNAME orgname, ORGOUCODE orgoucode, ORGOUNAME orgouname, APPROVEDATE approvedate, CREATEID createid, CREATENAME createname, CREATETIME createtime, UPDATETIME updatetime, LASTAPPROVENAME lastapprovename, LASTAPPROVEID lastapproveid, FEEUSERNAME feeusername, REVIEWUSERNAME reviewusername, FEEUSERID feeuserid, REVIEWUSERID reviewuserid, PROVINCEID provinceid, ADJUSTOR adjustor, ADJUSTORID adjustorId, ADJUSTTIME adjustTime, ADJUSTPERIOD adjustPeriod from T_PREBILL_INSTANCE where ISNEW = 1 and CONTRACTID= :1
bbg1cdtpuyhs6 select t.id, t.paramid, t.data, t.comments, t.creator, t.companyid, t.provinceid, t.createtime, t.updatetime, t.lvl from T_CUSTOM_ITEM t where t.paramid=:1 and t.lvl=:2 and t.deleted=0 and t.provinceid=:3
bjwrstsj8js0n select c.ID as id, c.AffairID as affairId, c.Classify as classify, classifyName, ISREADY, companyName, overView, c.TemplateID as templateId, c.Version as version, c.LocalSN as localSn, c.NAME as name, c.ContractStatus as contractStatus, c.ChangeType as changeType, c.RelationID as relationId, c.CONJUNCTION as conjunction, c.FrameWorkMode as frameWorkMode, c.DEGREE as degree, c.PRIORITY as priority, c.PRECONDITION as precondition, c.Cnt as cnt, c.WATERMARK as watermark, c.Fixed as fixed, replace(c.phone, 'N/A', '') as phone, c.fixedAmount as fixedAmount, c.signDeptName as signDeptNames, c.BIDQUALIFITIONEXP as bidqualifitionexp, c.Printed as printed, c.Globalsn as globalSn, c.Archived as archived, c.Comments as comments, c.Creator as creator, c.CreatorName as creatorName, c.Mobile as mobile, c.takerId as takerId, c.takerName as takerName, c.DeptID as deptId, c.DeptName as deptName, c.CompanyID as companyId, c.ProvinceID as provinceId, c.CreateTime as createTime, c.UpdateTime as updateTime, c.Deleted as deleted, c.ProfessionalType as professionalType, c.PurchaseResultID as purchaseResultID, c.ISBATCH as isBatch, c.REQUIRENAME as requireName, c.SIGNDATE as signDate , c.signcnt as signCnt, c.signer as signer, c.COMEFROM as comeFrom, c.relationName as relationname, c.configResultID as configResultID, c.BidType as bidType, c.performAccount as performAccount, c.sendApprovalDate as sendApproval Date, c.DRAFTOUTTAB, c.PERFORMTAB, c.signstatus as signStatus, c.performtype as performType, c.baseStation as baseStation, c.checkVendor as checkVendor , t.PURID as purId, t.forframeflag as forframeflag, c.IsBeforehand as isBeforehand, c.degree_ext , c.isimport as isimport, c.explain as explain, c.issettlement as isSettlement, c.isttf as isTTF , c.hasPrebill as hasPrebill, c.istwoinone as istwoinone, c.otherside as otherside, c.dataComeFrom as dataComeFrom, t.reserved11 as orderCtr, c.we as we, (select p.sum from t_contract_arrair p where p.id = c.AffairID) as sum, c.accountrate as accountRate, c.isrenew as isRenew from T_CONTRACT_CONTENT c left join T_EXTERNAL_PAYORDER t on t.contractid = c.id where c.id=:1 and c.provinceId = :2
bsjgcnt113f44 select t.DEPTID as deptId, t.DEPENAME as deptName , t.COMPANYID as companyId , t.COMPANYNAME as companyName , min(t.createtime) as createTime from T_APPROVEBATCH_COMMENTS t where t.DELETED=0 and t.SAVETMP=1 and t.BUSINESSID = :1 and t.ACTDEFID = :2 group by t.DEPTID, t.DEPENAME, t.COMPANYID, t.COMPANYNAME order by createTime
cppqs92bv0t2v update cuecm.t_cloud_reading set issuccess=:1 where readingCode=:2 and readingStatus=:3
cypbpr80qsj6y SELECT NAME, VALUE, COMMENTS FROM t_data_item WHERE DELETED=0 AND CATAID=:1 order by SEQ, VALUE
dfx1uagtscq1u select count(distinct id) from ( select vf.workflowid||'' as id from v_finishexecutableworktask vf left join T_DATA_ITEM appt on appt.value=vf.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1 = 1 and vf.title like '%'||:1||'%' and vf.globalID in ('P{209240553}', 'O{36146075201}', 'O{36146}', 'O{36065}') union all select t.pendingcode as id from ( select tab1.pendingcode, tab1.title, tab1.type as businessTypeId, tab2.name as businessTypeName, tab1.dealdate, tab1.seandername from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 where flag=3 and tab1.dealdate> add_months(sysdate, -3) and tab1.recieverid = :2 )t where 1=1 and t.title like '%'||:3||'%' )
dgvq7yup0tkkc select doc.id, CLASSIFY, doc.RELATIONID, doc.DOCTYPE, doc.SEQ, doc.CREATOR, doc.CREATETIME, doc.DELETED, doc.provinceId, t.displayname from T_DOC_DESC doc left join t_uam_staff t on doc.creator = t.id where doc.relationid = :1 and doc.DocType in (3, 1, 2, 6, 11) and doc.deleted = 0 and doc.provinceId = :2
dj9cqfrmvgfa0 select a.id as id , a.affairId as affairId, a.LocalSN as localSn, a.NAME as name, a.classifyName as classifyName , a.OTHERSIDE as otherSide , b.MONEY as money , a.CreateTime as createTime, a.comeFrom as comeFrom , a.changeType as changeType, a.isReady as isReady , a.locked as locked , a.provinceId as provinceId , a.contractstatus as contractstatus, a.mobile as mobile, a.isRenew as isRenew, a.datacomefrom, a.comefrom, a.globalsn as globalsn, a.we as we, a.deptname as deptName, a.takername as takerName, a.purchaseresultid as purchaseResultID, a.istwoinone as isTwoInOne, a.classify as classify FROM T_CONTRACT_CONTENT a , T_CONTRACT_FINANCE b WHERE a.CONTRACTSTATUS=:1 AND a.DELETED=:2 and a.ID=b.CONTRACTID and a.provinceId=:3 and a.takerid=:4 and a.comefrom !=:5 and a.affairId not in(SELECT OLDARRAIRID FROM T_CONTRACT_CONTENT WHERE OLDARRAIRID IS NOT NULL AND DELETED = 0 AND CONTRACTSTATUS not in (207, 210)) and a.conjunction !=:6 order by a.createTime desc
f8kugz1xpukbr SELECT MAX(A.ORGCODE) FROM T_MAP_ORG4SOA A WHERE A.ORGID = :B1
fy8q0ju5a26r6 select count(1) from t_block_classify t, t_contract_block a where rownum <= 1 and t.blockid = a.id and t.classifyid = :1 and t.enabled = 1 and t.provinceid =:2 and t.companyid = :3 and a.blockprefix =:4
g1zhchw2v548c select * from ( select distinct null as pendingcode, ve.BUSSINESSTYPE, ve.workflowid, ve.processcreator, ve.accepted, ve.parentworkflowid, ve.afarid, to_char(ve.sendtime, 'yyyy-MM-dd') as sendtime, appt.name as workflowtype, to_char(ve.starttime, 'yyyy-MM-dd HH24:mi:ss') as starttime , replace(ve.sendername, 'N/A', '') as sendername, ve.senderid, ve.approvelevel, ve.accepterid, ve.acceptername, ve.processinstid, ve.title, ve.createtime, ve.creator, ve.creatorname, ve.deptid, ve.deptname, ve.workitemid, ve.beCommission, ve.batch from v_executableworktask ve left join T_DATA_ITEM appt on appt.value=ve.BUSSINESSTYPE and appt.deleted=0 and appt.cataid = 1101 where 1=1 and ve.globalID in ('P{205694453}', 'O{511800100}', 'O{5118}', 'G{236378350}', 'G{236377821}') and ve.BUSINESSID in ( SELECT C.id FROM T_CONTRACT_CONTENT C WHERE INSTR(C.GLOBALSN, :1) >0 UNION SELECT E.ID FROM T_CONTRACT_CONTENT C, CUECM.T_CONTRACT_DONE E WHERE E.AFFAIRID = C.AFFAIRID AND INSTR(C.GLOBALSN, :2) >0 UNION SELECT L.RELATIONID FROM T_CONTRACT_CONTENT C, T_APPROVE_LIST L WHERE L.DENYSIGN = 0 AND L.TARGETID = C.ID AND INSTR(C.GLOBALSN, :3) >0 UNION SELECT F.id FROM t_contract_file f, T_CONTRACT_CONTENT C WHERE f.contractId = C.ID AND INSTR(C.GLOBALSN, :4) >0 UNION SELECT d.id FROM t_contract_dissension d, T_CONTRACT_CONTENT C WHERE c.id=d.contractid AND INSTR(C.GLOBALSN, :5) >0 ) union select pendingcode, businessTypeId, null, null, null, null, null, null, businessTypeName, starttime, seandername, null, null, null, null, null, title, null, null, null, null, null, null, '0', null from ( select tab1.pendingcode, tab1.type as businessTypeId, tab2.name businessTypeName, to_char(tab1.senddate, 'yyyy-MM-dd HH24:mi:ss') as starttime , tab1.seandername, tab1.title from t_approve_notify tab1 left join t_data_item tab2 on tab1.type = tab2.value and tab2.cataid = 1101 and tab2.deleted = 0 where tab1.flag=0 and tab1.recieverid = :6 and TAB1.BUSSINESSID in ( SELECT C.id FROM T_CONTRACT_CONTENT C WHERE INSTR(C.GLOBALSN, :7) >0 UNION SELECT E.ID FROM T_CONTRACT_CONTENT C, CUECM.T_CONTRACT_DONE E WHERE E.AFFAIRID = C.AFFAIRID AND INSTR(C.GLOBALSN, :8) >0 UNION SELECT L.RELATIONID FROM T_CONTRACT_CONTENT C, T_APPROVE_LIST L WHERE L.DENYSIGN = 0 AND L.TARGETID = C.ID AND INSTR(C.GLOBALSN, :9) >0 UNION SELECT F.id FROM t_contract_file f, T_CONTRACT_CONTENT C WHERE f.contractId = C.ID AND INSTR(C.GLOBALSN, :10) >0 UNION SELECT d.id FROM t_contract_dissension d, T_CONTRACT_CONTENT C WHERE c.id=d.contractid AND INSTR(C.GLOBALSN, :11) >0 ) ) where 1=1 order by starttime desc ) where rownum<=:12
g6qdf8b80sg7y select id from T_CONTRACT_CONTENT where to_single_byte(globalSn) =TO_SINGLE_BYTE(:1) and deleted = 0
gaqyz76td58dn SELECT COUNT(ID) FROM T_APPROVE_ACCESS WHERE approveID=:1 and StaffID=:2
gckrhq51a6757 update t_contract_content cnt set cnt.checkvendor = :1 where cnt.contractstatus in (201, 202, 209) and cnt.id in ( select corp.contractid from t_contract_corp corp where corp.corpid in ( select max(r.id) id from t_vendor_repository r where r.vendornum = :2 ) )
ggb8rzqbq0xj7 SELECT id , relationId , targetId , provinceId , createTime, extfield , businessType , deleted FROM t_template_list WHERE deleted=0 and relationId=:1 order by targetId
ggw6y1mv9x1b7 select t.ID as id, t.CONTRACTID as contractId, t.SEQ as seq, t.TYPE as type, t.CORPID as corpId, t.NAME as name, t.purId as purId, replace(t.BANK, 'N/A', '') as bank, replace(t.ACCOUNT, 'N/A', '') as account, replace(t.ACCOUNTNAME, 'N/A', '') as accountName, replace(t.LINKMAN, 'N/A', '') as linkMan, replace(t.TELEPHONE, 'N/A', '') as telephone, t.isMaster as isMaster, t.COMMENTS as comments , t.CREATOR as creator, t.DEPTID as deptId, t.CREATETIME as createTime, t.UPDATETIME as updateTime, t.DELETED as deleted, t.SelectMode as selectMode, t.PARTNERTYPE, t.COMEFROM, t.ISMASTER as isMaster, d.DAYTIME as dayTime, d.OPRNAME as oprName, d.OPRID as oprId , v.hrCode as hrCode, v.hrName as hrName, v.ISINNER as isinner, v.ouId as ouId, v.ouName as ouName, v.vendornum as vendorNum from T_CONTRACT_CORP t left join t_contract_signature d on d.bodyid=t.id left join T_VENDOR_REPOSITORY v on v.id=t.CORPID where t.CONTRACTID=:1 and t.deleted=0 and t.PROVINCEID = :2 order by t.isMaster desc, t.id desc
grwydz59pu6mc select text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 596,878 165.74 5.76
CPU used when call started 674,050 187.17 6.51
CR blocks created 6,027 1.67 0.06
Cached Commit SCN referenced 28,770 7.99 0.28
Commit SCN cached 4 0.00 0.00
DB time 1,549,610 430.29 14.97
DBWR checkpoint buffers written 87,358 24.26 0.84
DBWR checkpoints 1 0.00 0.00
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 3,710 1.03 0.04
DBWR undo block writes 11,593 3.22 0.11
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
Parallel operations not downgraded 0 0.00 0.00
RowCR - row contention 384 0.11 0.00
RowCR attempts 14,221 3.95 0.14
RowCR hits 13,792 3.83 0.13
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for undo segment recovery 1 0.00 0.00
SMON posted for undo segment shrink 35 0.01 0.00
SQL*Net roundtrips to/from client 1,702,822 472.84 16.45
SQL*Net roundtrips to/from dblink 23,384,417 6,493.36 225.86
active txn count during cleanout 5,638 1.57 0.05
application wait time 1 0.00 0.00
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 15,239 4.23 0.15
branch node splits 3 0.00 0.00
buffer is not pinned count 28,089,494 7,799.86 271.30
buffer is pinned count 37,906,790 10,525.91 366.13
bytes received via SQL*Net from client 338,588,410 94,018.80 3,270.28
bytes received via SQL*Net from dblink 5,006,886,516 1,390,305.93 48,359.36
bytes sent via SQL*Net to client 456,208,331 126,679.35 4,406.32
bytes sent via SQL*Net to dblink 4,120,432,881 1,144,156.61 39,797.49
calls to get snapshot scn: kcmgss 2,122,263 589.31 20.50
calls to kcmgas 53,951 14.98 0.52
calls to kcmgcs 10,661 2.96 0.10
change write time 390 0.11 0.00
cleanout - number of ktugct calls 13,497 3.75 0.13
cleanouts and rollbacks - consistent read gets 1,717 0.48 0.02
cleanouts only - consistent read gets 5,805 1.61 0.06
cluster key scan block gets 8,833 2.45 0.09
cluster key scans 3,341 0.93 0.03
commit batch performed 945 0.26 0.01
commit batch requested 945 0.26 0.01
commit batch/immediate performed 986 0.27 0.01
commit batch/immediate requested 986 0.27 0.01
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: buffer being written 1 0.00 0.00
commit cleanout failures: callback failure 21,391 5.94 0.21
commit cleanout failures: cannot pin 19 0.01 0.00
commit cleanouts 230,331 63.96 2.22
commit cleanouts successfully completed 208,920 58.01 2.02
commit immediate performed 41 0.01 0.00
commit immediate requested 41 0.01 0.00
commit txn count during cleanout 49,813 13.83 0.48
concurrency wait time 990 0.27 0.01
consistent changes 30,730 8.53 0.30
consistent gets 365,172,456 101,400.63 3,527.04
consistent gets - examination 18,440,024 5,120.40 178.10
consistent gets direct 8,584 2.38 0.08
consistent gets from cache 365,163,868 101,398.24 3,526.96
current blocks converted for CR 1 0.00 0.00
cursor authentications 4,919 1.37 0.05
data blocks consistent reads - undo records applied 9,537 2.65 0.09
db block changes 789,056 219.10 7.62
db block gets 1,032,601 286.73 9.97
db block gets direct 7,298 2.03 0.07
db block gets from cache 1,025,303 284.70 9.90
deferred (CURRENT) block cleanout applications 54,242 15.06 0.52
dirty buffers inspected 18 0.00 0.00
enqueue conversions 47,206,670 13,108.29 455.95
enqueue deadlocks 0 0.00 0.00
enqueue releases 1,072,013 297.68 10.35
enqueue requests 1,071,661 297.58 10.35
enqueue timeouts 0 0.00 0.00
enqueue waits 23 0.01 0.00
exchange deadlocks 3 0.00 0.00
execute count 1,111,763 308.71 10.74
failed probes on index block reclamation 5 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 211,152 58.63 2.04
free buffer requested 229,885 63.83 2.22
heap block compress 3,448 0.96 0.03
hot buffers moved to head of LRU 561,471 155.91 5.42
immediate (CR) block cleanout applications 7,522 2.09 0.07
immediate (CURRENT) block cleanout applications 17,045 4.73 0.16
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 6,018 1.67 0.06
index fast full scans (full) 28,249 7.84 0.27
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 4,550,709 1,263.64 43.95
index scans kdiixs1 7,049,356 1,957.46 68.09
leaf node 90-10 splits 268 0.07 0.00
leaf node splits 907 0.25 0.01
lob reads 5,039 1.40 0.05
lob writes 21,946 6.09 0.21
lob writes unaligned 18,740 5.20 0.18
logons cumulative 491 0.14 0.00
messages received 48,676 13.52 0.47
messages sent 48,676 13.52 0.47
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 345,658,848 95,982.11 3,338.57
opened cursors cumulative 521,353 144.77 5.04
parse count (failures) 3 0.00 0.00
parse count (hard) 10,120 2.81 0.10
parse count (total) 516,966 143.55 4.99
parse time cpu 2,392 0.66 0.02
parse time elapsed 11,054 3.07 0.11
physical read IO requests 103,766 28.81 1.00
physical read bytes 1,692,983,296 470,105.47 16,351.80
physical read total IO requests 138,769 38.53 1.34
physical read total bytes 2,553,198,592 708,968.97 24,660.25
physical read total multi block requests 48,125 13.36 0.46
physical reads 206,663 57.39 2.00
physical reads cache 200,531 55.68 1.94
physical reads cache prefetch 102,980 28.60 0.99
physical reads direct 6,132 1.70 0.06
physical reads direct (lob) 3,028 0.84 0.03
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 74,791 20.77 0.72
physical write bytes 776,478,720 215,611.63 7,499.67
physical write total IO requests 122,312 33.96 1.18
physical write total bytes 1,603,136,000 445,156.78 15,484.00
physical write total multi block requests 47,302 13.13 0.46
physical writes 94,785 26.32 0.92
physical writes direct 7,356 2.04 0.07
physical writes direct (lob) 7,262 2.02 0.07
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 87,429 24.28 0.84
physical writes non checkpoint 39,782 11.05 0.38
pinned buffers inspected 0 0.00 0.00
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 3,546 0.98 0.03
queries parallelized 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 514,024 142.73 4.96
recursive cpu usage 30,429 8.45 0.29
redo blocks written 462,429 128.41 4.47
redo buffer allocation retries 12 0.00 0.00
redo entries 452,710 125.71 4.37
redo log space requests 12 0.00 0.00
redo log space wait time 188 0.05 0.00
redo ordering marks 0 0.00 0.00
redo size 218,115,828 60,566.13 2,106.69
redo subscn max counts 10,789 3.00 0.10
redo synch time 2,816 0.78 0.03
redo synch writes 40,657 11.29 0.39
redo wastage 11,088,860 3,079.14 107.10
redo write time 2,737 0.76 0.03
redo writer latching time 8 0.00 0.00
redo writes 41,774 11.60 0.40
rollback changes - undo records applied 85 0.02 0.00
rollbacks only - consistent read gets 4,642 1.29 0.04
root node splits 0 0.00 0.00
rows fetched via callback 3,745,329 1,040.00 36.17
session connect time 0 0.00 0.00
session cursor cache hits 197,014 54.71 1.90
session logical reads 366,204,915 101,687.32 3,537.02
shared hash latch upgrades - no wait 66,403 18.44 0.64
shared hash latch upgrades - wait 625 0.17 0.01
sorts (disk) 0 0.00 0.00
sorts (memory) 665,966 184.92 6.43
sorts (rows) 92,304,314 25,630.95 891.53
sql area evicted 8,826 2.45 0.09
sql area purged 3 0.00 0.00
summed dirty queue length 18 0.00 0.00
switch current to new buffer 6,245 1.73 0.06
table fetch by rowid 26,863,772 7,459.50 259.47
table fetch continued row 241,686 67.11 2.33
table scan blocks gotten 292,734,299 81,286.09 2,827.39
table scan rows gotten 18,618,606,575 5,169,991.20 179,829.11
table scans (direct read) 0 0.00 0.00
table scans (long tables) 36 0.01 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 225,796 62.70 2.18
total number of times SMON posted 36 0.01 0.00
transaction rollbacks 986 0.27 0.01
transaction tables consistent read rollbacks 24 0.01 0.00
transaction tables consistent reads - undo records applied 1,299 0.36 0.01
undo change vector size 48,299,908 13,411.86 466.51
user I/O wait time 47,659 13.23 0.46
user calls 2,164,460 601.02 20.91
user commits 38,121 10.59 0.37
user rollbacks 65,414 18.16 0.63
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 251,325 69.79 2.43
write clones created in background 0 0.00 0.00
write clones created in foreground 3 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session pga memory max 2.1E+12 2.1E+12
session cursor cache count 27,010,181 27,014,812
session uga memory 9.2E+14 9.2E+14
opened cursors current 18,703 10,019
workarea memory allocated 1,248,766 1,226,288
logons current 1,375 816
session uga memory max 3.5E+12 3.5E+12
session pga memory 3.7E+11 3.7E+11

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 1 1.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
TS_DATA 84,300 23 3.55 1.70 38,994 11 252 5.08
TS_INDEX 17,456 5 9.44 3.52 27,078 8 179 6.98
UNDOTBS1 26 0 5.00 1.00 7,804 2 24 3.75
SYSAUX 1,965 1 1.99 1.00 780 0 0 0.00
SYSTEM 41 0 5.85 1.00 182 0 0 0.00
USERS 1 0 0.00 1.00 104 0 0 0.00
MOBILEOA_DATA 2 0 5.00 1.00 2 0 0 0.00
TEMP_CUECM 1 0 0.00 1.00 2 0 0 0.00
TS_HISTORY 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
MOBILEOA_DATA /dbfs/oradata/oradata/htdb/MOBILEOA_01.dbf 1 0 0.00 1.00 1 0 0 0.00
MOBILEOA_DATA /dbfs/oradata/oradata/htdb/MOBILEOA_02.dbf 1 0 10.00 1.00 1 0 0 0.00
SYSAUX /dbfs/oradata/oradata/htdb/sysaux01.dbf 1,098 0 2.30 1.00 613 0 0 0.00
SYSAUX /dbfs/oradata/oradata/htdb/sysaux02.dbf 867 0 1.60 1.00 167 0 0 0.00
SYSTEM /dbfs/oradata/oradata/htdb/system01.dbf 39 0 5.90 1.00 181 0 0 0.00
SYSTEM /dbfs/oradata/oradata/htdb/system02.dbf 2 0 5.00 1.00 1 0 0 0.00
TEMP_CUECM /dbfs/oradata/oradata/htdb/temp_cuecm01.dbf 1 0 0.00 1.00 2 0 0  
TS_DATA /dbfs/oradata/oradata/htdb/data01.dbf 6,694 2 2.80 2.44 895 0 16 9.38
TS_DATA /dbfs/oradata/oradata/htdb/data02.dbf 5,672 2 2.75 2.54 332 0 4 5.00
TS_DATA /dbfs/oradata/oradata/htdb/data03.dbf 3,049 1 4.24 2.27 413 0 3 3.33
TS_DATA /dbfs/oradata/oradata/htdb/data04.dbf 4,242 1 3.49 1.92 432 0 10 7.00
TS_DATA /dbfs/oradata/oradata/htdb/data05.dbf 4,712 1 2.61 2.48 428 0 4 5.00
TS_DATA /dbfs/oradata/oradata/htdb/data06.dbf 3,483 1 3.56 1.92 505 0 6 8.33
TS_DATA /dbfs/oradata/oradata/htdb/data07.dbf 4,004 1 3.46 1.83 421 0 16 4.38
TS_DATA /dbfs/oradata/oradata/htdb/data08.dbf 3,816 1 3.83 1.80 678 0 10 11.00
TS_DATA /dbfs/oradata/oradata/htdb/data09.dbf 2,769 1 3.98 1.98 368 0 5 4.00
TS_DATA /dbfs/oradata/oradata/htdb/data10.dbf 1,664 0 3.59 1.76 281 0 2 5.00
TS_DATA /dbfs/oradata/oradata/htdb/data11.dbf 1,144 0 4.75 1.49 268 0 7 5.71
TS_DATA /dbfs/oradata/oradata/htdb/data12.dbf 1,492 0 3.51 1.54 270 0 7 7.14
TS_DATA /dbfs/oradata/oradata/htdb/data13.dbf 2,622 1 4.03 1.56 384 0 6 6.67
TS_DATA /dbfs/oradata/oradata/htdb/data14.dbf 1,617 0 4.49 1.27 221 0 8 5.00
TS_DATA /dbfs/oradata/oradata/htdb/data15.dbf 1,691 0 4.57 1.24 553 0 5 10.00
TS_DATA /dbfs/oradata/oradata/htdb/data16.dbf 1,464 0 4.30 1.31 449 0 6 5.00
TS_DATA /dbfs/oradata/oradata/htdb/data17.dbf 1,659 0 4.37 1.33 272 0 14 6.43
TS_DATA /dbfs/oradata/oradata/htdb/data18.dbf 2,016 1 3.89 1.20 1,150 0 13 1.54
TS_DATA /dbfs/oradata/oradata/htdb/data19.dbf 2,216 1 3.54 1.30 1,157 0 3 3.33
TS_DATA /dbfs/oradata/oradata/htdb/data20.dbf 1,982 1 3.70 1.33 406 0 12 7.50
TS_DATA /dbfs/oradata/oradata/htdb/data21.dbf 1,610 0 4.04 1.63 439 0 8 5.00
TS_DATA /dbfs/oradata/oradata/htdb/data22.dbf 1,400 0 3.86 1.67 440 0 4 5.00
TS_DATA /dbfs/oradata/oradata/htdb/data23.dbf 1,505 0 3.20 1.47 531 0 2 10.00
TS_DATA /dbfs/oradata/oradata/htdb/data24.dbf 1,541 0 3.41 1.35 586 0 2 5.00
TS_DATA /dbfs/oradata/oradata/htdb/data25.dbf 1,386 0 3.46 1.28 680 0 4 7.50
TS_DATA /dbfs/oradata/oradata/htdb/data26.dbf 1,542 0 4.83 1.21 1,142 0 9 6.67
TS_DATA /dbfs/oradata/oradata/htdb/data27.dbf 1,241 0 4.82 1.26 934 0 1 0.00
TS_DATA /dbfs/oradata/oradata/htdb/data28.dbf 1,248 0 3.86 1.30 1,031 0 6 1.67
TS_DATA /dbfs/oradata/oradata/htdb/data29.dbf 1,331 0 4.24 1.29 585 0 0 0.00
TS_DATA /dbfs/oradata/oradata/htdb/data30.dbf 2,265 1 4.47 1.19 3,106 1 0 0.00
TS_DATA /dbfs/oradata/oradata/htdb/data31.dbf 1,035 0 5.13 1.12 4,403 1 4 2.50
TS_DATA /dbfs/oradata/oradata/htdb/data32.dbf 1,202 0 4.08 1.19 1,473 0 4 2.50
TS_DATA /dbfs/oradata/oradata/htdb/data33.dbf 528 0 6.27 1.00 1,887 1 2 5.00
TS_DATA /dbfs/oradata/oradata/htdb/data34.dbf 650 0 5.17 1.00 832 0 0 0.00
TS_DATA /dbfs/oradata/oradata/htdb/data35.dbf 517 0 6.21 1.00 585 0 0 0.00
TS_DATA /dbfs/oradata/oradata/htdb/data36.dbf 6,287 2 0.64 1.00 6,560 2 10 0.00
TS_DATA /dbfs/oradata/oradata/htdb/data37.dbf 282 0 10.11 1.00 365 0 3 3.33
TS_DATA /dbfs/oradata/oradata/htdb/data38.dbf 187 0 7.75 1.00 283 0 3 6.67
TS_DATA /dbfs/oradata/oradata/htdb/data39.dbf 171 0 9.12 1.00 372 0 19 1.58
TS_DATA /dbfs/oradata/oradata/htdb/data40.dbf 270 0 9.56 1.00 1,000 0 5 2.00
TS_DATA /dbfs/oradata/oradata/htdb/data41.dbf 56 0 12.32 1.00 1,411 0 8 0.00
TS_DATA /dbfs/oradata/oradata/htdb/data42.dbf 17 0 7.65 1.00 233 0 1 0.00
TS_DATA /dbfs/oradata/oradata/htdb/data43.dbf 19 0 7.89 1.00 200 0 0 0.00
TS_DATA /dbfs/oradata/oradata/htdb/data44.dbf 2 0 0.00 1.00 33 0 0 0.00
TS_HISTORY /dbfs/oradata/oradata/htdb/history01.dbf 1 0 0.00 1.00 1 0 0 0.00
TS_INDEX /dbfs/oradata/oradata/htdb/index01.dbf 241 0 11.24 3.88 433 0 7 5.71
TS_INDEX /dbfs/oradata/oradata/htdb/index02.dbf 4,315 1 9.93 5.69 4,747 1 17 6.47
TS_INDEX /dbfs/oradata/oradata/htdb/index03.dbf 5,121 1 9.12 5.52 3,394 1 85 6.47
TS_INDEX /dbfs/oradata/oradata/htdb/index04.dbf 4,628 1 9.37 1.00 10,313 3 30 9.67
TS_INDEX /dbfs/oradata/oradata/htdb/index05.dbf 3,151 1 9.28 1.00 8,191 2 40 6.50
UNDOTBS1 /dbfs/oradata/oradata/htdb/undotbs01.dbf 26 0 5.00 1.00 7,804 2 24 3.75
USERS /dbfs/oradata/oradata/htdb/users01.dbf 1 0 0.00 1.00 104 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 5,986,418 100 366,265,837 200,516 87,457 0 0 455


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual Redo Blks Target Redo Blks Log File Size Redo Blks Log Ckpt Timeout Redo Blks Log Ckpt Interval Redo Blks
B 0 16 13011 83571 386011 3774870 386011  
E 0 12 5986 34253 184029 3774870 184029  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

P Size for Est (M) Size Factor Buffers for Estimate Est Phys Read Factor Estimated Physical Reads
D 4,832 0.10 597,658 7.52 1.3E+11
D 9,664 0.20 1,195,316 3.90 69,343,177,770
D 14,496 0.30 1,792,974 2.15 38,285,605,435
D 19,328 0.40 2,390,632 1.46 26,037,782,528
D 24,160 0.50 2,988,290 1.21 21,468,866,904
D 28,992 0.60 3,585,948 1.11 19,707,069,136
D 33,824 0.70 4,183,606 1.06 18,839,264,534
D 38,656 0.80 4,781,264 1.03 18,328,876,227
D 43,488 0.90 5,378,922 1.01 18,007,194,955
D 48,320 1.00 5,976,580 1.00 17,786,090,059
D 48,400 1.00 5,986,475 1.00 17,782,478,046
D 53,152 1.10 6,574,238 0.99 17,632,399,489
D 57,984 1.20 7,171,896 0.99 17,524,125,990
D 62,816 1.30 7,769,554 0.98 17,445,237,028
D 67,648 1.40 8,367,212 0.98 17,387,506,905
D 72,480 1.50 8,964,870 0.97 17,333,842,177
D 77,312 1.60 9,562,528 0.97 17,260,449,554
D 82,144 1.70 10,160,186 0.96 17,111,059,322
D 86,976 1.80 10,757,844 0.94 16,784,406,572
D 91,808 1.90 11,355,502 0.91 16,161,028,656
D 96,640 2.00 11,953,160 0.85 15,127,907,878

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 21,431 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M) Auto PGA Target(M) PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem %Auto W/A Mem %Man W/A Mem Global Mem Bound(K)
B 16,384 10,778 7,145.39 1,213.99 16.99 100.00 0.00 1,048,576
E 16,384 12,640 4,241.21 1,194.07 28.15 100.00 0.00 1,048,576

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 229,672 229,672 0 0
64K 128K 1,679 1,679 0 0
128K 256K 644 644 0 0
256K 512K 329 329 0 0
512K 1024K 15,835 15,835 0 0
1M 2M 2,977 2,977 0 0
2M 4M 87 87 0 0
4M 8M 105 105 0 0
8M 16M 5 5 0 0
64M 128M 4 4 0 0
128M 256M 10 10 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
2,048 0.13 70,707,652.90 5,432,152.79 93.00 29,588
4,096 0.25 70,707,652.90 4,296,582.43 94.00 7,507
8,192 0.50 70,707,652.90 3,616,354.80 95.00 2,363
12,288 0.75 70,707,652.90 3,549,508.22 95.00 1,450
16,384 1.00 70,707,652.90 582,719.50 99.00 859
19,661 1.20 70,707,652.90 474,475.82 99.00 500
22,938 1.40 70,707,652.90 473,821.57 99.00 59
26,214 1.60 70,707,652.90 473,722.83 99.00 0
29,491 1.80 70,707,652.90 473,722.83 99.00 0
32,768 2.00 70,707,652.90 473,722.83 99.00 0
49,152 3.00 70,707,652.90 473,722.83 99.00 0
65,536 4.00 70,707,652.90 473,722.83 99.00 0
98,304 6.00 70,707,652.90 473,722.83 99.00 0
131,072 8.00 70,707,652.90 473,722.83 99.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits (K)
1,104 0.28 420 19,690 36,121,716 0.99 1,933,298 1.33 1,178,013
1,504 0.39 814 26,208 36,248,863 0.99 1,806,151 1.24 1,183,158
1,904 0.49 1,210 32,920 36,355,929 0.99 1,699,085 1.17 1,187,523
2,304 0.59 1,607 39,366 36,435,512 1.00 1,619,502 1.12 1,191,006
2,704 0.69 2,005 45,781 36,496,213 1.00 1,558,801 1.07 1,193,717
3,104 0.80 2,403 52,477 36,542,721 1.00 1,512,293 1.04 1,195,841
3,504 0.90 2,802 59,097 36,577,408 1.00 1,477,606 1.02 1,197,510
3,904 1.00 3,201 65,402 36,603,832 1.00 1,451,182 1.00 1,198,830
4,304 1.10 3,599 72,285 36,624,111 1.00 1,430,903 0.99 1,199,885
4,704 1.20 3,997 78,937 36,639,961 1.00 1,415,053 0.98 1,200,740
5,104 1.31 4,396 85,637 36,652,589 1.00 1,402,425 0.97 1,201,444
5,504 1.41 4,794 92,303 36,662,842 1.00 1,392,172 0.96 1,202,033
5,904 1.51 5,193 98,690 36,671,326 1.00 1,383,688 0.95 1,202,534
6,304 1.61 5,590 104,876 36,678,478 1.00 1,376,536 0.95 1,202,968
6,704 1.72 5,989 111,225 36,684,612 1.00 1,370,402 0.94 1,203,348
7,104 1.82 6,388 117,805 36,689,950 1.00 1,365,064 0.94 1,203,687
7,504 1.92 6,787 124,315 36,694,660 1.00 1,360,354 0.94 1,203,992
7,904 2.02 7,186 130,655 36,698,927 1.00 1,356,087 0.93 1,204,274

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M) SGA Size Factor Est DB Time (s) Est Physical Reads
13,108 0.25 100,545,688 69,342,772,793
26,216 0.50 51,273,146 21,468,785,637
39,324 0.75 48,094,882 18,328,400,030
52,432 1.00 47,295,581 17,782,477,957
65,540 1.25 46,955,059 17,444,610,876
78,648 1.50 46,789,525 17,259,673,105
91,756 1.75 45,692,268 16,160,715,967
104,864 2.00 45,370,658 15,127,553,998

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB) Size Factor Est Spill Count Est Spill Time (s) Est Unspill Count Est Unspill Time (s)
16 0.50 0 0 0 0
32 1.00 0 0 0 0
48 1.50 0 0 0 0
64 2.00 0 0 0 0
80 2.50 0 0 0 0
96 3.00 0 0 0 0
112 3.50 0 0 0 0
128 4.00 0 0 0 0
144 4.50 0 0 0 0
160 5.00 0 0 0 0
176 5.50 0 0 0 0
192 6.00 0 0 0 0
208 6.50 0 0 0 0
224 7.00 0 0 0 0
240 7.50 0 0 0 0
256 8.00 0 0 0 0
272 8.50 0 0 0 0
288 9.00 0 0 0 0
304 9.50 0 0 0 0
320 10.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 431 3 6
undo header 23 0 4
undo block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
CF-Controlfile Transaction 2,601 2,601 0 1 0 260.00
HW-Segment High Water Mark 5,705 5,705 0 13 0 7.85
TX-Transaction (index contention) 96 96 0 9 0 3.44

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 8.81 46,811 10,447 537 720/720 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
14-10ÔÂ 12:53 933 5,292 10,447 193 720 0/0 0/0/0/0/0/0
14-10ÔÂ 12:43 846 4,761 9,846 201 720 0/0 0/0/0/0/0/0
14-10ÔÂ 12:33 907 5,341 9,245 193 720 0/0 0/0/0/0/0/0
14-10ÔÂ 12:23 1,524 8,872 8,644 479 720 0/0 0/0/0/0/0/0
14-10ÔÂ 12:13 1,709 9,844 8,044 522 720 0/0 0/0/0/0/0/0
14-10ÔÂ 12:03 2,892 12,701 7,443 537 720 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM db client latch 2,663 0.00   0 0  
AWR Alerted Metric Element list 79,314 0.00   0 0  
Consistent RBA 41,782 0.00   0 0  
FAL request queue 142 0.00   0 0  
FAL subheap alocation 142 0.00   0 0  
FIB s.o chain latch 16 0.00   0 0  
FOB s.o list latch 12,466 0.12 0.00 0 0  
JS mem alloc latch 17 0.00   0 0  
JS queue access latch 17 0.00   0 0  
JS queue state obj latch 26,080 0.00   0 0  
JS slv state obj latch 1,105 0.00   0 0  
KMG MMAN ready and startup request latch 1,198 0.00   0 0  
KMG resize request state object freelist 2 0.00   0 0  
KTF sga latch 4,619 0.00   0 1,194 0.00
KWQMN job cache list latch 33 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
LGWR NS Write 728 0.00   0 0  
MQL Tracking Latch 0     0 70 0.00
Memory Management Latch 21 0.00   0 1,198 0.00
OS process 3,132 0.00   0 0  
OS process allocation 2,729 0.00   0 0  
OS process: request allocation 1,417 0.00   0 0  
PL/SQL warning settings 632 0.00   0 0  
SGA IO buffer pool latch 5,271 0.00   0 5,271 0.00
SQL memory manager latch 1 0.00   0 1,198 0.00
SQL memory manager workarea list latch 231,576 0.00 0.00 0 0  
Shared B-Tree 132 0.00   0 0  
active checkpoint queue latch 9,587 0.00   0 0  
active service list 10,034 0.04 0.00 0 2,392 0.00
alert log latch 5 0.00   0 0  
archive control 172 0.00   0 0  
archive process latch 1,483 0.00   0 0  
begin backup scn array 6,291 0.00   0 0  
buffer pool 6 0.00   0 0  
cache buffer handles 1,658,123 0.06 0.00 0 0  
cache buffers chains 717,327,667 0.55 0.00 0 1,047,517 0.00
cache buffers lru chain 207,356 0.02 0.00 0 1,777,757 0.01
cache table scan latch 0     0 20,676 0.00
channel handle pool latch 1,417 0.00   0 0  
channel operations parent latch 19,868 0.00   0 0  
checkpoint queue latch 554,841 0.00 0.00 0 90,288 0.00
client/application info 3,589 0.00   0 0  
commit callback allocation 12 0.00   0 0  
compile environment latch 491 0.00   0 0  
dml lock allocation 174,265 0.02 0.00 0 0  
dummy allocation 1,541 0.06 0.00 0 0  
enqueue hash chains 49,420,302 0.01 0.00 0 0  
enqueues 2,086,562 0.07 0.00 0 0  
event group latch 429 0.00   0 0  
file cache latch 650 0.00   0 0  
global KZLD latch for mem in SGA 399 0.00   0 0  
global tx hash mapping 515,638 0.00 0.00 0 0  
hash table column usage latch 591 0.00   0 3,177,733 0.00
hash table modification latch 178 0.00   0 0  
interrupt manipulation 4 0.00   0 0  
job workq parent latch 0     0 124 0.00
job_queue_processes parameter latch 122 0.00   0 0  
kks stats 63,879 0.01 0.13 0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 4,736 0.00   0 0  
ksuosstats global area 242 0.00   0 0  
ktm global data 112 0.00   0 0  
kwqbsn:qsga 131 0.00   0 0  
lgwr LWN SCN 44,180 0.90 0.00 0 0  
library cache 2,754,560 0.01 0.23 1 36,517 0.07
library cache load lock 1,278 0.00   0 0  
library cache lock 4,440,776 0.00 0.00 0 0  
library cache lock allocation 38,862 0.00   0 0  
library cache pin 697,245 0.00 0.00 0 0  
library cache pin allocation 14,376 0.00   0 0  
list of block allocation 3,470 0.00   0 0  
loader state object freelist 24,426 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 3,881 0.00   0 14 0.00
messages 175,231 0.01 0.00 0 0  
mostly latch-free SCN 46,166 4.91 0.00 0 0  
multiblock read objects 106,876 0.00   0 3 0.00
ncodef allocation latch 58 0.00   0 0  
object queue header heap 4,544 0.00   0 5,020 0.00
object queue header operation 728,499 0.00 0.00 0 9,880 0.01
object stats modification 1 0.00   0 1 0.00
parallel query alloc buffer 480 0.00   0 0  
parameter list 71 0.00   0 0  
parameter table management 1,545 0.00   0 0  
post/wait queue 61,104 0.00 0.00 0 40,747 0.00
process allocation 1,417 0.00   0 429 0.00
process group creation 1,417 0.00   0 0  
qmn task queue latch 940 16.81 0.00 0 0  
redo allocation 130,062 0.02 0.15 0 452,873 0.03
redo copy 0     0 452,934 0.15
redo writing 137,625 0.00 0.00 0 0  
resmgr group change latch 707 0.00   0 0  
resmgr:active threads 1,526 0.00   0 0  
resmgr:actses change group 463 0.00   0 0  
resmgr:free threads list 1,525 0.00   0 0  
resmgr:resource group CPU method 1,022 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 127,331,731 3.48 0.00 0 709 0.00
rules engine rule set statistics 100 0.00   0 0  
sequence cache 100,011 0.00 0.00 0 0  
session allocation 402,772 0.02 0.07 0 0  
session idle bit 4,535,686 0.00 0.00 0 0  
session state list latch 1,008 0.00   0 0  
session switching 4,998 0.00   0 0  
session timer 1,218 0.00   0 0  
shared pool 1,001,960 0.02 0.56 2 0  
shared pool simulator 81,531 0.00   0 0  
simulator hash latch 22,858,486 0.00 0.00 0 0  
simulator lru latch 88,298 0.09 0.00 0 22,667,464 0.92
slave class 8 0.00   0 0  
slave class create 32 3.13 1.00 0 0  
sort extent pool 467 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 448 0.00   0 0  
temp lob duration state obj allocation 155 0.00   0 0  
threshold alerts latch 292 0.00   0 0  
transaction allocation 9,879 0.00   0 0  
transaction branch allocation 510,103 0.01 0.00 0 0  
undo global data 298,593 0.01 0.00 0 0  
user lock 2,840 0.18 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
row cache objects 127,331,731 4,429,203 126 4,429,080 0 0 0
cache buffers chains 717,327,667 3,955,504 1,512 3,954,038 0 0 0
enqueue hash chains 49,420,302 3,943 2 3,941 0 0 0
enqueues 2,086,562 1,542 4 1,538 0 0 0
library cache 2,754,560 346 78 271 0 0 0
shared pool 1,001,960 225 127 98 0 0 0
session allocation 402,772 67 5 62 0 0 0
redo allocation 130,062 26 4 22 0 0 0
kks stats 63,879 8 1 7 0 0 0
slave class create 32 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
active service list kswslogon: session logout 0 2 1
cache buffers chains kcbgtcr: kslbegin excl 0 3,004 2,540
cache buffers chains kcbrls: kslbegin 0 269 742
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 66 49
cache buffers chains kcbgtcr: kslbegin shared 0 11 7
cache buffers chains kcbgtcr: fast path 0 4 4
cache buffers chains kcbgcur: kslbegin 0 1 2
cache buffers chains kcbget: pin buffer 0 1 0
enqueue hash chains ksqcnl 0 2 1
enqueues ksqgel: create enqueue 0 2 4
enqueues ksqdel 0 1 0
enqueues ksqies 0 1 0
kks stats kks stats alloc/free 0 1 1
library cache kgldti: 2child 0 4 0
library cache kglhdgn: child: 0 4 45
library cache kglobpn: child: 0 4 9
library cache kglpndl: child: after processing 0 4 0
library cache kglic 0 2 0
library cache kglLockCursor 0 1 5
library cache kglScanDependency 0 1 0
library cache kglobld 0 1 0
library cache kglpnp: child 0 1 5
library cache kglukp: child 0 1 1
library cache lock kgllkdl: child: no lock handle 0 4 2
redo allocation kcrfw_redo_gen: redo allocation 3 0 3 2
redo allocation kcrfw_redo_gen: redo allocation 2 0 1 0
row cache objects kqreqd: reget 0 98 2
row cache objects kqrpre: find obj 0 20 103
row cache objects kqreqd 0 7 21
row cache objects kqrso 0 1 0
session allocation kspallmod 0 2 0
session allocation ksuxds: KSUSFCLC not set 0 2 2
session allocation ksucri 0 1 3
shared pool kghalo 0 113 36
shared pool kghfrunp: clatch: nowait 0 51 0
shared pool kghupr1 0 6 55
shared pool kghfre 0 3 20
shared pool kghfrunp: alloc: wait 0 3 0
shared pool kghalp 0 2 13
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
CUECM TS_DATA T_CLOUD_READING   TABLE 44,536,576 12.16
CUECM TS_DATA T_RULE_INSTANCE   TABLE 40,161,936 10.97
CUECM TS_DATA T_APPROVEBATCH_COMMENTS   TABLE 21,346,880 5.83
CUECM TS_DATA T_VENDOR_REPOSITORY VALID TABLE PARTITION 18,887,936 5.16
CUECM USERS T_MSG_MAILRECEIVER   TABLE 15,037,024 4.11

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
CUECM TS_INDEX INDEX_PENDING   INDEX 48,055 23.25
CUECM TS_DATA T_APPROVE_PROCESS   TABLE 30,134 14.58
CUECM TS_DATA T_CLOUD_PENDING   TABLE 8,796 4.26
CUECM TS_DATA T_APPROVE_AFFAIR   TABLE 4,064 1.97
CUECM TS_INDEX INX_CLOUDPEND_ID   INDEX 2,450 1.19

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
CUECM TS_DATA IDX_CONTRACT_ORDER   INDEX 41 25.31
CUECM TS_INDEX INX_CORDER_PID   INDEX 15 9.26
CUECM TS_INDEX IDX_CONTRACT_TAKERIDN   INDEX 13 8.02
CUECM TS_INDEX INX_MONEY_CHANGED   INDEX 12 7.41
CUECM TS_INDEX INX_APPROVELOG_PROFID   INDEX 8 4.94

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
CUECM TS_DATA IDX_0610_08   INDEX 2 66.67
CUECM TS_DATA UQPC_APPROVE_NOTIFY   INDEX 1 33.33

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
CUECM TS_DATA T_INTERFACE_LOGS   TABLE 12 25.53
CUECM TS_DATA T_RULE_INSTANCE   TABLE 10 21.28
CUECM TS_DATA T_CLOUD_PENDING   TABLE 8 17.02
CUECM TS_DATA IDX_INTERFACELOGS_BATCHID   INDEX 7 14.89
CUECM TS_DATA IDX_0610_09   INDEX 5 10.64

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 65 0.00 0   2 1
dc_database_links 36,946,602 0.00 0   0 3
dc_files 1,566 0.00 0   0 58
dc_global_oids 2,717 0.33 0   0 78
dc_histogram_data 1,491,689 0.14 0   0 15,332
dc_histogram_defs 734,915 0.17 0   0 5,106
dc_object_ids 2,981,462 0.00 0   0 1,138
dc_objects 56,758 0.23 0   5 617
dc_profiles 798 0.00 0   0 2
dc_rollback_segments 12,986 0.00 0   0 617
dc_segments 260,895 0.10 0   7 777
dc_sequences 51 3.92 0   51 5
dc_tablespace_quotas 3 0.00 0   0 1
dc_tablespaces 355,632 0.00 0   0 11
dc_usernames 2,167 1.38 0   0 43
dc_users 580,526 0.00 0   0 77
outstanding_alerts 112 0.00 0   0 20


Back to Top

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 1,475 0.27 26,388 0.03 4 0
CLUSTER 30 0.00 48 0.00 0 0
INDEX 55,194 0.02 63,624 0.02 0 0
SQL AREA 315,965 5.87 1,207,331 2.45 915 85
TABLE/PROCEDURE 6,211 2.72 224,510 0.26 194 0
TRIGGER 5,037 0.00 19,118 0.01 1 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 4,875.74   3.54 42.04 982 982 1,378 1,378
  SQL 1,319.44 1,277.36 0.97 31.48 1,155 1,188 1,357 1,109
  Freeable 970.88 0.00 0.92 0.28 6   1,057 1,057
  PL/SQL 33.59 23.74 0.02 0.02 0 0 1,376 1,376
E Other 2,495.11   3.05 30.06 614 709 819 819
  SQL 1,229.19 1,204.88 1.54 40.92 1,155 1,188 798 565
  Freeable 502.00 0.00 0.90 0.35 6   559 559
  PL/SQL 18.67 12.38 0.02 0.02 0 0 817 817

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 50,834,964,480 50,751,078,400
Fixed Size 2,198,928  
Redo Buffers 14,577,664  
Variable Size 4,127,195,760 4,211,081,840

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 32.00 32.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 62.97 62.97 0.00
shared ASH buffers 50.00 50.00 0.00
shared CCursor 141.13 148.78 5.42
shared PCursor 95.45 99.09 3.81
shared db_block_hash_buckets 360.00 360.00 0.00
shared free memory 975.33 977.78 0.25
shared kglsim object batch 45.93 45.93 0.00
shared library cache 121.34 123.79 2.02
shared sql area 1,647.78 1,725.08 4.69
streams Sender info 2.03 2.03 0.00
streams free memory 31.72 31.72 0.00
  buffer_cache 48,480.00 48,400.00 -0.17
  fixed_sga 2.10 2.10 0.00
  log_buffer 13.90 13.90 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type CPU Time User I/O Time Sys I/O Time
QMON Slaves 120,000 8,985 0
QMON Coordinator 70,000 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset Name Evals Fast Evals SQL Execs CPU Time Elapsed Time
SYS.ALERT_QUE_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource Name Current Utilization Maximum Utilization Initial Allocation Limit
processes 820 1,500 1500 1500
sessions 833 1,655 1655 1655


Back to Top

init.ora Parameters

Parameter Name Begin value End value (if different)
audit_file_dest /dbfs/oradata/admin/htdb/adump   
audit_sys_operations TRUE   
audit_trail DB, EXTENDED   
background_dump_dest /dbfs/oradata/admin/htdb/bdump   
compatible 10.2.0.5.0   
control_files /dbfs/oradata/oradata/htdb/control01.ctl, /dbfs/oradata/oradata/htdb/control02.ctl, /dbfs/oradata/oradata/htdb/control03.ctl   
core_dump_dest /dbfs/oradata/admin/htdb/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name htdb   
db_recovery_file_dest      
db_recovery_file_dest_size 161061273600   
dispatchers (PROTOCOL=TCP) (SERVICE=htdbXDB)   
job_queue_processes 10   
log_archive_config DG_CONFIG=(htdb, htsdb)   
log_archive_dest_1 location=/dbfs/archive VALID_FOR=(ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=htdb   
log_archive_dest_2 SERVICE=htsdb LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=htsdb   
log_archive_dest_state_2 ENABLE   
log_archive_max_processes 8   
open_cursors 800   
open_links 20   
pga_aggregate_target 17179869184   
processes 1500   
remote_login_passwordfile EXCLUSIVE   
sessions 1655   
sga_target 54978936832   
streams_pool_size 33554432   
undo_management AUTO   
undo_retention 43200   
undo_tablespace UNDOTBS1   
user_dump_dest /dbfs/oradata/admin/htdb/udump   


Back to Top

End of Report