WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORCL1321195808orcl1110.2.0.4.0YESczjbdb1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1758315-Sep-14 08:00:37132 22.8
End Snap:1758415-Sep-14 09:18:46206 27.7
Elapsed:  78.15 (mins)  
DB Time:  3,937.37 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 13,856M 13,856MStd Block Size: 16K
Shared Pool Size: 16,720M 16,720MLog Buffer: 14,288K

Load Profile

Per SecondPer Transaction
Redo size: 40,830.19 8,382.24
Logical reads: 54,681.16 11,225.78
Block changes: 225.75 46.35
Physical reads: 201.76 41.42
Physical writes: 13.30 2.73
User calls: 147.79 30.34
Parses: 924.54 189.80
Hard parses: 6.72 1.38
Sorts: 460.52 94.54
Logons: 0.07 0.01
Executes: 2,877.76 590.79
Transactions: 4.87 

% Blocks changed per Read: 0.41Recursive Call %: 95.43
Rollback per transaction %: 27.87Rows per Sort: 7.72

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.63In-memory Sort %: 100.00
Library Hit %: 99.64Soft Parse %: 99.27
Execute to Parse %: 67.87Latch Hit %: 99.87
Parse CPU to Parse Elapsd %: 1.39% Non-Parse CPU: 70.05

Shared Pool Statistics

BeginEnd
Memory Usage %: 86.67 84.59
% SQL with executions>1: 98.20 82.50
% Memory for SQL w/exec>1: 98.83 79.17

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
enq: SQ - contention 18,877 55,186 2,923 23.4Configuration
cursor: pin S wait on X 5,414,192 52,972 10 22.4Concurrency
latch: row cache objects 470,631 48,409 103 20.5Concurrency
row cache lock 13,778 34,722 2,520 14.7Concurrency
latch: library cache 136,207 32,988 242 14.0Concurrency

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 117.57 24.14
Global Cache blocks served: 1,119.80 229.89
GCS/GES messages received: 2,429.62 498.79
GCS/GES messages sent: 461.78 94.80
DBWR Fusion writes: 1.53 0.31
Estd Interconnect traffic (KB) 20,362.56 

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

