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: 25445 14-10ÔÂ-13 11:00:43 770 13.7
End Snap: 25446 14-10ÔÂ-13 12:00:15 1375 13.6
Elapsed:   59.53 (mins)    
DB Time:   13,515.48 (mins)    

Report Summary

Cache Sizes

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

Load Profile

Per Second Per Transaction
Redo size: 123,893.50 1,695.31
Logical reads: 322,826.86 4,417.42
Block changes: 504.63 6.91
Physical reads: 465.85 6.37
Physical writes: 1,503.40 20.57
User calls: 1,656.11 22.66
Parses: 404.60 5.54
Hard parses: 10.33 0.14
Sorts: 702.19 9.61
Logons: 0.70 0.01
Executes: 850.25 11.63
Transactions: 73.08  

% Blocks changed per Read: 0.16 Recursive Call %: 19.75
Rollback per transaction %: 70.88 Rows per Sort: 127.72

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97 Redo NoWait %: 100.00
Buffer Hit %: 99.87 In-memory Sort %: 100.00
Library Hit %: 97.56 Soft Parse %: 97.45
Execute to Parse %: 52.41 Latch Hit %: 96.76
Parse CPU to Parse Elapsd %: 0.19 % Non-Parse CPU: 96.32

Shared Pool Statistics

