|
DB Name |
DB Id |
Instance |
Inst num |
Release |
RAC |
Host |
|
XXX |
1622186648 |
XXX |
1 |
10.2.0.3.0 |
NO |
xxx |
|
Snap Id |
Snap Time |
Sessions |
Cursors/Session |
|
|
Begin Snap: |
134902 |
26-Oct-18 00:00:32 |
124 |
26.5 |
|
End Snap: |
134903 |
26-Oct-18 00:30:56 |
121 |
26.4 |
|
Elapsed: |
|
30.41 (mins) |
|
|
|
DB Time: |
|
67.17 (mins) |
|
|
Cache
Sizes
|
Begin |
End |
|||
|
Buffer Cache: |
496M |
496M |
Std Block Size: |
8K |
|
Shared Pool Size: |
1,424M |
1,424M |
Log Buffer: |
14,348K |
Load
Profile
|
Per Second |
Per Transaction |
|
|
Redo size: |
18,804.24 |
10,705.40 |
|
Logical reads: |
33,328.30 |
18,974.07 |
|
Block changes: |
52.48 |
29.88 |
|
Physical reads: |
3,347.80 |
1,905.93 |
|
Physical writes: |
6.27 |
3.57 |
|
User calls: |
44.19 |
25.16 |
|
Parses: |
35.66 |
20.30 |
|
Hard parses: |
0.29 |
0.17 |
|
Sorts: |
17.22 |
9.80 |
|
Logons: |
0.54 |
0.31 |
|
Executes: |
207.90 |
118.36 |
|
Transactions: |
1.76 |
|
|
% Blocks changed per
Read: |
0.16 |
Recursive Call %: |
92.58 |
|
Rollback per
transaction %: |
41.81 |
Rows per Sort: |
41.77 |
Instance
Efficiency Percentages (Target 100%)
|
Buffer Nowait %: |
98.64 |
Redo NoWait %: |
100.00 |
|
Buffer Hit %: |
89.96 |
In-memory Sort %: |
100.00 |
|
Library Hit %: |
99.68 |
Soft Parse %: |
99.19 |
|
Execute to Parse %: |
82.85 |
Latch Hit %: |
99.92 |
|
Parse
CPU to Parse Elapsd %: |
2.52 |
% Non-Parse CPU: |
99.67 |
Shared
Pool Statistics
|
Begin |
End |
|
|
Memory Usage %: |
68.17 |
68.28 |
|
% SQL with
executions>1: |
93.03 |
97.67 |
|
%
Memory for SQL w/exec>1: |
95.16 |
97.86 |
Top
5 Timed Events
|
Event |
Waits |
Time(s) |
Avg Wait(ms) |
% Total Call Time |
Wait Class |
|
db file sequential
read |
4,417,060 |
2,524 |
1 |
62.6 |
User I/O |
|
read by other session |
827,710 |
550 |
1 |
13.7 |
User I/O |
|
CPU time |
|
461 |
|
11.4 |
|
|
db file scattered read |
215,000 |
343 |
2 |
8.5 |
User I/O |
|
SQL*Net
more data from client |
638 |
10 |
16 |
.2 |
Network |
|
Statistic Name |
Time (s) |
% of DB Time |
|
sql execute elapsed
time |
4,023.12 |
99.83 |
|
DB CPU |
461.24 |
11.45 |
|
PL/SQL
execution elapsed time |
220.96 |
5.48 |
|
parse time elapsed |
5.27 |
0.13 |
|
hard parse elapsed
time |
1.83 |
0.05 |
|
connection
management call elapsed time |
0.89 |
0.02 |
|
repeated bind elapsed
time |
0.10 |
0.00 |
|
sequence load elapsed
time |
0.07 |
0.00 |
|
PL/SQL
compilation elapsed time |
0.04 |
0.00 |
|
hard
parse (sharing criteria) elapsed time |
0.00 |
0.00 |
|
failed parse elapsed
time |
0.00 |
0.00 |
|
DB time |
4,029.91 |
|
|
background elapsed
time |
23.18 |
|
|
background cpu time |
6.70 |
|
Back to Wait Events Statistics
Back to Top
|
Wait Class |
Waits |
%Time -outs |
Total Wait Time (s) |
Avg wait (ms) |
Waits /txn |
|
User I/O |
5,460,730 |
0.00 |
3,418 |
1 |
1,703.82 |
|
System I/O |
16,262 |
0.00 |
11 |
1 |
5.07 |
|
Network |
99,934 |
0.00 |
10 |
0 |
31.18 |
|
Other |
2,188,781 |
99.70 |
5 |
0 |
682.93 |
|
Commit |
3,432 |
0.00 |
4 |
1 |
1.07 |
|
Application |
879 |
0.00 |
0 |
1 |
0.27 |
|
Concurrency |
3,842 |
0.03 |
0 |
0 |
1.20 |
|
Configuration |
146 |
0.00 |
0 |
1 |
0.05 |
Back to Wait Events Statistics
Back to Top
|
Event |
Waits |
%Time -outs |
Total Wait Time (s) |
Avg wait (ms) |
Waits /txn |
|
db file sequential
read |
4,417,060 |
0.00 |
2,524 |
1 |
1,378.18 |
|
read by other session |
827,710 |
0.00 |
550 |
1 |
258.26 |
|
db file scattered read |
215,000 |
0.00 |
343 |
2 |
67.08 |
|
SQL*Net
more data from client |
638 |
0.00 |
10 |
16 |
0.20 |
|
log file parallel
write |
5,727 |
0.00 |
5 |
1 |
1.79 |
|
log file sync |
3,432 |
0.00 |
4 |
1 |
1.07 |
|
control file
sequential read |
7,445 |
0.00 |
3 |
0 |
2.32 |
|
PX Deq: Signal ACK |
441 |
7.26 |
2 |
4 |
0.14 |
|
PX qref latch |
2,182,172 |
100.00 |
2 |
0 |
680.86 |
|
db file parallel write |
1,356 |
0.00 |
1 |
1 |
0.42 |
|
control file parallel
write |
1,615 |
0.00 |
1 |
1 |
0.50 |
|
PX
Deq Credit: send blkd |
2,729 |
0.00 |
1 |
0 |
0.85 |
|
db file parallel read |
241 |
0.00 |
1 |
4 |
0.08 |
|
local write wait |
334 |
0.00 |
1 |
2 |
0.10 |
|
rdbms ipc reply |
166 |
0.00 |
1 |
3 |
0.05 |
|
log file sequential
read |
57 |
0.00 |
0 |
6 |
0.02 |
|
enq:
RO - fast object reuse |
226 |
0.00 |
0 |
1 |
0.07 |
|
latch: cache buffers
chains |
3,809 |
0.00 |
0 |
0 |
1.19 |
|
SQL*Net
break/reset to client |
650 |
0.00 |
0 |
0 |
0.20 |
|
SQL*Net
more data to client |
4,110 |
0.00 |
0 |
0 |
1.28 |
|
log buffer space |
145 |
0.00 |
0 |
1 |
0.05 |
|
direct path write |
233 |
0.00 |
0 |
1 |
0.07 |
|
Log archive I/O |
58 |
0.00 |
0 |
2 |
0.02 |
|
os thread startup |
3 |
0.00 |
0 |
28 |
0.00 |
|
SQL*Net
message to client |
82,354 |
0.00 |
0 |
0 |
25.70 |
|
PX
Deq: Table Q Get Keys |
326 |
0.00 |
0 |
0 |
0.10 |
|
reliable message |
116 |
0.00 |
0 |
0 |
0.04 |
|
latch free |
14 |
0.00 |
0 |
3 |
0.00 |
|
SQL*Net
message to dblink |
12,751 |
0.00 |
0 |
0 |
3.98 |
|
buffer busy waits |
12 |
0.00 |
0 |
1 |
0.00 |
|
enq: TX - index
contention |
2 |
0.00 |
0 |
6 |
0.00 |
|
direct path read |
151 |
0.00 |
0 |
0 |
0.05 |
|
cursor:
pin S wait on X |
1 |
100.00 |
0 |
10 |
0.00 |
|
enq: PS - contention |
62 |
0.00 |
0 |
0 |
0.02 |
|
PX
Deq: Table Q qref |
112 |
0.00 |
0 |
0 |
0.03 |
|
SQL*Net
more data to dblink |
54 |
0.00 |
0 |
0 |
0.02 |
|
latch:
cache buffers lru chain |
9 |
0.00 |
0 |
0 |
0.00 |
|
latch: library cache |
13 |
0.00 |
0 |
0 |
0.00 |
|
log file single write |
4 |
0.00 |
0 |
1 |
0.00 |
|
LGWR
wait for redo copy |
80 |
0.00 |
0 |
0 |
0.02 |
|
cursor: pin S |
2,549 |
0.00 |
0 |
0 |
0.80 |
|
latch: redo writing |
1 |
0.00 |
0 |
1 |
0.00 |
|
SQL*Net
more data from dblink |
27 |
0.00 |
0 |
0 |
0.01 |
|
enq:
TX - row lock contention |
2 |
0.00 |
0 |
0 |
0.00 |
|
enq: TX - contention |
1 |
0.00 |
0 |
1 |
0.00 |
|
enq: TM - contention |
1 |
0.00 |
0 |
1 |
0.00 |
|
latch:
object queue header operation |
4 |
0.00 |
0 |
0 |
0.00 |
|
db file single write |
1 |
0.00 |
0 |
0 |
0.00 |
|
latch:
In memory undo latch |
1 |
0.00 |
0 |
0 |
0.00 |
|
latch: shared pool |
1 |
0.00 |
0 |
0 |
0.00 |
|
SQL*Net
message from client |
82,356 |
0.00 |
95,323 |
1157 |
25.70 |
|
Streams
AQ: waiting for messages in the queue |
1,853 |
100.00 |
14,108 |
7614 |
0.58 |
|
pipe get |
1,335 |
100.00 |
5,345 |
4004 |
0.42 |
|
PX Idle Wait |
1,638 |
64.71 |
2,133 |
1302 |
0.51 |
|
Streams
AQ: qmn slave idle wait |
256 |
0.00 |
1,782 |
6962 |
0.08 |
|
Streams
AQ: qmn coordinator idle wait |
592 |
54.22 |
1,782 |
3011 |
0.18 |
|
EMON idle wait |
365 |
100.00 |
1,782 |
4883 |
0.11 |
|
Streams
AQ: waiting for time management or cleanup tasks |
20 |
55.00 |
1,759 |
87934 |
0.01 |
|
SQL*Net
message from dblink |
12,751 |
0.00 |
141 |
11 |
3.98 |
|
PX Deq: Execution Msg |
5,196 |
0.00 |
14 |
3 |
1.62 |
|
jobq slave wait |
4 |
75.00 |
11 |
2686 |
0.00 |
|
PX Deq: Execute Reply |
2,590 |
0.00 |
2 |
1 |
0.81 |
|
PX
Deq: Table Q Normal |
5,277 |
0.00 |
2 |
0 |
1.65 |
|
single-task message |
27 |
0.00 |
2 |
66 |
0.01 |
|
PX Deq: Msg Fragment |
1,804 |
0.00 |
1 |
1 |
0.56 |
|
PX
Deq Credit: need buffer |
2,444 |
0.00 |
0 |
0 |
0.76 |
|
PX Deq: Parse Reply |
342 |
0.00 |
0 |
0 |
0.11 |
|
PX Deq: Join ACK |
402 |
0.00 |
0 |
0 |
0.13 |
|
class slave wait |
2 |
0.00 |
0 |
0 |
0.00 |
Back to Wait Events Statistics
Back to Top
|
Event |
Waits |
%Time -outs |
Total Wait Time (s) |
Avg wait (ms) |
Waits /txn |
|
log file parallel
write |
5,727 |
0.00 |
5 |
1 |
1.79 |
|
db file sequential
read |
3,359 |
0.00 |
2 |
1 |
1.05 |
|
control file
sequential read |
4,988 |
0.00 |
2 |
0 |
1.56 |
|
db file scattered read |
1,102 |
0.00 |
2 |
1 |
0.34 |
|
db file parallel write |
1,356 |
0.00 |
1 |
1 |
0.42 |
|
control file parallel
write |
1,615 |
0.00 |
1 |
1 |
0.50 |
|
log file sequential
read |
57 |
0.00 |
0 |
6 |
0.02 |
|
log buffer space |
145 |
0.00 |
0 |
1 |
0.05 |
|
Log archive I/O |
58 |
0.00 |
0 |
2 |
0.02 |
|
os thread startup |
3 |
0.00 |
0 |
28 |
0.00 |
|
direct path write |
81 |
0.00 |
0 |
0 |
0.03 |
|
direct path read |
143 |
0.00 |
0 |
0 |
0.04 |
|
events in waitclass
Other |
102 |
0.00 |
0 |
0 |
0.03 |
|
log file single write |
4 |
0.00 |
0 |
1 |
0.00 |
|
latch: redo writing |
1 |
0.00 |
0 |
1 |
0.00 |
|
db file single write |
1 |
0.00 |
0 |
0 |
0.00 |
|
latch: cache buffers
chains |
2 |
0.00 |
0 |
0 |
0.00 |
|
rdbms ipc message |
14,122 |
45.82 |
21,355 |
1512 |
4.41 |
|
Streams
AQ: qmn slave idle wait |
256 |
0.00 |
1,782 |
6962 |
0.08 |
|
Streams
AQ: qmn coordinator idle wait |
592 |
54.22 |
1,782 |
3011 |
0.18 |
|
EMON idle wait |
365 |
100.00 |
1,782 |
4883 |
0.11 |
|
pmon timer |
608 |
100.00 |
1,781 |
2930 |
0.19 |
|
Streams
AQ: waiting for time management or cleanup tasks |
20 |
55.00 |
1,759 |
87934 |
0.01 |
|
smon timer |
230 |
0.43 |
1,633 |
7100 |
0.07 |
Back to Wait Events Statistics
Back to Top
|
Statistic |
Total |
|
NUM_LCPUS |
0 |
|
NUM_VCPUS |
0 |
|
AVG_BUSY_TIME |
11,852 |
|
AVG_IDLE_TIME |
126,951 |
|
AVG_IOWAIT_TIME |
6,849 |
|
AVG_SYS_TIME |
7,719 |
|
AVG_USER_TIME |
4,065 |
|
BUSY_TIME |
190,557 |
|
IDLE_TIME |
2,032,174 |
|
IOWAIT_TIME |
110,473 |
|
SYS_TIME |
124,491 |
|
USER_TIME |
66,066 |
|
LOAD |
0 |
|
OS_CPU_WAIT_TIME |
522,500 |
|
RSRC_MGR_CPU_WAIT_TIME |
0 |
|
PHYSICAL_MEMORY_BYTES |
39,728,447,488 |
|
NUM_CPUS |
16 |
|
NUM_CPU_CORES |
6 |
Back to Wait Events Statistics
Back to Top
|
Service Name |
DB Time (s) |
DB CPU (s) |
Physical Reads |
Logical Reads |
|
SYS$USERS |
4,025.10 |
461.10 |
6,094,187 |
60,793,903 |
|
EXXX |
0.00 |
0.00 |
0 |
0 |
|
SYS$BACKGROUND |
0.00 |
0.00 |
12,851 |
48,406 |
Back to Wait Events Statistics
Back to Top
|
Service Name |
User I/O Total Wts |
User I/O Wt Time |
Concurcy Total Wts |
Concurcy Wt Time |
Admin Total Wts |
Admin Wt Time |
Network Total Wts |
Network Wt Time |
|
SYS$USERS |
5454731 |
341302 |
3837 |
31 |
0 |
0 |
98959 |
1023 |
|
EXXX |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
SYS$BACKGROUND |
5915 |
531 |
5 |
8 |
0 |
0 |
0 |
0 |
Back to Wait Events Statistics
Back to Top
|
Elapsed Time (s) |
CPU Time (s) |
Executions |
Elap per Exec (s) |
% Total DB Time |
SQL Id |
SQL Module |
SQL Text |
|
1,781 |
248 |
63 |
28.27 |
44.19 |
|
SELECT
- SUM(NVL(AEL.ACCOUNTED... |
|
|
506 |
30 |
1 |
505.66 |
12.55 |
pmdtm.exe |
SELECT
XXDW_SALES_CORRECTION_D... |
|
|
491 |
29 |
1 |
491.48 |
12.20 |
pmdtm.exe |
SELECT
XXDW_SALES_CORRECTION_D... |
|
|
331 |
42 |
10 |
33.11 |
8.22 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
BEGIN
xxnt_atp_engine_wf_pkg.s... |
|
|
228 |
16 |
9 |
25.36 |
5.66 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
OH.HEADER_ID, OH.ORDER... |
|
|
215 |
22 |
27 |
7.96 |
5.33 |
XXEXT_B2C_ORDER_IF_MAIN
|
BEGIN
xxext_b2c_order_if_pkg.o... |
|
|
214 |
22 |
26 |
8.24 |
5.32 |
XXEXT_B2C_ORDER_IF_MAIN
|
SELECT
OH.*, IFL.ORDER_ACTION... |
|
|
174 |
7 |
60 |
2.90 |
4.31 |
JDBC Thin Client |
BEGIN
WF_EVENT.LISTEN ( p_ag... |
|
|
171 |
8 |
0 |
|
4.24 |
|
DECLARE job BINARY_INTEGER := ... |
|
|
169 |
8 |
0 |
|
4.20 |
|
DELETE FROM
XXMDM_ITEM_DEBUG_L... |
|
|
164 |
22 |
12 |
13.65 |
4.06 |
XXATP_ENGINE_RESERVATION_IF
|
BEGIN
XXATP_ATP_INTERFACES_PKG... |
|
|
148 |
17 |
12 |
12.33 |
3.67 |
XXATP_ENGINE_RESERVATION_IF
|
SELECT /*+ RULE */ R.RESERVATI... |
|
|
87 |
4 |
15 |
5.79 |
2.15 |
JDBC Thin Client |
select /*+
FIRST_ROWS(1) */ ... |
|
|
54 |
5 |
3 |
18.00 |
1.34 |
SQL*Plus |
SELECT /*+ ORDERED
INDEX( AEH... |
|
|
51 |
48 |
24,416 |
0.00 |
1.28 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
NVL(SUM(XXNT_ATP_ENGINE... |
Back to SQL Statistics
Back to Top
|
CPU Time (s) |
Elapsed Time (s) |
Executions |
CPU per Exec (s) |
% Total DB Time |
SQL Id |
SQL Module |
SQL Text |
|
248 |
1,781 |
63 |
3.94 |
44.19 |
|
SELECT
- SUM(NVL(AEL.ACCOUNTED... |
|
|
48 |
51 |
24,416 |
0.00 |
1.28 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
NVL(SUM(XXNT_ATP_ENGINE... |
|
|
42 |
331 |
10 |
4.18 |
8.22 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
BEGIN
xxnt_atp_engine_wf_pkg.s... |
|
|
30 |
506 |
1 |
30.06 |
12.55 |
pmdtm.exe |
SELECT
XXDW_SALES_CORRECTION_D... |
|
|
29 |
491 |
1 |
29.05 |
12.20 |
pmdtm.exe |
SELECT
XXDW_SALES_CORRECTION_D... |
|
|
22 |
215 |
27 |
0.81 |
5.33 |
XXEXT_B2C_ORDER_IF_MAIN
|
BEGIN
xxext_b2c_order_if_pkg.o... |
|
|
22 |
214 |
26 |
0.84 |
5.32 |
XXEXT_B2C_ORDER_IF_MAIN
|
SELECT
OH.*, IFL.ORDER_ACTION... |
|
|
22 |
164 |
12 |
1.81 |
4.06 |
XXATP_ENGINE_RESERVATION_IF
|
BEGIN
XXATP_ATP_INTERFACES_PKG... |
|
|
20 |
21 |
16,934 |
0.00 |
0.52 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
ST.ACTIVITY_STATUS FROM... |
|
|
17 |
148 |
12 |
1.46 |
3.67 |
XXATP_ENGINE_RESERVATION_IF
|
SELECT /*+ RULE */ R.RESERVATI... |
|
|
16 |
228 |
9 |
1.81 |
5.66 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
OH.HEADER_ID, OH.ORDER... |
|
|
8 |
171 |
0 |
|
4.24 |
|
DECLARE job BINARY_INTEGER := ... |
|
|
8 |
169 |
0 |
|
4.20 |
|
DELETE FROM
XXMDM_ITEM_DEBUG_L... |
|
|
7 |
174 |
60 |
0.12 |
4.31 |
JDBC Thin Client |
BEGIN
WF_EVENT.LISTEN ( p_ag... |
|
|
5 |
54 |
3 |
1.72 |
1.34 |
SQL*Plus |
SELECT /*+ ORDERED
INDEX( AEH... |
|
|
4 |
87 |
15 |
0.24 |
2.15 |
JDBC Thin Client |
select /*+
FIRST_ROWS(1) */ ... |
Back to SQL Statistics
Back to Top
|
Buffer Gets |
Executions |
Gets per Exec |
%Total |
CPU Time (s) |
Elapsed Time (s) |
SQL Id |
SQL Module |
SQL Text |
|
30,455,986 |
63 |
483,428.35 |
50.08 |
248.45 |
1780.84 |
|
SELECT
- SUM(NVL(AEL.ACCOUNTED... |
|
|
7,460,815 |
12 |
621,734.58 |
12.27 |
21.69 |
163.75 |
XXATP_ENGINE_RESERVATION_IF
|
BEGIN
XXATP_ATP_INTERFACES_PKG... |
|
|
7,406,005 |
12 |
617,167.08 |
12.18 |
17.49 |
147.99 |
XXATP_ENGINE_RESERVATION_IF
|
SELECT /*+ RULE */ R.RESERVATI... |
|
|
5,792,999 |
10 |
579,299.90 |
9.53 |
41.83 |
331.08 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
BEGIN
xxnt_atp_engine_wf_pkg.s... |
|
|
5,070,114 |
27 |
187,782.00 |
8.34 |
21.83 |
214.99 |
XXEXT_B2C_ORDER_IF_MAIN
|
BEGIN
xxext_b2c_order_if_pkg.o... |
|
|
5,069,223 |
26 |
194,970.12 |
8.34 |
21.80 |
214.37 |
XXEXT_B2C_ORDER_IF_MAIN
|
SELECT
OH.*, IFL.ORDER_ACTION... |
|
|
3,539,777 |
1 |
3,539,777.00 |
5.82 |
30.06 |
505.66 |
pmdtm.exe |
SELECT
XXDW_SALES_CORRECTION_D... |
|
|
3,539,777 |
1 |
3,539,777.00 |
5.82 |
29.05 |
491.48 |
pmdtm.exe |
SELECT
XXDW_SALES_CORRECTION_D... |
|
|
3,326,391 |
9 |
369,599.00 |
5.47 |
16.28 |
228.25 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
OH.HEADER_ID, OH.ORDER... |
|
|
1,409,850 |
24,416 |
57.74 |
2.32 |
48.50 |
51.44 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
NVL(SUM(XXNT_ATP_ENGINE... |
|
|
1,065,336 |
7,266 |
146.62 |
1.75 |
3.47 |
3.47 |
|
Select
R.Rowid From Fnd_Concur... |
|
|
1,043,557 |
49,734 |
20.98 |
1.72 |
17.46 |
18.09 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
X.ORGANIZATION_ID ORGAN... |
|
|
881,935 |
3 |
293,978.33 |
1.45 |
5.16 |
53.99 |
SQL*Plus |
SELECT /*+ ORDERED
INDEX( AEH... |
|
|
822,952 |
16,934 |
48.60 |
1.35 |
20.03 |
20.76 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
ST.ACTIVITY_STATUS FROM... |
|
|
787,315 |
0 |
|
1.29 |
8.23 |
170.99 |
|
DECLARE job BINARY_INTEGER := ... |
|
|
772,745 |
0 |
|
1.27 |
8.16 |
169.37 |
|
DELETE FROM
XXMDM_ITEM_DEBUG_L... |
Back to SQL Statistics
Back to Top
|
Physical Reads |
Executions |
Reads per Exec |
%Total |
CPU Time (s) |
Elapsed Time (s) |
SQL Id |
SQL Module |
SQL Text |
|
2,894,606 |
63 |
45,946.13 |
47.39 |
248.45 |
1780.84 |
|
SELECT
- SUM(NVL(AEL.ACCOUNTED... |
|
|
775,169 |
0 |
|
12.69 |
8.23 |
170.99 |
|
DECLARE job BINARY_INTEGER := ... |
|
|
767,931 |
0 |
|
12.57 |
8.16 |
169.37 |
|
DELETE FROM XXMDM_ITEM_DEBUG_L... |
|
|
540,271 |
12 |
45,022.58 |
8.84 |
21.69 |
163.75 |
XXATP_ENGINE_RESERVATION_IF
|
BEGIN
XXATP_ATP_INTERFACES_PKG... |
|
|
538,410 |
12 |
44,867.50 |
8.81 |
17.49 |
147.99 |
XXATP_ENGINE_RESERVATION_IF
|
SELECT /*+ RULE */ R.RESERVATI... |
|
|
469,396 |
27 |
17,385.04 |
7.68 |
21.83 |
214.99 |
XXEXT_B2C_ORDER_IF_MAIN
|
BEGIN
xxext_b2c_order_if_pkg.o... |
|
|
469,113 |
26 |
18,042.81 |
7.68 |
21.80 |
214.37 |
XXEXT_B2C_ORDER_IF_MAIN
|
SELECT
OH.*, IFL.ORDER_ACTION... |
|
|
374,909 |
1 |
374,909.00 |
6.14 |
30.06 |
505.66 |
pmdtm.exe |
SELECT
XXDW_SALES_CORRECTION_D... |
|
|
352,268 |
1 |
352,268.00 |
5.77 |
29.05 |
491.48 |
pmdtm.exe |
SELECT
XXDW_SALES_CORRECTION_D... |
|
|
297,916 |
10 |
29,791.60 |
4.88 |
41.83 |
331.08 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
BEGIN
xxnt_atp_engine_wf_pkg.s... |
|
|
259,627 |
9 |
28,847.44 |
4.25 |
16.28 |
228.25 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
OH.HEADER_ID, OH.ORDER... |
|
|
125,592 |
60 |
2,093.20 |
2.06 |
7.25 |
173.81 |
JDBC Thin Client |
BEGIN
WF_EVENT.LISTEN ( p_ag... |
|
|
98,865 |
3 |
32,955.00 |
1.62 |
5.16 |
53.99 |
SQL*Plus |
SELECT /*+ ORDERED
INDEX( AEH... |
|
|
64,819 |
2 |
32,409.50 |
1.06 |
0.83 |
11.25 |
pmdtm.exe |
BEGIN
XXDW_TRANSFER_PKG.ST... |
|
|
64,381 |
2 |
32,190.50 |
1.05 |
0.78 |
10.95 |
pmdtm.exe |
SELECT
* FROM XXDW_TRANSFER_LO... |
|
|
62,604 |
15 |
4,173.60 |
1.02 |
3.57 |
86.84 |
JDBC Thin Client |
select /*+
FIRST_ROWS(1) */ ... |
Back to SQL Statistics
Back to Top
|
Executions |
Rows Processed |
Rows per Exec |
CPU per Exec (s) |
Elap per Exec (s) |
SQL Id |
SQL Module |
SQL Text |
|
49,734 |
96,812 |
1.95 |
0.00 |
0.00 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
X.ORGANIZATION_ID ORGAN... |
|
|
24,416 |
24,417 |
1.00 |
0.00 |
0.00 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
NVL(SUM(XXNT_ATP_ENGINE... |
|
|
16,934 |
12,208 |
0.72 |
0.00 |
0.00 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
ST.ACTIVITY_STATUS FROM... |
|
|
14,194 |
4,353 |
0.31 |
0.00 |
0.00 |
? @xxx2 (TNS V1-V3) |
SELECT
PROFILE_OPTION_VALUE FR... |
|
|
12,213 |
12,213 |
1.00 |
0.00 |
0.00 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
NVL(SUM(R.RESERVATION_Q... |
|
|
12,208 |
12,208 |
1.00 |
0.00 |
0.00 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
SO.SALES_ORDER_ID FROM ... |
|
|
10,701 |
10,701 |
1.00 |
0.00 |
0.00 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
* FROM MTL_SYSTEM_ITEMS... |
|
|
10,696 |
10,696 |
1.00 |
0.00 |
0.00 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT DECODE(EFFECTIVITY_CONT... |
|
|
9,931 |
9,922 |
1.00 |
0.00 |
0.00 |
|
select (RUNNING_PROCESSES-MAX_... |
|
|
9,177 |
9,032 |
0.98 |
0.00 |
0.00 |
|
select type#, blocks,
extents,... |
|
|
8,136 |
7,484 |
0.92 |
0.00 |
0.00 |
? @xxx2 (TNS V1-V3) |
SELECT
PROFILE_OPTION_ID, APP... |
|
|
7,266 |
0 |
0.00 |
0.00 |
0.00 |
|
Select
R.Rowid From Fnd_Concur... |
|
|
5,347 |
512 |
0.10 |
0.00 |
0.00 |
? @xxx2 (TNS V1-V3) |
SELECT
PROFILE_OPTION_VALUE FR... |
Back to SQL Statistics
Back to Top
|
Parse Calls |
Executions |
% Total Parses |
SQL Id |
SQL Module |
SQL Text |
|
9,176 |
9,177 |
14.10 |
|
select type#, blocks, extents,... |
|
|
2,020 |
2,022 |
3.10 |
|
select privilege#,
level from ... |
|
|
1,846 |
1,846 |
2.84 |
FNDRSRUN |
begin :con :=
XXNT_AP_EXPINV_A... |
|
|
933 |
933 |
1.43 |
|
update obj$ set obj#=:6,
type#... |
|
|
876 |
876 |
1.35 |
XXATP_ENGINE_RESERVATION_IF
|
SELECT
* FROM ( SELECT Nvl(a.d... |
|
|
817 |
817 |
1.26 |
|
update seg$ set type#=:4,
bloc... |
|
|
637 |
8,136 |
0.98 |
? @xxx2 (TNS V1-V3) |
SELECT
PROFILE_OPTION_ID, APP... |
|
|
627 |
5,347 |
0.96 |
? @xxx2 (TNS V1-V3) |
SELECT
PROFILE_OPTION_VALUE FR... |
|
|
596 |
14,194 |
0.92 |
? @xxx2 (TNS V1-V3) |
SELECT
PROFILE_OPTION_VALUE FR... |
|
|
586 |
586 |
0.90 |
|
select STATSTYPE# from
USTATS$... |
Back to SQL Statistics
Back to Top
|
Sharable Mem (b) |
Executions |
% Total |
SQL Id |
SQL Module |
SQL Text |
|
2,791,316 |
0 |
0.19 |
|
SELECT
flv1.meaning invoice_ty... |
|
|
2,031,814 |
26 |
0.14 |
XXEXT_B2C_ORDER_IF_MAIN
|
SELECT
OH.*, IFL.ORDER_ACTION... |
|
|
2,021,529 |
12 |
0.14 |
XXATP_ENGINE_RESERVATION_IF
|
select i.segment1,
p.organiza... |
|
|
1,482,960 |
15 |
0.10 |
XXNT_ATP_ENGINE_SO_RESERVATION
|
SELECT
X.ORGANIZATION_ID ORGAN... |
|
|
1,319,023 |
16 |
0.09 |
FNDRSSUB |
INSERT
INTO FND_CONCURRENT_REQ... |
Back to SQL Statistics
Back to Top
|
Version Count |
Executions |
SQL Id |
SQL Module |
SQL Text |
|
61 |
12 |
XXATP_ENGINE_RESERVATION_IF
|
select i.segment1,
p.organiza... |
|
|
39 |
10 |
XXATP_ENGINE_ATP_IF |
insert into atp_atp_if@DB
(... |
|
|
31 |
15 |
XXATP_ENGINE_ATP_IF |
select max(1) from
atp_atp_if@... |
Back to SQL Statistics
Back to Top
|
SQL Id |
SQL Text |
|
BEGIN
XXDW_TRANSFER_PKG.START_GL_TRANSACTIONS (:1) ; END; |
|
|
select
privilege#, level from sysauth$ connect by grantee#=prior privilege# and
privilege#>0 start with grantee#=:1 and privilege#>0 |
|
|
SELECT
* FROM MTL_SYSTEM_ITEMS WHERE ORGANIZATION_ID = :B2 AND INVENTORY_ITEM_ID =
:B1 |
|
|
SELECT
NVL(SUM(XXNT_ATP_ENGINE_WF_PKG.GET_ATR_QTY(:B2 , :B1 ,
SECONDARY_INVENTORY_NAME, NULL, NULL)), 0) FROM MTL_SECONDARY_INVENTORIES
WHERE RESERVABLE_TYPE=1 AND INVENTORY_ATP_CODE=1 AND ORGANIZATION_ID=:B1 |
|
|
Select
R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And
R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate AND EXISTS (
Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And
R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id =
P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O
Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From
Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id =
C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID,
R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0,
31757))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((20024,
515331), (20024, 517331), (20024, 517332), (20024, 517334), (20024,
517335)))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID,
R.Request_ID |
|
|
SELECT
* FROM XXDW_TRANSFER_LOG WHERE DECODE(LAST_UPDATE_DATE, NULL, CREATION_DATE,
LAST_UPDATE_DATE) >= (SYSDATE - :B2 ) AND ENTITY = :B1 AND TRANSFER_FLAG =
1 FOR UPDATE SKIP LOCKED |
|
|
select
(RUNNING_PROCESSES-MAX_PROCESSES) , MAX_PROCESSES , NVL(SLEEP_SECONDS, 0) ,
DIAGNOSTIC_LEVEL into :b0, :b1, :b2, :b3:b4 from FND_CONCURRENT_QUEUES where
((APPLICATION_ID=:b5 and CONCURRENT_QUEUE_ID=:b6) and (TARGET_NODE=:b7 or
(TARGET_NODE is null and :b7 is null ))) |
|
|
select
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 |
|
|
INSERT
INTO FND_CONCURRENT_REQUESTS ( REQUEST_ID, SECURITY_GROUP_ID, PHASE_CODE,
STATUS_CODE, PRIORITY, PARENT_REQUEST_ID, PRIORITY_REQUEST_ID, DESCRIPTION,
REQ_INFORMATION, IS_SUB_REQUEST, HAS_SUB_REQUEST, UPDATE_PROTECTED,
HOLD_FLAG, ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG,
ARGUMENT_INPUT_METHOD_CODE, IMPLICIT_CODE, REQUEST_DATE,
REQUESTED_START_DATE, REQUESTED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
LAST_UPDATE_LOGIN, ORACLE_ID, CONC_LOGIN_ID, RESPONSIBILITY_ID,
RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE, NLS_TERRITORY,
NLS_NUMERIC_CHARACTERS, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID,
QUEUE_METHOD_CODE, REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID,
PRINT_GROUP, PRINTER, PRINT_STYLE, NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG,
CRM_THRSHLD, RESUBMIT_TIME, RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE,
RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_END_DATE, RESUBMITTED, CRITICAL,
REQUEST_TYPE, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, STALE_DATE,
CANCEL_OR_HOLD, OUTPUT_FILE_TYPE, NLS_COMPLIANT, CD_ID, REQUEST_LIMIT,
INCREMENT_DATES, ENABLE_TRACE, OPS_INSTANCE, ARGUMENT_TEXT,
NUMBER_OF_ARGUMENTS, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5,
ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10, ARGUMENT11,
ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15, ARGUMENT16, ARGUMENT17,
ARGUMENT18, ARGUMENT19, ARGUMENT20, ARGUMENT21, ARGUMENT22, ARGUMENT23,
ARGUMENT24, ARGUMENT25) SELECT :B73 , :B72 , :B71 , DECODE (:B70 , 'A', 'A',
'Z', 'Z', DECODE(FCP.QUEUE_METHOD_CODE, 'B', 'Q', DECODE (:B52 , 'Y', 'Q',
DECODE(:B33 , 'Y', 'Q', 'I')))), DECODE (FCP.QUEUE_CONTROL_FLAG, 'Y',
NVL(FCP.REQUEST_PRIORITY, 0), DECODE (:B69 , NULL, 50, :B69 )), DECODE (:B61
, 0, NULL, :B61 ), :B68 , :B67 , NULL, :B66 , 'N', :B65 , :B64 , 'Y', :B52 ,
'S', :B63 , SYSDATE, DECODE (:B62 , '', (SYSDATE - :B60 ), GREATEST (:B62 ,
DECODE (:B61 , 0, (SYSDATE - :B60 ), FND_CONC_DATE.STRING_TO_DATE (
'01-01-0001')))), :B59 , SYSDATE, :B59 , :B58 , ORACLE_ID, :B58 , :B57 , :B56
, :B55 , :B54 , :B53 , FA.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID,
DECODE(:B33 , 'Y', 'B', DECODE(:B52 , 'N', FCP.QUEUE_METHOD_CODE, 'B')),
FCP.CLASS_APPLICATION_ID, FCP.CONCURRENT_CLASS_ID, :B51 , :B50 , :B49 , :B48
, :B47 , :B46 , DECODE (:B45 , '', NULL, TO_CHAR
(FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001' || :B45 ), 'HH24:MI:SS')),
DECODE (:B44 , '', NULL, :B44 ), :B43 , :B42 , :B41 , 'N', :B40 , :B39 , :B38
, :B37 , :B36 , :B35 , FCP.OUTPUT_FILE_TYPE, FCP.NLS_COMPLIANT, :B34 , :B33 ,
:B32 , FCP.ENABLE_TRACE, :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 ,
:B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 ,
:B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 FROM
FND_APPLICATION FA, FND_CONCURRENT_PROGRAMS FCP, FND_ORACLE_USERID WHERE
ORACLE_USERNA ME = :B3 AND FCP.ENABLED_FLAG = 'Y' AND (FCP.APPLICATION_ID =
FA.APPLICATION_ID AND CONCURRENT_PROGRAM_NAME = UPPER (:B2 )) AND
FA.APPLICATION_SHORT_NAME = UPPER (:B1 ) |
|
|
DECLARE
job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :=
FALSE; BEGIN APPS.XXMDM_ITEM.PURGE; :mydate := next_date; IF broken THEN :b
:= 1; ELSE :b := 0; END IF; END; |
|
|
SELECT
NVL(SUM(R.RESERVATION_QUANTITY), 0) FROM MTL_RESERVATIONS R WHERE
R.ORGANIZATION_ID=:B3 AND R.DEMAND_SOURCE_LINE_ID=:B2 AND
R.DEMAND_SOURCE_HEADER_ID=:B1 AND R.DEMAND_SOURCE_TYPE_ID IN (2, 8) |
|
|
SELECT OH.HEADER_ID,
OH.ORDER_NUMBER, OH.ORDER_TYPE_ID, TT.NAME AS ORDER_TYPE,
NVL(OH.FREIGHT_TERMS_CODE, 'N/A') AS FREIGHT_TERMS_CODE, (SELECT NAME FROM
OE_ORDER_SOURCES WHERE ORDER_SOURCE_ID=OH.ORDER_SOURCE_ID) AS ORDER_SOURCE,
OH.ORIG_SYS_DOCUMENT_REF AS EXT_ORDER_NUM, OL.LINE_ID, OL.LINE_NUMBER,
OL.SHIPMENT_NUMBER, OL.SHIP_FROM_ORG_ID AS ORGANIZATION_ID,
OL.INVENTORY_ITEM_ID, OL.ORDERED_ITEM, OL.ORDERED_QUANTITY,
MTP.ORGANIZATION_CODE FROM OE_ORDER_LINES_ALL OL, OE_ORDER_HEADERS_ALL OH,
OE_TRANSACTION_TYPES_TL TT, MTL_PARAMETERS MTP WHERE OL.ORG_ID=:B4 AND
OL.OPEN_FLAG='Y' AND OL.HEADER_ID=OH.HEADER_ID AND OL.FLOW_STATUS_CODE IN ('BOOKED',
'AWAITING_SHIPPING') AND OH.OPEN_FLAG='Y' AND
TT.TRANSACTION_TYPE_ID=OH.ORDER_TYPE_ID AND TT.LANGUAGE='US' AND
OL.SHIP_FROM_ORG_ID=MTP.ORGANIZATION_ID AND NVL(MTP.ATTRIBUTE11, 'N')='Y' AND
NVL(:B3 , OH.ORDER_TYPE_ID)=OH.ORDER_TYPE_ID AND
NVL(:B2 , OL.SHIP_FROM_ORG_ID)=OL.SHIP_FROM_ORG_ID AND NVL(:B1 ,
OH.HEADER_ID)=OH.HEADER_ID ORDER BY OH.CREATION_DATE, OH.ORDER_NUMBER,
OL.LINE_NUMBER, OL.SHIPMENT_NUMBER |
|
|
SELECT
ST.ACTIVITY_STATUS FROM WF_ITEM_ACTIVITY_STATUSES ST, WF_PROCESS_ACTIVITIES
PRA WHERE ST.ITEM_KEY=TO_CHAR(:B1 ) AND ST.PROCESS_ACTIVITY=PRA.INSTANCE_ID
AND ST.ITEM_TYPE='OEOL' AND PRA.ACTIVITY_NAME='XXNT_CHECK_LINE_RESERVATION' |
|
|
SELECT
PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID =
:B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND
LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL |
|
|
BEGIN
XXATP_ATP_INTERFACES_PKG.reservation_if_main( :errbuf, :rc, :A0, :A1, :A2);
END; |
|
|
SELECT
OH.*, IFL.ORDER_ACTION FROM OE_ORDER_HEADERS_V OH, XXEXT.XXEXT_ORDER_IF_LOG
IFL WHERE OH.ORG_ID=:B3 AND OH.ORDER_TYPE_ID=:B2 AND
OH.ORDER_SOURCE_ID=(SELECT ORDER_SOURCE_ID FROM OE_ORDER_SOURCES WHERE
NAME='HYBRIS-B2C') AND OH.HEADER_ID=IFL.HEADER_ID AND IFL.STATUS_FLAG='x' AND
NVL(:B1 , OH.HEADER_ID)=OH.HEADER_ID AND IFL.DIRECTION='OUT' AND
IFL.ORDER_ACTION IN ('NEW', 'CHANGE', 'CANCEL', 'NOP') AND
OH.FLOW_STATUS_CODE IN ('BOOKED', 'CANCELLED', 'CLOSED') AND OH.ATTRIBUTE4 IS
NULL UNION ALL SELECT OH.*, DECODE(OH.FLOW_STATUS_CODE, 'CANCELLED',
'CANCEL', 'CHANGE') AS ORDER_ACTION FROM OE_ORDER_HEADERS_V OH,
XXEXT.XXEXT_ORDER_IF_LOG IFL WHERE OH.ORG_ID=:B3 AND OH.ORDER_TYPE_ID=:B2 AND
OH.ORDER_SOURCE_ID=(SELECT ORDER_SOURCE_ID FROM OE_ORDER_SOURCES WHERE
NAME='HYBRIS-B2C') AND (OH.LAST_UPDATE_DATE>IFL.LAST_UPDATE_DATE OR
(SELECT MAX(OL.LAST_UPDATE_DATE) FROM OE_ORDER_LINES_ALL OL WHERE
OL.HEADER_ID=OH.HEADER_ID)>IFL.LAST_UPDATE_DATE OR (SELECT
MAX(DD.LAST_UPDATE_DATE) FROM WSH_DELIVERY_DETAILS DD, OE_ORDER_LINES_ALL OL
WHERE OL.HEADER_ID=OH.HEADER_ID AND
OL.LINE_ID=DD.SOURCE_LINE_ID)>IFL.LAST_UPDATE_DATE OR (SELECT
MAX(DA.LAST_UPDATE_DATE) FROM WSH_DELIVERY_ASSIGNMENTS DA, WSH_DELIVERY_DETAILS
DD, OE_ORDER_LINES_ALL OL WHERE OL.HEADER_ID=OH.HEADER_ID AND
OL.LINE_ID=DD.SOURCE_LINE_ID AND
DA.DELIVERY_DETAIL_ID=DD.DELIVERY_DETAIL_ID)>IFL.LAST_UPDATE_DATE OR
(SELECT MAX(DL.LAST_UPDATE_DATE) FROM WSH_DELIVERY_ASSIGNMENTS DA, WSH_DELIVERY_DETAILS
DD, WSH_DE LIVERY_LEGS DL, OE_ORDER_LINES_ALL OL WHERE
OL.HEADER_ID=OH.HEADER_ID AND OL.LINE_ID=DD.SOURCE_LINE_ID AND
DA.DELIVERY_DETAIL_ID=DD.DELIVERY_DETAIL_ID AND
DA.DELIVERY_ID=DL.DELIVERY_ID)>IFL.LAST_UPDATE_DATE OR (SELECT MAX(D.LAST_UPDATE_DATE)
FROM WSH_DELIVERY_ASSIGNMENTS DA, WSH_DELIVERY_DETAILS DD, WSH_NEW_DELIVERIES
D, OE_ORDER_LINES_ALL OL WHERE OL.HEADER_ID=OH.HEADER_ID AND
OL.LINE_ID=DD.SOURCE_LINE_ID AND DA.DELIVERY_DETAIL_ID=DD.DELIVERY_DETAIL_ID
AND DA.DELIVERY_ID=D.DELIVERY_ID)>IFL.LAST_UPDATE_DATE OR (SELECT
MAX(TRXL.LAST_UPDATE_DATE) FROM RA_CUSTOMER_TRX_LINES_ALL TRXL,
OE_ORDER_LINES_ALL OL WHERE OL.HEADER_ID=OH.HEADER_ID AND
TO_CHAR(OL.LINE_ID)=TRXL.INTERFACE_LINE_ATTRIBUTE6)>IFL.LAST_UPDATE_DATE
OR :B1 =OH.HEADER_ID ) AND OH.HEADER_ID=IFL.HEADER_ID AND IFL.STATUS_FLAG='P'
AND IFL.ORDER_ACTION IN ('NEW', 'CHANGE') AND OH.FLOW_STATUS_CODE IN
('BOOKED', 'CANCELLED', 'CLOSED') AND OH.ATTRIBUTE4 IS NULL UNION ALL SELECT
OH.*, DECODE(OH.FLOW_STATUS_CODE, 'CANCELLED', 'CANCEL', 'CHANGE') AS
ORDER_ACTION FROM OE_ORDER_HEADERS_V OH WHERE OH.ORG_ID=:B3 AND
OH.ORDER_TYPE_ID=:B2 AND :B1 =OH.HEADER_ID AND OH.FLOW_STATUS_CODE IN
('BOOKED', 'CANCELLED', 'CLOSED') AND OH.ATTRIBUTE4 IS NULL AND NOT EXISTS
(SELECT * FROM XXEXT.XXEXT_ORDER_IF_LOG IFL WHERE OH.HEADER_ID=IFL.HEADER_ID
AND IFL.STATUS_FLAG='x') ORDER BY 5 |
|
|
SELECT
PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID =
:B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE
IS NOT NULL |
|
|
SELECT
SO.SALES_ORDER_ID FROM MTL_SALES_ORDERS SO WHERE SO.SEGMENT1 = TO_CHAR(:B2 )
AND SO.SEGMENT2 = :B1 AND SO.SEGMENT3 = 'ORDER ENTRY' |
|
|
SELECT
XXDW_SALES_CORRECTION_DATA_V.ORGANISATION_CODE, XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_DATE,
XXDW_SALES_CORRECTION_DATA_V.ITEM_CODE,
XXDW_SALES_CORRECTION_DATA_V.SHIP_FROM_ORGANISATION_CODE,
XXDW_SALES_CORRECTION_DATA_V.SHIP_TO_CUSTOMER_SITE_REF,
XXDW_SALES_CORRECTION_DATA_V.BILL_TO_CUSTOMER_SITE_REF, XXDW_SALES_CORRECTION_DATA_V.SALES_REPRESENTATIVE_CODE,
XXDW_SALES_CORRECTION_DATA_V.CORRECTION_TYPE,
XXDW_SALES_CORRECTION_DATA_V.ORDER_TYPE,
XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_CURRENCY_CODE,
XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_AMOUNT, XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_QUANTITY,
XXDW_SALES_CORRECTION_DATA_V.TRX_NUMBER FROM XXDW_SALES_CORRECTION_DATA_V
WHERE XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_DATE >=
to_date('2017-01-01', 'YYYY-MM-DD') AND
XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_DATE >=
trunc((Last_Day(ADD_MONTHS(SYSDATE, -2)) + 1)) -- Current + previous month |
|
|
SELECT flv1.meaning
invoice_type -- тип документа , decode(:p_group, 'P', flv1.meaning, NULL)
invoice_type_g -- тип документа , ai.invoice_date --дата
документа , ai.invoice_num --номер документа , ai.invoice_currency_code
--валюта документа , pv.vendor_name --наименование поставщика , pv.segment1
vendor_num --номер поставщика , pv.segment1 vendor_num_g --номер поставщика ,
ai.invoice_amount -- сумма в валюте документа , aps.amount_remaining
--неоплаченная сумма , aps.due_date -- срок оплаты , NVL (ai.base_amount,
ai.invoice_amount) base_amount --сумма документа в функциональной валюте ,
pv.vendor_id , (select u.user_name from fnd_user u where u.user_id =
ai.created_by) as user_name -->> Andrey Xxx |
|
|
select STATSTYPE# from
USTATS$ where OBJ# = :1 and INTCOL# = :2 |
|
|
SELECT * FROM ( SELECT
Nvl(a.demand_source_name, b.demand_source_name) demand_source_name, Nvl(a.reserved_quantity,
0) reserved_quantity, Nvl(b.reserved_quantity, 0)
reserved_quantity_old FROM (SELECT v.tag||decode(r.state, 'S',
r.demand_source_id, 'T', 'temp') as demand_source_name,
sum(r.reserved_quantity) reserved_quantity FROM atp_reservation_details_v@RUWDB
r, fnd_lookup_values v WHERE v.view_application_id=700 AND
v.lookup_type='XX_ATP_ENGINE_INSTANCES' AND v.enabled_flag='Y' AND
v.LANGUAGE='US' AND v.lookup_code = r.INSTANCE AND r.item=:1 AND
r.organization_code=:2 GROUP BY v.tag||decode(r.state, 'S',
r.demand_source_id, 'T', 'temp')) a full OUTER JOIN (SELECT
r.demand_source_name, Sum(r.reservation_quantity) reserved_quantity FROM
mtl_reservations r WHERE r.demand_source_type_id = 13 AND r.inventory_item_id
= :3 AND r.organization_id = :4 AND EXISTS (SELECT 1
FROM fnd_lookup_values_vl WHERE view_application_id=700 AND
lookup_type='XX_ATP_ENGINE_INSTANCES' AND enabled_flag='Y' AND
r.demand_source_name LIKE tag||'%') GROUP BY r.demand_source_name) b ON
(a.demand_source_name=b.demand_source_name) ) WHERE reserved_quantity !=
reserved_quantity_old |
|
|
update
seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9,
extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13),
groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16,
spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and
block#=:3 |
|
|
DELETE
FROM XXMDM_ITEM_DEBUG_LOG WHERE PROCESS_DATE < (SYSDATE - :B1 ) |
|
|
select
i.segment1, p.organization_code, i.inventory_item_id, i.organization_id from
mtl_system_items i, mtl_parameters p, (select distinct item,
organization_code from atp_reserve_log@RUWDB) l where l.organization_code =
p.organization_code and l.item = i.segment1 and i.organization_id =
p.organization_id group by i.segment1 , p.organization_code,
i.inventory_item_id, i.organization_id |
|
|
SELECT
XXDW_SALES_CORRECTION_DATA_V.ORGANISATION_CODE,
XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_DATE,
XXDW_SALES_CORRECTION_DATA_V.ITEM_CODE,
XXDW_SALES_CORRECTION_DATA_V.SHIP_FROM_ORGANISATION_CODE,
XXDW_SALES_CORRECTION_DATA_V.SHIP_TO_CUSTOMER_SITE_REF,
XXDW_SALES_CORRECTION_DATA_V.BILL_TO_CUSTOMER_SITE_REF,
XXDW_SALES_CORRECTION_DATA_V.SALES_REPRESENTATIVE_CODE,
XXDW_SALES_CORRECTION_DATA_V.CORRECTION_TYPE,
XXDW_SALES_CORRECTION_DATA_V.ORDER_TYPE,
XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_CURRENCY_CODE,
XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_AMOUNT,
XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_QUANTITY,
XXDW_SALES_CORRECTION_DATA_V.TRX_NUMBER FROM XXDW_SALES_CORRECTION_DATA_V
WHERE XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_DATE >=
to_date('2017-01-01', 'YYYY-MM-DD') AND
XXDW_SALES_CORRECTION_DATA_V.TRANSACTION_DATE >=
trunc((Last_Day(ADD_MONTHS(SYSDATE, -2)) + 1)) -- Current + previous month |
|
|
select /*+
FIRST_ROWS(1) */ tab.rowid, tab.msgid, tab.corrid, tab.priority, tab.delay,
tab.expiration, tab.retry_count, tab.exception_qschema, tab.exception_queue,
tab.chain_no, tab.local_order_no, tab.enq_time, tab.time_manager_info,
tab.state, tab.enq_tid, tab.step_no, tab.sender_name, tab.sender_address,
tab.sender_protocol, tab.dequeue_msgid, tab.user_pxxx, tab.user_data from
"APPLSYS"."WF_DEFERRED" tab,
"APPLSYS"."AQ$_WF_DEFERRED_I" iot where (iot.subscriber# = :1 and iot.name = :2 and iot.queue# = :3) and
iot.msg_priority = tab.priority and iot.msg_enq_time = tab.enq_time and
iot.msg_step_no = tab.step_no and iot.msg_chain_no = tab.chain_no and
iot.msg_local_order_no = tab.local_order_no and tab.corrid like :4 and
tab.msgid = iot.msgid |
|
|
SELECT
PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG ,
RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG ,
SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE,
USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME =
UPPER(:B1 ) AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE,
SYSDATE) >= SYSDATE |
|
|
insert
into atp_atp_if@RUWDB (organization_code, item, atp_value, status_flag,
can_reserve, creation_date, created_by, last_update_date, last_updated_by,
run_id) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10) |
|
|
update
obj$ set obj#=:6, type#=:7, ctime=:8, mtime=:9, stime=:10, status=:11,
dataobj#=:13, flags=:14, oid$=:15, spare1=:16, spare2=:17 where owner#=:1 and
name=:2 and namespace=:3 and(remoteowner=:4 or remoteowner is null and :4 is
null)and(linkname=:5 or linkname is null and :5 is null)and(subname=:12 or
subname is null and :12 is null) |
|
|
SELECT
/*+ RULE */ R.RESERVATION_ID, OH.HEADER_ID, S.NAME SOURCE_NAME,
OH.ORIG_SYS_DOCUMENT_REF, R.DEMAND_SOURCE_NAME, R.INVENTORY_ITEM_ID,
R.ORGANIZATION_ID, I.SEGMENT1 AS ITEM, P.ORGANIZATION_CODE, V.LOOKUP_CODE
INSTANCE, (SELECT SUM(ORDERED_QUANTITY - NVL(SHIPPED_QUANTITY, 0) -
NVL((SELECT SUM(RESERVATION_QUANTITY) FROM MTL_RESERVATIONS WHERE
DEMAND_SOURCE_TYPE_ID=2 AND DEMAND_SOURCE_LINE_ID = OL.LINE_ID), 0)) Q FROM
OE_ORDER_LINES_ALL OL WHERE OL.HEADER_ID = OH.HEADER_ID AND
OL.INVENTORY_ITEM_ID = R.INVENTORY_ITEM_ID AND OL.SHIP_FROM_ORG_ID =
R.ORGANIZATION_ID) Q FROM MTL_RESERVATIONS R, MTL_PARAMETERS P,
FND_LOOKUP_VALUES_VL V, MTL_SYSTEM_ITEMS I, OE_ORDER_HEADERS_ALL OH,
OE_ORDER_SOURCES S WHERE V.LOOKUP_TYPE = 'XX_ATP_ENGINE_INSTANCES' AND V.VIEW_APPLICATION_ID=700
AND V.DESCRIPTION = S.NAME AND R.DEMAND_SOURCE_NAME LIKE V.TAG||'%' AND
OH.ORDER_SOURCE_ID = S.ORDER_SOURCE_ID AND OH.ORIG_SYS_DOCUMENT_REF =
SUBSTR(R.DEMAND_SOURCE_NAME, LENGTH(V.TAG)+1) AND P.ORGANIZATION_ID =
R.ORGANIZATION_ID AND I.INVENTORY_ITEM_ID = R.INVENTORY_ITEM_ID AND
I.ORGANIZATION_ID = R.ORGANIZATION_ID AND 0>=(SELECT SUM(ORDERED_QUANTITY
- NVL(SHIPPED_QUANTITY, 0) - NVL((SELECT SUM(RESERVATION_QUANTITY) FROM
MTL_RESERVATIONS WHERE DEMAND_SOURCE_TYPE_ID=2 AND DEMAND_SOURCE_LINE_ID =
OL.LINE_ID), 0)) Q FROM OE_ORDER_LINES_ALL OL WHERE OL.HEADER_ID =
OH.HEADER_ID AND OL.INVENTORY_ITEM_ID = R.INVENTORY_ITEM_ID AND
OL.SHIP_FROM_ORG_ID = R.ORGANIZATION_ID) |
|
|
begin
:con := XXNT_AP_EXPINV_ATTACH_PKG.RLS_PREDICATE(:sn, :on); end; |
|
|
BEGIN
xxnt_atp_engine_wf_pkg.submit_request( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4,
:A5, :A6, :A7); END; |
|
|
SELECT
/*+ ORDERED INDEX( AEH PAYMENTS_HEADERS_U1) */ SUM(NVL(AEL.ACCOUNTED_DR, 0.0)
- NVL(AEL.ACCOUNTED_CR, 0.0) ) FROM PAYMENTS_HEADERS AEH, PAYMENTS_LINES AEL
WHERE AEL.AE_HEADER_ID = AEH.AE_HEADER_ID AND AEH.ACCOUNTING_DATE >=
'01-JAN-2017' AND AEH.ACCOUNTING_DATE <= '31-OCT-2018' AND
AEL.AE_LINE_TYPE_CODE IN ( 'LIABILITY', 'PREPAY' ) AND AEL.THIRD_PARTY_ID =
2390 |
|
|
SELECT
DECODE(EFFECTIVITY_CONTROL , 2 , 'Y' , 'N') FROM MTL_SYSTEM_ITEMS WHERE
INVENTORY_ITEM_ID = :B2 AND ORGANIZATION_ID = :B1 |
|
|
select
max(1) from atp_atp_if@DB where 1=0 |
|
|
SELECT
X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,
X.REVISION REVISION , NULL LOT_NUMBER , NULL LOT_EXPIRATION_DATE ,
X.SUBINVENTORY_CODE SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE ,
X.LOCATOR_ID LOCATOR_ID , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.QUANTITY_TYPE
QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID FROM ( SELECT
X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,
DECODE(:B10 , 2, NULL , X.REVISION) REVISION , NULL LOT_NUMBER ,
X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID ,
SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE ,
X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID FROM ( SELECT
MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,
MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE
SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID ,
MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0)
PRIMARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID
LPN_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13
AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND
((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR
(:B6 = 3 AND NOT (:B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 =
MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) =
NVL(MR.DEMAND_SOURCE_LINE_ID, -9999) AND NVL(:B2 , '@@@###@@#') =
NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) =
NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) )) UNION ALL SELECT
MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE
SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID ,
MOQ.PRIMARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID
COST_GROUP_ID , MOQ.LPN_ID LPN_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION
ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID
INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER ,
MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID ,
DECODE(MMTT.TRANSACTION_STATUS, 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1,
-1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) *
ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, 5,
1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID ,
NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID FROM
MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND
MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0)
<> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND
MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34) ) AND
MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT
DECODE(MMTT.TRANSACTION_ACTION_ID , 3, MMTT.TRANSFER_ORGANIZATION ,
MMTT.ORGANIZATION_ID) ORGANIZATION_ID , MMTT.IN VENTORY_ITEM_ID
INVENTORY_ITEM_ID , MMTT.REVISION REVISION , NULL LOT_NUMBER ,
MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION
LOCATOR_ID , ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , 1 QUANTITY_TYPE ,
MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID,
MMTT.TRANSFER_LPN_ID) LPN_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE
MMTT.POSTING_FLAG = 'Y' AND NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 AND
MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) AND MMTT.WIP_SUPPLY_TYPE IS NULL ) X
WHERE X.ORGANIZATION_ID = :B9 AND X.INVENTORY_ITEM_ID = :B8 GROUP BY
X.ORGANIZATION_ID, X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER,
X.SUBINVENTORY_CODE, X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID,
X.LPN_ID ) X , MTL_SECONDARY_INVENTORIES SUB WHERE X.ORGANIZATION_ID =
SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE =
SUB.SECONDARY_INVENTORY_NAME (+) AND (:B12 = 2 OR NVL(SUB.ASSET_INVENTORY, 1)
= 1) AND ((:B11 =1 AND NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 ) OR (:B11 = 2 AND
NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B11 =3 OR (:B11 = 4 AND
(NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1)=1)) ) |
|
|
BEGIN
WF_EVENT.LISTEN ( p_agent_name => :1, p_wait => :2, p_correlation =>
:3, p_deq_condition => null, p_message_count => :4, p_max_error_count
=> :5 ); END; |
|
|
SELECT
- SUM(NVL(AEL.ACCOUNTED_DR, 0.0) - NVL(AEL.ACCOUNTED_CR, 0.0) ) FROM PAYMENTS_LINES
AEL, PAYMENTS_HEADERS AEH WHERE AEL.AE_HEADER_ID = AEH.AE_HEADER_ID AND (:b1
IS NULL OR AEH.ACCOUNTING_DATE >= FND_DATE.CANONICAL_TO_DATE(:b1) ) AND
(:b3 IS NULL OR AEH.ACCOUNTING_DATE <= FND_DATE.CANONICAL_TO_DATE(:b3) )
AND AEL.AE_LINE_TYPE_CODE IN ( 'LIABILITY', 'PREPAY' ) AND AEL.THIRD_PARTY_ID
= :b5 |
|
|
SELECT X.ORGANIZATION_ID ORGANIZATION_ID
, X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER
LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE
SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCATOR_ID
LOCATOR_ID , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.QUANTITY_TYPE
QUANTITY_TYPE , X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID FROM ( SELECT
X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,
DECODE(:B10 , 2, NULL, X.REVISION) REVISION , X.LOT_NUMBER LOT_NUMBER ,
X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID ,
SUM(X.PRIMARY_QUANTITY) PRIMARY_QUANTITY , X.QUANTITY_TYPE QUANTITY_TYPE ,
X.COST_GROUP_ID COST_GROUP_ID , X.LPN_ID LPN_ID FROM ( SELECT
MR.ORGANIZATION_ID ORGANIZATION_ID , MR.INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,
MR.REVISION REVISION , MR.LOT_NUMBER LOT_NUMBER , MR.SUBINVENTORY_CODE
SUBINVENTORY_CODE , MR.LOCATOR_ID LOCATOR_ID ,
MR.PRIMARY_RESERVATION_QUANTITY - NVL(MR.DETAILED_QUANTITY, 0)
PRIMARY_QUANTITY , 3 QUANTITY_TYPE , TO_NUMBER(NULL) COST_GROUP_ID , LPN_ID
LPN_ID FROM MTL_RESERVATIONS MR WHERE NVL(MR.SUPPLY_SOURCE_TYPE_ID, 13) = 13
AND MR.PRIMARY_RESERVATION_QUANTITY > NVL(MR.DETAILED_QUANTITY, 0) AND
((:B7 <>1) OR (:B7 = 1 AND MR.LPN_ID IS NULL)) AND (:B6 <> 3 OR
(:B6 = 3 AND NOT ( :B5 = MR.DEMAND_SOURCE_TYPE_ID AND :B4 =
MR.DEMAND_SOURCE_HEADER_ID AND NVL(:B3 , -9999) =
NVL(MR.DEMAND_SOURCE_LINE_ID, -999 9) AND NVL(:B2 , '@@@###@@#') =
NVL(MR.DEMAND_SOURCE_NAME, '@@@###@@#') AND NVL(:B1 , -9999) =
NVL(MR.DEMAND_SOURCE_DELIVERY, -9999) ) )) UNION ALL SELECT
MOQ.ORGANIZATION_ID ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MOQ.REVISION REVISION , MOQ.LOT_NUMBER LOT_NUMBER , MOQ.SUBINVENTORY_CODE
SUBINVENTORY_CODE , MOQ.LOCATOR_ID LOCATOR_ID ,
MOQ.PRIMARY_TRANSACTION_QUANTITY , 1 QUANTITY_TYPE , MOQ.COST_GROUP_ID
COST_GROUP_ID , MOQ.LPN_ID LPN_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ UNION
ALL SELECT MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID
INVENTORY_ITEM_ID , MMTT.REVISION REVISION , MMTT.LOT_NUMBER LOT_NUMBER ,
MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID ,
DECODE(MMTT.TRANSACTION_STATUS, 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1,
-1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) *
ROUND(ABS(MMTT.PRIMARY_QUANTITY), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, 5,
1) QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID ,
NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID FROM
MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE MMTT.POSTING_FLAG = 'Y' AND
MMTT.LOT_NUMBER IS NOT NULL AND MMTT.SUBINVENTORY_CODE IS NOT NULL AND
(NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 OR NVL(MMTT.TRANSACTION_STATUS,
0) = 2 AND MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34) ) AND
MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT
MMTT.ORGANIZATION_ID ORGANIZATION_ID , MMTT. INVENTORY_ITEM_ID
INVENTORY_ITEM_ID , MMTT.REVISION REVISION , MTLT.LOT_NUMBER LOT_NUMBER ,
MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE , MMTT.LOCATOR_ID LOCATOR_ID ,
DECODE(MMTT.TRANSACTION_STATUS, 2, 1, DECODE(MMTT.TRANSACTION_ACTION_ID, 1,
-1, 2, -1, 28, -1, 3, -1, SIGN(MMTT.PRIMARY_QUANTITY))) * ROUND(ABS(
MTLT.PRIMARY_QUANTITY ), 5) , DECODE(MMTT.TRANSACTION_STATUS, 2, 5, 1)
QUANTITY_TYPE , MMTT.COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.ALLOCATED_LPN_ID,
NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID)) LPN_ID FROM
MTL_MATERIAL_TRANSACTIONS_TEMP MMTT, MTL_TRANSACTION_LOTS_TEMP MTLT WHERE
MMTT.POSTING_FLAG = 'Y' AND MMTT.TRANSACTION_TEMP_ID =
MTLT.TRANSACTION_TEMP_ID AND MMTT.LOT_NUMBER IS NULL AND
MMTT.SUBINVENTORY_CODE IS NOT NULL AND (NVL(MMTT.TRANSACTION_STATUS, 0)
<> 2 OR NVL(MMTT.TRANSACTION_STATUS, 0) = 2 AND
MMTT.TRANSACTION_ACTION_ID IN (1, 2, 28, 3, 21, 29, 32, 34) ) AND
MMTT.TRANSACTION_ACTION_ID NOT IN (5, 6, 24, 30) UNION ALL SELECT
DECODE(MMTT.TRANSACTION_ACTION_ID , 3, MMTT.TRANSFER_ORGANIZATION ,
MMTT.ORGANIZATION_ID) ORGANIZATION_ID , MMTT.INVENTORY_ITEM_ID
INVENTORY_ITEM_ID , MMTT.REVISION REVISION , MMTT.LOT_NUMBER LOT_NUMBER ,
MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE , MMTT.TRANSFER_TO_LOCATION
LOCATOR_ID , ROUND(ABS( MMTT.PRIMARY_QUANTITY), 5) , 1 QUANTITY_TYPE ,
MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID , NVL(MMTT.CONTENT_LPN_ID,
MMTT.TRANSFER_LPN_ID) LPN_ID FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT WHERE
MMTT.POSTING_FLAG = 'Y' AND MMTT.LOT_NUMBER IS NOT NULL AND
NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 AND MMTT.TRANSACTION_ACTION_ID IN
(2, 28, 3) UNION ALL SELECT DECODE(MMTT.TRANSACTION_ACTION_ID , 3,
MMTT.TRANSFER_ORGANIZATION , MMTT.ORGANIZATION_ID) ORGANIZATION_ID ,
MMTT.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , MMTT.REVISION REVISION ,
MTLT.LOT_NUMBER LOT_NUMBER , MMTT.TRANSFER_SUBINVENTORY SUBINVENTORY_CODE ,
MMTT.TRANSFER_TO_LOCATION LOCATOR_ID , ROUND(ABS( MTLT.PRIMARY_QUANTITY ), 5)
, 1 QUANTITY_TYPE , MMTT.TRANSFER_COST_GROUP_ID COST_GROUP_ID ,
NVL(MMTT.CONTENT_LPN_ID, MMTT.TRANSFER_LPN_ID) LPN_ID FROM
MTL_MATERIAL_TRANSACTIONS_TEMP MMTT, MTL_TRANSACTION_LOTS_TEMP MTLT WHERE MMTT.POSTING_FLAG
= 'Y' AND MMTT.LOT_NUMBER IS NULL AND MMTT.TRANSACTION_TEMP_ID =
MTLT.TRANSACTION_TEMP_ID AND NVL(MMTT.TRANSACTION_STATUS, 0) <> 2 AND
MMTT.TRANSACTION_ACTION_ID IN (2, 28, 3) ) X WHERE X.ORGANIZATION_ID = :B9
AND X.INVENTORY_ITEM_ID = :B8 GROUP BY X.ORGANIZATION_ID,
X.INVENTORY_ITEM_ID, X.REVISION , X.LOT_NUMBER, X.SUBINVENTORY_CODE,
X.LOCATOR_ID , X.QUANTITY_TYPE, X.COST_GROUP_ID, X.LPN_ID ) X ,
MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.ORGANIZATION_ID =
SUB.ORGANIZATION_ID (+) AND X.SUBINVENTORY_CODE =
SUB.SECONDARY_INVENTORY_NAME (+) AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID
(+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_ID (+) AND X.LOT_NUMBER =
LOT.LOT_NUMBER (+) AND (:B14 = 2 OR NVL(SUB.ASSET_INVENTORY, 1) = 1) AND
((:B13 = 1 AND NVL(SUB.INVENTORY _ATP_CODE, 1) = 1 ) OR (:B13 = 2 AND
NVL(SUB.AVAILABILITY_TYPE, 1) = 1 ) OR :B13 =3 OR (:B13 = 4 AND
NVL(SUB.INVENTORY_ATP_CODE, 1) = 1 AND NVL(SUB.AVAILABILITY_TYPE, 1) = 1) )
AND (:B12 = 2 OR LOT.EXPIRATION_DATE IS NULL OR :B11 IS NULL OR
LOT.EXPIRATION_DATE > :B11 ) |
|
|
BEGIN
xxext_b2c_order_if_pkg.order_if_main( :errbuf, :rc, :A0, :A1, :A2, :A3, :A4,
:A5, :A6); END; |
Back to SQL Statistics
Back to Top
|
Statistic |
Total |
per Second |
per Trans |
|
CPU
used by this session |
42,852 |
23.49 |
13.37 |
|
CPU
used when call started |
43,269 |
23.71 |
13.50 |
|
CR
blocks created |
5,799 |
3.18 |
1.81 |
|
Cached
Commit SCN referenced |
10,809,054 |
5,923.96 |
3,372.56 |
|
Commit
SCN cached |
99 |
0.05 |
0.03 |
|
DB
time |
2,406,477 |
1,318.88 |
750.85 |
|
DBWR
checkpoint buffers written |
398 |
0.22 |
0.12 |
|
DBWR
checkpoints |
200 |
0.11 |
0.06 |
|
DBWR
object dxxx buffers written |
369 |
0.20 |
0.12 |
|
DBWR
parallel query checkpoint buffers written |
0 |
0.00 |
0.00 |
|
DBWR
revisited being-written buffer |
13 |
0.01 |
0.00 |
|
DBWR
tablespace checkpoint buffers written |
0 |
0.00 |
0.00 |
|
DBWR
thread checkpoint buffers written |
0 |
0.00 |
0.00 |
|
DBWR
transaction table writes |
289 |
0.16 |
0.09 |
|
DBWR
undo block writes |
1,822 |
1.00 |
0.57 |
|
DDL
statements parallelized |
126 |
0.07 |
0.04 |
|
DFO
trees parallelized |
147 |
0.08 |
0.05 |
|
DML
statements parallelized |
20 |
0.01 |
0.01 |
|
IMU CR rollbacks |
4,505 |
2.47 |
1.41 |
|
IMU Flushes |
2,304 |
1.26 |
0.72 |
|
IMU Redo allocation
size |
2,101,816 |
1,151.91 |
655.79 |
|
IMU commits |
1,418 |
0.78 |
0.44 |
|
IMU contention |
101 |
0.06 |
0.03 |
|
IMU ktichg flush |
3 |
0.00 |
0.00 |
|
IMU pool not allocated |
1 |
0.00 |
0.00 |
|
IMU
recursive-transaction flush |
2 |
0.00 |
0.00 |
|
IMU undo allocation
size |
12,549,968 |
6,878.08 |
3,915.75 |
|
IMU-
failed to get a private strand |
1 |
0.00 |
0.00 |
|
Misses for writing
mapping |
0 |
0.00 |
0.00 |
|
PX local messages
recv'd |
22,231 |
12.18 |
6.94 |
|
PX local messages sent |
22,231 |
12.18 |
6.94 |
|
Parallel
operations downgraded 25 to 50 pct |
0 |
0.00 |
0.00 |
|
Parallel
operations downgraded 75 to 99 pct |
0 |
0.00 |
0.00 |
|
Parallel
operations downgraded to serial |
0 |
0.00 |
0.00 |
|
Parallel operations
not downgraded |
147 |
0.08 |
0.05 |
|
SMON
posted for undo segment recovery |
0 |
0.00 |
0.00 |
|
SMON
posted for undo segment shrink |
1 |
0.00 |
0.00 |
|
SQL*Net
roundtrips to/from client |
81,514 |
44.67 |
25.43 |
|
SQL*Net
roundtrips to/from dblink |
12,751 |
6.99 |
3.98 |
|
active
txn count during cleanout |
5,474 |
3.00 |
1.71 |
|
application wait time |
49 |
0.03 |
0.02 |
|
background checkpoints
completed |
1 |
0.00 |
0.00 |
|
background checkpoints
started |
1 |
0.00 |
0.00 |
|
background timeouts |
6,480 |
3.55 |
2.02 |
|
branch node splits |
0 |
0.00 |
0.00 |
|
buffer
is not pinned count |
39,931,431 |
21,884.65 |
12,459.10 |
|
buffer is pinned count |
144,992,205 |
79,463.81 |
45,239.38 |
|
bytes
received via SQL*Net from client |
11,087,306 |
6,076.46 |
3,459.38 |
|
bytes
received via SQL*Net from dblink |
2,185,318 |
1,197.68 |
681.85 |
|
bytes sent via SQL*Net
to client |
14,435,046 |
7,911.21 |
4,503.91 |
|
bytes sent via SQL*Net to
dblink |
2,435,955 |
1,335.04 |
760.05 |
|
calls
to get snapshot scn: kcmgss |
418,518 |
229.37 |
130.58 |
|
calls to kcmgas |
22,101 |
12.11 |
6.90 |
|
calls to kcmgcs |
1,466 |
0.80 |
0.46 |
|
change write time |
89 |
0.05 |
0.03 |
|
cleanout
- number of ktugct calls |
5,279 |
2.89 |
1.65 |
|
cleanouts
and rollbacks - consistent read gets |
4,532 |
2.48 |
1.41 |
|
cleanouts
only - consistent read gets |
147 |
0.08 |
0.05 |
|
cluster
key scan block gets |
54,352 |
29.79 |
16.96 |
|
cluster key scans |
18,814 |
10.31 |
5.87 |
|
commit batch performed |
25 |
0.01 |
0.01 |
|
commit batch requested |
25 |
0.01 |
0.01 |
|
commit batch/immediate
performed |
464 |
0.25 |
0.14 |
|
commit batch/immediate
requested |
464 |
0.25 |
0.14 |
|
commit
cleanout failures: block lost |
38 |
0.02 |
0.01 |
|
commit
cleanout failures: buffer being written |
0 |
0.00 |
0.00 |
|
commit
cleanout failures: callback failure |
38 |
0.02 |
0.01 |
|
commit
cleanout failures: cannot pin |
11 |
0.01 |
0.00 |
|
commit cleanouts |
16,030 |
8.79 |
5.00 |
|
commit cleanouts successfully
completed |
15,943 |
8.74 |
4.97 |
|
commit immediate
performed |
439 |
0.24 |
0.14 |
|
commit immediate
requested |
439 |
0.24 |
0.14 |
|
commit
txn count during cleanout |
473 |
0.26 |
0.15 |
|
concurrency wait time |
40 |
0.02 |
0.01 |
|
consistent changes |
7,843 |
4.30 |
2.45 |
|
consistent gets |
60,709,378 |
33,272.12 |
18,942.08 |
|
consistent gets -
examination |
19,819,820 |
10,862.37 |
6,184.03 |
|
consistent gets direct |
18 |
0.01 |
0.01 |
|
consistent gets from
cache |
60,709,360 |
33,272.11 |
18,942.08 |
|
current
blocks converted for CR |
0 |
0.00 |
0.00 |
|
cursor authentications |
24 |
0.01 |
0.01 |
|
data
blocks consistent reads - undo records applied |
6,609 |
3.62 |
2.06 |
|
db block changes |
95,753 |
52.48 |
29.88 |
|
db block gets |
102,490 |
56.17 |
31.98 |
|
db block gets direct |
2,397 |
1.31 |
0.75 |
|
db
block gets from cache |
100,093 |
54.86 |
31.23 |
|
deferred
(CURRENT) block cleanout applications |
5,817 |
3.19 |
1.81 |
|
dirty buffers
inspected |
7,088 |
3.88 |
2.21 |
|
enqueue conversions |
18,377 |
10.07 |
5.73 |
|
enqueue deadlocks |
0 |
0.00 |
0.00 |
|
enqueue releases |
78,419 |
42.98 |
24.47 |
|
enqueue requests |
79,590 |
43.62 |
24.83 |
|
enqueue timeouts |
1,187 |
0.65 |
0.37 |
|
enqueue waits |
235 |
0.13 |
0.07 |
|
exchange deadlocks |
0 |
0.00 |
0.00 |
|
execute count |
379,339 |
207.90 |
118.36 |
|
failed
probes on index block reclamation |
0 |
0.00 |
0.00 |
|
free buffer inspected |
6,274,827 |
3,438.95 |
1,957.82 |
|
free buffer requested |
6,116,761 |
3,352.33 |
1,908.51 |
|
heap block compress |
753 |
0.41 |
0.23 |
|
hot
buffers moved to head of LRU |
520,151 |
285.07 |
162.29 |
|
immediate
(CR) block cleanout applications |
4,679 |
2.56 |
1.46 |
|
immediate
(CURRENT) block cleanout applications |
2,623 |
1.44 |
0.82 |
|
index crx upgrade
(found) |
0 |
0.00 |
0.00 |
|
index crx upgrade
(positioned) |
13,535 |
7.42 |
4.22 |
|
index
fast full scans (direct read) |
0 |
0.00 |
0.00 |
|
index fast full scans
(full) |
40 |
0.02 |
0.01 |
|
index
fast full scans (rowid ranges) |
273 |
0.15 |
0.09 |
|
index fetch by key |
9,337,440 |
5,117.44 |
2,913.40 |
|
index scans kdiixs1 |
7,523,072 |
4,123.06 |
2,347.29 |
|
java
call heap collected bytes |
0 |
0.00 |
0.00 |
|
java
call heap collected count |
0 |
0.00 |
0.00 |
|
java
call heap gc count |
0 |
0.00 |
0.00 |
|
java
call heap live object count |
0 |
0.00 |
0.00 |
|
java
call heap live object count max |
0 |
0.00 |
0.00 |
|
java
call heap live size |
0 |
0.00 |
0.00 |
|
java
call heap live size max |
0 |
0.00 |
0.00 |
|
java
call heap object count |
0 |
0.00 |
0.00 |
|
java
call heap object count max |
0 |
0.00 |
0.00 |
|
java
call heap total size |
0 |
0.00 |
0.00 |
|
java
call heap total size max |
0 |
0.00 |
0.00 |
|
java
call heap used size |
0 |
0.00 |
0.00 |
|
java
call heap used size max |
0 |
0.00 |
0.00 |
|
leaf node 90-10 splits |
15 |
0.01 |
0.00 |
|
leaf node splits |
24 |
0.01 |
0.01 |
|
lob reads |
432 |
0.24 |
0.13 |
|
lob writes |
145 |
0.08 |
0.05 |
|
lob writes unaligned |
145 |
0.08 |
0.05 |
|
logons cumulative |
979 |
0.54 |
0.31 |
|
messages received |
53,838 |
29.51 |
16.80 |
|
messages sent |
53,838 |
29.51 |
16.80 |
|
no
buffer to keep pinned count |
0 |
0.00 |
0.00 |
|
no
work - consistent read gets |
40,787,043 |
22,353.57 |
12,726.07 |
|
opened cursors
cumulative |
59,449 |
32.58 |
18.55 |
|
parse count (failures) |
1 |
0.00 |
0.00 |
|
parse count (hard) |
529 |
0.29 |
0.17 |
|
parse count (total) |
65,064 |
35.66 |
20.30 |
|
parse time cpu |
154 |
0.08 |
0.05 |
|
parse time elapsed |
6,110 |
3.35 |
1.91 |
|
physical read IO
requests |
4,637,476 |
2,541.60 |
1,446.95 |
|
physical read bytes |
50,040,897,536 |
27,425,200.01 |
15,613,384.57 |
|
physical
read total IO requests |
4,645,384 |
2,545.93 |
1,449.42 |
|
physical read total
bytes |
50,217,279,488 |
27,521,867.14 |
15,668,417.94 |
|
physical
read total multi block requests |
215,194 |
117.94 |
67.14 |
|
physical reads |
6,108,508 |
3,347.80 |
1,905.93 |
|
physical reads cache |
6,108,347 |
3,347.71 |
1,905.88 |
|
physical reads cache
prefetch |
1,476,070 |
808.97 |
460.55 |
|
physical reads direct |
161 |
0.09 |
0.05 |
|
physical reads direct
(lob) |
8 |
0.00 |
0.00 |
|
physical
reads direct temporary tablespace |
0 |
0.00 |
0.00 |
|
physical reads
prefetch warmup |
0 |
0.00 |
0.00 |
|
physical write IO
requests |
7,293 |
4.00 |
2.28 |
|
physical write bytes |
93,749,248 |
51,379.81 |
29,250.94 |
|
physical
write total IO requests |
23,900 |
13.10 |
7.46 |
|
physical write total
bytes |
298,460,160 |
163,572.80 |
93,123.29 |
|
physical
write total multi block requests |
8,876 |
4.86 |
2.77 |
|
physical writes |
11,444 |
6.27 |
3.57 |
|
physical writes direct |
2,477 |
1.36 |
0.77 |
|
physical writes direct
(lob) |
10 |
0.01 |
0.00 |
|
physical
writes direct temporary tablespace |
0 |
0.00 |
0.00 |
|
physical writes from
cache |
8,967 |
4.91 |
2.80 |
|
physical writes non
checkpoint |
11,033 |
6.05 |
3.44 |
|
pinned buffers
inspected |
912 |
0.50 |
0.28 |
|
prefetch
warmup blocks aged out before use |
0 |
0.00 |
0.00 |
|
prefetched
blocks aged out before use |
12 |
0.01 |
0.00 |
|
process
last non-idle time |
1,827 |
1.00 |
0.57 |
|
queries parallelized |
1 |
0.00 |
0.00 |
|
recursive
aborts on index block reclamation |
0 |
0.00 |
0.00 |
|
recursive calls |
1,005,850 |
551.26 |
313.84 |
|
recursive cpu usage |
9,599 |
5.26 |
3.00 |
|
redo blocks written |
72,563 |
39.77 |
22.64 |
|
redo buffer allocation
retries |
0 |
0.00 |
0.00 |
|
redo entries |
46,924 |
25.72 |
14.64 |
|
redo log space
requests |
0 |
0.00 |
0.00 |
|
redo
log space wait time |
0 |
0.00 |
0.00 |
|
redo ordering marks |
1,472 |
0.81 |
0.46 |
|
redo size |
34,310,820 |
18,804.24 |
10,705.40 |
|
redo subscn max counts |
3,466 |
1.90 |
1.08 |
|
redo synch time |
375 |
0.21 |
0.12 |
|
redo synch writes |
6,264 |
3.43 |
1.95 |
|
redo wastage |
1,625,172 |
890.68 |
507.07 |
|
redo write time |
535 |
0.29 |
0.17 |
|
redo writer latching
time |
0 |
0.00 |
0.00 |
|
redo writes |
5,727 |
3.14 |
1.79 |
|
rollback
changes - undo records applied |
128 |
0.07 |
0.04 |
|
rollbacks
only - consistent read gets |
1,247 |
0.68 |
0.39 |
|
rows fetched via
callback |
1,422,663 |
779.70 |
443.89 |
|
session connect time |
0 |
0.00 |
0.00 |
|
session cursor cache
hits |
33,469 |
18.34 |
10.44 |
|
session logical reads |
60,811,887 |
33,328.30 |
18,974.07 |
|
session pga memory |
408,507,336 |
223,884.78 |
127,459.39 |
|
session pga memory max |
1,338,912,840 |
733,798.84 |
417,757.52 |
|
session uga memory |
20,681,016 |
11,334.35 |
6,452.74 |
|
session uga memory max |
1,328,811,992 |
728,263.01 |
414,605.93 |
|
shared
hash latch upgrades - no wait |
104,607 |
57.33 |
32.64 |
|
shared
hash latch upgrades - wait |
7 |
0.00 |
0.00 |
|
sorts (disk) |
0 |
0.00 |
0.00 |
|
sorts (memory) |
31,415 |
17.22 |
9.80 |
|
sorts (rows) |
1,312,343 |
719.24 |
409.47 |
|
sql area evicted |
79 |
0.04 |
0.02 |
|
sql area purged |
184 |
0.10 |
0.06 |
|
summed dirty queue
length |
6,612 |
3.62 |
2.06 |
|
switch
current to new buffer |
399 |
0.22 |
0.12 |
|
table fetch by rowid |
80,429,412 |
44,079.80 |
25,094.98 |
|
table fetch continued
row |
1,171,993 |
642.32 |
365.68 |
|
table scan blocks gotten |
1,926,614 |
1,055.89 |
601.13 |
|
table scan rows gotten |
92,889,837 |
50,908.81 |
28,982.79 |
|
table scans (cache
partitions) |
0 |
0.00 |
0.00 |
|
table scans (direct
read) |
0 |
0.00 |
0.00 |
|
table scans (long
tables) |
1,631 |
0.89 |
0.51 |
|
table scans (rowid
ranges) |
1,343 |
0.74 |
0.42 |
|
table scans (short
tables) |
5,032 |
2.76 |
1.57 |
|
total
number of times SMON posted |
229 |
0.13 |
0.07 |
|
transaction rollbacks |
26 |
0.01 |
0.01 |
|
transaction
tables consistent read rollbacks |
0 |
0.00 |
0.00 |
|
transaction
tables consistent reads - undo records applied |
0 |
0.00 |
0.00 |
|
undo change vector
size |
5,227,544 |
2,864.99 |
1,631.06 |
|
user
I/O wait time |
341,940 |
187.40 |
106.69 |
|
user calls |
80,623 |
44.19 |
25.16 |
|
user commits |
1,865 |
1.02 |
0.58 |
|
user rollbacks |
1,340 |
0.73 |
0.42 |
|
workarea executions -
onepass |
0 |
0.00 |
0.00 |
|
workarea executions -
optimal |
14,745 |
8.08 |
4.60 |
|
write
clones created in background |
327 |
0.18 |
0.10 |
|
write
clones created in foreground |
1 |
0.00 |
0.00 |
Back to Instance Activity Statistics
Back to Top
|
Statistic |
Begin Value |
End Value |
|
session cursor cache
count |
34,853,172 |
34,872,960 |
|
opened cursors current |
3,284 |
3,190 |
|
workarea memory
allocated |
1,086 |
613 |
|
logons current |
124 |
121 |
Back to Instance Activity Statistics
Back to Top
|
Statistic |
Total |
per Hour |
|
log switches (derived) |
1 |
1.97 |
Back to Instance Activity Statistics
Back to Top
|
Tablespace |
Reads |
Av Reads/s |
Av Rd(ms) |
Av Blks/Rd |
Writes |
Av Writes/s |
Buffer Waits |
Av Buf Wt(ms) |
|
APPS_TS_TX_DATA |
4,180,938 |
2,291 |
0.62 |
1.35 |
2,524 |
1 |
683,178 |
0.68 |
|
APPS_TS_TX_IDX |
293,214 |
161 |
0.63 |
1.00 |
1,510 |
1 |
18,572 |
0.81 |
|
APPS_TS_QUEUES |
130,625 |
72 |
0.66 |
1.00 |
25 |
0 |
124,929 |
0.69 |
|
APPS_TS_INTERFACE |
8,971 |
5 |
0.85 |
1.00 |
2 |
0 |
0 |
0.00 |
|
SYSTEM |
8,051 |
4 |
0.90 |
2.32 |
701 |
0 |
16 |
0.63 |
|
HYBRISTBSP |
7,210 |
4 |
0.78 |
1.00 |
3 |
0 |
0 |
0.00 |
|
SYSAUX |
1,915 |
1 |
0.93 |
1.03 |
864 |
0 |
0 |
0.00 |
|
APPS_UNDOTS2 |
1,447 |
1 |
0.79 |
1.00 |
1,315 |
1 |
0 |
0.00 |
|
APPS_TS_SEED |
2,718 |
1 |
0.94 |
1.27 |
2 |
0 |
35 |
0.57 |
|
XXATPENGINE_TBSP |
848 |
0 |
0.71 |
1.19 |
41 |
0 |
0 |
0.00 |
|
APPS_TS_ARCHIVE |
495 |
0 |
0.93 |
1.41 |
250 |
0 |
3 |
0.00 |
|
XXNT_DATA |
69 |
0 |
0.43 |
1.00 |
8 |
0 |
0 |
0.00 |
|
TEMP2 |
28 |
0 |
0.71 |
1.00 |
12 |
0 |
0 |
0.00 |
|
APPS_TS_TOOLS |
15 |
0 |
0.67 |
1.00 |
14 |
0 |
0 |
0.00 |
|
APPS_TS_SUMMARY |
18 |
0 |
0.00 |
1.00 |
3 |
0 |
0 |
0.00 |
|
XXMDMD |
18 |
0 |
0.56 |
1.00 |
2 |
0 |
0 |
0.00 |
|
APPS_TS_MEDIA |
5 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
WMSTBSP |
5 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXBACK |
5 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
PERFSTAT |
4 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXMDMX |
4 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
APPS_TS_NOLOGGING |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
CTXD |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
DBATOOLS |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
ODM |
3 |
0 |
3.33 |
1.00 |
1 |
0 |
0 |
0.00 |
|
OLAP |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
OWAPUB |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
PORTAL |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXRL_DATA |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXRL_IDX |
3 |
0 |
3.33 |
1.00 |
1 |
0 |
0 |
0.00 |
|
Tablespace |
Filename |
Reads |
Av Reads/s |
Av Rd(ms) |
Av Blks/Rd |
Writes |
Av Writes/s |
Buffer Waits |
Av Buf Wt(ms) |
|
APPS_TS_ARCHIVE |
/exxx/dbdata/a_archive01.dbf |
495 |
0 |
0.93 |
1.41 |
250 |
0 |
3 |
0.00 |
|
APPS_TS_INTERFACE |
/exxx/dbdata/a_int01.dbf |
7,216 |
4 |
0.87 |
1.00 |
1 |
0 |
0 |
0.00 |
|
APPS_TS_INTERFACE |
/exxx/dbdata/a_int02.dbf |
1,755 |
1 |
0.79 |
1.00 |
1 |
0 |
0 |
0.00 |
|
APPS_TS_MEDIA |
/exxx/dbdata/a_media01.dbf |
5 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
APPS_TS_NOLOGGING |
/exxx/dbdata/a_nolog01.dbf |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
APPS_TS_QUEUES |
/exxx/dbdata/a_queue01.dbf |
82,027 |
45 |
0.64 |
1.00 |
18 |
0 |
78,648 |
0.69 |
|
APPS_TS_QUEUES |
/exxx/dbdata/a_queue02.dbf |
48,598 |
27 |
0.68 |
1.00 |
7 |
0 |
46,281 |
0.70 |
|
APPS_TS_SEED |
/exxx/dbdata/a_ref01.dbf |
1,050 |
1 |
0.84 |
1.20 |
1 |
0 |
7 |
1.43 |
|
APPS_TS_SEED |
/exxx/dbdata/a_ref02.dbf |
1,668 |
1 |
1.00 |
1.31 |
1 |
0 |
28 |
0.36 |
|
APPS_TS_SUMMARY |
/exxx/dbdata/a_summ01.dbf |
5 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
APPS_TS_SUMMARY |
/exxx/dbdata/a_summ02.dbf |
7 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
APPS_TS_SUMMARY |
/exxx/dbdata/a_summ03.dbf |
6 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
APPS_TS_TOOLS |
/exxx/dbdata/apps_ts_tools01.dbf |
15 |
0 |
0.67 |
1.00 |
14 |
0 |
0 |
0.00 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data01.dbf |
136,771 |
75 |
0.85 |
1.92 |
336 |
0 |
60,484 |
0.68 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data02.dbf |
143,476 |
79 |
0.82 |
1.94 |
219 |
0 |
65,449 |
0.69 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data03.dbf |
143,049 |
78 |
0.84 |
1.91 |
726 |
0 |
58,894 |
0.69 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data04.dbf |
137,409 |
75 |
0.81 |
1.98 |
168 |
0 |
61,135 |
0.69 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data06.dbf |
144,506 |
79 |
0.82 |
1.96 |
152 |
0 |
64,733 |
0.66 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data07.dbf |
139,404 |
76 |
0.82 |
1.99 |
139 |
0 |
63,266 |
0.67 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data08.dbf |
151,064 |
83 |
0.81 |
1.90 |
128 |
0 |
77,275 |
0.67 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data09.dbf |
150,015 |
82 |
0.82 |
1.91 |
103 |
0 |
72,348 |
0.67 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data10.dbf |
142,255 |
78 |
0.84 |
1.96 |
172 |
0 |
65,454 |
0.67 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data11.dbf |
144,927 |
79 |
0.81 |
1.91 |
135 |
0 |
70,556 |
0.68 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data12.dbf |
55,505 |
30 |
0.82 |
2.28 |
78 |
0 |
15,016 |
0.64 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data13.dbf |
1,262,966 |
692 |
0.51 |
1.02 |
84 |
0 |
3,692 |
0.62 |
|
APPS_TS_TX_DATA |
/exxx/dbdata/a_txn_data14.dbf |
1,429,591 |
783 |
0.50 |
1.02 |
84 |
0 |
4,876 |
0.63 |
|
APPS_TS_TX_IDX |
/exxx/dbdata/a_txn_ind01.dbf |
31,924 |
17 |
0.64 |
1.00 |
179 |
0 |
2,205 |
0.83 |
|
APPS_TS_TX_IDX |
/exxx/dbdata/a_txn_ind02.dbf |
31,687 |
17 |
0.62 |
1.00 |
120 |
0 |
2,586 |
0.96 |
|
APPS_TS_TX_IDX |
/exxx/dbdata/a_txn_ind03.dbf |
29,384 |
16 |
0.63 |
1.00 |
86 |
0 |
2,233 |
0.78 |
|
APPS_TS_TX_IDX |
/exxx/dbdata/a_txn_ind04.dbf |
30,011 |
16 |
0.61 |
1.00 |
145 |
0 |
2,102 |
0.76 |
|
APPS_TS_TX_IDX |
/exxx/dbdata/a_txn_ind05.dbf |
32,266 |
18 |
0.63 |
1.00 |
112 |
0 |
2,426 |
0.83 |
|
APPS_TS_TX_IDX |
/exxx/dbdata/a_txn_ind06.dbf |
34,157 |
19 |
0.60 |
1.00 |
187 |
0 |
2,138 |
0.83 |
|
APPS_TS_TX_IDX |
/exxx/dbdata/a_txn_ind07.dbf |
31,659 |
17 |
0.61 |
1.00 |
107 |
0 |
2,117 |
0.75 |
|
APPS_TS_TX_IDX |
/exxx/dbdata/a_txn_ind08.dbf |
31,567 |
17 |
0.64 |
1.00 |
120 |
0 |
1,975 |
0.78 |
|
APPS_TS_TX_IDX |
/exxx/dbdata/a_txn_ind09.dbf |
40,559 |
22 |
0.66 |
1.00 |
454 |
0 |
790 |
0.65 |
|
APPS_UNDOTS2 |
/exxx/dbdata/undo04.dbf |
309 |
0 |
0.87 |
1.00 |
371 |
0 |
0 |
0.00 |
|
APPS_UNDOTS2 |
/exxx/dbdata/undo05.dbf |
230 |
0 |
0.91 |
1.00 |
238 |
0 |
0 |
0.00 |
|
APPS_UNDOTS2 |
/exxx/dbdata/undo07.dbf |
329 |
0 |
0.70 |
1.00 |
353 |
0 |
0 |
0.00 |
|
APPS_UNDOTS2 |
/exxx/dbdata/undo08.dbf |
579 |
0 |
0.76 |
1.00 |
353 |
0 |
0 |
0.00 |
|
CTXD |
/exxx/dbdata/ctxd01.dbf |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
DBATOOLS |
/exxx/dbdata/dbatools01.dbf |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
HYBRISTBSP |
/exxx/dbdata/hybristbsp01.dbf |
4,248 |
2 |
0.79 |
1.00 |
1 |
0 |
0 |
0.00 |
|
HYBRISTBSP |
/exxx/dbdata/hybristbsp02.dbf |
1,162 |
1 |
0.87 |
1.00 |
1 |
0 |
0 |
0.00 |
|
HYBRISTBSP |
/exxx/dbdata/hybristbsp03.dbf |
1,800 |
1 |
0.68 |
1.00 |
1 |
0 |
0 |
0.00 |
|
ODM |
/exxx/dbdata/odm.dbf |
3 |
0 |
3.33 |
1.00 |
1 |
0 |
0 |
0.00 |
|
OLAP |
/exxx/dbdata/olap.dbf |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
OWAPUB |
/exxx/dbdata/owad01.dbf |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
PERFSTAT |
/exxx/dbdata/perfstat01.dbf |
4 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
PORTAL |
/exxx/dbdata/portal01.dbf |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
SYSAUX |
/exxx/dbdata/sysaux01.dbf |
441 |
0 |
1.16 |
1.08 |
115 |
0 |
0 |
0.00 |
|
SYSAUX |
/exxx/dbdata/sysaux02.dbf |
478 |
0 |
0.94 |
1.02 |
291 |
0 |
0 |
0.00 |
|
SYSAUX |
/exxx/dbdata/sysaux03.dbf |
262 |
0 |
1.07 |
1.06 |
87 |
0 |
0 |
0.00 |
|
SYSAUX |
/exxx/dbdata/sysaux04.dbf |
734 |
0 |
0.74 |
1.00 |
371 |
0 |
0 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system01.dbf |
665 |
0 |
0.78 |
2.41 |
77 |
0 |
4 |
2.50 |
|
SYSTEM |
/exxx/dbdata/system02.dbf |
579 |
0 |
1.07 |
2.87 |
71 |
0 |
1 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system03.dbf |
671 |
0 |
1.03 |
2.91 |
54 |
0 |
0 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system04.dbf |
860 |
0 |
0.92 |
2.64 |
61 |
0 |
0 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system05.dbf |
1,169 |
1 |
0.86 |
2.26 |
90 |
0 |
4 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system06.dbf |
465 |
0 |
0.80 |
2.85 |
39 |
0 |
0 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system07.dbf |
480 |
0 |
0.83 |
2.32 |
113 |
0 |
0 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system08.dbf |
447 |
0 |
0.83 |
2.34 |
17 |
0 |
0 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system09.dbf |
535 |
0 |
0.99 |
2.12 |
18 |
0 |
0 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system10.dbf |
935 |
1 |
0.93 |
1.83 |
83 |
0 |
3 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system11.dbf |
1,064 |
1 |
0.88 |
1.77 |
60 |
0 |
4 |
0.00 |
|
SYSTEM |
/exxx/dbdata/system12.dbf |
181 |
0 |
0.72 |
1.72 |
18 |
0 |
0 |
0.00 |
|
TEMP2 |
/exxx/dbdata/temp01.dbf |
19 |
0 |
1.05 |
1.00 |
12 |
0 |
0 |
|
|
TEMP2 |
/exxx/dbdata/temp02.dbf |
3 |
0 |
0.00 |
1.00 |
0 |
0 |
0 |
|
|
TEMP2 |
/exxx/dbdata/temp03.dbf |
3 |
0 |
0.00 |
1.00 |
0 |
0 |
0 |
|
|
TEMP2 |
/exxx/dbdata/temp04.dbf |
3 |
0 |
0.00 |
1.00 |
0 |
0 |
0 |
|
|
WMSTBSP |
/exxx/dbdata/wmstbsp.dbf |
5 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXATPENGINE_TBSP |
/exxx/dbdata/xxatpengine_data01.dbf |
848 |
0 |
0.71 |
1.19 |
41 |
0 |
0 |
0.00 |
|
XXBACK |
/exxx/dbdata/xxback.dbf |
5 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXMDMD |
/exxx/dbdata/xxmdmd_01.dbf |
9 |
0 |
1.11 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXMDMD |
/exxx/dbdata/xxmdmd_02.dbf |
9 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXMDMX |
/exxx/dbdata/xxmdmx_01.dbf |
4 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXNT_DATA |
/exxx/dbdata/xxnt_data_01.dbf |
12 |
0 |
0.83 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXNT_DATA |
/exxx/dbdata/xxnt_data_02.dbf |
6 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXNT_DATA |
/exxx/dbdata/xxnt_data_03.dbf |
7 |
0 |
1.43 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXNT_DATA |
/exxx/dbdata/xxnt_data_04.dbf |
7 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXNT_DATA |
/exxx/dbdata/xxnt_data_05.dbf |
9 |
0 |
1.11 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXNT_DATA |
/exxx/dbdata/xxnt_data_06.dbf |
11 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXNT_DATA |
/exxx/dbdata/xxnt_data_07.dbf |
7 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXNT_DATA |
/exxx/dbdata/xxnt_data_09.dbf |
10 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXRL_DATA |
/exxx/dbdata/xxrl_data_01.dbf |
3 |
0 |
0.00 |
1.00 |
1 |
0 |
0 |
0.00 |
|
XXRL_IDX |
/exxx/dbdata/xxrl_idx_01.dbf |
3 |
0 |
3.33 |
1.00 |
1 |
0 |
0 |
0.00 |
|
P |
Number of Buffers |
Pool Hit% |
Buffer Gets |
Physical Reads |
Physical Writes |
Free Buff Wait |
Writ Comp Wait |
Buffer Busy Waits |
|
D |
61,349 |
90 |
60,807,866 |
6,107,812 |
8,967 |
0 |
0 |
827,993 |
|
Targt MTTR (s) |
Estd MTTR (s) |
Recovery Estd IOs |
Actual Redo Blks |
Target Redo Blks |
Log File Size Redo
Blks |
Log Ckpt Timeout Redo
Blks |
Log Ckpt Interval Redo
Blks |
|
|
B |
0 |
8 |
689 |
4477 |
34898 |
1843200 |
34898 |
100000 |
|
E |
0 |
8 |
285 |
1945 |
7904 |
1843200 |
7904 |
100000 |
Back to Advisory Statistics
Back to Top
No data exists for this section of the
report.
Back to Advisory Statistics
Back to Top
|
PGA Cache Hit % |
W/A MB Processed |
Extra W/A MB
Read/Written |
|
100.00 |
848 |
0 |
Back to Advisory Statistics
Back to Top
|
PGA Aggr Target(M) |
Auto PGA Target(M) |
PGA Mem Alloc(M) |
W/A PGA Used(M) |
%PGA W/A Mem |
%Auto W/A Mem |
%Man W/A Mem |
Global Mem Bound(K) |
|
|
B |
1,024 |
734 |
352.27 |
1.06 |
0.30 |
100.00 |
0.00 |
104,850 |
|
E |
1,024 |
732 |
345.09 |
0.60 |
0.17 |
100.00 |
0.00 |
104,850 |
Back to Advisory Statistics
Back to Top
|
Low Optimal |
High Optimal |
Total Execs |
Optimal Execs |
1-Pass Execs |
M-Pass Execs |
|
2K |
4K |
13,864 |
13,864 |
0 |
0 |
|
64K |
128K |
34 |
34 |
0 |
0 |
|
128K |
256K |
13 |
13 |
0 |
0 |
|
256K |
512K |
48 |
48 |
0 |
0 |
|
512K |
1024K |
608 |
608 |
0 |
0 |
|
1M |
2M |
159 |
159 |
0 |
0 |
|
2M |
4M |
2 |
2 |
0 |
0 |
|
4M |
8M |
1 |
1 |
0 |
0 |
|
16M |
32M |
2 |
2 |
0 |
0 |
|
32M |
64M |
2 |
2 |
0 |
0 |
Back to Advisory Statistics
Back to Top
|
PGA Target Est (MB) |
Size Factr |
W/A MB Processed |
Estd Extra W/A MB
Read/ Written to Disk |
Estd PGA Cache Hit % |
Estd PGA Overalloc Count |
|
128 |
0.13 |
2,921,753.63 |
2,061,728.35 |
59.00 |
78,310 |
|
256 |
0.25 |
2,921,753.63 |
2,052,079.95 |
59.00 |
77,829 |
|
512 |
0.50 |
2,921,753.63 |
441,646.19 |
87.00 |
8 |
|
768 |
0.75 |
2,921,753.63 |
269,701.83 |
92.00 |
0 |
|
1,024 |
1.00 |
2,921,753.63 |
124,173.83 |
96.00 |
0 |
|
1,229 |
1.20 |
2,921,753.63 |
108,712.00 |
96.00 |
0 |
|
1,434 |
1.40 |
2,921,753.63 |
108,712.00 |
96.00 |
0 |
|
1,638 |
1.60 |
2,921,753.63 |
108,712.00 |
96.00 |
0 |
|
1,843 |
1.80 |
2,921,753.63 |
108,712.00 |
96.00 |
0 |
|
2,048 |
2.00 |
2,921,753.63 |
108,712.00 |
96.00 |
0 |
|
3,072 |
3.00 |
2,921,753.63 |
108,712.00 |
96.00 |
0 |
|
4,096 |
4.00 |
2,921,753.63 |
108,712.00 |
96.00 |
0 |
|
6,144 |
6.00 |
2,921,753.63 |
108,712.00 |
96.00 |
0 |
|
8,192 |
8.00 |
2,921,753.63 |
108,712.00 |
96.00 |
0 |
Back to Advisory Statistics
Back to Top
|
Shared Pool Size(M) |
SP Size Factr |
Est LC Size (M) |
Est LC Mem Obj |
Est LC Time Saved (s) |
Est LC Time Saved
Factr |
Est LC Load Time (s) |
Est LC Load Time Factr |
Est LC Mem Obj Hits |
|
416 |
0.29 |
166 |
10,729 |
17,734,563 |
1.00 |
75,386 |
7.49 |
1,640,738,190 |
|
560 |
0.39 |
293 |
14,910 |
17,766,616 |
1.00 |
43,333 |
4.31 |
1,640,927,290 |
|
704 |
0.49 |
435 |
21,553 |
17,770,906 |
1.00 |
39,043 |
3.88 |
1,640,952,130 |
|
848 |
0.60 |
578 |
29,821 |
17,786,080 |
1.00 |
23,869 |
2.37 |
1,640,967,397 |
|
992 |
0.70 |
721 |
34,693 |
17,790,414 |
1.00 |
19,535 |
1.94 |
1,640,975,296 |
|
1,136 |
0.80 |
864 |
39,902 |
17,792,374 |
1.00 |
17,575 |
1.75 |
1,640,983,694 |
|
1,280 |
0.90 |
1,007 |
46,198 |
17,792,422 |
1.00 |
17,527 |
1.74 |
1,640,992,558 |
|
1,424 |
1.00 |
1,150 |
51,738 |
17,799,890 |
1.00 |
10,059 |
1.00 |
1,640,999,039 |
|
1,568 |
1.10 |
1,293 |
57,417 |
17,805,737 |
1.00 |
4,212 |
0.42 |
1,641,006,468 |
|
1,712 |
1.20 |
1,428 |
63,500 |
17,805,753 |
1.00 |
4,196 |
0.42 |
1,641,008,823 |
|
1,856 |
1.30 |
1,571 |
68,321 |
17,805,769 |
1.00 |
4,180 |
0.42 |
1,641,010,563 |
|
2,000 |
1.40 |
1,714 |
74,245 |
17,805,819 |
1.00 |
4,130 |
0.41 |
1,641,013,029 |
|
2,144 |
1.51 |
1,857 |
79,589 |
17,805,823 |
1.00 |
4,126 |
0.41 |
1,641,014,034 |
|
2,288 |
1.61 |
2,000 |
85,709 |
17,805,833 |
1.00 |
4,116 |
0.41 |
1,641,016,158 |
|
2,432 |
1.71 |
2,143 |
92,065 |
17,805,835 |
1.00 |
4,114 |
0.41 |
1,641,016,851 |
|
2,576 |
1.81 |
2,284 |
97,713 |
17,805,848 |
1.00 |
4,101 |
0.41 |
1,641,017,835 |
|
2,720 |
1.91 |
2,426 |
103,703 |
17,805,874 |
1.00 |
4,075 |
0.41 |
1,641,019,939 |
|
2,864 |
2.01 |
2,569 |
110,873 |
17,806,730 |
1.00 |
3,219 |
0.32 |
1,641,021,455 |
Back to Advisory Statistics
Back to Top
|
SGA Target Size (M) |
SGA Size Factor |
Est DB Time (s) |
Est Physical Reads |
|
512 |
0.25 |
3,123,632 |
|
|
1,024 |
0.50 |
3,072,049 |
|
|
1,536 |
0.75 |
3,058,009 |
|
|
2,048 |
1.00 |
3,052,210 |
|
|
2,560 |
1.25 |
3,052,210 |
|
|
3,072 |
1.50 |
3,051,294 |
|
|
3,584 |
1.75 |
3,051,294 |
|
|
4,096 |
2.00 |
3,051,294 |
|
Back to Advisory Statistics
Back to Top
|
Size for Est (MB) |
Size Factor |
Est Spill Count |
Est Spill Time (s) |
Est Unspill Count |
Est Unspill Time (s) |
|
16 |
0.50 |
0 |
0 |
0 |
0 |
|
32 |
1.00 |
0 |
0 |
0 |
0 |
|
48 |
1.50 |
0 |
0 |
0 |
0 |
|
64 |
2.00 |
0 |
0 |
0 |
0 |
|
80 |
2.50 |
0 |
0 |
0 |
0 |
|
96 |
3.00 |
0 |
0 |
0 |
0 |
|
112 |
3.50 |
0 |
0 |
0 |
0 |
|
128 |
4.00 |
0 |
0 |
0 |
0 |
|
144 |
4.50 |
0 |
0 |
0 |
0 |
|
160 |
5.00 |
0 |
0 |
0 |
0 |
|
176 |
5.50 |
0 |
0 |
0 |
0 |
|
192 |
6.00 |
0 |
0 |
0 |
0 |
|
208 |
6.50 |
0 |
0 |
0 |
0 |
|
224 |
7.00 |
0 |
0 |
0 |
0 |
|
240 |
7.50 |
0 |
0 |
0 |
0 |
|
256 |
8.00 |
0 |
0 |
0 |
0 |
|
272 |
8.50 |
0 |
0 |
0 |
0 |
|
288 |
9.00 |
0 |
0 |
0 |
0 |
|
304 |
9.50 |
0 |
0 |
0 |
0 |
|
320 |
10.00 |
0 |
0 |
0 |
0 |
Back to Advisory Statistics
Back to Top
|
Java Pool Size(M) |
JP Size Factr |
Est LC Size (M) |
Est LC Mem Obj |
Est LC Time Saved (s) |
Est LC Time Saved
Factr |
Est LC Load Time (s) |
Est LC Load Time Factr |
Est LC Mem Obj Hits |
|
16 |
0.25 |
16 |
412 |
53 |
1.00 |
10,059 |
1.00 |
3,205 |
|
32 |
0.50 |
22 |
521 |
53 |
1.00 |
10,059 |
1.00 |
3,205 |
|
48 |
0.75 |
22 |
521 |
53 |
1.00 |
10,059 |
1.00 |
3,205 |
|
64 |
1.00 |
22 |
521 |
53 |
1.00 |
10,059 |
1.00 |
3,205 |
|
80 |
1.25 |
22 |
521 |
53 |
1.00 |
10,059 |
1.00 |
3,205 |
|
96 |
1.50 |
22 |
521 |
53 |
1.00 |
10,059 |
1.00 |
3,205 |
|
112 |
1.75 |
22 |
521 |
53 |
1.00 |
10,059 |
1.00 |
3,205 |
|
128 |
2.00 |
22 |
521 |
53 |
1.00 |
10,059 |
1.00 |
3,205 |
Back to Advisory Statistics
Back to Top
|
Class |
Waits |
Total Wait Time (s) |
Avg Time (ms) |
|
data block |
827,763 |
564 |
1 |
|
segment header |
9 |
0 |
1 |
|
2nd level bmb |
3 |
0 |
3 |
Back to Wait Statistics
Back to Top
|
Enqueue Type (Request Reason) |
Requests |
Succ Gets |
Failed Gets |
Waits |
Wt Time (s) |
Av Wt Time(ms) |
|
RO-Multiple
Object Reuse (fast object reuse) |
1,791 |
1,791 |
0 |
168 |
0 |
1.78 |
|
TX-Transaction (index
contention) |
2 |
2 |
0 |
2 |
0 |
5.50 |
|
PS-PX Process
Reservation |
2,597 |
2,306 |
284 |
61 |
0 |
0.13 |
|
TX-Transaction
(row lock contention) |
24 |
2 |
22 |
2 |
0 |
1.00 |
|
TX-Transaction |
4,160 |
4,156 |
0 |
1 |
0 |
1.00 |
|
TM-DML |
24,431 |
23,917 |
514 |
1 |
0 |
0.00 |
Back to Wait Statistics
Back to Top
|
Undo TS# |
Num Undo Blocks (K) |
Number of Transactions |
Max Qry Len (s) |
Max Tx Concurcy |
Min/Max TR (mins) |
STO/ OOS |
uS/uR/uU/ eS/eR/eU |
|
32 |
1.07 |
5,052 |
2,572 |
8 |
|
0/0 |
0/0/0/0/0/0 |
Back to Undo Statistics
Back to Top
|
End Time |
Num Undo Blocks |
Number of Transactions |
Max Qry Len (s) |
Max Tx Concy |
Tun Ret (mins) |
STO/ OOS |
uS/uR/uU/ eS/eR/eU |
|
26-Oct 00:32 |
159 |
581 |
2,572 |
6 |
56 |
0/0 |
0/0/0/0/0/0 |
|
26-Oct 00:22 |
69 |
560 |
1,971 |
5 |
46 |
0/0 |
0/0/0/0/0/0 |
|
26-Oct 00:12 |
377 |
1,891 |
1,370 |
8 |
36 |
0/0 |
0/0/0/0/0/0 |
|
26-Oct 00:02 |
464 |
2,020 |
771 |
8 |
26 |
0/0 |
0/0/0/0/0/0 |
Back to Undo Statistics
Back to Top
|
Latch Name |
Get Requests |
Pct Get Miss |
Avg Slps /Miss |
Wait Time (s) |
NoWait Requests |
Pct NoWait Miss |
|
ASM db client latch |
1,917 |
0.00 |
|
0 |
0 |
|
|
AWR
Alerted Metric Element list |
10,748 |
0.00 |
|
0 |
0 |
|
|
Consistent RBA |
5,728 |
0.00 |
|
0 |
0 |
|
|
FAL request queue |
39 |
0.00 |
|
0 |
0 |
|
|
FAL subheap alocation |
39 |
0.00 |
|
0 |
0 |
|
|
FIB
s.o chain latch |
10 |
0.00 |
|
0 |
0 |
|
|
FOB
s.o list latch |
8,797 |
0.03 |
0.00 |
0 |
0 |
|
|
In memory undo latch |
31,203 |
0.01 |
0.25 |
0 |
4,756 |
0.02 |
|
JS mem alloc latch |
4 |
0.00 |
|
0 |
0 |
|
|
JS queue access latch |
4 |
0.00 |
|
0 |
0 |
|
|
JS
queue state obj latch |
10,950 |
0.00 |
|
0 |
0 |
|
|
JS
slv state obj latch |
3 |
0.00 |
|
0 |
0 |
|
|
KMG
MMAN ready and startup request latch |
608 |
0.00 |
|
0 |
0 |
|
|
KPON ksr channel latch |
364 |
0.00 |
|
0 |
0 |
|
|
KTF sga latch |
5 |
0.00 |
|
0 |
490 |
0.00 |
|
KWQMN
job cache list latch |
376 |
0.27 |
1.00 |
0 |
0 |
|
|
KWQP Pxxx Status |
213 |
0.00 |
|
0 |
0 |
|
|
MQL Tracking Latch |
0 |
|
|
0 |
37 |
0.00 |
|
Memory Management
Latch |
0 |
|
|
0 |
608 |
0.00 |
|
OS process |
1,242 |
0.00 |
|
0 |
0 |
|
|
OS process allocation |
1,429 |
0.00 |
|
0 |
0 |
|
|
OS process: request
allocation |
809 |
0.00 |
|
0 |
0 |
|
|
PL/SQL warning
settings |
12,318 |
0.00 |
|
0 |
0 |
|
|
SGA
IO buffer pool latch |
13 |
0.00 |
|
0 |
13 |
0.00 |
|
SQL memory manager
latch |
1 |
0.00 |
|
0 |
608 |
0.00 |
|
SQL
memory manager workarea list latch |
157,713 |
0.00 |
0.00 |
0 |
0 |
|
|
Shared B-Tree |
1,130 |
0.00 |
|
0 |
0 |
|
|
active checkpoint
queue latch |
50,308 |
0.08 |
0.00 |
0 |
0 |
|
|
active service list |
11,328 |
1.54 |
0.00 |
0 |
608 |
0.00 |
|
archive control |
72 |
0.00 |
|
0 |
0 |
|
|
archive process latch |
647 |
0.00 |
|
0 |
0 |
|
|
begin backup scn array |
421 |
0.00 |
|
0 |
0 |
|
|
bq:time
manger info latch |
66 |
0.00 |
|
0 |
0 |
|
|
bufq statistics |
5 |
0.00 |
|
0 |
0 |
|
|
cache buffer handles |
495,816 |
0.00 |
|
0 |
0 |
|
|
cache buffers chains |
109,169,318 |
0.09 |
0.04 |
0 |
7,614,433 |
0.00 |
|
cache buffers lru
chain |
53,293 |
0.09 |
0.18 |
0 |
8,011,202 |
0.12 |
|
cache table scan latch |
0 |
|
|
0 |
214,813 |
0.10 |
|
channel anchor |
730 |
0.00 |
|
0 |
0 |
|
|
channel handle pool
latch |
1,169 |
0.00 |
|
0 |
0 |
|
|
channel operations
parent latch |
16,448 |
0.04 |
0.00 |
0 |
0 |
|
|
checkpoint queue latch |
657,947 |
0.00 |
0.00 |
0 |
8,409 |
0.01 |
|
client/application
info |
6,771 |
0.00 |
|
0 |
0 |
|
|
commit callback
allocation |
648 |
0.00 |
|
0 |
0 |
|
|
compile environment
latch |
7,724 |
0.00 |
|
0 |
0 |
|
|
constraint object
allocation |
4 |
0.00 |
|
0 |
0 |
|
|
dictionary lookup |
239 |
0.00 |
|
0 |
0 |
|
|
dml lock allocation |
48,356 |
0.02 |
0.00 |
0 |
0 |
|
|
dummy allocation |
1,969 |
3.86 |
0.00 |
0 |
0 |
|
|
enqueue hash chains |
176,899 |
0.03 |
0.00 |
0 |
105 |
0.00 |
|
enqueues |
107,630 |
0.17 |
0.00 |
0 |
0 |
|
|
error message lists |
1,303 |
3.53 |
0.00 |
0 |
0 |
|
|
event group latch |
401 |
0.00 |
|
0 |
0 |
|
|
file cache latch |
1,394 |
0.00 |
|
0 |
0 |
|
|
first spare latch |
2,389 |
0.13 |
0.00 |
0 |
0 |
|
|
global
KZLD latch for mem in SGA |
389 |
0.00 |
|
0 |
0 |
|
|
global
ctx hash table latch |
120 |
0.00 |
|
0 |
0 |
|
|
global tx hash mapping |
14,246 |
0.00 |
|
0 |
0 |
|
|
hash
table column usage latch |
157 |
0.00 |
|
0 |
8,331 |
0.00 |
|
hash table
modification latch |
71 |
0.00 |
|
0 |
0 |
|
|
job workq parent latch |
0 |
|
|
0 |
2 |
0.00 |
|
job_queue_processes
parameter latch |
31 |
0.00 |
|
0 |
0 |
|
|
kks stats |
2,125 |
0.00 |
|
0 |
0 |
|
|
ksuosstats global area |
139 |
0.00 |
|
0 |
0 |
|
|
ktm global data |
232 |
0.00 |
|
0 |
0 |
|
|
kwqbsn:qsga |
1,058 |
0.00 |
|
0 |
0 |
|
|
lgwr LWN SCN |
5,746 |
0.02 |
0.00 |
0 |
0 |
|
|
library cache |
1,165,058 |
0.03 |
0.04 |
0 |
99 |
0.00 |
|
library cache load
lock |
1,806 |
0.00 |
|
0 |
0 |
|
|
library cache lock |
300,247 |
0.05 |
0.00 |
0 |
0 |
|
|
library cache lock
allocation |
19,557 |
0.01 |
0.00 |
0 |
0 |
|
|
library cache pin |
649,817 |
0.01 |
0.00 |
0 |
0 |
|
|
library cache pin
allocation |
5,721 |
0.02 |
0.00 |
0 |
0 |
|
|
list of block
allocation |
1,209 |
0.00 |
|
0 |
0 |
|
|
loader state object
freelist |
410 |
0.00 |
|
0 |
0 |
|
|
logminer context
allocation |
1 |
0.00 |
|
0 |
0 |
|
|
longop free list
parent |
17 |
0.00 |
|
0 |
35 |
0.00 |
|
message
pool operations parent latch |
1,191 |
0.08 |
0.00 |
0 |
0 |
|
|
messages |
130,303 |
0.11 |
0.00 |
0 |
0 |
|
|
mostly latch-free SCN |
5,750 |
0.10 |
0.00 |
0 |
0 |
|
|
multiblock read
objects |
433,005 |
0.03 |
0.02 |
0 |
0 |
|
|
ncodef allocation
latch |
29 |
0.00 |
|
0 |
0 |
|
|
object queue header
heap |
48,940 |
0.00 |
0.00 |
0 |
24,223 |
0.00 |
|
object queue header
operation |
12,494,864 |
0.00 |
0.03 |
0 |
0 |
|
|
object stats
modification |
559 |
0.00 |
|
0 |
0 |
|
|
parallel query alloc
buffer |
8,416 |
0.19 |
0.00 |
0 |
0 |
|
|
parallel query stats |
1,019 |
5.30 |
0.00 |
0 |
0 |
|
|
parameter table
allocation management |
2,761 |
5.29 |
0.00 |
0 |
0 |
|
|
post/wait queue |
8,446 |
0.07 |
0.00 |
0 |
3,574 |
0.20 |
|
process allocation |
956 |
0.00 |
|
0 |
401 |
0.00 |
|
process group creation |
809 |
0.00 |
|
0 |
0 |
|
|
process queue |
5,030 |
0.83 |
0.00 |
0 |
0 |
|
|
process queue
reference |
348,470 |
0.06 |
0.00 |
0 |
31,215 |
7048.38 |
|
qmn task queue latch |
1,630 |
0.55 |
1.00 |
0 |
0 |
|
|
query server freelists |
5,029 |
2.45 |
0.00 |
0 |
0 |
|
|
query server process |
0 |
|
|
0 |
4 |
0.00 |
|
redo allocation |
27,742 |
0.05 |
0.00 |
0 |
46,881 |
0.26 |
|
redo copy |
0 |
|
|
0 |
46,935 |
0.19 |
|
redo writing |
68,033 |
0.04 |
0.03 |
0 |
0 |
|
|
resmgr group change
latch |
2,791 |
0.00 |
|
0 |
0 |
|
|
resmgr:actses active
list |
2,288 |
0.00 |
|
0 |
0 |
|
|
resmgr:actses change
group |
1,605 |
0.00 |
|
0 |
0 |
|
|
resmgr:free threads
list |
1,965 |
5.14 |
0.00 |
0 |
0 |
|
|
resmgr:schema config |
9 |
0.00 |
|
0 |
0 |
|
|
row cache objects |
653,584 |
0.03 |
0.00 |
0 |
0 |
|
|
rules engine aggregate
statistics |
56 |
0.00 |
|
0 |
0 |
|
|
rules
engine rule set statistics |
324 |
0.00 |
|
0 |
0 |
|
|
rules engine rule
statistics |
112 |
0.00 |
|
0 |
0 |
|
|
sequence cache |
3,117 |
0.00 |
|
0 |
0 |
|
|
session allocation |
229,399 |
0.21 |
0.00 |
0 |
0 |
|
|
session idle bit |
167,976 |
0.00 |
0.00 |
0 |
0 |
|
|
session state list
latch |
3,405 |
2.44 |
0.00 |
0 |
0 |
|
|
session switching |
29 |
0.00 |
|
0 |
0 |
|
|
session timer |
608 |
0.00 |
|
0 |
0 |
|
|
shared pool |
93,395 |
0.61 |
0.00 |
0 |
0 |
|
|
shared pool sim alloc |
4 |
0.00 |
|
0 |
0 |
|
|
shared pool simulator |
19,799 |
0.00 |
|
0 |
0 |
|
|
slave class |
2 |
0.00 |
|
0 |
0 |
|
|
slave class create |
8 |
12.50 |
1.00 |
0 |
0 |
|
|
sort extent pool |
386 |
0.00 |
|
0 |
0 |
|
|
state object free list |
2 |
0.00 |
|
0 |
0 |
|
|
statistics aggregation |
112 |
0.00 |
|
0 |
0 |
|
|
temp
lob duration state obj allocation |
3 |
0.00 |
|
0 |
0 |
|
|
temporary
table state object allocation |
16 |
0.00 |
|
0 |
0 |
|
|
threshold alerts latch |
405 |
0.00 |
|
0 |
0 |
|
|
transaction allocation |
96,661 |
0.00 |
0.00 |
0 |
0 |
|
|
transaction branch
allocation |
1,631 |
0.00 |
|
0 |
0 |
|
|
undo global data |
38,334 |
0.02 |
0.00 |
0 |
0 |
|
|
user lock |
1,563 |
0.00 |
|
0 |
0 |
|
Back to Latch Statistics
Back to Top
|
Latch Name |
Get Requests |
Misses |
Sleeps |
Spin Gets |
Sleep1 |
Sleep2 |
Sleep3 |
|
cache buffers chains |
109,169,318 |
93,163 |
3,809 |
89,423 |
0 |
0 |
0 |
|
shared pool |
93,395 |
571 |
1 |
570 |
0 |
0 |
0 |
|
library cache |
1,165,058 |
314 |
13 |
306 |
0 |
0 |
0 |
|
multiblock read
objects |
433,005 |
133 |
3 |
130 |
0 |
0 |
0 |
|
object queue header
operation |
12,494,864 |
117 |
4 |
113 |
0 |
0 |
0 |
|
cache buffers lru
chain |
53,293 |
49 |
9 |
40 |
0 |
0 |
0 |
|
redo writing |
68,033 |
29 |
1 |
28 |
0 |
0 |
0 |
|
qmn task queue latch |
1,630 |
9 |
9 |
0 |
0 |
0 |
0 |
|
In memory undo latch |
31,203 |
4 |
1 |
3 |
0 |
0 |
0 |
|
KWQMN
job cache list latch |
376 |
1 |
1 |
0 |
0 |
0 |
0 |
|
slave class create |
8 |
1 |
1 |
0 |
0 |
0 |
0 |
Back to Latch Statistics
Back to Top
|
Latch Name |
Where |
NoWait Misses |
Sleeps |
Waiter Sleeps |
|
In memory undo latch |
kticmt: child |
0 |
1 |
0 |
|
KWQMN
job cache list latch |
kwqmnuji: update job
item |
0 |
1 |
0 |
|
cache buffers chains |
kcbgtcr: kslbegin excl |
0 |
10,267 |
10,178 |
|
cache buffers chains |
kcbrls: kslbegin |
0 |
70 |
195 |
|
cache buffers chains |
kcbzwb |
0 |
55 |
17 |
|
cache buffers chains |
kcbzgb: scan from tail.
nowait |
0 |
22 |
0 |
|
cache buffers chains |
kcbgtcr: fast path |
0 |
14 |
13 |
|
cache buffers chains |
kcbbic2 |
0 |
6 |
0 |
|
cache buffers chains |
kcbchg:
kslbegin: bufs not pinned |
0 |
6 |
6 |
|
cache buffers chains |
kcbzib: finish free bufs |
0 |
6 |
30 |
|
cache buffers chains |
kcbgtcr: kslbegin
shared |
0 |
4 |
3 |
|
cache buffers chains |
kcbzib:
multi-block read: nowait |
0 |
4 |
0 |
|
cache buffers chains |
kcbgcur: kslbegin |
0 |
3 |
4 |
|
cache buffers chains |
kcbbxsv |
0 |
1 |
1 |
|
cache buffers chains |
kcbo_write_process |
0 |
1 |
3 |
|
cache buffers lru
chain |
kcbzgws |
0 |
9 |
0 |
|
event range base latch |
No latch |
0 |
9 |
9 |
|
library cache |
kglScanDependency |
0 |
13 |
0 |
|
multiblock read
objects |
kcbzib: normal mbr
free |
0 |
2 |
3 |
|
multiblock read
objects |
kcbzib: mbr get |
0 |
1 |
0 |
|
object queue header
operation |
kcbw_unlink_q |
0 |
4 |
1 |
|
object queue header
operation |
kcbo_switch_cq |
0 |
1 |
1 |
|
redo writing |
kcrfwcr |
0 |
1 |
0 |
|
shared pool |
kghfre |
0 |
1 |
0 |
|
slave class create |
ksvcreate |
0 |
1 |
0 |
Back to Latch Statistics
Back to Top
No data exists for this section of the
report.
Back to Latch Statistics
Back to Top
No data exists for this section of the
report.
Back to Latch Statistics
Back to Top
|
Owner |
Tablespace Name |
Object Name |
Subobject Name |
Obj. Type |
Logical Reads |
%Total |
|
AP |
APPS_TS_TX_IDX |
PAYMENTS_HEADERS_U1 |
|
INDEX |
20,771,616 |
34.16 |
|
AP |
APPS_TS_TX_DATA |
PAYMENTS_HEADERS_ALL |
|
TABLE |
8,145,040 |
13.39 |
|
INV |
APPS_TS_TX_IDX |
MTL_RESERVATIONS_N1 |
|
INDEX |
6,499,840 |
10.69 |
|
PO |
APPS_TS_TX_IDX |
PO_DISTRIBUTIONS_N4 |
|
INDEX |
3,359,072 |
5.52 |
|
ONT |
APPS_TS_TX_DATA |
OE_ORDER_LINES_ALL |
|
TABLE |
2,838,512 |
4.67 |
Back to Segment Statistics
Back to Top
|
Owner |
Tablespace Name |
Object Name |
Subobject Name |
Obj. Type |
Physical Reads |
%Total |
|
AP |
APPS_TS_TX_DATA |
PAYMENTS_LINES_ALL |
|
TABLE |
2,613,772 |
42.79 |
|
APPS |
APPS_TS_TX_DATA |
XXMDM_ITEM_DEBUG_LOG |
|
TABLE |
771,955 |
12.64 |
|
INV |
APPS_TS_TX_DATA |
MTL_SYSTEM_ITEMS_B |
|
TABLE |
569,920 |
9.33 |
|
PO |
APPS_TS_TX_DATA |
PO_LINES_ALL |
|
TABLE |
416,392 |
6.82 |
|
ONT |
APPS_TS_TX_DATA |
OE_ORDER_HEADERS_ALL |
|
TABLE |
292,582 |
4.79 |
Back to Segment Statistics
Back to Top
|
Owner |
Tablespace Name |
Object Name |
Subobject Name |
Obj. Type |
Row Lock Waits |
% of Capture |
|
APPLSYS |
APPS_TS_TX_DATA |
FND_CONCURRENT_REQUESTS |
|
TABLE |
44 |
88.00 |
|
APPLSYS |
APPS_TS_TX_DATA |
FND_CONC_PROG_ONSITE_INFO |
|
TABLE |
4 |
8.00 |
|
APPLSYS |
APPS_TS_TX_IDX |
FND_CONCURRENT_REQUESTS_N3 |
|
INDEX |
2 |
4.00 |
Back to Segment Statistics
Back to Top
No data exists for this section of the
report.
Back to Segment Statistics
Back to Top
|
Owner |
Tablespace Name |
Object Name |
Subobject Name |
Obj. Type |
Buffer Busy Waits |
% of Capture |
|
APPLSYS |
APPS_TS_TX_DATA |
FND_CONCURRENT_PROCESSES |
|
TABLE |
4 |
33.33 |
|
APPLSYS |
APPS_TS_TX_IDX |
FND_CONCURRENT_PROCESSES_N1 |
|
INDEX |
2 |
16.67 |
|
APPLSYS |
APPS_TS_TX_IDX |
FND_CONC_RELEASE_CLASSES_N2 |
|
INDEX |
2 |
16.67 |
|
APPLSYS |
APPS_TS_TX_DATA |
FND_CONCURRENT_REQUESTS |
|
TABLE |
1 |
8.33 |
|
APPLSYS |
APPS_TS_TX_IDX |
FND_CONCURRENT_REQUESTS_N2 |
|
INDEX |
1 |
8.33 |
Back to Segment Statistics
Back to Top
|
Cache |
Get Requests |
Pct Miss |
Scan Reqs |
Pct Miss |
Mod Reqs |
Final Usage |
|
dc_awr_control |
34 |
0.00 |
0 |
|
2 |
3 |
|
dc_database_links |
9,853 |
0.00 |
0 |
|
0 |
5 |
|
dc_files |
81 |
0.00 |
0 |
|
0 |
81 |
|
dc_free_extents |
149 |
0.00 |
0 |
|
0 |
149 |
|
dc_global_oids |
3,276 |
0.00 |
0 |
|
0 |
126 |
|
dc_histogram_data |
243 |
0.00 |
0 |
|
0 |
5,028 |
|
dc_histogram_defs |
4,065 |
29.10 |
0 |
|
570 |
22,189 |
|
dc_object_grants |
90 |
0.00 |
0 |
|
0 |
639 |
|
dc_object_ids |
13,945 |
3.83 |
0 |
|
126 |
6,262 |
|
dc_objects |
5,660 |
2.23 |
0 |
|
1,233 |
4,180 |
|
dc_profiles |
390 |
0.00 |
0 |
|
0 |
1 |
|
dc_rollback_segments |
2,842 |
0.00 |
0 |
|
0 |
176 |
|
dc_segments |
4,470 |
3.24 |
0 |
|
1,107 |
5,212 |
|
dc_sequences |
159 |
0.00 |
0 |
|
159 |
43 |
|
dc_table_scns |
70 |
0.00 |
0 |
|
2 |
24 |
|
dc_tablespace_quotas |
1,420 |
0.00 |
0 |
|
0 |
15 |
|
dc_tablespaces |
71,252 |
0.00 |
0 |
|
0 |
37 |
|
dc_usernames |
5,152 |
0.00 |
0 |
|
0 |
98 |
|
dc_users |
98,472 |
0.00 |
0 |
|
0 |
132 |
|
global database name |
4 |
0.00 |
0 |
|
0 |
1 |
|
outstanding_alerts |
183 |
0.00 |
0 |
|
0 |
58 |
|
Namespace |
Get Requests |
Pct Miss |
Pin Requests |
Pct Miss |
Reloads |
Invali- dations |
|
BODY |
4,851 |
0.00 |
136,980 |
0.00 |
0 |
0 |
|
CLUSTER |
2 |
0.00 |
2 |
0.00 |
0 |
0 |
|
INDEX |
637 |
21.04 |
2,080 |
18.56 |
126 |
0 |
|
PIPE |
360 |
0.00 |
360 |
0.00 |
0 |
0 |
|
SQL AREA |
28 |
100.00 |
437,167 |
0.23 |
373 |
231 |
|
TABLE/PROCEDURE |
1,975 |
0.51 |
154,278 |
0.61 |
252 |
0 |
|
TRIGGER |
1,784 |
0.00 |
3,458 |
0.00 |
0 |
0 |
|
Category |
Alloc (MB) |
Used (MB) |
Avg Alloc (MB) |
Std Dev Alloc (MB) |
Max Alloc (MB) |
Hist Max Alloc (MB) |
Num Proc |
Num Alloc |
|
|
B |
Other |
268.87 |
|
2.12 |
3.50 |
22 |
40 |
127 |
127 |
|
|
Freeable |
52.75 |
0.00 |
0.75 |
0.87 |
7 |
|
70 |
70 |
|
|
SQL |
21.96 |
12.53 |
0.18 |
0.48 |
5 |
8 |
119 |
107 |
|
|
PL/SQL |
6.83 |
3.27 |
0.05 |
0.07 |
0 |
0 |
127 |
123 |
|
|
JAVA |
2.18 |
2.17 |
1.09 |
0.00 |
1 |
2 |
2 |
2 |
|
E |
Other |
267.90 |
|
2.23 |
3.63 |
22 |
40 |
120 |
120 |
|
|
Freeable |
48.00 |
0.00 |
0.74 |
0.91 |
7 |
|
65 |
65 |
|
|
SQL |
20.48 |
11.33 |
0.18 |
0.49 |
5 |
8 |
112 |
105 |
|
|
PL/SQL |
6.61 |
2.99 |
0.06 |
0.06 |
0 |
0 |
120 |
120 |
|
|
JAVA |
2.18 |
2.17 |
1.09 |
0.00 |
1 |
2 |
2 |
2 |
Back to Memory Statistics
Back to Top
|
SGA regions |
Begin Size (Bytes) |
End Size (Bytes) (if
different) |
|
Database Buffers |
520,093,696 |
|
|
Fixed Size |
2,082,480 |
|
|
Redo Buffers |
14,692,352 |
|
|
Variable Size |
5,905,582,416 |
|
Back to Memory Statistics
Back to Top
|
Pool |
Name |
Begin MB |
End MB |
% Diff |
|
java |
free memory |
46.24 |
46.24 |
0.00 |
|
java |
joxlod exec hp |
16.59 |
16.59 |
0.00 |
|
java |
joxs heap |
1.17 |
1.17 |
0.00 |
|
large |
free memory |
15.92 |
15.94 |
0.10 |
|
shared |
ASH buffers |
22.50 |
22.50 |
0.00 |
|
shared |
CCursor |
44.14 |
44.24 |
0.23 |
|
shared |
Heap0: KGL |
36.39 |
36.43 |
0.12 |
|
shared |
KGLS heap |
33.92 |
33.92 |
0.00 |
|
shared |
KQR M PO |
17.00 |
17.00 |
0.01 |
|
shared |
PCursor |
28.92 |
28.96 |
0.12 |
|
shared |
PL/SQL MPCODE |
57.02 |
57.02 |
0.00 |
|
shared |
free memory |
453.31 |
451.76 |
-0.34 |
|
shared |
ktcmvcb |
127.52 |
127.52 |
0.00 |
|
shared |
library cache |
70.52 |
70.57 |
0.07 |
|
shared |
obj stat memo |
21.00 |
21.03 |
0.17 |
|
shared |
private strands |
22.17 |
22.17 |
0.00 |
|
shared |
sql area |
421.74 |
423.00 |
0.30 |
|
streams |
free memory |
31.99 |
31.99 |
0.00 |
|
|
buffer_cache |
496.00 |
496.00 |
0.00 |
|
|
fixed_sga |
1.99 |
1.99 |
0.00 |
|
|
log_buffer |
14.01 |
14.01 |
0.00 |
Back to Memory Statistics
Back to Top
|
Session Type |
CPU Time |
User I/O Time |
Sys I/O Time |
|
QMON Slaves |
80,447 |
384,179 |
0 |
|
QMON Coordinator |
72,761 |
0 |
0 |
Back to Streams Statistics
Back to Top
No data exists for this section of the
report.
Back to Streams Statistics
Back to Top
No data exists for this section of the
report.
Back to Streams Statistics
Back to Top
|
Queue Schema and Name |
Incoming per second |
Outgoing per second |
Spilled per second |
Diff Pct Spilled |
|
APPLSYS.WF_CONTROL |
0 |
0 |
0 |
0 |
Back to Streams Statistics
Back to Top
|
Subscriber Name |
Incoming per second |
Outgoing per second |
Spilled per second |
|
WFBESCL_1127 |
0 |
0 |
0 |
|
WFBESCL_1128 |
0 |
0 |
0 |
|
WFBESCL_1129 |
0 |
0 |
0 |
Back to Streams Statistics
Back to Top
|
Ruleset Name |
Evals |
Fast Evals |
SQL Execs |
CPU Time |
Elapsed Time |
|
APPLSYS.WF_DEFERRED_QUEUE_M_R |
56 |
0 |
56 |
0 |
0 |
|
SYS.ALERT_QUE_R |
0 |
0 |
0 |
0 |
0 |
|
APPLSYS.WF_JAVA_DEFERRED_R |
0 |
0 |
0 |
0 |
0 |
|
APPLSYS.WF_NOTIFICATION_OUT_R |
0 |
0 |
0 |
0 |
0 |
|
APPLSYS.FND_CP_GSM_OPP_AQ_R |
0 |
0 |
0 |
0 |
0 |
|
APPLSYS.WF_DEFERRED_R |
0 |
0 |
0 |
0 |
0 |
Back to Streams Statistics
Back to Top
No data exists for this section of the
report.
|
Parameter Name |
Begin value |
End value (if different) |
|
_b_tree_bitmap_plans |
FALSE |
|
|
_disable_image_check |
FALSE |
|
|
_fast_full_scan_enabled |
FALSE |
|
|
_index_join_enabled |
FALSE |
|
|
_like_with_bind_as_equality |
TRUE |
|
|
_log_switch_timeout |
1800 |
|
|
_sort_elimination_cost_ratio |
5 |
|
|
_sqlexec_progression_cost |
2147483647 |
|
|
_system_trig_enabled |
TRUE |
|
|
_trace_files_public |
TRUE |
|
|
aq_tm_processes |
1 |
|
|
background_dump_dest |
/exxx/exxxdb/10.2.0/admin/EXXX_xxxdb/bdump |
|
|
compatible |
10.2.0 |
|
|
control_file_record_keep_time |
10 |
|
|
control_files |
/exxx/dbdata/cntrl01.dbf,
/exxx/dbdata/cntrl02.dbf, /exxx/dbexxx/oracle/controlfile/cntrl03.dbf |
|
|
core_dump_dest |
/exxx/exxxdb/10.2.0/admin/EXXX_xxxdb/cdump |
|
|
cursor_sharing |
EXACT |
|
|
db_block_checking |
FALSE |
|
|
db_block_checksum |
TRUE |
|
|
db_block_size |
8192 |
|
|
db_cache_advice |
OFF |
|
|
db_cache_size |
0 |
|
|
db_file_multiblock_read_count |
8 |
|
|
db_files |
512 |
|
|
db_name |
EXXX |
|
|
dml_locks |
10000 |
|
|
job_queue_processes |
10 |
|
|
log_archive_dest_1 |
location=/exxx/dbdata/archive |
|
|
log_buffer |
14246912 |
|
|
log_checkpoint_interval |
100000 |
|
|
log_checkpoint_timeout |
1200 |
|
|
log_checkpoints_to_alert |
TRUE |
|
|
max_dump_file_size |
20480 |
|
|
nls_comp |
binary |
|
|
nls_date_format |
DD-MON-RR |
|
|
nls_language |
american |
|
|
nls_length_semantics |
BYTE |
|
|
nls_numeric_characters |
., |
|
|
nls_sort |
binary |
|
|
nls_territory |
america |
|
|
olap_page_pool_size |
4194304 |
|
|
open_cursors |
1500 |
|
|
optimizer_index_cost_adj |
100 |
|
|
optimizer_secure_view_merging |
FALSE |
|
|
parallel_max_servers |
8 |
|
|
parallel_min_servers |
0 |
|
|
pga_aggregate_target |
1073741824 |
|
|
plsql_code_type |
INTERPRETED |
|
|
plsql_native_library_dir |
/exxx/exxxdb/10.2.0/plsql/nativelib |
|
|
plsql_native_library_subdir_count |
149 |
|
|
plsql_optimize_level |
2 |
|
|
processes |
800 |
|
|
query_rewrite_enabled |
true |
|
|
session_cached_cursors |
500 |
|
|
sessions |
1600 |
|
|
sga_max_size |
6442450944 |
|
|
sga_target |
2147483648 |
|
|
shared_pool_reserved_size |
41943040 |
|
|
shared_pool_size |
419430400 |
|
|
timed_statistics |
TRUE |
|
|
undo_management |
AUTO |
|
|
undo_tablespace |
APPS_UNDOTS2 |
|
|
user_dump_dest |
/exxx/exxxdb/10.2.0/admin/EXXX_xxxdb/udump |
|
|
utl_file_dir |
/exxx/outputs/tmp,
/usr/tmp, /exxx/exxxdb/10.2.0/appsutil/outbound/EXXX_xxxdb, /exxx/xxtop/data/archive,
/exxx/xxtop/data/inbound, /exxx/xxtop/data/outbound, /exxx/xxtop/data/inbound/archive |
|
|
workarea_size_policy |
AUTO |
|
End
of Report