Buffer access - local cache %: 99.42
Buffer access - remote cache %: 0.22
Buffer access - disk %: 0.37

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.3
Avg global cache cr block receive time (ms): 0.6
Avg global cache current block receive time (ms): 1.6
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.1
Global cache log flushes for cr blocks served %: 0.5
Avg global cache cr block flush time (ms): 1.0
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.1
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 2.0

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.1
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.1
Avg GES message process time (ms): 0.0
% of direct sent messages: 35.46
% of indirect sent messages: 60.48
% of flow controlled messages: 4.06

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
parse time elapsed 137,401.29 58.16
sql execute elapsed time 97,800.89 41.40
sequence load elapsed time 86,099.64 36.45
hard parse elapsed time 84,005.89 35.56
failed parse elapsed time 10,212.20 4.32
DB CPU 6,526.03 2.76
hard parse (sharing criteria) elapsed time 1,543.71 0.65
PL/SQL execution elapsed time 224.28 0.09
PL/SQL compilation elapsed time 123.20 0.05
connection management call elapsed time 10.59 0.00
RMAN cpu time (backup/restore) 0.50 0.00
hard parse (bind mismatch) elapsed time 0.48 0.00
repeated bind elapsed time 0.42 0.00
inbound PL/SQL rpc elapsed time 0.00 0.00
DB time 236,242.44  
background elapsed time 5,833.94  
background cpu time 501.31  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Concurrency 6,133,971 88.46 170,081 28 268.56
Configuration 19,750 95.37 55,187 2794 0.86
Other 212,290 79.76 4,946 23 9.29
User I/O 282,386 0.00 837 3 12.36
Cluster 593,805 0.51 228 0 26.00
System I/O 75,413 0.00 203 3 3.30
Administrative 1,106 0.00 92 83 0.05
Network 680,673 0.00 59 0 29.80
Commit 15,021 0.01 17 1 0.66
Application 2,331 0.00 1 0 0.10

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
enq: SQ - contention 18,877 99.78 55,186 2923 0.83
cursor: pin S wait on X 5,414,192 100.00 52,972 10 237.05
latch: row cache objects 470,631 0.00 48,409 103 20.61
row cache lock 13,778 85.98 34,722 2520 0.60
latch: library cache 136,207 0.00 32,988 242 5.96
reliable message 3,417 87.77 2,941 861 0.15
rdbms ipc reply 1,114 90.31 1,966 1765 0.05
latch: shared pool 43,113 0.11 987 23 1.89
db file sequential read 232,571 0.00 768 3 10.18
kst: async disk IO 9,024 0.00 178 20 0.40
Backup: sbtbackup 4 0.00 76 18923 0.00
gc cr multi block request 397,244 0.00 72 0 17.39
SQL*Net more data from client 2,897 0.00 58 20 0.13
gc current block busy 552 0.00 57 104 0.02
gc current block 2-way 105,489 0.00 55 1 4.62
db file scattered read 45,171 0.00 52 1 1.98
log switch/archive 2 100.00 20 9766 0.00
log file sync 15,021 0.01 17 1 0.66
db file parallel read 4,419 0.00 16 4 0.19
gc cr block 2-way 25,205 0.00 14 1 1.10
gc cr grant 2-way 39,470 0.00 13 0 1.73
log file parallel write 18,666 0.00 11 1 0.82
gc buffer busy 5,868 0.00 10 2 0.26
Backup: sbtclose2 4 0.00 10 2445 0.00
Streams AQ: qmn coordinator waiting for slave to start 2 100.00 10 4884 0.00
db file parallel write 27,910 0.00 7 0 1.22
Backup: sbtwrite2 1,081 0.00 5 5 0.05
gc current grant 2-way 12,438 0.00 4 0 0.54
control file sequential read 17,206 0.00 4 0 0.75
DFS lock handle 8,057 0.00 4 0 0.35
gc current grant busy 4,169 0.00 2 1 0.18
latch: cache buffers chains 1,343 0.00 2 1 0.06
Backup: sbtinfo2 4 0.00 1 367 0.00
log file sequential read 176 0.00 1 7 0.01
kjbdrmcvtq lmon drm quiesce: ping completion 42 7.14 1 27 0.00
CGS wait for IPC msg 155,321 99.89 1 0 6.80
control file parallel write 2,200 0.00 1 0 0.10
ges global resource directory to be frozen 42 95.24 1 20 0.00
library cache lock 1,523 0.00 1 0 0.07
gcs log flush sync 716 9.64 1 1 0.03
enq: WF - contention 18 0.00 1 29 0.00
enq: TM - contention 612 0.00 0 1 0.03
SQL*Net message to client 672,273 0.00 0 0 29.43
gc object scan 3,018 99.97 0 0 0.13
kksfbc child completion 7 100.00 0 50 0.00
os thread startup 8 0.00 0 42 0.00
enq: HW - contention 869 0.00 0 0 0.04
latch: ges resource hash list 18 0.00 0 17 0.00
gc cr block busy 140 0.00 0 2 0.01
Log archive I/O 172 0.00 0 1 0.01
latch free 59 0.00 0 3 0.00
SQL*Net break/reset to client 1,718 0.00 0 0 0.08
latch: object queue header operation 143 0.00 0 1 0.01
direct path read 54 0.00 0 3 0.00
SQL*Net more data to client 5,503 0.00 0 0 0.24
cursor: pin S 29,717 0.00 0 0 1.30
read by other session 113 0.00 0 1 0.00
latch: gcs resource hash 10 0.00 0 11 0.00
RMAN backup & recovery I/O 21 0.00 0 5 0.00
name-service call wait 1 0.00 0 77 0.00
enq: PS - contention 170 0.00 0 0 0.01
ksxr poll remote instances 7,066 63.93 0 0 0.31
library cache pin 9 0.00 0 8 0.00
control file single write 32 0.00 0 2 0.00
PX Deq Credit: send blkd 213 0.00 0 0 0.01
enq: CF - contention 118 0.00 0 0 0.01
wait list latch free 4 0.00 0 11 0.00
gc current multi block request 195 0.00 0 0 0.01
cursor: mutex X 53,093 0.00 0 0 2.32
PX Deq: reap credit 5,400 97.80 0 0 0.24
IPC send completion sync 183 99.45 0 0 0.01
enq: TX - index contention 31 0.00 0 1 0.00
enq: TQ - TM contention 57 0.00 0 0 0.00
gc current block congested 9 0.00 0 3 0.00
log file switch completion 2 0.00 0 12 0.00
enq: FB - contention 38 0.00 0 0 0.00
PX Deq: Signal ACK 133 36.84 0 0 0.01
ges inquiry response 24 0.00 0 1 0.00
latch: library cache pin 2 0.00 0 5 0.00
gc cr grant congested 4 0.00 0 3 0.00
log file single write 6 0.00 0 2 0.00
latch: library cache lock 3 0.00 0 3 0.00
enq: TT - contention 17 0.00 0 0 0.00
buffer busy waits 37 0.00 0 0 0.00
LGWR wait for redo copy 98 0.00 0 0 0.00
Backup: sbtinit 3 0.00 0 2 0.00
enq: TA - contention 11 0.00 0 0 0.00
enq: RS - prevent file delete 6 0.00 0 0 0.00
gc cr block congested 1 0.00 0 2 0.00
enq: TX - row lock contention 1 0.00 0 2 0.00
enq: TD - KTF dump entries 6 0.00 0 0 0.00
enq: DR - contention 3 0.00 0 1 0.00
enq: PI - contention 3 0.00 0 1 0.00
wait for scn ack 6 0.00 0 0 0.00
direct path write 58 0.00 0 0 0.00
enq: WL - contention 2 0.00 0 1 0.00
enq: MW - contention 3 0.00 0 0 0.00
gc current split 2 0.00 0 0 0.00
latch: KCL gc element parent latch 12 0.00 0 0 0.00
gc current block unknown 1 0.00 0 0 0.00
enq: TX - allocate ITL entry 2 0.00 0 0 0.00
enq: MR - contention 1 0.00 0 0 0.00
enq: AF - task serialization 1 0.00 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 7 0.00 0 0 0.00
Backup: sbtend 3 0.00 0 0 0.00
KJC: Wait for msg sends to complete 9 0.00 0 0 0.00
Backup: sbtcommand 4 0.00 0 0 0.00
buffer deadlock 12 91.67 0 0 0.00
PX qref latch 1 100.00 0 0 0.00
Backup: sbtinit2 3 0.00 0 0 0.00
cursor: mutex S 1 0.00 0 0 0.00
SQL*Net message from client 672,208 0.00 339,098 504 29.43
gcs remote message 2,145,028 98.48 35,842 17 93.92
Streams AQ: waiting for messages in the queue 1,407 99.36 9,126 6486 0.06
PX Idle Wait 2,557 95.54 6,121 2394 0.11
Streams AQ: qmn slave idle wait 175 1.14 4,692 26809 0.01
ges remote message 83,165 89.02 4,576 55 3.64
Streams AQ: qmn coordinator idle wait 338 50.00 4,564 13502 0.01
virtual circuit status 156 100.00 4,547 29149 0.01
Streams AQ: waiting for time management or cleanup tasks 122 97.54 4,391 35989 0.01
DIAG idle wait 20,950 0.00 4,174 199 0.92
wait for unread message on broadcast channel 3,800 99.24 3,696 973 0.17
PX Deq: Execution Msg 1,838 75.46 3,039 1654 0.08
jobq slave wait 4 75.00 11 2686 0.00
PX Deq: Execute Reply 89 0.00 0 3 0.00
PX Deq: Join ACK 162 31.48 0 1 0.01
PX Deq: Parse Reply 102 0.00 0 1 0.00
PX Deq: Msg Fragment 220 0.00 0 0 0.01
Streams AQ: RAC qmn coordinator idle wait 338 100.00 0 0 0.01
class slave wait 6 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
row cache lock 747 77.38 1,698 2273 0.03
latch: row cache objects 22,540 0.00 1,640 73 0.99
events in waitclass Other 165,946 97.33 1,535 9 7.27
kst: async disk IO 9,024 0.00 178 20 0.40
log file parallel write 18,666 0.00 11 1 0.82
db file parallel write 27,910 0.00 7 0 1.22
latch: shared pool 218 22.02 6 26 0.01
control file sequential read 12,050 0.00 3 0 0.53
log file sequential read 176 0.00 1 7 0.01
control file parallel write 2,058 0.00 1 0 0.09
enq: TM - contention 608 0.00 0 1 0.03
gc object scan 3,018 99.97 0 0 0.13
enq: HW - contention 864 0.00 0 0 0.04
os thread startup 7 0.00 0 31 0.00
Log archive I/O 172 0.00 0 1 0.01
db file sequential read 42 0.00 0 4 0.00
direct path read 54 0.00 0 3 0.00
library cache lock 192 0.00 0 0 0.01
gc current block 2-way 124 0.00 0 1 0.01
gc cr block 2-way 85 0.00 0 1 0.00
latch: cache buffers chains 16 0.00 0 1 0.00
log file single write 6 0.00 0 2 0.00
gc buffer busy 1 0.00 0 9 0.00
gc current grant 2-way 24 0.00 0 0 0.00
gc current grant busy 13 0.00 0 1 0.00
gc cr block busy 1 0.00 0 3 0.00
gc cr multi block request 5 0.00 0 0 0.00
gc cr grant 2-way 5 0.00 0 0 0.00
direct path write 54 0.00 0 0 0.00
buffer busy waits 1 0.00 0 0 0.00
rdbms ipc message 121,559 63.85 68,969 567 5.32
gcs remote message 2,145,031 98.48 35,842 17 93.92
ges remote message 83,165 89.02 4,576 55 3.64
pmon timer 1,691 99.82 4,574 2705 0.07
Streams AQ: qmn coordinator idle wait 338 50.00 4,564 13502 0.01
Streams AQ: waiting for time management or cleanup tasks 122 97.54 4,391 35989 0.01
DIAG idle wait 20,950 0.00 4,174 199 0.92
smon timer 12 91.67 3,288 273964 0.00
Streams AQ: qmn slave idle wait 22 0.00 587 26696 0.00
PX Deq: Join ACK 30 40.00 0 1 0.00
PX Deq: Parse Reply 18 0.00 0 1 0.00
PX Deq: Execute Reply 16 0.00 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 338 100.00 0 0 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 38,637
AVG_IDLE_TIME 430,040
AVG_IOWAIT_TIME 2,679
AVG_SYS_TIME 6,061
AVG_USER_TIME 32,417
BUSY_TIME 1,241,268
IDLE_TIME 13,766,124
IOWAIT_TIME 89,775
SYS_TIME 198,963
USER_TIME 1,042,305
LOAD 0
OS_CPU_WAIT_TIME 1,416,600
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 66,706,210,816
NUM_CPUS 32
NUM_CPU_CORES 16

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
orcl 186,293.10 5,735.00 935,101 217,312,107
SYS$USERS 49,941.40 787.00 10,606 38,807,800
SYS$BACKGROUND 0.00 0.00 107 67,948
orclXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
orcl 275163 81949 2949188 12473435 0 0 625600 3115
SYS$USERS 7034 1686 3160956 4200136 1106 9209 54284 2756
SYS$BACKGROUND 180 41 23798 334376 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
78,092 317 13,553 5.76 33.06 g8xnyqtspkytq   BEGIN PKG_K_SIINTERFACE.PRC_K_...
50,956 1 13,552 3.76 21.57 4mqz0c67a1yh4   SELECT TRIM(TO_CHAR(SYSDATE, ...
26,107 1 1,144 22.82 11.05 1594gjs64t9mq   SELECT TO_CHAR(SYSDATE, 'YYYY...
23,458 53 25 938.31 9.93 7f5kc7uasbd71   Select nvl(bac450, 1) from sb0...
7,050 31 5 1409.94 2.98 3mggs6x0c2j46   select count(1) from az01b whe...
7,043 7 6 1173.90 2.98 81ky0n97v4zsg emagent@czjbdb1 (TNS V1-V3) /* OracleOEM */ select s.sid, ...
5,862 0 383 15.30 2.48 98m85gxpsy0ma JDBC Thin Client select SEQ_SYS.nextval from du...
4,668 34 3 1555.84 1.98 gg94xm5r0u849 JDBC Thin Client select count(1) as rowcount FR...
3,866 30 3 1288.69 1.64 0964j692azjbt   select count(1) as rowcount FR...
3,175 32 2 1587.74 1.34 f6zt27zrxfct7 JDBC Thin Client select count(1) as rowcount FR...
3,148 30 2 1573.90 1.33 6dwy28vj4q4ub JDBC Thin Client select count(1) as rowcount FR...
2,799 28 2 1399.39 1.18 dwt5z8gvd6brd   SELECT Pkg_a_Comm.Fun_a_Getage...
2,742 27 2 1370.76 1.16 0vjkh1ts6njxd   SELECT Pkg_a_Comm.Fun_a_Getage...

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
1,431 2,254 755 1.90 0.95 1fbb7ms9cnyvk JDBC Thin Client select OD11.OAE300 as opSeqNum...
874 1,378 504 1.73 0.58 2vkwyp6k8xp5x JDBC Thin Client Select count(1) as TOTALCOUNT...
548 629 4,096,260 0.00 0.27 1cqnd1639a6qq JDBC Thin Client begin :con := DBMS_CONTEXT.FUN...
370 571 251 1.48 0.24 d4u9rxn27xhg2   Select count(1) as TOTALCOUNTS...
317 78,092 13,553 0.02 33.06 g8xnyqtspkytq   BEGIN PKG_K_SIINTERFACE.PRC_K_...
274 425 2 136.97 0.18 frwp0hdnvprjw   BEGIN PKG_ÈËÔ±±ä¸ü.PRC_ÅúÁ¿µ¼Èë(:1, :2...
232 352 786 0.30 0.15 3dc10hfsmfmtb   SELECT NVL(AAC001, '0') FROM ...
212 213 4,096,987 0.00 0.09 9hc736jw3944q JDBC Thin Client SELECT * FROM OA20 WHERE UPPER...
168 260 124 1.35 0.11 8d1ug9186ydw0 JDBC Thin Client select OD11.OAE300 as opSeqNum...
86 133 74 1.16 0.06 9hsugkmssr2uj JDBC Thin Client Select count(1) as TOTALCOUNT...
53 23,458 25 2.13 9.93 7f5kc7uasbd71   Select nvl(bac450, 1) from sb0...
34 4,668 3 11.30 1.98 gg94xm5r0u849 JDBC Thin Client select count(1) as rowcount FR...
32 3,175 2 16.10 1.34 f6zt27zrxfct7 JDBC Thin Client select count(1) as rowcount FR...
31 7,050 5 6.24 2.98 3mggs6x0c2j46   select count(1) from az01b whe...
30 3,148 2 15.21 1.33 6dwy28vj4q4ub JDBC Thin Client select count(1) as rowcount FR...
30 3,866 3 9.91 1.64 0964j692azjbt   select count(1) as rowcount FR...
28 2,799 2 13.93 1.18 dwt5z8gvd6brd   SELECT Pkg_a_Comm.Fun_a_Getage...
27 2,742 2 13.53 1.16 0vjkh1ts6njxd   SELECT Pkg_a_Comm.Fun_a_Getage...
7 7,043 6 1.12 2.98 81ky0n97v4zsg emagent@czjbdb1 (TNS V1-V3) /* OracleOEM */ select s.sid, ...
1 26,107 1,144 0.00 11.05 1594gjs64t9mq   SELECT TO_CHAR(SYSDATE, 'YYYY...
1 50,956 13,552 0.00 21.57 4mqz0c67a1yh4   SELECT TRIM(TO_CHAR(SYSDATE, ...
0 5,862 383 0.00 2.48 98m85gxpsy0ma JDBC Thin Client select SEQ_SYS.nextval from du...

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
39,990,344 755 52,967.34 15.60 1430.80 2253.83 1fbb7ms9cnyvk JDBC Thin Client select OD11.OAE300 as opSeqNum...
28,862,120 2 14,431,060.00 11.26 273.94 425.15 frwp0hdnvprjw   BEGIN PKG_ÈËÔ±±ä¸ü.PRC_ÅúÁ¿µ¼Èë(:1, :2...
28,440,797 786 36,184.22 11.09 231.92 351.93 3dc10hfsmfmtb   SELECT NVL(AAC001, '0') FROM ...
22,904,471 504 45,445.38 8.93 874.07 1378.30 2vkwyp6k8xp5x JDBC Thin Client Select count(1) as TOTALCOUNT...
18,334,297 13,553 1,352.79 7.15 316.59 78092.21 g8xnyqtspkytq   BEGIN PKG_K_SIINTERFACE.PRC_K_...
16,953,672 251 67,544.51 6.61 370.36 571.04 d4u9rxn27xhg2   Select count(1) as TOTALCOUNTS...
14,836,411 4,096,987 3.62 5.79 211.81 213.35 9hc736jw3944q JDBC Thin Client SELECT * FROM OA20 WHERE UPPER...
14,832,227 4,096,260 3.62 5.78 548.01 629.45 1cqnd1639a6qq JDBC Thin Client begin :con := DBMS_CONTEXT.FUN...
9,604,930 126 76,229.60 3.75 70.28 121.26 5bm56td3r1p5t   BEGIN PKG_A_²¹ÍË´¦Àí.PRC_A_ÍËÊÕ´¦Àí_MA...
8,476,814 124 68,361.40 3.31 168.00 259.72 8d1ug9186ydw0 JDBC Thin Client select OD11.OAE300 as opSeqNum...
5,058,743 74 68,361.39 1.97 85.54 132.80 9hsugkmssr2uj JDBC Thin Client Select count(1) as TOTALCOUNT...
3,418,075 50 68,361.50 1.33 58.33 91.50 5gdd5vx2fru8w   Select count(1) as TOTALCOUNTS...

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
76,207 126 604.82 8.06 70.28 121.26 5bm56td3r1p5t   BEGIN PKG_A_²¹ÍË´¦Àí.PRC_A_ÍËÊÕ´¦Àí_MA...
64,121 13,553 4.73 6.78 316.59 78092.21 g8xnyqtspkytq   BEGIN PKG_K_SIINTERFACE.PRC_K_...
5,539 755 7.34 0.59 1430.80 2253.83 1fbb7ms9cnyvk JDBC Thin Client select OD11.OAE300 as opSeqNum...
1,333 1,767 0.75 0.14 7.12 14.03 0agmch182tjp7   INSERT INTO KC24 (AKB020, AKC...
780 5,689 0.14 0.08 69.03 79.84 4cpkp2819vcmn   SELECT AAC001, AAB001, AAC00...
732 239 3.06 0.08 50.21 1733.75 8dt9ys0pvgmu9   BEGIN PKG_ÈËÔ±±ä¸ü.PRC_Ðø±£(:1, :2, ...
584 29 20.14 0.06 48.82 80.60 7r6pt27vj98g3   select V_AC01.OAE001 as V_AC01...
338 2 169.00 0.04 273.94 425.15 frwp0hdnvprjw   BEGIN PKG_ÈËÔ±±ä¸ü.PRC_ÅúÁ¿µ¼Èë(:1, :2...
319 1,940 0.16 0.03 2.26 2.71 37m0zfmqrkmyf   SELECT NVL(AKC087, 0) FROM KC0...
176 3,312 0.05 0.02 1.47 1.81 2muvjhf3frgc7   SELECT SUM(DECODE(AAE140, '31...

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
4,096,987 2,851,691 0.70 0.00 0.00 9hc736jw3944q JDBC Thin Client SELECT * FROM OA20 WHERE UPPER...
4,096,260 4,093,905 1.00 0.00 0.00 1cqnd1639a6qq JDBC Thin Client begin :con := DBMS_CONTEXT.FUN...
17,789 17,789 1.00 0.00 0.00 78pc9uq6xy52c   SELECT NVL(AAA005, '0') FROM ...
15,072 15,072 1.00 0.00 0.00 bhwvmcwaj7vcn JDBC Thin Client SELECT AAA005 FROM AA01 WHERE ...
13,553 13,552 1.00 0.00 0.00 3d2ckc6bf9j7z JDBC Thin Client SELECT AKB022 FROM KB01 WHERE ...
13,553 13,553 1.00 0.02 5.76 g8xnyqtspkytq   BEGIN PKG_K_SIINTERFACE.PRC_K_...
13,552 13,552 1.00 0.00 3.76 4mqz0c67a1yh4   SELECT TRIM(TO_CHAR(SYSDATE, ...
12,604 12,592 1.00 0.00 0.00 brqqzz2cx2ad0   SELECT AKC385 FROM KC33 WHERE ...
12,592 12,592 1.00 0.00 0.00 2j90640w599t8   SELECT SYSDATE - MIN(AKC348) F...
12,592 12,592 1.00 0.00 0.00 8dcvna2y5nshw   SELECT NVL(AAA005, '0') FROM ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
4,095,607 4,096,260 94.48 1cqnd1639a6qq JDBC Thin Client begin :con := DBMS_CONTEXT.FUN...
7,746 17,789 0.18 78pc9uq6xy52c   SELECT NVL(AAA005, '0') FROM ...
4,501 8,774 0.10 40gzt5gt09ryz   SELECT NVL(AAB324, '0') FROM ...
3,736 3,735 0.09 grwydz59pu6mc   select text from view$ where r...
2,921 4,261 0.07 2qxyp64559m61   SELECT NVL(AAA005, '0') FROM ...
2,812 5,689 0.06 4cpkp2819vcmn   SELECT AAC001, AAB001, AAC00...
2,704 3,154 0.06 ghgxmq1br4hc0   SELECT AAE140, AKC160, AAE12...
2,273 2,365 0.05 8w3nm1pmu1d7k JDBC Thin Client SELECT AKB023 FROM KB01 WHERE ...
2,119 2,119 0.05 47r1y8yn34jmj   select default$ from col$ wher...
1,934 1,940 0.04 37m0zfmqrkmyf   SELECT NVL(AKC087, 0) FROM KC0...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
6,987,701 1,149 0.04 cs428643kphvv   SELECT AAC001, AAB001, AAC00...
4,947,871 21 0.03 2v8ychtv49x3s JDBC Thin Client SELECT AC01.AAC001, AC01.AAB0...
2,379,335 5 0.01 8f1sjvfxuup9w PL/SQL Developer select t.*, o.*, m.comments ...
2,287,637 4 0.01 fh3nahb250bj8   select KC21.AKB020 as KC21_AKB...
2,185,505 4 0.01 aghwt3kvh48ua   Select count(1) as TOTALCOUNTS...
2,018,534 189 0.01 ast4awk7xb7ay   select V_AC01.OAE001 as V_AC01...
1,841,014 5 0.01 30sxgjt5s6s27 JDBC Thin Client insert into AC01(OAE001, AAC00...
1,822,742 1 0.01 bd502nbh9abbs plsqldev.exe select s.synonym_name object_n...
1,786,535 263 0.01 2mvn9yfdpx95r JDBC Thin Client SELECT AC01.*, AC02.AAE140 FR...
1,714,278 77 0.01 2wjg030ma6wn6 JDBC Thin Client select AC01.OAE001 as AC01_OAE...
1,706,601 7 0.01 1pd9c8a75v014   select V_AC01.OAE001 as V_AC01...
1,655,833 1 0.01 31a13pnjps7j3   SELECT source, (case w...
1,443,266 4 0.01 g4gwx26fvxuy9 JDBC Thin Client select V_AC01.OAE001 as V_AC01...
1,402,452 1 0.01 d0b3sfq0ws3k6   select V_AC01.OAE001 as V_AC01...
1,397,154 271 0.01 4fazmsttfa0g7 JDBC Thin Client SELECT AAC001, AAC004, AAC00...
1,355,367 1 0.01 fqmpmkfr6pqyk PlSqlDev.exe select s.synonym_name object_n...
1,261,494 4 0.01 3xnpf0z4x81h7   select ic10.aac001, ac01.aac0...
1,237,319 1 0.01 8u0gn9x5h5m0d   SELECT "AC01"."AAC001", ...
1,215,522 3 0.01 3yupxjjwqm99m   select QUERY_CBQKB.AAB001 as Q...
1,215,522 3 0.01 3yupxjjwqm99m   select QUERY_CBQKB.AAB001 as Q...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
40 1 19rkm1wsf9axx   insert into WRI$_ALERT_HISTORY...
33 4 3qsmy8ybvwt3n   insert into WRI$_ALERT_OUTSTAN...
25 1,075 dbu92p57gtcrs   select AA01.AAE130 as AA01_AAE...
24 1 298ppdduqr7wm   SELECT status FROM sys.wri$_ad...
23 1 14566d856s6hs   SELECT owner# FROM sys.wri$_ad...
23 1 31a13pnjps7j3   SELECT source, (case w...
22 2 10xj8nynmpqtq   SELECT dbin.db_name, dbin.ins...
22 1 gdn3ysuyssf82   SELECT advisor_id FROM sys.wri...

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
116.69 0.15 78,092.21 316.59 13,553 g8xnyqtspkytq   BEGIN PKG_K_SIINTERFACE.PRC_K_...
2.87 0.13 2,253.83 1,430.80 755 1fbb7ms9cnyvk JDBC Thin Client select OD11.OAE300 as opSeqNum...
2.24 15.93 14.03 7.12 1,767 0agmch182tjp7   INSERT INTO KC24 (AKB020, AKC...
1.52 1.91 79.84 69.03 5,689 4cpkp2819vcmn   SELECT AAC001, AAB001, AAC00...
1.13 49.43 2.29 1.58 1,772 4kgcpukdub57v   SELECT * FROM KC22 WHERE AKB02...
1.12 74.79 1.50 0.86 1,772 0aggvaxz16vxs   SELECT SUM(NVL(AKC235, 0)) FR...
0.95 2.85 33.24 29.69 12,592 2j90640w599t8   SELECT SYSDATE - MIN(AKC348) F...
0.67 31.62 2.13 1.67 1,767 8f74xp2z5m3cj   INSERT INTO KC29 (AKB020, AKC...
0.51 0.03 1,733.75 50.21 239 8dt9ys0pvgmu9   BEGIN PKG_ÈËÔ±±ä¸ü.PRC_Ðø±£(:1, :2, ...
0.40 0.00 26,107.27 1.36 1,144 1594gjs64t9mq   SELECT TO_CHAR(SYSDATE, 'YYYY...
0.38 14.02 2.71 2.26 1,940 37m0zfmqrkmyf   SELECT NVL(AKC087, 0) FROM KC0...
0.35 19.49 1.81 1.47 3,312 2muvjhf3frgc7   SELECT SUM(DECODE(AAE140, '31...
0.32 0.40 80.60 48.82 29 7r6pt27vj98g3   select V_AC01.OAE001 as V_AC01...
0.30 8.06 3.78 3.54 12,604 brqqzz2cx2ad0   SELECT AKC385 FROM KC33 WHERE ...
0.30 31.89 0.94 0.89 1,772 a4cwn4fdp57b3   UPDATE KC21 SET AKC317 = :B14 ...
0.27 0.06 425.15 273.94 2 frwp0hdnvprjw   BEGIN PKG_ÈËÔ±±ä¸ü.PRC_ÅúÁ¿µ¼Èë(:1, :2...
0.24 0.20 121.26 70.28 126 5bm56td3r1p5t   BEGIN PKG_A_²¹ÍË´¦Àí.PRC_A_ÍËÊÕ´¦Àí_MA...
0.23 53.70 0.43 0.41 1,786 50zrt2xad5jkn   SELECT AKC192, AAC001, AKC021,...
0.19 0.01 1,378.30 874.07 504 2vkwyp6k8xp5x JDBC Thin Client Select count(1) as TOTALCOUNT...
0.17 0.03 571.04 370.36 251 d4u9rxn27xhg2   Select count(1) as TOTALCOUNTS...
0.17 31.14 0.55 0.55 1,790 bgm8m7bscb5d3 JDBC Thin Client SELECT DISTINCT AAC001, AKA13...
0.17 8.74 1.93 1.93 1,772 9717x59gm5mxz   SELECT COUNT(1) FROM KC24 WHER...
0.12 0.17 73.44 47.57 28 fafbqq5281vy0 JDBC Thin Client Select count(1) as TOTALCOUNT...
0.12 0.03 351.93 231.92 786 3dc10hfsmfmtb   SELECT NVL(AAC001, '0') FROM ...
0.09 0.04 259.72 168.00 124 8d1ug9186ydw0 JDBC Thin Client select OD11.OAE300 as opSeqNum...
0.07 0.22 33.48 17.64 1,149 cs428643kphvv   SELECT AAC001, AAB001, AAC00...
0.07 27.48 0.25 0.25 1,776 07fjqzyq6z2qp   SELECT * FROM KC21 WHERE KC21....
0.06 0.05 132.80 85.54 74 9hsugkmssr2uj JDBC Thin Client Select count(1) as TOTALCOUNT...
0.03 0.00 1,618.87 0.03 25 d2hxrvrwz4vvg JDBC Thin Client select SEQ_A_AAE079.nextval fr...
0.03 0.03 91.50 58.33 50 5gdd5vx2fru8w   Select count(1) as TOTALCOUNTS...
0.03 15.03 0.19 0.19 3,154 ghgxmq1br4hc0   SELECT AAE140, AKC160, AAE12...
0.02 0.51 4.03 3.74 263 2mvn9yfdpx95r JDBC Thin Client SELECT AC01.*, AC02.AAE140 FR...
0.02 0.09 18.09 11.81 7 1pd9c8a75v014   select V_AC01.OAE001 as V_AC01...
0.02 0.03 54.66 52.79 8,774 40gzt5gt09ryz   SELECT NVL(AAB324, '0') FROM ...
0.01 0.62 2.09 1.94 189 ast4awk7xb7ay   select V_AC01.OAE001 as V_AC01...
0.01 12.57 0.10 0.06 5 30sxgjt5s6s27 JDBC Thin Client insert into AC01(OAE001, AAC00...
0.01 0.20 5.79 3.64 4 g4gwx26fvxuy9 JDBC Thin Client select V_AC01.OAE001 as V_AC01...
0.01 0.00 50,956.19 0.98 13,552 4mqz0c67a1yh4   SELECT TRIM(TO_CHAR(SYSDATE, ...
0.01 0.59 1.61 1.00 3 3yupxjjwqm99m   select QUERY_CBQKB.AAB001 as Q...
0.01 2.94 0.30 0.25 3,735 grwydz59pu6mc   select text from view$ where r...
0.01 0.00 1,654.77 34.18 1 fx7nuhacnspfh   insert into KC24h value select...
0.01 0.00 1,640.14 31.83 1 dhj0f5nb3ykns JDBC Thin Client INSERT INTO AC01H(OAE001, AAC0...
0.01 0.00 7,043.42 6.74 6 81ky0n97v4zsg emagent@czjbdb1 (TNS V1-V3) /* OracleOEM */ select s.sid, ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
07fjqzyq6z2qpSELECT * FROM KC21 WHERE KC21.AKB020 = :B4 AND KC21.AKC190 = :B3 AND KC21.AKA135 = :B2 AND KC21.AAE100 = :B1
0964j692azjbtselect count(1) as rowcount FROM AC02_JMV, AC01 WHERE AC02_JMV.AAC001=AC01.AAC001 AND (1 = 1) AND ((AC01.AAC002 in ('342321195312153411', '342321531215341')) )
0aggvaxz16vxsSELECT SUM(NVL(AKC235, 0)) FROM KC22 WHERE AKB020 = :B2 AND AKC190 = :B1 AND AKA065<>'3' AND AAE072 = 'AAAA' AND AKA135 = '1' AND AAE100 = '1'
0agmch182tjp7 INSERT INTO KC24 (AKB020, AKC190, AAE072, AKA135, AAE100, AAC001, AKA130, AKC021, BKC021, AAB001, AAE040, AKC251, BKC251, BKC252, BKC253, BKC256, BKC255, AKC252, AKC268, AKC269, AKC278, AKC264, AKC263, AKC255, AKC261, AKC260, AKC283, AKC285, AKC286, AKC287, AKC288, AKC253, AKC280, AKC281, AKC282, BKC258, AKC334, AKC256, AKC289, AKC290, AKC257, AKC291, AKC292, AKC258, AKC302, AKC303, BKC257, AKC304, AKC305, AKC090, AKC197, AKC339, AKC344, AKC299, AKC306, AKC347, AKC384, AKC378, AKC379, AKC380, AKC381, AKC382, AKC383, AAE011, AAE036, AKC319, AKC800, AKC801, OAE001, OAE300, OAE301, BAA084, AKC336, AKC266, AKC267, AKC351, AKC421, AKC422, AKC423, AAE074, AAE117, AAE145, AAE002, AKC427, AKC428, AKC429, AKC433, AKC434, AKC202, AKC435, AKC436, AKC437, AKC438, AKC367, AKC357, AKC774, AKC775, AKC780, AKC781, AKC782, AKC783, AKC787, AKC790, AKC791, AKC439, AKC440, AAB324, AKC328, AKC338, AKA810, CAB324, AKC820, AKC535, AKC536, AKC538, AKC540, AKC542 ) VALUES (:B109 , :B108 , :B107 , 1, 1, :B106 , :B105 , :B104 , :B103 , :B102 , :B101 , :B100 , :B99 , :B98 , :B97 , :B96 , :B95 , :B94 , :B93 , :B92 , :B91 , :B90 , :B89 , :B88 , :B87 , (:B86 + NVL(:B6 , 0)), :B85 , :B84 , :B83 , :B82 , :B81 , :B80 , :B79 , :B78 , :B77 , :B76 , :B75 , :B74 , :B73 , :B72 , :B71 , :B70 , :B69 , :B68 , :B67 , :B66 , :B65 , :B64 , :B63 , :B62 , :B6 1 , :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , :B54 , :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , SYSDATE, NULL, :B47 , :B46 , SEQ_A_ROWID.NEXTVAL, :B45 , NULL, :B44 , :B43 , SYSDATE, 0, :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , NVL(:B20 , 0), NVL(:B19 , 0), NVL(:B18 , 0), NVL(:B17 , 0), :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
0vjkh1ts6njxdSELECT Pkg_a_Comm.Fun_a_Getage(to_char(to_date('2002-10-08', 'yyyy-mm-dd'), 'yyyymmdd'), to_char(sysdate, 'yyyymmdd'), '1') age FROM dual
10xj8nynmpqtq SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t ime = s1.startup_time
14566d856s6hsSELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1
1594gjs64t9mqSELECT TO_CHAR(SYSDATE, 'YYYYMMDD') || TO_CHAR(LPAD(SEQ_K_ÒµÎñÖ§¸¶Á÷Ë®ºÅ.NEXTVAL, 10, 0)) FROM DUAL
19rkm1wsf9axxinsert into WRI$_ALERT_HISTORY (sequence_id, reason_id, owner, object_name, subobject_name, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, resolution, metric_value) 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)
1cqnd1639a6qqbegin :con := DBMS_CONTEXT.FUN_GETPOLICY(:sn, :on); end;
1fbb7ms9cnyvkselect OD11.OAE300 as opSeqNum, OD11.OAG001 as businessId, OD11.AAE011 as operator, OD11.AAE036 as opDate, OD11.OAC004 as operatorName, OD11.OAG010 as maxCheckGrade, OD11.OAG011 as curCheckGrade, OD11.OAG012 as operateStatus, OD11.OAE302 as nextOpSeqNum, OD11.AAE013 as OD11_AAE013, OD11.OAG013 as OD11_OAG013, OD11.OAG014 as OD11_OAG014, OD11.OAG099 as OD11_OAG099, OD11.OAG015 as OD11_OAG015, OD11.OAG016 as OD11_OAG016 from OD11 where OD11.OAG014=:1 and (OD11.OAG012=:2 or OD11.OAG012=:3)
1pd9c8a75v014 select V_AC01.OAE001 as V_AC01_OAE001, V_AC01.AAC001 as V_AC01_AAC001, V_AC01.AAB001 as V_AC01_AAB001, V_AC01.AAC002 as V_AC01_AAC002, V_AC01.AAC003 as V_AC01_AAC003, V_AC01.AAC022 as V_AC01_AAC022, V_AC01.AAC004 as V_AC01_AAC004, V_AC01.AAC005 as V_AC01_AAC005, V_AC01.AAC006 as V_AC01_AAC006, V_AC01.AAC007 as V_AC01_AAC007, V_AC01.AAC008 as V_AC01_AAC008, V_AC01.AAC009 as V_AC01_AAC009, V_AC01.AAC010 as V_AC01_AAC010, V_AC01.AAC011 as V_AC01_AAC011, V_AC01.AAC012 as V_AC01_AAC012, V_AC01.AAC013 as V_AC01_AAC013, V_AC01.AAC014 as V_AC01_AAC014, V_AC01.AAC015 as V_AC01_AAC015, V_AC01.AAC016 as V_AC01_AAC016, V_AC01.AAC017 as V_AC01_AAC017, V_AC01.AAC019 as V_AC01_AAC019, V_AC01.AAC020 as V_AC01_AAC020, V_AC01.AAC021 as V_AC01_AAC021, V_AC01.AAC024 as V_AC01_AAC024, V_AC01.AAC031 as V_AC01_AAC031, V_AC01.AAE004 as V_AC01_AAE004, V_AC01.AAE005 as V_AC01_AAE005, V_AC01.AAE006 as V_AC01_AAE006, V_AC01.AAE007 as V_AC01_AAE007, V_AC01.AAE008 as V_AC01_AAE008, V_AC01.AAE010 as V_AC01_AAE010, V_AC01.AAE015 as V_AC01_AAE015, V_AC01.AAB301 as V_AC01_AAB301, V_AC01.AIC001 as V_AC01_AIC001, V_AC01.AJC001 as V_AC01_AJC001, V_AC01.AKC002 as V_AC01_AKC002, V_AC01.AKC020 as V_AC01_AKC020, V_AC01.AKC021 as V_AC01_AKC021, V_AC01.AKC026 as V_AC01_AKC026, V_AC01.AKC030 as V_AC01_AKC030, V_AC01.AIC162 as V_AC01_AIC162, V_AC01.BAC002 as V_AC01_BAC002, V_AC01.BAC016 as V_AC01_BAC016, V_AC01.BAC022 as V_AC01_BAC022, V_AC01.BAC023 as V_AC01_BAC023, V_AC01.BAC024 as V_AC01_BAC024, V_AC01.BAC025 as V_AC 01_BAC025, V_AC01.BAC111 as V_AC01_BAC111, V_AC01.BAC118 as V_AC01_BAC118, V_AC01.BAC119 as V_AC01_BAC119, V_AC01.BAE001 as V_AC01_BAE001, V_AC01.AAE011 as V_AC01_AAE011, V_AC01.AAE036 as V_AC01_AAE036, V_AC01.AAE013 as V_AC01_AAE013, V_AC01.OAE300 as V_AC01_OAE300, V_AC01.OAE301 as V_AC01_OAE301, V_AC01.BAC026 as V_AC01_BAC026, V_AC01.BAC027 as V_AC01_BAC027, V_AC01.BAC028 as V_AC01_BAC028, V_AC01.BAC029 as V_AC01_BAC029, V_AC01.BAC030 as V_AC01_BAC030, V_AC01.BAC031 as V_AC01_BAC031, V_AC01.BAC032 as V_AC01_BAC032, V_AC01.BAC033 as V_AC01_BAC033, V_AC01.BAC034 as V_AC01_BAC034, V_AC01.BAC035 as V_AC01_BAC035, V_AC01.BAC036 as V_AC01_BAC036, V_AC01.BAC037 as V_AC01_BAC037, V_AC01.BAC038 as V_AC01_BAC038, V_AC01.BAC039 as V_AC01_BAC039, V_AC01.BAC040 as V_AC01_BAC040, V_AC01.BAC041 as V_AC01_BAC041, V_AC01.BAC042 as V_AC01_BAC042, V_AC01.BAC043 as V_AC01_BAC043, V_AC01.BAC044 as V_AC01_BAC044, V_AC01.BAC045 as V_AC01_BAC045, V_AC01.BAC046 as V_AC01_BAC046, V_AC01.BAC047 as V_AC01_BAC047, V_AC01.BAC048 as V_AC01_BAC048, V_AC01.BAC049 as V_AC01_BAC049, V_AC01.BAC050 as V_AC01_BAC050, V_AC01.BAC051 as V_AC01_BAC051, V_AC01.BAC052 as V_AC01_BAC052, V_AC01.BAC053 as V_AC01_BAC053, V_AC01.BAC054 as V_AC01_BAC054, V_AC02.AAB001 as V_AC02_AAB001, V_AC02.AAC001 as V_AC02_AAC001, V_AC02.AAE140 as V_AC02_AAE140, V_AC02.AAE041 as V_AC02_AAE041, V_AC02.AAE042 as V_AC02_AAE042, V_AC02.AAC031 as V_AC02_AAC031, V_AC02.AAE011 as AAE011, V_AC02.AAE036 as AAE036, V_AC01.BAC073 as V_AC01_BAC073, V_AC01.BAC074 as V_AC01_BAC074, V_AC01.AAB004 as V_AC01_AAB004, '' as V_AC56_AGE000 from V_AC01, V_AC02 where ( V_AC01.AAC001=V_AC02.AAC001 ) and ((V_AC01.AAC003 like :1) and ( v_ac01.aac001 = v_ac02.aac001 and akc021 in ('34', '35', '36', '37') and aac012 in ('91', '92', '93', '94', '95', '96', '97') and V_AC02.aae140='39' ))
298ppdduqr7wmSELECT status FROM sys.wri$_adv_tasks WHERE id = :1
2j90640w599t8SELECT SYSDATE - MIN(AKC348) FROM KC33 WHERE AKB020 = :B2 AND AKC347 = :B1 AND NVL(AKC385, 0) = 1
2muvjhf3frgc7SELECT SUM(DECODE(AAE140, '31', '31', '35', '35', '36', '36', '38', '38', '39', '39')) || SUM(DECODE(AAE140, '33', '33', '34', '34')) || SUM(DECODE(AAE140, '32', '32')) BAA084 FROM AC02 WHERE AAC001 = :B2 AND SUBSTR(AAE140, 1, 1) = '3' AND AAC031 <> '3' AND AAE041 <= TO_CHAR(:B1 , 'yyyymm') AND (AAE042 IS NULL OR AAE042 >= TO_CHAR(:B1 , 'yyyymm'))
2mvn9yfdpx95rSELECT AC01.*, AC02.AAE140 FROM AC01, AC02 WHERE AC01.AAC001 = AC02.AAC001 AND AC01.AAC001 = :B3 AND AC02.AAE041 <= :B2 AND (AC02.AAE042 >= :B2 OR AC02.AAE042 IS NULL) AND AC02.AAC031 IN (:B1 ) ORDER BY AC02.AAC001
2qxyp64559m61SELECT NVL(AAA005, '0') FROM AA01 WHERE AAE130 = '3' AND AAA003 = 'MASXJ' AND TRUNC(AAE030, 'DD') <= TRUNC(SYSDATE, 'DD') AND (TRUNC(AAE031, 'DD') >= TRUNC(SYSDATE, 'DD') OR AAE031 IS NULL)
2v8ychtv49x3s SELECT AC01.AAC001, AC01.AAB001, AC01.AAC002, AC01.AAC003, AC01.AAC004, AC01.AAC005, AC01.AAC006, AC01.AAC020, AC01.AAE036, AC01.AKC020, AC01.AKC021, AC01.AKC030, AC01.AAC008, AC01.AAC031, AC01.BAC022, AC01.BAC016, AC01.BAC111, AB01.AAB004, AB01.AAB301, AB01.AAB019, AB01.AAB020, '', 0 AKC306, KC04.AAE001, KC04.AKC080, KC04.AKC081, KC04.AKC082, KC04.AKC097, KC04.AKC098, KC04.AKC083, KC04.AKC084, KC04.AKC099, KC04.AKC096, KC04.AKC085, KC04.AKC087, KC04.AKC317, KC04.AKC093, KC04.AKC134, KC04.AKC086, KC04.AKC088, KC04.AKC123, KC04.AKC121, KC04.AKC089, KC04.AKC100, KC04.AKC122, 0 AKC114, KC04.AKC132, KC04.AKC133, KC04.AKC137, KC04.AKC090, KC04.AKC117, KC04.AKC139, KC04.AKC341, KC04.AKC112, KC04.AKC101, KC04.AKC120, KC04.AKC135, KC04.AKC136, KC04.AKC156, KC04.AKC142, KC04.AKC143, KC04.AKC144, KC04.AKC145, KC04.AKC146, KC04.AKC147, KC04.AKC148, KC04.AKC149, KC04.AKC150, KC04.AKC151, KC04.AKC152, KC04.AKC153, KC04.AKC154, KC04.AKC155, AKC157, AKC158, AKC159, 0, '', '', '', '', '', '', NULL, '', '', 0, 0, '', 0, 0, '', 0, 0, KC04.AKC138, AC01.BAC028, AC01.AAB324, KC04.AKC505, KC04.AKC506, KC04.AKC561, KC04.AKC563, KC04.AKC566 FROM AC01, KC04, AB01 WHERE AC01.AAC001 = KC04.AAC001 AND AC01.AAB001 = AB01.AAB001 AND KC04.AAE001 = TO_NUMBER(:B2 ) AND KC04.AAC001 = :B1 AND AC01.AKC020 IS NOT NULL
2vkwyp6k8xp5x Select count(1) as TOTALCOUNTS from OD11 where OD11.OAG014=:1 and (OD11.OAG012=:2 or OD11.OAG012=:3)
2wjg030ma6wn6 select AC01.OAE001 as AC01_OAE001, AC01.AAC001 as AC01_AAC001, AC01.AAB001 as AC01_AAB001, AC01.AAC002 as AC01_AAC002, AC01.AAC003 as AC01_AAC003, AC01.AAC022 as AC01_AAC022, AC01.AAC004 as AC01_AAC004, AC01.AAC005 as AC01_AAC005, AC01.AAC006 as AC01_AAC006, AC01.AAC007 as AC01_AAC007, AC01.AAC008 as AC01_AAC008, AC01.AAC009 as AC01_AAC009, AC01.AAC010 as AC01_AAC010, AC01.AAC011 as AC01_AAC011, AC01.AAC012 as AC01_AAC012, AC01.AAC013 as AC01_AAC013, AC01.AAC014 as AC01_AAC014, AC01.AAC015 as AC01_AAC015, AC01.AAC016 as AC01_AAC016, AC01.AAC017 as AC01_AAC017, AC01.AAC019 as AC01_AAC019, AC01.AAC020 as AC01_AAC020, AC01.AAC021 as AC01_AAC021, AC01.AAC024 as AC01_AAC024, AC01.AAC031 as AC01_AAC031, AC01.AAE004 as AC01_AAE004, AC01.AAE005 as AC01_AAE005, AC01.AAE006 as AC01_AAE006, AC01.AAE007 as AC01_AAE007, AC01.AAE008 as AC01_AAE008, AC01.AAE010 as AC01_AAE010, AC01.AAE015 as AC01_AAE015, AC01.AAB301 as AC01_AAB301, AC01.AIC001 as AC01_AIC001, AC01.AJC001 as AC01_AJC001, AC01.AKC002 as AC01_AKC002, AC01.AKC020 as AC01_AKC020, AC01.AKC021 as AC01_AKC021, AC01.AKC026 as AC01_AKC026, AC01.AKC030 as AC01_AKC030, AC01.AIC162 as AC01_AIC162, AC01.BAC002 as AC01_BAC002, AC01.BAC016 as AC01_BAC016, AC01.BAC022 as AC01_BAC022, AC01.BAC023 as AC01_BAC023, AC01.BAC024 as AC01_BAC024, AC01.BAC025 as AC01_BAC025, AC01.BAC111 as AC01_BAC111, AC01.BAC118 as AC01_BAC118, AC01.BAC119 as AC01_BAC119, AC01.BAE001 as AC01_BAE001, AC01.AAE011 as AC01_AAE011, AC01.AAE036 as AC01_AAE036, AC01.AAE0 13 as AC01_AAE013, AC01.OAE300 as AC01_OAE300, AC01.OAE301 as AC01_OAE301, AC01.BAC026 as AC01_BAC026, AC01.BAC027 as AC01_BAC027, AC01.BAC028 as AC01_BAC028, AC01.BAC029 as AC01_BAC029, AC01.BAC030 as AC01_BAC030, AC01.BAC031 as AC01_BAC031, AC01.BAC032 as AC01_BAC032, AC01.BAC033 as AC01_BAC033, AC01.BAC034 as AC01_BAC034, AC01.BAC035 as AC01_BAC035, AC01.BAC036 as AC01_BAC036, AC01.BAC037 as AC01_BAC037, AC01.BAC038 as AC01_BAC038, AC01.BAC039 as AC01_BAC039, AC01.BAC040 as AC01_BAC040, AC01.BAC041 as AC01_BAC041, AC01.BAC042 as AC01_BAC042, AC01.BAC043 as AC01_BAC043, AC01.BAC044 as AC01_BAC044, AC01.BAC045 as AC01_BAC045, AC01.BAC046 as AC01_BAC046, AC01.BAC047 as AC01_BAC047, AC01.BAC048 as AC01_BAC048, AC01.BAC049 as AC01_BAC049, AC01.BAC050 as AC01_BAC050, AC01.BAC051 as AC01_BAC051, AC01.BAC052 as AC01_BAC052, AC01.BAC053 as AC01_BAC053, AC01.BAC054 as AC01_BAC054, AC01.AAB034 as AC01_AAB034, AC01.AAB324 as AC01_AAB324, AC01.BAC055 as AC01_BAC055, AC01.BAC056 as AC01_BAC056, AC01.BAC057 as AC01_BAC057, AC01.BAC058 as AC01_BAC058, AC01.BAC059 as AC01_BAC059, AC01.BAC060 as AC01_BAC060, AC01.BAC061 as AC01_BAC061, AC01.BAC062 as AC01_BAC062, AC01.BAC063 as AC01_BAC063, AC01.BAC064 as AC01_BAC064, AC01.BAC065 as AC01_BAC065, AC01.BAC066 as AC01_BAC066, AC01.BAC067 as AC01_BAC067, AC01.BAC068 as AC01_BAC068, AC01.BAC069 as AC01_BAC069, AC01.BAC070 as AC01_BAC070, AC01.BAC071 as AC01_BAC071, AC01.BAC072 as AC01_BAC072, AC01.BAC073 as AC01_BAC073, AC01.BAC074 as AC01_BAC07 4, AC01.AAC093 as AC01_AAC093, AC01.AAC094 as AC01_AAC094, AC01.AAC095 as AC01_AAC095, AC01.AAC096 as AC01_AAC096, AC01.AAC097 as AC01_AAC097, AC01.AAC098 as AC01_AAC098, AC01.AAC099 as AC01_AAC099 from AC01 where AC01.AAC001 = :1
30sxgjt5s6s27 insert into AC01(OAE001, AAC001, AAB001, AAC002, AAC003, AAC022, AAC004, AAC005, AAC006, AAC007, AAC008, AAC009, AAC010, AAC011, AAC012, AAC013, AAC014, AAC015, AAC016, AAC017, AAC019, AAC020, AAC021, AAC024, AAC031, AAE004, AAE005, AAE006, AAE007, AAE008, AAE010, AAE015, AAB301, AIC001, AJC001, AKC002, AKC020, AKC021, AKC026, AKC030, AIC162, BAC002, BAC016, BAC022, BAC023, BAC024, BAC025, BAC111, BAC118, BAC119, BAE001, AAE011, AAE036, AAE013, OAE300, OAE301, BAC026, BAC027, BAC028, BAC029, BAC030, BAC031, BAC032, BAC033, BAC034, BAC035, BAC036, BAC037, BAC038, BAC039, BAC040, BAC041, BAC042, BAC043, BAC044, BAC045, BAC046, BAC047, BAC048, BAC049, BAC050, BAC051, BAC052, BAC053, BAC054, AAB034, AAB324, BAC055, BAC056, BAC057, BAC058, BAC059, BAC060, BAC061, BAC062, BAC063, BAC064, BAC065, BAC066, BAC067, BAC068, BAC069, BAC070, BAC071, BAC072, BAC073, BAC074, AAC093, AAC094, AAC095, AAC096, AAC097, AAC098, AAC099) values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114)
31a13pnjps7j3 SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
37m0zfmqrkmyfSELECT NVL(AKC087, 0) FROM KC04 WHERE KC04.AAE001 = (SELECT MAX(AAE001) FROM KC04 A WHERE A.AAC001 = :B1 ) AND KC04.AAC001 = :B1
3d2ckc6bf9j7zSELECT AKB022 FROM KB01 WHERE AKB020 = :B1 AND AAE100 = '1'
3dc10hfsmfmtbSELECT NVL(AAC001, '0') FROM V_AC01 WHERE UPPER(AAC002) = :B2 AND AAC003 = :B1 AND AAC031='1' AND EXISTS (SELECT 1 FROM V_AB59 WHERE BAC045 = V_AC01.AAB001)
3mggs6x0c2j46select count(1) from az01b where aaz500 = 'MA9907887' and aac002 = '342321194402250413' and aac003 = '³Â´ïÃ÷'
3qsmy8ybvwt3ninsert into WRI$_ALERT_OUTSTANDING (reason_id, object_id, subobject_id, internal_instance_number, owner, object_name, subobject_name, sequence_id, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, time_suggested, creation_time, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, message_level, hosting_client_id, process_id, host_id, host_nw_addr, instance_name, instance_number, user_id, execution_context_id, error_instance_id, context, metric_value) 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)
3xnpf0z4x81h7select ic10.aac001, ac01.aac002, ac01.aac003, ac01.aac004, ac01.aac005, ac01.aac007, ic11.aae035, ac01.aic162, ic10.aic161, ic10.aab001, ab01.aab004, ic10.aic160, ic10.aae044, ic10.aae116, ab01.aab027 from ab01, ac01, ic10, ic11 where ( ab01.aab001 = ac01.aab001 ) and ( ac01.aac001 = ic10.aac001 ) and ( ac01.aac001 = ic11.aac001 ) and ( ic11.aic190 = '5' ) and ic10.aac001 = '3411261234'
3yupxjjwqm99mselect QUERY_CBQKB.AAB001 as QUERY_CBQKB_AAB001, QUERY_CBQKB.AAB004 as QUERY_CBQKB_AAB004, QUERY_CBQKB.AAC001 as QUERY_CBQKB_AAC001, QUERY_CBQKB.AAC002 as QUERY_CBQKB_AAC002, QUERY_CBQKB.AAC003 as QUERY_CBQKB_AAC003, QUERY_CBQKB.AAC004 as QUERY_CBQKB_AAC004, QUERY_CBQKB.AAC006 as QUERY_CBQKB_AAC006, QUERY_CBQKB.AAC012 as QUERY_CBQKB_AAC012, QUERY_CBQKB.AKC020 as QUERY_CBQKB_AKC020, QUERY_CBQKB.AKC021 as QUERY_CBQKB_AKC021, QUERY_CBQKB.AAE011 as AAE011, QUERY_CBQKB.AAE036 as AAE036, QUERY_CBQKB.AAC031 as QUERY_CBQKB_AAC031, QUERY_CBQKB.BAC042 as QUERY_CBQKB_BAC042, QUERY_CBQKB.BAC048 as QUERY_CBQKB_BAC048, QUERY_CBQKB.BAC049 as QUERY_CBQKB_BAC049, QUERY_CBQKB.BAC051 as QUERY_CBQKB_BAC051, QUERY_CBQKB.BAC055 as QUERY_CBQKB_BAC055 from QUERY_CBQKB where (QUERY_CBQKB.AAB001 like :1) and ( exists (SELECT 1 FROM ac02 d WHERE query_cbqkb.aac001 = d.aac001 and d.aac031 = '1' and d.aae041 = '201409'))
40gzt5gt09ryzSELECT NVL(AAB324, '0') FROM AC01 WHERE AKC020 = :B1 AND ROWNUM = 1
47r1y8yn34jmjselect default$ from col$ where rowid=:1
4cpkp2819vcmnSELECT AAC001, AAB001, AAC002, AAC003, AAC004, AAC005, AAC006, AAC020, AAE036, AKC020, AKC021, AKC030, AAC008, AAC031, BAC022, BAC016, BAC111, AAB004, AAB301, AAB019, AAB020, BAA084, AKC306, AAE001, AKC080, AKC081, AKC082, AKC097, AKC098, AKC083, AKC084, AKC099, AKC096, AKC085, AKC087, AKC317, AKC093, AKC134, AKC086, AKC088, AKC123, AKC121, AKC089, AKC100, AKC122, AKC114, AKC132, AKC133, AKC137, AKC090, AKC117, AKC139, AKC341, AKC112, AKC101, AKC120, AKC135, AKC136, AKC156, AKC142, AKC143, AKC144, AKC145, AKC146, AKC147, AKC148, AKC149, AKC150, AKC151, AKC152, AKC153, AKC154, AKC155, AKC157, AKC158, AKC159, 0, '', '', '', '', '', '', NULL, '', '', 0, 0, '', 0, 0, '', 0, 0, AKC138, BAC028, AAB324, AKC505, AKC506, AKC561, AKC563, AKC566 FROM PERSONACCOUNT WHERE AKC020 = :B1
4fazmsttfa0g7SELECT AAC001, AAC004, AAC005, AAC006, AAC007, AAC008, AKC021, AAC009, AAC012, AAC013, AAC019, AAC020, AAB301, AIC162, PKG_A_COMM.FUN_A_GETAGE(TO_CHAR(AAC006, 'yyyymmdd'), :B2 , NULL) AGE FROM AC01 WHERE AAC001 = :B1
4kgcpukdub57vSELECT * FROM KC22 WHERE AKB020 = :B3 AND AKC190 = :B2 AND AAE072 = 'AAAA' AND (AKC126 = 0 OR AKC126 IS NULL) AND AAE100 = '1' AND TRUNC(AKC221, 'DD') <= TRUNC(:B1 , 'DD') ORDER BY AKA063 ASC
4mqz0c67a1yh4SELECT TRIM(TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS')) || '-' || TRIM(TO_CHAR(TRIM(:B1 ), '00000000')) || '-' || TRIM(TO_CHAR(SEQ_SYS.NEXTVAL, '0000')) FROM DUAL
50zrt2xad5jknSELECT AKC192, AAC001, AKC021, AKA130 FROM KC21 WHERE AKB020 = :B2 AND AKC190 = :B1 AND AAE100 = '1'
5bm56td3r1p5tBEGIN PKG_A_²¹ÍË´¦Àí.PRC_A_ÍËÊÕ´¦Àí_MAIN(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16); END;
5gdd5vx2fru8wSelect count(1) as TOTALCOUNTS from OD11 where OD11.OAG015=:1 and (OD11.OAG012=:2 or OD11.OAG012=:3)
6dwy28vj4q4ubselect count(1) as rowcount FROM "AC01" WHERE ( ( ac01.aac001 = '10026629' ) )
78pc9uq6xy52cSELECT NVL(AAA005, '0') FROM KA67 WHERE AAA003 = 'SFKG'
7f5kc7uasbd71Select nvl(bac450, 1) from sb04 where sab001='5040201304'
7r6pt27vj98g3 select V_AC01.OAE001 as V_AC01_OAE001, V_AC01.AAC001 as V_AC01_AAC001, V_AC01.AAB001 as V_AC01_AAB001, V_AC01.AAC002 as V_AC01_AAC002, V_AC01.AAC003 as V_AC01_AAC003, V_AC01.AAC022 as V_AC01_AAC022, V_AC01.AAC004 as V_AC01_AAC004, V_AC01.AAC005 as V_AC01_AAC005, V_AC01.AAC006 as V_AC01_AAC006, V_AC01.AAC007 as V_AC01_AAC007, V_AC01.AAC008 as V_AC01_AAC008, V_AC01.AAC009 as V_AC01_AAC009, V_AC01.AAC010 as V_AC01_AAC010, V_AC01.AAC011 as V_AC01_AAC011, V_AC01.AAC012 as V_AC01_AAC012, V_AC01.AAC013 as V_AC01_AAC013, V_AC01.AAC014 as V_AC01_AAC014, V_AC01.AAC015 as V_AC01_AAC015, V_AC01.AAC016 as V_AC01_AAC016, V_AC01.AAC017 as V_AC01_AAC017, V_AC01.AAC019 as V_AC01_AAC019, V_AC01.AAC020 as V_AC01_AAC020, V_AC01.AAC021 as V_AC01_AAC021, V_AC01.AAC024 as V_AC01_AAC024, V_AC01.AAC031 as V_AC01_AAC031, V_AC01.AAE004 as V_AC01_AAE004, V_AC01.AAE005 as V_AC01_AAE005, V_AC01.AAE006 as V_AC01_AAE006, V_AC01.AAE007 as V_AC01_AAE007, V_AC01.AAE008 as V_AC01_AAE008, V_AC01.AAE010 as V_AC01_AAE010, V_AC01.AAE015 as V_AC01_AAE015, V_AC01.AAB301 as V_AC01_AAB301, V_AC01.AIC001 as V_AC01_AIC001, V_AC01.AJC001 as V_AC01_AJC001, V_AC01.AKC002 as V_AC01_AKC002, V_AC01.AKC020 as V_AC01_AKC020, V_AC01.AKC021 as V_AC01_AKC021, V_AC01.AKC026 as V_AC01_AKC026, V_AC01.AKC030 as V_AC01_AKC030, V_AC01.AIC162 as V_AC01_AIC162, V_AC01.BAC002 as V_AC01_BAC002, V_AC01.BAC016 as V_AC01_BAC016, V_AC01.BAC022 as V_AC01_BAC022, V_AC01.BAC023 as V_AC01_BAC023, V_AC01.BAC024 as V_AC01_BAC024, V_AC01.BAC025 as V_AC 01_BAC025, V_AC01.BAC111 as V_AC01_BAC111, V_AC01.BAC118 as V_AC01_BAC118, V_AC01.BAC119 as V_AC01_BAC119, V_AC01.BAE001 as V_AC01_BAE001, V_AC01.AAE011 as V_AC01_AAE011, V_AC01.AAE036 as V_AC01_AAE036, V_AC01.AAE013 as V_AC01_AAE013, V_AC01.OAE300 as V_AC01_OAE300, V_AC01.OAE301 as V_AC01_OAE301, V_AC01.BAC026 as V_AC01_BAC026, V_AC01.BAC027 as V_AC01_BAC027, V_AC01.BAC028 as V_AC01_BAC028, V_AC01.BAC029 as V_AC01_BAC029, V_AC01.BAC030 as V_AC01_BAC030, V_AC01.BAC031 as V_AC01_BAC031, V_AC01.BAC032 as V_AC01_BAC032, V_AC01.BAC033 as V_AC01_BAC033, V_AC01.BAC034 as V_AC01_BAC034, V_AC01.BAC035 as V_AC01_BAC035, V_AC01.BAC036 as V_AC01_BAC036, V_AC01.BAC037 as V_AC01_BAC037, V_AC01.BAC038 as V_AC01_BAC038, V_AC01.BAC039 as V_AC01_BAC039, V_AC01.BAC040 as V_AC01_BAC040, V_AC01.BAC041 as V_AC01_BAC041, V_AC01.BAC042 as V_AC01_BAC042, V_AC01.BAC043 as V_AC01_BAC043, V_AC01.BAC044 as V_AC01_BAC044, V_AC01.BAC045 as V_AC01_BAC045, V_AC01.BAC046 as V_AC01_BAC046, V_AC01.BAC047 as V_AC01_BAC047, V_AC01.BAC048 as V_AC01_BAC048, V_AC01.BAC049 as V_AC01_BAC049, V_AC01.BAC050 as V_AC01_BAC050, V_AC01.BAC051 as V_AC01_BAC051, V_AC01.BAC052 as V_AC01_BAC052, V_AC01.BAC053 as V_AC01_BAC053, V_AC01.BAC054 as V_AC01_BAC054, V_AC02.AAB001 as V_AC02_AAB001, V_AC02.AAC001 as V_AC02_AAC001, V_AC02.AAE140 as V_AC02_AAE140, V_AC02.AAE041 as V_AC02_AAE041, V_AC02.AAE042 as V_AC02_AAE042, V_AC02.AAC031 as V_AC02_AAC031, V_AC02.AAE011 as AAE011, V_AC02.AAE036 as AAE036, V_AC01.BAC073 as V_AC01_BAC073, V_AC01.BAC074 as V_AC01_BAC074, V_AC01.AAB004 as V_AC01_AAB004, '' as V_AC56_AGE000 from V_AC01, V_AC02 where ( V_AC01.AAC001=V_AC02.AAC001 ) and ((V_AC01.AKC020 like :1) and ( v_ac01.aac001 = v_ac02.aac001 and akc021 in ('34', '35', '36', '37') and aac012 in ('91', '92', '93', '94', '95', '96', '97') and V_AC02.aae140='39' ))
81ky0n97v4zsg/* OracleOEM */ select s.sid, s.serial# from v$session s where s.sid = (select sid from v$mystat where rownum=1)
8d1ug9186ydw0select OD11.OAE300 as opSeqNum, OD11.OAG001 as businessId, OD11.AAE011 as operator, OD11.AAE036 as opDate, OD11.OAC004 as operatorName, OD11.OAG010 as maxCheckGrade, OD11.OAG011 as curCheckGrade, OD11.OAG012 as operateStatus, OD11.OAE302 as nextOpSeqNum, OD11.AAE013 as OD11_AAE013, OD11.OAG013 as OD11_OAG013, OD11.OAG014 as OD11_OAG014, OD11.OAG099 as OD11_OAG099, OD11.OAG015 as OD11_OAG015, OD11.OAG016 as OD11_OAG016 from OD11 where OD11.OAG015=:1 and (OD11.OAG012=:2 or OD11.OAG012=:3)
8dcvna2y5nshwSELECT NVL(AAA005, '0') FROM KA67 WHERE AAA003 = 'QDYXQ'
8dt9ys0pvgmu9BEGIN PKG_ÈËÔ±±ä¸ü.PRC_Ðø±£(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23); END;
8f1sjvfxuup9wselect t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null
8f74xp2z5m3cjINSERT INTO KC29 (AKB020, AKC190, AAE072, AKA135, AKC293, AKC294, AKC295, AKC296, AKC297, BKC191, BKC192, BKC193, BKC194, BKC195, BKC196, BKC197, BKC198, BKC199, BKC200, BKC201, BKC202, BKC203, AKC115, AKC116, AKC117, AKC118, AKC119, AKC101, AKC112, AKC113, AKC114, BKC066, BKC033, AKC319, OAE001, OAE300, OAE301, BKC206, BKC207, BKC208, BKC209, BKC210, BKC211, AKC543, AKC544, AKC545, AKC546, AKC547, AKC548, AKC549, AKC550, AKC551, AKC552, AKC553, AKC554 ) VALUES (:B53 , :B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , SEQ_A_ROWID.NEXTVAL, :B19 , NULL, :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
8u0gn9x5h5m0d SELECT "AC01"."AAC001", "AC01"."AAB001", "AB01"."AAB003", "AB01"."AAB004", "AB01"."AAB019", "AC01"."AAC002", "AC01"."AAC003", "AC01"."AAC022", "AC01"."AAC004", "AC01"."AAC005", "AC01"."AAC006", "AC01"."AAC007", "AC01"."AAC008", "AC01"."AAC009", "AC01"."AAC010", "AC01"."AAC011", "AC01"."AAC012", "AC01"."AAC013", "AC01"."AAC014", "AC01"."AAC015", "AC01"."AAC016", "AC01"."AAC017", "AC01"."AAC019", "AC01"."AAC020", "AC01"."AAC021", "AC01"."AAC024", "AC01"."AAC031", "AC01"."AAE004", "AC01"."AAE005", "AC01"."AAE006", "AC01"."AAE007", "AC01"."AAE015", "AC01"."AAB301", "AC01"."AIC001", "AC01"."AJC001", "AC01"."AKC002", "AC01"."AKC020", "AC01"."AAE008", "AC01"."AAE010", "AC01"."AKC021", "AC01"."AKC026", "AC01"."AKC030", "AC01"."AIC162", "AC01"."BAC022", "AC01"."BAC025", "AC01"."BAC118", "AC01"."AAE011", "AC01"."AAE036" FROM "A B01", "AC01" WHERE ( "AB01"."AAB001" = "AC01"."AAB001" ) AND ab01.aab019 <> '53' AND aac001 = ''
8w3nm1pmu1d7kSELECT AKB023 FROM KB01 WHERE AKB020 = :B1
9717x59gm5mxzSELECT COUNT(1) FROM KC24 WHERE AKB020 = :B3 AND AKC190 = :B2 AND AAE100 = '1' AND AKC197 = :B1 AND SUBSTR(AKA130, 1, 1) = '2'
98m85gxpsy0maselect SEQ_SYS.nextval from dual
9hc736jw3944qSELECT * FROM OA20 WHERE UPPER(:B2 ) = TABLE_NAME AND USER = SCHEMA_NAME AND ((MODELID = 'ALL' OR MODELID = SYS_CONTEXT(USER, 'modelid')) AND SYS_CONTEXT(USER, 'modelid') <> '9999999') AND (USERID = 'ALL' OR USERID = SYS_CONTEXT(USER, 'userid')) AND (HOSPITALID = 'ALL'OR HOSPITALID = SYS_CONTEXT(USER, 'hospitalid')) AND (SOCIALPOOLCODE = 'ALL'OR SOCIALPOOLCODE = SYS_CONTEXT(USER, 'aab324')) AND (SIOFFICEID = 'ALL' OR SIOFFICEID = SYS_CONTEXT(USER, 'aab034')) AND SYS_CONTEXT(USER, 'vpdflag') = 'true' AND ISENABLED = '1' AND :B1 <> '9999999' ORDER BY POLICY_LEVEL DESC
9hsugkmssr2uj Select count(1) as TOTALCOUNTS from OD11 where OD11.OAG015=:1 and (OD11.OAG012=:2 or OD11.OAG012=:3)
a4cwn4fdp57b3UPDATE KC21 SET AKC317 = :B14 , AKC126 = '1', AKC351 = :B13 , AKC194 = :B12 , AKC195 = :B11 , AKC196 = :B10 , AKC232 = :B9 , AKC198 = :B8 , AKC238 = :B7 , AKC199 = :B6 , AKC239 = :B5 , AKC322 = :B4 , AKC352 = :B3 WHERE AKB020 = :B2 AND AKC190 = :B1 AND AKA135 = '1' AND AAE100 = '1'
aghwt3kvh48uaSelect count(1) as TOTALCOUNTS from KC21, AB01, AC01, KB01 where ( kc21.aab001 = ab01.aab001 and kc21.akb020 = kb01.akb020 and kc21.aac001 = ac01.aac001 and kc21.aka135 = '1' and nvl(kc21.akc197, '0') in ('0', '2') ) and ( KC21.AKB020 = :1 AND KC21.AKC190 = :2 )
ast4awk7xb7ay select V_AC01.OAE001 as V_AC01_OAE001, V_AC01.AAC001 as V_AC01_AAC001, V_AC01.AAB001 as V_AC01_AAB001, V_AC01.AAC002 as V_AC01_AAC002, V_AC01.AAC003 as V_AC01_AAC003, V_AC01.AAC022 as V_AC01_AAC022, V_AC01.AAC004 as V_AC01_AAC004, V_AC01.AAC005 as V_AC01_AAC005, V_AC01.AAC006 as V_AC01_AAC006, V_AC01.AAC007 as V_AC01_AAC007, V_AC01.AAC008 as V_AC01_AAC008, V_AC01.AAC009 as V_AC01_AAC009, V_AC01.AAC010 as V_AC01_AAC010, V_AC01.AAC011 as V_AC01_AAC011, V_AC01.AAC012 as V_AC01_AAC012, V_AC01.AAC013 as V_AC01_AAC013, V_AC01.AAC014 as V_AC01_AAC014, V_AC01.AAC015 as V_AC01_AAC015, V_AC01.AAC016 as V_AC01_AAC016, V_AC01.AAC017 as V_AC01_AAC017, V_AC01.AAC019 as V_AC01_AAC019, V_AC01.AAC020 as V_AC01_AAC020, V_AC01.AAC021 as V_AC01_AAC021, V_AC01.AAC024 as V_AC01_AAC024, V_AC01.AAC031 as V_AC01_AAC031, V_AC01.AAE004 as V_AC01_AAE004, V_AC01.AAE005 as V_AC01_AAE005, V_AC01.AAE006 as V_AC01_AAE006, V_AC01.AAE007 as V_AC01_AAE007, V_AC01.AAE008 as V_AC01_AAE008, V_AC01.AAE010 as V_AC01_AAE010, V_AC01.AAE015 as V_AC01_AAE015, V_AC01.AAB301 as V_AC01_AAB301, V_AC01.AIC001 as V_AC01_AIC001, V_AC01.AJC001 as V_AC01_AJC001, V_AC01.AKC002 as V_AC01_AKC002, V_AC01.AKC020 as V_AC01_AKC020, V_AC01.AKC021 as V_AC01_AKC021, V_AC01.AKC026 as V_AC01_AKC026, V_AC01.AKC030 as V_AC01_AKC030, V_AC01.AIC162 as V_AC01_AIC162, V_AC01.BAC002 as V_AC01_BAC002, V_AC01.BAC016 as V_AC01_BAC016, V_AC01.BAC022 as V_AC01_BAC022, V_AC01.BAC023 as V_AC01_BAC023, V_AC01.BAC024 as V_AC01_BAC024, V_AC01.BAC025 as V_AC 01_BAC025, V_AC01.BAC111 as V_AC01_BAC111, V_AC01.BAC118 as V_AC01_BAC118, V_AC01.BAC119 as V_AC01_BAC119, V_AC01.BAE001 as V_AC01_BAE001, V_AC01.AAE011 as V_AC01_AAE011, V_AC01.AAE036 as V_AC01_AAE036, V_AC01.AAE013 as V_AC01_AAE013, V_AC01.OAE300 as V_AC01_OAE300, V_AC01.OAE301 as V_AC01_OAE301, V_AC01.BAC026 as V_AC01_BAC026, V_AC01.BAC027 as V_AC01_BAC027, V_AC01.BAC028 as V_AC01_BAC028, V_AC01.BAC029 as V_AC01_BAC029, V_AC01.BAC030 as V_AC01_BAC030, V_AC01.BAC031 as V_AC01_BAC031, V_AC01.BAC032 as V_AC01_BAC032, V_AC01.BAC033 as V_AC01_BAC033, V_AC01.BAC034 as V_AC01_BAC034, V_AC01.BAC035 as V_AC01_BAC035, V_AC01.BAC036 as V_AC01_BAC036, V_AC01.BAC037 as V_AC01_BAC037, V_AC01.BAC038 as V_AC01_BAC038, V_AC01.BAC039 as V_AC01_BAC039, V_AC01.BAC040 as V_AC01_BAC040, V_AC01.BAC041 as V_AC01_BAC041, V_AC01.BAC042 as V_AC01_BAC042, V_AC01.BAC043 as V_AC01_BAC043, V_AC01.BAC044 as V_AC01_BAC044, V_AC01.BAC045 as V_AC01_BAC045, V_AC01.BAC046 as V_AC01_BAC046, V_AC01.BAC047 as V_AC01_BAC047, V_AC01.BAC048 as V_AC01_BAC048, V_AC01.BAC049 as V_AC01_BAC049, V_AC01.BAC050 as V_AC01_BAC050, V_AC01.BAC051 as V_AC01_BAC051, V_AC01.BAC052 as V_AC01_BAC052, V_AC01.BAC053 as V_AC01_BAC053, V_AC01.BAC054 as V_AC01_BAC054, V_AC02.AAB001 as V_AC02_AAB001, V_AC02.AAC001 as V_AC02_AAC001, V_AC02.AAE140 as V_AC02_AAE140, V_AC02.AAE041 as V_AC02_AAE041, V_AC02.AAE042 as V_AC02_AAE042, V_AC02.AAC031 as V_AC02_AAC031, V_AC02.AAE011 as AAE011, V_AC02.AAE036 as AAE036, V_AC01.BAC073 as V_AC01_BAC073, V_AC01.BAC074 as V_AC01_BAC074, V_AC01.AAB004 as V_AC01_AAB004, '' as V_AC56_AGE000 from V_AC01, V_AC02 where ( V_AC01.AAC001=V_AC02.AAC001 ) and ((V_AC01.AAC001 = :1) and ( v_ac01.aac001 = v_ac02.aac001 and akc021 in ('34', '35', '36', '37') and aac012 in ('91', '92', '93', '94', '95', '96', '97') and V_AC02.aae140='39' ))
bd502nbh9abbsselect s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
bgm8m7bscb5d3SELECT DISTINCT AAC001, AKA130, AKC192, NVL(AKC128, '0'), AKC020, AKC193, AKC353, NVL(AKC194, SYSDATE) FROM KC21 WHERE AKB020 = :B2 AND AKC190 = :B1 AND AAE100 = '1'
bhwvmcwaj7vcnSELECT AAA005 FROM AA01 WHERE AAE130 = '0' AND AAA003 = 'XTJSQ'
brqqzz2cx2ad0SELECT AKC385 FROM KC33 WHERE AKB020 = :B3 AND AKC377 = :B2 AND AKC347 = :B1 AND NVL(AKC385, 0) = '1'
cs428643kphvvSELECT AAC001, AAB001, AAC002, AAC003, AAC004, AAC005, AAC006, AAC020, AAE036, AKC020, AKC021, AKC030, AAC008, AAC031, BAC022, BAC016, BAC111, AAB004, AAB301, AAB019, AAB020, BAA084, AKC306, AAE001, AKC080, AKC081, AKC082, AKC097, AKC098, AKC083, AKC084, AKC099, AKC096, AKC085, AKC087, AKC317, AKC093, AKC134, AKC086, AKC088, AKC123, AKC121, AKC089, AKC100, AKC122, AKC114, AKC132, AKC133, AKC137, AKC090, AKC117, AKC139, AKC341, AKC112, AKC101, AKC120, AKC135, AKC136, AKC156, AKC142, AKC143, AKC144, AKC145, AKC146, AKC147, AKC148, AKC149, AKC150, AKC151, AKC152, AKC153, AKC154, AKC155, AKC157, AKC158, AKC159, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', AKC138, BAC028, AAB324, AKC505, AKC506, AKC561, AKC563, AKC566 FROM PERSONACCOUNT WHERE AAC001 = :B1
d0b3sfq0ws3k6 select V_AC01.OAE001 as V_AC01_OAE001, V_AC01.AAC001 as V_AC01_AAC001, V_AC01.AAB001 as V_AC01_AAB001, V_AC01.AAC002 as V_AC01_AAC002, V_AC01.AAC003 as V_AC01_AAC003, V_AC01.AAC022 as V_AC01_AAC022, V_AC01.AAC004 as V_AC01_AAC004, V_AC01.AAC005 as V_AC01_AAC005, V_AC01.AAC006 as V_AC01_AAC006, V_AC01.AAC007 as V_AC01_AAC007, V_AC01.AAC008 as V_AC01_AAC008, V_AC01.AAC009 as V_AC01_AAC009, V_AC01.AAC010 as V_AC01_AAC010, V_AC01.AAC011 as V_AC01_AAC011, V_AC01.AAC012 as V_AC01_AAC012, V_AC01.AAC013 as V_AC01_AAC013, V_AC01.AAC014 as V_AC01_AAC014, V_AC01.AAC015 as V_AC01_AAC015, V_AC01.AAC016 as V_AC01_AAC016, V_AC01.AAC017 as V_AC01_AAC017, V_AC01.AAC019 as V_AC01_AAC019, V_AC01.AAC020 as V_AC01_AAC020, V_AC01.AAC021 as V_AC01_AAC021, V_AC01.AAC024 as V_AC01_AAC024, V_AC01.AAC031 as V_AC01_AAC031, V_AC01.AAE004 as V_AC01_AAE004, V_AC01.AAE005 as V_AC01_AAE005, V_AC01.AAE006 as V_AC01_AAE006, V_AC01.AAE007 as V_AC01_AAE007, V_AC01.AAE008 as V_AC01_AAE008, V_AC01.AAE010 as V_AC01_AAE010, V_AC01.AAE015 as V_AC01_AAE015, V_AC01.AAB301 as V_AC01_AAB301, V_AC01.AIC001 as V_AC01_AIC001, V_AC01.AJC001 as V_AC01_AJC001, V_AC01.AKC002 as V_AC01_AKC002, V_AC01.AKC020 as V_AC01_AKC020, V_AC01.AKC021 as V_AC01_AKC021, V_AC01.AKC026 as V_AC01_AKC026, V_AC01.AKC030 as V_AC01_AKC030, V_AC01.AIC162 as V_AC01_AIC162, V_AC01.BAC002 as V_AC01_BAC002, V_AC01.BAC016 as V_AC01_BAC016, V_AC01.BAC022 as V_AC01_BAC022, V_AC01.BAC023 as V_AC01_BAC023, V_AC01.BAC024 as V_AC01_BAC024, V_AC01.BAC025 as V_AC 01_BAC025, V_AC01.BAC111 as V_AC01_BAC111, V_AC01.BAC118 as V_AC01_BAC118, V_AC01.BAC119 as V_AC01_BAC119, V_AC01.BAE001 as V_AC01_BAE001, V_AC01.AAE011 as AAE011, V_AC01.AAE036 as AAE036, V_AC01.AAE013 as V_AC01_AAE013, V_AC01.OAE300 as V_AC01_OAE300, V_AC01.OAE301 as V_AC01_OAE301, V_AC01.BAC026 as V_AC01_BAC026, V_AC01.BAC027 as V_AC01_BAC027, V_AC01.BAC028 as V_AC01_BAC028, V_AC01.BAC029 as V_AC01_BAC029, V_AC01.BAC030 as V_AC01_BAC030, V_AC01.BAC031 as V_AC01_BAC031, V_AC01.BAC032 as V_AC01_BAC032, V_AC01.BAC033 as V_AC01_BAC033, V_AC01.BAC034 as V_AC01_BAC034, V_AC01.BAC035 as V_AC01_BAC035, V_AC01.BAC036 as V_AC01_BAC036, V_AC01.BAC037 as V_AC01_BAC037, V_AC01.BAC038 as V_AC01_BAC038, V_AC01.BAC039 as V_AC01_BAC039, V_AC01.BAC040 as V_AC01_BAC040, V_AC01.BAC041 as V_AC01_BAC041, V_AC01.BAC042 as V_AC01_BAC042, V_AC01.BAC043 as V_AC01_BAC043, V_AC01.BAC044 as V_AC01_BAC044, V_AC01.BAC045 as V_AC01_BAC045, V_AC01.BAC046 as V_AC01_BAC046, V_AC01.BAC047 as V_AC01_BAC047, V_AC01.BAC048 as V_AC01_BAC048, V_AC01.BAC049 as V_AC01_BAC049, V_AC01.BAC050 as V_AC01_BAC050, V_AC01.BAC051 as V_AC01_BAC051, V_AC01.BAC052 as V_AC01_BAC052, V_AC01.BAC053 as V_AC01_BAC053, V_AC01.BAC054 as V_AC01_BAC054, V_AC01.BAC056 as V_AC01_BAC056, V_AC01.BAC055 as V_AC01_BAC055, '' as V_AC01_AAB004, V_AC01.BAC073 as V_AC01_BAC073, V_AC01.BAC074 as V_AC01_BAC074 from V_AC01 where (V_AC01.AAC002 = :1) and ( aac031='1' and akc021 in ('34', '35', '36', '37') and aac012 in ('91', '92', '93', '94', '95', '96', '97') and exists (select * from v_ac02 where aac001 = V_AC01.aac001 and v_ac02.AAE140 = '39'))
d2hxrvrwz4vvgselect SEQ_A_AAE079.nextval from dual
d4u9rxn27xhg2Select count(1) as TOTALCOUNTS from OD11 where OD11.OAG014=:1 and (OD11.OAG012=:2 or OD11.OAG012=:3)
dbu92p57gtcrsselect AA01.AAE130 as AA01_AAE130, AA01.AAA003 as AA01_AAA003, AA01.AAA005 as AA01_AAA005, AA01.AAA004 as AA01_AAA004, AA01.AAE030 as AA01_AAE030, AA01.AAE031 as AA01_AAE031, AA01.AAE013 as AA01_AAE013, AA01.AAE011 as AA01_AAE011, AA01.AAE035 as AA01_AAE035 from AA01 where AA01.AAA003 = :1 AND AA01.AAE030 <= sysdate AND (AA01.AAE031 >= sysdate OR AA01.AAE031 IS NULL)
dhj0f5nb3ykns INSERT INTO AC01H(OAE001, AAC001, AAB001, AAC002, AAC003, AAC022, AAC004, AAC005, AAC006, AAC007, AAC008, AAC009, AAC010, AAC011, AAC012, AAC013, AAC014, AAC015, AAC016, AAC017, AAC019, AAC020, AAC021, AAC024, AAC031, AAE004, AAE005, AAE006, AAE007, AAE008, AAE010, AAE015, AAB301, AIC001, AJC001, AKC002, AKC020, AKC021, AKC026, AKC030, AIC162, BAC002, BAC016, BAC022, BAC023, BAC024, BAC025, BAC111, BAC118, BAC119, BAE001, AAE011, AAE036, AAE013, OAE300, OAE301, BAC026, BAC027, BAC028, BAC029, BAC030, BAC031, BAC032, BAC033, BAC034, BAC035, BAC036, BAC037, BAC038, BAC039, BAC040, BAC041, BAC042, BAC043, BAC044, BAC045, BAC046, BAC047, BAC048, BAC049, BAC050, BAC051, BAC052, BAC053, BAC054, AAB034, AAB324, BAC055, BAC056, BAC057, BAC058, BAC059, BAC060, BAC061, BAC062, BAC063, BAC064, BAC065, BAC066, BAC067, BAC068, BAC069, BAC070, BAC071, BAC072, BAC073, BAC074, AAC093, AAC094, AAC095, AAC096, AAC097, AAC098, AAC099) SELECT OAE001, AAC001, AAB001, AAC002, AAC003, AAC022, AAC004, AAC005, AAC006, AAC007, AAC008, AAC009, AAC010, AAC011, AAC012, AAC013, AAC014, AAC015, AAC016, AAC017, AAC019, AAC020, AAC021, AAC024, AAC031, AAE004, AAE005, AAE006, AAE007, AAE008, AAE010, AAE015, AAB301, AIC001, AJC001, AKC002, AKC020, AKC021, AKC026, AKC030, AIC162, BAC002, BAC016, BAC022, BAC023, BAC024, BAC025, BAC111, BAC118, BAC119, BAE001, AAE011, AAE036, AAE013, OAE300, OAE301, BAC026, BAC027, BAC028, BAC029, BAC030, BAC031, BAC032, BAC033, BAC034, BAC035, BAC036, BAC037, BAC038, BAC039, BAC 040, BAC041, BAC042, BAC043, BAC044, BAC045, BAC046, BAC047, BAC048, BAC049, BAC050, BAC051, BAC052, BAC053, BAC054, AAB034, AAB324, BAC055, BAC056, BAC057, BAC058, BAC059, BAC060, BAC061, BAC062, BAC063, BAC064, BAC065, BAC066, BAC067, BAC068, BAC069, BAC070, BAC071, BAC072, BAC073, BAC074, AAC093, AAC094, AAC095, AAC096, AAC097, AAC098, AAC099 FROM AC01 WHERE AAC001 ='11653780'
dwt5z8gvd6brdSELECT Pkg_a_Comm.Fun_a_Getage(to_char(to_date('1966-11-17', 'yyyy-mm-dd'), 'yyyymmdd'), to_char(sysdate, 'yyyymmdd'), '1') age FROM dual
f6zt27zrxfct7select count(1) as rowcount FROM "AB01" WHERE ( ( ab01.aab001 = '23070' ) )
fafbqq5281vy0 Select count(1) as TOTALCOUNTS from V_AC01, V_AC02 where ( V_AC01.AAC001=V_AC02.AAC001 ) and ((V_AC01.AKC020 like :1) and ( v_ac01.aac001 = v_ac02.aac001 and akc021 in ('34', '35', '36', '37') and aac012 in ('91', '92', '93', '94', '95', '96', '97') and V_AC02.aae140='39' ))
fh3nahb250bj8select KC21.AKB020 as KC21_AKB020, KC21.AAB001 as KC21_AAB001, KC21.AAC001 as KC21_AAC001, KC21.AKC190 as KC21_AKC190, KC21.AKA135 as KC21_AKA135, KC21.AKA130 as KC21_AKA130, KC21.AKC021 as KC21_AKC021, KC21.AKA101 as KC21_AKA101, KC21.AKC192 as KC21_AKC192, KC21.AKC193 as KC21_AKC193, KC21.AKC194 as KC21_AKC194, KC21.AKC196 as KC21_AKC196, KC21.AKC231 as KC21_AKC231, KC21.AKC232 as KC21_AKC232, KC21.AKC323 as KC21_AKC323, KC21.AKC324 as KC21_AKC324, KC21.AKC201 as KC21_AKC201, KC21.AKC202 as KC21_AKC202, KC21.AAE100 as KC21_AAE100, KC21.AKC195 as KC21_AKC195, KC21.AKC020 as KC21_AKC020, AC01.AAC003 as AC01_AAC003, AC01.AAC004 as AC01_AAC004, AC01.AAC006 as AC01_AAC006, AC01.AAC002 as AC01_AAC002, AC01.AAC008 as AC01_AAC008, AB01.AAB004 as AB01_AAB004, KB01.AKB021 as KB01_AKB021 from KC21, AB01, AC01, KB01 where ( kc21.aab001 = ab01.aab001 and kc21.akb020 = kb01.akb020 and kc21.aac001 = ac01.aac001 and kc21.aka135 = '1' and nvl(kc21.akc197, '0') in ('0', '2') ) and ( KC21.AKB020 = :1 AND KC21.AKC190 = :2 )
fqmpmkfr6pqykselect s.synonym_name object_name, o.object_type from sys.all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
frwp0hdnvprjwBEGIN PKG_ÈËÔ±±ä¸ü.PRC_ÅúÁ¿µ¼Èë(:1, :2, :3, :4); END;
fx7nuhacnspfhinsert into KC24h value select * from KC24 where OAE001 = 1124066972
g4gwx26fvxuy9 select V_AC01.OAE001 as V_AC01_OAE001, V_AC01.AAC001 as V_AC01_AAC001, V_AC01.AAB001 as V_AC01_AAB001, V_AC01.AAC002 as V_AC01_AAC002, V_AC01.AAC003 as V_AC01_AAC003, V_AC01.AAC022 as V_AC01_AAC022, V_AC01.AAC004 as V_AC01_AAC004, V_AC01.AAC005 as V_AC01_AAC005, V_AC01.AAC006 as V_AC01_AAC006, V_AC01.AAC007 as V_AC01_AAC007, V_AC01.AAC008 as V_AC01_AAC008, V_AC01.AAC009 as V_AC01_AAC009, V_AC01.AAC010 as V_AC01_AAC010, V_AC01.AAC011 as V_AC01_AAC011, V_AC01.AAC012 as V_AC01_AAC012, V_AC01.AAC013 as V_AC01_AAC013, V_AC01.AAC014 as V_AC01_AAC014, V_AC01.AAC015 as V_AC01_AAC015, V_AC01.AAC016 as V_AC01_AAC016, V_AC01.AAC017 as V_AC01_AAC017, V_AC01.AAC019 as V_AC01_AAC019, V_AC01.AAC020 as V_AC01_AAC020, V_AC01.AAC021 as V_AC01_AAC021, V_AC01.AAC024 as V_AC01_AAC024, V_AC01.AAC031 as V_AC01_AAC031, V_AC01.AAE004 as V_AC01_AAE004, V_AC01.AAE005 as V_AC01_AAE005, V_AC01.AAE006 as V_AC01_AAE006, V_AC01.AAE007 as V_AC01_AAE007, V_AC01.AAE008 as V_AC01_AAE008, V_AC01.AAE010 as V_AC01_AAE010, V_AC01.AAE015 as V_AC01_AAE015, V_AC01.AAB301 as V_AC01_AAB301, V_AC01.AIC001 as V_AC01_AIC001, V_AC01.AJC001 as V_AC01_AJC001, V_AC01.AKC002 as V_AC01_AKC002, V_AC01.AKC020 as V_AC01_AKC020, V_AC01.AKC021 as V_AC01_AKC021, V_AC01.AKC026 as V_AC01_AKC026, V_AC01.AKC030 as V_AC01_AKC030, V_AC01.AIC162 as V_AC01_AIC162, V_AC01.BAC002 as V_AC01_BAC002, V_AC01.BAC016 as V_AC01_BAC016, V_AC01.BAC022 as V_AC01_BAC022, V_AC01.BAC023 as V_AC01_BAC023, V_AC01.BAC024 as V_AC01_BAC024, V_AC01.BAC025 as V_AC 01_BAC025, V_AC01.BAC111 as V_AC01_BAC111, V_AC01.BAC118 as V_AC01_BAC118, V_AC01.BAC119 as V_AC01_BAC119, V_AC01.BAE001 as V_AC01_BAE001, V_AC01.AAE011 as V_AC01_AAE011, V_AC01.AAE036 as V_AC01_AAE036, V_AC01.AAE013 as V_AC01_AAE013, V_AC01.OAE300 as V_AC01_OAE300, V_AC01.OAE301 as V_AC01_OAE301, V_AC01.BAC026 as V_AC01_BAC026, V_AC01.BAC027 as V_AC01_BAC027, V_AC01.BAC028 as V_AC01_BAC028, V_AC01.BAC029 as V_AC01_BAC029, V_AC01.BAC030 as V_AC01_BAC030, V_AC01.BAC031 as V_AC01_BAC031, V_AC01.BAC032 as V_AC01_BAC032, V_AC01.BAC033 as V_AC01_BAC033, V_AC01.BAC034 as V_AC01_BAC034, V_AC01.BAC035 as V_AC01_BAC035, V_AC01.BAC036 as V_AC01_BAC036, V_AC01.BAC037 as V_AC01_BAC037, V_AC01.BAC038 as V_AC01_BAC038, V_AC01.BAC039 as V_AC01_BAC039, V_AC01.BAC040 as V_AC01_BAC040, V_AC01.BAC041 as V_AC01_BAC041, V_AC01.BAC042 as V_AC01_BAC042, V_AC01.BAC043 as V_AC01_BAC043, V_AC01.BAC044 as V_AC01_BAC044, V_AC01.BAC045 as V_AC01_BAC045, V_AC01.BAC046 as V_AC01_BAC046, V_AC01.BAC047 as V_AC01_BAC047, V_AC01.BAC048 as V_AC01_BAC048, V_AC01.BAC049 as V_AC01_BAC049, V_AC01.BAC050 as V_AC01_BAC050, V_AC01.BAC051 as V_AC01_BAC051, V_AC01.BAC052 as V_AC01_BAC052, V_AC01.BAC053 as V_AC01_BAC053, V_AC01.BAC054 as V_AC01_BAC054, V_AC02.AAB001 as V_AC02_AAB001, V_AC02.AAC001 as V_AC02_AAC001, V_AC02.AAE140 as V_AC02_AAE140, V_AC02.AAE041 as V_AC02_AAE041, V_AC02.AAE042 as V_AC02_AAE042, V_AC02.AAC031 as V_AC02_AAC031, V_AC02.AAE011 as AAE011, V_AC02.AAE036 as AAE036, V_AC01.BAC073 as V_AC01_BAC073, V_AC01.BAC074 as V_AC01_BAC074, V_AC01.AAB004 as V_AC01_AAB004, '' as V_AC56_AGE000 from V_AC01, V_AC02 where ( V_AC01.AAC001=V_AC02.AAC001 ) and ((V_AC01.AAC003 like :1) AND (V_AC01.BAC045 = :2) and ( v_ac01.aac001 = v_ac02.aac001 and akc021 in ('34', '35', '36', '37') and aac012 in ('91', '92', '93', '94', '95', '96', '97') and V_AC02.aae140='39' ))
g8xnyqtspkytqBEGIN PKG_K_SIINTERFACE.PRC_K_SIINTERFACE(:1, :2, :3, :4, :5, :6); END;
gdn3ysuyssf82SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1
gg94xm5r0u849select count(1) as rowcount FROM "AB01", "AC01" WHERE ( "AB01"."AAB001" = "AC01"."AAB001" ) AND ab01.aab019 <> '53' AND aac001 = '12076190'
ghgxmq1br4hc0SELECT AAE140, AKC160, AAE121, AKC163, AAE030, AAE031 FROM KC08 WHERE AAC001 = :B3 AND NVL(AAE121, '0') > '0' AND NVL(AAE100, '1') = '1' AND AKC163 IN ('10', '20') AND ((AKC020 = :B2 AND AKC160 IN ('6', '7', '8')) OR AKC160 NOT IN ('6', '7', '8')) AND TRUNC(AAE030, 'DD') <= TRUNC(:B1 , 'DD') AND (TRUNC(AAE031, 'DD') IS NULL OR TRUNC(AAE031, 'DD') >= TRUNC(:B1 , 'DD'))
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 639,071 136.29 27.98
CPU used when call started 638,305 136.13 27.95
CR blocks created 4,177 0.89 0.18
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DB time 25,308,109 5,397.40 1,108.06
DBWR checkpoint buffers written 54,144 11.55 2.37
DBWR checkpoints 3 0.00 0.00
DBWR fusion writes 7,165 1.53 0.31
DBWR object drop buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 397 0.08 0.02
DBWR undo block writes 5,284 1.13 0.23
DFO trees parallelized 57 0.01 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 382 0.08 0.02
PX local messages sent 382 0.08 0.02
PX remote messages recv'd 355 0.08 0.02
PX remote messages sent 423 0.09 0.02
Parallel operations downgraded to serial 87 0.02 0.00
Parallel operations not downgraded 57 0.01 0.00
RowCR - row contention 307 0.07 0.01
RowCR attempts 20,113 4.29 0.88
RowCR hits 19,676 4.20 0.86
SMON posted for undo segment shrink 1 0.00 0.00
SQL*Net roundtrips to/from client 673,097 143.55 29.47
active txn count during cleanout 6,984 1.49 0.31
application wait time 65 0.01 0.00
background checkpoints completed 3 0.00 0.00
background checkpoints started 3 0.00 0.00
background timeouts 20,218 4.31 0.89
branch node splits 2 0.00 0.00
buffer is not pinned count 52,262,837 11,145.97 2,288.22
buffer is pinned count 10,642,530,247 2,269,707.75 465,960.17
bytes received via SQL*Net from client 52,410,130 11,177.39 2,294.66
bytes sent via SQL*Net to client 189,882,120 40,495.72 8,313.58
calls to get snapshot scn: kcmgss 13,718,885 2,925.79 600.65
calls to kcmgas 146,621 31.27 6.42
calls to kcmgcs 1,639 0.35 0.07
change write time 538 0.11 0.02
cleanout - number of ktugct calls 7,115 1.52 0.31
cleanouts and rollbacks - consistent read gets 2,110 0.45 0.09
cleanouts only - consistent read gets 811 0.17 0.04
cluster key scan block gets 302,206 64.45 13.23
cluster key scans 27,588 5.88 1.21
cluster wait time 22,836 4.87 1.00
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 904 0.19 0.04
commit batch/immediate requested 904 0.19 0.04
commit cleanout failures: block lost 627 0.13 0.03
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 1,378 0.29 0.06
commit cleanout failures: cannot pin 21 0.00 0.00
commit cleanouts 202,428 43.17 8.86
commit cleanouts successfully completed 200,402 42.74 8.77
commit immediate performed 904 0.19 0.04
commit immediate requested 904 0.19 0.04
commit txn count during cleanout 21,585 4.60 0.95
concurrency wait time 17,007,947 3,627.25 744.66
consistent changes 23,791 5.07 1.04
consistent gets 255,116,424 54,408.09 11,169.72
consistent gets - examination 4,198,962 895.50 183.84
consistent gets direct 1 0.00 0.00
consistent gets from cache 255,116,428 54,408.09 11,169.72
current blocks converted for CR 11 0.00 0.00
cursor authentications 3,521 0.75 0.15
data blocks consistent reads - undo records applied 23,333 4.98 1.02
db block changes 1,058,527 225.75 46.35
db block gets 1,280,490 273.09 56.06
db block gets direct 280 0.06 0.01
db block gets from cache 1,280,183 273.02 56.05
deferred (CURRENT) block cleanout applications 71,576 15.26 3.13
dirty buffers inspected 1,950 0.42 0.09
enqueue conversions 1,170 0.25 0.05
enqueue deadlocks 122 0.03 0.01
enqueue releases 159,321 33.98 6.98
enqueue requests 159,501 34.02 6.98
enqueue timeouts 50 0.01 0.00
enqueue waits 2,006 0.43 0.09
exchange deadlocks 14 0.00 0.00
execute count 13,493,651 2,877.76 590.79
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 1,670,808 356.33 73.15
free buffer requested 1,519,718 324.11 66.54
gc CPU used by this session 53,547 11.42 2.34
gc cr block build time 27 0.01 0.00
gc cr block flush time 13 0.00 0.00
gc cr block receive time 1,653 0.35 0.07
gc cr block send time 359 0.08 0.02
gc cr blocks received 26,360 5.62 1.15
gc cr blocks served 26,971 5.75 1.18
gc current block flush time 46 0.01 0.00
gc current block pin time 1,774 0.38 0.08
gc current block receive time 86,457 18.44 3.79
gc current block send time 61,628 13.14 2.70
gc current blocks received 524,910 111.95 22.98
gc current blocks served 5,223,691 1,114.04 228.71
gc local grants 831,655 177.37 36.41
gc remote grants 125,872 26.84 5.51
gcs messages sent 2,053,243 437.89 89.90
ges messages sent 112,025 23.89 4.90
global enqueue get time 15,441 3.29 0.68
global enqueue gets async 1,963 0.42 0.09
global enqueue gets sync 578,295 123.33 25.32
global enqueue releases 742,358 158.32 32.50
heap block compress 19,751 4.21 0.86
hot buffers moved to head of LRU 725,327 154.69 31.76
immediate (CR) block cleanout applications 2,921 0.62 0.13
immediate (CURRENT) block cleanout applications 17,347 3.70 0.76
index crx upgrade (found) 19 0.00 0.00
index crx upgrade (positioned) 156,158 33.30 6.84
index fast full scans (full) 90 0.02 0.00
index fetch by key 1,407,422 300.16 61.62
index scans kdiixs1 820,968 175.09 35.94
leaf node 90-10 splits 173 0.04 0.01
leaf node splits 793 0.17 0.03
lob reads 16 0.00 0.00
lob writes 116 0.02 0.01
lob writes unaligned 116 0.02 0.01
logons cumulative 336 0.07 0.01
messages received 69,711 14.87 3.05
messages sent 69,583 14.84 3.05
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 246,359,159 52,540.45 10,786.30
opened cursors cumulative 4,330,541 923.56 189.60
parse count (failures) 228 0.05 0.01
parse count (hard) 31,518 6.72 1.38
parse count (total) 4,335,096 924.54 189.80
parse time cpu 195,429 41.68 8.56
parse time elapsed 14,069,352 3,000.54 616.00
physical read IO requests 946,060 201.76 41.42
physical read bytes 15,500,247,040 3,305,701.74 678,644.79
physical read total IO requests 344,237 73.41 15.07
physical read total bytes 16,302,179,328 3,476,727.98 713,755.66
physical read total multi block requests 45,827 9.77 2.01
physical reads 946,060 201.76 41.42
physical reads cache 946,005 201.75 41.42
physical reads cache prefetch 663,735 141.55 29.06
physical reads direct 55 0.01 0.00
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 53,646 11.44 2.35
physical write bytes 1,021,575,168 217,868.97 44,727.46
physical write total IO requests 509,248 108.61 22.30
physical write total bytes 2,345,993,728 500,324.64 102,714.26
physical write total multi block requests 21,729 4.63 0.95
physical writes 62,352 13.30 2.73
physical writes direct 334 0.07 0.01
physical writes direct (lob) 2 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 62,018 13.23 2.72
physical writes non checkpoint 43,526 9.28 1.91
pinned buffers inspected 84 0.02 0.00
prefetch clients - default 2 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 330 0.07 0.01
process last non-idle time 4,829 1.03 0.21
queries parallelized 41 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 14,480,633 3,088.25 634.00
recursive cpu usage 144,125 30.74 6.31
redo blocks written 396,821 84.63 17.37
redo buffer allocation retries 3 0.00 0.00
redo entries 577,277 123.11 25.27
redo log space requests 3 0.00 0.00
redo log space wait time 2 0.00 0.00
redo ordering marks 5,046 1.08 0.22
redo size 191,450,416 40,830.19 8,382.24
redo subscn max counts 2,771 0.59 0.12
redo synch time 1,817 0.39 0.08
redo synch writes 15,095 3.22 0.66
redo wastage 4,918,904 1,049.04 215.36
redo write time 1,406 0.30 0.06
redo writer latching time 0 0.00 0.00
redo writes 18,674 3.98 0.82
rollback changes - undo records applied 69,356 14.79 3.04
rollbacks only - consistent read gets 2,046 0.44 0.09
rows fetched via callback 990,292 211.20 43.36
session connect time 0 0.00 0.00
session cursor cache hits 4,123,353 879.38 180.53
session logical reads 256,396,864 54,681.16 11,225.78
session pga memory 278,478,784 59,390.52 12,192.59
session pga memory max 663,636,544 141,532.23 29,055.89
session uga memory 4,445,133,040 948,003.22 194,620.54
session uga memory max 724,831,112 154,583.05 31,735.16
shared hash latch upgrades - no wait 189,073 40.32 8.28
shared hash latch upgrades - wait 22 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 2,159,342 460.52 94.54
sorts (rows) 16,675,305 3,556.30 730.09
sql area evicted 46,508 9.92 2.04
sql area purged 216 0.05 0.01
summed dirty queue length 7,110 1.52 0.31
switch current to new buffer 11,323 2.41 0.50
table fetch by rowid 5,346,064,852 1,140,142.85 234,065.89
table fetch continued row 347,770 74.17 15.23
table scan blocks gotten 185,587,563 39,579.83 8,125.55
table scan rows gotten 22,291,844,108 4,754,129.90 976,000.18
table scans (cache partitions) 0 0.00 0.00
table scans (direct read) 0 0.00 0.00
table scans (long tables) 748 0.16 0.03
table scans (short tables) 2,143,541 457.15 93.85
total number of times SMON posted 1 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 904 0.19 0.04
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 63,304,264 13,500.75 2,771.64
user I/O wait time 83,708 17.85 3.66
user calls 692,993 147.79 30.34
user commits 16,475 3.51 0.72
user rollbacks 6,365 1.36 0.28
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 2,141,542 456.72 93.76
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 888,582 891,864
opened cursors current 3,016 5,705
workarea memory allocated 0 1,104
logons current 132 206

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 3 2.30

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)
USERS 240,443 51 2.58 3.57 17,649 4 5,932 1.69
INDEX 85,356 18 2.50 1.00 34,291 7 61 8.36
UNDOTBS1 3 0 0.00 1.00 1,280 0 6 0.00
SYSAUX 61 0 6.07 1.16 352 0 0 0.00
SYSTEM 247 0 8.02 3.28 71 0 5 8.00
UNDOTBS2 3 0 0.00 1.00 3 0 3 3.33

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
INDEX /oradata/ORCL/datafile/index01.dbf 12,437 3 2.78 1.00 5,585 1 20 3.00
INDEX /oradata/ORCL/datafile/index02.dbf 11,027 2 2.44 1.01 4,516 1 8 21.25
INDEX /oradata/ORCL/datafile/index03.dbf 12,905 3 2.58 1.01 5,558 1 6 13.33
INDEX /oradata/ORCL/datafile/index04.dbf 12,025 3 2.46 1.01 4,668 1 2 0.00
INDEX /oradata/ORCL/datafile/index05.dbf 13,106 3 2.35 1.00 4,794 1 13 2.31
INDEX /oradata/ORCL/datafile/index06.dbf 11,913 3 2.51 1.00 4,314 1 3 13.33
INDEX /oradata/ORCL/datafile/index07.dbf 11,943 3 2.42 1.00 4,856 1 9 14.44
SYSAUX /oradata/ORCL/datafile/o1_mf_sysaux_84nbb7v4_.dbf 61 0 6.07 1.16 352 0 0 0.00
SYSTEM /oradata/ORCL/datafile/o1_mf_system_84nb97qc_.dbf 247 0 8.02 3.28 71 0 5 8.00
UNDOTBS1 /oradata/ORCL/datafile/o1_mf_undotbs1_84nb9stw_.dbf 3 0 0.00 1.00 1,280 0 6 0.00
UNDOTBS2 /oradata/ORCL/datafile/o1_mf_undotbs2_84nbc2gd_.dbf 3 0 0.00 1.00 3 0 3 3.33
USERS /oradata/ORCL/datafile/user01.dbf 31,629 7 2.74 3.87 2,951 1 1,212 1.62
USERS /oradata/ORCL/datafile/user02.dbf 33,433 7 2.61 3.62 2,726 1 529 2.17
USERS /oradata/ORCL/datafile/user03.dbf 37,478 8 2.51 3.48 3,109 1 759 1.48
USERS /oradata/ORCL/datafile/user04.dbf 36,163 8 2.52 3.39 1,743 0 817 1.35
USERS /oradata/ORCL/datafile/user05.dbf 36,673 8 2.48 3.34 2,461 1 751 1.46
USERS /oradata/ORCL/datafile/user06.dbf 34,404 7 2.51 3.43 2,111 0 989 1.79
USERS /oradata/ORCL/datafile/user07.dbf 30,663 7 2.73 3.97 2,548 1 875 2.07

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 857,340 100 256,166,763 945,998 62,018 0 0 6,007


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 1866 7836 40457 737280 40457  
E 0 0 2093 23857 48732 737280 48732  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 1,376 0.10 85,140 5.67 5,352,356,666
D 2,752 0.20 170,280 2.59 2,439,409,796
D 4,128 0.30 255,420 1.46 1,382,158,190
D 5,504 0.40 340,560 1.14 1,079,861,984
D 6,880 0.50 425,700 1.05 992,475,335
D 8,256 0.60 510,840 1.02 963,882,996
D 9,632 0.70 595,980 1.01 953,357,715
D 11,008 0.79 681,120 1.01 948,634,430
D 12,384 0.89 766,260 1.00 945,831,872
D 13,760 0.99 851,400 1.00 943,791,018
D 13,856 1.00 857,340 1.00 943,676,769
D 15,136 1.09 936,540 1.00 942,154,838
D 16,512 1.19 1,021,680 1.00 940,769,491
D 17,888 1.29 1,106,820 1.00 939,502,456
D 19,264 1.39 1,191,960 0.99 938,104,408
D 20,640 1.49 1,277,100 0.99 935,981,106
D 22,016 1.59 1,362,240 0.99 931,875,923
D 23,392 1.69 1,447,380 0.98 923,759,329
D 24,768 1.79 1,532,520 0.96 909,427,961
D 26,144 1.89 1,617,660 0.94 883,914,193
D 27,520 1.99 1,702,800 0.89 837,468,806

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 7,720 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 6,351 5,253 881.63 0.00 0.00 0.00 0.00 650,340
E 6,351 5,102 1,148.37 1.08 0.09 100.00 0.00 650,340

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 2,137,366 2,137,366 0 0
64K 128K 466 466 0 0
128K 256K 102 102 0 0
256K 512K 28 28 0 0
512K 1024K 2,829 2,829 0 0
1M 2M 56 56 0 0
2M 4M 13 13 0 0
4M 8M 37 37 0 0
8M 16M 69 69 0 0
16M 32M 5 5 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
794 0.13 21,131,526.94 1,947,635.85 92.00 843
1,588 0.25 21,131,526.94 72,470.33 100.00 1
3,176 0.50 21,131,526.94 69,976.75 100.00 0
4,763 0.75 21,131,526.94 69,976.75 100.00 0
6,351 1.00 21,131,526.94 26,104.88 100.00 0
7,621 1.20 21,131,526.94 11,501.36 100.00 0
8,891 1.40 21,131,526.94 11,501.36 100.00 0
10,162 1.60 21,131,526.94 11,501.36 100.00 0
11,432 1.80 21,131,526.94 11,501.36 100.00 0
12,702 2.00 21,131,526.94 11,501.36 100.00 0
19,053 3.00 21,131,526.94 11,501.36 100.00 0
25,404 4.00 21,131,526.94 11,501.36 100.00 0
38,106 6.00 21,131,526.94 11,501.36 100.00 0
50,808 8.00 21,131,526.94 11,501.36 100.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
3,296 0.20 1,981 115,548 18,108,860 0.94 1,939,168 2.82 2,857,121,802
4,976 0.30 3,642 151,561 18,663,984 0.96 1,384,044 2.01 2,857,642,033
6,656 0.40 5,317 206,326 18,978,455 0.98 1,069,573 1.55 2,857,912,567
8,336 0.50 6,995 252,994 19,104,337 0.99 943,691 1.37 2,858,039,835
10,016 0.60 8,673 295,835 19,161,367 0.99 886,661 1.29 2,858,118,340
11,696 0.70 10,350 333,513 19,200,521 0.99 847,507 1.23 2,858,184,333
13,376 0.80 12,026 364,623 19,241,012 0.99 807,016 1.17 2,858,247,669
15,056 0.90 13,703 397,171 19,294,336 1.00 753,692 1.10 2,858,325,533
16,736 1.00 15,381 431,829 19,360,174 1.00 687,854 1.00 2,858,412,633
18,416 1.10 17,059 468,082 19,442,788 1.00 605,240 0.88 2,858,526,514
20,096 1.20 18,736 502,080 19,510,984 1.01 537,044 0.78 2,858,625,705
21,776 1.30 20,414 535,890 19,570,612 1.01 477,416 0.69 2,858,714,471
23,456 1.40 22,092 573,510 19,607,550 1.01 440,478 0.64 2,858,779,326
25,136 1.50 23,770 605,887 19,632,121 1.01 415,907 0.60 2,858,826,510
26,816 1.60 25,448 638,062 19,649,241 1.01 398,787 0.58 2,858,859,386
28,496 1.70 27,125 673,460 19,662,148 1.02 385,880 0.56 2,858,883,218
30,176 1.80 28,803 706,036 19,676,765 1.02 371,263 0.54 2,858,901,732
31,856 1.90 30,482 739,060 19,685,669 1.02 362,359 0.53 2,858,919,262
33,536 2.00 33,536 886,043 19,693,969 1.02 354,059 0.51 2,858,936,262

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
7,680 0.25 11,626,120 1,353,231,884
15,360 0.50 9,693,314 971,703,537
23,040 0.75 9,432,496 943,676,349
30,720 1.00 9,151,542 943,676,349
38,400 1.25 9,033,493 933,390,277
46,080 1.50 8,983,160 926,029,601
53,760 1.75 8,773,589 819,866,012
61,440 2.00 8,727,832 819,866,012

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
32 0.29 4 105 2 1.00 687,854 1.00 105
48 0.43 4 105 2 1.00 687,854 1.00 105
64 0.57 4 105 2 1.00 687,854 1.00 105
80 0.71 4 105 2 1.00 687,854 1.00 105
96 0.86 4 105 2 1.00 687,854 1.00 105
112 1.00 4 105 2 1.00 687,854 1.00 105
128 1.14 4 105 2 1.00 687,854 1.00 105
144 1.29 4 105 2 1.00 687,854 1.00 105
160 1.43 4 105 2 1.00 687,854 1.00 105
176 1.57 4 105 2 1.00 687,854 1.00 105
192 1.71 4 105 2 1.00 687,854 1.00 105
208 1.86 4 105 2 1.00 687,854 1.00 105
224 2.00 4 105 2 1.00 687,854 1.00 105
240 2.14 4 105 2 1.00 687,854 1.00 105

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 5,996 11 2
1st level bmb 2 0 30
undo header 8 0 1
undo block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
SQ-Sequence Cache 124 124 0 41 56,564 1,379,612.20
WF-AWR Flush 25 23 2 17 1 31.35
TM-DML 56,249 56,249 0 612 1 0.84
HW-Segment High Water Mark 1,336 1,336 0 868 0 0.40
PS-PX Process Reservation 475 438 37 169 0 0.51
CF-Controlfile Transaction 10,991 10,991 0 118 0 0.58
TQ-Queue table enqueue (TM contention) 57 57 0 57 0 0.60
TX-Transaction (index contention) 50 50 0 31 0 1.06
FB-Format Block 83 83 0 37 0 0.62
TT-Tablespace 108 108 0 17 0 0.47
TA-Instance Undo 11 11 0 11 0 0.45
DR-Distributed Recovery 3 3 0 3 0 1.00
TX-Transaction (row lock contention) 123 1 0 1 0 3.00
RS-Reclaimable Space (prevent file delete) 18 18 0 6 0 0.33
TD-KTF map table enqueue (KTF dump entries) 6 6 0 6 0 0.33
PI-Remote PX Process Spawn Status 6 6 0 3 0 0.67
WL-Being Written Redo Log 3 3 0 2 0 1.00
MW-MWIN Schedule 3 3 0 3 0 0.33
MR-Media Recovery 1,244 1,244 0 1 0 1.00
AF-Advisor Framework (task serialization) 7 7 0 1 0 0.00
TX-Transaction (allocate ITL entry) 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 5.80 23,287 1,830 29 5760/5760 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
15-Sep 09:22 784 2,952 1,830 29 5,760 0/0 0/0/0/0/0/0
15-Sep 09:12 0 44 1,229 25 5,760 0/0 0/0/0/0/0/0
15-Sep 09:02 5 116 626 23 5,760 0/0 0/0/0/0/0/0
15-Sep 08:52 1,203 4,219 63 24 5,760 0/0 0/0/0/0/0/0
15-Sep 08:42 1,604 5,791 140 6 5,760 0/0 0/0/0/0/0/0
15-Sep 08:32 766 3,367 92 7 5,760 0/0 0/0/0/0/0/0
15-Sep 08:22 789 3,237 107 6 5,760 0/0 0/0/0/0/0/0
15-Sep 08:12 396 2,169 16 4 5,760 0/0 0/0/0/0/0/0
15-Sep 08:02 255 1,392 0 4 5,760 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 db client latch 3,138 0.00   0 0  
ASM network background latch 1 0.00   0 0  
AWR Alerted Metric Element list 30,272 0.00   0 0  
Consistent RBA 18,671 0.00   0 0  
FAL request queue 100 0.00   0 0  
FAL subheap alocation 100 0.00   0 0  
FIB s.o chain latch 92 0.00   0 0  
FOB s.o list latch 1,863 0.00   0 0  
JS broadcast add buf latch 1,072 0.00   0 0  
JS broadcast drop buf latch 1,072 0.00   0 0  
JS broadcast load blnc latch 938 0.00   0 0  
JS queue state obj latch 33,768 0.00   0 0  
JS slv state obj latch 1 0.00   0 0  
KCL gc element parent latch 17,419,979 0.00 0.02 0 3,012 0.03
KJC message pool free list 63,185 0.04 0.00 0 19,017 0.00
KJCT flow control latch 1,015,000 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 1,563 0.00   0 0  
KSXR large replies 204 0.00   0 0  
KTF sga latch 10 0.00   0 1,439 0.00
KWQMN job cache list latch 604 0.00   0 0  
MQL Tracking Latch 0     0 94 0.00
Memory Management Latch 0     0 1,563 0.00
OS process 483 0.00   0 0  
OS process allocation 1,962 0.00   0 0  
OS process: request allocation 367 0.27 0.00 0 0  
PL/SQL warning settings 4,134,700 0.00   0 0  
SGA IO buffer pool latch 45,192 0.00   0 45,192 0.00
SQL memory manager latch 1 0.00   0 1,563 0.00
SQL memory manager workarea list latch 128,842 0.00   0 0  
Shared B-Tree 174 0.00   0 0  
X$KSFQP 33 0.00   0 0  
active checkpoint queue latch 37,757 0.05 0.00 0 0  
active service list 11,055 0.01 0.00 0 3,060 0.00
archive control 265 0.00   0 0  
archive process latch 1,769 0.00   0 0  
begin backup scn array 28 0.00   0 0  
business card 114 0.00   0 0  
cache buffer handles 11,300 0.01 0.00 0 0  
cache buffers chains 523,774,034 0.11 0.00 2 23,701,947 0.01
cache buffers lru chain 1,242,336 0.02 0.00 0 75,899,643 0.03
cache table scan latch 0     0 45,171 0.00
channel handle pool latch 376 0.27 0.00 0 0  
channel operations parent latch 241,533 0.01 0.00 0 0  
checkpoint queue latch 1,080,781 0.00 0.00 0 78,911 0.00
client/application info 46,882 0.00   0 0  
commit callback allocation 88 0.00   0 0  
compile environment latch 336 0.00   0 0  
dml lock allocation 112,594 0.02 0.00 0 0  
dummy allocation 597 0.00   0 0  
enqueue hash chains 488,175 0.02 0.00 0 67,674 0.00
enqueues 284,531 0.02 0.02 0 0  
error message lists 257 0.00   0 0  
event group latch 222 0.45 0.00 0 0  
file cache latch 529 0.00   0 0  
gcs opaque info freelist 8,358,562 0.06 0.00 0 0  
gcs partitioned table hash 43,997,730 0.00   0 712,623 0.00
gcs remaster request queue 6 0.00   0 0  
gcs remastering latch 4,657,551 0.00 4.50 0 0  
gcs resource freelist 2,523,534 0.04 0.00 0 1,336,940 0.12
gcs resource hash 20,835,594 0.06 0.00 0 1,879 0.00
gcs resource scan list 3,758 0.00   0 0  
gcs shadows freelist 5,198,850 0.00 0.00 0 5,073,610 0.00
ges caches resource lists 262,448 0.05 0.00 0 228,905 0.03
ges deadlock list 3,130 0.00   0 5 0.00
ges domain table 1,022,389 0.00 0.00 0 0  
ges enqueue table freelist 1,162,139 0.00 0.00 0 0  
ges group table 1,521,141 0.00 0.00 0 0  
ges process hash list 13,028 0.01 0.00 0 3 0.00
ges process parent latch 2,428,991 0.00 0.00 0 208,776 0.00
ges process table freelist 367 0.27 0.00 0 0  
ges resource hash list 1,884,824 0.06 0.01 0 383,055 0.00
ges resource scan list 144 0.00   0 0  
ges resource table freelist 177,132 0.00 0.00 0 0  
ges synchronous data 128 0.78 0.00 0 112,307 0.00
ges timeout list 1,320 0.00   0 3,017 0.00
global KZLD latch for mem in SGA 206 0.00   0 0  
global ctx hash table latch 958,126 0.00   0 0  
hash table column usage latch 703 0.00   0 518,031 0.00
hash table modification latch 173 0.00   0 0  
job workq parent latch 0     0 2 0.00
job_queue_processes parameter latch 79 0.00   0 0  
kks stats 223,330 0.02 0.02 0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 638 0.00   0 0  
krbmrosl 105 0.00   0 0  
ksuosstats global area 315 0.00   0 0  
ktm global data 14 0.00   0 0  
kwqbsn:qsga 174 0.00   0 0  
lgwr LWN SCN 18,993 0.04 0.00 0 0  
library cache 24,368,812 0.57 0.98 32982 1,242,111 10.00
library cache load lock 184 0.00   0 0  
library cache lock 2,457,214 0.01 0.01 0 0  
library cache lock allocation 6,003 0.00   0 0  
library cache pin 14,387,494 0.04 0.00 0 0  
library cache pin allocation 3,099 0.00   0 0  
list of block allocation 4,049 0.00   0 0  
loader state object freelist 44 0.00   0 0  
longop free list parent 25 0.00   0 25 0.00
message pool operations parent latch 1,254 0.00   0 0  
messages 343,930 0.04 0.00 0 0  
mostly latch-free SCN 19,114 0.45 0.00 0 0  
multiblock read objects 169,834 0.00 0.00 0 0  
name-service memory objects 27,986 0.00   0 0  
name-service namespace bucket 52,824 0.00   0 0  
name-service pending queue 17,356 0.00   0 0  
name-service request 2 0.00   0 0  
name-service request queue 66,183 0.00   0 0  
ncodef allocation latch 83 0.00   0 0  
object queue header heap 4,748 0.00   0 21,323 0.00
object queue header operation 3,512,752 0.01 0.64 0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 2,121 0.00   0 0  
parallel query stats 269 0.00   0 0  
parallel txn reco latch 4,521 0.00   0 0  
parameter list 830 0.00   0 0  
parameter table allocation management 622 0.00   0 0  
post/wait queue 42,742 0.07 0.00 0 15,806 0.01
process allocation 38,571 0.00 0.00 0 221 0.45
process group creation 367 0.00   0 0  
process queue 769 0.00   0 0  
process queue reference 18,531 0.00   0 1,512 0.07
qmn state object latch 4 0.00   0 0  
qmn task queue latch 687 0.44 0.00 0 0  
query server freelists 616 0.00   0 0  
query server process 1 0.00   0 0  
queued dump request 19,453 0.00   0 0  
redo allocation 57,053 0.03 0.00 0 577,097 0.05
redo copy 0     0 577,213 0.03
redo writing 97,329 0.02 0.00 0 0  
resmgr group change latch 706 0.00   0 0  
resmgr:active threads 588 0.00   0 0  
resmgr:actses change group 329 0.00   0 0  
resmgr:actses change state 1 0.00   0 0  
resmgr:free threads list 585 0.00   0 0  
resmgr:resource group CPU method 1 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
resmgr:vc list latch 1 0.00   0 0  
row cache objects 100,773,931 2.24 0.21 48405 2,040,366 79.71
rules engine aggregate statistics 5 0.00   0 0  
rules engine rule set statistics 10 0.00   0 0  
sequence cache 322,024 0.03 0.01 0 0  
session allocation 436,435 0.05 0.00 0 0  
session idle bit 1,507,125 0.00 0.00 0 0  
session state list latch 856 0.23 0.00 0 0  
session switching 83 0.00   0 0  
session timer 1,691 0.00   0 0  
shared pool 13,648,370 12.63 0.03 987 0  
shared pool simulator 2,926,644,701 0.00 0.00 0 0  
simulator hash latch 27,994,903 0.00 0.00 0 0  
simulator lru latch 0     0 19,461,142 0.71
slave class 6 0.00   0 0  
slave class create 24 4.17 1.00 0 0  
sort extent pool 131 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
threshold alerts latch 242 0.00   0 0  
transaction allocation 358,873 0.00   0 0  
transaction branch allocation 1,691 0.00   0 0  
undo global data 112,438 0.01 0.00 0 0  
user lock 682 0.15 0.00 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
row cache objects 100,773,931 2,256,862 470,631 1,978,068 0 0 0
shared pool 13,648,370 1,724,326 43,113 1,687,431 0 0 0
cache buffers chains 523,774,034 576,661 1,343 575,345 0 0 0
library cache 24,368,812 139,695 136,207 107,607 0 0 0
gcs resource hash 20,835,594 12,855 10 12,847 0 0 0
shared pool simulator 2,926,644,701 6,226 19 6,207 0 0 0
library cache pin 14,387,494 5,822 2 5,820 0 0 0
ges resource hash list 1,884,824 1,210 18 1,192 0 0 0
KCL gc element parent latch 17,419,979 615 12 603 0 0 0
library cache lock 2,457,214 271 3 268 0 0 0
object queue header operation 3,512,752 222 143 101 0 0 0
sequence cache 322,024 84 1 83 0 0 0
enqueues 284,531 64 1 63 0 0 0
kks stats 223,330 44 1 43 0 0 0
gcs remastering latch 4,657,551 8 36 5 0 0 0
slave class create 24 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclnfndnewm 0 7 2
KCL gc element parent latch kclrwrite 0 6 0
KCL gc element parent latch kclbla 0 4 0
KCL gc element parent latch kclnfnd 0 2 4
KCL gc element parent latch kclulb 0 1 4
cache buffers chains kcbgtcr: kslbegin excl 0 2,085 2,141
cache buffers chains kcbrls: kslbegin 0 1,302 1,384
cache buffers chains kclcls_3 0 84 0
cache buffers chains kclexpand 0 48 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 22 12
cache buffers chains kclwrt 0 17 0
cache buffers chains kclobj_1 0 13 0
cache buffers chains kcbzib: multi-block read: nowait 0 12 0
cache buffers chains kcbgtcr: fast path 0 7 0
cache buffers chains kcbzgb: scan from tail. nowait 0 5 0
cache buffers chains kcbgcur: kslbegin 0 2 2
cache buffers chains kcbnew: new latch again 0 2 0
cache buffers chains kcbbxsv 0 1 16
cache buffers chains kcbget: pin buffer 0 1 2
cache buffers chains kcbzib: finish free bufs 0 1 1
cache buffers chains kcbzwb 0 1 24
cache buffers chains kclbla 0 1 0
enqueues ksqgel: create enqueue 0 1 0
gcs remastering latch 59 0 35 0
gcs remastering latch 43 0 3 0
gcs resource hash kjbrdrmcvtq_98 0 4 3
gcs resource hash kjblocalfile_nolock 0 3 0
gcs resource hash kjbopen:affinity 0 3 4
ges resource hash list kjakcai: search for resp by resname 0 7 1
ges resource hash list kjlrlr: remove lock from resource queue 0 5 8
ges resource hash list kjrmas1: lookup master node 0 3 0
ges resource hash list kjucvl: lock convert request 0 2 6
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 1 0
kks stats kks stats alloc/free 0 1 1
library cache kglpndl: child: after processing 0 282 28
library cache kglpnp: child 0 216 360
library cache kgldti: 2child 0 107 191
library cache kglpndl: child: before processing 0 71 568
library cache kglukp: child 0 50 65
library cache kglLockCursor 0 48 105
library cache kglpin 0 38 84
library cache kglobpn: child: 0 36 192
library cache kglget: unpin heap 0 0 24 14
library cache kglhdgn: child: 0 10 116
library cache kglati 0 4 2
library cache kglhdgc: child: 0 3 1
library cache kglScanDependency 0 2 0
library cache lock kgllkdl: child: no lock handle 0 48 60
library cache lock kgllkdl: child: cleanup 0 2 0
library cache lock ksucallcbksafely: kqllhng 0 2 0
library cache lock kgllkal: child: multiinstance 0 1 3
library cache pin kglpndl 0 1 1
library cache pin kglpnp: child 0 1 1
object queue header operation kclobj_1 0 148 100
object queue header operation kcbo_switch_q_bg 0 2 17
object queue header operation kcbo_switch_mq_bg 0 1 6
object queue header operation kcbw_link_q 0 1 3
object queue header operation kcbw_unlink_q_bg 0 1 4
object queue header operation kclobj_3 0 1 5
row cache objects kqrbip 0 3,523 22,538
row cache objects kqreqd: reget 0 407 4,091
row cache objects kqrso 0 372 13,755
row cache objects kqrpre: find obj 0 218 7,462
row cache objects kqreqd 0 92 4,012
row cache objects kqrigt 0 31 472
row cache objects kqrbtm: pop parent 0 1 0
row cache objects ksucallcbksafely: kqrhngc 0 1 0
sequence cache kdnssd 0 1 0
shared pool kghfrunp: clatch: wait 0 562,981 552,478
shared pool kghfrunp: alloc: wait 0 40,547 40,438
shared pool kghfrunp: clatch: nowait 0 38,030 0
shared pool kghfre 0 1,511 275
shared pool kghalo 0 832 1,570
shared pool kghupr1 0 181 690
shared pool kghalp 0 37 127
shared pool kghasp 0 5 4
shared pool simulator kglsim_unpin_simhp 0 18 0
shared pool simulator kglsim_unpin_simhp: fast path 0 1 15
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
AHSIMIS USERS OD11   TABLE 90,673,088 35.36
AHSIMIS USERS AB14H   TABLE 68,913,552 26.88
AHSIMIS USERS AC01   TABLE 33,667,152 13.13
AHSIMIS USERS OA20   TABLE 14,831,024 5.78
AHSIMIS USERS IC40H   TABLE 9,515,424 3.71

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
AHSIMIS USERS AB14H   TABLE 413,431 43.70
AHSIMIS USERS AB14   TABLE 142,104 15.02
AHSIMIS USERS IC40H   TABLE 75,299 7.96
AHSIMIS USERS KC24   TABLE 40,711 4.30
AHSIMIS USERS AB09   TABLE 39,182 4.14

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
AHSIMIS USERS IC40   TABLE 244 82.99
AHSIMIS INDEX IDX_KC21_OAE001   INDEX 6 2.04
AHSIMIS INDEX IDX_KC22_OAE001   INDEX 6 2.04
AHSIMIS INDEX IDX_KC22_OAE300   INDEX 4 1.36
AHSIMIS INDEX INDEX_KC21_AAE036   INDEX 4 1.36

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
AHSIMIS INDEX IDX_IC40_OAE300   INDEX 1 100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
AHSIMIS USERS AZ01B   TABLE 12 38.71
AHSIMIS USERS KC22   TABLE 4 12.90
AHSIMIS INDEX IDX_KC24_OAE300   INDEX 3 9.68
AHSIMIS INDEX IDX_KC04_OAE300   INDEX 2 6.45
AHSIMIS INDEX IDX_KC23_OAE001   INDEX 2 6.45

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
AHSIMIS USERS AB14H   TABLE 5,754 98.90
AHSIMIS INDEX IDX_KC24_OAE001   INDEX 12 0.21
AHSIMIS INDEX IDX_KC24_OAE300   INDEX 11 0.19
AHSIMIS USERS KB31   TABLE 8 0.14
AHSIMIS USERS OD11   TABLE 6 0.10

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
AHSIMIS USERS KC22   TABLE 9,001 34.15
AHSIMIS USERS KC24   TABLE 3,263 12.38
AHSIMIS USERS KC04   TABLE 1,377 5.22
AHSIMIS USERS KC21   TABLE 1,161 4.40
AHSIMIS USERS OD11   TABLE 989 3.75

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
AHSIMIS USERS AB14H   TABLE 400,512 76.30
AHSIMIS USERS KC24   TABLE 29,556 5.63
AHSIMIS USERS KC70   TABLE 27,418 5.22
AHSIMIS USERS AC04H   TABLE 9,542 1.82
AHSIMIS USERS KC20   TABLE 8,148 1.55

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 59 1.69 0   1 1
dc_database_links 423 0.00 0   0 1
dc_files 288 0.00 0   0 18
dc_global_oids 5,575 0.02 0   0 419
dc_histogram_data 2,178,950 0.00 0   0 15,607
dc_histogram_defs 1,199,961 0.00 0   0 11,329
dc_object_grants 8,838 0.20 0   0 7,054
dc_object_ids 5,480,675 0.00 0   0 7,189
dc_objects 392,333 0.01 0   0 7,923
dc_profiles 207 0.00 0   0 1
dc_rollback_segments 12,712 0.62 0   0 413
dc_segments 608,364 0.00 0   31 12,818
dc_sequences 1,598 23.34 0   1,598 30
dc_tablespace_quotas 1 0.00 0   1 1
dc_tablespaces 109,882 0.00 0   0 8
dc_usernames 4,488,161 0.00 0   0 76
dc_users 27,413,562 0.00 0   0 101
outstanding_alerts 100 66.00 0   5 19

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 3 1 0
dc_global_oids 1 0 23
dc_histogram_defs 38 0 159,079
dc_object_ids 12 0 3
dc_objects 27 0 4,792
dc_rollback_segments 80 79 0
dc_segments 77 5 1,778
dc_sequences 3,166 376 3
dc_tablespace_quotas 2 2 0
outstanding_alerts 179 60 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 478 0.00 3,284,702 0.00 1 0
CLUSTER 39 0.00 64 0.00 0 0
INDEX 8 0.00 33 0.00 0 0
SQL AREA 97,265 63.24 17,778,231 0.50 633 14
TABLE/PROCEDURE 6,594 0.08 3,599,888 0.00 66 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 64 0 0 0 0
INDEX 33 0 14 0 0
TABLE/PROCEDURE 79,247 5 17 4 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 778.60   5.73 11.46 110 232 136 136
  Freeable 83.88 0.00 1.18 1.06 6   71 71
  SQL 12.37 7.17 0.11 0.12 0 41 111 105
  PL/SQL 6.83 3.13 0.05 0.08 1 1 134 133
E Other 974.46   4.62 9.70 113 232 211 211
  Freeable 122.94 0.00 1.07 0.97 6   115 115
  SQL 22.44 12.96 0.12 0.12 1 41 186 173
  PL/SQL 16.71 5.24 0.08 0.10 1 1 209 207

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 14,529,069,056  
Fixed Size 2,143,032  
Redo Buffers 14,630,912  
Variable Size 17,666,411,720  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 106.16 106.16 0.00
java joxlod exec hp 5.65 5.65 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared CCursor 1,394.47 1,337.92 -4.06
shared KQR L PO 200.66   -100.00
shared PCursor 945.13 927.50 -1.87
shared free memory 2,229.16 2,576.62 15.59
shared library cache 502.79 487.84 -2.97
shared sql area 10,318.58 10,260.79 -0.56
  buffer_cache 13,856.00 13,856.00 0.00
  fixed_sga 2.04 2.04 0.00
  log_buffer 13.95 13.95 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 494,060 811,077 994920 994920
gcs_shadows 605,410 893,677 994920 994920
sessions 225 582 665 665


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_ksb_disable_diagpid TRUE   
audit_file_dest /opt/oracle/app/ora10g/admin/orcl/adump   
background_dump_dest /opt/oracle/app/ora10g/admin/orcl/bdump   
cluster_database TRUE   
cluster_database_instances 2   
cluster_interconnects 192.168.2.1   
compatible 10.2.0.3.0   
control_files /oradata/ORCL/controlfile/o1_mf_84nb90pd_.ctl   
core_dump_dest /opt/oracle/app/ora10g/admin/orcl/cdump   
db_block_size 16384   
db_create_file_dest /oradata   
db_domain      
db_file_multiblock_read_count 16   
db_name orcl   
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)   
dml_locks 6000   
instance_number 1   
job_queue_processes 10   
local_listener ORCL1   
log_archive_dest /arch   
nls_language SIMPLIFIED CHINESE   
nls_territory CHINA   
open_cursors 6000   
pga_aggregate_target 6659506176   
processes 600   
remote_listener LISTENERS_ORCL   
remote_login_passwordfile EXCLUSIVE   
sessions 665   
sga_max_size 32212254720   
sga_target 32212254720   
shared_pool_size 17179869184   
spfile /oradata/ORCL/spfileorcl.ora   
thread 1   
undo_management AUTO   
undo_retention 10800   
undo_tablespace UNDOTBS1   
user_dump_dest /opt/oracle/app/ora10g/admin/orcl/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 8,677 1.85 0.38
acks for commit broadcast(logical) 10,147 2.16 0.44
broadcast msgs on commit(actual) 18,628 3.97 0.82
broadcast msgs on commit(logical) 18,675 3.98 0.82
broadcast msgs on commit(wasted) 3,315 0.71 0.15
broadcast on commit wait time(ms) 4,308 0.92 0.19
broadcast on commit waits 15,805 3.37 0.69
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 3 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 55 0.01 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 3,738,106 797.22 163.66
gcs ast xid 2 0.00 0.00
gcs blocked converts 26,882 5.73 1.18
gcs blocked cr converts 31,990 6.82 1.40
gcs compatible basts 545 0.12 0.02
gcs compatible cr basts (global) 1,189 0.25 0.05
gcs compatible cr basts (local) 4,152,748 885.65 181.82
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 6,684 1.43 0.29
gcs dbwr write request msgs 4,528 0.97 0.20
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 5,201 1.11 0.23
gcs immediate (null) converts 379,646 80.97 16.62
gcs immediate cr (compatible) converts 10 0.00 0.00
gcs immediate cr (null) converts 1,278,771 272.72 55.99
gcs indirect ast 85,545 18.24 3.75
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 1,052 0.22 0.05
gcs msgs process time(ms) 726,772 155.00 31.82
gcs msgs received 11,362,703 2,423.30 497.49
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 690 0.15 0.03
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 4 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 46 0.01 0.00
gcs side channel msgs actual 0 0.00 0.00
gcs side channel msgs logical 0 0.00 0.00
gcs stale cr 0 0.00 0.00
gcs undo cr 72 0.02 0.00
gcs write notification msgs 783 0.17 0.03
gcs writes refused 37 0.01 0.00
ges msgs process time(ms) 474 0.10 0.02
ges msgs received 29,631 6.32 1.30
global posts dropped 0 0.00 0.00
global posts queue time 4 0.00 0.00
global posts queued 28 0.01 0.00
global posts requested 28 0.01 0.00
global posts sent 28 0.01 0.00
implicit batch messages received 325,445 69.41 14.25
implicit batch messages sent 31,914 6.81 1.40
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 22,689 4.84 0.99
messages queue sent actual 122,209 26.06 5.35
messages queue sent logical 294,128 62.73 12.88
messages received actual 1,313,283 280.08 57.50
messages received logical 11,392,543 2,429.66 498.80
messages sent directly 197,920 42.21 8.67
messages sent indirectly 337,555 71.99 14.78
messages sent not implicit batched 90,296 19.26 3.95
messages sent pbatched 1,695,215 361.53 74.22
msgs causing lmd to send msgs 11,952 2.55 0.52
msgs causing lms(s) to send msgs 139,519 29.75 6.11
msgs received queue time (ms) 275,353 58.72 12.06
msgs received queued 11,392,246 2,429.60 498.78
msgs sent queue time (ms) 8,599 1.83 0.38
msgs sent queue time on ksxp (ms) 33,491 7.14 1.47
msgs sent queued 293,845 62.67 12.87
msgs sent queued on ksxp 513,331 109.48 22.48
process batch messages received 663,686 141.54 29.06
process batch messages sent 214,960 45.84 9.41


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 25,915
CURRENT Block Requests 1,053
Data Block Requests 25,915
Undo Block Requests 72
TX Block Requests 596
Current Results 26,518
Private results 106
Zero Results 344
Disk Read Results 0
Fail Results 0
Fairness Down Converts 5,446
Fairness Clears 0
Free GC Elements 0
Flushes 131
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 175
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 5,223,548 100.00 0.00 0.00 0.00 0.00
Flushes 228 88.60 9.21 1.75 0.44 0.00
Writes 7,165 84.82 13.37 0.50 0.20 1.12


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 24,491 99.04 0.47 0.48 524,296 77.88 0.10 22.01
2 Others 965 99.27 0.73 0.00 609 100.00 0.00 0.00
2 undo header 792 98.86 1.14 0.00 26 96.15 3.85 0.00
2 undo block 121 93.39 6.61 0.00 0      


Back to Top

End of Report