WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
RACSTAGE3867507123racstage1110.2.0.3.0YESdcr7e1b3

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:76309-Jan-08 18:00:5248 2.7
End Snap:76809-Jan-08 23:00:5572 2.1
Elapsed:  300.05 (mins)  
DB Time:  300.42 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 3,984M 3,936MStd Block Size: 8K
Shared Pool Size: 464M 512MLog Buffer: 14,348K

Load Profile

Per SecondPer Transaction
Redo size: 24,281.02 12,642.06
Logical reads: 440.80 229.50
Block changes: 140.54 73.17
Physical reads: 0.95 0.49
Physical writes: 3.15 1.64
User calls: 109.45 56.98
Parses: 47.77 24.87
Hard parses: 0.16 0.08
Sorts: 14.43 7.51
Logons: 0.08 0.04
Executes: 55.86 29.09
Transactions: 1.92 

% Blocks changed per Read: 31.88Recursive Call %: 42.13
Rollback per transaction %: 53.06Rows per Sort: 53.75

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.71Redo NoWait %: 100.00
Buffer Hit %: 99.79In-memory Sort %: 100.00
Library Hit %: 98.88Soft Parse %: 99.66
Execute to Parse %: 14.49Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 78.68% Non-Parse CPU: 99.84

Shared Pool Statistics

BeginEnd
Memory Usage %: 80.72 80.53
% SQL with executions>1: 73.61 76.84
% Memory for SQL w/exec>1: 75.63 73.87

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  17,085  94.8 
gc buffer busy 23,484 237 10 1.3Cluster
gc current block busy 16,148 213 13 1.2Cluster
Streams AQ: qmn coordinator waiting for slave to start 17 96 5,661 .5Other
gc cr block busy 29,944 80 3 .4Cluster

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 17.44 9.08
Global Cache blocks served: 15.49 8.06
GCS/GES messages received: 32.49 16.92
GCS/GES messages sent: 35.18 18.31
DBWR Fusion writes: 0.36 0.19
Estd Interconnect traffic (KB) 276.65 

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

