WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORCL1298563979orcl110.2.0.5.0NOwdfcmp

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1029326-Feb-13 10:00:0874 18.2
End Snap:1029426-Feb-13 11:00:25125 11.8
Elapsed:  60.28 (mins)  
DB Time:  1,797.86 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 17,712M 17,712MStd Block Size: 8K
Shared Pool Size: 2,560M 2,560MLog Buffer: 14,296K

Load Profile

Per SecondPer Transaction
Redo size: 996,771.16 210,509.34
Logical reads: 106,925.15 22,581.65
Block changes: 7,781.02 1,643.28
Physical reads: 6,418.18 1,355.46
Physical writes: 278.73 58.87
User calls: 380.49 80.36
Parses: 262.16 55.37
Hard parses: 71.41 15.08
Sorts: 112.77 23.82
Logons: 0.25 0.05
Executes: 232.15 49.03
Transactions: 4.74 

% Blocks changed per Read: 7.28Recursive Call %: 71.26
Rollback per transaction %: 1.88Rows per Sort: 39.22

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97Redo NoWait %: 99.79
Buffer Hit %: 94.14In-memory Sort %: 100.00
Library Hit %: 78.35Soft Parse %: 72.76
Execute to Parse %: -12.93Latch Hit %: 99.88
Parse CPU to Parse Elapsd %: 40.92% Non-Parse CPU: 95.34

Shared Pool Statistics

