WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
XLCMP409443607xlcmp2210.2.0.5.0YESxlser2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2027513-Jan-14 02:00:1257 2.2
End Snap:2028013-Jan-14 07:00:4155 2.0
Elapsed:  300.49 (mins)  
DB Time:  11.16 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 8,240M 8,240MStd Block Size: 8K
Shared Pool Size: 1,248M 1,248MLog Buffer: 14,320K

Load Profile

Per SecondPer Transaction
Redo size: 685.92 9,668.96
Logical reads: 3,051.77 43,018.64
Block changes: 3.53 49.79
Physical reads: 28.43 400.77
Physical writes: 0.28 3.93
User calls: 31.76 447.73
Parses: 10.79 152.11
Hard parses: 1.15 16.22
Sorts: 6.75 95.21
Logons: 0.05 0.69
Executes: 8.48 119.54
Transactions: 0.07 

% Blocks changed per Read: 0.12Recursive Call %: 50.53
Rollback per transaction %: 25.80Rows per Sort: 5.59

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.99
Buffer Hit %: 99.96In-memory Sort %: 100.00
Library Hit %: 88.27Soft Parse %: 89.34
Execute to Parse %: -27.24Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 33.40% Non-Parse CPU: 98.25

Shared Pool Statistics

BeginEnd
Memory Usage %: 67.51 67.58
% SQL with executions>1: 88.58 92.35
% Memory for SQL w/exec>1: 93.62 95.56

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  487  72.7 
direct path read 32,803 143 4 21.3User I/O
gc cr block 2-way 193,914 79 0 11.9Cluster
control file sequential read 368,012 72 0 10.7System I/O
SQL*Net break/reset to client 36,722 65 2 9.7Application

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 24.28 342.25
Global Cache blocks served: 8.73 123.10
GCS/GES messages received: 52.40 738.63
GCS/GES messages sent: 45.77 645.25
DBWR Fusion writes: 0.04 0.58
Estd Interconnect traffic (KB) 283.27 

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

