[oracle@db1 log]$ cat 20120814awr.lst AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
G1DB2583992970G1db1110.2.0.4.0YESdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:650014-Aug-12 11:00:07158 4.4
End Snap:650114-Aug-12 12:03:10269 2.5
Elapsed:  63.06 (mins)  
DB Time:  1,096.67 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 3,920M 3,712MStd Block Size: 8K
Shared Pool Size: 2,176M 2,384MLog Buffer: 14,336K

Load Profile

Per SecondPer Transaction
Redo size: 9,260.89 1,408.42
Logical reads: 16,982.26 2,582.72
Block changes: 222.11 33.78
Physical reads: 199.58 30.35
Physical writes: 2.47 0.38
User calls: 231.36 35.19
Parses: 42.17 6.41
Hard parses: 5.19 0.79
Sorts: 6.11 0.93
Logons: 0.19 0.03
Executes: 41.14 6.26
Transactions: 6.58 

% Blocks changed per Read: 1.31Recursive Call %: 28.03
Rollback per transaction %: 80.92Rows per Sort: 36.83

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97Redo NoWait %: 100.00
Buffer Hit %: 98.84In-memory Sort %: 100.00
Library Hit %: 81.69Soft Parse %: 87.69
Execute to Parse %: -2.50Latch Hit %: 99.91
Parse CPU to Parse Elapsd %: 88.72% Non-Parse CPU: 93.45

Shared Pool Statistics

BeginEnd
Memory Usage %: 42.50 48.75
% SQL with executions>1: 32.34 30.82
% Memory for SQL w/exec>1: 42.81 37.59

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
enq: TX - row lock contention 105,229 51,443 489 78.2Application
gc buffer busy 16,158 5,089 315 7.7Cluster
log file sync 9,031 4,147 459 6.3Commit
row cache lock 6,900 2,914 422 4.4Concurrency
gc current block busy 620 713 1,149 1.1Cluster

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 287.99 43.80
Global Cache blocks served: 825.91 125.61
GCS/GES messages received: 2,016.74 306.71
GCS/GES messages sent: 1,041.01 158.32
DBWR Fusion writes: 0.33 0.05
Estd Interconnect traffic (KB) 9,508.44 

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

