0% found this document useful (0 votes)

323 views166 pages

SP 07271130

This STATSPACK report summarizes database performance metrics for a PRDX31 instance on a Linux system with 28 CPUs and 125.5GB memory over a 60 minute period from 10:30AM to 11:30AM on July 27, 2016. Key findings include the instance using 48.59 minutes of 48.59 total minutes of CPU time, 4.86 million logical reads, and the top timed event being LGWR worker group idle at 8.9 seconds per wait.

Uploaded by

kam_chan_syd7562

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

323 views166 pages

SP 07271130

Uploaded by

kam_chan_syd7562

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as TXT, PDF, TXT or read online on Scribd

You are on page 1/ 166

STATSPACK report for

Database DB Id Instance Inst Num Startup Time Release RAC

~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
2148983765 PRDX31 1 16-Jul-16 22:21 12.1.0.2.0 YES

Host Name Platform CPUs Cores Sockets Memory (G)

~~~~ ---------------- ---------------------- ----- ----- ------- ------------
phlxdb01.baiada. Linux x86 64-bit 28 14 1 125.5

Snapshot Snap Id Snap Time Sessions Curs/Sess Comment

~~~~~~~~ ---------- ------------------ -------- --------- ------------------
Begin Snap: 2677 27-Jul-16 10:30:34 127 5.8
End Snap: 2678 27-Jul-16 11:30:34 136 5.5
Elapsed: 60.00 (mins) Av Act Sess: 1.0
DB time: 60.53 (mins) DB CPU: 48.59 (mins)

Cache Sizes Begin End

~~~~~~~~~~~ ---------- ----------
Buffer Cache: 2,192M Std Block Size: 8K
Shared Pool: 4,896M Log Buffer: 8,528K

Load Profile Per Second Per Transaction Per Exec Per Call
~~~~~~~~~~~~ ------------------ ----------------- ----------- -----------
DB time(s): 1.0 1.3 0.00 0.00
DB CPU(s): 0.8 1.0 0.00 0.00
Redo size: 13,141.4 16,330.3
Logical reads: 4,861.3 6,041.0
Block changes: 63.6 79.0
Physical reads: 22.5 27.9
Physical writes: 2.4 3.0
User calls: 205.2 254.9
Parses: 199.2 247.5
Hard parses: 7.8 9.7
W/A MB processed: 1.1 1.3
Logons: 7.2 8.9
Executes: 281.1 349.3
Rollbacks: 0.1 0.2
Transactions: 0.8

Instance Efficiency Indicators

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.54 Optimal W/A Exec %: 100.00
Library Hit %: 95.55 Soft Parse %: 96.08
Execute to Parse %: 29.13 Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 94.96 % Non-Parse CPU: 12.22

Shared Pool Statistics Begin End

------ ------
Memory Usage %: 86.78 85.35
% SQL with executions>1: 41.80 45.12
% Memory for SQL w/exec>1: 43.75 48.15

Top 5 Timed Events Avg %Total

~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
LGWR worker group idle 808 7,189 8898 25.0
AQPC idle 120 3,601 30005 12.5
heartbeat redo informer 3,600 3,600 1000 12.5
lreg timer 1,198 3,600 3005 12.5
Streams AQ: load balancer idle 720 3,595 4993 12.5
-------------------------------------------------------------
Host CPU (CPUs: 28 Cores: 14 Sockets: 1)
~~~~~~~~ Load Average
Begin End User System Idle WIO WCPU
------- ------- ------- ------- ------- ------- --------
2.78 1.38 3.66 0.99 95.33 0.03

Instance CPU
~~~~~~~~~~~~ % Time (seconds)
-------- --------------
Host: Total time (s): 99,942.1
Host: Busy CPU time (s): 4,668.4
% of time Host is Busy: 4.7
Instance: Total CPU time (s): 3,068.5
% of Busy CPU used for Instance: 65.7
Instance: Total Database time (s): 3,763.0
%DB time waiting for CPU (Resource Mgr): 0.0

Memory Statistics Begin End

~~~~~~~~~~~~~~~~~ ------------ ------------
Host Mem (MB): 128,551.1 128,551.1
SGA use (MB): 8,192.0 8,192.0
PGA use (MB): 819.9 842.5
% Host Mem used for SGA+PGA: 7.0 7.0
-------------------------------------------------------------

Time Model System Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Ordered by % of DB time desc, Statistic name

Statistic Time (s) % DB time

----------------------------------- -------------------- ---------
DB CPU 2,915.7 80.3
parse time elapsed 2,552.3 70.3
hard parse elapsed time 2,510.5 69.1
sql execute elapsed time 433.6 11.9
connection management call elapsed 74.8 2.1
PL/SQL execution elapsed time 12.9 .4
inbound PL/SQL rpc elapsed time 2.1 .1
RMAN cpu time (backup/restore) 2.0 .1
hard parse (sharing criteria) elaps 1.6 .0
PL/SQL compilation elapsed time 0.8 .0
repeated bind elapsed time 0.2 .0
failed parse elapsed time 0.0 .0
sequence load elapsed time 0.0 .0
hard parse (bind mismatch) elapsed 0.0 .0
DB time 3,632.0
background cpu time 152.8
background elapsed time 131.1
-------------------------------------------------------------
RAC Statistics DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Begin End
----- -----
Number of Instances: 2 2

Global Cache Load Profile

~~~~~~~~~~~~~~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Global Cache blocks received: 2.11 2.62
Global Cache blocks served: 2.29 2.84
GCS/GES messages received: 56.46 70.16
GCS/GES messages sent: 56.17 69.80
DBWR Fusion writes: 0.37 0.45
Estd Interconnect traffic (KB): 57.14

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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer access - local cache %: 99.50
Buffer access - remote cache %: 0.04
Buffer access - disk %: 0.46

Global Cache and Enqueue Services - Workload Characteristics

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Avg global enqueue get time (ms): 0.0

Avg global cache cr block receive time (ms): 0.2

Avg global cache current block receive time (ms): 0.3

Avg global cache cr block build time (ms): 0.0

Avg global cache cr block send time (ms): 0.0
Avg global cache cr block flush time (ms): 1.0
Global cache log flushes for cr blocks served %: 0.2

Avg global cache current block pin time (ms): 0.0

Avg global cache current block send time (ms): 0.0
Avg global cache current block flush time (ms): 0.0
Global cache log flushes for current blocks served %: 0.2

Global Cache and Enqueue Services - Messaging Statistics

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Avg message sent queue time (ms): 0.2
Avg message sent queue time on ksxp (ms): 0.7
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0

% of direct sent messages: 72.27

% of indirect sent messages: 23.45
% of flow controlled messages: 4.28
-------------------------------------------------------------
Foreground Wait Events DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)

Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
log switch/archive 60 100 601 10008 0.0 2.1
switch logfile command 18 0 29 1619 0.0 .1
cursor: pin S wait on X 199 0 24 121 0.1 .1
db file sequential read 82,167 0 23 0 28.4 .1
control file sequential read 46,561 0 22 0 16.1 .1
PX Deq: Slave Session Stats 56,620 0 19 0 19.5 .1
gc cr disk read 37,490 0 13 0 12.9 .0
reliable message 18,087 0 12 1 6.2 .0
enq: IV - contention 15,534 5 11 1 5.4 .0
enq: PS - contention 22,041 11 11 0 7.6 .0
IPC send completion sync 40,938 0 9 0 14.1 .0
Disk file operations I/O 89,266 0 9 0 30.8 .0
CRS call completion 130 0 6 46 0.0 .0
PX Deq: reap credit 432,585 100 4 0 149.3 .0
GPnP Initialization 130 0 3 22 0.0 .0
log file sync 2,300 0 2 1 0.8 .0
gc cr block 2-way 3,530 0 2 1 1.2 .0
gc current block 2-way 3,233 0 1 0 1.1 .0
ASM file metadata operation 486 0 1 3 0.2 .0
CSS initialization 440 0 1 3 0.2 .0
library cache lock 1,512 40 1 1 0.5 .0
PX Deq: Signal ACK EXT 36,174 0 1 0 12.5 .0
CSS operation: action 500 0 1 1 0.2 .0
recovery area: computing bac 1,082 0 1 0 0.4 .0
log file sequential read 199 0 1 3 0.1 .0
gc current grant busy 1,153 0 0 0 0.4 .0
recovery area: computing obs 18 0 0 25 0.0 .0
kksfbc child completion 9 100 0 49 0.0 .0
dbms_file_transfer I/O 316 0 0 1 0.1 .0
GPnP Get Item 130 0 0 3 0.0 .0
control file parallel write 498 0 0 1 0.2 .0
name-service call wait 4 0 0 75 0.0 .0
control file single write 169 0 0 1 0.1 .0
GPnP Termination 130 0 0 2 0.0 .0
kfk: async disk IO 54 0 0 3 0.0 .0
library cache: mutex X 38 0 0 4 0.0 .0
row cache lock 1,234 0 0 0 0.4 .0
latch: shared pool 172 0 0 1 0.1 .0
enq: CF - contention 154 0 0 1 0.1 .0
recovery area: computing dro 2 0 0 64 0.0 .0
CSS group membership query 130 0 0 1 0.0 .0
SQL*Net break/reset to clien 906 0 0 0 0.3 .0
Log archive I/O 18 0 0 5 0.0 .0
ges inquiry response 271 0 0 0 0.1 .0
cursor: pin S 4 0 0 23 0.0 .0
oracle thread bootstrap 1 0 0 91 0.0 .0
gc current grant 2-way 190 0 0 0 0.1 .0
CSS operation: query 620 0 0 0 0.2 .0
CSS operation: data query 260 0 0 0 0.1 .0
gc cr block busy 44 0 0 1 0.0 .0
DFS lock handle 120 0 0 0 0.0 .0
gc cr grant 2-way 180 0 0 0 0.1 .0
Foreground Wait Events DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)

Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
library cache pin 148 0 0 0 0.1 .0
SQL*Net more data to client 948 0 0 0 0.3 .0
gc cr multi block request 40 0 0 1 0.0 .0
db file scattered read 6 0 0 3 0.0 .0
gc cr block lost 21 0 0 1 0.0 .0
enq: JS - job run lock - syn 31 100 0 0 0.0 .0
log file switch (checkpoint 2 0 0 6 0.0 .0
db file parallel read 3 0 0 4 0.0 .0
direct path read 23 0 0 0 0.0 .0
cursor: pin X 2 0 0 5 0.0 .0
enq: FB - contention 22 0 0 0 0.0 .0
KJC: Wait for msg sends to c 56 0 0 0 0.0 .0
SQL*Net vector data to clien 268 0 0 0 0.1 .0
enq: WL - contention 10 100 0 0 0.0 .0
latch: call allocation 30 0 0 0 0.0 .0
gc current block busy 5 0 0 1 0.0 .0
get branch/thread/sequence e 18 0 0 0 0.0 .0
latch: row cache objects 21 0 0 0 0.0 .0
SQL*Net message from client 511,059 0 196,125 384 176.4
jobq slave wait 3,146 100 1,569 499 1.1
PX Deq: Execution Msg 61,338 0 60 1 21.2
PX Deq: Join ACK 72,348 0 38 1 25.0
PX Deq: Parse Reply 36,174 0 15 0 12.5
PX Deq: Execute Reply 36,194 0 5 0 12.5
SQL*Net message to client 511,068 0 1 0 176.4
KSV master wait 1,416 0 1 1 0.5
PX Deq: Msg Fragment 130 0 0 0 0.0
SQL*Net more data from clien 299 0 0 0 0.1
PX Deq Credit: send blkd 5 0 0 0 0.0
-------------------------------------------------------------

Background Wait Events DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)

Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
LGWR worker group idle 808 0 7,189 8898 0.3 25.0
AQPC idle 120 100 3,601 30005 0.0 12.5
heartbeat redo informer 3,600 0 3,600 1000 1.2 12.5
lreg timer 1,198 100 3,600 3005 0.4 12.5
Streams AQ: load balancer id 720 0 3,595 4993 0.2 12.5
REPL Capture/Apply: RAC AQ q 47 100 3,535 75206 0.0 12.3
Failed Logon Delay 38 100 38 1000 0.0 .1
Disk file operations I/O 2,281 0 11 5 0.8 .0
control file sequential read 21,792 0 6 0 7.5 .0
log file parallel write 6,621 0 5 1 2.3 .0
oracle thread bootstrap 212 0 3 16 0.1 .0
ASM file metadata operation 12,472 0 3 0 4.3 .0
RMAN backup & recovery I/O 659 0 2 4 0.2 .0
reliable message 913 0 2 2 0.3 .0
ksdxexeotherwait 114 0 2 17 0.0 .0
libcache interrupt action by 65,229 0 2 0 22.5 .0
control file parallel write 2,724 0 2 1 0.9 .0
enq: IV - contention 4,954 0 2 0 1.7 .0
PX Deq: Slave Join Frag 20,446 0 2 0 7.1 .0
enq: CF - contention 148 0 1 9 0.1 .0
PX Deq: reap credit 65,609 100 1 0 22.6 .0
enq: XR - database force log 1,199 0 0 0 0.4 .0
enq: PS - contention 962 18 0 1 0.3 .0
IPC send completion sync 1,589 0 0 0 0.5 .0
db file sequential read 105 0 0 3 0.0 .0
kfk: async disk IO 131 0 0 2 0.0 .0
CGS wait for IPC msg 34,816 100 0 0 12.0 .0
log file sequential read 739 0 0 0 0.3 .0
db file parallel write 901 0 0 0 0.3 .0
ksxr poll remote instances 24,072 100 0 0 8.3 .0
os thread creation 213 0 0 1 0.1 .0
gc current block lost 2 0 0 125 0.0 .0
PX Deq: Slave Session Stats 1,578 0 0 0 0.5 .0
latch: ges resource hash lis 2,277 0 0 0 0.8 .0
row cache cleanup 66,645 0 0 0 23.0 .0
gc cr block 2-way 362 0 0 0 0.1 .0
CSS operation: action 245 0 0 1 0.1 .0
Log archive I/O 42 0 0 4 0.0 .0
gc current block 2-way 280 0 0 0 0.1 .0
log file single write 240 0 0 0 0.1 .0
control file single write 84 0 0 1 0.0 .0
name-service call wait 2 0 0 50 0.0 .0
CSS operation: data query 165 0 0 1 0.1 .0
DFS lock handle 230 100 0 0 0.1 .0
row cache process 69,283 0 0 0 23.9 .0
CSS operation: data update 111 0 0 1 0.0 .0
ADR block file read 21 0 0 1 0.0 .0
enq: RS - prevent file delet 64 100 0 0 0.0 .0
asynch descriptor resize 10,841 100 0 0 3.7 .0
direct path write 47 0 0 1 0.0 .0
PX Deq: Signal ACK EXT 1,578 0 0 0 0.5 .0

Background Wait Events DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)

Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
LGWR all worker groups 404 0 0 0 0.1 .0
gc current grant busy 61 0 0 0 0.0 .0
gcs log flush sync 24 0 0 1 0.0 .0
enq: WL - contention 29 100 0 0 0.0 .0
gc current grant 2-way 29 0 0 0 0.0 .0
enq: TA - contention 23 0 0 0 0.0 .0
latch: shared pool 15 0 0 0 0.0 .0
get branch/thread/sequence e 78 0 0 0 0.0 .0
enq: TD - KTF dump entries 12 0 0 0 0.0 .0
library cache lock 16 0 0 0 0.0 .0
library cache pin 16 0 0 0 0.0 .0
enq: TM - contention 8 0 0 1 0.0 .0
CSS initialization 2 0 0 2 0.0 .0
latch free 40 0 0 0 0.0 .0
row cache lock 7 0 0 1 0.0 .0
log file sync 5 0 0 1 0.0 .0
ges inquiry response 10 0 0 0 0.0 .0
SQL*Net break/reset to clien 152 0 0 0 0.1 .0
enq: WF - contention 8 0 0 0 0.0 .0
gc cr grant 2-way 7 0 0 0 0.0 .0
LGWR wait for redo copy 49 0 0 0 0.0 .0
gc cr multi block request 4 0 0 1 0.0 .0
gc cr block lost 3 0 0 1 0.0 .0
ADR block file write 10 0 0 0 0.0 .0
rdbms ipc message 209,241 30 100,740 481 72.2
Space Manager: slave idle wa 6,032 0 18,000 2984 2.1
class slave wait 723,949 99 17,991 25 249.9
PX Idle Wait 20,448 0 7,378 361 7.1
GCR sleep 25,772 7 7,194 279 8.9
ges remote message 165,021 34 7,193 44 57.0
gcs remote message 319,464 70 7,191 23 110.3
DIAG idle wait 61,994 87 7,188 116 21.4
PING 1,542 19 3,606 2338 0.5
shared server idle wait 120 100 3,601 30009 0.0
dispatcher timer 60 100 3,601 60009 0.0
ASM background timer 8,278 0 3,600 435 2.9
pmon timer 1,308 90 3,600 2752 0.5
wait for unread message on b 1,200 100 3,600 3000 0.4
smon timer 1,200 0 3,599 3000 0.4
Streams AQ: qmn slave idle w 848 0 3,597 4242 0.3
Streams AQ: qmn coordinator 256 50 3,585 14004 0.1
SQL*Net message from client 23,509 0 83 4 8.1
KSV master wait 5,429 40 2 0 1.9
PX Deq: Join ACK 3,156 0 2 1 1.1
PX Deq: Parse Reply 1,578 0 1 0 0.5
PX Deq: Execute Reply 1,578 0 0 0 0.5
SQL*Net message to client 18,259 0 0 0 6.3
PX Deq Credit: send blkd 60 0 0 0 0.0
-------------------------------------------------------------

Wait Events (fg and bg) DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> s - second, cs - centisecond, ms - millisecond, us - microsecond
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)

Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
LGWR worker group idle 808 0 7,189 8898 0.3 25.0
AQPC idle 120 100 3,601 30005 0.0 12.5
heartbeat redo informer 3,600 0 3,600 1000 1.2 12.5
lreg timer 1,198 100 3,600 3005 0.4 12.5
Streams AQ: load balancer id 720 0 3,595 4993 0.2 12.5
REPL Capture/Apply: RAC AQ q 47 100 3,535 75206 0.0 12.3
log switch/archive 60 100 601 10008 0.0 2.1
Failed Logon Delay 38 100 38 1000 0.0 .1
switch logfile command 18 0 29 1619 0.0 .1
control file sequential read 68,353 0 29 0 23.6 .1
cursor: pin S wait on X 199 0 24 121 0.1 .1
db file sequential read 82,272 0 23 0 28.4 .1
Disk file operations I/O 91,547 0 20 0 31.6 .1
PX Deq: Slave Session Stats 58,198 0 19 0 20.1 .1
reliable message 19,000 0 14 1 6.6 .0
gc cr disk read 37,490 0 13 0 12.9 .0
enq: IV - contention 20,488 4 13 1 7.1 .0
enq: PS - contention 23,003 11 11 0 7.9 .0
IPC send completion sync 42,527 0 10 0 14.7 .0
CRS call completion 130 0 6 46 0.0 .0
log file parallel write 6,621 0 5 1 2.3 .0
PX Deq: reap credit 498,194 100 4 0 172.0 .0
ASM file metadata operation 12,958 0 4 0 4.5 .0
oracle thread bootstrap 213 0 3 16 0.1 .0
GPnP Initialization 130 0 3 22 0.0 .0
RMAN backup & recovery I/O 659 0 2 4 0.2 .0
log file sync 2,305 0 2 1 0.8 .0
control file parallel write 3,222 0 2 1 1.1 .0
gc cr block 2-way 3,892 0 2 0 1.3 .0
ksdxexeotherwait 114 0 2 17 0.0 .0
libcache interrupt action by 65,229 0 2 0 22.5 .0
PX Deq: Slave Join Frag 20,446 0 2 0 7.1 .0
gc current block 2-way 3,513 0 2 0 1.2 .0
enq: CF - contention 302 0 2 5 0.1 .0
CSS initialization 442 0 1 3 0.2 .0
library cache lock 1,528 39 1 1 0.5 .0
log file sequential read 938 0 1 1 0.3 .0
CSS operation: action 745 0 1 1 0.3 .0
PX Deq: Signal ACK EXT 37,752 0 1 0 13.0 .0
recovery area: computing bac 1,082 0 1 0 0.4 .0
gc current grant busy 1,214 0 1 0 0.4 .0
enq: XR - database force log 1,199 0 0 0 0.4 .0
kfk: async disk IO 185 0 0 3 0.1 .0
recovery area: computing obs 18 0 0 25 0.0 .0
kksfbc child completion 9 100 0 49 0.0 .0
dbms_file_transfer I/O 316 0 0 1 0.1 .0
name-service call wait 6 0 0 67 0.0 .0
control file single write 253 0 0 1 0.1 .0
GPnP Get Item 130 0 0 3 0.0 .0