Buffer access - local cache %: 95.83
Buffer access - remote cache %: 3.96
Buffer access - disk %: 0.21

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.2
Avg global cache cr block receive time (ms): 0.9
Avg global cache current block receive time (ms): 2.2
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 %: 15.7
Avg global cache cr block flush time (ms): 1.1
Avg global cache current block pin time (ms): 8,380.9
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 10.6
Avg global cache current block flush time (ms): 81.6

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 2,193.8
Avg message sent queue time on ksxp (ms): 0.2
Avg message received queue time (ms): 0.2
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 67.20
% of indirect sent messages: 17.16
% of flow controlled messages: 15.63

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 17,935.96 99.51
DB CPU 17,085.48 94.79
PL/SQL execution elapsed time 165.00 0.92
parse time elapsed 51.86 0.29
hard parse elapsed time 23.67 0.13
connection management call elapsed time 1.51 0.01
hard parse (sharing criteria) elapsed time 1.34 0.01
PL/SQL compilation elapsed time 0.59 0.00
repeated bind elapsed time 0.43 0.00
sequence load elapsed time 0.13 0.00
hard parse (bind mismatch) elapsed time 0.04 0.00
failed parse elapsed time 0.01 0.00
DB time 18,025.02  
background elapsed time 452.30  
background cpu time 211.73  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Cluster 359,964 0.06 691 2 10.41
Other 724,521 76.32 341 0 20.95
User I/O 13,281 0.00 39 3 0.38
System I/O 135,624 0.00 35 0 3.92
Concurrency 26,340 0.95 30 1 0.76
Commit 16,504 0.00 12 1 0.48
Network 1,178,278 0.00 2 0 34.08
Configuration 1,854 48.17 1 0 0.05
Application 3,688 0.00 0 0 0.11

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
gc buffer busy 23,484 0.84 237 10 0.68
gc current block busy 16,148 0.00 213 13 0.47
Streams AQ: qmn coordinator waiting for slave to start 17 100.00 96 5661 0.00
gc cr block busy 29,944 0.00 80 3 0.87
cr request retry 90 90.00 74 825 0.00
reliable message 3,387 1.51 62 18 0.10
gc cr block 2-way 139,033 0.00 49 0 4.02
gc current block 2-way 101,645 0.00 39 0 2.94
db file sequential read 12,695 0.00 38 3 0.37
gcs log flush sync 65,298 8.96 36 1 1.89
gc recovery quiesce 73 41.10 32 434 0.00
DFS lock handle 5,471 0.84 31 6 0.16
gc current grant busy 16,117 0.00 27 2 0.47
wait for scn ack 53,286 0.00 15 0 1.54
control file sequential read 53,370 0.00 12 0 1.54
log file sync 16,504 0.00 12 1 0.48
enq: TX - index contention 815 0.37 12 14 0.02
log file parallel write 61,628 0.00 10 0 1.78
gc cr multi block request 25,989 0.00 10 0 0.75
log file sequential read 404 0.00 7 17 0.01
row cache lock 15,409 0.00 6 0 0.45
enq: US - contention 9,782 0.00 5 1 0.28
enq: WF - contention 34 14.71 4 109 0.00
PX Deq: Signal ACK 2,265 34.57 3 1 0.07
db file parallel write 12,347 0.00 3 0 0.36
cursor: pin S wait on X 293 83.28 3 10 0.01
control file parallel write 6,915 0.00 3 0 0.20
CGS wait for IPC msg 247,348 99.86 3 0 7.15
SQL*Net message to client 1,170,377 0.00 2 0 33.85
library cache pin 2,309 0.00 2 1 0.07
buffer busy waits 807 0.25 2 2 0.02
buffer deadlock 2,554 98.98 2 1 0.07
db file scattered read 388 0.00 2 5 0.01
gc cr disk read 4,983 0.00 2 0 0.14
PX qref latch 224,246 99.99 2 0 6.49
os thread startup 39 0.00 1 38 0.00
library cache lock 2,900 0.00 1 0 0.08
name-service call wait 20 0.00 1 58 0.00
gc current retry 41 0.00 1 28 0.00
enq: PS - contention 1,772 0.00 1 1 0.05
PX Deq: reap credit 44,126 92.07 1 0 1.28
latch free 551 0.00 1 2 0.02
latch: shared pool 2,109 0.00 1 0 0.06
PX Deq Credit: send blkd 4,855 49.17 1 0 0.14
kjbdrmcvtq lmon drm quiesce: ping completion 35 17.14 1 20 0.00
ksxr poll remote instances 53,364 54.39 1 0 1.54
latch: cache buffers chains 1,451 0.00 1 0 0.04
enq: HW - contention 935 0.00 1 1 0.03
rdbms ipc reply 1,962 0.00 1 0 0.06
gc current split 60 0.00 0 8 0.00
latch: library cache 84 0.00 0 5 0.00
ges global resource directory to be frozen 35 100.00 0 12 0.00
gc current grant 2-way 1,443 0.00 0 0 0.04
enq: CF - contention 626 0.00 0 1 0.02
enq: FB - contention 506 0.00 0 0 0.01
gc current multi block request 516 0.00 0 0 0.01
SQL*Net break/reset to client 3,591 0.00 0 0 0.10
latch: library cache lock 51 0.00 0 4 0.00
gcs drm freeze in enter server mode 7 0.00 0 26 0.00
log file switch completion 17 0.00 0 11 0.00
Log archive I/O 952 0.00 0 0 0.03
SQL*Net more data from client 6,552 0.00 0 0 0.19
IPC send completion sync 289 98.96 0 0 0.01
gc cr grant 2-way 398 0.00 0 0 0.01
latch: ges resource hash list 862 0.00 0 0 0.02
enq: TX - contention 27 0.00 0 2 0.00
cursor: pin S 23 0.00 0 3 0.00
LGWR wait for redo copy 466 0.00 0 0 0.01
global enqueue expand wait 7 71.43 0 7 0.00
enq: SR - contention 108 0.00 0 0 0.00
latch: enqueue hash chains 34 0.00 0 1 0.00
enq: TT - contention 141 0.00 0 0 0.00
kksfbc child completion 1 100.00 0 48 0.00
direct path read temp 15 0.00 0 3 0.00
latch: object queue header operation 111 0.00 0 0 0.00
direct path write temp 52 0.00 0 1 0.00
gc cr failure 90 0.00 0 0 0.00
enq: TD - KTF dump entries 36 0.00 0 1 0.00
direct path read 67 0.00 0 0 0.00
enq: TM - contention 86 0.00 0 0 0.00
library cache load lock 3 0.00 0 9 0.00
latch: cache buffers lru chain 64 0.00 0 0 0.00
enq: TA - contention 43 0.00 0 0 0.00
enq: JQ - contention 36 0.00 0 1 0.00
latch: row cache objects 70 0.00 0 0 0.00
latch: KCL gc element parent latch 278 0.00 0 0 0.01
SQL*Net more data to client 852 0.00 0 0 0.02
db file parallel read 3 0.00 0 5 0.00
latch: redo allocation 106 0.00 0 0 0.00
enq: TQ - TM contention 25 0.00 0 0 0.00
enq: TO - contention 26 0.00 0 0 0.00
latch: undo global data 22 0.00 0 0 0.00
undo segment extension 895 99.78 0 0 0.03
latch: gcs resource hash 87 0.00 0 0 0.00
enq: JS - job run lock - synchronize 8 0.00 0 1 0.00
enq: PI - contention 4 0.00 0 2 0.00
enq: DR - contention 11 0.00 0 1 0.00
read by other session 13 0.00 0 0 0.00
enq: JS - queue lock 1 0.00 0 4 0.00
enq: MD - contention 13 0.00 0 0 0.00
enq: AF - task serialization 4 0.00 0 1 0.00
enq: TX - allocate ITL entry 5 0.00 0 0 0.00
enq: PW - flush prewarm buffers 6 0.00 0 0 0.00
direct path write 48 0.00 0 0 0.00
enq: PE - contention 3 0.00 0 1 0.00
enq: SK - contention 4 0.00 0 0 0.00
enq: UL - contention 5 0.00 0 0 0.00
SQL*Net message to dblink 497 0.00 0 0 0.01
log file single write 8 0.00 0 0 0.00
lock escalate retry 3 100.00 0 0 0.00
latch: messages 10 0.00 0 0 0.00
lock deadlock retry 4 100.00 0 0 0.00
enq: PG - contention 3 0.00 0 0 0.00
KJC: Wait for msg sends to complete 12 0.00 0 0 0.00
enq: WL - contention 1 0.00 0 1 0.00
latch: session allocation 4 0.00 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 4 0.00 0 0 0.00
enq: JS - wdw op 1 0.00 0 0 0.00
latch: redo writing 2 0.00 0 0 0.00
latch: checkpoint queue latch 2 0.00 0 0 0.00
SQL*Net message from client 1,170,351 0.00 421,365 360 33.85
jobq slave wait 21,780 49.45 52,956 2431 0.63
Streams AQ: qmn slave idle wait 7,593 0.22 37,193 4898 0.22
PX Idle Wait 15,428 93.25 36,261 2350 0.45
Streams AQ: waiting for messages in the queue 5,515 97.14 35,127 6369 0.16
gcs remote message 1,526,327 96.26 35,039 23 44.14
DIAG idle wait 89,348 0.00 17,576 197 2.58
ASM background timer 3,635 0.00 17,576 4835 0.11
ges remote message 290,040 93.30 17,570 61 8.39
Streams AQ: delete acknowledged messages 3,582 100.00 17,569 4905 0.10
class slave wait 196 74.49 17,537 89474 0.01
virtual circuit status 597 100.00 17,530 29364 0.02
Streams AQ: qmn coordinator idle wait 7,961 46.25 17,471 2195 0.23
Streams AQ: waiting for time management or cleanup tasks 178 41.57 17,277 97061 0.01
wait for unread message on broadcast channel 17,638 99.43 17,254 978 0.51
PX Deq: Execution Msg 3,947 6.44 156 40 0.11
single-task message 71 0.00 6 78 0.00
KSV master wait 32 3.13 3 104 0.00
PX Deq: Execute Reply 1,841 23.19 3 2 0.05
PX Deq: Join ACK 2,078 39.75 1 1 0.06
SQL*Net message from dblink 497 0.00 1 3 0.01
PX Deq: Parse Reply 1,889 37.27 1 1 0.05
PL/SQL lock timer 1 100.00 1 975 0.00
PX Deq: Msg Fragment 2,803 4.28 1 0 0.08
Streams AQ: RAC qmn coordinator idle wait 8,145 99.83 0 0 0.24
SGA: MMAN sleep for component shrink 6 66.67 0 8 0.00
PX Deq Credit: need buffer 8 37.50 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 437,821 64.84 216 0 12.66
log file parallel write 61,628 0.00 10 0 1.78
control file sequential read 40,040 0.00 10 0 1.16
log file sequential read 404 0.00 7 17 0.01
db file parallel write 12,347 0.00 3 0 0.36
control file parallel write 6,915 0.00 3 0 0.20
os thread startup 35 0.00 1 32 0.00
row cache lock 674 0.00 0 1 0.02
gc cr block 2-way 489 0.00 0 0 0.01
Log archive I/O 952 0.00 0 0 0.03
gc current block 2-way 414 0.00 0 0 0.01
library cache lock 180 0.00 0 0 0.01
latch: cache buffers chains 434 0.00 0 0 0.01
gc cr block busy 2 0.00 0 32 0.00
gc current grant busy 131 0.00 0 0 0.00
gc cr multi block request 224 0.00 0 0 0.01
enq: TM - contention 25 0.00 0 0 0.00
buffer busy waits 111 1.80 0 0 0.00
db file sequential read 1 0.00 0 7 0.00
undo segment extension 514 100.00 0 0 0.01
latch: row cache objects 38 0.00 0 0 0.00
library cache pin 4 0.00 0 0 0.00
log file sync 2 0.00 0 1 0.00
log file single write 8 0.00 0 0 0.00
latch: redo writing 2 0.00 0 0 0.00
gc current grant 2-way 1 0.00 0 0 0.00
direct path write 23 0.00 0 0 0.00
direct path read 22 0.00 0 0 0.00
latch: shared pool 46 0.00 -0 -0 0.00
rdbms ipc message 381,980 67.40 244,579 640 11.05
gcs remote message 1,526,341 96.26 35,039 23 44.14
DIAG idle wait 89,348 0.00 17,576 197 2.58
ASM background timer 3,635 0.00 17,576 4835 0.11
pmon timer 6,237 99.98 17,572 2817 0.18
ges remote message 290,046 93.30 17,570 61 8.39
Streams AQ: delete acknowledged messages 3,582 100.00 17,569 4905 0.10
Streams AQ: qmn coordinator idle wait 7,961 46.25 17,471 2195 0.23
Streams AQ: waiting for time management or cleanup tasks 178 41.57 17,277 97061 0.01
smon timer 110 4.55 17,100 155458 0.00
KSV master wait 32 3.13 3 104 0.00
PX Deq: Join ACK 141 41.84 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 8,145 99.83 0 0 0.24
SGA: MMAN sleep for component shrink 6 66.67 0 8 0.00
PX Deq: Parse Reply 139 42.45 0 0 0.00
PX Deq: Execute Reply 129 34.11 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 2,245,751
IDLE_TIME 4,917,394
IOWAIT_TIME 23,898
NICE_TIME 95
SYS_TIME 236,099
USER_TIME 2,004,243
LOAD 1
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 431,536
NUM_CPUS 4
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 17,022.00 16,704.80 16,605 2,156,567
nyco 998.70 377.00 299 5,260,595
racstage 4.20 3.50 76 75,883
ATG_STREAMS_ADM.CAPT_NUTRP_QUEUE 0.00 0.00 0 0
ATG_STREAMS_ADM.CAPT_NUTR_QUEUE 0.00 0.00 0 0
ATG_STREAMS_ADM.CAPT_PNUTR_QUEUE 0.00 0.00 0 0
SYS$BACKGROUND 0.00 0.00 105 439,034
SYS.CAPT_NUTRP_QUEUE 0.00 0.00 0 0
SYS.KUPC$C_1_20080104173601 0.00 0.00 0 0
SYS.KUPC$S_1_20080104173601 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
SYS$USERS 12689 3793 15151 751 0 0 39053 14
nyco 312 109 6412 1922 0 0 1129511 220
racstage 72 26 1871 58 0 0 7993 2
SYS$BACKGROUND 208 18 2892 240 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
16,579 16,485 2 8289.45 91.98 3h7fatfmwuwnp emagent@dcr7e1b3 (TNS V1-V3) /* OracleOEM */ declare T...
9,445 9,443 2 4722.50 52.40 2u77msbt0sb25 emagent@dcr7e1b3 (TNS V1-V3) SELECT NVL(COUNT(MSG_STATE), 0...
7,134 7,042 2 3566.94 39.58 68wcvyvpdy74j emagent@dcr7e1b3 (TNS V1-V3) SELECT NVL(COUNT(MSG_STATE), 0...
86 11 25,425 0.00 0.48 298mw906pgpg4   INSERT INTO dcspp_amount_info(...
83 83 1 83.02 0.46 4xx30f7tam1da sqlplus@dcr7e1b3 (TNS V1-V3) select s.USERNAME, ...
82 35 1 82.20 0.46 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
77 12 28,505 0.00 0.43 f4760tx2hyp0j   INSERT INTO dcspp_amtinfo_adj(...
49 5 1 48.69 0.27 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
42 2 34 1.24 0.23 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
36 4 1 36.27 0.20 2x8b8b45yfqzt sqlplus@dcr7e1b3 (TNS V1-V3) select FILE_NAME, ...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
16,485 16,579 2 8242.46 91.98 3h7fatfmwuwnp emagent@dcr7e1b3 (TNS V1-V3) /* OracleOEM */ declare T...
9,443 9,445 2 4721.53 52.40 2u77msbt0sb25 emagent@dcr7e1b3 (TNS V1-V3) SELECT NVL(COUNT(MSG_STATE), 0...
7,042 7,134 2 3520.92 39.58 68wcvyvpdy74j emagent@dcr7e1b3 (TNS V1-V3) SELECT NVL(COUNT(MSG_STATE), 0...
83 83 1 82.99 0.46 4xx30f7tam1da sqlplus@dcr7e1b3 (TNS V1-V3) select s.USERNAME, ...
35 82 1 34.80 0.46 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
15 28 23,702 0.00 0.16 g95a6c61jsuv8   DELETE FROM dcspp_amtinfo_adj ...
13 26 19,467 0.00 0.14 cnvu1tn3uf7ux   DELETE FROM dcspp_shipitem_sub...
12 18 19,467 0.00 0.10 b961m68nwgk0t   DELETE FROM dcspp_taxshipitem ...
12 17 19,467 0.00 0.09 31yp6g9ht89g3   DELETE FROM dcspp_ntaxshipitem...
12 77 28,505 0.00 0.43 f4760tx2hyp0j   INSERT INTO dcspp_amtinfo_adj(...

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
792,482 1 792,482.00 9.99 34.80 82.20 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
344,720 2 172,360.00 4.34 1.00 1.00 0ps9sruch2xx8 sqlplus@dcr7e1b3 (TNS V1-V3) select OWNER, DATA...
285,754 28,505 10.02 3.60 11.72 76.90 f4760tx2hyp0j   INSERT INTO dcspp_amtinfo_adj(...
260,864 2 130,432.00 3.29 16484.91 16578.90 3h7fatfmwuwnp emagent@dcr7e1b3 (TNS V1-V3) /* OracleOEM */ declare T...
229,576 23,702 9.69 2.89 14.89 28.31 g95a6c61jsuv8   DELETE FROM dcspp_amtinfo_adj ...
219,503 1 219,503.00 2.77 4.93 48.69 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
168,170 25,425 6.61 2.12 11.45 86.43 298mw906pgpg4   INSERT INTO dcspp_amount_info(...
163,412 21,686 7.54 2.06 9.68 30.79 4xrxgw4j40q6x   SELECT sequence_num, adjustmen...
162,886 25,425 6.41 2.05 8.03 26.16 bkc0t4k34k0xx   INSERT INTO dcspp_price_adjust...
137,107 32,355 4.24 1.73 6.42 18.74 gtbbrmz2rw8m5   UPDATE dcspp_amount_info S...
136,639 22,547 6.06 1.72 6.88 19.78 bwuu1md5yvb2w   DELETE FROM dcspp_amount_info ...
130,414 2 65,207.00 1.64 9443.06 9445.01 2u77msbt0sb25 emagent@dcr7e1b3 (TNS V1-V3) SELECT NVL(COUNT(MSG_STATE), 0...
130,414 2 65,207.00 1.64 7041.85 7133.88 68wcvyvpdy74j emagent@dcr7e1b3 (TNS V1-V3) SELECT NVL(COUNT(MSG_STATE), 0...
123,864 29,660 4.18 1.56 4.68 34.59 9g54f9u1tm2yh   UPDATE dcspp_price_adjust ...
113,583 19,467 5.83 1.43 13.41 25.90 cnvu1tn3uf7ux   DELETE FROM dcspp_shipitem_sub...
112,588 19,467 5.78 1.42 12.42 17.72 b961m68nwgk0t   DELETE FROM dcspp_taxshipitem ...
111,828 19,467 5.74 1.41 12.30 16.91 31yp6g9ht89g3   DELETE FROM dcspp_ntaxshipitem...
111,530 1 111,530.00 1.41 4.28 36.27 2x8b8b45yfqzt sqlplus@dcr7e1b3 (TNS V1-V3) select FILE_NAME, ...
106,619 9,956 10.71 1.34 9.56 17.45 7x86bfu27vdsm   INSERT INTO dcspp_ord_abandon(...
102,900 100 1,029.00 1.30 1.02 1.04 fyrbzparfb4gb DBMS_SCHEDULER SELECT OWNER, SEGMENT_NAME, ...
99,596 1 99,596.00 1.26 0.72 0.76 809f7pzn1gs22 sqlplus@dcr7e1b3 (TNS V1-V3) select acc.OWNER, ...
90,389 1 90,389.00 1.14 0.20 0.20 1sdncrnq37hjm emagent@dcr7e1b3 (TNS V1-V3) /* OracleOEM */ SELECT /*+ IN...
89,137 34 2,621.68 1.12 2.04 42.28 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
88,757 10,272 8.64 1.12 3.67 20.32 6ktnc6kzb8p7v   INSERT INTO dcspp_order_price(...
86,569 2,953 29.32 1.09 3.78 4.17 6dj8a273d7t3r   UPDATE cbp_order SET oms_o...
82,347 9,245 8.91 1.04 3.71 15.98 fs0t33k408zw4   INSERT INTO dcspp_tax_price(am...
80,204 9,245 8.68 1.01 3.24 15.28 1zxbp7bhad0jb   INSERT INTO cbp_tax_price(amou...

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
9,933 1 9,933.00 58.14 4.28 36.27 2x8b8b45yfqzt sqlplus@dcr7e1b3 (TNS V1-V3) select FILE_NAME, ...
3,674 1 3,674.00 21.50 4.93 48.69 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
3,662 34 107.71 21.43 2.04 42.28 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
2,925 1 2,925.00 17.12 34.80 82.20 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
54 5 10.80 0.32 0.13 0.15 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
15 1 15.00 0.09 0.82 0.91 f97szfrxt9pyh sqlplus@dcr7e1b3 (TNS V1-V3) select blevel as "Index Blevel...
13 1 13.00 0.08 1.50 1.55 4mnzkdak7jbkt DBMS_SCHEDULER select /*+ no_parallel(t) no_p...
12 2,568 0.00 0.07 2.72 12.83 a9yjmbgy5bx9c   INSERT INTO dcspp_shipitem_rel...
12 5 2.40 0.07 7.32 7.49 djs2w2f17nw2z   DECLARE job BINARY_INTEGER := ...
11 1,252 0.01 0.06 1.47 1.77 25uamm5j57cj9   INSERT INTO dcspp_item(commerc...

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
46,289 46,289 1.00 0.00 0.00 aqk3cnr7nwrda   INSERT INTO dss_dps_view_item ...
32,355 32,355 1.00 0.00 0.00 gtbbrmz2rw8m5   UPDATE dcspp_amount_info S...
29,660 29,660 1.00 0.00 0.00 9g54f9u1tm2yh   UPDATE dcspp_price_adjust ...
28,505 28,505 1.00 0.00 0.00 f4760tx2hyp0j   INSERT INTO dcspp_amtinfo_adj(...
25,425 25,425 1.00 0.00 0.00 298mw906pgpg4   INSERT INTO dcspp_amount_info(...
25,425 25,425 1.00 0.00 0.00 bkc0t4k34k0xx   INSERT INTO dcspp_price_adjust...
23,702 4,235 0.18 0.00 0.00 g95a6c61jsuv8   DELETE FROM dcspp_amtinfo_adj ...
22,547 3,080 0.14 0.00 0.00 bwuu1md5yvb2w   DELETE FROM dcspp_amount_info ...
21,686 8,140 0.38 0.00 0.00 4xrxgw4j40q6x   SELECT sequence_num, adjustmen...
19,467 0 0.00 0.00 0.00 27j2x027fvfc6   DELETE FROM dcspp_order_price ...
19,467 0 0.00 0.00 0.00 31yp6g9ht89g3   DELETE FROM dcspp_ntaxshipitem...
19,467 0 0.00 0.00 0.00 b961m68nwgk0t   DELETE FROM dcspp_taxshipitem ...
19,467 0 0.00 0.00 0.00 cnvu1tn3uf7ux   DELETE FROM dcspp_shipitem_sub...
14,380 14,380 1.00 0.00 0.00 gk165qzg6vpfm   UPDATE dcspp_order_price S...
11,959 11,949 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
11,869 11,869 1.00 0.00 0.00 0qmbftn4pga1g   UPDATE dcspp_ord_abandon S...
10,785 10,015 0.93 0.00 0.00 6abjvp0nd0m01   UPDATE dcspp_tax_price SET...
10,785 10,015 0.93 0.00 0.00 a8tuhu1k9xkb1   UPDATE cbp_tax_price SET d...
10,272 10,272 1.00 0.00 0.00 6ktnc6kzb8p7v   INSERT INTO dcspp_order_price(...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
32,355 32,355 3.76 gtbbrmz2rw8m5   UPDATE dcspp_amount_info S...
29,660 29,660 3.45 9g54f9u1tm2yh   UPDATE dcspp_price_adjust ...
25,425 25,425 2.96 298mw906pgpg4   INSERT INTO dcspp_amount_info(...
25,425 25,425 2.96 bkc0t4k34k0xx   INSERT INTO dcspp_price_adjust...
23,702 23,702 2.76 g95a6c61jsuv8   DELETE FROM dcspp_amtinfo_adj ...
22,547 22,547 2.62 bwuu1md5yvb2w   DELETE FROM dcspp_amount_info ...
22,085 28,505 2.57 f4760tx2hyp0j   INSERT INTO dcspp_amtinfo_adj(...
21,686 21,686 2.52 4xrxgw4j40q6x   SELECT sequence_num, adjustmen...
19,467 19,467 2.26 27j2x027fvfc6   DELETE FROM dcspp_order_price ...
19,467 19,467 2.26 31yp6g9ht89g3   DELETE FROM dcspp_ntaxshipitem...
19,467 19,467 2.26 b961m68nwgk0t   DELETE FROM dcspp_taxshipitem ...
19,467 19,467 2.26 cnvu1tn3uf7ux   DELETE FROM dcspp_shipitem_sub...
14,380 14,380 1.67 gk165qzg6vpfm   UPDATE dcspp_order_price S...
11,959 11,959 1.39 2ym6hhaq30r73   select type#, blocks, extents,...
11,869 11,869 1.38 0qmbftn4pga1g   UPDATE dcspp_ord_abandon S...
10,785 10,785 1.25 6abjvp0nd0m01   UPDATE dcspp_tax_price SET...
10,785 10,785 1.25 a8tuhu1k9xkb1   UPDATE cbp_tax_price SET d...
10,272 10,272 1.19 6ktnc6kzb8p7v   INSERT INTO dcspp_order_price(...
9,956 9,956 1.16 7x86bfu27vdsm   INSERT INTO dcspp_ord_abandon(...
9,885 9,885 1.15 4xpkxs0jddqjm   UPDATE dcspp_amount_info S...
9,484 9,484 1.10 ayv7vjb7ngnjg   SELECT t1.amount_info_id, t1.v...
9,301 9,301 1.08 cwpgpfkbsdzcc   UPDATE dcspp_ord_abandon S...
9,301 9,301 1.08 gkcatdfgt8d3n   SELECT order_id, ord_last_upda...
9,245 9,245 1.08 1zxbp7bhad0jb   INSERT INTO cbp_tax_price(amou...
9,245 9,245 1.08 fs0t33k408zw4   INSERT INTO dcspp_tax_price(am...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

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
73.01 84.48 86.43 11.45 25,425 298mw906pgpg4   INSERT INTO dcspp_amount_info(...
66.06 85.90 76.90 11.72 28,505 f4760tx2hyp0j   INSERT INTO dcspp_amtinfo_adj(...
36.13 74.19 48.69 4.93 1 6mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
35.78 84.63 42.28 2.04 34 8szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
25.73 83.57 30.79 9.68 21,686 4xrxgw4j40q6x   SELECT sequence_num, adjustmen...
20.05 70.83 28.31 14.89 23,702 g95a6c61jsuv8   DELETE FROM dcspp_amtinfo_adj ...
19.69 75.26 26.16 8.03 25,425 bkc0t4k34k0xx   INSERT INTO dcspp_price_adjust...
19.23 74.25 25.90 13.41 19,467 cnvu1tn3uf7ux   DELETE FROM dcspp_shipitem_sub...
17.21 84.68 20.32 3.67 10,272 6ktnc6kzb8p7v   INSERT INTO dcspp_order_price(...
15.15 85.73 17.67 3.96 2,568 6w0sjchwkq643   INSERT INTO dcspp_order(order_...
13.26 74.82 17.72 12.42 19,467 b961m68nwgk0t   DELETE FROM dcspp_taxshipitem ...
13.06 81.73 15.98 3.71 9,245 fs0t33k408zw4   INSERT INTO dcspp_tax_price(am...
12.79 64.69 19.78 6.88 22,547 bwuu1md5yvb2w   DELETE FROM dcspp_amount_info ...
12.72 83.29 15.28 3.24 9,245 1zxbp7bhad0jb   INSERT INTO cbp_tax_price(amou...
12.49 73.87 16.91 12.30 19,467 31yp6g9ht89g3   DELETE FROM dcspp_ntaxshipitem...
12.10 89.81 13.47 1.91 56 22br1212sy71m   SELECT t1.amount_info_id, t1.v...
11.69 90.63 12.90 1.94 2,568 9025xptwsgst1   INSERT INTO dcspp_ntaxshipitem...
11.01 85.83 12.83 2.72 2,568 a9yjmbgy5bx9c   INSERT INTO dcspp_shipitem_rel...
10.34 84.86 12.18 2.60 5,906 8tt8b9djvbr68   INSERT INTO dcspp_order_rel(or...
10.22 88.13 11.60 2.04 2,953 2u8mkmfpr8n09   INSERT INTO dcspp_order_item(o...
9.33 11.35 82.20 34.80 1 b6usrg82hwsa3 DBMS_SCHEDULER call dbms_stats.gather_databas...
8.59 78.65 10.92 5.37 3,338 ff0tgfzw6c4kz   DELETE FROM dcspp_auth_status ...
8.53 48.90 17.45 9.56 9,956 7x86bfu27vdsm   INSERT INTO dcspp_ord_abandon(...
7.91 88.16 8.97 1.77 1,740 ffbrku49b1r95   INSERT INTO dcspp_payorder_rel...
7.54 89.30 8.45 1.26 1,740 2f2zht0jfs1ut   INSERT INTO dcspp_taxshipitem(...
7.42 89.11 8.32 1.24 1,740 a5v1z2zhm6cdg   INSERT INTO dcspp_shipitem_tax...
7.12 88.82 8.02 1.32 1,740 brbvfrck5zpvz   INSERT INTO dcspp_shipitem_sub...
6.61 74.88 8.83 3.46 5,521 2gxjq59qr7gqd   INSERT INTO dcspp_auth_status(...
6.31 85.47 7.39 0.68 1,317 fwutywyf7nd5p   INSERT INTO dcspp_amount_info(...
5.33 86.44 6.17 1.34 9,484 ayv7vjb7ngnjg   SELECT t1.amount_info_id, t1.v...
4.39 56.98 7.70 4.55 19,467 27j2x027fvfc6   DELETE FROM dcspp_order_price ...
4.34 23.17 18.74 6.42 32,355 gtbbrmz2rw8m5   UPDATE dcspp_amount_info S...
4.32 75.29 5.74 1.58 3,480 6h4gy0ym4fsd6   INSERT INTO dcspp_relationship...
3.78 86.72 4.36 0.79 1,251 61sk18vc0ajav   INSERT INTO dcspp_itmprice_det...
3.43 85.10 4.03 0.95 1,252 957zsnv3dtz2v   INSERT INTO dcspp_order_pg(ord...
3.23 27.57 11.72 4.54 11,869 0qmbftn4pga1g   UPDATE dcspp_ord_abandon S...
2.85 88.72 3.21 0.46 488 0s1d68aavuh17   INSERT INTO dcspp_order_sg(ord...
2.74 85.71 3.20 0.64 1,252 4xj3y410vtm24   INSERT INTO dcspp_cc_status(st...
2.73 63.81 4.28 2.14 9,885 4xpkxs0jddqjm   UPDATE dcspp_amount_info S...
2.70 7.44 36.27 4.28 1 2x8b8b45yfqzt sqlplus@dcr7e1b3 (TNS V1-V3) select FILE_NAME, ...
1.89 45.31 4.17 3.78 2,953 6dj8a273d7t3r   UPDATE cbp_order SET oms_o...
1.79 72.77 2.46 1.53 2,922 1fh1pm6ct91p3   SELECT shipping_group_id, ship...
1.79 88.27 2.03 0.34 2,502 dbd6jx4ac9kq0   SELECT type, version, currency...
1.17 3.37 34.59 4.68 29,660 9g54f9u1tm2yh   UPDATE dcspp_price_adjust ...
0.96 90.25 1.07 0.13 10 22fm0kf95w8j5   SELECT t1.order_id FROM dcs...
0.89 94.78 0.94 0.11 297 f9zmavumh3txr   SELECT sequence_num, payment_g...
0.88 11.35 7.79 2.75 9,301 cwpgpfkbsdzcc   UPDATE dcspp_ord_abandon S...
0.86 27.92 3.08 2.02 9,301 gkcatdfgt8d3n   SELECT order_id, ord_last_upda...
0.80 45.31 1.77 1.47 1,252 25uamm5j57cj9   INSERT INTO dcspp_item(commerc...
0.75 25.18 2.97 1.58 10,785 a8tuhu1k9xkb1   UPDATE cbp_tax_price SET d...
0.66 32.89 2.00 1.80 10,785 6abjvp0nd0m01   UPDATE dcspp_tax_price SET...
0.65 92.04 0.70 0.09 297 f9mpwjjnr8h90   SELECT sequence_num, relations...
0.61 76.47 0.79 0.21 6 25kqrdu78dkmd   SELECT t1.amount_info_id, t1.v...
0.57 6.32 9.08 2.05 14,380 gk165qzg6vpfm   UPDATE dcspp_order_price S...
0.57 88.60 0.65 0.07 513 98vbvhfyyb5cx   SELECT url FROM dcs_media_e...
0.56 78.80 0.72 0.18 28 3sq8w0cbaj6sb   SELECT t1.order_id, t1.version...
0.54 89.08 0.61 0.09 495 abbu4j41fgqp8   SELECT abandonment_id FROM ...
0.49 93.08 0.52 0.06 297 8gtb1amd3ag1z   SELECT t1.shipping_group_id, t...
0.49 93.22 0.52 0.07 297 b2rs85rd1ctg6   SELECT shipping_group_id, comm...
0.49 93.12 0.52 0.07 297 5jdhg3c8fz3cj   SELECT daytime_phone FROM n...
0.44 15.92 2.78 2.78 46,289 aqk3cnr7nwrda   INSERT INTO dss_dps_view_item ...
0.32 47.86 0.66 0.43 3,080 02zx66k9d06uc   DELETE FROM dcspp_price_adjust...
0.29 45.86 0.63 0.48 5,043 gthf71bt7fu0p   SELECT t1.adjustment_id, t1.ve...
0.28 85.24 0.33 0.07 594 23rhmg06mnkur   SELECT district_tax FROM cb...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
02zx66k9d06ucDELETE FROM dcspp_price_adjust WHERE adjustment_id = :1
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
0ps9sruch2xx8select OWNER, DATA_TYPE, COUNT(*) from all_tab_columns where OWNER not in ('SYS', 'SYSTEM') group by OWNER, DATA_TYPE
0qmbftn4pga1gUPDATE dcspp_ord_abandon SET version=:1, ord_last_updated=:2 WHERE abandonment_id=:3 AND version=:4
0s1d68aavuh17INSERT INTO dcspp_order_sg(order_id, sequence_num, shipping_groups) VALUES(:1, :2, :3)
1fh1pm6ct91p3SELECT shipping_group_id, ship_item_tax FROM dcspp_shipitem_tax WHERE amount_info_id=:1
1sdncrnq37hjm /* OracleOEM */ SELECT /*+ INDEX(ts) */ o.object_type, u.name, o.object_name, o.partition, o.lob_column, o.seg_type, ts.name, 4 FROM ( SELECT 1 "OBJECT_TYPE", o.owner# "USER_NAME#", o.name "OBJECT_NAME", ' ' "PARTITION", ' ' "LOB_COLUMN", 1 "SEG_TYPE", t.ts# "TABLESPACE#" FROM sys.obj$ o, sys.tab$ t, sys.seg$ s WHERE o.obj# = t.obj# AND t.ts# in (:1, :2) AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND decode (bitand (t.property, 1), 1, 1, 0) = 0 AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 AND decode (bitand (t.property, 1024), 1024, 1, 0) = 0 UNION ALL SELECT 2, o.owner#, o.name, ' ', ' ', 2, i.ts# FROM sys.obj$ o, sys.ind$ i, sys.seg$ s WHERE o.obj# = i.obj# AND i.ts# in (:1, :2) AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# not in (4, 8) UNION ALL SELECT 3, o.owner#, o.name, ' ', ' ', 12, c.ts# FROM sys.obj$ o, sys.clu$ c, sys.seg$ s WHERE o.obj# = c.obj# AND c.ts# IN (:1, :2) AND c.file# = s.file# AND c.block# = s.block# AND c.ts# = s.ts# UNION ALL SELECT 1, o.owner#, tn.name, ' ', ' ', 1, i.ts# FROM sys.obj$ o, sys.seg$ s, sys.tab$ t, sys.obj$ tn, sys.ind$ i WHERE o.obj# = i.obj# AND i.ts# IN ( :1, :2) AND i.file# = s.file# AND i.block# = s.block# AND i.ts# = s.ts# AND i.bo# = tn.obj# AND tn.obj# = t.obj# AND decode (bitand (i.property, 2), 2, 1, 0) = 0 AND i.type# = 4 UNION ALL SELECT 1, o.owner#, o.name, o.subname, ' ', 3, tp.ts# FROM sys.obj$ o, sys.seg$ s, sys.tab$ t, sys.tabpart$ tp WHERE o.obj# = tp.obj# AND tp.ts# IN (:1, :2) AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 0 UNION ALL SELECT 2, o.owner#, o.name, o.subname, ' ', 4, ip.ts# FROM sys.obj$ o, sys.seg$ s, sys.ind$ i, sys.indpart$ ip WHERE o.obj# = ip.obj# AND ip.ts# IN (:1, :2) AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# not in (4, 8) UNION ALL SELECT 1, o.owner#, tn.name, ' ', ' ', 5, t.ts# FROM sys.obj$ o, sys.seg$ s, sys.tab$ t, sys.obj$ tn, sys.tab$ iot WHERE o.obj# = t.obj# AND t.ts# IN (:1, :2) AND t.file# = s.file# AND t.block# = s.block# AND t.ts# = s.ts# AND tn.obj# = t.bobj# AND tn.obj# = iot.obj# AND decode (bitand (t.property, 32), 32, 1, 0) = 0 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 UNI ON ALL SELECT 1, tn.owner#, tn.name, ' ', decode(bitand(c.property, 1), 1, ac.name, c.name), 8, l.ts# FROM sys.seg$ s, sys.obj$ tn, sys.attrcol$ ac, sys.col$ c, sys.lob$ l WHERE tn.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.ts# IN (:1, :2) AND l.file# = s.file# AND l.block# = s.block# AND l.ts# = s.ts# AND c.obj# = ac.obj#(+) AND c.intcol# = ac.intcol#(+) AND bitand(c.property, 32768) != 32768 UNION ALL SELECT 1, o.owner#, tn.name, o.subname, ' ', 3, ip.ts# FROM sys.seg$ s, sys.obj$ o, sys.ind$ i, sys.obj$ tn, sys.indpart$ ip WHERE o.obj# = ip.obj# AND ip.ts# IN (:1, :2) AND ip.file# = s.file# AND ip.block# = s.block# AND ip.ts# = s.ts# AND i.obj# = ip.bo# AND decode (bitand (i.property, 2), 2, 1, 0) = 1 AND i.type# = 4 AND i.bo# = tn.obj# UNION ALL SELECT 1, o.owner#, tbo.name, o.subname, ' ', 13, tp.ts# FROM sys.seg$ s, sys.obj$ o, sys.obj$ tbo, sys.tab$ t, sys.tabpart$ tp WHERE o.obj# = tp.obj# AND tp.ts# IN (:1, :2) AND tp.file# = s.file# AND tp.block# = s.block# AND tp.ts# = s.ts# AND t.obj# = tp.bo# AND decode (bitand (t.property, 32), 32, 1, 0) = 1 AND decode (bitand (t.property, 64), 64, 1, 0) = 0 AND decode (bitand (t.property, 512), 512, 1, 0) = 1 AND tbo.obj# = t.bobj# UNION ALL SELECT 1, tbo.owner#, tbo.name, po.subname, decode(bitand(c.property, 1), 1, a.name , c.name), 8, lf.ts# FROM sys.seg$ s, sys.obj$ tbo, sys.attrcol$ a, sys.col$ c, sys.lob$ l, sys.obj$ po, sys.partobj$ pobj, sys.lobfrag$ lf WHERE pobj.obj# = tbo.obj# AND lf.ts# IN (:1, :2) AND lf.file# = s.file# AND lf.block# = s.block# AND lf.ts# = s.ts# AND mod(pobj.spare2, 256) = 0 AND tbo.obj# = c.obj# AND c.obj# = l.obj# AND c.intcol# = l.intcol# AND l.lobj# = lf.parentobj# AND lf.tabfragobj# = po.obj# AND bitand(c.property, 32768) != 32768 AND c.obj# = a.obj#(+) AND c.intcol# = a.intcol#(+) UNION ALL SELECT 1, o.owner#, bo.name, o.subname, ' ', 9, tsp.ts# FROM sys.seg$ s, sys.obj$ o, sys.obj$ bo, sys.tabsubpart$ tsp WHERE o.obj# = tsp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 2 AND tsp.file# = s.file# AND tsp.block# = s.block# AND tsp.ts# IN (:1, :2) UNION ALL SELECT 2, o.owner#, bo.name, o.subname, ' ', 10, isp.ts# FROM sys.seg$ s, sys.obj$ o, sys.obj$ bo, sys.indsubpart$ isp WHERE o.obj# = isp.obj# AND bo.owner# = o.owner# AND bo.name = o.name AND bo.type# = 1 AND isp.file# = s.file# AND isp.block# = s.block# AND isp.ts# IN (:1, :2) ) o, sys.ts$ ts, sys.user$ u WHERE o.USER_NAME# = u.user# AND u.name NOT IN ('SYS', 'SYSTEM', 'SYSMAN', 'CTXSYS', 'MDSYS', 'ORDSYS', 'ORDPLUGINS', 'OLAPSYS', 'DBSNMP', 'MGMT_VIEW', 'OUTLN', 'ANONYMOUS', 'DMSYS', 'EXFSYS', 'LBACSYS', 'SI_INFORMTN_SCHEMA', 'SYSMAN', 'WKPROXY', 'WKSYS', 'WK_TEST', 'WMSYS', 'XDB', 'TRACESVR', 'SCOTT', 'ADAMS', 'BLAKE', 'CLARK', 'JONES', 'HR', 'TSMSYS') AND o.TABLESPACE# = ts.ts# AND ts.ts# IN (:1, :2) AND rownum < 201
1zxbp7bhad0jbINSERT INTO cbp_tax_price(amount_info_id, district_tax) VALUES(:1, :2)
22br1212sy71mSELECT t1.amount_info_id, t1.version, t1.type, t1.currency_code, t1.amount, t1.discounted, t1.amount_is_final FROM dcspp_amount_info t1 WHERE t1.amount_info_id IN (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190, :191, :192, :193, :194, :195, :196, :197, :198, :199, :200)
22fm0kf95w8j5SELECT t1.order_id FROM dcspp_order t1 WHERE (t1.state = :1)
23rhmg06mnkurSELECT district_tax FROM cbp_tax_price WHERE amount_info_id=:1
25kqrdu78dkmdSELECT t1.amount_info_id, t1.version, t1.type, t1.currency_code, t1.amount, t1.discounted, t1.amount_is_final FROM dcspp_amount_info t1 WHERE t1.amount_info_id IN (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99)
25uamm5j57cj9INSERT INTO dcspp_item(commerce_item_id, type, version, item_class_type, catalog_ref_id, catalog_key, product_id, quantity, state, price_info, order_ref) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
27j2x027fvfc6DELETE FROM dcspp_order_price WHERE amount_info_id = :1
298mw906pgpg4INSERT INTO dcspp_amount_info(amount_info_id, type, version, currency_code, amount, discounted, amount_is_final) VALUES(:1, :2, :3, :4, :5, :6, :7)
2f2zht0jfs1utINSERT INTO dcspp_taxshipitem(amount_info_id, shipping_group_id, tax_ship_item_sub) VALUES(:1, :2, :3)
2gxjq59qr7gqdINSERT INTO dcspp_auth_status(payment_group_id, sequence_num, auth_status) VALUES(:1, :2, :3)
2u77msbt0sb25SELECT NVL(COUNT(MSG_STATE), 0) FROM ATG_STREAMS_ADM.AQ$CAPT_NUTR_QUEUE_TBL WHERE consumer_name is null AND MSG_STATE='READY' and queue = 'CAPT_NUTR_QUEUE' and address IN (select '"'||destination_queue_owner ||'"' ||'.'||'"' ||destination_queue_name||'"@'||destination_dblink from dba_propagation)
2u8mkmfpr8n09INSERT INTO dcspp_order_item(order_id, sequence_num, commerce_items) VALUES(:1, :2, :3)
2x8b8b45yfqztselect FILE_NAME, d.TABLESPACE_NAME, d.BYTES, sum(nvl(e.BYTES, 0)), round(sum(nvl(e.BYTES, 0)) / (d.BYTES), 4) * 100, d.BYTES - nvl(sum(e.BYTES), 0) from DBA_EXTENTS e, DBA_DATA_FILES d where d.FILE_ID = e.FILE_ID (+) group by FILE_NAME, d.TABLESPACE_NAME, d.FILE_ID, d.BYTES, STATUS order by d.TABLESPACE_NAME, d.FILE_ID
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
31yp6g9ht89g3DELETE FROM dcspp_ntaxshipitem WHERE amount_info_id = :1
3h7fatfmwuwnp /* OracleOEM */ declare TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; resultsql varchar2(32767); rquery varchar2(1000); wquery varchar2(1000); propagation_name varchar2(100) ; i number :=0; rdy NUMBER := 0; wtg NUMBER := 0; begin resultsql := ''; FOR cur_row IN (select propagation_name, queue_table, source_queue_owner, source_queue_name from dba_queues, dba_propagation where owner=source_queue_owner and source_queue_name=name) LOOP rquery := 'SELECT NVL(COUNT(MSG_STATE), 0) FROM '||cur_row.source_queue_owner||'.AQ$'||cur_row.queue_table||' WHERE consumer_name is null AND MSG_STATE=''READY'' and queue = '''||cur_row.source_queue_name||''' and address IN (select ''"''||destination_queue_owner ||''"'' ||''.''||''"'' ||destination_queue_name||''"@''||destination_dblink from dba_propagation)'; execute immediate rquery into rdy; wquery := 'SELECT NVL(COUNT(MSG_STATE), 0) FROM '||cur_row.source_queue_owner||'.AQ$'||cur_row.queue_table||' WHERE consumer_name is null AND MSG_STATE=''WAITING'' and queue = '''||cur_row.source_queue_name||''' and address IN (select ''"''||destination_queue_owner ||''"'' ||''.''||''"'' ||destination_queue_name||''"@''||destination_dblink from dba_propagation)'; execute immediate wquery into wtg; if(i > 0) then resultsql := resultsql || ' UNION '; end if; propagation_name := cur_row.propagation_name; resultsql := resultsql || 'select '''||propagation_name||''' propagation_nam e, '||rdy|| ' ready, '||wtg||' waiting from dual'; i := i + 1; END LOOP; ---- -- If no propagation jobs are there , return an empty result set ---- if(resultsql IS NULL) then OPEN data_cursor FOR SELECT -1 FROM dual WHERE 0=1; else OPEN data_cursor FOR resultsql; end if; :1 := data_cursor; end;
3sq8w0cbaj6sb SELECT t1.order_id, t1.version, t1.creation_date, t1.tax_price_info, t1.type, t1.explicitly_saved, t1.created_by_order, t1.state, t1.last_modified_date, t1.submitted_date, t1.price_info, t1.description, t1.state_detail, t1.origin_of_order, t1.completed_date, t1.profile_id, t1.order_class_type FROM dcspp_order t1 WHERE t1.order_id IN (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190, :191, :192, :193, :194, :195, :196, :197, :198, :199, :200)
4mnzkdak7jbkt select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */ count(*), count("ROWS_PROCESSED_DELTA"), count(distinct "ROWS_PROCESSED_DELTA"), sum(sys_op_opnsize("ROWS_PROCESSED_DELTA")), substrb(dump(min("ROWS_PROCESSED_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("ROWS_PROCESSED_DELTA"), 16, 0, 32), 1, 120), count("CPU_TIME_TOTAL"), count(distinct "CPU_TIME_TOTAL"), sum(sys_op_opnsize("CPU_TIME_TOTAL")), substrb(dump(min("CPU_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("CPU_TIME_TOTAL"), 16, 0, 32), 1, 120), count("CPU_TIME_DELTA"), count(distinct "CPU_TIME_DELTA"), sum(sys_op_opnsize("CPU_TIME_DELTA")), substrb(dump(min("CPU_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("CPU_TIME_DELTA"), 16, 0, 32), 1, 120), count("ELAPSED_TIME_TOTAL"), count(distinct "ELAPSED_TIME_TOTAL"), sum(sys_op_opnsize("ELAPSED_TIME_TOTAL")), substrb(dump(min("ELAPSED_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("ELAPSED_TIME_TOTAL"), 16, 0, 32), 1, 120), count("ELAPSED_TIME_DELTA"), count(distinct "ELAPSED_TIME_DELTA"), sum(sys_op_opnsize("ELAPSED_TIME_DELTA")), substrb(dump(min("ELAPSED_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("ELAPSED_TIME_DELTA"), 16, 0, 32), 1, 120), count("IOWAIT_TOTAL"), count(distinct "IOWAIT_TOTAL"), sum(sys_op_opnsize("IOWAIT_TOTAL")), substrb(dump(min("IOWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("IOWAIT_TOTAL"), 16, 0, 32), 1, 120), count("IOWAIT_DELTA"), count(distinct "IOWAIT_DELTA"), sum(sys_op_opnsize("IOWAIT_DELTA")), substrb(dump(min("IOWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("IOWAIT_DELTA"), 16, 0, 32), 1, 120), count("CLWAIT_TOTAL"), count(distinct "CLWAIT_TOTAL"), sum(sys_op_opnsize("CLWAIT_TOTAL")), substrb(dump(min("CLWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("CLWAIT_TOTAL"), 16, 0, 32), 1, 120), count("CLWAIT_DELTA"), count(distinct "CLWAIT_DELTA"), sum(sys_op_opnsize("CLWAIT_DELTA")), substrb(dump(min("CLWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("CLWAIT_DELTA"), 16, 0, 32), 1, 120), count("APWAIT_TOTAL"), count(distinct "APWAIT_TOTAL"), sum(sys_op_opnsize("APWAIT_TOTAL")), substrb(dump(min("APWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("APWAIT_TOTAL"), 16, 0, 32), 1, 120), count("APWAIT_DELTA"), count(distinct "APWAIT_DELTA"), sum(sys_op_opnsize("APWAIT_DELTA")), substrb(dump(min("APWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("APWAIT_DELTA"), 16, 0, 32), 1, 120), count("CCWAIT_TOTAL"), count(distinct "CCWAIT_TOTAL"), sum(sys_op_opnsize("CCWAIT_TOTAL")), substrb(dump(min("CCWAIT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("CCWAIT_TOTAL"), 16, 0, 32), 1, 120), count("CCWAIT_DELTA"), count(distinct "CCWAIT_DELTA"), sum(sys_op_opnsize("CCWAIT_DELTA")), substrb(dump(min("CCWAIT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("CCWAIT_DELTA"), 16, 0, 32), 1, 120), count("DIRECT_WRITES_TOTAL"), count(distinct "DIRECT_WRITES_TOTAL"), sum(sys_op_opnsize("DIRECT_WRITES_TOTAL" )), substrb(dump(min("DIRECT_WRITES_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("DIRECT_WRITES_TOTAL"), 16, 0, 32), 1, 120), count("DIRECT_WRITES_DELTA"), count(distinct "DIRECT_WRITES_DELTA"), sum(sys_op_opnsize("DIRECT_WRITES_DELTA")), substrb(dump(min("DIRECT_WRITES_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("DIRECT_WRITES_DELTA"), 16, 0, 32), 1, 120), count("PLSEXEC_TIME_TOTAL"), count(distinct "PLSEXEC_TIME_TOTAL"), sum(sys_op_opnsize("PLSEXEC_TIME_TOTAL")), substrb(dump(min("PLSEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PLSEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), count("PLSEXEC_TIME_DELTA"), count(distinct "PLSEXEC_TIME_DELTA"), sum(sys_op_opnsize("PLSEXEC_TIME_DELTA")), substrb(dump(min("PLSEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PLSEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), count("JAVEXEC_TIME_TOTAL"), count(distinct "JAVEXEC_TIME_TOTAL"), sum(sys_op_opnsize("JAVEXEC_TIME_TOTAL")), substrb(dump(min("JAVEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("JAVEXEC_TIME_TOTAL"), 16, 0, 32), 1, 120), count("JAVEXEC_TIME_DELTA"), count(distinct "JAVEXEC_TIME_DELTA"), sum(sys_op_opnsize("JAVEXEC_TIME_DELTA")), substrb(dump(min("JAVEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("JAVEXEC_TIME_DELTA"), 16, 0, 32), 1, 120), count("BIND_DATA"), count(distinct "BIND_DATA"), sum(sys_op_opnsize("BIND_DATA")), substrb(dump(min(substrb("BIND_DATA", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("BIND_DATA", 1, 32)), 16, 0, 32 ), 1, 120), count("FLAG"), count(distinct "FLAG"), sum(sys_op_opnsize("FLAG")), substrb(dump(min("FLAG"), 16, 0, 32), 1, 120), substrb(dump(max("FLAG"), 16, 0, 32), 1, 120), count(distinct "SNAP_ID"), sum(sys_op_opnsize("SNAP_ID")), count(distinct "DBID"), sum(sys_op_opnsize("DBID")), count(distinct "INSTANCE_NUMBER"), sum(sys_op_opnsize("INSTANCE_NUMBER")), count(distinct "SQL_ID"), sum(sys_op_opnsize("SQL_ID")), count(distinct "PLAN_HASH_VALUE"), sum(sys_op_opnsize("PLAN_HASH_VALUE")), substrb(dump(min("PLAN_HASH_VALUE"), 16, 0, 32), 1, 120), substrb(dump(max("PLAN_HASH_VALUE"), 16, 0, 32), 1, 120), count("OPTIMIZER_COST"), count(distinct "OPTIMIZER_COST"), sum(sys_op_opnsize("OPTIMIZER_COST")), substrb(dump(min("OPTIMIZER_COST"), 16, 0, 32), 1, 120), substrb(dump(max("OPTIMIZER_COST"), 16, 0, 32), 1, 120), count("OPTIMIZER_MODE"), count(distinct "OPTIMIZER_MODE"), sum(sys_op_opnsize("OPTIMIZER_MODE")), substrb(dump(min("OPTIMIZER_MODE"), 16, 0, 32), 1, 120), substrb(dump(max("OPTIMIZER_MODE"), 16, 0, 32), 1, 120), count("OPTIMIZER_ENV_HASH_VALUE"), count(distinct "OPTIMIZER_ENV_HASH_VALUE"), sum(sys_op_opnsize("OPTIMIZER_ENV_HASH_VALUE")), substrb(dump(min("OPTIMIZER_ENV_HASH_VALUE"), 16, 0, 32), 1, 120), substrb(dump(max("OPTIMIZER_ENV_HASH_VALUE"), 16, 0, 32), 1, 120), count("SHARABLE_MEM"), count(distinct "SHARABLE_MEM"), sum(sys_op_opnsize("SHARABLE_MEM")), count("LOADED_VERSIONS"), count(distinct "LOADED_VERSIONS"), sum(sys_op_opnsize("LOADED_VERSIONS")), substrb(dump (min("LOADED_VERSIONS"), 16, 0, 32), 1, 120), substrb(dump(max("LOADED_VERSIONS"), 16, 0, 32), 1, 120), count("VERSION_COUNT"), count(distinct "VERSION_COUNT"), sum(sys_op_opnsize("VERSION_COUNT")), count("MODULE"), count(distinct "MODULE"), sum(sys_op_opnsize("MODULE")), substrb(dump(min(substrb("MODULE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("MODULE", 1, 32)), 16, 0, 32), 1, 120), count("ACTION"), count(distinct "ACTION"), sum(sys_op_opnsize("ACTION")), substrb(dump(min(substrb("ACTION", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("ACTION", 1, 32)), 16, 0, 32), 1, 120), count("SQL_PROFILE"), count(distinct "SQL_PROFILE"), sum(sys_op_opnsize("SQL_PROFILE")), substrb(dump(min(substrb("SQL_PROFILE", 1, 32)), 16, 0, 32), 1, 120), substrb(dump(max(substrb("SQL_PROFILE", 1, 32)), 16, 0, 32), 1, 120), count("FORCE_MATCHING_SIGNATURE"), count(distinct "FORCE_MATCHING_SIGNATURE"), sum(sys_op_opnsize("FORCE_MATCHING_SIGNATURE")), substrb(dump(min("FORCE_MATCHING_SIGNATURE"), 16, 0, 32), 1, 120), substrb(dump(max("FORCE_MATCHING_SIGNATURE"), 16, 0, 32), 1, 120), count("PARSING_SCHEMA_ID"), count(distinct "PARSING_SCHEMA_ID"), sum(sys_op_opnsize("PARSING_SCHEMA_ID")), substrb(dump(min("PARSING_SCHEMA_ID"), 16, 0, 32), 1, 120), substrb(dump(max("PARSING_SCHEMA_ID"), 16, 0, 32), 1, 120), count("PARSING_SCHEMA_NAME"), count(distinct "PARSING_SCHEMA_NAME"), sum(sys_op_opnsize("PARSING_SCHEMA_NAME")), substrb(dump(min("PARSING_SCHEMA_NAME"), 16, 0, 32), 1, 120), substrb(dump(max("PARSING_SCHEMA_NAME"), 16, 0, 32), 1, 120), count("FETCHES_TOTAL"), count(distinct "FETCHES_TOTAL"), sum(sys_op_opnsize("FETCHES_TOTAL")), substrb(dump(min("FETCHES_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("FETCHES_TOTAL"), 16, 0, 32), 1, 120), count("FETCHES_DELTA"), count(distinct "FETCHES_DELTA"), sum(sys_op_opnsize("FETCHES_DELTA")), substrb(dump(min("FETCHES_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("FETCHES_DELTA"), 16, 0, 32), 1, 120), count("END_OF_FETCH_COUNT_TOTAL"), count(distinct "END_OF_FETCH_COUNT_TOTAL"), sum(sys_op_opnsize("END_OF_FETCH_COUNT_TOTAL")), substrb(dump(min("END_OF_FETCH_COUNT_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("END_OF_FETCH_COUNT_TOTAL"), 16, 0, 32), 1, 120), count("END_OF_FETCH_COUNT_DELTA"), count(distinct "END_OF_FETCH_COUNT_DELTA"), sum(sys_op_opnsize("END_OF_FETCH_COUNT_DELTA")), substrb(dump(min("END_OF_FETCH_COUNT_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("END_OF_FETCH_COUNT_DELTA"), 16, 0, 32), 1, 120), count("SORTS_TOTAL"), count(distinct "SORTS_TOTAL"), sum(sys_op_opnsize("SORTS_TOTAL")), substrb(dump(min("SORTS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("SORTS_TOTAL"), 16, 0, 32), 1, 120), count("SORTS_DELTA"), count(distinct "SORTS_DELTA"), sum(sys_op_opnsize("SORTS_DELTA")), substrb(dump(min("SORTS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("SORTS_DELTA"), 16, 0, 32), 1, 120), count("EXECUTIONS_TOTAL"), count(distinct "EXECUTIONS_TOTAL"), sum(sys_op_opnsize("EXECUTIONS_TOTAL")), su bstrb(dump(min("EXECUTIONS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("EXECUTIONS_TOTAL"), 16, 0, 32), 1, 120), count("EXECUTIONS_DELTA"), count(distinct "EXECUTIONS_DELTA"), sum(sys_op_opnsize("EXECUTIONS_DELTA")), substrb(dump(min("EXECUTIONS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("EXECUTIONS_DELTA"), 16, 0, 32), 1, 120), count("PX_SERVERS_EXECS_TOTAL"), count(distinct "PX_SERVERS_EXECS_TOTAL"), sum(sys_op_opnsize("PX_SERVERS_EXECS_TOTAL")), substrb(dump(min("PX_SERVERS_EXECS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PX_SERVERS_EXECS_TOTAL"), 16, 0, 32), 1, 120), count("PX_SERVERS_EXECS_DELTA"), count(distinct "PX_SERVERS_EXECS_DELTA"), sum(sys_op_opnsize("PX_SERVERS_EXECS_DELTA")), substrb(dump(min("PX_SERVERS_EXECS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PX_SERVERS_EXECS_DELTA"), 16, 0, 32), 1, 120), count("LOADS_TOTAL"), count(distinct "LOADS_TOTAL"), sum(sys_op_opnsize("LOADS_TOTAL")), substrb(dump(min("LOADS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("LOADS_TOTAL"), 16, 0, 32), 1, 120), count("LOADS_DELTA"), count(distinct "LOADS_DELTA"), sum(sys_op_opnsize("LOADS_DELTA")), substrb(dump(min("LOADS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("LOADS_DELTA"), 16, 0, 32), 1, 120), count("INVALIDATIONS_TOTAL"), count(distinct "INVALIDATIONS_TOTAL"), sum(sys_op_opnsize("INVALIDATIONS_TOTAL")), substrb(dump(min("INVALIDATIONS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("INVALIDATIONS_TOTAL"), 16, 0, 32), 1, 120), count("INVALIDATIONS_DELTA" ), count(distinct "INVALIDATIONS_DELTA"), sum(sys_op_opnsize("INVALIDATIONS_DELTA")), substrb(dump(min("INVALIDATIONS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("INVALIDATIONS_DELTA"), 16, 0, 32), 1, 120), count("PARSE_CALLS_TOTAL"), count(distinct "PARSE_CALLS_TOTAL"), sum(sys_op_opnsize("PARSE_CALLS_TOTAL")), substrb(dump(min("PARSE_CALLS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("PARSE_CALLS_TOTAL"), 16, 0, 32), 1, 120), count("PARSE_CALLS_DELTA"), count(distinct "PARSE_CALLS_DELTA"), sum(sys_op_opnsize("PARSE_CALLS_DELTA")), substrb(dump(min("PARSE_CALLS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("PARSE_CALLS_DELTA"), 16, 0, 32), 1, 120), count("DISK_READS_TOTAL"), count(distinct "DISK_READS_TOTAL"), sum(sys_op_opnsize("DISK_READS_TOTAL")), substrb(dump(min("DISK_READS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("DISK_READS_TOTAL"), 16, 0, 32), 1, 120), count("DISK_READS_DELTA"), count(distinct "DISK_READS_DELTA"), sum(sys_op_opnsize("DISK_READS_DELTA")), substrb(dump(min("DISK_READS_DELTA"), 16, 0, 32), 1, 120), substrb(dump(max("DISK_READS_DELTA"), 16, 0, 32), 1, 120), count("BUFFER_GETS_TOTAL"), count(distinct "BUFFER_GETS_TOTAL"), sum(sys_op_opnsize("BUFFER_GETS_TOTAL")), substrb(dump(min("BUFFER_GETS_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("BUFFER_GETS_TOTAL"), 16, 0, 32), 1, 120), count("BUFFER_GETS_DELTA"), count(distinct "BUFFER_GETS_DELTA"), sum(sys_op_opnsize("BUFFER_GETS_DELTA")), substrb(dump(min("BUFFER_GETS_DELTA"), 16, 0, 32), 1, 120) , substrb(dump(max("BUFFER_GETS_DELTA"), 16, 0, 32), 1, 120), count("ROWS_PROCESSED_TOTAL"), count(distinct "ROWS_PROCESSED_TOTAL"), sum(sys_op_opnsize("ROWS_PROCESSED_TOTAL")), substrb(dump(min("ROWS_PROCESSED_TOTAL"), 16, 0, 32), 1, 120), substrb(dump(max("ROWS_PROCESSED_TOTAL"), 16, 0, 32), 1, 120) from "SYS"."WRH$_SQLSTAT" t
4xj3y410vtm24INSERT INTO dcspp_cc_status(status_id, auth_expiration, avs_code, avs_desc_result) VALUES(:1, :2, :3, :4)
4xpkxs0jddqjmUPDATE dcspp_amount_info SET version=:1 WHERE amount_info_id=:2 AND version=:3
4xrxgw4j40q6xSELECT sequence_num, adjustments FROM dcspp_amtinfo_adj WHERE amount_info_id=:1 ORDER BY 1 ASC
4xx30f7tam1daselect s.USERNAME, s.OSUSER, s.SID, a.OWNER, a.OBJECT, a.TYPE from sys.v_$session s, sys.v_$access a where s.SID = a.SID and s.USERNAME not in ('SYS', 'SYSTEM') and a.OWNER not in ('SYS', 'SYSTEM') order by a.OBJECT, a.TYPE, s.USERNAME
5jdhg3c8fz3cjSELECT daytime_phone FROM nyco_shp_addr WHERE shipping_group_id=:1
61sk18vc0ajavINSERT INTO dcspp_itmprice_det(amount_info_id, sequence_num, cur_price_details) VALUES(:1, :2, :3)
68wcvyvpdy74jSELECT NVL(COUNT(MSG_STATE), 0) FROM ATG_STREAMS_ADM.AQ$CAPT_NUTR_QUEUE_TBL WHERE consumer_name is null AND MSG_STATE='WAITING' and queue = 'CAPT_NUTR_QUEUE' and address IN (select '"'||destination_queue_owner ||'"' ||'.'||'"' ||destination_queue_name||'"@'||destination_dblink from dba_propagation)
6abjvp0nd0m01UPDATE dcspp_tax_price SET city_tax=:1, county_tax=:2, state_tax=:3, country_tax=:4 WHERE amount_info_id=:5
6dj8a273d7t3rUPDATE cbp_order SET oms_order_id=:1 WHERE order_id=:2
6h4gy0ym4fsd6INSERT INTO dcspp_relationship(relationship_id, type, version, rel_class_type, relationship_type, order_ref) VALUES(:1, :2, :3, :4, :5, :6)
6ktnc6kzb8p7vINSERT INTO dcspp_order_price(amount_info_id, raw_subtotal, tax, shipping) VALUES(:1, :2, :3, :4)
6mcpb06rctk0xcall dbms_space.auto_space_advisor_job_proc ( )
6w0sjchwkq643INSERT INTO dcspp_order(order_id, type, version, order_class_type, profile_id, description, state, creation_date, origin_of_order, explicitly_saved, submitted_date, last_modified_date, price_info, tax_price_info) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)
7x86bfu27vdsmINSERT INTO dcspp_ord_abandon(abandonment_id, version, order_id) VALUES(:1, :2, :3)
809f7pzn1gs22select acc.OWNER, acc.CONSTRAINT_NAME, acc.COLUMN_NAME, acc.POSITION, 'No Index' from dba_cons_columns acc, dba_constraints ac where ac.CONSTRAINT_NAME = acc.CONSTRAINT_NAME and ac.CONSTRAINT_TYPE = 'R' and acc.OWNER not in ('SYS', 'SYSTEM') and not exists ( select 'TRUE' from dba_ind_columns b where b.TABLE_OWNER = acc.OWNER and b.TABLE_NAME = acc.TABLE_NAME and b.COLUMN_NAME = acc.COLUMN_NAME and b.COLUMN_POSITION = acc.POSITION) order by acc.OWNER, acc.CONSTRAINT_NAME, acc.COLUMN_NAME, acc.POSITION
8gtb1amd3ag1zSELECT t1.shipping_group_id, t1.version, t1.type, t1.shipgrp_class_type, t1.shipping_method, t1.description, t1.ship_on_date, t1.actual_ship_date, t1.state, t1.state_detail, t1.submitted_date, t1.price_info, t1.order_ref FROM dcspp_ship_group t1 WHERE t1.shipping_group_id = :1
8szmwam7fysa3insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
8tt8b9djvbr68INSERT INTO dcspp_order_rel(order_id, sequence_num, relationships) VALUES(:1, :2, :3)
9025xptwsgst1INSERT INTO dcspp_ntaxshipitem(amount_info_id, shipping_group_id, non_tax_item_sub) VALUES(:1, :2, :3)
957zsnv3dtz2vINSERT INTO dcspp_order_pg(order_id, sequence_num, payment_groups) VALUES(:1, :2, :3)
98vbvhfyyb5cxSELECT url FROM dcs_media_ext WHERE media_id=:1
9g54f9u1tm2yhUPDATE dcspp_price_adjust SET version=:1, adj_description=:2, pricing_model=:3, adjustment=:4, qty_adjusted=:5 WHERE adjustment_id=:6 AND version=:7
a5v1z2zhm6cdgINSERT INTO dcspp_shipitem_tax(amount_info_id, shipping_group_id, ship_item_tax) VALUES(:1, :2, :3)
a8tuhu1k9xkb1UPDATE cbp_tax_price SET district_tax=:1 WHERE amount_info_id=:2
a9yjmbgy5bx9cINSERT INTO dcspp_shipitem_rel(relationship_id, shipping_group_id, commerce_item_id, quantity, returned_qty, amount, state) VALUES(:1, :2, :3, :4, :5, :6, :7)
abbu4j41fgqp8SELECT abandonment_id FROM dcspp_ord_abandon WHERE order_id=:1
aqk3cnr7nwrdaINSERT INTO dss_dps_view_item (id, timestamp, sessionid, parentsessionid, repositoryname, folder, itemtype, repositoryid, itemdescriptor, page, profileid) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11)
ayv7vjb7ngnjgSELECT t1.amount_info_id, t1.version, t1.type, t1.currency_code, t1.amount, t1.discounted, t1.amount_is_final FROM dcspp_amount_info t1 WHERE t1.amount_info_id = :1
b2rs85rd1ctg6SELECT shipping_group_id, commerce_item_id, quantity, returned_qty, amount, state, state_detail FROM dcspp_shipitem_rel WHERE relationship_id=:1
b6usrg82hwsa3call dbms_stats.gather_database_stats_job_proc ( )
b961m68nwgk0tDELETE FROM dcspp_taxshipitem WHERE amount_info_id = :1
bkc0t4k34k0xxINSERT INTO dcspp_price_adjust(adjustment_id, version, adj_description, pricing_model, adjustment, qty_adjusted) VALUES(:1, :2, :3, :4, :5, :6)
brbvfrck5zpvzINSERT INTO dcspp_shipitem_sub(amount_info_id, shipping_group_id, ship_item_subtotal) VALUES(:1, :2, :3)
bwuu1md5yvb2wDELETE FROM dcspp_amount_info WHERE amount_info_id = :1
cnvu1tn3uf7uxDELETE FROM dcspp_shipitem_sub WHERE amount_info_id = :1
cwpgpfkbsdzccUPDATE dcspp_ord_abandon SET version=:1, order_id=:2 WHERE abandonment_id=:3 AND version=:4
dbd6jx4ac9kq0SELECT type, version, currency_code, amount, discounted, amount_is_final FROM dcspp_amount_info WHERE amount_info_id=:1
djs2w2f17nw2zDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
f4760tx2hyp0jINSERT INTO dcspp_amtinfo_adj(amount_info_id, sequence_num, adjustments) VALUES(:1, :2, :3)
f97szfrxt9pyhselect blevel as "Index Blevel", count(blevel) as "# Indexes", decode(blevel, 0, 'OK BLEVEL', 1, 'OK BLEVEL', 2, 'OK BLEVEL', 3, 'OK BLEVEL', 'BLEVEL HIGH') " " from dba_indexes where owner not in ('SYSTEM', 'SYS') and num_rows is not null group by blevel order by blevel desc
f9mpwjjnr8h90SELECT sequence_num, relationships FROM dcspp_order_rel WHERE order_id=:1 ORDER BY 1 ASC
f9zmavumh3txrSELECT sequence_num, payment_groups FROM dcspp_order_pg WHERE order_id=:1 ORDER BY 1 ASC
ff0tgfzw6c4kzDELETE FROM dcspp_auth_status WHERE payment_group_id = :1
ffbrku49b1r95INSERT INTO dcspp_payorder_rel(relationship_id, payment_group_id, order_id, amount) VALUES(:1, :2, :3, :4)
fs0t33k408zw4INSERT INTO dcspp_tax_price(amount_info_id, city_tax, county_tax, state_tax, country_tax) VALUES(:1, :2, :3, :4, :5)
fwutywyf7nd5pINSERT INTO dcspp_amount_info(amount_info_id, type, version, currency_code, amount, discounted) VALUES(:1, :2, :3, :4, :5, :6)
fyrbzparfb4gbSELECT OWNER, SEGMENT_NAME, PARTITION_NAME, SEGMENT_TYPE, TABLESPACE_NAME, TABLESPACE_ID FROM SYS_DBA_SEGS WHERE SEGMENT_OBJD = :B1
g95a6c61jsuv8DELETE FROM dcspp_amtinfo_adj WHERE amount_info_id = :1
gk165qzg6vpfmUPDATE dcspp_order_price SET raw_subtotal=:1, tax=:2, shipping=:3 WHERE amount_info_id=:4
gkcatdfgt8d3nSELECT order_id, ord_last_updated, abandon_state, abandonment_count, abandonment_date, reanimation_date, convert_date, lost_date FROM dcspp_ord_abandon WHERE abandonment_id=:1
gtbbrmz2rw8m5UPDATE dcspp_amount_info SET version=:1, currency_code=:2, amount=:3, discounted=:4, amount_is_final=:5 WHERE amount_info_id=:6 AND version=:7
gthf71bt7fu0pSELECT t1.adjustment_id, t1.version, t1.adj_description, t1.pricing_model, t1.adjustment, t1.qty_adjusted FROM dcspp_price_adjust t1 WHERE t1.adjustment_id = :1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 1,974,457 109.68 57.10
CPU used when call started 1,962,880 109.03 56.77
CR blocks created 54,165 3.01 1.57
Cached Commit SCN referenced 9,046 0.50 0.26
Commit SCN cached 284 0.02 0.01
DB time 26,467,274 1,470.18 765.46
DBWR checkpoint buffers written 49,608 2.76 1.43
DBWR checkpoints 2 0.00 0.00
DBWR fusion writes 6,456 0.36 0.19
DBWR object drop buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 911 0.05 0.03
DBWR undo block writes 22,815 1.27 0.66
DFO trees parallelized 851 0.05 0.02
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 6,314 0.35 0.18
PX local messages sent 6,314 0.35 0.18
PX remote messages recv'd 2,126 0.12 0.06
PX remote messages sent 5,322 0.30 0.15
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 851 0.05 0.02
RowCR - row contention 4,247 0.24 0.12
RowCR attempts 331,388 18.41 9.58
RowCR hits 366,599 20.36 10.60
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment shrink 22 0.00 0.00
SQL*Net roundtrips to/from client 1,168,910 64.93 33.81
SQL*Net roundtrips to/from dblink 497 0.03 0.01
active txn count during cleanout 316,967 17.61 9.17
application wait time 23 0.00 0.00
background checkpoints completed 2 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 85,483 4.75 2.47
branch node splits 3 0.00 0.00
buffer is not pinned count 1,328,646 73.80 38.43
buffer is pinned count 1,049,556 58.30 30.35
bytes received via SQL*Net from client 231,991,829 12,886.48 6,709.43
bytes received via SQL*Net from dblink 158,944 8.83 4.60
bytes sent via SQL*Net to client 111,727,681 6,206.15 3,231.27
bytes sent via SQL*Net to dblink 145,701 8.09 4.21
calls to get snapshot scn: kcmgss 1,145,241 63.61 33.12
calls to kcmgas 421,645 23.42 12.19
calls to kcmgcs 5,312 0.30 0.15
change write time 1,806 0.10 0.05
cleanout - number of ktugct calls 179,066 9.95 5.18
cleanouts and rollbacks - consistent read gets 63,536 3.53 1.84
cleanouts only - consistent read gets 10,920 0.61 0.32
cluster key scan block gets 435,503 24.19 12.60
cluster key scans 192,668 10.70 5.57
cluster wait time 69,116 3.84 2.00
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 270 0.01 0.01
commit batch/immediate requested 270 0.01 0.01
commit cleanout failures: block lost 28,801 1.60 0.83
commit cleanout failures: callback failure 3,256 0.18 0.09
commit cleanout failures: cannot pin 68 0.00 0.00
commit cleanouts 421,995 23.44 12.20
commit cleanouts successfully completed 389,870 21.66 11.28
commit immediate performed 270 0.01 0.01
commit immediate requested 270 0.01 0.01
commit txn count during cleanout 284,364 15.80 8.22
concurrency wait time 2,972 0.17 0.09
consistent changes 487,007 27.05 14.08
consistent gets 5,071,974 281.73 146.69
consistent gets - examination 2,289,525 127.18 66.22
consistent gets direct 66 0.00 0.00
consistent gets from cache 5,072,394 281.76 146.70
current blocks converted for CR 3 0.00 0.00
cursor authentications 677 0.04 0.02
data blocks consistent reads - undo records applied 447,813 24.87 12.95
db block changes 2,530,120 140.54 73.17
db block gets 2,863,587 159.06 82.82
db block gets direct 958 0.05 0.03
db block gets from cache 2,862,565 159.01 82.79
deferred (CURRENT) block cleanout applications 168,601 9.37 4.88
dirty buffers inspected 20 0.00 0.00
enqueue conversions 133,802 7.43 3.87
enqueue releases 2,227,375 123.72 64.42
enqueue requests 2,228,586 123.79 64.45
enqueue timeouts 1,212 0.07 0.04
enqueue waits 14,612 0.81 0.42
exchange deadlocks 3,581 0.20 0.10
execute count 1,005,694 55.86 29.09
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 248,579 13.81 7.19
free buffer requested 419,652 23.31 12.14
gc CPU used by this session 10,633 0.59 0.31
gc cr block build time 437 0.02 0.01
gc cr block flush time 2,812 0.16 0.08
gc cr block receive time 16,528 0.92 0.48
gc cr block send time 429 0.02 0.01
gc cr blocks received 192,175 10.67 5.56
gc cr blocks served 166,185 9.23 4.81
gc current block flush time 97,534 5.42 2.82
gc current block pin time 94,409,513 5,244.18 2,730.41
gc current block receive time 26,392 1.47 0.76
gc current block send time 337 0.02 0.01
gc current blocks received 121,797 6.77 3.52
gc current blocks served 112,648 6.26 3.26
gc local grants 26,232 1.46 0.76
gc remote grants 17,454 0.97 0.50
gcs messages sent 562,930 31.27 16.28
ges messages sent 70,339 3.91 2.03
global enqueue get time 10,575 0.59 0.31
global enqueue gets async 21,484 1.19 0.62
global enqueue gets sync 664,562 36.91 19.22
global enqueue releases 553,713 30.76 16.01
heap block compress 2,538 0.14 0.07
hot buffers moved to head of LRU 4,424 0.25 0.13
immediate (CR) block cleanout applications 74,459 4.14 2.15
immediate (CURRENT) block cleanout applications 15,448 0.86 0.45
index crx upgrade (found) 10 0.00 0.00
index crx upgrade (positioned) 40,899 2.27 1.18
index fast full scans (full) 691 0.04 0.02
index fetch by key 840,067 46.66 24.30
index scans kdiixs1 325,145 18.06 9.40
leaf node 90-10 splits 114 0.01 0.00
leaf node splits 2,771 0.15 0.08
lob reads 1,563 0.09 0.05
lob writes 352 0.02 0.01
lob writes unaligned 352 0.02 0.01
logons cumulative 1,473 0.08 0.04
messages received 119,311 6.63 3.45
messages sent 118,959 6.61 3.44
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,784,044 99.10 51.60
opened cursors cumulative 883,798 49.09 25.56
parse count (failures) 7 0.00 0.00
parse count (hard) 2,892 0.16 0.08
parse count (total) 859,954 47.77 24.87
parse time cpu 2,735 0.15 0.08
parse time elapsed 3,476 0.19 0.10
physical read IO requests 12,661 0.70 0.37
physical read bytes 139,960,320 7,774.40 4,047.79
physical read total IO requests 66,973 3.72 1.94
physical read total bytes 1,423,861,248 79,091.42 41,179.43
physical read total multi block requests 803 0.04 0.02
physical reads 17,085 0.95 0.49
physical reads cache 16,772 0.93 0.49
physical reads cache prefetch 4,224 0.23 0.12
physical reads direct 313 0.02 0.01
physical reads direct (lob) 45 0.00 0.00
physical reads direct temporary tablespace 225 0.01 0.01
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 22,900 1.27 0.66
physical write bytes 465,149,952 25,837.75 13,452.58
physical write total IO requests 155,256 8.62 4.49
physical write total bytes 1,920,987,648 106,705.38 55,556.81
physical write total multi block requests 113,994 6.33 3.30
physical writes 56,781 3.15 1.64
physical writes direct 1,205 0.07 0.03
physical writes direct (lob) 21 0.00 0.00
physical writes direct temporary tablespace 1,107 0.06 0.03
physical writes from cache 55,576 3.09 1.61
physical writes non checkpoint 31,327 1.74 0.91
pinned buffers inspected 417 0.02 0.01
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 51,783 2.88 1.50
process last non-idle time 18,017 1.00 0.52
queries parallelized 575 0.03 0.02
recursive calls 1,434,555 79.69 41.49
recursive cpu usage 1,939,264 107.72 56.09
redo blocks written 915,301 50.84 26.47
redo buffer allocation retries 10 0.00 0.00
redo entries 1,344,123 74.66 38.87
redo log space requests 17 0.00 0.00
redo log space wait time 22 0.00 0.00
redo ordering marks 20,661 1.15 0.60
redo size 437,124,528 24,281.02 12,642.06
redo subscn max counts 15,609 0.87 0.45
redo synch time 1,240 0.07 0.04
redo synch writes 69,718 3.87 2.02
redo wastage 16,279,128 904.26 470.81
redo write time 1,939 0.11 0.06
redo writer latching time 3 0.00 0.00
redo writes 61,630 3.42 1.78
rollback changes - undo records applied 1,064 0.06 0.03
rollbacks only - consistent read gets 3,324 0.18 0.10
rows fetched via callback 313,022 17.39 9.05
session connect time 270 0.01 0.01
session cursor cache hits 470,505 26.14 13.61
session logical reads 7,935,561 440.80 229.50
session pga memory 1,784,701,416 99,135.07 51,615.28
session pga memory max 4,477,706,728 248,723.82 129,499.57
session uga memory ############### 21,474,075.18 11,180,608.25
session uga memory max 4,933,387,824 274,035.60 142,678.31
shared hash latch upgrades - no wait 413,297 22.96 11.95
shared hash latch upgrades - wait 298 0.02 0.01
sorts (memory) 259,826 14.43 7.51
sorts (rows) 13,964,950 775.71 403.88
sql area evicted 526 0.03 0.02
sql area purged 55 0.00 0.00
summed dirty queue length 64 0.00 0.00
switch current to new buffer 7,818 0.43 0.23
table fetch by rowid 669,939 37.21 19.38
table fetch continued row 1,915 0.11 0.06
table scan blocks gotten 518,606 28.81 15.00
table scan rows gotten 46,682,594 2,593.08 1,350.11
table scans (long tables) 0 0.00 0.00
table scans (short tables) 29,571 1.64 0.86
total number of times SMON posted 106 0.01 0.00
transaction lock background gets 44 0.00 0.00
transaction lock foreground requests 44 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 270 0.01 0.01
undo change vector size 156,001,932 8,665.46 4,511.73
user I/O wait time 3,947 0.22 0.11
user calls 1,970,343 109.45 56.98
user commits 16,232 0.90 0.47
user rollbacks 18,345 1.02 0.53
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 64,117 3.56 1.85
write clones created in background 0 0.00 0.00
write clones created in foreground 1 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 137,530 144,471
opened cursors current 131 152
workarea memory allocated 1,396 1,417
logons current 48 72

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 2 0.40

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)
TBS_NYCO 2,992 0 3.43 1.72 14,724 1 15,256 11.60
SYSAUX 3,892 0 2.94 1.29 2,770 0 0 0.00
TBS_NUTR 4,410 0 2.87 1.02 53 0 0 0.00
UNDOTBS1 2 0 0.00 1.00 3,065 0 160 0.25
SYSTEM 1,251 0 3.33 1.00 1,116 0 0 0.00
PERFSTAT 28 0 0.00 1.00 1,105 0 0 0.00
TEMP 80 0 1.38 13.84 61 0 0 0.00
TBS_QCSUPPLY 2 0 0.00 1.00 2 0 0 0.00
UNDOTBS2 2 0 0.00 1.00 2 0 7,531 2.48
USERS 2 0 0.00 1.00 2 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)
PERFSTAT /opt/oracle/TMP/datafile/perfstat01.dbf 28 0 0.00 1.00 1,105 0 0 0.00
SYSAUX +DATA/racstage/datafile/sysaux.261.640049793 3,892 0 2.94 1.29 2,770 0 0 0.00
SYSTEM +DATA/racstage/datafile/system.259.640049785 1,251 0 3.33 1.00 1,116 0 0 0.00
TBS_NUTR +DATA/racstage/datafile/tbs_nutr.266.640501461 3,148 0 2.87 1.03 51 0 0 0.00
TBS_NUTR +DATA/racstage/datafile/tbs_nutr.268.640501337 1,262 0 2.88 1.00 2 0 0 0.00
TBS_NYCO +DATA/racstage/datafile/tbs_nyco.6283.643138369 483 0 4.04 3.06 7,347 0 7,841 12.14
TBS_NYCO +DATA/racstage/datafile/tbs_nyco.6284.643138469 2,509 0 3.31 1.46 7,377 0 7,415 11.02
TBS_QCSUPPLY +DATA/racstage/datafile/tbs_qcsupply.6313.643568945 2 0 0.00 1.00 2 0 0 0.00
TEMP +DATA/racstage/tempfile/temp.262.640049795 80 0 1.38 13.84 61 0 0  
UNDOTBS1 +DATA/racstage/datafile/undotbs1.260.640049791 2 0 0.00 1.00 3,065 0 160 0.25
UNDOTBS2 +DATA/racstage/datafile/undotbs2.263.640049797 2 0 0.00 1.00 2 0 7,531 2.48
USERS +DATA/racstage/datafile/users.264.640049797 2 0 0.00 1.00 2 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 472,074 100 7,931,791 16,772 55,576 0 0 22,948


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 117 1508 4746 5428 1105920 5428  
E 0 116 766 4641 5223 1105920 5223  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 384 0.10 46,056 6.69 12,908,170
D 768 0.20 92,112 2.02 3,908,119
D 1,152 0.29 138,168 1.48 2,853,054
D 1,536 0.39 184,224 1.36 2,631,979
D 1,920 0.49 230,280 1.22 2,358,566
D 2,304 0.59 276,336 1.15 2,217,750
D 2,688 0.68 322,392 1.10 2,118,862
D 3,072 0.78 368,448 1.08 2,083,751
D 3,456 0.88 414,504 1.02 1,974,054
D 3,840 0.98 460,560 1.02 1,961,215
D 3,936 1.00 472,074 1.00 1,930,143
D 4,224 1.07 506,616 0.95 1,836,927
D 4,608 1.17 552,672 0.91 1,751,369
D 4,992 1.27 598,728 0.88 1,704,423
D 5,376 1.37 644,784 0.87 1,686,844
D 5,760 1.46 690,840 0.87 1,680,798
D 6,144 1.56 736,896 0.87 1,680,798
D 6,528 1.66 782,952 0.87 1,680,798
D 6,912 1.76 829,008 0.87 1,680,798
D 7,296 1.85 875,064 0.87 1,680,798
D 7,680 1.95 921,120 0.87 1,680,775

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
99.40 1,898 12

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 2,500 2,119 312.48 1.36 0.44 100.00 0.00 256,000
E 2,500 2,101 351.54 1.38 0.39 100.00 0.00 256,000

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 61,906 61,906 0 0
64K 128K 252 252 0 0
128K 256K 47 47 0 0
256K 512K 112 112 0 0
512K 1024K 1,450 1,450 0 0
1M 2M 335 335 0 0
2M 4M 12 12 0 0
4M 8M 3 1 2 0
8M 16M 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
313 0.13 24,849.33 910.97 96.00 0
625 0.25 24,849.33 763.24 97.00 0
1,250 0.50 24,849.33 57.12 100.00 0
1,875 0.75 24,849.33 57.12 100.00 0
2,500 1.00 24,849.33 57.12 100.00 0
3,000 1.20 24,849.33 0.00 100.00 0
3,500 1.40 24,849.33 0.00 100.00 0
4,000 1.60 24,849.33 0.00 100.00 0
4,500 1.80 24,849.33 0.00 100.00 0
5,000 2.00 24,849.33 0.00 100.00 0
7,500 3.00 24,849.33 0.00 100.00 0
10,000 4.00 24,849.33 0.00 100.00 0
15,000 6.00 24,849.33 0.00 100.00 0
20,000 8.00 24,849.33 0.00 100.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
384 0.75 74 4,775 91,447 0.88 12,427 56.23 2,745,988
448 0.88 129 8,833 99,128 0.96 4,746 21.48 2,753,549
512 1.00 192 12,298 103,653 1.00 221 1.00 2,759,405
576 1.13 255 16,068 105,348 1.02 1 0.00 2,761,323
640 1.25 318 22,220 105,349 1.02 1 0.00 2,761,767
704 1.38 381 28,449 105,349 1.02 1 0.00 2,761,948
768 1.50 434 33,150 105,349 1.02 1 0.00 2,762,032
832 1.63 434 33,150 105,349 1.02 1 0.00 2,762,055
896 1.75 434 33,150 105,349 1.02 1 0.00 2,762,064
960 1.88 434 33,150 105,349 1.02 1 0.00 2,762,064
1,024 2.00 434 33,150 105,349 1.02 1 0.00 2,762,064

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,500 0.25 442,071 4,425,432
3,000 0.50 434,356 2,511,502
4,500 0.75 433,706 2,235,492
6,000 1.00 433,403 1,930,143
7,500 1.25 433,403 1,903,314
9,000 1.50 433,403 1,903,314
10,500 1.75 433,403 1,903,314
12,000 2.00 433,403 1,903,314

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)
224 0.15 0 0 0 0
384 0.26 0 0 0 0
544 0.36 0 0 0 0
704 0.47 0 0 0 0
864 0.57 0 0 0 0
1,024 0.68 0 0 0 0
1,184 0.79 0 0 0 0
1,344 0.89 0 0 0 0
1,504 1.00 0 0 0 0
1,664 1.11 0 0 0 0
1,824 1.21 0 0 0 0
1,984 1.32 0 0 0 0
2,144 1.43 0 0 0 0
2,304 1.53 0 0 0 0
2,464 1.64 0 0 0 0
2,624 1.74 0 0 0 0
2,784 1.85 0 0 0 0
2,944 1.96 0 0 0 0
3,104 2.06 0 0 0 0
3,264 2.17 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 14,959 177 12
undo header 6,794 18 3
undo block 897 1 1
segment header 20 0 14
2nd level bmb 194 0 0
1st level bmb 83 0 1

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (index contention) 882 882 0 718 12 16.67
US-Undo Segment 13,953 13,953 0 9,566 6 0.59
WF-AWR Flush 74 74 0 27 4 140.74
PS-PX Process Reservation 6,713 5,949 764 1,747 1 0.72
HW-Segment High Water Mark 3,045 3,045 0 896 1 0.64
CF-Controlfile Transaction 43,116 43,115 1 619 0 0.52
FB-Format Block 627 627 0 486 0 0.66
TT-Tablespace 12,649 12,649 0 140 0 0.50
TD-KTF map table enqueue (KTF dump entries) 36 36 0 36 0 1.67
SR-Synchronized Replication 12,675 12,675 0 89 0 0.56
TX-Transaction 29,499 29,499 0 24 0 2.08
TM-DML 516,870 516,868 0 77 0 0.39
TA-Instance Undo 63 63 0 43 0 0.70
TO-Temp Object 41 41 0 21 0 1.43
JQ-Job Queue 518 76 442 36 0 0.56
TQ-Queue table enqueue (TM contention) 44 44 0 25 0 0.80
JS-Job Scheduler (job run lock - synchronize) 15 15 0 8 0 1.25
AF-Advisor Framework (task serialization) 76 76 0 4 0 2.50
PI-Remote PX Process Spawn Status 10 10 0 4 0 2.50
PG-Global Parameter 6 6 0 3 0 3.33
DR-Distributed Recovery 10 10 0 10 0 0.00
MD-Materialized View Log DDL 19 19 0 10 0 0.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 5 0 5 5 0 0.00
TX-Transaction (allocate ITL entry) 5 5 0 4 0 0.00
UL-User-defined 80 80 0 4 0 0.00
PE-Parameter 1,486 1,486 0 3 0 0.00
SK-Shrink Segment 3 3 0 3 0 0.00
JS-Job Scheduler (wdw op) 1 1 0 1 0 0.00
JS-Job Scheduler (queue lock) 835,649 835,649 0 1 0 0.00
WL-Being Written Redo Log 2 2 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 22.39 30,662 2,475 33 15/54.25 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
09-Jan 23:10 6 374 0 1 15 0/0 0/0/0/0/0/0
09-Jan 23:00 193 842 0 3 15 0/0 0/0/0/0/0/0
09-Jan 22:50 6 248 1,540 2 39 0/0 0/0/0/0/0/0
09-Jan 22:40 5 227 940 1 29 0/0 0/0/0/0/0/0
09-Jan 22:30 1,363 1,426 340 26 19 0/0 0/0/0/0/0/0
09-Jan 22:20 825 529 697 33 25 0/0 0/0/0/0/0/0
09-Jan 22:10 1,121 919 0 33 15 0/0 0/0/0/0/0/0
09-Jan 22:00 3,357 4,327 0 10 15 0/0 0/0/0/0/0/0
09-Jan 21:50 2,342 3,420 0 11 15 0/0 0/0/0/0/0/0
09-Jan 21:40 3,353 2,739 12 15 15 0/0 0/0/0/0/0/0
09-Jan 21:30 5 215 1,626 2 40 0/0 0/0/0/0/0/0
09-Jan 21:20 7 210 1,026 1 30 0/0 0/0/0/0/0/0
09-Jan 21:10 8 396 426 1 20 0/0 0/0/0/0/0/0
09-Jan 21:00 210 320 0 3 15 0/0 0/0/0/0/0/0
09-Jan 20:50 11 310 1,749 1 42 0/0 0/0/0/0/0/0
09-Jan 20:40 8 220 1,149 1 32 0/0 0/0/0/0/0/0
09-Jan 20:30 9 245 2,475 1 54 0/0 0/0/0/0/0/0
09-Jan 20:20 18 610 1,780 1 52 0/0 0/0/0/0/0/0
09-Jan 20:10 24 1,003 1,180 1 42 0/0 0/0/0/0/0/0
09-Jan 20:00 204 536 1,546 4 41 0/0 0/0/0/0/0/0
09-Jan 19:50 10 286 946 1 31 0/0 0/0/0/0/0/0
09-Jan 19:40 6 226 342 1 21 0/0 0/0/0/0/0/0
09-Jan 19:30 291 567 0 9 15 0/0 0/0/0/0/0/0
09-Jan 19:20 1,540 1,662 0 14 15 0/0 0/0/0/0/0/0
09-Jan 19:10 813 1,248 0 10 17 0/0 0/0/0/0/0/0
09-Jan 19:00 1,294 2,374 0 9 15 0/0 0/0/0/0/0/0
09-Jan 18:50 893 1,045 0 8 15 0/0 0/0/0/0/0/0
09-Jan 18:40 2,914 2,035 1,523 9 40 0/0 0/0/0/0/0/0
09-Jan 18:30 1 211 922 1 30 0/0 0/0/0/0/0/0
09-Jan 18:20 1,368 1,346 322 8 20 0/0 0/0/0/0/0/0
09-Jan 18:10 9 225 0 3 15 0/0 0/0/0/0/0/0
09-Jan 18:00 175 321 0 3 15 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
AQ Propagation Scheduling Proc Table 1,657 0.00   0 0  
AQ Propagation Scheduling System Load 71 0.00   0 0  
ASM allocation 136 0.00   0 0  
ASM db client latch 12,512 0.00   0 0  
ASM map headers 92 0.00   0 0  
ASM map load waiting list 28 0.00   0 0  
ASM map operation freelist 362 0.00   0 0  
ASM map operation hash table 494,400 0.00   0 0  
ASM network background latch 7,295 0.00   0 0  
AWR Alerted Metric Element list 103,614 0.00   0 0  
Consistent RBA 61,636 0.00   0 0  
FAL request queue 362 0.00   0 0  
FAL subheap alocation 362 0.00   0 0  
FIB s.o chain latch 38 0.00   0 0  
FOB s.o list latch 1,506 0.00   0 0  
JS Sh mem access 4 0.00   0 0  
JS broadcast add buf latch 20,406 0.00   0 0  
JS broadcast drop buf latch 20,409 0.00   0 0  
JS broadcast kill buf latch 1 0.00   0 0  
JS broadcast load blnc latch 19,868 0.00   0 0  
JS mem alloc latch 59 0.00   0 0  
JS queue access latch 59 0.00   0 0  
JS queue state obj latch 1,671,298 0.00   0 0  
JS slv state obj latch 2,864 0.00   0 0  
KCL gc element parent latch 6,346,880 0.01 0.47 0 16,305 0.69
KFK SGA context latch 12,096 0.00   0 0  
KFMD SGA 278 0.00   0 0  
KJC message pool free list 95,938 0.01 0.00 0 8,195 0.00
KJCT flow control latch 827,172 0.01 0.07 0 0  
KMG MMAN ready and startup request latch 5,975 0.00   0 0  
KMG resize request state object freelist 6 0.00   0 0  
KSXR large replies 1,204 0.00   0 0  
KTF sga latch 72 0.00   0 4,583 0.00
KWQMN job cache list latch 8,524 0.00   0 0  
KWQP Prop Status 5,786 0.00   0 0  
MQL Tracking Latch 0     0 358 0.00
Memory Management Latch 66 0.00   0 5,975 0.00
Memory Queue Subscriber 651 0.00   0 0  
OS process 1,530 0.00   0 0  
OS process allocation 7,014 0.00   0 0  
OS process: request allocation 900 0.00   0 0  
PL/SQL warning settings 2,394 0.00   0 0  
SGA IO buffer pool latch 2,245 0.00   0 2,245 0.00
SQL memory manager latch 10 0.00   0 5,967 0.00
SQL memory manager workarea list latch 425,501 0.00   0 0  
Shared B-Tree 4,223,962,571 0.00   0 0  
active checkpoint queue latch 20,524 0.00   0 0  
active service list 512,295 0.00 0.00 0 6,237 0.00
archive control 664 0.00   0 0  
archive process latch 6,329 0.00   0 0  
begin backup scn array 28 0.00   0 0  
bq:time manger info latch 3,888 0.00   0 0  
buffer pool 6 0.00   0 0  
bufq statistics 12,995 0.00   0 0  
business card 1,702 0.00   0 0  
cache buffer handles 33,969 0.00   0 0  
cache buffers chains 21,155,467 0.02 0.43 1 628,672 0.06
cache buffers lru chain 348,361 0.04 0.45 0 997,414 0.08
cache table scan latch 0     0 388 0.00
channel handle pool latch 962 0.00   0 0  
channel operations parent latch 1,777,904 0.00 0.00 0 0  
checkpoint queue latch 519,047 0.00 0.10 0 166,938 0.00
client/application info 7,286 0.00   0 0  
commit callback allocation 122 0.00   0 0  
compile environment latch 85,636 0.00   0 0  
dictionary lookup 25 0.00   0 0  
dml lock allocation 813,062 0.01 0.12 0 0  
dummy allocation 2,936 0.00   0 0  
enqueue hash chains 5,618,665 0.00 0.18 0 754 0.13
enqueue sob latch 17 0.00   0 0  
enqueues 3,668,056 0.00 0.10 0 0  
error message lists 3,919 0.00   0 0  
event group latch 462 0.00   0 0  
file cache latch 2,437 0.00   0 0  
gcs drop object freelist 500 0.00   0 0  
gcs opaque info freelist 276,178 0.00 0.80 0 0  
gcs partitioned table hash 9,812,929 0.00   0 0  
gcs remaster request queue 34 0.00   0 0  
gcs remastering latch 3,369,263 0.00 4.00 0 0  
gcs resource freelist 17,783 0.00   0 6,509 0.00
gcs resource hash 3,493,476 0.01 0.40 0 1,300 0.00
gcs resource scan list 2,600 0.00   0 0  
gcs shadows freelist 41,528 0.00   0 47,417 0.00
ges caches resource lists 251,305 0.02 0.00 0 234,785 0.01
ges deadlock list 6,880 0.00   0 11 0.00
ges domain table 1,097,708 0.00   0 0  
ges enqueue table freelist 1,131,153 0.02 0.07 0 0  
ges group table 1,830,153 0.00 0.10 0 0  
ges process hash list 37,010 0.00   0 0  
ges process parent latch 2,466,783 0.00 0.00 0 0  
ges process table freelist 900 0.00   0 0  
ges resource hash list 1,574,709 0.09 0.58 0 81,008 0.01
ges resource scan list 3,971 0.00   0 0  
ges resource table freelist 97,055 0.00 0.00 0 0  
ges synchronous data 352 1.42 0.00 0 71,751 0.00
ges timeout list 40,130 0.00   0 31,908 0.00
global KZLD latch for mem in SGA 417 0.00   0 0  
global ctx hash table latch 1 0.00   0 0  
hash table column usage latch 1,339 0.00   0 331,836 0.00
hash table modification latch 848 0.00   0 0  
internal temp table object number allocation latc 8 0.00   0 0  
job workq parent latch 0     0 182 0.00
job_queue_processes parameter latch 387 0.00   0 0  
kks stats 10,830 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
ksuosstats global area 1,214 0.00   0 0  
ktm global data 157 0.00   0 0  
kwqbsn:qsga 2,112,242,836 0.00   0 0  
lgwr LWN SCN 68,367 0.01 0.00 0 0  
library cache 2,293,765 0.01 0.24 0 8,116 0.12
library cache load lock 7,764 0.00   0 0  
library cache lock 2,059,918 0.01 0.19 0 0  
library cache lock allocation 7,117 0.01 1.00 0 0  
library cache pin 242,091 0.02 0.00 0 2 0.00
library cache pin allocation 1,354 0.00   0 0  
list of block allocation 33,224 0.00   0 0  
loader state object freelist 254 0.00   0 0  
logminer context allocation 5 0.00   0 0  
longop free list parent 237 0.00   0 265 0.00
message pool operations parent latch 8,639 0.00   0 0  
messages 909,853 0.01 0.13 0 0  
mostly latch-free SCN 68,821 0.41 0.01 0 0  
msg queue 26 0.00   0 26 0.00
multiblock read objects 29,638 0.00 0.00 0 0  
name-service memory objects 25,660 0.00   0 0  
name-service namespace bucket 186,895 0.00   0 0  
name-service pending queue 13,262 0.00   0 0  
name-service request 40 0.00   0 0  
name-service request queue 194,245 0.00   0 0  
ncodef allocation latch 298 0.00   0 0  
object queue header heap 50,804 0.00   0 118 0.00
object queue header operation 1,084,204 0.02 0.54 0 5,728 0.00
object stats modification 110 0.00   0 0  
parallel query alloc buffer 19,653 0.00   0 0  
parallel query stats 3,204 0.00   0 0  
parallel txn reco latch 13,578 0.00   0 0  
parameter list 2,502 0.20 0.00 0 0  
parameter table allocation management 1,829 0.11 0.00 0 0  
post/wait queue 118,123 0.16 0.01 0 85,605 0.00
process allocation 169,928 0.00 1.00 0 462 0.00
process group creation 900 0.00   0 0  
process queue 9,450 0.00   0 0  
process queue reference 194,873 0.01 0.00 0 19,426 1154.36
qmn state object latch 34 0.00   0 0  
qmn task queue latch 21,548 4.39 0.36 0 0  
query server freelists 7,763 0.00   0 0  
query server process 6 0.00   0 6 16.67
queue sender's info. latch 18,497 0.11 0.00 0 0  
queued dump request 89,348 0.00   0 0  
redo allocation 199,422 0.10 0.53 0 1,343,851 0.05
redo copy 0     0 1,344,078 0.05
redo writing 218,990 0.00 1.00 0 0  
resmgr group change latch 2,004 0.00   0 0  
resmgr:actses active list 2,888 0.00   0 0  
resmgr:actses change group 1,442 0.00   0 0  
resmgr:free threads list 2,878 0.00   0 0  
resmgr:schema config 10 0.00   0 0  
row cache objects 1,892,593 0.04 0.09 0 6,921 0.35
rules engine aggregate statistics 20 0.00   0 0  
rules engine rule set statistics 1,040 0.00   0 0  
segmented array pool 20 0.00   0 0  
sequence cache 2,192 0.00   0 0  
session allocation 664,051 0.14 0.00 0 0  
session idle bit 4,024,847 0.00 0.26 0 0  
session state list latch 3,360 0.00   0 0  
session switching 298 0.00   0 0  
session timer 6,237 0.00   0 0  
shared pool sim alloc 130 0.00   0 0  
shared pool simulator 302,873 0.00 1.00 0 0  
simulator hash latch 488,681 0.00   0 0  
simulator lru latch 458,376 0.02 0.46 0 25,659 0.00
slave class 131 0.00   0 0  
slave class create 177 3.95 1.00 0 0  
sort extent pool 748 0.00   0 0  
state object free list 10 0.00   0 0  
statistics aggregation 1,820 0.00   0 0  
temp lob duration state obj allocation 4 0.00   0 0  
temporary table state object allocation 4 0.00   0 0  
threshold alerts latch 1,567 0.00   0 0  
trace latch 58 0.00   0 0  
transaction allocation 670,615 0.00   0 0  
transaction branch allocation 298 0.00   0 0  
undo global data 1,367,719 0.01 0.17 0 6 0.00
user lock 1,898 0.37 0.71 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
shared pool -71,115,100 258,972 2,109 256,974 0 0 0
cache buffers chains 21,155,467 3,383 1,451 2,028 0 0 0
Memory Queue -71,662,491 2,055 65 2,005 0 0 0
ges resource hash list 1,574,709 1,481 862 620 0 0 0
qmn task queue latch 21,548 946 336 610 0 0 0
session allocation 664,051 924 4 920 0 0 0
row cache objects 1,892,593 779 70 714 0 0 0
KCL gc element parent latch 6,346,880 590 278 322 0 0 0
library cache 2,293,765 344 84 268 0 0 0
mostly latch-free SCN 68,821 282 3 279 0 0 0
library cache lock 2,059,918 267 51 217 0 0 0
ges enqueue table freelist 1,131,153 227 16 211 0 0 0
gcs resource hash 3,493,476 218 87 139 0 0 0
object queue header operation 1,084,204 204 111 97 0 0 0
redo allocation 199,422 200 106 94 0 0 0
enqueue hash chains 5,618,665 192 34 161 0 0 0
post/wait queue 118,123 188 1 187 0 0 0
cache buffers lru chain 348,361 142 64 86 0 0 0
undo global data 1,367,719 129 22 111 0 0 0
dml lock allocation 813,062 95 11 86 0 0 0
messages 909,853 78 10 70 0 0 0
session idle bit 4,024,847 73 19 57 0 0 0
KJCT flow control latch 827,172 71 5 67 0 0 0
simulator lru latch 458,376 70 32 43 0 0 0
ges group table 1,830,153 40 4 36 0 0 0
enqueues 3,668,056 21 2 19 0 0 0
checkpoint queue latch 519,047 20 2 18 0 0 0
gcs remastering latch 3,369,263 8 32 1 0 0 0
process allocation 169,928 7 7 1 0 0 0
slave class create 177 7 7 0 0 0 0
user lock 1,898 7 5 2 0 0 0
gcs opaque info freelist 276,178 5 4 1 0 0 0
redo writing 218,990 2 2 0 0 0 0
library cache lock allocation 7,117 1 1 0 0 0 0
shared pool simulator 302,873 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclchkping 0 210 1
KCL gc element parent latch kclnfndnewm 0 40 27
KCL gc element parent latch kclevict 0 12 0
KCL gc element parent latch kclbla 0 9 13
KCL gc element parent latch kclliter 0 9 5
KCL gc element parent latch KCLUNLNK 0 8 9
KCL gc element parent latch kclhngcbk1 0 5 0
KCL gc element parent latch kclpto 0 4 207
KCL gc element parent latch kclulb 0 4 7
KCL gc element parent latch kcldrop 0 2 0
KCL gc element parent latch kclebs 0 2 1
KCL gc element parent latch kclfwrite1 0 2 0
KCL gc element parent latch kclpto_1 0 2 0
KCL gc element parent latch kclfwrite2 0 1 0
KCL gc element parent latch kclpdc_3 0 1 1
KCL gc element parent latch kclplz 0 1 6
KCL gc element parent latch kclpto_3 0 1 8
KCL gc element parent latch kclrwrite 0 1 1
KJCT flow control latch kjctcsnd: send normal message 0 5 2
Memory Queue kgqmsca 0 897 573
Memory Queue kgqmmsg_change 0 8 332
active service list kswssyis: find service entry 1 0 1 0
cache buffers chains kcbgtcr: fast path 0 642 147
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 252 214
cache buffers chains kcbchg: kslbegin: call CR func 0 184 83
cache buffers chains kcbget: pin buffer 0 157 133
cache buffers chains kcbgtcr: kslbegin excl 0 142 469
cache buffers chains kcbzwb 0 112 74
cache buffers chains kcbgcur: kslbegin 0 69 50
cache buffers chains kcbrls: kslbegin 0 43 101
cache buffers chains kcbzgb: scan from tail. nowait 0 21 0
cache buffers chains kclbla 0 18 42
cache buffers chains kclwcrs 0 18 57
cache buffers chains kcbzib: finish free bufs 0 13 11
cache buffers chains kclpto 0 12 0
cache buffers chains kcbnlc 0 10 9
cache buffers chains kclebs_1 0 10 7
cache buffers chains kcbgtcr 0 9 0
cache buffers chains kcbzib: exchange rls 0 9 1
cache buffers chains kcbgkcbcr 0 7 4
cache buffers chains kcbso1: set no access 0 6 9
cache buffers chains kclwrt 0 6 1
cache buffers chains kcbget: exchange rls 0 3 4
cache buffers chains kclpdc_4 0 3 22
cache buffers chains kclpto_1 0 3 235
cache buffers chains kcbget: exchange 0 2 6
cache buffers chains kcbgtcr: kslbegin shared 0 2 1
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 2 0
cache buffers chains kclwlr 0 2 2
cache buffers chains kcbbxsv 0 1 19
cache buffers chains kcbgcur: buf pinned 0 1 0
cache buffers chains kcbgcur: deadlock 0 1 0
cache buffers chains kclfpdb 0 1 0
cache buffers lru chain kcbzgws 0 22 1
cache buffers lru chain kcbzgb: posted for free bufs 0 20 57
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 17 0
cache buffers lru chain kclwcrs 0 4 0
cache buffers lru chain kcbzgm 0 1 0
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 2 0
cost function kzulrl 0 5 5
dml lock allocation ktaiam 0 9 9
dml lock allocation ktaidm 0 2 2
enqueue hash chains ksqcmi: if lk mode requested 0 12 2
enqueue hash chains ksqcnl 0 9 12
enqueue hash chains ksqgtl3 0 6 11
enqueue hash chains ksqcmi: if lk mode not requested 0 4 2
enqueue hash chains ksqrcl 0 2 6
enqueue hash chains ksucallcbksafely: ksqhngcbk1 0 1 0
enqueues ksqdel 0 2 2
event range base latch No latch 0 336 336
gcs opaque info freelist kjbrcvt save opaque info 0 3 3
gcs opaque info freelist kjbrgrant free opaque info 0 1 1
gcs remastering latch 59 0 24 0
gcs remastering latch 69 0 7 0
gcs remastering latch 43 0 2 0
gcs resource hash kjbassume 0 36 1
gcs resource hash kjbcrcomplete 0 30 0
gcs resource hash kjbconvert 0 6 3
gcs resource hash kjblocalfile_nolock 0 4 2
gcs resource hash kjbrdrmcvtq_98 0 4 6
gcs resource hash kjbrrcfwst 0 3 1
gcs resource hash kclfwrite1 0 1 1
gcs resource hash kjbcrconvert 0 1 0
gcs resource hash kjbopen 0 1 0
gcs resource hash kjbopen:affinity 0 1 0
ges enqueue table freelist kjlalc: lock allocation 0 12 14
ges enqueue table freelist kjlfr: remove lock from parent object 0 4 2
ges group table kjgagll: move a lock from process lock list to group lock list 0 3 1
ges group table kjgdgll: move a lock from group lock list to process lock list 0 1 3
ges resource hash list kjrmas1: lookup master node 0 592 1
ges resource hash list kjakcai: search for resp by resname 0 86 7
ges resource hash list kjcvscn: remove from scan queue 0 63 0
ges resource hash list kjlrlr: remove lock from resource queue 0 47 198
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 39 5
ges resource hash list kjucvl: lock convert request 0 29 640
ges resource hash list kjrref: find matched resource 0 6 11
lgwr LWN SCN kcs023 0 1 0
library cache kgldte: child 0 0 22 15
library cache kglLockCursor 0 17 3
library cache kglhdgn: child: 0 14 50
library cache kglrtl 0 4 2
library cache kglpndl: child: before processing 0 3 0
library cache kglic 0 2 0
library cache kglpndl: child: after processing 0 2 0
library cache kglScanDependency 0 1 0
library cache kglati 0 1 0
library cache kglobpn: child: 0 1 4
library cache kqlmbfre: child: in loop 0 1 4
library cache lock kgllkal: child: multiinstance 0 32 33
library cache lock kgllkdl: child: cleanup 0 19 18
library cache lock kgllkdl: child: no lock handle 0 14 6
library cache lock allocation kgllkget 0 1 1
messages ksaamb: after wakeup 0 5 10
messages ksarcv 0 4 0
messages ksarcv: after wait 0 1 0
mostly latch-free SCN kcslcu3 0 2 3
object queue header operation kcbw_unlink_q 0 45 16
object queue header operation kcbw_link_q 0 30 7
object queue header operation kclobj_3 0 21 0
object queue header operation kcbo_switch_cq 0 16 21
object queue header operation kcbo_switch_q_bg 0 3 0
object queue header operation kcbo_switch_mq_bg 0 2 13
object queue header operation kcbo_swap_buf 0 1 0
object queue header operation kcbo_swap_buf_bg 0 1 1
object queue header operation kclobj_1 0 1 0
post/wait queue ksliwat:add:nowait 0 1 0
process allocation ksucrp 0 6 0
process allocation ksuapc 0 1 6
redo allocation kcrfw_redo_gen: redo allocation 1 0 106 0
redo writing kcrfw_post: after write 0 1 0
redo writing kcrfwcr 0 1 1
row cache objects kqrpre: find obj 0 33 64
row cache objects kqreqd: reget 0 20 1
row cache objects kqreqd 0 12 1
row cache objects kqrbip 0 1 3
row cache objects kqrigt 0 1 0
row cache objects kqrso 0 1 0
session allocation ksucri 0 1 1
session allocation ksuprc 0 1 1
session allocation ksuxds: KSUSFCLC not set 0 1 0
session allocation ksuxds: not user session 0 1 0
session idle bit ksupuc: set busy 0 18 4
session idle bit ksupuc: clear busy 0 2 13
shared pool kghalo 0 1,379 931
shared pool kghfre 0 400 580
shared pool kghupr1 0 209 566
shared pool kghfrunp: alloc: cursor dur 0 47 0
shared pool kghalp 0 46 19
shared pool kghfrunp: alloc: wait 0 15 0
shared pool kghfrh 0 8 0
shared pool kghfrunp: clatch: nowait 0 3 0
shared pool kgh: sim resz update 0 2 0
shared pool kghasp 0 2 2
shared pool kghfree_extents: scan 0 1 11
shared pool kghfrunp: clatch: wait 0 1 4
shared pool simulator kglsim_upd_newhp 0 1 0
simulator lru latch kcbs_simulate: simulate set 0 32 32
slave class create ksvcreate 0 6 0
slave class create ksvsubmit 0 1 0
undo global data ktudba: KSLBEGIN 0 12 20
undo global data kturimugur: child 0 10 2

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
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_AMOUNT_INF_P   INDEX 421,584 5.31
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_AMOUNT_INFO   TABLE 263,232 3.32
ATG_STREAMS_ADM SYSAUX SYS_C0011652   INDEX 260,832 3.29
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_PRICE_ADJUST   TABLE 195,968 2.47
SYS SYSTEM I_OBJ#   INDEX 195,488 2.46

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
ATGDB_NYCO_CORE_STG TBS_NYCO DCS_CART_EVENT   TABLE 655 3.83
ATGDB_NYCO_CORE_STG TBS_NYCO NYCO_CC_FRAUD_STATUS   TABLE 192 1.12
ATGDB_NYCO_CORE_STG TBS_NYCO DRPT_SESSION_ORD   TABLE 102 0.60
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_PRICE_ADJUST   TABLE 101 0.59
SYS SYSTEM HISTGRM$   TABLE 64 0.37

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_AMOUNT_INF_P   INDEX 149 19.18
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_ORDABANDN1_X   INDEX 69 8.88
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_PRICE_ADJU_P   INDEX 62 7.98
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_AMTINFO_AD_P   INDEX 53 6.82
ATGDB_NYCO_CORE_STG TBS_NYCO AMTINF_ADJ_AID_IDX   INDEX 27 3.47

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
ATGDB_NYCO_CORE_STG TBS_NYCO ORDER_LASTMOD_IDX   INDEX 2 40.00
ATGDB_NYCO_CORE_STG TBS_NYCO ORDER_SUBMIT_IDX   INDEX 2 40.00
SYS SYSAUX I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST   INDEX 1 20.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_AMOUNT_INF_P   INDEX 148 24.79
ATGDB_NYCO_CORE_STG TBS_NYCO AMTINF_ADJ_AID_IDX   INDEX 60 10.05
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_PRICE_ADJU_P   INDEX 51 8.54
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_AMTINFO_AD_P   INDEX 33 5.53
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_ORDER_REL_P   INDEX 26 4.36

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_AMOUNT_INF_P   INDEX 3,046 23.43
ATGDB_NYCO_CORE_STG TBS_NYCO AMTINF_ADJ_AID_IDX   INDEX 1,290 9.92
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_PRICE_ADJU_P   INDEX 610 4.69
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_ORDER_PRIC_P   INDEX 541 4.16
ATGDB_NYCO_CORE_STG TBS_NYCO NTAX_SHIP_ITEM_IDX   INDEX 508 3.91

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
ATGDB_NYCO_CORE_STG TBS_NYCO AMTINF_ADJ_AID_IDX   INDEX 9,082 4.73
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_AMOUNT_INF_P   INDEX 8,133 4.23
ATGDB_NYCO_CORE_STG TBS_NYCO SHIP_ITEM_SUB_IDX   INDEX 6,028 3.14
ATGDB_NYCO_CORE_STG TBS_NYCO TAX_SHIP_ITEM_IDX   INDEX 5,920 3.08
ATGDB_NYCO_CORE_STG TBS_NYCO NTAX_SHIP_ITEM_IDX   INDEX 5,915 3.08

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_AMOUNT_INF_P   INDEX 7,871 6.46
ATGDB_NYCO_CORE_STG TBS_NYCO AMTINF_ADJ_AID_IDX   INDEX 4,874 4.00
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_AMTINFO_AD_P   INDEX 4,838 3.97
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_PRICE_ADJU_P   INDEX 4,517 3.71
ATGDB_NYCO_CORE_STG TBS_NYCO DCSPP_ORD_ABNDN_P   INDEX 4,237 3.48

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 326 0.61 0   8 1
dc_constraints 234 33.33 0   234 1
dc_database_links 142 0.00 0   0 1
dc_files 99 10.10 0   0 11
dc_global_oids 2,241 0.85 0   0 40
dc_histogram_data 24,181 15.78 0   2,596 4,399
dc_histogram_defs 30,323 27.48 0   2,793 3,793
dc_object_grants 68 27.94 0   0 38
dc_object_ids 30,697 3.23 0   22 1,242
dc_objects 14,594 9.33 0   91 1,400
dc_profiles 523 0.00 0   0 1
dc_rollback_segments 329,701 0.00 0   44 221
dc_segments 7,263 22.11 0   306 1,020
dc_sequences 106 8.49 0   106 5
dc_table_scns 19 100.00 0   0 0
dc_tablespace_quotas 1,152 10.59 0   0 4
dc_tablespaces 85,078 0.00 0   0 11
dc_usernames 3,557 0.25 0   0 18
dc_users 93,505 0.02 0   1 52
outstanding_alerts 629 78.70 0   20 19

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 18 2 0
dc_constraints 390 0 460
dc_files 10 0 9
dc_global_oids 19 0 4
dc_histogram_defs 12,368 0 3,444
dc_object_ids 1,033 0 801
dc_objects 1,542 1 800
dc_rollback_segments 78 8 0
dc_segments 2,092 251 964
dc_sequences 206 6 5
dc_table_scns 19 0 0
dc_tablespace_quotas 698 120 0
dc_tablespaces 1 0 1
dc_usernames 9 0 8
dc_users 15 0 13
outstanding_alerts 1,237 468 17

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 898 0.56 1,486 1.28 12 0
CLUSTER 190 1.05 461 0.65 1 0
INDEX 345 59.13 2,117 24.89 71 0
SQL AREA 2,664 82.92 1,066,578 0.78 440 191
TABLE/PROCEDURE 5,712 9.21 27,213 12.35 1,454 0
TRIGGER 306 3.59 327 4.28 3 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
BODY 5 5 3 4 0
CLUSTER 461 13 3 5 0
INDEX 2,117 736 134 538 0
TABLE/PROCEDURE 14,643 2,237 183 1,284 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 285.41   5.49 7.51 30 30 52 52
  Freeable 23.81 0.00 0.95 0.94 4   25 25
  SQL 2.44 1.91 0.07 0.25 1 8 33 18
  PL/SQL 0.84 0.28 0.02 0.04 0 0 50 48
E Other 325.79   4.29 6.50 30 30 76 76
  Freeable 22.13 0.00 0.89 0.95 4   25 25
  SQL 2.71 2.08 0.05 0.20 2 10 58 30
  PL/SQL 0.95 0.31 0.01 0.03 0 0 74 72

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 4,177,526,784 4,127,195,136
Fixed Size 2,082,080  
Redo Buffers 14,692,352  
Variable Size 2,097,154,784 2,147,486,432

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 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 ASH buffers 8.00 8.00 0.00
shared CCursor 6.00 11.36 89.43
shared FileOpenBlock 6.55 6.55 0.00
shared Heap0: KGL   5.26  
shared KQR L PO 5.39 7.56 40.29
shared PCursor   7.77  
shared PL/SQL DIANA 4.84   -100.00
shared XDB Schema Cac 7.52 7.52 0.00
shared db_block_hash_buckets 22.50 22.50 0.00
shared event statistics per sess 7.29 7.29 0.00
shared free memory 89.48 99.70 11.42
shared gcs resources 80.48 80.48 0.00
shared gcs shadows 50.69 50.69 0.00
shared ges big msg buffers 15.20 15.20 0.00
shared ges enqueues 8.13 8.86 8.99
shared ges reserved msg buffers 7.86 7.86 0.00
shared ges resource 4.72 5.24 11.23
shared library cache 10.57 13.59 28.53
shared row cache 7.16 7.16 0.00
shared sql area 37.61 54.83 45.80
streams free memory 1,493.44 1,493.44 0.00
  buffer_cache 3,984.00 3,936.00 -1.20
  fixed_sga 1.99 1.99 0.00
  log_buffer 14.01 14.01 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 Coordinator 910,970 0 0
Propagation Sender 24,127 0 0
QMON Slaves -2,402,064 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

Queue Schema and NameIncoming per secondOutgoing per secondSpilled per secondDiff Pct Spilled
ATG_STREAMS_ADM.CAPT_NUTRP_QUEUE 0 0 0 0
ATG_STREAMS_ADM.CAPT_NUTR_QUEUE 0 0 0 0
ATG_STREAMS_ADM.CAPT_PNUTR_QUEUE 0 0 0 0
SYS.CAPT_NUTRP_QUEUE 0 0 0 0
SYS.KUPC$C_1_20080104173601 0 0 0 0
SYS.KUPC$S_1_20080104173601 0 0 0 0

Back to Streams Statistics
Back to Top

Buffered Subscribers

Subscriber NameIncoming per secondOutgoing per secondSpilled per second
PROXY: NUTRP_ETL 0 0 0
PROXY: NUTRP_ETL 0 0 0
PROXY: NUTRP_ETL 0 0 0
PROXY: NUTRP_ETL 0 0 0
PROXY: NUTRP_ETL 0 0 0
PROXY: NUTR_ETL 0 0 0
PROXY: "ATG_STREAMS_ADM"."APPL_NUTRP_QUEUE"@NUTRP_ETL 0 0 0
PROXY: "ATG_STREAMS_ADM"."APPL_NUTR_QUEUE"@NUTR_ETL 0 0 0
PROXY: "ATG_STREAMS_ADM"."APPL_PNUTR_QUEUE"@NUTRP_ETL 0 0 0
PROXY: NUTRP_ETL 0 0 0
PROXY: NUTRP_ETL 0 0 0
PROXY: NUTR_ETL 0 0 0
PROXY: "ATG_STREAMS_ADM"."APPL_PNUTR_QUEUE"@NUTRP_ETL -0 0 -0
PROXY: NUTRP_ETL -0 0 -0
PROXY: NUTR_ETL -0 0 -0
PROXY: "ATG_STREAMS_ADM"."APPL_PNUTR_QUEUE"@NUTRP_ETL -0 0 -0
PROXY: NUTR_ETL -0 0 -0
PROXY: "ATG_STREAMS_ADM"."APPL_PNUTR_QUEUE"@NUTRP_ETL -0 0 -0

Back to Streams Statistics
Back to Top

Rule Set

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 20 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_shadows 466,139 545,895 547904 547904


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest /opt/oracle/admin/racstage/adump   
background_dump_dest /opt/oracle/admin/racstage/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files +DATA/racstage/controlfile/current.256.640049785   
core_dump_dest /opt/oracle/admin/racstage/cdump   
db_block_size 8192   
db_create_file_dest +DATA   
db_create_online_log_dest_1 +DATA   
db_domain      
db_file_multiblock_read_count 16   
db_name racstage   
db_recovery_file_dest_size 524288000000   
dispatchers (PROTOCOL=TCP) (SERVICE=racstageXDB)   
instance_number 1   
job_queue_processes 30   
log_archive_dest_1 LOCATION=+DATA/racstage/   
log_archive_format %t_%s_%r.dbf   
open_cursors 300   
pga_aggregate_target 2621440000   
processes 750   
recyclebin OFF   
remote_listener LISTENERS_RACSTAGE   
remote_login_passwordfile EXCLUSIVE   
service_names SYS$SYS.KUPC$S_1_20080104173601.RACSTAGE, SYS$ATG_STREAMS_ADM.CAPT_NUTR_QUEUE.RACSTAGE, SYS$ATG_STREAMS_ADM.CAPT_NUTRP_QUEUE.RACSTAGE, SYS$SYS.CAPT_NUTRP_QUEUE.RACSTAGE, SYS$ATG_STREAMS_ADM.CAPT_PNUTR_QUEUE.RACSTAGE, SYS$SYS.KUPC$C_1_20080104173601.RACSTAGE, dba, nyco   
sessions 830   
sga_max_size 6291456000   
sga_target 6291456000   
streams_pool_size 1577058304   
thread 1   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /opt/oracle/admin/racstage/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 52,981 2.94 1.53
acks for commit broadcast(logical) 56,598 3.14 1.64
broadcast msgs on commit(actual) 61,508 3.42 1.78
broadcast msgs on commit(logical) 61,630 3.42 1.78
broadcast msgs on commit(wasted) 3,841 0.21 0.11
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 4 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 62,138 3.45 1.80
gcs ast xid 59 0.00 0.00
gcs blocked converts 136,670 7.59 3.95
gcs blocked cr converts 176,792 9.82 5.11
gcs compatible basts 91 0.01 0.00
gcs compatible cr basts (global) 5,572 0.31 0.16
gcs compatible cr basts (local) 4,047 0.22 0.12
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 5,826 0.32 0.17
gcs dbwr write request msgs 4,798 0.27 0.14
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 2,320 0.13 0.07
gcs immediate (null) converts 9,780 0.54 0.28
gcs immediate cr (compatible) converts 1 0.00 0.00
gcs immediate cr (null) converts 1,652 0.09 0.05
gcs indirect ast 18,781 1.04 0.54
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 1,763 0.10 0.05
gcs msgs process time(ms) 23,109 1.28 0.67
gcs msgs received 523,373 29.07 15.14
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 227 0.01 0.01
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 166 0.01 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 65 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 35,696 1.98 1.03
gcs side channel msgs actual 3,283 0.18 0.09
gcs side channel msgs logical 323,077 17.95 9.34
gcs stale cr 5,029 0.28 0.15
gcs undo cr 8,814 0.49 0.25
gcs write notification msgs 859 0.05 0.02
gcs writes refused 345 0.02 0.01
ges msgs process time(ms) 1,148 0.06 0.03
ges msgs received 61,544 3.42 1.78
global posts dropped 0 0.00 0.00
global posts queue time 77,481 4.30 2.24
global posts queued 20 0.00 0.00
global posts requested 20 0.00 0.00
global posts sent 20 0.00 0.00
implicit batch messages received 2,452 0.14 0.07
implicit batch messages sent 11,467 0.64 0.33
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 76,120 4.23 2.20
messages queue sent actual 136,785 7.60 3.96
messages queue sent logical 167,777 9.32 4.85
messages received actual 500,099 27.78 14.46
messages received logical 584,917 32.49 16.92
messages sent directly 327,276 18.18 9.47
messages sent indirectly 83,590 4.64 2.42
messages sent not implicit batched 125,318 6.96 3.62
messages sent pbatched 203,098 11.28 5.87
msgs causing lmd to send msgs 18,212 1.01 0.53
msgs causing lms(s) to send msgs 93,842 5.21 2.71
msgs received queue time (ms) 140,205 7.79 4.05
msgs received queued 584,917 32.49 16.92
msgs sent queue time (ms) 366,367,649 20,350.68 10,595.70
msgs sent queue time on ksxp (ms) 101,895 5.66 2.95
msgs sent queued 167,003 9.28 4.83
msgs sent queued on ksxp 540,365 30.02 15.63
process batch messages received 198,305 11.02 5.74
process batch messages sent 140,388 7.80 4.06


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 73,789
CURRENT Block Requests 92,452
Data Block Requests 73,789
Undo Block Requests 8,831
TX Block Requests 77,324
Current Results 153,124
Private results 856
Zero Results 12,216
Disk Read Results 0
Fail Results 1
Fairness Down Converts 7,849
Fairness Clears 0
Free GC Elements 0
Flushes 26,050
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 31,241
Light Works 39,604
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 112,401 95.55 0.00 4.44 0.00 0.00
Flushes 11,953 94.29 3.79 0.08 0.00 1.84
Writes 4,520 66.81 32.81 0.11 0.04 0.22


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 103,259 70.58 29.25 0.17 117,531 86.42 13.56 0.02
2 undo header 72,053 98.47 1.53 0.00 166 89.76 10.24 0.00
2 Others 7,295 99.38 0.62 0.00 4,077 99.46 0.54 0.00
2 undo block 9,563 77.57 22.43 0.00 1 100.00 0.00 0.00


Back to Top

End of Report