Begin End
Memory Usage %: 73.04 74.39
% SQL with executions>1: 78.10 78.25
% Memory for SQL w/exec>1: 70.02 73.03

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
latch: library cache 1,720,202 469,227 273 57.9 Concurrency
cursor: pin S wait on X 14,721,210 144,334 10 17.8 Concurrency
SQL*Net message from dblink 141,862,444 51,546 0 6.4 Network
CPU time   23,607   2.9  
latch: shared pool 99,904 20,465 205 2.5 Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
parse time elapsed 531,181.76 65.50
sql execute elapsed time 309,737.71 38.20
hard parse elapsed time 165,823.47 20.45
DB CPU 23,607.31 2.91
failed parse elapsed time 21,974.59 2.71
connection management call elapsed time 9,413.65 1.16
PL/SQL execution elapsed time 4,074.91 0.50
hard parse (sharing criteria) elapsed time 3,346.50 0.41
hard parse (bind mismatch) elapsed time 1,587.47 0.20
PL/SQL compilation elapsed time 77.18 0.01
sequence load elapsed time 33.71 0.00
repeated bind elapsed time 1.96 0.00
DB time 810,928.83  
background elapsed time 3,749.68  
background cpu time 58.30  

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
Concurrency 51,275,326 29 639,408 12 78.85
Network 288,852,719   52,159 0 6.43
CPU time     23,607   2.91
Other 102,473,019 12 15,805 0 1.95
User I/O 1,197,937 0 6,005 5 0.74
Application 12,597 2 712 57 0.09
Commit 89,149 3 376 4 0.05
System I/O 179,993   339 2 0.04
Configuration 152 3 49 325 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
latch: library cache 1,720,202   469,227 273 6.59
cursor: pin S wait on X 14,721,210 100 144,334 10 56.40
SQL*Net message from dblink 141,862,444   51,546 0 543.49
latch: shared pool 99,904   20,465 205 0.38
latch free 41,643 0 7,154 172 0.16
enq: US - contention 6,939 13 5,097 735 0.03
latch: session allocation 9,649   2,450 254 0.04
db file sequential read 361,999   2,000 6 1.39
buffer busy waits 9,087 7 1,707 188 0.03
db file scattered read 154,875   1,680 11 0.59
latch: cache buffers chains 99,528   1,252 13 0.38
latch: row cache objects 126,545   1,149 9 0.48
read by other session 289,304 0 1,149 4 1.11
row cache lock 3,234 4 1,068 330 0.01
direct path write temp 336,659   783 2 1.29
enq: TX - row lock contention 243 82 619 2546 0.00
SQL*Net more data from dblink 293,435   514 2 1.12
log file sync 89,149 3 376 4 0.34
kksfbc child completion 7,668 100 374 49 0.03
local write wait 30,875 0 355 11 0.12
latch: cache buffer handles 1,269   272 215 0.00
db file parallel write 34,745   243 7 0.13
enq: JD - contention 42 95 121 2871 0.00
os thread startup 127 65 95 745 0.00
SQL*Net break/reset to client 12,330   93 8 0.05
SQL*Net message to dblink 141,861,376   70 0 543.49
log file parallel write 86,647   70 1 0.33
cursor: pin S 90,389,920   62 0 346.30
cursor: pin X 6,174 100 61 10 0.02
latch: redo allocation 308   42 136 0.00
library cache load lock 17 71 41 2387 0.00
enq: TH - metric threshold evaluation 14 93 40 2857 0.00
latch: library cache lock 317   37 116 0.00
LGWR wait for redo copy 4,397 65 29 7 0.02
latch: enqueue hash chains 2,620   26 10 0.01
enq: HW - contention 94   25 270 0.00
direct path read temp 3,456   24 7 0.01
enq: SQ - contention 38 5 22 584 0.00
enq: TX - contention 10 60 22 2179 0.00
log file sequential read 50,808   22 0 0.19
ksdxexeotherwait 12,001,850 100 15 0 45.98
latch: cache buffers lru chain 85   14 169 0.00
cursor: mutex S 20,641,785   14 0 79.08
cursor: mutex X 13,853,121   13 0 53.07
latch: object queue header operation 72   12 170 0.00
direct path sync 8,283   12 1 0.03
LNS wait on SENDREQ 290   9 32 0.00
SQL*Net more data from client 100,794   9 0 0.39
SQL*Net message to client 4,644,073   8 0 17.79
enq: TX - index contention 244   7 27 0.00
Streams AQ: qmn coordinator waiting for slave to start 2 50 5 2443 0.00
wait list latch free 90   3 38 0.00
latch: checkpoint queue latch 15   3 201 0.00
control file sequential read 6,114   3 0 0.02
control file parallel write 1,679   2 1 0.01
latch: redo writing 15   2 109 0.00
SQL*Net more data to client 73,092   2 0 0.28
direct path write 8,396   2 0 0.03
latch: undo global data 21   1 62 0.00
db file parallel read 42   1 21 0.00
direct path read 4,048   1 0 0.02
latch: messages 6   1 123 0.00
SQL*Net more data to dblink 17,215   0 0 0.07
undo segment extension 4 50 0 49 0.00
rdbms ipc reply 187   0 0 0.00
SQL*Net break/reset to dblink 24   0 0 0.00
log buffer space 1   0 1 0.00
latch: library cache pin 5   0 0 0.00
buffer deadlock 38 100 0 0 0.00
SQL*Net message from client 4,646,998   1,491,993 321 17.80
Streams AQ: qmn slave idle wait 202 2 4,563 22589 0.00
virtual circuit status 118 100 3,486 29538 0.00
LNS ASYNC end of log 352,192 100 3,450 10 1.35
Streams AQ: qmn coordinator idle wait 382 35 3,441 9007 0.00
jobq slave wait 1,109 97 3,226 2909 0.00
Streams AQ: waiting for time management or cleanup tasks 7 71 937 133916 0.00
single-task message 1,067   234 219 0.00
class slave wait 13   0 8 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
latch: library cache 2,913   793 272 0.01
db file parallel write 34,745   243 7 0.13
events in waitclass Other 5,075 57 226 45 0.02
latch: shared pool 885   197 222 0.00
os thread startup 127 65 95 745 0.00
log file parallel write 86,656   70 1 0.33
row cache lock 81   19 232 0.00
log file sequential read 49,549   14 0 0.19
latch: row cache objects 55   10 185 0.00
LNS wait on SENDREQ 290   9 32 0.00
buffer busy waits 45   3 72 0.00
control file sequential read 5,689   2 0 0.02
control file parallel write 1,679   2 1 0.01
latch: redo writing 15   2 109 0.00
latch: cache buffers chains 12   1 69 0.00
direct path read 76   0 0 0.00
direct path write 58   0 0 0.00
rdbms ipc message 131,578 11 64,940 494 0.50
Streams AQ: qmn slave idle wait 202 2 4,563 22589 0.00
pmon timer 1,508 85 3,473 2303 0.01
LNS ASYNC end of log 352,198 100 3,450 10 1.35
Streams AQ: qmn coordinator idle wait 382 35 3,441 9007 0.00
smon timer 280 2 3,049 10890 0.00
class slave wait 1   0 95 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 99,600
AVG_IDLE_TIME 257,721
AVG_IOWAIT_TIME 103,504
AVG_SYS_TIME 22,145
AVG_USER_TIME 77,331
BUSY_TIME 3,190,592
IDLE_TIME 8,250,677
IOWAIT_TIME 3,315,800
SYS_TIME 712,383
USER_TIME 2,478,209
LOAD 5
OS_CPU_WAIT_TIME 3,603,000
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 29,518,336,000
VM_OUT_BYTES 59,131,465,728
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 807,850.50 23,511.10 719,571 1,150,670,802
htdb 3,148.30 101.70 943,742 1,932,216
SYS$BACKGROUND 0.00 0.00 536 254,799
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 1116289 5055 51220450 624166 0 0 288837273 52148
htdb 80786 947 4113 850 0 0 4869 0
SYS$BACKGROUND 873 2 4349 1175 0 0 290 9

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
66,172 5,306 21 3151.05 8.16 8tzz6w3889pu7   select count(*) from (select r...
17,082 27 2,469 6.92 2.11 ct39f2cm4k7nw   select id, pid, seq, funcname,...
16,105 3 10,887 1.48 1.99 3wu60f31s55y5   select o.id, o.orgName, o.hrCo...
16,079 4 6,720 2.39 1.98 49sbrh7cvcf2z   select t.hastemplate from t_co...
10,559 2 8,170 1.29 1.30 g7mw3ydv5ax9g   SELECT c.id as id, c.fieldno a...
8,128 105 10,958 0.74 1.00 9zryarq7p3x30   select distinct(id) from T_UAM...
6,230 610 2,613 2.38 0.77 35b3cs58d15aa   select t.id as id, t.affairId ...
5,279 2 24,076 0.22 0.65 grwydz59pu6mc   select text from view$ where r...
5,246 1 1,701 3.08 0.65 04jwf5mx1n5nd   select ID, CONTRACTID, MONEYTY...
5,173 1 9,202 0.56 0.64 56yjja3g02qtc   select id, processDefId, actDe...

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
5,306 66,172 21 252.67 22.48 8.16 8tzz6w3889pu7   select count(*) from (select r...
1,149 2,239 612 1.88 4.87 0.28 g6qdf8b80sg7y   select id from T_CONTRACT_CONT...
741 1,283 5,521 0.13 3.14 0.16 1b90jf6ad9q7c   select count(*) from T_MSG_Use...
610 6,230 2,613 0.23 2.58 0.77 35b3cs58d15aa   select t.id as id, t.affairId ...
590 1,215 916 0.64 2.50 0.15 7tv0gpd6r6ry0   insert into T_RULE_INSTANCE(ID...
483 699 786 0.61 2.05 0.09 akz2wnkz1mmkh   select ID , RULEID, SN, CURREN...
442 4,403 87 5.08 1.87 0.54 dj9cqfrmvgfa0   select a.id as id , a.affairId...
438 837 2,573 0.17 1.85 0.10 56bynvhuns08a   select t.id as id, t.affairId ...
387 3,496 0   1.64 0.43 8pmax79k781p7   select count(*) from (select r...
353 922 432 0.82 1.50 0.11 1rpx65rvf7hd6   select l.* from T_APPROVE_LOG ...
320 639 2,454 0.13 1.36 0.08 19k07g153405z   select * from ( select r.id, m...
300 2,640 1,486 0.20 1.27 0.33 2g01qvjauajsy   UPDATE T_CONTRACT_CONTENT SET ...
298 1,155 373 0.80 1.26 0.14 32qm4hssp9chn   UPDATE T_REPORT_STATUSCHANGE S...
275 445 2,949 0.09 1.16 0.05 b7pguzqb199u2   select PREBILLID prebillid, PR...
264 982 21 12.58 1.12 0.12 3y8azvq7nxaun   select * from ( select p.orgou...
256 1,488 260 0.98 1.08 0.18 ah2hgzyr5ygy8   select contract.lastApproverNa...

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
94,595,011 21 4,504,524.33 8.20 5305.99 66171.96 8tzz6w3889pu7   select count(*) from (select r...
78,400,098 2,613 30,003.86 6.80 609.68 6230.45 35b3cs58d15aa   select t.id as id, t.affairId ...
76,999,605 2,573 29,926.00 6.68 437.75 837.47 56bynvhuns08a   select t.id as id, t.affairId ...
63,875,191 87 734,197.60 5.54 441.95 4403.23 dj9cqfrmvgfa0   select a.id as id , a.affairId...
50,457,325 916 55,084.42 4.38 590.44 1214.64 7tv0gpd6r6ry0   insert into T_RULE_INSTANCE(ID...
45,204,176 5,521 8,187.68 3.92 740.88 1282.70 1b90jf6ad9q7c   select count(*) from T_MSG_Use...
43,294,412 786 55,081.95 3.75 483.38 699.46 akz2wnkz1mmkh   select ID , RULEID, SN, CURREN...
30,706,830 612 50,174.56 2.66 1148.90 2239.23 g6qdf8b80sg7y   select id from T_CONTRACT_CONT...
25,591,910 86 297,580.35 2.22 169.45 782.80 9fyztfympp6gx   select a.id as id , a.affairId...
24,110,050 30,284 796.13 2.09 97.20 417.41 ggb8rzqbq0xj7   SELECT id , relationId , targe...
23,290,680 916 25,426.51 2.02 217.78 278.58 bsjgcnt113f44   select t.DEPTID as deptId, t.D...
22,541,449 1,486 15,169.21 1.95 299.55 2640.09 2g01qvjauajsy   UPDATE T_CONTRACT_CONTENT SET ...
22,376,262 373 59,989.98 1.94 297.86 1154.73 32qm4hssp9chn   UPDATE T_REPORT_STATUSCHANGE S...
20,594,243 2,454 8,392.11 1.79 320.49 638.87 19k07g153405z   select * from ( select r.id, m...
14,282,678 2,949 4,843.23 1.24 274.78 445.41 b7pguzqb199u2   select PREBILLID prebillid, PR...
13,467,361 10,958 1,229.00 1.17 104.73 8128.50 9zryarq7p3x30   select distinct(id) from T_UAM...
12,920,531 10,971 1,177.70 1.12 99.82 244.27 c8rwtnhwdkxa3   select g.id, g.name, g.company...
12,903,959 260 49,630.61 1.12 256.01 1487.71 ah2hgzyr5ygy8   select contract.lastApproverNa...

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
252,420 71 3,555.21 15.17 111.30 4559.29 39qkfcm7998kk   SELECT l.ID, p.REQUESTER, l.WO...
25,536 21 1,216.00 1.53 5305.99 66171.96 8tzz6w3889pu7   select count(*) from (select r...
9,662 21,359 0.45 0.58 1.49 634.55 0x1wx5qjhayqp   SELECT count(distinct l.compan...
7,732 9,678 0.80 0.46 5.11 350.48 a9mq5sjz83fb2   INSERT INTO CUECM.T_INTERFACE_...
5,374 4,820 1.11 0.32 10.36 1064.59 gaqyz76td58dn   SELECT COUNT(ID) FROM T_APPROV...
3,638 3 1,212.67 0.22 203.21 1154.81 dfx1uagtscq1u   select count(distinct id) from...
3,366 1,486 2.27 0.20 299.55 2640.09 2g01qvjauajsy   UPDATE T_CONTRACT_CONTENT SET ...
2,968 0   0.18 386.64 3495.95 8pmax79k781p7   select count(*) from (select r...
2,903 29,426 0.10 0.17 0.61 304.60 90j3hhq0sz6fd   select * from T_FILE_LIBRARY w...
1,362 1,506 0.90 0.08 31.80 4653.42 8r5v32n3k1qb0   select count(*) from ( SELECT ...

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
819,587 819,286 1.00 0.00 0.00 7vtbsjxmu0trr   select id, pid, seq, hrCode, h...
207,685 101,912 0.49 0.00 0.00 bbg1cdtpuyhs6   select t.id, t.paramid, t.data...
105,915 33,906 0.32 0.00 0.02 a7wk0m5j6fcy0   select t.id, t.paramid, t.data...
94,502 94,399 1.00 0.00 0.01 820b94rxtc2rq   select id, seq, userid, displa...
78,316 1,241,292 15.85 0.00 0.00 cypbpr80qsj6y   SELECT NAME, VALUE, COMMENTS F...
30,284 86,431 2.85 0.00 0.01 ggb8rzqbq0xj7   SELECT id , relationId , targe...
29,710 29,708 1.00 0.00 0.01 fy8q0ju5a26r6   select count(1) from t_block_c...
29,426 46,384 1.58 0.00 0.01 90j3hhq0sz6fd   select * from T_FILE_LIBRARY w...
28,388 28,384 1.00 0.00 0.01 bjwrstsj8js0n   select c.ID as id, c.AffairID ...
26,261 25,032 0.95 0.00 0.03 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
101,631 819,587 7.03 7vtbsjxmu0trr   select id, pid, seq, hrCode, h...
54,442 207,685 3.77 bbg1cdtpuyhs6   select t.id, t.paramid, t.data...
41,529 105,915 2.87 a7wk0m5j6fcy0   select t.id, t.paramid, t.data...
31,473 94,502 2.18 820b94rxtc2rq   select id, seq, userid, displa...
24,071 24,076 1.67 grwydz59pu6mc   select text from view$ where r...
21,638 28,388 1.50 bjwrstsj8js0n   select c.ID as id, c.AffairID ...
19,929 29,710 1.38 fy8q0ju5a26r6   select count(1) from t_block_c...
19,154 26,261 1.33 3u7g76wsqd21c   select processDefId, actDefId,...
16,021 16,021 1.11 23txcp69tfpw5   select id, seq, userid, displa...
14,181 29,426 0.98 90j3hhq0sz6fd   select * from T_FILE_LIBRARY w...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
1,184,309 2 0.03 92202kn5h6h69   select count(distinct id) from...
1,091,343 24 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 295 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
25 50 5u0cauu9rz06g   update t_contract_arrair set c...
24 1,359 6xq5pfm5bqcvf   INSERT INTO CUECM.T_INTERFACE_...
23 9,678 a9mq5sjz83fb2   INSERT INTO CUECM.T_INTERFACE_...
23 13 axmdf8vq7k1rh   select increment$, minvalue, m...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text
04jwf5mx1n5nd select ID, CONTRACTID, MONEYTYPE, EXCHANGERATE, MONEY, RMBMONEY, GBKMONEY, COMMENTS , CREATETIME, UPDATETIME, DELETED from T_CONTRACT_FINANCE where contractId = :1 and deleted=0 and provinceId = :2
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
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
3wu60f31s55y5 select o.id, o.orgName, o.hrCode, o.hrpCode, o.displayName from T_UAM_STAFF s left join T_UAM_ORG o on s.deptId=o.id where s.hrStatus<3 and s.userId=:1 and s.locked=0 and o.orgStatus<3 and o.locked=0
3y8azvq7nxaun select * from ( select p.orgouname as orgOuName, p.prebillno as preBillNo, p.prebillid as prebillId, c.name as contractName, c.globalsn as contractNo, c.classifyname as contractclassifyname, c.otherside, f.money as contractSum, c.deptname as takerDept, c.takername as takerPerson, p.totalContribution, p.totalCountamount, p.billtype as billtype, p.TOTALOFFSETAMOUNT as totalCostaccount, p.isrenew as isRenew, p.prebillstatus as prebBillStatus , p.prebillarrairid as prebillarrairid from t_prebill_instance p, t_contract_content c, t_contract_finance f where p.contractid = c.id and c.id=f.contractid and p.isnew=1 and c.globalsn like '%'||:1||'%' and (c.companyid = :2 or p.createId = :3) order by p.createtime desc ) where rownum<=:4
49sbrh7cvcf2z select t.hastemplate from t_contract_hotel_header t where t.contractid = :1
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
56yjja3g02qtc select id, processDefId, actDefId, pageURL, actionURL, businessType, provinceId from t_wfext_bizExtend where processDefId=:1 and actDefId=:2 and businessType=:3
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
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
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
8r5v32n3k1qb0 select count(*) from ( SELECT tab.name, tab.globalsn, tab.otherside, tab.classifyname, tab.receiveDay, tab.payDay, tab.becomeDay FROM (select b.name, b.globalsn, b.otherside, b.classifyname, CASE WHEN per.receiveDay > 15 THEN NULL ELSE per.receiveDay END receiveDay, CASE WHEN per.payDay > 60 THEN NULL ELSE per.payDay END payDay, CASE WHEN TRUNC(a.enddate - SYSDATE) > 60 THEN NULL ELSE TRUNC(a.enddate - SYSDATE) END becomeDay FROM t_contract_arrair a, t_contract_content b, (SELECT CONTRACTID, CASE WHEN receiveDay IS NOT NULL THEN TRUNC(receiveDay - sysdate) END receiveDay, CASE WHEN payDay IS NOT NULL THEN TRUNC(payDay - sysdate) END payDay FROM (SELECT contractid, MIN(DECODE(INDICATE, 1, PLANTIME, NULL)) receiveDay, MIN(DECODE(INDICATE, 2, PLANTIME, NULL)) payDay FROM (SELECT contract.ID contractid, S.INDICATE, MIN(case when S.PLANTIME is not null and s.deleted=1 then null when S.PLANTIME is not null and contract.fixedamount=0 then null when S.PLANTIME is not null and (s.ishistory=2 or s.ishistory=1) then null when S.PLANTIME is not null and s.comefrom=1 then null when S.PLANTIME i s not null and (s.adjust is null or s.adjust= 0) and s.amount = (select sum(tr.applysum) a from t_contract_trade tr where tr.payplanno=s.indexkey) then null when S.PLANTIME is not null and s.adjust is not null and s.adjust= (select sum(tr.applysum) from t_contract_trade tr where tr.payplanno=s.indexkey) then null when S.PLANTIME is not null and s.amount=0 then null else S.PLANTIME end )PLANTIME FROM (SELECT b.id, b.fixedamount FROM t_contract_performer r, t_contract_content b WHERE r.PERFORMERID = :1 AND b.contractstatus IN (205, 214, 216) AND b.AFFAIRID = r.affairid AND r.deleted = 0 AND b.deleted = 0 ) contract LEFT JOIN t_contr act_payments s ON s.contractid = contract.id GROUP BY contract.id, s.indicate) GROUP BY contractid) A) per WHERE per.contractid = b.id AND a.id = b.affairid ) tab where 1 = 1 )
8tzz6w3889pu7 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{208943057}', 'O{150300031}', 'O{1503}', 'G{309117492}') 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
92202kn5h6h69 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{205651480}', 'O{450100025}', 'O{4501}') 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.pendingcode 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) >0 ) )t where 1=1 )
9fyztfympp6gx 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.performtype = 0 and affairid in (select affairid from T_CONTRACT_PERFORMER where performerid=:3 and isoriginal=:4) and a.takerid!=: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.comefrom !=:6 and a.conjunction !=:7 order by a.createTime desc
9zryarq7p3x30 select distinct(id) from T_UAM_FUNC f left join v_stafffunc s on f.id=s.funcid where s.staffId=:1 and (f.funcclass=102 or f.funcclass=103)
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
c8rwtnhwdkxa3 select g.id, g.name, g.companyId, g.isvalid, g.creator from T_UAM_GROUP g left join T_UAM_GROUPSTAFF s on g.id=s.groupid where s.isvalid=1 and s.staffId=:1 and g.type=1
ct39f2cm4k7nw select id, pid, seq, funcname, isCommon, extfield, comments from t_uam_func f left join (select distinct funcid from v_stafffunc where staffId = :1) d on f.id=d.funcid where deleted = 0 and (iscommon = 0 and f.id = d.funcid) and funcClass=:2 order by id
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||'%' )
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
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
g6qdf8b80sg7y select id from T_CONTRACT_CONTENT where to_single_byte(globalSn) =TO_SINGLE_BYTE(:1) and deleted = 0
g7mw3ydv5ax9g SELECT c.id as id, c.fieldno as fieldno, c.fielddisplayname as fielddisplayname, c.isshow as isshow, c.fieldshowtype as fieldshowtype, c.seq as seq, c.extfield as extfield, c.provinceid as provinceid, c.createtime as createtime, c.updatetime as updatetime, c.deleted as deleted, d.defaultFieldName as defaultFieldName, d.tableName as tableName, d.tableFileName as tableFileName, d.fieldType as fieldType, d.maxlength as maxlength FROM T_CONTRACT_EXTFIELD_CONFIG c, T_CONTRACT_EXTFIELD_REG d WHERE c.deleted = 0 and c.fieldno=d.fieldno and c.isshow in (1, 2) and c.provinceId = :1 order by seq
gaqyz76td58dn SELECT COUNT(ID) FROM T_APPROVE_ACCESS WHERE approveID=:1 and StaffID=:2
ggb8rzqbq0xj7 SELECT id , relationId , targetId , provinceId , createTime, extfield , businessType , deleted FROM t_template_list WHERE deleted=0 and relationId=:1 order by targetId
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 2,656,421 743.75 10.18
CPU used when call started 2,580,378 722.46 9.89
CR blocks created 44,120 12.35 0.17
Cached Commit SCN referenced 8,568 2.40 0.03
Commit SCN cached 1 0.00 0.00
DB time 86,793,763 24,300.60 332.52
DBWR checkpoint buffers written 178,676 50.03 0.68
DBWR checkpoints 0 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 2,485 0.70 0.01
DBWR undo block writes 22,765 6.37 0.09
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 1,245 0.35 0.00
RowCR attempts 45,472 12.73 0.17
RowCR hits 44,002 12.32 0.17
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for undo segment recovery 207 0.06 0.00
SMON posted for undo segment shrink 45 0.01 0.00
SQL*Net roundtrips to/from client 4,630,285 1,296.39 17.74
SQL*Net roundtrips to/from dblink 141,727,412 39,680.98 542.98
active txn count during cleanout 68,070 19.06 0.26
application wait time 70,718 19.80 0.27
background checkpoints completed 1 0.00 0.00
background checkpoints started 0 0.00 0.00
background timeouts 14,420 4.04 0.06
branch node splits 9 0.00 0.00
buffer is not pinned count 194,351,093 54,414.61 744.59
buffer is pinned count 302,127,961 84,590.09 1,157.49
bytes received via SQL*Net from client 937,131,642 262,379.05 3,590.28
bytes received via SQL*Net from dblink 34,426,631,173 9,638,802.45 131,893.20
bytes sent via SQL*Net to client 1,321,837,749 370,089.45 5,064.14
bytes sent via SQL*Net to dblink 19,011,165,493 5,322,765.03 72,834.41
calls to get snapshot scn: kcmgss 5,484,859 1,535.66 21.01
calls to kcmgas 154,857 43.36 0.59
calls to kcmgcs 32,637 9.14 0.13
change write time 11,640 3.26 0.04
cleanout - number of ktugct calls 56,541 15.83 0.22
cleanouts and rollbacks - consistent read gets 22,245 6.23 0.09
cleanouts only - consistent read gets 14,322 4.01 0.05
cluster key scan block gets 28,583 8.00 0.11
cluster key scans 11,508 3.22 0.04
commit batch performed 2,867 0.80 0.01
commit batch requested 2,867 0.80 0.01
commit batch/immediate performed 4,977 1.39 0.02
commit batch/immediate requested 4,977 1.39 0.02
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: buffer being written 22 0.01 0.00
commit cleanout failures: callback failure 49,985 13.99 0.19
commit cleanout failures: cannot pin 306 0.09 0.00
commit cleanouts 506,976 141.94 1.94
commit cleanouts successfully completed 456,663 127.86 1.75
commit immediate performed 2,110 0.59 0.01
commit immediate requested 2,110 0.59 0.01
commit txn count during cleanout 103,750 29.05 0.40
concurrency wait time 62,619,014 17,532.13 239.90
consistent changes 163,327 45.73 0.63
consistent gets 1,150,616,670 322,150.80 4,408.17
consistent gets - examination 115,181,376 32,248.60 441.28
consistent gets direct 11,025 3.09 0.04
consistent gets from cache 1,150,605,629 322,147.71 4,408.13
current blocks converted for CR 1 0.00 0.00
cursor authentications 17,983 5.03 0.07
data blocks consistent reads - undo records applied 90,968 25.47 0.35
db block changes 1,802,380 504.63 6.91
db block gets 2,414,300 675.96 9.25
db block gets direct 11,696 3.27 0.04
db block gets from cache 2,402,604 672.68 9.20
deferred (CURRENT) block cleanout applications 115,258 32.27 0.44
dirty buffers inspected 87 0.02 0.00
enqueue conversions 285,064,926 79,812.76 1,092.12
enqueue deadlocks 0 0.00 0.00
enqueue releases 2,716,920 760.69 10.41
enqueue requests 2,717,285 760.79 10.41
enqueue timeouts 7 0.00 0.00
enqueue waits 6,418 1.80 0.02
exchange deadlocks 38 0.01 0.00
execute count 3,036,818 850.25 11.63
failed probes on index block reclamation 1 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 1,678,950 470.07 6.43
free buffer requested 1,666,158 466.49 6.38
heap block compress 10,482 2.93 0.04
hot buffers moved to head of LRU 1,503,820 421.04 5.76
immediate (CR) block cleanout applications 36,569 10.24 0.14
immediate (CURRENT) block cleanout applications 35,312 9.89 0.14
index crx upgrade (found) 11 0.00 0.00
index crx upgrade (positioned) 12,810 3.59 0.05
index fast full scans (full) 81,609 22.85 0.31
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 25,453,429 7,126.48 97.52
index scans kdiixs1 52,180,290 14,609.49 199.91
leaf node 90-10 splits 866 0.24 0.00
leaf node splits 2,197 0.62 0.01
lob reads 5,444 1.52 0.02
lob writes 30,456 8.53 0.12
lob writes unaligned 26,260 7.35 0.10
logons cumulative 2,504 0.70 0.01
messages received 154,239 43.18 0.59
messages sent 154,239 43.18 0.59
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,032,701,340 289,136.75 3,956.42
opened cursors cumulative 1,463,248 409.68 5.61
parse count (failures) 3,222 0.90 0.01
parse count (hard) 36,881 10.33 0.14
parse count (total) 1,445,109 404.60 5.54
parse time cpu 86,828 24.31 0.33
parse time elapsed 46,438,942 13,002.02 177.91
physical read IO requests 524,484 146.85 2.01
physical read bytes 13,630,234,624 3,816,206.65 52,219.32
physical read total IO requests 585,484 163.92 2.24
physical read total bytes 16,409,926,656 4,594,467.59 62,868.71
physical read total multi block requests 211,644 59.26 0.81
physical reads 1,663,847 465.85 6.37
physical reads cache 1,548,697 433.61 5.93
physical reads cache prefetch 1,035,801 290.00 3.97
physical reads direct 115,150 32.24 0.44
physical reads direct (lob) 3,969 1.11 0.02
physical reads direct temporary tablespace 107,136 30.00 0.41
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 508,587 142.39 1.95
physical write bytes 43,988,082,688 12,315,827.15 168,524.45
physical write total IO requests 602,928 168.81 2.31
physical write total bytes 44,552,216,064 12,473,773.78 170,685.72
physical write total multi block requests 431,004 120.67 1.65
physical writes 5,369,639 1,503.40 20.57
physical writes direct 5,160,007 1,444.70 19.77
physical writes direct (lob) 10,057 2.82 0.04
physical writes direct temporary tablespace 5,148,253 1,441.41 19.72
physical writes from cache 209,632 58.69 0.80
physical writes non checkpoint 5,232,888 1,465.11 20.05
pinned buffers inspected 2,800 0.78 0.01
prefetch clients - default 1 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,498 0.98 0.01
queries parallelized 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 1,456,014 407.66 5.58
recursive cpu usage 99,938 27.98 0.38
redo blocks written 940,611 263.35 3.60
redo buffer allocation retries 0 0.00 0.00
redo entries 1,028,339 287.92 3.94
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 0 0.00 0.00
redo size 442,506,828 123,893.50 1,695.31
redo subscn max counts 21,551 6.03 0.08
redo synch time 39,270 10.99 0.15
redo synch writes 86,855 24.32 0.33
redo wastage 23,601,840 6,608.07 90.42
redo write time 7,535 2.11 0.03
redo writer latching time 2,986 0.84 0.01
redo writes 86,613 24.25 0.33
rollback changes - undo records applied 16,169 4.53 0.06
rollbacks only - consistent read gets 25,148 7.04 0.10
root node splits 1 0.00 0.00
rows fetched via callback 19,746,391 5,528.61 75.65
session connect time 0 0.00 0.00
session cursor cache hits 465,048 130.20 1.78
session logical reads 1,153,031,345 322,826.86 4,417.42
shared hash latch upgrades - no wait 210,318 58.89 0.81
shared hash latch upgrades - wait 2,436 0.68 0.01
sorts (disk) 0 0.00 0.00
sorts (memory) 2,508,005 702.19 9.61
sorts (rows) 320,313,199 89,681.61 1,227.16
sql area evicted 33,078 9.26 0.13
sql area purged 3,119 0.87 0.01
summed dirty queue length 89 0.02 0.00
switch current to new buffer 10,116 2.83 0.04
table fetch by rowid 206,577,022 57,837.64 791.43
table fetch continued row 852,211 238.60 3.26
table scan blocks gotten 792,551,347 221,899.31 3,036.37
table scan rows gotten 47,899,468,140 13,410,940.74 183,509.51
table scans (direct read) 0 0.00 0.00
table scans (long tables) 122 0.03 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 515,980 144.46 1.98
total number of times SMON posted 276 0.08 0.00
transaction rollbacks 4,977 1.39 0.02
transaction tables consistent read rollbacks 181 0.05 0.00
transaction tables consistent reads - undo records applied 19,879 5.57 0.08
undo change vector size 112,415,516 31,474.21 430.68
user I/O wait time 600,464 168.12 2.30
user calls 5,915,092 1,656.11 22.66
user commits 76,018 21.28 0.29
user rollbacks 185,001 51.80 0.71
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 944,622 264.48 3.62
write clones created in background 30,720 8.60 0.12
write clones created in foreground 79 0.02 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.2E+12 2.1E+12
session cursor cache count 26,977,164 27,010,181
session uga memory 9.2E+14 9.2E+14
opened cursors current 10,572 18,703
workarea memory allocated 11,124,522 1,248,766
logons current 770 1,375
session uga memory max 3.5E+12 3.5E+12
session pga memory 3.8E+11 3.7E+11

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 0 0.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 479,965 134 7.51 3.16 79,788 22 289,882 4.06
TEMP_CUECM 3,631 1 11.84 1.00 360,923 101 7,112 242.92
TS_INDEX 36,366 10 10.95 1.00 54,550 15 1,068 13.48
TEMP 3,456 1 7.88 31.00 6,493 2 0 0.00
UNDOTBS1 429 0 19.86 1.00 5,816 2 146 49.73
SYSAUX 459 0 4.23 1.00 967 0 0 0.00
SYSTEM 167 0 9.22 1.00 218 0 56 8.21
USERS 8 0 11.25 1.00 174 0 3 0.00
MOBILEOA_DATA 2 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 0.00 1.00 1 0 0 0.00
SYSAUX /dbfs/oradata/oradata/htdb/sysaux01.dbf 243 0 5.80 1.00 740 0 0 0.00
SYSAUX /dbfs/oradata/oradata/htdb/sysaux02.dbf 216 0 2.45 1.00 227 0 0 0.00
SYSTEM /dbfs/oradata/oradata/htdb/system01.dbf 165 0 9.33 1.00 217 0 56 8.21
SYSTEM /dbfs/oradata/oradata/htdb/system02.dbf 2 0 0.00 1.00 1 0 0 0.00
TEMP /dbfs/oradata/oradata/htdb/temp01.dbf 3,456 1 7.88 31.00 6,493 2 0  
TEMP_CUECM /dbfs/oradata/oradata/htdb/temp_cuecm01.dbf 23 0 6.09 1.00 200,802 56 43 0.00
TEMP_CUECM /dbfs/oradata/oradata/htdb/temp_cuecm02.dbf 3,608 1 11.87 1.00 160,121 45 7,069 244.40
TS_DATA /dbfs/oradata/oradata/htdb/data01.dbf 48,772 14 7.06 5.69 1,502 0 10,025 4.19
TS_DATA /dbfs/oradata/oradata/htdb/data02.dbf 43,753 12 6.77 5.73 634 0 12,188 5.41
TS_DATA /dbfs/oradata/oradata/htdb/data03.dbf 18,993 5 8.19 3.15 916 0 10,760 3.75
TS_DATA /dbfs/oradata/oradata/htdb/data04.dbf 25,242 7 8.98 2.60 860 0 14,376 3.92
TS_DATA /dbfs/oradata/oradata/htdb/data05.dbf 22,039 6 8.44 2.99 905 0 14,618 6.63
TS_DATA /dbfs/oradata/oradata/htdb/data06.dbf 23,562 7 7.48 2.81 1,085 0 13,068 4.31
TS_DATA /dbfs/oradata/oradata/htdb/data07.dbf 26,562 7 7.63 2.63 1,014 0 13,708 4.42
TS_DATA /dbfs/oradata/oradata/htdb/data08.dbf 23,523 7 10.16 2.91 1,350 0 11,243 5.64
TS_DATA /dbfs/oradata/oradata/htdb/data09.dbf 17,130 5 6.69 2.77 823 0 7,555 4.87
TS_DATA /dbfs/oradata/oradata/htdb/data10.dbf 11,817 3 6.44 2.38 629 0 6,813 7.57
TS_DATA /dbfs/oradata/oradata/htdb/data11.dbf 8,584 2 5.20 2.49 496 0 3,086 3.30
TS_DATA /dbfs/oradata/oradata/htdb/data12.dbf 9,140 3 6.04 2.17 627 0 4,547 5.66
TS_DATA /dbfs/oradata/oradata/htdb/data13.dbf 15,112 4 11.42 2.96 796 0 5,321 7.29
TS_DATA /dbfs/oradata/oradata/htdb/data14.dbf 9,706 3 12.46 3.22 554 0 2,608 2.81
TS_DATA /dbfs/oradata/oradata/htdb/data15.dbf 11,334 3 12.29 3.04 1,253 0 5,763 3.64
TS_DATA /dbfs/oradata/oradata/htdb/data16.dbf 10,031 3 10.58 3.13 1,089 0 5,885 4.02
TS_DATA /dbfs/oradata/oradata/htdb/data17.dbf 9,081 3 12.44 3.33 678 0 4,581 3.72
TS_DATA /dbfs/oradata/oradata/htdb/data18.dbf 8,718 2 11.94 2.32 2,652 1 6,459 4.89
TS_DATA /dbfs/oradata/oradata/htdb/data19.dbf 9,508 3 6.83 2.23 2,552 1 8,279 2.37
TS_DATA /dbfs/oradata/oradata/htdb/data20.dbf 8,944 3 6.25 2.32 965 0 8,638 2.02
TS_DATA /dbfs/oradata/oradata/htdb/data21.dbf 8,761 2 4.94 2.34 1,118 0 9,531 3.18
TS_DATA /dbfs/oradata/oradata/htdb/data22.dbf 6,800 2 6.06 1.63 963 0 7,481 4.40
TS_DATA /dbfs/oradata/oradata/htdb/data23.dbf 9,140 3 5.89 2.28 1,151 0 10,426 4.88
TS_DATA /dbfs/oradata/oradata/htdb/data24.dbf 8,313 2 5.06 1.58 1,360 0 8,985 4.26
TS_DATA /dbfs/oradata/oradata/htdb/data25.dbf 7,389 2 5.93 1.52 1,533 0 8,910 3.04
TS_DATA /dbfs/oradata/oradata/htdb/data26.dbf 7,581 2 5.28 2.28 2,725 1 6,514 1.70
TS_DATA /dbfs/oradata/oradata/htdb/data27.dbf 6,659 2 7.15 2.39 2,337 1 5,327 1.98
TS_DATA /dbfs/oradata/oradata/htdb/data28.dbf 6,349 2 4.44 2.43 2,181 1 6,440 2.22
TS_DATA /dbfs/oradata/oradata/htdb/data29.dbf 7,264 2 4.95 2.27 1,566 0 8,456 2.79
TS_DATA /dbfs/oradata/oradata/htdb/data30.dbf 10,052 3 5.10 1.93 6,694 2 12,135 3.64
TS_DATA /dbfs/oradata/oradata/htdb/data31.dbf 4,797 1 5.79 2.68 8,838 2 4,726 2.31
TS_DATA /dbfs/oradata/oradata/htdb/data32.dbf 11,898 3 3.83 1.80 3,416 1 27,688 2.55
TS_DATA /dbfs/oradata/oradata/htdb/data33.dbf 3,745 1 6.01 2.82 4,131 1 3,007 3.00
TS_DATA /dbfs/oradata/oradata/htdb/data34.dbf 3,868 1 4.28 2.24 1,894 1 33 5.45
TS_DATA /dbfs/oradata/oradata/htdb/data35.dbf 7,349 2 2.50 1.37 5,229 1 17 31.76
TS_DATA /dbfs/oradata/oradata/htdb/data36.dbf 4,908 1 3.55 1.22 4,506 1 173 22.31
TS_DATA /dbfs/oradata/oradata/htdb/data37.dbf 894 0 8.94 2.07 893 0 19 6.84
TS_DATA /dbfs/oradata/oradata/htdb/data38.dbf 843 0 6.50 2.14 1,035 0 30 6.67
TS_DATA /dbfs/oradata/oradata/htdb/data39.dbf 580 0 12.90 2.66 859 0 96 91.46
TS_DATA /dbfs/oradata/oradata/htdb/data40.dbf 804 0 12.72 2.19 2,204 1 113 11.68
TS_DATA /dbfs/oradata/oradata/htdb/data41.dbf 229 0 9.39 5.19 2,695 1 239 22.59
TS_DATA /dbfs/oradata/oradata/htdb/data42.dbf 132 0 12.27 8.27 585 0 12 17.50
TS_DATA /dbfs/oradata/oradata/htdb/data43.dbf 57 0 13.68 3.61 366 0 2 190.00
TS_DATA /dbfs/oradata/oradata/htdb/data44.dbf 2 0 0.00 1.00 129 0 1 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 502 0 11.02 1.00 643 0 23 7.83
TS_INDEX /dbfs/oradata/oradata/htdb/index02.dbf 6,983 2 10.92 1.00 8,814 2 98 19.49
TS_INDEX /dbfs/oradata/oradata/htdb/index03.dbf 8,908 2 10.73 1.00 6,093 2 432 8.87
TS_INDEX /dbfs/oradata/oradata/htdb/index04.dbf 11,551 3 11.48 1.00 22,133 6 236 10.68
TS_INDEX /dbfs/oradata/oradata/htdb/index05.dbf 8,422 2 10.49 1.00 16,867 5 279 21.36
UNDOTBS1 /dbfs/oradata/oradata/htdb/undotbs01.dbf 429 0 19.86 1.00 5,816 2 146 49.73
USERS /dbfs/oradata/oradata/htdb/users01.dbf 8 0 11.25 1.00 174 0 3 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,996,313 100 1,152,582,067 1,548,679 209,604 0 0 298,338


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 20 20164 132696 709936 3774870 709936  
E 0 16 13011 83571 386011 3774870 386011  

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,848 0.10 599,637 7.48 1.3E+11
D 9,696 0.20 1,199,274 3.86 68,720,055,935
D 14,544 0.30 1,798,911 2.13 37,905,337,085
D 19,392 0.40 2,398,548 1.45 25,850,975,088
D 24,240 0.50 2,998,185 1.20 21,384,782,765
D 29,088 0.60 3,597,822 1.11 19,669,321,763
D 33,936 0.70 4,197,459 1.06 18,819,079,717
D 38,784 0.80 4,797,096 1.03 18,316,973,022
D 43,632 0.90 5,396,733 1.01 18,000,351,070
D 48,480 1.00 5,996,370 1.00 17,782,277,529
D 53,328 1.10 6,596,007 0.99 17,630,859,316
D 58,176 1.20 7,195,644 0.99 17,524,265,000
D 63,024 1.30 7,795,281 0.98 17,446,558,521
D 67,872 1.40 8,394,918 0.98 17,389,753,892
D 72,720 1.50 8,994,555 0.97 17,336,265,854
D 77,568 1.60 9,594,192 0.97 17,261,866,685
D 82,416 1.70 10,193,829 0.96 17,108,346,774
D 87,264 1.80 10,793,466 0.94 16,771,510,672
D 92,112 1.90 11,393,103 0.91 16,130,247,674
D 96,960 2.00 11,992,740 0.85 15,071,328,744

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 74,787 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 11,420 15,459.73 10,867.88 70.30 100.00 0.00 991,480
E 16,384 10,778 7,145.39 1,213.99 16.99 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 862,120 862,120 0 0
64K 128K 5,438 5,438 0 0
128K 256K 2,590 2,590 0 0
256K 512K 1,588 1,588 0 0
512K 1024K 61,700 61,700 0 0
1M 2M 10,503 10,503 0 0
2M 4M 337 337 0 0
4M 8M 322 322 0 0
8M 16M 38 38 0 0
16M 32M 2 2 0 0
64M 128M 2 2 0 0
128M 256M 6 6 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,688,604.74 5,432,152.79 93.00 29,588
4,096 0.25 70,688,604.74 4,296,582.43 94.00 7,507
8,192 0.50 70,688,604.74 3,616,354.80 95.00 2,363
12,288 0.75 70,688,604.74 3,549,508.22 95.00 1,450
16,384 1.00 70,688,604.74 582,719.50 99.00 859
19,661 1.20 70,688,604.74 474,475.82 99.00 500
22,938 1.40 70,688,604.74 473,821.57 99.00 59
26,214 1.60 70,688,604.74 473,722.83 99.00 0
29,491 1.80 70,688,604.74 473,722.83 99.00 0
32,768 2.00 70,688,604.74 473,722.83 99.00 0
49,152 3.00 70,688,604.74 473,722.83 99.00 0
65,536 4.00 70,688,604.74 473,722.83 99.00 0
98,304 6.00 70,688,604.74 473,722.83 99.00 0
131,072 8.00 70,688,604.74 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,136 0.30 426 19,232 36,105,089 0.99 1,901,368 1.31 1,177,949
1,520 0.40 799 25,354 36,225,003 0.99 1,781,454 1.23 1,182,884
1,904 0.50 1,178 31,533 36,320,693 0.99 1,685,764 1.16 1,187,009
2,288 0.60 1,559 38,047 36,394,029 1.00 1,612,428 1.11 1,190,320
2,672 0.70 1,940 44,403 36,451,284 1.00 1,555,173 1.07 1,192,944
3,056 0.80 2,322 50,491 36,495,538 1.00 1,510,919 1.04 1,195,017
3,440 0.90 2,705 56,966 36,529,448 1.00 1,477,009 1.02 1,196,660
3,824 1.00 3,087 63,516 36,555,552 1.00 1,450,905 1.00 1,197,968
4,208 1.10 3,468 70,053 36,575,852 1.00 1,430,605 0.99 1,199,019
4,592 1.20 3,850 76,484 36,591,833 1.00 1,414,624 0.98 1,199,876
4,976 1.30 4,233 82,523 36,604,619 1.00 1,401,838 0.97 1,200,583
5,360 1.40 4,616 88,615 36,615,031 1.00 1,391,426 0.96 1,201,176
5,744 1.50 4,998 94,602 36,623,660 1.00 1,382,797 0.95 1,201,682
6,128 1.60 5,380 100,803 36,630,939 1.00 1,375,518 0.95 1,202,120
6,512 1.70 5,762 107,221 36,637,184 1.00 1,369,273 0.94 1,202,504
6,896 1.80 6,145 113,365 36,642,617 1.00 1,363,840 0.94 1,202,845
7,280 1.90 6,527 119,555 36,647,404 1.00 1,359,053 0.94 1,203,153
7,664 2.00 6,909 125,942 36,651,681 1.00 1,354,776 0.93 1,203,433

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 99,896,520 68,719,610,429
26,216 0.50 51,177,581 21,384,966,620
39,324 0.75 48,142,104 18,317,523,794
52,432 1.00 47,281,579 17,782,277,249
65,540 1.25 46,950,610 17,446,192,209
78,648 1.50 46,785,124 17,261,256,526
91,756 1.75 45,655,096 16,130,303,693
104,864 2.00 45,361,950 15,070,479,969

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)
file header block 6,968 1,728 248
data block 290,953 1,192 4
undo header 108 4 38
undo block 37 3 86
bitmap block 25 0 16
system undo header 35 0 7
segment header 18 0 13
system undo block 2 0 10
bitmap index block 158 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)
US-Undo Segment 6,566 6,564 0 5,997 5,220 870.46
TX-Transaction (row lock contention) 283 281 2 43 634 14,739.05
JD-Job Queue Date 666 666 0 2 124 61,931.00
TH-Threshold Chain (metric threshold evaluation) 69 69 0 1 41 40,952.00
HW-Segment High Water Mark 7,000 7,000 0 94 26 277.02
SQ-Sequence Cache 149 149 0 36 23 630.92
TX-Transaction 87,807 87,814 0 3 22 7,437.33
TX-Transaction (index contention) 507 507 0 242 7 28.40

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 23.56 104,024 7,443 610 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:03 2,892 12,701 7,443 537 720 0/0 0/0/0/0/0/0
14-10ÔÂ 11:53 3,343 13,733 6,841 610 720 0/0 0/0/0/0/0/0
14-10ÔÂ 11:43 1,898 4,493 6,235 603 720 0/0 0/0/0/0/0/0
14-10ÔÂ 11:33 4,282 19,436 5,631 528 720 0/0 0/0/0/0/0/0
14-10ÔÂ 11:23 3,793 17,374 5,025 562 720 0/0 0/0/0/0/0/0
14-10ÔÂ 11:13 2,671 14,161 4,419 416 720 0/0 0/0/0/0/0/0
14-10ÔÂ 11:03 4,678 22,126 3,817 168 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,565 0.00   0 0  
AWR Alerted Metric Element list 94,138 0.00   0 0  
Consistent RBA 86,667 0.00 0.00 0 0  
FAL request queue 130 0.00   0 0  
FAL subheap alocation 130 0.00   0 0  
FIB s.o chain latch 24 0.00   0 0  
FOB s.o list latch 33,654 1.38 0.58 30 0  
JS mem alloc latch 17 0.00   0 0  
JS queue access latch 17 0.00   0 0  
JS queue state obj latch 22,462 0.00   0 0  
JS slv state obj latch 120 0.00   0 0  
KMG MMAN ready and startup request latch 1,173 0.00   0 0  
KMG resize request state object freelist 2 0.00   0 0  
KTF sga latch 16,002 0.00   0 1,175 0.00
KWQMN job cache list latch 34 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
LGWR NS Write 711 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 20 0.00   0 1,173 0.00
OS process 9,268 0.00   0 0  
OS process allocation 7,978 0.46 0.68 4 0  
OS process: request allocation 6,595 0.65 1.12 13 0  
PL/SQL warning settings 2,961 0.00   0 0  
SGA IO buffer pool latch 58,795 0.11 2.13 29 58,795 0.42
SQL memory manager latch 1,128 39.18 1.24 48 1,186 0.25
SQL memory manager workarea list latch 777,169 0.00 0.21 1 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 69,834 0.04 0.00 0 0  
active service list 17,866 0.65 0.03 0 2,622 0.00
archive control 140 0.00   0 0  
archive process latch 1,450 0.00   0 0  
begin backup scn array 8,449 0.01 0.00 0 0  
buffer pool 6 0.00   0 0  
cache buffer handles 5,940,610 0.28 0.08 272 0  
cache buffers chains 2,197,955,894 1.12 0.00 1251 6,898,154 0.03
cache buffers lru chain 586,317 0.05 0.32 14 10,621,420 0.08
cache table scan latch 0     0 154,725 0.10
channel handle pool latch 6,597 0.74 0.90 8 0  
channel operations parent latch 27,857 0.08 0.00 0 0  
checkpoint queue latch 1,642,466 0.00 0.45 3 181,743 0.01
client/application info 13,437 0.00   0 0  
commit callback allocation 240 0.00   0 0  
compile environment latch 2,503 0.00   0 0  
dml lock allocation 394,577 0.11 0.07 5 0  
dummy allocation 4,403 1.11 0.14 0 0  
enqueue hash chains 290,773,736 0.23 0.00 26 4,668 0.94
enqueues 5,228,516 0.40 0.01 30 0  
event group latch 3,601 0.00   0 0  
event range base latch 172 0.00   0 0  
file cache latch 974 0.00   0 0  
global KZLD latch for mem in SGA 2,407 0.00   0 0  
global tx hash mapping 1,907,452 0.00 1.58 13 0  
hash table column usage latch 1,023 0.49 0.00 0 13,200,019 0.00
hash table modification latch 113 0.00   0 0  
interrupt manipulation 11 0.00   0 0  
job workq parent latch 0     0 98 0.00
job_queue_processes parameter latch 101 0.00   0 0  
kks stats 232,373 3.11 1.83 2662 0  
kokc descriptor allocation latch 326,664 0.03 0.10 1 0  
ksuosstats global area 236 0.00   0 0  
ktm global data 1,128 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 89,467 0.65 0.00 0 0  
library cache 8,252,733 3.13 6.67 469187 128,866 10.78
library cache load lock 3,526 0.00   0 51 0.00
library cache lock 12,684,996 0.12 0.02 37 0  
library cache lock allocation 103,287 0.27 2.13 123 0  
library cache pin 2,147,086 0.12 0.00 0 0  
library cache pin allocation 38,716 0.02 0.14 0 0  
list of block allocation 9,388 0.33 1.48 9 0  
loader state object freelist 32,032 0.02 0.00 0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 6,678 0.01 0.00 0 640 0.00
messages 465,301 0.20 0.01 1 0  
mostly latch-free SCN 102,016 12.22 0.00 0 0  
multiblock read objects 671,348 0.02 0.01 0 139 0.00
ncodef allocation latch 268 0.00   0 0  
object queue header heap 8,711 0.00   0 9,246 0.00
object queue header operation 3,879,371 0.01 0.35 12 9,846 0.14
object stats modification 1 0.00   0 1 0.00
parallel query alloc buffer 472 0.00   0 0  
parameter list 409 0.00   0 0  
parameter table management 4,434 0.07 1.33 1 0  
post/wait queue 130,764 0.00 0.00 0 89,161 0.02
process allocation 6,595 2.15 74.12 103 3,595 0.17
process group creation 6,595 0.29 0.00 0 0  
qmn state object latch 3 0.00   0 0  
qmn task queue latch 839 14.54 0.02 0 0  
redo allocation 267,940 0.15 0.75 42 1,027,023 0.32
redo copy 0     0 1,028,246 0.60
redo writing 334,866 0.01 0.44 2 0  
resmgr group change latch 2,677 0.00   0 0  
resmgr:active threads 4,379 0.00   0 0  
resmgr:actses change group 2,461 0.00   0 0  
resmgr:free threads list 4,378 1.10 0.27 1 0  
resmgr:resource group CPU method 1,857 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 559,832,238 13.88 0.00 1149 25,032 1.24
rules engine aggregate statistics 23 0.00   0 0  
rules engine rule set statistics 146 0.00   0 0  
sequence cache 220,075 0.24 0.00 0 0  
session allocation 752,700 0.45 2.87 2450 0  
session idle bit 12,197,158 0.00 0.01 0 0  
session state list latch 5,077 2.50 0.00 0 0  
session switching 15,238 0.64 0.63 8 0  
session timer 1,484 0.00   0 0  
shared pool 3,670,475 1.90 1.43 20464 0  
shared pool simulator 271,841 0.06 1.83 58 0  
simulator hash latch 76,292,525 0.01 0.04 59 0  
simulator lru latch 182,289 0.41 0.12 21 75,631,186 1.94
slave class 12 0.00   0 0  
slave class create 49 2.04 11.00 3 0  
sort extent pool 91,569 0.54 1.52 146 0  
state object free list 2 0.00   0 0  
statistics aggregation 448 0.00   0 0  
temp lob duration state obj allocation 427 0.00   0 0  
threshold alerts latch 315 0.00   0 0  
trace latch 8 37.50 0.67 0 0  
transaction allocation 1,251,569 0.01 2.03 66 5 0.00
transaction branch allocation 1,882,819 0.06 0.48 106 0  
undo global data 1,165,622 0.12 0.02 1 140 0.00
user lock 8,536 23.81 6.60 3608 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 559,832,238 77,697,831 126,382 77,575,199 0 0 0
cache buffers chains 2,197,955,894 24,553,278 99,530 24,468,566 0 0 0
enqueue hash chains 290,773,736 668,495 2,620 665,953 0 0 0
library cache 8,252,733 257,976 1,720,204 61,985 0 0 0
shared pool 3,670,475 69,799 99,908 23,201 0 0 0
enqueues 5,228,516 20,953 302 20,683 0 0 0
cache buffer handles 5,940,610 16,617 1,269 16,114 0 0 0
library cache lock 12,684,996 15,114 317 14,850 0 0 0
mostly latch-free SCN 102,016 12,464 59 12,406 0 0 0
kks stats 232,373 7,235 13,218 744 0 0 0
simulator hash latch 76,292,525 6,114 270 6,007 0 0 0
session allocation 752,700 3,360 9,649 1,104 0 0 0
library cache pin 2,147,086 2,553 5 2,548 0 0 0
user lock 8,536 2,032 13,419 170 0 0 0
undo global data 1,165,622 1,385 21 1,367 0 0 0
transaction branch allocation 1,882,819 1,085 516 837 0 0 0
messages 465,301 943 6 937 0 0 0
simulator lru latch 182,289 740 88 716 0 0 0
session idle bit 12,197,158 541 4 537 0 0 0
sequence cache 220,075 535 1 534 0 0 0
sort extent pool 91,569 491 745 103 0 0 0
FOB s.o list latch 33,654 463 270 239 0 0 0
SQL memory manager latch 1,128 442 547 5 0 0 0
dml lock allocation 394,577 439 29 421 0 0 0
redo allocation 267,940 408 308 201 0 0 0
library cache lock allocation 103,287 276 588 13 0 0 0
cache buffers lru chain 586,317 264 85 216 0 0 0
object queue header operation 3,879,371 204 72 163 0 0 0
multiblock read objects 671,348 165 1 164 0 0 0
shared pool simulator 271,841 163 298 13 0 0 0
transaction allocation 1,251,569 154 313 16 0 0 0
process allocation 6,595 142 10,525 1 0 0 0
qmn task queue latch 839 122 3 119 0 0 0
active service list 17,866 117 3 114 0 0 0
session switching 15,238 97 61 49 0 0 0
kokc descriptor allocation latch 326,664 87 9 82 0 0 0
SGA IO buffer pool latch 58,795 63 134 4 0 0 0
channel handle pool latch 6,597 49 44 23 0 0 0
dummy allocation 4,403 49 7 42 0 0 0
resmgr:free threads list 4,378 48 13 36 0 0 0
OS process: request allocation 6,595 43 48 35 0 0 0
OS process allocation 7,978 37 25 24 0 0 0
redo writing 334,866 34 15 20 0 0 0
SQL memory manager workarea list latch 777,169 33 7 26 0 0 0
checkpoint queue latch 1,642,466 33 15 26 0 0 0
global tx hash mapping 1,907,452 31 49 22 0 0 0
list of block allocation 9,388 31 46 2 0 0 0
library cache pin allocation 38,716 7 1 6 0 0 0
parameter table management 4,434 3 4 0 0 0 0
trace latch 8 3 2 1 0 0 0
slave class create 49 1 11 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
FOB s.o list latch ksfd_allfob 0 256 264
FOB s.o list latch ksfd_fobd 0 14 6
OS process allocation kso_new_process:2 0 22 22
OS process allocation kso_delete_process:1 0 3 3
OS process: request allocation kso_new_process 0 48 48
SGA IO buffer pool latch ksfd_free_sgabuffer 0 96 134
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 38 0
SQL memory manager latch qesmmIQueryRefreshBound 0 547 547
SQL memory manager workarea list latch qesmmIRefreshBound 0 4 0
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 3 4
active service list kswslogon: session login 0 37 37
active service list kswslogon: session logout 0 8 4
cache buffer handles kcbzgs 0 1,066 975
cache buffer handles kcbzfs 0 203 294
cache buffers chains kcbgtcr: kslbegin excl 0 217,808 191,011
cache buffers chains kcbrls: kslbegin 0 42,969 71,866
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 7,352 3,456
cache buffers chains kcbgtcr: fast path 0 1,228 703
cache buffers chains kcbbxsv 0 558 6
cache buffers chains kcbzwb 0 483 967
cache buffers chains kcbgcur: kslbegin 0 100 555
cache buffers chains kcbchg: kslbegin: call CR func 0 51 1,715
cache buffers chains kcbgtcr: kslbegin shared 0 28 22
cache buffers chains kcbzib: finish free bufs 0 21 77
cache buffers chains kcbzdh 0 19 0
cache buffers chains kcbbic2 0 17 5
cache buffers chains kcbzgb: scan from tail. nowait 0 17 0
cache buffers chains kcbzib: multi-block read: nowait 0 12 0
cache buffers chains kcbget: pin buffer 0 11 17
cache buffers chains kcbcge 0 4 432
cache buffers chains kcbnlc 0 4 56
cache buffers chains kcbrlb1 0 2 20
cache buffers chains kcbbic1 0 1 1
cache buffers chains kcbso1: set no access 0 1 0
cache buffers lru chain kcbbxsv: move to being written 0 43 71
cache buffers lru chain kcbzgws 0 29 0
cache buffers lru chain kcbzgm 0 7 0
cache buffers lru chain kcbbic2 0 1 7
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 1 0
cache buffers lru chain kcbw_make_free_nowait 0 1 0
cache buffers lru chain kcbw_quiesce_granule 0 1 1
cache buffers lru chain kcbzar: KSLNBEGIN 0 1 0
cache buffers lru chain kcbzswcu 0 1 1
channel handle pool latch ksrchconnect() 0 45 45
checkpoint queue latch kcbkubc 0 12 6
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 1 0
checkpoint queue latch kcbk_get_cqlt_nowait2 0 1 0
checkpoint queue latch kcbkllrba: compute lowest lrba 0 1 9
cost function kzulgt: find user res 0 9,997 10,886
cost function kzulrl 0 3,418 2,529
dml lock allocation ktaiam 0 24 26
dml lock allocation ktaidm 0 5 3
dummy allocation ktcscnfy 0 7 7
enqueue hash chains ksqcnl 0 2,484 2,457
enqueue hash chains ksqcmi: kslgpl 0 53 2
enqueue hash chains ksqrcl 0 48 83
enqueue hash chains ksqgtl3 0 34 75
enqueues ksqdel 0 126 108
enqueues ksqgel: create enqueue 0 124 150
enqueues ksqgtl2 0 30 0
enqueues ksqies 0 22 44
event range base latch No latch 0 92 63
global tx hash mapping K2GTBlatch 0 49 49
kks stats kks stats alloc/free 0 13,217 13,217
kokc descriptor allocation latch kokcdlt: regular free 0 9 0
lgwr LWN SCN kcs023 0 2 0
library cache kgldti: 2child 0 813,319 62,601
library cache kglpin 0 448,054 87,635
library cache kglhdgn: child: 0 40,320 758,865
library cache kglLockCursor 0 37,906 29,776
library cache kglobpn: child: 0 33,294 196,479
library cache kglpndl: child: after processing 0 32,538 853
library cache kglukp: child 0 27,688 22,371
library cache kgldte: child 0 0 20,073 241,587
library cache kglati 0 15,475 206
library cache kglpndl: child: before processing 0 7,533 87,108
library cache kglhdgc: child: 0 2,743 821
library cache kglpnp: child 0 992 3,744
library cache kglScanDependency 0 937 213
library cache kglobld 0 172 1,025
library cache kglrtl 0 74 251
library cache kgldtld: 2child 0 73 192
library cache kglhdbrnl: child 0 24 1,242
library cache kglpur: child 0 14 698
library cache kglini: child 0 11 47
library cache kglivr: child 0 3 0
library cache kglnti 0 3 0
library cache lock kgllkdl: child: no lock handle 0 48,564 45,097
library cache lock kgllkdl: child: cleanup 0 118 105
library cache lock kgllkal: child: multiinstance 0 110 151
library cache lock allocation kgllkget 0 575 467
library cache lock allocation kgllkrel 0 13 121
library cache pin kglpndl 0 4 4
library cache pin kglpnal: child: alloc space 0 1 1
library cache pin allocation kglpnget 0 1 0
list of block allocation ktlabl 0 37 37
list of block allocation ktcdod 0 5 6
list of block allocation ktlbbl 0 4 5
messages ksaamb: after wakeup 0 3 3
messages ksarcv: after wait 0 2 2
messages ksarcv 0 1 1
mostly latch-free SCN kcslcu3 0 57 59
multiblock read objects kcbzib: normal mbr free 0 1 0
object queue header operation kcbo_switch_q_bg 0 36 2
object queue header operation kcbo_switch_cq 0 11 40
object queue header operation kcbo_ivbo 0 10 8
object queue header operation kcbw_unlink_q 0 6 13
object queue header operation kcbo_switch_mq_bg 0 5 9
object queue header operation kcbw_make_free_nowait 0 3 0
object queue header operation kcbw_link_q 0 2 1
parameter table management kspallmod 0 4 0
process allocation ksuapc 0 10,389 10,328
process allocation ksucrp 0 129 0
process allocation ksudlp 0 7 197
redo allocation kcrfw_redo_gen: redo allocation 1 0 256 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 33 129
redo allocation kcrfw_redo_gen: redo allocation 2 0 9 0
redo allocation kcrfw_redo_write: before write 0 7 134
redo allocation kcrfw_redo_write: more space 0 3 662
redo writing kcrfw_post: rba scn pair 0 8 0
redo writing kcrfwcr 0 5 14
redo writing kcrfw_cal_target_rba 0 1 0
redo writing kcrfw_post: after write 0 1 0
resmgr:free threads list kgskthrcreate 0 13 11
row cache objects kqreqd: reget 0 70,713 7,691
row cache objects kqrpre: find obj 0 34,647 95,888
row cache objects kqreqd 0 19,470 22,402
row cache objects kqrso 0 1,068 269
row cache objects kqrcmt: while loop 0 18 2
row cache objects kqrpup 0 6 0
row cache objects ksucallcbksafely: kqrhngc 0 6 0
row cache objects kqrget 0 4 13
row cache objects kqrpre: init complete 0 3 7
row cache objects kqrcmt: clear flag 0 1 9
sequence cache kdnssd 0 1 0
session allocation ksucrp 0 7,115 2,035
session allocation ksuxds: not user session 0 908 2,033
session allocation ksucri 0 897 5,415
session allocation ksuprc 0 454 43
session allocation kspallmod 0 139 0
session allocation ksuxds: KSUSFCLC not set 0 97 88
session allocation ksudlp 0 31 26
session allocation ksudlc 0 7 9
session allocation ksusroll 0 1 0
session idle bit ksupuc: clear busy 0 2 3
session idle bit ksupuc: set busy 0 2 1
session switching kskexeall 0 61 61
shared pool kghfrunp: clatch: wait 0 126,811 179,425
shared pool kghfrunp: clatch: nowait 0 63,977 0
shared pool kghalo 0 61,580 41,914
shared pool kghfrunp: alloc: wait 0 15,814 2,711
shared pool kghupr1 0 9,439 25,339
shared pool kghalp 0 8,252 18,894
shared pool kghfre 0 4,420 10,403
shared pool kghasp 0 201 214
shared pool kghfrh 0 109 1
shared pool kghfree_extents: scan 0 70 406
shared pool kgh: add extent to reserved list 0 15 15
shared pool kgh_next_free 0 3 8
shared pool kghfnd: get next extent 0 1 0
shared pool kghfrunp: alloc: clatch nowait 0 1 0
shared pool simulator kglsim_unpin_simhp 0 216 122
shared pool simulator kglsim_upd_newhp 0 61 29
shared pool simulator kglsim_chg_simhp_free 0 11 27
shared pool simulator kglsim_scan_lru: scan 0 10 97
simulator hash latch kcbs_lookup_setid: lookup dba 0 139 104
simulator hash latch kcbsacc: lookup dba 0 126 157
simulator hash latch kcbs_get_or_extract_simbufseq 0 3 9
simulator hash latch kcbsacc: insert dba 0 2 0
simulator lru latch kcbs_simulate: simulate set 0 82 0
simulator lru latch kcbs_simbufseq 0 4 86
simulator lru latch kcbs_shrink_pool 0 2 0
slave class create ksvcreate 0 11 11
sort extent pool ktstallocext: new extent in-doubt 0 369 5
sort extent pool ktstfd 0 178 0
sort extent pool ktstaddextent1 0 124 700
sort extent pool ktstallobj1 0 21 2
sort extent pool ktstallocext: current num of extents 0 17 0
sort extent pool ktstdt: return extent 0 14 10
sort extent pool ktstdt: dealloc sort extent 0 11 0
sort extent pool ktstcrtobj 0 5 0
sort extent pool ktstgrowseg 0 5 8
sort extent pool ktstsmonmsg 0 1 6
trace latch kstipg 0 2 2
transaction allocation ktiNonImuPoolAllocate 0 200 95
transaction allocation ktcxbr 0 99 121
transaction allocation ktiNonImuPoolFree 0 12 63
transaction allocation ktcdso 0 2 19
transaction branch allocation ktcbba 0 324 91
transaction branch allocation ksupuc 0 190 409
transaction branch allocation ktcbod 0 2 6
undo global data ktucof: at start 0 10 0
undo global data ktuswr: other segs 0 6 0
undo global data ktudba: KSLBEGIN 0 5 17

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_RULE_INSTANCE   TABLE 93,422,384 8.10
CUECM TS_DATA T_VENDOR_REPOSITORY VALID TABLE PARTITION 76,963,232 6.67
CUECM TS_DATA T_APPROVE_PROCESS   TABLE 65,451,728 5.68
CUECM USERS T_MSG_MAILRECEIVER   TABLE 64,511,616 5.59
CUECM TS_DATA T_CONTRACT_CONTENT SYS_CONP12 TABLE PARTITION 51,771,296 4.49

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_DATA T_INTERFACE_LOGS   TABLE 324,206 19.49
CUECM TS_DATA T_APPROVE_PROCESS   TABLE 304,666 18.31
CUECM TS_DATA T_CLOUD_PENDING   TABLE 139,771 8.40
CUECM TS_DATA T_APPROVE_AFFAIR   TABLE 27,424 1.65
CUECM TS_DATA T_APPROVE_LOG   TABLE 10,465 0.63

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_T_CONTRACT_CHANGED002   INDEX 166 35.10
CUECM TS_INDEX IDX_CONTRACT_TAKERIDN   INDEX 49 10.36
QRTZ TS_DATA QRTZ_LOCKS   TABLE 40 8.46
SYS SYSAUX WRH$_SQL_PLAN_PK   INDEX 30 6.34
CUECM TS_DATA IDX_INTERFACELOGS_BATCHID   INDEX 20 4.23

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 1 33.33
CUECM TS_DATA IDX_APPROVE_LOG2   INDEX 1 33.33
CUECM TS_INDEX INDEX_PENDING   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 IDX_T_CONTRACT_CHANGED002   INDEX 362 19.93
CUECM TS_DATA T_CONTRACT_CHANGED   TABLE 345 19.00
CUECM TS_DATA T_CLOUD_PENDING   TABLE 234 12.89
CUECM TS_DATA T_CONTRACT_MONEY_CHANGED   TABLE 165 9.09
CUECM TS_DATA T_INTERFACE_LOGS   TABLE 123 6.77

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 72 0.00 0   2 1
dc_database_links 166,766,926 0.00 0   0 3
dc_files 812 0.00 0   0 58
dc_global_oids 163,415 0.01 0   0 78
dc_histogram_data 5,060,777 0.13 0   0 14,604
dc_histogram_defs 2,312,590 0.19 0   0 4,690
dc_object_grants 128 15.63 0   0 25
dc_object_ids 10,215,249 0.01 0   0 1,064
dc_objects 207,601 0.28 0   5 609
dc_profiles 4,823 0.00 0   0 3
dc_rollback_segments 504,901 0.02 0   969 617
dc_segments 945,280 0.18 0   316 1,014
dc_sequences 113 7.96 0   113 6
dc_tablespace_quotas 5 0.00 0   0 1
dc_tablespaces 1,474,916 0.00 0   0 11
dc_usernames 13,028 0.48 0   0 45
dc_users 2,339,216 0.00 0   0 80
outstanding_alerts 137 10.95 0   23 20


Back to Top

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 3,218 0.22 37,000 0.03 5 0
CLUSTER 91 1.10 147 1.36 1 0
INDEX 149,495 0.01 169,970 0.01 2 0
JAVA DATA 3 33.33 7 14.29 0 0
JAVA RESOURCE 3 33.33 7 14.29 0 0
JAVA SOURCE 3 33.33 7 14.29 0 0
SQL AREA 978,404 6.23 3,322,084 3.19 5,972 360
TABLE/PROCEDURE 30,293 1.48 828,574 0.20 620 0
TRIGGER 14,747 0.01 47,173 0.03 12 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 SQL 10,896.97 10,868.14 14.49 109.11 849 1,240 752 523
  Other 4,057.29   5.26 27.54 430 1,559 771 771
  Freeable 481.75 0.00 0.93 0.43 6   516 516
  PL/SQL 18.11 11.81 0.02 0.02 0 0 769 769
E 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

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 50,918,850,560 50,834,964,480
Fixed Size 2,198,928  
Redo Buffers 14,577,664  
Variable Size 4,043,309,680 4,127,195,760

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 135.65 141.13 4.04
shared PCursor 92.74 95.45 2.93
shared db_block_hash_buckets 360.00 360.00 0.00
shared free memory 1,005.14 975.33 -2.97
shared kglsim object batch 45.93 45.93 0.00
shared library cache 114.07 121.34 6.37
shared sql area 1,572.93 1,647.78 4.76
streams Sender info 2.03 2.03 0.00
streams free memory 31.72 31.72 0.00
  buffer_cache 48,560.00 48,480.00 -0.16
  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 Coordinator 8,490,000 0 0
QMON Slaves 2,980,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 23 0 0 5 2,378

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource Name Current Utilization Maximum Utilization Initial Allocation Limit
processes 1,379 1,500 1500 1500
sessions 1,391 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