[oracle@db2 log]$ cat 20120814awrb01.lst AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
G1DB2583992970G1db2210.2.0.4.0YESdb2

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:650014-Aug-12 11:00:0799 1.5
End Snap:650114-Aug-12 12:03:10212 .4
Elapsed:  63.06 (mins)  
DB Time:  1,613.41 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 2,432M 2,432MStd Block Size: 8K
Shared Pool Size: 3,664M 3,664MLog Buffer: 14,336K

Load Profile

Per SecondPer Transaction
Redo size: 6,430.83 3,271.12
Logical reads: 10,768.04 5,477.30
Block changes: 20.80 10.58
Physical reads: 409.17 208.13
Physical writes: 2.10 1.07
User calls: 51.11 26.00
Parses: 17.96 9.14
Hard parses: 0.30 0.15
Sorts: 3.54 1.80
Logons: 0.20 0.10
Executes: 18.43 9.37
Transactions: 1.97 

% Blocks changed per Read: 0.19Recursive Call %: 30.18
Rollback per transaction %: 54.48Rows per Sort: 62.68

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.88Redo NoWait %: 100.00
Buffer Hit %: 96.20In-memory Sort %: 100.00
Library Hit %: 96.63Soft Parse %: 98.31
Execute to Parse %: 2.53Latch Hit %: 99.89
Parse CPU to Parse Elapsd %: 87.61% Non-Parse CPU: 99.20

Shared Pool Statistics

BeginEnd
Memory Usage %: 82.99 83.05
% SQL with executions>1: 93.59 97.01
% Memory for SQL w/exec>1: 94.32 96.24

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
enq: TX - row lock contention 169,988 83,130 489 85.9Application
gc buffer busy 47,694 6,069 127 6.3Cluster
row cache lock 1,869 3,174 1,698 3.3Concurrency
log file sync 4,934 1,489 302 1.5Commit
gc current block busy 764 887 1,161 .9Cluster

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 826.40 420.36
Global Cache blocks served: 288.03 146.51
GCS/GES messages received: 1,041.32 529.68
GCS/GES messages sent: 2,017.48 1,026.22
DBWR Fusion writes: 0.28 0.14
Estd Interconnect traffic (KB) 9,512.85 

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