Buffer access - local cache %: 97.15
Buffer access - remote cache %: 1.70
Buffer access - disk %: 1.16

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 14.1
Avg global cache cr block receive time (ms): 89.4
Avg global cache current block receive time (ms): 1.5
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 %: 9.4
Avg global cache cr block flush time (ms): 544.9
Avg global cache current block pin time (ms): 9.6
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): 27,905.3

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 5.4
Avg message sent queue time on ksxp (ms): 0.3
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: 7.98
% of indirect sent messages: 91.32
% of flow controlled messages: 0.70

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 61,598.89 93.61
DB CPU 644.95 0.98
parse time elapsed 54.61 0.08
hard parse elapsed time 47.86 0.07
connection management call elapsed time 1.43 0.00
hard parse (sharing criteria) elapsed time 0.29 0.00
hard parse (bind mismatch) elapsed time 0.21 0.00
sequence load elapsed time 0.18 0.00
PL/SQL execution elapsed time 0.10 0.00
PL/SQL compilation elapsed time 0.10 0.00
failed parse elapsed time 0.07 0.00
repeated bind elapsed time 0.03 0.00
DB time 65,800.48  
background elapsed time 1,615.48  
background cpu time 177.13  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Application 107,158 97.99 51,444 480 4.31
Cluster 689,747 1.00 6,303 9 27.73
Commit 9,031 46.60 4,147 459 0.36
Concurrency 23,045 4.24 2,922 127 0.93
Other 739,751 98.02 1,722 2 29.74
User I/O 121,509 0.00 230 2 4.88
System I/O 43,629 0.00 61 1 1.75
Configuration 42 2.38 1 24 0.00
Network 797,680 0.00 1 0 32.06

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 105,229 99.79 51,443 489 4.23
gc buffer busy 16,158 32.03 5,089 315 0.65
log file sync 9,031 46.60 4,147 459 0.36
row cache lock 6,900 13.87 2,914 422 0.28
gc current block busy 620 93.71 713 1149 0.02
enq: CF - contention 2,599 54.29 693 267 0.10
gcs log flush sync 25,156 97.20 681 27 1.01
gc cr block busy 392 74.74 358 914 0.02
KJC: Wait for msg sends to complete 1,086 99.63 325 300 0.04
db file sequential read 36,956 0.00 128 3 1.49
gc cr multi block request 567,586 0.00 111 0 22.82
db file scattered read 75,549 0.00 89 1 3.04
control file sequential read 30,885 0.00 30 1 1.24
gc current block 2-way 78,592 0.00 24 0 3.16
log file parallel write 5,769 0.00 13 2 0.23
db file parallel write 4,293 0.00 10 2 0.17
db file parallel read 3,404 0.00 9 3 0.14
control file parallel write 2,602 0.00 8 3 0.10
enq: US - contention 455 0.00 7 16 0.02
library cache lock 15,275 0.00 5 0 0.61
Streams AQ: qmn coordinator waiting for slave to start 1 100.00 5 4883 0.00
name-service call wait 69 0.00 5 69 0.00
gc cr grant 2-way 18,508 0.00 4 0 0.74
direct path read 4,447 0.00 3 1 0.18
CGS wait for IPC msg 681,506 99.99 2 0 27.40
os thread startup 29 0.00 2 71 0.00
gc cr block 2-way 3,643 0.05 2 0 0.15
wait for scn ack 4,018 0.00 1 0 0.16
log buffer space 1 100.00 1 1000 0.00
read by other session 1,109 0.00 1 1 0.04
enq: WF - contention 10 10.00 1 80 0.00
log file sequential read 43 0.00 1 15 0.00
gc current grant busy 961 0.00 1 1 0.04
gc current grant 2-way 2,179 0.00 1 0 0.09
SQL*Net more data to client 62,522 0.00 0 0 2.51
SQL*Net message to client 729,955 0.00 0 0 29.34
enq: TM - contention 336 0.00 0 1 0.01
ges global resource directory to be frozen 24 100.00 0 10 0.00
cursor: pin S wait on X 29 72.41 0 7 0.00
kksfbc child completion 8 50.00 0 25 0.00
SQL*Net break/reset to client 1,592 0.00 0 0 0.06
kjbdrmcvtq lmon drm quiesce: ping completion 24 4.17 0 7 0.00
enq: TX - index contention 11 0.00 0 11 0.00
rdbms ipc reply 547 0.00 0 0 0.02
reliable message 282 0.00 0 0 0.01
SQL*Net more data from client 5,203 0.00 0 0 0.21
IPC send completion sync 341 100.00 0 0 0.01
latch free 27 0.00 0 3 0.00
DFS lock handle 318 0.00 0 0 0.01
ksxr poll remote instances 12,608 50.71 0 0 0.51
enq: PS - contention 232 0.00 0 0 0.01
PX Deq: reap credit 9,972 99.64 0 0 0.40
gc cr disk read 140 0.00 0 0 0.01
library cache pin 228 0.00 0 0 0.01
enq: TT - contention 130 0.00 0 0 0.01
buffer busy waits 24 0.00 0 1 0.00
Log archive I/O 35 0.00 0 1 0.00
latch: cache buffers chains 510 0.00 0 0 0.02
PX Deq Credit: send blkd 117 12.82 0 0 0.00
gc current multi block request 115 0.00 0 0 0.00
enq: HW - contention 39 0.00 0 0 0.00
enq: TX - contention 28 0.00 0 0 0.00
direct path write 44 0.00 0 0 0.00
gc object scan 852 100.00 0 0 0.03
enq: FB - contention 22 0.00 0 0 0.00
PX Deq: Signal ACK 83 15.66 0 0 0.00
enq: TA - contention 12 0.00 0 0 0.00
latch: shared pool 16 0.00 0 0 0.00
enq: PI - contention 4 0.00 0 0 0.00
enq: TX - allocate ITL entry 2 0.00 0 1 0.00
PX qref latch 7 57.14 0 0 0.00
latch: enqueue hash chains 8 0.00 0 0 0.00
latch: ges resource hash list 7 0.00 0 0 0.00
latch: KCL gc element parent latch 19 0.00 0 0 0.00
latch: row cache objects 5 0.00 0 0 0.00
enq: MW - contention 2 0.00 0 0 0.00
gc current split 1 0.00 0 1 0.00
LGWR wait for redo copy 20 0.00 0 0 0.00
log file single write 2 0.00 0 0 0.00
enq: JQ - contention 1 0.00 0 0 0.00
enq: PW - flush prewarm buffers 1 0.00 0 0 0.00
latch: gcs resource hash 2 0.00 0 0 0.00
buffer deadlock 4 100.00 0 0 0.00
latch: session allocation 2 0.00 0 0 0.00
latch: library cache 2 0.00 0 0 0.00
cursor: mutex S 14 0.00 0 0 0.00
cursor: mutex X 2 0.00 0 0 0.00
SQL*Net message from client 729,850 0.00 170,736 234 29.34
gcs remote message 1,709,802 99.23 21,327 12 68.73
PX Idle Wait 7,768 97.48 18,668 2403 0.31
jobq slave wait 7,544 49.36 18,291 2425 0.30
ASM background timer 802 0.00 3,695 4607 0.03
DIAG idle wait 18,901 0.00 3,692 195 0.76
ges remote message 126,933 86.90 3,691 29 5.10
Streams AQ: waiting for messages in the queue 391 96.68 3,686 9427 0.02
Streams AQ: qmn slave idle wait 129 4.65 3,681 28539 0.01
Streams AQ: qmn coordinator idle wait 282 52.48 3,681 13055 0.01
class slave wait 51 39.22 3,671 71972 0.00
Streams AQ: waiting for time management or cleanup tasks 1 100.00 2,061 2061154 0.00
PX Deq: Execution Msg 1,296 22.07 28 21 0.05
KSV master wait 29 13.79 12 418 0.00
PX Deq: Execute Reply 189 6.35 8 42 0.01
PX Deq: Table Q Normal 891 1.12 5 6 0.04
SGA: MMAN sleep for component shrink 97 96.91 1 10 0.00
PX Deq: Parse Reply 85 17.65 0 2 0.00
PX Deq: Join ACK 95 16.84 0 0 0.00
PX Deq: Msg Fragment 303 35.97 0 0 0.01
Streams AQ: RAC qmn coordinator idle wait 283 100.00 0 0 0.01

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 726,935 98.21 1,382 2 29.22
control file sequential read 15,717 0.00 23 1 0.63
log file parallel write 5,769 0.00 13 2 0.23
db file parallel write 4,293 0.00 10 2 0.17
control file parallel write 2,602 0.00 8 3 0.10
log file sequential read 38 0.00 1 16 0.00
os thread startup 11 0.00 0 38 0.00
enq: TM - contention 335 0.00 0 1 0.01
library cache lock 832 0.00 0 0 0.03
db file sequential read 137 0.00 0 1 0.01
row cache lock 172 0.00 0 0 0.01
db file scattered read 23 0.00 0 2 0.00
Log archive I/O 35 0.00 0 1 0.00
direct path read 26 0.00 0 1 0.00
gc cr block 2-way 31 0.00 0 0 0.00
gc cr grant 2-way 27 0.00 0 0 0.00
gc object scan 852 100.00 0 0 0.03
gc current block 2-way 5 0.00 0 1 0.00
gc current grant 2-way 16 0.00 0 0 0.00
gc cr multi block request 7 0.00 0 0 0.00
gc current multi block request 30 0.00 0 0 0.00
gc current grant busy 4 0.00 0 0 0.00
log file single write 2 0.00 0 0 0.00
latch: cache buffers chains 5 0.00 0 0 0.00
direct path write 26 0.00 -0 -1 0.00
rdbms ipc message 74,743 75.02 57,978 776 3.00
gcs remote message 1,709,367 99.23 21,327 12 68.71
ASM background timer 802 0.00 3,695 4607 0.03
DIAG idle wait 18,900 0.00 3,692 195 0.76
ges remote message 126,862 86.92 3,691 29 5.10
pmon timer 1,925 100.00 3,688 1916 0.08
Streams AQ: qmn slave idle wait 129 4.65 3,681 28539 0.01
Streams AQ: qmn coordinator idle wait 282 52.48 3,681 13055 0.01
class slave wait 49 40.82 3,671 74910 0.00
smon timer 15 0.00 3,631 242077 0.00
Streams AQ: waiting for time management or cleanup tasks 1 100.00 2,061 2061154 0.00
SGA: MMAN sleep for component shrink 97 96.91 1 10 0.00
KSV master wait 25 0.00 0 4 0.00
PX Deq: Join ACK 30 40.00 0 0 0.00
PX Deq: Parse Reply 28 39.29 0 0 0.00
PX Deq: Execute Reply 19 31.58 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 283 100.00 0 0 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 104,811
IDLE_TIME 8,970,791
IOWAIT_TIME 51,585
NICE_TIME 0
SYS_TIME 18,041
USER_TIME 78,088
LOAD 1
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 63,926.90 399.50 744,203 38,844,554
SYS$USERS 1,880.80 246.70 9,752 25,466,236
SYS$BACKGROUND 0.00 0.00 1,290 118,183

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 112177 20050 5159 238949 0 0 136722 10
SYS$USERS 8068 2378 14413 53081 0 0 658974 84
SYS$BACKGROUND 1287 541 3521 126 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
47,735 0 189 252.57 72.55 gzt34x6x7p8r0   UPDATE TMSTPOS SET TM_SMP=:1, ...
3,688 0 1 3687.75 5.60 gtpuh24u3cr3d   UPDATE TMSTPOS Set ...
2,369 0 32 74.03 3.60 gmvpuabz0upuy   INSERT INTO HPSTJNL (TXN_CD, C...
1,705 0 210 8.12 2.59 1v2p6m8d45ugy   UPDATE PUBSEQREC SET TM_SMP=:1...
1,357 0 133 10.20 2.06 72zqywap3utzv   INSERT INTO HPSTSJNL (AC_DT, T...
699 2 29 24.11 1.06 ba10x084yqdmg   SELECT LOG_NO, AC_DT OAC_DT, T...
460 0 95 4.84 0.70 26b1gn36rvajz JDBC Thin Client update FLOW_RUN_PRCS set CHILD...
401 0 86 4.66 0.61 0hpnx35mqhhpg   INSERT INTO HPSTSJNL (AC_DT, T...
258 0 9 28.62 0.39 gkscxsrrb9c7z   UPDATE TMSTATT SET TM_SMP=:1, ...
232 0 1 232.25 0.35 5xqtgz7cmz3my   UPDATE PUBSEQREC SET TM_SMP='2...

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
45 95 46 0.98 0.15 21mszhdh48c8b   UPDATE pubigtjnl SET STS = '4'...
35 61 46 0.75 0.09 2sxc8ayf8jzwv   SELECT TRAN_ID, LOG_NO, EXP_SE...
31 61 46 0.68 0.09 18ng21jkmu4r3   UPDATE pubigtjnl SET STS = '1'...
30 53 46 0.64 0.08 b4rwmd2njqqb3   UPDATE pubigtjnl SET STS = '1'...
23 36 437 0.05 0.05 4z72p16nrg35t   SELECT LOG_NO FROM...
22 25 8 2.72 0.04 d1nygjmu0sbfh   select count(1) TOTAL_NUM from...
15 16 152 0.10 0.02 cvzyymfbqx0uz   select * from (Select F...
11 11 463 0.02 0.02 b0qwmrwvssh9g JDBC Thin Client select RUN_ID , PRCS_ID , US...
7 7 270 0.03 0.01 37pz9rgg7ugvg JDBC Thin Client select RUN_ID , PRCS_ID , US...
6 17 4 1.58 0.03 a2p5jz512thmt JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
2 699 29 0.08 1.06 ba10x084yqdmg   SELECT LOG_NO, AC_DT OAC_DT, T...
0 47,735 189 0.00 72.55 gzt34x6x7p8r0   UPDATE TMSTPOS SET TM_SMP=:1, ...
0 1,357 133 0.00 2.06 72zqywap3utzv   INSERT INTO HPSTSJNL (AC_DT, T...
0 2,369 32 0.00 3.60 gmvpuabz0upuy   INSERT INTO HPSTJNL (TXN_CD, C...
0 1,705 210 0.00 2.59 1v2p6m8d45ugy   UPDATE PUBSEQREC SET TM_SMP=:1...
0 3,688 1 0.03 5.60 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
5,187,231 437 11,870.09 8.07 22.62 35.87 4z72p16nrg35t   SELECT LOG_NO FROM...
4,446,608 152 29,254.00 6.92 15.28 16.01 cvzyymfbqx0uz   select * from (Select F...
2,817,054 46 61,240.30 4.38 31.45 60.69 18ng21jkmu4r3   UPDATE pubigtjnl SET STS = '1'...
2,817,049 46 61,240.20 4.38 29.50 53.49 b4rwmd2njqqb3   UPDATE pubigtjnl SET STS = '1'...
2,817,048 46 61,240.17 4.38 34.59 60.50 2sxc8ayf8jzwv   SELECT TRAN_ID, LOG_NO, EXP_SE...
2,817,043 46 61,240.07 4.38 44.88 95.45 21mszhdh48c8b   UPDATE pubigtjnl SET STS = '4'...
1,194,949 8 149,368.63 1.86 21.76 24.89 d1nygjmu0sbfh   select count(1) TOTAL_NUM from...
817,817 463 1,766.34 1.27 11.21 11.23 b0qwmrwvssh9g JDBC Thin Client select RUN_ID , PRCS_ID , US...
789,891 1 789,891.00 1.23 3.32 159.65 awyuzsx1nzhbq   SELECT (CASE WHEN (SELE...
592,409 1 592,409.00 0.92 2.18 2.18 brkr3aakccfn6   SELECT (CASE WHEN (SELE...

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
60,611 2 30,305.50 8.03 4.66 19.44 15m25vhxac56v JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
57,495 46 1,249.89 7.61 44.88 95.45 21mszhdh48c8b   UPDATE pubigtjnl SET STS = '4'...
54,384 46 1,182.26 7.20 34.59 60.50 2sxc8ayf8jzwv   SELECT TRAN_ID, LOG_NO, EXP_SE...
42,821 46 930.89 5.67 31.45 60.69 18ng21jkmu4r3   UPDATE pubigtjnl SET STS = '1'...
36,083 46 784.41 4.78 29.50 53.49 b4rwmd2njqqb3   UPDATE pubigtjnl SET STS = '1'...
18,968 4 4,742.00 2.51 6.31 17.29 a2p5jz512thmt JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
2,215 437 5.07 0.29 22.62 35.87 4z72p16nrg35t   SELECT LOG_NO FROM...
1,608 2 804.00 0.21 2.12 11.81 djs2w2f17nw2z   DECLARE job BINARY_INTEGER := ...
646 8 80.75 0.09 21.76 24.89 d1nygjmu0sbfh   select count(1) TOTAL_NUM from...
180 1,312 0.14 0.02 0.83 1.89 fta7uj8qz3s5v   INSERT INTO ACMTCDDT(JRN_NO, J...

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,595 5,595 1.00 0.00 0.00 39jk1sd6mm65v   SELECT * FROM HPSTRULE WHERE R...
5,333 5,336 1.00 0.00 0.00 520mkxqpf15q8   select 1 from dual
3,221 3,221 1.00 0.00 0.00 bmh6mhtj0j1vh JDBC Thin Client select CLASS_CODE, CLASS_DESC ...
3,195 9,211 2.88 0.00 0.00 g97f7f972atab   SELECT DISTINCT(RUL_ID) AS RUL...
2,967 2,135 0.72 0.00 0.00 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
2,338 2,338 1.00 0.00 0.00 8mqvtww43thvj   select SYS_VER_NO, WIN_MODE, W...
2,338 2,338 1.00 0.00 0.00 gbdtgmzym5036   select to_char(sysdate, 'YYYYM...
2,007 39 0.02 0.00 0.00 d4bw42jjybuqv   SELECT * FROM HPSTOPER WHERE R...
1,843 1,843 1.00 0.00 0.00 0vujxx80tg5md JDBC Thin Client select count(distinct(user_ID)...
1,817 43,608 24.00 0.00 0.00 9g5nhn9ap9zbb JDBC Thin Client select SEQ_ID FROM DEPARTMENT
1,579 1,580 1.00 0.00 0.00 c2ym3p7ky2puv JDBC Thin Client select QUERY_USER, QUERY_USER...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
5,595 5,595 3.51 39jk1sd6mm65v   SELECT * FROM HPSTRULE WHERE R...
5,333 5,333 3.34 520mkxqpf15q8   select 1 from dual
3,221 3,221 2.02 bmh6mhtj0j1vh JDBC Thin Client select CLASS_CODE, CLASS_DESC ...
3,195 3,195 2.00 g97f7f972atab   SELECT DISTINCT(RUL_ID) AS RUL...
2,338 2,338 1.47 8mqvtww43thvj   select SYS_VER_NO, WIN_MODE, W...
2,338 2,338 1.47 gbdtgmzym5036   select to_char(sysdate, 'YYYYM...
2,007 2,007 1.26 d4bw42jjybuqv   SELECT * FROM HPSTOPER WHERE R...
1,843 1,843 1.16 0vujxx80tg5md JDBC Thin Client select count(distinct(user_ID)...
1,817 1,817 1.14 9g5nhn9ap9zbb JDBC Thin Client select SEQ_ID FROM DEPARTMENT
1,580 1,579 0.99 c2ym3p7ky2puv JDBC Thin Client select QUERY_USER, QUERY_USER...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,995,787 7 0.08 66kwrzhxwst0c JDBC Thin Client update FORM_DATA_722_701 set D...
1,980,427 6 0.08 3wj0z84gxgpqk JDBC Thin Client update FORM_DATA_722_701 set D...
1,980,427 16 0.08 a48u7u7d2f1ua JDBC Thin Client update FORM_DATA_722_701 set D...
1,980,427 8 0.08 ghbugzkktwuyk JDBC Thin Client update FORM_DATA_722_701 set D...
1,494,337 2 0.06 726p5x3umc7kw JDBC Thin Client update FORM_DATA_781_741 set D...
1,494,305 2 0.06 dadtrdhtxh10g JDBC Thin Client update FORM_DATA_781_741 set D...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
39 82 ajptcbg0g7c61   INSERT INTO HPSTJNL (TXN_CD, C...
38 87 bp7jntj1g9h66 JDBC Thin Client insert into FLOW_RUN_FEEDBACK ...
27 752 6c0n4uz9q956t   SELECT DLY_PAY_VOL FROM HPSTUR...
27 1,312 fta7uj8qz3s5v   INSERT INTO ACMTCDDT(JRN_NO, J...
24 762 amm0k8nmxqj5d   SELECT 'Y' EXIST_BLACK_FLG ...
21 173 4m7m0t6fjcs5x   update seq$ set increment$=:2,...

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,703.40 99.91 1,704.88 0.11 210 1v2p6m8d45ugy   UPDATE PUBSEQREC SET TM_SMP=:1...
1,259.17 53.15 2,368.99 0.15 32 gmvpuabz0upuy   INSERT INTO HPSTJNL (TXN_CD, C...
696.03 99.56 699.10 2.36 29 ba10x084yqdmg   SELECT LOG_NO, AC_DT OAC_DT, T...
638.89 47.08 1,356.96 0.19 133 72zqywap3utzv   INSERT INTO HPSTSJNL (AC_DT, T...
257.14 99.82 257.60 0.01 9 gkscxsrrb9c7z   UPDATE TMSTATT SET TM_SMP=:1, ...
250.61 62.50 400.96 0.09 86 0hpnx35mqhhpg   INSERT INTO HPSTSJNL (AC_DT, T...
231.76 99.79 232.25 0.01 1 5xqtgz7cmz3my   UPDATE PUBSEQREC SET TM_SMP='2...
195.49 99.96 195.56 0.05 60 5ansr7r9htpq3   update undo$ set name=:2, file...
195.36 42.51 459.55 0.05 95 26b1gn36rvajz JDBC Thin Client update FLOW_RUN_PRCS set CHILD...
169.12 99.98 169.15 0.00 1 cv2ntr4mbk7q0   UPDATE PUBSEQREC SET TM_SMP='2...
156.36 97.94 159.65 3.32 1 awyuzsx1nzhbq   SELECT (CASE WHEN (SELE...
155.42 97.82 158.88 3.49 3 2u0qnkndnbqb2   SELECT COUNT(TXN_TM) YC FROM H...
153.09 99.71 153.54 0.00 1 0m6g4mkh6qhqp   UPDATE PUBSEQREC SET TM_SMP='2...
142.25 99.97 142.29 0.00 1 g8963kawtf07z   UPDATE PUBSEQREC SET TM_SMP='2...
137.16 99.97 137.19 0.00 1 2uu451ct9mcxq   UPDATE PUBSEQREC SET TM_SMP='2...
38.73 40.58 95.45 44.88 46 21mszhdh48c8b   UPDATE pubigtjnl SET STS = '4'...
24.84 40.93 60.69 31.45 46 18ng21jkmu4r3   UPDATE pubigtjnl SET STS = '1'...
21.40 40.01 53.49 29.50 46 b4rwmd2njqqb3   UPDATE pubigtjnl SET STS = '1'...
20.60 34.04 60.50 34.59 46 2sxc8ayf8jzwv   SELECT TRAN_ID, LOG_NO, EXP_SE...
8.83 51.07 17.29 6.31 4 a2p5jz512thmt JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
6.83 35.13 19.44 4.66 2 15m25vhxac56v JDBC Thin Client select sum(CASE WHEN TXN_CD = ...
2.56 7.14 35.87 22.62 437 4z72p16nrg35t   SELECT LOG_NO FROM...
0.98 3.95 24.89 21.76 8 d1nygjmu0sbfh   select count(1) TOTAL_NUM from...
0.83 5.21 16.01 15.28 152 cvzyymfbqx0uz   select * from (Select F...
0.69 18.68 3.69 2.70 1 awyx0ca8maspu SQL*Plus select to_char(count(case when...
0.41 3.51 11.81 2.12 2 djs2w2f17nw2z   DECLARE job BINARY_INTEGER := ...
0.28 8.82 3.20 2.46 1 3h3u20aqp3jmg SQL*Plus select to_char(count(case when...
0.25 72.10 0.35 0.11 82 ajptcbg0g7c61   INSERT INTO HPSTJNL (TXN_CD, C...
0.22 11.76 1.89 0.83 1,312 fta7uj8qz3s5v   INSERT INTO ACMTCDDT(JRN_NO, J...
0.21 7.09 2.97 2.54 1 12m329dqy1wdc SQL*Plus select to_char(count(case when...
0.17 0.00 47,735.06 0.40 189 gzt34x6x7p8r0   UPDATE TMSTPOS SET TM_SMP=:1, ...
0.12 0.16 74.88 0.05 27 anq4kcs4wx1gq JDBC Thin Client update MANAGER set CREATE_DATE...
0.11 0.07 156.01 0.00 1 aq8yqxyyb40nn   update sys.job$ set this_date=...
0.11 54.64 0.20 0.05 120 8swypbbr0m372   select order#, columns, types ...
0.03 0.03 107.71 0.07 87 bp7jntj1g9h66 JDBC Thin Client insert into FLOW_RUN_FEEDBACK ...
0.03 0.09 35.28 0.13 129 8141n46hbgfhy   INSERT INTO PUBTLOGJNL (JRN_NO...
0.02 3.73 0.65 0.35 868 g4u6hd8jhxtjg   SELECT STL_CLS FR...
0.02 0.48 4.77 4.69 3 a725f79a7f13r   select count(1) TOTAL_NUM from...
0.02 0.65 2.78 2.76 202 1a6xa13xdmbqk JDBC Thin Client select points0_.TRADE_TRANSACT...
0.02 19.56 0.09 0.09 758 7ndyz6bdvh9zv   SELECT ACC_DT FROM pubpltinf
0.02 19.67 0.09 0.09 868 1jpbu18d03apd   SELECT TRM_STS, SGN_STS, TRM_T...
0.01 7.75 0.19 0.11 586 61hcjrkbxxhb3   SELECT MAC_KEY, PIN_KEY ...
0.01 4.13 0.21 0.17 1,253 2ym6hhaq30r73   select type#, blocks, extents,...
0.01 0.14 5.83 4.16 7 3j5241r66nxuy   select * from (SELECT ROWNUM R...
0.01 0.00 156.15 0.04 11 3b873nssv9bgt JDBC Thin Client insert into TIMING_TASK_LOG (E...
0.01 0.30 2.16 2.16 3 9aujnnr5jdmac   SELECT COUNT(TXN_TM) YC FROM H...
0.01 12.66 0.05 0.05 173 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
0.01 0.28 2.06 2.06 3 1p18937m44s1s   SELECT COUNT(B.LOG_NO) YC FROM...
0.01 0.26 2.10 2.10 3 gc94vahcnqf8q   SELECT COUNT(TXN_TM) YC FROM H...
0.01 10.31 0.05 0.05 753 d7nk6dja4wwzk   SELECT DLY_STL_AMT FROM HPSTMR...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
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)
0m6g4mkh6qhqpUPDATE PUBSEQREC SET TM_SMP='20120814120003', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='CUP' AND SEQ_CND='CUP'
0vujxx80tg5mdselect count(distinct(user_ID)) as COUNT from user_online
12m329dqy1wdcselect to_char(count(case when TTXN_STS in('T', 'X') then 'posp_type' end)/count(TTXN_STS), 99.99) as posp_timecount from HPSTJNL_20120320 where substr(txn_tm, 0, 12)>='20120814110300' and substr(txn_tm, 0, 12)<='20120814110800'
15m25vhxac56vselect 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= 800219558120072 and jrn_no= 201208110005717642 and ac_dt= 20120811
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
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
21mszhdh48c8bUPDATE pubigtjnl SET STS = '4', TM_SMP = :1 WHERE REG_ID=:2 and NOD_ID=:3 and STS = '2' AND FAL_TMS > MAX_TMS
26b1gn36rvajzupdate FLOW_RUN_PRCS set CHILD_RUN = :1 , PRCS_TIME = :2 , PARENT = :3 , USER_ID = :4 , CREATE_TIME = :5 , RUN_ID = :6 , FLOW_PRCS = :7 , TOP_FLAG = :8 , PRCS_FLAG = :9 , TIME_OUT = :10 , FREE_ITEM = :11 , PRCS_ID = :12 , OP_FLAG = :13 , OTHER_USER = :14 where SEQ_ID = :15
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
2uu451ct9mcxqUPDATE PUBSEQREC SET TM_SMP='20120814120019', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='BOC' AND SEQ_CND='BOC'
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
37pz9rgg7ugvgselect RUN_ID , PRCS_ID , USER_ID , PRCS_TIME , DELIVER_TIME , PRCS_FLAG , FLOW_PRCS , OP_FLAG , TOP_FLAG , DEL_FLAG , PARENT , CHILD_RUN , TIME_OUT , FREE_ITEM , CREATE_TIME , OTHER_USER , SEQ_ID from FLOW_RUN_PRCS where PRCS_ID = :1 and USER_ID = :2 and RUN_ID = :3 and FLOW_PRCS = :4
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)
3h3u20aqp3jmgselect to_char(count(case when TTXN_STS in('T', 'X') then 'posp_type' end)/count(TTXN_STS), 99.99) as posp_timecount from HPSTJNL_20120320 where substr(txn_tm, 0, 12)>='20120814112300' and substr(txn_tm, 0, 12)<='20120814112800'
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
3wj0z84gxgpqk update FORM_DATA_722_701 set DATA_352=:1, DATA_354=:2, DATA_353=:3, DATA_355=:4, DATA_356=:5, DATA_27=:6, DATA_28=:7, DATA_25=:8, DATA_29=:9, DATA_20=:10, DATA_26=:11, DATA_217=:12, DATA_216=:13, DATA_215=:14, DATA_214=:15, DATA_23=:16, DATA_24=:17, DATA_21=:18, DATA_219=:19, DATA_22=:20, DATA_218=:21, DATA_220=:22, DATA_221=:23, DATA_222=:24, DATA_14=:25, DATA_15=:26, DATA_16=:27, DATA_17=:28, DATA_18=:29, DATA_19=:30, DATA_226=:31, DATA_228=:32, DATA_227=:33, DATA_10=:34, DATA_11=:35, DATA_229=:36, DATA_12=:37, DATA_13=:38, DATA_230=:39, DATA_231=:40, DATA_232=:41, DATA_233=:42, DATA_234=:43, DATA_235=:44, DATA_273=:45, DATA_272=:46, DATA_271=:47, DATA_270=:48, DATA_131=:49, DATA_130=:50, DATA_136=:51, DATA_135=:52, DATA_134=:53, DATA_113=:54, DATA_44=:55, DATA_43=:56, DATA_46=:57, DATA_45=:58, DATA_40=:59, DATA_118=:60, DATA_42=:61, DATA_41=:62, DATA_47=:63, DATA_269=:64, DATA_266=:65, DATA_265=:66, DATA_268=:67, DATA_267=:68, DATA_262=:69, DATA_264=:70, DATA_263=:71, DATA_260=:72, DATA_35=:73, DATA_33=:74, DATA_116=:75, DATA_117=:76, DATA_32=:77, DATA_31=:78, DATA_30=:79, DATA_258=:80, DATA_39=:81, DATA_259=:82, DATA_38=:83, DATA_37=:84, DATA_36=:85, DATA_253=:86, DATA_150=:87, DATA_252=:88, DATA_251=:89, DATA_250=:90, DATA_257=:91, DATA_256=:92, DATA_255=:93, DATA_254=:94, DATA_158=:95, DATA_157=:96, DATA_156=:97, DATA_154=:98, DATA_153=:99, DATA_152=:100, DATA_60=:101, DATA_62=:102, DATA_61=:103, DATA_64=:104, DATA_63=:105, DATA_66=:106, DATA_65=:107, DATA_148=:108, DAT A_68=:109, DATA_149=:110, DATA_67=:111, DATA_249=:112, DATA_69=:113, DATA_240=:114, DATA_246=:115, DATA_247=:116, DATA_248=:117, DATA_242=:118, DATA_241=:119, DATA_244=:120, DATA_243=:121, DATA_245=:122, DATA_145=:123, DATA_144=:124, DATA_146=:125, DATA_141=:126, DATA_140=:127, DATA_142=:128, DATA_53=:129, DATA_52=:130, DATA_51=:131, DATA_50=:132, DATA_57=:133, DATA_56=:134, DATA_138=:135, DATA_55=:136, DATA_54=:137, DATA_236=:138, DATA_237=:139, DATA_238=:140, DATA_59=:141, DATA_278=:142, DATA_277=:143, DATA_276=:144, DATA_275=:145, DATA_274=:146, DATA_34=:147, DATA_357=:148, DATA_163=:149, DATA_70=:150, DATA_358=:151, DATA_164=:152, DATA_359=:153, DATA_165=:154, DATA_166=:155, DATA_160=:156, DATA_361=:157, DATA_78=:158, DATA_360=:159, DATA_79=:160, DATA_363=:161, DATA_362=:162, DATA_77=:163, DATA_74=:164, DATA_75=:165, DATA_72=:166, DATA_73=:167, DATA_3=:168, DATA_4=:169, DATA_1=:170, DATA_2=:171, DATA_379=:172, DATA_280=:173, DATA_281=:174, DATA_282=:175, DATA_283=:176, DATA_381=:177, DATA_380=:178, DATA_9=:179, DATA_6=:180, DATA_383=:181, DATA_5=:182, DATA_382=:183, DATA_8=:184, DATA_7=:185, DATA_384=:186, DATA_340=:187, DATA_341=:188, DATA_344=:189, DATA_345=:190, DATA_342=:191, DATA_343=:192, DATA_347=:193, DATA_346=:194, DATA_349=:195, DATA_348=:196, DATA_208=:197, DATA_207=:198, DATA_209=:199, DATA_204=:200, DATA_206=:201, DATA_205=:202, DATA_210=:203, DATA_211=:204, DATA_212=:205, DATA_213=:206, DATA_350=:207, DATA_351=:208, DATA_48=:209, DATA_49=:210, DATA_239=:211, DATA_58=:212, DATA_80=:213, DATA_81=:214, DATA_374=:215, DATA_373=:216, DATA_372=:217, DATA_377=:218, DATA_375=:219, DATA_71=:220 where RUN_ID=10669
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4z72p16nrg35tSELECT LOG_NO FROM HPSTJNL WHERE TRM_NO=:1 AND MERC_ID =:2 AND BAT_NO =:3 AND CSEQ_NO=:4
520mkxqpf15q8select 1 from dual
5ansr7r9htpq3update undo$ set name=:2, file#=:3, block#=:4, status$=:5, user#=:6, undosqn=:7, xactsqn=:8, scnbas=:9, scnwrp=:10, inst#=:11, ts#=:12, spare1=:13 where us#=:1
5xqtgz7cmz3myUPDATE PUBSEQREC SET TM_SMP='20120814115842', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='CUP' AND SEQ_CND='CUP'
61hcjrkbxxhb3SELECT MAC_KEY, PIN_KEY FROM TMSTPOS WHERE MERC_ID=:1 AND TRM_NO=:2
66kwrzhxwst0c update FORM_DATA_722_701 set DATA_352=:1, DATA_354=:2, DATA_353=:3, DATA_355=:4, DATA_356=:5, DATA_27=:6, DATA_28=:7, DATA_25=:8, DATA_29=:9, DATA_20=:10, DATA_26=:11, DATA_217=:12, DATA_216=:13, DATA_215=:14, DATA_214=:15, DATA_23=:16, DATA_24=:17, DATA_21=:18, DATA_219=:19, DATA_22=:20, DATA_218=:21, DATA_220=:22, DATA_221=:23, DATA_222=:24, DATA_14=:25, DATA_15=:26, DATA_16=:27, DATA_17=:28, DATA_18=:29, DATA_19=:30, DATA_226=:31, DATA_228=:32, DATA_227=:33, DATA_10=:34, DATA_11=:35, DATA_229=:36, DATA_12=:37, DATA_13=:38, DATA_230=:39, DATA_231=:40, DATA_232=:41, DATA_233=:42, DATA_234=:43, DATA_235=:44, DATA_273=:45, DATA_272=:46, DATA_271=:47, DATA_270=:48, DATA_131=:49, DATA_130=:50, DATA_136=:51, DATA_135=:52, DATA_134=:53, DATA_113=:54, DATA_44=:55, DATA_43=:56, DATA_46=:57, DATA_45=:58, DATA_40=:59, DATA_118=:60, DATA_42=:61, DATA_41=:62, DATA_47=:63, DATA_269=:64, DATA_266=:65, DATA_265=:66, DATA_268=:67, DATA_267=:68, DATA_262=:69, DATA_264=:70, DATA_263=:71, DATA_260=:72, DATA_35=:73, DATA_33=:74, DATA_116=:75, DATA_117=:76, DATA_32=:77, DATA_31=:78, DATA_30=:79, DATA_258=:80, DATA_39=:81, DATA_259=:82, DATA_38=:83, DATA_37=:84, DATA_36=:85, DATA_253=:86, DATA_150=:87, DATA_252=:88, DATA_251=:89, DATA_250=:90, DATA_257=:91, DATA_256=:92, DATA_255=:93, DATA_254=:94, DATA_158=:95, DATA_157=:96, DATA_156=:97, DATA_154=:98, DATA_153=:99, DATA_152=:100, DATA_60=:101, DATA_62=:102, DATA_61=:103, DATA_64=:104, DATA_63=:105, DATA_66=:106, DATA_65=:107, DATA_148=:108, DAT A_68=:109, DATA_149=:110, DATA_67=:111, DATA_249=:112, DATA_69=:113, DATA_240=:114, DATA_246=:115, DATA_247=:116, DATA_248=:117, DATA_242=:118, DATA_241=:119, DATA_244=:120, DATA_243=:121, DATA_245=:122, DATA_145=:123, DATA_144=:124, DATA_146=:125, DATA_141=:126, DATA_140=:127, DATA_142=:128, DATA_53=:129, DATA_52=:130, DATA_51=:131, DATA_50=:132, DATA_57=:133, DATA_56=:134, DATA_138=:135, DATA_55=:136, DATA_54=:137, DATA_236=:138, DATA_237=:139, DATA_238=:140, DATA_59=:141, DATA_278=:142, DATA_277=:143, DATA_276=:144, DATA_275=:145, DATA_274=:146, DATA_34=:147, DATA_357=:148, DATA_163=:149, DATA_70=:150, DATA_358=:151, DATA_164=:152, DATA_359=:153, DATA_165=:154, DATA_166=:155, DATA_160=:156, DATA_361=:157, DATA_78=:158, DATA_360=:159, DATA_79=:160, DATA_363=:161, DATA_362=:162, DATA_77=:163, DATA_74=:164, DATA_75=:165, DATA_72=:166, DATA_73=:167, DATA_3=:168, DATA_4=:169, DATA_1=:170, DATA_2=:171, DATA_379=:172, DATA_280=:173, DATA_281=:174, DATA_282=:175, DATA_283=:176, DATA_381=:177, DATA_380=:178, DATA_9=:179, DATA_6=:180, DATA_383=:181, DATA_5=:182, DATA_382=:183, DATA_8=:184, DATA_7=:185, DATA_384=:186, DATA_340=:187, DATA_341=:188, DATA_344=:189, DATA_345=:190, DATA_342=:191, DATA_343=:192, DATA_347=:193, DATA_346=:194, DATA_349=:195, DATA_348=:196, DATA_208=:197, DATA_207=:198, DATA_209=:199, DATA_204=:200, DATA_206=:201, DATA_205=:202, DATA_210=:203, DATA_211=:204, DATA_212=:205, DATA_213=:206, DATA_350=:207, DATA_351=:208, DATA_48=:209, DATA_49=:210, DATA_239=:211, DATA_58=:212, DATA_80=:213, DATA_81=:214, DATA_374=:215, DATA_373=:216, DATA_372=:217, DATA_377=:218, DATA_375=:219, DATA_71=:220 where RUN_ID=10665
6c0n4uz9q956tSELECT DLY_PAY_VOL FROM HPSTURDY WHERE STL_USR_ID = :1 AND PAY_CARD_ID = :2 AND TOT_DAY = :3
726p5x3umc7kw update FORM_DATA_781_741 set DATA_384=:1, DATA_216=:2, DATA_353=:3, DATA_354=:4, DATA_355=:5, DATA_356=:6, DATA_27=:7, DATA_28=:8, DATA_25=:9, DATA_26=:10, DATA_29=:11, DATA_217=:12, DATA_20=:13, DATA_218=:14, DATA_22=:15, DATA_220=:16, DATA_221=:17, DATA_222=:18, DATA_14=:19, DATA_15=:20, DATA_16=:21, DATA_17=:22, DATA_215=:23, DATA_214=:24, DATA_23=:25, DATA_24=:26, DATA_21=:27, DATA_219=:28, DATA_18=:29, DATA_19=:30, DATA_226=:31, DATA_227=:32, DATA_10=:33, DATA_229=:34, DATA_11=:35, DATA_12=:36, DATA_13=:37, DATA_228=:38, DATA_230=:39, DATA_231=:40, DATA_232=:41, DATA_233=:42, DATA_234=:43, DATA_235=:44, DATA_201=:45, DATA_202=:46, DATA_200=:47, DATA_345=:48, DATA_347=:49, DATA_346=:50, DATA_349=:51, DATA_348=:52, DATA_208=:53, DATA_207=:54, DATA_209=:55, DATA_204=:56, DATA_203=:57, DATA_206=:58, DATA_205=:59, DATA_210=:60, DATA_211=:61, DATA_212=:62, DATA_213=:63, DATA_350=:64, DATA_351=:65, DATA_352=:66, DATA_33=:67, DATA_118=:68, DATA_32=:69, DATA_31=:70, DATA_30=:71, DATA_258=:72, DATA_39=:73, DATA_259=:74, DATA_38=:75, DATA_37=:76, DATA_36=:77, DATA_253=:78, DATA_150=:79, DATA_252=:80, DATA_251=:81, DATA_250=:82, DATA_257=:83, DATA_256=:84, DATA_255=:85, DATA_254=:86, DATA_158=:87, DATA_157=:88, DATA_156=:89, DATA_154=:90, DATA_153=:91, DATA_152=:92, DATA_60=:93, DATA_62=:94, DATA_61=:95, DATA_64=:96, DATA_63=:97, DATA_66=:98, DATA_65=:99, DATA_68=:100, DATA_148=:101, DATA_67=:102, DATA_149=:103, DATA_249=:104, DATA_69=:105, DATA_247=:106, DATA_248=:107, DATA_240=:10 8, DATA_242=:109, DATA_241=:110, DATA_244=:111, DATA_243=:112, DATA_246=:113, DATA_245=:114, DATA_145=:115, DATA_144=:116, DATA_146=:117, DATA_141=:118, DATA_140=:119, DATA_142=:120, DATA_53=:121, DATA_52=:122, DATA_51=:123, DATA_50=:124, DATA_57=:125, DATA_56=:126, DATA_138=:127, DATA_55=:128, DATA_54=:129, DATA_236=:130, DATA_237=:131, DATA_238=:132, DATA_59=:133, DATA_58=:134, DATA_239=:135, DATA_80=:136, DATA_175=:137, DATA_173=:138, DATA_368=:139, DATA_81=:140, DATA_369=:141, DATA_179=:142, DATA_177=:143, DATA_178=:144, DATA_171=:145, DATA_172=:146, DATA_370=:147, DATA_374=:148, DATA_373=:149, DATA_372=:150, DATA_371=:151, DATA_377=:152, DATA_375=:153, DATA_71=:154, DATA_357=:155, DATA_358=:156, DATA_163=:157, DATA_70=:158, DATA_359=:159, DATA_164=:160, DATA_165=:161, DATA_166=:162, DATA_167=:163, DATA_168=:164, DATA_160=:165, DATA_78=:166, DATA_361=:167, DATA_79=:168, DATA_360=:169, DATA_363=:170, DATA_77=:171, DATA_362=:172, DATA_74=:173, DATA_365=:174, DATA_364=:175, DATA_278=:176, DATA_277=:177, DATA_276=:178, DATA_275=:179, DATA_274=:180, DATA_273=:181, DATA_272=:182, DATA_271=:183, DATA_131=:184, DATA_270=:185, DATA_130=:186, DATA_136=:187, DATA_135=:188, DATA_134=:189, DATA_113=:190, DATA_44=:191, DATA_43=:192, DATA_46=:193, DATA_45=:194, DATA_40=:195, DATA_42=:196, DATA_41=:197, DATA_47=:198, DATA_269=:199, DATA_266=:200, DATA_48=:201, DATA_49=:202, DATA_265=:203, DATA_268=:204, DATA_267=:205, DATA_262=:206, DATA_264=:207, DATA_263=:208, DATA_260=:209, DATA_35=:2 10, DATA_34=:211, DATA_116=:212, DATA_117=:213, DATA_189=:214, DATA_379=:215, DATA_185=:216, DATA_280=:217, DATA_186=:218, DATA_281=:219, DATA_187=:220, DATA_282=:221, DATA_283=:222, DATA_181=:223, DATA_182=:224, DATA_183=:225, DATA_381=:226, DATA_380=:227, DATA_9=:228, DATA_6=:229, DATA_383=:230, DATA_5=:231, DATA_382=:232, DATA_8=:233, DATA_7=:234, DATA_75=:235, DATA_72=:236, DATA_367=:237, DATA_73=:238, DATA_366=:239, DATA_3=:240, DATA_4=:241, DATA_1=:242, DATA_2=:243, DATA_197=:244, DATA_195=:245, DATA_193=:246, DATA_194=:247, DATA_191=:248, DATA_190=:249 where RUN_ID=10674
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)
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
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
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
9g5nhn9ap9zbbselect SEQ_ID FROM DEPARTMENT
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
a48u7u7d2f1ua update FORM_DATA_722_701 set DATA_352=:1, DATA_354=:2, DATA_353=:3, DATA_355=:4, DATA_356=:5, DATA_27=:6, DATA_28=:7, DATA_25=:8, DATA_29=:9, DATA_20=:10, DATA_26=:11, DATA_217=:12, DATA_216=:13, DATA_215=:14, DATA_214=:15, DATA_23=:16, DATA_24=:17, DATA_21=:18, DATA_219=:19, DATA_22=:20, DATA_218=:21, DATA_220=:22, DATA_221=:23, DATA_222=:24, DATA_14=:25, DATA_15=:26, DATA_16=:27, DATA_17=:28, DATA_18=:29, DATA_19=:30, DATA_226=:31, DATA_228=:32, DATA_227=:33, DATA_10=:34, DATA_11=:35, DATA_229=:36, DATA_12=:37, DATA_13=:38, DATA_230=:39, DATA_231=:40, DATA_232=:41, DATA_233=:42, DATA_234=:43, DATA_235=:44, DATA_273=:45, DATA_272=:46, DATA_271=:47, DATA_270=:48, DATA_131=:49, DATA_130=:50, DATA_136=:51, DATA_135=:52, DATA_134=:53, DATA_113=:54, DATA_44=:55, DATA_43=:56, DATA_46=:57, DATA_45=:58, DATA_40=:59, DATA_118=:60, DATA_42=:61, DATA_41=:62, DATA_47=:63, DATA_269=:64, DATA_266=:65, DATA_265=:66, DATA_268=:67, DATA_267=:68, DATA_262=:69, DATA_264=:70, DATA_263=:71, DATA_260=:72, DATA_35=:73, DATA_33=:74, DATA_116=:75, DATA_117=:76, DATA_32=:77, DATA_31=:78, DATA_30=:79, DATA_258=:80, DATA_39=:81, DATA_259=:82, DATA_38=:83, DATA_37=:84, DATA_36=:85, DATA_253=:86, DATA_150=:87, DATA_252=:88, DATA_251=:89, DATA_250=:90, DATA_257=:91, DATA_256=:92, DATA_255=:93, DATA_254=:94, DATA_158=:95, DATA_157=:96, DATA_156=:97, DATA_154=:98, DATA_153=:99, DATA_152=:100, DATA_60=:101, DATA_62=:102, DATA_61=:103, DATA_64=:104, DATA_63=:105, DATA_66=:106, DATA_65=:107, DATA_148=:108, DAT A_68=:109, DATA_149=:110, DATA_67=:111, DATA_249=:112, DATA_69=:113, DATA_240=:114, DATA_246=:115, DATA_247=:116, DATA_248=:117, DATA_242=:118, DATA_241=:119, DATA_244=:120, DATA_243=:121, DATA_245=:122, DATA_145=:123, DATA_144=:124, DATA_146=:125, DATA_141=:126, DATA_140=:127, DATA_142=:128, DATA_53=:129, DATA_52=:130, DATA_51=:131, DATA_50=:132, DATA_57=:133, DATA_56=:134, DATA_138=:135, DATA_55=:136, DATA_54=:137, DATA_236=:138, DATA_237=:139, DATA_238=:140, DATA_59=:141, DATA_278=:142, DATA_277=:143, DATA_276=:144, DATA_275=:145, DATA_274=:146, DATA_34=:147, DATA_357=:148, DATA_163=:149, DATA_70=:150, DATA_358=:151, DATA_164=:152, DATA_359=:153, DATA_165=:154, DATA_166=:155, DATA_160=:156, DATA_361=:157, DATA_78=:158, DATA_360=:159, DATA_79=:160, DATA_363=:161, DATA_362=:162, DATA_77=:163, DATA_74=:164, DATA_75=:165, DATA_72=:166, DATA_73=:167, DATA_3=:168, DATA_4=:169, DATA_1=:170, DATA_2=:171, DATA_379=:172, DATA_280=:173, DATA_281=:174, DATA_282=:175, DATA_283=:176, DATA_381=:177, DATA_380=:178, DATA_9=:179, DATA_6=:180, DATA_383=:181, DATA_5=:182, DATA_382=:183, DATA_8=:184, DATA_7=:185, DATA_384=:186, DATA_340=:187, DATA_341=:188, DATA_344=:189, DATA_345=:190, DATA_342=:191, DATA_343=:192, DATA_347=:193, DATA_346=:194, DATA_349=:195, DATA_348=:196, DATA_208=:197, DATA_207=:198, DATA_209=:199, DATA_204=:200, DATA_206=:201, DATA_205=:202, DATA_210=:203, DATA_211=:204, DATA_212=:205, DATA_213=:206, DATA_350=:207, DATA_351=:208, DATA_48=:209, DATA_49=:210, DATA_239=:211, DATA_58=:212, DATA_80=:213, DATA_81=:214, DATA_374=:215, DATA_373=:216, DATA_372=:217, DATA_377=:218, DATA_375=:219, DATA_71=:220 where RUN_ID=10670
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 )
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)
amm0k8nmxqj5dSELECT 'Y' EXIST_BLACK_FLG FROM USERBLACKLIST WHERE CRD_NO=:1
anq4kcs4wx1gqupdate MANAGER set CREATE_DATE=:1, MANAGER_ID=:2, ERR_LOGIN_COUNT=:3, LAST_LOGIN_DATE=:4, MERCHANT_ID=:5, mobile=:6, name=:7, password=:8, status=:9, type=:10 where id=:11
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
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
awyx0ca8maspuselect to_char(count(case when TTXN_STS in('T', 'X') then 'posp_type' end)/count(TTXN_STS), 99.99) as posp_timecount from HPSTJNL_20120320 where substr(txn_tm, 0, 12)>='20120814112800' and substr(txn_tm, 0, 12)<='20120814113300'
b0qwmrwvssh9gselect RUN_ID , PRCS_ID , USER_ID , PRCS_TIME , DELIVER_TIME , PRCS_FLAG , FLOW_PRCS , OP_FLAG , TOP_FLAG , DEL_FLAG , PARENT , CHILD_RUN , TIME_OUT , FREE_ITEM , CREATE_TIME , OTHER_USER , SEQ_ID from FLOW_RUN_PRCS where PRCS_ID = :1 and RUN_ID = :2 and FLOW_PRCS = :3
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
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
bmh6mhtj0j1vhselect CLASS_CODE, CLASS_DESC from CODE_ITEM where CLASS_CODE = ('7') and CLASS_NO = 'SMS_REMIND'
bp7jntj1g9h66insert into FLOW_RUN_FEEDBACK ( PRCS_ID, USER_ID, CONTENT, EDIT_TIME, ATTACHMENT_NAME, FLOW_PRCS, RUN_ID, FEED_FLAG, ATTACHMENT_ID ) values( :1 , :2, :3, :4, :5, :6, :7, :8, :9 )
brkr3aakccfn6SELECT (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 HPSTJNL T WHERE T.TTXN_STS!='S' AND T.TXN_TM BETWEEN :3 AND :4 AND T.TXN_CD<='2010090')*100/ (SELECT COUNT(TXN_TM) FNUM FROM HPSTJNL T WHERE T.TXN_TM BETWEEN :5 AND :6 AND T.TXN_CD<='2010090'), 2) ELSE 0 END )YC FROM DUAL
c2ym3p7ky2puvselect QUERY_USER, QUERY_USER_DEPT , MANAGE_USER , MANAGE_USER_DEPT from FLOW_TYPE where SEQ_ID=722
cv2ntr4mbk7q0UPDATE PUBSEQREC SET TM_SMP='20120814115946', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='BOC' AND SEQ_CND='BOC'
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
dadtrdhtxh10g update FORM_DATA_781_741 set DATA_384=:1, DATA_216=:2, DATA_353=:3, DATA_354=:4, DATA_355=:5, DATA_356=:6, DATA_27=:7, DATA_28=:8, DATA_25=:9, DATA_26=:10, DATA_29=:11, DATA_217=:12, DATA_20=:13, DATA_218=:14, DATA_22=:15, DATA_220=:16, DATA_221=:17, DATA_222=:18, DATA_14=:19, DATA_15=:20, DATA_16=:21, DATA_17=:22, DATA_215=:23, DATA_214=:24, DATA_23=:25, DATA_24=:26, DATA_21=:27, DATA_219=:28, DATA_18=:29, DATA_19=:30, DATA_226=:31, DATA_227=:32, DATA_10=:33, DATA_229=:34, DATA_11=:35, DATA_12=:36, DATA_13=:37, DATA_228=:38, DATA_230=:39, DATA_231=:40, DATA_232=:41, DATA_233=:42, DATA_234=:43, DATA_235=:44, DATA_201=:45, DATA_202=:46, DATA_200=:47, DATA_345=:48, DATA_347=:49, DATA_346=:50, DATA_349=:51, DATA_348=:52, DATA_208=:53, DATA_207=:54, DATA_209=:55, DATA_204=:56, DATA_203=:57, DATA_206=:58, DATA_205=:59, DATA_210=:60, DATA_211=:61, DATA_212=:62, DATA_213=:63, DATA_350=:64, DATA_351=:65, DATA_352=:66, DATA_33=:67, DATA_118=:68, DATA_32=:69, DATA_31=:70, DATA_30=:71, DATA_258=:72, DATA_39=:73, DATA_259=:74, DATA_38=:75, DATA_37=:76, DATA_36=:77, DATA_253=:78, DATA_150=:79, DATA_252=:80, DATA_251=:81, DATA_250=:82, DATA_257=:83, DATA_256=:84, DATA_255=:85, DATA_254=:86, DATA_158=:87, DATA_157=:88, DATA_156=:89, DATA_154=:90, DATA_153=:91, DATA_152=:92, DATA_60=:93, DATA_62=:94, DATA_61=:95, DATA_64=:96, DATA_63=:97, DATA_66=:98, DATA_65=:99, DATA_68=:100, DATA_148=:101, DATA_67=:102, DATA_149=:103, DATA_249=:104, DATA_69=:105, DATA_247=:106, DATA_248=:107, DATA_240=:10 8, DATA_242=:109, DATA_241=:110, DATA_244=:111, DATA_243=:112, DATA_246=:113, DATA_245=:114, DATA_145=:115, DATA_144=:116, DATA_146=:117, DATA_141=:118, DATA_140=:119, DATA_142=:120, DATA_53=:121, DATA_52=:122, DATA_51=:123, DATA_50=:124, DATA_57=:125, DATA_56=:126, DATA_138=:127, DATA_55=:128, DATA_54=:129, DATA_236=:130, DATA_237=:131, DATA_238=:132, DATA_59=:133, DATA_58=:134, DATA_239=:135, DATA_80=:136, DATA_175=:137, DATA_173=:138, DATA_368=:139, DATA_81=:140, DATA_369=:141, DATA_179=:142, DATA_177=:143, DATA_178=:144, DATA_171=:145, DATA_172=:146, DATA_370=:147, DATA_374=:148, DATA_373=:149, DATA_372=:150, DATA_371=:151, DATA_377=:152, DATA_375=:153, DATA_71=:154, DATA_357=:155, DATA_358=:156, DATA_163=:157, DATA_70=:158, DATA_359=:159, DATA_164=:160, DATA_165=:161, DATA_166=:162, DATA_167=:163, DATA_168=:164, DATA_160=:165, DATA_78=:166, DATA_361=:167, DATA_79=:168, DATA_360=:169, DATA_363=:170, DATA_77=:171, DATA_362=:172, DATA_74=:173, DATA_365=:174, DATA_364=:175, DATA_278=:176, DATA_277=:177, DATA_276=:178, DATA_275=:179, DATA_274=:180, DATA_273=:181, DATA_272=:182, DATA_271=:183, DATA_131=:184, DATA_270=:185, DATA_130=:186, DATA_136=:187, DATA_135=:188, DATA_134=:189, DATA_113=:190, DATA_44=:191, DATA_43=:192, DATA_46=:193, DATA_45=:194, DATA_40=:195, DATA_42=:196, DATA_41=:197, DATA_47=:198, DATA_269=:199, DATA_266=:200, DATA_48=:201, DATA_49=:202, DATA_265=:203, DATA_268=:204, DATA_267=:205, DATA_262=:206, DATA_264=:207, DATA_263=:208, DATA_260=:209, DATA_35=:2 10, DATA_34=:211, DATA_116=:212, DATA_117=:213, DATA_189=:214, DATA_379=:215, DATA_185=:216, DATA_280=:217, DATA_186=:218, DATA_281=:219, DATA_187=:220, DATA_282=:221, DATA_283=:222, DATA_181=:223, DATA_182=:224, DATA_183=:225, DATA_381=:226, DATA_380=:227, DATA_9=:228, DATA_6=:229, DATA_383=:230, DATA_5=:231, DATA_382=:232, DATA_8=:233, DATA_7=:234, DATA_75=:235, DATA_72=:236, DATA_367=:237, DATA_73=:238, DATA_366=:239, DATA_3=:240, DATA_4=:241, DATA_1=:242, DATA_2=:243, DATA_197=:244, DATA_195=:245, DATA_193=:246, DATA_194=:247, DATA_191=:248, DATA_190=:249 where RUN_ID=10463
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;
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)
g4u6hd8jhxtjgSELECT STL_CLS FROM URMTMSTL WHERE MERC_ID=:1 AND AMT_TYP='1' AND :2 BETWEEN EFF_DT AND EXP_DT
g8963kawtf07zUPDATE PUBSEQREC SET TM_SMP='20120814120014', SEL_VAL = SEL_VAL WHERE BR_NO='1021' AND SEQ_NM='BOC' AND SEQ_CND='BOC'
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
ghbugzkktwuyk update FORM_DATA_722_701 set DATA_352=:1, DATA_354=:2, DATA_353=:3, DATA_355=:4, DATA_356=:5, DATA_27=:6, DATA_28=:7, DATA_25=:8, DATA_29=:9, DATA_20=:10, DATA_26=:11, DATA_217=:12, DATA_216=:13, DATA_215=:14, DATA_214=:15, DATA_23=:16, DATA_24=:17, DATA_21=:18, DATA_219=:19, DATA_22=:20, DATA_218=:21, DATA_220=:22, DATA_221=:23, DATA_222=:24, DATA_14=:25, DATA_15=:26, DATA_16=:27, DATA_17=:28, DATA_18=:29, DATA_19=:30, DATA_226=:31, DATA_228=:32, DATA_227=:33, DATA_10=:34, DATA_11=:35, DATA_229=:36, DATA_12=:37, DATA_13=:38, DATA_230=:39, DATA_231=:40, DATA_232=:41, DATA_233=:42, DATA_234=:43, DATA_235=:44, DATA_273=:45, DATA_272=:46, DATA_271=:47, DATA_270=:48, DATA_131=:49, DATA_130=:50, DATA_136=:51, DATA_135=:52, DATA_134=:53, DATA_113=:54, DATA_44=:55, DATA_43=:56, DATA_46=:57, DATA_45=:58, DATA_40=:59, DATA_118=:60, DATA_42=:61, DATA_41=:62, DATA_47=:63, DATA_269=:64, DATA_266=:65, DATA_265=:66, DATA_268=:67, DATA_267=:68, DATA_262=:69, DATA_264=:70, DATA_263=:71, DATA_260=:72, DATA_35=:73, DATA_33=:74, DATA_116=:75, DATA_117=:76, DATA_32=:77, DATA_31=:78, DATA_30=:79, DATA_258=:80, DATA_39=:81, DATA_259=:82, DATA_38=:83, DATA_37=:84, DATA_36=:85, DATA_253=:86, DATA_150=:87, DATA_252=:88, DATA_251=:89, DATA_250=:90, DATA_257=:91, DATA_256=:92, DATA_255=:93, DATA_254=:94, DATA_158=:95, DATA_157=:96, DATA_156=:97, DATA_154=:98, DATA_153=:99, DATA_152=:100, DATA_60=:101, DATA_62=:102, DATA_61=:103, DATA_64=:104, DATA_63=:105, DATA_66=:106, DATA_65=:107, DATA_148=:108, DAT A_68=:109, DATA_149=:110, DATA_67=:111, DATA_249=:112, DATA_69=:113, DATA_240=:114, DATA_246=:115, DATA_247=:116, DATA_248=:117, DATA_242=:118, DATA_241=:119, DATA_244=:120, DATA_243=:121, DATA_245=:122, DATA_145=:123, DATA_144=:124, DATA_146=:125, DATA_141=:126, DATA_140=:127, DATA_142=:128, DATA_53=:129, DATA_52=:130, DATA_51=:131, DATA_50=:132, DATA_57=:133, DATA_56=:134, DATA_138=:135, DATA_55=:136, DATA_54=:137, DATA_236=:138, DATA_237=:139, DATA_238=:140, DATA_59=:141, DATA_278=:142, DATA_277=:143, DATA_276=:144, DATA_275=:145, DATA_274=:146, DATA_34=:147, DATA_357=:148, DATA_163=:149, DATA_70=:150, DATA_358=:151, DATA_164=:152, DATA_359=:153, DATA_165=:154, DATA_166=:155, DATA_160=:156, DATA_361=:157, DATA_78=:158, DATA_360=:159, DATA_79=:160, DATA_363=:161, DATA_362=:162, DATA_77=:163, DATA_74=:164, DATA_75=:165, DATA_72=:166, DATA_73=:167, DATA_3=:168, DATA_4=:169, DATA_1=:170, DATA_2=:171, DATA_379=:172, DATA_280=:173, DATA_281=:174, DATA_282=:175, DATA_283=:176, DATA_381=:177, DATA_380=:178, DATA_9=:179, DATA_6=:180, DATA_383=:181, DATA_5=:182, DATA_382=:183, DATA_8=:184, DATA_7=:185, DATA_384=:186, DATA_340=:187, DATA_341=:188, DATA_344=:189, DATA_345=:190, DATA_342=:191, DATA_343=:192, DATA_347=:193, DATA_346=:194, DATA_349=:195, DATA_348=:196, DATA_208=:197, DATA_207=:198, DATA_209=:199, DATA_204=:200, DATA_206=:201, DATA_205=:202, DATA_210=:203, DATA_211=:204, DATA_212=:205, DATA_213=:206, DATA_350=:207, DATA_351=:208, DATA_48=:209, DATA_49=:210, DATA_239=:211, DATA_58=:212, DATA_80=:213, DATA_81=:214, DATA_374=:215, DATA_373=:216, DATA_372=:217, DATA_377=:218, DATA_375=:219, DATA_71=:220 where RUN_ID=10668
gkscxsrrb9c7zUPDATE TMSTATT SET TM_SMP=:1, REG_FLG = '4', UPD_TM=:2 , UPD_TLR=:3 WHERE ATT_PK= :4
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 64,149 16.96 2.58
CPU used when call started 65,116 17.21 2.62
CR blocks created 1,462 0.39 0.06
Cached Commit SCN referenced 3,328 0.88 0.13
Commit SCN cached 1 0.00 0.00
DB time 2,552,002 674.53 102.58
DBWR checkpoint buffers written 7,665 2.03 0.31
DBWR checkpoints 1 0.00 0.00
DBWR fusion writes 1,246 0.33 0.05
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint 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 132 0.03 0.01
DBWR undo block writes 1,671 0.44 0.07
DDL statements parallelized 0 0.00 0.00
DFO trees parallelized 28 0.01 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 1,573 0.42 0.06
PX local messages sent 1,573 0.42 0.06
PX remote messages recv'd 576 0.15 0.02
PX remote messages sent 388 0.10 0.02
Parallel operations downgraded to serial 51 0.01 0.00
Parallel operations not downgraded 28 0.01 0.00
RowCR - row contention 2 0.00 0.00
RowCR attempts 3,584 0.95 0.14
RowCR hits 3,948 1.04 0.16
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 727,938 192.40 29.26
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 1,892 0.50 0.08
application wait time 5,144,712 1,359.82 206.81
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 17,026 4.50 0.68
branch node splits 2 0.00 0.00
buffer is not pinned count 13,385,707 3,538.04 538.08
buffer is pinned count 61,903,763 16,362.06 2,488.39
bytes received via SQL*Net from client 196,762,334 52,007.12 7,909.41
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 395,909,925 104,644.70 15,914.70
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 2,532,756 669.44 101.81
calls to kcmgas 48,193 12.74 1.94
calls to kcmgcs 849 0.22 0.03
change write time 87 0.02 0.00
cleanout - number of ktugct calls 1,836 0.49 0.07
cleanouts and rollbacks - consistent read gets 919 0.24 0.04
cleanouts only - consistent read gets 199 0.05 0.01
cluster key scan block gets 14,274 3.77 0.57
cluster key scans 5,319 1.41 0.21
cluster wait time 630,276 166.59 25.34
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 13 0.00 0.00
commit batch/immediate requested 13 0.00 0.00
commit cleanout failures: block lost 18 0.00 0.00
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 72 0.02 0.00
commit cleanout failures: cannot pin 4 0.00 0.00
commit cleanouts 20,146 5.32 0.81
commit cleanouts successfully completed 20,052 5.30 0.81
commit immediate performed 13 0.00 0.00
commit immediate requested 13 0.00 0.00
commit txn count during cleanout 2,405 0.64 0.10
concurrency wait time 292,148 77.22 11.74
consistent changes 754,981 199.55 30.35
consistent gets 61,988,370 16,384.42 2,491.79
consistent gets - examination 1,405,488 371.49 56.50
consistent gets direct 6,059 1.60 0.24
consistent gets from cache 63,471,138 16,776.34 2,551.40
current blocks converted for CR 11 0.00 0.00
cursor authentications 3,165 0.84 0.13
data blocks consistent reads - undo records applied 4,516 1.19 0.18
db block changes 840,309 222.11 33.78
db block gets 2,261,870 597.84 90.92
db block gets direct 163 0.04 0.01
db block gets from cache 2,261,707 597.80 90.92
deferred (CURRENT) block cleanout applications 11,008 2.91 0.44
dirty buffers inspected 9 0.00 0.00
enqueue conversions 2,341 0.62 0.09
enqueue deadlocks 0 0.00 0.00
enqueue releases 81,318 21.49 3.27
enqueue requests 81,307 21.49 3.27
enqueue timeouts 44 0.01 0.00
enqueue waits 2,441 0.65 0.10
exchange deadlocks 5 0.00 0.00
execute count 155,654 41.14 6.26
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 1,858,014 491.10 74.69
free buffer requested 2,008,509 530.88 80.74
gc CPU used by this session 24,567 6.49 0.99
gc blocks lost 0 0.00 0.00
gc cr block build time 13 0.00 0.00
gc cr block flush time 34,601 9.15 1.39
gc cr block receive time 35,989 9.51 1.45
gc cr block send time 14 0.00 0.00
gc cr blocks received 4,026 1.06 0.16
gc cr blocks served 6,781 1.79 0.27
gc current block flush time 89,297 23.60 3.59
gc current block pin time 3,006,848 794.75 120.87
gc current block receive time 164,568 43.50 6.62
gc current block send time 5,893 1.56 0.24
gc current blocks received 1,085,554 286.93 43.64
gc current blocks served 3,117,949 824.12 125.33
gc local grants 319,007 84.32 12.82
gc remote grants 431,409 114.03 17.34
gcs messages sent 3,890,236 1,028.25 156.38
ges messages sent 48,312 12.77 1.94
global enqueue get time 100,414 26.54 4.04
global enqueue gets async 5,332 1.41 0.21
global enqueue gets sync 66,114 17.47 2.66
global enqueue releases 68,598 18.13 2.76
heap block compress 444 0.12 0.02
hot buffers moved to head of LRU 34,968 9.24 1.41
immediate (CR) block cleanout applications 1,118 0.30 0.04
immediate (CURRENT) block cleanout applications 1,295 0.34 0.05
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 17,568 4.64 0.71
index fast full scans (full) 256 0.07 0.01
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 1,306,898 345.43 52.53
index scans kdiixs1 74,050 19.57 2.98
leaf node 90-10 splits 13 0.00 0.00
leaf node splits 249 0.07 0.01
lob reads 176,176 46.57 7.08
lob writes 294,569 77.86 11.84
lob writes unaligned 294,569 77.86 11.84
logons cumulative 734 0.19 0.03
messages received 17,773 4.70 0.71
messages sent 17,645 4.66 0.71
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 61,488,998 16,252.43 2,471.72
opened cursors cumulative 167,924 44.38 6.75
parse count (failures) 26 0.01 0.00
parse count (hard) 19,635 5.19 0.79
parse count (total) 159,551 42.17 6.41
parse time cpu 4,222 1.12 0.17
parse time elapsed 4,759 1.26 0.19
physical read IO requests 144,392 38.16 5.80
physical read bytes 6,189,654,016 1,636,014.75 248,810.31
physical read total IO requests 175,383 46.36 7.05
physical read total bytes 6,748,353,024 1,783,686.94 271,268.76
physical read total multi block requests 76,770 20.29 3.09
physical reads 755,081 199.58 30.35
physical reads cache 749,488 198.10 30.13
physical reads cache prefetch 633,755 167.51 25.48
physical reads direct 6,085 1.61 0.24
physical reads direct (lob) 6,043 1.60 0.24
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 6,698 1.77 0.27
physical write bytes 76,423,168 20,199.74 3,072.04
physical write total IO requests 15,180 4.01 0.61
physical write total bytes 192,674,304 50,926.59 7,745.08
physical write total multi block requests 6,159 1.63 0.25
physical writes 9,329 2.47 0.38
physical writes direct 189 0.05 0.01
physical writes direct (lob) 16 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 9,140 2.42 0.37
physical writes non checkpoint 6,508 1.72 0.26
pinned buffers inspected 20 0.01 0.00
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 4 0.00 0.00
process last non-idle time 3,774 1.00 0.15
queries parallelized 28 0.01 0.00
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 340,967 90.12 13.71
recursive cpu usage 8,699 2.30 0.35
redo blocks written 74,176 19.61 2.98
redo buffer allocation retries 0 0.00 0.00
redo entries 92,561 24.47 3.72
redo log space requests 0 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 1,698 0.45 0.07
redo size 35,037,388 9,260.89 1,408.42
redo subscn max counts 887 0.23 0.04
redo synch time 424,561 112.22 17.07
redo synch writes 4,825 1.28 0.19
redo wastage 1,502,960 397.25 60.42
redo write time 1,358 0.36 0.05
redo writer latching time 0 0.00 0.00
redo writes 5,772 1.53 0.23
rollback changes - undo records applied 29 0.01 0.00
rollbacks only - consistent read gets 494 0.13 0.02
rows fetched via callback 324,751 85.84 13.05
session connect time 0 0.00 0.00
session cursor cache hits 85,662 22.64 3.44
session logical reads 64,250,240 16,982.26 2,582.72
session pga memory 714,745,528 188,917.54 28,731.18
session pga memory max 1,544,242,648 408,165.58 62,075.12
session uga memory 8,628,038,736 2,280,514.96 346,827.94
session uga memory max 317,966,080 84,043.02 12,781.53
shared hash latch upgrades - no wait 25,710 6.80 1.03
shared hash latch upgrades - wait 15 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 23,125 6.11 0.93
sorts (rows) 851,807 225.14 34.24
sql area evicted 10,221 2.70 0.41
sql area purged 25 0.01 0.00
summed dirty queue length 18 0.00 0.00
switch current to new buffer 1,105 0.29 0.04
table fetch by rowid 34,972,823 9,243.82 1,405.83
table fetch continued row 65,612 17.34 2.64
table scan blocks gotten 52,353,985 13,837.91 2,104.51
table scan rows gotten 2,943,035,579 777,886.71 118,303.48
table scans (long tables) 218 0.06 0.01
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 68,758 18.17 2.76
total number of times SMON posted 15 0.00 0.00
transaction lock background gets 60 0.02 0.00
transaction lock foreground requests 60 0.02 0.00
transaction lock foreground wait time 3 0.00 0.00
transaction rollbacks 13 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 10,589,440 2,798.94 425.67
user I/O wait time 22,878 6.05 0.92
user calls 875,320 231.36 35.19
user commits 4,746 1.25 0.19
user rollbacks 20,131 5.32 0.81
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 11,561 3.06 0.46
write clones created in background 0 0.00 0.00
write clones created in foreground 7 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 19,731,008 19,736,908
opened cursors current 703 660
workarea memory allocated 1,216 1,216
logons current 158 269

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 121,430 32 1.17 5.42 1,962 1 3,451 989.57
TBS_RPT 7,437 2 1.48 10.71 1 0 11,954 1.14
USERS 4,689 1 0.11 1.35 1 0 1 0.00
SYSAUX 3,084 1 5.43 1.00 1,134 0 0 0.00
TBS_POSP_IDX 2,557 1 6.92 1.01 1,624 0 2 30.00
TBS_POSP_IDX_2 3,096 1 4.66 1.00 362 0 1,075 983.07
T9WORKFLOW 878 0 7.00 1.06 871 0 2 0.00
SYSTEM 931 0 5.41 1.08 88 0 0 0.00
TBS_VAS 304 0 6.41 1.01 176 0 0 0.00
UNDOTBS1 46 0 7.83 1.00 353 0 2 0.00
TBS_PAX 28 0 8.21 1.00 93 0 1 0.00
TBS_RPT_IDX 41 0 2.93 1.00 1 0 0 0.00
TBS_BMP 28 0 1.79 1.07 1 0 0 0.00
TBS_PAX_IDX 6 0 5.00 1.00 19 0 2 0.00
TBS_SMS 3 0 50.00 1.00 1 0 0 0.00
TEMP 3 0 3.33 1.00 0 0 0 0.00
UNDOTBS2 2 0 0.00 1.00 1 0 66 11.52
BMP 1 0 0.00 1.00 1 0 0 0.00
LV_POSP 1 0 0.00 1.00 1 0 0 0.00
TBS_BMP_IDX 1 0 0.00 1.00 1 0 0 0.00
TBS_CLOUD 1 0 0.00 1.00 1 0 0 0.00
TBS_GG 1 0 0.00 1.00 1 0 0 0.00
TBS_MNG 1 0 0.00 1.00 1 0 0 0.00
TBS_MNG_IDX 1 0 0.00 1.00 1 0 0 0.00
TBS_MQ 1 0 0.00 1.00 1 0 0 0.00
TBS_SMS_IDX 1 0 0.00 1.00 1 0 0 0.00
TBS_VAS_IDX 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
BMP +ORADATA/g1db/datafile/bmp.dbf 1 0 0.00 1.00 1 0 0 0.00
LV_POSP +ORADATA/g1db/datafile/lv_posp.dbf 1 0 0.00 1.00 1 0 0 0.00
SYSAUX +ORADATA/g1db/datafile/sysaux.261.736641563 3,084 1 5.43 1.00 1,134 0 0 0.00
SYSTEM +ORADATA/g1db/datafile/system.259.736641557 931 0 5.41 1.08 88 0 0 0.00
T9WORKFLOW +ORADATA/g1db/datafile/t9workflow01.dbf 878 0 7.00 1.06 871 0 2 0.00
TBS_BMP +ORADATA/g1db/datafile/tbs_bmp.279.736909997 28 0 1.79 1.07 1 0 0 0.00
TBS_BMP_IDX +ORADATA/g1db/datafile/tbs_bmp_idx.284.736910303 1 0 0.00 1.00 1 0 0 0.00
TBS_CLOUD +ORADATA/g1db/datafile/tbs_cloudboss.dbf 1 0 0.00 1.00 1 0 0 0.00
TBS_GG +ORADATA/g1db/datafile/tbs_gg.1172.790730537 1 0 0.00 1.00 1 0 0 0.00
TBS_MNG +ORADATA/g1db/datafile/tbs_mng.278.736910049 1 0 0.00 1.00 1 0 0 0.00
TBS_MNG_IDX +ORADATA/g1db/datafile/tbs_mng_idx.285.736910315 1 0 0.00 1.00 1 0 0 0.00
TBS_MQ +ORADATA/g1db/datafile/tbs_mq.1140.790707929 1 0 0.00 1.00 1 0 0 0.00
TBS_PAX +ORADATA/g1db/datafile/tbs_pax01.dbf 28 0 8.21 1.00 93 0 1 0.00
TBS_PAX_IDX +ORADATA/g1db/datafile/tbs_pax_idx01.dbf 6 0 5.00 1.00 19 0 2 0.00
TBS_POSP +ORADATA/g1db/datafile/tbs_posp.277.736909545 121,430 32 1.17 5.42 1,962 1 3,451 989.57
TBS_POSP_IDX +ORADATA/g1db/datafile/tbs_posp_idx.286.736910319 2,557 1 6.92 1.01 1,624 0 2 30.00
TBS_POSP_IDX_2 +ORADATA/g1db/datafile/tbs_posp_idx_2.dbf 3,096 1 4.66 1.00 362 0 1,075 983.07
TBS_RPT +ORADATA/g1db/datafile/tbs_rpt.280.736910069 7,437 2 1.48 10.71 1 0 11,954 1.14
TBS_RPT_IDX +ORADATA/g1db/datafile/tbs_rpt_idx.282.736910281 41 0 2.93 1.00 1 0 0 0.00
TBS_SMS +ORADATA/g1db/datafile/tbs_sms01.dbf 3 0 50.00 1.00 1 0 0 0.00
TBS_SMS_IDX +ORADATA/g1db/datafile/tbs_sms_idx01.dbf 1 0 0.00 1.00 1 0 0 0.00
TBS_VAS +ORADATA/g1db/datafile/tbs_vas.281.736910101 304 0 6.41 1.01 176 0 0 0.00
TBS_VAS_IDX +ORADATA/g1db/datafile/tbs_vas_idx.283.736910293 1 0 0.00 1.00 1 0 0 0.00
TEMP +ORADATA/g1db/tempfile/temp.262.736641563 3 0 3.33 1.00 0 0 0  
UNDOTBS1 +ORADATA/g1db/datafile/undotbs1.260.736641561 46 0 7.83 1.00 353 0 2 0.00
UNDOTBS2 +ORADATA/g1db/datafile/undotbs2.263.736641567 2 0 0.00 1.00 1 0 66 11.52
USERS +ORADATA/g1db/datafile/users.264.736641567 4,689 1 0.11 1.35 1 0 1 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 444,069 99 65,757,706 749,537 9,140 0 0 16,556


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 1 1400 12375 32306 1887390 32306  
E 0 2 1995 15886 39973 1887390 39973  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 368 0.10 44,137 1.54 1,268,160,029
D 736 0.20 88,274 1.48 1,215,551,793
D 1,104 0.30 132,411 1.41 1,163,221,211
D 1,472 0.40 176,548 1.35 1,111,392,854
D 1,840 0.50 220,685 1.29 1,060,363,128
D 2,208 0.59 264,822 1.23 1,010,622,616
D 2,576 0.69 308,959 1.17 962,348,971
D 2,944 0.79 353,096 1.11 915,552,050
D 3,312 0.89 397,233 1.06 870,141,722
D 3,680 0.99 441,370 1.00 825,975,516
D 3,712 1.00 445,208 1.00 822,229,500
D 4,048 1.09 485,507 0.95 782,896,325
D 4,416 1.19 529,644 0.90 740,747,990
D 4,784 1.29 573,781 0.85 699,378,655
D 5,152 1.39 617,918 0.80 658,641,078
D 5,520 1.49 662,055 0.75 618,394,732
D 5,888 1.59 706,192 0.70 578,510,320
D 6,256 1.69 750,329 0.66 538,875,229
D 6,624 1.78 794,466 0.61 499,397,801
D 6,992 1.88 838,603 0.56 460,008,625
D 7,360 1.98 882,740 0.51 420,657,999

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 477 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,504 901.19 4.31 0.48 100.00 0.00 328,490
E 3,208 2,346 1,353.09 1.19 0.09 100.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 11,021 11,021 0 0
64K 128K 60 60 0 0
128K 256K 18 18 0 0
256K 512K 22 22 0 0
512K 1024K 371 371 0 0
1M 2M 61 61 0 0
2M 4M 4 4 0 0
4M 8M 1 1 0 0
16M 32M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
401 0.13 2,844,862.73 573,275.69 83.00 375
802 0.25 2,844,862.73 341,871.23 89.00 0
1,604 0.50 2,844,862.73 333,787.20 89.00 0
2,406 0.75 2,844,862.73 333,787.20 89.00 0
3,208 1.00 2,844,862.73 332,385.00 90.00 0
3,850 1.20 2,844,862.73 308,711.89 90.00 0
4,491 1.40 2,844,862.73 308,711.89 90.00 0
5,133 1.60 2,844,862.73 308,711.89 90.00 0
5,774 1.80 2,844,862.73 308,711.89 90.00 0
6,416 2.00 2,844,862.73 308,711.89 90.00 0
9,624 3.00 2,844,862.73 308,711.89 90.00 0
12,832 4.00 2,844,862.73 308,711.89 90.00 0
19,248 6.00 2,844,862.73 308,711.89 90.00 0
25,664 8.00 2,844,862.73 308,711.89 90.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
720 0.30 267 20,898 25,358,838 0.93 2,058,630 35.27 370,350,070
960 0.40 502 34,143 25,656,928 0.94 1,760,540 30.16 370,684,351
1,200 0.50 739 51,625 25,951,110 0.95 1,466,358 25.12 371,013,536
1,440 0.60 976 69,104 26,238,901 0.96 1,178,567 20.19 371,336,411
1,680 0.70 1,214 81,322 26,523,399 0.97 894,069 15.32 371,656,087
1,920 0.80 1,452 94,813 26,804,798 0.98 612,670 10.50 371,972,819
2,160 0.90 1,691 109,538 27,083,298 0.99 334,170 5.73 372,286,636
2,400 1.00 1,929 128,310 27,359,104 1.00 58,364 1.00 372,597,974
2,640 1.10 2,168 148,756 27,632,418 1.01 1 0.00 372,907,013
2,880 1.20 2,407 171,467 27,903,437 1.02 1 0.00 373,213,961
3,120 1.30 2,646 191,490 28,172,351 1.03 1 0.00 373,518,865
3,360 1.40 2,884 203,205 28,439,344 1.04 1 0.00 373,821,796
3,600 1.50 3,121 216,310 28,704,589 1.05 1 0.00 374,122,866
3,840 1.60 3,359 228,159 28,968,219 1.06 1 0.00 374,422,052
4,080 1.70 3,598 238,527 29,230,145 1.07 1 0.00 374,719,049
4,320 1.80 3,836 248,967 29,490,776 1.08 1 0.00 375,014,333
4,560 1.90 4,074 256,823 29,751,050 1.09 1 0.00 375,309,130
4,800 2.00 4,313 260,064 30,011,309 1.10 1 0.00 375,603,901

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,530,095 1,198,315,226
3,072 0.50 4,765,499 1,198,315,226
4,608 0.75 4,554,794 1,001,967,157
6,144 1.00 4,362,412 822,228,095
7,680 1.25 4,148,218 622,344,445
9,216 1.50 4,084,090 471,876,704
10,752 1.75 4,082,345 397,465,061
12,288 2.00 4,082,345 397,465,061

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 16,326 4,326 265
1st level bmb 160 159 995
undo header 53 1 14
file header block 3 0 10
undo block 14 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,259 11,245 14 1,174 1,011 861.27
US-Undo Segment 446 446 0 431 8 18.03
WF-AWR Flush 19 19 0 9 1 91.11
TX-Transaction (row lock contention) 44 40 0 40 1 18.50
TM-DML 15,606 15,606 0 333 0 1.11
TX-Transaction (index contention) 14 14 0 11 0 10.91
PS-PX Process Reservation 510 482 28 206 0 0.39
TT-Tablespace 650 650 0 127 0 0.47
FB-Format Block 37 37 0 18 0 1.11
TX-Transaction 6,143 6,143 0 27 0 0.37
MW-MWIN Schedule 2 2 0 2 0 5.00
HW-Segment High Water Mark 658 658 0 35 0 0.00
TA-Instance Undo 12 12 0 12 0 0.00
PI-Remote PX Process Spawn Status 4 4 0 4 0 0.00
TX-Transaction (allocate ITL entry) 2 2 0 2 0 0.00
JQ-Job Queue 3 1 2 1 0 0.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 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
1 2.13 6,657 1,383 16 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:08 23 133 1,005 5 1,440 0/0 0/0/0/0/0/0
14-Aug 11:58 782 1,766 584 16 1,440 0/0 0/0/0/0/0/0
14-Aug 11:48 185 783 0 4 1,440 0/0 0/0/0/0/0/0
14-Aug 11:38 266 1,426 1,357 4 1,440 0/0 0/0/0/0/0/0
14-Aug 11:28 150 546 1,383 3 1,440 0/0 0/0/0/0/0/0
14-Aug 11:18 173 997 781 3 1,440 0/0 0/0/0/0/0/0
14-Aug 11:08 547 1,006 181 5 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 182 0.00   0 0  
ASM db client latch 2,597 0.00   0 0  
ASM map headers 88 0.00   0 0  
ASM map load waiting list 19 0.00   0 0  
ASM map operation freelist 729 0.41 0.00 0 0  
ASM map operation hash table 427,384 0.04 0.00 0 0  
ASM network background latch 1,621 0.00   0 0  
AWR Alerted Metric Element list 22,205 0.00   0 0  
Consistent RBA 5,771 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 26 0.00   0 0  
FOB s.o list latch 1,004 0.10 1.00 0 0  
JS broadcast add buf latch 864 0.00   0 0  
JS broadcast drop buf latch 864 0.00   0 0  
JS broadcast load blnc latch 756 0.00   0 0  
JS queue state obj latch 22,680 0.00   0 0  
KCL gc element parent latch 15,767,119 0.01 0.01 0 94,304 0.28
KFK SGA context latch 2,679 0.00   0 0  
KFMD SGA 529 0.57 0.00 0 0  
KJC message pool free list 126,611 0.06 0.00 0 63,768 0.00
KJCT flow control latch 2,226,302 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,357 0.00   0 0  
KMG resize request state object freelist 8 0.00   0 0  
KSXR large replies 252 0.00   0 0  
KTF sga latch 14 0.00   0 939 0.00
KWQMN job cache list latch 284 0.00   0 0  
KWQP Prop Status 1 0.00   0 0  
MQL Tracking Latch 0     0 70 0.00
Memory Management Latch 177 0.00   0 1,357 0.00
OS process 1,512 0.00   0 0  
OS process allocation 2,378 0.00   0 0  
OS process: request allocation 1,018 0.10 0.00 0 0  
PL/SQL warning settings 941 0.00   0 0  
SGA IO buffer pool latch 5 0.00   0 5 0.00
SQL memory manager latch 2 0.00   0 1,256 0.00
SQL memory manager workarea list latch 109,517 0.00 0.00 0 0  
Shared B-Tree 126 0.00   0 0  
active checkpoint queue latch 8,684 0.15 0.00 0 0  
active service list 10,861 0.26 0.00 0 1,925 0.00
archive control 63 0.00   0 0  
archive process latch 1,404 0.00   0 0  
begin backup scn array 23 0.00   0 0  
buffer pool 537 0.00   0 0  
business card 32 0.00   0 0  
cache buffer handles 1,453 0.00   0 0  
cache buffers chains 141,045,252 0.16 0.00 0 11,108,856 0.01
cache buffers lru chain 2,103,309 0.01 0.00 0 19,672,061 0.01
cache table scan latch 0     0 75,545 0.01
channel handle pool latch 1,020 0.00   0 0  
channel operations parent latch 373,726 0.01 0.00 0 0  
checkpoint queue latch 392,026 0.01 0.00 0 41,860 0.03
client/application info 4,126 0.00   0 0  
compile environment latch 756 0.00   0 0  
dml lock allocation 31,103 0.00   0 0  
dummy allocation 1,402 1.00 0.07 0 0  
enqueue hash chains 206,978 0.03 0.11 0 59,252 0.00
enqueues 166,789 0.03 0.05 0 0  
error message lists 208 5.77 0.00 0 0  
event group latch 564 0.00   0 0  
file cache latch 703 0.00   0 0  
gcs opaque info freelist 4,414,588 0.21 0.00 0 0  
gcs partitioned table hash 33,491,842 0.00   0 0  
gcs remaster request queue 3 0.00   0 0  
gcs remastering latch 3,971,644 0.00 0.00 0 0  
gcs resource freelist 1,698,715 0.01 0.00 0 1,031,947 0.02
gcs resource hash 15,517,853 0.00 0.00 0 22 0.00
gcs resource scan list 44 0.00   0 0  
gcs shadows freelist 3,099,480 0.00 0.00 0 3,092,585 0.00
ges caches resource lists 482,639 0.01 0.00 0 461,225 0.00
ges deadlock list 30,108 0.00   0 3,500 0.00
ges domain table 135,578 0.00   0 0  
ges enqueue table freelist 133,200 0.00   0 0  
ges group table 190,922 0.00 0.00 0 0  
ges process hash list 14,657 0.00   0 0  
ges process parent latch 303,200 0.00   0 7 0.00
ges process table freelist 1,018 0.00   0 0  
ges resource hash list 273,757 0.12 0.02 0 56,391 0.02
ges resource scan list 1,090 0.00   0 0  
ges resource table freelist 73,975 0.00   0 0  
ges synchronous data 128 1.56 0.00 0 220,357 0.00
ges timeout list 7,616 0.00   0 17,134 0.00
global KZLD latch for mem in SGA 552 0.00   0 0  
hash table column usage latch 764 0.00   0 486,044 0.00
hash table modification latch 139 0.00   0 0  
job workq parent latch 0     0 4 0.00
job_queue_processes parameter latch 65 0.00   0 0  
kks stats 78,924 0.03 0.00 0 0  
kokc descriptor allocation latch 542 0.00   0 0  
ksuosstats global area 256 0.00   0 0  
ksv instance 1 0.00   0 0  
ktm global data 15 0.00   0 0  
kwqbsn:qsga 126 0.00   0 0  
lgwr LWN SCN 6,300 0.00   0 0  
library cache 926,958 0.03 0.01 0 73,389 0.01
library cache load lock 3,341 0.00   0 0  
library cache lock 491,356 0.03 0.00 0 0  
library cache lock allocation 3,298 0.00   0 0  
library cache pin 189,314 0.01 0.00 0 2 0.00
library cache pin allocation 522 0.00   0 0  
list of block allocation 347 0.00   0 0  
loader state object freelist 2,366 0.00   0 0  
longop free list parent 22 0.00   0 22 0.00
message pool operations parent latch 1,202 0.00   0 0  
messages 173,877 0.03 0.00 0 0  
mostly latch-free SCN 6,313 0.03 0.00 0 0  
msg queue 26 0.00   0 26 0.00
multiblock read objects 502,454 0.00 0.00 0 2 0.00
name-service memory objects 4,134 0.02 0.00 0 0  
name-service namespace bucket 47,109 0.00   0 0  
name-service pending queue 2,620 0.00   0 0  
name-service request 132 0.00   0 0  
name-service request queue 40,430 0.00   0 0  
ncodef allocation latch 91 0.00   0 0  
object queue header heap 117,380 0.00   0 116,795 0.00
object queue header operation 4,194,124 0.00 0.00 0 30,053 0.04
object stats modification 1 0.00   0 0  
parallel query alloc buffer 3,264 0.58 0.00 0 0  
parallel query stats 274 10.22 0.00 0 0  
parallel txn reco latch 1,716 0.00   0 0  
parameter list 4,863 0.00   0 0  
parameter table allocation management 654 7.65 0.24 0 0  
post/wait queue 42,138 0.04 0.00 0 35,676 0.06
process allocation 36,797 0.01 1.00 0 564 0.00
process group creation 1,018 0.00   0 0  
process queue 1,368 1.32 0.00 0 0  
process queue reference 48,983 0.02 0.00 0 3,103 0.23
qmn state object latch 1 0.00   0 0  
qmn task queue latch 499 0.00   0 0  
query server freelists 1,136 4.31 0.00 0 0  
query server process 22 0.00   0 22 0.00
queued dump request 15,763 0.00   0 0  
redo allocation 18,414 0.01 0.00 0 93,489 0.04
redo copy 0     0 93,503 0.04
redo writing 28,664 0.03 0.00 0 0  
resmgr group change latch 839 0.00   0 0  
resmgr:active threads 1,399 0.00   0 0  
resmgr:actses change group 717 0.00   0 0  
resmgr:free threads list 1,397 2.86 0.00 0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 4,271,758 0.05 0.00 0 4,849 0.00
rules engine rule set statistics 100 0.00   0 0  
segmented array pool 26 0.00   0 0  
sequence cache 13,314 0.00   0 0  
session allocation 367,533 0.08 0.01 0 0  
session idle bit 1,799,065 0.00 0.00 0 0  
session state list latch 1,512 1.19 0.00 0 0  
session switching 91 0.00   0 0  
session timer 1,926 0.00   0 0  
shared pool 973,120 0.04 0.04 0 0  
shared pool simulator 907,204 0.00 0.11 0 0  
simulator hash latch 6,480,329 0.00 0.00 0 0  
simulator lru latch 2,279 0.00   0 4,922,006 0.26
slave class 92 0.00   0 0  
slave class create 81 1.23 1.00 0 0  
sort extent pool 272 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 3 0.00   0 0  
threshold alerts latch 516 0.00   0 0  
trace latch 46 0.00   0 0  
transaction allocation 388 0.00   0 0  
transaction branch allocation 1,926 0.00   0 0  
undo global data 36,418 0.01 0.00 0 2 0.00
user lock 1,957 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 141,045,252 218,814 510 218,357 0 0 0
gcs opaque info freelist 4,414,588 9,170 3 9,168 0 0 0
row cache objects 4,271,758 2,232 5 2,227 0 0 0
KCL gc element parent latch 15,767,119 1,568 19 1,552 0 0 0
gcs resource hash 15,517,853 684 2 683 0 0 0
shared pool 973,120 365 16 350 0 0 0
ges resource hash list 273,757 319 7 312 0 0 0
session allocation 367,533 297 2 295 0 0 0
library cache 926,958 261 2 259 0 0 0
enqueue hash chains 206,978 71 8 63 0 0 0
enqueues 166,789 57 3 54 0 0 0
parameter table allocation management 654 50 12 40 0 0 0
dummy allocation 1,402 14 1 13 0 0 0
shared pool simulator 907,204 9 1 8 0 0 0
process allocation 36,797 5 5 0 0 0 0
FOB s.o list latch 1,004 1 1 0 0 0 0
slave class create 81 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
FOB s.o list latch ksfd_allfob 0 1 1
KCL gc element parent latch kclnfndnewm 0 33 5
KCL gc element parent latch kclchkping 0 3 0
KCL gc element parent latch kclevict 0 2 0
KCL gc element parent latch kclrwrite 0 2 0
KCL gc element parent latch kclfwrite1 0 1 0
KCL gc element parent latch kclnfnd 0 1 10
KCL gc element parent latch kclplz 0 1 5
KCL gc element parent latch kclulb 0 1 5
KCL gc element parent latch kclzcl 0 1 11
active service list ksws_event: ksws event 0 6 4
cache buffers chains kcbgtcr: kslbegin excl 0 2,050 2,034
cache buffers chains kcbrls: kslbegin 0 352 435
cache buffers chains kclcls_3 0 51 2
cache buffers chains kcbzwb 0 27 27
cache buffers chains kcbgtcr: fast path 0 24 14
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 22 18
cache buffers chains kcbgcur: kslbegin 0 12 10
cache buffers chains kcbnew: new latch again 0 3 0
cache buffers chains kcbzgb: scan from tail. nowait 0 3 0
cache buffers chains kcbzib: multi-block read: nowait 0 3 0
cache buffers chains kcbchg: kslbegin: call CR func 0 2 7
cache buffers chains kcbgtcr: kslbegin shared 0 1 0
cache buffers chains kclgrantlk_1 0 1 0
cache buffers chains kclobj_1 0 1 0
channel operations parent latch ksrchdelete() 0 1 1
dummy allocation ktcdod 0 1 1
enqueue hash chains ksqgtl3 0 8 8
enqueues ksqgel: create enqueue 0 3 3
gcs opaque info freelist kjbrgrant free opaque info 0 2 1
gcs opaque info freelist kjbrcvt save opaque info 0 1 2
gcs resource hash kjbcropen:affinity 0 2 0
ges resource hash list kjrmas1: lookup master node 0 3 0
ges resource hash list kjakcai: search for resp by resname 0 2 0
ges resource hash list kjcvscn: remove from scan queue 0 2 0
parameter table allocation management ksp_param_table_free 0 12 12
process allocation ksucrp 0 5 0
row cache objects kqreqd: reget 0 3 0
row cache objects kqreqd 0 1 0
session allocation ksursi 0 1 0
session allocation ksuxds: KSUSFCLC not set 0 1 1
shared pool kghalo 0 15 10
shared pool kghfrunp: clatch: nowait 0 3 0
shared pool kghfrunp: alloc: wait 0 1 0
shared pool simulator kglsim_unpin_simhp 0 1 1
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
TD_OA T9WORKFLOW FLOW_RUN_PRCS   TABLE 20,195,888 31.43
POSP TBS_POSP PUBIGTJNL   TABLE 11,459,216 17.84
VAS_PLATFORM TBS_VAS MEMBER_POSFILE_INFO   TABLE 4,535,664 7.06
POSP TBS_POSP HPSTJNL_INT P201207 TABLE PARTITION 3,716,736 5.78
POSP TBS_POSP HPSTJNL_INT P201206 TABLE PARTITION 3,052,096 4.75

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
POSP TBS_POSP ACMTCDDT   TABLE 464,178 61.47
POSP TBS_POSP PUBIGTJNL   TABLE 192,647 25.51
RPTADM TBS_RPT RPT_SETTLETRADE_DETAIL   TABLE 79,584 10.54
PERFSTAT SYSAUX STATS$SQLTEXT_PK   INDEX 2,146 0.28
POSP TBS_POSP_IDX NI1_ACMTCDDT   INDEX 883 0.12

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
POSP TBS_POSP PUBSEQREC   TABLE 78 67.24
VAS_PLATFORM TBS_VAS PK_USER_RELATION   INDEX 15 12.93
POSP TBS_POSP TMSTPOS   TABLE 8 6.90
POSP TBS_POSP_IDX SYS_C004692   INDEX 4 3.45
POSP TBS_POSP PK_HPSTSJNLN   INDEX 3 2.59

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
POSP TBS_POSP_IDX PUBIGTJNL_NI2   INDEX 1 50.00
POSP TBS_POSP_IDX SYS_C004441   INDEX 1 50.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
POSP TBS_POSP PUBSEQREC   TABLE 8 36.36
POSP TBS_POSP_IDX_2 HPSTJNL_PK_INT   INDEX 6 27.27
POSP TBS_POSP PK_HPSTSJNLN   INDEX 5 22.73
TD_OA T9WORKFLOW FLOW_RUN_PRCS   TABLE 2 9.09
POSP TBS_POSP HPSTJNL P201208 TABLE PARTITION 1 4.55

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
RPTADM TBS_RPT RPT_SETTLETRADE_DETAIL   TABLE 10,845 70.64
POSP TBS_POSP PUBSEQREC   TABLE 2,100 13.68
POSP TBS_POSP_IDX_2 HPSTJNL_PK_INT   INDEX 1,069 6.96
POSP TBS_POSP HPSTJNL P201208 TABLE PARTITION 677 4.41
POSP TBS_POSP PK_HPSTSJNLN   INDEX 660 4.30

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 918 22.80
POSP TBS_POSP TMSTPOS   TABLE 523 12.99
POSP TBS_POSP HPSTJNL P201208 TABLE PARTITION 439 10.90
POSP TBS_POSP PUBIGTJNL   TABLE 243 6.04
POSP TBS_POSP HPSTAMTACC   TABLE 241 5.99

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 1,001,856 92.29
RPTADM TBS_RPT RPT_SETTLETRADE_DETAIL   TABLE 34,597 3.19
POSP TBS_POSP ACMTCDDT   TABLE 22,748 2.10
POSP TBS_POSP HPSTJNL_INT P201207 TABLE PARTITION 4,245 0.39
POSP TBS_POSP HPSTJNL_INT P201206 TABLE PARTITION 2,886 0.27

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 64 3.13 0   0 1
dc_database_links 1,080 0.00 0   0 1
dc_files 780 0.00 0   0 26
dc_global_oids 422 7.35 0   0 21
dc_histogram_data 278,328 0.70 0   0 3,116
dc_histogram_defs 212,572 1.44 0   0 3,871
dc_object_grants 36 22.22 0   0 16
dc_object_ids 530,941 0.02 0   0 2,387
dc_objects 37,678 1.21 0   0 683
dc_profiles 527 0.00 0   0 1
dc_rollback_segments 5,862 0.48 0   60 138
dc_segments 268,679 0.36 0   10 2,238
dc_sequences 174 22.99 0   174 22
dc_tablespace_quotas 2 50.00 0   2 1
dc_tablespaces 114,500 0.01 0   0 32
dc_usernames 2,703 0.04 0   0 18
dc_users 142,243 0.00 0   0 51
outstanding_alerts 222 81.53 0   0 1

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 2 2 0
dc_global_oids 31 0 22
dc_histogram_defs 3,064 0 3,187
dc_object_ids 96 0 4
dc_objects 457 0 361
dc_rollback_segments 127 35 0
dc_segments 1,027 4 800
dc_sequences 348 20 12
dc_tablespace_quotas 4 0 0
dc_tablespaces 13 0 13
dc_usernames 1 0 2
dc_users 1 0 1
outstanding_alerts 444 180 1

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 284 1.76 870 0.92 3 0
CLUSTER 44 2.27 80 2.50 1 0
INDEX 179 10.06 334 7.78 8 0
SQL AREA 104,926 34.58 204,491 28.52 1,504 98
TABLE/PROCEDURE 2,854 6.48 120,920 1.32 962 0
TRIGGER 371 0.54 875 0.80 5 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 5 6 5 0
CLUSTER 80 1 1 1 0
INDEX 334 18 18 18 0
TABLE/PROCEDURE 40,666 153 128 84 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 795.72   5.00 5.73 26 34 159 159
  Freeable 99.44 0.00 1.03 0.75 4   97 97
  SQL 3.47 2.24 0.03 0.11 1 266 137 63
  PL/SQL 2.64 1.07 0.02 0.06 1 2 159 159
E Other 1,238.08   4.59 5.34 51 51 270 270
  Freeable 109.00 0.00 0.82 0.68 4   133 133
  SQL 3.34 2.19 0.01 0.08 1 266 247 62
  PL/SQL 2.94 1.17 0.01 0.05 1 2 270 270

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 4,110,417,920 3,892,314,112
Fixed Size 2,093,544  
Redo Buffers 14,680,064  
Variable Size 2,315,259,416 2,533,363,224

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 57.62 77.37 34.26
shared Cursor Stats 43.05 43.05 0.00
shared KGH: NO ACCESS 167.10 167.10 0.00
shared PCursor 62.27 68.90 10.66
shared free memory 1,251.30 1,221.76 -2.36
shared gcs resources 88.73 88.73 0.00
shared gcs shadows 86.47 86.47 0.00
shared kglsim heap 41.01 41.01 0.00
shared kglsim object batch 74.54 74.54 0.00
shared library cache 42.61 46.68 9.55
shared sql area 179.87 383.59 113.26
  buffer_cache 3,920.00 3,712.00 -5.31
  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 399,463 554,762 573995 573995
gcs_shadows 573,995 861,870 573995 573995


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 1   
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 1   
undo_management AUTO   
undo_retention 86400   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/orahome/admin/G1db/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 3,668 0.97 0.15
acks for commit broadcast(logical) 4,186 1.11 0.17
broadcast msgs on commit(actual) 5,768 1.52 0.23
broadcast msgs on commit(logical) 5,772 1.53 0.23
broadcast msgs on commit(wasted) 433 0.11 0.02
broadcast on commit wait time(ms) 93,116,907 24,612.14 3,743.09
broadcast on commit waits 4,011 1.06 0.16
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 2,054,332 542.99 82.58
gcs ast xid 1 0.00 0.00
gcs blocked converts 3,518 0.93 0.14
gcs blocked cr converts 4,128 1.09 0.17
gcs compatible basts 555 0.15 0.02
gcs compatible cr basts (global) 268 0.07 0.01
gcs compatible cr basts (local) 2,201,347 581.85 88.49
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 1,085 0.29 0.04
gcs dbwr write request msgs 552 0.15 0.02
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 1,931 0.51 0.08
gcs immediate (null) converts 90,816 24.00 3.65
gcs immediate cr (compatible) converts 16 0.00 0.00
gcs immediate cr (null) converts 1,224,872 323.75 49.24
gcs indirect ast 13,797 3.65 0.55
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 294 0.08 0.01
gcs msgs process time(ms) 113,979 30.13 4.58
gcs msgs received 7,596,203 2,007.79 305.35
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 21 0.01 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 4 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 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 11,601 3.07 0.47
gcs side channel msgs logical 1,110,871 293.62 44.65
gcs stale cr 616 0.16 0.02
gcs undo cr 63 0.02 0.00
gcs write notification msgs 52 0.01 0.00
gcs writes refused 2 0.00 0.00
ges msgs process time(ms) 791 0.21 0.03
ges msgs received 33,880 8.95 1.36
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 198,674 52.51 7.99
implicit batch messages sent 94,149 24.88 3.78
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 10,662 2.82 0.43
messages queue sent actual 191,507 50.62 7.70
messages queue sent logical 1,426,158 376.95 57.33
messages received actual 1,170,529 309.39 47.05
messages received logical 7,630,165 2,016.76 306.72
messages sent directly 120,882 31.95 4.86
messages sent indirectly 1,383,564 365.70 55.62
messages sent not implicit batched 97,360 25.73 3.91
messages sent pbatched 2,442,321 645.54 98.18
msgs causing lmd to send msgs 7,912 2.09 0.32
msgs causing lms(s) to send msgs 132,217 34.95 5.31
msgs received queue time (ms) 95,704 25.30 3.85
msgs received queued 7,630,190 2,016.77 306.72
msgs sent queue time (ms) 7,629,989 2,016.72 306.71
msgs sent queue time on ksxp (ms) 157,835 41.72 6.34
msgs sent queued 1,412,435 373.33 56.78
msgs sent queued on ksxp 614,136 162.32 24.69
process batch messages received 520,635 137.61 20.93
process batch messages sent 339,537 89.74 13.65


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 6,346
CURRENT Block Requests 490
Data Block Requests 6,346
Undo Block Requests 44
TX Block Requests 288
Current Results 6,285
Private results 260
Zero Results 238
Disk Read Results 5
Fail Results 0
Fairness Down Converts 954
Fairness Clears 0
Free GC Elements 0
Flushes 635
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 104
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 3,117,143 100.00 0.00 0.00 0.00 0.00
Flushes 32 25.00 25.00 25.00 25.00 0.00
Writes 585 52.48 32.65 5.81 4.79 4.27


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 3,636 97.14 2.86 0.00 1,085,372 100.00 0.00 0.00
2 undo header 285 96.14 3.86 0.00 23 86.96 13.04 0.00
2 Others 95 97.89 2.11 0.00 131 98.47 1.53 0.00
2 undo block 21 100.00 0.00 0.00 8 100.00 0.00 0.00


Back to Top

End of Report