WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
UDAS2PDB4051413816udas2p1110.2.0.4.0YESfipd329

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2078707-Apr-11 11:00:4071 4.8
End Snap:2078907-Apr-11 13:00:07102 4.2
Elapsed:  119.45 (mins)  
DB Time:  948.09 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 2,208M 2,304MStd Block Size: 8K
Shared Pool Size: 1,904M 1,808MLog Buffer: 14,340K

Load Profile

Per SecondPer Transaction
Redo size: 864,437.85 236,009.48
Logical reads: 28,414.86 7,757.85
Block changes: 3,248.79 886.99
Physical reads: 1,408.61 384.58
Physical writes: 468.16 127.82
User calls: 129.38 35.32
Parses: 96.32 26.30
Hard parses: 1.55 0.42
Sorts: 12.60 3.44
Logons: 1.51 0.41
Executes: 365.74 99.85
Transactions: 3.66 

% Blocks changed per Read: 11.43Recursive Call %: 88.51
Rollback per transaction %: 28.14Rows per Sort: 317.54

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.91Redo NoWait %: 99.98
Buffer Hit %: 96.09In-memory Sort %: 99.55
Library Hit %: 99.39Soft Parse %: 98.40
Execute to Parse %: 73.66Latch Hit %: 99.60
Parse CPU to Parse Elapsd %: 37.91% Non-Parse CPU: 99.57

Shared Pool Statistics

BeginEnd
Memory Usage %: 70.72 72.74
% SQL with executions>1: 80.27 88.74
% Memory for SQL w/exec>1: 90.83 88.43

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
gc buffer busy 192,810 16,894 88 29.7Cluster
gc current block busy 64,292 16,476 256 29.0Cluster
log file sync 42,091 7,765 184 13.7Commit
CPU time  6,586  11.6 
LGWR wait on LNS 55,167 3,663 66 6.4Network

RAC Statistics

BeginEnd
Number of Instances: 3 3

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 1,132.09 309.08
Global Cache blocks served: 286.53 78.23
GCS/GES messages received: 2,056.08 561.35
GCS/GES messages sent: 3,312.27 904.32
DBWR Fusion writes: 53.78 14.68
Estd Interconnect traffic (KB) 12,397.49 

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