Wait Events (fg and bg) DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
CGS wait for IPC msg 34,816 100 0 0 12.0 .0
db file parallel write 901 0 0 0 0.3 .0
ksxr poll remote instances 24,072 100 0 0 8.3 .0
os thread creation 213 0 0 1 0.1 .0
gc current block lost 2 0 0 125 0.0 .0
Log archive I/O 60 0 0 4 0.0 .0
GPnP Termination 130 0 0 2 0.0 .0
latch: ges resource hash lis 2,283 0 0 0 0.8 .0
row cache cleanup 66,645 0 0 0 23.0 .0
CSS operation: data query 425 0 0 0 0.1 .0
library cache: mutex X 38 0 0 4 0.0 .0
row cache lock 1,241 0 0 0 0.4 .0
latch: shared pool 187 0 0 1 0.1 .0
DFS lock handle 350 66 0 0 0.1 .0
recovery area: computing dro 2 0 0 64 0.0 .0
log file single write 240 0 0 0 0.1 .0
CSS group membership query 130 0 0 1 0.0 .0
SQL*Net break/reset to clien 1,058 0 0 0 0.4 .0
ges inquiry response 281 0 0 0 0.1 .0
cursor: pin S 4 0 0 23 0.0 .0
gc current grant 2-way 219 0 0 0 0.1 .0
row cache process 69,283 0 0 0 23.9 .0
CSS operation: query 626 0 0 0 0.2 .0
gc cr block busy 44 0 0 1 0.0 .0
gc cr grant 2-way 187 0 0 0 0.1 .0
CSS operation: data update 111 0 0 1 0.0 .0
library cache pin 164 0 0 0 0.1 .0
SQL*Net more data to client 948 0 0 0 0.3 .0
ADR block file read 21 0 0 1 0.0 .0
enq: RS - prevent file delet 64 100 0 0 0.0 .0
asynch descriptor resize 10,841 100 0 0 3.7 .0
direct path write 47 0 0 1 0.0 .0
gc cr multi block request 44 0 0 1 0.0 .0
LGWR all worker groups 404 0 0 0 0.1 .0
db file scattered read 6 0 0 3 0.0 .0
gcs log flush sync 24 0 0 1 0.0 .0
gc cr block lost 24 0 0 1 0.0 .0
enq: WL - contention 39 100 0 0 0.0 .0
enq: JS - job run lock - syn 31 100 0 0 0.0 .0
log file switch (checkpoint 2 0 0 6 0.0 .0
direct path read 25 0 0 0 0.0 .0
db file parallel read 3 0 0 4 0.0 .0
cursor: pin X 2 0 0 5 0.0 .0
enq: TA - contention 23 0 0 0 0.0 .0
enq: FB - contention 22 0 0 0 0.0 .0
get branch/thread/sequence e 96 0 0 0 0.0 .0
KJC: Wait for msg sends to c 59 0 0 0 0.0 .0
SQL*Net vector data to clien 268 0 0 0 0.1 .0
enq: TD - KTF dump entries 12 0 0 0 0.0 .0

Wait Events (fg and bg) DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
latch free 56 0 0 0 0.0 .0
enq: TM - contention 8 0 0 1 0.0 .0
latch: call allocation 31 0 0 0 0.0 .0
gc current block busy 5 0 0 1 0.0 .0
enq: WF - contention 8 0 0 0 0.0 .0
LGWR wait for redo copy 49 0 0 0 0.0 .0
ADR block file write 10 0 0 0 0.0 .0
latch: row cache objects 21 0 0 0 0.0 .0
SQL*Net message from client 534,568 0 196,208 367 184.5
rdbms ipc message 209,241 30 100,740 481 72.2
Space Manager: slave idle wa 6,032 0 18,000 2984 2.1
class slave wait 723,949 99 17,991 25 249.9
PX Idle Wait 20,448 0 7,378 361 7.1
GCR sleep 25,772 7 7,194 279 8.9
ges remote message 165,021 34 7,193 44 57.0
gcs remote message 319,464 70 7,191 23 110.3
DIAG idle wait 61,994 87 7,188 116 21.4
PING 1,542 19 3,606 2338 0.5
shared server idle wait 120 100 3,601 30009 0.0
dispatcher timer 60 100 3,601 60009 0.0
ASM background timer 8,278 0 3,600 435 2.9
pmon timer 1,308 90 3,600 2752 0.5
wait for unread message on b 1,200 100 3,600 3000 0.4
smon timer 1,200 0 3,599 3000 0.4
Streams AQ: qmn slave idle w 848 0 3,597 4242 0.3
Streams AQ: qmn coordinator 256 50 3,585 14004 0.1
jobq slave wait 3,146 100 1,569 499 1.1
PX Deq: Execution Msg 61,338 0 60 1 21.2
PX Deq: Join ACK 75,504 0 40 1 26.1
PX Deq: Parse Reply 37,752 0 16 0 13.0
PX Deq: Execute Reply 37,772 0 6 0 13.0
KSV master wait 6,845 32 3 0 2.4
SQL*Net message to client 529,327 0 1 0 182.7
PX Deq Credit: send blkd 65 0 0 0 0.0
PX Deq: Msg Fragment 130 0 0 0 0.0
SQL*Net more data from clien 299 0 0 0 0.1
-------------------------------------------------------------
Wait Event Histogram DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was <.05%, null is truly 0
-> Ordered by Event (idle events last)

Total ----------------- % of Waits ------------------

Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
ADR block file read 21 76.2 4.8 14.3 4.8
ADR block file write 10 100.0
ADR file lock 16 100.0
AQPC idle 120 100.0
ASM background starting 4 100.0
ASM file metadata operatio 12K 95.9 2.6 .5 .0 .4 .6 .0
CGS wait for IPC msg 34K 100.0
CRS call completion 130 100.0
CSS group membership query 130 83.8 16.2
CSS initialization 442 14.0 23.8 39.8 22.4
CSS operation: action 745 48.3 51.7
CSS operation: data query 425 94.1 5.9
CSS operation: data update 111 100.0
CSS operation: query 626 96.3 3.7
DFS lock handle 350 100.0
Disk file operations I/O 91K 99.7 .1 .0 .0 .0 .1 .0 .0
Failed Logon Delay 38 100.0
GCR CSS group query 165 100.0
GCR CSS group update 111 100.0
GPnP Get Item 130 .8 99.2
GPnP Initialization 130 .8 99.2
GPnP Termination 130 96.2 3.8
IPC send completion sync 42K 99.9 .0 .0 .0 .0 .0
KJC: Wait for msg sends to 59 96.6 3.4
LGWR all worker groups 404 100.0
LGWR wait for redo copy 49 100.0
LGWR worker group idle 808 .2 .2 1.0 73.3 25.2
Log archive I/O 60 30.0 40.0 11.7 1.7 6.7 10.0
PX Deq: Signal ACK EXT 37K 100.0 .0
PX Deq: Slave Join Frag 20K 100.0 .0
PX Deq: Slave Session Stat 58K 98.2 1.7 .0 .0 .0 .0 .0
PX Deq: reap credit 498K 100.0 .0 .0
PX qref latch 176 100.0
Parameter File I/O 2 100.0
REPL Capture/Apply: RAC AQ 47 100.0
RMAN backup & recovery I/O 659 75.7 3.5 .5 1.2 12.3 5.9 .9
Redo Transport Open 60 100.0
SQL*Net break/reset to cli 1058 99.7 .3
SQL*Net more data to clien 948 99.9 .1
SQL*Net vector data to cli 268 100.0
Streams AQ: load balancer 720 100.0
asynch descriptor resize 10K 100.0
buffer deadlock 1 100.0
control file parallel writ 3222 98.5 1.0 .2 .0 .2 .0
control file sequential re 68K 85.9 13.6 .4 .0 .0 .0 .0
control file single write 253 14.6 85.4
cursor: pin S 4 25.0 50.0 25.0
cursor: pin S wait on X 199 2.5 57.3 40.2
cursor: pin X 2 50.0 50.0
db file async I/O submit 414 100.0
db file parallel read 3 66.7 33.3
Wait Event Histogram DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was <.05%, null is truly 0
-> Ordered by Event (idle events last)

Total ----------------- % of Waits ------------------

Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
db file parallel write 901 97.4 1.8 .4 .1 .2
db file scattered read 6 50.0 50.0
db file sequential read 82K 99.5 .1 .1 .3 .1 .0 .0
dbms_file_transfer I/O 316 92.4 1.9 1.3 .6 1.6 1.3 .9
direct path read 25 96.0 4.0
direct path write 47 100.0
enq: CF - contention 302 79.1 .7 6.3 5.3 2.6 6.0
enq: DR - contention 2 100.0
enq: FB - contention 22 100.0
enq: IV - contention 20K 87.7 12.1 .1 .1 .0 .0 .0
enq: JS - job run lock - s 31 100.0
enq: MW - contention 2 100.0
enq: PS - contention 23K 99.8 .2 .0 .0 .0 .0
enq: RS - prevent file del 64 100.0
enq: SV - contention 2 100.0
enq: TA - contention 23 100.0
enq: TD - KTF dump entries 12 100.0
enq: TM - contention 8 87.5 12.5
enq: TX - index contention 2 100.0
enq: UL - contention 1 100.0
enq: WF - contention 8 100.0
enq: WL - contention 39 100.0
enq: XR - database force l 1199 99.9 .1
external table open 2 100.0
external table read 2 100.0
gc buffer busy release 1 100.0
gc cr block 2-way 3892 99.4 .5 .1
gc cr block busy 44 2.3 95.5 2.3
gc cr block lost 24 100.0
gc cr disk read 37K 100.0 .0 .0
gc cr grant 2-way 187 100.0
gc cr multi block request 44 100.0
gc current block 2-way 3513 99.7 .2 .0 .0
gc current block busy 5 100.0
gc current block lost 2 50.0 50.0
gc current grant 2-way 219 100.0
gc current grant busy 1214 99.8 .1 .1
gc current multi block req 1 100.0
gcs log flush sync 24 83.3 12.5 4.2
ges inquiry response 281 100.0
get branch/thread/sequence 96 100.0
heartbeat redo informer 3600 100.0
kfk: async disk IO 185 82.7 .5 1.6 11.9 3.2
kksfbc child completion 9 100.0
ksdxexeotherwait 114 15.8 50.0 25.4 8.8
ksxr poll remote instances 24K 100.0
latch free 56 100.0
latch: call allocation 31 100.0
latch: gcs resource hash 1 100.0
latch: ges resource hash l 2283 100.0
latch: redo allocation 1 100.0
Wait Event Histogram DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was <.05%, null is truly 0
-> Ordered by Event (idle events last)

Total ----------------- % of Waits ------------------

Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
latch: row cache objects 21 100.0
latch: shared pool 187 93.0 3.7 .5 1.6 .5 .5
libcache interrupt action 65K 100.0
library cache lock 1528 96.6 1.2 .8 1.1 .1 .2
library cache pin 164 100.0
library cache: mutex X 38 57.9 42.1
lock deadlock retry 1 100.0
log file parallel write 6621 98.0 .8 .4 .5 .2 .0 .0
log file sequential read 938 95.6 1.3 .4 .2 1.4 .6 .4
log file single write 240 100.0
log file switch (checkpoin 2 50.0 50.0
log file sync 2305 96.0 1.5 .9 .9 .5 .1 .1
log switch/archive 60 100.0
lreg timer 1199 100.0
name-service call wait 6 16.7 16.7 66.7
oracle thread bootstrap 213 66.2 32.4 1.4
os thread creation 213 7.5 92.5
recovery area: computing b 1082 99.8 .2
recovery area: computing d 2 100.0
recovery area: computing o 18 50.0 11.1 16.7 5.6 5.6 11.1
reliable message 18K 97.9 2.0 .0 .1 .0 .0 .0
resmgr:cpu quantum 1 100.0
row cache cleanup 66K 100.0
row cache lock 1241 99.9 .1
row cache process 69K 100.0
switch logfile command 18 11.1 88.9
ASM background timer 8278 53.9 16.6 13.6 3.1 1.5 1.2 .8 9.4
DIAG idle wait 61K 12.0 .4 .0 .0 2.8 32.9 51.8
GCR sleep 25K 93.0 7.0
KSV master wait 6845 92.5 5.6 .9 .0 .7 .2 .0
PING 1542 81.5 18.5
PX Deq Credit: send blkd 65 100.0
PX Deq: Execute Reply 37K 99.9 .0 .0 .0 .0 .0
PX Deq: Execution Msg 61K 68.0 26.0 5.9 .1 .0 .0 .0
PX Deq: Join ACK 75K 79.1 20.8 .0 .0 .0 .0 .0
PX Deq: Msg Fragment 130 100.0
PX Deq: Parse Reply 37K 99.9 .1 .0 .0 .0 .0
PX Idle Wait 20K .6 .5 .6 1.6 1.9 4.4 87.6 2.9
SQL*Net message from clien 534K 96.6 2.1 .4 .2 .1 .1 .1 .4
SQL*Net message to client 529K 100.0 .0
SQL*Net more data from cli 299 99.7 .3
Space Manager: slave idle 5871 .0 .1 99.9
Streams AQ: qmn coordinato 256 50.0 50.0
Streams AQ: qmn slave idle 848 .1 .1 6.0 93.8
class slave wait 723K .2 .1 .1 .1 99.3 .0 .1 .1
dispatcher timer 60 100.0
gcs remote message 319K 13.1 3.6 8.2 2.0 1.8 71.2 .2
ges remote message 165K 27.8 1.1 14.6 4.3 1.7 5.7 44.7
jobq slave wait 3146 .0 100.0
pmon timer 1308 .1 .2 .4 .9 .8 5.9 91.7
rdbms ipc message 209K 38.3 .5 2.4 1.7 1.2 1.6 43.3 11.0
Wait Event Histogram DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was <.05%, null is truly 0
-> Ordered by Event (idle events last)

Total ----------------- % of Waits ------------------

Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
shared server idle wait 120 100.0
smon timer 1200 .2 99.8
wait for unread message on 1200 100.0
-------------------------------------------------------------
SQL ordered by CPU DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Total DB CPU (s): 2,916
-> Captured SQL accounts for 12.5% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU

CPU CPU per Elapsd Old

Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
369.57 85 4.35 12.7 375.74 25,645,707 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

124.52 18 6.92 4.3 151.14 3,296,509 2757901947

115.78 6 19.30 4.0 116.26 8,013,281 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0
80.36 11 7.31 2.8 91.31 5,820,986 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

75.51 22,990 0.00 2.6 95.68 0 3937862827

75.05 32 2.35 2.6 75.59 5,933,019 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

67.81 19,819 0.00 2.3 79.42 0 3937862827

Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
57.38 17,727 0.00 2.0 63.33 0 3937862827
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
54.72 17,197 0.00 1.9 72.90 0 3937862827
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
54.17 12,577 0.00 1.9 56.40 0 3937862827
SQL ordered by CPU DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Total DB CPU (s): 2,916
-> Captured SQL accounts for 12.5% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU

CPU CPU per Elapsd Old

Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
53.21 13,179 0.00 1.8 59.88 0 3937862827
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
49.37 15,773 0.00 1.7 54.70 0 3937862827
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum

48.00 125 0.38 1.6 48.49 0 2868219621

Module: Lab128
--lab128 select sql_id,plan_hash_value,parse_calls,disk_reads,di
rect_writes, buffer_gets,rows_processed,serializable_aborts,fet
ches,executions, end_of_fetch_count,loads,invalidations,px_serv
ers_executions, cpu_time,elapsed_time,application_wait_time,con

47.32 11,739 0.00 1.6 50.77 0 3937862827

46.07 2 23.04 1.6 46.61 3,063,591 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0
33.50 31 1.08 1.1 33.85 2,942,591 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

30.94 5 6.19 1.1 38.20 1,303,981 2757901947

-------------------------------------------------------------
SQL ordered by Elapsed time for DB: PRDX3 Instance: PRDX31 Snaps: 2677 -2678
-> Total DB Time (s): 3,632
-> Captured SQL accounts for 12.2% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time

Elapsed Elap per CPU Old

Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
375.74 85 4.42 10.3 369.57 1,080 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

151.14 18 8.40 4.2 124.52 28 2757901947

116.26 6 19.38 3.2 115.78 1,055 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

95.68 22,990 0.00 2.6 75.51 0 3937862827

91.31 11 8.30 2.5 80.36 50 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

79.42 19,819 0.00 2.2 67.81 0 3937862827

75.59 32 2.36 2.1 75.05 13 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

73.80 6 12.30 2.0 26.22 94,737 554837621

72.90 17,197 0.00 2.0 54.72 0 3937862827

Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
SQL ordered by Elapsed time for DB: PRDX3 Instance: PRDX31 Snaps: 2677 -2678
-> Total DB Time (s): 3,632
-> Captured SQL accounts for 12.2% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time

Elapsed Elap per CPU Old

Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum

65.72 5 13.14 1.8 20.56 78,779 2501057403

Module: Lab128
--lab128 select file_id,tablespace_name ts_name, sum(bytes) byte
s_free from dba_free_space group by file_id, tablespace_name

63.33 17,727 0.00 1.7 57.38 0 3937862827

56.99 6 9.50 1.6 26.28 94,765 554837621

56.40 12,577 0.00 1.6 54.17 0 3937862827

55.21 6 9.20 1.5 26.10 94,787 554837621

54.70 15,773 0.00 1.5 49.37 0 3937862827

Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
SQL ordered by Elapsed time for DB: PRDX3 Instance: PRDX31 Snaps: 2677 -2678
-> Total DB Time (s): 3,632
-> Captured SQL accounts for 12.2% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time

Elapsed Elap per CPU Old

53.00 6 8.83 1.5 23.97 94,742 554837621

50.77 11,739 0.00 1.4 47.32 0 3937862827

48.49 125 0.39 1.3 48.00 0 2868219621

48.46 5 9.69 1.3 20.06 78,989 554837621

46.61 2 23.31 1.3 46.07 150 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

46.45 5 9.29 1.3 21.18 78,987 554837621

Elapsed Elap per CPU Old

Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
44.17 5 8.83 1.2 19.65 78,987 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
42.84 5 8.57 1.2 20.52 78,950 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE

38.20 5 7.64 1.1 30.94 4 2757901947

-------------------------------------------------------------
SQL ordered by Gets DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 17,500,832
-> Captured SQL accounts for 104.2% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets

CPU Elapsd Old

Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
25,645,707 85 301,714.2 146.5 369.57 375.74 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

14,078,903 1 14,078,903.0 80.4 16.58 18.23 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

14,039,638 1 14,039,638.0 80.2 13.52 13.53 2783330933

13,154,809 1 13,154,809.0 75.2 15.98 17.90 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

13,117,866 1 13,117,866.0 75.0 13.02 13.05 2783330933

12,741,047 1 12,741,047.0 72.8 15.02 16.75 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

12,703,062 1 12,703,062.0 72.6 12.21 12.23 2783330933

9,654,906 1,911 5,052.3 55.2 27.47 28.95 279517402

9,537,881 1 9,537,881.0 54.5 13.69 15.99 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

9,503,632 1 9,503,632.0 54.3 10.70 10.81 2783330933

Module: DBMS_SCHEDULER
INSERT INTO STATS$SQL_PLAN ( PLAN_HASH_VALUE , ID , OPERATION ,
SQL ordered by Gets DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 17,500,832
-> Captured SQL accounts for 104.2% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets

CPU Elapsd Old

Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
OPTIONS , OBJECT_NODE , OBJECT# , OBJECT_OWNER , OBJECT_NAME , O
BJECT_ALIAS , OBJECT_TYPE , OPTIMIZER , PARENT_ID , DEPTH , POSI
TION , SEARCH_COLUMNS , COST , CARDINALITY , BYTES , OTHER_TAG ,

8,118,402 1 8,118,402.0 46.4 13.01 15.68 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

8,084,006 1 8,084,006.0 46.2 9.63 9.75 2783330933

8,013,281 6 1,335,546.8 45.8 115.78 116.26 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

6,316,912 1,205 5,242.3 36.1 26.36 27.47 3726831061

6,289,709 1 6,289,709.0 35.9 10.54 12.58 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

6,261,826 1 6,261,826.0 35.8 7.82 7.90 2783330933

5,933,019 32 185,406.8 33.9 75.05 75.59 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0
5,820,986 11 529,180.5 33.3 80.36 91.31 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

5,141,916 1 5,141,916.0 29.4 10.02 12.23 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )
5,112,655 1 5,112,655.0 29.2 6.95 7.17 2783330933
SQL ordered by Gets DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 17,500,832
-> Captured SQL accounts for 104.2% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets

CPU Elapsd Old

Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
Module: DBMS_SCHEDULER
INSERT INTO STATS$SQL_PLAN ( PLAN_HASH_VALUE , ID , OPERATION ,
OPTIONS , OBJECT_NODE , OBJECT# , OBJECT_OWNER , OBJECT_NAME , O
BJECT_ALIAS , OBJECT_TYPE , OPTIMIZER , PARENT_ID , DEPTH , POSI
TION , SEARCH_COLUMNS , COST , CARDINALITY , BYTES , OTHER_TAG ,

3,296,509 18 183,139.4 18.8 124.52 151.14 2757901947

3,063,591 2 1,531,795.5 17.5 46.07 46.61 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0
2,942,591 31 94,922.3 16.8 33.50 33.85 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

2,938,593 1 2,938,593.0 16.8 8.05 10.25 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

2,911,330 1 2,911,330.0 16.6 5.25 5.38 2783330933

2,640,438 10,866 243.0 15.1 19.13 19.51 88163218

2,640,438 10,866 243.0 15.1 14.46 14.72 3495037511

2,281,284 9,388 243.0 13.0 16.98 17.31 88163218

SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monit
oring optimizer_features_enable(default) no_parallel result_cach
e(snapshot=3600) */ SUM(C1) FROM (SELECT /*+ qb_name("innerQuery
") NO_INDEX_FFS( "T4") */ 1 AS C1 FROM X3PRD."BPADDRESS" "T4" W
2,281,284 9,388 243.0 13.0 13.01 13.21 3495037511
SQL ordered by Gets DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 17,500,832
-> Captured SQL accounts for 104.2% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets

CPU Elapsd Old

Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monit
oring optimizer_features_enable(default) no_parallel result_cach
e(snapshot=3600) */ SUM(C1) FROM (SELECT /*+ qb_name("innerQuery
") NO_INDEX_FFS( "T5") */ 1 AS C1 FROM X3PRD."BPADDRESS" "T5" W

2,096,361 8,627 243.0 12.0 15.29 15.56 88163218

2,096,361 8,627 243.0 12.0 11.39 11.62 3495037511

2,064,353 144 14,335.8 11.8 11.15 11.40 3434664022

2,025,405 8,335 243.0 11.6 14.65 14.87 88163218

2,025,405 8,335 243.0 11.6 10.80 11.03 3495037511

1,946,031 1 1,946,031.0 11.1 7.28 10.42 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

1,920,238 1 1,920,238.0 11.0 4.68 4.96 2783330933

1,914,949 381 5,026.1 10.9 5.49 5.75 4005045403

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YDD5_.* From X3PRD.YAGESUM YDD5_ Where YDD5_.BPR_0 = :1 A
nd YDD5_.ACCDAT_0 <= :2 And YDD5_.FCY_0 = :3 And YDD5_.CREDAT_0
<= :4 And YDD5_.YTBMLOC_0 = :5 And YDD5_.NUM_0 = :6 And YDD5_.TY
SQL ordered by Gets DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 17,500,832
-> Captured SQL accounts for 104.2% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets

CPU Elapsd Old

Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
P_0 = :7 Order by YDD5_.NUM_0,YDD5_.LIG_0,YDD5_.NUMHDU_0 Desc

1,909,824 1,218 1,568.0 10.9 7.61 7.65 273266063

1,856,081 2,439 761.0 10.6 7.15 7.17 2611622919

1,812,537 7,459 243.0 10.4 13.53 13.74 88163218

1,812,537 7,459 243.0 10.4 9.98 10.14 3495037511

1,413,533 5,817 243.0 8.1 10.76 10.91 88163218

1,413,290 5,816 243.0 8.1 8.25 8.40 3495037511

1,368,819 5,633 243.0 7.8 10.37 10.48 88163218

1,368,819 5,633 243.0 7.8 8.03 8.07 3495037511

1,303,981 5 260,796.2 7.5 30.94 38.20 2757901947

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
SQL ordered by Gets DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 17,500,832
-> Captured SQL accounts for 104.2% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets

CPU Elapsd Old

Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
Select YPDCSHCO_.LOC_0, YPDCSHCO_.YCALLGRPDEF_0, YPDCSHCO_.CALLG
RPDES_0, YPDCSHCO_.CUSTGRPDES_0, YPDCSHCO_.BPCNAM_0, YPDCSHCO_.E
XPPAYDAT_0, YPDCSHCO_.DOCNUM_0, YPDCSHCO_.TODAYAMT_0, YPDCSHCO_.
THISWEEKAMT_0, YPDCSHCO_.THISMONTHAMT_0, YPDCSHCO_.NEXT4WEEKAMT_

1,282,311 5,277 243.0 7.3 9.78 9.89 88163218

1,282,311 5,277 243.0 7.3 7.45 7.51 3495037511

1,210,424 19 63,706.5 6.9 16.76 16.82 2326074386

select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'GACCENTRY'escape'\' and table_name not lik
e 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NUL

1,209,501 19 63,657.9 6.9 16.83 16.91 676544137

select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'FACILITY'escape'\' and table_name not like
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL

1,208,274 19 63,593.4 6.9 17.12 17.18 3541378398

select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'YCUSAGED'escape'\' and table_name not like
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL

1,206,454 1 1,206,454.0 6.9 7.19 8.60 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

1,200,940 19 63,207.4 6.9 16.90 16.99 3677039803

select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'APLSTD'escape'\' and table_name not like '
BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL f

1,182,744 1 1,182,744.0 6.8 3.51 3.67 2783330933

Module: DBMS_SCHEDULER
INSERT INTO STATS$SQL_PLAN ( PLAN_HASH_VALUE , ID , OPERATION ,
OPTIONS , OBJECT_NODE , OBJECT# , OBJECT_OWNER , OBJECT_NAME , O
BJECT_ALIAS , OBJECT_TYPE , OPTIMIZER , PARENT_ID , DEPTH , POSI
TION , SEARCH_COLUMNS , COST , CARDINALITY , BYTES , OTHER_TAG ,
SQL ordered by Gets DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 17,500,832
-> Captured SQL accounts for 104.2% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets

CPU Elapsd Old

Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
1,182,734 1 1,182,734.0 6.8 5.90 7.45 3724895247
Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

1,160,497 1 1,160,497.0 6.6 3.45 3.68 2783330933

1,042,663 5 208,532.6 6.0 13.84 13.93 646758067

select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'ATEXTRA'escape'\' and table_name not like
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL

978,646 1,286 761.0 5.6 3.90 3.91 2611622919

969,270 76 12,753.6 5.5 14.26 14.37 4058986612

select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'BPCUSTOMER'escape'\' and table_name not li
ke 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NU

964,320 615 1,568.0 5.5 3.80 3.80 273266063

956,307 95 10,066.4 5.5 12.66 12.76 646758067

862,731 4 215,682.8 4.9 11.09 11.13 4058986612

817,217 3 272,405.7 4.7 20.85 24.68 2757901947

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YPDCSHCO_.LOC_0, YPDCSHCO_.YCALLGRPDEF_0, YPDCSHCO_.CALLG
RPDES_0, YPDCSHCO_.CUSTGRPDES_0, YPDCSHCO_.BPCNAM_0, YPDCSHCO_.E
XPPAYDAT_0, YPDCSHCO_.DOCNUM_0, YPDCSHCO_.TODAYAMT_0, YPDCSHCO_.
SQL ordered by Gets DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 17,500,832
-> Captured SQL accounts for 104.2% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets

CPU Elapsd Old

Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
THISWEEKAMT_0, YPDCSHCO_.THISMONTHAMT_0, YPDCSHCO_.NEXT4WEEKAMT_

725,113 5 145,022.6 4.1 6.24 6.25 2188448765

725,113 5 145,022.6 4.1 6.36 6.39 4198429574

-------------------------------------------------------------
SQL ordered by Reads DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Disk Reads Threshold: 1000 Total Disk Reads: 80,875
-> Captured SQL accounts for 99.7% of Total Disk Reads
-> SQL reported below exceeded 1.0% of Total Disk Reads

CPU Elapsd
Physical Rds Executions Rds per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
94,787 6 15,797.8 117.2 26.10 55.21 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
94,784 6 15,797.3 117.2 23.47 54.95 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
94,765 6 15,794.2 117.2 26.28 56.99 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
94,742 6 15,790.3 117.1 23.97 53.00 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
94,737 6 15,789.5 117.1 26.22 73.80 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
78,989 5 15,797.8 97.7 20.06 48.46 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
78,987 5 15,797.4 97.7 21.18 46.45 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
78,987 5 15,797.4 97.7 19.65 44.17 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
78,985 5 15,797.0 97.7 21.19 45.97 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
SQL ordered by Reads DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Disk Reads Threshold: 1000 Total Disk Reads: 80,875
-> Captured SQL accounts for 99.7% of Total Disk Reads
-> SQL reported below exceeded 1.0% of Total Disk Reads

CPU Elapsd
Physical Rds Executions Rds per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
78,971 5 15,794.2 97.6 19.24 45.16 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
78,950 5 15,790.0 97.6 20.52 42.84 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE

78,779 5 15,755.8 97.4 20.56 65.72 2501057403

Module: Lab128
--lab128 select file_id,tablespace_name ts_name, sum(bytes) byte
s_free from dba_free_space group by file_id, tablespace_name

15,790 1 15,790.0 19.5 3.87 8.27 3851899012

Module: Lab128
--lab128 select ts# ts_id, segfile# header_rfn, segblock# header
_block, file# rfn, block# bl, length blocks from sys.uet$ unio
n all select ktfbuesegtsn ts_id, ktfbuesegfno header_rfn, ktfbu
esegbno header_block, ktfbuefno rfn, ktfbuebno bl, ktfbueblks bl

3,477 250 13.9 4.3 5.66 8.28 3870739168

Module: Lab128
--lab128 select /*+rule*/ sid, inst_id,decode(type,'TM',id1,null
) obj_id,type,id1,id2, lmode,lmode "Lock Held",request,request
"Lock Request", ctime,0 con_id from gv$lock where type!='MR'

2,049 2 1,024.5 2.5 8.79 12.34 475673829

1,344 64 21.0 1.7 1.84 2.37 219306063

Module: Lab128
--lab128 select name,v value from ( select /*+ no_merge */ n
ame,decode(value,'TRUE',1,'FALSE',0,to_number(value)) v from v
$system_parameter where type in (1,3,6) and rownum >0 ) uni
on all select '_active_threads_', count(thread#) inst_cnt from

1,280 1 1,280.0 1.6 4.94 8.18 475673829

Module: SQL Developer
select DBMS_METADATA.GET_DDL('VIEW',:NAME,:OWNER) from dual
union all select dbms_metadata.GET_DDL ('TRIGGER', trig
ger_name ,owner ) from Dba_triggers where table_owner = :OWNER a
SQL ordered by Reads DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Disk Reads Threshold: 1000 Total Disk Reads: 80,875
-> Captured SQL accounts for 99.7% of Total Disk Reads
-> SQL reported below exceeded 1.0% of Total Disk Reads

CPU Elapsd
Physical Rds Executions Rds per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
nd table_name = :NAME union all select dbms_metadata
1,272 2 636.0 1.6 4.28 4.65 475673829
Module: SQL Developer
select DBMS_METADATA.GET_DDL('VIEW',:NAME,:OWNER) from dual
union all select dbms_metadata.GET_DDL ('TRIGGER', trig
ger_name ,owner ) from Dba_triggers where table_owner = :OWNER a
nd table_name = :NAME union all select dbms_metadata

1,080 85 12.7 1.3 369.57 375.74 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0
1,055 6 175.8 1.3 115.78 116.26 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

853 105 8.1 1.1 1.04 1.37 3022972439

Module: Lab128
--lab128 select sum(decode(pool,null,0,bytes)) pools_total, sum
(decode(pool,'shared pool',bytes,0)) shared_total, sum(decode(p
ool,'shared pool',decode(name,'free memory',bytes,0),0)) shared_
free, sum(decode(pool,'large pool',bytes,0)) large_total, sum(

-------------------------------------------------------------
SQL ordered by Executions DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Executions Threshold: 100 Total Executions: 1,011,804
-> Captured SQL accounts for 94.9% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions

CPU per Elap per Old

Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
334,846 334,847 1.0 0.00 0.00 3360804353
select default$ from col$ where rowid=:1

326,340 635 0.0 0.00 0.00 214372507

select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su
bname from obj$ o where o.obj#=:1
279,164 50 0.0 0.00 0.00 214372507
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su
bname from obj$ o where o.obj#=:1

278,948 278,940 1.0 0.00 0.00 3360804353

select default$ from col$ where rowid=:1
266,622 266,620 1.0 0.00 0.00 3360804353
select default$ from col$ where rowid=:1

259,236 59 0.0 0.00 0.00 214372507

select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su
bname from obj$ o where o.obj#=:1

252,988 252,988 1.0 0.00 0.00 3360804353

select default$ from col$ where rowid=:1

247,374 36 0.0 0.00 0.00 214372507

select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su
bname from obj$ o where o.obj#=:1

239,617 141,787 0.6 0.00 0.00 4200760169

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select /*+ FIRST_ROWS ( 1 ) */ ADW_.ROWID, ADW_.* From X3PRD.ADO
VAL ADW_ Where ( ADW_.CMP_0 = :1 And ADW_.FCY_0 = :2 And ADW_.PA
RAM_0 = :3 ) Order by ADW_.CMP_0,ADW_.FCY_0,ADW_.PARAM_0

222,147 28 0.0 0.00 0.00 214372507

select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su
bname from obj$ o where o.obj#=:1

222,028 222,028 1.0 0.00 0.00 3360804353

select default$ from col$ where rowid=:1
193,149 193,148 1.0 0.00 0.00 3360804353
select default$ from col$ where rowid=:1

185,965 46 0.0 0.00 0.00 214372507

select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su
bname from obj$ o where o.obj#=:1

175,717 175,714 1.0 0.00 0.00 3360804353

select default$ from col$ where rowid=:1

172,033 37 0.0 0.00 0.00 214372507

select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su
bname from obj$ o where o.obj#=:1
SQL ordered by Executions DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Executions Threshold: 100 Total Executions: 1,011,804
-> Captured SQL accounts for 94.9% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions

CPU per Elap per Old

Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
162,153 162,151 1.0 0.00 0.00 3360804353
select default$ from col$ where rowid=:1

161,565 34 0.0 0.00 0.00 214372507

select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.su
bname from obj$ o where o.obj#=:1

69,484 69,480 1.0 0.00 0.00 1733272032

Module: rman@phlxdb01.baiada.com.au (TNS V1-V3)
declare thread number; sequence number; recid number; alRec
dbms_rcvman.alRec_t; begin dbms_rcvman.getArchivedLog(alRec
=> alRec); if (:rlscn = alRec.rlgSCN and :stopthr = alRec.thread
and ((alRec.sequence >= :stopseq and :toclause = 0) or (alRec.s
68,996 68,992 1.0 0.00 0.00 1733272032
Module: rman@phlxdb01.baiada.com.au (TNS V1-V3)
declare thread number; sequence number; recid number; alRec
dbms_rcvman.alRec_t; begin dbms_rcvman.getArchivedLog(alRec
=> alRec); if (:rlscn = alRec.rlgSCN and :stopthr = alRec.thread
and ((alRec.sequence >= :stopseq and :toclause = 0) or (alRec.s
68,522 68,518 1.0 0.00 0.00 1733272032
Module: rman@phlxdb01.baiada.com.au (TNS V1-V3)
declare thread number; sequence number; recid number; alRec
dbms_rcvman.alRec_t; begin dbms_rcvman.getArchivedLog(alRec
=> alRec); if (:rlscn = alRec.rlgSCN and :stopthr = alRec.thread
and ((alRec.sequence >= :stopseq and :toclause = 0) or (alRec.s
64,694 64,690 1.0 0.00 0.00 1733272032
Module: rman@phlxdb01.baiada.com.au (TNS V1-V3)
declare thread number; sequence number; recid number; alRec
dbms_rcvman.alRec_t; begin dbms_rcvman.getArchivedLog(alRec
=> alRec); if (:rlscn = alRec.rlgSCN and :stopthr = alRec.thread
and ((alRec.sequence >= :stopseq and :toclause = 0) or (alRec.s

32,379 32,363 1.0 0.00 0.00 3408690335

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select /*+ FIRST_ROWS ( 1 ) */ YYB_.ROWID, YYB_.* From X3PRD.BPC
USTOMER YYB_ Where ( YYB_.BPCNUM_0 = :1 ) Order by YYB_.BPCNUM_0

29,445 22 0.0 0.00 0.00 3300761786

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select /*+ FIRST_ROWS ( 1 ) */ lck__.ROWID, lck__.* From X3PRD.A
PLLCK lck__ Where ( lck__.LCKPID_0 = :1 And lck__.LCKFLG_0 = :
2) Order by lck__.LCKPID_0,lck__.LCKFLG_0
28,526 106 0.0 0.00 0.00 3300761786
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select /*+ FIRST_ROWS ( 1 ) */ lck__.ROWID, lck__.* From X3PRD.A
PLLCK lck__ Where ( lck__.LCKPID_0 = :1 And lck__.LCKFLG_0 = :
2) Order by lck__.LCKPID_0,lck__.LCKFLG_0

22,990 22,990 1.0 0.00 0.00 3937862827

Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
SQL ordered by Executions DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Executions Threshold: 100 Total Executions: 1,011,804
-> Captured SQL accounts for 94.9% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions

CPU per Elap per Old

Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum

22,773 22,773 1.0 0.00 0.00 3468666020

select text from view$ where rowid=:1

22,588 22,588 1.0 0.00 0.00 691523139

22,588 22,588 1.0 0.00 0.00 4235131838

21,732 21,732 1.0 0.00 0.00 2150122797

21,732 21,732 1.0 0.00 0.00 3602650837

21,714 21,714 1.0 0.00 0.00 3235541382

21,713 21,714 1.0 0.00 0.00 2165594810

21,529 10,251 0.5 0.00 0.00 3150117071

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
UPDATE X3PRD.YCALLLISTTM SET X3PRD.YCALLLISTTM.UPDUSR_0 = :1, X
3PRD.YCALLLISTTM.UPDDATTIM_0 = :2, X3PRD.YCALLLISTTM.YASNO_0 =
:3, X3PRD.YCALLLISTTM.YAUSER_0 = :4 Where X3PRD.YCALLLISTTM.YB
PCPAY_0 = :5 And X3PRD.YCALLLISTTM.YUSER_0 = :6
20,580 7,821 0.4 0.00 0.00 3150117071
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
UPDATE X3PRD.YCALLLISTTM SET X3PRD.YCALLLISTTM.UPDUSR_0 = :1, X
3PRD.YCALLLISTTM.UPDDATTIM_0 = :2, X3PRD.YCALLLISTTM.YASNO_0 =
SQL ordered by Executions DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Executions Threshold: 100 Total Executions: 1,011,804
-> Captured SQL accounts for 94.9% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions

CPU per Elap per Old

Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
:3, X3PRD.YCALLLISTTM.YAUSER_0 = :4 Where X3PRD.YCALLLISTTM.YB
PCPAY_0 = :5 And X3PRD.YCALLLISTTM.YUSER_0 = :6

19,819 19,820 1.0 0.00 0.00 3937862827

19,766 19,766 1.0 0.00 0.00 691523139

19,766 19,766 1.0 0.00 0.00 4235131838

19,391 19,389 1.0 0.00 0.00 3468666020

select text from view$ where rowid=:1

19,174 16,665 0.9 0.00 0.00 978461749

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select /*+ FIRST_ROWS ( 1 ) */ ADP_.ROWID, ADP_.* From X3PRD.ADO
PAR ADP_ Where ( ADP_.PARAM_0 = :1 ) Order by ADP_.PARAM_0

19,018 13,245 0.7 0.00 0.00 4200760169

18,776 18,776 1.0 0.00 0.00 2150122797

18,774 18,774 1.0 0.00 0.00 3602650837

18,758 18,758 1.0 0.00 0.00 2165594810

SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monit
oring optimizer_features_enable(default) no_parallel result_cach
e(snapshot=3600) */ C1, C2, C3 FROM (SELECT /*+ qb_name("innerQu
SQL ordered by Executions DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Executions Threshold: 100 Total Executions: 1,011,804
-> Captured SQL accounts for 94.9% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions

CPU per Elap per Old

Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
ery") INDEX( "T8" "ATABDIV_YCODE1") */ COUNT(*) AS C1, 42949672

18,758 18,758 1.0 0.00 0.00 3235541382

18,429 18,429 1.0 0.00 0.00 3306873268

17,813 17,813 1.0 0.00 0.00 3468666020

select text from view$ where rowid=:1

17,727 17,727 1.0 0.00 0.00 3937862827

17,281 17,281 1.0 0.00 0.00 3306873268

17,256 17,256 1.0 0.00 0.00 2165594810

17,256 17,256 1.0 0.00 0.00 3235541382

17,254 17,254 1.0 0.00 0.00 2150122797

17,254 17,254 1.0 0.00 0.00 3602650837

SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monit
SQL ordered by Executions DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Executions Threshold: 100 Total Executions: 1,011,804
-> Captured SQL accounts for 94.9% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions

CPU per Elap per Old

Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
oring optimizer_features_enable(default) no_parallel result_cach
e(snapshot=3600) */ C1, C2, C3 FROM (SELECT /*+ qb_name("innerQu
ery") INDEX( "T9" "ATABDIV_CODE") */ COUNT(*) AS C1, 4294967295

17,197 17,197 1.0 0.00 0.00 3937862827

16,972 16,972 1.0 0.00 0.00 3468666020

select text from view$ where rowid=:1

16,672 16,672 1.0 0.00 0.00 2165594810

16,672 16,672 1.0 0.00 0.00 3235541382

16,670 16,670 1.0 0.00 0.00 2150122797

16,670 16,670 1.0 0.00 0.00 3602650837

16,621 16,621 1.0 0.00 0.00 3306873268

16,614 16,614 1.0 0.00 0.00 691523139

SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monit
oring optimizer_features_enable(default) no_parallel result_cach
e(snapshot=3600) */ C1, C2, C3 FROM (SELECT /*+ qb_name("innerQu
ery") INDEX( "T4" "ATABDIV_YCODE1") */ COUNT(*) AS C1, 42949672
16,614 16,614 1.0 0.00 0.00 4235131838
SQL ordered by Executions DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Executions Threshold: 100 Total Executions: 1,011,804
-> Captured SQL accounts for 94.9% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions

CPU per Elap per Old

Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monit
oring optimizer_features_enable(default) no_parallel result_cach
e(snapshot=3600) */ C1, C2, C3 FROM (SELECT /*+ qb_name("innerQu
ery") INDEX( "T4" "ATABDIV_CODE") */ COUNT(*) AS C1, 4294967295

16,518 16,518 1.0 0.00 0.00 3306873268

16,370 16,370 1.0 0.00 0.00 691523139

16,370 16,370 1.0 0.00 0.00 4235131838

15,773 15,773 1.0 0.00 0.00 3937862827

-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Parse Calls Threshold: 1000 Total Parse Calls: 717,061
-> Captured SQL accounts for 94.7% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls

% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
334,842 334,846 46.70 3360804353
select default$ from col$ where rowid=:1
278,943 278,948 38.90 3360804353
select default$ from col$ where rowid=:1
266,622 266,622 37.18 3360804353
select default$ from col$ where rowid=:1
252,988 252,988 35.28 3360804353
select default$ from col$ where rowid=:1
222,028 222,028 30.96 3360804353
select default$ from col$ where rowid=:1
193,149 193,149 26.94 3360804353
select default$ from col$ where rowid=:1
175,716 175,717 24.51 3360804353
select default$ from col$ where rowid=:1
162,153 162,153 22.61 3360804353
select default$ from col$ where rowid=:1

69,484 69,484 9.69 1733272032

Module: rman@phlxdb01.baiada.com.au (TNS V1-V3)
declare thread number; sequence number; recid number; alRec
dbms_rcvman.alRec_t; begin dbms_rcvman.getArchivedLog(alRec
=> alRec); if (:rlscn = alRec.rlgSCN and :stopthr = alRec.thread
and ((alRec.sequence >= :stopseq and :toclause = 0) or (alRec.s
68,996 68,996 9.62 1733272032
Module: rman@phlxdb01.baiada.com.au (TNS V1-V3)
declare thread number; sequence number; recid number; alRec
dbms_rcvman.alRec_t; begin dbms_rcvman.getArchivedLog(alRec
=> alRec); if (:rlscn = alRec.rlgSCN and :stopthr = alRec.thread
and ((alRec.sequence >= :stopseq and :toclause = 0) or (alRec.s
68,522 68,522 9.56 1733272032
Module: rman@phlxdb01.baiada.com.au (TNS V1-V3)
declare thread number; sequence number; recid number; alRec
dbms_rcvman.alRec_t; begin dbms_rcvman.getArchivedLog(alRec
=> alRec); if (:rlscn = alRec.rlgSCN and :stopthr = alRec.thread
and ((alRec.sequence >= :stopseq and :toclause = 0) or (alRec.s
64,694 64,694 9.02 1733272032
Module: rman@phlxdb01.baiada.com.au (TNS V1-V3)
declare thread number; sequence number; recid number; alRec
dbms_rcvman.alRec_t; begin dbms_rcvman.getArchivedLog(alRec
=> alRec); if (:rlscn = alRec.rlgSCN and :stopthr = alRec.thread
and ((alRec.sequence >= :stopseq and :toclause = 0) or (alRec.s

54,666 22,990 7.62 3937862827

% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
49,726 12,577 6.93 3937862827
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
45,038 13,179 6.28 3937862827
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
41,498 11,739 5.79 3937862827
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
36,883 17,727 5.14 3937862827
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
35,373 17,197 4.93 3937862827
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum
32,165 15,773 4.49 3937862827
Module: oraagent.bin@phlxdb01.baiada.com.au (TNS V1-V3)
SELECT executions, end_of_fetch_count, elapsed_time
/px_servers elapsed_time, cpu_time/px_servers cpu_tim
e, buffer_gets/executions buffer_gets FROM (SELECT
sum(executions) as executions, sum

29,439 29,445 4.11 3300761786

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select /*+ FIRST_ROWS ( 1 ) */ lck__.ROWID, lck__.* From X3PRD.A
PLLCK lck__ Where ( lck__.LCKPID_0 = :1 And lck__.LCKFLG_0 = :
2) Order by lck__.LCKPID_0,lck__.LCKFLG_0
28,510 28,526 3.98 3300761786
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select /*+ FIRST_ROWS ( 1 ) */ lck__.ROWID, lck__.* From X3PRD.A
PLLCK lck__ Where ( lck__.LCKPID_0 = :1 And lck__.LCKFLG_0 = :
2) Order by lck__.LCKPID_0,lck__.LCKFLG_0

22,773 22,773 3.18 3468666020

select text from view$ where rowid=:1
SQL ordered by Parse Calls DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Parse Calls Threshold: 1000 Total Parse Calls: 717,061
-> Captured SQL accounts for 94.7% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls

% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------

22,588 22,588 3.15 691523139

22,588 22,588 3.15 4235131838

21,732 21,732 3.03 2150122797

21,732 21,732 3.03 3602650837

21,714 21,713 3.03 2165594810

21,714 21,714 3.03 3235541382

21,529 21,529 3.00 3150117071

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
UPDATE X3PRD.YCALLLISTTM SET X3PRD.YCALLLISTTM.UPDUSR_0 = :1, X
3PRD.YCALLLISTTM.UPDDATTIM_0 = :2, X3PRD.YCALLLISTTM.YASNO_0 =
:3, X3PRD.YCALLLISTTM.YAUSER_0 = :4 Where X3PRD.YCALLLISTTM.YB
PCPAY_0 = :5 And X3PRD.YCALLLISTTM.YUSER_0 = :6
20,580 20,580 2.87 3150117071
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
UPDATE X3PRD.YCALLLISTTM SET X3PRD.YCALLLISTTM.UPDUSR_0 = :1, X
3PRD.YCALLLISTTM.UPDDATTIM_0 = :2, X3PRD.YCALLLISTTM.YASNO_0 =
:3, X3PRD.YCALLLISTTM.YAUSER_0 = :4 Where X3PRD.YCALLLISTTM.YB
PCPAY_0 = :5 And X3PRD.YCALLLISTTM.YUSER_0 = :6

19,766 19,766 2.76 691523139

SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monit
SQL ordered by Parse Calls DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Parse Calls Threshold: 1000 Total Parse Calls: 717,061
-> Captured SQL accounts for 94.7% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls

% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
oring optimizer_features_enable(default) no_parallel result_cach
e(snapshot=3600) */ C1, C2, C3 FROM (SELECT /*+ qb_name("innerQu
ery") INDEX( "T4" "ATABDIV_YCODE1") */ COUNT(*) AS C1, 42949672

19,766 19,766 2.76 4235131838

19,391 19,391 2.70 3468666020

select text from view$ where rowid=:1

18,776 18,776 2.62 2150122797

18,774 18,774 2.62 3602650837

18,758 18,758 2.62 2165594810

18,758 18,758 2.62 3235541382

18,429 18,429 2.57 3306873268

18,137 766 2.53 3937862827

% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
select text from view$ where rowid=:1

17,288 552 2.41 3937862827

17,281 17,281 2.41 3306873268

17,256 17,256 2.41 2165594810

17,256 17,256 2.41 3235541382

17,254 17,254 2.41 2150122797

17,254 17,254 2.41 3602650837

17,150 730 2.39 3937862827

16,972 16,972 2.37 3468666020

select text from view$ where rowid=:1

16,672 16,672 2.33 2165594810

16,672 16,672 2.33 3235541382

16,670 16,670 2.32 2150122797

16,670 16,670 2.32 3602650837

16,621 16,621 2.32 3306873268

16,614 16,614 2.32 691523139

16,614 16,614 2.32 4235131838

16,518 16,518 2.30 3306873268

16,370 16,370 2.28 691523139

SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monit
oring optimizer_features_enable(default) no_parallel result_cach
e(snapshot=3600) */ C1, C2, C3 FROM (SELECT /*+ qb_name("innerQu
SQL ordered by Parse Calls DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Parse Calls Threshold: 1000 Total Parse Calls: 717,061
-> Captured SQL accounts for 94.7% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls

% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
ery") INDEX( "T4" "ATABDIV_YCODE1") */ COUNT(*) AS C1, 42949672

16,370 16,370 2.28 4235131838

15,592 15,592 2.17 691523139

15,592 15,592 2.17 4235131838

15,500 15,500 2.16 3306873268

15,376 15,376 2.14 3468666020

select text from view$ where rowid=:1

15,318 15,320 2.14 3300761786

14,920 14,920 2.08 2165594810

-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Sharable Memory Threshold(KB): 1024

Max End
Sharable Sharable Old
Memory (KB) Memory (KB) Parse Calls Executions % Total Hash Value
----------- ----------- ------------ ------------ ------- ----------
53,568 41,433 4 85 1.1 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
53,568 53,568 14 32 1.1 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
53,568 53,568 11 31 1.1 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0
:1 Order by YYTV_.YUSER_0
:1 Order by YYTV_.YUSER_0
47,658 47,658 4 11 1.0 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0
41,544 41,544 4 6 0.8 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0
41,433 41,433 0 0 0.8 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
41,433 41,433 0 0 0.8 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
41,433 41,433 0 0 0.8 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
41,433 41,433 1 1 0.8 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
41,433 41,433 2 2 0.8 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0
:1 Order by YYTV_.YUSER_0
:1 Order by YYTV_.YUSER_0
:1 Order by YYTV_.YUSER_0
:1 Order by YYTV_.YUSER_0
26,893 26,893 2 2 0.5 4216847646
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

20,276 20,276 0 0 0.4 3431404835

select owner,table_name,table_type,NULL from sys.all_catalog whe
20,276 20,276 1 1 0.4 3431404835
select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'YDEPSUM'escape'\' and table_name not like
\'and table_name like'YDEPSUM'escape'\' and table_name not like
SQL ordered by Sharable Memory DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Sharable Memory Threshold(KB): 1024

Max End
Sharable Sharable Old
Memory (KB) Memory (KB) Parse Calls Executions % Total Hash Value
----------- ----------- ------------ ------------ ------- ----------
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
17,773 17,773 0 0 0.4 3431404835
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,773 17,773 0 0 0.4 3431404835
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,773 17,773 0 0 0.4 3431404835
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,773 17,773 0 0 0.4 3431404835
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,773 17,773 0 0 0.4 3431404835
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,773 17,773 0 0 0.4 3431404835
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,773 17,773 0 0 0.4 3431404835
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,773 17,773 0 0 0.4 3431404835
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,773 17,773 0 0 0.4 3431404835
select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'YDEPSUM'escape'\' and table_name not like
\'and table_name like'YDEPSUM'escape'\' and table_name not like
\'and table_name like'YDEPSUM'escape'\' and table_name not like
\'and table_name like'YDEPSUM'escape'\' and table_name not like
\'and table_name like'YDEPSUM'escape'\' and table_name not like
\'and table_name like'YDEPSUM'escape'\' and table_name not like
\'and table_name like'YDEPSUM'escape'\' and table_name not like
\'and table_name like'YDEPSUM'escape'\' and table_name not like
\'and table_name like'YDEPSUM'escape'\' and table_name not like
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL

17,753 17,753 0 0 0.4 676544137

select owner,table_name,table_type,NULL from sys.all_catalog whe
17,753 17,753 0 0 0.4 676544137
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,753 17,753 0 0 0.4 676544137
SQL ordered by Sharable Memory DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Sharable Memory Threshold(KB): 1024

Max End
Sharable Sharable Old
Memory (KB) Memory (KB) Parse Calls Executions % Total Hash Value
----------- ----------- ------------ ------------ ------- ----------
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,753 17,753 0 0 0.4 676544137
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,753 17,753 19 19 0.4 676544137
select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'FACILITY'escape'\' and table_name not like
\'and table_name like'FACILITY'escape'\' and table_name not like
\'and table_name like'FACILITY'escape'\' and table_name not like
\'and table_name like'FACILITY'escape'\' and table_name not like
\'and table_name like'FACILITY'escape'\' and table_name not like
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL

17,753 17,753 0 0 0.4 3677039803

select owner,table_name,table_type,NULL from sys.all_catalog whe
17,753 17,753 0 0 0.4 3677039803
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,753 17,753 0 0 0.4 3677039803
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,753 17,753 0 0 0.4 3677039803
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,753 17,753 19 19 0.4 3677039803
select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'APLSTD'escape'\' and table_name not like '
\'and table_name like'APLSTD'escape'\' and table_name not like '
\'and table_name like'APLSTD'escape'\' and table_name not like '
\'and table_name like'APLSTD'escape'\' and table_name not like '
\'and table_name like'APLSTD'escape'\' and table_name not like '
BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL f
BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL f
BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL f
BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL f
BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL f

17,741 17,741 0 0 0.4 2326074386

select owner,table_name,table_type,NULL from sys.all_catalog whe
17,741 17,741 0 0 0.4 2326074386
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,741 17,741 0 0 0.4 2326074386
select owner,table_name,table_type,NULL from sys.all_catalog whe
SQL ordered by Sharable Memory DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Sharable Memory Threshold(KB): 1024

Max End
Sharable Sharable Old
Memory (KB) Memory (KB) Parse Calls Executions % Total Hash Value
----------- ----------- ------------ ------------ ------- ----------
17,741 17,741 19 19 0.4 2326074386
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,741 17,741 0 0 0.4 2326074386
select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'GACCENTRY'escape'\' and table_name not lik
\'and table_name like'GACCENTRY'escape'\' and table_name not lik
\'and table_name like'GACCENTRY'escape'\' and table_name not lik
\'and table_name like'GACCENTRY'escape'\' and table_name not lik
\'and table_name like'GACCENTRY'escape'\' and table_name not lik
e 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NUL
e 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NUL
e 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NUL
e 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NUL
e 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NUL

17,741 17,741 0 0 0.4 3541378398

select owner,table_name,table_type,NULL from sys.all_catalog whe
17,741 17,741 0 0 0.4 3541378398
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,741 17,741 0 0 0.4 3541378398
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,741 17,741 0 0 0.4 3541378398
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,741 17,741 19 19 0.4 3541378398
select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'YCUSAGED'escape'\' and table_name not like
\'and table_name like'YCUSAGED'escape'\' and table_name not like
\'and table_name like'YCUSAGED'escape'\' and table_name not like
\'and table_name like'YCUSAGED'escape'\' and table_name not like
\'and table_name like'YCUSAGED'escape'\' and table_name not like
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL

17,678 17,678 0 0 0.4 646758067

select owner,table_name,table_type,NULL from sys.all_catalog whe
17,678 17,678 0 0 0.4 646758067
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,678 17,678 95 95 0.4 646758067
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,678 17,678 0 0 0.4 646758067
SQL ordered by Sharable Memory DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Sharable Memory Threshold(KB): 1024

Max End
Sharable Sharable Old
Memory (KB) Memory (KB) Parse Calls Executions % Total Hash Value
----------- ----------- ------------ ------------ ------- ----------
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,678 17,678 0 0 0.4 646758067
select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'ATEXTRA'escape'\' and table_name not like
\'and table_name like'ATEXTRA'escape'\' and table_name not like
\'and table_name like'ATEXTRA'escape'\' and table_name not like
\'and table_name like'ATEXTRA'escape'\' and table_name not like
\'and table_name like'ATEXTRA'escape'\' and table_name not like
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL
'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NULL

17,670 17,670 0 0 0.4 4058986612

select owner,table_name,table_type,NULL from sys.all_catalog whe
17,670 17,670 0 0 0.4 4058986612
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,670 17,670 0 0 0.4 4058986612
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,670 17,670 0 0 0.4 4058986612
select owner,table_name,table_type,NULL from sys.all_catalog whe
17,670 17,670 76 76 0.4 4058986612
select owner,table_name,table_type,NULL from sys.all_catalog whe
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
re table_type in('~','TABLE','VIEW')and owner like'X3PRD'escape'
\'and table_name like'BPCUSTOMER'escape'\' and table_name not li
\'and table_name like'BPCUSTOMER'escape'\' and table_name not li
\'and table_name like'BPCUSTOMER'escape'\' and table_name not li
\'and table_name like'BPCUSTOMER'escape'\' and table_name not li
\'and table_name like'BPCUSTOMER'escape'\' and table_name not li
ke 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NU
ke 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NU
ke 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NU
ke 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NU
ke 'BIN$%' union all select a.owner,a.synonym_name,'SYNONYM',NU

17,290 17,290 2 2 0.3 3350058350

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select Y0011_.USRCALGRP_0, Y0011_.YCALLGRPDEF_0, Y0011_.YCALLGRP
17,290 15,841 1 1 0.3 3350058350
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select Y0011_.USRCALGRP_0, Y0011_.YCALLGRPDEF_0, Y0011_.YCALLGRP
17,290 17,290 4 4 0.3 3350058350
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
SQL ordered by Sharable Memory DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Sharable Memory Threshold(KB): 1024

Max End
Sharable Sharable Old
Memory (KB) Memory (KB) Parse Calls Executions % Total Hash Value
----------- ----------- ------------ ------------ ------- ----------
Select Y0011_.USRCALGRP_0, Y0011_.YCALLGRPDEF_0, Y0011_.YCALLGRP
NAM_0, Y0011_.BPR_0, Y0011_.BPCNAM_0, Y0011_.ACCDAT_0, Y0011_.PA
NAM_0, Y0011_.BPR_0, Y0011_.BPCNAM_0, Y0011_.ACCDAT_0, Y0011_.PA
NAM_0, Y0011_.BPR_0, Y0011_.BPCNAM_0, Y0011_.ACCDAT_0, Y0011_.PA
YLOC_0, Y0011_.AMT_0, Y0011_.PAYSTA_0, Y0011_.PAYMENT_0 From X3P
YLOC_0, Y0011_.AMT_0, Y0011_.PAYSTA_0, Y0011_.PAYMENT_0 From X3P
YLOC_0, Y0011_.AMT_0, Y0011_.PAYSTA_0, Y0011_.PAYMENT_0 From X3P
RD.Y0011 Y0011_, X3PRD.ALISTEH ALH_ Where ((ALH_.COD_0(+) = :1)
RD.Y0011 Y0011_, X3PRD.ALISTEH ALH_ Where ((ALH_.COD_0(+) = :1)
RD.Y0011 Y0011_, X3PRD.ALISTEH ALH_ Where ((ALH_.COD_0(+) = :1)
15,841 15,841 1 1 0.3 3350058350
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select Y0011_.USRCALGRP_0, Y0011_.YCALLGRPDEF_0, Y0011_.YCALLGRP
15,841 15,841 0 0 0.3 3350058350
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select Y0011_.USRCALGRP_0, Y0011_.YCALLGRPDEF_0, Y0011_.YCALLGRP
15,841 15,841 2 2 0.3 3350058350
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select Y0011_.USRCALGRP_0, Y0011_.YCALLGRPDEF_0, Y0011_.YCALLGRP
15,841 15,752 22 22 0.3 3350058350
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select Y0011_.USRCALGRP_0, Y0011_.YCALLGRPDEF_0, Y0011_.YCALLGRP
NAM_0, Y0011_.BPR_0, Y0011_.BPCNAM_0, Y0011_.ACCDAT_0, Y0011_.PA
NAM_0, Y0011_.BPR_0, Y0011_.BPCNAM_0, Y0011_.ACCDAT_0, Y0011_.PA
NAM_0, Y0011_.BPR_0, Y0011_.BPCNAM_0, Y0011_.ACCDAT_0, Y0011_.PA
NAM_0, Y0011_.BPR_0, Y0011_.BPCNAM_0, Y0011_.ACCDAT_0, Y0011_.PA
YLOC_0, Y0011_.AMT_0, Y0011_.PAYSTA_0, Y0011_.PAYMENT_0 From X3P
YLOC_0, Y0011_.AMT_0, Y0011_.PAYSTA_0, Y0011_.PAYMENT_0 From X3P
YLOC_0, Y0011_.AMT_0, Y0011_.PAYSTA_0, Y0011_.PAYMENT_0 From X3P
YLOC_0, Y0011_.AMT_0, Y0011_.PAYSTA_0, Y0011_.PAYMENT_0 From X3P
RD.Y0011 Y0011_, X3PRD.ALISTEH ALH_ Where ((ALH_.COD_0(+) = :1)
RD.Y0011 Y0011_, X3PRD.ALISTEH ALH_ Where ((ALH_.COD_0(+) = :1)
RD.Y0011 Y0011_, X3PRD.ALISTEH ALH_ Where ((ALH_.COD_0(+) = :1)
RD.Y0011 Y0011_, X3PRD.ALISTEH ALH_ Where ((ALH_.COD_0(+) = :1)
15,819 15,819 4 4 0.3 3350058350
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select Y0011_.USRCALGRP_0, Y0011_.YCALLGRPDEF_0, Y0011_.YCALLGRP
NAM_0, Y0011_.BPR_0, Y0011_.BPCNAM_0, Y0011_.ACCDAT_0, Y0011_.PA
YLOC_0, Y0011_.AMT_0, Y0011_.PAYSTA_0, Y0011_.PAYMENT_0 From X3P
RD.Y0011 Y0011_, X3PRD.ALISTEH ALH_ Where ((ALH_.COD_0(+) = :1)
15,752 15,752 0 0 0.3 3350058350
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select Y0011_.USRCALGRP_0, Y0011_.YCALLGRPDEF_0, Y0011_.YCALLGRP
NAM_0, Y0011_.BPR_0, Y0011_.BPCNAM_0, Y0011_.ACCDAT_0, Y0011_.PA
YLOC_0, Y0011_.AMT_0, Y0011_.PAYSTA_0, Y0011_.PAYMENT_0 From X3P
RD.Y0011 Y0011_, X3PRD.ALISTEH ALH_ Where ((ALH_.COD_0(+) = :1)

14,123 14,123 0 0 0.3 254562652

Module: SQL Developer
SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2(
14,123 14,123 0 0 0.3 254562652
Module: SQL Developer
SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2(
SQL ordered by Sharable Memory DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Sharable Memory Threshold(KB): 1024

Max End
Sharable Sharable Old
Memory (KB) Memory (KB) Parse Calls Executions % Total Hash Value
----------- ----------- ------------ ------------ ------- ----------
14,123 14,123 0 0 0.3 254562652
Module: SQL Developer
SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2(
14,123 14,123 0 0 0.3 254562652
Module: SQL Developer
SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2(
'VIEW_T', '7')), KU$.OBJ_NUM FROM SYS.KU$_VIEW_VIEW KU$ WHERE KU
'VIEW_T', '7')), KU$.OBJ_NUM FROM SYS.KU$_VIEW_VIEW KU$ WHERE KU
'VIEW_T', '7')), KU$.OBJ_NUM FROM SYS.KU$_VIEW_VIEW KU$ WHERE KU
'VIEW_T', '7')), KU$.OBJ_NUM FROM SYS.KU$_VIEW_VIEW KU$ WHERE KU
$.SCHEMA_OBJ.NAME=:NAME1 AND KU$.SCHEMA_OBJ.OWNER_NAME=:SCHEMA2
$.SCHEMA_OBJ.NAME=:NAME1 AND KU$.SCHEMA_OBJ.OWNER_NAME=:SCHEMA2
$.SCHEMA_OBJ.NAME=:NAME1 AND KU$.SCHEMA_OBJ.OWNER_NAME=:SCHEMA2
$.SCHEMA_OBJ.NAME=:NAME1 AND KU$.SCHEMA_OBJ.OWNER_NAME=:SCHEMA2

-------------------------------------------------------------
SQL ordered by Cluster Wait Time DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Cluster CWT % of Elapsd CPU Old

Wait Time (s) Elapsd Time Time (s) Time (s) Executions Hash Value
------------- ----------- ----------- ----------- -------------- ----------
33.85 45.9 73.80 26.22 6 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE

33.57 51.1 65.72 20.56 5 2501057403

Module: Lab128
--lab128 select file_id,tablespace_name ts_name, sum(bytes) byte
s_free from dba_free_space group by file_id, tablespace_name

17.63 32.1 54.95 23.47 6 554837621

Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
17.04 29.9 56.99 26.28 6 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
17.00 35.1 48.46 20.06 5 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
15.49 28.1 55.21 26.10 6 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
15.36 29.0 53.00 23.97 6 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
14.55 32.2 45.16 19.24 5 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
13.93 30.0 46.45 21.18 5 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
13.16 29.8 44.17 19.65 5 554837621
SQL ordered by Cluster Wait Time DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Cluster CWT % of Elapsd CPU Old

Wait Time (s) Elapsd Time Time (s) Time (s) Executions Hash Value
------------- ----------- ----------- ----------- -------------- ----------
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
13.01 28.3 45.97 21.19 5 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE
10.87 25.4 42.84 20.52 5 554837621
Module: sqlplus@phlxdb01.baiada.com.au (TNS V1-V3)
select upper(d.NAME) || '|' || file_name ||'|'|| tablespace_name
||'|'|| fstatus ||'|'|| AUTOEXTENSIBLE ||'|'|
| blocks ||'|'|| maxblocks ||'|'|| USER_BLOCKS ||'|'|| INCREMENT
_BY ||'|'|| ONLINE_STATUS ||'|'|| BLOCK_SIZE

2.11 25.5 8.27 3.87 1 3851899012

1.83 74.8 2.45 0.74 15 2320756840

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
DELETE FROM X3PRD.YCALLLIST Where X3PRD.YCALLLIST.YUSER_0 = :1

1.45 35.8 4.04 2.68 2,931 202710481

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1

1.44 0.4 375.74 369.57 85 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

1.39 13.3 10.42 7.28 1 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

1.30 96.5 1.34 0.05 124 1674923013

update obj$ set obj#=:4, type#=:5,ctime=:6,mtime=:7,stime=:8,sta
tus=:9,dataobj#=:10,flags=:11,oid$=:12,spare1=:13,spare2=:14,spa
re3=:15,signature=:16,spare7=:17,spare8=:18,spare9=:19 where own
er#=:1 and name=:2 and namespace=:3 and remoteowner is null and

1.05 53.2 1.98 1.01 2,940 1529012343

select spare6 from user$ where user#=:1

1.04 5.7 18.23 16.58 1 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )
SQL ordered by Cluster Wait Time DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Cluster CWT % of Elapsd CPU Old

Wait Time (s) Elapsd Time Time (s) Time (s) Executions Hash Value
------------- ----------- ----------- ----------- -------------- ----------

0.99 59.7 1.65 0.74 1 3304543689

0.97 5.8 16.75 15.02 1 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

0.95 57.6 1.65 0.25 1 3304543689

Module: DBMS_SCHEDULER
INSERT INTO STATS$SQL_PLAN_USAGE ( SNAP_ID , DBID , INSTANCE_NUM
BER , OLD_HASH_VALUE , TEXT_SUBSET , PLAN_HASH_VALUE , SQL_ID ,
HASH_VALUE , COST , ADDRESS , OPTIMIZER , LAST_ACTIVE_TIME ) SEL
ECT /*+ ordered use_nl(sq) index(sq) */ :B3 , :B2 , :B1 , SS.OLD
0.89 56.0 1.58 0.65 1 3304543689
Module: DBMS_SCHEDULER
INSERT INTO STATS$SQL_PLAN_USAGE ( SNAP_ID , DBID , INSTANCE_NUM
BER , OLD_HASH_VALUE , TEXT_SUBSET , PLAN_HASH_VALUE , SQL_ID ,
HASH_VALUE , COST , ADDRESS , OPTIMIZER , LAST_ACTIVE_TIME ) SEL
ECT /*+ ordered use_nl(sq) index(sq) */ :B3 , :B2 , :B1 , SS.OLD

0.87 73.1 1.20 0.36 15 3948373469

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
DELETE FROM X3PRD.YCALLLISTTM Where X3PRD.YCALLLISTTM.YUSER_0 =
:1

0.83 4.6 17.90 15.98 1 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )
0.83 5.2 15.99 13.69 1 3724895247
Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

0.83 24.0 3.44 2.62 3,103 202710481

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1
0.82 22.8 3.59 2.81 3,189 202710481
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1
0.78 22.1 3.50 2.74 3,231 202710481
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1
0.77 20.6 3.72 3.07 3,422 202710481
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1
0.76 4.9 15.68 13.01 1 3724895247
SQL ordered by Cluster Wait Time DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Cluster CWT % of Elapsd CPU Old

Wait Time (s) Elapsd Time Time (s) Time (s) Executions Hash Value
------------- ----------- ----------- ----------- -------------- ----------
Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

0.74 44.4 1.66 0.54 1 3304543689

Module: DBMS_SCHEDULER
INSERT INTO STATS$SQL_PLAN_USAGE ( SNAP_ID , DBID , INSTANCE_NUM
BER , OLD_HASH_VALUE , TEXT_SUBSET , PLAN_HASH_VALUE , SQL_ID ,
HASH_VALUE , COST , ADDRESS , OPTIMIZER , LAST_ACTIVE_TIME ) SEL
ECT /*+ ordered use_nl(sq) index(sq) */ :B3 , :B2 , :B1 , SS.OLD
0.72 38.9 1.86 0.59 1 3304543689
Module: DBMS_SCHEDULER
INSERT INTO STATS$SQL_PLAN_USAGE ( SNAP_ID , DBID , INSTANCE_NUM
BER , OLD_HASH_VALUE , TEXT_SUBSET , PLAN_HASH_VALUE , SQL_ID ,
HASH_VALUE , COST , ADDRESS , OPTIMIZER , LAST_ACTIVE_TIME ) SEL
ECT /*+ ordered use_nl(sq) index(sq) */ :B3 , :B2 , :B1 , SS.OLD

0.69 20.2 3.44 2.84 3,112 202710481

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1

0.68 5.4 12.58 10.54 1 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

0.67 20.5 3.25 2.64 3,052 202710481

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1
0.64 19.0 3.37 2.78 3,173 202710481
Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1

0.63 29.3 2.15 0.56 1 3304543689

0.60 18.4 3.27 2.65 3,141 202710481

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1

0.60 5.9 10.25 8.05 1 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )
0.59 4.8 12.23 10.02 1 3724895247
Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

0.57 17.9 3.19 2.66 3,068 202710481

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
SQL ordered by Cluster Wait Time DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Cluster CWT % of Elapsd CPU Old

Wait Time (s) Elapsd Time Time (s) Time (s) Executions Hash Value
------------- ----------- ----------- ----------- -------------- ----------
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1

0.57 33.6 1.69 1.16 3,428 1529012343

select spare6 from user$ where user#=:1

0.55 17.7 3.11 2.59 3,006 202710481

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-
00-00', to_date(NULL), :2) where user#=:1

0.53 33.3 1.59 1.15 3,124 1529012343

select spare6 from user$ where user#=:1

0.52 33.9 1.53 1.09 31 2320756840

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
DELETE FROM X3PRD.YCALLLIST Where X3PRD.YCALLLIST.YUSER_0 = :1

0.51 38.4 1.34 0.38 1 3304543689

0.51 35.2 1.46 1.02 3,246 1529012343

select spare6 from user$ where user#=:1
0.51 35.1 1.46 1.02 3,067 1529012343
select spare6 from user$ where user#=:1

0.51 0.6 91.31 80.36 11 4216847646

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select YYTV_.* From X3PRD.YCALLLISTV YYTV_ Where YYTV_.YUSER_0 =
:1 Order by YYTV_.YUSER_0

0.49 32.4 1.51 1.09 3,180 1529012343

select spare6 from user$ where user#=:1
0.48 35.2 1.37 0.92 3,113 1529012343
select spare6 from user$ where user#=:1
0.47 32.0 1.47 1.03 3,199 1529012343
select spare6 from user$ where user#=:1
0.45 32.8 1.38 0.97 3,155 1529012343
select spare6 from user$ where user#=:1
0.44 31.7 1.39 1.01 3,078 1529012343
select spare6 from user$ where user#=:1

0.43 34.6 1.23 0.36 1 3304543689

0.42 31.5 1.34 0.97 3,017 1529012343

select spare6 from user$ where user#=:1
SQL ordered by Cluster Wait Time DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Cluster CWT % of Elapsd CPU Old

Wait Time (s) Elapsd Time Time (s) Time (s) Executions Hash Value
------------- ----------- ----------- ----------- -------------- ----------

0.42 31.8 1.32 0.40 1 3304543689

0.41 5.6 7.45 5.90 1 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

0.39 64.5 0.60 0.15 418 2032935852

Module: sadora@phlxpr02.baiada.com.au (TNS V1-V3)
Select count(*) From X3PRD.YCALLLISTTM YCT9_ Where YCT9_.YBPCPAY
_0 = :1 And YCT9_.YBPLCK_0 = :2 And YCT9_.YBPLCKUSR_0 <> :3

0.38 4.4 8.60 7.19 1 3724895247

Module: DBMS_SCHEDULER
call db_proc_rac_statspack ( )

0.36 33.6 1.07 0.30 16 4284443297

SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monit
oring optimizer_features_enable(default) no_parallel */ SUM(C1)
FROM (SELECT /*+ qb_name("innerQuery") INDEX_FFS( "GACCDUDATE"
"GACCDUDATE_DUD9") */ 1 AS C1 FROM X3PRD."GACCDUDATE" "GACCDUDA

0.34 35.4 0.97 0.26 16 1926763730

0.34 55.5 0.61 0.14 1 1629027619

Module: DBMS_SCHEDULER
INSERT INTO STATS$SQLTEXT ( OLD_HASH_VALUE , TEXT_SUBSET , PIECE
, SQL_ID , SQL_TEXT , ADDRESS , COMMAND_TYPE , LAST_SNAP_ID ) S
ELECT /*+ ordered use_nl(vst) */ NEW_SQL.OLD_HASH_VALUE , NEW_SQ
L.TEXT_SUBSET , VST.PIECE , VST.SQL_ID , VST.SQL_TEXT , VST.ADDR

-------------------------------------------------------------
truncate table STATS$TEMP_SQLSTATS
*
ERROR at line 1:
ORA-00942: table or view does not exist
Instance Activity Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total per Second per Trans

--------------------------------- ------------------ -------------- ------------
Batched IO (bound) vector count 46 0.0 0.0
Batched IO (full) vector count 0 0.0 0.0
Batched IO (space) vector count 0 0.0 0.0
Batched IO block miss count 124 0.0 0.0
Batched IO buffer defrag count 3 0.0 0.0
Batched IO double miss count 8 0.0 0.0
Batched IO same unit count 62 0.0 0.0
Batched IO single block count 38 0.0 0.0
Batched IO slow jump count 0 0.0 0.0
Batched IO vector block count 50 0.0 0.0
Batched IO vector read count 16 0.0 0.0
Block Cleanout Optim referenced 89 0.0 0.0
CCursor + sql area evicted 25,662 7.1 8.9
CLI BG ENQ 1,198 0.3 0.4
CLI BG Fls done 119 0.0 0.0
CLI BG attempt Flush 1,198 0.3 0.4
CLI Flstask create 1,198 0.3 0.4
CLI Flush 1,198 0.3 0.4
CLI SGA Alloc 0 0.0 0.0
CLI Thru Wrt 179 0.1 0.1
CLI bytes fls to table 130,888 36.4 45.2
CPU used by this session 279,300 77.6 96.4
CPU used when call started 273,823 76.1 94.5
CR blocks created 61 0.0 0.0
Cached Commit SCN referenced 77 0.0 0.0
Clusterwide global transactions 0 0.0 0.0
Commit SCN cached 120 0.0 0.0
DB time 518,477 144.0 179.0
DBWR checkpoint buffers written 7,777 2.2 2.7
DBWR checkpoints 60 0.0 0.0
DBWR fusion writes 1,317 0.4 0.5
DBWR object drop buffers written 0 0.0 0.0
DBWR parallel query checkpoint bu 0 0.0 0.0
DBWR revisited being-written buff 0 0.0 0.0
DBWR tablespace checkpoint buffer 0 0.0 0.0
DBWR thread checkpoint buffers wr 7,777 2.2 2.7
DBWR transaction table writes 224 0.1 0.1
DBWR undo block writes 2,574 0.7 0.9
DFO trees parallelized 18,877 5.2 6.5
DX/BB enqueue lock background get 0 0.0 0.0
DX/BB enqueue lock foreground req 0 0.0 0.0
Effective IO time 29,938 8.3 10.3
HSC Heap Segment Block Changes 33,288 9.3 11.5
Heap Segment Array Inserts 370 0.1 0.1
Heap Segment Array Updates 3,427 1.0 1.2
KTFB alloc req 23 0.0 0.0
KTFB alloc space (block) 12,320,768 3,422.4 4,252.9
KTFB alloc time (ms) 5,735 1.6 2.0
KTFB apply req 22 0.0 0.0
KTFB apply time (ms) 219 0.1 0.1
KTFB commit req 0 0.0 0.0
KTFB commit time (ms) 0 0.0 0.0
KTFB free req 0 0.0 0.0
KTFB free space (block) 0 0.0 0.0
KTFB free time (ms) 0 0.0 0.0
LOB table id lookup cache misses 0 0.0 0.0
Instance Activity Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total per Second per Trans

--------------------------------- ------------------ -------------- ------------
Misses for writing mapping 0 0.0 0.0
Number of read IOs issued 0 0.0 0.0
PX local messages recv'd 75,569 21.0 26.1
PX local messages sent 75,569 21.0 26.1
PX remote messages recv'd 40,965 11.4 14.1
PX remote messages sent 40,965 11.4 14.1
Parallel operations not downgrade 18,877 5.2 6.5
Requests to/from client 510,802 141.9 176.3
RowCR - row contention 1 0.0 0.0
RowCR attempts 311 0.1 0.1
RowCR hits 310 0.1 0.1
SCN increments due to another dat 0 0.0 0.0
SMON posted for dropping temp seg 0 0.0 0.0
SMON posted for instance recovery 0 0.0 0.0
SMON posted for undo segment reco 0 0.0 0.0
SMON posted for undo segment shri 2 0.0 0.0
SQL*Net roundtrips to/from client 511,202 142.0 176.5
SQL*Net roundtrips to/from dblink 0 0.0 0.0
TBS Extension: bytes extended 0 0.0 0.0
TBS Extension: files extended 0 0.0 0.0
TBS Extension: tasks created 0 0.0 0.0
TBS Extension: tasks executed 0 0.0 0.0
active txn count during cleanout 638 0.2 0.2
application wait time 11 0.0 0.0
background checkpoints completed 60 0.0 0.0
background checkpoints started 60 0.0 0.0
background timeouts 27,494 7.6 9.5
branch node splits 1 0.0 0.0
buffer is not pinned count 3,974,359 1,104.0 1,371.9
buffer is pinned count 8,003,570 2,223.2 2,762.7
bytes received via SQL*Net from c 248,004,507 68,890.1 85,607.4
bytes received via SQL*Net from d 0 0.0 0.0
bytes sent via SQL*Net to client 188,846,269 52,457.3 65,186.8
bytes sent via SQL*Net to dblink 0 0.0 0.0
bytes via SQL*Net vector to clien 618,158 171.7 213.4
calls to get snapshot scn: kcmgss 1,414,027 392.8 488.1
calls to kcmgas 29,812 8.3 10.3
calls to kcmgcs 644,282 179.0 222.4
cell physical IO interconnect byt 20,551,994,880 5,708,887.5 7,094,233.7
change write time 133 0.0 0.1
cleanout - number of ktugct calls 675 0.2 0.2
cleanouts and rollbacks - consist 23 0.0 0.0
cleanouts only - consistent read 32 0.0 0.0
cluster key scan block gets 13,963 3.9 4.8
cluster key scans 9,355 2.6 3.2
cluster wait time 1,765 0.5 0.6
commit batch/immediate performed 2 0.0 0.0
commit batch/immediate requested 2 0.0 0.0
commit cleanout failures: block l 1 0.0 0.0
commit cleanout failures: buffer 0 0.0 0.0
commit cleanout failures: callbac 15 0.0 0.0
commit cleanout failures: cannot 0 0.0 0.0
commit cleanouts 18,424 5.1 6.4
commit cleanouts successfully com 18,408 5.1 6.4
commit immediate performed 2 0.0 0.0
commit immediate requested 2 0.0 0.0
Instance Activity Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total per Second per Trans

--------------------------------- ------------------ -------------- ------------
commit txn count during cleanout 456 0.1 0.2
concurrency wait time 2,757 0.8 1.0
consistent changes 23,332 6.5 8.1
consistent gets 17,250,155 4,791.7 5,954.5
consistent gets direct 0 0.0 0.0
consistent gets examination 1,109,147 308.1 382.9
consistent gets examination (fast 1,104,446 306.8 381.2
consistent gets from cache 17,250,156 4,791.7 5,954.5
consistent gets pin 16,141,010 4,483.6 5,571.6
consistent gets pin (fastpath) 16,056,587 4,460.2 5,542.5
cursor authentications 874 0.2 0.3
cursor reload failures 12 0.0 0.0
data blocks consistent reads - un 67 0.0 0.0
db block changes 228,968 63.6 79.0
db block gets 250,796 69.7 86.6
db block gets direct 0 0.0 0.0
db block gets from cache 250,796 69.7 86.6
db block gets from cache (fastpat 71,737 19.9 24.8
deferred (CURRENT) block cleanout 10,653 3.0 3.7
dirty buffers inspected 7 0.0 0.0
enqueue conversions 77,960 21.7 26.9
enqueue releases 226,488 62.9 78.2
enqueue requests 226,864 63.0 78.3
enqueue timeouts 368 0.1 0.1
enqueue waits 24,717 6.9 8.5
exchange deadlocks 1 0.0 0.0
execute count 1,011,804 281.1 349.3
failed probes on index block recl 1 0.0 0.0
fastpath consistent get quota lim 0 0.0 0.0
file io service time 4,458,553 1,238.5 1,539.0
file io wait time 48,931,077 13,592.0 16,890.3
free buffer inspected 8,345 2.3 2.9
free buffer requested 102,251 28.4 35.3
gc blocks compressed 5,637 1.6 2.0
gc blocks lost 27 0.0 0.0
gc cleanout applied 0 0.0 0.0
gc cleanout saved 1 0.0 0.0
gc cr block flush time 1 0.0 0.0
gc cr block receive time 84 0.0 0.0
gc cr blocks flushed 10 0.0 0.0
gc cr blocks received 4,058 1.1 1.4
gc cr blocks served 4,248 1.2 1.5
gc current block flush time 0 0.0 0.0
gc current block pin time 0 0.0 0.0
gc current block receive time 90 0.0 0.0
gc current blocks flushed 9 0.0 0.0
gc current blocks pinned 0 0.0 0.0
gc current blocks received 3,526 1.0 1.2
gc current blocks served 3,981 1.1 1.4
gc force cr read cr 79,480 22.1 27.4
gc force cr read current 2 0.0 0.0
gc kbytes saved 18,035 5.0 6.2
gc kbytes sent 47,797 13.3 16.5
gc local grants 67,232 18.7 23.2
gc read time waited 0 0.0 0.0
gc read wait timeouts 0 0.0 0.0
Instance Activity Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total per Second per Trans

--------------------------------- ------------------ -------------- ------------
gc read waits 0 0.0 0.0
gc reader bypass grants 307 0.1 0.1
gc reader bypass waits 20 0.0 0.0
gc remote grants 16,622 4.6 5.7
gcs messages sent 97,040 27.0 33.5
ges messages sent 105,180 29.2 36.3
global enqueue get time 6,595 1.8 2.3
global enqueue gets async 13,435 3.7 4.6
global enqueue gets sync 10,092,322 2,803.4 3,483.7
global enqueue releases 9,987,729 2,774.4 3,447.6
heap block compress 973 0.3 0.3
hot buffers moved to head of LRU 988 0.3 0.3
immediate (CR) block cleanout app 55 0.0 0.0
immediate (CURRENT) block cleanou 2,546 0.7 0.9
in call idle wait time 21,744,814 6,040.2 7,506.0
index crx upgrade (positioned) 416 0.1 0.1
index crx upgrade (prefetch) 0 0.0 0.0
index fast full scans (full) 107 0.0 0.0
index fetch by key 655,626 182.1 226.3
index scans kdiixs1 858,844 238.6 296.5
leaf node 90-10 splits 4 0.0 0.0
leaf node splits 166 0.1 0.1
lob reads 1 0.0 0.0
lob writes 6,267 1.7 2.2
lob writes unaligned 1,720 0.5 0.6
logical read bytes from cache 143,367,823,360 39,824,395.4 ############
logons cumulative 25,902 7.2 8.9
max cf enq hold time 1,560 0.4 0.5
messages received 13,015 3.6 4.5
messages sent 13,015 3.6 4.5
min active SCN optimization appli 12 0.0 0.0
no buffer to keep pinned count 43 0.0 0.0
no work - consistent read gets 15,566,808 4,324.1 5,373.4
non-idle wait count 2,751,740 764.4 949.9
non-idle wait time 86,082 23.9 29.7
opened cursors cumulative 979,753 272.2 338.2
parse count (describe) 0 0.0 0.0
parse count (failures) 17 0.0 0.0
parse count (hard) 28,094 7.8 9.7
parse count (total) 717,061 199.2 247.5
parse time cpu 245,178 68.1 84.6
parse time elapsed 258,194 71.7 89.1
physical read IO requests 80,814 22.5 27.9
physical read bytes 662,528,000 184,035.6 228,694.5
physical read total IO requests 229,970 63.9 79.4
physical read total bytes 19,826,563,072 5,507,378.6 6,843,825.7
physical read total multi block r 67,959 18.9 23.5
physical reads 80,875 22.5 27.9
physical reads cache 80,438 22.3 27.8
physical reads cache prefetch 20 0.0 0.0
physical reads direct 437 0.1 0.2
physical reads direct (lob) 77 0.0 0.0
physical reads direct temporary t 0 0.0 0.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 5,478 1.5 1.9
physical write bytes 70,828,032 19,674.5 24,448.8
Instance Activity Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total per Second per Trans

--------------------------------- ------------------ -------------- ------------
physical write total IO requests 39,104 10.9 13.5
physical write total bytes 725,431,808 201,508.8 250,407.9
physical write total multi block 689 0.2 0.2
physical writes 8,646 2.4 3.0
physical writes direct 360 0.1 0.1
physical writes direct (lob) 0 0.0 0.0
physical writes direct temporary 0 0.0 0.0
physical writes from cache 8,286 2.3 2.9
physical writes non checkpoint 4,202 1.2 1.5
pinned buffers inspected 7 0.0 0.0
prefetch clients - default 0 0.0 0.0
prefetch warmup blocks aged out b 0 0.0 0.0
prefetch warmup blocks flushed ou 0 0.0 0.0
prefetched blocks aged out before 3 0.0 0.0
process last non-idle time 3,601 1.0 1.2
queries parallelized 18,877 5.2 6.5
recovery blocks read 0 0.0 0.0
recursive calls 3,567,495 991.0 1,231.4
recursive cpu usage 251,790 69.9 86.9
redo KB read 51,870 14.4 17.9
redo blocks checksummed by FG (ex 25,968 7.2 9.0
redo blocks written 103,909 28.9 35.9
redo blocks written (group 0) 0 0.0 0.0
redo blocks written (group 1) 0 0.0 0.0
redo buffer allocation retries 2 0.0 0.0
redo entries 109,080 30.3 37.7
redo log space requests 2 0.0 0.0
redo log space wait time 2 0.0 0.0
redo ordering marks 0 0.0 0.0
redo size 47,308,868 13,141.4 16,330.3
redo size for direct writes 0 0.0 0.0
redo subscn max counts 2,305 0.6 0.8
redo synch long waits 4 0.0 0.0
redo synch poll writes 0 0.0 0.0
redo synch polls 0 0.0 0.0
redo synch time 173 0.1 0.1
redo synch time (usec) 2,131,623 592.1 735.8
redo synch time overhead (usec) 4,629,678 1,286.0 1,598.1
redo synch time overhead count ( 3,836 1.1 1.3
redo synch time overhead count ( 833 0.2 0.3
redo synch time overhead count ( 2 0.0 0.0
redo synch time overhead count (1 0 0.0 0.0
redo synch time overhead count (i 0 0.0 0.0
redo synch writes 5,851 1.6 2.0
redo wastage 4,061,428 1,128.2 1,401.9
redo write broadcast ack count 36 0.0 0.0
redo write broadcast ack time 26,897 7.5 9.3
redo write broadcast lgwr post co 0 0.0 0.0
redo write finish time 5,210,283 1,447.3 1,798.5
redo write gather time 313,702 87.1 108.3
redo write info find 4,671 1.3 1.6
redo write schedule time 336,560 93.5 116.2
redo write size count ( 4KB) 6,170 1.7 2.1
redo write size count ( 8KB) 246 0.1 0.1
redo write size count ( 16KB) 38 0.0 0.0
redo write size count ( 32KB) 34 0.0 0.0
Instance Activity Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total per Second per Trans

--------------------------------- ------------------ -------------- ------------
redo write size count ( 128KB) 103 0.0 0.0
redo write size count ( 256KB) 4 0.0 0.0
redo write size count ( 512KB) 5 0.0 0.0
redo write size count (1024KB) 4 0.0 0.0
redo write size count (inf) 16 0.0 0.0
redo write time 522 0.2 0.2
redo write time (usec) 5,218,037 1,449.5 1,801.2
redo write total time 5,314,205 1,476.2 1,834.4
redo write worker delay (usec) 0 0.0 0.0
redo writes 6,621 1.8 2.3
redo writes (group 0) 0 0.0 0.0
redo writes (group 1) 0 0.0 0.0
redo writes adaptive all 6,620 1.8 2.3
redo writes adaptive worker 0 0.0 0.0
rollback changes - undo records a 4 0.0 0.0
rollbacks only - consistent read 40 0.0 0.0
root node splits 0 0.0 0.0
rows fetched via callback 236,685 65.8 81.7
securefile allocation bytes 0 0.0 0.0
securefile allocation chunks 0 0.0 0.0
securefile bytes non-transformed 130,965 36.4 45.2
securefile direct read bytes 630,784 175.2 217.7
securefile direct read ops 26 0.0 0.0
securefile direct write bytes 0 0.0 0.0
securefile direct write ops 0 0.0 0.0
securefile number of non-transfor 120 0.0 0.0
segment cfs allocations 0 0.0 0.0
segment chunks allocation from di 0 0.0 0.0
segment dispenser allocations 0 0.0 0.0
segment dispenser load empty 0 0.0 0.0
segment dispenser load tasks 0 0.0 0.0
segment prealloc bytes 0 0.0 0.0
segment prealloc ops 0 0.0 0.0
segment prealloc tasks 0 0.0 0.0
segment prealloc time (ms) 0 0.0 0.0
segment prealloc ufs2cfs bytes 0 0.0 0.0
segment total chunk allocation 0 0.0 0.0
session connect time 0 0.0 0.0
session cursor cache hits 150,133 41.7 51.8
session logical reads 17,500,832 4,861.3 6,041.0
session pga memory 19,873,176 5,520.3 6,859.9
session pga memory max 771,668,056 214,352.2 266,368.0
session uga memory 2,246,293,424 623,970.4 775,386.1
session uga memory max 12,744,249,128 3,540,069.2 4,399,119.5
shared hash latch upgrades - no w 121,483 33.8 41.9
shared hash latch upgrades - wait 0 0.0 0.0
shared io pool buffer get success 26 0.0 0.0
sorts (disk) 0 0.0 0.0
sorts (memory) 42,353 11.8 14.6
sorts (rows) 88,039,375 24,455.4 30,389.8
sql area evicted 25,431 7.1 8.8
sql area purged 46 0.0 0.0
summed dirty queue length 4 0.0 0.0
switch current to new buffer 6,925 1.9 2.4
table fetch by rowid 5,470,243 1,519.5 1,888.2
table fetch continued row 68 0.0 0.0
Instance Activity Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total per Second per Trans

--------------------------------- ------------------ -------------- ------------
table scan blocks gotten 12,016,370 3,337.9 4,147.9
table scan disk non-IMC rows gott 268,931,651 74,703.2 92,831.1
table scan rows gotten 271,864,794 75,518.0 93,843.6
table scans (direct read) 0 0.0 0.0
table scans (long tables) 0 0.0 0.0
table scans (short tables) 47,744 13.3 16.5
temp space allocated (bytes) 8,388,608 2,330.2 2,895.6
total cf enq hold time 4,100 1.1 1.4
total number of cf enq holders 1,169 0.3 0.4
total number of times SMON posted 1,200 0.3 0.4
transaction lock background gets 0 0.0 0.0
transaction lock foreground reque 0 0.0 0.0
transaction lock foreground wait 0 0.0 0.0
transaction rollbacks 2 0.0 0.0
transaction tables consistent rea 0 0.0 0.0
transaction tables consistent rea 0 0.0 0.0
undo change vector size 17,205,272 4,779.2 5,939.0
user I/O wait time 4,364 1.2 1.5
user calls 738,560 205.2 254.9
user commits 2,382 0.7 0.8
user logons cumulative 5,212 1.5 1.8
user logouts cumulative 5,203 1.5 1.8
user rollbacks 515 0.1 0.2
workarea executions - onepass 0 0.0 0.0
workarea executions - optimal 25,959 7.2 9.0
write clones created in backgroun 0 0.0 0.0
write clones created in foregroun 0 0.0 0.0
-------------------------------------------------------------

Instance Activity Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Statistics with absolute values (should not be diffed)

Statistic Begin Value End Value

--------------------------------- --------------- ---------------
logons current 127 136
opened cursors current 739 753
session cursor cache count 9,429,804 9,481,421
workarea memory allocated 0 268
-------------------------------------------------------------

Instance Activity Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic Total per Hour

--------------------------------- ------------------ ---------
log switches (derived) 60 60.00
-------------------------------------------------------------

OS Statistics DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> ordered by statistic type (CPU use, Virtual Memory, Hardware Config), Name

Statistic Total
------------------------- ----------------------
INACTIVE_MEMORY_BYTES 18,267,869,184
SWAP_FREE_BYTES 33,549,213,696
BUSY_TIME 466,837
IDLE_TIME 9,527,373
IOWAIT_TIME 2,712
NICE_TIME 0
SYS_TIME 98,491
USER_TIME 366,262
RSRC_MGR_CPU_WAIT_TIME 9
VM_IN_BYTES 0
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 134,795,640,832
NUM_CPUS 28
NUM_CPU_CORES 14
NUM_CPU_SOCKETS 1
GLOBAL_RECEIVE_SIZE_MAX 4,194,304
GLOBAL_SEND_SIZE_MAX 1,048,576
TCP_RECEIVE_SIZE_DEFAULT 87,380
TCP_RECEIVE_SIZE_MAX 6,291,456
TCP_RECEIVE_SIZE_MIN 4,096
TCP_SEND_SIZE_DEFAULT 16,384
TCP_SEND_SIZE_MAX 4,194,304
TCP_SEND_SIZE_MIN 4,096
-------------------------------------------------------------

OS Statistics - detail DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Snap Snapshot
Id Day Time Load %Busy %User %System %WIO %WCPU
------ --------------- ------ ------ ------ ------- ------ ------
2677 Wed 27 10:30:34 2.8
2678 Wed 27 11:30:34 1.4 4.7 3.7 1.0 0.0
-------------------------------------------------------------
IO Stat by Function - summary DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->Data Volume values suffixed with M,G,T,P are in multiples of 1024,
other values suffixed with K,M,G,T,P are in multiples of 1000
->ordered by Data Volume (Read+Write) desc

---------- Read --------- --------- Write -------- --- Wait ----

Data Requests Data Data Requests Data Avg
Function Volume /sec Vol/sec Volume /sec Vol/sec Count Tm(ms)
--------------- ------ -------- -------- ------ -------- -------- ------ ------
Others 17G 38.8 4.9M 324M 1.5 .1M 77K 0.0
RMAN 661M 1.8 .2M 178M .1 .0M 4931 0.0
Buffer Cache Re 628M 22.3 .2M 80K 0.0
LGWR 49M .9 .0M 121M 7.7 .0M 11K 0.0
Direct Reads 3M .1 .0M .0 0.0
Direct Writes 1M .0 .0M 2M .1 .0M 0.0
-------------------------------------------------------------

IO Stat by Function - detail DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

->ordered by Data Volume (Read+Write) desc

----------- Read ---------- ----------- Write ---------

Small Large Small Large Small Large Small Large
Read Read Data Data Write Write Data Data
Function Reqs Reqs Read Read Reqs Reqs Writn Writn
------------------ ------ ------ ------ ------ ------ ------ ------ ------
Others 73K 66K 2026M 15G 5113 298 82M 242M
RMAN 4503 2002 86M 575M 200 177 3M 175M
Buffer Cache Reads 80K 628M
LGWR 3369 49M 28K 104 56M 65M
Direct Reads 313 3M 29
Direct Writes 73 1M 331 2M
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->ordered by IOs (Reads + Writes) desc

Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
SYSAUX
23,335 6 0.3 1.0 327 0 0 0.0
SEED_IDX
11,939 3 0.2 1.0 24 0 0 0.0
X3PRDPF_IDX
10,959 3 0.3 1.0 24 0 0 0.0
SYSTEM
9,209 3 0.3 1.0 212 0 0 0.0
SEED_DAT
7,164 2 0.2 1.0 24 0 0 0.0
X3PRDPF_DAT
6,409 2 0.2 1.0 24 0 0 0.0
X3PRD_IDX
2,714 1 0.5 1.0 1,808 1 0 0.0
X3_IDX
4,366 1 0.3 1.0 56 0 0 0.0
X3_DAT
3,444 1 0.3 1.0 124 0 0 0.0
X3PRD_DAT
572 0 0.6 1.1 967 0 0 0.0
PERFSTAT
476 0 2.5 1.0 893 0 0 0.0
UNDOTBS1
24 0 0.4 1.0 659 0 0 0.0
USERS
148 0 0.5 1.0 270 0 0 0.0
BSCX3TEST
29 0 0.7 1.0 24 0 0 0.0
UNDOTBS2
25 0 0.4 1.0 24 0 0 0.0
TEMP
0 0 0.0 3 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->Mx Rd Bkt: Max bucket time for single block read
->ordered by Tablespace, File

Tablespace Filename
------------------------ ----------------------------------------------------
Av Mx Av
Av Rd Rd Av Av Buffer BufWt
Reads Reads/s (ms) Bkt Blks/Rd Writes Writes/s Waits (ms)
-------------- ------- ----- --- ------- ------------ -------- ---------- ------
BSCX3TEST +DATA_DG/PRDX3/DATAFILE/bscx3test.325.910430035
29 0 0.7 1 1.0 24 0 0

PERFSTAT +DATA_DG/PRDX3/DATAFILE/perfstat.326.912090039
476 0 2.5 1 1.0 893 0 0

SEED_DAT +DATA_DG/PRDX3/DATAFILE/seed_dat.271.895336327
7,164 2 0.2 1 1.0 24 0 0

SEED_IDX +DATA_DG/PRDX3/DATAFILE/seed_idx.272.895336329
11,939 3 0.2 1 1.0 24 0 0

SYSAUX +DATA_DG/PRDX3/DATAFILE/sysaux.257.895240481
23,335 6 0.3 1 1.0 327 0 0

SYSTEM +DATA_DG/PRDX3/DATAFILE/system.258.895240515
9,209 3 0.3 1 1.0 212 0 0

TEMP +DATA_DG/PRDX3/TEMPFILE/temp.264.895240605
0 0 3 0 0

UNDOTBS1 +DATA_DG/PRDX3/DATAFILE/undotbs1.260.895240551
24 0 0.4 1.0 659 0 0

UNDOTBS2 +DATA_DG/PRDX3/DATAFILE/undotbs2.265.895240743
25 0 0.4 1 1.0 24 0 0

USERS +DATA_DG/PRDX3/DATAFILE/users.259.895240551
148 0 0.5 1 1.0 270 0 0

X3PRDPF_DAT +DATA_DG/PRDX3/DATAFILE/x3prdpf_dat.262.914374437
6,409 2 0.2 1 1.0 24 0 0

X3PRDPF_IDX +DATA_DG/PRDX3/DATAFILE/x3prdpf_idx.279.914374443
10,959 3 0.3 1 1.0 24 0 0

X3PRD_DAT +DATA_DG/PRDX3/DATAFILE/x3prd_dat.266.915577131
572 0 0.6 1 1.1 967 0 0

X3PRD_IDX +DATA_DG/PRDX3/DATAFILE/x3prd_idx.263.915577133
2,714 1 0.5 1 1.0 1,808 1 0

X3_DAT +DATA_DG/PRDX3/DATAFILE/x3_dat.269.895336245
3,444 1 0.3 1 1.0 124 0 0

X3_IDX +DATA_DG/PRDX3/DATAFILE/x3_idx.270.895336245
4,366 1 0.3 1 1.0 56 0 0

-------------------------------------------------------------
File Read Histogram Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->Number of single block reads in each time range
->Tempfiles are not included
->ordered by Tablespace, File

Tablespace Filename
------------------------ ----------------------------------------------------
0 - 2 ms 2 - 4 ms 4 - 8 ms 8 - 16 ms 16 - 32 ms 32+ ms
------------ ------------ ------------ ------------ ------------ ------------
SEED_IDX +DATA_DG/PRDX3/DATAFILE/seed_idx.272.895336329
11,900 0 0 0 0 0

X3PRDPF_DAT +DATA_DG/PRDX3/DATAFILE/x3prdpf_dat.262.914374437
6,378 0 0 0 0 0

X3PRDPF_IDX +DATA_DG/PRDX3/DATAFILE/x3prdpf_idx.279.914374443
10,929 0 0 0 0 0

PERFSTAT +DATA_DG/PRDX3/DATAFILE/perfstat.326.912090039
301 0 0 0 0 0

SYSTEM +DATA_DG/PRDX3/DATAFILE/system.258.895240515
9,113 0 0 0 0 0

X3_DAT +DATA_DG/PRDX3/DATAFILE/x3_dat.269.895336245
3,407 0 0 0 0 0

SYSAUX +DATA_DG/PRDX3/DATAFILE/sysaux.257.895240481
23,271 0 0 0 0 0

USERS +DATA_DG/PRDX3/DATAFILE/users.259.895240551
116 0 0 0 0 0

X3_IDX +DATA_DG/PRDX3/DATAFILE/x3_idx.270.895336245
4,336 0 0 0 0 0

UNDOTBS2 +DATA_DG/PRDX3/DATAFILE/undotbs2.265.895240743
1 0 0 0 0 0

X3PRD_DAT +DATA_DG/PRDX3/DATAFILE/x3prd_dat.266.915577131
489 0 0 0 0 0

BSCX3TEST +DATA_DG/PRDX3/DATAFILE/bscx3test.325.910430035
5 0 0 0 0 0

SEED_DAT +DATA_DG/PRDX3/DATAFILE/seed_dat.271.895336327
7,135 0 0 0 0 0

X3PRD_IDX +DATA_DG/PRDX3/DATAFILE/x3prd_idx.263.915577133
2,592 0 0 0 0 0

-------------------------------------------------------------
IO Stats Function Detail DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Small Small Large Large

Function FileType Read Write Read Write Wait Time
Name Name (MB) (MB) (MB) (MB) Waits (ms)
------------ ------------ ------- ------- ------- ------- --------- -----------
RMAN Control File 60 3 287 72 4173 1354
RMAN Data File 0 0 0 0 0 0
RMAN Archive Log 5 0 94 0 240 836
RMAN Other(8) 0 0 0 0 487 337
RMAN Data File Ba 0 0 0 5 29 137
RMAN Data File In 0 0 0 0 0 0
RMAN Archive Log 0 0 0 98 0 0
RMAN Parameter Fi 0 0 0 0 2 0
RMAN OSM File 21 0 194 0 0 0
DBWR Control File 0 0 0 0 0 0
DBWR Data File 0 51 0 14 0 0
LGWR Control File 49 19 0 0 3129 788
LGWR Data File 0 0 0 0 0 0
LGWR Log File 0 37 0 65 480 146
LGWR Other(8) 0 0 0 0 7222 5142
Streams AQ Data File 0 0 0 0 0 0
Buffer Cache Data File 628 0 0 0 80416 23611
Buffer Cache Other(8) 0 0 0 0 3 9
Buffer Cache OSM File 0 0 0 0 0 0
Direct Reads Data File 3 0 0 0 0 0
Direct Write Data File 1 2 0 0 0 0
Others(14) Control File 798 79 8505 145 61343 28137
Others(14) Data File 14 0 0 0 1830 405
Others(14) Log File 2 0 48 0 492 80
Others(14) Archive Log 2 3 49 97 0 0
Others(14) Other(8) 0 0 0 0 12364 12559
Others(14) Parameter Fi 0 0 0 0 0 0
Others(14) OSM File 1210 0 6984 0 0 0
Others(14) Password Fil 0 0 0 0 780 200
Others(14) External Tab 0 0 1 0 0 0
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> B: Begin snapshot, E: End snapshot

Targt Estd Log File Log Ckpt Log Ckpt

MTTR MTTR Recovery Actual Target Size Timeout Interval
(s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks
- ----- ----- ---------- --------- --------- ---------- --------- ------------
B 0 0 697 5958 4213 995328 4213
E 0 0 849 2582 3001 995328 3001
-------------------------------------------------------------

Memory Dynamic Components DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Op - memory resize Operation
-> Cache: D: Default, K: Keep, R: Recycle
-> Mode: DEF: DEFerred mode, IMM: IMMediate mode

Begin Snap End Snap Op Last Op

Cache Size (M) Size (M) Count Type/Mode Last Op Time
---------------------- ---------- -------- ------- ---------- ---------------
D:buffer cache 2,192 0 SHRINK/DEF 19-Jul 10:09:12
PGA Target 6,144 0 STATIC
SGA Target 8,192 0 STATIC
Shared IO Pool 400 0 GROW/IMM 16-Jul 22:21:35
java pool 112 0 STATIC
large pool 576 0 SHRINK/DEF 16-Jul 22:22:08
shared pool 4,896 0 GROW/DEF 19-Jul 10:09:12
-------------------------------------------------------------

Buffer Pool Advisory DB/Inst: PRDX3/PRDX31 End Snap: 2678

-> Only rows with estimated physical reads >0 are displayed
-> ordered by Pool, Block Size, Buffers For Estimate

Est
Phys Estimated Est
Size for Size Buffers Read Phys Reads Est Phys % dbtime
P Est (M) Factr (thousands) Factr (thousands) Read Time for Rds
--- -------- ----- ------------ ------ -------------- ------------ --------
D 208 .1 24 35.6 847,086 344,927 50.1
D 416 .2 49 11.4 271,785 110,785 16.1
D 624 .3 73 5.3 125,577 51,280 7.4
D 832 .4 98 3.3 77,702 31,796 4.6
D 1,040 .5 122 2.3 54,592 22,390 3.2
D 1,248 .6 147 1.8 42,183 17,340 2.5
D 1,456 .7 171 1.5 34,629 14,265 2.1
D 1,664 .8 196 1.2 29,540 12,194 1.8
D 1,872 .9 220 1.1 26,692 11,035 1.6
D 2,080 .9 245 1.0 24,597 10,183 1.5
D 2,192 1.0 258 1.0 23,814 9,864 1.4
D 2,288 1.0 269 1.0 23,281 9,647 1.4
D 2,496 1.1 294 0.9 21,663 8,988 1.3
D 2,704 1.2 318 0.9 20,838 8,653 1.3
D 2,912 1.3 343 0.8 20,239 8,409 1.2
D 3,120 1.4 367 0.8 19,783 8,224 1.2
D 3,328 1.5 392 0.8 19,484 8,101 1.2
D 3,536 1.6 416 0.8 19,344 8,045 1.2
D 3,744 1.7 441 0.8 19,210 7,990 1.2
D 3,952 1.8 465 0.8 19,071 7,934 1.2
D 4,160 1.9 490 0.8 18,937 7,879 1.1
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
-> Buffers: the number of buffers. Units of K, M, G are divided by 1000

Free Writ Buffer

Pool Buffer Physical Physical Buffer Comp Busy
P Buffers Hit% Gets Reads Writes Waits Wait Waits
--- ------- ---- -------------- ------------ ----------- ------- ---- ----------
D 258K 100 17,502,205 80,439 8,286 0 0 0
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> B: Begin snap E: End snap (rows identified with B or E contain data
which is absolute i.e. not diffed over the interval)
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
-> Auto PGA Target - actual workarea memory target
-> W/A PGA Used - amount of memory used for all WorkAreas (manual + auto)
-> %PGA W/A Mem - percentage of PGA memory allocated to WorkAreas
-> %Auto W/A Mem - percentage of WorkArea memory controlled by Auto Mem Mgmt
-> %Man W/A Mem - percentage of WorkArea memory under Manual control

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written

--------------- ---------------- -------------------------
100.0 3,808 0

%PGA %Auto %Man

PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem
Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
- --------- --------- ---------- ---------- ------ ------ ------ ----------
B 6,144 4,958 819.9 0.0 .0 .0 .0 629,140
E 6,144 4,952 842.5 0.3 .0 100.0 .0 629,140
-------------------------------------------------------------

PGA Aggr Target Histogram DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Optimal Executions are purely in-memory operations

Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
2K 4K 22,783 22,783 0 0
64K 128K 162 162 0 0
128K 256K 320 320 0 0
256K 512K 18 18 0 0
512K 1024K 1,194 1,194 0 0
1M 2M 1,413 1,413 0 0
2M 4M 34 34 0 0
4M 8M 16 16 0 0
8M 16M 2 2 0 0
16M 32M 2 2 0 0
32M 64M 4 4 0 0
64M 128M 4 4 0 0
-------------------------------------------------------------

PGA Memory Advisory DB/Inst: PRDX3/PRDX31 End Snap: 2678

-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
where Estd PGA Overalloc Count is 0

Estd Extra Estd

PGA Aggr W/A MB Estd Time PGA Estd PGA
Target Size W/A MB Read/Written to Process Cache Overalloc
Est (MB) Factr Processed to Disk Bytes (s) Hit % Count
---------- ------ -------------- -------------- ---------- ------ ----------
768 0.1 1,562,398 20,606 922.6 99.0 571
1,536 0.3 1,562,398 79 910.7 100.0 0
3,072 0.5 1,562,398 79 910.7 100.0 0
4,608 0.8 1,562,398 79 910.7 100.0 0
6,144 1.0 1,562,398 79 910.7 100.0 0
7,373 1.2 1,562,398 0 910.6 100.0 0
8,602 1.4 1,562,398 0 910.6 100.0 0
9,830 1.6 1,562,398 0 910.6 100.0 0
11,059 1.8 1,562,398 0 910.6 100.0 0
12,288 2.0 1,562,398 0 910.6 100.0 0
18,432 3.0 1,562,398 0 910.6 100.0 0
24,576 4.0 1,562,398 0 910.6 100.0 0
36,864 6.0 1,562,398 0 910.6 100.0 0
49,152 8.0 1,562,398 0 910.6 100.0 0
-------------------------------------------------------------
Process Memory Summary Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> B: Begin snap E: End snap
-> All rows below contain absolute values (i.e. not diffed over the interval)
-> Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
-> Num Procs or Allocs: For Begin/End snapshot lines, it is the number of
processes. For Category lines, it is the number of allocations
-> ordered by Begin/End snapshot, Alloc (MB) desc

Hist Num
Avg Std Dev Max Max Procs
Alloc Used Freeabl Alloc Alloc Alloc Alloc or
Category (MB) (MB) (MB) (MB) (MB) (MB) (MB) Allocs
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B -------- 820.5 631.7 116.1 6.3 9.0 60 344 131
Other 682.8 5.2 8.7 60 256 131
Freeable 116.1 .0 1.5 2.1 15 79
SQL 19.8 4.1 .2 .3 1 86 74
PL/SQL 1.9 1.1 .0 .1 1 1 128
E -------- 842.5 640.0 123.4 6.0 8.8 60 345 140
Other 696.7 5.0 8.5 60 257 140
Freeable 123.4 .0 1.4 2.0 15 91
SQL 20.5 4.9 .2 .3 1 111 83
PL/SQL 1.9 1.2 .0 .1 1 1 137
-------------------------------------------------------------

Top Process Memory (by component) DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> ordered by Begin/End snapshot, Alloc (MB) desc

Alloc Used Freeabl Max Hist Max

PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
B 39 MARK -------- 59.6 59.4 .0 59.6 59.6
Other 59.6 59.6 59.6
PL/SQL .0 .0 .0 .0
52 ARC3 -------- 47.6 40.8 3.2 47.6 47.6
Other 44.4 44.4 44.4
Freeable 3.2 .0 3.2
PL/SQL .0 .0 .0 .0
49 ARC0 -------- 44.4 40.8 .0 44.4 44.4
Other 44.4 44.4 44.4
PL/SQL .0 .0 .0 .0
50 ARC1 -------- 44.4 40.8 .0 44.4 44.4
Other 44.4 44.4 44.4
PL/SQL .0 .0 .0 .0
18 LMS1 -------- 22.2 21.6 .0 22.2 22.2
Other 22.2 22.2 22.2
PL/SQL .0 .0 .0 .0
17 LMS0 -------- 21.4 17.5 3.4 21.4 21.4
Other 18.0 18.0 18.0
Freeable 3.4 .0 3.4
PL/SQL .0 .0 .0 .0
22 DBW0 -------- 20.6 13.4 5.9 20.6 20.6
Other 14.6 14.6 14.6
Freeable 5.9 .0 5.9
PL/SQL .0 .0 .0 .0
35 MMON -------- 19.6 3.9 15.1 19.6 19.6
Freeable 15.1 .0 15.1
Other 3.9 3.9 3.9
PL/SQL .5 .3 .5 .6
SQL .0 .0 .0 2.3
51 ARC2 -------- 19.5 17.8 .0 19.5 19.5
Other 19.5 19.5 19.5
PL/SQL .0 .0 .0 .0
23 DBW1 -------- 18.1 11.0 3.1 18.1 18.1
Other 15.0 15.0 15.0
Freeable 3.1 .0 3.1
PL/SQL .0 .0 .0 .0
24 DBW2 -------- 17.6 10.4 3.1 17.6 17.6
Other 14.5 14.5 14.5
Freeable 3.1 .0 3.1
PL/SQL .0 .0 .0 .0
14 LMON -------- 16.7 16.0 .0 16.7 16.7
Other 16.7 16.7 16.7
PL/SQL .0 .0 .0 .0
13 DIA0 -------- 14.9 14.0 .4 14.9 14.9
Other 14.5 14.5 14.5
Freeable .4 .0 .4
PL/SQL .0 .0 .0 .0
16 LMD1 -------- 13.1 12.5 .2 13.1 13.1
Other 13.0 13.0 13.0
Freeable .2 .0 .2
PL/SQL .0 .0 .0 .0
15 LMD0 -------- 13.1 12.5 .2 13.1 13.1
Other 12.9 12.9 12.9

Top Process Memory (by component) DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> ordered by Begin/End snapshot, Alloc (MB) desc

Alloc Used Freeabl Max Hist Max

PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
B 15 Freeable .2 .0 .2
PL/SQL .0 .0 .0 .0
60 CJQ0 -------- 12.4 4.7 7.3 12.4 12.4
Freeable 7.3 .0 7.3
Other 4.8 4.8 4.8
PL/SQL .4 .3 .4 .5
SQL .0 .0 .0 2.3
57 W001 -------- 9.9 3.6 5.8 9.9 9.9
Freeable 5.8 .0 5.8
Other 4.2 4.2 4.2
SQL .0 .0 .0 .7
PL/SQL .0 .0 .0 .0
121 ------------ 9.1 8.8 .0 9.1 19.5
Other 8.8 8.8 12.1
SQL .5 .1 .5 7.4
PL/SQL .0 .0 .0 .0
56 W000 -------- 9.0 3.7 4.9 9.0 9.0
Freeable 4.9 .0 4.9
Other 4.1 4.1 4.1
SQL .0 .0 .0 .7
PL/SQL .0 .0 .0 .0
68 W003 -------- 8.7 3.6 4.8 8.7 8.7
Freeable 4.8 .0 4.8
Other 3.9 3.9 3.9
SQL .0 .0 .0 .6
PL/SQL .0 .0 .0 .0
E 39 MARK -------- 59.6 59.4 .0 59.6 59.6
Other 59.6 59.6 59.6
PL/SQL .0 .0 .0 .0
52 ARC3 -------- 47.6 40.8 3.2 47.6 47.6
Other 44.4 44.4 44.4
Freeable 3.2 .0 3.2
PL/SQL .0 .0 .0 .0
49 ARC0 -------- 44.4 40.8 .0 44.4 44.4
Other 44.4 44.4 44.4
PL/SQL .0 .0 .0 .0
50 ARC1 -------- 44.4 40.8 .0 44.4 44.4
Other 44.4 44.4 44.4
PL/SQL .0 .0 .0 .0
18 LMS1 -------- 22.2 21.6 .0 22.2 22.2
Other 22.2 22.2 22.2
PL/SQL .0 .0 .0 .0
17 LMS0 -------- 21.4 17.5 3.4 21.4 21.4
Other 18.0 18.0 18.0
Freeable 3.4 .0 3.4
PL/SQL .0 .0 .0 .0
22 DBW0 -------- 20.6 13.4 5.9 20.6 20.6
Other 14.6 14.6 14.6
Freeable 5.9 .0 5.9
PL/SQL .0 .0 .0 .0
35 MMON -------- 19.6 3.9 15.1 19.6 19.6
Freeable 15.1 .0 15.1
Other 3.9 3.9 3.9

Top Process Memory (by component) DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> ordered by Begin/End snapshot, Alloc (MB) desc

Alloc Used Freeabl Max Hist Max

PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
E 35 PL/SQL .5 .3 .5 .6
SQL .0 .0 .0 2.3
51 ARC2 -------- 19.5 17.8 .0 19.5 19.5
Other 19.5 19.5 19.5
PL/SQL .0 .0 .0 .0
23 DBW1 -------- 18.1 11.0 3.1 18.1 18.1
Other 15.0 15.0 15.0
Freeable 3.1 .0 3.1
PL/SQL .0 .0 .0 .0
24 DBW2 -------- 17.6 10.4 3.1 17.6 17.6
Other 14.5 14.5 14.5
Freeable 3.1 .0 3.1
PL/SQL .0 .0 .0 .0
14 LMON -------- 16.7 16.0 .0 16.7 16.7
Other 16.7 16.7 16.7
PL/SQL .0 .0 .0 .0
13 DIA0 -------- 14.9 14.1 .3 14.9 14.9
Other 14.7 14.7 14.7
Freeable .3 .0 .3
PL/SQL .0 .0 .0 .0
16 LMD1 -------- 13.1 12.5 .2 13.1 13.1
Other 13.0 13.0 13.0
Freeable .2 .0 .2
PL/SQL .0 .0 .0 .0
15 LMD0 -------- 13.1 12.5 .2 13.1 13.1
Other 12.9 12.9 12.9
Freeable .2 .0 .2
PL/SQL .0 .0 .0 .0
60 CJQ0 -------- 12.4 4.7 7.3 12.4 12.4
Freeable 7.3 .0 7.3
Other 4.8 4.8 4.8
PL/SQL .4 .3 .4 .5
SQL .0 .0 .0 2.3
57 W001 -------- 9.9 3.7 5.7 9.9 9.9
Freeable 5.7 .0 5.7
Other 4.2 4.2 4.2
SQL .0 .0 .0 .7
PL/SQL .0 .0 .0 .0
56 W000 -------- 9.0 3.7 4.9 9.0 9.0
Freeable 4.9 .0 4.9
Other 4.1 4.1 4.1
SQL .0 .0 .0 .7
PL/SQL .0 .0 .0 .0
130 ------------ 9.0 5.9 1.0 9.0 344.6
Other 7.6 7.6 257.3
Freeable 1.0 .0 1.0
SQL .3 .0 .3 85.5
PL/SQL .0 .0 .0 .8
68 W003 -------- 8.7 3.6 4.8 8.7 8.7
Freeable 4.8 .0 4.8
Other 3.9 3.9 3.9
SQL .0 .0 .0 .6
PL/SQL .0 .0 .0 .0

Top Process Memory (by component) DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> ordered by Begin/End snapshot, Alloc (MB) desc

Alloc Used Freeabl Max Hist Max

PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
-------------------------------------------------------------
Enqueue activity DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> only enqueues with waits are shown
-> Enqueue stats gathered prior to 10g should not be compared with 10g data
-> ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)

------------------------------------------------------------------------------
Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
------------ ------------ ----------- ----------- ------------ --------------
PS-PX Process Reservation
134,022 133,690 332 23,001 14 .60
CF-Controlfile Transaction
9,745 9,745 0 302 2 4.97
XR-Quiesce / Force Logging (database force logging)
1,199 1,199 0 1,199 1 .57
RS-Reclaimable Space (prevent file delete)
269 269 0 64 0 .47
WL-Being Written Redo Log
96 60 36 39 0 .51
JS-Job Scheduler (job run lock - synchronize)
32 32 0 31 0 .65
TM-DML
11,035 11,035 0 8 0 1.25
FB-Format Block
27 27 0 23 0 .00
TA-Instance Undo
23 23 0 23 0 .00
TD-KTF map table enqueue (KTF dump entries)
12 12 0 12 0 .00
WF-AWR Flush
9 9 0 8 0 .00
TX-Transaction (index contention)
2 2 0 2 0 .00
MW-MWIN Schedule
2 2 0 2 0 .00
DR-Distributed Recovery
2 2 0 2 0 .00
UL-User-defined
1 1 0 1 0 .00
-------------------------------------------------------------
Undo Segment Summary DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
-> STO - Snapshot Too Old count, OOS - Out Of Space count
-> Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/
TS# Blocks (K) Transactions Len (s) Concy TR (mins) OOS eS/eR/eU
---- ---------- --------------- -------- ---------- --------- ----- -----------
2 2.9 7,679 2,408 3 42.1/52.1 0/0 0/0/0/0/0/0
-------------------------------------------------------------

Undo Segment Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Most recent 35 Undostat rows, ordered by End Time desc

Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/
End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- -----------
27-Jul 11:31 507 1,012 1,293 2 49 0/0 0/0/0/0/0/0
27-Jul 11:21 139 918 2,408 3 52 0/0 0/0/0/0/0/0
27-Jul 11:11 44 867 1,808 2 42 0/0 0/0/0/0/0/0
27-Jul 11:01 549 1,375 2,292 3 50 0/0 0/0/0/0/0/0
27-Jul 10:51 494 1,201 1,810 2 43 0/0 0/0/0/0/0/0
27-Jul 10:41 708 1,313 1,887 2 45 0/0 0/0/0/0/0/0
27-Jul 10:31 428 993 2,376 3 52 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

Pct Avg Wait Pct

Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
AQ Background: interrupt 1 0.0 0 848 0.0
AQ Coord jobx_kwsbgsgn l 120 0.0 0 0
AQ Sharded master pool l 120 0.0 0 0
AQ deq hash table latch 1 0.0 0 0
ASM Keyed state latch 10,837 0.0 0 0
ASM allocation 5,558 0.0 0 0
ASM db client latch 2,836 0.0 0 0
ASM map headers 4,554 0.0 0 0
ASM map load waiting lis 820 0.0 0 0
ASM map operation freeli 15,726 0.0 0 0
ASM map operation hash t 2,067,285 0.0 0.0 0 0
ASM network SGA latch 213 0.0 0 0
ASM network background l 17,793 0.0 0 0
ASM network state latch 4,745 0.0 0 0
ASM remote client latch 161 0.0 0 0
ASM scan context latch 284 0.0 0 0
AWR Alerted Metric Eleme 26,282 0.0 0 0
Change Notification Hash 1,199 0.0 0 0
Consistent RBA 6,679 0.0 0 0
DML lock allocation 1,656,480 0.0 0 0
Event Group Locks 31,322 0.0 0 0
FAL Queue 219 0.0 0 0
FIB s.o chain latch 2,160 0.0 0 0
FOB s.o list latch 28,027 0.0 0 0
File State Object Pool P 1 0.0 0 0
Hang Manager wait event 238 0.0 0 2,699 0.0
I/O Staticstics latch 1 0.0 0 0
ILM Stats Stripe Latch 1 0.0 0 0
ILM Stats main anchor la 26,139 0.0 0 0
ILM access tracking exte 1 0.0 0 0
ILM activity tracking la 1 0.0 0 0
IM area sb latch 1 0.0 0 0
IM area scb latch 1 0.0 0 0
IM emb latch 1 0.0 0 0
IM seg hdr latch 1 0.0 0 0
IPC other latch 29 0.0 0 0
IPC stats buffer allocat 56,061 0.0 0 56,022 0.0
In memory undo latch 1 0.0 0 0
JS Sh mem access 5 0.0 0 0
JS broadcast add buf lat 1,122 0.0 0 0
JS broadcast drop buf la 1,120 0.0 0 0
JS broadcast load blnc l 105 0.0 0 0
JS mem alloc latch 71 0.0 0 0
JS queue access latch 72 0.0 0 0
JS queue state obj latch 67,114 0.0 0 0
JS slv state obj latch 97 0.0 0 0
KCNIBR - invalid block r 1 0.0 0 0
KFC FX Hash Latch 1 0.0 0 0
KFC Hash Latch 1 0.0 0 0
KFCL LE Freelist 1 0.0 0 0
Latch Activity DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

Pct Avg Wait Pct

Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
KFK SGA Libload latch 1,000 0.0 0 0
KFMD SGA 122 0.0 0 0
KGNFS-NFS:SHM structure 1 0.0 0 0
KGNFS-NFS:SVR LIST 1,201 0.0 0 0
KJC message pool free li 28,152 0.3 0.0 0 6,768 0.0
KJC message pool pending 1 0.0 0 0
KJCT flow control latch 356,751 0.0 0.0 0 0
KMG MMAN ready and start 1,200 0.0 0 0
KSFS OFS ctx level paren 1 0.0 0 0
KSFS OFS req layer paren 1 0.0 0 0
KSFS OFS sess layer pare 1 0.0 0 0
KSFS id table parent lat 1 0.0 0 0
KSFS ksfs_node latch 1 0.0 0 0
KSFSD name cache parent 1 0.0 0 0
KSXR hang analysis phase 39,077 0.0 0 4 0.0
KSXR hang analysis phase 3,149 0.0 0 0
KSXR large replies 242 0.0 0 0
KTF sga latch 463 0.2 0.0 0 1,005 0.0
KTILM latch 1 0.0 0 0
KWQMN job cache list lat 259 0.0 0 0
KWQP Prop Status 2 0.0 0 0
Locator state objects po 1 0.0 0 0
Lsod array latch 11,289 0.0 0 0
MQL Tracking Latch 0 0 71 0.0
Memory Management Latch 1 0.0 0 1,200 0.0
Memory Queue 1 0.0 0 0
Memory Queue Message Sub 1 0.0 0 0
Memory Queue Message Sub 1 0.0 0 0
Memory Queue Message Sub 1 0.0 0 0
Memory Queue Message Sub 1 0.0 0 0
Memory Queue Subscriber 1 0.0 0 0
Message cache latch 1 0.0 0 0
MinActiveScn Latch 2,478 0.0 0 0
Mutex 1 0.0 0 0
Mutex Stats 1 0.0 0 0
OS process 22,734 0.0 0 0
OS process allocation 18,862 0.0 0 0
OS process: request allo 10,838 0.0 0 0
PL/SQL warning settings 104,097 0.0 0 0
PX hash array latch 1 0.0 0 0
Parent latch for depende 1 0.0 0 0
QMT 1 0.0 0 0
RTT parent context 60 0.0 0 0
Report Request stats lat 240 0.0 0 0
Request holder compeltio 427 0.0 0 0
Reserved Space Latch 254 0.0 0 0
Retry Ht elm latch 1 0.0 0 0
Retry bkt latch 1 0.0 0 0
SGA Blackbox latch 4 0.0 0 0
SGA IO buffer pool latch 77 0.0 0 77 0.0
Latch Activity DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

Pct Avg Wait Pct

Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
SGA Logging Bkt Latch 56,811 0.0 0 0
SGA Logging Log Latch 61,199 0.0 0 3,713 0.0
SGA blob parent 1 0.0 0 0
SGA bucket locks 1 0.0 0 0
SGA heap locks 1 0.0 0 0
SGA pool locks 1 0.0 0 0
SQL memory manager latch 1 0.0 0 1,199 0.0
SQL memory manager worka 176,466 0.0 0 0
SR Stats Stripe Latch 1 0.0 0 0
SR Stats main anchor lat 3,172 0.0 0 0
Sched IM Job latch 162 0.0 0 0
Sched InMem Job Cache 1,171 0.0 0 0
Shared B-Tree 132 0.0 0 0
Streams Generic 1 0.0 0 0
Subscriber Ht elm latch 1 0.0 0 0
Testing 1 0.0 0 0
Token Manager 1 0.0 0 0
Txn Ht elm latch 1 0.0 0 0
Txn bkt latch 1 0.0 0 0
WCR: sync 1 0.0 0 0
Write State Object Pool 1 0.0 0 0
X$KSFQP 39,557 0.0 0 0
XDB NFS Security Latch 1 0.0 0 0
XDB unused session pool 1 0.0 0 0
XDB used session pool 1 0.0 0 0
active checkpoint queue 6,230 2.0 0.0 0 0
active service list 221,754 0.0 0.0 0 194,339 0.0
affinity stats hash tabl 126 0.0 0 0
affinity stats objects f 129 0.0 0 0
alert log latch 120 0.0 0 0
archive destination 7,833 0.0 0 0
archive process latch 657 0.0 0 0
buffer pool 1 0.0 0 0
business card 37,753 0.0 0 0
cache buffer handles 320 0.0 0 0
cache buffers chains 34,556,615 0.0 0.0 0 87,794 0.0
cache buffers lru chain 31,977 0.0 0.0 0 202,609 0.0
cache table scan latch 6 0.0 0 6 0.0
call allocation 101,579 0.0 0.6 0 0
cas latch 1 0.0 0 0
change notification clie 1 0.0 0 0
channel handle pool latc 12,427 0.0 0 0
channel operations paren 262,046 0.7 0.0 0 5 0.0
checkpoint queue latch 256,602 0.0 0.0 0 10,544 0.0
client/application info 190,762 0.0 0.0 0 0
compile environment latc 25,898 0.0 0 0
corrupted undo seg latch 14 0.0 0 0
cp handoff latch 1 0.0 0 0
cp pool latch 1 0.0 0 0
cp server hash latch 1 0.0 0 0
Latch Activity DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

Pct Avg Wait Pct

Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
cp sga latch 161 0.0 0 0
cp srv type state latch 484 0.0 0 0
cp srv type wait latch 1 0.0 0 0
cvmap freelist lock 1 0.0 0 0
deferred cleanup latch 161 0.0 0 0
dispatcher info 868 0.0 0 0
dml lock allocation 161 0.0 0 0
done queue latch 1 0.0 0 0
dtp latch 5,415 0.0 0 0
dummy allocation 51,788 0.0 0.0 0 0
eighth spare latch - X p 1 0.0 0 0
eleventh spare latch - c 1 0.0 0 0
enqueue freelist latch 1 0.0 0 373,119 0.0
enqueue hash chains 772,575 0.0 0.0 0 9 0.0
enqueues 1 0.0 0 0
error message lists 94,368 0.0 0.0 0 0
event stats latch 25,891 0.0 0 0
fifteenth spare latch - 1 0.0 0 0
file cache latch 218 0.0 0 0
first Audit Vault latch 601 0.0 0 0
flash file access latch 1 0.0 0 0
flashback copy 1 0.0 0 0
fourteenth spare latch - 1 0.0 0 0
fourth Audit Vault latch 1 0.0 0 0
gc element 309,400 0.0 0.0 0 4,234 0.0
gcs commit scn state 1 0.0 0 0
gcs opaque info freelist 7,665 0.0 0 0
gcs partitioned table ha 5,085,253 0.0 0 1,718 0.0
gcs pcm hashed value buc 1 0.0 0 0
gcs remaster request que 234 0.0 0 0
gcs resource freelist 1,900 0.0 0 0
gcs resource hash 223,235 0.0 0.0 0 0
gcs resource scan list 1 0.0 0 0
gcs resource validate li 1 0.0 0 0
gcs shadows freelist 3,235 0.0 0 0
ges DFS wait callback in 2 0.0 0 0
ges cached resource list 5,102,696 0.0 0.0 0 164,974 0.0
ges deadlock list 2,196 0.0 0 0
ges domain table 19,920,523 0.0 0.0 0 0
ges enqueue table freeli 19,975,693 0.0 0.0 0 0
ges group table 20,073,991 0.0 0.0 0 0
ges process hash list 46,724 0.0 0 0
ges process parent latch 40,216,415 0.0 0.0 0 0
ges process table freeli 10,837 0.0 0 0
ges resource hash list 30,179,874 0.0 0.3 0 307 3.3
ges resource scan list 321 0.0 0 0
ges resource table freel 145,769 0.0 0 0
ges timeout list 41,323 0.0 0 156 0.0
ges value block free lis 7,382 0.0 0 0
global KZLD latch for au 3,428 0.0 0 0
Latch Activity DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

Pct Avg Wait Pct

Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
global tx hash mapping 1 0.0 0 0
granule from data transf 1 0.0 0 0
granule operation 1 0.0 0 0
hash table Sql Plan Find 299 0.0 0 362,634 0.0
hash table column usage 335 0.0 0 86,389,883 0.0
hash table modification 103 0.0 0 0
heartbeat check 1 0.0 0 1,260 0.0
heartbeat structure mana 0 0 1,799 0.0
imc buf hdl lat 1 0.0 0 0
imc hash lat 1 0.0 0 0
imc sj lat 1 0.0 0 0
imc srchsp lat 1 0.0 0 0
imc-txn-wrk-lat 1 0.0 0 0
in-memory area latch 1 0.0 0 0
in-memory columnar segme 1 0.0 0 0
in-memory columnar ts ex 1 0.0 0 0
in-memory global pool la 1 0.0 0 0
interrupt manipulation 141,589 0.0 0.0 0 0
intra txn parallel recov 1 0.0 0 0
io pool granule list 49 0.0 0 0
io pool granule metadata 102 0.0 0 0
job workq parent latch 33 0.0 0 32 0.0
job_queue_processes free 74 0.0 0 0
job_queue_processes para 10 0.0 0 0
k2q global data latch 2,400 0.0 0 0
k2q lock allocation 1 0.0 0 0
kcb DW scan objtemp hash 1 0.0 0 0
kcbtsemkid latch 60 0.0 0 0
kcn buffer chains 1 0.0 0 0
kdlx hb parent latch 1 0.0 0 0
kgb parent 1 0.0 0 0
kgnfs mount latch 1 0.0 0 0
kjci objects freelist la 1 0.0 0 0
kjci process context lat 1 0.0 0 6,103 0.0
kjoedcso state object fr 161 0.0 0 0
kjoeq omni enqueue hash 1 0.0 0 0
kjoer owner hash bucket 1 0.0 0 0
krbmrosl 1,046 0.0 0 0
krso process latch 120 0.0 0 0
ksfv messages 1 0.0 0 0
ksi resource reuse count 1 0.0 0 0
ksim group membership ca 208,163 0.0 0.0 0 0
ksim membership request 0 0 3,186 0.0
kss move lock 327 0.0 0 0
ksuosstats global area 1,570 0.0 0 0
ksv allocation latch 813 0.0 0 0
ksv class latch 35,525 0.0 0.4 0 0
ksv instance latch 980 0.0 0 0
ksv msg queue latch 1,644 0.0 0 1,643 0.0
ksxp shared latch 10,838 0.0 0 0
Latch Activity DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

Pct Avg Wait Pct

Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
ksxp so latch 10,838 0.0 0 0
ksz_so allocation latch 10,837 0.0 0 0
ktfbn latch 769 0.0 0 0
ktm global data 4,823 0.0 0 0
ktm prv jrnls 1 0.0 0 0
ktmpj HT ls 1 0.0 0 0
kwqbsn:qsga 130 0.0 0 0
kwslbmdl: metadata latch 2,880 0.0 0 0
kwslbql: queue latch 1 0.0 0 0
kwsptQcachLt: queue cach 1 0.0 0 0
kwsptTrncTsksLt: trunc t 1 0.0 0 0
kwsptjobAdPtLt: AdPt lis 259 0.0 0 0
kxfxscanrate_latch 1 0.0 0 0
lgwr LWN SCN 7,295 0.0 0 0
list of block allocation 7,524 0.0 0 0
loader state object free 288 0.0 0 0
lob segment dispenser la 1 0.0 0 0
lob segment hash table l 85 0.0 0 0
lob segment query latch 1 0.0 0 0
lock DBA buffer during m 1 0.0 0 0
log write info 0 0 6,737 0.1
log write slave phase 1 0.0 0 0
logical standby cache 1 0.0 0 0
logminer context allocat 1 0.0 0 0
logminer local 1 0.0 0 0
logminer work area 1 0.0 0 0
longop free list parent 8 0.0 0 7 0.0
managed standby latch 156 0.0 0 0
mapped buffers lru chain 1 0.0 0 0
message bitmap latch 1 0.0 0 0
message pool operations 65,827 0.0 0 0
messages 444,222 0.1 0.0 0 0
msg queue latch 1 0.0 0 0
multiblock read objects 1,616 0.0 0 0
name-service memory obje 23,574 0.0 0 0
name-service namespace b 231,119 0.0 0.0 0 0
name-service pending que 20,400 0.0 0 0
name-service request 12 0.0 0 0
name-service request que 47,459 0.0 0 0
ncodef allocation latch 161 0.0 0 0
ninth spare latch - X pa 1 0.0 0 0
object queue header free 170,676 0.0 0.0 0 0
object queue header oper 225,810 0.0 0.0 0 31,599 0.0
object queue memory 1 0.0 0 0
object stats modificatio 114,881 0.0 0 0
parallel query alloc buf 311,395 0.0 0 763 0.0
parallel query stats 77,072 0.0 0.0 0 0
parallel txn reco latch 460 0.0 0 0
parameter table manageme 473,436 0.0 0.2 0 0
peshm 1 0.0 0 0
Latch Activity DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

Pct Avg Wait Pct

Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
pesom_free_list 1 0.0 0 0
pesom_hash_node 1 0.0 0 0
pkey global statistics 67 0.0 0 0
post/wait queue 174,018 0.0 0.0 0 175,759 0.1
process allocation 11,051 0.0 0 5,423 0.0
process group creation 10,838 0.0 0 0
process pkey statistics 1,087 0.0 0 0
process queue 136,832 0.0 0 0
process queue reference 3,647,911 0.0 0.0 0 329,141 0.1
qmn task queue latch 1,241 0.0 0 0
query server freelists 173,011 0.0 0 0
query server process 23,188 0.0 0.0 0 2 0.0
queued dump request 12 0.0 0 0
queuing load statistics 1 0.0 0 0
recovery domain hash lis 1 0.0 0 0
redo allocation 137,448 0.0 0.1 0 0
redo copy 1 0.0 0 109,124 0.1
redo transport task latc 339 0.0 0 0
redo writing 35,047 0.1 0.0 0 0
reservation so alloc lat 124 0.0 0 0
resmgr group change latc 26,462 0.0 0 0
resmgr:active threads 52,726 0.0 0 1,248 0.0
resmgr:actses change gro 26,339 0.0 0 0
resmgr:actses change sta 178 0.0 0 0
resmgr:free threads list 52,116 0.0 0.0 0 0
resmgr:plan CPU method 1 0.0 0 0
resmgr:resource group CP 37,829 0.0 0.0 0 0
resmgr:schema config 18,171 0.0 0 48 0.0
resmgr:session queuing 1 0.0 0 0
resumable state object 11 0.0 0 0
rm cas latch 1 0.0 0 0
row cache objects 77,309,302 0.0 0.0 0 44 0.0
rules engine rule set st 100 0.0 0 0
second Audit Vault latch 1 0.0 0 0
segmented array pool 1,492 0.0 0 0
sequence cache 12,287 0.0 0 0
session allocation 122,139 0.0 0 70,681 0.0
session idle bit 1,521,841 0.0 0 0
session queue latch 1 0.0 0 0
session state list latch 45,526 0.0 0.0 0 0
session statistics 52,586 0.0 0.0 0 0
session switching 5,577 0.0 0 0
session timer 1,308 0.0 0 0
seventh spare latch - X 1 0.0 0 0
sga hash table parent la 1 0.0 0 0
shard latch 1 0.0 0 0
shared pool 19,763,124 0.0 0.1 0 11 0.0
shared pool sim alloc 1 0.0 0 0
shared pool simulator 102,672 0.0 0 0
sim partition latch 1 0.0 0 0
Latch Activity DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0

Pct Avg Wait Pct

Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
simulator hash latch 1,031,802 0.0 0 0
simulator lru latch 1 0.0 0 1,031,717 0.0
sixth spare latch - X pa 1 0.0 0 0
sort extent pool 2,722 0.0 0.0 0 0
space background task la 5,134 5.6 0.1 0 2,400 0.0
subscriber Ht bkt 1 0.0 0 0
tablespace key chain 1 0.0 0 0
temp lob duration state 430 0.0 0 0
tenth spare latch - X pa 1 0.0 0 0
test excl. parent l0 1 0.0 0 0
test excl. parent2 l0 1 0.0 0 0
test excl. parent2 lmid 1 0.0 0 0
test shared parent2 lmid 1 0.0 0 0
thirteenth spare latch - 1 0.0 0 0
threshold alerts latch 165 0.0 0 0
transaction allocation 325,342 0.0 1.0 0 0
transaction branch alloc 1,308 0.0 0 0
twelfth spare latch - ch 1 0.0 0 0
twenty-fifth spare latch 1 0.0 0 0
twenty-first spare latch 1 0.0 0 0
twenty-fourth spare latc 1 0.0 0 0
twenty-second spare latc 1 0.0 0 0
twenty-third spare latch 1 0.0 0 0
undo global data 30,359 0.0 0 0
virtual circuit buffers 1 0.0 0 0
virtual circuit holder 1 0.0 0 0
virtual circuit queues 1 0.0 0 0
-------------------------------------------------------------
Latch Sleep breakdown DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> ordered by misses desc

Get Spin
Latch Name Requests Misses Sleeps Gets
-------------------------- --------------- ------------ ----------- -----------
row cache objects 77,309,302 19,178 21 19,160
ges resource hash list 30,179,874 6,739 2,281 4,458
shared pool 19,763,124 3,143 190 2,957
channel operations parent 262,046 1,711 2 1,709
space background task latc 5,134 290 34 256
parameter table management 473,436 82 13 69
gcs resource hash 223,235 50 1 49
call allocation 101,579 50 31 19
redo allocation 137,448 16 1 15
ksv class latch 35,525 14 6 8
transaction allocation 325,342 1 1 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
active service list kswslogon: session logout 0 3 0
call allocation ksuxds 0 30 17
call allocation ksudlp: top call 0 1 117
channel operations paren ksrpubwait():1 0 2 3
channel operations paren ksrsconsume() 0 1 0
gcs resource hash kjbopen 0 1 0
ges resource hash list kjucvl: lock convert reque 0 2,102 28
ges resource hash list kjlrlr: remove lock from r 0 148 2,105
ges resource hash list kjrmas1: lookup master nod 0 27 0
ges resource hash list kjakcai: search for resp b 0 2 147
ges resource hash list kjlmfnd: search for lockp 0 2 1
ksv class latch ksvclsl: run 0 4 0
ksv class latch ksvclsl: create 0 2 0
parameter table manageme kspcpy 0 11 0
parameter table manageme ksp_param_table_free 0 10 0
redo allocation kcrfw_redo_gen: redo alloc 0 1 1
row cache objects kqrpre: find obj 0 11 17
row cache objects kqreqd: reget 0 7 2
row cache objects kqreqd 0 2 2
shared pool kghalo 0 143 47
shared pool kghalp 0 42 5
shared pool kgh_heap_sizes 0 3 0
shared pool kghfre 0 1 26
shared pool kghfrunp: clatch: nowait 0 1 0
shared pool kghupr1 0 1 112
space background task la ktsj_grab_task 0 33 34
space background task la ktsj_detach_task 0 1 0
transaction allocation ktcxbr 0 1 1
-------------------------------------------------------------
Mutex Sleep DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> ordered by Wait Time desc

Wait
Mutex Type Location Sleeps Time (s)
------------------ -------------------------------- -------------- ------------
Cursor Pin kkslce [KKSCHLPIN2] 22,014 24.2
Library Cache kglhdgn2 106 29 0.1
Library Cache kgllkc1 57 20 0.1
Library Cache kgllkdl1 85 7 0.0
Cursor Pin kksfbc [KKSCHLCREA] 4 0.0
Library Cache kglpnal2 91 6 0.0
Cursor Pin kksfbc [KKSCHLPIN1] 1 0.0
Library Cache kglget1 1 6 0.0
Library Cache kglhdgn1 62 2 0.0
Library Cache kglpin1 4 1 0.0
Library Cache kglpnal1 90 1 0.0
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Segment Logical Reads Threshold: 10000
-> Pct Total shows % of logical reads for each top segment compared with total
logical reads for all segments captured by the Snapshot

Subobject Obj. Logical Pct

Owner Tablespace Object Name Name Type Reads Total
---------- ---------- -------------------- ------------ ----- ------------ -----
X3PRD X3PRD_DAT BPADDRESS TABLE 5,980,176 33.2
X3PRD X3PRD_DAT GACCDUDATE TABLE 4,425,360 24.5
X3PRD X3PRD_DAT BPCUSTOMER TABLE 1,322,640 7.3
SYS SYSTEM CDEF$ TABLE 681,280 3.8
X3PRD X3PRD_DAT GACCENTRYD TABLE 660,512 3.7
-------------------------------------------------------------

Segments by Physical Reads DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> End Segment Physical Reads Threshold: 1000

Subobject Obj. Physical Pct

Owner Tablespace Object Name Name Type Reads Total
---------- ---------- -------------------- ------------ ----- ------------ -----
SYS SYSAUX WRH$_SEG_STAT_OBJ TABLE 23 25.8
PERFSTAT PERFSTAT STATS$SQLTEXT_PK INDEX 12 13.5
X3PRD X3PRD_IDX GACCDUDATE_DUD0 INDEX 11 12.4
PERFSTAT PERFSTAT STATS$SQL_PLAN_USAGE INDEX 10 11.2
PERFSTAT PERFSTAT STATS$SQL_PLAN_PK INDEX 7 7.9
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> End Segment Row Lock Waits Threshold: 100

Row
Subobject Obj. Lock Pct
Owner Tablespace Object Name Name Type Waits Total
---------- ---------- -------------------- ------------ ----- ------------ -----
AUDSYS SYSAUX CLI_TIME$ffedbdf1$1$ INDEX 1 50.0
PERFSTAT PERFSTAT STATS$LATCH_PK INDEX 1 50.0
-------------------------------------------------------------
Segments by Global Cache Buffer Busy Waits DB/Inst: PRDX3/PRDX31 Snaps: 2677-2
-> There is no specific Threshold for Segment GC Buffer Busy Waits

GC Buffer
Subobject Obj. Busy Pct
Owner Tablespace Object Name Name Type Waits Total
---------- ---------- -------------------- ------------ ----- ------------ -----
X3PRD X3PRD_DAT ATEXTRA TABLE 3 60.0
X3PRD X3PRD_DAT AUTILIS TABLE 2 40.0
-------------------------------------------------------------

Segments by CR Blocks Received DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> End Global Cache CR Blocks Received Threshold: 1000

CR
Subobject Obj. Blocks Pct
Owner Tablespace Object Name Name Type Recevd Total
---------- ---------- -------------------- ------------ ----- ------------ -----
SYS SYSTEM USER$ TABLE 1,598 26.2
X3PRD X3PRD_DAT AUTILIS TABLE 800 13.1
X3PRD X3PRD_DAT YCALLLIST TABLE 630 10.3
X3PRD X3PRD_IDX YCALLLIST_YCA0 INDEX 328 5.4
SYS SYSAUX I_OPT_FINDING_F_ID INDEX 302 4.9
-------------------------------------------------------------

Segments By Current Blocks Received DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> End Global Cache CU Blocks Received Threshold: 1000

CU
Subobject Obj. Blocks Pct
Owner Tablespace Object Name Name Type Recevd Total
---------- ---------- -------------------- ------------ ----- ------------ -----
SYS SYSTEM CDEF$ TABLE 2,577 30.7
SYS SYSTEM USER$ TABLE 791 9.4
PERFSTAT PERFSTAT STATS$SQL_PLAN_USAGE INDEX 685 8.2
PERFSTAT PERFSTAT STATS$LATCH_PK INDEX 509 6.1
X3PRD X3PRD_DAT ATEXTRA TABLE 473 5.6
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
->"Pct Misses" should be very low (< 2% in most cases)
->"Final Usage" is the number of cache entries being used in End Snapshot

Get Pct Scan Pct Mod Final

Cache Requests Miss Reqs Miss Reqs Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_awr_control 66 0.0 0 2 1
dc_files 75 0.0 0 0 15
dc_global_oids 768 0.0 0 0 41
dc_histogram_data 3,884,992 0.0 0 0 3,587
dc_histogram_defs 5,374,834 0.0 0 0 8,441
dc_object_grants 33 3.0 0 0 11
dc_objects 2,253,176 11.5 0 196 2,759
dc_profiles 6,991 0.0 0 0 1
dc_props 22,034 0.0 0 0 60
dc_rollback_segments 1,188 0.0 0 0 22
dc_segments 1,289,808 0.0 0 0 2,199
dc_sequences 46 26.1 0 46 6
dc_table_scns 2 100.0 0 0 0
dc_tablespace_quotas 4 25.0 0 0 3
dc_tablespaces 7,266,420 0.0 0 0 17
dc_users 8,214,600 0.0 20,852 0.0 0 214
outstanding_alerts 4 100.0 0 0 1
sch_lj_oids 67 0.0 0 0 20
-------------------------------------------------------------

GES GES GES

Cache Requests Conflicts Releases
------------------------- ------------ ------------ ------------
dc_awr_control 4 0 0
dc_histogram_defs 742 0 153
dc_objects 513 38 3
dc_segments 32 0 5
dc_sequences 82 3 1
dc_table_scns 2 0 0
dc_tablespace_quotas 3 1 0
dc_users 16 0 0
outstanding_alerts 8 3 0
-------------------------------------------------------------

Library Cache Activity DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

->"Pct Misses" should be very low

Get Pct Pin Pct Invali-

Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
ACCOUNT_STATUS 13,980 0.0 0 0 0
AUDIT POLICY 10,426 0.0 10,426 0.0 0 0
BODY 9,292 0.0 83,693 0.0 1 0
CLUSTER 90 0.0 91 0.0 0 0
DBLINK 19,133 0.0 0 0 0
DIRECTORY 242 0.0 364 33.2 121 0
EDITION 6,124 0.0 12,248 0.0 0 0
INDEX 2 0.0 2 100.0 2 0
OBJECT ID 8 100.0 0 0 0
QUEUE 720 0.0 834 0.0 0 0
SCHEMA 3,641 0.1 0 0 0
SQL AREA 133,836 34.1 1,606,048 5.0 4,834 59
SQL AREA BUILD 27,692 99.4 0 0 0
SQL AREA STATS 27,678 97.5 27,678 97.5 0 0
TABLE/PROCEDURE 145,989 0.0 676,808 0.1 357 9
TRANSFORMATION 360 0.0 360 0.0 0 0
TRIGGER 1,458 0.8 13,017 0.2 9 0
-------------------------------------------------------------

GES Lock GES Pin GES Pin GES Inval GES Invali-
Namespace Requests Requests Releases Requests dations
--------------- ------------ ------------ ------------ ----------- -----------
ACCOUNT_STATUS 13,980 0 0 0 0
AUDIT POLICY 10,426 10,426 10,426 0 0
BODY 2 83,664 83,664 0 0
CLUSTER 91 91 91 0 0
DBLINK 19,133 0 0 0 0
DIRECTORY 122 362 362 0 0
EDITION 6,124 6,124 6,124 0 0
INDEX 2 2 2 0 0
OBJECT ID 0 0 0 0 0
QUEUE 360 834 834 0 0
SCHEMA 3,508 0 0 0 0
SQL AREA 0 0 0 0 0
SQL AREA BUILD 0 0 0 0 0
SQL AREA STATS 0 0 0 0 0
TABLE/PROCEDURE 171,943 264,007 264,007 1 1
TRANSFORMATION 360 360 360 0 0
TRIGGER 0 13,017 13,017 0 0
-------------------------------------------------------------
Global Enqueue Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total per Second per Trans

--------------------------------- ---------------- ------------ ------------
KA local message waits 0 0.0 0.0
KA local messages received 0 0.0 0.0
KA messages received actual 0 0.0 0.0
KA messages received logical 0 0.0 0.0
KA requests failed 0 0.0 0.0
KA requests succeeded 0 0.0 0.0
acks for commit broadcast(actual) 5,208 1.4 1.8
acks for commit broadcast(logical 5,338 1.5 1.8
broadcast msgs on commit(actual) 6,543 1.8 2.3
broadcast msgs on commit(logical) 6,618 1.8 2.3
broadcast msgs on commit(wasted) 137 0.0 0.0
dynamically allocated gcs resourc 0 0.0 0.0
dynamically allocated gcs shadows 0 0.0 0.0
flow control messages received 3 0.0 0.0
flow control messages sent 15 0.0 0.0
gcs apply delta 0 0.0 0.0
gcs assume cvt 0 0.0 0.0
gcs assume no cvt 1,991 0.6 0.7
gcs ast xid 0 0.0 0.0
gcs blocked converts 4,604 1.3 1.6
gcs blocked cr converts 2,889 0.8 1.0
gcs compatible basts 35 0.0 0.0
gcs compatible cr basts (global) 403 0.1 0.1
gcs compatible cr basts (local) 360 0.1 0.1
gcs cr basts to PIs 0 0.0 0.0
gcs cr serve without current lock 0 0.0 0.0
gcs dbwr flush pi msgs 2,826 0.8 1.0
gcs dbwr write request msgs 1,422 0.4 0.5
gcs delta msgs sent 0 0.0 0.0
gcs delta push aborted by cancel 0 0.0 0.0
gcs delta push aborted by remaste 0 0.0 0.0
gcs delta push cancelled 0 0.0 0.0
gcs delta push cancelled at maste 0 0.0 0.0
gcs delta push cancelled by close 0 0.0 0.0
gcs delta push cancelled by consi 0 0.0 0.0
gcs delta push cancelled by cvt p 0 0.0 0.0
gcs delta push cancelled by dwncv 0 0.0 0.0
gcs delta push create pi 0 0.0 0.0
gcs delta update master msgs sent 0 0.0 0.0
gcs delta wait aborted by remaste 0 0.0 0.0
gcs delta wait cancelled 0 0.0 0.0
gcs error msgs 0 0.0 0.0
gcs force cr block only 10 0.0 0.0
gcs force cr grant 2 0.0 0.0
gcs force cr no current 0 0.0 0.0
gcs forward cr to pinged instance 0 0.0 0.0
gcs immediate (compatible) conver 153 0.0 0.1
gcs immediate (null) converts 817 0.2 0.3
gcs immediate cr (compatible) con 741 0.2 0.3
gcs immediate cr (null) converts 96 0.0 0.0
gcs indirect ast 501 0.1 0.2
gcs indirect bidless ast 164 0.0 0.1
gcs indirect fg ast 337 0.1 0.1
gcs lms flush pi msgs 0 0.0 0.0
gcs lms write request msgs 182 0.1 0.1
gcs msgs process time(ms) 2,245 0.6 0.8
Global Enqueue Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total per Second per Trans

--------------------------------- ---------------- ------------ ------------
gcs msgs received 98,085 27.2 33.9
gcs new served by master 504 0.1 0.2
gcs out-of-order msgs 21 0.0 0.0
gcs pings refused 1,449 0.4 0.5
gcs pkey conflicts retry 0 0.0 0.0
gcs push delta 0 0.0 0.0
gcs queued converts 0 0.0 0.0
gcs reader bypass N->Xw ping loca 0 0.0 0.0
gcs reader bypass N->Xw ping remo 0 0.0 0.0
gcs reader bypass grant X on assu 0 0.0 0.0
gcs reader bypass grant ast 0 0.0 0.0
gcs reader bypass grant fg ast 0 0.0 0.0
gcs reader bypass grant immediate 307 0.1 0.1
gcs recovery claim msgs 0 0.0 0.0
gcs refuse xid 0 0.0 0.0
gcs regular cr 0 0.0 0.0
gcs retry convert request 2 0.0 0.0
gcs share recovery bast 0 0.0 0.0
gcs side channel msgs actual 1,842 0.5 0.6
gcs side channel msgs logical 22,910 6.4 7.9
gcs stale cr 85,062 23.6 29.4
gcs undo cr 0 0.0 0.0
gcs write notification msgs 123 0.0 0.0
gcs writes refused 29 0.0 0.0
ges msgs process time(ms) 1,193 0.3 0.4
ges msgs received 105,157 29.2 36.3
global posts dropped 0 0.0 0.0
global posts queue time 0 0.0 0.0
global posts queued 0 0.0 0.0
global posts requested 0 0.0 0.0
global posts sent 0 0.0 0.0
implicit batch messages received 1,296 0.4 0.4
implicit batch messages sent 4,575 1.3 1.6
lmd msg send time(ms) 0 0.0 0.0
lms(s) msg send time(ms) 0 0.0 0.0
messages flow controlled 6,769 1.9 2.3
messages queue sent actual 75,217 20.9 26.0
messages queue sent logical 10,252 2.8 3.5
messages received actual 199,599 55.4 68.9
messages received logical 203,242 56.5 70.2
messages sent directly 114,398 31.8 39.5
messages sent indirectly 37,125 10.3 12.8
messages sent not implicit batche 1 0.0 0.0
messages sent pbatched 73,757 20.5 25.5
msgs causing lmd to send msgs 0 0.0 0.0
msgs causing lms(s) to send msgs 0 0.0 0.0
msgs received queue time (ms) 1,487 0.4 0.5
msgs received queued 203,242 56.5 70.2
msgs sent queue time (ms) 12,698 3.5 4.4
msgs sent queue time on ksxp (ms) 129,079 35.9 44.6
msgs sent queued 80,832 22.5 27.9
msgs sent queued on ksxp 195,890 54.4 67.6
number of broadcasted resources 0 0.0 0.0
number of directly freed master r 72,478 20.1 25.0
number of ges deadlock detected 0 0.0 0.0
number of lock borrowed by LMD 0 0.0 0.0
Global Enqueue Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total per Second per Trans

--------------------------------- ---------------- ------------ ------------
number of received ODPS messages 0 0.0 0.0
number of resource borrowed by LM 0 0.0 0.0
number of sent ODPS messages 0 0.0 0.0
process batch messages received 67,997 18.9 23.5
process batch messages sent 72,994 20.3 25.2
-------------------------------------------------------------
Global CR Served Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Statistic Total
------------------------------ ------------------
CR Block Requests 4,156
CURRENT Block Requests 43,157
Data Block Requests 4,156
Undo Block Requests 0
TX Block Requests 11
Current Results 4,242
Private results 0
Zero Results 6
Disk Read Results 43,065
Fail Results 0
Fairness Down Converts 2,642
Fairness Clears 95
Free GC Elements 0
Flushes 10
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 5
Errors 0
-------------------------------------------------------------

Global CURRENT Served Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Pins = CURRENT Block Pin Operations
-> Flushes = Redo Flush before CURRENT Block Served Operations
-> Writes = CURRENT Block Fusion Write Operations

Statistic Total % <1ms % <10ms % <100ms % <1s % <10s

----------- ----------- -------- -------- -------- -------- --------
Pin 0 0.00
0.00 0.00
0.00 0.00
Flu 9 100.00
0.00 0.00
0.00 0.00
Wri 1,317 26.73
72.51 0.68
0.00 0.08
-------------------------------------------------------------

Global Cache Transfer Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
Busy (Busy) - Block Transfer impacted by Remote Contention
Congested (Congst) - Block Transfer impacted by Remote System Load
-> ordered by CR + Current Blocks Received desc

-------------- CR ------------- ----------- Current -----------

Inst Block Blocks % % % Blocks % % %
No Class Received Immed Busy Congst Received Immed Busy Congst
---- -------- ----------- ------ ------ ------ ----------- ------ ------ ------
2 data blo 3,761 98.9 1.1 .0 3,273 99.8 .2 .0
2 others 65 100.0 .0 .0 228 100.0 .0 .0
2 undo hea 230 100.0 .0 .0 29 100.0 .0 .0
2 undo blo 2 50.0 50.0 .0 0
-------------------------------------------------------------
Interconnect Ping Stats DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> Latency of roundtrip of a message from this instance to other instances.
-> Average and standard deviation are in miliseconds
-> The latency of messages from the instance to itself is used as
control, since message latency can include wait for CPU

---------- 500 bytes --------------- ------------- 8 Kbytes --------------

Target Avg Std Avg
Inst CNT500B WAIT500B Time(ms) Dev CNT8K WAIT8K Time(ms)
------ ---------- ---------- -------- ------ ---------- ---------- --------
Std
Dev
------
1 286 .048452 .2 .0 286 .04518 .2
.0
2 286 .088893 .3 .1 286 .123188 .4
.1
-------------------------------------------------------------
Rule Sets DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678
-> * indicates Rule Set activity (re)started between Begin/End snaps
-> Top 25 ordered by Evaluations desc

No-SQL SQL
Rule * Eval/sec Reloads/sec Eval % Eval %
----------------------------------- - ------------ ----------- ------ ------
SYS.ALERT_QUE_R 0 0 0 0
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: PRDX3/PRDX31 End Snap: 2678
-> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
-> Note there is often a 1:Many correlation between a single logical object
in the Library Cache, and the physical number of memory objects associated
with it. Therefore comparing the number of Lib Cache objects (e.g. in
v$librarycache), with the number of Lib Cache Memory Objects is invalid

Est LC Est LC Est LC Est LC

Shared SP Est LC Time Time Load Load Est LC
Pool Size Size Est LC Saved Saved Time Time Mem
Size (M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
2,416 .5 332 11,866 ####### .4 ####### 27.1 ###########
2,912 .6 828 23,429 ####### .5 ####### 23.4 ###########
3,408 .7 1,324 35,368 ####### .7 ####### 12.2 ###########
3,904 .8 1,820 45,805 ####### .8 ####### 8.4 ###########
4,400 .9 2,316 55,976 ####### .9 ####### 4.7 ###########
4,736 1.0 2,650 62,562 ####### 1.0 ####### 2.2 ###########
4,752 1.0 2,665 62,860 ####### 1.0 ####### 2.1 ###########
4,768 1.0 2,681 63,178 ####### 1.0 ####### 2.0 ###########
4,784 1.0 2,697 63,496 ####### 1.0 ####### 1.9 ###########
4,800 1.0 2,713 63,798 ####### 1.0 ####### 1.8 ###########
4,816 1.0 2,729 64,096 ####### 1.0 ####### 1.7 ###########
4,832 1.0 2,745 64,445 ####### 1.0 ####### 1.5 ###########
4,848 1.0 2,761 64,769 ####### 1.0 ####### 1.4 ###########
4,864 1.0 2,777 65,044 ####### 1.0 ####### 1.3 ###########
4,880 1.0 2,793 65,339 ####### 1.0 ####### 1.2 ###########
4,896 1.0 2,809 65,752 ####### 1.0 ####### 1.0 ###########
4,912 1.0 2,825 66,037 ####### 1.0 ####### 1.0 ###########
4,928 1.0 2,841 66,345 ####### 1.0 ####### 1.0 ###########
4,944 1.0 2,857 66,647 ####### 1.0 ####### 1.0 ###########
4,960 1.0 2,873 66,935 ####### 1.0 ####### 1.0 ###########
4,976 1.0 2,888 67,227 ####### 1.0 ####### 1.0 ###########
4,992 1.0 2,904 67,547 ####### 1.0 ####### 1.0 ###########
5,008 1.0 2,920 67,865 ####### 1.0 ####### 1.0 ###########
5,024 1.0 2,935 68,183 ####### 1.0 ####### 1.0 ###########
5,040 1.0 2,951 68,493 ####### 1.0 ####### 1.0 ###########
5,392 1.1 3,303 75,393 ####### 1.0 ####### 1.0 ###########
5,888 1.2 3,799 85,223 ####### 1.0 ####### .9 ###########
6,384 1.3 4,295 94,374 ####### 1.0 ####### .9 ###########
6,880 1.4 4,791 103,061 ####### 1.0 ####### .9 ###########
7,376 1.5 5,287 111,127 ####### 1.0 ####### .8 ###########
7,872 1.6 5,783 119,082 ####### 1.0 ####### .8 ###########
8,368 1.7 6,279 129,431 ####### 1.0 ####### .8 ###########
8,864 1.8 6,775 139,652 ####### 1.0 ####### .7 ###########
9,360 1.9 7,271 149,176 ####### 1.0 ####### .7 ###########
9,856 2.0 7,766 158,779 ####### 1.0 ####### .7 ###########
-------------------------------------------------------------
SGA Target Advisory DB/Inst: PRDX3/PRDX31 End Snap: 2678

SGA Target SGA Size Est DB Est DB Est Physical

Size (M) Factor Time (s) Time Factor Reads
---------- -------- -------- ----------- --------------
1,024 .1 0 .0 23,814,050
2,048 .3 0 .0 23,814,050
3,072 .4 0 .0 23,814,050
4,096 .5 ######## 12.9 478,228,989
5,120 .6 ######## 5.2 478,228,989
6,144 .8 985,142 1.4 478,228,989
7,168 .9 709,077 1.0 23,814,050
8,192 1.0 688,959 1.0 23,814,050
9,216 1.1 670,908 1.0 19,548,954
10,240 1.3 650,102 .9 19,548,954
11,264 1.4 629,088 .9 19,548,954
12,288 1.5 607,800 .9 19,548,954
13,312 1.6 603,321 .9 12,228,515
14,336 1.8 602,495 .9 10,918,742
15,360 1.9 602,357 .9 10,690,127
16,384 2.0 602,357 .9 10,690,127
-------------------------------------------------------------
SGA Memory Summary DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

End Size (Bytes)

SGA regions Begin Size (Bytes) (if different)
------------------------------ -------------------- --------------------
Database Buffers 2,717,908,992
Fixed Size 7,663,544
Redo Buffers 9,113,600
Variable Size 5,855,248,456
-------------------- --------------------
sum 8,589,934,592
-------------------------------------------------------------

SGA breakdown difference DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

-> Top 35 rows by size, ordered by Pool, Name (note rows with null values for
Pool column, or Names showing free memory are always shown)
-> Null value for Begin MB or End MB indicates the size of that Pool/Name was
insignificant, or zero in that snapshot

Pool Name Begin MB End MB % Diff

------ ------------------------------ -------------- -------------- --------
java p free memory 112.0 112.0 0.00
large PX msg pool 524.8 524.8 0.00
large free memory 50.8 50.8 0.00
shared ASH buffers 56.0 56.0 0.00
shared KGLH0 1,030.5 1,020.5 -0.97
shared KGLHD 126.7 133.9 5.74
shared SQLA 2,097.8 2,017.1 -3.85
shared free memory 647.0 717.1 10.83
shared gcs resources 197.2 197.2 0.00
shared gcs shadows 109.6 109.6 0.00
shared ktli log buf s 86.1 86.1 0.00
shared object queue hash buckets 56.0 56.0 0.00
buffer_cache 2,192.0 2,192.0 0.00
fixed_sga 7.3 7.3 0.00
log_buffer 8.7 8.7 0.00
shared_io_pool 400.0 400.0 0.00
-------------------------------------------------------------
SQL Memory Statistics DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

Begin End % Diff

-------------- -------------- --------------
Avg Cursor Size (KB): 74.79 73.13 -2.27
Cursor to Parent ratio: 1.04 1.04 .46
Total Cursors: 35,703 34,978 -2.07
Total Parents: 34,396 33,544 -2.54
-------------------------------------------------------------
init.ora Parameters DB/Inst: PRDX3/PRDX31 Snaps: 2677-2678

End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
audit_file_dest /u01/app/oracle/admin/PRDX3/adump
audit_trail DB
cluster_database TRUE
compatible 12.1.0.2.0
control_files +DATA_DG/PRDX3/CONTROLFILE/curren
t.261.895240597, +RECO_DG/PRDX3/C
ONTROLFILE/current.256.895240597
db_block_size 8192
db_create_file_dest +DATA_DG
db_domain
db_name PRDX3
db_recovery_file_dest +RECO_DG
db_recovery_file_dest_size 53687091200
diagnostic_dest /u01/app/oracle
dispatchers (PROTOCOL=TCP) (SERVICE=PRDX3XDB)
instance_number 1
local_listener (ADDRESS=(PROTOCOL=TCP)(HOST=10.
30.0.119)(PORT=1521))
open_cursors 600
pga_aggregate_limit 8589934592
pga_aggregate_target 6442450944
processes 300
remote_listener oraprd-scan.baiada.com.au:1521,
oraprd-scan.baiada.com.au:1521, o
raprd-scan.baiada.com.au:1521
remote_login_passwordfile EXCLUSIVE
sec_case_sensitive_logon FALSE
sga_target 8589934592
thread 1
undo_tablespace UNDOTBS1
-------------------------------------------------------------

End of Report ( sp_07271130.txt )

SP 07272030
No ratings yet
SP 07272030
127 pages
SP 07271730
No ratings yet
SP 07271730
175 pages
SP 07271930
No ratings yet
SP 07271930
134 pages
Statpack 10 08
No ratings yet
Statpack 10 08
75 pages
SP 1830 1845
No ratings yet
SP 1830 1845
63 pages
Awr
0% (1)
Awr
161 pages
Report 06
No ratings yet
Report 06
82 pages
Awrrpt 1 66643 66644
No ratings yet
Awrrpt 1 66643 66644
228 pages
Picktime 06 01 2017
No ratings yet
Picktime 06 01 2017
85 pages
Awrrpt 07 To 11 04 2016
No ratings yet
Awrrpt 07 To 11 04 2016
41 pages
Database Performance Summary
No ratings yet
Database Performance Summary
241 pages
Awr 1930 1945
No ratings yet
Awr 1930 1945
82 pages
Awrrpt 1 19237 19243
No ratings yet
Awrrpt 1 19237 19243
69 pages
Awrrpt 1 1454 1457
No ratings yet
Awrrpt 1 1454 1457
74 pages
Awrrpt 1 475 482
No ratings yet
Awrrpt 1 475 482
90 pages
Awrrpt 1 87965 87969
No ratings yet
Awrrpt 1 87965 87969
328 pages
Database Performance Analysis
No ratings yet
Database Performance Analysis
233 pages
Awrrpt 2 87965 87971
No ratings yet
Awrrpt 2 87965 87971
336 pages
Awrrpt 1 87751 87755
No ratings yet
Awrrpt 1 87751 87755
287 pages
Awrrpt 1 7072 7078
No ratings yet
Awrrpt 1 7072 7078
117 pages
Awrrpt 2 87751 87757
No ratings yet
Awrrpt 2 87751 87757
289 pages
RC10PRD 10 11 Awr
No ratings yet
RC10PRD 10 11 Awr
52 pages
Optimize Oracle Buffer Busy Waits
No ratings yet
Optimize Oracle Buffer Busy Waits
9 pages
Sample of Tibero TPR Report (Oracle AWR Feature On Tibero Database)
No ratings yet
Sample of Tibero TPR Report (Oracle AWR Feature On Tibero Database)
126 pages
Ault - AWR 1
No ratings yet
Ault - AWR 1
24 pages
Workload Repository Comparison Report
No ratings yet
Workload Repository Comparison Report
135 pages
Free Oracle Performance Tools IOUG PDF
No ratings yet
Free Oracle Performance Tools IOUG PDF
101 pages
Case Study: The Mysterious Performance Drop: About Oracle Case Studies
No ratings yet
Case Study: The Mysterious Performance Drop: About Oracle Case Studies
9 pages
WORKLOAD FOR ICTPRDDB v2
No ratings yet
WORKLOAD FOR ICTPRDDB v2
103 pages
Interpret Statspack Report
No ratings yet
Interpret Statspack Report
9 pages
Workload For Ictprddb
No ratings yet
Workload For Ictprddb
98 pages
Workload For Mtvwork
No ratings yet
Workload For Mtvwork
30 pages
Workload For Infra
No ratings yet
Workload For Infra
32 pages
Performance Testing DB Performance
No ratings yet
Performance Testing DB Performance
19 pages
Finding Database Bottlenecks
No ratings yet
Finding Database Bottlenecks
4 pages
Awrrpt 1 21676 21699
No ratings yet
Awrrpt 1 21676 21699
314 pages
Oracle 10g CPU Usage Optimization
No ratings yet
Oracle 10g CPU Usage Optimization
3 pages
Chinar - Aliyev - Time Model-Eng
No ratings yet
Chinar - Aliyev - Time Model-Eng
13 pages
Oracle DB Performance Scripts
100% (1)
Oracle DB Performance Scripts
21 pages
Beginning Perf Tuning
0% (1)
Beginning Perf Tuning
28 pages
WORKLOAD FOR INFRA v2
No ratings yet
WORKLOAD FOR INFRA v2
30 pages
Logical IO Vs Physical IO Vs Consistent Gets
No ratings yet
Logical IO Vs Physical IO Vs Consistent Gets
11 pages
Awrrpt 1 21748 21771
No ratings yet
Awrrpt 1 21748 21771
314 pages
SQL Trace Analysis for DBAs
No ratings yet
SQL Trace Analysis for DBAs
29 pages
Statspack Report Analysis Guide
100% (1)
Statspack Report Analysis Guide
24 pages
Percona2016linuxsystemsperf 160421182216
No ratings yet
Percona2016linuxsystemsperf 160421182216
72 pages
Copenhagen Schema
100% (1)
Copenhagen Schema
56 pages
Awrrpt 1 21724 21747
No ratings yet
Awrrpt 1 21724 21747
349 pages
Sequences
No ratings yet
Sequences
5 pages
Oracle Performance Tuning Basics
No ratings yet
Oracle Performance Tuning Basics
32 pages
Oow 2012 BeginningPerformanceTuning ArupNanda
No ratings yet
Oow 2012 BeginningPerformanceTuning ArupNanda
29 pages
Oracle ASH and AWR Insights
100% (1)
Oracle ASH and AWR Insights
33 pages
Scale10x Performance 120806162249 Phpapp02
No ratings yet
Scale10x Performance 120806162249 Phpapp02
86 pages
Oracle AWR/ASH Analysis: June 18, 2016
No ratings yet
Oracle AWR/ASH Analysis: June 18, 2016
56 pages
01 - Lab - Creating A Single Instance
No ratings yet
01 - Lab - Creating A Single Instance
27 pages
BI Apps11g Perf Tech Note V1
No ratings yet
BI Apps11g Perf Tech Note V1
32 pages
02 Lab Oracle Compute Docker
No ratings yet
02 Lab Oracle Compute Docker
10 pages
10g Fixes
No ratings yet
10g Fixes
5 pages
MCD Level 1 - 3
No ratings yet
MCD Level 1 - 3
6 pages
2ceit402 Design and Analysis of Algorithms Ce It Ceai
No ratings yet
2ceit402 Design and Analysis of Algorithms Ce It Ceai
2 pages
KH341A.ty1.F01M.factory Manual - Washer Extractor.V100B0
No ratings yet
KH341A.ty1.F01M.factory Manual - Washer Extractor.V100B0
3 pages
Fluke 115: Multimeter
No ratings yet
Fluke 115: Multimeter
2 pages
Rajamohan PPT New
No ratings yet
Rajamohan PPT New
13 pages
Grade 11 Maths P1 Nov 2024 QP
No ratings yet
Grade 11 Maths P1 Nov 2024 QP
15 pages
Synthesis and Characterization of Silica Nanoparticles From Clay
No ratings yet
Synthesis and Characterization of Silica Nanoparticles From Clay
7 pages
Comp614 (Chap 4)
No ratings yet
Comp614 (Chap 4)
20 pages
Linguistic Analysis of Adjectives
No ratings yet
Linguistic Analysis of Adjectives
175 pages
DCF Valuation
No ratings yet
DCF Valuation
29 pages
Fishing Operations
100% (1)
Fishing Operations
81 pages
LUTEC AUSTRALIA PTY LTD Displays Prototypes That Amplifying Electricity by 5 Times
No ratings yet
LUTEC AUSTRALIA PTY LTD Displays Prototypes That Amplifying Electricity by 5 Times
1 page
Presentation of Parts of Speech
No ratings yet
Presentation of Parts of Speech
23 pages
Chasing The Dragon's Tail
92% (39)
Chasing The Dragon's Tail
494 pages
Lab 6 Access
No ratings yet
Lab 6 Access
13 pages
ML Unit 2
No ratings yet
ML Unit 2
71 pages
Singer A Phragmentary Tablet Bearing An Unknowwn Script, Aphek II, 2009
No ratings yet
Singer A Phragmentary Tablet Bearing An Unknowwn Script, Aphek II, 2009
13 pages
Assignment 2
No ratings yet
Assignment 2
3 pages
Rittal Fan-and-Filter Units Catalog
No ratings yet
Rittal Fan-and-Filter Units Catalog
8 pages
The Art of Assembly Language Programming Using PIC® Technology: Core Fundamentals. Theresa Schousek PDF Download
No ratings yet
The Art of Assembly Language Programming Using PIC® Technology: Core Fundamentals. Theresa Schousek PDF Download
138 pages
A T-Beam Reinforced With 4-32 MM Diameter Bars
No ratings yet
A T-Beam Reinforced With 4-32 MM Diameter Bars
6 pages
Improving Electrical System Reliability With Infrared Thermography
No ratings yet
Improving Electrical System Reliability With Infrared Thermography
12 pages
Using The Matrices Palette in S Math Studio
No ratings yet
Using The Matrices Palette in S Math Studio
7 pages
Signal Modulation Techniques
No ratings yet
Signal Modulation Techniques
2 pages
Unsteady Oldroyd-B Fluid Dynamics
No ratings yet
Unsteady Oldroyd-B Fluid Dynamics
10 pages
Practical Handbook of Remote Sensing, 2nd Edition Samantha Lavender PDF Download
No ratings yet
Practical Handbook of Remote Sensing, 2nd Edition Samantha Lavender PDF Download
76 pages
07 - LTE Physical Channels
No ratings yet
07 - LTE Physical Channels
199 pages
133R0228 HLP-SK180 Series English Operating Manual V2013-04
No ratings yet
133R0228 HLP-SK180 Series English Operating Manual V2013-04
147 pages
Syllabus CS330 SIUC
No ratings yet
Syllabus CS330 SIUC
6 pages
Concrete Beam Crack Prevention
No ratings yet
Concrete Beam Crack Prevention
3 pages