BeginEnd
Memory Usage %: 35.03 34.54
% SQL with executions>1: 37.30 40.32
% Memory for SQL w/exec>1: 50.17 60.58

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
buffer busy waits 45,481 43,087 947 39.9Concurrency
db file sequential read 469,438 21,606 46 20.0User I/O
log file switch (checkpoint incomplete) 27,832 16,958 609 15.7Configuration
log file sync 93,087 8,088 87 7.5Commit
CPU time  7,572  7.0 

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 98,267.10 91.10
DB CPU 7,572.40 7.02
parse time elapsed 1,433.01 1.33
sequence load elapsed time 1,361.02 1.26
hard parse elapsed time 944.03 0.88
failed parse elapsed time 162.76 0.15
PL/SQL compilation elapsed time 157.54 0.15
connection management call elapsed time 66.46 0.06
hard parse (sharing criteria) elapsed time 52.41 0.05
hard parse (bind mismatch) elapsed time 45.29 0.04
PL/SQL execution elapsed time 37.93 0.04
repeated bind elapsed time 0.87 0.00
DB time 107,871.56  
background elapsed time 9,298.68  
background cpu time 51.60  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
Concurrency 238,902 20 44,092 185 40.87
User I/O 2,088,213 0 25,945 12 24.05
Configuration 29,810 53 19,004 637 17.62
Commit 93,087 82 8,088 87 7.50
CPU time     7,572   7.02
System I/O 53,530   1,797 34 1.67
Application 173,532 0 202 1 0.19
Network 3,348,733   185 0 0.17
Other 107,820 0 121 1 0.11

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
buffer busy waits 45,481 96 43,087 947 2.66
db file sequential read 469,438   21,606 46 27.41
log file switch (checkpoint incomplete) 27,832 53 16,958 609 1.63
log file sync 93,087 82 8,088 87 5.44
db file scattered read 1,521,982   3,718 2 88.87
log file parallel write 13,781   1,518 110 0.80
enq: SQ - contention 371 96 1,062 2863 0.02
log buffer space 1,232 42 773 628 0.07
row cache lock 447 42 584 1307 0.03
read by other session 60,129 0 556 9 3.51
control file parallel write 2,001   266 133 0.12
log file switch completion 346 39 210 606 0.02
SQL*Net more data to client 2,571,575   180 0 150.16
latch: shared pool 9,402   134 14 0.55
enq: TX - row lock contention 46 93 127 2768 0.00
latch: library cache 4,625   126 27 0.27
SQL*Net break/reset to client 173,472   74 0 10.13
latch: In memory undo latch 134   61 455 0.01
cursor: pin S wait on X 4,259 99 56 13 0.25
latch free 2,041   43 21 0.12
db file single write 891   42 47 0.05
enq: CF - contention 57 2 30 520 0.00
db file parallel read 120   22 185 0.01
kksfbc child completion 317 95 15 48 0.02
enq: US - contention 210   14 67 0.01
latch: cache buffers chains 14,371   11 1 0.84
control file sequential read 37,672   10 0 2.20
latch: library cache lock 492   10 20 0.03
os thread startup 34 3 6 178 0.00
cursor: mutex X 158,952   6 0 9.28
enq: TX - index contention 25   6 229 0.00
latch: row cache objects 630   5 8 0.04
enq: JS - queue lock 2 100 5 2443 0.00
latch: cache buffers lru chain 645   4 6 0.04
latch: redo allocation 527   3 6 0.03
log file single write 38   3 71 0.00
latch: object queue header operation 329   2 7 0.02
SQL*Net message to client 722,881   2 0 42.21
library cache load lock 8   2 211 0.00
SQL*Net more data from client 53,787   2 0 3.14
latch: session allocation 30   1 41 0.00
cursor: pin S 102,916   1 0 6.01
direct path sync 26   1 33 0.00
rdbms ipc reply 133   1 6 0.01
SQL*Net message from dblink 252   1 3 0.01
LGWR wait for redo copy 308 7 1 2 0.02
latch: messages 193   1 4 0.01
latch: undo global data 21   0 13 0.00
undo segment extension 3 67 0 65 0.00
direct path write temp 17,746   0 0 1.04
direct path read temp 17,685   0 0 1.03
log file sequential read 38   0 3 0.00
latch: library cache pin 41   0 3 0.00
latch: redo writing 26   0 3 0.00
cursor: mutex S 1   0 45 0.00
latch: enqueue hash chains 39   0 1 0.00
latch: checkpoint queue latch 19   0 2 0.00
buffer deadlock 33 100 0 0 0.00
direct path read 185   0 0 0.01
SQL*Net message to dblink 232   0 0 0.01
SQL*Net break/reset to dblink 14   0 0 0.00
direct path write 11   0 0 0.00
SQL*Net more data from dblink 6   0 0 0.00
SQL*Net message from client 723,662   187,835 260 42.26
virtual circuit status 123 100 3,578 29090 0.01
jobq slave wait 565 97 1,638 2898 0.03
single-task message 6   0 21 0.00
class slave wait 8   0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 13,781   1,519 110 0.80
buffer busy waits 413 95 387 937 0.02
control file parallel write 2,001   266 133 0.12
db file sequential read 2,541   164 65 0.15
events in waitclass Other 1,679 1 45 27 0.10
db file single write 891   42 47 0.05
row cache lock 31 32 33 1065 0.00
log file switch (checkpoint incomplete) 40 55 30 748 0.00
control file sequential read 37,474   8 0 2.19
os thread startup 34 3 6 178 0.00
latch: shared pool 97   5 50 0.01
log buffer space 7 29 4 558 0.00
log file single write 38   3 71 0.00
latch: library cache 44   3 58 0.00
log file switch completion 3   1 335 0.00
latch: row cache objects 6   1 120 0.00
db file scattered read 21   0 7 0.00
log file sequential read 38   0 3 0.00
latch: cache buffers chains 5   0 4 0.00
latch: redo writing 3   0 1 0.00
latch: library cache lock 4   0 1 0.00
rdbms ipc message 28,251 43 34,013 1204 1.65
pmon timer 2,239 77 3,586 1602 0.13
smon timer 12 83 3,431 285940 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 1,101,520
IDLE_TIME 10,796,558
IOWAIT_TIME 1,504,991
NICE_TIME 44
SYS_TIME 563,040
USER_TIME 536,969
LOAD 1,198
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 1.8E+11
VM_OUT_BYTES 12,369,432,576
PHYSICAL_MEMORY_BYTES 33,246,838,784
NUM_CPUS 32
NUM_CPU_SOCKETS 32

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
orcl 103,987.90 7,300.90 22,794,433 375,766,487
SYS$USERS 2,212.80 165.30 26,943 7,641,631
SYS$BACKGROUND 0.00 0.00 2,900 83,882
orclXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
orcl 2051924 24185 237906 43647 0 0 3340911 184
SYS$USERS 21508 1337 265 10 0 0 1282 0
SYS$BACKGROUND 4705 209 649 434 0 0 0 0

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 IdSQL ModuleSQL Text
44,164 4 5,599 7.89 40.94 1506ft6gwszrd dllhost.exe Update tWebComLogin Set LastDa...
4,731 27 725 6.53 4.39 2gw4dt8v4gyjn dllhost.exe SELECT BGNDATE, BGNTIME, BILLN...
4,368 52 999 4.37 4.05 cjq91hg7qh6xd dllhost.exe SELECT ORGCODE , DEPID , ISHYD...
2,955 424 95 31.10 2.74 5zhu4psa6zx33 HsCmpServer.exe Select IsSelect, OrgCode, EtpC...
2,147 0 261 8.23 1.99 cz85cv85maqjy HsCmpServer.exe Insert into tSysLog (LogTime, ...
1,985 73 2,635 0.75 1.84 6fzqkjh00c8q0 HsCom.exe BEGIN sStk_FollowMeRece(:1, :2...
1,882 155 0   1.74 ftkpvbpb4yjny   DECLARE job BINARY_INTEGER := ...
1,437 84 0   1.33 fr4uqtgmvgwa0   INSERT INTO TTMPSKUGTPLU (ORGC...
1,358 0 452 3.00 1.26 gsu79x1f2hnkj HsCmpServer.exe SELECT QID_TSYSLOG_LOGID.NEXTV...
1,147 180 4 286.84 1.06 bbqp1ywqmvhv2 HsCmpServer.exe SELECT '['||TO_CHAR(D1.CLSCODE...

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 IdSQL ModuleSQL Text
424 2,955 95 4.47 5.61 2.74 5zhu4psa6zx33 HsCmpServer.exe Select IsSelect, OrgCode, EtpC...
195 918 53 3.68 2.58 0.85 c7s87nurt7yqz HsCmpServer.exe Select IsSelect, OrgCode, EtpC...
180 1,147 4 44.98 2.38 1.06 bbqp1ywqmvhv2 HsCmpServer.exe SELECT '['||TO_CHAR(D1.CLSCODE...
155 1,026 1 155.27 2.05 0.95 3rapz0p1df6qj oracle@wdfcrm (TNS V1-V3) DELETE FROM "TPOSPLUPARA" "A1"...
155 1,882 0   2.05 1.74 ftkpvbpb4yjny   DECLARE job BINARY_INTEGER := ...
128 409 2 63.88 1.69 0.38 5cf7hmzgu3uvn HsCmpServer.exe select a.orgcode, a.etpname, a...
121 790 1 121.46 1.60 0.73 14sr6fg49gwfu oracle@wdfcrm (TNS V1-V3) INSERT INTO "TPOSPLUPARA" ("DS...
84 1,437 0   1.11 1.33 fr4uqtgmvgwa0   INSERT INTO TTMPSKUGTPLU (ORGC...
81 803 13 6.26 1.08 0.74 795tq5r6g30kx HsCmpServer.exe BEGIN SORD_CGJYGETKCDATA( :1, ...
73 1,985 2,635 0.03 0.97 1.84 6fzqkjh00c8q0 HsCom.exe BEGIN sStk_FollowMeRece(:1, :2...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
78,749,935 95 828,946.68 20.36 424.50 2954.50 5zhu4psa6zx33 HsCmpServer.exe Select IsSelect, OrgCode, EtpC...
36,432,051 53 687,397.19 9.42 195.10 918.27 c7s87nurt7yqz HsCmpServer.exe Select IsSelect, OrgCode, EtpC...
22,291,517 1 22,291,517.00 5.76 155.27 1026.06 3rapz0p1df6qj oracle@wdfcrm (TNS V1-V3) DELETE FROM "TPOSPLUPARA" "A1"...
18,456,557 1 18,456,557.00 4.77 121.46 789.53 14sr6fg49gwfu oracle@wdfcrm (TNS V1-V3) INSERT INTO "TPOSPLUPARA" ("DS...
11,811,475 13 908,575.00 3.05 81.41 803.32 795tq5r6g30kx HsCmpServer.exe BEGIN SORD_CGJYGETKCDATA( :1, ...
7,778,621 0   2.01 155.22 1882.06 ftkpvbpb4yjny   DECLARE job BINARY_INTEGER := ...
5,049,520 105 48,090.67 1.31 45.62 121.67 dtj01urbaanhz dllhost.exe SELECT BARCODE, DEPCODE, DEPID...
4,902,992 1 4,902,992.00 1.27 71.07 438.36 44hgw9cwssu0r   INSERT INTO TPLUINCREASE_TMP (...
4,462,788 3 1,487,596.00 1.15 32.55 619.90 5pk50wtr6uqvw HsCmpServer.exe INSERT INTO TORDCGJYKCDATA(INO...
3,666,051 4 916,512.75 0.95 179.93 1147.35 bbqp1ywqmvhv2 HsCmpServer.exe SELECT '['||TO_CHAR(D1.CLSCODE...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
2,373,286 2 1,186,643.00 10.22 127.77 408.89 5cf7hmzgu3uvn HsCmpServer.exe select a.orgcode, a.etpname, a...
565,406 4 141,351.50 2.44 179.93 1147.35 bbqp1ywqmvhv2 HsCmpServer.exe SELECT '['||TO_CHAR(D1.CLSCODE...
133,532 1 133,532.00 0.58 43.47 1060.71 54uwsfvp7srsg HsCmpServer.exe BEGIN SJOB_GATHERSALES( :1 ); ...
61,374 2,635 23.29 0.26 73.28 1985.30 6fzqkjh00c8q0 HsCom.exe BEGIN sStk_FollowMeRece(:1, :2...
47,486 725 65.50 0.20 26.65 4731.23 2gw4dt8v4gyjn dllhost.exe SELECT BGNDATE, BGNTIME, BILLN...
36,046 999 36.08 0.16 52.09 4367.66 cjq91hg7qh6xd dllhost.exe SELECT ORGCODE , DEPID , ISHYD...
34,120 95 359.16 0.15 424.50 2954.50 5zhu4psa6zx33 HsCmpServer.exe Select IsSelect, OrgCode, EtpC...
26,936 0   0.12 155.22 1882.06 ftkpvbpb4yjny   DECLARE job BINARY_INTEGER := ...
24,348 1 24,348.00 0.10 155.27 1026.06 3rapz0p1df6qj oracle@wdfcrm (TNS V1-V3) DELETE FROM "TPOSPLUPARA" "A1"...
17,373 53 327.79 0.07 195.10 918.27 c7s87nurt7yqz HsCmpServer.exe Select IsSelect, OrgCode, EtpC...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
38,239 38,239 1.00 0.00 0.00 gjbjrmkrw4424 dllhost.exe select sysdate , dual."ROWID" ...
35,322 35,322 1.00 0.00 0.00 3scwabj9qsmkj dllhost.exe select B.*, B."ROWID" from tWe...
31,141 31,137 1.00 0.00 0.01 7rcsysu9557sv dllhost.exe Select ComType , twebcomlogin....
25,134 438,545 17.45 0.00 0.01 db78fxqxwxt7r   select /*+ rule */ bucket, end...
22,264 27,463 1.23 0.00 0.00 2uwmmnqdwxw57 dllhost.exe Select tWebComTable.*, tWebCom...
21,463 335,245 15.62 0.00 0.00 fcsw30vk481ab dllhost.exe Select tWebComField.*, tWebCom...
11,696 11,696 1.00 0.00 0.00 39dj638nh40zk HsCom.exe SELECT T.STARTDATE FROM TCVSPD...
7,705 7,703 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
6,530 6,530 1.00 0.00 0.00 grwydz59pu6mc   select text from view$ where r...
5,634 5,634 1.00 0.00 0.10 9h6wvmuyqq55f HsCmpServer.exe Insert into tAcpJsCondition (...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
38,238 38,239 4.03 gjbjrmkrw4424 dllhost.exe select sysdate , dual."ROWID" ...
35,362 0 3.73 24c6vrzw1ug5g dllhost.exe select B.* from tWebComItem B...
35,357 0 3.73 4wzc12hz2tx0m dllhost.exe select B.* from tWebComItem B...
35,322 35,322 3.73 3scwabj9qsmkj dllhost.exe select B.*, B."ROWID" from tWe...
31,541 0 3.33 0fv9wbfyra9q0 dllhost.exe Select * from tWebComField whe...
31,541 0 3.33 dv7t3p1w4pn0f dllhost.exe Select * from tWebComField whe...
31,140 0 3.28 26twhcjg0m4rd dllhost.exe Select ComType from twebcomlog...
31,140 31,141 3.28 7rcsysu9557sv dllhost.exe Select ComType , twebcomlogin....
31,137 0 3.28 14nxsybunua07 dllhost.exe Select * from tWebComTable wh...
30,382 0 3.20 43yqd5khtcuth dllhost.exe Select * from tWebComField whe...
22,264 22,264 2.35 2uwmmnqdwxw57 dllhost.exe Select tWebComTable.*, tWebCom...
21,462 21,463 2.26 fcsw30vk481ab dllhost.exe Select tWebComField.*, tWebCom...
11,696 11,696 1.23 39dj638nh40zk HsCom.exe SELECT T.STARTDATE FROM TCVSPD...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
5,985,437 65 0.22 dzzpqr2ztvm6m HsCmpServer.exe SELECT tSkuPlu.*, tSkuPlu."ROW...
4,790,479 93 0.18 61dxxmtszm096 HsCmpServer.exe SELECT PluCode , BarCode , Car...
3,867,857 1,720 0.14 1ms7q0c0jgbrs HsCmpServer.exe SELECT tEtpCustomer.*, tEtpCus...
3,196,123 999 0.12 cjq91hg7qh6xd dllhost.exe SELECT ORGCODE , DEPID , ISHYD...
2,365,616 138 0.09 849gk14t5hav7 dllhost.exe SELECT CARDCODE , CARDID , CAR...
1,536,787 8 0.06 bw3ku8f10udvb HsCmpServer.exe SELECT Billno , OrgCode , OrgN...
1,527,287 35,322 0.06 3scwabj9qsmkj dllhost.exe select B.*, B."ROWID" from tWe...
1,515,765 122 0.06 42n46ckrhbpb2 HsCmpServer.exe SELECT Billno , Serialno , Plu...
1,259,783 9 0.05 6yj8z3nugrb3x HsCmpServer.exe SELECT count(*) FROM tProDscPl...
1,232,330 218 0.05 25af3drxuaqgb dllhost.exe SELECT BGNTIME , BILLNO , CARD...
1,082,251 163 0.04 13x01bd986fqn dllhost.exe SELECT BGNDATE , BGNTIME , BIL...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
375 28 aj42bn2u07xxc dllhost.exe UPDATE TCVSDBBODY SET TAG=:"SY...
301 68 dz3m6y0660j5n HsCom.exe select distinct BillNo, OrgCo...
287 999 cjq91hg7qh6xd dllhost.exe SELECT ORGCODE , DEPID , ISHYD...
286 138 849gk14t5hav7 dllhost.exe SELECT CARDCODE , CARDID , CAR...
175 33 9as33rwqkzsxp dllhost.exe SELECT BARCODE , BILLNO , CARG...
155 218 25af3drxuaqgb dllhost.exe SELECT BGNTIME , BILLNO , CARD...
150 10 091rmkuc80y8u dllhost.exe UPDATE TCVSTHBODY SET TAG=:"SY...
150 10 cpa7wp2th7tx2 dllhost.exe SELECT BARCODE , BILLNO , CARG...
148 11 absdr89pb19cy dllhost.exe UPDATE TCVSJHBODY SET TAG=:"SY...
136 20 fcgwk3qgp2zsr dllhost.exe UPDATE TCVSTHBODY SET TAG=:"SY...
124 163 13x01bd986fqn dllhost.exe SELECT BGNDATE , BGNTIME , BIL...
121 93 61dxxmtszm096 HsCmpServer.exe SELECT PluCode , BarCode , Car...
121 94 ax8tdc572zcny HsCmpServer.exe SELECT count(*) FROM tDstPsBod...
104 1,720 1ms7q0c0jgbrs HsCmpServer.exe SELECT tEtpCustomer.*, tEtpCus...
99 9 6yj8z3nugrb3x HsCmpServer.exe SELECT count(*) FROM tProDscPl...
96 65 dzzpqr2ztvm6m HsCmpServer.exe SELECT tSkuPlu.*, tSkuPlu."ROW...
90 122 42n46ckrhbpb2 HsCmpServer.exe SELECT Billno , Serialno , Plu...
88 86 gwck0qa3zvft8 dllhost.exe SELECT BGNDATE , BGNTIME , BIL...
77 28 59ybxu7r1g03f dllhost.exe UPDATE TCVSZDPSBODY SET TAG=:"...
76 25 2q9d3yh417u9h dllhost.exe UPDATE TCVSZDPSBODY SET TAG=:"...
68 35,322 3scwabj9qsmkj dllhost.exe select B.*, B."ROWID" from tWe...
67 10 5t2jkzcphbn4g dllhost.exe UPDATE TCVSJHBODY SET TAG=:"SY...
64 22,264 2uwmmnqdwxw57 dllhost.exe Select tWebComTable.*, tWebCom...
63 17 9j7tuj8mt5pmf dllhost.exe SELECT BARCODE , BILLNO , DATA...
57 21,463 fcsw30vk481ab dllhost.exe Select tWebComField.*, tWebCom...
57 21,463 fcsw30vk481ab dllhost.exe Select tWebComField.*, tWebCom...
44 12 6xdfuhg84tq0n dllhost.exe SELECT ISTH , ORGCODE , PLUID ...
42 3 4fnsr6wg9h81y dllhost.exe SELECT BARCODE , BILLNO , CARG...
36 2 a1hmw4xxaddsa dllhost.exe UPDATE TCVSDBBODY SET TAG=:"SY...
27 27 1kryh5j3tbyq1 HsCmpServer.exe SELECT Billno , Serialno , Plu...
26 27 8duwz1yy2k7cg HsCmpServer.exe SELECT count(*) FROM tDstPsDif...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
091rmkuc80y8uUPDATE TCVSTHBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND DATASTATE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
0fv9wbfyra9q0Select * from tWebComField where FaceCode=:"SYS_B_0"
13x01bd986fqnSELECT BGNDATE , BGNTIME , BILLNO , ENDDATE , ENDTIME , GENTYPE , GROUPNO , ORGCODE , PLUCODE , PLUID , PLUTYPE , POSCOMUPTYPE , PRI , PRICE , REMARK , UPD1 , UPD2 , UPD3 , UPD4 , UPD5 , UPTDATE , TPROCXZHZXORGGROUP."ROWID" FROM TPROCXZHZXORGGROUP WHERE ORGCODE=:"SYS_B_0" AND UPTDATE >=TO_DATE(:"SYS_B_1", :"SYS_B_2")
14nxsybunua07 Select * from tWebComTable where FaceCode=:"SYS_B_0" and ComItemCode=:"SYS_B_1" Order by IsMaster Desc, SerialNo
14sr6fg49gwfuINSERT INTO "TPOSPLUPARA" ("DSHOPNO", "DBARCODE", "DYEARAVG", "DMONTHAVG", "DWEEKAVG", "DTOTALAVG", "DUPDATEDATE") SELECT "A2"."DSHOPNO", "A2"."DBARCODE", "A2"."DYEARAVG", "A2"."DMONTHAVG", "A2"."DWEEKAVG", "A2"."DTOTALAVG", "A2"."DUPDATEDATE" FROM "TPOSPLUPARA"@! "A2"
1506ft6gwszrdUpdate tWebComLogin Set LastDate=sysdate where OrgCode=:"SYS_B_0"
1kryh5j3tbyq1SELECT Billno , Serialno , PluID , PluCode , PluName , PsPrice , CyCount , PsTotal , CyYy , (SELECT a.LxName FROM tBasFlContent a WHERE a.LxCode=tDstPsDifBody.CyYy AND FLCODE=:"SYS_B_0") AS CyYy$ , Remark , ExPluCode , ExPluName , PluType , CsCount , CkCode , CkName , IsPk , DotDecimal , OriCyCount , BarCode FROM tDstPsDifBody Where Billno=:"SYS_B_1"
1ms7q0c0jgbrsSELECT tEtpCustomer.*, tEtpCustomer."ROWID" FROM tEtpCustomer WHERE EtpCode=:"SYS_B_0" AND (OrgCode = :"SYS_B_1" and EtpAttribute = :"SYS_B_2" and IsActive = :"SYS_B_3" and YwStatus = :"SYS_B_4")
24c6vrzw1ug5g select B.* from tWebComItem B
25af3drxuaqgbSELECT BGNTIME , BILLNO , CARDLXCODE , ENDTIME , ISENABLED , LMTCOUNT , LMTTYPE , ORGCODE , PLUCODE , PLUID , POSCOMUPTYPE , PRI , UPTDATE , YHPRICE , YHRATE , YHTYPE , VPROCXHYPLU."ROWID" FROM VPROCXHYPLU WHERE UPTDATE >= TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"
26twhcjg0m4rdSelect ComType from twebcomlogin where OrgCode=:"SYS_B_0"
2gw4dt8v4gyjnSELECT BGNDATE, BGNTIME, BILLNO, CXTYPE, DATATYPE, ENDDATE, ENDTIME, ISENABLED, ISHYZSZ, LMTCOUNT, ORGCODE, PLUCODE, PLUID, POSCOMUPTYPE, PRI, UPTDATE, YHPRICE, YHRATE, YHTYPE FROM VPROCXPTPLU WHERE UPTDATE >= TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"
2q9d3yh417u9hUPDATE TCVSZDPSBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND DATASTATE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
2uwmmnqdwxw57Select tWebComTable.*, tWebComTable."ROWID" from tWebComTable where FaceCode=:"SYS_B_0" and ComItemCode=:"SYS_B_1" Order by IsMaster Desc, SerialNo
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
39dj638nh40zkSELECT T.STARTDATE FROM TCVSPDBODY T WHERE T.BILLNO=:B3 AND T.ORGCODE=:B2 AND T.SERIALNO = :B1
3rapz0p1df6qjDELETE FROM "TPOSPLUPARA" "A1" WHERE "A1"."DSHOPNO">=:"SYS_B_0" AND "A1"."DSHOPNO"<=:"SYS_B_1"
3scwabj9qsmkjselect B.*, B."ROWID" from tWebComItem B where B.FaceCode=:"SYS_B_0" and B.ComItemCode=:"SYS_B_1"
42n46ckrhbpb2SELECT Billno , Serialno , PluID , PluCode , PluName , BarCode , ExPluCode , ExPluName , Spec , Unit , PriceType , JdRate , PsPrice , PsTotal , PackUnit , PackQty , PackCount , SglCount , PsCount , PluType , DepID , DepCode , (SELECT a.DepName FROM tOrgDept a WHERE a.DepID=tDstPsBody.DepID ) AS DepName , (SELECT a.DotDecimal FROM tSkuPlu a WHERE a.PluID=tDstPsBody.PluID ) AS R_DotDecimal , Remark , DataSource , Tag , WPsPrice , WPsTotal , XTaxRate , XTaxTotal , PlnCount , SdCount , KwCode , Price , STotal , CargoNo , MaterialCode , CxYhTotal , CxMsg , YhBillNo , YhSerialno , RefSerialno , StlCurrPsPrice , StlCurrPsTotal , ChgType , (SELECT a.LxName FROM tBasFlContent a WHERE a.LxCode=tDstPsBody.ChgType AND FLCODE=:"SYS_B_0" AND LXCODE<:"SYS_B_1") AS ChgType$ , LsPrice , ZkRate , PsPlnBillNo , PsPlnSerialNo , ClsID , ClsCode , ClsName , ScDate , PzCode FROM tDstPsBody Where BillNo = :"SYS_B_2" ORDER BY KwCode, ClsCode, Pluname, Unit, PluCode
43yqd5khtcuthSelect * from tWebComField where FaceCode=:"SYS_B_0" And ComItemCode=:"SYS_B_1" And upper(SendTable)=:"SYS_B_2"
44hgw9cwssu0rINSERT INTO TPLUINCREASE_TMP (ORGCODE, DEPID, PLUID) SELECT ORGCODE, DEPID, PLUID FROM TSKUPLUEX A WHERE NOT EXISTS (SELECT * FROM TSKUGTPLU B WHERE A.ORGCODE = B.ORGCODE AND A.DEPID = B.DEPID AND A.PLUID = B.PLUID )
4fnsr6wg9h81ySELECT BARCODE , BILLNO , CARGONO , DATASTATE , DBCOUNT , DBORGCODE , DBORGNAME , DEPCODE , DEPID , DEPNAME , JZDATE , LRDATE , ORGCODE , PLUCODE , PLUID , PLUNAME , REMARK , SERIALNO , SPEC , UNIT , USERCODE , USERID , YWTYPE , TCVSDBBODY."ROWID" FROM TCVSDBBODY WHERE TAG<>:"SYS_B_0" AND YWTYPE=:"SYS_B_1" AND DATASTATE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
4wzc12hz2tx0m select B.* from tWebComItem B where B.FaceCode=:"SYS_B_0" and B.ComItemCode=:"SYS_B_1"
54uwsfvp7srsgBEGIN SJOB_GATHERSALES( :1 ); END;
59ybxu7r1g03fUPDATE TCVSZDPSBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND DATASTATE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
5cf7hmzgu3uvn select a.orgcode, a.etpname, a.udp1, a.udp2, a.hsxsje, a.wsxsje, a.hsml, a.hsmllv, a.wsml, nvl(b.hsxsje, :"SYS_B_00") as fw_hsxsje, nvl(b.wsxsje, :"SYS_B_01") as fw_wsxsje, nvl(b.hsml, :"SYS_B_02") as fw_hsml, nvl(b.hsmllv, :"SYS_B_03") as fw_hsmllv, nvl(b.wsml, :"SYS_B_04") as fw_wsml, a.hsxsje+nvl(b.hsxsje, :"SYS_B_05") as hz_hsxsje, a.wsxsje+nvl(b.wsxsje, :"SYS_B_06") as hz_wsxsje, a.hsml+nvl(b.hsml, :"SYS_B_07") as hz_hsml, a.wsml+nvl(b.wsml, :"SYS_B_08") as hz_wsml from ( select t.orgcode, g.etpname, f.udp1, f.udp2, sum(t.hxtotal) as hsxsje, sum(t.wxtotal) as wsxsje, sum(t.hmtotal) as hsml, round( sum(t.hmtotal)/(sum(t.hxtotal)+:"SYS_B_09") , :"SYS_B_10")*:"SYS_B_11" as hsmllv, sum(t.wmtotal) as wsml from ( select orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201301 where DataType in (:"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16") union all SELECT orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201302 where DataType in (:"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21") union all select orgcode, barcode, sstotal as hxtotal, sstotal as wxtotal , :"SYS_B_22" as hmtotal, :"SYS_B_23" as wmtotal, xsdate fro m tSalSaleplu where TranType<>:"SYS_B_24" and NOT SALENO LIKE :"SYS_B_25" ) t , tOrgExInfo f , tEtpEnterprise g where t.orgcode=f.orgcode and t.orgcode=g.etpcode and not t.barcode in (:"SYS_B_26", :"SYS_B_27", :"SYS_B_28", :"SYS_B_29", :"SYS_B_30", :"SYS_B_31", :"SYS_B_32", :"SYS_B_33", :"SYS_B_34", :"SYS_B_35", :"SYS_B_36", :"SYS_B_37", :"SYS_B_38", :"SYS_B_39", :"SYS_B_40", :"SYS_B_41", :"SYS_B_42") and t.xsdate >= to_date(:"SYS_B_43", :"SYS_B_44" ) and t.xsdate <= to_date(:"SYS_B_45", :"SYS_B_46") group by t.orgcode, g.etpname, f.udp1, f.udp2 ) a, --·þÎñÐÔÏîÄ¿ (select t.orgcode, sum(t.hxtotal) as hsxsje, sum(t.wxtotal) as wsxsje, sum(t.hmtotal) as hsml, round( sum(t.hmtotal)/(sum(t.hxtotal)+:"SYS_B_47") , :"SYS_B_48")*:"SYS_B_49" as hsmllv, sum(t.wmtotal) as wsml from ( select orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201301 where DataType in (:"SYS_B_50", :"SYS_B_51", :"SYS_B_52", :"SYS_B_53", :"SYS_B_54") union all SELECT orgcode, barcode, hxtotal, wxtotal, hmtotal, wmtotal, xsdate from tSalPluDetail201302 where DataType in (:"SYS_B _55", :"SYS_B_56", :"SYS_B_57", :"SYS_B_58", :"SYS_B_59") union all select orgcode, barcode, sstotal as hxtotal, sstotal as wxtotal , :"SYS_B_60" as hmtotal, :"SYS_B_61" as wmtotal, xsdate from tSalSaleplu where TranType<>:"SYS_B_62" and NOT SALENO LIKE :"SYS_B_63") t where t.barcode in (:"SYS_B_64", :"SYS_B_65", :"SYS_B_66", :"SYS_B_67", :"SYS_B_68", :"SYS_B_69", :"SYS_B_70", :"SYS_B_71", :"SYS_B_72", :"SYS_B_73", :"SYS_B_74", :"SYS_B_75", :"SYS_B_76", :"SYS_B_77", :"SYS_B_78", :"SYS_B_79", :"SYS_B_80") and t.xsdate >= to_date(:"SYS_B_81", :"SYS_B_82" ) and t.xsdate <= to_date(:"SYS_B_83", :"SYS_B_84") group by t.orgcode ) b where a.orgcode=b.orgcode(+)
5pk50wtr6uqvw INSERT INTO TORDCGJYKCDATA(INORGCODE, PLUID, DEPID, KCCOUNT, LOCKCOUNT, FRZCOUNT, KYCOUNT, ZTCOUNT, AVG1STCOUNT, MINCOUNT, MAXCOUNT, GENDATE, CKCODE) SELECT A.ORGCODE AS INORGCODE, A.PLUID, A.DEPID, NVL(C.KCCOUNT, 0) AS KCCOUNT, NVL(C.LOCKCOUNT, 0) AS LOCKCOUNT, NVL(C.FRZCOUNT, 0) AS FRZCOUNT, NVL(C.KCCOUNT, 0)-NVL(C.LOCKCOUNT, 0)-NVL(C.FRZCOUNT, 0) AS KYCOUNT, NVL((SELECT SUM(ZTCOUNT) FROM TORDTMPPLUZTKC_TMP WHERE HORGCODE=:B2 AND PLUID=A.PLUID AND CKCODE=:B1 ), 0) AS ZTCOUNT, NVL((SELECT SUM(AVGPSCOUNT) FROM TDSTCKDAYAVGPSCOUNT WHERE PLUID=A.PLUID AND CKCODE=:B1 AND ORGCODE=:B4 ), 0) AS AVG1STCOUNT, A.MINCOUNT, A.MAXCOUNT, :B3 AS GENDATE, :B1 FROM TSKUPLUEX A, (SELECT PLUID, SUM(KCCOUNT) AS KCCOUNT, (SELECT NVL(SUM(LOCKCOUNT), 0) FROM TSTKLSKCLOCK WHERE ORGCODE=:B2 AND PLUID=KC.PLUID AND CKCODE=:B1 AND EXISTS(SELECT * FROM TSTKSTORE WHERE ORGCODE=:B2 AND CKCODE=TSTKLSKCLOCK.CKCODE AND KCTYPE<='2') ) AS LOCKCOUNT, 0.00 AS FRZCOUNT FROM TSTKLSKC KC WHERE ORGCODE=:B2 AND CKCODE=:B1 AND EXISTS (SELECT * FROM TSTKSTORE WHERE ORGCODE=:B2 AND CKCODE=KC.CKCODE AND KCTYPE<='2') GROUP BY PLUID ) C, TSKUPLU D WHERE A.ORGCODE=:B2 AND A.PLUID=C.PLUID AND A.PLUID=D.PLUID AND A.ISJH='1' AND D.ISACTIVE='1' AND D.ISKC='1' AND EXISTS(SELECT 1 FROM TSKUETPPARAS WHERE ORGCODE=:B2 AND PLUID=A.PLUID)
5t2jkzcphbn4gUPDATE TCVSJHBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND YWTYPE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
5zhu4psa6zx33Select IsSelect, OrgCode, EtpCode, R_EtpName, PluID, R_PluCode, R_PluName, R_BarCode, R_Unit, R_Spec, R_CargoNo, R_Produce, R_ClsID, R_ClsCode, R_ClsName, ExPluCode, DepID, R_DepCode, R_DepName, PackUnit, PackQty, PackCount, SglCount, CgCount, YOrdCount, R_KyCount, R_QhStatus, YCgCount, GenDate, R_KcCount, R_LockCount, R_FrzCount, R_ZtCount, R_Avg1stCount, R_KxDays, R_RefXsCount, RgCount, ZnCount, QhclCount, HeCount, R_MinCount, R_MaxCount, R_DotDecimal, R_NewJhDate, R_NewHJPrice, R_NewWJPrice, R_CxBgnDate, R_CxEndDate, CxBhEnd_CxBgnDate, CxBhEnd_CxEndDate, CxBhBgn_CxBgnDate, CxBhBgn_CxEndDate, CxBh_CxBgnDate, CxBh_CxEndDate, Remark, DataSrc, R_DpCount, R_QhCount, R_JhCycle, R_PsCycle, R_AqDays, R_BzDays, R_IsTh, R_zzDays, R_FdKcCount, R_QszXsCount From vOrdCgJyHzSupFpAll A Where OrgCode=:"SYS_B_0" and CkCode=:"SYS_B_1" and R_ClsCode like :"SYS_B_2" and EtpCode=:"SYS_B_3" and Rownum<=:"SYS_B_4"
61dxxmtszm096SELECT PluCode , BarCode , CargoNo , MaterialCode , tSkuPlu."ROWID" FROM tSkuPlu WHERE (PluCode=:"SYS_B_00" Or CargoNo=:"SYS_B_01" Or BarCode=:"SYS_B_02" or MaterialCode=:"SYS_B_03") and IsActive=:"SYS_B_04" AND (IsActive = :"SYS_B_05" and IsKc = :"SYS_B_06" and YwStatus in ( :"SYS_B_07" , :"SYS_B_08" ) and exists ( select PluID from tSkuPluEx where OrgCode = :"SYS_B_09" and IsPs = :"SYS_B_10" and PluID = tSkuPlu.PluID ) and ( exists ( select * from tEtpCustomer where EtpCode = :"SYS_B_11" and EtpDstType = :"SYS_B_12" ) or exists ( select PluID from tSkuPluEx where OrgCode = :"SYS_B_13" and cgMode = :"SYS_B_14" and PluID = tSkuPlu.PluID )))
6fzqkjh00c8q0BEGIN sStk_FollowMeRece(:1, :2, :3, :4, :5, :6); END;
6xdfuhg84tq0nSELECT ISTH , ORGCODE , PLUID , POSCOMUPTYPE , UDP1 , UDP2 , UDP3 , UDP4 , UDP5 , UPTDATE , TCVSGTPLUUDP."ROWID" FROM TCVSGTPLUUDP WHERE ORGCODE=:"SYS_B_0" AND UPTDATE >=TO_DATE(:"SYS_B_1", :"SYS_B_2")
6yj8z3nugrb3xSELECT count(*) FROM tProDscPlu WHERE BillNo = :"SYS_B_0"
795tq5r6g30kxBEGIN SORD_CGJYGETKCDATA( :1, :2, :3, :4, :5, :6 ); END;
7rcsysu9557svSelect ComType , twebcomlogin."ROWID" from twebcomlogin where OrgCode=:"SYS_B_0"
849gk14t5hav7SELECT CARDCODE , CARDID , CARDPWD , CKRCODE , CKRID , CKRNAME , DATASTATUS , ENDDATE , FIELD1 , FIELD2 , FIELD3 , INITDATE , INVALIDDATE , ISALLCLEAR , ISPRESENT , ISRECEDE , ISREPRINT , ISVIEWREPORT , ISVOID , LRDATE , MAXRATE , MAXTOTAL , ORGCODE , ORGNAME , REMARK , USERCODE , USERID , USERNAME , YWSTATUS , TSALRIGHTCARD."ROWID" FROM TSALRIGHTCARD WHERE ORGCODE=:"SYS_B_0"
8duwz1yy2k7cgSELECT count(*) FROM tDstPsDifBody WHERE Billno=:"SYS_B_0"
9as33rwqkzsxpSELECT BARCODE , BILLNO , CARGONO , CGBILLNO , CKCODE , DATASTATE , DEPCODE , DEPID , DEPNAME , DHDATE , EXPLUCODE , EXPLUNAME , JHCOUNT , LRDATE , ORGCODE , PLUCODE , PLUID , PLUNAME , REALCOUNT , REMARK , SCDATE , SERIALNO , SPEC , SUPCODE , UNIT , USERCODE , USERID , YWTYPE , TCVSJHBODY."ROWID" FROM TCVSJHBODY WHERE TAG<>:"SYS_B_0" AND YWTYPE=:"SYS_B_1" AND ORGCODE=:"SYS_B_2"
9h6wvmuyqq55f Insert into tAcpJsCondition (OrgCode, HtID, YwBillNo, YwType, JsCode) Values (:"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4")
9j7tuj8mt5pmfSELECT BARCODE , BILLNO , DATASTATE , EXPLUCODE , EXPLUNAME , FHBGNDATE , FHENDDATE , FHTYPE , FHTYPE , FHTYPENAME , FHTYPENAME , JZDATE , LRDATE , MODIFYTYPE , MODIFYTYPENAME , ORGCODE , PLUCODE , PLUID , PLUNAME , PSCOUNT , REMARK , SERIALNO , SPEC , TAG , UDP1 , UDP2 , UDP3 , UDP4 , UDP5 , UNIT , USERCODE , USERID , USERNAME , TCVSZDPSBODY."ROWID" FROM TCVSZDPSBODY WHERE TAG<>:"SYS_B_0" AND DATASTATE=:"SYS_B_1" AND ORGCODE=:"SYS_B_2"
a1hmw4xxaddsaUPDATE TCVSDBBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND YWTYPE=:"SYS_B_2" AND DATASTATE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
absdr89pb19cyUPDATE TCVSJHBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND YWTYPE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
aj42bn2u07xxcUPDATE TCVSDBBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND YWTYPE=:"SYS_B_3" AND DATASTATE=:"SYS_B_4" AND ORGCODE=:"SYS_B_5"
ax8tdc572zcnySELECT count(*) FROM tDstPsBody WHERE BillNo = :"SYS_B_0"
bbqp1ywqmvhv2 SELECT '['||TO_CHAR(D1.CLSCODE)||']'||D1.CLSNAME AS BM , '['||TO_CHAR(D2.CLSCODE)||']'||D2.CLSNAME AS DL , '['||TO_CHAR(D3.CLSCODE)||']'||D3.CLSNAME AS ZL , '['||TO_CHAR(D.CLSCODE)||']'||D.CLSNAME AS XFL, S.PLUCODE, S.PLUNAME, S.BARCODE, S.SPEC, S.UNIT, CASE UDP10 WHEN '1' THEN 'Õý³£' WHEN '2' THEN '²»Òª¿É·¢' WHEN '3' THEN '²»Òª²»·¢' WHEN '4' THEN 'Ô¤ÌÔÌ­' WHEN '5' THEN 'Í£ÊÛÇåÍË' WHEN '6' THEN 'ÌÔÌ­' ELSE '䶨Òå' END AS YWSTATUS , NVL(H.HJPRICE, S.HJPRICE) AS HJPRICE, NVL(HX.MINHJPRICE, H.HJPRICE) AS MINHJPRICE , NVL(H.WJPRICE, S.WJPRICE) AS WJPRICE, NVL(F.PRICE, S.PRICE) AS PRICE, NVL(F.HYPRICE, S.HYPRICE) AS HYPRICE, CASE S.UDP1 WHEN '1' THEN '²»ÄÜÍË' WHEN '2'THEN '¹ýÆÚÍË' WHEN '3' THEN 'ÁÙ½ü±£ÖÊÆÚ1/6ÍË' WHEN '4' THEN '³§¼Ò»»»õ' ELSE '䶨Òå' END AS UDP1 , S.UDP2, S.UDP3, S.UDP4, HT.HTNAME AS ETPNAME, S.UDP5, S.UDP6, S.UDP7, S.UDP8, H.JTAXRATE, H.JTAXCALTYPE, S.LRDATE, S.LRUSERCODE, S.LRUSERNAME, F.ISJH, F.ISTH, F.ISPS, F.ISJS, F.ISSALE, F.ISSALETH, F.ISCANPRESENT, H.ISTH, S.PLUMN, S.PLUWEIGHT, S.PLUWIDTH, S.PLUHEIGHT, S.PLUHEIGHT, S.PLULONG, S.CGYNAME, S.PRODUCE, S.PLUID, NVL(SPCZ.PACKQTY, 0) AS ZJXS , NVL(SPFD.PACKQTY, 0) AS ZXFHL , CASE HT.JYMODE WHEN '0' THEN '¾­Ïú' WHEN '1' THEN '´úÏú' WHEN '2' THEN 'ÁªÏú' WHEN '3' THEN '×âÁÞ' ELSE 'ÎÞ' END AS JYMODE , CASE HT.JSCODE WHEN '0' THEN '¾­Ïú½áËã' WHEN '1' THEN '´úÏú½áËã' WHEN '2' THEN 'ÁªÏú½áËã' WHEN '3' THEN '×â½ð½áËã' ELSE 'ÎÞ' END JSCODE, HT.YQDAYS, HT.ZQDAYS, NVL(FXDS.FXJS, 0) AS FXJS, NVL(YHDS.YHJ S, 0) AS YHJS, NVL(S.BRANDCODE, 'ÎÞ') AS BRANDCODE, NVL(P.BRANDNAME, 'ÎÞ') AS BRANDNAME, F.AQDAYS FROM (SELECT PLUID, PLUCODE, PLUNAME, PLUENAME, PLUABBRNAME, PLUMN, BARCODE, UNIT, SPEC, PLUWEIGHT, PLUHEIGHT, PLULONG, PLUWIDTH, ISMULPACKET, ORGCODE, ORGNAME, CGYID, CGYCODE, CGYNAME, CARGONO, PRODUCE, GRADE, QUALITY, ISSEASON, SALESEASON, BZDAYS, CASE LENGTH(CLSID) WHEN 11 THEN '8'||SUBSTR(PLUCODE, 0, 4)||'01' +0 ELSE CLSID END CLSID, BRANDCODE, JTAXCALTYPE, WJPRICE, HJPRICE, JTAXRATE, PRICE, XTAXRATE, PROMDECIMAL, PROMFORMULA, DOTDECIMAL, ISWEIGHT, ISCOUTQTY, ISSELFBRAND, ISKC, ISFRESH, ISEXPLUCODE, ISCURRDAY, JHBFBZDAYS, PSBFBZDAYS, ISNEWPLU, ISACTIVE, CXINFO, YWSTATUS, LRDATE, LRUSERID, LRUSERCODE, LRUSERNAME, ZXDATE, ZXUSERID, ZXUSERCODE, ZXUSERNAME, UDP1, UDP2, UDP3, UDP4, UDP5, UDP6, UDP7, UDP8, UDP9, DATASTATUS, HYPRICE, PLUCLS, PLUMODEL, UDP10, UDP11, UDP12, UDP13, UDP14, MATERIALCODE, LRORGCODE, LRORGNAME, DATASRC FROM TSKUPLU ) S, TBASBRAND P, (SELECT * FROM TSKUPLUEX WHERE ORGCODE='WDF00')F, (SELECT X.HTCODE, H.* FROM TCNTCONTRACT X, TCNTPLU H WHERE X.CNTID=H.CNTID ) H, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D) D, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D ) D1, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D) D2, ( SE L ECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D ) D3 , (SELECT * FROM TSKUPLUPACKET WHERE ISPUR='1' )SPCZ, ( SELECT * FROM TSKUPLUPACKET WHERE ISDIST='1') SPFD , (SELECT M.PLUID, MIN(M.HJPRICE) AS MINHJPRICE FROM TORDJHHEAD P, TORDJHBODY M WHERE P.BILLNO=M.BILLNO AND P.YWTYPE='0904' GROUP BY M.PLUID) HX, TCNTCONTRACT HT , ( SELECT F.PLUID, COUNT(F.ORGCODE) AS FXJS FROM TSKUPLUEX F WHERE LENGTH(F.ORGCODE)=4 AND F.ISJH='1' GROUP BY F.PLUID ) FXDS, (SELECT PLUID, COUNT(ORGCODE) AS YHJS FROM ( SELECT A.ORGCODE , A.PLUID, SUM(A.KCCOUNT) AS KCSL FROM TSTKLSKC A WHERE LENGTH(A.ORGCODE)= 4 GROUP BY A.ORGCODE , A.PLUID HAVING SUM(A.KCCOUNT)>0 ) N1 GROUP BY PLUID ) YHDS WHERE SUBSTR(S.CLSID, 2, 2)=D1.CLSCODE(+) AND SUBSTR(S.CLSID, 2, 3)=D2.CLSCODE(+) AND SUBSTR(S.CLSID, 2, 4)=D3.CLSCODE(+) AND S.CLSID=D.CLSID(+) AND S.UDP4=HT.HTCODE(+) AND S.PLUID=H.PLUID(+) AND S.UDP4=H.HTCODE(+) AND S.PLUID= F.PLUID(+) AND S.PLUID=HX.PLUID(+) AND S.PLUID=SPCZ.PLUID(+) AND S.PLUID= SPFD.PLUID(+) AND S.PLUID=FXDS.PLUID(+) AND S.PLUID=YHDS.PLUID(+) AND S.BRANDCODE=P.BRANDCODE(+) AND EXISTS (SELECT 1 FROM TUSRRIGHTORG A, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D) C WHERE A.USERID=:B1 AND C.CLSID = S.CLSID AND C.CLSCODE LIKE A.DEPCODE||'%')
bw3ku8f10udvb SELECT Billno , OrgCode , OrgName , InOrgCode , DepID , DepCode , (SELECT RTRIM(LTRIM(a.DepName)) FROM tOrgDept a WHERE a.DepID=tDstPsHead.DepID ) AS DepCode$ , (SELECT a.DepName FROM tOrgDept a WHERE a.DepID=tDstPsHead.DepID ) AS DepName , CkCode , CkName , Orgtype , ShOrgCode , ShOrgName , InShOrgCode , LinkTel , QrType , PsType , CntID , HtCode , HtName , JyMode , JsCode , LrDate , UserId , UserCode , UserName , JzDate , JzrID , JzrCode , JzrName , TjDate , TjrID , TjrCode , TjrName , HzDate , RptDate , PrnTimes , PrnDate , TimeMark , YwType , (SELECT a.YwTypeName FROM tSysYwType a WHERE a.YwType=tDstPsHead.YwType) AS YwType$ , YwIOType , GenType , Remark , JzType , RefBillNo , IsNeedTjWl , DataStatus , YwStatus , CKMode , PsCount , PsTotal , RefBillType , (SELECT a.YwTypeName FROM tSysYwType a WHERE a.YwType=tDstPsHead.RefBillType) AS RefBillType$ , (SELECT a.PsArea FROM vEtpCustomer a WHERE a.EtpCode=tDstPsHead.ShOrgCode AND ORGCODE=:"SYS_B_00" ) AS PsArea , DataSource , (SELECT a.Address FROM vEtpCustomer a WHERE a.EtpCode=tDstPsHead.ShOrgCode AND ORGCODE=:"SYS_B_01" ) AS Address , (SELECT a.Linkman FROM vEtpCustomer a WHERE a.EtpCode=tDstPsHead.ShOrgCode AND ORGCODE=:"SYS_B_02" ) AS LinkMan , (SELECT a.HCost FROM tStkKcJzHead a WHERE a.YwBillNo=tDstPsHead.Billno AND YWTYPE=:"SYS_B_03" ) AS HCost , (SELECT a.WCost FROM tStkKcJzHead a WHERE a.YwBillNo=tDstPsHead.Billno AN D YWTYPE=:"SYS_B_04" ) AS WCost , (SELECT a.EmpName FROM vEtpCustomer a WHERE a.EtpCode=tDstPsHead.ShOrgCode AND ORGCODE=:"SYS_B_05" ) AS EmpName , WPsTotal , XTaxTotal , PlnCount , SdCount , WlAreaCode , IsUrgent , PlnShDate , WlAreaName , STotal , ShType , PsPath , PathSerialNo , FhBillNo , ShEtpCode , ShEtpName , CxYhTotal , CurrCode , (SELECT a.CurrName FROM tBasCurrency a WHERE a.CurrCode=tDstPsHead.CurrCode) AS CurrCode$ , ExchangeRate , StlCurrPsTotal , IsStdCurr , PreYsYeTotal , PieceCount , IsRcpXd FROM tDstPsHead Where (LrDate between :"SYS_B_06" and :"SYS_B_07" and ( ShOrgCode Like :"SYS_B_08" ) and ( YwType <> :"SYS_B_09" or PsType <> :"SYS_B_10" ) and ((( tDstPsHead.OrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_11" connect by Prior OrgCode = PreOrgCode ) ) or tDstPsHead.OrgCode = :"SYS_B_12" ) or tDstPsHead.ShOrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_13" connect by Prior OrgCode = PreOrgCode ))))) and rownum <= :"SYS_B_14"
c7s87nurt7yqzSelect IsSelect, OrgCode, EtpCode, R_EtpName, PluID, R_PluCode, R_PluName, R_BarCode, R_Unit, R_Spec, R_CargoNo, R_Produce, R_ClsID, R_ClsCode, R_ClsName, ExPluCode, DepID, R_DepCode, R_DepName, PackUnit, PackQty, PackCount, SglCount, CgCount, YOrdCount, R_KyCount, R_QhStatus, YCgCount, GenDate, R_KcCount, R_LockCount, R_FrzCount, R_ZtCount, R_Avg1stCount, R_KxDays, R_RefXsCount, RgCount, ZnCount, QhclCount, HeCount, R_MinCount, R_MaxCount, R_DotDecimal, R_NewJhDate, R_NewHJPrice, R_NewWJPrice, R_CxBgnDate, R_CxEndDate, CxBhEnd_CxBgnDate, CxBhEnd_CxEndDate, CxBhBgn_CxBgnDate, CxBhBgn_CxEndDate, CxBh_CxBgnDate, CxBh_CxEndDate, Remark, DataSrc, R_DpCount, R_QhCount, R_JhCycle, R_PsCycle, R_AqDays, R_BzDays, R_IsTh, R_zzDays, R_FdKcCount, R_QszXsCount From vOrdCgJyHzSupFpAll A Where OrgCode=:"SYS_B_0" and CkCode=:"SYS_B_1" and EtpCode=:"SYS_B_2" and Rownum<=:"SYS_B_3"
cjq91hg7qh6xdSELECT ORGCODE , DEPID , ISHYDSC , ISPLDSC , ISXLDSC , ISPTDSC , ISPACKDSC , SPEC , UNIT , BARCODE , PLUMN , UPTDATE , POSCOMUPTYPE , POSCOMCURNO , BRANDCODE , CLSCODE , CLSID , UPTFLAG , ISMINPRICE , ISPRESENT , ISCANPRESENT , ISCANSALETH , ISCANSALE , MAXPRICE , MINPRICE , ISCOUTQTY , ISWEIGHT , PLUTYPE , PROMFORMULA , PROMDECIMAL , XTAXRATE , DOTDECIMAL , PRICE , HYPRICE , ISZEROSALE , ISKCNOW , ISKC , ISCERTIDSC , PLUENAME , DEPCODE , PLUID , PLUCODE , PLUNAME , DEPNAME , PLUABBRNAME , VSKUGTPLU."ROWID" FROM VSKUGTPLU WHERE ORGCODE=:"SYS_B_0" AND UPTDATE >=TO_DATE(:"SYS_B_1", :"SYS_B_2")
cpa7wp2th7tx2SELECT BARCODE , BILLNO , CARGONO , CKCODE , DATASTATE , DEPCODE , DEPID , DEPNAME , EXPLUCODE , EXPLUNAME , JZDATE , LRDATE , ORGCODE , PLUCODE , PLUID , PLUNAME , REASON , REMARK , SERIALNO , SPEC , SUPCODE , THCOUNT , TJDATE , UNIT , USERCODE , USERID , YWTYPE , TCVSTHBODY."ROWID" FROM TCVSTHBODY WHERE TAG<>:"SYS_B_0" AND DATASTATE=:"SYS_B_1" AND ORGCODE=:"SYS_B_2"
cz85cv85maqjyInsert into tSysLog (LogTime, OrgCode, UserId, UserCode, UserName, Computer, LoginPos, LogPosition, LogContent, LogType) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dtj01urbaanhzSELECT BARCODE, DEPCODE, DEPID, KCCOUNT, ORGCODE, PLUCODE, PLUID, PLUNAME, PRICE FROM VCVSKCCOUNT WHERE ORGCODE=:"SYS_B_0"
dv7t3p1w4pn0fSelect * from tWebComField where FaceCode=:"SYS_B_0" And ComItemCode=:"SYS_B_1"
dz3m6y0660j5n select distinct BillNo, OrgCode from tCvsDbBody where BillNo=:"SYS_B_0" and DataState=:"SYS_B_1"
dzzpqr2ztvm6mSELECT tSkuPlu.*, tSkuPlu."ROWID" FROM tSkuPlu WHERE (PluCode=:"SYS_B_00" Or CargoNo=:"SYS_B_01" Or BarCode=:"SYS_B_02" or MaterialCode=:"SYS_B_03") and IsActive=:"SYS_B_04" AND (IsActive = :"SYS_B_05" and IsKc = :"SYS_B_06" and YwStatus in ( :"SYS_B_07" , :"SYS_B_08" ) and exists ( select PluID from tSkuPluEx where OrgCode = :"SYS_B_09" and IsPs = :"SYS_B_10" and PluID = tSkuPlu.PluID ) and ( exists ( select * from tEtpCustomer where EtpCode = :"SYS_B_11" and EtpDstType = :"SYS_B_12" ) or exists ( select PluID from tSkuPluEx where OrgCode = :"SYS_B_13" and cgMode = :"SYS_B_14" and PluID = tSkuPlu.PluID )))
fcgwk3qgp2zsrUPDATE TCVSTHBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND DATASTATE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
fcsw30vk481abSelect tWebComField.*, tWebComField."ROWID" from tWebComField where FaceCode=:"SYS_B_0" And ComItemCode=:"SYS_B_1" And upper(SendTable)=:"SYS_B_2"
fr4uqtgmvgwa0INSERT INTO TTMPSKUGTPLU (ORGCODE, DEPID, PLUID, ISKC, ISKCNOW, ISPACKDSC, ISPTDSC, ISXLDSC, ISPLDSC, ISHYDSC, ISCERTIDSC, UPTFLAG, POSCOMUPTYPE, DEPFLAG) SELECT X.ORGCODE, X.DEPID, X.PLUID , '1', '1', '0', '0', '0', '0', '0', '0', '1', '0' , '0' FROM (SELECT A.ORGCODE, A.DEPID, A.PLUID FROM TSKUPLUEX A, TORGMANAGE B, TSTKSTORE E, TPLUINCREASE_TMP C WHERE EXISTS(SELECT D.ORGCODE FROM TSTKLSKC D WHERE A.ORGCODE=D.ORGCODE AND A.DEPID=D.DEPID AND E.CKCODE=D.CKCODE AND A.PLUID=D.PLUID) AND A.ORGCODE=C.ORGCODE AND A.PLUID=C.PLUID AND A.DEPID=C.DEPID AND A.DEPID<>0 AND A.ORGCODE=B.ORGCODE AND B.ISENABLE='1' AND A.ORGCODE=E.ORGCODE AND E.CKTYPE='0' ) X, TSKUPLU Z WHERE X.PLUID=Z.PLUID AND Z.ISACTIVE='1' AND Z.ISKC='1' AND NOT EXISTS(SELECT 1 FROM TTMPSKUGTPLU B WHERE X.PLUID = B.PLUID AND X.DEPID = B.DEPID AND X.ORGCODE = B.ORGCODE)
ftkpvbpb4yjnyDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN sSys_HsCmp_GtPluForJob; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
gjbjrmkrw4424select sysdate , dual."ROWID" from dual
grwydz59pu6mcselect text from view$ where rowid=:1
gsu79x1f2hnkjSELECT QID_TSYSLOG_LOGID.NEXTVAL FROM DUAL
gwck0qa3zvft8SELECT BGNDATE , BGNTIME , BILLNO , ENDDATE , ENDTIME , ORGCODE , PLUCODE , PLUCOUNT , PLUID , POSCOMUPTYPE , PRI , UPTDATE , YHPRICE , VPROCXZHZXPLU."ROWID" FROM VPROCXZHZXPLU WHERE UPTDATE >= TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 705,593 195.10 41.20
CPU used when call started 695,540 192.32 40.62
CR blocks created 301,051 83.24 17.58
Cached Commit SCN referenced 3,039 0.84 0.18
Commit SCN cached 4 0.00 0.00
DB time 10,760,256 2,975.20 628.34
DBWR checkpoint buffers written 289,248 79.98 16.89
DBWR checkpoints 19 0.01 0.00
DBWR object drop buffers written 0 0.00 0.00
DBWR revisited being-written buffer 537 0.15 0.03
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 135,896 37.58 7.94
DBWR transaction table writes 316 0.09 0.02
DBWR undo block writes 230,789 63.81 13.48
IMU CR rollbacks 67 0.02 0.00
IMU Flushes 4,039 1.12 0.24
IMU Redo allocation size 43,637,908 12,065.84 2,548.20
IMU commits 10,224 2.83 0.60
IMU contention 43 0.01 0.00
IMU ktichg flush 386 0.11 0.02
IMU pool not allocated 4,361 1.21 0.25
IMU recursive-transaction flush 6 0.00 0.00
IMU undo allocation size 88,679,136 24,519.69 5,178.34
IMU- failed to get a private strand 4,361 1.21 0.25
RowCR - row contention 30 0.01 0.00
RowCR attempts 86,128 23.81 5.03
RowCR hits 87,461 24.18 5.11
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 2 0.00 0.00
SQL*Net roundtrips to/from client 728,585 201.45 42.55
SQL*Net roundtrips to/from dblink 232 0.06 0.01
active txn count during cleanout 586,915 162.28 34.27
application wait time 20,212 5.59 1.18
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 15 0.00 0.00
background checkpoints started 19 0.01 0.00
background timeouts 13,103 3.62 0.77
branch node splits 103 0.03 0.01
buffer is not pinned count 43,876,916 12,131.92 2,562.16
buffer is pinned count 147,813,007 40,870.14 8,631.42
bytes received via SQL*Net from client 272,273,613 75,283.37 15,899.19
bytes received via SQL*Net from dblink 167,451 46.30 9.78
bytes sent via SQL*Net to client 5,656,363,003 1,563,978.54 330,298.57
bytes sent via SQL*Net to dblink 57,195 15.81 3.34
calls to get snapshot scn: kcmgss 1,508,347 417.06 88.08
calls to kcmgas 665,558 184.03 38.86
calls to kcmgcs 307,780 85.10 17.97
change write time 91,554 25.31 5.35
cleanout - number of ktugct calls 612,898 169.47 35.79
cleanouts and rollbacks - consistent read gets 220,858 61.07 12.90
cleanouts only - consistent read gets 2,758 0.76 0.16
cluster key scan block gets 1,337,927 369.94 78.13
cluster key scans 565,071 156.24 33.00
commit batch performed 3 0.00 0.00
commit batch requested 3 0.00 0.00
commit batch/immediate performed 342 0.09 0.02
commit batch/immediate requested 342 0.09 0.02
commit cleanout failures: block lost 90,139 24.92 5.26
commit cleanout failures: buffer being written 10 0.00 0.00
commit cleanout failures: callback failure 307 0.08 0.02
commit cleanout failures: cannot pin 340 0.09 0.02
commit cleanouts 234,231 64.76 13.68
commit cleanouts successfully completed 143,435 39.66 8.38
commit immediate performed 339 0.09 0.02
commit immediate requested 339 0.09 0.02
commit txn count during cleanout 108,365 29.96 6.33
concurrency wait time 4,409,188 1,219.14 257.47
consistent changes 51,085,488 14,125.08 2,983.09
consistent gets 339,549,105 93,884.98 19,827.68
consistent gets - examination 87,531,393 24,202.34 5,111.32
consistent gets direct 191 0.05 0.01
consistent gets from cache 339,548,916 93,884.93 19,827.67
current blocks converted for CR 6,047 1.67 0.35
cursor authentications 4,950 1.37 0.29
data blocks consistent reads - undo records applied 49,147,295 13,589.18 2,869.92
db block changes 28,141,228 7,781.02 1,643.28
db block gets 47,161,552 13,040.12 2,753.96
db block gets direct 665 0.18 0.04
db block gets from cache 47,160,887 13,039.94 2,753.92
deferred (CURRENT) block cleanout applications 63,692 17.61 3.72
dirty buffers inspected 163,235 45.13 9.53
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 3,231 0.89 0.19
enqueue deadlocks 0 0.00 0.00
enqueue releases 458,158 126.68 26.75
enqueue requests 458,295 126.72 26.76
enqueue timeouts 26 0.01 0.00
enqueue waits 275 0.08 0.02
exchange deadlocks 33 0.01 0.00
execute count 839,612 232.15 49.03
failed probes on index block reclamation 268 0.07 0.02
frame signature mismatch 0 0.00 0.00
free buffer inspected 27,728,925 7,667.02 1,619.21
free buffer requested 23,316,673 6,447.04 1,361.56
global undo segment hints helped 1 0.00 0.00
heap block compress 353,287 97.68 20.63
hot buffers moved to head of LRU 6,008,016 1,661.21 350.83
immediate (CR) block cleanout applications 223,616 61.83 13.06
immediate (CURRENT) block cleanout applications 134,722 37.25 7.87
index crx upgrade (found) 5 0.00 0.00
index crx upgrade (positioned) 51,072 14.12 2.98
index fast full scans (full) 18,189 5.03 1.06
index fetch by key 6,102,294 1,687.28 356.34
index scans kdiixs1 30,111,345 8,325.76 1,758.33
leaf node 90-10 splits 175 0.05 0.01
leaf node splits 25,168 6.96 1.47
lob reads 481 0.13 0.03
lob writes 48 0.01 0.00
lob writes unaligned 48 0.01 0.00
local undo segment hints helped 0 0.00 0.00
local undo segment hints were stale 0 0.00 0.00
logons cumulative 889 0.25 0.05
messages received 37,071 10.25 2.16
messages sent 37,075 10.25 2.16
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 250,727,405 69,325.87 14,641.02
opened cursors cumulative 1,243,575 343.85 72.62
parse count (failures) 87,655 24.24 5.12
parse count (hard) 258,249 71.41 15.08
parse count (total) 948,134 262.16 55.37
parse time cpu 35,269 9.75 2.06
parse time elapsed 86,181 23.83 5.03
physical read IO requests 2,033,202 562.18 118.73
physical read bytes 1.9E+11 52,577,733.51 11,103,956.78
physical read total IO requests 2,071,903 572.88 120.99
physical read total bytes 1.9E+11 52,750,695.84 11,140,484.91
physical read total multi block requests 1,557,773 430.72 90.96
physical reads 23,212,312 6,418.18 1,355.46
physical reads cache 22,664,286 6,266.65 1,323.46
physical reads cache prefetch 20,650,026 5,709.71 1,205.84
physical reads direct 548,026 151.53 32.00
physical reads direct (lob) 185 0.05 0.01
physical reads direct temporary tablespace 547,835 151.48 31.99
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 290,684 80.37 16.97
physical write bytes 8,258,125,824 2,283,363.28 482,226.33
physical write total IO requests 310,293 85.80 18.12
physical write total bytes 12,096,023,040 3,344,537.91 706,337.11
physical write total multi block requests 69,541 19.23 4.06
physical writes 1,008,072 278.73 58.87
physical writes direct 555,134 153.49 32.42
physical writes direct (lob) 12 0.00 0.00
physical writes direct temporary tablespace 554,689 153.37 32.39
physical writes from cache 452,938 125.24 26.45
physical writes non checkpoint 900,400 248.96 52.58
pinned buffers inspected 2,743 0.76 0.16
pinned cursors current 66 0.02 0.00
prefetch clients - default 209 0.06 0.01
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 149,880 41.44 8.75
process last non-idle time 3,743 1.03 0.22
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 3,412,010 943.42 199.24
recursive cpu usage 107,687 29.78 6.29
redo blocks written 7,288,811 2,015.35 425.62
redo buffer allocation retries 3,484 0.96 0.20
redo entries 13,913,156 3,846.97 812.45
redo log space requests 29,859 8.26 1.74
redo log space wait time 1,760,550 486.79 102.81
redo ordering marks 227,445 62.89 13.28
redo size 3,604,972,424 996,771.16 210,509.34
redo subscn max counts 335,115 92.66 19.57
redo synch time 835,207 230.93 48.77
redo synch writes 17,047 4.71 1.00
redo wastage 4,934,912 1,364.50 288.17
redo write time 158,316 43.77 9.24
redo writer latching time 76 0.02 0.00
redo writes 13,925 3.85 0.81
rollback changes - undo records applied 56,916 15.74 3.32
rollbacks only - consistent read gets 86,084 23.80 5.03
root node splits 1 0.00 0.00
rows fetched via callback 3,927,889 1,086.06 229.37
session connect time 0 0.00 0.00
session cursor cache hits 536,535 148.35 31.33
session logical reads 386,710,829 106,925.15 22,581.65
shared hash latch upgrades - no wait 195,301 54.00 11.40
shared hash latch upgrades - wait 10 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 407,859 112.77 23.82
sorts (rows) 15,994,722 4,422.52 934.00
space was found by tune down 0 0.00 0.00
space was not found by tune down 0 0.00 0.00
sql area evicted 171,028 47.29 9.99
sql area purged 16,193 4.48 0.95
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 2,346,931 648.92 137.05
switch current to new buffer 32,015 8.85 1.87
table fetch by rowid 72,966,260 20,175.10 4,260.80
table fetch continued row 58,155 16.08 3.40
table scan blocks gotten 76,394,075 21,122.88 4,460.97
table scan rows gotten 4,339,070,849 1,199,748.62 253,376.40
table scans (direct read) 0 0.00 0.00
table scans (long tables) 91 0.03 0.01
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 160,106 44.27 9.35
total number of times SMON posted 2 0.00 0.00
transaction rollbacks 342 0.09 0.02
transaction tables consistent read rollbacks 5 0.00 0.00
transaction tables consistent reads - undo records applied 222 0.06 0.01
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 1,687,487,956 466,588.68 98,539.44
user I/O wait time 2,668,889 737.95 155.85
user calls 1,376,098 380.49 80.36
user commits 16,803 4.65 0.98
user rollbacks 322 0.09 0.02
workarea executions - onepass 41 0.01 0.00
workarea executions - optimal 119,072 32.92 6.95
write clones created in background 26 0.01 0.00
write clones created in foreground 39,179 10.83 2.29

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 1.8E+11 1.9E+11
session cursor cache count 10,381,835 10,418,271
session uga memory 1.1E+14 1.1E+14
opened cursors current 1,344 1,472
workarea memory allocated 139,195 212,460
logons current 74 125
session uga memory max 1.1E+12 1.1E+12
session pga memory 26,690,720,880 26,873,054,872

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 19 18.91

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
HSCMP_TBL_SAL 1,047,325 290 2.36 15.39 4,704 1 1,397 18.08
HSCMP_TBL 622,276 172 23.62 7.81 105,062 29 81,428 538.12
HSCMP_TBL_STK_P 156,040 43 4.20 6.96 6,872 2 0 0.00
HSCMP_IDX 144,092 40 45.24 1.12 8,094 2 12,890 24.73
UNDOTBS1 715 0 94.99 1.00 126,933 35 1,100 437.06
HSCMP_TEMP 17,817 5 51.39 30.77 35,676 10 0 0.00
SYSTEM 7,613 2 68.15 1.03 266 0 0 0.00
SYSAUX 1,080 0 48.17 1.03 401 0 0 0.00
HSCMP_TBL_STK 385 0 37.82 4.06 380 0 4 2.50
HSCMP_TBL_LOG 38 0 87.63 1.00 96 0 23 4.78
TEMP 3 0 173.33 1.00 0 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
HSCMP_IDX /home/oracle/oradata/orcl/HSCMP_IDX.dbf 27,220 8 51.58 1.12 2,189 1 2,640 25.63
HSCMP_IDX /home/oracle/oradata/orcl/HSCMP_IDX01.dbf 19,110 5 49.27 1.12 923 0 1,701 27.64
HSCMP_IDX /home/oracle/oradata/orcl/HSCMP_IDX2.dbf 21,336 6 52.42 1.14 1,080 0 2,124 25.34
HSCMP_IDX /home/oracle/oradata/orcl/HSCMP_IDX23.dbf 23,846 7 37.61 1.10 1,259 0 1,836 26.63
HSCMP_IDX /home/oracle/oradata/orcl/HSCMP_IDX3.dbf 26,435 7 31.12 1.06 1,506 0 1,397 18.24
HSCMP_IDX /home/oracle/oradata/orcl/hscmp_idx1.dbf 26,145 7 51.04 1.17 1,137 0 3,192 23.78
HSCMP_TBL /home/oracle/oradata/orcl/HSCMP_TBL.dbf 33,413 9 40.72 5.92 4,078 1 3,615 19.75
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl1.dbf 29,486 8 38.89 6.79 3,257 1 2,434 51.48
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl10.dbf 24,423 7 10.81 10.69 3,148 1 666 4.52
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl11.dbf 14,837 4 8.17 11.82 3,066 1 2,522 4.26
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl12.dbf 20,065 6 16.30 9.64 3,143 1 1,537 3.45
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl13.dbf 17,549 5 21.34 7.97 3,790 1 658 4.12
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl14.dbf.dbf 20,924 6 10.22 8.63 5,879 2 91 38.68
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl15.dbf 16,471 5 18.31 8.42 4,473 1 70 48.00
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl16.dbf 14,761 4 15.70 9.52 4,414 1 48 37.92
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl17.dbf 19,008 5 12.90 9.13 4,520 1 37 20.81
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl18.dbf 12,755 4 19.76 8.62 6,357 2 36 22.50
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl19.dbf 12,812 4 16.15 8.30 5,849 2 47 19.36
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl2.dbf 27,498 8 44.27 5.65 4,316 1 2,287 34.60
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl20.dbf 12,507 3 24.96 7.50 3,127 1 36 12.78
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl21.dbf 20,521 6 8.30 7.19 7,418 2 146 16.37
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl22.dbf 14,648 4 12.39 8.72 3,575 1 0 0.00
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl23.dbf 15,245 4 16.49 7.91 1,934 1 5 38.00
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl24.dbf 16,305 5 19.03 7.68 2,102 1 26 77.69
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl25.dbf 18,510 5 11.07 7.26 371 0 1 120.00
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl26.dbf 17,679 5 10.27 7.62 411 0 1,590 2.97
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl27.dbf 10,375 3 11.73 8.99 560 0 1,879 0.20
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl28.dbf 9,141 3 16.02 7.51 525 0 585 1.09
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl29.dbf 6,845 2 16.76 8.34 357 0 721 0.96
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl3.dbf 25,484 7 45.93 6.04 3,392 1 2,799 12.68
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl30.dbf 9,109 3 15.89 9.77 472 0 1,613 0.33
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl31.dbf 9,751 3 17.33 8.28 344 0 1,336 0.90
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl32..dbf 6,456 2 23.72 8.97 276 0 1,147 0.56
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl4.dbf 52,668 15 45.62 5.21 5,955 2 46,477 934.07
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl5.dbf 26,371 7 26.71 8.05 4,473 1 2,283 8.45
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl6.dbf 22,352 6 15.37 9.26 3,794 1 2,694 2.66
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl7.dbf 20,512 6 21.67 8.30 3,325 1 1,620 5.35
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl8.dbf 21,784 6 21.36 7.66 3,201 1 1,207 6.92
HSCMP_TBL /home/oracle/oradata/orcl/hscmp_tbl9.dbf 22,011 6 20.22 7.88 3,160 1 1,215 3.06
HSCMP_TBL_LOG /home/oracle/oradata/orcl/HSCMP_.dbf 38 0 87.63 1.00 96 0 23 4.78
HSCMP_TBL_SAL /home/oracle/oradata/orcl/HSCMP_TBL_SAL.dbf 102,352 28 2.17 15.37 257 0 129 24.42
HSCMP_TBL_SAL /home/oracle/oradata/orcl/HSCMP_TBL_SAL10.dbf 113,392 31 2.34 15.79 1 0 52 19.42
HSCMP_TBL_SAL /home/oracle/oradata/orcl/HSCMP_TBL_SAL3.dbf 76,467 21 1.92 15.30 0 0 88 14.20
HSCMP_TBL_SAL /home/oracle/oradata/orcl/HSCMP_TBL_SAL5.dbf 85,450 24 2.10 15.25 8 0 126 22.14
HSCMP_TBL_SAL /home/oracle/oradata/orcl/HSCMP_TBL_SAL6.dbf 73,413 20 2.59 15.02 107 0 123 18.70
HSCMP_TBL_SAL /home/oracle/oradata/orcl/HSCMP_TBL_SAL7.dbf 77,296 21 2.47 15.22 200 0 114 18.16
HSCMP_TBL_SAL /home/oracle/oradata/orcl/HSCMP_TBL_SAL8.dbf 113,080 31 2.33 15.65 5 0 124 18.63
HSCMP_TBL_SAL /home/oracle/oradata/orcl/HSCMP_TBL_SAL9.dbf 91,157 25 2.22 15.73 4 0 149 17.58
HSCMP_TBL_SAL /home/oracle/oradata/orcl/hscmp_tbl_sal1.dbf 110,415 31 3.06 15.01 3,004 1 210 14.10
HSCMP_TBL_SAL /home/oracle/oradata/orcl/hscmp_tbl_sal2.dbf 99,750 28 2.60 15.31 959 0 114 19.91
HSCMP_TBL_SAL /home/oracle/oradata/orcl/hscmp_tbl_sal4.dbf 104,553 29 2.03 15.45 159 0 168 15.06
HSCMP_TBL_STK /home/oracle/oradata/orcl/HSCMP_TBL_STK.dbf 277 0 38.19 5.26 150 0 0 0.00
HSCMP_TBL_STK /home/oracle/oradata/orcl/hscmp_tbl_stk.dbf 51 0 67.25 1.00 25 0 4 2.50
HSCMP_TBL_STK /home/oracle/oradata/orcl/hscmp_tbl_stk1.dbf.dbf 5 0 10.00 1.00 6 0 0 0.00
HSCMP_TBL_STK /home/oracle/oradata/orcl/hscmp_tbl_stk2.dbf 52 0 9.62 1.00 199 0 0 0.00
HSCMP_TBL_STK_P /home/oracle/oradata/orcl/HSCMP_TBL_STK_P01.dbf 156,040 43 4.20 6.96 6,872 2 0 0.00
HSCMP_TEMP /home/oracle/oradata/orcl/HSCMP_TEMP.dbf 17,817 5 51.39 30.77 35,676 10 0  
SYSAUX /home/oracle/oradata/orcl/sysaux01.dbf 1,080 0 48.17 1.03 401 0 0 0.00
SYSTEM /home/oracle/oradata/orcl/system01.dbf 7,613 2 68.15 1.03 266 0 0 0.00
TEMP /home/oracle/oradata/orcl/temp02.dbf 3 0 173.33 1.00 0 0 0  
UNDOTBS1 /home/oracle/oradata/orcl/UNDOTBS1.dbf 179 0 100.17 1.00 20,544 6 1,061 443.40
UNDOTBS1 /home/oracle/oradata/orcl/undotbs2.dbf 101 0 103.86 1.00 26,713 7 5 678.00
UNDOTBS1 /home/oracle/oradata/orcl/undotbs3.dbf 120 0 90.08 1.00 11,507 3 9 4.44
UNDOTBS1 /home/oracle/oradata/orcl/undotbs4.dbf 124 0 73.79 1.00 18,519 5 4 2.50
UNDOTBS1 /home/oracle/oradata/orcl/undotbs5.dbf 65 0 86.92 1.00 19,747 5 11 303.64
UNDOTBS1 /home/oracle/oradata/orcl/undotbs6.dbf 109 0 115.05 1.00 23,844 7 8 431.25
UNDOTBS1 /home/oracle/oradata/orcl/undotbs7.dbf 17 0 79.41 1.00 6,059 2 2 45.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 2,187,475 101 -3,909,045,217 22,542,174 444,365 0 0 111,086


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 17 4219 83047 873969 1474560 873969  
E 0 60 37371 1484373 1474560 1474560 2669669  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 1,760 0.10 217,690 1.50 5,035,470,159
D 3,520 0.20 435,380 1.35 4,530,534,364
D 5,280 0.30 653,070 1.24 4,158,346,364
D 7,040 0.40 870,760 1.16 3,897,966,836
D 8,800 0.50 1,088,450 1.11 3,715,593,315
D 10,560 0.60 1,306,140 1.07 3,589,038,916
D 12,320 0.70 1,523,830 1.04 3,501,487,785
D 14,080 0.79 1,741,520 1.02 3,440,184,633
D 15,840 0.89 1,959,210 1.01 3,396,468,757
D 17,600 0.99 2,176,900 1.00 3,363,867,453
D 17,712 1.00 2,190,753 1.00 3,362,270,055
D 19,360 1.09 2,394,590 0.99 3,338,762,232
D 21,120 1.19 2,612,280 0.99 3,318,009,688
D 22,880 1.29 2,829,970 0.98 3,299,667,895
D 24,640 1.39 3,047,660 0.98 3,282,365,520
D 26,400 1.49 3,265,350 0.97 3,265,242,704
D 28,160 1.59 3,483,040 0.97 3,247,860,661
D 29,920 1.69 3,700,730 0.96 3,229,988,977
D 31,680 1.79 3,918,420 0.96 3,211,590,703
D 33,440 1.89 4,136,110 0.95 3,192,758,422
D 35,200 1.99 4,353,800 0.94 3,173,215,963

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
64.97 19,269 10,389

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 MemGlobal Mem Bound(K)
B 3,160 2,767 210.62 0.92 0.44 100.00 0.00 323,580
E 3,160 2,708 693.38 74.70 10.77 100.00 0.00 323,580

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 111,617 111,617 0 0
64K 128K 1,249 1,249 0 0
128K 256K 136 136 0 0
256K 512K 136 136 0 0
512K 1024K 3,702 3,702 0 0
1M 2M 2,025 2,025 0 0
2M 4M 56 56 0 0
4M 8M 20 18 2 0
8M 16M 8 8 0 0
16M 32M 2 2 0 0
32M 64M 3 3 0 0
64M 128M 11 11 0 0
128M 256M 38 5 33 0
256M 512M 4 0 4 0
512M 1024M 2 0 2 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
395 0.13 12,019,135.51 1,453,108.30 89.00 8
790 0.25 12,019,135.51 1,202,693.10 91.00 2
1,580 0.50 12,019,135.51 1,055,103.72 92.00 0
2,370 0.75 12,019,135.51 1,055,034.63 92.00 0
3,160 1.00 12,019,135.51 1,019,581.59 92.00 0
3,792 1.20 12,019,135.51 300,571.95 98.00 0
4,424 1.40 12,019,135.51 300,571.95 98.00 0
5,056 1.60 12,019,135.51 300,571.95 98.00 0
5,688 1.80 12,019,135.51 300,571.95 98.00 0
6,320 2.00 12,019,135.51 300,571.95 98.00 0
9,480 3.00 12,019,135.51 300,571.95 98.00 0
12,640 4.00 12,019,135.51 300,571.95 98.00 0
18,960 6.00 12,019,135.51 300,571.95 98.00 0
25,280 8.00 12,019,135.51 300,571.95 98.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits (K)
784 0.30 292 21,011 86,956,541 1.00 586,053 1.30 1,776,848
1,040 0.40 543 38,941 86,979,398 1.00 563,196 1.25 1,780,577
1,296 0.50 798 57,014 87,001,799 1.00 540,795 1.20 1,784,277
1,552 0.60 1,053 74,318 87,023,076 1.00 519,518 1.15 1,787,894
1,808 0.70 1,305 92,345 87,042,812 1.00 499,782 1.11 1,791,418
2,064 0.80 1,559 110,772 87,060,362 1.00 482,232 1.07 1,794,801
2,320 0.90 1,814 128,911 87,076,251 1.00 466,343 1.03 1,798,040
2,576 1.00 2,069 145,531 87,090,619 1.00 451,975 1.00 1,801,118
2,832 1.10 2,324 161,728 87,103,586 1.00 439,008 0.97 1,804,031
3,088 1.20 2,579 177,539 87,115,282 1.00 427,312 0.95 1,806,796
3,344 1.30 2,833 193,866 87,125,821 1.00 416,773 0.92 1,809,415
3,600 1.40 3,088 211,028 87,135,345 1.00 407,249 0.90 1,811,909
3,856 1.50 3,343 228,124 87,143,981 1.00 398,613 0.88 1,814,287
4,112 1.60 3,598 245,649 87,151,859 1.00 390,735 0.86 1,816,562
4,368 1.70 3,853 262,311 87,159,094 1.00 383,500 0.85 1,818,742
4,624 1.80 4,108 279,252 87,165,798 1.00 376,796 0.83 1,820,840
4,880 1.89 4,362 296,666 87,172,066 1.00 370,528 0.82 1,822,867
5,136 1.99 4,617 314,268 87,177,993 1.00 364,601 0.81 1,824,837

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,120 0.25 17,762,278 4,562,487,134
10,240 0.50 13,685,129 3,742,053,159
15,360 0.75 12,287,992 3,464,652,327
20,480 1.00 11,780,255 3,362,434,324
25,600 1.25 11,481,047 3,305,609,184
30,720 1.50 11,218,348 3,252,818,965
35,840 1.75 10,934,448 3,195,657,582
40,960 2.00 10,816,647 3,195,657,582

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
16 1.00 0 0 3 0
32 2.00 0 0 3 0
48 3.00 0 0 3 0
64 4.00 0 0 3 0
80 5.00 0 0 3 0
96 6.00 0 0 3 0
112 7.00 0 0 3 0
128 8.00 0 0 3 0
144 9.00 0 0 3 0
160 10.00 0 0 3 0
176 11.00 0 0 3 0
192 12.00 0 0 3 0
208 13.00 0 0 3 0
224 14.00 0 0 3 0
240 15.00 0 0 3 0
256 16.00 0 0 3 0
272 17.00 0 0 3 0
288 18.00 0 0 3 0
304 19.00 0 0 3 0
320 20.00 0 0 3 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

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 105,176 44,208 420
undo header 1,057 468 442
undo block 43 13 307
1st level bmb 38 2 47
segment header 27 2 56
2nd level bmb 19 0 16

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
SQ-Sequence Cache 689 689 0 14 1,088 77,704.29
TX-Transaction (row lock contention) 4 3 1 3 130 43,466.67
CF-Controlfile Transaction 11,477 11,474 3 27 30 1,121.48
US-Undo Segment 255 255 0 206 14 69.37
TX-Transaction (index contention) 116 116 0 24 6 243.33
JS-Job Scheduler (queue lock) 13,222 13,221 1 1 5 5,010.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 239.53 65,297 1,159 47 3245.5/3327.2 0/0 0/0/0/12/58992/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
26-Feb 11:02 20,980 6,633 1,159 24 3,327 0/0 0/0/0/2/20352/0
26-Feb 10:52 25,166 2,639 555 36 3,290 0/0 0/0/0/7/32512/0
26-Feb 10:42 71,247 21,093 855 47 3,293 0/0 0/0/0/3/6128/0
26-Feb 10:32 109,940 26,365 254 13 3,245 0/0 0/0/0/0/0/0
26-Feb 10:22 3,775 2,042 786 7 3,292 0/0 0/0/0/0/0/0
26-Feb 10:12 3,256 2,843 375 6 3,284 0/0 0/0/0/0/0/0
26-Feb 10:02 5,170 3,682 142 5 3,276 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 2,390 0.00   0 0  
AWR Alerted Metric Element list 26,296 0.00   0 0  
Consistent RBA 13,836 0.03 0.00 0 0  
FOB s.o list latch 28,575 0.27 0.63 2 0  
In memory undo latch 168,766 0.08 0.95 61 28,873 0.00
JS mem alloc latch 6 0.00   0 0  
JS queue access latch 6 0.00   0 0  
JS queue state obj latch 26,514 0.00   0 0  
JS slv state obj latch 95,107 0.01 0.13 0 0  
KMG MMAN ready and startup request latch 1,226 0.00   0 0  
KTF sga latch 8 0.00   0 1,187 0.00
KWQMN job cache list latch 25 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 73 0.00
Memory Management Latch 0     0 1,226 0.00
OS process 2,613 0.00   0 0  
OS process allocation 3,021 0.00   0 0  
OS process: request allocation 1,662 0.06 1.00 0 0  
PL/SQL warning settings 17,948 0.00   0 0  
SGA IO buffer pool latch 2,673 0.00   0 6,201 0.02
SQL memory manager latch 1 0.00   0 1,118 0.00
SQL memory manager workarea list latch 264,712 0.00 0.50 0 0  
Shared B-Tree 3 0.00   0 0  
Undo Hint Latch 0     0 8 0.00
active checkpoint queue latch 25,556 0.18 0.04 0 0  
active service list 12,208 0.03 0.75 0 6,591 0.02
archive control 8 0.00   0 0  
begin backup scn array 51 0.00   0 0  
cache buffer handles 52,628 0.00   0 0  
cache buffers chains 873,991,612 0.13 0.01 11 51,209,176 0.00
cache buffers lru chain 1,027,658 0.23 0.28 4 51,965,747 0.11
cache table scan latch 0     0 1,525,924 0.06
channel handle pool latch 1,662 0.06 1.00 0 0  
channel operations parent latch 18,751 0.00   0 0  
checkpoint queue latch 1,102,286 0.02 0.11 0 461,538 0.00
client/application info 5,115 0.00   0 0  
commit callback allocation 1,101 0.00   0 0  
compile environment latch 882 0.00   0 0  
dictionary lookup 5 0.00   0 0  
dml lock allocation 107,287 0.03 0.16 0 0  
dummy allocation 1,711 0.06 1.00 0 0  
enqueue hash chains 915,795 0.02 0.28 0 1,294 0.00
enqueues 690,746 0.05 0.10 0 0  
event group latch 857 0.00   0 0  
file cache latch 617 0.00   0 0  
global KZLD latch for mem in SGA 825 0.00   0 0  
global tx hash mapping 2,425 0.00   0 0  
hash table column usage latch 1,505 0.07 0.00 0 2,530,678 0.00
hash table modification latch 286 0.00   0 0  
job workq parent latch 0     0 54 0.00
job_queue_processes parameter latch 89 0.00   0 0  
kks stats 932,799 0.15 0.72 23 0  
kokc descriptor allocation latch 42 0.00   0 0  
ksuosstats global area 248 0.00   0 0  
ktm global data 16 0.00   0 0  
kwqbsn:qsga 2 0.00   0 0  
lgwr LWN SCN 14,054 0.18 0.00 0 0  
library cache 7,537,574 0.12 0.51 126 531,318 0.30
library cache load lock 24,063 0.00 0.00 0 458 0.00
library cache lock 5,644,689 0.02 0.39 10 0  
library cache lock allocation 94,311 0.00   0 0  
library cache pin 1,661,916 0.01 0.28 0 0  
library cache pin allocation 30,033 0.00   0 0  
list of block allocation 10,529 0.34 1.00 2 0  
loader state object freelist 1,480 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 1,187 0.00   0 243 0.00
messages 120,604 1.71 0.09 1 0  
mostly latch-free SCN 14,534 2.02 0.00 0 0  
multiblock read objects 3,365,612 0.01 0.03 0 0  
ncodef allocation latch 566 0.00   0 0  
object queue header heap 15,018 0.00   0 19,249 0.00
object queue header operation 47,227,358 0.00 0.24 2 0  
object stats modification 175 0.00   0 0  
parallel query alloc buffer 472 0.00   0 0  
parameter list 9,043 0.00   0 0  
parameter table management 1,720 0.00   0 0  
post/wait queue 115,436 1.51 0.01 0 120,934 1.50
process allocation 1,662 1.87 3.10 2 857 0.00
process group creation 1,662 0.00   0 0  
redo allocation 112,175 0.95 0.49 3 13,911,101 0.09
redo copy 0     0 13,912,553 0.02
redo writing 98,875 4.34 0.01 0 0  
resmgr group change latch 859 0.00   0 0  
resmgr:active threads 1,696 0.00   0 0  
resmgr:actses change group 850 0.00   0 0  
resmgr:free threads list 1,695 0.18 1.00 0 0  
resmgr:resource group CPU method 797 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 16,065,721 0.06 0.06 5 14,827 0.19
rules engine aggregate statistics 24 0.00   0 0  
rules engine rule set statistics 148 0.00   0 0  
sequence cache 42,384 0.00 1.00 0 0  
session allocation 32,699 0.10 0.91 1 0  
session idle bit 2,739,872 0.00 0.03 0 0  
session state list latch 1,321 0.00   0 0  
session switching 4,591 0.07 0.33 0 0  
session timer 2,040 0.00   0 0  
shared pool 7,965,595 0.28 0.42 134 0  
shared pool simulator 1,136,165 0.04 0.49 8 0  
simulator hash latch 26,931,451 0.00 0.14 0 0  
simulator lru latch 436,796 0.23 0.44 4 23,555,812 0.35
slave class 8 0.00   0 0  
slave class create 32 3.13 2.00 0 0  
sort extent pool 17,401 0.02 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
temporary table state object allocation 17 0.00   0 0  
threshold alerts latch 386 0.00   0 0  
transaction allocation 161,980 0.01 1.17 1 0  
transaction branch allocation 4,417 0.00   0 0  
undo global data 12,166,401 0.01 0.01 0 2 0.00
user lock 3,249 0.28 1.22 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 873,991,612 1,142,802 14,410 1,129,435 0 0 0
shared pool 7,965,595 22,644 9,430 14,192 0 0 0
row cache objects 16,065,721 9,828 630 9,368 0 0 0
library cache 7,537,574 9,078 4,632 4,957 0 0 0
redo writing 98,875 4,287 26 4,261 0 0 0
cache buffers lru chain 1,027,658 2,336 645 1,711 0 0 0
messages 120,604 2,066 193 1,875 0 0 0
post/wait queue 115,436 1,742 26 1,716 0 0 0
undo global data 12,166,401 1,536 21 1,517 0 0 0
kks stats 932,799 1,403 1,010 537 0 0 0
object queue header operation 47,227,358 1,374 330 1,069 0 0 0
library cache lock 5,644,689 1,268 492 833 0 0 0
redo allocation 112,175 1,065 527 575 0 0 0
simulator lru latch 436,796 1,018 448 582 0 0 0
shared pool simulator 1,136,165 467 230 252 0 0 0
simulator hash latch 26,931,451 450 63 389 0 0 0
enqueues 690,746 340 35 307 0 0 0
multiblock read objects 3,365,612 222 6 216 0 0 0
checkpoint queue latch 1,102,286 169 19 150 0 0 0
library cache pin 1,661,916 146 41 105 0 0 0
In memory undo latch 168,766 141 134 13 0 0 0
enqueue hash chains 915,795 139 39 103 0 0 0
FOB s.o list latch 28,575 76 48 31 0 0 0
active checkpoint queue latch 25,556 45 2 43 0 0 0
session idle bit 2,739,872 37 1 36 0 0 0
list of block allocation 10,529 36 36 1 0 0 0
session allocation 32,699 33 30 4 0 0 0
dml lock allocation 107,287 32 5 27 0 0 0
process allocation 1,662 31 96 0 0 0 0
transaction allocation 161,980 12 14 3 0 0 0
user lock 3,249 9 11 0 0 0 0
JS slv state obj latch 95,107 8 1 0 0 0 0
active service list 12,208 4 3 1 0 0 0
resmgr:free threads list 1,695 3 3 0 0 0 0
session switching 4,591 3 1 2 0 0 0
SQL memory manager workarea list latch 264,712 2 1 1 0 0 0
OS process: request allocation 1,662 1 1 0 0 0 0
channel handle pool latch 1,662 1 1 0 0 0 0
dummy allocation 1,711 1 1 0 0 0 0
sequence cache 42,384 1 1 0 0 0 0
slave class create 32 1 2 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
FOB s.o list latch ksfd_allfob 0 48 48
In memory undo latch kticmt: child 0 98 8
In memory undo latch ktiFlush: child 0 35 119
In memory undo latch ktichg: child 0 6 8
In memory undo latch kturbk 0 3 1
OS process: request allocation kso_new_process 0 1 0
SQL memory manager workarea list latch qesmmIRegisterWorkArea 0 1 0
active checkpoint queue latch kcbbacq: scan active checkpoints 0 2 2
active service list kswslogon: session logout 0 2 1
active service list kswslogon: session login 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 14,478 6,610
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 5,049 6,545
cache buffers chains kcbrls: kslbegin 0 781 3,741
cache buffers chains kcbzwb 0 479 491
cache buffers chains kcbzgb: scan from tail. nowait 0 160 0
cache buffers chains kcbgcur: kslbegin 0 105 83
cache buffers chains kcbgtcr: fast path 0 92 48
cache buffers chains kcbget: pin buffer 0 55 51
cache buffers chains kcbchg: kslbegin: call CR func 0 48 3,611
cache buffers chains kcbzib: multi-block read: nowait 0 21 0
cache buffers chains kcbzib: finish free bufs 0 11 23
cache buffers chains kcbnlc 0 9 41
cache buffers chains kcbget: exchange 0 8 25
cache buffers chains kcbget: exchange rls 0 4 9
cache buffers chains kcb_post_apply: kcbhq62 0 2 2
cache buffers chains kcbbic1 0 2 0
cache buffers chains kcbbic2 0 2 1
cache buffers chains kcbbxsv 0 2 3
cache buffers chains kcbcge 0 1 7
cache buffers chains kcbnew: new latch again 0 1 0
cache buffers lru chain kcbzgws 0 471 0
cache buffers lru chain kcbbic2 0 53 314
cache buffers lru chain kcbbxsv: move to being written 0 47 185
cache buffers lru chain kcbzar: KSLNBEGIN 0 23 0
cache buffers lru chain kcbzgb: posted for free bufs 0 21 131
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 9 0
cache buffers lru chain kcbo_link_q 0 8 1
cache buffers lru chain kcbzgm 0 6 0
cache buffers lru chain kcbbwlru 0 3 5
cache buffers lru chain kcbzswcu 0 3 5
cache buffers lru chain kcbo_ivd_proc 0 1 4
channel handle pool latch ksrchconnect() 0 1 1
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 13 0
checkpoint queue latch kcbkubc 0 3 14
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 2 2
checkpoint queue latch kcbbcthc: check thread queue 0 1 2
cost function kzulrl 0 7 9
cost function kzulgt: find user res 0 4 2
dml lock allocation ktaiam 0 5 3
dummy allocation ktcscnfy 0 1 1
enqueue hash chains ksqgtl3 0 33 32
enqueue hash chains ksqrcl 0 6 7
enqueues ksqgel: create enqueue 0 22 20
enqueues ksqdel 0 13 15
event range base latch No latch 0 48 192
kks stats kks stats alloc/free 0 1,010 1,010
library cache kglobpn: child: 0 661 729
library cache kglrtl 0 479 166
library cache kglpndl: child: after processing 0 444 68
library cache kgldti: 2child 0 427 217
library cache kglhdgn: child: 0 288 919
library cache kglukp: child 0 235 246
library cache kglpin 0 129 143
library cache kglLockCursor 0 118 364
library cache kglpndl: child: before processing 0 84 320
library cache kglhdgc: child: 0 57 51
library cache kgldtld: 2child 0 21 11
library cache kgldte: child 0 0 14 16
library cache kglati 0 10 1
library cache kglic 0 4 0
library cache kglpnp: child 0 4 38
library cache kglobld 0 3 164
library cache kglnti 0 1 1
library cache lock kgllkdl: child: cleanup 0 365 196
library cache lock kgllkdl: child: no lock handle 0 276 296
library cache lock kgllkal: child: multiinstance 0 79 102
library cache pin kglpndl 0 32 33
library cache pin kglpnal: child: alloc space 0 9 8
list of block allocation ktlabl 0 36 34
messages ksaamb: after wakeup 0 159 149
messages ksarcv 0 28 42
messages ksarcv: after wait 0 6 2
multiblock read objects kcbzib: mbr get 0 4 4
multiblock read objects kcbzib: normal mbr free 0 2 2
object queue header operation kcbw_unlink_q 0 208 69
object queue header operation kcbo_switch_cq 0 100 148
object queue header operation kcbw_link_q 0 88 8
object queue header operation kcbo_switch_mq_bg 0 18 167
object queue header operation kcbo_ivbo 0 5 9
object queue header operation kcbo_switch_q_bg 0 5 15
object queue header operation kcbo_link_q:reget 0 1 0
object queue header operation kcbw_unlink_q_bg 0 1 7
post/wait queue ksliwat:add:nowait 0 16 0
post/wait queue ksliwat:remove 0 8 25
post/wait queue kslpstevent:get 0 1 0
post/wait queue kslpstevent:reget 0 1 0
process allocation ksuapc 0 61 70
process allocation ksucrp 0 35 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 372 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 95 463
redo allocation kcrfw_redo_gen: redo allocation 2 0 60 0
redo writing kcrfws: in loop 0 23 23
redo writing kcrfw_post: rba scn pair 0 2 0
redo writing kcrfw_cal_target_rba 0 1 0
resmgr:free threads list kgskthrsod 0 2 2
resmgr:free threads list kgskthrcreate 0 1 1
row cache objects kqreqd: reget 0 242 9
row cache objects kqrpre: find obj 0 189 419
row cache objects kqrso 0 126 82
row cache objects kqreqd 0 29 59
sequence cache kdnnxt: cached seq 0 1 0
session allocation ksuxds: KSUSFCLC not set 0 16 6
session allocation ksucri 0 4 6
session allocation ksudlp 0 4 10
session allocation ksucrp 0 2 2
session allocation ksuprc 0 2 0
session allocation ksuxds: not user session 0 2 6
session idle bit ksupuc: clear busy 0 1 0
session switching kskexeall 0 1 1
shared pool kghalo 0 5,677 4,110
shared pool kghupr1 0 1,240 2,411
shared pool kghfrunp: clatch: nowait 0 1,069 0
shared pool kghalp 0 781 1,450
shared pool kghfrunp: alloc: wait 0 759 186
shared pool kghfre 0 710 1,005
shared pool kghfrunp: clatch: wait 0 352 883
shared pool kghasp 0 197 254
shared pool kghfrh 0 58 4
shared pool kghfen: not perm alloc class 0 4 2
shared pool kgh_next_free 0 3 2
shared pool kghfree_extents: scan 0 2 7
shared pool simulator kglsim_upd_newhp 0 125 59
shared pool simulator kglsim_unpin_simhp 0 81 61
shared pool simulator kglsim_scan_lru: scan 0 15 67
shared pool simulator kglsim_chg_simhp_free 0 8 17
shared pool simulator kglsim_chg_simhp_noob 0 1 25
simulator hash latch kcbsacc: lookup dba 0 52 54
simulator hash latch kcbs_lookup_setid: lookup dba 0 7 4
simulator hash latch kcbsacc: insert dba 0 3 0
simulator hash latch kcbs_get_or_extract_simbufseq 0 1 4
simulator lru latch kcbs_simulate: simulate set 0 377 0
simulator lru latch kcbs_simbufseq 0 65 448
simulator lru latch kcbs_lookup_setid 0 6 0
slave class create ksvcreate 0 2 0
transaction allocation ktcxbr 0 14 6
undo global data ktudba: KSLBEGIN 0 13 16
undo global data ktufrbs: child 0 4 3
undo global data ktusm_begin_fu 0 3 0
undo global data ktusmofu: KSLBEGIN 0 1 1

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

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
HSCMP HSCMP_TBL PK_TCVSJHBODY   INDEX 85,492,224 22.11
HSCMP HSCMP_TBL IDX_CNTCXPLU   INDEX 52,310,592 13.53
HSCMP HSCMP_TBL TCVSSELFCOMINFO   TABLE 17,464,176 4.52
HSCMP HSCMP_TBL PK_SHOPNO_BARCODE   INDEX 13,195,216 3.41
HSCMP HSCMP_TBL ID_POSPLUPARA_SHOPNO   INDEX 13,136,176 3.40

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HSCMP HSCMP_TBL_SAL TSALPLUDETAIL201301   TABLE 5,934,309 25.57
HSCMP HSCMP_TBL_SAL TSALPLUDETAIL201302   TABLE 5,071,843 21.85
HSCMP HSCMP_TBL_SAL TSALPLUDETAIL201212   TABLE 3,351,849 14.44
HSCMP HSCMP_TBL TORDJHBODY   TABLE 1,612,549 6.95
HSCMP HSCMP_TBL_SAL TSALPLUDETAIL201211   TABLE 1,099,561 4.74

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
HSCMP HSCMP_TBL ID_POSPLUPARA_SHOPNO   INDEX 267 70.45
HSCMP HSCMP_TBL IDX_TSTKLSKCLOCK_PLUID   INDEX 18 4.75
HSCMP HSCMP_TBL PK_TACPPAYBILL2013   INDEX 18 4.75
HSCMP HSCMP_TBL_LOG PK_TSYSLOG   INDEX 12 3.17
HSCMP HSCMP_TBL IDX_TSTKLSKCLOCK_WLYWTYPE   INDEX 10 2.64

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
HSCMP HSCMP_TBL TWEBCOMLOGIN   TABLE 43,730 98.56
HSCMP HSCMP_TBL TPOSPLUPARA   TABLE 222 0.50
HSCMP HSCMP_TBL TWEBCOMCTRL   TABLE 188 0.42
HSCMP HSCMP_TBL IDX_TSALSALEPAY_WEBTMP_GUID   INDEX 53 0.12
HSCMP HSCMP_TBL PK_TSALSALE_WEBTMP   INDEX 34 0.08

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 66 1.52 0   2 1
dc_constraints 96 38.54 0   96 1
dc_database_links 1,910 0.10 0   0 2
dc_global_oids 116 35.34 0   0 3
dc_histogram_data 2,767,213 0.87 0   38 5,276
dc_histogram_defs 945,703 2.47 0   35 3,347
dc_object_grants 1,193 21.37 0   0 57
dc_object_ids 1,299,069 0.17 0   3 623
dc_objects 355,495 0.72 0   12 514
dc_profiles 852 0.47 0   0 1
dc_rollback_segments 11,883 0.00 0   54 345
dc_segments 557,040 1.28 0   46 747
dc_sequences 677 13.88 0   677 8
dc_table_scns 1 100.00 0   0 0
dc_tablespace_quotas 22 22.73 0   22 0
dc_tablespaces 523,288 0.00 0   0 11
dc_usernames 8,601 1.09 0   0 7
dc_users 734,978 0.03 0   0 43
outstanding_alerts 174 91.38 0   24 0


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 197 10.15 14,481 0.64 65 0
CLUSTER 715 1.12 1,068 0.84 1 0
INDEX 269 11.90 61,689 0.13 49 0
JAVA DATA 1 100.00 1 100.00 0 0
JAVA RESOURCE 1 100.00 1 100.00 0 0
JAVA SOURCE 1 100.00 1 100.00 0 0
SQL AREA 889,809 70.49 1,640,103 35.64 136,542 4,000
TABLE/PROCEDURE 57,977 2.09 1,022,506 1.13 6,978 0
TRIGGER 2,905 2.44 14,878 1.71 170 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 100.53   1.32 1.37 11 14 76 76
  Freeable 99.06 0.00 1.83 3.27 15   54 54
  SQL 9.56 6.95 0.14 0.41 3 60 67 66
  PL/SQL 1.56 1.14 0.02 0.02 0 0 74 74
E Freeable 433.88 0.00 4.43 19.65 188   98 98
  Other 160.74   1.26 1.18 11 15 128 128
  SQL 90.92 87.55 0.76 3.50 21 325 119 118
  PL/SQL 3.31 2.58 0.03 0.02 0 0 126 126

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 18,572,378,112  
Fixed Size 2,134,704  
Redo Buffers 14,639,104  
Variable Size 2,885,684,560  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 160.00 160.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 50.00 50.00 0.00
shared CCursor 47.90 43.24 -9.74
shared Cursor Stats 45.47 45.47 0.00
shared KGH: NO ACCESS 198.84 198.84 0.00
shared db_block_hash_buckets 180.00 180.00 0.00
shared free memory 1,663.20 1,675.79 0.76
shared kglsim heap 49.96 49.96 0.00
shared kglsim object batch 90.90 90.90 0.00
shared library cache 53.42 47.55 -10.99
shared obj stat memo 93.88 93.93 0.05
shared sql area 109.05 106.69 -2.17
streams Sender info 0.94 0.94 0.00
streams free memory 15.82 15.82 0.00
  buffer_cache 17,712.00 17,712.00 0.00
  fixed_sga 2.04 2.04 0.00
  log_buffer 13.96 13.96 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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 NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 24 0 0 4 833

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
aq_tm_processes 0   
audit_file_dest /home/oracle/admin/orcl/adump   
background_dump_dest /home/oracle/admin/orcl/bdump   
compatible 10.2.0.1.0   
control_files /home/oracle/oradata/orcl/control01.ctl, /home/oracle/oradata/orcl/control02.ctl, /home/oracle/oradata/orcl/control03.ctl   
core_dump_dest /home/oracle/admin/orcl/cdump   
cursor_sharing SIMILAR   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name orcl   
db_recovery_file_dest /home/oracle/flash_recovery_area   
db_recovery_file_dest_size 2147483648   
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)   
fast_start_parallel_rollback FALSE   
java_pool_size 167772160   
job_queue_processes 30   
open_cursors 1000   
pga_aggregate_target 3313500160   
processes 800   
remote_login_passwordfile EXCLUSIVE   
resource_limit FALSE   
session_cached_cursors 60   
sessions 885   
sga_max_size 21474836480   
sga_target 21474836480   
shared_pool_size 301989888   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /home/oracle/admin/orcl/udump   


Back to Top

End of Report