Buffer access - local cache %: 92.10
Buffer access - remote cache %: 3.98
Buffer access - disk %: 3.91

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 3.1
Avg global cache cr block receive time (ms): 34.6
Avg global cache current block receive time (ms): 3.2
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 7.6
Avg global cache cr block flush time (ms): 171.5
Avg global cache current block pin time (ms): 0.2
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 2.0
Avg global cache current block flush time (ms): 145.3

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.5
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: 25.51
% of indirect sent messages: 72.47
% of flow controlled messages: 2.02

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 55,503.73 97.57
connection management call elapsed time 13,907.70 24.45
DB CPU 6,585.88 11.58
parse time elapsed 1,159.33 2.04
hard parse elapsed time 1,134.44 1.99
sequence load elapsed time 142.94 0.25
failed parse elapsed time 24.17 0.04
PL/SQL execution elapsed time 20.71 0.04
PL/SQL compilation elapsed time 0.39 0.00
hard parse (bind mismatch) elapsed time 0.21 0.00
hard parse (sharing criteria) elapsed time 0.21 0.00
repeated bind elapsed time 0.12 0.00
DB time 56,885.46  
background elapsed time 12,441.50  
background cpu time 888.86  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Cluster 6,467,215 0.25 40,168 6 246.37
Commit 42,091 6.44 7,765 184 1.60
Other 2,906,614 76.10 7,485 3 110.73
Network 2,210,339 0.00 7,424 3 84.20
User I/O 3,716,303 0.00 5,663 2 141.57
Concurrency 105,488 1.99 1,286 12 4.02
Application 395,464 0.18 776 2 15.07
System I/O 302,283 0.00 422 1 11.52
Configuration 52,562 96.96 117 2 2.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
gc buffer busy 192,810 5.05 16,894 88 7.35
gc current block busy 64,292 7.33 16,476 256 2.45
log file sync 42,091 6.44 7,765 184 1.60
LGWR wait on LNS 55,167 0.10 3,663 66 2.10
LGWR-LNS wait on channel 411,202 81.13 3,661 9 15.66
LNS wait on SENDREQ 55,152 0.00 3,649 66 2.10
gcs log flush sync 1,885,706 75.73 3,551 2 71.84
gc cr block busy 7,781 12.58 2,946 379 0.30
db file sequential read 1,198,433 0.00 1,834 2 45.65
gc current block 2-way 1,563,080 0.01 1,526 1 59.55
db file scattered read 449,374 0.00 1,342 3 17.12
direct path read temp 1,395,748 0.00 1,205 1 53.17
enq: TX - index contention 6,205 32.22 1,108 179 0.24
gc cr multi block request 3,436,236 0.00 1,085 0 130.90
direct path write temp 609,109 0.00 675 1 23.20
gc current block 3-way 352,104 0.01 478 1 13.41
local write wait 5,517 1.14 458 83 0.21
enq: RO - fast object reuse 9,645 5.61 452 47 0.37
gc current grant busy 34,712 0.24 307 9 1.32
SQL*Net break/reset to client 380,630 0.00 225 1 14.50
gc cr grant 2-way 442,974 0.00 210 0 16.88
buffer busy waits 14,017 0.52 157 11 0.53
gc current grant 2-way 309,506 0.00 155 0 11.79
db file parallel read 53,746 0.00 144 3 2.05
log file sequential read 6,843 0.00 113 16 0.26
cr request retry 156 98.08 105 674 0.01
control file sequential read 146,339 0.00 105 1 5.57
SQL*Net more data from client 889,670 0.00 105 0 33.89
db file parallel write 80,268 0.00 104 1 3.06
enq: TX - row lock contention 270 66.30 97 359 0.01
log buffer space 168 25.60 94 557 0.01
log file parallel write 55,128 0.00 87 2 2.10
Streams AQ: qmn coordinator waiting for slave to start 9 100.00 45 4994 0.00
gc current split 1,497 0.94 39 26 0.06
enq: CF - contention 2,877 1.84 34 12 0.11
gc cr block 2-way 41,747 0.00 29 1 1.59
reliable message 2,263 0.44 27 12 0.09
DFS lock handle 18,453 0.00 21 1 0.70
log file switch completion 76 6.58 19 251 0.00
gc cr block 3-way 16,554 0.00 16 1 0.63
row cache lock 70,115 0.00 10 0 2.67
Log archive I/O 6,777 0.00 7 1 0.26
enq: FB - contention 6,131 0.00 7 1 0.23
control file parallel write 6,896 0.00 7 1 0.26
library cache lock 3,001 0.20 6 2 0.11
LGWR wait for redo copy 6,693 3.68 5 1 0.25
SQL*Net more data to client 266,631 0.00 5 0 10.16
read by other session 772 0.00 5 6 0.03
enq: HW - contention 1,361 0.29 4 3 0.05
ARCH wait on c/f tx acquire 2 4 100.00 4 977 0.00
CGS wait for IPC msg 328,312 99.89 3 0 12.51
enq: TM - contention 4,913 0.04 3 1 0.19
enq: TX - contention 52 0.00 3 49 0.00
gc current request 1 200.00 2 2321 0.00
ksxr poll remote instances 207,254 48.09 2 0 7.90
latch: KCL gc element parent latch 6,382 0.00 2 0 0.24
ges inquiry response 1,675 0.00 2 1 0.06
os thread startup 26 0.00 2 65 0.00
name-service call wait 18 5.56 2 94 0.00
gc current block congested 348 0.00 2 5 0.01
IPC send completion sync 1,764 99.66 2 1 0.07
gc cr disk read 2,869 0.00 1 1 0.11
latch free 418 0.00 1 3 0.02
latch: cache buffers chains 8,879 0.00 1 0 0.34
SQL*Net message to client 888,551 0.00 1 0 33.85
lock deadlock retry 49 100.00 1 20 0.00
ges global resource directory to be frozen 99 100.00 1 10 0.00
latch: session allocation 67 0.00 1 14 0.00
latch: cache buffers lru chain 562 0.00 1 1 0.02
enq: PS - contention 754 0.00 1 1 0.03
buffer deadlock 4,651 99.44 1 0 0.18
gc current retry 73 0.00 1 9 0.00
kjbdrmcvtq lmon drm quiesce: ping completion 99 39.39 1 6 0.00
library cache pin 3,148 0.00 1 0 0.12
enq: WF - contention 54 0.00 1 10 0.00
flashback buf free by RVWR 10 0.00 1 51 0.00
gc current block lost 1 0.00 0 494 0.00
LNS wait on LGWR 55,168 0.00 0 0 2.10
direct path read 2,758 0.00 0 0 0.11
gc cr block lost 1 0.00 0 386 0.00
latch: gcs resource hash 557 0.00 0 1 0.02
global enqueue expand wait 39 97.44 0 10 0.00
rdbms ipc reply 292 0.00 0 1 0.01
KJC: Wait for msg sends to complete 1,002 0.00 0 0 0.04
latch: object queue header operation 973 0.00 0 0 0.04
gc cr failure 136 0.00 0 2 0.01
enq: TT - contention 377 0.00 0 1 0.01
undo segment extension 50,935 99.96 0 0 1.94
cursor: pin S wait on X 23 86.96 0 9 0.00
PX Deq: reap credit 15,642 97.28 0 0 0.60
enq: TX - allocate ITL entry 17 0.00 0 10 0.00
gc current grant congested 31 0.00 0 5 0.00
buffer exterminate 4 0.00 0 40 0.00
latch: library cache 27 0.00 0 6 0.00
latch: shared pool 21 0.00 0 7 0.00
gc object scan 224 93.75 0 1 0.01
latch: ges resource hash list 786 0.00 0 0 0.03
direct path write 846 0.00 0 0 0.03
gcs drm freeze in enter server mode 2 0.00 0 65 0.00
PX Deq Credit: send blkd 245 27.76 0 1 0.01
latch: library cache lock 10 0.00 0 11 0.00
enq: TD - KTF dump entries 2 0.00 0 45 0.00
latch: row cache objects 15 0.00 0 5 0.00
enq: FL - Flashback db command 100 0.00 0 1 0.00
gc cr block congested 16 0.00 0 4 0.00
wait for scn ack 5 0.00 0 13 0.00
gc current block unknown 71 0.00 0 1 0.00
gc cr grant congested 26 0.00 0 2 0.00
enq: FL - Flashback database log 85 0.00 0 1 0.00
enq: TA - contention 46 0.00 0 1 0.00
latch: redo allocation 15 0.00 0 3 0.00
gc current multi block request 97 0.00 0 0 0.00
PX Deq: Signal ACK 176 38.64 0 0 0.01
latch: checkpoint queue latch 45 0.00 0 1 0.00
enq: SQ - contention 5 0.00 0 5 0.00
log file single write 32 0.00 0 1 0.00
latch: enqueue hash chains 5 0.00 0 4 0.00
latch: undo global data 8 0.00 0 2 0.00
enq: US - contention 23 0.00 0 1 0.00
wait list latch free 1 0.00 0 10 0.00
ges2 LMON to wake up LMD - mrcvr 22 9.09 0 0 0.00
enq: RS - file delete 15 0.00 0 1 0.00
cursor: pin S 376 0.00 0 0 0.01
enq: DR - contention 2 0.00 0 3 0.00
enq: WL - contention 7 0.00 0 1 0.00
enq: JS - job run lock - synchronize 2 0.00 0 1 0.00
enq: UL - contention 4 0.00 0 1 0.00
enq: PG - contention 5 0.00 0 0 0.00
enq: PE - contention 4 0.00 0 0 0.00
gc quiesce 28 0.00 0 0 0.00
enq: PW - flush prewarm buffers 2 0.00 0 1 0.00
enq: AF - task serialization 1 0.00 0 1 0.00
latch: messages 6 0.00 0 0 0.00
enq: PI - contention 1 0.00 0 1 0.00
latch: library cache pin 1 0.00 0 0 0.00
lock escalate retry 28 100.00 0 0 0.00
PX qref latch 1 100.00 0 0 0.00
SQL*Net message from client 888,546 0.00 302,267 340 33.85
PX Idle Wait 6,141 89.01 14,117 2299 0.23
Streams AQ: waiting for messages in the queue 2,288 97.29 13,934 6090 0.09
gcs remote message 4,409,491 85.49 9,892 2 167.98
Streams AQ: qmn slave idle wait 296 3.04 7,656 25866 0.01
class slave wait 524 0.38 7,517 14346 0.02
DIAG idle wait 35,770 0.00 6,999 196 1.36
ASM background timer 2,331 0.00 6,993 3000 0.09
ges remote message 248,622 88.36 6,990 28 9.47
virtual circuit status 239 100.00 6,969 29161 0.01
Streams AQ: qmn coordinator idle wait 521 49.33 6,920 13282 0.02
Streams AQ: waiting for time management or cleanup tasks 26 100.00 6,591 253511 0.00
jobq slave wait 83 96.39 234 2824 0.00
PX Deq: Execution Msg 3,566 31.21 159 45 0.14
KSV master wait 518 0.58 23 43 0.02
SGA: MMAN sleep for component shrink 1,006 94.83 10 10 0.04
PX Deq: Msg Fragment 1,159 29.94 0 0 0.04
PX Deq: Join ACK 184 36.41 0 1 0.01
PX Deq: Parse Reply 172 33.72 0 1 0.01
PX Deq: Execute Reply 88 30.68 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 521 100.00 0 0 0.02
PX Deq Credit: need buffer 17 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 2,864,838 76.49 7,340 3 109.14
LGWR wait on LNS 55,166 0.10 3,663 66 2.10
LNS wait on SENDREQ 55,150 0.00 3,649 66 2.10
log file sequential read 6,843 0.00 113 16 0.26
db file parallel write 80,271 0.00 104 1 3.06
log file parallel write 55,126 0.00 87 2 2.10
control file sequential read 46,783 0.00 35 1 1.78
Log archive I/O 6,777 0.00 7 1 0.26
control file parallel write 6,897 0.00 7 1 0.26
gc current block busy 6 50.00 6 1057 0.00
enq: RO - fast object reuse 4,703 0.00 4 1 0.18
db file sequential read 639 0.00 3 5 0.02
db file scattered read 136 0.00 1 6 0.01
os thread startup 23 0.00 1 35 0.00
enq: TM - contention 3,729 0.03 1 0 0.14
log buffer space 1 0.00 1 552 0.00
LNS wait on LGWR 55,166 0.00 0 0 2.10
buffer busy waits 189 5.82 0 2 0.01
direct path read 2,752 0.00 0 0 0.10
row cache lock 288 0.00 0 1 0.01
gc current block 2-way 631 0.00 0 1 0.02
log file sync 5 0.00 0 42 0.00
gc object scan 224 93.75 0 1 0.01
direct path write 840 0.00 0 0 0.03
db file parallel read 20 0.00 0 6 0.00
gc cr multi block request 157 0.00 0 1 0.01
gc cr grant 2-way 192 0.00 0 0 0.01
gc current grant 2-way 119 0.00 0 1 0.00
latch: cache buffers chains 893 0.00 0 0 0.03
gc cr block 2-way 132 0.00 0 1 0.01
gc cr block 3-way 59 0.00 0 1 0.00
gc current block 3-way 63 0.00 0 1 0.00
latch: shared pool 6 0.00 0 9 0.00
gc current grant busy 63 0.00 0 1 0.00
log file single write 32 0.00 0 1 0.00
library cache lock 21 0.00 0 1 0.00
latch: library cache 1 0.00 0 1 0.00
rdbms ipc message 523,429 28.81 123,558 236 19.94
gcs remote message 4,410,009 85.49 9,893 2 168.00
DIAG idle wait 35,773 0.00 7,000 196 1.36
ASM background timer 2,332 0.00 6,998 3001 0.09
pmon timer 6,508 99.91 6,993 1075 0.25
ges remote message 248,396 88.36 6,990 28 9.46
smon timer 5,560 26.38 6,977 1255 0.21
class slave wait 503 0.00 6,931 13780 0.02
Streams AQ: qmn coordinator idle wait 521 49.33 6,920 13282 0.02
Streams AQ: waiting for time management or cleanup tasks 26 100.00 6,591 253511 0.00
KSV master wait 518 0.58 23 43 0.02
SGA: MMAN sleep for component shrink 1,006 94.83 10 10 0.04
PX Deq: Join ACK 89 37.08 0 1 0.00
PX Deq: Parse Reply 81 35.80 0 1 0.00
PX Deq: Execute Reply 60 35.00 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 521 100.00 0 0 0.02

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 167,975
AVG_IDLE_TIME 548,507
AVG_IOWAIT_TIME 19,990
AVG_SYS_TIME 51,532
AVG_USER_TIME 116,227
BUSY_TIME 1,345,420
IDLE_TIME 4,389,723
IOWAIT_TIME 161,650
SYS_TIME 413,937
USER_TIME 931,483
LOAD 0
OS_CPU_WAIT_TIME 1,859,500
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 34,359,738,368
NUM_CPUS 8
NUM_CPU_CORES 4

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
codieff_blue_srv 56,481.10 6,547.60 10,085,677 203,056,575
SYS$USERS 408.10 39.20 1,276 333,786
SYS$BACKGROUND 0.00 0.00 8,183 263,611
udas2pXDB 0.00 0.00 0 0
udas2pdb_dg4.sbc.com 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
codieff_blue_srv 3707881 563215 102701 128276 0 0 1988811 10681
SYS$USERS 1328 1497 1304 135 0 0 25510 7
SYS$BACKGROUND 7074 1587 1481 182 0 0 165485 731305
udas2pdb_dg4.sbc.com 0 0 0 0 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
9,595 295 5,970 1.61 16.87 f5ma6sr1cyd7m pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_PROGRAMID_MAPP...
8,006 398 10,401 0.77 14.07 0a54p6s6jk94y pmdtm@fipd325 (TNS V1-V3) INSERT INTO STG_ID_MAPPER(GLF_...
7,641 26 11,085 0.69 13.43 15zytu14qzw6p sqlplus@flpd272 (TNS V1-V3) insert into sys.aud$( sessioni...
7,164 46 13,813 0.52 12.59 5pdgmjpnacak4 JDBC Thin Client INSERT INTO CODIE_TRANSACTION_...
5,024 16 10,062 0.50 8.83 1rd8um1taq1fn   update sys.aud$ set action#=:2...
2,407 402 18 133.73 4.23 gquasqp1c85d0 JDBC Thin Client insert into OM_VHO_SVC_COL_ASS...
1,613 10 294 5.49 2.84 fvk5x826hw6gg pmdtm@fipd422 (TNS V1-V3) INSERT INTO BF_STG_PRCH_HSTRY(...
1,283 265 1 1282.71 2.25 30jgq55twn6tx pmdtm@fipd216 (TNS V1-V3) SELECT BOUNDARY_ZIP_CODE_DIG...
916 112 2 457.99 1.61 0sa5cmb8p9qsx SQL*Plus select B.VHO_CLLI_CODE||', '||...
839 376 732 1.15 1.48 cdk073dvj8vua JDBC Thin Client SELECT 1 FROM DUAL WHERE EXIST...
819 629 184,753 0.00 1.44 dcd705zj1j1mt pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_SERVICE(PACKAG...
658 117 1 658.33 1.16 3b11swss8suuq pmdtm@fipd216 (TNS V1-V3) SELECT TUNER_POSITION, TO_TI...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
629 819 184,753 0.00 1.44 dcd705zj1j1mt pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_SERVICE(PACKAG...
402 2,407 18 22.36 4.23 gquasqp1c85d0 JDBC Thin Client insert into OM_VHO_SVC_COL_ASS...
398 8,006 10,401 0.04 14.07 0a54p6s6jk94y pmdtm@fipd325 (TNS V1-V3) INSERT INTO STG_ID_MAPPER(GLF_...
376 839 732 0.51 1.48 cdk073dvj8vua JDBC Thin Client SELECT 1 FROM DUAL WHERE EXIST...
295 9,595 5,970 0.05 16.87 f5ma6sr1cyd7m pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_PROGRAMID_MAPP...
265 1,283 1 264.64 2.25 30jgq55twn6tx pmdtm@fipd216 (TNS V1-V3) SELECT BOUNDARY_ZIP_CODE_DIG...
144 275 311 0.46 0.48 a3t2dv56rvvuj JDBC Thin Client SELECT DISTINCT TUNER_POSITION...
117 658 1 116.89 1.16 3b11swss8suuq pmdtm@fipd216 (TNS V1-V3) SELECT TUNER_POSITION, TO_TI...
112 916 2 55.80 1.61 0sa5cmb8p9qsx SQL*Plus select B.VHO_CLLI_CODE||', '||...
97 146 3,059 0.03 0.26 b5dgb0j12ndtq pmdtm@fipd325 (TNS V1-V3) INSERT INTO STG_IPTV_CHMAP_SVC...
46 7,164 13,813 0.00 12.59 5pdgmjpnacak4 JDBC Thin Client INSERT INTO CODIE_TRANSACTION_...
26 7,641 11,085 0.00 13.43 15zytu14qzw6p sqlplus@flpd272 (TNS V1-V3) insert into sys.aud$( sessioni...
16 5,024 10,062 0.00 8.83 1rd8um1taq1fn   update sys.aud$ set action#=:2...
10 1,613 294 0.03 2.84 fvk5x826hw6gg pmdtm@fipd422 (TNS V1-V3) INSERT INTO BF_STG_PRCH_HSTRY(...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
21,305,660 184,753 115.32 10.46 629.02 818.81 dcd705zj1j1mt pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_SERVICE(PACKAG...
17,840,311 18 991,128.39 8.76 402.47 2407.17 gquasqp1c85d0 JDBC Thin Client insert into OM_VHO_SVC_COL_ASS...
17,086,345 732 23,342.00 8.39 375.61 839.16 cdk073dvj8vua JDBC Thin Client SELECT 1 FROM DUAL WHERE EXIST...
12,943,455 3,324 3,893.94 6.36 66.62 112.91 bm28jpgutd5dt pmdtm@fipd216 (TNS V1-V3) DELETE VOD_MDT_CONTENT WHERE P...
8,601,672 2 4,300,836.00 4.22 111.60 915.98 0sa5cmb8p9qsx SQL*Plus select B.VHO_CLLI_CODE||', '||...
7,189,607 5,970 1,204.29 3.53 294.70 9594.97 f5ma6sr1cyd7m pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_PROGRAMID_MAPP...
7,078,735 10,401 680.58 3.48 397.99 8006.49 0a54p6s6jk94y pmdtm@fipd325 (TNS V1-V3) INSERT INTO STG_ID_MAPPER(GLF_...
6,672,422 311 21,454.73 3.28 143.61 274.60 a3t2dv56rvvuj JDBC Thin Client SELECT DISTINCT TUNER_POSITION...
6,608,174 312 21,180.04 3.24 93.47 141.87 01mfzbszdmf0u JDBC Thin Client SELECT MAP_NAME, MAP_AREA_NAM...
6,576,817 311 21,147.32 3.23 94.79 150.92 f8jra2wc6r5x7 JDBC Thin Client SELECT TUNER_POSITION, ELCTRN...
2,825,996 2 1,412,998.00 1.39 63.82 112.94 3yrgy45dtyrzt pmdtm@fipd216 (TNS V1-V3) SELECT DISTINCT OM_ASSOC.SK_...
2,062,576 12 171,881.33 1.01 71.51 277.96 g527v48drgf0j pmdtm@fipd422 (TNS V1-V3) SELECT BF_MART_PRCH_HSTR...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
1,330,308 18 73,906.00 13.18 402.47 2407.17 gquasqp1c85d0 JDBC Thin Client insert into OM_VHO_SVC_COL_ASS...
1,313,800 732 1,794.81 13.01 375.61 839.16 cdk073dvj8vua JDBC Thin Client SELECT 1 FROM DUAL WHERE EXIST...
1,062,399 1 1,062,399.00 10.52 264.64 1282.71 30jgq55twn6tx pmdtm@fipd216 (TNS V1-V3) SELECT BOUNDARY_ZIP_CODE_DIG...
549,456 1 549,456.00 5.44 116.89 658.33 3b11swss8suuq pmdtm@fipd216 (TNS V1-V3) SELECT TUNER_POSITION, TO_TI...
399,555 1 399,555.00 3.96 10.26 54.67 5ja8186ubypp9 pmdtm@fipd216 (TNS V1-V3) UPDATE PCT_VSDA_USD_LOAD SET L...
399,548 1 399,548.00 3.96 10.99 156.01 0vzy0911g8mjj pmdtm@fipd216 (TNS V1-V3) SELECT DISTINCT PCT_VSDA_USD_L...
399,548 1 399,548.00 3.96 11.30 152.27 6rsswhw400fa8 pmdtm@fipd216 (TNS V1-V3) SELECT DISTINCT PCT_VSDA_USD_L...
399,040 1 399,040.00 3.95 16.53 186.24 avks59hug3sws pmdtm@fipd422 (TNS V1-V3) SELECT DISTINCT PCT_VSDA_USD_L...
398,384 1 398,384.00 3.95 16.99 88.67 4dwzcg8d9wnc0 pmdtm@fipd325 (TNS V1-V3) SELECT MAX(PCT_VSDA_USD_LOAD.S...
398,004 1 398,004.00 3.94 17.79 94.06 26b87mkmvjkkn pmdtm@fipd422 (TNS V1-V3) UPDATE PCT_VSDA_USD_LOAD SET L...
363,378 2 181,689.00 3.60 111.60 915.98 0sa5cmb8p9qsx SQL*Plus select B.VHO_CLLI_CODE||', '||...
298,827 1 298,827.00 2.96 18.94 158.61 az9zjgfkgwqnn SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
287,370 1 287,370.00 2.85 16.96 83.20 29zg06f2scr5u SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
285,066 1 285,066.00 2.82 16.61 67.65 7yffgbkjb5j55 SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
284,917 1 284,917.00 2.82 14.62 134.30 b943xnx5pjgzg SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
284,372 1 284,372.00 2.82 17.66 153.05 3xycuhqtp1yfp SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
283,131 1 283,131.00 2.80 15.17 140.02 4fm9jy5xsacmu SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
278,464 1 278,464.00 2.76 13.68 62.72 932t85mdwkyjw SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
278,360 1 278,360.00 2.76 14.52 64.96 7rh0x6utfz564 SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
267,429 1 267,429.00 2.65 15.84 77.01 2xk4b655cgwjn SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
255,697 1 255,697.00 2.53 14.84 68.73 d6914jbs6x455 SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
209,734 5,970 35.13 2.08 294.70 9594.97 f5ma6sr1cyd7m pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_PROGRAMID_MAPP...
137,387 1 137,387.00 1.36 29.55 147.85 f7h7zgxtbg0jk pmdtm@fipd216 (TNS V1-V3) SELECT BK_BNDRY_POINT_DIGITS...
135,942 184,753 0.74 1.35 629.02 818.81 dcd705zj1j1mt pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_SERVICE(PACKAG...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
1,408,715 1,408,715 1.00 0.00 0.00 4tfmy24hppyh4 pmdtm@fipd325 (TNS V1-V3) SELECT STG_IPTV_CHMAP_SVC_SVCL...
185,071 370 0.00 0.00 0.00 2jfqzrxhrm93b   select /*+ rule */ c.name, u....
184,753 12,849 0.07 0.00 0.00 dcd705zj1j1mt pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_SERVICE(PACKAG...
184,696 184,696 1.00 0.00 0.00 2skwhauh2cwky   select o.name, u.name from ob...
154,751 154,751 1.00 0.00 0.00 22ym71j0bxj4j pmdtm@fipd422 (TNS V1-V3) SELECT STG_TAX_CHILD_PACKAGE_S...
79,390 79,390 1.00 0.00 0.00 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
20,171 10,167 0.50 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
13,813 13,811 1.00 0.00 0.52 5pdgmjpnacak4 JDBC Thin Client INSERT INTO CODIE_TRANSACTION_...
11,085 11,081 1.00 0.00 0.69 15zytu14qzw6p sqlplus@flpd272 (TNS V1-V3) insert into sys.aud$( sessioni...
10,401 2,054,117 197.49 0.04 0.77 0a54p6s6jk94y pmdtm@fipd325 (TNS V1-V3) INSERT INTO STG_ID_MAPPER(GLF_...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
185,072 185,071 26.81 2jfqzrxhrm93b   select /*+ rule */ c.name, u....
184,696 184,696 26.76 2skwhauh2cwky   select o.name, u.name from ob...
79,390 79,390 11.50 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
20,170 20,171 2.92 0h6b2sajwb74n   select privilege#, level from ...
10,132 11,085 1.47 15zytu14qzw6p sqlplus@flpd272 (TNS V1-V3) insert into sys.aud$( sessioni...
10,093 10,100 1.46 0k8522rmdzg4k   select privilege# from sysauth...
10,068 10,073 1.46 grwydz59pu6mc   select text from view$ where r...
10,056 10,062 1.46 1rd8um1taq1fn   update sys.aud$ set action#=:2...
10,029 10,086 1.45 459f3z9u4fb3u   select value$ from props$ wher...
9,986 10,005 1.45 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
9,947 9,985 1.44 5ur69atw3vfhj   select decode(failover_method,...
9,896 10,013 1.43 978j5sbkzfzzd   select dummy from dual where ...
9,879 9,998 1.43 4488b4fqp2vh5   select dummy from dual where ...
9,723 9,730 1.41 5un910zs5681s racgmdb@fipd329 (TNS V1-V3) DECLARE lcommand varch...
7,283 7,300 1.06 6dv0dpznx0dg9 pmdtm@fipd325 (TNS V1-V3) select VALUE from NLS_SESSION_...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
115 7,428 12ff1v1491pmv pmdtm@fipd422 (TNS V1-V3) INSERT INTO BF_AUDIT_TRAIL ( B...
38 12 4dxyvxm331xb3 JDBC Thin Client SELECT a.inst_id, SUM (DECODE ...
27 134 04xtrk7uyhknh   select obj#, type#, ctime, mti...
21 11,085 15zytu14qzw6p sqlplus@flpd272 (TNS V1-V3) insert into sys.aud$( sessioni...
21 0 7frqszzdu8sgg racgimon@fipd127 (TNS V1-V3) select DECODE(UPPER(d.OPEN_MOD...
21 76 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
8,858.27 92.32 9,594.97 294.70 5,970 f5ma6sr1cyd7m pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_PROGRAMID_MAPP...
7,488.32 98.00 7,641.49 25.80 11,085 15zytu14qzw6p sqlplus@flpd272 (TNS V1-V3) insert into sys.aud$( sessioni...
7,341.62 91.70 8,006.49 397.99 10,401 0a54p6s6jk94y pmdtm@fipd325 (TNS V1-V3) INSERT INTO STG_ID_MAPPER(GLF_...
6,035.62 84.25 7,163.91 46.01 13,813 5pdgmjpnacak4 JDBC Thin Client INSERT INTO CODIE_TRANSACTION_...
4,973.17 98.99 5,023.92 16.25 10,062 1rd8um1taq1fn   update sys.aud$ set action#=:2...
1,483.32 91.97 1,612.86 9.88 294 fvk5x826hw6gg pmdtm@fipd422 (TNS V1-V3) INSERT INTO BF_STG_PRCH_HSTRY(...
807.60 33.55 2,407.17 402.47 18 gquasqp1c85d0 JDBC Thin Client insert into OM_VHO_SVC_COL_ASS...
421.43 87.96 479.12 6.94 7,428 12ff1v1491pmv pmdtm@fipd422 (TNS V1-V3) INSERT INTO BF_AUDIT_TRAIL ( B...
300.03 32.76 915.98 111.60 2 0sa5cmb8p9qsx SQL*Plus select B.VHO_CLLI_CODE||', '||...
264.77 90.95 291.13 19.11 8,171 f7cj89gbthspp pmdtm@fipd422 (TNS V1-V3) DELETE FROM BF_STG_PRCH_HSTRY ...
188.08 67.72 277.73 11.19 512 33upt6jutd7x0 pmdtm@fipd325 (TNS V1-V3) INSERT INTO BF_MART_PRCH_HSTRY...
174.02 62.61 277.96 71.51 12 g527v48drgf0j pmdtm@fipd422 (TNS V1-V3) SELECT BF_MART_PRCH_HSTR...
170.77 20.35 839.16 375.61 732 cdk073dvj8vua JDBC Thin Client SELECT 1 FROM DUAL WHERE EXIST...
156.77 41.93 373.86 85.75 24 5qsu4hxv1rs6u JDBC Thin Client update om_pkg_pga_prvdr_assoc ...
155.20 91.11 170.34 13.57 10,296 7g7j8txwnt5rq pmdtm@fipd325 (TNS V1-V3) UPDATE BF_STG_PRCH_HSTRY SET I...
115.52 57.27 201.72 54.61 10 35ku6489jtxpa pmdtm@fipd422 (TNS V1-V3) SELECT BF_MART_PRCH_HSTR...
95.83 11.70 818.81 629.02 184,753 dcd705zj1j1mt pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_SERVICE(PACKAG...
93.03 83.03 112.05 18.15 79,390 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
92.05 33.52 274.60 143.61 311 a3t2dv56rvvuj JDBC Thin Client SELECT DISTINCT TUNER_POSITION...
87.58 48.03 182.35 48.20 900 9v4t0d7nsvnyx pmdtm@fipd422 (TNS V1-V3) INSERT INTO STG_TAX_CHILD_PACK...
85.56 90.31 94.74 9.01 154,751 22ym71j0bxj4j pmdtm@fipd422 (TNS V1-V3) SELECT STG_TAX_CHILD_PACKAGE_S...
30.95 20.22 153.05 17.66 1 3xycuhqtp1yfp SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
28.99 37.64 77.01 15.84 1 2xk4b655cgwjn SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
28.79 15.46 186.24 16.53 1 avks59hug3sws pmdtm@fipd422 (TNS V1-V3) SELECT DISTINCT PCT_VSDA_USD_L...
27.71 29.46 94.06 17.79 1 26b87mkmvjkkn pmdtm@fipd422 (TNS V1-V3) UPDATE PCT_VSDA_USD_LOAD SET L...
27.60 31.12 88.67 16.99 1 4dwzcg8d9wnc0 pmdtm@fipd325 (TNS V1-V3) SELECT MAX(PCT_VSDA_USD_LOAD.S...
27.35 32.87 83.20 16.96 1 29zg06f2scr5u SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
26.68 16.82 158.61 18.94 1 az9zjgfkgwqnn SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
26.03 37.88 68.73 14.84 1 d6914jbs6x455 SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
24.94 16.53 150.92 94.79 311 f8jra2wc6r5x7 JDBC Thin Client SELECT TUNER_POSITION, ELCTRN...
22.49 15.85 141.87 93.47 312 01mfzbszdmf0u JDBC Thin Client SELECT MAP_NAME, MAP_AREA_NAM...
20.30 31.05 65.37 34.27 76 431ukanuxc5uj JDBC Thin Client SELECT DISTINCT TUNER_POSITION...
18.90 27.94 67.65 16.61 1 7yffgbkjb5j55 SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
17.07 12.19 140.02 15.17 1 4fm9jy5xsacmu SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
15.67 85.81 18.26 0.36 12 4dxyvxm331xb3 JDBC Thin Client SELECT a.inst_id, SUM (DECODE ...
15.39 23.68 64.96 14.52 1 7rh0x6utfz564 SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
14.69 23.42 62.72 13.68 1 932t85mdwkyjw SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
14.28 10.63 134.30 14.62 1 b943xnx5pjgzg SQL*Plus UPDATE BF_MART_PRCH_HSTRY SET ...
14.21 31.16 45.61 13.28 5 cdfdzx8dduv4w pmdtm@fipd422 (TNS V1-V3) SELECT BF_MART_MDT.STATUS AS ...
9.21 1.40 658.33 116.89 1 3b11swss8suuq pmdtm@fipd216 (TNS V1-V3) SELECT TUNER_POSITION, TO_TI...
7.04 6.23 112.94 63.82 2 3yrgy45dtyrzt pmdtm@fipd216 (TNS V1-V3) SELECT DISTINCT OM_ASSOC.SK_...
4.93 0.38 1,282.71 264.64 1 30jgq55twn6tx pmdtm@fipd216 (TNS V1-V3) SELECT BOUNDARY_ZIP_CODE_DIG...
3.40 16.15 21.06 11.93 2,642 csgadz21m2mk0 pmdtm@fipd422 (TNS V1-V3) UPDATE STG_SERVICE SET SERVICE...
3.29 2.92 112.91 66.62 3,324 bm28jpgutd5dt pmdtm@fipd216 (TNS V1-V3) DELETE VOD_MDT_CONTENT WHERE P...
3.27 2.25 145.58 96.95 3,059 b5dgb0j12ndtq pmdtm@fipd325 (TNS V1-V3) INSERT INTO STG_IPTV_CHMAP_SVC...
2.78 5.19 53.52 10.48 1 2qbbfc05cdkaf pmdtm@fipd325 (TNS V1-V3) delete from stg_SERVICE where ...
2.19 35.81 6.11 3.73 1,548 9p1um1wd886xb   select o.owner#, u.name, ...
1.87 1.27 147.85 29.55 1 f7h7zgxtbg0jk pmdtm@fipd216 (TNS V1-V3) SELECT BK_BNDRY_POINT_DIGITS...
1.41 7.51 18.83 13.10 47 8vaak0p1tfc57 JDBC Thin Client SELECT MAP_NAME, MAP_AREA_NAM...
1.37 51.84 2.64 1.14 1,632 g00cj285jmgsw   update sys.mon_mods$ set inser...
1.17 5.99 19.53 13.09 47 0548jzyd9hy1y JDBC Thin Client SELECT TUNER_POSITION, ELCTRN...
0.81 14.42 5.61 0.98 4 a12b5292h48vq SQL*Plus select /*NORULE */ 'DATAPOINT ...
0.59 31.46 1.88 0.98 294 cn1gtsav2d5jh sqlplus@fipd329 (TNS V1-V3) BEGIN BEGIN IF (xdb.DBMS...
0.19 15.55 1.20 1.16 2,507 9qgtwh66xg6nz   update seg$ set type#=:4, bloc...
0.12 14.73 0.79 0.52 4 6uvzftsujw5s6 SQL*Plus select /*NORULE */ 'DATA:'||A....
0.08 11.19 0.75 0.37 85 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
0.06 51.00 0.11 0.11 73 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
0.05 4.75 1.14 1.02 10,073 grwydz59pu6mc   select text from view$ where r...
0.05 16.42 0.30 0.09 2 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
0.05 26.00 0.18 0.12 134 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0.05 20.81 0.22 0.11 39 cqgv56fmuj63x   select owner#, name, namespace...
0.04 14.91 0.25 0.23 1,635 5ngzsfstg8tmy   select o.owner#, o.name, o.nam...
0.04 6.12 0.58 0.54 1,677 btzq46kta67dz   update obj$ set obj#=:6, type#...
0.03 14.91 0.18 0.05 4 6atcfr6wc0g4y SQL*Plus select 'DATAPOINT', nvl(min(n...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
01mfzbszdmf0uSELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U200') and not exists (select 1 from UDAS_CHMAP_SER_DETAILS_V b left outer join (select * from ref_filter_package where upper(package_type)=upper(:3)) rbasic on b.package_billing_code=rbasic.package_billing_code , ref_filter_channel rchnl where a.zip_code=b.zip_code and a.map_type=b.map_type and a.package_billing_code=b.package_billing_code and a.vho_code=b.vho_code and a.channel_name=b.channel_name and b.channel_name=rchnl.channel_name and rbasic.package_billing_code is null) AND VHO_CODE=:4 GROUP BY MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0548jzyd9hy1ySELECT TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID, COUNT(TUNER_POSITION) AS TUNERPOSITION FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U100') and not exists (select package_billing_code from ref_filter_package rbasic, ref_filter_channel rchnl WHERE a.package_billing_code=rbasic.package_billing_code(+) and upper(package_type)=upper(:3) AND a.channel_name =rchnl.channel_name AND rbasic.package_billing_code IS NULL AND a.channel_name =rchnl.channel_name) AND VHO_CODE=:4 GROUP BY TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID
0a54p6s6jk94yINSERT INTO STG_ID_MAPPER(GLF_PROGRAM_ID, INTERNAL_PROGRAM_ID, VHO_CLLI_CODE) VALUES ( :1, :2, :3)
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0sa5cmb8p9qsxselect B.VHO_CLLI_CODE||', '||B.ASSET_BILLING_EVENT_ID||', '||A.BE_STATE_ID||', '||A.RESOURCE_TYPE||', '||A.REJECT_REASON||', '||A.RESOURCE_NAME||', '||A.PURCHASE_AMOUNT||', '||A.CURRENCY||', '||B.RESOURCE_TYPE||', '||B.BE_STATE_ID||', '||to_char(PE_LAST_UPDATE_TS, 'yyyy-mm-dd hh24:mi:ssxff')||', '||to_char(PE_INSERT_TS, 'yyyy-mm-dd hh24:mi:ssxff')||', '||VERSION_NUM||', '||DISCOUNT_AMOUNT from BF_ALRT_PRCH_HSTRY A, BF_AUDIT_TRAIL B where B.purchase_dt > :z and B.PE_INSERT_TS <= :y and B.PE_INSERT_TS >= :x and A.ASSET_BILLING_EVENT_ID(+) = B.ASSET_BILLING_EVENT_ID and A.VHO_CLLI_CODE(+)= B.VHO_CLLI_CODE
0vzy0911g8mjjSELECT DISTINCT PCT_VSDA_USD_LOAD.PROC_ID FROM PCT_VSDA_USD_LOAD WHERE PCT_VSDA_USD_LOAD.PROC_ID=17164001.000000000000000 AND PCT_VSDA_USD_LOAD.MODULE_NM='OMCM'
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
12ff1v1491pmvINSERT INTO BF_AUDIT_TRAIL ( BF_AUDIT_ID , ASSET_DEPLOYMENT_ID , ASSET_BILLING_EVENT_ID , PRINCIPAL_EXTERNAL_ID , VHO_CLLI_CODE , PURCHASE_DT , PURCHASE_AMOUNT , PPV_ASSET_START_DT , PPV_ASSET_END_DT , RECONCILIATION_FILE_ID , RELIABLE_DELIVERY_ID , VERSION_NUM , BE_STATE_ID , PE_INSERT_TS , PE_LAST_UPDATE_TS , LAST_UPDATE_PROCESS_ID , SRC_VAL_STATUS , SRC_VAL_FAILURE_REASON , MDT_DB_FAILURE_COUNT, MDT_API_FAILURE_COUNT, IPTV_UPD_STATUS, IPTV_UPD_FAILURE_COUNT, INSERT_TS ) VALUES( BF_AUDIT_TRAIL_SEQ.NEXTVAL, :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , 0 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , SYSDATE )
15zytu14qzw6pinsert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34)
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1rd8um1taq1fnupdate sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(systimestamp as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
22ym71j0bxj4jSELECT STG_TAX_CHILD_PACKAGE_SEQ.NEXTVAL FROM DUAL
26b87mkmvjkknUPDATE PCT_VSDA_USD_LOAD SET LOAD_STATUS=:1, LOAD_END_TS=:2 WHERE PROC_ID=:3 AND MODULE_NM='INC'
29zg06f2scr5uUPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='737009' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059266_20110407120746.txt')
2jfqzrxhrm93bselect /*+ rule */ c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user#
2qbbfc05cdkafdelete from stg_SERVICE where package_ID IN ( SELECT DISTINCT PACKAGE_ID FROM stg_package where package_type in ('RDP', 'LIVE'))
2skwhauh2cwkyselect o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user#
2xk4b655cgwjnUPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='736871' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059260_20110407114439.txt')
30jgq55twn6tx SELECT BOUNDARY_ZIP_CODE_DIGITS, PRINCIPAL_GROUP_CODE, VHO_CLLI_CODE, DMA_NAME, PACKAGE_BILLING_CODE, TO_TIMESTAMP(PACKAGE_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4') PACKAGE_START_DATE, PACKAGE_INCLUDES_HD_CONTENT, MAP_NAME, TO_TIMESTAMP(START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4') START_DATE FROM ( SELECT SA_BNDRY.BOUNDARY_ZIP_CODE_DIGITS, SA_PGROUP.PRINCIPAL_GROUP_CODE, SA_PGROUP.VHO_CLLI_CODE, SA_PGROUP.DMA_NAME, SA_PGROUP.PACKAGE_BILLING_CODE, DECODE(SA_PGROUP.PACKAGE_START_DATE, NULL, '01-JAN-1900', TO_CHAR(SA_PGROUP.PACKAGE_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4')) PACKAGE_START_DATE, SA_PGROUP.PACKAGE_INCLUDES_HD_CONTENT, CHMAP.MAP_NAME, DECODE(CHMAP.START_DATE, NULL, '01-JAN-1900', TO_CHAR(CHMAP.START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4')) START_DATE FROM SERVICE_AREA_BOUNDARY SA_BNDRY, SERVICE_AREA_PRINCIPAL_GROUP SA_PGROUP, CHANNEL_MAP_DETAILS CHMAP WHERE SA_BNDRY.SK_SERVICE_AREA = SA_PGROUP.SK_SERVICE_AREA AND SA_BNDRY.SK_CHANNEL_MAP = CHMAP.SK_CHANNEL_MAP AND SA_PGROUP.PACKAGE_END_DATE IS NULL AND CHMAP.END_DATE IS NULL MINUS SELECT MIR_SA_BNDRY.BOUNDARY_ZIP_CODE_DIGITS, MIR_SA_PGROUP.PRINCIPAL_GROUP_CODE, MIR_SA_PGROUP.VHO_CLLI_CODE, MIR_SA_PGROUP.DMA_NAME, MIR_SA_PGROUP.PACKAGE_BILLING_CODE, DECODE(MIR_SA_PGROUP.PACKAGE_START_DATE, NULL, '01-JAN-1900', TO_CHAR(MIR_SA_PGROUP.PACKAGE_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4')) PACKAGE_START_DATE, MIR_SA_PGROUP.PACKAGE_INCLUDE S_HD_CONTENT, MIR_CHMAP.MAP_NAME, DECODE(MIR_CHMAP.START_DATE, NULL, '01-JAN-1900', TO_CHAR(MIR_CHMAP.START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4')) START_DATE FROM MIR_SA_BOUNDARY MIR_SA_BNDRY, MIR_SA_PRINCIPAL_GROUP MIR_SA_PGROUP, MIR_CHMAP_DETAILS MIR_CHMAP WHERE MIR_SA_BNDRY.SK_SERVICE_AREA =MIR_SA_PGROUP.SK_SERVICE_AREA AND MIR_SA_BNDRY.SK_CHANNEL_MAP = MIR_CHMAP.SK_CHANNEL_MAP)
33upt6jutd7x0INSERT INTO BF_MART_PRCH_HSTRY(PRINCIPAL_EXTERNAL_ID, ASSET_BILLING_EVENT_ID, ASSET_DEPLOYMENT_ID, VHO_CLLI_CODE, PURCHASE_DT, PPV_ASSET_START_DT, PPV_ASSET_END_DT, RESOURCE_NAME, PROVIDER_ASSET_ID, RATING, PURCHASE_AMOUNT, CURRENCY, SERVICE_PROVIDER_ID, GENRE, CONTENT_PROVIDER_ID, RESOURCE_TYPE, EVENT_TYPE, ADULT_CONTENT_IND, BILLED_ASSET_TITLE, DISCOUNT_AMOUNT, BILLED_AMOUNT, BE_STATE_ID, VERSION_NUM, LAST_UPDATE_TS, WORKFLOW_RUN_ID, OVERLAY_ASSET_TITLE) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26)
35ku6489jtxpaSELECT BF_MART_PRCH_HSTRY.PRINCIPAL_EXTERNAL_ID, BF_MART_PRCH_HSTRY.ASSET_BILLING_EVENT_ID, BF_MART_PRCH_HSTRY.ASSET_DEPLOYMENT_ID, BF_MART_PRCH_HSTRY.PURCHASE_DT, BF_MART_PRCH_HSTRY.PPV_ASSET_START_DT, BF_MART_PRCH_HSTRY.PPV_ASSET_END_DT, BF_MART_PRCH_HSTRY.RESOURCE_NAME, BF_MART_PRCH_HSTRY.PROVIDER_ASSET_ID, BF_MART_PRCH_HSTRY.PURCHASE_AMOUNT, BF_MART_PRCH_HSTRY.GENRE, BF_MART_PRCH_HSTRY.RESOURCE_TYPE, BF_MART_PRCH_HSTRY.ADULT_CONTENT_IND, BF_MART_PRCH_HSTRY.DISCOUNT_AMOUNT, BF_MART_PRCH_HSTRY.BILLED_AMOUNT, BF_MART_PRCH_HSTRY.VERSION_NUM, BF_MART_PRCH_HSTRY.OVERLAY_ASSET_TITLE FROM BF_MART_PRCH_HSTRY WHERE BF_MART_PRCH_HSTRY.BE_STATE_ID=9 AND BF_MART_PRCH_HSTRY.RESOURCE_TYPE='PPV' AND BF_MART_PRCH_HSTRY.UAR_SRC_STATUS='N' AND BF_MART_PRCH_HSTRY.CSF_SRC_STATUS=( CASE WHEN BF_MART_PRCH_HSTRY.BILLED_AMOUNT=0 THEN 0 ELSE 1 END)
3b11swss8suuq SELECT TUNER_POSITION, TO_TIMESTAMP(START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4') START_DATE, TO_TIMESTAMP(PG_IC_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4') PG_IC_START_DATE, PRINCIPAL_GROUP_CODE, VHO_CLLI_CODE, DMA_NAME, PACKAGE_BILLING_CODE, TO_TIMESTAMP(PACKAGE_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4') PACKAGE_START_DATE, PACKAGE_INCLUDES_HD_CONTENT, MAP_NAME, TO_TIMESTAMP(CHMAP_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4') CHMAP_START_DATE, CHANNEL_NAME, CONTENT_TYPE FROM ( SELECT SA_MAP_CHNLS.CALL_LETTERS, SA_MAP_CHNLS.TUNER_POSITION, SA_MAP_CHNLS.SERVICE_COLLECTION_GUID, SA_MAP_CHNLS.ELCTRNC_PRGRM_GUIDE_GUID, SA_MAP_CHNLS.CH_TO_CHMAP_IPTV_GUID, DECODE(SA_MAP_CHNLS.START_DATE, NULL, '01-JAN-1900', TO_CHAR(SA_MAP_CHNLS.START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))START_DATE, DECODE(SA_MAP_CHNLS.END_DATE, NULL, '01-JAN-1900', TO_CHAR(SA_MAP_CHNLS.END_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))END_DATE, DECODE(SA_MAP_CHNLS.LAST_MODIFY, NULL, '01-JAN-1900', TO_CHAR(SA_MAP_CHNLS.LAST_MODIFY, 'DD-MM-YYYY HH24:MI:SS.FF4'))LAST_MODIFY, DECODE(SA_MAP_CHNLS.PG_IC_START_DATE, NULL, '01-JAN-1900', TO_CHAR(SA_MAP_CHNLS.PG_IC_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))PG_IC_START_DATE, DECODE(SA_MAP_CHNLS.PG_IC_END_DATE, NULL, '01-JAN-1900', TO_CHAR(SA_MAP_CHNLS.PG_IC_END_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))PG_IC_END_DATE, SA_PGROUP.PRINCIPAL _GROUP_CODE, SA_PGROUP.VHO_CLLI_CODE, SA_PGROUP.DMA_NAME, SA_PGROUP.PACKAGE_BILLING_CODE, DECODE(SA_PGROUP.PACKAGE_START_DATE, NULL, '01-JAN-1900', TO_CHAR(SA_PGROUP.PACKAGE_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))PACKAGE_START_DATE, SA_PGROUP.PACKAGE_INCLUDES_HD_CONTENT, CHMAP.MAP_NAME, DECODE(CHMAP.START_DATE, NULL, '01-JAN-1900', TO_CHAR(CHMAP.START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))CHMAP_START_DATE, CHNL.CHANNEL_NAME, CHNL.CONTENT_TYPE FROM SERVICE_AREA_MAP_CHANNELS SA_MAP_CHNLS, SERVICE_AREA_PRINCIPAL_GROUP SA_PGROUP, CHANNEL_MAP_DETAILS CHMAP, CHANNELS CHNL WHERE SA_MAP_CHNLS.SK_SERVICE_AREA = SA_PGROUP.SK_SERVICE_AREA AND SA_MAP_CHNLS.SK_CHANNEL_MAP = CHMAP.SK_CHANNEL_MAP AND SA_MAP_CHNLS.SK_CHANNELS = CHNL.SK_CHANNELS AND SA_MAP_CHNLS. END_DATE IS NULL AND SA_PGROUP.PACKAGE_END_DATE IS NULL AND SA_MAP_CHNLS.PG_IC_END_DATE IS NULL AND CHMAP.END_DATE IS NULL MINUS SELECT MIR_SA_MAP_CHNLS.CALL_LETTERS, MIR_SA_MAP_CHNLS.TUNER_POSITION, MIR_SA_MAP_CHNLS.SERVICE_COLLECTION_GUID, MIR_SA_MAP_CHNLS.ELCTRNC_PRGRM_GUIDE_GUID, MIR_SA_MAP_CHNLS.CH_TO_CHMAP_IPTV_GUID, DECODE(MIR_SA_MAP_CHNLS.START_DATE, NULL, '01-JAN-1900', TO_CHAR(MIR_SA_MAP_CHNLS.START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))START_DATE, DECODE(MIR_SA_MAP_CHNLS .END_DATE, NULL, '01-JAN-1900', TO_CHAR(MIR_SA_MAP_CHNLS.END_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))END_DATE, DECODE(MIR_SA_MAP_CHNLS.LAST_MODIFY, NULL, '01-JAN-1900', TO_CHAR(MIR_SA_MAP_CHNLS.LAST_MODIFY, 'DD-MM-YYYY HH24:MI:SS.FF4'))LAST_MODIFY, DECODE(MIR_SA_MAP_CHNLS.PG_IC_START_DATE, NULL, '01-JAN-1900', TO_CHAR(MIR_SA_MAP_CHNLS.PG_IC_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))PG_IC_START_DATE, DECODE(MIR_SA_MAP_CHNLS.PG_IC_END_DATE, NULL, '01-JAN-1900', TO_CHAR(MIR_SA_MAP_CHNLS.PG_IC_END_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))PG_IC_END_DATE, MIR_SA_PGROUP.PRINCIPAL_GROUP_CODE, MIR_SA_PGROUP.VHO_CLLI_CODE, MIR_SA_PGROUP.DMA_NAME, MIR_SA_PGROUP.PACKAGE_BILLING_CODE, DECODE(MIR_SA_PGROUP.PACKAGE_START_DATE, NULL, '01-JAN-1900', TO_CHAR(MIR_SA_PGROUP.PACKAGE_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))PACKAGE_START_DATE, MIR_SA_PGROUP.PACKAGE_INCLUDES_HD_CONTENT, MIR_CHMAP.MAP_NAME, DECODE(MIR_CHMAP.START_DATE, NULL, '01-JAN-1900', TO_CHAR(MIR_CHMAP.START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4'))MIR_CHMAP_START_DATE, MIR_CHNL.CHANNEL_NAME, MIR_CHNL.CONTENT_TYPE FROM MIR_SA_MAP_CHANNELS MIR_SA_MAP_CHNLS, MIR_SA_PRINCIPAL_GROUP MIR_SA_PGROUP, MIR_CHMAP_DETAILS MIR_CHMAP, MIR_CHANNELS MIR_CHNL WHERE MIR_SA_MAP_CHNLS.SK_SERVICE_AREA = MIR_SA_PGROUP.SK_SERVICE_AREA AND MIR_SA_MAP_CHNLS.SK_CHANNEL_ MAP = MIR_CHMAP.SK_CHANNEL_MAP AND MIR_SA_MAP_CHNLS.SK_CHANNELS = MIR_CHNL.SK_CHANNELS)
3xycuhqtp1yfpUPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='737448' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059273_20110407123812.txt')
3yrgy45dtyrzt SELECT DISTINCT OM_ASSOC.SK_PKG_PGA_COL_ID, OM_ASSOC.VERSION_NUM, OM_SVC_COL.BK_SVC_COL_NM, OM_SVC_COL.BK_SVC_COL_TYPE, OM_PGROUP.PGROUP_NM, DECODE(UPPER(OM_PGROUP.PGROUP_HD_FEE_RQRD), 'YES', 'Y', 'NO', 'N') PGROUP_HD_FEE_RQRD, OM_ORD_PKG.BK_PKG_BLNG_CD, OM_PGA.BK_PGA_NAME, DECODE(UPPER(OM_ASSOC.FREE_PRVW_IND), 'YES', 'Y', 'NO', 'N') FREE_PRVW_IND, OM_ASSOC.STATUS, OM_ASSOC.START_DT, OM_ASSOC.END_DT, (SELECT COUNT (*) FROM REF_SC_FILTER_RULES WHERE FLTR_TABLE_NM= 'OM_PKG_PGA_COL_ASSOC') FILTER_COUNT FROM OM_SERVICE_COLLECTION OM_SVC_COL, OM_PKG_PGA_ASSOC, OM_PGROUP, OM_PKG_PGA_COL_ASSOC OM_ASSOC, OM_PRNCPL_GRP_AREA OM_PGA, OM_ORDERABLE_PKG OM_ORD_PKG WHERE OM_SVC_COL.SK_SVC_COL_ID=OM_ASSOC.SK_SVC_COL_ID AND OM_ASSOC.SK_PKG_ID= OM_PKG_PGA_ASSOC.SK_PKG_ID AND OM_ASSOC.SK_PGA_ID= OM_PKG_PGA_ASSOC.SK_PGA_ID AND OM_PKG_PGA_ASSOC.SK_PKG_PGA_ID=OM_PGROUP.FK_PKG_PGA_ID AND OM_ASSOC.SK_PGA_ID=OM_PGA.SK_PGA_ID AND OM_ASSOC.SK_PKG_ID=OM_ORD_PKG.SK_PKG_ID AND TRUNC(OM_ASSOC.START_DT) = TRUNC(SYSDATE) AND UPPER(OM_ASSOC.FREE_PRVW_IND)<>'YES' AND (UPPER(OM_SVC_COL.STATUS)='ACTIVE' AND 0=(SELECT COUNT(*) FROM OM_SERVICE_COLLECTION SVC_COL WHERE UPPER(SVC_COL.STATUS)='INACTIVE' AND SVC_COL.SK_SVC_COL_ID=OM_SVC_COL.SK_SVC_COL_ID)) AND (OM_SVC_COL.START_DT<=OM_ASSOC.START_DT AND (OM_SVC_COL.END_DT IS NULL OR OM_SVC_COL.END_DT>OM_ASSOC.START_DT)) AND (UPPER(OM_PKG_PGA_ASSOC.STATUS)='ACTIVE' AND 0=(SELECT COUNT(*) FROM OM_PKG_PGA_A SSOC PKG_PGA_ASSOC WHERE UPPER(PKG_PGA_ASSOC.STATUS)='INACTIVE' AND PKG_PGA_ASSOC.SK_PKG_PGA_ID=OM_PKG_PGA_ASSOC.SK_PKG_PGA_ID)) AND (OM_PKG_PGA_ASSOC.START_DT<=OM_ASSOC.START_DT AND (OM_PKG_PGA_ASSOC.END_DT IS NULL OR OM_PKG_PGA_ASSOC.END_DT>OM_ASSOC.START_DT)) AND (UPPER(OM_PGROUP.STATUS)='ACTIVE' AND 0=(SELECT COUNT(*) FROM OM_PGROUP PGRP WHERE UPPER(PGRP.STATUS)='INACTIVE' AND PGRP.SK_PGROUP_ID=OM_PGROUP.SK_PGROUP_ID)) AND OM_PGROUP.END_DT IS NULL AND OM_PGROUP.PGROUP_NM <> 'Not Known' AND OM_PGROUP.PGROUP_HD_FEE_RQRD = decode(OM_ASSOC.BK_HD_FEE_RQRD, 1, 'Yes', 0, 'No') AND (UPPER(OM_PGA.STATUS)='ACTIVE' AND 0=(SELECT COUNT(*) FROM OM_PRNCPL_GRP_AREA WHERE UPPER(OM_PRNCPL_GRP_AREA.STATUS)='INACTIVE' AND OM_PRNCPL_GRP_AREA.SK_PGA_ID=OM_PGA.SK_PGA_ID)) AND (OM_PGA.START_DT<=OM_ASSOC.START_DT AND (OM_PGA.END_DT IS NULL OR OM_PGA.END_DT>OM_ASSOC.START_DT)) AND (UPPER(OM_ORD_PKG.STATUS)='ACTIVE' AND 0=(SELECT COUNT(*) FROM OM_ORDERABLE_PKG ORD_PKG WHERE UPPER(ORD_PKG.STATUS)='INACTIVE' AND ORD_PKG.SK_PKG_ID=OM_ORD_PKG.SK_PKG_ID)) AND (OM_ORD_PKG.START_DT<=OM_ASSOC.START_DT AND (OM_ORD_PKG.END_DT IS NULL OR OM_ORD_PKG.END_DT>OM_ASSOC.START_DT))
431ukanuxc5ujSELECT DISTINCT TUNER_POSITION, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, CALL_LETTERS, MAP_NAME, MAP_AREA_NAME, VHO_CODE, DMA_NAME, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND PACKAGE_BILLING_CODE IN ('U100') and not exists (select 1 from UDAS_CHMAP_SER_DETAILS_V b left outer join (select * from ref_filter_package where upper(package_type)=upper(:3)) rbasic on b.package_billing_code=rbasic.package_billing_code , ref_filter_channel rchnl where a.zip_code=b.zip_code and a.map_type=b.map_type and a.package_billing_code=b.package_billing_code and a.vho_code=b.vho_code and a.channel_name=b.channel_name and b.channel_name=rchnl.channel_name and rbasic.package_billing_code is null) AND VHO_CODE=:4 GROUP BY MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE
4488b4fqp2vh5select dummy from dual where USER like 'SYS'
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4dwzcg8d9wnc0SELECT MAX(PCT_VSDA_USD_LOAD.SVCH_LAST_UPDATE_TS) SVCH_LAST_UPDATE_TS FROM PCT_VSDA_USD_LOAD WHERE PCT_VSDA_USD_LOAD.LOAD_STATUS='Successfull' and PCT_VSDA_USD_LOAD.MODULE_NM ='OMCM'
4dxyvxm331xb3SELECT a.inst_id, SUM (DECODE (NAME, 'db block changes', VALUE, 0)), SUM (DECODE (NAME, 'db block gets', VALUE, 0)), SUM (DECODE (NAME, 'consistent gets', VALUE, 0)), SUM (DECODE (NAME, 'physical reads', VALUE, 0)), SUM (DECODE (NAME, 'physical writes', VALUE, 0)), SUM (DECODE (NAME, 'redo writes', VALUE, 0)), SUM (DECODE (NAME, 'parse count (total)', VALUE, 0)), SUM (DECODE (NAME, 'execute count', VALUE, 0)), SUM (DECODE (NAME, 'user commits', VALUE, 0)), SUM (DECODE (NAME, 'user rollbacks', VALUE, 0)), host_name FROM gv$sysstat a, gv$instance b WHERE a.INST_ID = b.INST_ID and NAME IN ('db block changes', 'db block gets', 'consistent gets', 'physical reads', 'physical writes', 'redo writes', 'redo writes', 'parse count (total)', 'execute count', 'user commits', 'user rollbacks') GROUP BY a.inst_id, HOST_NAME order by inst_id
4fm9jy5xsacmuUPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='736931' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059261_20110407114929.txt')
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4tfmy24hppyh4SELECT STG_IPTV_CHMAP_SVC_SVCL_SEQ.NEXTVAL FROM DUAL
5ja8186ubypp9UPDATE PCT_VSDA_USD_LOAD SET LOAD_STATUS=:1, LOAD_END_TS=:2 WHERE PROC_ID=:3 AND MODULE_NM='OMCM'
5ngzsfstg8tmyselect o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
5pdgmjpnacak4INSERT INTO CODIE_TRANSACTION_LOG (CODIE_CLIENT_APP, CODIE_TRANS_STATUS, CODIE_CLIENT_REQUEST_TIME, CODIE_TRANS_DESCRIPTION, CODIE_METHOD_ID, CODIE_START_TIME, CODIE_END_TIME, SRC_IP_ADDR, SRC_MESSAGE_ID, METHOD_VERSION, FAILURE_SYSTEM, RESPONSE_CODE, REQUEST_PARAMETER, RESPONSE_DURATION, CODIE_TRANS_ID, HOST_NAME) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)
5qsu4hxv1rs6uupdate om_pkg_pga_prvdr_assoc set status = 'Inactive' where (VOD_OFFR_NOTES is null or VOD_OFFR_NOTES =:1) and VOD_OFFR_ACCESS_TYPE =:2 and (PRODUCT_VALUE is null or PRODUCT_VALUE =:3) and status = :4
5un910zs5681sDECLARE lcommand varchar(200); BEGIN EXECUTE IMMEDIATE 'alter session set workarea_size_policy=MANUAL'; EXECUTE IMMEDIATE 'alter session set sort_area_size=31457280'; END set_trace;
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6atcfr6wc0g4yselect 'DATAPOINT', nvl(min(nvl(b.bytes, 0)/1048576), 11) minfreespace, nvl(min(nvl(b.bytes, 0)/c.bytes*100), 111) minfreespacepct from (select distinct e.ts#, f.name from sys.seg$ e, sys.ts$ f where e.ts# = f.ts# and e.ts# > 0 and e.TYPE# = 1 and f.online$ = 1 ) a, (select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name ) b, (select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name ) c, (select ts# from p$obj_exclusion where file# is null and block# is null and user# is null ) d, (select tablespace_name from dba_data_files a, sys.filext$ b where a.file_id = b.file# ) g, (select tablespace_name from dba_rollback_segs where status = 'ONLINE' ) h where a.name = b.tablespace_name(+) and a.name = c.tablespace_name and a.ts# = d.ts#(+) and d.ts# is null and a.name = g.tablespace_name(+) and g.tablespace_name is null and a.name = h.tablespace_name
6dv0dpznx0dg9select VALUE from NLS_SESSION_PARAMETERS where PARAMETER='NLS_LENGTH_SEMANTICS'
6rsswhw400fa8SELECT DISTINCT PCT_VSDA_USD_LOAD.PROC_ID FROM PCT_VSDA_USD_LOAD WHERE PCT_VSDA_USD_LOAD.PROC_ID=17162001.000000000000000 AND PCT_VSDA_USD_LOAD.MODULE_NM='OMCM'
6uvzftsujw5s6 select /*NORULE */ 'DATA:'||A.FILE#||':'||A.BLOCK#||':' || A.MAX_EXT_SIZE||':'||B.MAX_BLOCKS_FREE||':'||A.TS#||':' NOHEAD from (SELECT /*NORULE */ TS#, FILE#, BLOCK#, MAX(decode(1, sign(trunc(blocks*8192 / (1048576*1024))), 67108864, sign(trunc(blocks*8192 / (67108864))), 8388608, sign(trunc(blocks*8192 / (1048576))), 1048576, sign(trunc(blocks*8192 / (65536))), 65536))/8192 MAX_EXT_SIZE FROM SYS.SEG$ GROUP BY TS#, FILE#, BLOCK#) A, (SELECT /*NORULE */ VB.NAME TABLESPACE_NAME, VB.TS#, MAX(nvl(VA.BLOCKS, 0)) MAX_BLOCKS_FREE FROM DBA_FREE_SPACE VA, SYS.TS$ VB WHERE VB.NAME = VA.TABLESPACE_NAME (+) AND VB.ONLINE$ != 3 GROUP BY VB.NAME, VB.TS#) B, (SELECT TS#, FILE#, BLOCK# FROM P$OBJ_EXCLUSION WHERE TS# IS NOT NULL AND FILE# IS NULL AND BLOCK# IS NULL) C, (SELECT TS#, FILE#, BLOCK# FROM P$OBJ_EXCLUSION WHERE TS# IS NOT NULL AND FILE# IS NOT NULL AND BLOCK# IS NOT NULL) S, (SELECT /*NORULE */ UA.TS# TS#, UA.FILE# FILE#, UA.BLOCK# BLOCK# FROM SYS.SEG$ UA, P$OBJ_EXCLUSION UB WHERE UB.USER# IS NOT NULL AND UA.USER# = UB.USER#) U, (SELECT A.TS# TS#, NULL FILE#, NULL BLOCK# FROM SYS.FILE$ A, SYS.FILEXT$ B WHERE A.FILE# = B.FILE#) D, (SELECT /*NORULE */ TABLESPACE_NAME FROM DBA_TABLESPACES WHERE STATUS = 'ONLINE' AND CONTENTS = 'PERMANENT' AND (EXTENT_MANAGEMENT = ' LOCAL' AND ALLOCATION_TYPE = 'SYSTEM')) E WHERE A.TS# = B.TS# AND A.MAX_EXT_SIZE > B.MAX_BLOCKS_FREE AND B.MAX_BLOCKS_FREE > 0 AND A.TS# = C.TS#(+) AND C.TS# IS NULL AND A.TS# = S.TS# (+) AND A.FILE# = S.FILE# (+) AND A.BLOCK# = S.BLOCK# (+) AND S.TS# IS NULL AND S.FILE# IS NULL AND S.BLOCK# IS NULL AND A.TS# = U.TS# (+) AND A.FILE# = U.FILE# (+) AND A.BLOCK# = U.BLOCK# (+) AND U.TS# IS NULL AND U.FILE# IS NULL AND U.BLOCK# IS NULL AND A.TS# = D.TS#(+) AND D.TS# IS NULL AND B.TABLESPACE_NAME = E.TABLESPACE_NAME
7frqszzdu8sggselect DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2
7g7j8txwnt5rqUPDATE BF_STG_PRCH_HSTRY SET IPTV_UPD_STATUS = :1, BE_STATE_ID = :2, LAST_UPDATE_TS = :3, WORKFLOW_RUN_ID = :4 WHERE PRINCIPAL_EXTERNAL_ID = :5 AND ASSET_BILLING_EVENT_ID = :6 AND ASSET_DEPLOYMENT_ID = :7 AND VHO_CLLI_CODE = :8
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7rh0x6utfz564UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='736640' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059249_20110407110456.txt')
7yffgbkjb5j55UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='737163' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059268_20110407121455.txt')
8vaak0p1tfc57SELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U100') and not exists (select 1 from UDAS_CHMAP_SER_DETAILS_V b left outer join (select * from ref_filter_package where upper(package_type)=upper(:3)) rbasic on b.package_billing_code=rbasic.package_billing_code , ref_filter_channel rchnl where a.zip_code=b.zip_code and a.map_type=b.map_type and a.package_billing_code=b.package_billing_code and a.vho_code=b.vho_code and a.channel_name=b.channel_name and b.channel_name=rchnl.channel_name and rbasic.package_billing_code is null) AND VHO_CODE=:4 GROUP BY MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE
932t85mdwkyjwUPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='736704' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059252_20110407111635.txt')
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
978j5sbkzfzzdselect dummy from dual where USER like 'DEXTER_APPID'
9p1um1wd886xbselect o.owner#, u.name, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property, 0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o, user$ u where d.p_obj#=:1 and (d.p_timestamp=:2 or d.property=2) and d.d_obj#=o.obj# and o.owner#=u.user# order by o.obj#
9qgtwh66xg6nzupdate seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
9v4t0d7nsvnyxINSERT INTO STG_TAX_CHILD_PACKAGE(PARENT_PACKAGE_ID, CHILD_PACKAGE_ID, PARENT_PACKAGE_NAME, VHO) VALUES ( :1, :2, :3, :4)
a12b5292h48vqselect /*NORULE */ 'DATAPOINT free_space ' bpb, decode(min((a.BYTES_FREE / b.BYTES) * 100), '', 'NULL', min((a.BYTES_FREE / b.BYTES) * 100)) from (select /*NORULE */ tfs_b.name tablespace_name, tfs_b.ts# ts#, sum(nvl(tfs_a.bytes, 0)) bytes_free from dba_free_space tfs_a, sys.ts$ tfs_b where tfs_b.name = tfs_a.tablespace_name (+) and tfs_b.online$ != 3 group by tfs_b.name, tfs_b.ts#) a, (select /*NORULE */ e.tablespace_name, sum(e.bytes) bytes from dba_data_files e, (select /*NORULE */ tablespace_name from dba_data_files where autoextensible = 'YES') f where e.tablespace_name = f.tablespace_name(+) and f.tablespace_name is null and e.autoextensible = 'NO' group by e.tablespace_name) b, DBA_TABLESPACES c, (SELECT /*NORULE */ TS# FROM P$OBJ_EXCLUSION WHERE OBJECT_TYPE = 'TABLE' AND FILE# IS NULL AND BLOCK# IS NULL) d where a.TABLESPACE_NAME = b.TABLESPACE_NAME and b.TABLESPACE_NAME = c.TABLESPACE_NAME and c.CONTENTS != 'TEMPORARY' and c.status = 'ONLINE' and a.TS# = d.TS#(+) and d.TS# is NULL and c.TABLESPACE_NAME != 'SYSTEM'
a3t2dv56rvvujSELECT DISTINCT TUNER_POSITION, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, CALL_LETTERS, MAP_NAME, MAP_AREA_NAME, VHO_CODE, DMA_NAME, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND PACKAGE_BILLING_CODE IN ('U200') and not exists (select 1 from UDAS_CHMAP_SER_DETAILS_V b left outer join (select * from ref_filter_package where upper(package_type)=upper(:3)) rbasic on b.package_billing_code=rbasic.package_billing_code , ref_filter_channel rchnl where a.zip_code=b.zip_code and a.map_type=b.map_type and a.package_billing_code=b.package_billing_code and a.vho_code=b.vho_code and a.channel_name=b.channel_name and b.channel_name=rchnl.channel_name and rbasic.package_billing_code is null) AND VHO_CODE=:4 GROUP BY MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE
avks59hug3swsSELECT DISTINCT PCT_VSDA_USD_LOAD.PROC_ID FROM PCT_VSDA_USD_LOAD WHERE PCT_VSDA_USD_LOAD.PROC_ID=17163001.000000000000000 AND PCT_VSDA_USD_LOAD.MODULE_NM='INC'
az9zjgfkgwqnnUPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='737163' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059267_20110407121455.txt')
b5dgb0j12ndtqINSERT INTO STG_IPTV_CHMAP_SVC_SVCL(VHO, SERVICECOLLECIONID, SERVICECOLLECTIONNAME, EPGID, CHANNELMAPSID, CHANNELMAPSNAME, SERVICEID, NAME, MAPID) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9)
b943xnx5pjgzgUPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='736640' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059247_20110407110101.txt')
bm28jpgutd5dtDELETE VOD_MDT_CONTENT WHERE PACKAGE_ID=:1
btzq46kta67dzupdate obj$ set obj#=:6, type#=:7, ctime=:8, mtime=:9, stime=:10, status=:11, dataobj#=:13, flags=:14, oid$=:15, spare1=:16, spare2=:17 where owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 or remoteowner is null and :4 is null)and(linkname=:5 or linkname is null and :5 is null)and(subname=:12 or subname is null and :12 is null)
cdfdzx8dduv4wSELECT BF_MART_MDT.STATUS AS STATUS, BF_MART_MDT.FILTER_COUNT AS FILTER_COUNT, BF_MART_MDT.VAL_FAILURE_COUNT AS VAL_FAILURE_COUNT, BF_MART_MDT.PPV_ASSET_START_DT AS PPV_ASSET_START_DT, BF_MART_MDT.PPV_ASSET_END_DT AS PPV_ASSET_END_DT, BF_MART_MDT.VHO_CLLI_CODE AS VHO_CLLI_CODE, BF_MART_MDT.ASSET_DEPLOYMENT_ID AS ASSET_DEPLOYMENT_ID FROM BF_MART_MDT INNER JOIN BF_VHO_REF ON BF_VHO_REF.VHO_CLLI_CODE= BF_MART_MDT.VHO_CLLI_CODE WHERE BF_VHO_REF.SESSION_NO=10 AND BF_MART_MDT.RESOURCE_TYPE<>'PPV' ORDER BY VHO_CLLI_CODE, ASSET_DEPLOYMENT_ID, STATUS, FILTER_COUNT, VAL_FAILURE_COUNT, PPV_ASSET_START_DT, PPV_ASSET_END_DT
cdk073dvj8vuaSELECT 1 FROM DUAL WHERE EXISTS (SELECT * FROM SC_SVC_CHANGE WHERE SVCH_MOD_REC_SK_VAL = :B3 AND SVCH_MOD_REC_COL_SK_NM = :B2 AND SVCH_STATUS = 'Pending' AND SVCH_MOD_TABLE_NM = :B1 )
cn1gtsav2d5jhBEGIN BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; END;
cqgv56fmuj63xselect owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
csgadz21m2mk0UPDATE STG_SERVICE SET SERVICE_NAME = :1, INTENT = :2, HINT = :3 WHERE SERVICE_ID = :4
d6914jbs6x455UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='736871' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059258_20110407113846.txt')
dcd705zj1j1mtINSERT INTO STG_SERVICE(PACKAGE_ID, SERVICE_ID, SERVICE_NAME, HINT) VALUES ( :1, :2, :3, :4)
f5ma6sr1cyd7mINSERT INTO STG_PROGRAMID_MAPPER(INTERNAL_PROGRAM_ID, CONTENT_ID, VHO_CLLI_CODE) VALUES ( :1, :2, :3)
f7cj89gbthsppDELETE FROM BF_STG_PRCH_HSTRY WHERE PRINCIPAL_EXTERNAL_ID = :1 AND ASSET_BILLING_EVENT_ID = :2 AND ASSET_DEPLOYMENT_ID = :3 AND VHO_CLLI_CODE = :4
f7h7zgxtbg0jkSELECT BK_BNDRY_POINT_DIGITS, BK_PGROUP_NM FROM ( SELECT DISTINCT STG_PGA_BOUNDARY_POINTS.BK_BNDRY_POINT_DIGITS, STG_PGA_BOUNDARY_POINTS.BK_PGROUP_NM FROM STG_PGA_BOUNDARY_POINTS MINUS SELECT DISTINCT LC_PGA_BOUNDARY_POINTS.BK_BNDRY_POINT_DIGITS, LC_PGA_BOUNDARY_POINTS.BK_PGROUP_NM FROM LC_PGA_BOUNDARY_POINTS)
f8jra2wc6r5x7SELECT TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID, COUNT(TUNER_POSITION) AS TUNERPOSITION FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U200') and not exists (select package_billing_code from ref_filter_package rbasic, ref_filter_channel rchnl WHERE a.package_billing_code=rbasic.package_billing_code(+) and upper(package_type)=upper(:3) AND a.channel_name =rchnl.channel_name AND rbasic.package_billing_code IS NULL AND a.channel_name =rchnl.channel_name) AND VHO_CODE=:4 GROUP BY TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID
fvk5x826hw6ggINSERT INTO BF_STG_PRCH_HSTRY(PRINCIPAL_EXTERNAL_ID, ASSET_BILLING_EVENT_ID, ASSET_DEPLOYMENT_ID, VHO_CLLI_CODE, PURCHASE_DT, PPV_ASSET_START_DT, PPV_ASSET_END_DT, SRC_VAL_STATUS, SRC_VAL_FAILURE_COUNT, IPTV_UPD_STATUS, IPTV_UPD_FAILURE_COUNT, BE_STATE_ID, LAST_UPDATE_TS, WORKFLOW_RUN_ID, PRICE) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15)
g00cj285jmgswupdate sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g527v48drgf0j SELECT BF_MART_PRCH_HSTRY.PRINCIPAL_EXTERNAL_ID, BF_MART_PRCH_HSTRY.ASSET_BILLING_EVENT_ID, BF_MART_PRCH_HSTRY.ASSET_DEPLOYMENT_ID, BF_MART_PRCH_HSTRY.PURCHASE_DT, BF_MART_PRCH_HSTRY.PPV_ASSET_START_DT, BF_MART_PRCH_HSTRY.PPV_ASSET_END_DT, BF_MART_PRCH_HSTRY.RESOURCE_NAME, BF_MART_PRCH_HSTRY.PROVIDER_ASSET_ID, BF_MART_PRCH_HSTRY.PURCHASE_AMOUNT, BF_MART_PRCH_HSTRY.GENRE, BF_MART_PRCH_HSTRY.RESOURCE_TYPE, BF_MART_PRCH_HSTRY.ADULT_CONTENT_IND, BF_MART_PRCH_HSTRY.DISCOUNT_AMOUNT, BF_MART_PRCH_HSTRY.BILLED_AMOUNT, BF_MART_PRCH_HSTRY.VERSION_NUM, BF_MART_PRCH_HSTRY.OVERLAY_ASSET_TITLE, DISCOUNT_COUPON.COUPON_CD, DISCOUNT_COUPON.COUPON_DESC, DISCOUNT_COUPON.COUPON_EXTERNAL_ID, DISCOUNT_COUPON.COUPON_NM, DISCOUNT_COUPON.COUPON_TYPE, DISCOUNT_COUPON.COUPON_VALUE, ASSET_COUPON_ASSOC.COUPON_APPLIED_DT FROM BF_MART_PRCH_HSTRY LEFT OUTER JOIN ASSET_COUPON_ASSOC ON BF_MART_PRCH_HSTRY.PRINCIPAL_EXTERNAL_ID=ASSET_COUPON_ASSOC.PRINCIPAL_EXTERNAL_ID AND BF_MART_PRCH_HSTRY.ASSET_BILLING_EVENT_ID=ASSET_COUPON_ASSOC.ASSET_BILLING_EVENT_ID AND BF_MART_PRCH_HSTRY.ASSET_DEPLOYMENT_ID=ASSET_COUPON_ASSOC.ASSET_DEPLOYMENT_ID LEFT OUTER JOIN DISCOUNT_COUPON ON ASSET_COUPON_ASSOC.SK_COUPON_ID=DISCOUNT_COUPON.SK_COUPON_ID WHERE BF_MART_PRCH_HSTRY.BE_STATE_ID=9 AND BF_MART_PRCH_HSTRY.RESOURCE_TYPE=' VOD' AND BF_MART_PRCH_HSTRY.UAR_SRC_STATUS='N'AND BF_MART_PRCH_HSTRY.CSF_SRC_STATUS=( CASE WHEN BF_MART_PRCH_HSTRY.BILLED_AMOUNT=0 THEN 0 ELSE 1 END)
gquasqp1c85d0insert into OM_VHO_SVC_COL_ASSOC (version_num, sk_vho_id, SK_SVC_COL_ID, SK_SVC_ID, SVC_COL_SVC_SEQ, SVC_ORDER, last_update_ts, update_method, last_update_user_id, status, start_dt, end_dt, SK_VHO_SVC_COL_ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 602,991 84.14 22.97
CPU used when call started 601,735 83.96 22.92
CR blocks created 17,679 2.47 0.67
Cached Commit SCN referenced 8,726 1.22 0.33
Commit SCN cached 2 0.00 0.00
DB time 7,224,215 1,008.01 275.21
DBWR checkpoint buffers written 286,600 39.99 10.92
DBWR checkpoints 3,090 0.43 0.12
DBWR fusion writes 385,444 53.78 14.68
DBWR object drop buffers written 11,565 1.61 0.44
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 1,808 0.25 0.07
DBWR undo block writes 271,076 37.82 10.33
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 48 0.01 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 204 0.03 0.01
PX local messages sent 204 0.03 0.01
PX remote messages recv'd 2,425 0.34 0.09
PX remote messages sent 1,606 0.22 0.06
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 48 0.01 0.00
RowCR - row contention 392 0.05 0.01
RowCR attempts 19,537 2.73 0.74
RowCR hits 19,143 2.67 0.73
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 35 0.00 0.00
SQL*Net roundtrips to/from client 858,299 119.76 32.70
active txn count during cleanout 366,544 51.14 13.96
application wait time 77,630 10.83 2.96
background checkpoints completed 7 0.00 0.00
background checkpoints started 8 0.00 0.00
background timeouts 38,793 5.41 1.48
branch node splits 155 0.02 0.01
buffer is not pinned count 30,049,051 4,192.82 1,144.73
buffer is pinned count 118,338,433 16,512.04 4,508.13
bytes received via SQL*Net from client 2,207,613,781 308,033.62 84,099.57
bytes sent via SQL*Net to client 935,697,732 130,560.14 35,645.63
calls to get snapshot scn: kcmgss 3,236,674 451.62 123.30
calls to kcmgas 2,392,418 333.82 91.14
calls to kcmgcs 310,212 43.28 11.82
change write time 120,234 16.78 4.58
cleanout - number of ktugct calls 457,288 63.81 17.42
cleanouts and rollbacks - consistent read gets 4,831 0.67 0.18
cleanouts only - consistent read gets 7,211 1.01 0.27
cluster key scan block gets 349,473 48.76 13.31
cluster key scans 297,860 41.56 11.35
cluster wait time 4,018,775 560.75 153.10
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 458 0.06 0.02
commit batch/immediate requested 458 0.06 0.02
commit cleanout failures: block lost 163,961 22.88 6.25
commit cleanout failures: buffer being written 1,947 0.27 0.07
commit cleanout failures: callback failure 11,266 1.57 0.43
commit cleanout failures: cannot pin 3,366 0.47 0.13
commit cleanouts 2,592,646 361.76 98.77
commit cleanouts successfully completed 2,410,069 336.28 91.81
commit immediate performed 458 0.06 0.02
commit immediate requested 458 0.06 0.02
commit txn count during cleanout 779,097 108.71 29.68
concurrency wait time 128,589 17.94 4.90
consistent changes 108,635 15.16 4.14
consistent gets 158,878,043 22,168.63 6,052.50
consistent gets - examination 11,050,973 1,541.97 420.99
consistent gets direct 3 0.00 0.00
consistent gets from cache 158,878,040 22,168.63 6,052.50
current blocks converted for CR 95 0.01 0.00
cursor authentications 467 0.07 0.02
data blocks consistent reads - undo records applied 86,400 12.06 3.29
db block changes 23,283,404 3,248.79 886.99
db block gets 44,765,451 6,246.23 1,705.35
db block gets direct 190 0.03 0.01
db block gets from cache 44,765,261 6,246.20 1,705.34
deferred (CURRENT) block cleanout applications 315,364 44.00 12.01
dirty buffers inspected 424,143 59.18 16.16
enqueue conversions 21,902 3.06 0.83
enqueue deadlocks 0 0.00 0.00
enqueue releases 914,061 127.54 34.82
enqueue requests 916,415 127.87 34.91
enqueue timeouts 2,334 0.33 0.09
enqueue waits 27,648 3.86 1.05
exchange deadlocks 15,842 2.21 0.60
execute count 2,621,159 365.74 99.85
failed probes on index block reclamation 1 0.00 0.00
flashback log writes 15,328 2.14 0.58
free buffer inspected 16,626,642 2,319.96 633.40
free buffer requested 16,129,708 2,250.62 614.47
gc CPU used by this session 203,578 28.41 7.76
gc blocks lost 21 0.00 0.00
gc cr block build time 401 0.06 0.02
gc cr block flush time 170,220 23.75 6.48
gc cr block receive time 325,904 45.47 12.42
gc cr block send time 490 0.07 0.02
gc cr blocks received 94,305 13.16 3.59
gc cr blocks served 130,997 18.28 4.99
gc current block flush time 565,939 78.97 21.56
gc current block pin time 33,063 4.61 1.26
gc current block receive time 2,603,675 363.30 99.19
gc current block send time 7,297 1.02 0.28
gc current blocks received 8,019,163 1,118.93 305.49
gc current blocks served 1,922,519 268.25 73.24
gc local grants 3,717,909 518.77 141.63
gc remote grants 4,264,936 595.10 162.47
gcs messages sent 23,559,326 3,287.29 897.50
ges messages sent 179,009 24.98 6.82
global enqueue get time 176,467 24.62 6.72
global enqueue gets async 106,228 14.82 4.05
global enqueue gets sync 462,180 64.49 17.61
global enqueue releases 343,394 47.91 13.08
heap block compress 254,312 35.48 9.69
hot buffers moved to head of LRU 1,311,608 183.01 49.97
immediate (CR) block cleanout applications 12,054 1.68 0.46
immediate (CURRENT) block cleanout applications 190,561 26.59 7.26
index crx upgrade (found) 20 0.00 0.00
index crx upgrade (positioned) 16,807 2.35 0.64
index fast full scans (full) 815 0.11 0.03
index fetch by key 7,544,490 1,052.70 287.41
index scans kdiixs1 895,020 124.88 34.10
leaf node 90-10 splits 3,735 0.52 0.14
leaf node splits 50,660 7.07 1.93
lob reads 33 0.00 0.00
lob writes 192 0.03 0.01
lob writes unaligned 192 0.03 0.01
logons cumulative 10,813 1.51 0.41
messages received 418,910 58.45 15.96
messages sent 418,525 58.40 15.94
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 146,833,227 20,487.99 5,593.65
opened cursors cumulative 511,037 71.31 19.47
parse count (failures) 5,072 0.71 0.19
parse count (hard) 11,073 1.55 0.42
parse count (total) 690,313 96.32 26.30
parse time cpu 2,801 0.39 0.11
parse time elapsed 7,389 1.03 0.28
physical read IO requests 4,293,877 599.13 163.58
physical read bytes 82,700,296,192 11,539,369.58 3,150,487.47
physical read total IO requests 4,447,776 620.61 169.44
physical read total bytes 92,807,675,392 12,949,676.30 3,535,530.49
physical read total multi block requests 458,356 63.96 17.46
physical reads 10,095,251 1,408.61 384.58
physical reads cache 7,964,740 1,111.34 303.42
physical reads cache prefetch 6,263,457 873.96 238.61
physical reads direct 2,130,509 297.28 81.16
physical reads direct (lob) 4 0.00 0.00
physical reads direct temporary tablespace 2,127,565 296.86 81.05
physical reads for flashback new 394,793 55.09 15.04
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 2,850,932 397.80 108.61
physical write bytes 27,485,814,784 3,835,161.29 1,047,078.66
physical write total IO requests 3,000,531 418.67 114.31
physical write total bytes 58,699,838,976 8,190,528.54 2,236,184.34
physical write total multi block requests 305,101 42.57 11.62
physical writes 3,355,202 468.16 127.82
physical writes direct 2,128,589 297.01 81.09
physical writes direct (lob) 2 0.00 0.00
physical writes direct temporary tablespace 2,127,559 296.86 81.05
physical writes from cache 1,226,613 171.15 46.73
physical writes non checkpoint 3,204,668 447.15 122.08
pinned buffers inspected 28,587 3.99 1.09
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 572 0.08 0.02
process last non-idle time 7,166 1.00 0.27
queries parallelized 36 0.01 0.00
recovery blocks read 2 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 7,143,005 996.68 272.11
recursive cpu usage 157,265 21.94 5.99
redo blocks read for recovery 0 0.00 0.00
redo blocks written 12,525,002 1,747.64 477.14
redo buffer allocation retries 15,592 2.18 0.59
redo entries 12,385,058 1,728.12 471.81
redo log space requests 2,910 0.41 0.11
redo log space wait time 1,953 0.27 0.07
redo ordering marks 166,170 23.19 6.33
redo size 6,195,248,828 864,437.85 236,009.48
redo subscn max counts 25,523 3.56 0.97
redo synch time 798,930 111.48 30.44
redo synch writes 38,821 5.42 1.48
redo wastage 17,437,528 2,433.10 664.29
redo write time 12,731 1.78 0.48
redo writer latching time 538 0.08 0.02
redo writes 55,123 7.69 2.10
rollback changes - undo records applied 348,088 48.57 13.26
rollbacks only - consistent read gets 5,282 0.74 0.20
rows fetched via callback 3,853,716 537.72 146.81
session connect time 0 0.00 0.00
session cursor cache hits 492,896 68.77 18.78
session logical reads 203,643,502 28,414.86 7,757.85
session pga memory 1,632,174,184 227,741.16 62,178.06
session pga memory max 4,109,762,664 573,444.99 156,562.39
session uga memory 17,504,794,560 2,442,485.74 666,849.32
session uga memory max 5,577,132,832 778,190.65 212,462.20
shared hash latch upgrades - no wait 80,446 11.22 3.06
shared hash latch upgrades - wait 175 0.02 0.01
sorts (disk) 407 0.06 0.02
sorts (memory) 89,881 12.54 3.42
sorts (rows) 28,670,191 4,000.42 1,092.20
sql area evicted 5,972 0.83 0.23
sql area purged 5,849 0.82 0.22
summed dirty queue length 1,719,622 239.94 65.51
switch current to new buffer 9,940 1.39 0.38
table fetch by rowid 68,442,260 9,549.91 2,607.32
table fetch continued row 960,567 134.03 36.59
table scan blocks gotten 107,254,643 14,965.50 4,085.89
table scan rows gotten 3,739,361,428 521,762.02 142,451.86
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 4,954 0.69 0.19
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 107,816 15.04 4.11
total number of times SMON posted 4,093 0.57 0.16
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 458 0.06 0.02
transaction tables consistent read rollbacks 99 0.01 0.00
transaction tables consistent reads - undo records applied 10,066 1.40 0.38
undo change vector size 1,725,712,620 240,792.80 65,741.43
user I/O wait time 566,346 79.02 21.58
user calls 927,247 129.38 35.32
user commits 18,862 2.63 0.72
user rollbacks 7,388 1.03 0.28
workarea executions - multipass 518 0.07 0.02
workarea executions - onepass 126 0.02 0.00
workarea executions - optimal 72,101 10.06 2.75
write clones created in background 5,459 0.76 0.21
write clones created in foreground 1,286 0.18 0.05

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 66,261,172 66,417,729
opened cursors current 339 429
logons current 71 102

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 8 4.02

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
TEMP 2,123,332 296 0.00 1.00 2,127,576 297 0 0.00
UDAS_DAT 1,214,612 169 1.95 5.07 114,273 16 137,668 2.59
UDAS_IDX 126,239 18 1.47 1.00 504,701 70 13,955 124.31
VSDA_DAT 540,847 75 0.37 2.58 12,118 2 5,156 2.72
UNDOTBS1 266,573 37 1.08 1.00 75,986 11 977 0.53
CODIE_TRANS_DAT 14,467 2 7.22 1.00 14,179 2 7,583 576.79
SYSTEM 2,087 0 4.49 1.83 1,221 0 25,748 321.59
SYSAUX 2,224 0 4.49 1.21 917 0 0 0.00
UNDOTBS3 2,101 0 2.80 1.00 29 0 623 19.28
UNDOTBS2 947 0 1.91 1.00 30 0 685 61.15
TOOLS 461 0 2.15 1.10 284 0 0 0.00
USERS 4 0 0.00 1.00 4 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
CODIE_TRANS_DAT +DBGRP1/udas2pdb_dg4/datafile/codie_trans_dat.275.74 2,853 0 7.12 1.00 2,742 0 1,464 656.35
CODIE_TRANS_DAT +DBGRP1/udas2pdb_dg4/datafile/codie_trans_dat.277.74 2,834 0 7.42 1.00 2,823 0 532 506.82
CODIE_TRANS_DAT +DBGRP1/udas2pdb_dg4/datafile/codie_trans_dat.278.74 2,742 0 7.39 1.00 2,695 0 3,067 583.23
CODIE_TRANS_DAT +DBGRP1/udas2pdb_dg4/datafile/codie_trans_dat.281.74 2,936 0 7.00 1.00 2,923 0 1,009 511.47
CODIE_TRANS_DAT +DBGRP1/udas2pdb_dg4/datafile/codie_trans_dat.375.74 3,102 0 7.20 1.00 2,996 0 1,511 554.90
SYSAUX +DBGRP1/udas2pdb_dg4/datafile/sysaux.282.742840415 2,224 0 4.49 1.21 917 0 0 0.00
SYSTEM +DBGRP1/udas2pdb_dg4/datafile/system.269.742841387 2,087 0 4.49 1.83 1,221 0 25,748 321.59
TEMP +DBGRP1/udas2pdb_dg4/tempfile/temp.405.743516261 142,104 20 0.00 1.00 142,494 20 0  
TEMP +DBGRP1/udas2pdb_dg4/tempfile/temp.406.743516265 299,800 42 0.00 1.00 300,185 42 0  
TEMP +DBGRP1/udas2pdb_dg4/tempfile/temp.407.743516267 880,405 123 0.00 1.00 880,729 123 0  
TEMP +DBGRP1/udas2pdb_dg4/tempfile/temp.408.743516269 66,854 9 0.00 1.01 67,804 9 0  
TEMP +DBGRP1/udas2pdb_dg4/tempfile/temp.409.743516269 734,169 102 0.00 1.00 736,364 103 0  
TOOLS +DBGRP1/udas2pdb_dg4/datafile/tools.268.742841393 192 0 1.77 1.15 119 0 0 0.00
TOOLS +DBGRP1/udas2pdb_dg4/datafile/tools.270.742841269 269 0 2.42 1.06 165 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.261.742841591 17,223 2 2.58 6.38 610 0 10,270 1.09
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.262.742841589 24,457 3 2.01 4.47 2,055 0 2,698 1.26
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.263.742841587 28,235 4 1.88 3.58 7,274 1 2,506 2.62
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.264.742841585 22,386 3 2.09 4.40 2,638 0 10,364 1.53
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.265.742841583 14,875 2 2.50 6.34 1,424 0 8,708 2.68
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.266.742841581 13,919 2 2.46 6.38 581 0 9,930 2.47
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.286.742840209 14,696 2 2.01 7.05 201 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.287.742840157 24,884 3 1.86 5.68 189 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.290.742839219 11,103 2 2.84 10.67 293 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.291.742839009 23,903 3 2.12 6.33 359 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.292.742838971 15,019 2 2.45 9.86 324 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.293.742838959 13,170 2 2.71 10.42 327 0 599 0.73
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.294.742838939 17,008 2 2.37 9.41 421 0 364 1.07
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.295.742838903 14,093 2 2.66 10.83 416 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.296.742838891 978 0 3.23 1.83 345 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.297.742838889 16,275 2 2.18 8.14 320 0 786 0.76
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.298.742838877 20,801 3 2.54 10.82 372 0 372 1.02
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.299.742838841 3,585 1 3.06 11.87 330 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.300.742838835 872 0 2.96 1.61 310 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.301.742838793 671 0 4.17 1.88 344 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.302.742838787 4,676 1 2.41 1.86 763 0 18 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.303.742837971 7,110 1 1.20 1.57 710 0 410 1.05
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.305.742837847 4,146 1 2.11 2.10 966 0 439 1.07
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.306.742837701 6,561 1 1.34 1.48 884 0 662 0.97
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.307.742837005 5,038 1 2.44 5.71 1,161 0 48 1.46
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.308.742836991 5,224 1 1.58 1.79 1,229 0 240 1.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.309.742836967 9,942 1 2.82 7.95 1,371 0 69 26.38
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.310.742836963 10,554 1 2.77 7.44 1,343 0 37 1.35
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.311.742836939 10,277 1 2.71 8.10 1,315 0 51 1.18
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.312.742836937 9,236 1 2.94 8.37 1,217 0 50 1.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.313.742836901 9,616 1 3.11 8.06 1,300 0 40 0.75
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.314.742836885 7,108 1 2.39 5.20 1,228 0 50 1.60
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.315.742836845 10,326 1 3.01 9.67 1,492 0 127 72.76
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.316.742836833 12,783 2 3.30 7.67 3,441 0 211 1.28
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.317.742836811 11,114 2 2.94 9.25 849 0 40 2.50
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.318.742836781 10,730 1 3.03 9.16 647 0 41 0.49
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.319.742835963 10,397 1 3.01 9.22 662 0 23 2.61
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.322.742835955 10,834 2 2.98 8.83 683 0 77 122.60
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.337.742834135 11,158 2 3.21 9.01 675 0 10,740 1.08
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.338.742834135 12,281 2 2.95 8.03 609 0 11,261 1.15
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.339.742834133 21,116 3 2.29 5.19 1,340 0 2,539 1.16
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.340.742834133 15,901 2 2.61 6.43 697 0 3,145 1.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.341.742834131 29,606 4 1.93 3.66 8,445 1 2,374 1.18
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.342.742834131 22,591 3 2.21 4.60 3,464 0 2,521 1.32
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.343.742834129 28,034 4 1.89 3.67 4,952 1 11,479 1.72
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.344.742834129 29,614 4 1.86 3.53 6,588 1 2,613 5.87
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.345.742834127 13,731 2 2.91 6.71 1,706 0 10,537 1.29
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.346.742834127 17,313 2 2.50 5.35 3,413 0 10,420 1.36
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.347.742844289 10,045 1 2.53 9.30 642 0 39 2.31
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.351.742834125 16,126 2 2.56 5.60 1,599 0 8,408 1.24
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.352.742834125 18,845 3 2.39 4.91 2,127 0 8,582 1.22
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.357.742844311 11,400 2 2.42 9.19 942 0 153 3.92
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.358.742844353 11,928 2 2.18 7.44 1,300 0 135 1.41
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.359.742844409 8,444 1 2.01 4.83 1,217 0 60 6.67
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.360.742844445 8,876 1 2.40 9.10 1,226 0 99 67.47
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.361.742844471 6,440 1 2.01 7.19 1,253 0 67 1.04
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.362.742844499 6,115 1 1.37 1.39 918 0 233 1.20
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.363.742845327 6,936 1 1.53 1.69 826 0 430 1.14
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.364.742846439 4,962 1 2.27 2.35 762 0 30 17.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.365.742846457 704 0 3.59 1.86 335 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.366.742846475 23,771 3 1.19 7.92 356 0 371 1.56
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.367.742846521 17,343 2 1.65 11.57 347 0 473 0.80
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.368.742846571 25,138 4 0.93 6.12 338 0 832 2.25
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.369.742846581 13,033 2 1.68 11.56 371 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.370.742846597 21,032 3 1.51 7.12 1,521 0 49 14.69
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.400.743345493 337 0 2.70 2.75 247 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.401.743345515 311 0 2.38 2.90 194 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.402.743345537 368 0 3.21 2.65 321 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.403.743345559 412 0 2.52 2.43 272 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.404.743345581 587 0 1.75 1.96 268 0 2 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.410.743518945 469 0 2.45 2.72 270 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.411.743518965 511 0 2.02 2.44 231 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.412.743518985 497 0 1.79 2.42 260 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.413.743519007 523 0 1.80 2.32 233 0 2 280.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.414.743519027 540 0 2.09 1.87 217 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.415.743519047 354 0 2.51 2.38 201 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.416.743519069 318 0 2.61 2.48 113 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.417.743519089 308 0 3.54 2.53 155 0 46 13.26
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.418.743519109 1,911 0 2.32 1.24 635 0 349 142.38
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.419.743519131 10,552 1 1.25 1.12 88 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.420.743519151 11,195 2 1.40 1.12 102 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.421.743519171 11,875 2 1.33 1.30 347 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.422.743519193 11,328 2 1.31 1.32 299 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.423.743519213 7,142 1 1.16 1.49 405 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.424.743519231 4,207 1 1.47 1.85 1,118 0 59 211.02
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.425.743519297 2,678 0 1.85 2.28 1,073 0 107 148.50
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.426.743519319 3,249 0 2.33 2.04 1,725 0 189 168.94
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.427.743519339 2,426 0 1.24 2.46 584 0 1 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.428.743519359 2,394 0 1.18 2.26 534 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.429.743519381 2,400 0 1.18 1.96 370 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.430.743519401 2,371 0 1.14 2.00 524 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.431.743519421 2,355 0 1.13 2.02 596 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.432.743519441 2,427 0 1.26 1.94 812 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.433.743519461 2,744 0 1.12 1.83 891 0 1 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.434.743519481 1,257 0 1.47 2.85 623 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.435.743519503 1,355 0 1.17 2.18 461 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.436.743519523 1,357 0 0.99 1.75 424 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.437.743519543 1,219 0 0.96 1.79 580 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.438.743519563 2,814 0 1.00 1.34 1,553 0 4 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.439.743519583 1,654 0 0.96 1.58 1,390 0 1 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.440.743519617 2,261 0 1.15 1.42 838 0 1 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.441.743519637 1,636 0 0.92 1.58 559 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.442.743519655 1,927 0 1.02 1.37 402 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.443.743519677 4,527 1 1.28 1.00 74 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.444.743519697 16,389 2 1.16 1.00 5 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.445.743519717 17,488 2 1.08 1.00 343 0 6 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.446.743519739 10,783 2 1.31 1.00 613 0 5 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.447.743519759 12,331 2 1.26 1.00 278 0 8 6.25
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.448.743519779 11,172 2 1.13 1.00 211 0 4 52.50
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.449.743519801 12,616 2 1.14 1.00 48 0 1 70.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.450.743519821 10,959 2 1.26 1.00 725 0 0 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.451.743519843 17,885 2 1.15 1.00 883 0 4 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.452.743519863 16,670 2 1.12 1.00 117 0 5 54.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.453.743519883 17,990 3 1.09 1.00 294 0 24 1.25
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.454.743519905 17,268 2 1.12 1.00 260 0 1 10.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.455.743520171 18,415 3 1.07 1.00 440 0 16 86.88
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.456.743520193 18,500 3 1.15 1.00 544 0 3 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.457.743520213 17,560 2 1.14 1.00 220 0 4 50.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.458.743520233 14,722 2 1.15 1.00 357 0 1 0.00
UDAS_DAT +DBGRP1/udas2pdb_dg4/datafile/udas_dat.459.743520253 10,760 2 1.10 1.00 583 0 4 0.00
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.271.742841221 11,698 2 1.64 1.00 38,962 5 710 258.51
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.272.742841097 10,348 1 1.47 1.00 41,465 6 1,573 134.34
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.273.742841081 12,019 2 1.50 1.00 46,844 7 1,398 87.68
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.274.742841001 10,314 1 1.59 1.00 41,173 6 588 140.22
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.276.742840583 10,943 2 1.56 1.00 44,092 6 967 104.86
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.279.742840529 10,113 1 1.56 1.00 46,983 7 2,937 104.67
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.376.742848169 11,542 2 1.52 1.00 46,172 6 1,299 144.69
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.377.742848441 9,798 1 1.54 1.00 43,803 6 1,070 124.39
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.378.742848673 9,346 1 1.47 1.00 39,562 6 1,480 160.30
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.460.743520285 10,009 1 1.30 1.00 37,000 5 579 124.02
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.461.743520305 10,591 1 1.22 1.00 36,986 5 204 94.56
UDAS_IDX +DBGRP1/udas2pdb_dg4/datafile/udas_idx.462.743520325 9,518 1 1.29 1.00 41,659 6 1,150 66.63
UNDOTBS1 +DBGRP1/udas2pdb_dg4/datafile/undotbs1.284.742840369 41,036 6 1.09 1.00 10,753 2 28 0.36
UNDOTBS1 +DBGRP1/udas2pdb_dg4/datafile/undotbs1.289.742839381 48,510 7 1.11 1.00 12,705 2 31 0.00
UNDOTBS1 +DBGRP1/udas2pdb_dg4/datafile/undotbs1.353.742834115 51,426 7 1.14 1.00 15,569 2 805 0.57
UNDOTBS1 +DBGRP1/udas2pdb_dg4/datafile/undotbs1.371.742846793 40,729 6 1.07 1.00 10,241 1 45 0.89
UNDOTBS1 +DBGRP1/udas2pdb_dg4/datafile/undotbs1.463.745748923 38,949 5 1.03 1.00 12,126 2 42 0.00
UNDOTBS1 +DBGRP1/udas2pdb_dg4/datafile/undotbs1.464.745748947 45,923 6 1.04 1.00 14,592 2 26 0.38
UNDOTBS2 +DBGRP1/udas2pdb_dg4/datafile/undotbs2.283.742840407 277 0 2.60 1.00 6 0 78 11.67
UNDOTBS2 +DBGRP1/udas2pdb_dg4/datafile/undotbs2.288.742839893 100 0 2.60 1.00 6 0 81 26.42
UNDOTBS2 +DBGRP1/udas2pdb_dg4/datafile/undotbs2.354.742834115 94 0 1.91 1.00 4 0 274 139.38
UNDOTBS2 +DBGRP1/udas2pdb_dg4/datafile/undotbs2.372.742847719 39 0 0.26 1.00 6 0 98 3.27
UNDOTBS2 +DBGRP1/udas2pdb_dg4/datafile/undotbs2.465.745748987 297 0 1.18 1.00 4 0 68 1.47
UNDOTBS2 +DBGRP1/udas2pdb_dg4/datafile/undotbs2.466.745749015 140 0 2.07 1.00 4 0 86 2.67
UNDOTBS3 +DBGRP1/udas2pdb_dg4/datafile/undotbs3.267.742841571 1,620 0 3.04 1.00 4 0 488 24.14
UNDOTBS3 +DBGRP1/udas2pdb_dg4/datafile/undotbs3.280.742840521 27 0 0.00 1.00 5 0 14 1.43
UNDOTBS3 +DBGRP1/udas2pdb_dg4/datafile/undotbs3.285.742840285 74 0 1.89 1.00 6 0 36 1.11
UNDOTBS3 +DBGRP1/udas2pdb_dg4/datafile/undotbs3.373.742848085 263 0 2.24 1.00 6 0 34 1.47
UNDOTBS3 +DBGRP1/udas2pdb_dg4/datafile/undotbs3.467.745749055 61 0 2.79 1.00 4 0 29 1.38
UNDOTBS3 +DBGRP1/udas2pdb_dg4/datafile/undotbs3.468.745749083 56 0 1.25 1.00 4 0 22 3.64
USERS +DBGRP1/udas2pdb_dg4/datafile/users.374.742848119 4 0 0.00 1.00 4 0 0 0.00
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.256.742843381 27,562 4 0.44 3.09 77 0 272 1.32
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.257.742843377 24,845 3 0.44 3.05 82 0 254 1.61
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.258.742843325 29,097 4 0.33 2.70 36 0 268 1.60
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.259.742842429 35,039 5 0.23 2.06 21 0 300 1.77
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.260.742841593 7,868 1 0.46 2.62 56 0 111 1.26
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.304.742843383 33,302 5 0.34 2.49 157 0 316 17.78
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.320.742835961 7,702 1 0.43 2.53 6 0 103 1.94
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.321.742835959 8,338 1 0.46 2.45 6 0 86 2.33
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.323.742835955 8,640 1 0.50 2.38 38 0 87 1.38
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.324.742835951 7,962 1 0.43 2.42 28 0 92 2.28
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.325.742835951 28,902 4 0.40 3.07 60 0 280 1.86
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.326.742835949 27,337 4 0.37 2.87 33 0 266 1.62
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.327.742835947 8,274 1 0.40 2.41 11 0 117 1.88
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.328.742835943 7,492 1 0.64 2.71 7 0 91 2.31
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.329.742835941 31,741 4 0.33 2.77 21 0 283 1.73
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.330.742835935 26,590 4 0.44 3.21 7 0 276 1.74
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.331.742835849 27,314 4 0.33 2.79 48 0 259 2.05
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.332.742835825 30,909 4 0.29 2.47 38 0 263 1.79
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.333.742834975 28,160 4 0.32 2.75 137 0 263 1.86
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.334.742834965 30,313 4 0.30 2.46 145 0 259 1.85
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.335.742834139 28,911 4 0.29 2.25 53 0 305 1.77
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.336.742834139 35,289 5 0.22 2.00 15 0 305 1.74
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.348.742843395 22,511 3 0.68 1.58 11,024 2 97 1.13
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.349.742843391 7,892 1 0.42 2.50 7 0 112 1.79
VSDA_DAT +DBGRP1/udas2pdb_dg4/datafile/vsda_dat.350.742843387 8,857 1 0.46 2.40 5 0 91 1.43

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 274,343 96 203,581,216 7,964,617 1,226,613 0 0 193,219


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 115 28319 1153029 2115029 3686400 2115029  
E 0 46 45381 1057000 3686400 3686400 6176130  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 224 0.10 26,866 1.30 4,977,176,067
D 448 0.19 53,732 1.27 4,849,897,734
D 672 0.29 80,598 1.24 4,723,059,609
D 896 0.39 107,464 1.20 4,596,717,039
D 1,120 0.49 134,330 1.17 4,471,003,938
D 1,344 0.58 161,196 1.14 4,346,101,597
D 1,568 0.68 188,062 1.10 4,222,169,842
D 1,792 0.78 214,928 1.07 4,099,244,064
D 2,016 0.88 241,794 1.04 3,977,280,537
D 2,240 0.97 268,660 1.01 3,856,146,129
D 2,304 1.00 276,336 1.00 3,821,728,635
D 2,464 1.07 295,526 0.98 3,735,683,711
D 2,688 1.17 322,392 0.95 3,615,709,296
D 2,912 1.26 349,258 0.91 3,496,037,602
D 3,136 1.36 376,124 0.88 3,376,350,624
D 3,360 1.46 402,990 0.85 3,256,551,589
D 3,584 1.56 429,856 0.82 3,136,593,884
D 3,808 1.65 456,722 0.79 3,016,431,669
D 4,032 1.75 483,588 0.76 2,895,964,237
D 4,256 1.85 510,454 0.73 2,775,270,545
D 4,480 1.94 537,320 0.69 2,654,526,665

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
59.15 32,948 22,754

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 3,000 2,411 927.92 0.00 0.00 0.00 0.00 307,200
E 3,000 2,358 1,041.82 0.00 0.00 0.00 0.00 307,200

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 36,874 36,874 0 0
4K 8K 948 948 0 0
8K 16K 122 122 0 0
16K 32K 722 722 0 0
32K 64K 256 252 4 0
64K 128K 102 52 50 0
128K 256K 231 44 72 115
256K 512K 179 6 0 173
512K 1024K 28,278 28,238 0 40
1M 2M 4,814 4,784 0 30
2M 4M 48 6 0 42
4M 8M 34 8 0 26
8M 16M 72 4 0 68
16M 32M 2 0 0 2
32M 64M 6 0 0 6
64M 128M 8 0 0 8
256M 512M 4 0 0 4
512M 1024M 4 0 0 4

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
375 0.13 11,321,028.10 6,018,102.17 65.00 14,692
750 0.25 11,321,028.10 4,043,670.09 74.00 167
1,500 0.50 11,321,028.10 1,622,242.01 87.00 0
2,250 0.75 11,321,028.10 1,556,548.52 88.00 0
3,000 1.00 11,321,028.10 1,556,226.88 88.00 0
3,600 1.20 11,321,028.10 1,552,420.67 88.00 0
4,200 1.40 11,321,028.10 1,552,420.67 88.00 0
4,800 1.60 11,321,028.10 1,552,420.67 88.00 0
5,400 1.80 11,321,028.10 1,552,420.67 88.00 0
6,000 2.00 11,321,028.10 1,552,420.67 88.00 0
9,000 3.00 11,321,028.10 1,552,420.67 88.00 0
12,000 4.00 11,321,028.10 1,552,420.67 88.00 0
18,000 6.00 11,321,028.10 1,552,420.67 88.00 0
24,000 8.00 11,321,028.10 1,552,420.67 88.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
656 0.36 222 13,723 55,333,206 0.96 2,680,462 5.88 1,327,748,322
848 0.47 399 17,099 55,705,482 0.97 2,308,186 5.06 1,327,893,115
1,040 0.58 582 20,511 56,077,493 0.97 1,936,175 4.24 1,328,037,163
1,232 0.68 765 24,012 56,448,880 0.98 1,564,788 3.43 1,328,180,033
1,424 0.79 948 28,002 56,819,281 0.99 1,194,387 2.62 1,328,321,601
1,616 0.89 1,131 31,728 57,188,816 0.99 824,852 1.81 1,328,462,294
1,808 1.00 1,314 36,205 57,557,550 1.00 456,118 1.00 1,328,602,307
2,000 1.11 1,497 43,286 57,925,561 1.01 88,107 0.19 1,328,741,789
2,192 1.21 1,680 53,043 58,292,933 1.01 1 0.00 1,328,880,839
2,384 1.32 1,863 59,185 58,659,744 1.02 1 0.00 1,329,019,530
2,576 1.42 2,046 66,017 59,026,076 1.03 1 0.00 1,329,157,929
2,768 1.53 2,229 77,390 59,392,013 1.03 1 0.00 1,329,296,097
2,960 1.64 2,412 80,277 59,757,640 1.04 1 0.00 1,329,434,079
3,152 1.74 2,595 83,138 60,123,037 1.04 1 0.00 1,329,571,930
3,344 1.85 2,778 85,930 60,488,274 1.05 1 0.00 1,329,709,697
3,536 1.96 2,961 88,767 60,853,404 1.06 1 0.00 1,329,847,402
3,728 2.06 3,144 91,520 61,218,487 1.06 1 0.00 1,329,985,083

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,076 0.25 16,678,926 4,977,034,388
2,152 0.50 14,382,167 4,977,034,388
3,228 0.75 12,926,052 4,471,037,803
4,304 1.00 11,547,291 3,821,726,475
5,380 1.25 10,375,253 3,256,493,129
6,456 1.50 10,279,415 2,775,337,766
7,532 1.75 10,279,418 2,654,571,210
8,608 2.00 10,279,433 2,654,571,210

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
16 0.10 3 84 6 1.00 456,118 1.00 84
32 0.20 3 84 6 1.00 456,118 1.00 84
48 0.30 3 84 6 1.00 456,118 1.00 84
64 0.40 3 84 6 1.00 456,118 1.00 84
80 0.50 3 84 6 1.00 456,118 1.00 84
96 0.60 3 84 6 1.00 456,118 1.00 84
112 0.70 3 84 6 1.00 456,118 1.00 84
128 0.80 3 84 6 1.00 456,118 1.00 84
144 0.90 3 84 6 1.00 456,118 1.00 84
160 1.00 3 84 6 1.00 456,118 1.00 84
176 1.10 3 84 6 1.00 456,118 1.00 84
192 1.20 3 84 6 1.00 456,118 1.00 84
208 1.30 3 84 6 1.00 456,118 1.00 84
224 1.40 3 84 6 1.00 456,118 1.00 84
240 1.50 3 84 6 1.00 456,118 1.00 84
256 1.60 3 84 6 1.00 456,118 1.00 84
272 1.70 3 84 6 1.00 456,118 1.00 84
288 1.80 3 84 6 1.00 456,118 1.00 84
304 1.90 3 84 6 1.00 456,118 1.00 84
320 2.00 3 84 6 1.00 456,118 1.00 84

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 190,062 14,758 78
undo header 1,152 50 43
2nd level bmb 164 24 148
segment header 203 9 46
undo block 1,124 5 4
1st level bmb 187 5 25
file header block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (index contention) 5,353 5,348 0 4,167 1,135 272.42
RO-Multiple Object Reuse (fast object reuse) 19,908 19,908 0 8,550 463 54.14
TX-Transaction (row lock contention) 99 98 0 87 99 1,139.46
CF-Controlfile Transaction 23,930 23,912 18 2,620 35 13.31
FB-Format Block 9,104 9,105 0 5,528 7 1.33
HW-Segment High Water Mark 4,619 4,618 1 1,238 4 3.59
TM-DML 167,803 165,534 2,268 3,953 3 0.73
TX-Transaction 179,052 179,069 0 51 3 50.92
PS-PX Process Reservation 1,065 1,025 40 741 1 1.03
WF-AWR Flush 64 64 0 53 1 10.26
TT-Tablespace 5,797 5,797 0 352 0 0.96
TX-Transaction (allocate ITL entry) 19 19 0 17 0 10.59
TD-KTF map table enqueue (KTF dump entries) 23 23 0 1 0 92.00
FL-Flashback database log (Flashback db command) 143 143 0 94 0 0.76
FL-Flashback database log (Flashback database log) 209 209 0 79 0 0.84
TA-Instance Undo 47 47 0 46 0 1.22
SQ-Sequence Cache 79,547 79,547 0 5 0 5.00
US-Undo Segment 92 92 0 23 0 0.61
RS-Reclaimable Space (file delete) 14 12 2 14 0 0.86
WL-Being Written Redo Log 13 8 5 7 0 0.86
DR-Distributed Recovery 4 4 0 2 0 3.00
JS-Job Scheduler (job run lock - synchronize) 4 4 0 2 0 2.50
PG-Global Parameter 30 30 0 5 0 0.60
UL-User-defined 4 4 0 4 0 0.50
PW-Buffer Cache PreWarm (flush prewarm buffers) 2 2 0 2 0 1.00
AF-Advisor Framework (task serialization) 14 14 0 1 0 2.00
PE-Parameter 10,881 10,881 0 4 0 0.25
PI-Remote PX Process Spawn Status 14 14 0 1 0 1.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 297.73 439,949 821 45 160/160 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
07-Apr 13:01 23,907 4,941 26 39 160 0/0 0/0/0/0/0/0
07-Apr 12:51 23,508 5,806 6 43 160 0/0 0/0/0/0/0/0
07-Apr 12:41 49,175 21,550 53 28 160 0/0 0/0/0/0/0/0
07-Apr 12:31 14,384 8,891 0 39 160 0/0 0/0/0/0/0/0
07-Apr 12:21 37,308 15,194 232 33 160 0/0 0/0/0/0/0/0
07-Apr 12:11 42,410 47,391 0 40 160 0/0 0/0/0/0/0/0
07-Apr 12:01 22,867 47,598 0 45 160 0/0 0/0/0/0/0/0
07-Apr 11:51 3,700 5,413 0 35 160 0/0 0/0/0/0/0/0
07-Apr 11:41 5,294 5,355 0 13 160 0/0 0/0/0/0/0/0
07-Apr 11:31 12,691 8,135 0 24 160 0/0 0/0/0/0/0/0
07-Apr 11:21 19,937 15,639 821 31 160 0/0 0/0/0/0/0/0
07-Apr 11:11 5,992 4,524 221 10 160 0/0 0/0/0/0/0/0
07-Apr 11:01 36,557 249,512 7 29 160 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM allocation 3,982 0.00   0 0  
ASM db client latch 19,058 0.00   0 0  
ASM map headers 1,848 0.00   0 0  
ASM map load waiting list 371 0.00   0 0  
ASM map operation freelist 18,417 0.22 0.00 0 0  
ASM map operation hash table 16,196,084 0.00 0.00 0 0  
ASM network background latch 4,798 0.00   0 0  
AWR Alerted Metric Element list 58,232 0.00   0 0  
Consistent RBA 55,138 0.01 0.00 0 0  
FAL request queue 231 0.00   0 0  
FAL subheap alocation 231 0.00   0 0  
FIB s.o chain latch 578 0.00   0 0  
FOB s.o list latch 133,816 0.18 0.00 0 0  
JS broadcast add buf latch 8,041 0.00   0 0  
JS broadcast drop buf latch 8,043 0.00   0 0  
JS broadcast load blnc latch 7,836 0.00   0 0  
JS mem alloc latch 10 0.00   0 0  
JS queue access latch 10 0.00   0 0  
JS queue state obj latch 329,188 0.00   0 0  
JS slv state obj latch 32 0.00   0 0  
KCL gc element parent latch 73,887,305 0.16 0.05 2 645,690 0.40
KFK SGA context latch 28,404 0.00   0 0  
KFMD SGA 13,834 0.16 0.00 0 0  
KJC message pool free list 2,458,042 0.11 0.00 0 597,099 0.06
KJCT flow control latch 18,094,612 0.04 0.01 0 0  
KMG MMAN ready and startup request latch 3,394 0.00   0 0  
KMG resize request state object freelist 30 0.00   0 0  
KSXR large replies 714 0.00   0 0  
KTF sga latch 45 0.00   0 2,384 0.00
KWQMN job cache list latch 894 0.00   0 0  
LGWR NS Write 231 0.00   0 0  
MQL Tracking Latch 0     0 143 0.00
Memory Management Latch 1,306 0.00   0 3,394 0.00
OS process 30,618 0.00   0 0  
OS process allocation 22,836 0.45 0.00 0 0  
OS process: request allocation 20,350 0.65 0.01 0 0  
PL/SQL warning settings 42,219 0.00   0 0  
Reserved Space Latch 410 0.00   0 0  
SGA IO buffer pool latch 159,971 0.02 0.00 0 167,468 0.02
SQL memory manager latch 2 0.00   0 2,386 0.00
SQL memory manager workarea list latch 299,595 0.00 0.00 0 0  
Shared B-Tree 253 0.00   0 0  
active checkpoint queue latch 131,558 0.01 0.00 0 0  
active service list 129,528 0.48 0.13 0 6,508 0.00
alert log latch 8 0.00   0 0  
archive control 2,505 0.00   0 0  
archive process latch 2,864 0.07 0.50 0 0  
begin backup scn array 12 0.00   0 0  
buffer pool 91 0.00   0 0  
business card 96 0.00   0 0  
cache buffer handles 254,901 0.02 0.00 0 0  
cache buffers chains 492,825,353 0.73 0.00 1 41,677,618 0.22
cache buffers lru chain 15,970,260 0.58 0.01 1 128,371,976 0.46
cache table scan latch 0     0 448,676 0.16
channel handle pool latch 22,434 0.39 0.00 0 0  
channel operations parent latch 6,796,219 0.00 0.02 0 0  
checkpoint queue latch 4,300,590 0.04 0.02 0 2,236,710 0.03
client/application info 66,737 0.00 0.00 0 0  
commit callback allocation 320 0.00   0 0  
compile environment latch 10,821 0.00   0 0  
dictionary lookup 1,818 0.00   0 0  
dml lock allocation 335,780 0.02 0.00 0 0  
dummy allocation 21,610 0.81 0.00 0 0  
enqueue hash chains 2,338,041 0.04 0.01 0 27,543 0.00
enqueues 1,321,144 0.05 0.04 1 0  
error message lists 300 0.00   0 0  
event group latch 10,192 0.00   0 0  
file cache latch 11,661 0.00   0 0  
flashback FBA barrier 4 0.00   0 0  
flashback SCN barrier 8 0.00   0 0  
flashback allocation 762,708 0.01 0.00 0 0  
flashback copy 0     0 740,186 0.06
flashback hint SCN barrier 4 0.00   0 0  
flashback mapping 14,963 0.04 0.17 0 0  
flashback sync request 25,432 0.04 0.00 0 0  
gcs opaque info freelist 13,637,055 0.09 0.01 0 0  
gcs partitioned table hash 119,164,357 0.00   0 0  
gcs remaster request queue 9 0.00   0 0  
gcs remastering latch 16,386,502 0.00 3.04 0 0  
gcs resource freelist 5,081,199 0.04 0.00 0 2,857,045 0.05
gcs resource hash 67,661,318 0.08 0.01 0 12,400 0.10
gcs resource scan list 24,811 0.00 0.00 0 0  
gcs shadows freelist 4,166,120 0.00 0.00 0 4,157,636 0.00
ges caches resource lists 188,887 0.04 0.00 0 159,426 0.02
ges deadlock list 14,118 0.00   0 58 0.00
ges domain table 667,983 0.00 0.00 0 0  
ges enqueue table freelist 758,594 0.01 0.00 0 0  
ges group table 978,005 0.00 0.00 0 0  
ges process hash list 320,656 0.01 0.40 0 1 0.00
ges process parent latch 1,778,486 0.00 0.00 0 0  
ges process table freelist 20,350 0.28 0.00 0 0  
ges resource hash list 1,405,851 0.24 0.23 0 51,437 0.02
ges resource scan list 8,327 0.01 0.00 0 0  
ges resource table freelist 77,311 0.01 0.00 0 0  
ges synchronous data 768 1.95 0.00 0 264,340 0.01
ges timeout list 7,288 0.00   0 7,200 0.00
global KZLD latch for mem in SGA 10,126 0.00   0 0  
hash table column usage latch 601 0.00   0 38,989,975 0.00
hash table modification latch 250 0.00   0 0  
hint flashback FBA barrier 4 0.00   0 0  
internal temp table object number allocation latc 4 0.00   0 0  
job workq parent latch 0     0 8 0.00
job_queue_processes parameter latch 123 0.00   0 0  
kks stats 16,538 0.02 0.00 0 0  
kokc descriptor allocation latch 968 0.00   0 0  
ksuosstats global area 482 0.00   0 0  
ktm global data 5,630 0.00   0 0  
kwqbsn:qsga 253 0.00   0 0  
lgwr LWN SCN 56,355 0.07 0.00 0 0  
library cache 7,435,377 0.17 0.00 0 3,003 0.03
library cache load lock 830 0.00   0 0  
library cache lock 1,483,991 0.65 0.00 0 0  
library cache lock allocation 73,951 0.08 0.02 0 0  
library cache pin 3,825,058 0.04 0.00 0 8 0.00
library cache pin allocation 14,815 0.01 0.00 0 0  
list of block allocation 281,163 0.05 0.01 0 0  
loader state object freelist 2,066 0.05 0.00 0 0  
longop free list parent 438 0.00   0 66 0.00
message pool operations parent latch 243,250 0.00   0 0  
messages 1,588,196 0.05 0.01 0 0  
mostly latch-free SCN 57,125 1.36 0.01 0 0  
msg queue 511 0.00   0 511 0.00
multiblock read objects 2,672,944 0.04 0.00 0 0  
name-service memory objects 94,044 0.00   0 0  
name-service namespace bucket 113,865 0.00   0 0  
name-service pending queue 32,483 0.00   0 0  
name-service request 34 0.00   0 0  
name-service request queue 135,682 0.00   0 0  
ncodef allocation latch 313 0.00   0 0  
object queue header heap 16,838 0.00   0 16,771 0.00
object queue header operation 37,595,950 0.04 0.07 0 44,330 0.09
object stats modification 3,156 0.00   0 0  
parallel query alloc buffer 6,737 0.00   0 0  
parallel query stats 754 0.00   0 0  
parallel txn reco latch 9,588 0.00   0 0  
parameter list 98,335 0.59 0.00 0 0  
parameter table allocation management 51,319 3.07 0.00 0 0  
post/wait queue 3,727,992 0.09 0.00 0 3,317,400 0.05
process allocation 86,080 0.04 0.19 0 10,180 0.12
process group creation 20,350 0.33 0.00 0 0  
process queue 2,371 0.00   0 0  
process queue reference 48,291 0.00 0.00 0 4,527 0.02
qmn state object latch 18 0.00   0 0  
qmn task queue latch 1,091 0.73 0.13 0 0  
query server freelists 1,664 0.00   0 0  
query server process 5 0.00   0 6 0.00
queued dump request 35,773 0.00   0 0  
redo allocation 201,493 0.12 0.06 0 12,393,566 0.12
redo copy 64 0.00   0 12,396,251 0.08
redo writing 310,143 0.03 0.00 0 0  
reservation so alloc latch 204 0.00   0 0  
resmgr group change latch 24,040 0.00   0 0  
resmgr:active threads 21,582 0.00   0 0  
resmgr:actses change group 10,742 0.00   0 0  
resmgr:free threads list 21,580 1.60 0.00 0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 48,803,453 0.24 0.00 0 248 0.00
rules engine aggregate statistics 31 0.00   0 0  
rules engine rule set statistics 62 0.00   0 0  
segmented array pool 578 0.00   0 0  
sequence cache 5,072,662 0.00 0.00 0 0  
session allocation 790,335 0.22 0.04 1 0  
session idle bit 2,200,000 0.01 0.03 0 0  
session state list latch 31,019 1.79 0.01 0 0  
session switching 313 0.00   0 0  
session timer 6,510 0.00   0 0  
shared pool 1,488,784 0.14 0.01 0 0  
shared pool simulator 4,336,581 0.00 0.02 0 0  
simulator hash latch 33,985,377 0.00 0.01 0 0  
simulator lru latch 1,719 0.58 1.00 0 21,530,860 1.21
slave class 1,548 0.00   0 0  
slave class create 1,080 0.09 1.00 0 0  
sort extent pool 11,629 0.03 0.00 0 0  
state object free list 4 0.00   0 0  
statistics aggregation 1,680 0.00   0 0  
temp lob duration state obj allocation 4 0.00   0 0  
threshold alerts latch 698 0.00   0 0  
transaction allocation 129,975 0.02 0.00 0 0  
transaction branch allocation 6,508 0.00   0 0  
undo global data 1,804,016 0.01 0.06 0 1 0.00
user lock 40,202 2.58 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 492,825,353 3,616,650 8,881 3,608,138 0 0 0
row cache objects 48,803,453 119,515 16 119,499 0 0 0
KCL gc element parent latch 73,887,305 116,296 6,382 110,246 0 0 0
cache buffers lru chain 15,970,260 93,221 562 92,670 0 0 0
gcs resource hash 67,661,318 54,531 557 53,999 0 0 0
object queue header operation 37,595,950 14,765 973 13,855 0 0 0
gcs opaque info freelist 13,637,055 12,842 96 12,751 0 0 0
library cache 7,435,377 12,479 27 12,452 0 0 0
library cache lock 1,483,991 9,636 10 9,626 0 0 0
KJCT flow control latch 18,094,612 7,088 46 7,043 0 0 0
ges resource hash list 1,405,851 3,442 775 2,667 0 0 0
post/wait queue 3,727,992 3,394 1 3,393 0 0 0
KJC message pool free list 2,458,042 2,695 6 2,689 0 0 0
gcs resource freelist 5,081,199 2,285 6 2,279 0 0 0
shared pool 1,488,784 2,044 21 2,023 0 0 0
checkpoint queue latch 4,300,590 1,932 47 1,886 0 0 0
session allocation 790,335 1,714 67 1,647 0 0 0
parameter table allocation management 51,319 1,574 3 1,571 0 0 0
library cache pin 3,825,058 1,469 1 1,468 0 0 0
multiblock read objects 2,672,944 1,104 5 1,100 0 0 0
user lock 40,202 1,036 5 1,031 0 0 0
messages 1,588,196 856 6 851 0 0 0
enqueue hash chains 2,338,041 830 5 825 0 0 0
mostly latch-free SCN 57,125 776 6 770 0 0 0
simulator hash latch 33,985,377 766 7 759 0 0 0
enqueues 1,321,144 650 24 626 0 0 0
active service list 129,528 624 79 545 0 0 0
session state list latch 31,019 555 3 552 0 0 0
redo allocation 201,493 242 15 227 0 0 0
session idle bit 2,200,000 210 6 204 0 0 0
channel operations parent latch 6,796,219 207 4 203 0 0 0
list of block allocation 281,163 145 1 144 0 0 0
undo global data 1,804,016 139 8 131 0 0 0
OS process: request allocation 20,350 132 1 131 0 0 0
library cache lock allocation 73,951 59 1 58 0 0 0
shared pool simulator 4,336,581 54 1 53 0 0 0
ges process hash list 320,656 43 17 26 0 0 0
process allocation 86,080 32 6 26 0 0 0
gcs remastering latch 16,386,502 27 82 11 0 0 0
simulator lru latch 1,719 10 10 2 0 0 0
qmn task queue latch 1,091 8 1 7 0 0 0
flashback mapping 14,963 6 1 5 0 0 0
archive process latch 2,864 2 1 1 0 0 0
slave class create 1,080 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclnfndnewm 0 2,820 1,190
KCL gc element parent latch kclrwrite 0 1,575 292
KCL gc element parent latch kclbla 0 975 205
KCL gc element parent latch kclchkping 0 894 4
KCL gc element parent latch kclulb 0 639 1,186
KCL gc element parent latch kclzcl 0 372 169
KCL gc element parent latch kclplz 0 349 1,835
KCL gc element parent latch kclfwrite1 0 267 229
KCL gc element parent latch kclpto 0 196 1,378
KCL gc element parent latch KCLUNLNK 0 177 1,237
KCL gc element parent latch kclwrt 0 155 636
KCL gc element parent latch kclliter 0 43 16
KCL gc element parent latch kcllwr 0 34 58
KCL gc element parent latch kclnfnd 0 31 58
KCL gc element parent latch kclpdc_3 0 30 42
KCL gc element parent latch kclevict 0 23 0
KCL gc element parent latch kclpto_3 0 19 56
KCL gc element parent latch kclrwrite_1 0 19 11
KCL gc element parent latch kclhngcbk1 0 14 0
KCL gc element parent latch kclfwrite2 0 12 6
KCL gc element parent latch kcl_get_le_latch 0 9 0
KCL gc element parent latch kclebs 0 6 13
KCL gc element parent latch kclgrantlk 0 6 9
KCL gc element parent latch kclprm 0 4 10
KCL gc element parent latch kclshrsplit 0 3 0
KCL gc element parent latch kclexpand 0 2 0
KCL gc element parent latch kclgcr 0 2 9
KCL gc element parent latch kclpdc_14 0 2 11
KCL gc element parent latch kclpto_1 0 2 0
KCL gc element parent latch kclcvb 0 1 0
KCL gc element parent latch kclpdcl 0 1 22
KCL gc element parent latch kclwritten 0 1 0
KJC message pool free list kjcsmpav: allocate a msg buffer 0 6 6
KJCT flow control latch kjctcsnd: send normal message 0 25 8
KJCT flow control latch kjcts_sqenq: queue a message 0 18 15
KJCT flow control latch kjcts_sedeqv: dequeue a vector of msgs 0 2 12
KJCT flow control latch kjctr_updatetkt: update ticket info 0 1 11
OS process: request allocation kso_new_process 0 1 0
active service list ksws_event: ksws event 0 320 322
active service list kswsgsnp: get service name ptr 0 3 1
archive process latch kcrrsarc 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 15,791 15,375
cache buffers chains kcbrls: kslbegin 0 1,946 2,589
cache buffers chains kcbzwb 0 668 505
cache buffers chains kcbchg: kslbegin: call CR func 0 607 77
cache buffers chains kcbgcur: kslbegin 0 405 530
cache buffers chains kclcls_3 0 252 55
cache buffers chains kcbget: pin buffer 0 167 121
cache buffers chains kcbget: exchange rls 0 143 17
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 124 232
cache buffers chains kcbget: exchange 0 103 37
cache buffers chains kcbgtcr: fast path 0 100 47
cache buffers chains kcbzgb: scan from tail. nowait 0 83 0
cache buffers chains kcbzib: exchange rls 0 55 15
cache buffers chains kcbgtcr: kslbegin shared 0 44 38
cache buffers chains kcbzib: finish free bufs 0 39 18
cache buffers chains kcbzib: multi-block read: nowait 0 25 0
cache buffers chains kclwrt 0 20 7
cache buffers chains kclbla 0 14 30
cache buffers chains kcbbic2 0 13 10
cache buffers chains kcbbxsv 0 12 37
cache buffers chains kcbnlc 0 12 36
cache buffers chains kcbesc: escalate 0 10 0
cache buffers chains kcbso1: set no access 0 10 12
cache buffers chains kclebs_1 0 10 0
cache buffers chains kclexpand 0 7 7
cache buffers chains kclwlr 0 6 6
cache buffers chains kclobj_1 0 4 0
cache buffers chains kcbbic1 0 2 4
cache buffers chains kcbcge 0 2 1
cache buffers chains kcbgcur: buf pinned 0 2 5
cache buffers chains kcbgcur: deadlock 0 2 0
cache buffers chains kcllwr 0 2 2
cache buffers chains kcbkzs 0 1 1
cache buffers chains kcbnew: new latch again 0 1 3
cache buffers chains kcbzhngcbk1: get hash chain latch no wait 0 1 0
cache buffers chains kcllkopb_1 0 1 3
cache buffers chains kclpdc_3 0 1 0
cache buffers chains kclpto 0 1 0
cache buffers chains kclwcrs 0 1 1
cache buffers chains kclwcrs_2 0 1 6
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 202 6
cache buffers lru chain kcbzgws 0 140 0
cache buffers lru chain kcbbxsv: move to being written 0 66 34
cache buffers lru chain kclmvreqbg 0 57 191
cache buffers lru chain kcbzar: KSLNBEGIN 0 27 0
cache buffers lru chain kcbzgb: posted for free bufs 0 26 199
cache buffers lru chain H_MK_PI_CR_BG 0 18 0
cache buffers lru chain kcbbic2 0 6 47
cache buffers lru chain kcbzib: move stale buffers 0 6 58
cache buffers lru chain kcbbwlru 0 5 26
cache buffers lru chain kcbzgm 0 3 0
cache buffers lru chain kclmergepi 0 3 0
cache buffers lru chain kcbrenounce 0 1 0
cache buffers lru chain kcbw_make_free_nowait 0 1 0
cache buffers lru chain kcbzswcu 0 1 0
channel operations parent latch ksrwait() 0 3 3
channel operations parent latch ksrchdelete() 0 2 2
checkpoint queue latch kcbkubc 0 23 36
checkpoint queue latch kcbklbc: Link buffer into ckpt queue 0 13 0
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 8 3
checkpoint queue latch H_MK_PI_CR_BG 0 1 0
checkpoint queue latch kcbbcthc: check thread queue 0 1 0
checkpoint queue latch kcbk_get_cqlt_nowait2 0 1 0
cost function kzulrl 0 5 5
enqueue hash chains ksqcmi: if lk mode not requested 0 2 0
enqueue hash chains ksqexpandlmd 0 1 1
enqueue hash chains ksqgtl3 0 1 0
enqueue hash chains ksqrcl 0 1 3
enqueues ksqies 0 21 21
enqueues ksqdel 0 2 1
enqueues ksqgel: create enqueue 0 1 2
event range base latch No latch 0 1 1
flashback mapping krfw_advance_mapping1 0 1 0
gcs opaque info freelist kjbrcvt save opaque info 0 58 63
gcs opaque info freelist kjbrgrant free opaque info 0 38 33
gcs remastering latch 59 0 76 0
gcs remastering latch 43 0 11 0
gcs remastering latch 69 0 2 0
gcs remastering latch 24 0 1 0
gcs resource freelist kjbralc add resource 0 6 0
gcs resource hash kjblocalfile_nolock 0 110 7
gcs resource hash kjbcropen:affinity 0 95 2
gcs resource hash kjbassume 0 90 29
gcs resource hash kjbcropen 0 52 9
gcs resource hash kclfwrite1 0 41 8
gcs resource hash kclrwrite 0 34 5
gcs resource hash kjbopen:affinity 0 33 8
gcs resource hash kjbrwrdone reget 0 31 0
gcs resource hash kjbconvert 0 27 12
gcs resource hash kjbopen 0 19 7
gcs resource hash kjbrdrmcvtq_98 0 5 0
gcs resource hash kclpdc 0 3 2
gcs resource hash kjbmpclose 0 3 84
gcs resource hash kjbrrcfwst 0 3 1
gcs resource hash kjbrrcres_99 0 3 0
gcs resource hash kclzcl 0 2 202
gcs resource hash kjbldrmrpst 0 2 0
gcs resource hash kjbmpconvert 0 2 33
gcs resource hash kjblpwreq 0 1 8
gcs resource hash kjbmpopen 0 1 47
ges process hash list kjakiqa: set inquiry response 0 17 0
ges resource hash list kjrmas1: lookup master node 0 621 0
ges resource hash list kjakcai: search for resp by resname 0 80 7
ges resource hash list kjlrlr: remove lock from resource queue 0 33 107
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 25 12
ges resource hash list kjucvl: lock convert request 0 14 643
ges resource hash list kjcvscn: remove from scan queue 0 1 0
ges resource hash list kjrref: find matched resource 0 1 6
lgwr LWN SCN kcs023 0 1 0
library cache kgldte: child 0 0 12 13
library cache kglLockCursor 0 6 1
library cache kglpndl: child: after processing 0 3 0
library cache kglobpn: child: 0 2 2
library cache kglScanDependency 0 1 0
library cache kgldti: 2child 0 1 0
library cache kglhdgn: child: 0 1 8
library cache lock kgllkdl: child: cleanup 0 6 9
library cache lock kgllkal: child: multiinstance 0 4 1
library cache lock kgllkdl: child: no lock handle 0 1 0
library cache lock allocation kgllkget 0 1 1
library cache pin kglpndl 0 1 0
list of block allocation ktlabl 0 1 1
messages ksarcv 0 4 0
messages ksaamb: after wakeup 0 1 2
messages ksarcv: after wait 0 1 4
mostly latch-free SCN kcslcu3 0 5 6
multiblock read objects kcbzib: mbr get 0 3 0
multiblock read objects kcbzib: normal mbr free 0 2 5
object queue header operation kcbw_unlink_q 0 377 245
object queue header operation kclobj_1 0 245 83
object queue header operation kcbo_switch_mq_bg 0 176 325
object queue header operation kcbo_switch_cq 0 157 345
object queue header operation kcbw_link_q 0 148 56
object queue header operation kcbo_switch_q_bg 0 59 27
object queue header operation kcbw_unlink_q_bg 0 18 112
object queue header operation kclobj_2 0 11 6
object queue header operation kcbw_make_free_nowait 0 8 0
object queue header operation kcbo_service_ockpt 0 3 1
object queue header operation kcbo_write_q 0 1 3
parameter table allocation management ksp_param_table_free 0 3 3
post/wait queue ksliwat:add:nowait 0 1 0
process allocation ksudlp 0 6 6
redo allocation kcrfw_redo_gen: redo allocation 1 0 14 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 1 2
row cache objects kqreqd: reget 0 8 0
row cache objects kqreqd 0 4 6
row cache objects kqrpre: find obj 0 4 10
session allocation ksudlp 0 23 25
session allocation ksuxds: KSUSFCLC not set 0 20 18
session allocation ksuxds: not user session 0 20 3
session allocation ksucri 0 4 21
session idle bit ksupuc: set busy 0 4 2
session idle bit ksupuc: clear busy 0 1 3
session idle bit ksuxds 0 1 1
session state list latch kpscad 0 2 0
session state list latch kpseqd 0 1 0
shared pool kgh_next_free 0 9 0
shared pool kghfre 0 4 5
shared pool kghalo 0 3 8
shared pool kghupr1 0 3 7
shared pool kgh: quiesce extents 0 1 0
shared pool kghalp 0 1 1
shared pool simulator kglsim_unpin_simhp 0 1 0
simulator hash latch kcbsacc: lookup dba 0 3 4
simulator hash latch kcbs_lookup_setid: lookup dba 0 2 2
simulator hash latch kcbsacc: insert dba 0 1 0
simulator hash latch kcbsacc: remove dba 0 1 1
simulator lru latch kcbs_shrink_pool 0 7 0
simulator lru latch kcbs_grow_pool 0 3 0
slave class create ksvcreate 0 1 0
undo global data ktudba: KSLBEGIN 0 4 6
undo global data ktudnx:child 0 3 0
undo global data ktusmasp: ktugd_tuux 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
UDAS_CODIE UDAS_DAT MART_SERVICE   TABLE 78,639,088 38.62
VSDASCN VSDA_DAT SC_SVC_CHANGE   TABLE 18,088,224 8.88
UDAS_CODIE UDAS_DAT STG_SERVICE   TABLE 18,040,880 8.86
UDAS_CODIE UDAS_DAT SYS_C005840   INDEX 12,938,672 6.35
UDAS_CODIE UDAS_DAT BF_AUDIT_TRAIL P2011APR TABLE PARTITION 8,672,784 4.26

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
UDAS_CODIE UDAS_DAT BF_MART_PRCH_HSTRY   TABLE 2,831,298 28.05
UDAS_CODIE UDAS_DAT PCT_VSDA_USD_LOAD   TABLE 2,394,072 23.71
VSDASCN VSDA_DAT SC_SVC_CHANGE   TABLE 1,314,070 13.02
UDAS_CODIE UDAS_DAT BF_AUDIT_TRAIL P2011APR TABLE PARTITION 308,266 3.05
UDAS_CODIE UDAS_DAT STG_SERVICE   TABLE 129,617 1.28

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
UDAS_CODIE UDAS_IDX STG_ID_MAPPER_IDX1   INDEX 1,229 33.17
UDAS_CODIE UDAS_IDX STG_PROGRAMID_MAPPER_IDX1   INDEX 1,194 32.23
CODIE_TRANS CODIE_TRANS_DAT CODIE_START_TIME_IDX   INDEX 412 11.12
SYS SYSTEM I_AUD1   INDEX 404 10.90
UDAS_CODIE UDAS_DAT IX_AUDIT_PURCHASE_DT   INDEX 128 3.45

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
UDAS_CODIE UDAS_IDX STG_PROGRAMID_MAPPER_IDX1   INDEX 8 42.11
UDAS_CODIE UDAS_IDX STG_ID_MAPPER_IDX1   INDEX 4 21.05
CODIE_TRANS CODIE_TRANS_DAT CODIE_START_TIME_IDX   INDEX 2 10.53
UDAS_CODIE UDAS_DAT IX_AUDIT_PURCHASE_DT   INDEX 2 10.53
UDAS_CODIE UDAS_IDX IX_PURCHASE_DT   INDEX 2 10.53

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYS SYSTEM AUD$   TABLE 5,907 45.31
UDAS_CODIE UDAS_IDX STG_ID_MAPPER_IDX1   INDEX 2,258 17.32
UDAS_CODIE UDAS_IDX STG_PROGRAMID_MAPPER_IDX1   INDEX 1,610 12.35
SYS SYSTEM I_AUD1   INDEX 1,416 10.86
CODIE_TRANS CODIE_TRANS_DAT CODIE_START_TIME_IDX   INDEX 1,131 8.68

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
UDAS_CODIE UDAS_DAT MART_SERVICE   TABLE 128,552 72.84
SYS SYSTEM AUD$   TABLE 16,960 9.61
UDAS_CODIE UDAS_DAT BF_MART_MDT   TABLE 7,156 4.05
CODIE_TRANS CODIE_TRANS_DAT CODIE_START_TIME_IDX   INDEX 6,416 3.64
VSDASCN VSDA_DAT SC_SVC_CHANGE   TABLE 5,151 2.92

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
UDAS_CODIE UDAS_DAT SERVICE_ID_IDX   INDEX 23,397 24.81
UDAS_CODIE UDAS_DAT STG_PGA_BOUNDARY_POINTS   TABLE 10,989 11.65
UDAS_CODIE UDAS_DAT BF_STG_PRCH_HSTRY_X1   INDEX 9,293 9.85
UDAS_CODIE UDAS_DAT BF_MART_PRCH_HSTRY   TABLE 5,515 5.85
UDAS_CODIE UDAS_DAT PRN_ASSET_BILL_DEP_PK   INDEX 5,239 5.56

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
UDAS_CODIE UDAS_DAT MART_SERVICE   TABLE 3,738,308 46.62
VSDASCN VSDA_DAT SC_SVC_CHANGE   TABLE 1,480,079 18.46
UDAS_CODIE UDAS_DAT BF_MART_MDT   TABLE 780,717 9.74
UDAS_CODIE UDAS_IDX STG_PROGRAMID_MAPPER_IDX1   INDEX 621,184 7.75
UDAS_CODIE UDAS_IDX STG_ID_MAPPER_IDX1   INDEX 542,316 6.76

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 127 3.15 0   0 1
dc_database_links 20,243 0.00 0   0 1
dc_files 18,737 0.00 0   0 185
dc_global_oids 14,508 0.00 0   0 35
dc_histogram_data 1,975,869 0.01 0   0 4,495
dc_histogram_defs 485,662 0.02 0   0 3,528
dc_object_grants 112 4.46 0   0 82
dc_object_ids 653,767 0.25 0   0 1,309
dc_objects 106,659 0.13 0   1,677 1,399
dc_profiles 20,135 0.00 0   0 2
dc_rollback_segments 496,639 0.00 0   0 206
dc_segments 281,888 0.08 0   2,509 1,268
dc_sequences 80,168 0.06 0   80,168 13
dc_tablespace_quotas 3,069 5.15 0   24 5
dc_tablespaces 6,550,502 0.00 0   0 12
dc_usernames 67,190 0.00 0   0 73
dc_users 6,514,990 0.00 0   0 133
outstanding_alerts 322 73.29 0   31 8

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 4 4 0
dc_histogram_defs 76 0 64
dc_object_ids 3,894 71 2
dc_objects 3,486 73 87
dc_segments 5,100 185 345
dc_sequences 160,305 46 0
dc_tablespace_quotas 2,111 161 0
outstanding_alerts 600 231 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 7,990 0.00 15,918 0.00 0 0
CLUSTER 41 0.00 92 0.00 0 0
INDEX 18 0.00 1,512 0.60 9 0
SQL AREA 202,730 5.87 3,334,129 0.95 5,127 2,614
TABLE/PROCEDURE 12,514 0.36 1,904,783 0.02 102 0
TRIGGER 792 0.51 51,953 0.02 7 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 92 0 0 0 0
INDEX 1,512 2,980 11 3,020 0
TABLE/PROCEDURE 89,577 3,052 70 3,255 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 705.48   9.28 14.27 50 61 76 76
  Freeable 215.75 0.00 5.39 9.46 44   40 40
  SQL 3.57 2.62 0.07 0.21 2 14 53 49
  PL/SQL 1.12 0.89 0.02 0.01 0 0 74 73
E Other 819.38   7.88 12.40 50 61 104 104
  Freeable 218.00 0.00 3.96 8.38 44   55 55
  SQL 2.61 1.49 0.03 0.03 0 14 81 79
  PL/SQL 1.84 1.52 0.02 0.01 0 0 102 102

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 2,315,255,808 2,415,919,104
Fixed Size 2,092,848  
Redo Buffers 14,684,160  
Variable Size 3,674,210,512 3,573,547,216

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 155.27 155.27 0.00
java joxlod exec hp 4.65 4.65 0.00
large ASM map operations hashta 0.38 0.38 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.60 14.60 0.00
shared CCursor 108.49 134.99 24.44
shared KGH: NO ACCESS 176.45 176.45 0.00
shared PCursor 31.55 38.10 20.76
shared db_block_hash_buckets 22.50 22.50 0.00
shared free memory 557.45 492.83 -11.59
shared gcs resources 95.98 95.98 0.00
shared gcs shadows 237.28 237.28 0.00
shared kglsim object batch   20.16  
shared library cache 51.47 61.98 20.43
shared sql area 544.39 470.15 -13.64
  buffer_cache 2,208.00 2,304.00 4.35
  fixed_sga 2.00 2.00 0.00
  log_buffer 14.00 14.00 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 463,988 559,797 504420 504420
gcs_shadows 504,420 2,443,759 504420 504420


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
O7_DICTIONARY_ACCESSIBILITY TRUE   
archive_lag_target 7200   
audit_file_dest /usr/local/opt/oracle/admin/udas2pdb/adump   
audit_trail DB   
background_dump_dest /usr/local/opt/oracle/admin/udas2pdb/bdump   
cluster_database TRUE   
cluster_database_instances 3   
compatible 10.2.0.4.0   
control_files +DBGRP1/udas2pdb_dg4/controlfile/current.356.742834077, +RECOVERY/udas2pdb_dg4/controlfile/current.1098.742834077   
core_dump_dest /usr/local/opt/oracle/admin/udas2pdb/cdump   
db_block_checking full   
db_block_checksum full   
db_block_size 8192   
db_create_file_dest +DBGRP1   
db_domain sbc.com   
db_file_multiblock_read_count 16   
db_flashback_retention_target 180   
db_name udas2pdb   
db_recovery_file_dest +RECOVERY   
db_recovery_file_dest_size 805306368000   
db_unique_name udas2pdb_dg4   
dispatchers (PROTOCOL=TCP) (SERVICE=udas2pXDB)   
fal_client udas2pdb_dg4   
fal_server udas2pdb_dg2, udas2pdb_dg5   
instance_number 1   
java_pool_size 167772160   
job_queue_processes 10   
local_listener LISTENER_UDAS2P1   
log_archive_config DG_CONFIG=(udas2pdb_dg4, udas2pdb_dg5, udas2pdb_dg2)   
log_archive_dest_1 LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ONLINE_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=udas2pdb_dg4   
log_archive_dest_2 SERVICE=udas2pdb_dg5.sbc.com LGWR SYNC AFFIRM optional reopen=60 net_timeout=180 DB_UNIQUE_NAME=udas2pdb_dg5 VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE)   
log_archive_dest_3 SERVICE=udas2pdb_dg2.sbc.com LGWR ASYNC optional reopen=60 net_timeout=180 DB_UNIQUE_NAME=udas2pdb_dg2 VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE)   
log_archive_dest_4 LOCATION=+RECOVERY/udas2pdb_dg4/STDBYARC VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE) DB_UNIQUE_NAME=udas2pdb_dg4   
log_archive_dest_state_2 ENABLE   
log_archive_dest_state_3 DEFER   
log_archive_max_processes 5   
max_dump_file_size 1000M   
open_cursors 300   
pga_aggregate_target 3145728000   
processes 600   
remote_listener LISTENERS_UDAS2PDB   
remote_login_passwordfile EXCLUSIVE   
service_names udas2pdb_dg4.sbc.com, codieff_blue_srv   
sessions 665   
sga_max_size 6006243328   
sga_target 4513071104   
shared_pool_size 167772160   
spfile +DBGRP1/udas2pdb_dg4/spfileudas2p.ora   
standby_archive_dest +RECOVERY/udas2pdb_dg4/STDBYARC   
standby_file_management AUTO   
thread 1   
undo_management AUTO   
undo_retention 9600   
undo_tablespace UNDOTBS1   
user_dump_dest /usr/local/opt/oracle/admin/udas2pdb/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 40,370 5.63 1.54
acks for commit broadcast(logical) 65,893 9.19 2.51
broadcast msgs on commit(actual) 105,987 14.79 4.04
broadcast msgs on commit(logical) 110,236 15.38 4.20
broadcast msgs on commit(wasted) 19,921 2.78 0.76
broadcast on commit wait time(ms) 79 0.01 0.00
broadcast on commit waits 6 0.00 0.00
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 27 0.00 0.00
flow control messages sent 13 0.00 0.00
gcs assume cvt
gcs assume no cvt 1,366,715 190.70 52.07
gcs ast xid 1,507 0.21 0.06
gcs blocked converts 1,427,545 199.19 54.38
gcs blocked cr converts 108,854 15.19 4.15
gcs compatible basts 19,160 2.67 0.73
gcs compatible cr basts (global) 4,622 0.64 0.18
gcs compatible cr basts (local) 5,366,611 748.82 204.44
gcs cr basts to PIs 213 0.03 0.01
gcs cr serve without current lock 1 0.00 0.00
gcs dbwr flush pi msgs 424,371 59.21 16.17
gcs dbwr write request msgs 306,506 42.77 11.68
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 1,563 0.22 0.06
gcs immediate (compatible) converts 10,763 1.50 0.41
gcs immediate (null) converts 318,218 44.40 12.12
gcs immediate cr (compatible) converts 228,574 31.89 8.71
gcs immediate cr (null) converts 3,487,824 486.66 132.87
gcs indirect ast 398,209 55.56 15.17
gcs lms flush pi msgs 126,769 17.69 4.83
gcs lms write request msgs 125,090 17.45 4.77
gcs msgs process time(ms) 282,908 39.47 10.78
gcs msgs received 14,551,054 2,030.34 554.33
gcs out-of-order msgs 12 0.00 0.00
gcs pings refused 4,976 0.69 0.19
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 14,323 2.00 0.55
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 957 0.13 0.04
gcs regular cr 35,966 5.02 1.37
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 80,953 11.30 3.08
gcs side channel msgs logical 8,887,943 1,240.16 338.59
gcs stale cr 8 0.00 0.00
gcs undo cr 4,674 0.65 0.18
gcs write notification msgs 27,036 3.77 1.03
gcs writes refused 368 0.05 0.01
ges msgs process time(ms) 3,416 0.48 0.13
ges msgs received 184,415 25.73 7.03
global posts dropped 0 0.00 0.00
global posts queue time 270 0.04 0.01
global posts queued 60 0.01 0.00
global posts requested 62 0.01 0.00
global posts sent 60 0.01 0.00
implicit batch messages received 841,309 117.39 32.05
implicit batch messages sent 1,122,789 156.67 42.77
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 220,018 30.70 8.38
messages queue sent actual 3,154,200 440.11 120.16
messages queue sent logical 8,377,776 1,168.97 319.15
messages received actual 5,971,227 833.18 227.48
messages received logical 14,735,772 2,056.12 561.36
messages sent directly 2,776,014 387.34 105.75
messages sent indirectly 7,885,852 1,100.33 300.41
messages sent not implicit batched 2,031,512 283.46 77.39
messages sent pbatched 13,153,834 1,835.39 501.10
msgs causing lmd to send msgs 80,960 11.30 3.08
msgs causing lms(s) to send msgs 1,028,523 143.51 39.18
msgs received queue time (ms) 267,326 37.30 10.18
msgs received queued 14,735,215 2,056.04 561.34
msgs sent queue time (ms) 548,289 76.50 20.89
msgs sent queue time on ksxp (ms) 3,728,059 520.18 142.02
msgs sent queued 8,324,840 1,161.58 317.14
msgs sent queued on ksxp 8,123,302 1,133.46 309.46
process batch messages received 1,450,304 202.36 55.25
process batch messages sent 2,727,152 380.53 103.89


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 113,049
CURRENT Block Requests 19,984
Data Block Requests 113,048
Undo Block Requests 4,626
TX Block Requests 11,499
Current Results 127,674
Private results 282
Zero Results 2,996
Disk Read Results 2,044
Fail Results 6
Fairness Down Converts 5,914
Fairness Clears 0
Free GC Elements 0
Flushes 9,923
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 3,781
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 1,922,253 99.56 0.06 0.37 0.01 0.00
Flushes 38,944 0.27 3.44 71.30 22.35 2.63
Writes 385,466 3.32 46.34 46.07 3.25 1.02


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 52,790 91.70 8.03 0.27 4,370,326 99.29 0.50 0.21
3 data block 23,627 90.98 8.60 0.41 3,635,015 98.69 1.01 0.30
3 Others 2,497 92.35 7.65 0.00 7,609 95.48 3.08 1.45
2 Others 2,224 91.77 8.00 0.22 4,741 98.48 1.50 0.02
3 undo header 5,129 80.99 18.99 0.02 561 73.62 26.20 0.18
2 undo header 3,767 81.98 17.92 0.11 402 73.88 26.12 0.00
3 undo block 2,316 99.53 0.47 0.00 0      
2 undo block 1,936 99.74 0.26 0.00 0      


Back to Top

End of Report