Buffer access - local cache %: 99.16
Buffer access - remote cache %: 0.80
Buffer access - disk %: 0.04

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.2
Avg global cache cr block receive time (ms): 0.5
Avg global cache current block receive time (ms): 0.4
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.2
Avg global cache cr block flush time (ms): 2.9
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 1.5

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 6.3
Avg message sent queue time on ksxp (ms): 0.3
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 54.65
% of indirect sent messages: 41.25
% of flow controlled messages: 4.10

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 517.31 77.24
DB CPU 486.69 72.67
parse time elapsed 34.97 5.22
hard parse elapsed time 25.06 3.74
failed parse elapsed time 7.26 1.08
PL/SQL compilation elapsed time 2.07 0.31
connection management call elapsed time 1.23 0.18
PL/SQL execution elapsed time 0.87 0.13
Java execution elapsed time 0.15 0.02
hard parse (sharing criteria) elapsed time 0.10 0.01
repeated bind elapsed time 0.05 0.01
hard parse (bind mismatch) elapsed time 0.03 0.01
sequence load elapsed time 0.01 0.00
DB time 669.74  
background elapsed time 251.35  
background cpu time 218.09  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
CPU time     487   72.67
User I/O 40,914   174 4 25.93
Cluster 408,581 0 143 0 21.36
System I/O 376,595   76 0 11.31
Application 38,664 0 68 2 10.21
Other 4,459,149 100 60 0 8.97
Network 894,621   11 0 1.60
Concurrency 22,517 0 9 0 1.35
Commit 654 0 0 1 0.07
Configuration 54   0 1 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
direct path read 32,803   143 4 25.65
gc cr block 2-way 193,914   79 0 151.61
control file sequential read 368,012   72 0 287.73
SQL*Net break/reset to client 36,722   65 2 28.71
gc cr multi block request 150,977   39 0 118.04
CGS wait for IPC msg 4,400,677 100 28 0 3,440.72
gc current block 2-way 57,643   23 0 45.07
db file sequential read 6,786   19 3 5.31
Streams AQ: qmn coordinator waiting for slave to start 3 100 19 6182 0.00
db file scattered read 1,237   12 10 0.97
SQL*Net more data to client 109,398   10 0 85.53
reliable message 1,757 0 9 5 1.37
library cache lock 12,589   4 0 9.84
enq: KO - fast object checkpoint 1,326 0 3 2 1.04
control file parallel write 6,023   3 0 4.71
row cache lock 9,273   3 0 7.25
os thread startup 81   2 28 0.06
ges lmd/lmses to freeze in rcfg - mrcvr 131 62 1 7 0.10
enq: WF - contention 58   1 16 0.05
log file parallel write 2,556   1 0 2.00
gc cr grant 2-way 2,830   1 0 2.21
gc buffer busy 1,677   1 0 1.31
SQL*Net message to client 784,300   1 0 613.21
log file sync 654 0 0 1 0.51
kjbdrmcvtq lmon drm quiesce: ping completion 9   0 49 0.01
SQL*Net more data from client 923   0 0 0.72
enq: TM - contention 475   0 1 0.37
enq: PS - contention 790   0 0 0.62
DFS lock handle 970   0 0 0.76
ksxr poll remote instances 32,669 64 0 0 25.54
PX Deq: reap credit 17,467 98 0 0 13.66
kksfbc child completion 5 100 0 49 0.00
db file parallel read 41   0 6 0.03
PX Deq Credit: send blkd 764 10 0 0 0.60
gc current grant busy 643   0 0 0.50
rdbms ipc reply 1,039   0 0 0.81
gc cr disk read 525   0 0 0.41
library cache pin 525   0 0 0.41
gc cr block busy 61   0 2 0.05
enq: IR - contention 540   0 0 0.42
latch free 15   0 8 0.01
KJC: Wait for msg sends to complete 477   0 0 0.37
IPC send completion sync 234 100 0 0 0.18
PX Deq: Signal ACK 859 39 0 0 0.67
gc current grant 2-way 254   0 0 0.20
enq: TT - contention 229   0 0 0.18
enq: TQ - TM contention 166   0 0 0.13
enq: RO - fast object reuse 141   0 0 0.11
gc current block busy 24   0 1 0.02
ges global resource directory to be frozen 3 100 0 10 0.00
cursor: pin S wait on X 3 100 0 10 0.00
gcs log flush sync 73   0 0 0.06
latch: shared pool 42   0 1 0.03
ges inquiry response 68   0 0 0.05
enq: TA - contention 64   0 0 0.05
enq: HW - contention 52   0 0 0.04
log file switch completion 2   0 6 0.00
gc current multi block request 31   0 0 0.02
enq: FB - contention 16   0 0 0.01
latch: object queue header operation 3   0 1 0.00
enq: CF - contention 2   0 1 0.00
enq: AF - task serialization 3   0 1 0.00
enq: JS - job run lock - synchronize 6   0 0 0.00
log file sequential read 2   0 1 0.00
log file single write 2   0 0 0.00
enq: FU - contention 1   0 1 0.00
enq: JQ - contention 1   0 1 0.00
enq: TO - contention 1   0 1 0.00
latch: ges resource hash list 29   0 0 0.02
LGWR wait for redo copy 9   0 0 0.01
direct path write 47   0 0 0.04
latch: gcs resource hash 8   0 0 0.01
latch: cache buffers chains 4   0 0 0.00
latch: session allocation 1   0 0 0.00
gc object scan 2 100 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 2   0 0 0.00
SQL*Net message from client 784,680   291,356 371 613.51
gcs remote message 1,539,548 72 35,177 23 1,203.71
Streams AQ: qmn slave idle wait 647 0 17,723 27393 0.51
DIAG idle wait 90,133   17,604 195 70.47
ges remote message 311,998 67 17,600 56 243.94
PX Idle Wait 7,412 94 17,599 2374 5.80
ASM background timer 3,606   17,598 4880 2.82
virtual circuit status 601 100 17,546 29194 0.47
Streams AQ: qmn coordinator idle wait 1,282 50 17,526 13671 1.00
class slave wait 175 86 17,314 98935 0.14
Streams AQ: waiting for time management or cleanup tasks 555 100 17,135 30875 0.43
jobq slave wait 879 99 2,562 2915 0.69
i/o slave wait 15,186   581 38 11.87
PX Deq: Execution Msg 1,804 9 3 2 1.41
PX Deq: Join ACK 929 37 1 1 0.73
PX Deq: Parse Reply 1,027 33 1 1 0.80
PX Deq: Msg Fragment 521 11 0 0 0.41
PX Deq: Execute Reply 878 22 0 0 0.69
Streams AQ: RAC qmn coordinator idle wait 1,282 100 0 0 1.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
control file sequential read 365,332   71 0 285.64
events in waitclass Other 4,435,502 100 48 0 3,467.95
control file parallel write 6,023   3 0 4.71
os thread startup 81   2 28 0.06
gc cr block 2-way 3,203   1 0 2.50
log file parallel write 2,556   1 0 2.00
gc current block 2-way 1,002   0 0 0.78
enq: TM - contention 469   0 0 0.37
enq: KO - fast object checkpoint 417   0 0 0.33
library cache lock 208   0 0 0.16
row cache lock 267   0 0 0.21
gc current grant busy 135   0 0 0.11
enq: RO - fast object reuse 141   0 0 0.11
gc current grant 2-way 21   0 0 0.02
gc cr multi block request 9   0 0 0.01
log file sequential read 2   0 1 0.00
latch: shared pool 2   0 1 0.00
log file single write 2   0 0 0.00
direct path write 47   0 0 0.04
direct path read 47   0 0 0.04
gc object scan 2 100 0 0 0.00
db file sequential read 48   -0 -5 0.04
rdbms ipc message 472,276 90 210,225 445 369.25
gcs remote message 1,539,527 72 35,177 23 1,203.70
DIAG idle wait 90,134   17,604 195 70.47
ges remote message 311,984 67 17,600 56 243.93
ASM background timer 3,606   17,598 4880 2.82
pmon timer 6,781 100 17,596 2595 5.30
Streams AQ: qmn coordinator idle wait 1,282 50 17,526 13671 1.00
class slave wait 149 101 17,314 116199 0.12
Streams AQ: waiting for time management or cleanup tasks 555 100 17,135 30875 0.43
smon timer 60 100 16,846 280764 0.05
Streams AQ: qmn slave idle wait 301   8,349 27737 0.24
Streams AQ: RAC qmn coordinator idle wait 1,282 100 0 0 1.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 45,484
AVG_IDLE_TIME 1,758,691
AVG_IOWAIT_TIME 5,849
AVG_SYS_TIME 25,041
AVG_USER_TIME 19,989
BUSY_TIME 183,801
IDLE_TIME 7,036,594
IOWAIT_TIME 25,231
SYS_TIME 101,977
USER_TIME 81,824
LOAD 1
OS_CPU_WAIT_TIME 1,538,100
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 12,288
VM_OUT_BYTES 131,932,160
PHYSICAL_MEMORY_BYTES 16,441,671,680
NUM_CPUS 4
NUM_CPU_CORES 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
xlcmp 666.70 482.90 512,605 54,350,500
SYS$USERS 2.90 3.50 0 305
SYS$BACKGROUND 0.20 0.40 535 670,887
xlcmpXDB 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
xlcmp 40106 169 20263 6 0 0 892006 10
SYS$USERS 0 0 642 0 0 0 750 0
SYS$BACKGROUND 813 4 1612 3 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
256 140     38.29 gnuzuqn7ssmtr   SELECT PROMFORMULA , PROMDECIM...
164 161 1,087 0.15 24.52 81xv812rrxj0m exp.exe SELECT SCHEMAOID FROM SYS.EXU9...
16 15 518 0.03 2.43 2gw4dt8v4gyjn dllhost.exe SELECT BGNDATE, BGNTIME, BILLN...
7 1 1,795 0.00 1.09 dsr2rvq8k1tjv exp.exe SELECT SOURCE FROM SYS.EXU8SPS...
7 7 5 1.37 1.03 bunssq950snhf   insert into wrh$_sga_target_ad...
4 2 1,074 0.00 0.63 92z4f7xttas59 exp.exe SELECT TOWNER, TNAME, NAME, LE...
4 2 1 3.55 0.53 c0umuvkzkm400 HsCmpServer.exe SELECT F.BGNDATE, F.ENDDATE, F...
3 2 2 1.43 0.43 amfarz3f931s6 exp.exe SELECT VOBJID, VNAME, VTEXT, V...
3 1 1 2.71 0.40 07uqgg3c6fs53 HsCmpServer.exe SELECT DISTINCT '0'||P.PLUCODE...
3 2 84 0.03 0.40 a5aj5wm80yycx dllhost.exe SELECT BILLNO , ORGCODE , PLUC...

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
161 164 1,087 0.15 32.98 24.52 81xv812rrxj0m exp.exe SELECT SCHEMAOID FROM SYS.EXU9...
140 256     28.82 38.29 gnuzuqn7ssmtr   SELECT PROMFORMULA , PROMDECIM...
15 16 518 0.03 2.99 2.43 2gw4dt8v4gyjn dllhost.exe SELECT BGNDATE, BGNTIME, BILLN...
7 7 5 1.37 1.41 1.03 bunssq950snhf   insert into wrh$_sga_target_ad...
3 3 10 0.26 0.53 0.39 0cym20vhanvcg HsCmpServer.exe BEGIN SRPTRPT10010000001531( :...
2 2 5 0.49 0.50 0.37 84qubbrsr0kfn   insert into wrh$_latch (snap_i...
2 2 9 0.26 0.49 0.36 27v9xq21nhnqb HsCmpServer.exe Select Count(*) as FCount From...
2 3 84 0.03 0.49 0.40 a5aj5wm80yycx dllhost.exe SELECT BILLNO , ORGCODE , PLUC...
2 3 2 1.12 0.46 0.43 amfarz3f931s6 exp.exe SELECT VOBJID, VNAME, VTEXT, V...
2 4 1 2.05 0.42 0.53 c0umuvkzkm400 HsCmpServer.exe SELECT F.BGNDATE, F.ENDDATE, F...

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
41,879,936 1,087 38,528.00 76.12 160.50 164.23 81xv812rrxj0m exp.exe SELECT SCHEMAOID FROM SYS.EXU9...
1,718,927 518 3,318.39 3.12 14.56 16.29 2gw4dt8v4gyjn dllhost.exe SELECT BGNDATE, BGNTIME, BILLN...
390,181 4,939 79.00 0.71 0.09 1.36 7fprcxd5040cz exp.exe SELECT POLGRP, POLICY, POLOWN,...
272,978 9 30,330.89 0.50 2.38 2.39 27v9xq21nhnqb HsCmpServer.exe Select Count(*) as FCount From...
203,317 84 2,420.44 0.37 2.37 2.70 a5aj5wm80yycx dllhost.exe SELECT BILLNO , ORGCODE , PLUC...
157,072 7,834 20.05 0.29 0.13 1.46 6y0tb6wcmczp8 exp.exe SELECT BUCKET, ENDPTHASH, ENDP...
153,992 4 38,498.00 0.28 0.44 0.46 cfz686a6qp0kg   select o.obj#, u.name, o.name,...
149,561 2 74,780.50 0.27 1.26 1.30 dzxzrufuuug0n exp.exe SELECT IOBJID, IDOBJID, INAME,...
129,528 84 1,542.00 0.24 0.93 1.20 87kmfxmn2nnd8 dllhost.exe SELECT BILLNO , ISACQUI , LARG...
122,538 78 1,571.00 0.22 0.69 0.95 car763rjdunag dllhost.exe SELECT BILLNO , LXSE , PLUCODE...

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
17,918 2 8,959.00 3.50 2.23 2.86 amfarz3f931s6 exp.exe SELECT VOBJID, VNAME, VTEXT, V...
4,049 1,795 2.26 0.79 0.94 7.33 dsr2rvq8k1tjv exp.exe SELECT SOURCE FROM SYS.EXU8SPS...
167 2,525 0.07 0.03 0.08 1.16 41159q4pdcscb exp.exe SELECT NLSLENSEM, OPTLEVEL, CO...
155 15 10.33 0.03 0.04 0.95 bxavtsa0v0vju HsCmpServer.exe SELECT LBLDATATYPE, BILLNO, BG...
121 730 0.17 0.02 0.03 0.51 2p5skbyu7hzmg exp.exe SELECT SOURCE FROM SYS.EXU8SPS...
104 2 52.00 0.02 0.80 1.67 9j4tm6bbbm19b HsCmpServer.exe BEGIN SRPTRPT10010000000133( :...
104 2 52.00 0.02 0.73 1.59 dyw8vjw43384w HsCmpServer.exe INSERT /*+ Append */ INTO TRTM...
93 552 0.17 0.02 0.08 0.80 db78fxqxwxt7r   select /*+ rule */ bucket, end...
78 1 78.00 0.02 1.16 2.71 07uqgg3c6fs53 HsCmpServer.exe SELECT DISTINCT '0'||P.PLUCODE...
56 1,074 0.05 0.01 1.99 4.25 92z4f7xttas59 exp.exe SELECT TOWNER, TNAME, NAME, LE...

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
7,834 26,697 3.41 0.00 0.00 6y0tb6wcmczp8 exp.exe SELECT BUCKET, ENDPTHASH, ENDP...
7,592 116,475 15.34 0.00 0.00 fcsw30vk481ab dllhost.exe Select tWebComField.*, tWebCom...
7,521 7,521 1.00 0.00 0.00 3scwabj9qsmkj dllhost.exe select B.*, B."ROWID" from tWe...
7,009 8,104 1.16 0.00 0.00 2uwmmnqdwxw57 dllhost.exe Select tWebComTable.*, tWebCom...
7,009 0 0.00 0.00 0.00 7rcsysu9557sv dllhost.exe Select ComType , twebcomlogin....
6,913 6,877 0.99 0.00 0.00 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
6,511 6,511 1.00 0.00 0.00 gjbjrmkrw4424 dllhost.exe select sysdate , dual."ROWID" ...
4,939 0 0.00 0.00 0.00 7fprcxd5040cz exp.exe SELECT POLGRP, POLICY, POLOWN,...
3,595 3,595 1.00 0.00 0.00 8kyvv5knwptbf   select count(*) from sys.job$ ...
2,885 0 0.00 0.00 0.00 8cuu0uynbrhbn   select job, nvl2(last_date, 1,...
2,883 34 0.01 0.00 0.00 8p40k9bcw0274 exp.exe SELECT GRANTOR, GRANTORID, GRA...
2,525 1,795 0.71 0.00 0.00 41159q4pdcscb exp.exe SELECT NLSLENSEM, OPTLEVEL, CO...
1,795 334,991 186.62 0.00 0.00 dsr2rvq8k1tjv exp.exe SELECT SOURCE FROM SYS.EXU8SPS...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
8,104 0 4.17 0fv9wbfyra9q0 dllhost.exe Select * from tWebComField whe...
8,104 0 4.17 dv7t3p1w4pn0f dllhost.exe Select * from tWebComField whe...
7,592 0 3.90 43yqd5khtcuth dllhost.exe Select * from tWebComField whe...
7,592 7,592 3.90 fcsw30vk481ab dllhost.exe Select tWebComField.*, tWebCom...
7,521 0 3.87 24c6vrzw1ug5g dllhost.exe select B.* from tWebComItem B...
7,521 7,521 3.87 3scwabj9qsmkj dllhost.exe select B.*, B."ROWID" from tWe...
7,521 0 3.87 4wzc12hz2tx0m dllhost.exe select B.* from tWebComItem B...
7,012 0 3.60 26twhcjg0m4rd dllhost.exe Select ComType from twebcomlog...
7,009 0 3.60 14nxsybunua07 dllhost.exe Select * from tWebComTable wh...
7,009 7,009 3.60 2uwmmnqdwxw57 dllhost.exe Select tWebComTable.*, tWebCom...
7,009 7,009 3.60 7rcsysu9557sv dllhost.exe Select ComType , twebcomlogin....
6,511 6,511 3.35 gjbjrmkrw4424 dllhost.exe select sysdate , dual."ROWID" ...
4,939 4,939 2.54 7fprcxd5040cz exp.exe SELECT POLGRP, POLICY, POLOWN,...
2,883 2,883 1.48 8p40k9bcw0274 exp.exe SELECT GRANTOR, GRANTORID, GRA...
2,525 2,525 1.30 41159q4pdcscb exp.exe SELECT NLSLENSEM, OPTLEVEL, CO...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
25,114,240   1.92 gnuzuqn7ssmtr   SELECT PROMFORMULA , PROMDECIM...
2,987,662 300 0.23 ggatj7gwhv53m racgimon@xlser2 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
1,743,430 601 0.13 aykvshm7zsabd   select size_for_estimate, size...
1,552,257 47 0.12 015xhjsnm80ra HsCmpServer.exe select R.FunExCode , R."ROWID"...
1,415,036 15 0.11 ftm0jshxyjv38 HsCmpServer.exe SELECT FunCode , (SELECT a.Fun...
1,246,038 509 0.10 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
927 362 1w961dydxj6y4 HsPosServer.exe select LastDate , RunStatus , ...
591   gnuzuqn7ssmtr   SELECT PROMFORMULA , PROMDECIM...
140 47 015xhjsnm80ra HsCmpServer.exe select R.FunExCode , R."ROWID"...
140 47 015xhjsnm80ra HsCmpServer.exe select R.FunExCode , R."ROWID"...
53 15 aj1n3z08ngg5q HsCmpServer.exe Select RefFunCode , RefFunName...
52 15 0hk98m47caks7 HsCmpServer.exe Select RefFunCode , RefFunName...
46 7,009 2uwmmnqdwxw57 dllhost.exe Select tWebComTable.*, tWebCom...
44 15 5pjtzd4ztw5gv HsCmpServer.exe SELECT count(*) FROM tSysPrnFo...
44 15 ftm0jshxyjv38 HsCmpServer.exe SELECT FunCode , (SELECT a.Fun...
41 7,592 fcsw30vk481ab dllhost.exe Select tWebComField.*, tWebCom...
41 7,592 fcsw30vk481ab dllhost.exe Select tWebComField.*, tWebCom...
39 84 a5aj5wm80yycx dllhost.exe SELECT BILLNO , ORGCODE , PLUC...
39 84 a5aj5wm80yycx dllhost.exe SELECT BILLNO , ORGCODE , PLUC...
29 509 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
26 527 25af3drxuaqgb dllhost.exe SELECT BGNTIME , BILLNO , CARD...
26 527 25af3drxuaqgb dllhost.exe SELECT BGNTIME , BILLNO , CARD...
25 512 4gkrv36dmkz97 dllhost.exe SELECT BGNTIME , BILLNO , ENDT...
25 28 cx77ch6nkgd5p HsCmpServer.exe SELECT RptID , ClmName , ClmTy...
24 15 5vb8jnq47htvf HsCmpServer.exe Select FunType , tSysDutyFun."...
21 59 1xms4xm3up91a HsCmpServer.exe SELECT count(*) FROM tRptRptCo...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
1.28 47.33 2.71 1.16 1 07uqgg3c6fs53 HsCmpServer.exe SELECT DISTINCT '0'||P.PLUCODE...
0.83 23.46 3.55 2.05 1 c0umuvkzkm400 HsCmpServer.exe SELECT F.BGNDATE, F.ENDDATE, F...
0.82 48.76 1.67 0.80 2 9j4tm6bbbm19b HsCmpServer.exe BEGIN SRPTRPT10010000000133( :...
0.81 51.24 1.59 0.73 2 dyw8vjw43384w HsCmpServer.exe INSERT /*+ Append */ INTO TRTM...
0.66 66.19 1.00 0.90 3,595 8kyvv5knwptbf   select count(*) from sys.job$ ...
0.65 53.36 1.21 0.51 2,885 8cuu0uynbrhbn   select job, nvl2(last_date, 1,...
0.60 8.21 7.33 0.94 1,795 dsr2rvq8k1tjv exp.exe SELECT SOURCE FROM SYS.EXU8SPS...
0.44 15.26 2.86 2.23 2 amfarz3f931s6 exp.exe SELECT VOBJID, VNAME, VTEXT, V...
0.11 12.09 0.92 0.35 4 d92h3rjp0y217   begin prvt_hdm.auto_execute( :...
0.03 3.59 0.95 0.04 15 bxavtsa0v0vju HsCmpServer.exe SELECT LBLDATATYPE, BILLNO, BG...
0.03 21.43 0.14 0.07 39 677q4g4hhbn47 dllhost.exe Begin Delete from tWebComCtrl ...
0.03 5.37 0.47 0.42 11 8mrg623amm8rx   select OBJOID, CLSOID, RUNTIME...
0.02 0.88 2.47 2.45 5 84qubbrsr0kfn   insert into wrh$_latch (snap_i...
0.02 3.68 0.51 0.03 730 2p5skbyu7hzmg exp.exe SELECT SOURCE FROM SYS.EXU8SPS...
0.02 67.57 0.02 0.02 36 4w33a18a3ma73   select count(*) from sys.job$ ...
0.02 44.03 0.04 0.05 26 19kk7rxz9hphf dllhost.exe Begin Delete from tWebComCtrl ...
0.02 55.75 0.03 0.05 26 gyqvz1t1688a4 dllhost.exe DELETE FROM TWEBCOMCTRL WHERE ...
0.02 1.98 0.80 0.08 552 db78fxqxwxt7r   select /*+ rule */ bucket, end...
0.01 1.18 1.16 0.08 2,525 41159q4pdcscb exp.exe SELECT NLSLENSEM, OPTLEVEL, CO...
0.01 38.75 0.03 0.04 6 c7sn076yz7030   select smontabv.cnt, smontab.t...
0.01 47.38 0.03 0.04 11 1d89g35p484j3 dllhost.exe DELETE FROM TWEBCOMCTRL WHERE ...
0.01 1.75 0.66 0.26 730 a5n6w6u98cf1v exp.exe BEGIN :RET := SYS.DBMS_DDL.IS_...
0.01 43.67 0.03 0.03 19 996qaqb25hcd7 dllhost.exe DELETE FROM TWEBCOMCTRL WHERE ...
0.01 1.62 0.66 0.09 6,913 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
0.01 48.86 0.02 0.03 5 7cq8d0jqxzum1   delete from smon_scn_time wher...
0.01 33.91 0.03 0.03 10 2qu4au6r7knts dllhost.exe DELETE FROM TWEBCOMCTRL WHERE ...
0.01 27.92 0.04 0.03 10 fjvjd4xfxd7fz dllhost.exe Begin Delete from tWebComCtrl ...
0.01 21.34 0.05 0.01 220 3c1kubcdjnppq   update sys.col_usage$ set equa...
0.01 7.44 0.13 0.01 12 g5f37zm046z27 dllhost.exe Begin Delete from tWebComCtrl ...
0.01 0.00 164.23 160.50 1,087 81xv812rrxj0m exp.exe SELECT SCHEMAOID FROM SYS.EXU9...
0.01 4.15 0.19 0.08 3 f65q0ura3jt36   INSERT /*+ LEADING(@"SEL$F5BB7...
0.01 1.57 0.48 0.10 385 5bgq91rvvupgz exp.exe SELECT NAME, PROPERTY, BOBJID,...
0.01 46.16 0.02 0.02 6 brpf47dwmhsvv dllhost.exe Begin Delete from tWebComCtrl ...
0.01 0.15 4.25 1.99 1,074 92z4f7xttas59 exp.exe SELECT TOWNER, TNAME, NAME, LE...
0.01 7.94 0.07 0.03 2 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
0.01 36.58 0.01 0.02 5 bjqfr5n7cn51w dllhost.exe Begin Delete from tWebComCtrl ...
0.01 1.15 0.46 0.44 4 cfz686a6qp0kg   select o.obj#, u.name, o.name,...
0.01 0.63 0.81 0.61 2 7fv2hmgds4p4t exp.exe SELECT SYNNAM, DBMS_JAVA.LONGN...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
015xhjsnm80raselect R.FunExCode , R."ROWID" , S."ROWID" , G."ROWID" from tUsrRightFuncEx R , tUsrUserSub S , tUsrUserGrp G where R.UGrpCode=S.UGrpCode and R.UGrpCode=G.UGrpCode and S.UserID=:"SYS_B_0" and R.FunCode=:"SYS_B_1"
07uqgg3c6fs53SELECT DISTINCT '0'||P.PLUCODE||P.ISCOUTQTY||LPAD(TO_CHAR(ROUND(TT.PRICE, 2)*100), 6, '0')||SUBSTR(TT.DEPCODE, 1, 2)||'13'||P.PLUCODE||'000000'||LPAD(TO_CHAR(P.BZDAYS), 3, '0')||SUBSTR(PLUNAME, 1, 12)||'@?@?' AS SPLUSTR FROM TSKUPLU P, (SELECT ORGCODE, PLUID, DEPCODE, PRICE FROM TSKUGTPLU WHERE ISPTDSC='0' AND TO_CHAR(UPTDATE, 'YYYY-MM-DD')>=TO_CHAR(SYSDATE-1, 'YYYY-MM-DD') UNION ALL SELECT CX.ORGCODE, CX.PLUID, GT.DEPCODE, CX.YHPRICE AS PRICE FROM TPROCXPTPLU CX, TSKUGTPLU GT, (SELECT ORGCODE, PLUID, MAX(PRI) AS PRI FROM TPROCXPTPLU WHERE :B1 BETWEEN BGNDATE AND ENDDATE GROUP BY ORGCODE, PLUID) T WHERE GT.ISPTDSC='1' AND CX.PLUID=GT.PLUID AND CX.ORGCODE=GT.ORGCODE AND CX.ORGCODE=T.ORGCODE AND :B1 BETWEEN CX.BGNDATE AND CX.ENDDATE AND CX.PLUID=T.PLUID AND CX.PRI=T.PRI) TT, TCNTCONTRACT CNT, TCNTPLU CNTP, TCNTCNTORG ORG WHERE LENGTH(P.PLUCODE)=5 AND P.PLUID=TT.PLUID AND TT.ORGCODE=:B4 AND CNT.CNTID=CNTP.CNTID AND CNT.ETPCODE LIKE :B3 ||'%' AND CNT.CNTID=ORG.CNTID AND ORG.USORGCODE=TT.ORGCODE AND P.PLUID=CNTP.PLUID AND P.PLUCODE LIKE :B2 ||'%'
0cym20vhanvcgBEGIN SRPTRPT10010000001531( :1, :2, :3, :4, :5, :6, :7, :RESULT_SET ); END;
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0fv9wbfyra9q0Select * from tWebComField where FaceCode=:"SYS_B_0"
0hk98m47caks7Select RefFunCode , RefFunName , SerialNo , a."ROWID" FROM tNavReffun a Where (Exists(Select * From tNavRefFun b WHERE SubStr(To_Char(A.SerialNo), :"SYS_B_00", :"SYS_B_01")=SubStr(TO_Char(B.SerialNo), :"SYS_B_02", :"SYS_B_03") and a.FunCode=B.FunCode and RefFunCode=:"SYS_B_04") OR (FunCode=:"SYS_B_05")) And RefFunCode<>:"SYS_B_06" and (OrgCode=:"SYS_B_07" or OrgCode=:"SYS_B_08") and (IsSysSet=:"SYS_B_09" or UserId=:"SYS_B_10" or UserId=:"SYS_B_11") Order By FunCode, SerialNo
14nxsybunua07 Select * from tWebComTable where FaceCode=:"SYS_B_0" and ComItemCode=:"SYS_B_1" Order by IsMaster Desc, SerialNo
19kk7rxz9hphfBegin Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0005'; Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0007'; Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0009'; End;
1d89g35p484j3DELETE FROM TWEBCOMCTRL WHERE COMTABLE='tPosGtPlu'AND FACECODE='01'AND ITEMCODE='1003'AND ORGCODE='0004'
1w961dydxj6y4select LastDate , RunStatus , tSysOverItem."ROWID" from tSysOverItem where OrgCode=:"SYS_B_0" and ItemCode=:"SYS_B_1"
1xms4xm3up91aSELECT count(*) FROM tRptRptColumn WHERE RptID = :"SYS_B_0"
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"
27v9xq21nhnqbSelect Count(*) as FCount From tStkDbTzHead Where (ChOrgCode=:"SYS_B_0") and ((JzDate Is Not Null) And (EndDate Is Null) And Exists (Select * From tOrgManage Where (OrgType Between :"SYS_B_1" And :"SYS_B_2") And OrgCode = tStkDbTzHead.OrgCode) And (Not Exists (Select * From tStkDbHead Where YwBillNo = tStkDbTzHead.BillNo) Or Exists (Select * From tStkDbHead Where YwBillNo = tStkDbTzHead.BillNo And JzDate Is Null)))
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"
2p5skbyu7hzmgSELECT SOURCE FROM SYS.EXU8SPS WHERE OBJ# = :1 ORDER BY LINE
2qu4au6r7kntsDELETE FROM TWEBCOMCTRL WHERE COMTABLE='tPosGtPlu'AND FACECODE='01'AND ITEMCODE='1003'AND ORGCODE='0034'
2uwmmnqdwxw57Select tWebComTable.*, tWebComTable."ROWID" from tWebComTable where FaceCode=:"SYS_B_0" and ComItemCode=:"SYS_B_1" Order by IsMaster Desc, SerialNo
3c1kubcdjnppqupdate sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3scwabj9qsmkjselect B.*, B."ROWID" from tWebComItem B where B.FaceCode=:"SYS_B_0" and B.ComItemCode=:"SYS_B_1"
41159q4pdcscbSELECT NLSLENSEM, OPTLEVEL, CODETYPE, DEBUG, WARNINGS, CCFLAGS FROM SYS.EXU10R2OBJSWITCH WHERE OBJID = :1
43yqd5khtcuthSelect * from tWebComField where FaceCode=:"SYS_B_0" And ComItemCode=:"SYS_B_1" And upper(SendTable)=:"SYS_B_2"
4gkrv36dmkz97SELECT BGNTIME , BILLNO , ENDTIME , ISENABLED , MAXCOUNT , MINCOUNT , ORGCODE , PLUCODE , PLUID , POSCOMUPTYPE , PRI , SERIALNO , UPTDATE , YHPRICE , YHRATE , YHTYPE , VPROCXPLPLU."ROWID" FROM VPROCXPLPLU WHERE UPTDATE >= TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"
4w33a18a3ma73select count(*) from sys.job$ where next_date < :1 and (field1 = :2 or (field1 = 0 and 'Y' = :3)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))
4wzc12hz2tx0m select B.* from tWebComItem B where B.FaceCode=:"SYS_B_0" and B.ComItemCode=:"SYS_B_1"
5bgq91rvvupgzSELECT NAME, PROPERTY, BOBJID, SYS.DBMS_EXPORT_EXTENSION.FUNC_INDEX_DEFAULT(BOBJID, NAME) FROM SYS.EXU8ICO WHERE TOBJID = :1 ORDER BY COLID
5pjtzd4ztw5gvSELECT count(*) FROM tSysPrnFormat WHERE FunCode = :"SYS_B_0" and IsEnabled = :"SYS_B_1" and ( OrgCode = :"SYS_B_2" or OrgCode = :"SYS_B_3" )
5vb8jnq47htvfSelect FunType , tSysDutyFun."ROWID" From tSysDutyFun Where FunCode=:"SYS_B_0" and DutyCode=:"SYS_B_1"
677q4g4hhbn47 Begin Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0002'; Delete from tWebComCtrl Where COMTABLE='tProCxPtPlu'And FACECODE='01'And ITEMCODE='1016'And ORGCODE='0002'; Delete from tWebComCtrl Where COMTABLE='tProCxPlPlu'And FACECODE='01'And ITEMCODE='1017'And ORGCODE='0002'; Delete from tWebComCtrl Where COMTABLE='tProCxHyPlu'And FACECODE='01'And ITEMCODE='1020'And ORGCODE='0002'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0002'; Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0003'; Delete from tWebComCtrl Where COMTABLE='tProCxPtPlu'And FACECODE='01'And ITEMCODE='1016'And ORGCODE='0003'; Delete from tWebComCtrl Where COMTABLE='tProCxPlPlu'And FACECODE='01'And ITEMCODE='1017'And ORGCODE='0003'; Delete from tWebComCtrl Where COMTABLE='tProCxHyPlu'And FACECODE='01'And ITEMCODE='1020'And ORGCODE='0003'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0003'; Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0008'; Delete from tWebComCtrl Where COMTABLE='tProCxPtPlu'And FACECODE='01'And ITEMCODE='1016'And ORGCODE='0008'; Delete from tWebComCtrl Where COMTABLE='tProCxPlPlu'And FACECODE='01'And ITEMCODE='1017'And ORGCODE='0008'; Delete from tWebComCtrl Where COMTABLE='tProCxHyPlu'An d FACECODE='01'And ITEMCODE='1020'And ORGCODE='0008'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0008'; Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0010'; Delete from tWebComCtrl Where COMTABLE='tProCxPtPlu'And FACECODE='01'And ITEMCODE='1016'And ORGCODE='0010'; Delete from tWebComCtrl Where COMTABLE='tProCxPlPlu'And FACECODE='01'And ITEMCODE='1017'And ORGCODE='0010'; Delete from tWebComCtrl Where COMTABLE='tProCxHyPlu'And FACECODE='01'And ITEMCODE='1020'And ORGCODE='0010'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0010'; End;
6y0tb6wcmczp8SELECT BUCKET, ENDPTHASH, ENDPTVAL, UTL_RAW.CAST_TO_RAW(ENDPTVAL) ENDPTVAL_RAW FROM SYS.EXU8HSTU WHERE POBJID = :1 AND INTCOL = :2 ORDER BY BUCKET
7cq8d0jqxzum1delete from smon_scn_time where thread=0 and scn = (select min(scn) from smon_scn_time where thread=0)
7fprcxd5040czSELECT POLGRP, POLICY, POLOWN, POLSCH, POLFUN, STMT, CHKOPT, ENABLED, SPOLICY FROM SYS.EXU9RLS WHERE OBJOWN = :1 AND OBJNAM = :2
7fv2hmgds4p4tSELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM), DBMS_JAVA.LONGNAME(SYNTAB), TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNID, TABOWNID, SYNOBJNO FROM SYS.EXU9SYNU ORDER BY SYNTIME
7ng34ruy5awxqselect 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#
7rcsysu9557svSelect ComType , twebcomlogin."ROWID" from twebcomlogin where OrgCode=:"SYS_B_0"
81xv812rrxj0mSELECT SCHEMAOID FROM SYS.EXU9XMLST WHERE TOBJID = :1
84qubbrsr0kfninsert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
87kmfxmn2nnd8SELECT BILLNO , ISACQUI , LARGCODE , LARGNAME , LARGTOTAL , LXSE , REMARK , SERIALNO , XFTOTAL , VPROCXZSPRORATE."ROWID" FROM VPROCXZSPRORATE
8cuu0uynbrhbnselect job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
8kyvv5knwptbfselect count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400)) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000))
8mrg623amm8rx select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
8p40k9bcw0274SELECT GRANTOR, GRANTORID, GRANTEE, PRIV, WHO, WGO, ISDIR, TYPE FROM SYS.EXU8GRN WHERE OBJID = :1 ORDER BY WGO DESC, SEQUENCE
92z4f7xttas59SELECT TOWNER, TNAME, NAME, LENGTH, PRECISION, SCALE, TYPE, ISNULL, CONNAME, COLID, INTCOLID, SEGCOLID, COMMENT$, DEFAULT$, DFLTLEN, ENABLED, DEFER, FLAGS, COLPROP, CHARSETID, CHARSETFORM, FSPRECISION, LFPRECISION, CHARLEN, TFLAGS FROM SYS.EXU8COLU WHERE TOBJID = :1 ORDER BY SEGCOLID
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
996qaqb25hcd7DELETE FROM TWEBCOMCTRL WHERE COMTABLE='tPosGtPlu'AND FACECODE='01'AND ITEMCODE='1003'AND ORGCODE='0002'
9j4tm6bbbm19bBEGIN SRPTRPT10010000000133( :1, :2, :3, :4, :5, :6, :7, :RESULT_SET ); END;
a5aj5wm80yycxSELECT BILLNO , ORGCODE , PLUCODE , PLUID , POSCOMUPTYPE , PRI , UPTDATE , VPROCXZSPLU."ROWID" FROM VPROCXZSPLU WHERE ORGCODE=:"SYS_B_0" AND UPTDATE >=TO_DATE(:"SYS_B_1", :"SYS_B_2")
a5n6w6u98cf1vBEGIN :RET := SYS.DBMS_DDL.IS_TRIGGER_FIRE_ONCE_INTERNAL(:TOWNER, :TNAME); END;
aj1n3z08ngg5qSelect RefFunCode , RefFunName , tNavRefFun."ROWID" From tNavRefFun Where FunCode=:"SYS_B_0" and (OrgCode=:"SYS_B_1" or OrgCode=:"SYS_B_2") and (IsSysSet=:"SYS_B_3" or UserId=:"SYS_B_4" or UserId=:"SYS_B_5")
amfarz3f931s6SELECT VOBJID, VNAME, VTEXT, VLEN, VOWNER, VOWNERID, VAUDIT, VCOMMENT, VCNAME, PROPERTY, DEFER, FLAGS, OIDLEN, OIDCLAUSE, TYPEOWNER, TYPENAME, UNDERLEN, UNDERCLAUSE FROM SYS.EXU8VEWU ORDER BY VLEVEL, VOBJID
aykvshm7zsabdselect size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
bjqfr5n7cn51wBegin Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0008'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0008'; End;
brpf47dwmhsvvBegin Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0004'; Delete from tWebComCtrl Where COMTABLE='tProCxPtPlu'And FACECODE='01'And ITEMCODE='1016'And ORGCODE='0004'; Delete from tWebComCtrl Where COMTABLE='tProCxPlPlu'And FACECODE='01'And ITEMCODE='1017'And ORGCODE='0004'; Delete from tWebComCtrl Where COMTABLE='tProCxPackPlu'And FACECODE='01'And ITEMCODE='1019'And ORGCODE='0004'; Delete from tWebComCtrl Where COMTABLE='tProCxHyPlu'And FACECODE='01'And ITEMCODE='1020'And ORGCODE='0004'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0004'; End;
bunssq950snhfinsert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
bxavtsa0v0vju SELECT LBLDATATYPE, BILLNO, BGNDATE, ENDDATE, ORGCODE, TO_CHAR(PLUID) AS PLUID, PLUCODE, PLUNAME, BARCODE, UNIT, SPEC, CARGONO, PRODUCE, GRADE, QUALITY, TO_CHAR(PRICE) AS PRICE, TO_CHAR(HYPRICE) AS HYPRICE, TO_CHAR(PFPRICE) AS PFPRICE, TO_CHAR(YHPRICE) AS YHPRICE FROM (SELECT '0' AS LBLDATATYPE, '*' AS BILLNO, '*' AS BGNDATE, '*' AS ENDDATE, A.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, A.PRICE, A.HYPRICE, A.PFPRICE, 0 AS YHPRICE FROM TSKUPLUEX A, TSKUPLU B WHERE A.PLUID=B.PLUID AND A.ORGCODE=:B2 AND A.PLUID=:B1 AND B.PLUID=:B1 UNION ALL SELECT '1' AS LBLDATATYPE, A.JJBJBILLNO AS BILLNO, '*' AS BGNDATE, '*' AS ENDDATE, A.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, A.NEWPRICE AS PRICE, A.NEWHYPRICE AS HYPRICE, A.NEWPFPRICE AS PFPRICE, 0 AS YHPRICE FROM TPRCJJBJSKU A, TSKUPLU B WHERE B.PLUID=A.PLUID AND A.ORGCODE=:B2 AND A.PLUID=:B1 AND A.POSCOMUPTYPE<>'2' AND B.PLUID=:B1 UNION ALL SELECT '2' AS LBLDATATYPE, A.BILLNO, '*' AS BGNDATE, '*' AS ENDDATE, H.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, A.NEWPRICE AS PRICE, A.NEWHYPRICE AS HYPRICE, A.NEWPFPRICE AS PFPRICE, 0 AS YHPRICE FROM TSKUPLU B, TPRCTSJHEAD H, TPRCTSJBODY A WHERE B.PLUID=A.PLUID AND H.BILLNO=A.BILLNO AND H.JZDATE IS NOT NULL AND H.BILLTYPE='1' AND H.ISENABLED='1' AND H.ORGCODE=:B2 AND A.PLUID=:B1 AND B.PLUID=:B1 UNION ALL SELECT '3' AS LBLDATATYPE, '*' AS BILLNO, '*' AS BGNDATE, '*' AS ENDDATE, A.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, A.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, A.PRICE, 0 AS HYPRICE, 0 AS PFPRICE, 0 AS YHPRICE FROM TPRCXJPLU A, TSKUPLU B WHERE B.PLUID=A.PLUID AND A.ORGCODE=:B2 AND A.PLUID=:B1 AND B.PLUID=:B1 UNION ALL SELECT '4' AS LBLDATATYPE, '*' AS BILLNO, '*' AS BGNDATE, '*' AS ENDDATE, A.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, A.PRICE, 0 AS HYPRICE, 0 AS PFPRICE, 0 AS YHPRICE FROM TFRSPRICE A, TSKUPLU B WHERE B.PLUID=A.PLUID AND A.ORGCODE=:B2 AND A.PLUID=:B1 AND B.PLUID=:B1 UNION ALL SELECT '5' AS LBLDATATYPE, A.BILLNO, A.BGNDATE AS BGNDATE, A.ENDDATE AS ENDDATE, A.ORGCODE, A.PLUID, A.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, E.PRICE, 0 AS HYPRICE, 0 AS PFPRICE, A.YHPRICE AS YHPRICE FROM TPROCXPTPLU A, TSKUPLU B, TSKUPLUEX E WHERE B.PLUID=A.PLUID AND E.ORGCODE=A.ORGCODE AND E.PLUID=A.PLUID AND A.ORGCODE=:B2 AND A.PLUID=:B1 AND A.POSCOMUPTYPE<>'2' AND E.ORGCODE=:B2 AND E.PLUID=:B1 AND B.PLUID=:B1 AND A.PRI IN (SELECT MAX(A.PRI) FROM TPROCXPTPLU A WHERE A.ORGCODE=:B2 AND A.PLUID=:B1 AND A.POSCOMUPTYPE<>'2') UNION ALL SELECT '6' AS LBLDATATYPE, A.BILLNO, '*' AS BGNDATE, '*' AS ENDDATE, A.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, E.PRICE, 0 AS HYPRICE, 0 AS PFPRICE, A.YHPRICE FROM TPROCXPLPLU A, TSKUPLU B, TSKUPLUEX E WHERE B.PLUID=A.PLUID AND E.ORGCODE=A.ORGCODE AND E.PLUID=A.PLUID AND A.ORGCODE=:B2 AND A.PLUID=:B1 AND A.POSCOMUPTYPE<>'2' AND E.ORGCODE=:B2 AND E.PLUID=:B1 AND B.PLUID=:B1 AND A.PRI IN (SELECT MAX(A.PRI) FROM TPROCXPLPLU A WHERE A.ORGCODE=:B2 AND A.PLUID=:B1 AND A.POSCOMUPTYPE<>'2') UNION ALL SELECT '7' AS LBLDATATYPE, A.BILLNO, '*' AS BGNDATE, '*' AS ENDDATE, A.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, E.PRICE, 0 AS HYPRICE, 0 AS PFPRICE, A.YHPRICE FROM TPROCXXLPLU A, TSKUPLU B, TSKUPLUEX E WHERE B.PLUID=A.PLUID AND E.ORGCODE=A.ORGCODE AND E.PLUID=A.PLUID AND A.ORGCODE=:B2 AND A.PLUID=:B1 AND A.POSCOMUPTYPE<>'2' AND E.ORGCODE=:B2 AND E.PLUID=:B1 AND B.PLUID=:B1 AND A.PRI IN (SELECT MAX(A.PRI) FROM TPROCXXLPLU A WHERE A.ORGCODE=:B2 AND A.PLUID=:B1 AND A.POSCOMUPTYPE<>'2') UNION ALL SELECT '8' AS LBLDATATYPE, A.BILLNO, '*' AS BGNDATE, '*' AS ENDDATE, A.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, E.PRICE, CASE WHEN :B3 ='1' THEN C.YHPRICE ELSE A.YHPRICE END AS HYPRICE, 0 AS PFPRICE, A.YHPRICE FROM TPROCXHYPLU A, TSKUPLU B, TSKUPLUEX E, TPROCXPTPLU C WHERE B.PLUID=A.PLUID AND B.PLUID=C.PLUID AND E.ORGCODE=A.ORGCODE AND E.PLUID=A.PLUID AND E.ORGCODE=C.ORGCODE AND E.PLUID=C.PLUID AND A.ORGCODE=:B2 AND A.PLUID=:B1 AND A.POSCOMUPTYPE<>'2' AND C.ORGCODE=:B2 AND C.PLUID=:B1 AND C.POSCOMUPTYPE<>'2' AND E.ORGCODE=:B2 AND E.PLUID=:B1 AND B.PLUID=:B1 AND A.PRI IN (SELECT MAX(A.PRI) FROM TPROCXHYPLU A WHERE A.ORGCODE=:B2 AND A.PLUID=:B1 AND A.POSCOMUPTYPE<>'2') AND C.PRI IN (SELECT MAX(A.PRI) FROM TPROCXPTPLU A WHERE A.ORGCODE=:B2 AND A.PLUID=:B1 AND A.POSCOMUPTYPE<>'2') UNION ALL SELECT LBLDATATYPE, BILLNO, BGNDATE, ENDDATE, ORGCODE, PLUID, PLUCODE, PLUNAME, BARCODE, UNIT, SPEC, CARGONO, PRODUCE, GRADE, QUALITY, PRICE, HYPRICE, PFPRICE, YHPRICE FROM ( SELECT '9' AS LBLDATATYPE, A.BILLNO, H.BGNDATE, H.ENDDATE, C.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, D.PRICE, D.HYPRICE, D.PFPRICE, CASE WHEN A.YHTYPE='1' THEN A.YHPRICE ELSE ROUND(D.PRICE*(100.0-A.DSCRATE)/100.0, 2) END AS YHPRICE, H.PRI FROM TPRODSCPLU A, TPROCXORG C, TPROCXBILLHEAD H, TSKUPLU B, TSKUPLUEX D, TPROCXJOB AA WHERE A.BILLNO=C.BILLNO AND A.BILLNO=H.BILLNO AND A.BILLNO=AA.BILLNO AND A.PLUID=B.PLUID AND D.ORGCODE=C.ORGCODE AND D.PLUID=A.PLUID AND D.ORGCODE=:B2 AND D.PLUID=:B1 AND B.PLUID=:B1 AND C.ORGCODE=:B2 AND A.PLUID=:B1 AND AA.ISENABLED='1' AND AA.ISRUNING='0' AND NOT EXISTS (SELECT 1 FROM TPROCXPTPLU P WHERE P.PLUID=A.PLUID AND P.BILLNO=A.BILLNO ) UNION ALL SELECT '9' AS LBLDATATYPE, A.BILLNO, H.BGNDATE, H.ENDDATE, C.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY , D.PRICE, D.HYPRICE, D.PFPRICE, A.YHPRICE, H.PRI FROM TPROXLPROJECT A, TPROCXORG C, TPROCXBILLHEAD H, TSKUPLU B, TSKUPLUEX D, TPROCXJOB AA WHERE A.BILLNO=C.BILLNO AND A.BILLNO=H.BILLNO AND A.BILLNO=AA.BILLNO AND A.PLUID=B.PLUID AND D.ORGCODE=C.ORGCODE AND D.PLUID=A.PLUID AND D.ORGCODE=:B2 AND D.PLUID=:B1 AND B.PLUID=:B1 AND C.ORGCODE=:B2 AND A.PLUID=:B1 AND AA.ISENABLED='1' AND AA.ISRUNING='0' AND NOT EXISTS (SELECT 1 FROM TPROCXXLPLU P WHERE P.PLUID=A.PLUID AND P.BILLNO=A.BILLNO ) UNION ALL SELECT '9' AS LBLDATATYPE, A.BILLNO, H.BGNDATE, H.ENDDATE, C.ORGCODE, A.PLUID, B.PLUCODE, B.PLUNAME, B.BARCODE, B.UNIT, B.SPEC, B.CARGONO, B.PRODUCE, B.GRADE, B.QUALITY, D.PRICE, D.HYPRICE, D.PFPRICE, A.YHPRICE, H.PRI FROM TPROPLPROJECT A, TPROCXORG C, TPROCXBILLHEAD H, TSKUPLU B, TSKUPLUEX D, TPROCXJOB AA WHERE A.BILLNO=C.BILLNO AND A.BILLNO=H.BILLNO AND A.BILLNO=AA.BILLNO AND A.PLUID=B.PLUID AND D.ORGCODE=C.ORGCODE AND D.PLUID=A.PLUID AND D.ORGCODE=:B2 AND D.PLUID=:B1 AND B.PLUID=:B1 AND C.ORGCODE=:B2 AND A.PLUID=:B1 AND AA.ISENABLED='1' AND AA.ISRUNING='0' AND NOT EXISTS (SELECT 1 FROM TPROCXPLPLU P WHERE P.PLUID=A.PLUID AND P.BILLNO=A.BILLNO ) ORDER BY PRI DESC ) B UNION ALL SELECT LBLDATATYPE, BILLNO, BGNDATE, ENDDATE, ORGCODE, PLUID, PLUCODE, PLUNAME, BARCODE, UNIT, SPEC, CARGONO, PRODUCE, GRADE, QUALITY, PRICE, HYPRICE, PFPRICE, YHPRICE FROM ( SELECT '11' AS LBLDATATYPE, '*' AS BILLNO, H.BGNDATE, H.ENDDATE, R.ORGCODE, R.PACKAGEID AS PLUID, H.PACKAGECODE AS PLUCODE, H.PACKAGENAME AS PLUNAME, H.BARCODE, H.UNIT, '' AS SPEC, '' AS CARGONO, '' AS PRODUCE, '' AS GRADE, '' AS QUALITY, R.PRICE AS PRICE, R.HYPRICE, 0 AS PFPRICE, 0 AS YHPRICE FROM TSKUPLUPACKAGEHEAD H, TSKUPACKAGEORG R WHERE H.PACKAGEID=:B1 AND R.PACKAGEID=H.PACKAGEID AND R.ORGCODE=:B2 UNION ALL SELECT '10' AS LBLDATATYPE, '*' AS BILLNO, H.BGNDATE, H.ENDDATE, :B2 AS ORGCODE, H.PACKAGEID AS PLUID, H.PACKAGECODE AS PLUCODE, H.PACKAGENAME AS PLUNAME, H.BARCODE, H.UNIT, '' AS SPEC, '' AS CARGONO, '' AS PRODUCE, '' AS GRADE, '' AS QUALITY, H.PRICE AS PRICE, H.HYPRICE, 0 AS PFPRICE, 0 AS YHPRICE FROM TSKUPLUPACKAGEHEAD H WHERE H.PACKAGEID=:B1 ) C ) A ORDER BY LBLDATATYPE DESC
c0umuvkzkm400 SELECT F.BGNDATE, F.ENDDATE, F.BJLX, F.DEPNAME, F.PLUCODE, F.PLUNAME, F.CLSNAME, F.BARCODE, F.UNIT, F.SPEC, F.PRODUCE, F.PRICE, F.NEWPRICE, F.HYPRICE, F.NEWHYPRICE, F.ISCANSALE, F.ISKC, E.FDKCCOUNT, E.QSZXSCOUNT FROM ( SELECT T.BGNDATE, T.ENDDATE, T.BJLX, T.DEPNAME, T.PLUCODE, T.PLUNAME, T.CLSNAME, T.BARCODE, T.UNIT, T.SPEC, T.PRODUCE, T.PRICE, MAX(T.NEWPRICE) AS NEWPRICE, MAX(T.HYPRICE) AS HYPRICE, MAX(T.NEWHYPRICE) AS NEWHYPRICE, CASE WHEN A.ISCANSALE='0' THEN '????' WHEN A.ISCANSALE='1' THEN '???' END AS ISCANSALE, CASE WHEN A.ISKCNOW='0' THEN '???' WHEN A.ISKCNOW='1' THEN '???' END AS ISKC FROM (SELECT HEAD.BGNDATE AS BGNDATE, HEAD.ENDDATE AS ENDDATE, '????' AS BJLX, CASE WHEN DEP.DEPCODE IN ('01', '02', '03', '04') THEN '0' WHEN DEP.DEPCODE IN ('05', '06', '07', '08') THEN '1' END AS DEPNAME, B.PLUCODE, PLU.PLUNAME, PLU.BARCODE, PLU.UNIT, PLU.SPEC, PLU.PRODUCE, (SELECT CLSNAME FROM TCATCATEGORY WHERE CLSCODE IN (SELECT SUBSTR(CLSCODE, 1, 2) FROM TCATCATEGORY WHERE CLSID=PLU.CLSID )) AS CLSNAME, GT.PRICE, CASE WHEN HEAD.CXTYPE<>'20' THEN B.YHPRICE ELSE 0 END AS NEWPRICE, B.HYPRICE, CASE WHEN HEAD.CXTYPE='20' THEN B.YHPRICE ELSE 0 END AS NEWHYPRICE FROM TPRODSCPLU B, TSKUPLU PLU, TPROCXBILLHEAD HEAD, TSKUPLUEX PLUEX, TORGDEPT DEP, TSKUGTPLU GT WHERE B.PLUID=PLUEX.PLUID AND PLUEX.ORGCODE=:B1 AND PLUEX.DEPID=DEP.DEPID AND B.BILLNO=HEAD.BILLNO AND B.PLUID=PLU.PLUID AND GT.PLUCODE=B.PLUCODE AND PLUEX.ORGCODE=GT.ORGCODE AND B.BILLNO IN (SELECT H.BILLNO FROM TPRO CXBILLHEAD H, TPROCXORG ORG, TPROCXJOB JOB WHERE H.BILLNO=ORG.BILLNO AND H.JZDATE IS NOT NULL AND H.YWSTATUS IN ('0', '1') AND H.FREQUENCY IN ('0', '1') AND JOB.BILLNO=H.BILLNO AND ORG.ORGCODE=:B1 AND H.ENDDATE=:B2 )) T , TSKUGTPLU A WHERE :B1 =A.ORGCODE AND T.PLUCODE=A.PLUCODE GROUP BY T.BGNDATE, T.ENDDATE, T.BJLX, T.DEPNAME, T.PLUCODE, T.PLUNAME, T.CLSNAME, T.BARCODE, T.UNIT, T.SPEC, T.PRODUCE, T.PRICE, A.ISKCNOW, A.ISCANSALE) F, RTMP_TSKUMDKCXLCT_HL E, TSKUPLU G WHERE E.ORGCODE=:B1 AND E.PLUID=G.PLUID AND G.PLUCODE=F.PLUCODE AND G.ISACTIVE='1' GROUP BY F.BGNDATE, F.ENDDATE, F.BJLX, F.DEPNAME, F.PLUCODE, F.PLUNAME, F.CLSNAME, F.BARCODE, F.UNIT, F.SPEC, F.PRODUCE, F.PRICE, F.NEWPRICE, F.HYPRICE, F.NEWHYPRICE, F.ISCANSALE, F.ISKC, E.FDKCCOUNT, E.QSZXSCOUNT
c7sn076yz7030select smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings, smontab.tim_scn_map, smontab.orig_thread from smon_scn_time smontab, (select max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP, NUM_MAPPINGS, 0)) cnt from smon_scn_time where thread=0) smontabv where smontab.scn = smontabv.scnmax and thread=0
car763rjdunagSELECT BILLNO , LXSE , PLUCODE , PLUID , REMARK , VPROCXZSPROPLU."ROWID" FROM VPROCXZSPROPLU
cfz686a6qp0kgselect o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#
cx77ch6nkgd5pSELECT RptID , ClmName , ClmType , ClmCaption , ClmDefField , ClmDefCaption , TitleFont , ClmDataType , DispWdith , DispFmt , AnlignType , ForeColor , ClmFont , FootType , FootCaption , LnkObject , LnkFldCode , LnkFldName , IsLocal , IsRight , IsCanSort , IsCanFlt , IsSelect , IsCalculate , Formula , IsDisplay , IsLevel , IsSum , IsAdd , IsGroup , GrpExp , IsGrpSum , IsFigure , IsDefFigure , IsFigLable , IsDefFigLable , IsQryRelation , SerialNo FROM tRptRptColumn Where (RptID = :"SYS_B_0") and rownum <= :"SYS_B_1"
d92h3rjp0y217begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dsr2rvq8k1tjvSELECT SOURCE FROM SYS.EXU8SPSU WHERE OBJ# = :1 ORDER BY LINE
dv7t3p1w4pn0fSelect * from tWebComField where FaceCode=:"SYS_B_0" And ComItemCode=:"SYS_B_1"
dyw8vjw43384wINSERT /*+ Append */ INTO TRTMP_RPT_SALPACKPLU_3205 NOLOGGING (ORGCODE, SALENO, XSDATE, PAGENO, LNNO, PLUID, PLUCODE, PLUNAME, EXPLUCODE, BARCODE, UNIT, SPEC, PRICE, FSPRICE, XSCOUNT, YSTOTAL, SSTOTAL, YHTOTAL, XFTYPE, VIPCARDNO, CXBILLNO, HYBILLNO) SELECT A.ORGCODE, A.SALENO, A.XSDATE, A.PAGENO, A.LNNO, A.PLUID, A.PLUCODE, A.PLUNAME, A.EXPLUCODE, A.BARCODE, A.UNIT, A.SPEC, A.PRICE, A.FSPRICE, A.XSCOUNT, A.YSTOTAL, A.SSTOTAL, A.YHTOTAL, A.XFTYPE, B.VIPCARDNO, A.CXBILLNO, A.HYBILLNO FROM TSALSALEPLU A, TSALSALE B WHERE A.TRANTYPE='1' AND A.PACKTYPE='2' AND B.ORGCODE=A.ORGCODE AND B.SALENO=A.SALENO
dzxzrufuuug0nSELECT IOBJID, IDOBJID, INAME, IOWNER, IOWNERID, ISPACE, ITSNO, IFILENO, IBLOCKNO, BTNAME, BTOWNERID, BTOWNER, PROPERTY, CLUSTER$, PCTFREE$, INITRANS, MAXTRANS, BLEVEL, TYPE, DEFLOG, TSDEFLOG, BTOBJID, BTPROPERTY, BTCLUSTERFLAG, DEGREE, INSTANCES, ROWCNT, LEAFCNT, DISTKEY, LBLKKEY, DBLKKEY, CLUFAC, IFLAGS, SYSGENCONST FROM SYS.EXU9IND WHERE BTOWNERID = :1 AND SYSGENCONST = 0 AND (TYPE = 2 OR TYPE = 9 OR BITAND(PROPERTY, 16) = 16) ORDER BY IOBJID
f65q0ura3jt36 INSERT /*+ LEADING(@"SEL$F5BB74E1" "H"@"SEL$2" "A"@"SEL$1") USE_NL(@"SEL$F5BB74E1" "A"@"SEL$1") */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id, machine, port, ecid ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.curr ent_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id, a.machine, a.port, a.ecid FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
fcsw30vk481abSelect tWebComField.*, tWebComField."ROWID" from tWebComField where FaceCode=:"SYS_B_0" And ComItemCode=:"SYS_B_1" And upper(SendTable)=:"SYS_B_2"
fjvjd4xfxd7fzBegin Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0034'; Delete from tWebComCtrl Where COMTABLE='tProCxPtPlu'And FACECODE='01'And ITEMCODE='1016'And ORGCODE='0034'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0034'; Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0035'; Delete from tWebComCtrl Where COMTABLE='tProCxPtPlu'And FACECODE='01'And ITEMCODE='1016'And ORGCODE='0035'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0035'; End;
ftm0jshxyjv38SELECT FunCode , (SELECT a.FunName FROM tSysFunction a WHERE a.FunCode=tSysPrnFormat.FunCode) AS FunCode$ , PageNo , SerialNo , OrgCode , (SELECT a.OrgName FROM tOrgManage a WHERE a.OrgCode=tSysPrnFormat.OrgCode ) AS OrgName , PrnFormat , Remark , IsEnabled , PrnType , LrDate , UserID , UserCode , UserName , DefValue , PopName , IsBill FROM tSysPrnFormat Where FunCode = :"SYS_B_0" and IsEnabled = :"SYS_B_1" and ( OrgCode = :"SYS_B_2" or OrgCode = :"SYS_B_3" )
g5f37zm046z27 Begin Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0037'; Delete from tWebComCtrl Where COMTABLE='tProCxPtPlu'And FACECODE='01'And ITEMCODE='1016'And ORGCODE='0037'; Delete from tWebComCtrl Where COMTABLE='tProCxPlPlu'And FACECODE='01'And ITEMCODE='1017'And ORGCODE='0037'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0037'; Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0038'; Delete from tWebComCtrl Where COMTABLE='tProCxPtPlu'And FACECODE='01'And ITEMCODE='1016'And ORGCODE='0038'; Delete from tWebComCtrl Where COMTABLE='tProCxPlPlu'And FACECODE='01'And ITEMCODE='1017'And ORGCODE='0038'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0038'; Delete from tWebComCtrl Where COMTABLE='tPosGtPlu'And FACECODE='01'And ITEMCODE='1003'And ORGCODE='0039'; Delete from tWebComCtrl Where COMTABLE='tProCxPtPlu'And FACECODE='01'And ITEMCODE='1016'And ORGCODE='0039'; Delete from tWebComCtrl Where COMTABLE='tProCxPlPlu'And FACECODE='01'And ITEMCODE='1017'And ORGCODE='0039'; Delete from tWebComCtrl Where COMTABLE='tProCxZsPlu'And FACECODE='01'And ITEMCODE='1034'And ORGCODE='0039'; End;
ggatj7gwhv53mselect DECODE(UPPER(d.OPEN_MODE), :"SYS_B_0", :"SYS_B_1", :"SYS_B_2") , DECODE(UPPER(i.STATUS), :"SYS_B_3", :"SYS_B_4", :"SYS_B_5") into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2
gjbjrmkrw4424select sysdate , dual."ROWID" from dual
gnuzuqn7ssmtrSELECT PROMFORMULA , PROMDECIMAL , XTAXRATE , DOTDECIMAL , PRICE , HYPRICE , ISZEROSALE , ISKCNOW , ISKC , ISCERTIDSC , PLUENAME , DEPCODE , PLUID , PLUCODE , PLUNAME , DEPNAME , DEPID , ORGCODE , PLUABBRNAME , 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 , TSKUGTPLU."ROWID" FROM TSKUGTPLU WHERE UPTDATE>(TO_DATE(:"SYS_B_0", :"SYS_B_1")-:"SYS_B_2"/:"SYS_B_3") AND ORGCODE=:"SYS_B_4"
gyqvz1t1688a4DELETE FROM TWEBCOMCTRL WHERE COMTABLE='tPosGtPlu'AND FACECODE='01'AND ITEMCODE='1003'AND ORGCODE='0005'

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 39,915 2.21 31.21
CPU used when call started 38,672 2.14 30.24
CR blocks created 156 0.01 0.12
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DB time 340,830 18.90 266.48
DBWR checkpoint buffers written 4,351 0.24 3.40
DBWR checkpoints 468 0.03 0.37
DBWR fusion writes 744 0.04 0.58
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR tablespace checkpoint buffers written 4 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 483 0.03 0.38
DBWR undo block writes 1,103 0.06 0.86
DFO trees parallelized 361 0.02 0.28
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 1,956 0.11 1.53
PX local messages sent 1,956 0.11 1.53
PX remote messages recv'd 1,016 0.06 0.79
PX remote messages sent 1,590 0.09 1.24
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 361 0.02 0.28
RowCR - row contention 0 0.00 0.00
RowCR attempts 6 0.00 0.00
RowCR hits 6 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 783,082 43.43 612.26
active txn count during cleanout 341 0.02 0.27
application wait time 6,837 0.38 5.35
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 69,302 3.84 54.18
branch node splits 1 0.00 0.00
buffer is not pinned count 2,292,448 127.15 1,792.38
buffer is pinned count 4,880,846 270.72 3,816.14
bytes received via SQL*Net from client 52,671,054 2,921.44 41,181.43
bytes sent via SQL*Net to client 3,588,640,808 199,046.60 2,805,817.68
calls to get snapshot scn: kcmgss 272,933 15.14 213.40
calls to kcmgas 122,662 6.80 95.90
calls to kcmgcs 327 0.02 0.26
change write time 43 0.00 0.03
cleanout - number of ktugct calls 529 0.03 0.41
cleanouts and rollbacks - consistent read gets 105 0.01 0.08
cleanouts only - consistent read gets 110 0.01 0.09
cluster key scan block gets 95,952 5.32 75.02
cluster key scans 37,500 2.08 29.32
cluster wait time 14,304 0.79 11.18
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 0 0.00 0.00
commit batch/immediate requested 0 0.00 0.00
commit cleanout failures: block lost 42 0.00 0.03
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 19 0.00 0.01
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 7,236 0.40 5.66
commit cleanouts successfully completed 7,175 0.40 5.61
commit immediate performed 0 0.00 0.00
commit immediate requested 0 0.00 0.00
commit txn count during cleanout 369 0.02 0.29
concurrency wait time 902 0.05 0.71
consistent changes 1,449 0.08 1.13
consistent gets 54,954,439 3,048.09 42,966.72
consistent gets - examination 1,313,948 72.88 1,027.32
consistent gets direct 537,797 29.83 420.48
consistent gets from cache 54,416,642 3,018.26 42,546.24
current blocks converted for CR 0 0.00 0.00
cursor authentications 533 0.03 0.42
data blocks consistent reads - undo records applied 124 0.01 0.10
db block changes 63,684 3.53 49.79
db block gets 66,406 3.68 51.92
db block gets direct 0 0.00 0.00
db block gets from cache 66,406 3.68 51.92
deferred (CURRENT) block cleanout applications 2,763 0.15 2.16
dirty buffers inspected 0 0.00 0.00
enqueue conversions 7,153 0.40 5.59
enqueue deadlocks 0 0.00 0.00
enqueue releases 544,694 30.21 425.87
enqueue requests 544,695 30.21 425.88
enqueue timeouts 1 0.00 0.00
enqueue waits 3,541 0.20 2.77
exchange deadlocks 0 0.00 0.00
execute count 152,898 8.48 119.54
failed probes on index block reclamation 1 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 254,998 14.14 199.37
free buffer requested 463,812 25.73 362.64
gc CPU used by this session 9,861 0.55 7.71
gc blocks lost 0 0.00 0.00
gc cr block build time 4 0.00 0.00
gc cr block flush time 2 0.00 0.00
gc cr block receive time 17,423 0.97 13.62
gc cr block send time 10 0.00 0.01
gc cr blocks received 351,229 19.48 274.61
gc cr blocks served 3,026 0.17 2.37
gc current block flush time 2 0.00 0.00
gc current block pin time 69 0.00 0.05
gc current block receive time 3,866 0.21 3.02
gc current block send time 458 0.03 0.36
gc current blocks received 86,503 4.80 67.63
gc current blocks served 154,416 8.56 120.73
gc local grants 11,590 0.64 9.06
gc remote grants 13,963 0.77 10.92
gcs messages sent 734,960 40.77 574.64
ges messages sent 90,313 5.01 70.61
global enqueue get time 1,418 0.08 1.11
global enqueue gets async 17,923 0.99 14.01
global enqueue gets sync 45,314 2.51 35.43
global enqueue releases 56,622 3.14 44.27
heap block compress 169 0.01 0.13
hot buffers moved to head of LRU 11,718 0.65 9.16
immediate (CR) block cleanout applications 215 0.01 0.17
immediate (CURRENT) block cleanout applications 886 0.05 0.69
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 19,694 1.09 15.40
index fast full scans (full) 1,091 0.06 0.85
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 864,337 47.94 675.79
index scans kdiixs1 160,132 8.88 125.20
leaf node 90-10 splits 64 0.00 0.05
leaf node splits 98 0.01 0.08
lob reads 500 0.03 0.39
lob writes 411 0.02 0.32
lob writes unaligned 411 0.02 0.32
logons cumulative 888 0.05 0.69
messages received 18,855 1.05 14.74
messages sent 18,855 1.05 14.74
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 53,499,800 2,967.41 41,829.40
opened cursors cumulative 212,545 11.79 166.18
parse count (failures) 18,371 1.02 14.36
parse count (hard) 20,739 1.15 16.22
parse count (total) 194,546 10.79 152.11
parse time cpu 851 0.05 0.67
parse time elapsed 2,548 0.14 1.99
physical read IO requests 40,713 2.26 31.83
physical read bytes 4,199,063,552 232,904.15 3,283,083.31
physical read total IO requests 408,956 22.68 319.75
physical read total bytes 10,230,400,000 567,436.65 7,998,749.02
physical read total multi block requests 33,809 1.88 26.43
physical reads 512,581 28.43 400.77
physical reads cache 24,673 1.37 19.29
physical reads cache prefetch 16,866 0.94 13.19
physical reads direct 487,908 27.06 381.48
physical reads direct (lob) 191 0.01 0.15
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 4,040 0.22 3.16
physical write bytes 41,189,376 2,284.60 32,204.36
physical write total IO requests 12,533 0.70 9.80
physical write total bytes 153,405,952 8,508.77 119,942.10
physical write total multi block requests 2,352 0.13 1.84
physical writes 5,028 0.28 3.93
physical writes direct 47 0.00 0.04
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 4,981 0.28 3.89
physical writes non checkpoint 1,979 0.11 1.55
pinned buffers inspected 24 0.00 0.02
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 12 0.00 0.01
process last non-idle time 17,680 0.98 13.82
queries parallelized 361 0.02 0.28
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 584,922 32.44 457.33
recursive cpu usage 3,181 0.18 2.49
redo blocks written 26,403 1.46 20.64
redo buffer allocation retries 2 0.00 0.00
redo entries 33,773 1.87 26.41
redo log space requests 2 0.00 0.00
redo log space wait time 1 0.00 0.00
redo ordering marks 648 0.04 0.51
redo size 12,366,600 685.92 9,668.96
redo subscn max counts 1,102 0.06 0.86
redo synch time 31 0.00 0.02
redo synch writes 656 0.04 0.51
redo wastage 778,288 43.17 608.51
redo write broadcast ack time 15 0.00 0.01
redo write time 110 0.01 0.09
redo writer latching time 0 0.00 0.00
redo writes 2,555 0.14 2.00
rollback changes - undo records applied 0 0.00 0.00
rollbacks only - consistent read gets 19 0.00 0.01
root node splits 1 0.00 0.00
rows fetched via callback 106,997 5.93 83.66
session connect time 0 0.00 0.00
session cursor cache hits 116,483 6.46 91.07
session logical reads 55,020,845 3,051.77 43,018.64
shared hash latch upgrades - no wait 20,168 1.12 15.77
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 121,776 6.75 95.21
sorts (rows) 680,543 37.75 532.09
sql area evicted 2,071 0.11 1.62
sql area purged 18,373 1.02 14.37
summed dirty queue length 0 0.00 0.00
switch current to new buffer 143 0.01 0.11
table fetch by rowid 2,535,714 140.65 1,982.58
table fetch continued row 407 0.02 0.32
table scan blocks gotten 51,960,953 2,882.05 40,626.23
table scan rows gotten 446,406,846 24,760.28 349,028.03
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 400 0.02 0.31
table scans (long tables) 400 0.02 0.31
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 37,800 2.10 29.55
total number of times SMON posted 0 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction rollbacks 0 0.00 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 4,404,996 244.33 3,444.09
user I/O wait time 17,287 0.96 13.52
user calls 572,649 31.76 447.73
user commits 949 0.05 0.74
user rollbacks 330 0.02 0.26
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 52,437 2.91 41.00
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 1.6E+12 1.6E+12
session cursor cache count 2,195,954 2,203,748
session uga memory 1.8E+13 1.8E+13
opened cursors current 125 111
logons current 57 55
session uga memory max 4.6E+11 4.6E+11
session pga memory 4.1E+11 4.1E+11

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 0.20

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 31,239 2 0.11 14.34 409 0 1,677 0.41
SYSTEM 6,095 0 3.63 3.72 246 0 0 0.00
SYSAUX 481 0 8.36 1.01 2,324 0 0 0.00
HSCMP_TBL_LOG 2,728 0 0.02 15.30 27 0 0 0.00
UNDOTBS2 1 0 0.00 1.00 1,002 0 0 0.00
HSCMP_IDX 119 0 7.23 1.00 19 0 0 0.00
HSCMP_TBL_SAL 107 0 2.62 1.04 7 0 0 0.00
HSCMP_TBL_STK 3 0 0.00 1.00 3 0 0 0.00
HSCMP_COM 1 0 0.00 1.00 1 0 0 0.00
UNDOTBS1 1 0 0.00 1.00 1 0 0 0.00
USERS 1 0 0.00 1.00 1 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_COM +ORADISK/xlcmp/datafile/hscmp_com1.dbf 1 0 0.00 1.00 1 0 0 0.00
HSCMP_IDX +ORADISK/xlcmp/datafile/hscmp_idx.332.797345253 3 0 3.33 1.00 1 0 0 0.00
HSCMP_IDX +ORADISK/xlcmp/datafile/hscmp_idx01.dbf 24 0 8.33 1.00 1 0 0 0.00
HSCMP_IDX +ORADISK/xlcmp/datafile/hscmp_idx02.dbf 40 0 7.75 1.00 6 0 0 0.00
HSCMP_IDX +ORADISK/xlcmp/datafile/hscmp_idx03.dbf 30 0 6.67 1.00 1 0 0 0.00
HSCMP_IDX +ORADISK/xlcmp/datafile/hscmp_idx04.dbf 13 0 4.62 1.00 1 0 0 0.00
HSCMP_IDX +ORADISK/xlcmp/datafile/hscmp_idx05.dbf 9 0 8.89 1.00 9 0 0 0.00
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl01.dbf 1,232 0 0.09 14.03 329 0 123 0.41
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl02.dbf 1,238 0 0.54 13.27 1 0 161 0.43
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl03.dbf 1,001 0 0.08 14.66 1 0 1 0.00
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl04.dbf 1,074 0 0.08 14.39 11 0 3 0.00
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl05.dbf 1,169 0 0.13 14.14 1 0 0 0.00
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl06.dbf 1,152 0 0.08 14.73 1 0 12 0.83
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl07.dbf 1,220 0 0.10 14.82 1 0 78 0.38
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl08.dbf 1,270 0 0.29 14.41 2 0 145 0.48
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl09.dbf 1,184 0 0.03 14.58 3 0 158 0.25
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl10.dbf 1,629 0 0.38 11.03 6 0 110 0.45
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl11.dbf 1,909 0 0.06 13.88 42 0 85 0.35
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl12.dbf 827 0 0.06 14.08 1 0 0 0.00
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl13.dbf 941 0 0.05 13.96 1 0 115 0.70
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl14.dbf 1,193 0 0.11 14.26 1 0 159 0.44
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl15.dbf 685 0 0.16 14.31 1 0 0 0.00
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl16.dbf 833 0 0.08 14.72 1 0 0 0.00
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl17.dbf 563 0 0.14 13.82 1 0 212 0.42
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl18.dbf 2,158 0 0.01 15.04 1 0 284 0.32
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl19.dbf 4,134 0 0.09 14.53 1 0 31 0.32
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl20.dbf 3,676 0 0.01 15.20 1 0 0 0.00
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl21.dbf 2,150 0 0.04 15.12 1 0 0 0.00
HSCMP_TBL +ORADISK/xlcmp/datafile/hscmp_tbl22.dbf 1 0 0.00 1.00 1 0 0 0.00
HSCMP_TBL_LOG +ORADISK/xlcmp/datafile/hscmp_tbl_log01.dbf 1,395 0 0.02 15.32 18 0 0 0.00
HSCMP_TBL_LOG +ORADISK/xlcmp/datafile/hscmp_tbl_log02.dbf 1,333 0 0.02 15.28 9 0 0 0.00
HSCMP_TBL_SAL +ORADISK/xlcmp/datafile/hscmp_tbl_sal01.dbf 32 0 1.25 1.06 1 0 0 0.00
HSCMP_TBL_SAL +ORADISK/xlcmp/datafile/hscmp_tbl_sal02.dbf 23 0 2.61 1.00 1 0 0 0.00
HSCMP_TBL_SAL +ORADISK/xlcmp/datafile/hscmp_tbl_sal03.dbf 18 0 4.44 1.06 1 0 0 0.00
HSCMP_TBL_SAL +ORADISK/xlcmp/datafile/hscmp_tbl_sal04.dbf 9 0 2.22 1.00 1 0 0 0.00
HSCMP_TBL_SAL +ORADISK/xlcmp/datafile/hscmp_tbl_sal05.dbf 21 0 3.33 1.05 1 0 0 0.00
HSCMP_TBL_SAL +ORADISK/xlcmp/datafile/hscmp_tbl_sal06.dbf 3 0 3.33 1.00 1 0 0 0.00
HSCMP_TBL_SAL +ORADISK/xlcmp/datafile/hscmp_tbl_sal07.dbf 1 0 0.00 1.00 1 0 0 0.00
HSCMP_TBL_STK +ORADISK/xlcmp/datafile/hscmp_tbl_stk01.dbf 1 0 0.00 1.00 1 0 0 0.00
HSCMP_TBL_STK +ORADISK/xlcmp/datafile/hscmp_tbl_stk02.dbf 1 0 0.00 1.00 1 0 0 0.00
HSCMP_TBL_STK +ORADISK/xlcmp/datafile/hscmp_tbl_stk03.dbf 1 0 0.00 1.00 1 0 0 0.00
SYSAUX +ORADISK/xlcmp/datafile/sysaux.257.762368093 481 0 8.36 1.01 2,324 0 0 0.00
SYSTEM +ORADISK/xlcmp/datafile/system.256.762368091 6,094 0 3.63 3.72 245 0 0 0.00
SYSTEM +ORADISK/xlcmp/datafile/system01.dbf 1 0 0.00 1.00 1 0 0 0.00
UNDOTBS1 +ORADISK/xlcmp/datafile/undotbs1.258.762368093 1 0 0.00 1.00 1 0 0 0.00
UNDOTBS2 +ORADISK/xlcmp/datafile/undotbs2.264.762368175 1 0 0.00 1.00 1,002 0 0 0.00
USERS +ORADISK/xlcmp/datafile/users.259.762368093 1 0 0.00 1.00 1 0 0 0.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 985,769 100 -4,240,484,361 24,682 4,981 0 0 1,677


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 0 292 701 1161 552960 1161  
E 0 0 263 698 1645 552960 1645  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 816 0.10 97,767 2.96 2,448,710,038
D 1,632 0.20 195,534 2.36 1,954,434,878
D 2,448 0.30 293,301 1.94 1,602,646,462
D 3,264 0.40 391,068 1.64 1,358,642,206
D 4,080 0.50 488,835 1.44 1,188,760,565
D 4,896 0.59 586,602 1.29 1,067,966,824
D 5,712 0.69 684,369 1.19 980,585,227
D 6,528 0.79 782,136 1.11 916,058,321
D 7,344 0.89 879,903 1.05 867,273,951
D 8,160 0.99 977,670 1.00 829,763,533
D 8,240 1.00 987,255 1.00 826,856,262
D 8,976 1.09 1,075,437 0.97 800,109,488
D 9,792 1.19 1,173,204 0.94 776,012,959
D 10,608 1.29 1,270,971 0.91 755,722,214
D 11,424 1.39 1,368,738 0.89 737,869,422
D 12,240 1.49 1,466,505 0.87 721,608,002
D 13,056 1.58 1,564,272 0.85 706,209,779
D 13,872 1.68 1,662,039 0.84 690,957,886
D 14,688 1.78 1,759,806 0.82 675,247,776
D 15,504 1.88 1,857,573 0.80 658,651,864
D 16,320 1.98 1,955,340 0.78 641,082,547

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 2,441 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 MemGlobal Mem Bound(K)
B 1,907 1,588 268.35 0.66 0.25 100.00 0.00 195,310
E 1,907 1,586 269.75 0.00 0.00 0.00 0.00 195,310

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 49,660 49,660 0 0
64K 128K 51 51 0 0
128K 256K 16 16 0 0
256K 512K 24 24 0 0
512K 1024K 1,835 1,835 0 0
1M 2M 849 849 0 0
2M 4M 2 2 0 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
238 0.13 2,826,083.05 707,596.25 80.00 142
477 0.25 2,826,083.05 290,929.94 91.00 0
954 0.50 2,826,083.05 282,232.19 91.00 0
1,431 0.75 2,826,083.05 281,867.69 91.00 0
1,907 1.00 2,826,083.05 275,887.78 91.00 0
2,289 1.20 2,826,083.05 218,445.40 93.00 0
2,670 1.40 2,826,083.05 218,445.40 93.00 0
3,052 1.60 2,826,083.05 218,445.40 93.00 0
3,433 1.80 2,826,083.05 218,445.40 93.00 0
3,815 2.00 2,826,083.05 218,445.40 93.00 0
5,722 3.00 2,826,083.05 218,445.40 93.00 0
7,629 4.00 2,826,083.05 218,445.40 93.00 0
11,444 6.00 2,826,083.05 218,445.40 93.00 0
15,259 8.00 2,826,083.05 218,445.40 93.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)
736 0.59 157 10,078 5,496,336 1.00 171,844 1.17 596,528
864 0.69 284 15,301 5,503,043 1.00 165,137 1.12 597,667
992 0.79 410 25,024 5,509,419 1.00 158,761 1.08 598,740
1,120 0.90 535 32,640 5,515,366 1.00 152,814 1.04 599,728
1,248 1.00 659 39,465 5,520,765 1.00 147,415 1.00 600,609
1,376 1.10 786 45,601 5,525,442 1.00 142,738 0.97 601,359
1,504 1.21 913 52,872 5,529,492 1.00 138,688 0.94 601,996
1,632 1.31 1,040 59,797 5,533,198 1.00 134,982 0.92 602,575
1,760 1.41 1,167 66,609 5,536,655 1.00 131,525 0.89 603,112
1,888 1.51 1,294 73,103 5,539,907 1.00 128,273 0.87 603,618
2,016 1.62 1,421 79,653 5,542,964 1.00 125,216 0.85 604,096
2,144 1.72 1,548 86,475 5,545,791 1.00 122,389 0.83 604,543
2,272 1.82 1,675 93,393 5,548,335 1.01 119,845 0.81 604,953
2,400 1.92 1,802 100,365 5,550,649 1.01 117,531 0.80 605,334
2,528 2.03 1,929 107,433 5,552,857 1.01 115,323 0.78 605,701

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,388 0.25 5,779,843 2,019,761,759
4,776 0.50 3,317,070 1,228,460,329
7,164 0.75 2,432,903 946,667,719
9,552 1.00 2,060,036 826,856,249
11,940 1.25 1,853,208 762,526,833
14,328 1.50 1,702,414 714,073,057
16,716 1.75 1,570,365 680,668,064
19,104 2.00 1,546,675 662,477,227

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 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP 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
16 1.00 2 74 1 1.00 147,415 1.00 74
32 2.00 2 74 1 1.00 147,415 1.00 74

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 1,677 1 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
KO-Multiple Object Checkpoint (fast object checkpoint) 3,600 3,600 0 1,199 3 2.83
WF-AWR Flush 229 229 0 56 1 17.00
TM-DML 4,284 4,284 0 462 0 0.92
PS-PX Process Reservation 2,495 2,495 0 781 0 0.40
IR-Instance Recovery 400 400 0 400 0 0.34
TQ-Queue table enqueue (TM contention) 166 166 0 166 0 0.44
TT-Tablespace 919 919 0 202 0 0.36
RO-Multiple Object Reuse (fast object reuse) 268 268 0 134 0 0.37
TA-Instance Undo 60 60 0 60 0 0.53
HW-Segment High Water Mark 382 382 0 51 0 0.51
JS-Job Scheduler (job run lock - synchronize) 11 11 0 6 0 1.33
FB-Format Block 24 24 0 15 0 0.33
AF-Advisor Framework (task serialization) 35 35 0 3 0 0.67
CF-Controlfile Transaction 365,312 365,312 0 2 0 1.00
FU-DBFUS 1 1 0 1 0 1.00
JQ-Job Queue 1 0 1 1 0 1.00
TO-Temp Object 1 1 0 1 0 1.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
5 0.71 2,121 11,922 3 15/210.7 0/0 0/0/0/0/0/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
13-Jan 07:08 61 81 0 3 19 0/0 0/0/0/0/0/0
13-Jan 06:58 16 79 0 3 48 0/0 0/0/0/0/0/0
13-Jan 06:48 10 34 0 1 38 0/0 0/0/0/0/0/0
13-Jan 06:38 8 92 0 1 28 0/0 0/0/0/0/0/0
13-Jan 06:28 13 42 0 3 18 0/0 0/0/0/0/0/0
13-Jan 06:18 6 143 0 1 19 0/0 0/0/0/0/0/0
13-Jan 06:08 68 97 0 3 20 0/0 0/0/0/0/0/0
13-Jan 05:58 7 42 0 1 19 0/0 0/0/0/0/0/0
13-Jan 05:48 11 27 0 1 16 0/0 0/0/0/0/0/0
13-Jan 05:38 12 44 0 1 25 0/0 0/0/0/0/0/0
13-Jan 05:28 8 25 0 1 16 0/0 0/0/0/0/0/0
13-Jan 05:18 16 106 0 1 18 0/0 0/0/0/0/0/0
13-Jan 05:08 63 73 0 3 16 0/0 0/0/0/0/0/0
13-Jan 04:58 13 45 0 3 24 0/0 0/0/0/0/0/0
13-Jan 04:48 12 35 0 1 16 0/0 0/0/0/0/0/0
13-Jan 04:38 15 50 0 3 16 0/0 0/0/0/0/0/0
13-Jan 04:28 10 37 0 1 18 0/0 0/0/0/0/0/0
13-Jan 04:18 13 107 0 1 16 0/0 0/0/0/0/0/0
13-Jan 04:08 72 97 0 3 16 0/0 0/0/0/0/0/0
13-Jan 03:58 7 45 0 1 16 0/0 0/0/0/0/0/0
13-Jan 03:48 17 43 0 3 22 0/0 0/0/0/0/0/0
13-Jan 03:38 6 44 0 1 19 0/0 0/0/0/0/0/0
13-Jan 03:28 10 32 0 1 16 0/0 0/0/0/0/0/0
13-Jan 03:18 17 126 0 3 16 0/0 0/0/0/0/0/0
13-Jan 03:08 76 100 0 3 19 0/0 0/0/0/0/0/0
13-Jan 02:58 11 67 0 1 17 0/0 0/0/0/0/0/0
13-Jan 02:48 14 43 0 3 22 0/0 0/0/0/0/0/0
13-Jan 02:38 15 118 0 1 17 0/0 0/0/0/0/0/0
13-Jan 02:28 16 42 0 3 15 0/0 0/0/0/0/0/0
13-Jan 02:18 9 123 0 1 15 0/0 0/0/0/0/0/0
13-Jan 02:08 75 82 11,922 3 211 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 22,028 0.00   0 0  
ASM map operation freelist 159 0.00   0 0  
ASM map operation hash table 843,638 0.00   0 0  
ASM network background latch 7,210 0.00   0 0  
AWR Alerted Metric Element list 83,463 0.00   0 0  
Consistent RBA 2,557 0.00   0 0  
FOB s.o list latch 8,576 0.00   0 0  
JOX SGA heap latch 16 0.00   0 0  
JS broadcast add buf latch 4,136 0.00   0 0  
JS broadcast drop buf latch 4,136 0.00   0 0  
JS broadcast load blnc latch 3,596 0.00   0 0  
JS mem alloc latch 27 0.00   0 0  
JS queue access latch 27 0.00   0 0  
JS queue state obj latch 130,542 0.00   0 0  
JS slv state obj latch 242,463 0.01 0.00 0 0  
KCL gc element parent latch 1,974,064 0.01 0.00 0 518 0.00
KFK SGA context latch 15,064 0.00   0 0  
KFMD SGA 86 0.00   0 0  
KJC message pool free list 102,089 1.92 0.00 0 46,589 0.00
KJCT flow control latch 861,646 0.00 0.43 0 0  
KMG MMAN ready and startup request latch 6,009 0.00   0 0  
KSXR large replies 6 0.00   0 0  
KTF sga latch 62 0.00   0 5,289 0.00
KWQMN job cache list latch 2,442 0.00   0 0  
KWQP Prop Status 10 0.00   0 0  
MQL Tracking Latch 0     0 361 0.00
Memory Management Latch 0     0 6,009 0.00
OS process 1,866 0.00   0 0  
OS process allocation 7,251 0.00   0 0  
OS process: request allocation 918 0.00   0 0  
PL/SQL warning settings 4,591 0.00   0 0  
SGA IO buffer pool latch 104 0.00   0 104 0.00
SQL memory manager latch 5 0.00   0 6,008 0.00
SQL memory manager workarea list latch 426,606 0.00   0 0  
Shared B-Tree 650 0.00   0 0  
active checkpoint queue latch 11,293 0.01 0.00 0 0  
active service list 41,863 0.00   0 16,860 0.00
archive control 303 0.00   0 0  
business card 722 0.00   0 0  
cache buffer handles 6,498 0.00   0 0  
cache buffers chains 109,930,237 0.00 0.00 0 5,541,672 0.00
cache buffers lru chain 118,554 0.01 0.00 0 5,080,128 0.01
cache table scan latch 0     0 1,237 0.00
channel handle pool latch 988 0.00   0 0  
channel operations parent latch 1,140,305 0.01 0.02 0 0  
checkpoint queue latch 266,163 0.00 0.00 0 5,413 0.00
client/application info 4,098 0.00   0 0  
commit callback allocation 740 0.00   0 0  
compile environment latch 888 0.00   0 0  
dml lock allocation 8,891 0.00   0 0  
dummy allocation 1,778 0.00   0 0  
enqueue hash chains 1,118,923 0.00 0.00 0 621 0.00
enqueues 1,080,796 0.00 0.00 0 0  
error message lists 1,745 0.00   0 0  
event group latch 458 0.00   0 0  
file cache latch 4,193 0.00   0 0  
gcs opaque info freelist 477,404 0.03 0.00 0 0  
gcs partitioned table hash 6,156,629 0.00   0 392 0.00
gcs remastering latch 829,094 0.00   0 0  
gcs resource freelist 225,270 0.00   0 168,933 0.00
gcs resource hash 2,730,595 0.15 0.00 0 1 0.00
gcs resource scan list 2 0.00   0 0  
gcs shadows freelist 330,126 0.00   0 303,378 0.00
ges caches resource lists 4,077,644 0.00 0.00 0 4,067,789 0.00
ges deadlock list 21,864 0.00   0 0  
ges domain table 80,236 0.00   0 0  
ges enqueue table freelist 151,287 0.00   0 0  
ges group table 121,862 0.00   0 0  
ges process hash list 48,254 0.00   0 0  
ges process parent latch 315,289 0.00   0 0  
ges process table freelist 918 0.00   0 0  
ges resource hash list 430,269 0.01 0.54 0 75,102 0.03
ges resource scan list 36 0.00   0 0  
ges resource table freelist 131,951 0.00 0.00 0 0  
ges synchronous data 32 0.00   0 46,751 0.00
ges timeout list 12,048 0.00   0 6,771 0.00
global KZLD latch for mem in SGA 377 0.00   0 0  
hash table column usage latch 419 0.00   0 196,851 0.00
hash table modification latch 316 0.00   0 0  
interrupt manipulation 3,204 0.00   0 0  
job workq parent latch 0     0 22 0.00
job_queue_processes parameter latch 311 0.00   0 0  
kks stats 8,379 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 34 0.00   0 0  
ksuosstats global area 1,212 0.00   0 0  
ktm global data 60 0.00   0 0  
kwqbsn:qsga 645 0.00   0 0  
lgwr LWN SCN 7,419 0.00   0 0  
library cache 840,586 0.00 0.00 0 4,832 0.00
library cache load lock 3,686 0.00   0 0  
library cache lock 1,037,279 0.00 0.00 0 0  
library cache lock allocation 9,777 0.00   0 0  
library cache pin 170,715 0.00   0 0  
library cache pin allocation 1,784 0.00   0 0  
list of block allocation 569 0.00   0 0  
loader state object freelist 1,017 0.00   0 0  
logminer context allocation 5 0.00   0 0  
longop free list parent 12 0.00   0 11 0.00
message pool operations parent latch 6,851 0.00   0 0  
messages 969,230 0.00 0.00 0 0  
mostly latch-free SCN 7,434 0.17 0.00 0 0  
multiblock read objects 523,770 0.00 0.00 0 0  
name-service memory objects 19,252 0.00   0 0  
name-service namespace bucket 352,920 0.00   0 0  
name-service pending queue 12,228 0.00   0 0  
name-service request queue 369,751 0.00   0 0  
ncodef allocation latch 323 0.00   0 0  
object queue header heap 18,035 0.00   0 365 0.00
object queue header operation 971,679 0.00 0.38 0 0  
object stats modification 6 0.00   0 0  
parallel query alloc buffer 9,636 0.00   0 0  
parallel query stats 1,502 0.00   0 0  
parallel txn reco latch 1,500 0.00   0 0  
parameter list 4,718 0.00   0 0  
parameter table management 1,781 0.00   0 0  
post/wait queue 1,350 0.00   0 729 0.00
process allocation 341,294 0.00 0.00 0 457 0.22
process group creation 918 0.00   0 0  
process queue 3,995 0.00   0 0  
process queue reference 67,610 0.00 0.00 0 6,518 0.00
qmn state object latch 6 0.00   0 0  
qmn task queue latch 2,564 0.00   0 0  
query server freelists 3,305 0.00   0 0  
queued dump request 90,132 0.00   0 0  
redo allocation 17,403 0.01 0.00 0 33,767 0.01
redo copy 0     0 33,767 0.03
redo writing 28,772 0.00   0 0  
resmgr group change latch 1,096 0.00   0 0  
resmgr:active threads 1,695 0.00   0 0  
resmgr:actses change group 796 0.00   0 0  
resmgr:free threads list 1,690 0.00   0 0  
resmgr:resource group CPU method 800 0.00   0 0  
resmgr:schema config 5 0.00   0 0  
row cache objects 899,365 0.00 0.00 0 3,709 0.00
rules engine aggregate statistics 264 0.00   0 0  
rules engine rule set statistics 1,028 0.00   0 0  
sequence cache 2,107 0.00   0 0  
session allocation 14,070 0.45 0.02 0 0  
session idle bit 1,149,714 0.00   0 0  
session state list latch 1,066 0.00   0 0  
session switching 2,623 0.00   0 0  
session timer 6,781 0.00   0 0  
shared pool 473,270 0.01 1.08 0 0  
shared pool simulator 18,966 0.00   0 0  
simulator hash latch 3,416,745 0.00 0.00 0 0  
simulator lru latch 0     0 3,413,769 0.01
slave class 44 0.00   0 0  
slave class create 176 2.84 1.00 0 0  
sort extent pool 697 0.00   0 0  
state object free list 10 0.00   0 0  
statistics aggregation 2,800 0.00   0 0  
temp lob duration state obj allocation 3 0.00   0 0  
temporary table state object allocation 2 0.00   0 0  
threshold alerts latch 2,108 0.00   0 0  
transaction allocation 620 0.00   0 0  
transaction branch allocation 6,781 0.00   0 0  
undo global data 11,126 0.00   0 0  
user lock 1,516 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
gcs resource hash 2,730,595 4,027 8 4,019 0 0 0
cache buffers chains 109,930,237 1,943 4 1,939 0 0 0
session allocation 14,070 63 1 62 0 0 0
channel operations parent latch 1,140,305 61 1 60 0 0 0
ges resource hash list 430,269 54 29 25 0 0 0
shared pool 473,270 39 42 33 0 0 0
KJCT flow control latch 861,646 21 9 12 0 0 0
object queue header operation 971,679 8 3 6 0 0 0
slave class create 176 5 5 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch KCLUNLNK 0 1 0
KJCT flow control latch kjcts_sedeqv: dequeue a vector of msgs 0 8 0
KJCT flow control latch kjctcsnd: send normal message 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 38 35
cache buffers chains kcbzwb 0 1 0
channel operations parent latch ksrwait() 0 1 1
gcs resource hash kjbassume 0 4 0
gcs resource hash kjbcrcomplete 0 3 0
gcs resource hash kjbcropen:affinity 0 1 0
ges resource hash list kjakcai: search for resp by resname 0 25 0
ges resource hash list kjrmas1: lookup master node 0 3 0
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 1 0
object queue header operation kclobj_1 0 2 0
object queue header operation kcbo_switch_mq_bg 0 1 1
session allocation ksufap: active sessions 0 1 0
shared pool kgh: quiesce extents 0 36 0
shared pool kgh_next_free 0 4 0
shared pool kghalo 0 1 17
shared pool kghupr1 0 1 23
slave class create ksvcreate 0 5 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
SYS SYSTEM OPQTYPE$   TABLE 41,846,976 76.06
HSCMP HSCMP_TBL TSKUGTPLU   TABLE 6,659,632 12.10
HSCMP HSCMP_TBL TPROCXPTPLU   TABLE 1,703,312 3.10
SYS SYSTEM I_OBJ1   INDEX 451,008 0.82
SYS SYSTEM OBJ$   TABLE 427,760 0.78

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HSCMP HSCMP_TBL TSTKPCGUID   TABLE 129,293 25.22
HSCMP HSCMP_TBL TSYSRSALEPLUHIS   TABLE 107,821 21.03
HSCMP HSCMP_TBL_LOG TSYSLOG   TABLE 41,728 8.14
READHSCMP HSCMP_TBL TEMSUPXSYK20080312   TABLE 34,582 6.75
READHSCMP HSCMP_TBL TLSXSHULING20081006   TABLE 34,224 6.68

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
SYS SYSAUX WRH$_SERVICE_STAT_PK 3607_20250 INDEX PARTITION 2 100.00

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
HSCMP HSCMP_TBL TSKUGTPLU   TABLE 1,677 100.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
HSCMP HSCMP_TBL TSKUGTPLU   TABLE 336,146 95.71
HSCMP HSCMP_TBL_SAL TSALSALEPLU   TABLE 9,446 2.69
HSCMP HSCMP_TBL_SAL TSALSALE   TABLE 1,544 0.44
SYS SYSTEM JOB$   TABLE 1,447 0.41
SYS SYSTEM I_JOB_NEXT   INDEX 1,328 0.38

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
HSCMP HSCMP_TBL TSKUGTPLU   TABLE 82,936 95.88
HSCMP HSCMP_IDX IDX_TSKUGTPLU_PLUID   INDEX 808 0.93
HSCMP HSCMP_TBL TWEBCOMCTRL   TABLE 371 0.43
SYS SYSTEM I_JOB_NEXT   INDEX 330 0.38
SYS SYSTEM JOB$   TABLE 330 0.38

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 324 1.54 0   5 1
dc_database_links 764 0.00 0   0 1
dc_global_oids 115 11.30 0   0 90
dc_histogram_data 68,536 0.97 0   0 8,715
dc_histogram_defs 34,639 20.30 0   0 15,842
dc_object_grants 1,170 3.25 0   0 450
dc_object_ids 28,608 1.66 0   0 3,047
dc_objects 15,824 4.84 0   0 1,595
dc_profiles 377 0.00 0   0 1
dc_rollback_segments 2,698 0.00 0   0 28
dc_segments 27,456 2.77 0   17 2,525
dc_sequences 23 30.43 0   23 2
dc_tablespaces 61,668 0.00 0   0 12
dc_usernames 3,613 0.08 0   0 15
dc_users 73,716 0.00 0   0 46
global database name 1 100.00 0   0 1
outstanding_alerts 1,012 78.26 0   264 2

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 15 5 0
dc_global_oids 13 0 0
dc_histogram_defs 7,033 0 8,528
dc_object_ids 478 3 466
dc_objects 770 12 451
dc_segments 788 26 788
dc_sequences 46 5 0
dc_usernames 3 0 1
global database name 1 0 0
outstanding_alerts 1,856 660 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 89 14.61 13,234 0.34 32 0
CLUSTER 65 3.08 113 2.65 1 0
INDEX 2 100.00 6 33.33 0 0
JAVA DATA 1 0.00 0   0 0
SQL AREA 175,123 58.93 303,616 14.20 18,648 30
TABLE/PROCEDURE 7,158 10.67 66,346 2.72 386 0
TRIGGER 27 11.11 37 10.81 1 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 113 2 0 2 0
INDEX 6 2 0 2 0
TABLE/PROCEDURE 25,270 518 1,228 571 0

Back to Library Cache Statistics
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 174.94   2.92 4.38 24 24 60 60
  Freeable 89.50 0.00 2.98 9.70 54   30 30
  SQL 3.55 2.97 0.08 0.18 1 4 43 41
  PL/SQL 0.37 0.24 0.01 0.01 0 0 58 58
E Other 175.30   3.02 4.40 24 24 58 58
  Freeable 91.44 0.00 3.05 9.68 54   30 30
  SQL 2.58 2.14 0.07 0.13 1 4 39 37
  PL/SQL 0.44 0.31 0.01 0.01 0 0 56 56

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 8,640,266,240  
Fixed Size 2,112,864  
Redo Buffers 14,663,680  
Variable Size 1,358,955,168  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 10.25 10.25 0.00
java joxlod exec hp 5.56 5.56 0.00
java joxs heap 0.18 0.18 0.00
large ASM map operations hashta 0.38 0.38 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.60 14.60 0.00
shared CCursor 38.15 43.20 13.22
shared KGH: NO ACCESS 227.47 227.47 0.00
shared KGLS heap 25.33 25.40 0.25
shared KQR L PO 23.80 22.78 -4.28
shared KQR X PO 32.57 32.57 0.00
shared PCursor 23.51 25.17 7.02
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 405.45 404.61 -0.21
shared gcs resources 178.87 178.87 0.00
shared gcs shadows 107.11 107.11 0.00
shared ges enqueues 16.16 16.16 0.00
shared ges resource 18.19 18.19 0.00
shared kglsim heap 20.48 20.48 0.00
shared kglsim object batch 34.50 34.50 0.00
shared library cache 24.80 26.16 5.50
shared obj stat memo 22.85 22.85 0.00
shared sql area 115.72 100.00 -13.58
streams free memory 16.00 16.00 0.00
  buffer_cache 8,240.00 8,240.00 0.00
  fixed_sga 2.01 2.01 0.00
  log_buffer 13.98 13.98 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 580,000 68,043 0
QMON Coordinator 330,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 NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 264 0 0 0 1

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 575,713 1,071,632 1157654 1157654


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /oracle/app/oracle/admin/xlcmp/adump   
background_dump_dest /oracle/app/oracle/admin/xlcmp/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.5.0   
control_files +ORADISK/xlcmp/controlfile/current.260.762368151   
core_dump_dest /oracle/app/oracle/admin/xlcmp/cdump   
cursor_sharing SIMILAR   
db_block_size 8192   
db_create_file_dest +ORADISK   
db_domain      
db_file_multiblock_read_count 16   
db_name xlcmp   
dispatchers (PROTOCOL=TCP) (SERVICE=xlcmpXDB)   
instance_number 2   
job_queue_processes 10   
local_listener (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.39)(PORT=1521))   
log_archive_dest_1 LOCATION=+ORADISK/arch   
log_archive_format %t_%s_%r.dbf   
open_cursors 800   
pga_aggregate_target 2000000000   
processes 500   
recyclebin OFF   
remote_listener (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.29)(PORT=1521))   
remote_login_passwordfile EXCLUSIVE   
sessions 555   
sga_max_size 10015997952   
sga_target 10015997952   
spfile +ORADISK/xlcmp/spfilexlcmp.ora   
thread 2   
undo_management AUTO   
undo_tablespace UNDOTBS2   
user_dump_dest /oracle/app/oracle/admin/xlcmp/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 17,286 0.96 13.52
acks for commit broadcast(logical) 17,877 0.99 13.98
broadcast msgs on commit(actual) 2,550 0.14 1.99
broadcast msgs on commit(logical) 2,555 0.14 2.00
broadcast msgs on commit(wasted) 155 0.01 0.12
broadcast on commit wait time(ms) 8,904 0.49 6.96
broadcast on commit waits 1,447 0.08 1.13
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 134,758 7.47 105.36
gcs ast xid 0 0.00 0.00
gcs blocked converts 61,743 3.42 48.27
gcs blocked cr converts 183,697 10.19 143.63
gcs compatible basts 23 0.00 0.02
gcs compatible cr basts (global) 29,468 1.63 23.04
gcs compatible cr basts (local) 147,995 8.21 115.71
gcs cr basts to PIs 0 0.00 0.00
gcs cr serve without current lock 0 0.00 0.00
gcs dbwr flush pi msgs 634 0.04 0.50
gcs dbwr write request msgs 451 0.03 0.35
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 4,985 0.28 3.90
gcs immediate (null) converts 40,972 2.27 32.03
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 140,676 7.80 109.99
gcs indirect ast 164,765 9.14 128.82
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 37,170 2.06 29.06
gcs msgs process time(ms) 14,905 0.83 11.65
gcs msgs received 842,050 46.70 658.37
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 0 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 1 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 1 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 6,493 0.36 5.08
gcs side channel msgs logical 440,878 24.45 344.71
gcs stale cr 447 0.02 0.35
gcs undo cr 1 0.00 0.00
gcs write notification msgs 99 0.01 0.08
gcs writes refused 5 0.00 0.00
ges msgs process time(ms) 1,095 0.06 0.86
ges msgs received 102,656 5.69 80.26
global posts dropped 0 0.00 0.00
global posts queue time 64 0.00 0.05
global posts queued 370 0.02 0.29
global posts requested 370 0.02 0.29
global posts sent 370 0.02 0.29
implicit batch messages received 55,643 3.09 43.51
implicit batch messages sent 20,210 1.12 15.80
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 20,317 1.13 15.89
messages queue sent actual 146,620 8.13 114.64
messages queue sent logical 253,767 14.08 198.41
messages received actual 511,927 28.39 400.26
messages received logical 944,704 52.40 738.63
messages sent directly 270,507 15.00 211.50
messages sent indirectly 204,172 11.32 159.63
messages sent not implicit batched 126,411 7.01 98.84
messages sent pbatched 457,670 25.39 357.83
msgs causing lmd to send msgs 37,399 2.07 29.24
msgs causing lms(s) to send msgs 92,590 5.14 72.39
msgs received queue time (ms) 22,587 1.25 17.66
msgs received queued 944,701 52.40 738.62
msgs sent queue time (ms) 1,578,333 87.54 1,234.04
msgs sent queue time on ksxp (ms) 155,860 8.64 121.86
msgs sent queued 249,499 13.84 195.07
msgs sent queued on ksxp 529,690 29.38 414.14
number of ges deadlock detected 0 0.00 0.00
process batch messages received 101,306 5.62 79.21
process batch messages sent 265,755 14.74 207.78


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 2,754
CURRENT Block Requests 244
Data Block Requests 2,754
Undo Block Requests 1
TX Block Requests 63
Current Results 2,998
Private results 0
Zero Results 0
Disk Read Results 0
Fail Results 0
Fairness Down Converts 494
Fairness Clears 0
Free GC Elements 0
Flushes 7
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 27
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 154,381 100.00 0.00 0.00 0.00 0.00
Flushes 13 84.62 15.38 0.00 0.00 0.00
Writes 744 61.29 37.23 1.48 0.00 0.00


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 351,009 99.88 0.02 0.10 86,286 99.98 0.02 0.00
1 Others 181 98.90 1.10 0.00 188 99.47 0.53 0.00
1 undo header 27 77.78 22.22 0.00 25 84.00 16.00 0.00


Back to Top

End of Report