Buffer access - local cache %: 88.53
Buffer access - remote cache %: 7.67
Buffer access - disk %: 3.80

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 43.6
Avg global cache cr block receive time (ms): 51.4
Avg global cache current block receive time (ms): 1.1
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 %: 2.9
Avg global cache cr block flush time (ms): 3,035.9
Avg global cache current block pin time (ms): 27.3
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 69,621.8

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 27.3
Avg message sent queue time on ksxp (ms): 0.2
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: 11.51
% of indirect sent messages: 88.32
% of flow controlled messages: 0.17

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 95,311.36 98.46
DB CPU 504.74 0.52
parse time elapsed 5.37 0.01
hard parse elapsed time 3.33 0.00
connection management call elapsed time 1.79 0.00
hard parse (sharing criteria) elapsed time 0.33 0.00
sequence load elapsed time 0.09 0.00
failed parse elapsed time 0.03 0.00
PL/SQL execution elapsed time 0.02 0.00
hard parse (bind mismatch) elapsed time 0.00 0.00
repeated bind elapsed time 0.00 0.00
DB time 96,804.45  
background elapsed time 1,593.22  
background cpu time 98.66  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Application 170,706 99.41 83,130 487 22.95
Cluster 2,015,662 0.38 7,743 4 271.00
Concurrency 5,852 17.93 3,175 543 0.79
Other 531,994 98.21 1,642 3 71.52
Commit 4,934 29.69 1,489 302 0.66
User I/O 170,935 0.00 470 3 22.98
System I/O 27,748 0.00 52 2 3.73
Network 132,813 0.00 0 0 17.86
Configuration 830 99.64 0 0 0.11

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
enq: TX - row lock contention 169,988 99.83 83,130 489 22.85
gc buffer busy 47,694 12.90 6,069 127 6.41
row cache lock 1,869 56.07 3,174 1698 0.25
log file sync 4,934 29.69 1,489 302 0.66
gc current block busy 764 94.50 887 1161 0.10
gcs log flush sync 33,320 99.42 717 22 4.48
enq: CF - contention 2,598 55.70 712 274 0.35
gc cr block busy 852 32.98 346 406 0.11
gc cr multi block request 1,571,251 0.00 312 0 211.25
rdbms ipc reply 630 15.87 196 312 0.08
db file parallel read 82,153 0.00 180 2 11.05
db file sequential read 38,389 0.00 174 5 5.16
gc current block 2-way 374,688 0.00 123 0 50.37
db file scattered read 48,561 0.00 109 2 6.53
control file sequential read 18,435 0.00 28 2 2.48
log file parallel write 4,191 0.00 10 2 0.56
control file parallel write 2,491 0.00 8 3 0.33
read by other session 1,778 0.00 7 4 0.24
db file parallel write 2,584 0.00 6 2 0.35
Streams AQ: qmn coordinator waiting for slave to start 1 100.00 5 5333 0.00
enq: US - contention 494 0.00 3 6 0.07
gc cr grant 2-way 11,833 0.00 3 0 1.59
reliable message 282 0.71 3 9 0.04
gc cr block 2-way 5,330 0.00 2 0 0.72
cr request retry 3 66.67 2 651 0.00
CGS wait for IPC msg 477,581 99.98 2 0 64.21
gcs drm freeze in enter server mode 8 0.00 1 97 0.00
wait for scn ack 3,078 0.00 1 0 0.41
DFS lock handle 516 0.00 1 1 0.07
library cache lock 1,523 0.00 1 0 0.20
gc current grant busy 819 0.00 0 1 0.11
enq: XR - database force logging 1,282 0.00 0 0 0.17
log file sequential read 24 0.00 0 17 0.00
gc current grant 2-way 1,624 0.00 0 0 0.22
latch free 32 0.00 0 10 0.00
ges global resource directory to be frozen 28 92.86 0 9 0.00
gc remaster 8 0.00 0 25 0.00
SQL*Net break/reset to client 714 0.00 0 0 0.10
kjbdrmcvtq lmon drm quiesce: ping completion 28 0.00 0 4 0.00
SQL*Net message to client 132,584 0.00 0 0 17.83
os thread startup 4 0.00 0 19 0.00
latch: cache buffers chains 2,422 0.00 0 0 0.33
gc cr disk read 200 0.00 0 0 0.03
enq: PS - contention 214 0.00 0 0 0.03
SQL*Net more data from client 51 0.00 0 1 0.01
enq: TT - contention 167 0.00 0 0 0.02
PX Deq: reap credit 4,472 94.41 0 0 0.60
ksxr poll remote instances 4,552 82.78 0 0 0.61
PX Deq Credit: send blkd 183 68.31 0 0 0.02
PX Deq: Signal ACK 244 33.20 0 0 0.03
buffer deadlock 2,054 100.00 0 0 0.28
direct path read 26 0.00 0 0 0.00
cursor: pin S wait on X 1 100.00 0 11 0.00
enq: TX - contention 37 0.00 0 0 0.00
IPC send completion sync 38 100.00 0 0 0.01
enq: FB - contention 31 0.00 0 0 0.00
gc current multi block request 68 0.00 0 0 0.01
Log archive I/O 21 0.00 0 0 0.00
enq: TD - KTF dump entries 12 0.00 0 0 0.00
buffer busy waits 28 0.00 0 0 0.00
gc object scan 531 100.00 0 0 0.07
enq: WF - contention 10 0.00 0 0 0.00
undo segment extension 827 100.00 0 0 0.11
SQL*Net more data to client 178 0.00 0 0 0.02
latch: ges resource hash list 16 0.00 0 0 0.00
direct path write 28 0.00 0 0 0.00
enq: TM - contention 4 0.00 0 0 0.00
library cache pin 3 0.00 0 0 0.00
enq: HW - contention 3 0.00 0 0 0.00
LGWR wait for redo copy 16 0.00 0 0 0.00
latch: object queue header operation 21 0.00 0 0 0.00
latch: gcs resource hash 9 0.00 0 0 0.00
latch: KCL gc element parent latch 27 0.00 0 0 0.00
enq: DR - contention 2 0.00 0 0 0.00
KJC: Wait for msg sends to complete 1 0.00 0 1 0.00
log file single write 2 0.00 0 0 0.00
enq: TX - index contention 1 0.00 0 0 0.00
enq: WL - contention 1 0.00 0 0 0.00
enq: IR - contention 1 0.00 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 3 0.00 0 0 0.00
latch: cache buffers lru chain 2 0.00 0 0 0.00
latch: row cache objects 1 0.00 0 0 0.00
SQL*Net message from client 132,473 0.00 98,428 743 17.81
gcs remote message 1,190,581 99.36 21,370 18 160.07
jobq slave wait 6,027 49.26 14,564 2417 0.81
DIAG idle wait 18,910 0.00 3,694 195 2.54
PX Idle Wait 1,567 93.81 3,693 2357 0.21
ASM background timer 773 0.00 3,693 4777 0.10
ges remote message 116,076 97.62 3,692 32 15.61
class slave wait 42 71.43 3,675 87493 0.01
Streams AQ: qmn coordinator idle wait 270 55.19 3,666 13576 0.04
Streams AQ: qmn slave idle wait 128 4.69 3,659 28584 0.02
Streams AQ: waiting for time management or cleanup tasks 1 100.00 1,831 1831301 0.00
PX Deq: Execute Reply 273 19.78 10 38 0.04
PX Deq: Execution Msg 359 8.08 0 1 0.05
PX Deq: Parse Reply 266 36.47 0 1 0.04
PX Deq: Join ACK 266 36.47 0 0 0.04
KSV master wait 9 0.00 0 7 0.00
PX Deq: Msg Fragment 149 3.36 0 0 0.02
PX Deq: Table Q Normal 26 26.92 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 271 100.00 0 0 0.04
PX Deq Credit: need buffer 7 57.14 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 523,550 98.58 1,437 3 70.39
control file sequential read 15,618 0.00 26 2 2.10
log file parallel write 4,194 0.00 10 2 0.56
control file parallel write 2,491 0.00 8 3 0.33
db file parallel write 2,584 0.00 6 2 0.35
db file sequential read 218 0.00 1 6 0.03
gc current block 2-way 2,341 0.00 1 0 0.31
log file sequential read 24 0.00 0 17 0.00
row cache lock 296 0.00 0 1 0.04
gc current grant busy 29 0.00 0 7 0.00
db file parallel read 17 0.00 0 7 0.00
gc cr multi block request 570 0.00 0 0 0.08
os thread startup 4 0.00 0 19 0.00
db file scattered read 6 0.00 0 7 0.00
gc cr block busy 11 0.00 0 4 0.00
gc cr block 2-way 83 0.00 0 0 0.01
direct path read 26 0.00 0 0 0.00
Log archive I/O 21 0.00 0 0 0.00
gc current grant 2-way 22 0.00 0 0 0.00
gc object scan 531 100.00 0 0 0.07
undo segment extension 827 100.00 0 0 0.11
enq: TM - contention 3 0.00 0 0 0.00
buffer busy waits 12 0.00 0 0 0.00
library cache pin 1 0.00 0 0 0.00
log file single write 2 0.00 0 0 0.00
latch: cache buffers chains 10 0.00 0 0 0.00
direct path write 26 0.00 -0 -0 0.00
rdbms ipc message 64,263 86.85 58,373 908 8.64
gcs remote message 1,190,529 99.36 21,371 18 160.06
pmon timer 1,889 100.00 3,694 1956 0.25
DIAG idle wait 18,909 0.00 3,694 195 2.54
smon timer 773 0.00 3,693 4778 0.10
ASM background timer 773 0.00 3,693 4777 0.10
ges remote message 116,143 97.60 3,692 32 15.61
class slave wait 39 76.92 3,675 94223 0.01
Streams AQ: qmn coordinator idle wait 270 55.19 3,666 13576 0.04
Streams AQ: qmn slave idle wait 128 4.69 3,659 28584 0.02
Streams AQ: waiting for time management or cleanup tasks 1 100.00 1,831 1831301 0.00
KSV master wait 9 0.00 0 7 0.00
PX Deq: Join ACK 30 40.00 0 0 0.00
PX Deq: Parse Reply 30 40.00 0 0 0.00
PX Deq: Execute Reply 21 28.57 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 271 100.00 0 0 0.04

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 75,330
IDLE_TIME 9,002,856
IOWAIT_TIME 56,126
NICE_TIME 0
SYS_TIME 16,603
USER_TIME 50,765
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 33,747,128,320
NUM_CPUS 24
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
G1db 96,371.50 492.00 1,536,928 40,552,234
SYS$USERS 433.10 12.80 9,881 136,918
SYS$BACKGROUND 0.00 0.00 1,534 95,042

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
G1db 160242 41752 5320 300237 0 0 125705 8
SYS$USERS 9272 4589 211 17244 0 0 4598 1
SYS$BACKGROUND 1438 678 324 27 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
60,900 0 178 342.13 62.91 gzt34x6x7p8r0   UPDATE TMSTPOS SET TM_SMP=:1, ...
22,140 0 1 22139.58 22.87 gtpuh24u3cr3d   UPDATE TMSTPOS Set ...
1,939 0 478 4.06 2.00 8cryq35k225g0   UPDATE HPSTJNL SET TM_S...
1,938 0 149 13.01 2.00 72zqywap3utzv   INSERT INTO HPSTSJNL (AC_DT, T...
1,352 0 65 20.81 1.40 0hpnx35mqhhpg   INSERT INTO HPSTSJNL (AC_DT, T...
861 0 220 3.92 0.89 1v2p6m8d45ugy   UPDATE PUBSEQREC SET TM_SMP=:1...
838 0 17 49.28 0.87 gmvpuabz0upuy   INSERT INTO HPSTJNL (TXN_CD, C...
579 0 324 1.79 0.60 akmdds936uwup   INSERT INTO CMMTOPLG(TM_SMP, ...
495 4 22 22.52 0.51 ba10x084yqdmg   SELECT LOG_NO, AC_DT OAC_DT, T...
331 0 25 13.22 0.34 3b873nssv9bgt JDBC Thin Client insert into TIMING_TASK_LOG (E...

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
85 220 72 1.18 0.23 21mszhdh48c8b   UPDATE pubigtjnl SET STS = '4'...
63 165 72 0.88 0.17 18ng21jkmu4r3   UPDATE pubigtjnl SET STS = '1'...
44 90 72 0.61 0.09 2sxc8ayf8jzwv   SELECT TRAN_ID, LOG_NO, EXP_SE...
39 83 72 0.54 0.09 b4rwmd2njqqb3   UPDATE pubigtjnl SET STS = '1'...
37 105 371 0.10 0.11 4z72p16nrg35t   SELECT LOG_NO FROM...
13 42 3 4.39 0.04 2u0qnkndnbqb2   SELECT COUNT(TXN_TM) YC FROM H...
13 64 1 13.13 0.07 ffgkp4m35ad6v JDBC Thin Client select SUM(CASE WHEN DC_FLG = ...
13 62 1 12.79 0.06 9jq64v57cgujy JDBC Thin Client select * from ( select merchan...
13 43 1 12.60 0.04 fhhf6ykmbjv7w JDBC Thin Client select SUM(CASE WHEN DC_FLG = ...
13 54 1 12.53 0.06 34y4xcv9t20x6 JDBC Thin Client select count(*) as col_0_0_ fr...
0 60,900 178 0.00 62.91 gzt34x6x7p8r0   UPDATE TMSTPOS SET TM_SMP=:1, ...
0 1,938 149 0.00 2.00 72zqywap3utzv   INSERT INTO HPSTSJNL (AC_DT, T...
0 1,939 478 0.00 2.00 8cryq35k225g0   UPDATE HPSTJNL SET TM_S...
0 1,352 65 0.00 1.40 0hpnx35mqhhpg   INSERT INTO HPSTSJNL (AC_DT, T...
0 22,140 1 0.10 22.87 gtpuh24u3cr3d   UPDATE TMSTPOS Set ...

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
4,409,292 72 61,240.17 10.82 85.03 220.09 21mszhdh48c8b   UPDATE pubigtjnl SET STS = '4'...
4,409,288 72 61,240.11 10.82 43.81 89.56 2sxc8ayf8jzwv   SELECT TRAN_ID, LOG_NO, EXP_SE...
4,409,286 72 61,240.08 10.82 63.20 164.79 18ng21jkmu4r3   UPDATE pubigtjnl SET STS = '1'...
4,409,283 72 61,240.04 10.82 39.14 83.42 b4rwmd2njqqb3   UPDATE pubigtjnl SET STS = '1'...
4,209,392 371 11,346.07 10.33 37.15 105.21 4z72p16nrg35t   SELECT LOG_NO FROM...
2,925,400 100 29,254.00 7.18 10.76 13.39 cvzyymfbqx0uz   select * from (Select F...
789,737 4 197,434.25 1.94 2.63 2.63 1p18937m44s1s   SELECT COUNT(B.LOG_NO) YC FROM...
789,688 4 197,422.00 1.94 2.44 2.44 3q8xwrhs71v16   SELECT COUNT(TXN_TM) YC FROM H...
789,688 4 197,422.00 1.94 2.49 2.49 5ts4gcmzv3ju6   SELECT COUNT(TXN_TM) YC FROM H...
789,688 4 197,422.00 1.94 2.70 3.17 8uvnjbv62a5vd   SELECT COUNT(B.LOG_NO) YC FROM...
789,688 4 197,422.00 1.94 2.64 2.64 9aujnnr5jdmac   SELECT COUNT(TXN_TM) YC FROM H...
789,688 4 197,422.00 1.94 7.80 19.62 gc94vahcnqf8q   SELECT COUNT(TXN_TM) YC FROM H...
718,961 0   1.76 4.33 12.86 awyuzsx1nzhbq   SELECT (CASE WHEN (SELE...
659,719 3 219,906.33 1.62 13.16 42.34 2u0qnkndnbqb2   SELECT COUNT(TXN_TM) YC FROM H...
644,303 10 64,430.30 1.58 7.02 10.56 3j5241r66nxuy   select * from (SELECT ROWNUM R...
461,448 408 1,131.00 1.13 5.31 5.33 1a6xa13xdmbqk JDBC Thin Client select points0_.TRADE_TRANSACT...

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
234,619 1 234,619.00 15.16 12.60 42.78 fhhf6ykmbjv7w JDBC Thin Client select SUM(CASE WHEN DC_FLG = ...
234,234 1 234,234.00 15.13 12.53 53.52 34y4xcv9t20x6 JDBC Thin Client select count(*) as col_0_0_ fr...
233,996 1 233,996.00 15.12 12.79 61.81 9jq64v57cgujy JDBC Thin Client select * from ( select merchan...
232,568 1 232,568.00 15.02 13.13 64.09 ffgkp4m35ad6v JDBC Thin Client select SUM(CASE WHEN DC_FLG = ...
145,437 72 2,019.96 9.39 85.03 220.09 21mszhdh48c8b   UPDATE pubigtjnl SET STS = '4'...
108,820 72 1,511.39 7.03 43.81 89.56 2sxc8ayf8jzwv   SELECT TRAN_ID, LOG_NO, EXP_SE...
105,057 72 1,459.13 6.79 39.14 83.42 b4rwmd2njqqb3   UPDATE pubigtjnl SET STS = '1'...
104,148 72 1,446.50 6.73 63.20 164.79 18ng21jkmu4r3   UPDATE pubigtjnl SET STS = '1'...
53,121 1 53,121.00 3.43 3.49 14.44 0vv6wkbsswqy2 JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
34,876 1 34,876.00 2.25 2.90 7.88 3uvuf0skd5kwn JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
33,819 1 33,819.00 2.18 3.24 13.10 a2p5jz512thmt JDBC Thin Client select sum(CASE WHEN TXN_CD = ...

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
5,139 5,143 1.00 0.00 0.00 520mkxqpf15q8   select 1 from dual
4,570 4,570 1.00 0.00 0.00 39jk1sd6mm65v   SELECT * FROM HPSTRULE WHERE R...
2,634 7,538 2.86 0.00 0.00 g97f7f972atab   SELECT DISTINCT(RUL_ID) AS RUL...
1,939 1,938 1.00 0.00 0.00 8mqvtww43thvj   select SYS_VER_NO, WIN_MODE, W...
1,939 1,939 1.00 0.00 0.00 gbdtgmzym5036   select to_char(sysdate, 'YYYYM...
1,677 30 0.02 0.00 0.00 d4bw42jjybuqv   SELECT * FROM HPSTOPER WHERE R...
1,483 0 0.00 0.00 0.00 6jf6rjsd8wr3s   SELECT * FROM PUBBSPCTL WHERE ...
1,483 1,481 1.00 0.00 0.00 fs98fpjmf4ku5   SELECT CUR_AC_DT AC_DT FROM PU...
1,481 1,480 1.00 0.00 0.00 awq100hfhvwbs   SELECT min(BAT_NO) BAT_NO FRO...
1,282 1 0.00 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
1,224 577 0.47 0.00 0.00 28v3bhh9qfwca   SELECT * FROM HPSTRURC WHERE R...
1,186 1,186 1.00 0.00 0.00 1x2qxgyw0fn1f   select PUBSJRN.NEXTVAL from du...
1,175 39 0.03 0.00 0.00 a9vqty3tmt5bx   SELECT * FROM HPSTRURC WHERE R...
1,094 1,094 1.00 0.00 0.00 fta7uj8qz3s5v   INSERT INTO ACMTCDDT(JRN_NO, J...
758 758 1.00 0.00 0.00 7ndyz6bdvh9zv   SELECT ACC_DT FROM pubpltinf
720 720 1.00 0.00 0.00 1jpbu18d03apd   SELECT TRM_STS, SGN_STS, TRM_T...
720 720 1.00 0.00 0.00 fpz5gbqmkyfjv   SELECT AC_NO, AC_TYP, ORG_NO, ...
720 720 1.00 0.00 0.00 g4u6hd8jhxtjg   SELECT STL_CLS FR...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
5,095 5,139 7.50 520mkxqpf15q8   select 1 from dual
4,570 4,570 6.72 39jk1sd6mm65v   SELECT * FROM HPSTRULE WHERE R...
2,634 2,634 3.88 g97f7f972atab   SELECT DISTINCT(RUL_ID) AS RUL...
1,939 1,939 2.85 8mqvtww43thvj   select SYS_VER_NO, WIN_MODE, W...
1,939 1,939 2.85 gbdtgmzym5036   select to_char(sysdate, 'YYYYM...
1,677 1,677 2.47 d4bw42jjybuqv   SELECT * FROM HPSTOPER WHERE R...
1,486 1,483 2.19 6jf6rjsd8wr3s   SELECT * FROM PUBBSPCTL WHERE ...
1,486 1,483 2.19 fs98fpjmf4ku5   SELECT CUR_AC_DT AC_DT FROM PU...
1,484 1,481 2.18 awq100hfhvwbs   SELECT min(BAT_NO) BAT_NO FRO...
1,282 1,282 1.89 0h6b2sajwb74n   select privilege#, level from ...
1,224 1,224 1.80 28v3bhh9qfwca   SELECT * FROM HPSTRURC WHERE R...
1,186 1,186 1.75 1x2qxgyw0fn1f   select PUBSJRN.NEXTVAL from du...
1,175 1,175 1.73 a9vqty3tmt5bx   SELECT * FROM HPSTRURC WHERE R...
1,094 1,094 1.61 fta7uj8qz3s5v   INSERT INTO ACMTCDDT(JRN_NO, J...
758 758 1.12 7ndyz6bdvh9zv   SELECT ACC_DT FROM pubpltinf
720 720 1.06 1jpbu18d03apd   SELECT TRM_STS, SGN_STS, TRM_T...
720 720 1.06 fpz5gbqmkyfjv   SELECT AC_NO, AC_TYP, ORG_NO, ...
720 720 1.06 g4u6hd8jhxtjg   SELECT STL_CLS FR...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,355,367 1 0.04 fqmpmkfr6pqyk PlSqlDev.exe select s.synonym_name object_n...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
68 1,094 fta7uj8qz3s5v   INSERT INTO ACMTCDDT(JRN_NO, J...
62 6 5jxwda6s8nvc7   select tablespace_id, rfno, ...
51 1 0cn2wm9d7zq8d   SELECT decode(value, 'FATAL', ...
45 2 a725f79a7f13r   select count(1) TOTAL_NUM from...
41 1 31a13pnjps7j3   SELECT source, (case w...
36 72 18ng21jkmu4r3   UPDATE pubigtjnl SET STS = '1'...
35 6 a1xgxtssv5rrp   select sum(used_blocks), ts.t...
34 12 d1nygjmu0sbfh   select count(1) TOTAL_NUM from...
32 72 2sxc8ayf8jzwv   SELECT TRAN_ID, LOG_NO, EXP_SE...
32 1,481 awq100hfhvwbs   SELECT min(BAT_NO) BAT_NO FRO...
31 1,483 6jf6rjsd8wr3s   SELECT * FROM PUBBSPCTL WHERE ...
29 615 6c0n4uz9q956t   SELECT DLY_PAY_VOL FROM HPSTUR...
28 1 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
27 1 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
26 2 10xj8nynmpqtq   SELECT dbin.db_name, dbin.ins...
26 17 5c0j47g4t44hz   INSERT INTO HPSTJNL (TXN_CD, C...
25 1,483 fs98fpjmf4ku5   SELECT CUR_AC_DT AC_DT FROM PU...
24 220 1v2p6m8d45ugy   UPDATE PUBSEQREC SET TM_SMP=:1...
24 72 21mszhdh48c8b   UPDATE pubigtjnl SET STS = '4'...
24 8 b8bdxv42bdmqw   INSERT INTO HPSTJNL (TXN_CD, C...
23 5 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
22 1,939 8mqvtww43thvj   select SYS_VER_NO, WIN_MODE, W...
21 58 ajptcbg0g7c61   INSERT INTO HPSTJNL (TXN_CD, C...
21 2 dtfczmpcznpqj   select * from (SELECT ROWNUM R...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
1,938.52 99.99 1,938.74 0.23 478 8cryq35k225g0   UPDATE HPSTJNL SET TM_S...
964.23 49.75 1,938.09 0.24 149 72zqywap3utzv   INSERT INTO HPSTSJNL (AC_DT, T...
860.82 99.94 861.32 0.14 220 1v2p6m8d45ugy   UPDATE PUBSEQREC SET TM_SMP=:1...
837.58 99.98 837.74 0.07 17 gmvpuabz0upuy   INSERT INTO HPSTJNL (TXN_CD, C...
704.73 52.11 1,352.38 0.11 65 0hpnx35mqhhpg   INSERT INTO HPSTSJNL (AC_DT, T...
491.93 99.28 495.48 3.58 22 ba10x084yqdmg   SELECT LOG_NO, AC_DT OAC_DT, T...
236.70 99.99 236.71 0.01 1 0xnmr6ravm5p6   UPDATE PUBSEQREC SET TM_SMP='2...
226.69 100.00 226.70 0.00 1 6pztcxmc7d7q9   UPDATE PUBSEQREC SET TM_SMP='2...
219.25 99.99 219.27 0.00 1 8x8ur7mdgkqfn   UPDATE PUBSEQREC SET TM_SMP='2...
180.34 99.98 180.38 0.01 1 0j6nmvyv5757y   UPDATE PUBSEQREC SET TM_SMP='2...
167.53 99.97 167.58 0.00 1 dar43fzk5gksm   UPDATE PUBSEQREC SET TM_SMP='2...
157.36 99.79 157.69 0.39 145 2apymf23d1by7   select a.conn_ty oconn_ty, a.i...
148.95 99.98 148.99 0.00 1 fufxpmpq862jt   UPDATE PUBSEQREC SET TM_SMP='2...
133.71 99.83 133.94 0.01 1 djqn581w0b971   UPDATE PUBSEQREC SET TM_SMP='2...
99.22 45.08 220.09 85.03 72 21mszhdh48c8b   UPDATE pubigtjnl SET STS = '4'...
70.41 42.73 164.79 63.20 72 18ng21jkmu4r3   UPDATE pubigtjnl SET STS = '1'...
63.28 60.14 105.21 37.15 371 4z72p16nrg35t   SELECT LOG_NO FROM...
26.95 63.65 42.34 13.16 3 2u0qnkndnbqb2   SELECT COUNT(TXN_TM) YC FROM H...
20.25 22.62 89.56 43.81 72 2sxc8ayf8jzwv   SELECT TRAN_ID, LOG_NO, EXP_SE...
19.87 23.82 83.42 39.14 72 b4rwmd2njqqb3   UPDATE pubigtjnl SET STS = '1'...
14.87 24.06 61.81 12.79 1 9jq64v57cgujy JDBC Thin Client select * from ( select merchan...
13.92 70.95 19.62 7.80 4 gc94vahcnqf8q   SELECT COUNT(TXN_TM) YC FROM H...
11.79 18.39 64.09 13.13 1 ffgkp4m35ad6v JDBC Thin Client select SUM(CASE WHEN DC_FLG = ...
11.38 69.60 16.34 7.00 2 6nukz8p8yns9f JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
10.92 70.88 15.41 6.90 2 9u2j1ja60gh24 JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
10.87 20.31 53.52 12.53 1 34y4xcv9t20x6 JDBC Thin Client select count(*) as col_0_0_ fr...
10.79 25.22 42.78 12.60 1 fhhf6ykmbjv7w JDBC Thin Client select SUM(CASE WHEN DC_FLG = ...
6.07 71.38 8.51 2.90 1 40a0zbkvumvzv JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
5.58 38.64 14.44 3.49 1 0vv6wkbsswqy2 JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
5.45 71.07 7.67 3.37 1 9awdwbs89qv9p JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
5.42 42.18 12.86 4.33 0 awyuzsx1nzhbq   SELECT (CASE WHEN (SELE...
5.22 39.83 13.10 3.24 1 a2p5jz512thmt JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
5.17 70.31 7.36 3.45 1 511ws0h7r0zb6 JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
3.90 36.96 10.56 7.02 10 3j5241r66nxuy   select * from (SELECT ROWNUM R...
3.13 23.35 13.39 10.76 100 cvzyymfbqx0uz   select * from (Select F...
2.23 28.28 7.88 2.90 1 3uvuf0skd5kwn JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
1.91 3.96 48.13 3.82 2 djs2w2f17nw2z   DECLARE job BINARY_INTEGER := ...
0.50 15.90 3.17 2.70 4 8uvnjbv62a5vd   SELECT COUNT(B.LOG_NO) YC FROM...
0.13 24.44 0.55 0.29 12 d1nygjmu0sbfh   select count(1) TOTAL_NUM from...
0.13 6.90 1.94 0.65 1,094 fta7uj8qz3s5v   INSERT INTO ACMTCDDT(JRN_NO, J...
0.11 15.59 0.70 0.43 720 g4u6hd8jhxtjg   SELECT STL_CLS FR...
0.06 42.68 0.14 0.14 485 61hcjrkbxxhb3   SELECT MAC_KEY, PIN_KEY ...
0.05 0.00 60,899.58 0.33 178 gzt34x6x7p8r0   UPDATE TMSTPOS SET TM_SMP=:1, ...
0.05 0.02 330.59 0.12 25 3b873nssv9bgt JDBC Thin Client insert into TIMING_TASK_LOG (E...
0.05 21.56 0.23 0.03 17 5c0j47g4t44hz   INSERT INTO HPSTJNL (TXN_CD, C...
0.05 0.02 196.26 0.01 1 90myqygn6ty8n   UPDATE HPSTAMTACC SET TM_SMP='...
0.03 35.60 0.09 0.09 720 fpz5gbqmkyfjv   SELECT AC_NO, AC_TYP, ORG_NO, ...
0.03 0.02 169.45 0.09 133 8141n46hbgfhy   INSERT INTO PUBTLOGJNL (JRN_NO...
0.03 35.08 0.09 0.06 58 ajptcbg0g7c61   INSERT INTO HPSTJNL (TXN_CD, C...
0.03 31.61 0.09 0.09 720 1jpbu18d03apd   SELECT TRM_STS, SGN_STS, TRM_T...
0.03 4.80 0.56 0.50 1 fqmpmkfr6pqyk PlSqlDev.exe select s.synonym_name object_n...
0.02 46.21 0.05 0.05 6 a1xgxtssv5rrp   select sum(used_blocks), ts.t...
0.02 0.01 148.45 0.01 1 67j5s0j0sy99n   UPDATE pubpltinf SET TM_SMP='2...
0.02 0.01 155.36 0.00 1 aq8yqxyyb40nn   update sys.job$ set this_date=...
0.02 16.87 0.09 0.09 758 7ndyz6bdvh9zv   SELECT ACC_DT FROM pubpltinf
0.02 0.58 2.63 2.63 4 1p18937m44s1s   SELECT COUNT(B.LOG_NO) YC FROM...
0.01 21.44 0.05 0.05 614 d7nk6dja4wwzk   SELECT DLY_STL_AMT FROM HPSTMR...
0.01 14.27 0.05 0.02 5 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
0.01 72.39 0.01 0.01 3 8vkjh60z1g287   select OBJOID, CLSOID, RUNT...
0.01 13.68 0.04 0.04 615 6c0n4uz9q956t   SELECT DLY_PAY_VOL FROM HPSTUR...
0.01 36.67 0.02 0.02 8 b8bdxv42bdmqw   INSERT INTO HPSTJNL (TXN_CD, C...
0.01 22.91 0.02 0.01 6 dygyrnv17cyv2   INSERT INTO HPSTJNL (TXN_CD, C...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0cn2wm9d7zq8dSELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0hpnx35mqhhpgINSERT INTO HPSTSJNL (AC_DT, TM_SMP, LOG_NO, TXN_TM, APP_VER, CSEQ_NO, TRM_OPERAT, TRM_SN, APP_NUM) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9)
0j6nmvyv5757yUPDATE PUBSEQREC SET TM_SMP='20120814115935', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='BOC' AND SEQ_CND='BOC'
0vv6wkbsswqy2select sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -TXN_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN TXN_AMT ELSE 0 END) txnMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN FEE_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN -FEE_AMT ELSE 0 END) feeMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -ACT_STL_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN ACT_STL_AMT ELSE 0 END) actMoney from RPT_SETTLETRADE_DETAIL where 1=1 and MERC_ID= 800000358120083 and jrn_no= 201208130005780186 and ac_dt= 20120813
0xnmr6ravm5p6UPDATE PUBSEQREC SET TM_SMP='20120814115837', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='BOC' AND SEQ_CND='BOC'
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
18ng21jkmu4r3UPDATE pubigtjnl SET STS = '1', TM_SMP = :1 WHERE REG_ID=:2 and NOD_ID=:3 and STS = '0' AND OPR_CLK + TIM_OUT < :4
1a6xa13xdmbqkselect points0_.TRADE_TRANSACTION_ID as TRADE10_1_, points0_.id as id1_, points0_.id as id22_0_, points0_.type as type22_0_, points0_.CREATE_DATE as CREATE3_22_0_, points0_.DESCRIPTION as DESCRIPT4_22_0_, points0_.MEMBER_ID as MEMBER8_22_0_, points0_.MERCHANT_ID as MERCHANT9_22_0_, points0_.POINT as POINT22_0_, points0_.TOTAL_POINT as TOTAL6_22_0_, points0_.TRADE_TRANSACTION_ID as TRADE10_22_0_, points0_.USEABLE_POINT as USEABLE7_22_0_ from MEMBER_POINT_DETAIL points0_ where points0_.TRADE_TRANSACTION_ID=:1
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# (+)
1jpbu18d03apdSELECT TRM_STS, SGN_STS, TRM_TYP, PM_DW_FLG, EMV_DW_FLG, PRV_FLG, BAT_NO, TRM_KEY, MAC_KEY, PIN_KEY, RFD_FLG AS POS_RFD_FLG, SFT_VER, OFF_FLG, SIG_DT, INS_AD, DATA_KEY, DATA_KEY_TS, SATTLE_SMP FROM TMSTPOS WHERE MERC_ID=:1 AND TRM_NO=:2
1p18937m44s1sSELECT COUNT(B.LOG_NO) YC FROM HPSTJNL A, HPSTJNL B WHERE A.TXN_CD = '2010030' AND A.TXN_TYP!='C' AND A.TTXN_STS='S' AND A.TRSP_CD='000000' AND A.TXN_TM BETWEEN :1 AND :2 AND B.LOG_NO=A.OLOG_NO AND B.TXN_TYP!='D'
1v2p6m8d45ugyUPDATE PUBSEQREC SET TM_SMP=:1, SEL_VAL = SEL_VAL WHERE BR_NO=:2 AND SEQ_NM=:3 AND SEQ_CND=:4
1x2qxgyw0fn1fselect PUBSJRN.NEXTVAL from dual
21mszhdh48c8bUPDATE pubigtjnl SET STS = '4', TM_SMP = :1 WHERE REG_ID=:2 and NOD_ID=:3 and STS = '2' AND FAL_TMS > MAX_TMS
28v3bhh9qfwcaSELECT * FROM HPSTRURC WHERE RRC_TYP = :1 AND RUL_ID = :2 AND RSK_PARM1 = :3 AND (TO_NUMBER(:4) >= RSK_PARM_VAL1)
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2apymf23d1by7select a.conn_ty oconn_ty, a.ins_dt, b.reg_flg, a.trm_sn from tmstpos a, tmststkif b where a.merc_id =:1 and a.trm_no=:2 and a.merc_id=b.merc_id and a.trm_no=b.trm_no
2sxc8ayf8jzwvSELECT TRAN_ID, LOG_NO, EXP_SER, OBJ_SVR, TM_OUT, OPR_CLK, FAL_TMS, ITV, DATA FROM pubigtjnl WHERE REG_ID=:1 and NOD_ID=:2 and STS = '1' ORDER BY OPR_CLK FOR UPDATE
2u0qnkndnbqb2SELECT COUNT(TXN_TM) YC FROM HPSTJNL T WHERE T.TXN_TM BETWEEN :1 AND :2
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
34y4xcv9t20x6select count(*) as col_0_0_ from ACMTCDDT merchantac0_ where 1=1 and (merchantac0_.MERC_ID in (:1 , :2)) and (merchantac0_.TX_CD in (:3 , :4 , :5 , :6 , :7 , :8 , :9)) and (merchantac0_.CAP_TYP not in (:10 , :11)) and not (exists (select merchantac1_.VCH_NO from ACMTCDDT merchantac1_ where merchantac1_.VCH_NO=merchantac0_.VCH_NO and merchantac1_.TX_CD='2010019'))
39jk1sd6mm65vSELECT * FROM HPSTRULE WHERE RUL_ID = :1 AND CHK_END_FLG = 'N'
3b873nssv9bgtinsert into TIMING_TASK_LOG (END_DATE, RESULT_DESC, START_DATE, success, TASK_NAME, id) values (:1, :2, :3, :4, :5, :6)
3j5241r66nxuyselect * from (SELECT ROWNUM RN, TA.* FROM( SELECT A.AC_DT, A.MERC_ID, substr(A.crd_no, 1, 6)||'******'||substr(A.crd_no, 13, 8) CRD_NO, A.TXN_CD, A.TXN_TM, A.BAT_NO, A.CSEQ_NO, A.TRM_NO, A.TXN_AMT, A.MERC_FEE_AMT, A.LOG_NO, B.MERC_MOD, DECODE(B.MERC_MOD, '0', '', B.CHN_REL_FLG) CHN_REL_FLG, A.CRD_FLG FROM HPSTJNL A, URMTMINF B WHERE (:1 IS NULL OR A.MERC_ID=:2) AND (:3 IS NULL OR A.TXN_CD=:4) AND (A.AC_DT BETWEEN :5 AND :6) AND (:7 IS NULL OR A.CSEQ_NO=:8) AND A.TXN_TYP!='C' AND A.TTXN_STS='S' AND A.TXN_CD!='2010090' AND A.MERC_ID=B.MERC_ID AND 1=1 )TA)TA WHERE RN <= :9 and RN>= :10
3q8xwrhs71v16SELECT COUNT(TXN_TM) YC FROM HPSTJNL T WHERE T.TTXN_STS= 'X' AND T.TXN_TM BETWEEN :1 AND :2
3uvuf0skd5kwnselect sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -TXN_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN TXN_AMT ELSE 0 END) txnMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN FEE_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN -FEE_AMT ELSE 0 END) feeMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -ACT_STL_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN ACT_STL_AMT ELSE 0 END) actMoney from RPT_SETTLETRADE_DETAIL where 1=1 and MERC_ID= 800000358120096 and jrn_no= 201208130005780186 and ac_dt= 20120813
40a0zbkvumvzvselect sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -TXN_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN TXN_AMT ELSE 0 END) txnMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN FEE_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN -FEE_AMT ELSE 0 END) feeMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -ACT_STL_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN ACT_STL_AMT ELSE 0 END) actMoney from RPT_SETTLETRADE_DETAIL where 1=1 and TRM_NO= 81003364 and jrn_no= 201208130005780186 and ac_dt= 20120813
4z72p16nrg35tSELECT LOG_NO FROM HPSTJNL WHERE TRM_NO=:1 AND MERC_ID =:2 AND BAT_NO =:3 AND CSEQ_NO=:4
511ws0h7r0zb6select sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -TXN_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN TXN_AMT ELSE 0 END) txnMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN FEE_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN -FEE_AMT ELSE 0 END) feeMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -ACT_STL_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN ACT_STL_AMT ELSE 0 END) actMoney from RPT_SETTLETRADE_DETAIL where 1=1 and TRM_NO= 81003364 and jrn_no= 201208110005717642 and ac_dt= 20120811
520mkxqpf15q8select 1 from dual
5c0j47g4t44hzINSERT INTO HPSTJNL (TXN_CD, CORG_MERC_ID, EMV_FLG, CSEQ_NO, CORG_RAT, CTXN_DT, ACQ_RSV, TRSP_CD, CORG_TRM_NO, ORG_NO, CORG_BAT_NO, OLOG_NO, AC_DT, TM_SMP, COUP_FLG, BTX_ST, CRD_FLG, LOG_NO, CORG_FEE_AMT, MEM_NO, CRD_NO, FM_MERC_ID, TRM_NO, CORG_CSEQ_NO, BNK_TYP, CORG_REB_RAT, IN_MOD, CORG_NO, MCC_CD, AUT_CD, MERC_FEE_AMT, MERC_ID, TXN_TM, POS_OPR_ID, TXN_RSV1, CCY, RTR_SVR, BLOG_NO, REF_AMT, TXN_AMT, PRO_COD, BAT_NO, BD_FLG, CTXN_TM) 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, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44)
5jxwda6s8nvc7select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))
5ts4gcmzv3ju6SELECT COUNT(TXN_TM) YC FROM HPSTJNL T WHERE T.TXN_STS='T' AND T.TXN_TM BETWEEN :1 AND :2
61hcjrkbxxhb3SELECT MAC_KEY, PIN_KEY FROM TMSTPOS WHERE MERC_ID=:1 AND TRM_NO=:2
67j5s0j0sy99nUPDATE pubpltinf SET TM_SMP='20120814120008', Log_No = Log_No
6c0n4uz9q956tSELECT DLY_PAY_VOL FROM HPSTURDY WHERE STL_USR_ID = :1 AND PAY_CARD_ID = :2 AND TOT_DAY = :3
6jf6rjsd8wr3sSELECT * FROM PUBBSPCTL WHERE INST_ID = :1 AND SRV_ID = :2 AND (STATUS = 'W' OR (STATUS = 'P' AND PRE_STS NOT IN ('E', 'F') AND PROC_STS NOT IN ('E', 'F') AND AFTER_STS NOT IN ('E', 'F'))) ORDER BY TM_SMP
6nukz8p8yns9fselect sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -TXN_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN TXN_AMT ELSE 0 END) txnMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN FEE_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN -FEE_AMT ELSE 0 END) feeMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -ACT_STL_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN ACT_STL_AMT ELSE 0 END) actMoney from RPT_SETTLETRADE_DETAIL where 1=1 and TRM_NO= 81003363 and jrn_no= 201208130005780186 and ac_dt= 20120813
6pztcxmc7d7q9UPDATE PUBSEQREC SET TM_SMP='20120814115847', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='CUP' AND SEQ_CND='CUP'
72zqywap3utzvINSERT INTO HPSTSJNL (AC_DT, TM_SMP, LOG_NO, TXN_TM, APP_VER, CSEQ_NO, TRM_SN, APP_NUM) VALUES (:1, :2, :3, :4, :5, :6, :7, :8)
7ndyz6bdvh9zvSELECT ACC_DT FROM pubpltinf
8141n46hbgfhyINSERT INTO PUBTLOGJNL (JRN_NO, SYS_CNL, PROC_TM, TXN_MOD, MSG_CD, TX_CD, NOD_ID, SYS_TM, TX_DT, MSG_TYP, AC_DT, TM_SMP, SYS_DT, REG_ID, SIP, STE, SVR_NM, MSG_ID, TX_TM, BUS_CNL, BEG_TM) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21)
8cryq35k225g0UPDATE HPSTJNL SET TM_SMP=:1, CPS_CD=:2 WHERE LOG_NO=:3
8mqvtww43thvjselect SYS_VER_NO, WIN_MODE, WIN_STS, WIN_BEG_TM, WIN_END_TM, LAST_AC_DT, LAST_AC_DT_FLG, LAST_AC_DT2, LAST_AC_DT2_FLG, CUR_AC_DT, CUR_AC_DT_FLG, NEXT_AC_DT, NEXT_AC_DT_FLG, WIN_SW_TM, WIN_DT1, WIN_DT2 from pubtrsts
8uvnjbv62a5vdSELECT COUNT(B.LOG_NO) YC FROM HPSTJNL A, HPSTJNL B WHERE A.TXN_CD = '2010030' AND A.TXN_TYP='C' AND A.TTXN_STS='C' AND A.TRSP_CD='000000' AND A.TXN_TM BETWEEN :1 AND :2 AND B.LOG_NO=A.OLOG_NO AND B.TXN_TYP='D'
8vkjh60z1g287 select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
8x8ur7mdgkqfnUPDATE PUBSEQREC SET TM_SMP='20120814115855', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='CUP' AND SEQ_CND='CUP'
90myqygn6ty8nUPDATE HPSTAMTACC SET TM_SMP='20120814115918', ACC_DT='20120814', DAY_ACC_QU=0 WHERE MERC_ID='800000358120062'
9aujnnr5jdmacSELECT COUNT(TXN_TM) YC FROM HPSTJNL T WHERE T.TRSP_CD='000000' AND T.TXN_CD = '2010020' AND T.TXN_TYP='N' AND T.TTXN_STS != 'S' AND T.TXN_TM BETWEEN :1 AND :2
9awdwbs89qv9pselect sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -TXN_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN TXN_AMT ELSE 0 END) txnMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN FEE_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN -FEE_AMT ELSE 0 END) feeMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -ACT_STL_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN ACT_STL_AMT ELSE 0 END) actMoney from RPT_SETTLETRADE_DETAIL where 1=1 and TRM_NO= 81003363 and jrn_no= 201208110005717642 and ac_dt= 20120811
9jq64v57cgujyselect * from ( select merchantac0_.JRN_NO as JRN1_2_, merchantac0_.JRN_SEQ as JRN2_2_, merchantac0_.CR_AMT as CR3_2_, merchantac0_.BAL as BAL2_, merchantac0_.DC_FLG as DC5_2_, merchantac0_.DR_AMT as DR6_2_, merchantac0_.MERC_ID as MERC18_2_, merchantac0_.CAP_TYP as CAP19_2_, merchantac0_.AC_NO as AC20_2_, merchantac0_.RMK as RMK2_, merchantac0_.AC_DT as AC8_2_, merchantac0_.STL_AC_DT as STL9_2_, merchantac0_.STL_JRN_NO as STL10_2_, merchantac0_.STL_JRN_SEQ as STL11_2_, merchantac0_.STL_ORD_STS as STL12_2_, merchantac0_.TX_CD as TX13_2_, merchantac0_.TM_SMP as TM14_2_, merchantac0_.TX_AMT as TX15_2_, merchantac0_.TX_DESC as TX16_2_, merchantac0_.VCH_NO as VCH17_2_ from ACMTCDDT merchantac0_ where 1=1 and (merchantac0_.MERC_ID in (:1 , :2)) and (merchantac0_.TX_CD in (:3 , :4 , :5 , :6 , :7 , :8 , :9)) and (merchantac0_.CAP_TYP not in (:10 , :11)) and not (exists (select merchantac1_.VCH_NO from ACMTCDDT merchantac1_ where merchantac1_.VCH_NO=merchantac0_.VCH_NO and merchantac1_.TX_CD='2010019')) order by merchantac0_.TM_SMP desc ) where rownum <= :12
9u2j1ja60gh24select sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -TXN_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN TXN_AMT ELSE 0 END) txnMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN FEE_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN -FEE_AMT ELSE 0 END) feeMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -ACT_STL_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN ACT_STL_AMT ELSE 0 END) actMoney from RPT_SETTLETRADE_DETAIL where 1=1 and TRM_NO= 81003364 and jrn_no= 201208100005690484 and ac_dt= 20120810
a1xgxtssv5rrpselect sum(used_blocks), ts.ts# from GV$SORT_SEGMENT gv, ts$ ts where gv.tablespace_name = ts.name and ts.bitmapped <> 0 group by ts.ts#
a2p5jz512thmtselect sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -TXN_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN TXN_AMT ELSE 0 END) txnMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN FEE_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN -FEE_AMT ELSE 0 END) feeMoney, sum(CASE WHEN TXN_CD = '2010030' or TXN_CD = '2010070' or TXN_CD = '2010080' THEN -ACT_STL_AMT WHEN TXN_CD = '2010020' or TXN_CD = '2010060' THEN ACT_STL_AMT ELSE 0 END) actMoney from RPT_SETTLETRADE_DETAIL where 1=1 and TRM_NO= 81003363 and jrn_no= 201208100005690484 and ac_dt= 20120810
a725f79a7f13rselect count(1) TOTAL_NUM from(SELECT A.AC_DT, A.TXN_TM, A.CRD_NO, A.TXN_AMT, A.TXN_CD, A.MERC_ID, A.CORG_MERC_ID, A.TRM_NO, A.BAT_NO, A.CSEQ_NO, A.LOG_NO, B.MERC_ABBR, B.MERC_HOT_LIN, B.MERC_POS_AD, B.MERC_ATTR, C.CORG_NM, D.CTT_PSN_CNM, D.MBL_TEL, D.FIX_TEL FROM HPSTJNL A, URMTMINF B, CMMTCORG C, URMTMCNT D WHERE (:1 IS NULL OR A.CRD_NO=:2) AND (:3 IS NULL OR A.TXN_CD=:4) AND (:5 IS NULL OR A.MERC_ID=:6) AND (A.AC_DT BETWEEN :7 AND :8) AND (:9 IS NULL OR A.CORG_NO=:10) AND A.TXN_TYP!='C' AND A.TTXN_STS='S' AND A.TXN_CD!='2010090' AND D.CTT_PSN_TYP='5' AND A.MERC_ID=B.MERC_ID AND A.CORG_NO=C.CORG_NO AND A.MERC_ID=D.MERC_ID AND 1=1 )
a9vqty3tmt5bxSELECT * FROM HPSTRURC WHERE RRC_TYP = :1 AND RUL_ID = :2 AND RSK_PARM1 = :3 AND (TO_NUMBER(:4) >= RSK_PARM_VAL1) ORDER BY TO_NUMBER(RSK_PARM_VAL1) DESC
ajptcbg0g7c61INSERT INTO HPSTJNL (TXN_CD, CORG_MERC_ID, EMV_FLG, CSEQ_NO, CORG_RAT, CTXN_DT, TRSP_CD, CORG_TRM_NO, ORG_NO, CORG_BAT_NO, AC_DT, TM_SMP, COUP_FLG, CRD_FLG, LOG_NO, CORG_FEE_AMT, MEM_NO, CRD_NO, FM_MERC_ID, TXN_RSV3, TRM_NO, CORG_CSEQ_NO, BNK_TYP, CORG_REB_RAT, IN_MOD, CORG_NO, MCC_CD, MERC_FEE_AMT, MERC_ID, TXN_TM, POS_OPR_ID, TXN_RSV1, CCY, RTR_SVR, BLOG_NO, TXN_AMT, PRO_COD, BAT_NO, BD_FLG, CTXN_TM) 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, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40)
akmdds936uwupINSERT INTO CMMTOPLG(TM_SMP, SYS_DT, SYS_TM, JRN_NO, AC_DT, OPR_PROV, OPR_CITY, OPR_DEPT, OPR_ID, TX_TYP, TX_CD, BUS_TYP, BUS_ACP_CNL, SYS_ACS_CNL, IP_ADDR, PHY_ADDR, DAT_FMT, DAT_INF) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
awq100hfhvwbsSELECT min(BAT_NO) BAT_NO FROM PUBBSPCTL WHERE INST_ID = :1 AND TRIM(SRV_ID) IS NULL AND STATUS = 'W' AND ((DUE_DT_CTRL = '0') OR (DUE_DT_CTRL = '1' AND DUE_DT = :2) OR (DUE_DT_CTRL = '2' AND DUE_DT <= :3)) AND DUE_BGN_TM <= :4 AND DUE_END_TM >= :5 AND (TOTAL_CNT >= :6 AND TOTAL_CNT < :7)
awyuzsx1nzhbqSELECT (CASE WHEN (SELECT COUNT(TXN_TM) FNUM FROM HPSTJNL T WHERE T.TXN_TM BETWEEN :1 AND :2 AND T.TXN_CD>'2010090')!=0 THEN ROUND((SELECT COUNT(TXN_TM) FNUM FROM (SELECT TXN_TM FROM HPSTJNL T WHERE T.TTXN_STS!='S' AND T.TXN_TM BETWEEN :3 AND :4 AND T.TXN_CD>'2010090' AND T.TXN_CD<'2010160' UNION ALL SELECT TXN_TM FROM HPSTJNL T WHERE T.TXN_STS!='S' AND T.TXN_TM BETWEEN :5 AND :6 AND T.TXN_CD ='2010160' ) )*100/ (SELECT COUNT(TXN_TM) FNUM FROM HPSTJNL T WHERE T.TXN_TM BETWEEN :7 AND :8 AND T.TXN_CD>'2010090'), 2) ELSE 0 END )YC FROM DUAL
b4rwmd2njqqb3UPDATE pubigtjnl SET STS = '1', FAL_TMS = FAL_TMS + 1, TM_SMP = :1 WHERE REG_ID=:2 and NOD_ID=:3 and STS = '2' AND OPR_CLK + TM_OUT < :4
b8bdxv42bdmqwINSERT INTO HPSTJNL (TXN_CD, CORG_MERC_ID, EMV_FLG, CSEQ_NO, CORG_RAT, CTXN_DT, ACQ_RSV, TRSP_CD, CORG_TRM_NO, ORG_NO, CORG_BAT_NO, OLOG_NO, AC_DT, TM_SMP, COUP_FLG, BTX_ST, CRD_FLG, LOG_NO, CORG_FEE_AMT, MEM_NO, CRD_NO, FM_MERC_ID, TRM_NO, CORG_CSEQ_NO, BNK_TYP, CORG_REB_RAT, IN_MOD, CORG_NO, MCC_CD, AUT_CD, MERC_FEE_AMT, MERC_ID, TXN_TM, CCY, RTR_SVR, BLOG_NO, REF_AMT, TXN_AMT, PRO_COD, BAT_NO, BD_FLG, CTXN_TM) 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, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42)
ba10x084yqdmgSELECT LOG_NO, AC_DT OAC_DT, TXN_TYP OTXN_TYP, TXN_CD OTXN_CD, CORG_NO, RTR_SVR, BTX_ST, TLOG_NO OTLOG_NO, TTXN_STS OTTXN_STS, CRD_NO, CRD_FLG, BNK_TYP, TXN_AMT OTXN_AMT, REF_AMT, MERC_FEE_AMT, ORG_NO, CTXN_DT OCTXN_DT, CORG_BAT_NO, BD_FLG, CORG_MERC_ID, CORG_TRM_NO, CORG_CSEQ_NO OCORG_CSEQ_NO, MEM_NO, COUP_FLG, USR_ID, USR_NO, FM_MERC_ID FROM HPSTJNL WHERE MERC_ID=:1 AND TRM_NO=:2 AND BAT_NO=:3 AND CSEQ_NO=:4
cvzyymfbqx0uzselect * from (Select FILE_PATH FILEPATH, FILE_SIZE FILESIZE, FILE_NAME FILENAME, row_number() over (partition by file_name order by create_time desc) as file_order from vas_platform.member_posfile_info where merchant_code =:1 and increment_type =1 AND CREATE_TIME >= TO_DATE(:2, 'yyyyMMdd')) where file_order=1
d1nygjmu0sbfhselect count(1) TOTAL_NUM from(SELECT A.AC_DT, A.MERC_ID, substr(A.crd_no, 1, 6)||'******'||substr(A.crd_no, 13, 8) CRD_NO, A.TXN_CD, A.TXN_TM, A.BAT_NO, A.CSEQ_NO, A.TRM_NO, A.TXN_AMT, A.MERC_FEE_AMT, A.LOG_NO, B.MERC_MOD, DECODE(B.MERC_MOD, '0', '', B.CHN_REL_FLG) CHN_REL_FLG, A.CRD_FLG FROM HPSTJNL A, URMTMINF B WHERE (:1 IS NULL OR A.MERC_ID=:2) AND (:3 IS NULL OR A.TXN_CD=:4) AND (A.AC_DT BETWEEN :5 AND :6) AND (:7 IS NULL OR A.CSEQ_NO=:8) AND A.TXN_TYP!='C' AND A.TTXN_STS='S' AND A.TXN_CD!='2010090' AND A.MERC_ID=B.MERC_ID AND 1=1 )
d4bw42jjybuqvSELECT * FROM HPSTOPER WHERE RRC_TYP = :1 AND (TO_NUMBER(:2) > =ALL_RSK_VAL) ORDER BY TO_NUMBER(ALL_RSK_VAL) DESC
d7nk6dja4wwzkSELECT DLY_STL_AMT FROM HPSTMRDD WHERE USR_ID = :1 AND CAP_TYP = '1' AND TOT_DAY = :2
dar43fzk5gksmUPDATE PUBSEQREC SET TM_SMP='20120814115948', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='CUP' AND SEQ_CND='CUP'
djqn581w0b971UPDATE PUBSEQREC SET TM_SMP='20120814120022', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='ABC' AND SEQ_CND='ABC'
djs2w2f17nw2zDECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN statspack.snap; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
dtfczmpcznpqjselect * from (SELECT ROWNUM RN, TA.* FROM( SELECT A.AC_DT, A.TXN_TM, A.CRD_NO, A.TXN_AMT, A.TXN_CD, A.MERC_ID, A.CORG_MERC_ID, A.TRM_NO, A.BAT_NO, A.CSEQ_NO, A.LOG_NO, B.MERC_ABBR, B.MERC_HOT_LIN, B.MERC_POS_AD, B.MERC_ATTR, C.CORG_NM, D.CTT_PSN_CNM, D.MBL_TEL, D.FIX_TEL FROM HPSTJNL A, URMTMINF B, CMMTCORG C, URMTMCNT D WHERE (:1 IS NULL OR A.CRD_NO=:2) AND (:3 IS NULL OR A.TXN_CD=:4) AND (:5 IS NULL OR A.MERC_ID=:6) AND (A.AC_DT BETWEEN :7 AND :8) AND (:9 IS NULL OR A.CORG_NO=:10) AND A.TXN_TYP!='C' AND A.TTXN_STS='S' AND A.TXN_CD!='2010090' AND D.CTT_PSN_TYP='5' AND A.MERC_ID=B.MERC_ID AND A.CORG_NO=C.CORG_NO AND A.MERC_ID=D.MERC_ID AND 1=1 )TA)TA WHERE RN <= :11 and RN>= :12
dygyrnv17cyv2INSERT INTO HPSTJNL (TXN_CD, CORG_MERC_ID, USR_ID, EMV_FLG, CSEQ_NO, CORG_RAT, CTXN_DT, TRSP_CD, CORG_TRM_NO, ORG_NO, CORG_BAT_NO, AC_DT, TM_SMP, COUP_FLG, CRD_FLG, LOG_NO, CORG_FEE_AMT, MEM_NO, CRD_NO, FM_MERC_ID, TXN_RSV3, TRM_NO, CORG_CSEQ_NO, BNK_TYP, CORG_REB_RAT, IN_MOD, CORG_NO, MCC_CD, MERC_FEE_AMT, MERC_ID, TXN_TM, POS_OPR_ID, TXN_RSV1, CCY, USR_NO, RTR_SVR, BLOG_NO, TXN_AMT, PRO_COD, BAT_NO, BD_FLG, CTXN_TM) 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, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42)
ffgkp4m35ad6vselect SUM(CASE WHEN DC_FLG = 'C' AND TX_CD = '0200230' THEN CR_AMT WHEN DC_FLG = 'D' AND TX_CD = '0200230' THEN -DR_AMT ELSE 0 END) txAmt from ACMTCDDT where STL_ORD_STS = 'S2' and amt_typ='1' and MERC_ID in ('800000358120083', '800000358120096')
fhhf6ykmbjv7wselect SUM(CASE WHEN DC_FLG = 'C' AND TX_CD = '0200230' THEN CR_AMT WHEN DC_FLG = 'D' AND TX_CD = '0200230' THEN -DR_AMT ELSE 0 END) txAmt from ACMTCDDT where STL_ORD_STS = 'S2' and amt_typ='1' and MERC_ID in ('800222256910103', '800219556910063', '800219556910064', '800219556910065', '800219556910066', '800219556910067', '800219556910068', '800219556910069', '800219556910070', '800219556910071', '800222256910104', '800222256910105', '800222256910106', '800222256910107', '800222256910108', '800222256910109', '800222256910110', '800222256910111', '800222256910112', '800222256910113', '800222256910114', '800222256910115', '800222256910116', '800222256910117', '800222256910118', '800222256910119', '800222256910120', '800222256910121', '800222256910122', '800222256910123', '800222256910124', '800224656910002', '800229156910001')
fpz5gbqmkyfjvSELECT AC_NO, AC_TYP, ORG_NO, MERC_STS, MERC_STSW, MERC_ABBR, PSN_CRP_FLG, MCC_CD, MERC_FM_FLG, CLR_FLG, RFD_FEE_PRC_MOD, EMV_FLG, CDT_TXN_FLG, CLR_MERC, MERC_CITY, SATTLE_FLAG FROM URMTMINF WHERE MERC_ID=:1
fqmpmkfr6pqykselect s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
fs98fpjmf4ku5SELECT CUR_AC_DT AC_DT FROM PUBTRSTS
fta7uj8qz3s5vINSERT INTO ACMTCDDT(JRN_NO, JRN_SEQ, ITM_NO, MERC_ID, CCY, AC_NO, USR_NO, CAP_TYP, AC_TYP, AC_DT, RVS_TX_FLG, RSV_TX_TYP, RVS_JRN, RVS_JRN_SEQ, TX_CD, EXP_TX_CD, AMT_TYP, DC_FLG, DR_AMT, CR_AMT, BAL, UPD_BAL_FLG, TX_DESC, TX_AMT, VCH_NO, RMK, TRM_NO, CORG_TRM_NO, FEE_AMT, STL_AC_DT, STL_JRN_NO, STL_JRN_SEQ, STL_ORD_STS, TM_SMP) 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, :27, :28, :29, :30, :31, :32, :33, :34)
fufxpmpq862jtUPDATE PUBSEQREC SET TM_SMP='20120814120007', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='CUP' AND SEQ_CND='CUP'
g4u6hd8jhxtjgSELECT STL_CLS FROM URMTMSTL WHERE MERC_ID=:1 AND AMT_TYP='1' AND :2 BETWEEN EFF_DT AND EXP_DT
g97f7f972atabSELECT DISTINCT(RUL_ID) AS RUL_ID FROM HPSTRURC WHERE RRC_TYP = :1
gbdtgmzym5036select to_char(sysdate, 'YYYYMMDDHH24MISS') CURR_DT from dual
gc94vahcnqf8qSELECT COUNT(TXN_TM) YC FROM HPSTJNL T WHERE T.TRSP_CD='11007' AND T.TXN_TM BETWEEN :1 AND :2
gmvpuabz0upuyINSERT INTO HPSTJNL (TXN_CD, CSEQ_NO, AC_DT, TM_SMP, LOG_NO, TRM_NO, MERC_ID, TXN_TM, BLOG_NO, PRO_COD) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10)
gtpuh24u3cr3dUPDATE TMSTPOS Set TM_SMP=:1, SATTLE_SMP=:2, BAT_NO=:3 WHERE MERC_ID=:4 AND TRM_NO=:5
gzt34x6x7p8r0UPDATE TMSTPOS SET TM_SMP=:1, PIN_KEY=:2, MAC_KEY=:3, BAT_NO=:4, SIG_DT=:5, DATA_KEY=:6, SGN_STS='1', DATA_KEY_TS=:7 WHERE MERC_ID=:8 AND TRM_NO=:9

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 49,399 13.06 6.64
CPU used when call started 51,702 13.67 6.95
CR blocks created 341 0.09 0.05
Cached Commit SCN referenced 4,158 1.10 0.56
Commit SCN cached 1 0.00 0.00
DB time 2,095,109 553.76 281.68
DBWR checkpoint buffers written 1,639 0.43 0.22
DBWR checkpoints 1 0.00 0.00
DBWR fusion writes 1,070 0.28 0.14
DBWR object drop buffers written 0 0.00 0.00
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 129 0.03 0.02
DBWR undo block writes 1,532 0.40 0.21
DFO trees parallelized 89 0.02 0.01
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 414 0.11 0.06
PX local messages sent 414 0.11 0.06
PX remote messages recv'd 388 0.10 0.05
PX remote messages sent 576 0.15 0.08
Parallel operations downgraded to serial 3 0.00 0.00
Parallel operations not downgraded 89 0.02 0.01
RowCR - row contention 2 0.00 0.00
RowCR attempts 2,927 0.77 0.39
RowCR hits 3,178 0.84 0.43
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment shrink 1 0.00 0.00
SQL*Net roundtrips to/from client 130,148 34.40 17.50
active txn count during cleanout 1,410 0.37 0.19
application wait time 8,313,391 2,197.31 1,117.69
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 17,042 4.50 2.29
branch node splits 4 0.00 0.00
buffer is not pinned count 6,518,684 1,722.96 876.40
buffer is pinned count 10,043,390 2,654.57 1,350.28
bytes received via SQL*Net from client 19,096,487 5,047.40 2,567.42
bytes sent via SQL*Net to client 28,713,275 7,589.21 3,860.35
calls to get snapshot scn: kcmgss 139,384 36.84 18.74
calls to kcmgas 15,256 4.03 2.05
calls to kcmgcs 1,023 0.27 0.14
change write time 57 0.02 0.01
cleanout - number of ktugct calls 1,497 0.40 0.20
cleanouts and rollbacks - consistent read gets 265 0.07 0.04
cleanouts only - consistent read gets 59 0.02 0.01
cluster key scan block gets 7,947 2.10 1.07
cluster key scans 612 0.16 0.08
cluster wait time 774,168 204.62 104.08
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 3 0.00 0.00
commit batch/immediate requested 3 0.00 0.00
commit cleanout failures: block lost 83 0.02 0.01
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 16 0.00 0.00
commit cleanout failures: cannot pin 0 0.00 0.00
commit cleanouts 14,402 3.81 1.94
commit cleanouts successfully completed 14,303 3.78 1.92
commit immediate performed 3 0.00 0.00
commit immediate requested 3 0.00 0.00
commit txn count during cleanout 1,922 0.51 0.26
concurrency wait time 317,510 83.92 42.69
consistent changes 1,046 0.28 0.14
consistent gets 40,614,208 10,734.75 5,460.37
consistent gets - examination 1,273,826 336.69 171.26
consistent gets direct 0 0.00 0.00
consistent gets from cache 39,125,381 10,341.24 5,260.20
current blocks converted for CR 0 0.00 0.00
cursor authentications 225 0.06 0.03
data blocks consistent reads - undo records applied 877 0.23 0.12
db block changes 78,711 20.80 10.58
db block gets 125,799 33.25 16.91
db block gets direct 216 0.06 0.03
db block gets from cache 125,575 33.19 16.88
deferred (CURRENT) block cleanout applications 7,044 1.86 0.95
dirty buffers inspected 4,476 1.18 0.60
enqueue conversions 2,582 0.68 0.35
enqueue releases 54,440 14.39 7.32
enqueue requests 54,399 14.38 7.31
enqueue timeouts 19 0.01 0.00
enqueue waits 3,336 0.88 0.45
exchange deadlocks 2,055 0.54 0.28
execute count 69,731 18.43 9.37
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 5,037,996 1,331.59 677.33
free buffer requested 4,677,254 1,236.25 628.83
gc CPU used by this session 24,471 6.47 3.29
gc blocks lost 0 0.00 0.00
gc cr block build time 5 0.00 0.00
gc cr block flush time 35,824 9.47 4.82
gc cr block receive time 34,864 9.21 4.69
gc cr block send time 9 0.00 0.00
gc cr blocks received 6,784 1.79 0.91
gc cr blocks served 4,054 1.07 0.55
gc current block flush time 118,357 31.28 15.91
gc current block pin time 2,959,690 782.28 397.91
gc current block receive time 349,265 92.31 46.96
gc current block send time 1,924 0.51 0.26
gc current blocks received 3,119,842 824.61 419.45
gc current blocks served 1,085,687 286.96 145.96
gc local grants 537,158 141.98 72.22
gc remote grants 1,007,255 266.23 135.42
gcs messages sent 7,598,718 2,008.42 1,021.61
ges messages sent 34,272 9.06 4.61
global enqueue get time 91,111 24.08 12.25
global enqueue gets async 604 0.16 0.08
global enqueue gets sync 20,273 5.36 2.73
global enqueue releases 17,911 4.73 2.41
heap block compress 251 0.07 0.03
hot buffers moved to head of LRU 2,203,206 582.33 296.21
immediate (CR) block cleanout applications 324 0.09 0.04
immediate (CURRENT) block cleanout applications 1,225 0.32 0.16
index crx upgrade (found) 2 0.00 0.00
index crx upgrade (positioned) 10,747 2.84 1.44
index fast full scans (full) 264 0.07 0.04
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 1,169,500 309.11 157.23
index scans kdiixs1 75,699 20.01 10.18
leaf node 90-10 splits 73 0.02 0.01
leaf node splits 277 0.07 0.04
lob reads 4 0.00 0.00
lob writes 47 0.01 0.01
lob writes unaligned 47 0.01 0.01
logons cumulative 763 0.20 0.10
messages received 8,729 2.31 1.17
messages sent 8,601 2.27 1.16
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 37,766,913 9,982.18 5,077.56
opened cursors cumulative 68,244 18.04 9.18
parse count (failures) 31 0.01 0.00
parse count (hard) 1,147 0.30 0.15
parse count (total) 67,964 17.96 9.14
parse time cpu 403 0.11 0.05
parse time elapsed 460 0.12 0.06
physical read IO requests 939,308 248.27 126.29
physical read bytes 12,677,799,936 3,350,872.95 1,704,463.56
physical read total IO requests 957,776 253.15 128.77
physical read total bytes 13,000,121,856 3,436,065.95 1,747,798.04
physical read total multi block requests 48,580 12.84 6.53
physical reads 1,548,075 409.17 208.13
physical reads cache 1,547,557 409.04 208.06
physical reads cache prefetch 1,378,662 364.39 185.35
physical reads direct 26 0.01 0.00
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 5,448 1.44 0.73
physical write bytes 65,093,632 17,204.92 8,751.50
physical write total IO requests 12,164 3.22 1.64
physical write total bytes 152,744,960 40,372.06 20,535.76
physical write total multi block requests 4,333 1.15 0.58
physical writes 7,946 2.10 1.07
physical writes direct 242 0.06 0.03
physical writes direct (lob) 0 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 7,704 2.04 1.04
physical writes non checkpoint 7,073 1.87 0.95
pinned buffers inspected 65 0.02 0.01
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 19 0.01 0.00
process last non-idle time 3,781 1.00 0.51
queries parallelized 89 0.02 0.01
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 83,586 22.09 11.24
recursive cpu usage 1,265 0.33 0.17
redo blocks read for recovery 0 0.00 0.00
redo blocks written 51,869 13.71 6.97
redo buffer allocation retries 0 0.00 0.00
redo entries 46,186 12.21 6.21
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,277 0.34 0.17
redo size 24,330,596 6,430.83 3,271.12
redo subscn max counts 299 0.08 0.04
redo synch time 152,412 40.28 20.49
redo synch writes 3,438 0.91 0.46
redo wastage 1,085,816 286.99 145.98
redo write time 1,042 0.28 0.14
redo writer latching time 0 0.00 0.00
redo writes 4,198 1.11 0.56
rollback changes - undo records applied 19 0.01 0.00
rollbacks only - consistent read gets 104 0.03 0.01
rows fetched via callback 547,198 144.63 73.57
session connect time 0 0.00 0.00
session cursor cache hits 33,266 8.79 4.47
session logical reads 40,740,160 10,768.04 5,477.30
session pga memory 480,793,160 127,078.58 64,640.11
session pga memory max 1,340,924,424 354,420.12 180,280.24
session uga memory 8,611,816,128 2,276,191.60 1,157,813.41
session uga memory max 347,095,952 91,741.03 46,665.23
shared hash latch upgrades - no wait 20,728 5.48 2.79
shared hash latch upgrades - wait 2 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 13,405 3.54 1.80
sorts (rows) 840,168 222.07 112.96
sql area evicted 1,290 0.34 0.17
sql area purged 31 0.01 0.00
summed dirty queue length 11,224 2.97 1.51
switch current to new buffer 308 0.08 0.04
table fetch by rowid 7,483,474 1,977.96 1,006.11
table fetch continued row 1,471 0.39 0.20
table scan blocks gotten 32,165,606 8,501.70 4,324.50
table scan rows gotten 1,350,449,349 356,937.66 181,560.82
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 333 0.09 0.04
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 19,801 5.23 2.66
total number of times SMON posted 772 0.20 0.10
transaction lock background gets 64 0.02 0.01
transaction lock foreground requests 64 0.02 0.01
transaction lock foreground wait time 20,091 5.31 2.70
transaction rollbacks 3 0.00 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 7,881,528 2,083.17 1,059.63
user I/O wait time 46,919 12.40 6.31
user calls 193,388 51.11 26.00
user commits 3,386 0.89 0.46
user rollbacks 4,052 1.07 0.54
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 3,958 1.05 0.53
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 14,901,227 14,907,700
opened cursors current 148 94
logons current 99 212

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 0.95

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
TBS_POSP 885,296 234 0.21 1.59 1,872 0 39,565 77.44
TBS_RPT 38,008 10 0.27 3.21 1 0 6,029 1.61
SYSAUX 9,897 3 4.90 1.00 876 0 5 0.00
TBS_POSP_IDX 2,343 1 7.34 1.00 1,311 0 425 3.20
TBS_POSP_IDX_2 2,335 1 5.48 1.00 353 0 3,426 850.64
UNDOTBS2 313 0 6.49 1.00 475 0 13 0.00
TBS_VAS 440 0 6.36 1.03 302 0 2 0.00
TBS_CLOUD 480 0 4.35 2.21 32 0 9 0.00
SYSTEM 254 0 3.54 1.10 115 0 29 2.76
TBS_RPT_IDX 153 0 5.10 1.00 1 0 6 0.00
TBS_PAX 30 0 7.00 1.00 73 0 10 0.00
TBS_BMP 55 0 4.55 1.00 1 0 5 0.00
BMP 13 0 6.92 2.85 5 0 8 0.00
TBS_PAX_IDX 4 0 10.00 1.00 12 0 4 2.50
UNDOTBS1 6 0 3.33 1.00 1 0 3 0.00
LV_POSP 1 0 0.00 1.00 1 0 8 0.00
T9WORKFLOW 1 0 0.00 1.00 1 0 9 2.22
TBS_BMP_IDX 1 0 0.00 1.00 1 0 5 0.00
TBS_GG 1 0 0.00 1.00 1 0 10 0.00
TBS_MNG 1 0 0.00 1.00 1 0 1 0.00
TBS_MNG_IDX 1 0 0.00 1.00 1 0 4 2.50
TBS_MQ 1 0 0.00 1.00 1 0 12 0.00
TBS_SMS 1 0 0.00 1.00 1 0 8 0.00
TBS_SMS_IDX 1 0 0.00 1.00 1 0 7 0.00
TBS_VAS_IDX 1 0 0.00 1.00 1 0 6 0.00
USERS 1 0 0.00 1.00 1 0 6 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)
BMP +ORADATA/g1db/datafile/bmp.dbf 13 0 6.92 2.85 5 0 8 0.00
LV_POSP +ORADATA/g1db/datafile/lv_posp.dbf 1 0 0.00 1.00 1 0 8 0.00
SYSAUX +ORADATA/g1db/datafile/sysaux.261.736641563 9,897 3 4.90 1.00 876 0 5 0.00
SYSTEM +ORADATA/g1db/datafile/system.259.736641557 254 0 3.54 1.10 115 0 29 2.76
T9WORKFLOW +ORADATA/g1db/datafile/t9workflow01.dbf 1 0 0.00 1.00 1 0 9 2.22
TBS_BMP +ORADATA/g1db/datafile/tbs_bmp.279.736909997 55 0 4.55 1.00 1 0 5 0.00
TBS_BMP_IDX +ORADATA/g1db/datafile/tbs_bmp_idx.284.736910303 1 0 0.00 1.00 1 0 5 0.00
TBS_CLOUD +ORADATA/g1db/datafile/tbs_cloudboss.dbf 480 0 4.35 2.21 32 0 9 0.00
TBS_GG +ORADATA/g1db/datafile/tbs_gg.1172.790730537 1 0 0.00 1.00 1 0 10 0.00
TBS_MNG +ORADATA/g1db/datafile/tbs_mng.278.736910049 1 0 0.00 1.00 1 0 1 0.00
TBS_MNG_IDX +ORADATA/g1db/datafile/tbs_mng_idx.285.736910315 1 0 0.00 1.00 1 0 4 2.50
TBS_MQ +ORADATA/g1db/datafile/tbs_mq.1140.790707929 1 0 0.00 1.00 1 0 12 0.00
TBS_PAX +ORADATA/g1db/datafile/tbs_pax01.dbf 30 0 7.00 1.00 73 0 10 0.00
TBS_PAX_IDX +ORADATA/g1db/datafile/tbs_pax_idx01.dbf 4 0 10.00 1.00 12 0 4 2.50
TBS_POSP +ORADATA/g1db/datafile/tbs_posp.277.736909545 885,296 234 0.21 1.59 1,872 0 39,565 77.44
TBS_POSP_IDX +ORADATA/g1db/datafile/tbs_posp_idx.286.736910319 2,343 1 7.34 1.00 1,311 0 425 3.20
TBS_POSP_IDX_2 +ORADATA/g1db/datafile/tbs_posp_idx_2.dbf 2,335 1 5.48 1.00 353 0 3,426 850.64
TBS_RPT +ORADATA/g1db/datafile/tbs_rpt.280.736910069 38,008 10 0.27 3.21 1 0 6,029 1.61
TBS_RPT_IDX +ORADATA/g1db/datafile/tbs_rpt_idx.282.736910281 153 0 5.10 1.00 1 0 6 0.00
TBS_SMS +ORADATA/g1db/datafile/tbs_sms01.dbf 1 0 0.00 1.00 1 0 8 0.00
TBS_SMS_IDX +ORADATA/g1db/datafile/tbs_sms_idx01.dbf 1 0 0.00 1.00 1 0 7 0.00
TBS_VAS +ORADATA/g1db/datafile/tbs_vas.281.736910101 440 0 6.36 1.03 302 0 2 0.00
TBS_VAS_IDX +ORADATA/g1db/datafile/tbs_vas_idx.283.736910293 1 0 0.00 1.00 1 0 6 0.00
UNDOTBS1 +ORADATA/g1db/datafile/undotbs1.260.736641561 6 0 3.33 1.00 1 0 3 0.00
UNDOTBS2 +ORADATA/g1db/datafile/undotbs2.263.736641567 313 0 6.49 1.00 475 0 13 0.00
USERS +ORADATA/g1db/datafile/users.264.736641567 1 0 0.00 1.00 1 0 6 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 291,688 96 39,262,832 1,547,672 7,697 0 0 47,742


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 0 913 11326 18788 1887390 18788  
E 0 2 986 22202 31014 1887390 31014  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 240 0.10 28,785 3.66 2,771,672,735
D 480 0.20 57,570 2.62 1,985,980,818
D 720 0.30 86,355 2.00 1,512,894,622
D 960 0.39 115,140 1.63 1,235,461,411
D 1,200 0.49 143,925 1.38 1,047,498,471
D 1,440 0.59 172,710 1.24 937,238,234
D 1,680 0.69 201,495 1.08 816,485,970
D 1,920 0.79 230,280 1.03 782,447,491
D 2,160 0.89 259,065 1.01 766,439,797
D 2,400 0.99 287,850 1.00 758,434,492
D 2,432 1.00 291,688 1.00 757,955,157
D 2,640 1.09 316,635 1.00 754,836,812
D 2,880 1.18 345,420 0.99 753,903,965
D 3,120 1.28 374,205 0.99 753,411,993
D 3,360 1.38 402,990 0.99 753,179,030
D 3,600 1.48 431,775 0.99 753,036,404
D 3,840 1.58 460,560 0.99 752,856,247
D 4,080 1.68 489,345 0.99 751,879,728
D 4,320 1.78 518,130 0.98 745,893,328
D 4,560 1.88 546,915 0.96 725,712,051
D 4,800 1.97 575,700 0.91 692,755,205

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 363 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 3,208 2,515 832.79 12.39 1.49 100.00 0.00 328,490
E 3,208 2,356 1,226.27 0.00 0.00 0.00 0.00 328,490

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 3,718 3,718 0 0
64K 128K 26 26 0 0
128K 256K 2 2 0 0
256K 512K 2 2 0 0
512K 1024K 153 153 0 0
1M 2M 37 37 0 0
4M 8M 12 12 0 0
16M 32M 4 4 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
401 0.13 2,916,401.94 2,277,367.55 56.00 118
802 0.25 2,916,401.94 773,246.09 79.00 20
1,604 0.50 2,916,401.94 129,478.12 96.00 0
2,406 0.75 2,916,401.94 129,478.12 96.00 0
3,208 1.00 2,916,401.94 129,478.12 96.00 0
3,850 1.20 2,916,401.94 79,370.08 97.00 0
4,491 1.40 2,916,401.94 79,370.08 97.00 0
5,133 1.60 2,916,401.94 79,370.08 97.00 0
5,774 1.80 2,916,401.94 79,370.08 97.00 0
6,416 2.00 2,916,401.94 79,370.08 97.00 0
9,624 3.00 2,916,401.94 79,370.08 97.00 0
12,832 4.00 2,916,401.94 79,370.08 97.00 0
19,248 6.00 2,916,401.94 79,370.08 97.00 0
25,664 8.00 2,916,401.94 79,370.08 97.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
1,104 0.30 408 36,015 25,802,353 0.96 1,131,147 39.59 335,869,925
1,472 0.40 773 48,280 26,372,972 0.98 560,528 19.62 336,402,038
1,840 0.50 1,136 67,532 26,685,412 0.99 248,088 8.68 336,755,180
2,208 0.60 1,500 91,493 26,810,074 1.00 123,426 4.32 336,945,499
2,576 0.70 1,866 115,683 26,850,151 1.00 83,349 2.92 337,050,483
2,944 0.80 2,232 139,651 26,869,303 1.00 64,197 2.25 337,121,325
3,312 0.90 2,598 165,908 26,886,155 1.00 47,345 1.66 337,172,607
3,680 1.00 2,964 192,344 26,904,927 1.00 28,573 1.00 337,212,441
4,048 1.10 3,330 215,642 26,924,227 1.00 9,273 0.32 337,243,803
4,416 1.20 3,697 241,826 26,940,133 1.00 1 0.00 337,268,680
4,784 1.30 4,064 265,558 26,952,306 1.00 1 0.00 337,288,658
5,152 1.40 4,431 292,776 26,964,243 1.00 1 0.00 337,305,189
5,520 1.50 4,798 311,612 26,971,326 1.00 1 0.00 337,319,400
5,888 1.60 5,165 333,525 26,978,103 1.00 1 0.00 337,332,077
6,256 1.70 5,532 364,654 26,982,705 1.00 1 0.00 337,343,725
6,624 1.80 5,899 387,956 26,986,574 1.00 1 0.00 337,354,413
6,992 1.90 6,266 405,242 26,991,840 1.00 1 0.00 337,364,869
7,360 2.00 6,633 426,346 26,999,136 1.00 1 0.00 337,375,047

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
1,536 0.25 6,663,990 2,740,970,028
3,072 0.50 4,752,977 1,035,888,543
4,608 0.75 4,430,056 773,789,869
6,144 1.00 4,346,175 757,948,740
7,680 1.25 4,328,790 744,836,227
9,216 1.50 4,293,152 685,109,866
10,752 1.75 4,293,152 685,109,866
12,288 2.00 4,293,152 685,109,866

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

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 48,715 5,988 123
file header block 155 0 0
1st level bmb 15 0 2
segment header 22 0 0
undo header 12 0 0
2nd level bmb 2 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CF-Controlfile Transaction 11,210 11,195 15 1,135 729 642.19
US-Undo Segment 487 487 0 469 3 6.52
XR-Quiesce / Force Logging (database force logging) 1,257 1,257 0 1,257 1 0.41
PS-PX Process Reservation 644 644 0 211 0 0.52
TT-Tablespace 619 619 0 158 0 0.44
TX-Transaction (row lock contention) 11 9 0 9 0 6.67
TX-Transaction 4,239 4,238 1 37 0 0.54
TD-KTF map table enqueue (KTF dump entries) 12 12 0 12 0 1.67
FB-Format Block 57 57 0 28 0 0.36
WF-AWR Flush 20 20 0 10 0 1.00
DR-Distributed Recovery 2 2 0 2 0 5.00
TM-DML 9,572 9,572 0 4 0 0.00
HW-Segment High Water Mark 287 287 0 3 0 0.00
IR-Instance Recovery 11 11 0 1 0 0.00
TX-Transaction (index contention) 1 1 0 1 0 0.00
WL-Being Written Redo Log 1 1 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
4 1.76 6,610 1,825 13 1440/1440 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
14-Aug 12:11 364 2,157 611 4 1,440 0/0 0/0/0/0/0/0
14-Aug 12:01 408 659 0 13 1,440 0/0 0/0/0/0/0/0
14-Aug 11:51 88 751 1,825 2 1,440 0/0 0/0/0/0/0/0
14-Aug 11:41 86 589 1,772 3 1,440 0/0 0/0/0/0/0/0
14-Aug 11:31 93 563 1,170 2 1,440 0/0 0/0/0/0/0/0
14-Aug 11:21 92 623 570 3 1,440 0/0 0/0/0/0/0/0
14-Aug 11:11 73 644 108 2 1,440 0/0 0/0/0/0/0/0
14-Aug 11:01 551 624 1,667 4 1,440 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 40 0.00   0 0  
ASM db client latch 2,570 0.00   0 0  
ASM map headers 26 0.00   0 0  
ASM map load waiting list 7 0.00   0 0  
ASM map operation freelist 923 0.00   0 0  
ASM map operation hash table 1,963,265 0.00 0.00 0 0  
ASM network background latch 1,548 0.00   0 0  
AWR Alerted Metric Element list 18,461 0.00   0 0  
Consistent RBA 4,197 0.00   0 0  
FAL request queue 73 0.00   0 0  
FAL subheap alocation 73 0.00   0 0  
FIB s.o chain latch 6 0.00   0 0  
FOB s.o list latch 1,382 0.00   0 0  
JS broadcast add buf latch 865 0.00   0 0  
JS broadcast drop buf latch 865 0.00   0 0  
JS broadcast load blnc latch 757 0.00   0 0  
JS queue state obj latch 22,710 0.00   0 0  
KCL gc element parent latch 23,422,042 0.02 0.01 0 1,918 0.00
KFK SGA context latch 2,815 0.00   0 0  
KFMD SGA 602 0.00   0 0  
KJC message pool free list 350,307 0.04 0.00 0 149,096 0.01
KJCT flow control latch 4,471,007 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,261 0.00   0 0  
KSXR large replies 2 0.00   0 0  
KTF sga latch 24 0.00   0 904 0.00
KWQMN job cache list latch 274 0.00   0 0  
KWQP Prop Status 1 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,261 0.00
OS process 1,710 0.00   0 0  
OS process allocation 2,514 0.00   0 0  
OS process: request allocation 1,237 0.00   0 0  
PL/SQL warning settings 873 0.00   0 0  
SGA IO buffer pool latch 20 0.00   0 20 0.00
SQL memory manager latch 2 0.00   0 1,256 0.00
SQL memory manager workarea list latch 95,622 0.00   0 0  
Shared B-Tree 126 0.00   0 0  
active checkpoint queue latch 6,750 0.04 0.00 0 0  
active service list 10,918 0.00   0 1,889 0.00
archive control 126 0.00   0 0  
archive process latch 1,404 0.00   0 0  
begin backup scn array 10 0.00   0 0  
business card 178 0.00   0 0  
cache buffer handles 1,610 0.00   0 0  
cache buffers chains 88,570,697 0.24 0.01 0 14,547,671 0.02
cache buffers lru chain 4,692,960 0.06 0.00 0 28,505,933 0.03
cache table scan latch 0     0 48,534 0.06
channel handle pool latch 1,253 0.00   0 0  
channel operations parent latch 178,585 0.00 0.00 0 0  
checkpoint queue latch 360,034 0.00 0.00 0 9,833 0.00
client/application info 4,358 0.00   0 0  
compile environment latch 763 0.00   0 0  
dml lock allocation 18,940 0.01 0.00 0 0  
dummy allocation 1,413 0.00   0 0  
enqueue hash chains 140,491 0.06 0.00 0 90,001 0.00
enqueues 96,255 0.21 0.00 0 0  
error message lists 461 0.00   0 0  
event group latch 675 0.00   0 0  
file cache latch 728 0.00   0 0  
gcs opaque info freelist 3,998,660 0.07 0.00 0 0  
gcs partitioned table hash 39,577,068 0.00   0 0  
gcs remaster request queue 9 0.00   0 0  
gcs remastering latch 7,155,784 0.00 0.00 0 0  
gcs resource freelist 1,746,108 0.07 0.00 0 493,864 0.21
gcs resource hash 19,974,998 0.01 0.00 0 7 0.00
gcs resource scan list 14 0.00   0 0  
gcs shadows freelist 1,427,125 0.00   0 1,456,291 0.00
ges caches resource lists 454,738 0.02 0.00 0 447,893 0.01
ges deadlock list 3,040 0.00   0 5,080 0.00
ges domain table 70,089 0.00   0 0  
ges enqueue table freelist 72,928 0.00   0 0  
ges group table 52,953 0.00   0 0  
ges process hash list 31,308 0.00   0 11 0.00
ges process parent latch 122,232 0.00   0 1 0.00
ges process table freelist 1,237 0.00   0 0  
ges resource hash list 308,577 0.10 0.05 0 35,814 0.01
ges resource scan list 976 0.00   0 0  
ges resource table freelist 39,668 0.00   0 0  
ges synchronous data 128 0.78 0.00 0 12,819 0.03
ges timeout list 3,070 0.00   0 12,402 0.00
global KZLD latch for mem in SGA 684 0.00   0 0  
hash table column usage latch 152 0.00   0 38,811 0.00
hash table modification latch 163 0.00   0 0  
job workq parent latch 0     0 4 0.00
job_queue_processes parameter latch 66 0.00   0 0  
kks stats 7,704 0.00   0 0  
kokc descriptor allocation latch 2 0.00   0 0  
ksuosstats global area 256 0.00   0 0  
ktm global data 775 0.00   0 0  
kwqbsn:qsga 126 0.00   0 0  
lgwr LWN SCN 4,326 0.00   0 0  
library cache 198,483 0.09 0.00 0 5,113 0.00
library cache load lock 62 0.00   0 0  
library cache lock 167,283 0.01 0.00 0 0  
library cache lock allocation 2,453 0.00   0 0  
library cache pin 27,401 0.00   0 0  
library cache pin allocation 161 0.00   0 0  
list of block allocation 347 0.00   0 0  
loader state object freelist 14 0.00   0 0  
longop free list parent 37 0.00   0 37 0.00
message pool operations parent latch 1,202 0.00   0 0  
messages 142,291 0.02 0.00 0 0  
mostly latch-free SCN 4,334 0.02 0.00 0 0  
msg queue 6 0.00   0 6 0.00
multiblock read objects 934,315 0.04 0.00 0 0  
name-service memory objects 4,048 0.00   0 0  
name-service namespace bucket 74,609 0.00   0 0  
name-service pending queue 1,516 0.00   0 0  
name-service request queue 39,630 0.00   0 0  
ncodef allocation latch 90 0.00   0 0  
object queue header heap 7,681 0.00   0 7,743 0.00
object queue header operation 9,446,898 0.00 0.46 0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 2,284 0.00   0 0  
parallel query stats 353 0.00   0 0  
parallel txn reco latch 3,433 0.00   0 0  
parameter list 4,480 0.00   0 0  
parameter table allocation management 650 0.15 0.00 0 0  
post/wait queue 69,005 0.03 0.00 0 48,715 0.01
process allocation 38,121 0.07 1.00 0 675 0.00
process group creation 1,237 0.00   0 0  
process queue 982 0.00   0 0  
process queue reference 18,804 0.01 0.00 0 1,741 0.00
qmn state object latch 1 0.00   0 0  
qmn task queue latch 500 0.20 0.00 0 0  
query server freelists 811 0.00   0 0  
queued dump request 18,910 0.00   0 0  
redo allocation 12,898 0.03 0.00 0 47,678 0.07
redo copy 0     0 47,691 0.07
redo writing 22,011 0.01 0.00 0 0  
resmgr group change latch 848 0.00   0 0  
resmgr:active threads 1,408 0.00   0 0  
resmgr:actses change group 745 0.00   0 0  
resmgr:free threads list 1,406 0.07 0.00 0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 286,975 2.92 0.00 0 3,537 0.00
rules engine rule set statistics 100 0.00   0 0  
segmented array pool 6 0.00   0 0  
sequence cache 8,862 0.00   0 0  
session allocation 43,995 0.76 0.00 0 0  
session idle bit 402,054 0.00 0.00 0 0  
session state list latch 1,587 0.00   0 0  
session switching 90 0.00   0 0  
session timer 1,889 0.00   0 0  
shared pool 83,203 0.00 0.00 0 0  
shared pool simulator 119,913 0.00   0 0  
simulator hash latch 6,033,545 0.00 0.14 0 0  
simulator lru latch 0     0 3,947,577 0.28
slave class 33 0.00   0 0  
slave class create 30 3.33 1.00 0 0  
sort extent pool 1,001 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 336 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
threshold alerts latch 518 0.00   0 0  
trace latch 43 0.00   0 0  
transaction allocation 432 0.00   0 0  
transaction branch allocation 1,889 0.00   0 0  
undo global data 32,027 0.01 0.00 0 0  
user lock 2,534 0.28 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 88,570,697 210,611 2,362 208,336 0 0 0
row cache objects 286,975 8,383 1 8,382 0 0 0
KCL gc element parent latch 23,422,042 4,948 27 4,922 0 0 0
cache buffers lru chain 4,692,960 2,999 2 2,997 0 0 0
gcs opaque info freelist 3,998,660 2,713 1 2,712 0 0 0
gcs resource hash 19,974,998 2,634 9 2,628 0 0 0
ges resource hash list 308,577 311 16 295 0 0 0
object queue header operation 9,446,898 46 21 29 0 0 0
process allocation 38,121 28 28 0 0 0 0
simulator hash latch 6,033,545 14 2 13 0 0 0
slave class create 30 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 49 15
KCL gc element parent latch kclzcl 0 5 10
KCL gc element parent latch KCLUNLNK 0 4 19
KCL gc element parent latch kclbla 0 3 0
KCL gc element parent latch kclplz 0 3 8
KCL gc element parent latch kclulb 0 3 13
KCL gc element parent latch kclwrt 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 6,397 6,347
cache buffers chains kcbrls: kslbegin 0 197 248
cache buffers chains kcbgcur: kslbegin 0 141 135
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 31 27
cache buffers chains kcbzwb 0 30 22
cache buffers chains kclobj_1 0 11 0
cache buffers chains kcbgtcr: kslbegin shared 0 2 1
cache buffers chains kcbzgb: scan from tail. nowait 0 2 0
cache buffers chains kcbzib: finish free bufs 0 2 0
cache buffers chains kcbget: pin buffer 0 1 0
cache buffers chains kclwrt 0 1 0
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 2 1
gcs opaque info freelist kjbrgrant free opaque info 0 1 0
gcs resource hash kjbassume 0 6 0
gcs resource hash kjbcropen:affinity 0 2 0
gcs resource hash kjbcropen 0 1 1
ges resource hash list kjrmas1: lookup master node 0 7 0
ges resource hash list kjcvscn: remove from scan queue 0 6 0
ges resource hash list kjrref: find matched resource 0 2 9
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 1 0
object queue header operation kclobj_1 0 26 14
object queue header operation kcbo_switch_cq 0 1 0
object queue header operation kcbw_unlink_q 0 1 6
process allocation ksucrp 0 26 0
process allocation ksufap: active procs 0 2 3
row cache objects kqrpre: find obj 0 1 0
simulator hash latch kcbsacc: lookup dba 0 2 2
slave class create ksvcreate 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
POSP TBS_POSP PUBIGTJNL   TABLE 17,636,736 43.29
VAS_PLATFORM TBS_VAS MEMBER_POSFILE_INFO   TABLE 3,043,952 7.47
POSP TBS_POSP HPSTJNL_INT P201207 TABLE PARTITION 2,499,856 6.14
POSP TBS_POSP HPSTJNL_INT P201206 TABLE PARTITION 2,132,672 5.23
POSP TBS_POSP HPSTJNL_INT P201203 TABLE PARTITION 1,959,568 4.81

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
POSP TBS_POSP ACMTCDDT   TABLE 940,490 60.75
POSP TBS_POSP PUBIGTJNL   TABLE 463,461 29.94
RPTADM TBS_RPT RPT_SETTLETRADE_DETAIL   TABLE 121,833 7.87
PERFSTAT SYSAUX STATS$SQLTEXT_PK   INDEX 8,047 0.52
POSP TBS_POSP HPSTJNL_INT P201207 TABLE PARTITION 944 0.06

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
VAS_PLATFORM TBS_VAS PK_USER_RELATION   INDEX 25 51.02
POSP TBS_POSP PUBSEQREC   TABLE 18 36.73
POSP TBS_POSP TMSTPOS   TABLE 4 8.16
POSP TBS_POSP_IDX_2 HPSTJNL_IDX1_INT P201208 INDEX PARTITION 1 2.04
VAS_PLATFORM TBS_VAS PK_MEMBER   INDEX 1 2.04

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
POSP TBS_POSP PK_HPSTSJNLN   INDEX 8 50.00
POSP TBS_POSP PUBSEQREC   TABLE 4 25.00
POSP TBS_POSP HPSTCRDD   TABLE 2 12.50
POSP TBS_POSP_IDX_2 HPSTJNL_PK_INT   INDEX 2 12.50

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
POSP TBS_POSP HPSTJNL_INT P201207 TABLE PARTITION 6,246 12.94
RPTADM TBS_RPT RPT_SETTLETRADE_DETAIL   TABLE 6,027 12.49
POSP TBS_POSP HPSTJNL_INT P201201 TABLE PARTITION 4,308 8.93
POSP TBS_POSP HPSTJNL_INT P201206 TABLE PARTITION 3,993 8.27
POSP TBS_POSP ACMTCDDT   TABLE 3,925 8.13

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
POSP TBS_POSP HPSTMRDW   TABLE 988 14.56
POSP TBS_POSP TMSTPOS   TABLE 750 11.06
PERFSTAT SYSAUX STATS$SQLTEXT_PK   INDEX 737 10.86
POSP TBS_POSP PUBIGTJNL   TABLE 417 6.15
POSP TBS_POSP HPSTJNL P201208 TABLE PARTITION 355 5.23

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
POSP TBS_POSP PUBIGTJNL   TABLE 2,093,112 67.09
RPTADM TBS_RPT RPT_SETTLETRADE_DETAIL   TABLE 442,636 14.19
POSP TBS_POSP ACMTCDDT   TABLE 132,584 4.25
POSP TBS_POSP HPSTJNL_INT P201203 TABLE PARTITION 77,777 2.49
POSP TBS_POSP HPSTJNL_INT P201207 TABLE PARTITION 53,678 1.72

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 68 0.00 0   2 1
dc_database_links 1,344 0.00 0   0 1
dc_files 910 0.00 0   0 26
dc_global_oids 6 0.00 0   0 24
dc_histogram_data 24,715 0.58 0   0 7,903
dc_histogram_defs 13,564 0.89 0   0 4,331
dc_object_ids 14,874 0.04 0   0 2,585
dc_objects 3,709 0.03 0   0 1,095
dc_profiles 659 0.00 0   0 1
dc_rollback_segments 10,020 0.20 0   64 133
dc_segments 4,340 0.81 0   6 2,626
dc_sequences 40 55.00 0   40 22
dc_tablespace_quotas 2 100.00 0   2 7
dc_tablespaces 11,039 0.00 0   0 33
dc_usernames 2,696 0.00 0   0 49
dc_users 25,247 0.00 0   0 64
outstanding_alerts 222 81.08 0   0 31

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 4 0 0
dc_histogram_defs 121 0 3
dc_object_ids 6 0 0
dc_objects 1 0 0
dc_rollback_segments 138 32 0
dc_segments 75 5 0
dc_sequences 80 23 0
dc_tablespace_quotas 4 0 0
outstanding_alerts 444 180 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 127 0.00 169 0.00 0 0
CLUSTER 2 0.00 3 0.00 0 0
INDEX 37 0.00 55 0.00 0 0
SQL AREA 35,834 5.50 82,769 3.90 139 0
TABLE/PROCEDURE 666 0.00 14,003 0.28 13 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
BODY 1 0 0 0 0
CLUSTER 3 0 0 0 0
INDEX 55 0 0 0 0
TABLE/PROCEDURE 3,434 5 0 0 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 570.59   5.71 6.92 26 34 100 100
  SQL 195.43 152.36 2.51 14.52 91 256 78 58
  Freeable 65.31 0.00 1.05 1.56 12   62 62
  PL/SQL 1.51 0.40 0.02 0.06 0 2 100 100
E Other 965.00   4.53 4.96 26 33 213 213
  SQL 182.91 139.83 0.96 9.32 91 256 190 58
  Freeable 76.56 0.00 0.77 1.27 12   99 99
  PL/SQL 1.90 0.55 0.01 0.04 0 2 213 213

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 2,550,136,832  
Fixed Size 2,093,544  
Redo Buffers 14,680,064  
Variable Size 3,875,540,504  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large ASM map operations hashta 0.38 0.38 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.60 14.60 0.00
shared ASH buffers 40.50 40.50 0.00
shared CCursor 365.95 366.10 0.04
shared Cursor Stats 40.88 40.88 0.00
shared PCursor 259.65 259.41 -0.09
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 623.27 620.87 -0.39
shared gcs resources 106.86 106.86 0.00
shared gcs shadows 97.63 97.63 0.00
shared kglsim heap 39.80 39.80 0.00
shared kglsim object batch 74.01 74.01 0.00
shared library cache 178.59 178.61 0.01
shared sql area 1,585.78 1,585.26 -0.03
  buffer_cache 2,432.00 2,432.00 0.00
  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 431,583 670,587 691403 691403
gcs_shadows 691,403 983,879 691403 691403


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
archive_lag_target 3600   
audit_file_dest /oracle/orahome/admin/G1db/adump   
background_dump_dest /oracle/orahome/admin/G1db/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files +ORADATA/g1db/controlfile/current.256.736641549   
core_dump_dest /oracle/orahome/admin/G1db/cdump   
db_block_size 8192   
db_create_file_dest +ORADATA   
db_domain      
db_file_multiblock_read_count 16   
db_name G1db   
instance_number 2   
job_queue_processes 10   
log_archive_dest_1 LOCATION=+ORADATA/   
log_archive_format %t_%s_%r.dbf   
nls_language SIMPLIFIED CHINESE   
nls_territory CHINA   
open_cursors 300   
pga_aggregate_target 3363831808   
processes 1000   
remote_listener LISTENERS_G1DB   
remote_login_passwordfile EXCLUSIVE   
sga_target 6442450944   
spfile +ORADATA/g1db/spfileg1db.ora   
thread 2   
undo_management AUTO   
undo_retention 86400   
undo_tablespace UNDOTBS2   
user_dump_dest /oracle/orahome/admin/G1db/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 4,498 1.19 0.60
acks for commit broadcast(logical) 5,769 1.52 0.78
broadcast msgs on commit(actual) 4,195 1.11 0.56
broadcast msgs on commit(logical) 4,197 1.11 0.56
broadcast msgs on commit(wasted) 184 0.05 0.02
broadcast on commit wait time(ms) 282,881,818 74,768.57 38,031.97
broadcast on commit waits 3,082 0.81 0.41
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 935,225 247.19 125.74
gcs ast xid 0 0.00 0.00
gcs blocked converts 3,105 0.82 0.42
gcs blocked cr converts 6,519 1.72 0.88
gcs compatible basts 306 0.08 0.04
gcs compatible cr basts (global) 597 0.16 0.08
gcs compatible cr basts (local) 1,994,602 527.19 268.16
gcs cr basts to PIs 0 0.00 0.00
gcs cr serve without current lock 0 0.00 0.00
gcs dbwr flush pi msgs 914 0.24 0.12
gcs dbwr write request msgs 970 0.26 0.13
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 2,511 0.66 0.34
gcs immediate (null) converts 12,365 3.27 1.66
gcs immediate cr (compatible) converts 1 0.00 0.00
gcs immediate cr (null) converts 945,318 249.86 127.09
gcs indirect ast 21,883 5.78 2.94
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 267 0.07 0.04
gcs msgs process time(ms) 44,090 11.65 5.93
gcs msgs received 3,890,788 1,028.38 523.10
gcs out-of-order msgs 1 0.00 0.00
gcs pings refused 2 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 1 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 1 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 21,125 5.58 2.84
gcs side channel msgs logical 3,140,682 830.11 422.25
gcs stale cr 192 0.05 0.03
gcs undo cr 170 0.04 0.02
gcs write notification msgs 71 0.02 0.01
gcs writes refused 0 0.00 0.00
ges msgs process time(ms) 716 0.19 0.10
ges msgs received 48,972 12.94 6.58
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 0 0.00 0.00
global posts requested 0 0.00 0.00
global posts sent 0 0.00 0.00
implicit batch messages received 94,223 24.90 12.67
implicit batch messages sent 198,757 52.53 26.72
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 5,814 1.54 0.78
messages queue sent actual 290,282 76.72 39.03
messages queue sent logical 3,093,742 817.71 415.94
messages received actual 615,264 162.62 82.72
messages received logical 3,939,860 1,041.35 529.69
messages sent directly 397,087 104.95 53.39
messages sent indirectly 3,047,336 805.44 409.70
messages sent not implicit batched 91,524 24.19 12.30
messages sent pbatched 4,184,342 1,105.96 562.56
msgs causing lmd to send msgs 22,564 5.96 3.03
msgs causing lms(s) to send msgs 59,613 15.76 8.01
msgs received queue time (ms) 75,814 20.04 10.19
msgs received queued 3,939,916 1,041.36 529.70
msgs sent queue time (ms) 84,306,815 22,283.16 11,334.61
msgs sent queue time on ksxp (ms) 280,670 74.18 37.73
msgs sent queued 3,088,090 816.21 415.18
msgs sent queued on ksxp 1,172,623 309.94 157.65
process batch messages received 337,295 89.15 45.35
process batch messages sent 523,097 138.26 70.33


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 3,640
CURRENT Block Requests 422
Data Block Requests 3,640
Undo Block Requests 21
TX Block Requests 293
Current Results 3,967
Private results 13
Zero Results 81
Disk Read Results 1
Fail Results 0
Fairness Down Converts 614
Fairness Clears 0
Free GC Elements 0
Flushes 118
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 57
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 1,085,636 100.00 0.00 0.00 0.00 0.00
Flushes 17 64.71 17.65 5.88 11.76 0.00
Writes 784 45.66 42.47 6.38 1.66 3.83


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 6,304 89.97 10.03 0.00 3,117,529 100.00 0.00 0.00
1 Others 158 100.00 0.00 0.00 1,138 100.00 0.00 0.00
1 undo header 288 99.31 0.69 0.00 22 72.73 27.27 0.00
1 undo block 39 97.44 2.56 0.00 7 100.00 0.00 0.00


Back to Top

End of Report