WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
NFSNNC779052898nfsnnc1110.2.0.4.0YESnfsn1

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:2913109-Dec-13 10:00:27189 7.9
End Snap:2913209-Dec-13 11:00:36174 7.4
Elapsed:  60.14 (mins)  
DB Time:  354.96 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 15,040M 15,040MStd Block Size: 8K
Shared Pool Size: 3,104M 3,104MLog Buffer: 14,308K

Load Profile

Per SecondPer Transaction
Redo size: 92,911.28 10,018.89
Logical reads: 154,019.78 16,608.40
Block changes: 507.04 54.68
Physical reads: 1,537.69 165.81
Physical writes: 42.40 4.57
User calls: 1,126.24 121.45
Parses: 288.55 31.11
Hard parses: 68.85 7.42
Sorts: 71.68 7.73
Logons: 2.01 0.22
Executes: 373.37 40.26
Transactions: 9.27 

% Blocks changed per Read: 0.33Recursive Call %: 45.24
Rollback per transaction %: 11.71Rows per Sort: 86.09

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.80Redo NoWait %: 100.00
Buffer Hit %: 99.01In-memory Sort %: 100.00
Library Hit %: 79.67Soft Parse %: 76.14
Execute to Parse %: 22.72Latch Hit %: 99.53
Parse CPU to Parse Elapsd %: 76.53% Non-Parse CPU: 86.75

Shared Pool Statistics

BeginEnd
Memory Usage %: 93.70 93.31
% SQL with executions>1: 52.82 52.31
% Memory for SQL w/exec>1: 44.12 41.87

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  11,529  54.1 
db file sequential read 3,888,687 6,104 2 28.7User I/O
gc current block 2-way 2,353,662 1,069 0 5.0Cluster
gc buffer busy 1,015,804 945 1 4.4Cluster
gc cr grant 2-way 1,794,771 663 0 3.1Cluster

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 1,835.24 197.90
Global Cache blocks served: 986.24 106.35
GCS/GES messages received: 3,258.88 351.41
GCS/GES messages sent: 4,962.63 535.13
DBWR Fusion writes: 5.97 0.64
Estd Interconnect traffic (KB) 24,177.60 

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

Buffer access - local cache %: 97.82
Buffer access - remote cache %: 1.19
Buffer access - disk %: 0.99

Global Cache and Enqueue Services - Workload Characteristics

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.3
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 36.47
% of indirect sent messages: 62.78
% of flow controlled messages: 0.75

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 19,202.58 90.16
DB CPU 11,529.27 54.13
parse time elapsed 2,064.38 9.69
hard parse elapsed time 1,952.95 9.17
connection management call elapsed time 18.56 0.09
PL/SQL execution elapsed time 7.15 0.03
hard parse (sharing criteria) elapsed time 3.00 0.01
hard parse (bind mismatch) elapsed time 2.12 0.01
repeated bind elapsed time 2.05 0.01
PL/SQL compilation elapsed time 0.45 0.00
failed parse elapsed time 0.28 0.00
sequence load elapsed time 0.04 0.00
DB time 21,297.53  
background elapsed time 1,021.24  
background cpu time 920.80  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 4,113,885 0.00 6,714 2 122.95
Cluster 8,587,597 0.02 3,370 0 256.64
Concurrency 373,180 0.31 223 1 11.15
Other 872,302 85.78 170 0 26.07
System I/O 166,085 0.00 101 1 4.96
Network 3,401,672 0.00 46 0 101.66
Commit 34,291 0.00 31 1 1.02
Application 13,280 0.02 17 1 0.40
Configuration 3,476 90.28 0 0 0.10

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 3,888,687 0.00 6,104 2 116.22
gc current block 2-way 2,353,662 0.00 1,069 0 70.34
gc buffer busy 1,015,804 0.00 945 1 30.36
gc cr grant 2-way 1,794,771 0.00 663 0 53.64
gc cr multi block request 3,261,207 0.00 579 0 97.46
db file scattered read 108,226 0.00 385 4 3.23
library cache lock 135,530 0.00 185 1 4.05
read by other session 90,126 0.00 151 2 2.69
cr request retry 286 99.30 90 314 0.01
db file parallel read 18,641 0.00 70 4 0.56
gc cr block 2-way 107,329 0.00 53 0 3.21
gcs drm freeze in enter server mode 136 44.12 48 356 0.00
SQL*Net more data from client 51,493 0.00 42 1 1.54
log file parallel write 49,251 0.00 34 1 1.47
log file sync 34,291 0.00 31 1 1.02
control file sequential read 97,112 0.00 30 0 2.90
gc current grant busy 20,655 0.00 23 1 0.62
db file parallel write 16,423 0.00 23 1 0.49
row cache lock 44,732 0.00 15 0 1.34
cursor: pin S wait on X 1,165 98.03 11 10 0.03
SQL*Net break/reset to client 11,660 0.00 10 1 0.35
gc current grant 2-way 22,517 0.00 9 0 0.67
gc cr block busy 5,895 0.00 9 2 0.18
log file sequential read 798 0.00 8 10 0.02
enq: TX - row lock contention 184 1.09 7 40 0.01
gc remaster 121 0.00 7 60 0.00
latch: cache buffers chains 180,058 0.00 6 0 5.38
gc current block busy 738 0.00 6 7 0.02
kksfbc child completion 88 98.86 4 48 0.00
CGS wait for IPC msg 697,839 99.89 4 0 20.86
gcs log flush sync 7,891 22.72 4 0 0.24
latch: shared pool 3,825 0.00 4 1 0.11
latch: object queue header operation 10,666 0.00 3 0 0.32
Log archive I/O 797 0.00 3 4 0.02
direct path read 4,224 0.00 3 1 0.13
DFS lock handle 5,836 0.00 3 0 0.17
SQL*Net message to client 3,264,011 0.00 2 0 97.55
gc cr grant congested 847 0.00 2 3 0.03
gc current block congested 693 0.00 2 3 0.02
enq: WF - contention 16 25.00 2 124 0.00
latch free 1,725 0.00 2 1 0.05
library cache pin 4,210 0.00 2 0 0.13
wait for scn ack 3,517 0.00 2 1 0.11
control file parallel write 1,702 0.00 2 1 0.05
SQL*Net more data to client 86,168 0.00 2 0 2.58
reliable message 563 0.00 1 2 0.02
latch: gcs resource hash 28,524 0.00 1 0 0.85
kjbdrmcvtq lmon drm quiesce: ping completion 32 31.25 1 30 0.00
direct path write temp 2,039 0.00 1 0 0.06
direct path read temp 1,774 0.00 1 0 0.05
ksxr poll remote instances 97,995 42.76 1 0 2.93
rdbms ipc reply 3,889 0.00 1 0 0.12
gc object scan 2,142 98.51 1 0 0.06
PX Deq: Signal ACK 343 27.70 1 2 0.01
enq: TM - contention 1,429 0.00 1 0 0.04
enq: TO - contention 1,368 0.00 1 0 0.04
ges global resource directory to be frozen 32 100.00 0 10 0.00
gc cr block congested 50 0.00 0 6 0.00
latch: library cache 297 0.00 0 1 0.01
enq: HW - contention 327 0.00 0 1 0.01
buffer busy waits 3,077 0.26 0 0 0.09
IPC send completion sync 543 100.00 0 0 0.02
enq: PS - contention 397 0.00 0 0 0.01
name-service call wait 3 0.00 0 56 0.00
os thread startup 6 0.00 0 27 0.00
gc cr failure 279 0.00 0 0 0.01
gc current multi block request 592 0.00 0 0 0.02
latch: cache buffers lru chain 145 0.00 0 1 0.00
enq: FB - contention 244 0.00 0 0 0.01
log file switch completion 5 0.00 0 18 0.00
LGWR wait for redo copy 2,099 0.00 0 0 0.06
gc current retry 5 0.00 0 17 0.00
enq: TT - contention 216 0.00 0 0 0.01
PX Deq: reap credit 6,419 98.80 0 0 0.19
gc current block unknown 170 0.00 0 0 0.01
direct path write 168 0.00 0 0 0.01
enq: CF - contention 120 0.00 0 0 0.00
gc cr disk read 108 0.00 0 0 0.00
gc current grant congested 12 0.00 0 3 0.00
latch: KCL gc element parent latch 587 0.00 0 0 0.02
PX Deq Credit: send blkd 128 18.75 0 0 0.00
enq: TX - index contention 57 0.00 0 0 0.00
wait list latch free 2 0.00 0 10 0.00
latch: row cache objects 79 0.00 0 0 0.00
enq: TX - contention 8 0.00 0 1 0.00
latch: ges resource hash list 261 0.00 0 0 0.01
enq: TA - contention 24 0.00 0 0 0.00
latch: session allocation 229 0.00 0 0 0.01
undo segment extension 3,140 99.94 0 0 0.09
enq: US - contention 14 0.00 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 69 0.00 0 0 0.00
log file single write 2 0.00 0 1 0.00
ges inquiry response 4 0.00 0 0 0.00
enq: TX - allocate ITL entry 4 0.00 0 0 0.00
enq: RO - fast object reuse 4 0.00 0 0 0.00
enq: UL - contention 1 0.00 0 1 0.00
KJC: Wait for msg sends to complete 19 0.00 0 0 0.00
cursor: mutex S 127 0.00 0 0 0.00
enq: JS - job run lock - synchronize 1 0.00 0 0 0.00
enq: WL - contention 1 0.00 0 0 0.00
enq: PW - flush prewarm buffers 2 0.00 0 0 0.00
enq: PI - contention 1 0.00 0 0 0.00
cursor: pin S 17 0.00 0 0 0.00
latch: messages 1 0.00 0 0 0.00
latch: library cache lock 1 0.00 0 0 0.00
cursor: mutex X 16 0.00 0 0 0.00
lock escalate retry 4 100.00 0 0 0.00
SQL*Net message from client 3,264,022 0.00 295,386 90 97.55
gcs remote message 7,332,682 98.78 27,429 4 219.14
PX Idle Wait 1,727 83.03 3,816 2210 0.05
class slave wait 34 82.35 3,550 104409 0.00
virtual circuit status 121 100.00 3,524 29122 0.00
DIAG idle wait 18,031 0.00 3,523 195 0.54
Streams AQ: qmn coordinator idle wait 292 43.84 3,522 12060 0.01
Streams AQ: qmn slave idle wait 131 0.00 3,522 26883 0.00
ASM background timer 728 0.00 3,516 4830 0.02
Streams AQ: waiting for messages in the queue 372 100.00 3,515 9450 0.01
ges remote message 321,721 78.05 3,512 11 9.61
Streams AQ: waiting for time management or cleanup tasks 12 100.00 3,471 289290 0.00
jobq slave wait 40 100.00 117 2930 0.00
PX Deq: Execution Msg 1,536 21.88 1 0 0.05
PX Deq: Execute Reply 199 5.03 0 2 0.01
PX Deq: Join ACK 287 32.40 0 1 0.01
PX Deq: Parse Reply 299 33.78 0 0 0.01
KSV master wait 4 0.00 0 15 0.00
PX Deq: Msg Fragment 336 30.36 0 0 0.01
Streams AQ: RAC qmn coordinator idle wait 295 97.97 0 0 0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 49,248 0.00 34 1 1.47
db file parallel write 16,423 0.00 23 1 0.49
events in waitclass Other 834,958 88.75 19 0 24.95
db file scattered read 2,545 0.00 10 4 0.08
log file sequential read 798 0.00 8 10 0.02
control file sequential read 9,728 0.00 3 0 0.29
Log archive I/O 797 0.00 3 4 0.02
db file sequential read 2,053 0.00 3 1 0.06
gc cr multi block request 3,044 0.00 2 1 0.09
control file parallel write 1,702 0.00 2 1 0.05
gc object scan 2,142 98.51 1 0 0.06
enq: TM - contention 1,403 0.00 1 0 0.04
db file parallel read 106 0.00 1 5 0.00
gc current block 2-way 756 0.00 0 1 0.02
gc current grant 2-way 860 0.00 0 0 0.03
os thread startup 6 0.00 0 27 0.00
row cache lock 417 0.00 0 0 0.01
gc cr grant 2-way 207 0.00 0 0 0.01
buffer busy waits 537 1.49 0 0 0.02
library cache lock 92 0.00 0 0 0.00
gc cr block 2-way 36 0.00 0 1 0.00
latch: cache buffers chains 80 0.00 0 0 0.00
latch: library cache 4 0.00 0 1 0.00
latch: shared pool 27 0.00 0 0 0.00
log file single write 2 0.00 0 1 0.00
library cache pin 3 0.00 0 1 0.00
direct path write 40 0.00 0 0 0.00
gc cr grant congested 1 0.00 0 2 0.00
enq: RO - fast object reuse 4 0.00 0 0 0.00
gc current multi block request 8 0.00 0 0 0.00
latch: row cache objects 5 0.00 0 0 0.00
direct path read 40 0.00 0 0 0.00
enq: PW - flush prewarm buffers 1 0.00 -0 -0 0.00
rdbms ipc message 230,788 30.83 59,553 258 6.90
gcs remote message 7,332,515 98.78 27,429 4 219.14
class slave wait 32 87.50 3,550 110934 0.00
DIAG idle wait 18,030 0.00 3,522 195 0.54
Streams AQ: qmn coordinator idle wait 292 43.84 3,522 12060 0.01
Streams AQ: qmn slave idle wait 131 0.00 3,522 26883 0.00
pmon timer 1,959 98.26 3,520 1797 0.06
ASM background timer 728 0.00 3,516 4830 0.02
ges remote message 321,711 78.05 3,512 11 9.61
smon timer 10,812 6.73 3,498 324 0.32
Streams AQ: waiting for time management or cleanup tasks 12 100.00 3,471 289290 0.00
KSV master wait 4 0.00 0 15 0.00
PX Deq: Parse Reply 30 40.00 0 1 0.00
PX Deq: Join ACK 30 40.00 0 1 0.00
PX Deq: Execute Reply 26 34.62 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 295 97.97 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 46,012
AVG_IDLE_TIME 314,540
AVG_IOWAIT_TIME 16,420
AVG_SYS_TIME 9,132
AVG_USER_TIME 36,757
BUSY_TIME 1,476,061
IDLE_TIME 10,068,825
IOWAIT_TIME 529,275
SYS_TIME 296,018
USER_TIME 1,180,043
LOAD 0
OS_CPU_WAIT_TIME 1,368,500
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 66,303,557,632
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
nfsnnc 21,274.40 11,516.50 5,503,748 556,336,301
SYS$USERS 34.40 23.30 294 38,774
SYS$BACKGROUND 0.00 0.00 42,886 310,962
nfsnncXDB 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
nfsnnc 4108230 669916 367370 22066 0 0 3363342 4619
SYS$USERS 294 57 847 75 0 0 10440 2
SYS$BACKGROUND 5545 1463 4956 152 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
1,948 1,925 3,940 0.49 9.15 cd2zjpv26y5wh   select a.pk_messageinfo, a.se...
210 78 10 20.97 0.98 0guwtdwjmtp8v   select ccheckitemid from qc_ch...
178 58 3,932 0.05 0.84 9539rk3kwp5b5   select a.pk_checkflow, a.pk_b...
112 26 1 111.53 0.52 bwq4c63ng4j09   select distinct B.cinvbasid, ...
103 66 5,735 0.02 0.48 cn1gtsav2d5jh   BEGIN BEGIN IF (xdb.DBMS...
88 77 11,471 0.01 0.41 78m9ryygp65v5   SELECT /*+ ALL_ROWS */ COUNT(*...
78 31 11 7.05 0.36 52jdn4b137x70   SELECT DISTINCT head.burgency,...
52 50 150 0.35 0.24 2hzd2sxpmj4mx   SELECT NFSN_FUNC_002(NULL, :B...
48 41 1,435 0.03 0.23 cxscp7btdg0ya   select templateflag, template...
40 39 2 20.24 0.19 4j8y1zt1xbu0w   call nfsn_proc_dailyfund ( 105...

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,925 1,948 3,940 0.49 9.15 cd2zjpv26y5wh   select a.pk_messageinfo, a.se...
78 210 10 7.76 0.98 0guwtdwjmtp8v   select ccheckitemid from qc_ch...
77 88 11,471 0.01 0.41 78m9ryygp65v5   SELECT /*+ ALL_ROWS */ COUNT(*...
66 103 5,735 0.01 0.48 cn1gtsav2d5jh   BEGIN BEGIN IF (xdb.DBMS...
58 178 3,932 0.01 0.84 9539rk3kwp5b5   select a.pk_checkflow, a.pk_b...
50 52 150 0.33 0.24 2hzd2sxpmj4mx   SELECT NFSN_FUNC_002(NULL, :B...
41 48 1,435 0.03 0.23 cxscp7btdg0ya   select templateflag, template...
39 40 2 19.65 0.19 4j8y1zt1xbu0w   call nfsn_proc_dailyfund ( 105...
31 78 11 2.80 0.36 52jdn4b137x70   SELECT DISTINCT head.burgency,...
26 112 1 26.15 0.52 bwq4c63ng4j09   select distinct B.cinvbasid, ...

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
84,598,877 3,940 21,471.80 15.22 1925.01 1948.17 cd2zjpv26y5wh   select a.pk_messageinfo, a.se...
3,666,371 525 6,983.56 0.66 11.78 12.86 as02f6azutjwt   select templateflag, template...
3,562,288 1,435 2,482.43 0.64 40.97 48.08 cxscp7btdg0ya   select templateflag, template...
3,431,050 2 1,715,525.00 0.62 39.30 40.47 4j8y1zt1xbu0w   call nfsn_proc_dailyfund ( 105...
2,191,765 3,932 557.42 0.39 58.46 178.21 9539rk3kwp5b5   select a.pk_checkflow, a.pk_b...
1,983,736 150 13,224.91 0.36 49.89 51.78 2hzd2sxpmj4mx   SELECT NFSN_FUNC_002(NULL, :B...
1,628,034 3,933 413.94 0.29 11.12 11.93 36rfh2zq85qax   select a.pk_messageinfo, a.se...
1,397,408 1 1,397,408.00 0.25 8.26 21.01 gpxg3p8snws57   SELECT DISTINCT zb.vouchid, z...
1,261,434 64 19,709.91 0.23 5.89 11.61 8bd2za131fg0a   SELECT NVL(SUM(A), 0) FROM ( ...
1,258,576 16 78,661.00 0.23 14.57 21.03 aj37st6bd0gyq   begin :n_Return_Number := nfsn...

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
331,671 1 331,671.00 5.98 26.15 111.53 bwq4c63ng4j09   select distinct B.cinvbasid, ...
242,945 10 24,294.50 4.38 77.64 209.74 0guwtdwjmtp8v   select ccheckitemid from qc_ch...
39,567 3,932 10.06 0.71 58.46 178.21 9539rk3kwp5b5   select a.pk_checkflow, a.pk_b...
21,372 1 21,372.00 0.39 8.26 21.01 gpxg3p8snws57   SELECT DISTINCT zb.vouchid, z...
9,532 2 4,766.00 0.17 1.99 20.44 2j8psf2sknsmd   SELECT head.bassetcard, head....
5,978 1 5,978.00 0.11 1.19 13.83 c8kffcg7mg04t   insert into tmp_gl_rsvoucherpk...
5,942 3,940 1.51 0.11 7.77 21.16 1twg5kk5w8uqq   select a.pk_messageinfo, a.se...
5,610 2 2,805.00 0.10 1.32 12.02 16d1bnbqv6tyk   select fin.pk_finindex, fin.b...
3,008 10,166 0.30 0.05 7.26 11.14 db78fxqxwxt7r   select /*+ rule */ bucket, en...
2,374 16 148.38 0.04 14.57 21.03 aj37st6bd0gyq   begin :n_Return_Number := nfsn...

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
14,877 14,877 1.00 0.00 0.00 60uw2vh6q9vn2   insert into col$(obj#, name, i...
13,977 167,336 11.97 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
11,471 11,452 1.00 0.01 0.01 78m9ryygp65v5   SELECT /*+ ALL_ROWS */ COUNT(*...
11,469 11,474 1.00 0.00 0.00 0h2vakcbv7d3m   SELECT USER_ID FROM ALL_USERS ...
11,469 11,473 1.00 0.00 0.00 ayd7gwk0296dt   SELECT COUNT(*) FROM ALL_USERS...
11,186 6,918 0.62 0.00 0.00 1bph5g603jg2k   select 1 from sm_createcorp t1...
10,166 162,385 15.97 0.00 0.00 db78fxqxwxt7r   select /*+ rule */ bucket, en...
8,157 8,157 1.00 0.00 0.00 54qdjfczdqbsd   select bd_currtype.pk_currtype...
6,974 13,966 2.00 0.00 0.00 0k8522rmdzg4k   select privilege# from sysauth...
6,970 6,956 1.00 0.00 0.00 5ur69atw3vfhj   select decode(failover_method,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
13,944 13,977 1.34 0h6b2sajwb74n   select privilege#, level from ...
8,157 8,157 0.78 54qdjfczdqbsd   select bd_currtype.pk_currtype...
6,968 6,974 0.67 0k8522rmdzg4k   select privilege# from sysauth...
6,949 6,970 0.67 5ur69atw3vfhj   select decode(failover_method,...
6,943 6,969 0.67 459f3z9u4fb3u   select value$ from props$ wher...
6,924 6,969 0.67 0ws7ahf1d78qa   select SYS_CONTEXT('USERENV', ...
6,142 6,142 0.59 grwydz59pu6mc   select text from view$ where r...
5,748 5,990 0.55 b6vxaxdx93w36   select configflag, operator, ...
5,727 5,737 0.55 bdv0rkkssq2jm exp.exe SELECT count(*) FROM user_poli...
5,726 11,471 0.55 78m9ryygp65v5   SELECT /*+ ALL_ROWS */ COUNT(*...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,618,356 1 0.05 8hzv9d7uday84   SELECT bd_cubasdoc.pk_cubasdoc...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
48 582 0pmdqu6yjq251   select pk_org, initcode, val...
48 582 0pmdqu6yjq251   select pk_org, initcode, val...

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
69.71 33.24 209.74 77.64 10 0guwtdwjmtp8v   select ccheckitemid from qc_ch...
58.60 75.54 77.57 30.78 11 52jdn4b137x70   SELECT DISTINCT head.burgency,...
47.39 26.59 178.21 58.46 3,932 9539rk3kwp5b5   select a.pk_checkflow, a.pk_b...
24.70 66.30 37.26 18.10 11 6k420h9q90q18   SELECT DISTINCT head.vbillcode...
23.80 21.34 111.53 26.15 1 bwq4c63ng4j09   select distinct B.cinvbasid, ...
19.81 19.29 102.72 65.84 5,735 cn1gtsav2d5jh   BEGIN BEGIN IF (xdb.DBMS...
18.25 66.56 27.42 13.09 7 2c29xfsw38syh   SELECT DISTINCT head.burgency,...
16.86 19.07 88.37 76.77 11,471 78m9ryygp65v5   SELECT /*+ ALL_ROWS */ COUNT(*...
14.11 70.38 20.04 8.74 4 ff9d4mydufrg3   SELECT DISTINCT head.burgency,...
12.28 75.21 16.32 6.55 2 8mf0whbta05sb   SELECT DISTINCT head.burgency,...
4.20 19.98 21.01 8.26 1 gpxg3p8snws57   SELECT DISTINCT zb.vouchid, z...
2.91 14.23 20.44 1.99 2 2j8psf2sknsmd   SELECT head.bassetcard, head....
2.49 22.49 11.09 9.75 14,877 60uw2vh6q9vn2   insert into col$(obj#, name, i...
1.92 9.11 21.03 14.57 16 aj37st6bd0gyq   begin :n_Return_Number := nfsn...
1.70 55.72 3.06 2.80 5,737 bdv0rkkssq2jm exp.exe SELECT count(*) FROM user_poli...
1.49 7.02 21.16 7.77 3,940 1twg5kk5w8uqq   select a.pk_messageinfo, a.se...
1.42 12.71 11.14 7.26 10,166 db78fxqxwxt7r   select /*+ rule */ bucket, en...
1.27 33.89 3.76 3.70 5,240 04xtrk7uyhknh   select obj#, type#, ctime, mti...
1.17 2.25 51.78 49.89 150 2hzd2sxpmj4mx   SELECT NFSN_FUNC_002(NULL, :B...
1.13 9.37 12.02 1.32 2 16d1bnbqv6tyk   select fin.pk_finindex, fin.b...
1.12 59.24 1.90 1.72 5,736 fy9ta5zgkwqmp   SELECT count(*) FROM user_poli...
1.09 7.85 13.83 1.19 1 c8kffcg7mg04t   insert into tmp_gl_rsvoucherpk...
1.07 4.41 24.35 23.18 25 d4632xbngx6gs   select distinct fbm_baseinfo.p...
0.81 6.94 11.61 5.89 64 8bd2za131fg0a   SELECT NVL(SUM(A), 0) FROM ( ...
0.72 60.51 1.19 1.13 823 cqgv56fmuj63x   select owner#, name, namespace...
0.53 66.40 0.79 0.79 323 0zht1pujthavs   SELECT hostID, ip, port, se...
0.52 32.01 1.64 1.50 2,564 83taa7kaw59c1   select name, intcol#, segcol#,...
0.52 62.39 0.83 0.82 823 8swypbbr0m372   select order#, columns, types ...
0.39 39.85 0.98 0.96 3,515 5ngzsfstg8tmy   select o.owner#, o.name, o.nam...
0.37 10.73 3.40 2.26 1,854 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
0.36 3.21 11.12 9.68 582 0pmdqu6yjq251   select pk_org, initcode, val...
0.35 36.88 0.94 0.94 6,142 grwydz59pu6mc   select text from view$ where r...
0.24 14.06 1.71 1.26 1,006 1gu8t96d0bdmu   select t.ts#, t.file#, t.block...
0.19 3.69 5.06 4.37 2 7a7wgrxc8uzu8   SELECT ic_general_h.cgeneralhi...
0.16 68.57 0.24 0.24 569 7nuw4xwrnuwxq   select col#, intcol#, toid, ve...
0.11 5.22 2.05 1.98 4 b2gg09hzxsuq9   select mean.doperatdate, mean...
0.09 0.70 12.86 11.78 525 as02f6azutjwt   select templateflag, template...
0.08 5.63 1.35 1.35 11,469 0h2vakcbv7d3m   SELECT USER_ID FROM ALL_USERS ...
0.07 0.00 1,948.17 1,925.01 3,940 cd2zjpv26y5wh   select a.pk_messageinfo, a.se...
0.07 0.16 40.47 39.30 2 4j8y1zt1xbu0w   call nfsn_proc_dailyfund ( 105...
0.05 0.38 11.93 11.12 3,933 36rfh2zq85qax   select a.pk_messageinfo, a.se...
0.04 2.26 1.69 1.64 3 5946tm5jwn68n   select mean.doperatdate, mean...
0.03 3.13 1.10 1.10 11,469 ayd7gwk0296dt   SELECT COUNT(*) FROM ALL_USERS...
0.03 1.92 1.62 1.59 1 b8gv77h3fb5c1   select mean.doperatdate, mean...
0.03 0.22 12.91 12.75 42 bj7xs3yz6g3uk   select pk, path, creator, i...
0.02 6.79 0.35 0.19 3 8vkjh60z1g287   select OBJOID, CLSOID, RUNT...
0.02 0.15 13.42 13.23 35 2v4vycrkk1qtm   select distinct bankdoccode, ...
0.02 0.07 27.01 23.41 1,309 8swc03d362v74   select vmainlicense, vpairlic...
0.02 0.86 2.12 2.12 5,845 ds9csubu4dvns   SELECT * FROM pub_billbusiness...
0.02 0.23 7.64 6.90 132 9cakzhc23v156   select procmsg from tmp_bill_p...
0.01 1.70 0.85 0.82 5,990 b6vxaxdx93w36   select configflag, operator, ...
0.01 20.07 0.07 0.04 44 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...
0.01 19.02 0.07 0.04 44 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
0.01 0.71 1.66 1.61 1 b7uay8bnq0d6b   select mean.doperatdate, mean...
0.01 0.02 48.08 40.97 1,435 cxscp7btdg0ya   select templateflag, template...
0.01 12.26 0.08 0.01 2 2sh8mhgm91t44   insert into ic_general_b ( bba...
0.01 22.37 0.04 0.02 44 c6awqs517jpj0   select /*+ index(idl_char$ i_i...
0.01 1.35 0.63 0.62 5,927 8x6qfz2r732hw   select finishflag from pub_bil...
0.01 0.32 2.52 2.52 6,018 10u35nm4prs0p   select pk_busiclass, pk_corp,...
0.01 18.37 0.04 0.04 34 b1wc53ddd6h3p   select audit$, options from pr...
0.01 6.63 0.10 0.07 4 5b90h22g346sh   select clb.clbh, clb.clb_oid,...
0.01 25.30 0.02 0.02 6 6ck819rxkrsqb   insert into sm_operatelog ( cl...
0.01 15.57 0.03 0.03 2 32vaydynfcwkq   insert into ic_general_b ( bba...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0guwtdwjmtp8vselect ccheckitemid from qc_checkbill_b1 where ccheckitemid = :1 and dr = 0
0h2vakcbv7d3mSELECT USER_ID FROM ALL_USERS WHERE USERNAME = :B1
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0pmdqu6yjq251select pk_org, initcode, value, pkvalue from pub_sysinit where pk_org = :1
0ws7ahf1d78qaselect SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0zht1pujthavsSELECT hostID, ip, port, servername, activetime, activeStatus, loadWeight FROM qdi_host ORDER BY activetime desc
10u35nm4prs0pselect pk_busiclass, pk_corp, pk_billtype, actiontype, pk_businesstype, isbefore, classname, ts, dr from pub_busiclass where isbefore = :1 and pk_billtype = :2 and actiontype = :3 and pk_businesstype = :4
16d1bnbqv6tykselect fin.pk_finindex, fin.billcode, fin.pk_sys, fin.pk_proc, fin.pk_busitype, fin.businame, fin.busidate, fin.operator, fin.checker, rt.prepared, fin.pk_corp, fin.flag, fin.currency, fin.money, fin.dapcomment, fin.settlemode, fin.docnum, fin.docdate, fin.pk_vouchentry, fin.deltag, fin.sign, fin.pk_mergebatch, fin.mergebatchcode, fin.errmsg, fin.checkstate, fin.pk_rtvouch, bt.billtypename, fin.procmsg, oper.user_name, ch.user_name, pre.user_name, cur.currtypename, fin.destsystem, rt.assino, fin.pk_glorg, fin.pk_glbook from dap_finindex fin left outer join dap_rtvouch rt on fin.pk_rtvouch = rt.pk_voucher left outer join bd_billtype bt on fin.pk_proc = bt.pk_billtypecode left outer join sm_user oper on fin.operator = oper.cuserid left outer join sm_user ch on fin.checker = ch.cuserid left outer join sm_user pre on rt.prepared = pre.cuserid left outer join bd_currtype cur on fin.currency = cur.pk_currtype where flag = 2 and fin.pk_glorg = '0001891000000001S2FA' and fin.pk_glbook = '0001AA10000000004VTQ' and ( ( pk_sys = 'IA' and pk_proc = 'I2' ) ) and fin.busidate >= '2013-12-01' and fin.currency = '00010000000000000001' and fin.busidate <= '2013-12-09' and fin.destsystem = 0 order by fin.billcode
1bph5g603jg2kselect 1 from sm_createcorp t1, sm_codetocode t2 where t1.pk_corp = :1 and t2.pk_codetocode = :2 and t1.funccode = t2.funccode
1gu8t96d0bdmuselect t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1twg5kk5w8uqqselect a.pk_messageinfo, a.senderman, b.user_name, a.checkman, a.pk_corp, a.type, a.state, a.url, a.title, a.content, a.senddate, a.priority, a.dealdate, a.billid, a.billno, a.pk_billtype, a.pk_srcbilltype, a.pk_busitype, a.actiontype, a.titlecolor from pub_messageinfo a left outer join sm_user b on a.senderman = b.cuserid where ( checkman = :1 and a.type in ( 0, 10 ) ) and ( a.receivedeleteflag is null or a.receivedeleteflag = 'N' ) and a.state = 0 order by senddate desc
2c29xfsw38syh SELECT DISTINCT head.burgency, head.capproverid, head.cbilltypecode, head.clastoperatorid, head.coperator, head.crequireappid, head.dapplydate, head.dauditdate, head.freqtypeflag, head.fstatusflag, head.iprintcount, head.pk_corp, head.pk_hdefdoc1, head.pk_hdefdoc10, head.pk_hdefdoc11, head.pk_hdefdoc12, head.pk_hdefdoc13, head.pk_hdefdoc14, head.pk_hdefdoc15, head.pk_hdefdoc16, head.pk_hdefdoc17, head.pk_hdefdoc18, head.pk_hdefdoc19, head.pk_hdefdoc2, head.pk_hdefdoc20, head.pk_hdefdoc3, head.pk_hdefdoc4, head.pk_hdefdoc5, head.pk_hdefdoc6, head.pk_hdefdoc7, head.pk_hdefdoc8, head.pk_hdefdoc9, head.taudittime, head.tlastmaketime, head.tmaketime, head.ts, head.vbillcode, head.vhdef1, head.vhdef10, head.vhdef11, head.vhdef12, head.vhdef13, head.vhdef14, head.vhdef15, head.vhdef16, head.vhdef17, head.vhdef18, head.vhdef19, head.vhdef2, head.vhdef20, head.vhdef3, head.vhdef4, head.vhdef5, head.vhdef6, head.vhdef7, head.vhdef8, head.vhdef9, head.vmemo FROM po_requireapp head INNER JOIN po_requireapp_b body ON ( head.crequireappid = body.crequireappid and body.dr = 0 ) LEFT OUTER JOIN po_requireapp_b body2 ON body2.csourcebid2 = '422X' and body2.csourcebid2 = body.crequireapp_bid and body2.dr = 0 and body2.creqcalbodyid = body.creqcalbodyid WHERE ( ( head.freqtypeflag = 1 ) and ( head.dapplydate >= '2013-12-04' ) and ( body.creqcalbodyid = '11316510000000000335' ) and ( nvl ( body.bendgather, 'N' ) = 'N' ) ) and ( head.pk _corp = '1131' and head.fstatusflag = 1 AND ( head.freqtypeflag = 0 OR ( head.freqtypeflag = 1 AND nvl( body.csourcetypecode, ' ' ) != '422X' ) ) AND nvl( body.bclose, 'N' ) = 'N' AND nvl( body.naccuoutnum, 0.0 ) < nvl( body.nnum, 0.0 ) AND body2.crequireapp_bid is null )
2hzd2sxpmj4mxSELECT NFSN_FUNC_002(NULL, :B5 , :B4 , :B3 , :B2 , :B1 ) FROM DUAL
2j8psf2sknsmd SELECT head.bassetcard, head.bdirecttranflag, head.boutretflag, head.bsalecooppur, head.cauditorid, head.cbilltypecode, head.cbizid, head.cbiztype, head.ccustomerid, head.cdilivertypeid, head.cdispatcherid, head.cdptid, head.cendreportid, head.cgeneralhid, head.cinventoryid, head.clastmodiid, head.coperatorid, head.cothercalbodyid, head.cothercorpid, head.cotherwhid, head.coutcalbodyid, head.coutcorpid, head.cproviderid, head.cregister, head.csettlepathid, head.ctrancustid, head.cwarehouseid, head.cwastewarehouseid, head.cwhsmanagerid, head.daccountdate, head.dauditdate, head.dbilldate, head.fallocflag, head.fbillflag, head.freplenishflag, head.fspecialflag, head.iprintcount, head.ndiscountmny, head.nnetmny, head.pk_calbody, head.pk_corp, head.pk_cubasdoc, head.pk_cubasdocC, head.pk_defdoc1, head.pk_defdoc10, head.pk_defdoc11, head.pk_defdoc12, head.pk_defdoc13, head.pk_defdoc14, head.pk_defdoc15, head.pk_defdoc16, head.pk_defdoc17, head.pk_defdoc18, head.pk_defdoc19, head.pk_defdoc2, head.pk_defdoc20, head.pk_defdoc3, head.pk_defdoc4, head.pk_defdoc5, head.pk_defdoc6, head.pk_defdoc7, head.pk_defdoc8, head.pk_defdoc9, head.pk_measware, head.pk_purcorp, head.taccounttime, head.tlastmoditime, head.tmaketime, head.ts, head.vbillcode, head.vheadnote2, head.vnote, head.vuserdef1, head.vuserdef10, head.vuserdef11, head.vuserdef12, head.vuserdef13, head.vuserdef14, head.vuserdef15, head.vuserdef16, head .vuserdef17, head.vuserdef18, head.vuserdef19, head.vuserdef2, head.vuserdef20, head.vuserdef3, head.vuserdef4, head.vuserdef5, head.vuserdef6, head.vuserdef7, head.vuserdef8, head.vuserdef9 FROM ic_general_h head WHERE head.dr = 0 AND head.cbilltypecode = '45' and head.cproviderid = '00016510000000076OU7' and head.pk_corp = '1103' and ( 1 = 1 ) AND ( nvl( freplenishflag, 'N' ) = 'N' and nvl( boutretflag, 'N' ) = 'N' ) AND ( ( head.dbilldate >= '2011-10-01' and head.dbilldate <= '2013-12-09' ) and ( 1 = 1 ) and ( 1 = 1 ) )
2sh8mhgm91t44 insert into ic_general_b ( bbarcodeclose, bonroadflag, breturnprofit, bsafeprice, bsourcelargess, bsupplyflag, btoinzgflag, btoouttoiaflag, btooutzgflag, btou8rm, bzgflag, castunitid, cbodybilltypecode, cbodywarehouseid, ccheckstateid, ccorrespondbid, ccorrespondcode, ccorrespondhid, ccorrespondtype, ccostobject, cfirstbillbid, cfirstbillhid, cfirsttype, cfreezeid, cgeneralbid, cgeneralhid, cinvbasid, cinventoryid, corder_bb1id, cparentid, cprojectid, cprojectphaseid, cquotecurrency, cquoteunitid, creceieveid, creceiveareaid, creceivepointid, crowno, cselastunitid, csignwastbid, csignwasthid, csignwasttype, csourcebillbid, csourcebillhid, csourcetype, csourcewastbid, csourcewasthid, csourcewasttype, csrc2billbid, csrc2billhid, csrc2billtype, csumid, cvendorid, cworkcenterid, cworksiteid, cwp, dbizdate, ddeliverdate, dfirstbilldate, drequiredate, drequiretime, dstandbydate, dzgdate, fbillrowflag, fchecked, flargess, ftoouttransflag, hsl, idesatype, isok, naccumtonum, naccumwastnum, nbarcodenum, ncorrespondastnum, ncorrespondgrsnum, ncorrespondnum, ncountnum, nfeesettletimes, ninassistnum, ningrossnum, ninnum, nkdnum, nmny, nneedinassistnum, noutassistnum, noutgrossnum, noutnum, nplannedmny, nplannedprice, nprice, npricesettlebill, nquotemny, nquotentmny, nquotentprice, nquoteprice, nquoteunitnum, nquoteunitrate, nreplenishedastnum, nreplenishednum, nretastnum, nretnum, nsalemny , nsaleprice, nshouldinnum, nshouldoutassistnum, nshouldoutnum, ntarenum, ntaxmny, ntaxprice, ntranoutastnum, ntranoutnum, pk_bodycalbody, pk_corp, pk_creqwareid, pk_cubasdoc, pk_defdoc1, pk_defdoc10, pk_defdoc11, pk_defdoc12, pk_defdoc13, pk_defdoc14, pk_defdoc15, pk_defdoc16, pk_defdoc17, pk_defdoc18, pk_defdoc19, pk_defdoc2, pk_defdoc20, pk_defdoc3, pk_defdoc4, pk_defdoc5, pk_defdoc6, pk_defdoc7, pk_defdoc8, pk_defdoc9, pk_invoicecorp, pk_measware, pk_packsort, pk_reqcorp, pk_reqstoorg, pk_returnreason, vbatchcode, vbilltypeu8rm, vbodynote2, vcorrespondrowno, vfirstbillcode, vfirstrowno, vfree1, vfree10, vfree2, vfree3, vfree4, vfree5, vfree6, vfree7, vfree8, vfree9, vnotebody, vproductbatch, vreceiveaddress, vsignwastcode, vsignwastrowno, vsourcebillcode, vsourcerowno, vsourcewastcode, vsourcewastrowno, vsrc2billcode, vsrc2billrowno, vtransfercode, vuserdef1, vuserdef10, vuserdef11, vuserdef12, vuserdef13, vuserdef14, vuserdef15, vuserdef16, vuserdef17, vuserdef18, vuserdef19, vuserdef2, vuserdef20, vuserdef3, vuserdef4, vuserdef5, vuserdef6, vuserdef7, vuserdef8, vuserdef9, vvehiclecode , ts) 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, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190 , '2013-12-09 10:41:17')
2v4vycrkk1qtmselect distinct bankdoccode, bankdocname, amcode, pk_bankdoc from v_fbm_bankdoc where 11 = 11 order by bankdoccode
32vaydynfcwkq insert into ic_general_b ( bbarcodeclose, bonroadflag, breturnprofit, bsafeprice, bsourcelargess, bsupplyflag, btoinzgflag, btoouttoiaflag, btooutzgflag, btou8rm, bzgflag, castunitid, cbodybilltypecode, cbodywarehouseid, ccheckstateid, ccorrespondbid, ccorrespondcode, ccorrespondhid, ccorrespondtype, ccostobject, cfirstbillbid, cfirstbillhid, cfirsttype, cfreezeid, cgeneralbid, cgeneralhid, cinvbasid, cinventoryid, corder_bb1id, cparentid, cprojectid, cprojectphaseid, cquotecurrency, cquoteunitid, creceieveid, creceiveareaid, creceivepointid, crowno, cselastunitid, csignwastbid, csignwasthid, csignwasttype, csourcebillbid, csourcebillhid, csourcetype, csourcewastbid, csourcewasthid, csourcewasttype, csrc2billbid, csrc2billhid, csrc2billtype, csumid, cvendorid, cworkcenterid, cworksiteid, cwp, dbizdate, ddeliverdate, dfirstbilldate, drequiredate, drequiretime, dstandbydate, dzgdate, fbillrowflag, fchecked, flargess, ftoouttransflag, hsl, idesatype, isok, naccumtonum, naccumwastnum, nbarcodenum, ncorrespondastnum, ncorrespondgrsnum, ncorrespondnum, ncountnum, nfeesettletimes, ninassistnum, ningrossnum, ninnum, nkdnum, nmny, nneedinassistnum, noutassistnum, noutgrossnum, noutnum, nplannedmny, nplannedprice, nprice, npricesettlebill, nquotemny, nquotentmny, nquotentprice, nquoteprice, nquoteunitnum, nquoteunitrate, nreplenishedastnum, nreplenishednum, nretastnum, nretnum, nsalemny , nsaleprice, nshouldinnum, nshouldoutassistnum, nshouldoutnum, ntarenum, ntaxmny, ntaxprice, ntranoutastnum, ntranoutnum, pk_bodycalbody, pk_corp, pk_creqwareid, pk_cubasdoc, pk_defdoc1, pk_defdoc10, pk_defdoc11, pk_defdoc12, pk_defdoc13, pk_defdoc14, pk_defdoc15, pk_defdoc16, pk_defdoc17, pk_defdoc18, pk_defdoc19, pk_defdoc2, pk_defdoc20, pk_defdoc3, pk_defdoc4, pk_defdoc5, pk_defdoc6, pk_defdoc7, pk_defdoc8, pk_defdoc9, pk_invoicecorp, pk_measware, pk_packsort, pk_reqcorp, pk_reqstoorg, pk_returnreason, vbatchcode, vbilltypeu8rm, vbodynote2, vcorrespondrowno, vfirstbillcode, vfirstrowno, vfree1, vfree10, vfree2, vfree3, vfree4, vfree5, vfree6, vfree7, vfree8, vfree9, vnotebody, vproductbatch, vreceiveaddress, vsignwastcode, vsignwastrowno, vsourcebillcode, vsourcerowno, vsourcewastcode, vsourcewastrowno, vsrc2billcode, vsrc2billrowno, vtransfercode, vuserdef1, vuserdef10, vuserdef11, vuserdef12, vuserdef13, vuserdef14, vuserdef15, vuserdef16, vuserdef17, vuserdef18, vuserdef19, vuserdef2, vuserdef20, vuserdef3, vuserdef4, vuserdef5, vuserdef6, vuserdef7, vuserdef8, vuserdef9, vvehiclecode , ts) 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, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179, :180, :181, :182, :183, :184, :185, :186, :187, :188, :189, :190 , '2013-12-09 10:47:44')
36rfh2zq85qaxselect a.pk_messageinfo, a.senderman, b.user_name, a.checkman, a.pk_corp, a.type, a.state, a.url, a.title, a.content, a.senddate, a.priority, a.dealdate, a.billid, a.billno, a.pk_billtype, a.pk_srcbilltype, a.pk_busitype, a.actiontype, a.titlecolor from pub_messageinfo a left outer join sm_user b on a.senderman = b.cuserid where checkman = :1 and ( a.type in ( 3, 4, 5, 6 ) ) and ( a.receivedeleteflag is null or a.receivedeleteflag = 'N' ) and a.state = 0 order by senddate desc
459f3z9u4fb3uselect value$ from props$ where name = 'GLOBAL_DB_NAME'
4j8y1zt1xbu0wcall nfsn_proc_dailyfund ( 1052, '2013-12-05', 'N', '1036G4100000000084GZ' )
52jdn4b137x70 SELECT DISTINCT head.burgency, head.capproverid, head.cbilltypecode, head.clastoperatorid, head.coperator, head.crequireappid, head.dapplydate, head.dauditdate, head.freqtypeflag, head.fstatusflag, head.iprintcount, head.pk_corp, head.pk_hdefdoc1, head.pk_hdefdoc10, head.pk_hdefdoc11, head.pk_hdefdoc12, head.pk_hdefdoc13, head.pk_hdefdoc14, head.pk_hdefdoc15, head.pk_hdefdoc16, head.pk_hdefdoc17, head.pk_hdefdoc18, head.pk_hdefdoc19, head.pk_hdefdoc2, head.pk_hdefdoc20, head.pk_hdefdoc3, head.pk_hdefdoc4, head.pk_hdefdoc5, head.pk_hdefdoc6, head.pk_hdefdoc7, head.pk_hdefdoc8, head.pk_hdefdoc9, head.taudittime, head.tlastmaketime, head.tmaketime, head.ts, head.vbillcode, head.vhdef1, head.vhdef10, head.vhdef11, head.vhdef12, head.vhdef13, head.vhdef14, head.vhdef15, head.vhdef16, head.vhdef17, head.vhdef18, head.vhdef19, head.vhdef2, head.vhdef20, head.vhdef3, head.vhdef4, head.vhdef5, head.vhdef6, head.vhdef7, head.vhdef8, head.vhdef9, head.vmemo FROM po_requireapp head INNER JOIN po_requireapp_b body ON ( head.crequireappid = body.crequireappid and body.dr = 0 ) LEFT OUTER JOIN po_requireapp_b body2 ON body2.csourcebid2 = '422X' and body2.csourcebid2 = body.crequireapp_bid and body2.dr = 0 and body2.creqcalbodyid = body.creqcalbodyid WHERE ( ( head.freqtypeflag = 1 ) and ( head.dapplydate >= '2013-11-01' ) and ( nvl ( body.bendgather, 'N' ) = 'N' ) ) and ( head.pk_corp = '1029' and head.fstatusflag = 1 AND ( head.f reqtypeflag = 0 OR ( head.freqtypeflag = 1 AND nvl( body.csourcetypecode, ' ' ) != '422X' ) ) AND nvl( body.bclose, 'N' ) = 'N' AND nvl( body.naccuoutnum, 0.0 ) < nvl( body.nnum, 0.0 ) AND body2.crequireapp_bid is null )
54qdjfczdqbsdselect bd_currtype.pk_currtype, bd_currtype.currtypename from bd_currtype where bd_currtype.pk_currtype in ( '00010000000000000001' )
5946tm5jwn68n select mean.doperatdate, mean.pk_busitype, busitype.businame, mean.cponderid, mean.ccustomerid, cubasdockh.custname ccustomername, mean.cinvoicecustid, cubasdockpkh.custname cinvoicecustname, mean.pk_org, salestru.vsalestruname orgname, salepreorder.careaflowid, defdocqylx.docname careaflowname, salepreorder.ccementflowid, defdocsnlx.docname ccementflowname, mean.pk_defdoc16, defdockslx.docname custtypename, mean.cinventoryid, invbasdoc.invcode cinvbasdocname, invbasdoc.invname cinventoryname, mean.nsuttle, mean.vcarnumber, mean.vbatchnumber, mean.vsaleorderid, salepreorder.bstaticflg, mean.norigtaxprice, mean.norigsummny, decode ( nvl ( nsuttle, 0 ), 0, null, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) ) /nsuttle ) norignetprice, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) ) noutafternum, mean.noutnum, mean.ntransprice, mean.ntransmny, mean.nwaitfreight, mean.ntotalinvoicenum, mean.nalreadytrannum, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) + nvl ( mean.ntransmny, 0 ) ) norigtaxmny, mean.cdeptid, deptdoc.deptname cdeptname, mean.cemployeeid, psndoc.psnname cemployeename, mean.cconsigncorpid, bdcorp.unitname cconsigncorpname, mean.creceiveaddressid, areacl.areaclname creceiveaddressname, mean.ctruecustomerid, cubasdocjbr.custname ctruecustomername, salepreorder.vnote, mean.ctransporttypeid, sendtype.sendname ctransporttypename, mean.ctransitcorpid, cubasdocysdw.custname ctransitco rpname, salepreorder.vbillno, mean.pk_so_meannc, salepreorderb.pk_saledispose_b, salepreorder.pk_saledispose_h, mean.vdef1, mean.vdef2, mean.vdef3, mean.vdef4, mean.vdef5, mean.vdef6, mean.vdef7, mean.vdef8, mean.vdef9, mean.vdef10, mean.vdef11, mean.vdef12, mean.vdef13, mean.vdef14, mean.vdef15, mean.vdef16, mean.vdef17, mean.vdef18, mean.vdef19, mean.vdef20, salepreorderb.nnum nordernum from so_meannc mean inner join so_salepreorder_b salepreorderb on mean.pk_saledispose_b = salepreorderb.pk_saledispose_b inner join so_salepreorder salepreorder on salepreorderb.pk_saledispose_h = salepreorder.pk_saledispose_h left outer join bd_busitype busitype on mean.pk_busitype = busitype.pk_busitype left outer join bd_cumandoc cumandockh on mean.ccustomerid = cumandockh.pk_cumandoc left outer join bd_cubasdoc cubasdockh on cumandockh.pk_cubasdoc = cubasdockh.pk_cubasdoc left outer join bd_cumandoc cumandockpkh on mean.cinvoicecustid = cumandockpkh.pk_cumandoc left outer join bd_cubasdoc cubasdockpkh on cumandockpkh.pk_cubasdoc = cubasdockpkh.pk_cubasdoc left outer join bd_salestru salestru on mean.pk_org = salestru.csalestruid left outer join bd_defdoc defdocqylx on salepreorder.careaflowid = defdocqylx.pk_defdoc left outer join bd_defdoc defdocsnlx on salepreorder.ccementflowid = defdocsnlx.pk_defdoc left outer join bd_defdoc defdockslx on mean.pk_defdoc16 = defdockslx.pk_defdoc left outer join bd_invmandoc invmandoc on invmandoc.pk_invmandoc = mean.cinventory id left outer join bd_invbasdoc invbasdoc on invbasdoc.pk_invbasdoc = invmandoc.pk_invbasdoc left outer join bd_deptdoc deptdoc on mean.cdeptid = deptdoc.pk_deptdoc left outer join bd_psndoc psndoc on mean.cemployeeid = psndoc.pk_psndoc left outer join bd_corp bdcorp on mean.cconsigncorpid = bdcorp.pk_corp left outer join bd_areacl areacl on mean.creceiveaddressid = areacl.pk_areacl left outer join bd_cumandoc cumandocjbr on mean.ctruecustomerid = cumandocjbr.pk_cumandoc left outer join bd_cubasdoc cubasdocjbr on cumandocjbr.pk_cubasdoc = cubasdocjbr.pk_cubasdoc left outer join bd_sendtype sendtype on sendtype.pk_sendtype = mean.ctransporttypeid left outer join bd_cubasdoc cubasdocysdw on cubasdocysdw.pk_cubasdoc = mean.ctransitcorpid where ( mean.doperatdate >= '2013-12-09' ) and ( mean.doperatdate <= '2013-12-09' ) and mean.dr = 0 and mean.pk_corp = '1181'
5b90h22g346sh select clb.clbh, clb.clb_oid, clb.vouchid, clb.fb_oid, clb.clbz, clb.clrq, clb.clnd, clb.clqj, clb.hxbh, clb.xydqr, clb.clr, clb.jfclybje, clb.jfclfbje, clb.jfclbbje, clb.jfclshl, clb.dfclybje, clb.dfclfbje, clb.dfclbbje, clb.dfclshl, fb.accountid, fb.szxmid, fb.wldx, fb.xgbh, fb.fx, fb.zy, fb.kmbm, fb.hbbm, fb.bzbm, fb.bbhl, fb.fbhl, fb.jobphaseid, fb.jobid, fb.deptid, fb.ywybm, fb.jfybje, fb.jffbje, fb.jfbbje, fb.jfshl, fb.ybye, fb.fbye, fb.bbye, fb.shlye, fb.jfybsj, fb.jffbsj, fb.jfbbsj, fb.jfybwsje, fb.chbm_cl, fb.dj, fb.sl, fb.fkyhmc, fb.dfyhzh, fb.skyhmc, fb.bfyhzh, fb.zyx1 fb_zyx1, fb.zyx2 fb_zyx2, fb.zyx3 fb_zyx3, fb.zyx4 fb_zyx4, fb.zyx5 fb_zyx5, fb.zyx6 fb_zyx6, fb.zyx7 fb_zyx7, fb.zyx8 fb_zyx8, fb.zyx9 fb_zyx9, fb.zyx10 fb_zyx10, fb.zyx11 fb_zyx11, fb.zyx12 fb_zyx12, fb.zyx13 fb_zyx13, fb.zyx14 fb_zyx14, fb.zyx15 fb_zyx15, fb.zyx16 fb_zyx16, fb.zyx17 fb_zyx17, fb.zyx18 fb_zyx18, fb.zyx19 fb_zyx19, fb.zyx20 fb_zyx20, fb.htbh, fb.ddh, fb.fph, fb.wbfybje, fb.wbffbje, fb.wbfbbje, fb.dfybje, fb.dffbje, fb.dfbbje, fb.dfshl, fb.dfybsj, fb.dffbsj, fb.dfbbsj, fb.dfybwsje, fb.sfkxyh, fb.tax_num, fb.bz_date, fb.bz_kjnd, fb.bz_kjqj, fb.dfbbwsje, fb.hsdj, fb.kslb, zb.prepay, zb.ddhbbm, zb.dwbm, zb.djbh, zb.djlxbm, zb.djrq, zb.pzglh, zb.qcbz, zb.lybz, zb.djzt, zb.lrr, zb.shr, zb.shrq, zb.xslxbm, zb.ybje, zb.fbje, zb.bbje, zb.zyx1, zb.zyx2, zb.zyx3, zb.zyx4, zb.zyx5 , zb.zyx6, zb.zyx7, zb.zyx8, zb.zyx9, zb.zyx10, zb.zyx11, zb.zyx12, zb.zyx13, zb.zyx14, zb.zyx15, zb.zyx16, zb.zyx17, zb.zyx18, zb.zyx19, zb.zyx20, zb.djkjnd, zb.djkjqj, zb.shkjnd, zb.shkjqj, zb.hzbz, zb.sfkr, zb.kmbm zb_kmbm, zb.qrr, zb.yhqrr, zb.scomment, zb.djdl, zb.fj, zb.pj_jsfs, fb.cinventoryid, invbas.pk_invcl, fb.hbbm, fb.notetype, clb.dydjdl, fb.ordercusmandoc, fb.productline, fb.othersysflag, fb.xm, fb.xmys, fb.task, fb.Ph, fb.Xyzh, fb.Cksqsh, fb.ddlx, fb.Ddhh, fb.Jsfsbm, fb.xmbm2, clb.fkxyb_oid, clb.hxbbhl, clb.hxfbhl, clb.dydjzbid, clb.dydjfbid, clb.clid, zb.isselectedpay, zb.zgyf, fb.zrdeptid, fb.qxrq, fb.isSFKXYChanged, zb.zyx21, zb.zyx22, zb.zyx23, zb.zyx24, zb.zyx25, zb.zyx26, zb.zyx27, zb.zyx28, zb.zyx29, zb.zyx30, zb.payman, zb.paydate, fb.zyx21, fb.zyx22, fb.zyx23, fb.zyx24, fb.zyx25, fb.zyx26, fb.zyx27, fb.zyx28, fb.zyx29, fb.zyx30, fb.payflag, fb.bjdwwsdj, fb.isverifyfinished, fb.ckdh, fb.ckdid, fb.ddhid, fb.fphid, fb.encode, fb.clbh, fb.billdate, fb.payman, fb.paydate, fb.verifyfinisheddate, clb.isreserve from arap_djclb clb inner join arap_djfb fb on fb.fb_oid = clb.fb_oid inner join arap_djzb zb on fb.vouchid = zb.vouchid left outer join bd_invbasdoc invbas on fb.cinventoryid = invbas.pk_invbasdoc where clb.clbh = :1 and clb.dr = 0 and fb.dr = 0 and zb.dr = 0 and ( clb.clbz = - 1 or clb.clbz = - 2 or clb.clbz = 0 or clb.clbz = 2 or clb.clbz = 10 )
5ngzsfstg8tmyselect o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
5ur69atw3vfhjselect decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
60uw2vh6q9vn2insert into col$(obj#, name, intcol#, segcol#, type#, length, precision#, scale, null$, offset, fixedstorage, segcollength, deflength, default$, col#, property, charsetid, charsetform, spare1, spare2, spare3)values(:1, :2, :3, :4, :5, :6, decode(:5, 182/*DTYIYM*/, :7, 183/*DTYIDS*/, :7, decode(:7, 0, null, :7)), decode(:5, 2, decode(:8, -127/*MAXSB1MINAL*/, null, :8), 178, :8, 179, :8, 180, :8, 181, :8, 182, :8, 183, :8, 231, :8, null), :9, 0, :10, :11, decode(:12, 0, null, :12), :13, :14, :15, :16, :17, :18, :19, :20)
6ck819rxkrsqbinsert into sm_operatelog ( clogcodeid, companyname, opratorname, operatetype, entersystem, enterfunction, enterbutton, enterip, logintime, logouttime, busitype, billtype, billid, billcode, operatorid, pk_corp, businesslog, enterfunctioncode , ts) values ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18 , '2013-12-09 10:59:48')
6k420h9q90q18SELECT DISTINCT head.vbillcode, head.crequireappid, head.cbilltypecode, head.pk_corp FROM po_requireapp head INNER JOIN po_requireapp_b body ON body.crequireappid = head.crequireappid WHERE body.dr = 0 AND head.dr = 0 AND body.csourceid2 = :1 AND body.csourcetypecode2 = '20'
78m9ryygp65v5SELECT /*+ ALL_ROWS */ COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1
7a7wgrxc8uzu8 SELECT ic_general_h.cgeneralhid, ic_general_h.cauditorid, ic_general_h.cbilltypecode, ic_general_h.cbizid, ic_general_h.cbiztype, ic_general_h.ccustomerid, ic_general_h.cdilivertypeid, ic_general_h.cdispatcherid, ic_general_h.cdptid, ic_general_h.cinventoryid, ic_general_h.coperatorid, ic_general_h.cproviderid, ic_general_h.cregister, ic_general_h.cwarehouseid, ic_general_h.cwastewarehouseid, ic_general_h.cwhsmanagerid, ic_general_h.daccountdate, ic_general_h.dauditdate, ic_general_h.dbilldate, ic_general_h.dr, ic_general_h.fbillflag, ic_general_h.fspecialflag, ic_general_h.pk_corp, ic_general_h.vbillcode, ic_general_h.vdiliveraddress, ic_general_h.vnote, ic_general_h.vuserdef1, ic_general_h.vuserdef10, ic_general_h.vuserdef2, ic_general_h.vuserdef3, ic_general_h.vuserdef4, ic_general_h.vuserdef5, ic_general_h.vuserdef6, ic_general_h.vuserdef7, ic_general_h.vuserdef8, ic_general_h.vuserdef9, ic_general_h.vuserdef11, ic_general_h.vuserdef12, ic_general_h.vuserdef13, ic_general_h.vuserdef14, ic_general_h.vuserdef15, ic_general_h.vuserdef16, ic_general_h.vuserdef17, ic_general_h.vuserdef18, ic_general_h.vuserdef19, ic_general_h.vuserdef20, ic_general_h.pk_defdoc1, ic_general_h.pk_defdoc2, ic_general_h.pk_defdoc3, ic_general_h.pk_defdoc4, ic_general_h.pk_defdoc5, ic_general_h.pk_defdoc6, ic_general_h.pk_defdoc7, ic_general_h.pk_defdoc8, ic_general_h.pk_defdoc9, ic_general_h.pk_defdoc10, ic_general_h.pk_defdoc11, ic_general_ h.pk_defdoc12, ic_general_h.pk_defdoc13, ic_general_h.pk_defdoc14, ic_general_h.pk_defdoc15, ic_general_h.pk_defdoc16, ic_general_h.pk_defdoc17, ic_general_h.pk_defdoc18, ic_general_h.pk_defdoc19, ic_general_h.pk_defdoc20, ic_general_h.pk_corp, ic_general_h.ts, ic_general_h.pk_calbody, ic_general_h.pk_purcorp, ic_general_h.freplenishflag, ic_general_h.boutretflag, ic_general_h.bassetcard, ic_general_h.taccounttime, ic_general_h.clastmodiid, ic_general_h.iprintcount, ic_general_h.tmaketime, ic_general_h.tlastmoditime, ic_general_b.bzgflag, ic_general_b.castunitid, ic_general_b.ccorrespondbid, ic_general_b.ccorrespondcode, ic_general_b.ccorrespondhid, ic_general_b.ccorrespondtype, ic_general_b.ccostobject, ic_general_b.cfirstbillbid, ic_general_b.cfirstbillhid, ic_general_b.cfirsttype, ic_general_b.cgeneralbid, ic_general_b.cgeneralhid, ic_general_b.cinventoryid, ic_general_b.cprojectid, ic_general_b.cprojectphaseid, ic_general_b.csourcebillbid, ic_general_b.csourcebillhid, ic_general_b.csourcetype, ic_general_b.cwp, ic_general_b.dbizdate, ic_general_b.dr, ic_general_b.dstandbydate, ic_general_b.dvalidate, ic_general_b.fchecked, ic_general_b.flargess, ic_general_b.isok, ic_general_b.ninassistnum, ic_general_b.ninnum, ic_general_b.nmny, ic_general_b.nneedinassistnum, ic_general_b.noutassistnum, ic_general_b.noutnum, ic_general_b.nplannedmny, ic_general_b.nplannedprice, ic_general_b.nprice, ic_general_b.nshouldinnum, ic_gen eral_b.nshouldoutassistnum, ic_general_b.nshouldoutnum, ic_general_b.ntranoutnum, ic_general_b.vbatchcode, ic_general_b.vfree1, ic_general_b.vfree10, ic_general_b.vfree2, ic_general_b.vfree3, ic_general_b.vfree4, ic_general_b.vfree5, ic_general_b.vfree6, ic_general_b.vfree7, ic_general_b.vfree8, ic_general_b.vfree9, ic_general_b.vproductbatch, ic_general_b.vsourcebillcode, ic_general_b.vuserdef1, ic_general_b.vuserdef10, ic_general_b.vuserdef2, ic_general_b.vuserdef3, ic_general_b.vuserdef4, ic_general_b.vuserdef5, ic_general_b.vuserdef6, ic_general_b.vuserdef7, ic_general_b.vuserdef8, ic_general_b.vuserdef9, ic_general_b.vuserdef11, ic_general_b.vuserdef12, ic_general_b.vuserdef13, ic_general_b.vuserdef14, ic_general_b.vuserdef15, ic_general_b.vuserdef16, ic_general_b.vuserdef17, ic_general_b.vuserdef18, ic_general_b.vuserdef19, ic_general_b.vuserdef20, ic_general_b.pk_defdoc1, ic_general_b.pk_defdoc2, ic_general_b.pk_defdoc3, ic_general_b.pk_defdoc4, ic_general_b.pk_defdoc5, ic_general_b.pk_defdoc6, ic_general_b.pk_defdoc7, ic_general_b.pk_defdoc8, ic_general_b.pk_defdoc9, ic_general_b.pk_defdoc10, ic_general_b.pk_defdoc11, ic_general_b.pk_defdoc12, ic_general_b.pk_defdoc13, ic_general_b.pk_defdoc14, ic_general_b.pk_defdoc15, ic_general_b.pk_defdoc16, ic_general_b.pk_defdoc17, ic_general_b.pk_defdoc18, ic_general_b.pk_defdoc19, ic_general_b.pk_defdoc20, ic_general_b.pk_corp, ic_general_b.ts, ic_general_b.vnotebody, ic_general_b.cinvbasid, ic_general_b.pk_invoicecorp, ic_general_b.hsl, ic_general_b.crowno, ic_general_b.csourcetype, ic_general_b.vsourcebillcode, ic_general_b.vsourcerowno, ic_general_b.vfirstbillcode, ic_general_b.vfirstrowno, ic_general_bb3.caccountunitid, ic_general_bb3.cgeneralbb3, ic_general_bb3.cgeneralbid, ic_general_bb3.cgeneralhid, ic_general_bb3.dr, ic_general_bb3.naccountmny, ic_general_bb3.naccountnum1, ic_general_bb3.naccountnum2, ic_general_bb3.nmaterialmoney, ic_general_bb3.npmoney, ic_general_bb3.npprice, ic_general_bb3.nsignnum, ic_general_bb3.ts, po_order.vordercode, po_order.ctermprotocolid, po_order.cgiveinvoicevendor, po_order.cvendormangid, po_order_b.corderid, po_order_b.corder_bid, po_order_b.pk_corp, po_order_b.cusedeptid, po_order_b.cmangid, po_order_b.cbaseid, po_order_b.nordernum, po_order_b.cassistunit, po_order_b.nassistnum, po_order_b.ndiscountrate, po_order_b.idiscounttaxtype, po_order_b.ntaxrate, po_order_b.ccurrencytypeid, po_order_b.noriginalnetprice, po_order_b.noriginalcurprice, po_order_b.noriginalcurmny, po_order_b.noriginaltaxmny, po_order_b.noriginaltaxpricemny, po_order_b.nexchangeotobrate, po_order_b.ntaxmny, po_order_b.nmoney, po_order_b.ntaxpricemny, po_order_b.naccumarrvnum, po_order_b.naccumstorenum, po_order_b.naccuminvoicenum, po_order_b.naccumwastnum, po_order_b.dplanarrvdate, po_order_b.vvendorordercode, po_order_b.vvendororderrow, po_order_b.cwarehouseid, po_order_b.v receiveaddress, po_order_b.nconfirmnum, po_order_b.dconfirmdate, po_order_b.ccorrectrowid, po_order_b.dcorrectdate, po_order_b.cprojectid, po_order_b.cprojectphaseid, po_order_b.coperator, po_order_b.iisactive, po_order_b.iisreplenish, po_order_b.forderrowstatus, po_order_b.csourcebilltype, po_order_b.csourcebillid, po_order_b.csourcerowid, po_order_b.cupsourcebilltype, po_order_b.cupsourcebillid, po_order_b.cupsourcebillrowid, po_order_b.vmemo, po_order_b.vfree1, po_order_b.vfree2, po_order_b.vfree3, po_order_b.vfree4, po_order_b.vfree5, po_order_b.vdef1, po_order_b.vdef2, po_order_b.vdef3, po_order_b.vdef4, po_order_b.vdef5, po_order_b.vdef6, po_order_b.dr, po_order_b.ts, po_order_b.norgnettaxprice FROM ic_general_h INNER JOIN ic_general_b ON ic_general_h.cgeneralhid = ic_general_b.cgeneralhid INNER JOIN ic_general_bb3 ON ic_general_b.cgeneralbid = ic_general_bb3.cgeneralbid LEFT OUTER JOIN po_order_b ON ic_general_b.cfirstbillhid = po_order_b.corderid AND ic_general_b.cfirstbillbid = po_order_b.corder_bid LEFT OUTER JOIN po_order ON po_order.corderid = po_order_b.corderid LEFT OUTER JOIN bd_cumandoc ON ic_general_h.cproviderid = bd_cumandoc.pk_cumandoc left outer join bd_invmandoc on ic_general_b.cinventoryid = bd_invmandoc.pk_invmandoc WHERE ( ic_general_h.fbillflag = 3 OR ic_general_h.fbillflag = 4 ) AND ic_general_h.dr = 0 AND ic_general_b.dr = 0 AND nvl ( ic_general_b.flargess, 'N' ) = 'N' AND ic_general_bb3.dr = 0 AND ic_general_b.isok = 'N' AND ic_general_b.ninnum IS NOT NULL AND ic_general_b.pk_invoicecorp = '1421' AND ic_general_h.cbiztype = '0001F1100000001KT12H' AND ic_general_h.cbilltypecode = '45' AND ( ( ic_general_h.dbilldate <= '2013-12-09' ) and ( ic_general_h.cproviderid IN ( SELECT pk_cumandoc FROM bd_cumandoc LEFT OUTER JOIN bd_cubasdoc ON bd_cumandoc.pk_cubasdoc = bd_cubasdoc.pk_cubasdoc LEFT OUTER JOIN bd_areacl ON bd_cubasdoc.pk_areacl = bd_areacl.pk_areacl WHERE custname = '½ðɽÇøÕÅÑßÕòÓÀ»ª×ÛºÏÃÅÊв¿' ) ) ) AND ( ( ic_general_b.cfirsttype IS NULL ) OR ( po_order.dr = 0 AND po_order_b.dr = 0 AND ic_general_b.cfirsttype = '21' ) ) AND ( bd_cumandoc.frozenflag IS NULL OR bd_cumandoc.frozenflag = 'N' ) ORDER BY ic_general_h.cgeneralhid, ic_general_b.cinventoryid
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7nuw4xwrnuwxqselect col#, intcol#, toid, version#, packed, intcols, intcol#s, flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc
83taa7kaw59c1select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8bd2za131fg0aSELECT NVL(SUM(A), 0) FROM ( SELECT SUM(D.RECEIVE - D.PAY) A FROM CMP_DETAIL D WHERE D.PK_ACCOUNT IS NULL AND FUNDFORMCODE = 2 AND D.PK_BILLTYPE <> '36GM' AND ( D.NOTEDIRECTION = 0 OR ( D.NOTEDIRECTION = 1 AND D.PK_DETAIL IN ( SELECT OUTER.PK_OUTERBILL_B FROM FBM_OUTER OUTER, FBM_REGISTER REG WHERE REG.PK_REGISTER = OUTER.PK_REGISTER AND REG.PK_BILLTYPECODE = '36GA' AND REG.SFFLAG = 'Y' AND NVL(REG.DR, 0) = 0 AND NVL(OUTER.DR, 0) = 0 AND REG.PK_CORP = D.PK_CORP ) ) ) AND ( D.ISBILLRECORD <> 'Y' OR D.ISBILLRECORD IS NULL ) AND D.PK_NOTETYPE = '0001A9100000000026B0' AND D.PK_CURRTYPE = '00010000000000000001' AND ( D.TALLYSTATUS <> 0 OR ( D.TALLYSTATUS = 0 AND D.TALLYDATE IS NOT NULL ) ) AND D.TALLYDATE IS NOT NULL AND ( D.TALLYDATE > :B3 AND D.TALLYDATE < :B2 ) AND D.PK_CORP = :B1 UNION SELECT -SUM(D.RECEIVE - D.PAY) A FROM CMP_DETAIL D LEFT JOIN FBM_BASEINFO F ON F.FBMBILLNO = D.NOTENUMBER WHERE D.PK_ACCOUNT IS NULL AND F.BASEINFOSTATUS = 'has_impawn' AND FUNDFORMCODE = 2 AND D.TALLYDATE IS NOT NULL AND D.TALLYDATE IS NOT NULL AND D.PK_NOTETYPE = '0001A9100000000026B0' AND D.PK_CURRTYPE = '00010000000000000001' AND ( D.TALLYDATE > :B3 AND D.TALLYDATE < :B2 ) AND D.PK_CORP = :B1 )
8hzv9d7uday84 SELECT bd_cubasdoc.pk_cubasdoc FROM bd_cubasdoc WHERE bd_cubasdoc.ts >= '2013-12-09 10:45:07' AND ( bd_cubasdoc.pk_cubasdoc IN ( '10238910000000000VNT', '10268910000000000IJB', '1155G41000000002727Z', '1421F1100000000010BF', '1026651000000000RC0P', '11406510000000007WQH', '1020891000000000038D', '000165100000000GDRBP', '1155G41000000001LDBZ', '11556510000000001CQT', '11556510000000001CR5', '10248910000000001MZP', '000165100000000GD623', '1155G410000000026RTG', '1155651000000000WAVY', '1155651000000000A0L1', '1155G410000000029A50', '11556510000000001PBR', '1155G41000000002KS61', '1155651000000000AYC7', '1155651000000001AAZ9', '10286510000000005LED', '115565100000000018XP', '115565100000000018Y1', '1155651000000000CGCO', '1155G41000000002R4PW', '1155G410000000029JBE', '1155G41000000002CWYE', '1155G41000000002KPSB', '1155G410000000026IZH', '1155651000000000UZ5F', '1155G41000000002DKB9', '11556510000000001CNH', '10196510000000005P9G', '11506510000000001150', '11556510000000004YK3', '10726510000000007AOF', '0001651000000006A8UG', '000165100000000GEY3X', '11266510000000072L28', '102289100000000027KC', '11556510000000001C5Q', '115565100000000015OX', '11556510000000000U6M', '115565100000000014Y9', '1155G41000000002DKAC', '11776510000000000AT9', '10466510000000006Z1F', '0001A910000000000QIC', '000165100000000GF6QD', '11556510000000000X01', '11556510000000001901', '1155G410000000028BCD', '10278910000000000X7E', '10246510000000006 JC9', '1155G41000000002CVQW', '11556510000000000U7E', '1155G41000000002CVNK', '0001A910000000000WSB', '1155651000000000ONFE', '11556510000000001CQD', '1155F11000000002OZK0', '1020891000000000037P', '1155651000000000ONCH', '115565100000000162EL', '10286510000000009RZ6', '1155G41000000002BDRK', '1155G41000000002721E', '11556510000000000U6E', '0001651000000006A81U', '11556510000000000WYC', '1155G410000000028E3Q', '1155G410000000028GZ9', '11556510000000005STT', '11556510000000016S5A', '1155G410000000027QRX', '11556510000000001CNX', '11556510000000001CO9', '10268910000000001DF9', '1155G410000000026DLV', '000165100000000GFPFN', '1155651000000001BGEU', '1075651000000000JL96', '00018910000000013H0V', '10268910000000004LW9', '1026651000000001APRU', '1070651000000000L7ZT', '102089100000000003A5', '102289100000000003ZT', '1011A9100000000000YJ', '11556510000000000U5D', '1029651000000000DSX1', '1022651000000000REVT', '10626510000000001I0H', '1155G410000000026CJQ', '1155651000000000BR64', '1155G41000000001N4JL', '115565100000000018XH', '115565100000000018VT', '115565100000000018W5', '1029651000000000KNUM', '000165100000000MXMCX', '1155651000000000DAIB', '11556510000000000N5M', '11556510000000000ZQL', '1155G4100000000272EO', '1155G41000000002MUG0', '101989100000000002HD', '1155G41000000002EW86', '0001A910000000000R6A', '1155G410000000027QRP', '1155G41000000002CVOB', '1032651000000000A8UB', '1155G41000000002JAAM', '0001A91000000000P BUB', '1023651000000000C2BR', '11556510000000001CPT', '11556510000000001CQ5', '11556510000000000U86', '11556510000000000U7U', '10376510000000004TXH', '11626510000000000VOI', '115565100000000012AJ', '115565100000000018TL', '1155651000000000WRWJ', '1155651000000000RWPF', '000165100000000GCOW4', '11556510000000001COX', '11556510000000001CP9', '1155651000000000C9KL', '1155651000000000UCAI', '0001A910000000000WSJ', '11556510000000000YUD', '0001A91000000000PBS6', '10218910000000000K29', '1012A9100000000000YS', '1155651000000000PCUH', '1155651000000000PZGA', '107765100000000031MU', '11556510000000001CQL', '1155651000000000PJ54', '1155G41000000002DJAL', '1155G41000000002EGCN', '10296510000000009KX9', '11556510000000000U8M', '1155G41000000001QLW3', '1155G410000000026R9E', '1008A9100000000000WF', '11346510000000002YAR', '1155G41000000002K7NR', '1155F11000000002RHU0', '10576510000000001UCX', '1017651000000000GF1T', '1155G41000000002CWXW', '1155G41000000002B18G', '1155G41000000002R4Q0', '1155G41000000002CWXM', '000165100000000HMH3Q', '101689100000000003V5', '11556510000000000N6M', '1074651000000000AH3U', '1026651000000000YSH8', '0001A91000000000PBTJ', '1028651000000000DBXV', '1155G410000000026WAS', '0001A910000000000QX8', '000165100000000GEY3Q', '10288910000000000JB6', '10738910000000000GFL', '0001A910000000000QLU', '102989100000000002BX', '0001A91000000000PBUL', '115565100000000015OP', '115565100000000015P1', '1155G41000000002C 75K', '0001A910000000000QD8', '0001651000000005XXK1', '0001A910000000000QC4', '1155G41000000002DKB1', '000165100000000GHKHV', '11556510000000001CAK', '1026651000000000ZGHI', '1155G410000000026QTL', '1155651000000000RMA4', '1155G410000000026BSH', '000165100000000CLQAP', '1155G41000000001P5KX', '1035651000000000B2BL', '1155G410000000026BCN', '1155651000000000UMMJ', '10196510000000008VGG', '102889100000000017ZG', '11556510000000000N6U', '10268910000000002WY5', '11556510000000000WX8', '11556510000000000WWW', '1155651000000000YDGZ', '102289100000000003Y9', '1155651000000000TF77', '11556510000000005TJ1', '0001651000000006A8UW', '11556510000000007NNT', '1026651000000000JVQV', '1155G41000000001WO2B', '11556510000000019JPW', '0001A91000000000PBTB', '1155G41000000002HKS9', '11566510000000000G85', '115565100000000018ST', '115565100000000018T5', '1155G41000000002MOQ9', '1155651000000000159G', '1155651000000001I4Y1', '10346510000000005F48', '115565100000000015OH', '1155G410000000026CBD', '0001A910000000000WS3', '0001A910000000000WRR', '1028651000000000HT7F', '101689100000000003YT', '1155651000000000WRWB', '000165100000000GH9TY', '102289100000000022YO', '1155G410000000026CW1', '1145651000000000347Q', '1155G41000000002CZB8', '10268910000000001UKT', '1155F11000000001QTZJ', '11556510000000001COP', '11556510000000001CP1', '1155651000000001FDPU', '1155G41000000002CXLO', '1155651000000000VPZ5', '11556510000000000WXO', '11556510000000000 WY0', '102289100000000017A6', '115565100000000011UZ', '1155G41000000002DOTE', '1011A91000000000012J', '1155G4100000000274BQ', '103265100000000139V4', '1022891000000000179Q', '1155G410000000026TEU', '101989100000000002BT', '101989100000000002C5', '11556510000000000X09', '11556510000000001909', '1013G41000000003EZFZ', '115565100000000014TM', '1024651000000000AZV6', '0001651000000006A784', '11336510000000003R6C', '1155G41000000002C1F1', '1034651000000000V9AZ', '1094651000000000FFTM', '11556510000000004HJG', '1155G41000000002C1BH', '10268910000000001UKL', '107765100000000037VU', '11256510000000000HDO', '1102651000000000ZEZ5', '115565100000000018WX', '115565100000000018X9', '11556510000000001NM3', '0001A910000000000QKI', '102689100000000015OM', '1007A9100000000002IE', '11556510000000000U3D', '10396510000000008XQ2', '1155G41000000002C1CM', '10286510000000008OMV', '1030651000000000F9TF', '1019651000000000OQW4', '1155G41000000002I53O', '0001A91000000000PBRF', '1155651000000000AI7S', '115565100000000018TD', '1029651000000000ILS4', '1155G41000000002C1BP', '0001A91000000000PBUJ', '1028F11000000001GNUT', '11556510000000001CM5', '000165100000000GEY40', '113565100000000005KA', '0001651000000006A7SE', '102689100000000002F9', '11556510000000008J7H', '1155G41000000002D0ZC', '1026651000000000CJW8', '10218910000000000VN1', '1155651000000000VBK8', '1155G41000000002F56K', '1155651000000000RGSG', '1155G41000000002DIYX', '11556510000000000 YQ1', '1155F11000000001XF89', '11556510000000019JQO', '0001A910000000000WS9', '0001A910000000000WRX', '000165100000000GFPFK', '1155G410000000024UZH', '000165100000000GH9UB', '1155651000000000WYZ7', '1155651000000001HH6B', '11556510000000000WW4', '11556510000000000WVS', '1155G41000000001LBRP', '11386510000000001VWH', '000165100000000GAB52', '10748910000000000P0T', '000165100000000GF6P8', '1155F11000000002Q2V9', '10178910000000000YQN', '1029651000000000IRZ8', '1155G410000000026UK6', '1155G41000000002CBYW', '115565100000000150XX', '10866510000000003H57', '10736510000000001SWH', '0001A91000000000PBTP', '0001A91000000000PBU1', '115565100000000014TE', '000165100000000GD63I', '1155F110000000020TES', '10226510000000006KJ0', '1155651000000000RPP1', '11556510000000005SU6', '0001A91000000000PBTX', '0001A91000000000PBU9', '1022651000000000CN9W', '1155G41000000002CWU1', '113665100000000005OH', '1155651000000000BT7U', '000165100000000T5GP7', '11556510000000000WXG', '1155G410000000023HGJ', '11556510000000000WZX', '115565100000000018ZX', '1155G41000000001KYEI', '11826510000000003YQY', '11556510000000001CZB', '10076510000000006FUI', '102389100000000016G5', '115565100000000015O9', '1155651000000000Z0WR', '00016510000000068S6G', '11556510000000000U4L', '11556510000000000N6E', '11556510000000000U55', '11556510000000000U4T', '1026651000000000OSQX', '10268910000000001BV1', '1155G41000000002BY7I', '1155G41000000002CZ44', '000165100000000Q5 UDK', '1029651000000000ACOU', '11556510000000001CMT', '11556510000000001CN5', '1022G41000000001EOWC', '1017651000000000K6Z1', '1155651000000000ZG9Y', '115565100000000068KZ', '1155651000000000RJLI', '1018651000000000XXM4', '1155651000000000CO2T', '1004A910000000000221', '1019651000000000AJMP', '11556510000000001C75', '0001651000000006A8UO', '1155651000000000B5KK', '1155G41000000002QOJ5', '1155G41000000002F8GP', '1155G410000000026ZHD', '10288910000000000RTO', '1023G41000000001P547', '1035651000000000BROX', '115565100000000018UX', '115565100000000018V9', '0001A91000000000PBSC', '1155G410000000028BC5', '1155G41000000002AZVB', '12076510000000000IJP', '1155651000000000AQKP', '1094651000000000TN8T', '0001A91000000000PBR8', '0001A91000000000PBQW', '1155G41000000002N7JD', '101689100000000003X1', '10266510000000015JG2', '115565100000000018VP', '115565100000000018W1', '1155651000000000UPKF', '10248910000000003DCY', '11566510000000000G9Q', '1155G4100000000271OK', '1155G41000000001W22Z', '1155G41000000002CX30', '0001891000000001262K', '11556510000000018RK5', '106965100000000078C4', '1155G41000000002KMBE', '1155F11000000002OVAX', '1155651000000000TSJB', '1155651000000000UCJ6', '0001A91000000000PBR0', '000165100000000GF6QL', '1155G410000000026CFG', '11556510000000000DW1', '1155651000000001F58M', '1155G41000000002CXLH', '1155G410000000026XB9', '1016891000000000040P', '11556510000000004Z0N', '000165100000000GF6PX', '0001A91000000000P BSV', '0001A91000000000PBT7', '1022651000000000A47T', '1155G41000000002K9RG', '1155G410000000029D32', '1155651000000000126T', '1155G410000000027SZA', '1155651000000000W4VS', '11556510000000009SYC', '106589100000000007RP', '102665100000000078TZ', '1155651000000000XAEV', '1155G41000000002K9RK', '1113651000000000JKKP', '11556510000000001COH', '11556510000000000U4D', '1155651000000001AAZD', '102089100000000011VZ', '11556510000000001NMC', '1155F11000000002Q367', '11556510000000019LLY', '000165100000000GHKIA', '1072G4100000000288BS', '0001A91000000000PBSN', '1017651000000000XN0G', '0001A910000000000QIE', '00018910000000014QXR', '1155G41000000002C75F', '101789100000000016HE', '11556510000000007PSN', '11556510000000005TKT', '115665100000000061LE', '1155G410000000028BCT', '000165100000000GF6T4', '1155G41000000001MAMF', '10708910000000000K81', '106589100000000007QL', '000165100000000GEY43', '00018910000000012SM6', '1155G410000000026CJ8', '115565100000000018R9', '1421F110000000000G7Z', '115565100000000018VD', '1155651000000001FCVU', '102689100000000015QM', '1155G410000000027WKY', '1155651000000000UGI4', '115565100000000064TC', '1155651000000001BIYV', '0001651000000010NZQ2', '1155651000000000TMPO', '1086651000000000XKC4', '1155G41000000001W1W7', '1155G41000000002D4HU', '115565100000000012RK', '000165100000000GF6PO', '000165100000000GF6Q0', '115565100000000019JD', '1155F11000000001Y1LT', '1155G41000000002DKAV', '000165100000000GA B5G', '1155G410000000027QF5', '1155G41000000002ADQ9', '11556510000000000U49', '11556510000000000U3X', '1155G41000000002C1BY', '000165100000000GF6PF', '0001651000000006A89E', '1155651000000000V894', '1155G41000000001MKIG', '11556510000000001CRL', '1155651000000001I4NF', '113665100000000005ML', '1004A9100000000001QQ', '1004A9100000000001R2', '0001A91000000000PBSR', '0001A91000000000PBT3', '1155G41000000002CXQR', '1155F11000000002OVB1', '0001651000000006A85K', '000165100000000GD630', '1155651000000000QKUD', '1007A9100000000002L2', '1155651000000000OP1T', '1155G41000000002B2FC', '1074651000000000A0EZ', '1155G410000000026RA6', '11556510000000000WZD', '115565100000000018ZD', '1083651000000000QK8T', '1026651000000000GUIE', '1155G410000000026DOW', '101889100000000014W9', '1089651000000000698W', '115565100000000012NS', '1155G41000000002C757', '0001A910000000000WSM', '1155G41000000002C1C6', '101965100000000083OJ', '000165100000000GHXGZ', '1155G4100000000272UO', '10218910000000001F0A', '115565100000000011UN', '1155G41000000002A3E6', '1155651000000000BRAW', '0001A910000000000QOU', '1155G41000000002EAVM', '11556510000000000X0D', '1155651000000000O5M1', '11336510000000004C6P', '1155G410000000026WEZ', '000165100000000THIOA', '11556510000000018PCX', '11256510000000000HDK', '1155G410000000026X6I', '0001A91000000000PBQY', '115565100000000018TT', '115565100000000018U5', '1155G41000000001OS50', '11556510000000001944', '1155651000000000X KFH', '11556510000000004XJ3', '1155G41000000001WRJ8', '1155651000000001FDJH', '1155651000000000166G', '11556510000000007OBC', '1155G41000000002CY7H', '11556510000000000U9E', '1155651000000000YLDS', '1155G41000000001NVXB', '000165100000000GFPFW', '000165100000000GN83U', '1074651000000000A0DK', '1155651000000000D17Q', '1084651000000000PEQ1', '1155G410000000026C9Q', '1155651000000000T4CM', '1155651000000000AFUD', '1155G410000000026XL3', '115565100000000017ZI', '1155G410000000027WKQ', '1155G41000000002KH8A', '1155G41000000002EIDT', '000189100000000126BO', '102289100000000017A2', '1102651000000000L9J6', '1010A9100000000000TC', '1155G410000000028LKZ', '10286510000000009S4A', '1155G41000000002CYDW', '1155651000000000BN0U', '1155651000000000XR7E', '1155G41000000001PTEM', '11556510000000000N66', '11556510000000000N5U', '1155F11000000001YZL1', '000165100000000GFPFH', '000165100000000Q4NDZ', '115565100000000018YT', '115565100000000018Z5', '0001A91000000000PBTH', '1026651000000000U0FR', '1155651000000001A335', '11556510000000019FSX', '1155G410000000027VMJ', '1155G41000000002CYD9', '10386510000000007UU1', '10356510000000004809', '0001891000000000XYHW', '11556510000000001E98', '11556510000000000WW0', '1155651000000001AL00', '1155G4100000000274PM', '1155G410000000026WN7', '1155F11000000002IW0O', '1155G41000000002BWV8', '115565100000000067SI', '11556510000000000U66', '11556510000000000U5U', '1155G41000000002BSR4', '1155G41000000001J SVR', '11556510000000001CM9', '1155G41000000002DJ6G', '11956510000000003LX0', '000165100000000GFPGT', '11556510000000001CML', '1155G41000000002675Q', '11556510000000019LJG', '10268910000000001TM9', '1155651000000000C9N4', '10398910000000000955', '000165100000000GCOVJ', '0001G4100000001I0WHY', '000165100000000GHKI1', '1155G410000000026CO6', '11556510000000000WWG', '101789100000000053N9', '1032651000000000E4SX', '10268910000000003XZH', '000165100000000GF6QO', '102889100000000033WA', '10218910000000001EYW', '0001A91000000000PBS4', '1155G410000000026IWT', '0001A910000000000WSD', '1150651000000000115W', '0001651000000006A8UU', '1155G41000000002CMEV', '10268910000000000IKU', '1155G41000000001O2T5', '107765100000000037W2', '107765100000000037VQ', '11556510000000001CMD', '1155651000000000SYIR', '1155G410000000027YV1', '1155G41000000002AY41', '000189100000000126EI', '11556510000000000WX0', '11556510000000000WWO', '11556510000000000WZT', '115565100000000018ZT', '1155F11000000001YD9K', '10896510000000005U0X', '11556510000000000WXC', '1007A9100000000002HY', '1004A9100000000001TU', '1178651000000000K8EM', '1155651000000001HH6H', '1155G41000000001OTEC', '11256510000000002565', '1155G410000000028RAI', '000165100000000GVITK', '1007A910000000000351', '1155G410000000026X1T', '1070651000000000728H', '1026891000000000111D', '1018651000000000LE71', '1155651000000000X5UD', '115565100000000018SH', '11556510000000000U41', '11556510000000000 U3P', '115565100000000018YL', '1155G410000000026U0V', '000165100000000GCOUX', '0001A91000000000PBUH', '11556510000000000WZL', '115565100000000018ZL', '11556510000000000YBP', '0001A91000000000PBTN', '00018910000000012637', '11556510000000000U5M', '1155651000000000POKV', '1155G41000000001MJCZ', '1155651000000000R78V', '0001A910000000000WS1', '0001A910000000000QMI', '10218910000000001B2P', '1003A91000000003T07Z', '10288910000000001KCB', '11556510000000001CPP', '11556510000000001CQ1', '11556510000000001COT', '11556510000000001CP5', '1155G41000000002F8JS', '1022651000000000CWUR', '1155G41000000002N49G', '1155G4100000000270KY', '1155G41000000002CEP5', '11556510000000000U76', '11556510000000000U6U', '1155G41000000001OY5C', '1155G41000000002CW1X', '115565100000000012BH', '1155651000000000VD6G', '0001A91000000000PBRD', '11556510000000018XN8', '115665100000000016H1', '11556510000000001EAD', '108465100000000025WQ', '000165100000000GS9NB', '1155651000000000WRWF', '109465100000000031QN', '1155651000000000TA4V', '115565100000000018WP', '115565100000000018X1', '11556510000000018WEX', '1155651000000000R80H', '10328910000000000UVT', '115565100000000017A7', '10866510000000003DWX', '1155G41000000001KYA4', '1155F11000000002P8HU', '1155651000000001BFVP', '1155G41000000002FGY8', '11556510000000009QKX', '1026651000000001G3PX', '104589100000000006BH', '1019651000000001GEV2', '10268910000000001627', '10286510000000007FQX', '1155G41000000002C XL7', '115565100000000018YD', '1155G410000000026CJU', '103989100000000008P9', '1155G410000000023HPK', '1026651000000000CFNQ', '115565100000000018RH', '1021891000000000445D', '0001A910000000000WRZ', '1028651000000000L749', '1155651000000000TD0C', '11556510000000000U96', '11556510000000000U8U', '117765100000000061M2', '115565100000000015O1', '1155G410000000027YXR', '1155651000000000US91', '1155G41000000002CVZD', '1028651000000000HUUY', '1155G41000000002C1CA', '1155G4100000000257P0', '000165100000000GD639', '1155651000000000W012', '10178910000000001S5L', '1155G41000000002CWTR', '1155G41000000002CWYV', '1155F11000000002IASS', '102265100000000052VL', '1155G410000000028D4F', '000165100000000GF6VW', '1155F110000000021JEV', '115565100000000011UF', '10388910000000000378', '1038891000000000036W', '1155G410000000027ZBN', '1155G410000000028CSN', '115565100000000018XT', '115565100000000018Y5', '10266510000000005SDL', '101789100000000004SM', '1155G41000000002DROX', '0001A91000000000PBTV', '0001A91000000000PBU7', '11556510000000001CA2', '1155G41000000001OYGK', '1021651000000001N1ST', '1075G41000000002TTIV', '1155G410000000021BMN', '11556510000000001CQP', '11556510000000001CR1', '1155G41000000001N4JH', '1155G410000000026B9P', '11556510000000009A4E', '102289100000000003UX', '1155G41000000002762Y', '1155F11000000001ZHFV', '1155G4100000000257OW', '0001A910000000000QWK', '1155G410000000026LKS', '1155651000000000VS86', '1003A91000000000I TS8', '115565100000000199MP', '1155651000000001I4TH', '1155651000000000159K', '11556510000000000WYS', '1107651000000000MB94', '1013A9100000000000WD', '1155651000000000TN5X', '101989100000000002FH', '11556510000000006MNV', '000165100000000HICG5', '11556510000000001CRD', '1155G41000000001QLVM', '0001651000000006A8F6', '0001A91000000000PBR2', '1155G41000000002KFHW', '1029651000000000JB8V', '0001651000000006A8UM', '10216510000000007L5D', '1155G410000000028FV0', '1013A9100000000000YD', '1155G41000000002F7VA', '1155G41000000002CVW8', '10286510000000009T19', '115565100000000011UV', '1155F110000000021JFX' ) OR bd_cubasdoc.pk_cubasdoc IN ( '0001A91000000000PBSE', '1155G41000000002EAWF', '1155651000000000SDQZ', '11296510000000004CN9', '1155G410000000028BCL', '115565100000000018WH', '1155G410000000027T9O', '1155G410000000028P5Q', '1155G41000000001JQH7', '11556510000000001CNT', '11556510000000001CO5', '1155651000000000X86W', '11556510000000001CPH', '1155651000000001BITY', '1155G41000000001WOER', '1019651000000001F19X', '1155651000000001F18O', '11556510000000000N73', '115565100000000018UD', '1155651000000000VBL7', '1155F11000000002OH0M', '11266510000000001ZTH', '0001A91000000000PBSX', '0001A91000000000PBT9', '1155G410000000026BB6', '1003A9100000000012YT', '1155651000000000CSRE', '1155651000000000BXVJ', '1155G41000000002BMZV', '1155F110000000020WGX', '1155651000000001BA6D', '1155651000000000CAUW', '1155651000000000D9OR', '1008A91000 00000000VV', '0001A910000000000QLC', '102389100000000002E9', '1155G41000000002CVU4', '1100651000000000LLS1', '11556510000000000U7M', '0001A91000000000PBSP', '0001A91000000000PBT1', '115565100000000018UL', '1004A9100000000001MI', '1155651000000000RUDX', '1028891000000000114K', '000165100000000GCOV0', '1155G410000000026C9I', '11556510000000000U8E', '000165100000000GF6Q7', '0001A91000000000PBRL', '115165100000000007TP', '1155651000000001BMAJ', '11796510000000000N5W', '1020891000000000039P', '1155G41000000001O33B', '110365100000000038IL', '000165100000000GF6UU', '11556510000000000WYK', '1155G410000000026WVX', '1155G4100000000287LX', '1155G410000000023F7F', '10248910000000002NT3', '10298910000000001IU4', '00018910000000012AYS', '1155G410000000026BDZ', '1155G41000000001M5PM', '1017651000000000HKUL', '1155G41000000002C1B5', '1094651000000000FFTQ', '10547610000000002J2D', '1155F110000000022MW9', '10118910000000002W82', '115565100000000018XD', '1155G41000000002CWYI', '1155G41000000002DKA7', '1088651000000000JR78', '1155G410000000026S83', '11556510000000000N62', '11556510000000000N5Q', '1155F11000000001ZI2Y', '1155G410000000026U3T', '10218910000000000K3D', '115565100000000076HM', '1155G41000000001J1RB', '102189100000000002HT', '1155G410000000026W4C', '115565100000000015O5', '11556510000000001CNL', '11556510000000001CQX', '11556510000000001CR9', '1155651000000000129A', '1155G410000000026S0L', '103589100000000004QT', '1134651000 0000003GC6', '0001A910000000000QC0', '11556510000000004YK7', '1155651000000000UCJ2', '10238910000000000G7L', '10286510000000009S3Y', '1155G41000000001KZ3M', '115565100000000015OD', '11556510000000009QKT', '1155651000000000VBC8', '10726510000000004FZ9', '1155G410000000028BCH', '1003A910000000020S12', '1155651000000000C9NH', '11556510000000019LSB', '1114651000000000076N', '1155651000000000B4FL', '1155G410000000026V66', '1089651000000000Y94H', '0001A91000000000PBST', '0001A91000000000PBT5', '1155G410000000026R9A', '000165100000000GD636', '10198910000000000EOY', '1155651000000000CQD1', '1155G41000000002CWGF', '1155G41000000001MVR3', '11556510000000001CAO', '1155G410000000026RAE', '11556510000000000N6I', '11556510000000000U72', '11556510000000000U6Q', '1155651000000000VBLW', '111565100000000042FI', '101689100000000003UX', '1155G410000000026BAH', '11556510000000001CQH', '1155G410000000026BB2', '000165100000000GS9Q1', '1155G410000000028BC9', '000165100000000GCOW1', '1155G410000000026FAY', '1008A9100000000000S3', '1155651000000000USE5', '1155G41000000001XAOI', '1155G41000000002FD2X', '0001A91000000000PBTF', '1020891000000000037L', '1155651000000000CGAZ', '115565100000000018TH', '11556510000000000U5H', '11556510000000000WYO', '11556510000000000WZ0', '1155651000000001519W', '1421F110000000000G8X', '10298910000000001YA1', '1155G4100000000275OJ', '1032651000000000XVXS', '1102651000000000F61B', '11556510000000001CAG', '1155G41000 0000026U3L', '1155651000000000126G', '0001651000000006A8US', '000165100000000GHXHA', '1155F11000000001XQUN', '0001651000000006A7II', '1155651000000000A0LE', '1155G41000000002C1BD', '1155651000000000XUJM', '1155F11000000002Q36B', '1003A910000000001GP4', '1155651000000000VP7K', '1155F110000000026HM9', '1026651000000000I2L2', '1155651000000000WZ3K', '000165100000000GD63F', '1020651000000000BFTV', '1155G410000000024XDD', '10228910000000000GDR', '1155G410000000029KSF', '1155651000000001I4XX', '1155G41000000001KYAB', '1074651000000000KQWX', '1092651000000001E2E8', '10546510000000005UXC', '10736510000000001SWT', '11556510000000001C30', '11556510000000019XZI', '1155G410000000026VBL', '11556510000000001RBB', '103589100000000004RX', '1155F11000000002IYOI', '1020891000000000035T', '1155G41000000002DKB5', '11556510000000000ZZQ', '1035651000000000D6S2', '1155G410000000029CKZ', '115565100000000018VX', '115565100000000018W9', '1155G41000000002ISNT', '11556510000000000N6Q', '0001A910000000000WSF', '1155G410000000027R62', '00018910000000012SME', '1155G41000000002QF7X', '000165100000000GF6QH', '1155G41000000001WOEY', '102889100000000033VU', '10218910000000000VN5', '10216510000000008WCC', '0001A91000000000PBSH', '102189100000000023ME', '1155G41000000002K7NN', '1155F11000000002W97R', '102865100000000089U9', '1019891000000000111K', '115565100000000015OL', '1155G410000000028S47', '10268910000000001PSV', '107065100000000073QA', '0001651000 00000GF6PU', '0001A91000000000PBS2', '000165100000000GHKKE', '1074651000000000AX3L', '11556510000000000WX4', '11556510000000000WWS', '11556510000000000U8Y', '1155G410000000026YFM', '106589100000000007Q5', '11556510000000000WXS', '11556510000000000WY4', '1155651000000001A0DM', '10806510000000000VNX', '1155F11000000001Y8SL', '10806510000000009QCG', '1026G41000000001WY7P', '115565100000000018SX', '115565100000000018T9', '1155F11000000001ZS6D', '1155G410000000026R9I', '10246510000000009AVP', '1155651000000000RMA8', '115565100000000012AN', '1155651000000000CYUQ', '000165100000000GCOVY', '1155651000000000CGF0', '11556510000000005SU2', '11556510000000000U8I', '10248910000000001Y83', '1155651000000000RWPJ', '10248910000000001MZT', '11316510000000009B07', '10728910000000000FFT', '11556510000000000WZ9', '115565100000000018YX', '115565100000000018Z9', '11556510000000000X05', '11556510000000001905', '1003A9100000000012Z2', '11556510000000000YRG', '1155651000000000CMJR', '1011A9100000000000WN', '11556510000000000Y46', '115565100000000018SP', '115565100000000018T1', '1155G410000000027QS5', '11556510000000000U6A', '1155G41000000002C75O', '0001A910000000000QPK', '1155G41000000002D8LI', '1155651000000000SCX5', '0001891000000000XYNQ', '11556510000000004IBW', '1155651000000000WATR', '1155651000000000B5F8', '1155G410000000029AMJ', '1155G41000000002CX2T', '115565100000000015OT', '115565100000000015P5', '1155G410000000026WRI', '1035891000 00000004S1', '11556510000000001CPX', '11556510000000001CQ9', '11556510000000001CND', '10778910000000000E31', '102989100000000084G2', '109265100000000000TO', '0001A910000000000R3I', '1155651000000000P8YH', '11556510000000018RK1', '1155651000000000RPOT', '1003A9100000000012ZL', '1155651000000000BR1L', '000165100000000GF6PC', '1021651000000000KC8J', '0001A91000000000PBRB', '1155F110000000021O0Z', '1431F11000000000067Q', '1155651000000000Y7RR', '0001651000000006A81A', '1019651000000000935X', '1034651000000000DJ5A', '1013A9100000000001ML', '11246510000000000D61', '10916510000000003EUG', '11556510000000008J5L', '102665100000000073LI', '10956510000000005J45', '10218910000000000IIP', '11556510000000016JUY', '10236510000000008OBW', '10228910000000001KC0', '115565100000000017ZE', '11556510000000018SPC', '000165100000000JPJB4', '115565100000000014TI', '11556510000000001639', '000165100000000GEY3U', '1155G4100000000272VU', '1155G41000000001MWDD', '1155651000000000T42S', '11556510000000015UPS', '113065100000000027MT', '000165100000000CSERZ', '0001A91000000000PBUF', '1155G41000000002C1BT', '1029651000000000DCPL', '000165100000000GD62V', '1155G41000000001L2RL', '1155G41000000001MUCO', '11556510000000018LHZ', '1155651000000000RP5U', '1022651000000000XO6O', '1010651000000000E2YW', '1155G41000000001M8VE', '1155651000000000UCJA', '1026651000000000RGNP', '000165100000000GD63L', '1155651000000000USE9', '1155651000000000162M', '1155G41000 000002KS51', '0001A91000000000PBSZ', '00018910000000014QXW', '11556510000000000WW8', '11556510000000000WVW', '1013A9100000000000XL', '1155651000000001FDP8', '11556510000000016A8X', '1155G41000000002C1EL', '1155G41000000002C1BL', '11556510000000001CM1', '1003A910000000001HCI', '115565100000000012RC', '102089100000000009DB', '0001891000000000XYK5', '1026651000000000UMPG', '000165100000000GF6P4', '1003A91000000000IU4V', '1155G410000000027VLJ', '10298910000000007O8O', '11556510000000000U3H', '10846510000000001KDZ', '11556510000000001COD', '11556510000000000U51', '11556510000000000U4P', '0001G41000000016P9BR', '1155651000000000162F', '10388910000000000358', '000165100000000GS9P8', '1155651000000000A0GK', '10696510000000005929', '0001A910000000000WS5', '0001A910000000000WRT', '11556510000000009YSZ', '102965100000000155KW', '1155651000000000B1DS', '000165100000000GF6PL', '1155G41000000002BV0E', '11556510000000019XU7', '1020651000000000HSGY', '1155G41000000002K7OA', '000165100000000GAB5J', '1016891000000000040T', '1155651000000001C0FU', '000165100000000GFPFZ', '1155G41000000002CWJN', '11556510000000000WXK', '1155G41000000002ADQD', '1155G41000000002391F', '0001651000000006A8UK', '10286510000000005LEP', '109465100000000074Y8', '11556510000000001NM7', '115565100000000067SE', '1023651000000000A4ZY', '0001A91000000000PBTL', '11556510000000004Z0W', '107565100000000027JU', '1155G410000000026J37', '1155G410000000027QF9', '1177651000 0000000AT5', '11346510000000006DXT', '000165100000000GH9U4', '1029651000000000ACOQ', '115565100000000018VL', '1155G41000000002979Y', '1022651000000000L4BD', '1155G41000000002CWDJ', '0001651000000006A7ES', '1155G41000000002AH1Y', '10778910000000000EBL', '1155651000000000POEP', '0001A91000000000PBSJ', '1011A9100000000000ZZ', '1155G41000000002F7VV', '1155G41000000002BRHG', '1155651000000000AI6I', '1155G41000000001LVJW', '115565100000000011T6', '1155G41000000002BXIU', '1022651000000000MCBQ', '00018910000000012D8E', '1155651000000000YD3E', '10696510000000011O32', '11556510000000004Z0H', '1155G41000000002CDBX', '1155G41000000002L7GZ', '10876510000000002NP7', '1056891000000000070H', '101889100000000045P7', '1026G41000000001UG11', '1155G410000000025XKG', '1155651000000000B7JT', '1102651000000000ZEZ1', '106965100000000024E9', '10226510000000009YTF', '1004A9100000000001QU', '11556510000000000U59', '11556510000000000U4X', '0001A91000000000PBR4', '10178910000000000YQB', '1022651000000000CJXY', '11556510000000001COL', '1155651000000001AAZH', '10228910000000000MED', '1018651000000000VVHV', '1155G41000000002CFDY', '1155G41000000002A7JE', '1007A9100000000002R6', '0001A91000000000PBRR', '11556510000000005TOK', '1155651000000000PBOZ', '105589100000000006ZE', '1431G410000000001FPM', '112565100000000080XN', '11556510000000001CRT', '102665100000000087ZH', '0001A910000000000R7A', '1020891000000000039D', '1155651000000000RUD9', '1155G41000 000002L9R5', '11626510000000001AOP', '1155F110000000020UFI', '1094651000000000317I', '11856510000000000A15', '1022651000000000RKAJ', '11556510000000000N6Y', '1081651000000000LZPX', '1155G41000000002CVUB', '1094651000000000FFTA', '11056510000000002YHH', '101889100000000036RL', '1155G410000000026E8N', '11556510000000000WYW', '000165100000000GF6V8', '1155G41000000002C1CI', '11556510000000000N6A', '0001A910000000000QVU', '10696510000000004PSI', '1038651000000002VBQZ', '0001891000000001267V', '11556510000000001CMX', '11556510000000001CN9', '115565100000000018UT', '115565100000000018V5', '1155651000000000UDER', '115565100000000018XL', '1155651000000000116V', '1155G41000000001JSIO', '1026651000000000KIFD', '000189100000000159DX', '1155G41000000002CVZW', '00018910000000014QV5', '1155651000000000CTF5', '1155G41000000001PX8L', '1155G41000000002CVSA', '115565100000000018WT', '115565100000000018X5', '102089100000000003BH', '0001A91000000000PBRY', '11556510000000000U4H', '10196510000000005GSN', '115565100000000011UJ', '1155G410000000026XG4', '1155651000000000CQDO', '1023651000000000CH5Q', '115565100000000012RS', '1155G41000000002ISNX', '1022891000000000178I', '101889100000000002E9', '1029651000000000ES5U', '10776£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡àÖÒ»£¿£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿Ü¥£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿ £¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿µ¶«£¿£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿µ¶£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†e£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†e£¿ …¸£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿…¸Ò»£¿£¿£¿£¿£¿¡¡£¿¡¡£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿¡¡ÔÈ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿µ¶‚t£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†e£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿ÔÈ£¿Ü¥£¿£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡…¸£¿£¿£¿£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿†e£¿‰Þ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿àÖ£¿£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿Ü¥£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿«‰Þ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿…¸£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿‰Þ…¸Ü¥£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿‚t£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿…¸£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿Ü¥£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡‚t£¿µ¶Ò»£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿Ò»£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿ÔÈ£¿‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿‡ó£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿Ü¥£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿ƒx£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ƒx£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿ÔȆe£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†e£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿«£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿†e£¿£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿ £¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿Ü¥àÖ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿…¸¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿ƒx£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡‰Þ£¿£¿«£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿¡¡£¿£¿£¿£¿£¿£¿£¿¡¡£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿ƒxƒx£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿«£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡†eÔÈ£¿ƒx£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡£¿£¿£¿‚t£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿¡¡¡¡¡¡¡¡00001CN1', '00016510000000068SBG', '0001A91000000000PBTD', '104989100000000008OT', '1155F11000000002S1Y6', '1155G410000000024REJ', '0001A910000000000QHA', '1155651000000000V22P', '1155G41000000002HKSD', '1155651000000000TAW8', '1155651000000000SWWC', '000165100000000CSERW', '115565100000000018TX', '115565100000000018U9', '115565100000000019JH', '1155651000000000RPUE', '1155G41000000002D4IB', '000165100000000 GF6VP', '1155G410000000026R9Q', '11556510000000000WXW', '11556510000000000WY8', '00016510000000068S6U', '10298910000000007ZT5', '102189100000000002D9', '10208910000000001I25', '10238910000000000VMX', '1155G410000000026YIW', '10228910000000002XPL', '115565100000000012M3', '1074651000000000AH4V', '1022651000000000A82S', '1155G410000000026UTZ', '1019651000000000839Q', '1155G41000000002B615', '000165100000000GFPFT', '1155651000000001B77C', '1155651000000000WBO4', '1155G410000000028CH0', '11556510000000000ZY7', '1155G41000000002F56S', '11556510000000018GB5', '1155G410000000026WAO', '1155G41000000002CY1P', '1155G41000000002KULM', '1155G410000000022W0S', '115565100000000018TP', '115565100000000018U1', '1155651000000000BQ3R', '1155G41000000002KFHS', '11556510000000009T0F', '1023651000000000C2JX', '0001A91000000000PBR6', '0001A91000000000PBQU', '115565100000000012RG', '1155F11000000001Y1S4', '1155G41000000002CWN5', '1155651000000000QNYO', '1155651000000000YH62', '0001A91000000000PBTT', '0001A91000000000PBU5', '1155G41000000002CXGH', '1155G41000000001LKCN', '1022651000000000ZRFR', '1028G41000000001A0CZ', '1090651000000000A2OK', '1155F11000000001QWSN', '1155F11000000001Y80B', '115565100000000018YH', '1155651000000000PTU3', '1155F11000000001Y0ND', '1155G41000000001MSN5', '116665100000000009EH', '11556510000000000WWC', '0001G41000000018VXSW', '1155651000000000UY9Y', '1155G410000000026C7X', '000165100000000GD63C', '115565100000000 017AZ', '1094651000000000HTA8', '11556510000000007YK9', '1155651000000000D7DQ', '1032651000000000PAJ1', '1155651000000001F53O', '115065100000000012NV', '1155F11000000001Y1QG', '11556510000000001CMH', '1022891000000000179I', '0001A910000000000WSH', '1017651000000001MT1T', '1155651000000001CBB1', '1029651000000000CYTT', '11556510000000008J5F', '000165100000000GD65B', '1155G41000000002NKMY', '1155G410000000028OF8', '1155G410000000026CDK', '00018910000000012DAB', '1391G410000000001CN3', '114165100000000022UR', '11556510000000000ZXC', '11556510000000001CRH', '1155G41000000002A2VJ', '115565100000000012L5', '1155651000000000WZWS', '11556510000000000U5Y', '1022651000000001803X', '1155651000000000XR7A', '1155651000000000STWL', '1155G410000000026V0V', '1155G41000000001JRRD', '1155651000000000RP9X', '000189100000000126BT', '10208910000000000FFQ', '1028G41000000001ASD9', '1155651000000000SYR5', '1155G41000000002JL1Y', '11556510000000000N5Y', '11556510000000004ID0', '1155G41000000002DRP6', '11556510000000000N77', '115565100000000012R8', '102489100000000002E1', '1155G41000000002EBGO', '10326510000000009D7N', '1155651000000000RO57', '1155G410000000027WT2', '000165100000000GS9PJ', '0001A91000000000PBS0', '1155F110000000020S7T', '1155G410000000029JBA', '0001A91000000000PBUN', '000165100000000GF6Q4', '101789100000000004VE', '11556510000000000U62', '11556510000000000U5Q', '000165100000000W9ZCK', '11556510000000004X6M', '000165100000000 GN83P', '0001A910000000000QDC', '0001651000000006A81C', '102989100000000002C1', '1155G41000000002CWY0', '1155F11000000002QTWF', '11556510000000000WWK', '115565100000000018SL', '10798910000000000VMZ', '11556510000000000WZP', '115565100000000018ZP', '1155G410000000026IX1', '10206510000000007QJT', '0001A91000000000PBRW', '0001A91000000000PBS8', '11556510000000004YJX', '1155651000000000SJ1R', '1155F11000000002OV61', '101989100000000002DH', '1155G410000000026S4A', '1155G41000000002NKN2', '11556510000000019848', '1155G41000000002C1B9', '1155G41000000002INXY', '1155G41000000002EAUM', '1155G4100000000270KU', '1155G41000000001OTSG', '11556510000000000U3L', '1155651000000000RGMY', '1032F11000000001WSWM', '11556510000000019LIL', '1003A9100000000012ZQ', '1155G41000000002DOTI', '107765100000000031OA', '102465100000000B9JLW', '115565100000000018UP', '115565100000000018V1', '1155F11000000001ZHHJ', '1155G41000000002DKA2', '1155G41000000002CWMY', '000165100000000H2I67', '0001A91000000000PBSA', '1004A9100000000002PB', '1155G410000000026DIY', '0001A91000000000PBTR', '0001A91000000000PBU3', '102689100000000002DL', '1155G410000000028BCP', '1155G41000000001N76T', '000165100000000GF6SX', '1155651000000000R2P8', '000165100000000GCOV3', '1155G410000000028F68', '000165100000000BYON9', '115565100000000164LS', '1155G41000000002KA40', '1155F11000000001Y0N9', '115565100000000015R4', '1155651000000001A0OY', '11556510000000007OBG', '103889100000000 0036S', '000165100000000GF6QA', '1155G41000000001JSVN', '1155G41000000002O5GU', '10218910000000002P8U', '0001651000000006A7AU', '1030651000000000F9TJ', '1022891000000000040D', '1155651000000001C6S3', '11556510000000000U7A', '11556510000000000WZH', '115565100000000018ZH', '1155F11000000002IW6H', '10736510000000001SXH', '115565100000000018XX', '115565100000000018Y9', '000165100000000GF6PI', '1155G41000000002JNTQ', '11556510000000008965', '1155G410000000027MJM', '1155651000000000107X', '1155G41000000002MORA', '115565100000000015AL', '1024651000000000CD9F', '11556510000000000ZPZ', '0001A91000000000PBRH', '1155G41000000002C1CE', '115565100000000018YP', '115565100000000018Z1', '0001651000000006A7OC', '1155651000000000ONNT', '11776510000000003X7D', '1155G41000000002CGRP', '10226510000000009Y29', '10506510000000007F0V', '115565100000000011UB', '1155651000000000Q5FG', '1155G410000000025YEF', '10218910000000001B35', '1155651000000000BT5L', '1155G410000000026CJY', '000165100000000GFPFQ', '000165100000000GFPG2', '0001A910000000000WS7', '0001A910000000000WRV' ) OR bd_cubasdoc.pk_cubasdoc IN ( '115565100000000018RL', '1029651000000000E6SX', '11556510000000000U92', '11556510000000000U8Q', '1155G41000000002FIFV', '115565100000000019J9', '1155G410000000020ICG', '11556510000000000WYG', '115565100000000018WD', '1155651000000000PBOK', '1155651000000000POF7', '11556510000000018XCY', '1155651000000001I43V', '115565100000000014T9', '11556510 000000001CNP', '11556510000000001CO1', '0001891000000001264H', '1003A910000000024FYS', '10288910000000000Q99', '1155651000000001F18S', '1077651000000000DOAA', '10696510000000004I23', '1003A910000000002DZK', '0001651000000006A8UQ', '12466510000000001J0F', '0001A91000000000PBSL', '10288910000000001BU9', '10228910000000002UML', '1155G41000000002INW4', '11556510000000000U7Y', '115565100000000018RD', '1155651000000001C2UN', '0001A91000000000PBRP', '1155651000000000CO2X', '1155G4100000000271UX', '0001A910000000000VB8', '00016510000000068RZS', '1155651000000001C2SK', '1155651000000000BR1Y', '1155G41000000002C1B1', '102389100000000002E5', '11556510000000000U6I', '1155651000000000UBZH', '11556510000000000U82', '11556510000000000U7Q', '115565100000000018UH', '11556510000000001P95', '11556510000000000R09', '1155651000000000UB2F', '10866510000000003J3M', '1155G41000000002CWY7', '0001A91000000000PBTZ', '11556510000000000U8A', '115565100000000011UR', '115565100000000011V3', '000165100000000GF6PR', '11556510000000000X0H', '1155G41000000001X3X5', '1155651000000001C7CF', '10088910000000001AAX', '10296510000000016AXL', '11426510000000000AUK', '1155G41000000001L4UC', '1020651000000000H0R6', '1155651000000000TD0W', '1155G410000000026BSZ', '11556510000000000U7I', '1155G41000000002NKPT', '0001A91000000000PBUD', '1155651000000000B609', '1091651000000000AMQC', '1155G41000000002LICT', '10268910000000000IKE', '1155651000000001BJ0G', '1155F110 00000002RHTW', '11556510000000000YU6', '11556510000000001EB8', '10718910000000000IN1', '1155G41000000002FRXP', '1155651000000000D7D6', '1155651000000000SEXN', '11556510000000001CPL', '1155F11000000002IW4T', '115565100000000018R5', '1155F110000000026HO1', '11556510000000000U6Y', '101789100000000016H2', '10186510000000013MM5', '1155651000000000XSQK', '1155G41000000002D47O', '1155G41000000002FRB5', '10218910000000001E8U', '1155G41000000001OF5V', '115565100000000018WL', '10916510000000001TP5', '11556510000000001561', '1003A91000000002LN36', '11556510000000001CPD', '10708910000000000K6T', '0001891000000001EC3L', '1018651000000000NN75', '1022651000000000CJYM' ) ) AND ( pk_cubasdoc in ( select pk_cubasdoc from bd_cumandoc where pk_corp = '1155' ) )
8mf0whbta05sb SELECT DISTINCT head.burgency, head.capproverid, head.cbilltypecode, head.clastoperatorid, head.coperator, head.crequireappid, head.dapplydate, head.dauditdate, head.freqtypeflag, head.fstatusflag, head.iprintcount, head.pk_corp, head.pk_hdefdoc1, head.pk_hdefdoc10, head.pk_hdefdoc11, head.pk_hdefdoc12, head.pk_hdefdoc13, head.pk_hdefdoc14, head.pk_hdefdoc15, head.pk_hdefdoc16, head.pk_hdefdoc17, head.pk_hdefdoc18, head.pk_hdefdoc19, head.pk_hdefdoc2, head.pk_hdefdoc20, head.pk_hdefdoc3, head.pk_hdefdoc4, head.pk_hdefdoc5, head.pk_hdefdoc6, head.pk_hdefdoc7, head.pk_hdefdoc8, head.pk_hdefdoc9, head.taudittime, head.tlastmaketime, head.tmaketime, head.ts, head.vbillcode, head.vhdef1, head.vhdef10, head.vhdef11, head.vhdef12, head.vhdef13, head.vhdef14, head.vhdef15, head.vhdef16, head.vhdef17, head.vhdef18, head.vhdef19, head.vhdef2, head.vhdef20, head.vhdef3, head.vhdef4, head.vhdef5, head.vhdef6, head.vhdef7, head.vhdef8, head.vhdef9, head.vmemo FROM po_requireapp head INNER JOIN po_requireapp_b body ON ( head.crequireappid = body.crequireappid and body.dr = 0 ) LEFT OUTER JOIN po_requireapp_b body2 ON body2.csourcebid2 = '422X' and body2.csourcebid2 = body.crequireapp_bid and body2.dr = 0 and body2.creqcalbodyid = body.creqcalbodyid WHERE ( ( head.freqtypeflag = 1 ) and ( nvl ( body.bendgather, 'N' ) = 'N' ) ) and ( head.pk_corp = '1078' and head.fstatusflag = 1 AND ( head.freqtypeflag = 0 OR ( head.freqtypeflag = 1 AND nvl( body.csourcetypecode, ' ' ) != '422X' ) ) AND nvl( body.bclose, 'N' ) = 'N' AND nvl( body.naccuoutnum, 0.0 ) < nvl( body.nnum, 0.0 ) AND body2.crequireapp_bid is null )
8swc03d362v74select vmainlicense, vpairlicense from meam_vehicle where rownum<16 and ( vmainlicense like :1 or vpairlicense like :2 ) and ( dr = 0 or dr is null )
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
8vkjh60z1g287 select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, a.schedule_limit SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, v$instance i where bitand(a.job_status, 515) = 1 and ( i.logins = 'ALLOWED' or bitand(a.flags, 2147483648) <> 0 ) and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c, v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :4 and c.next_start_date + c.duration > :5 and i.logins = 'AL LOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 3, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d, v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :6 and d.next_start_date + d.duration > :7 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 4), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.name = 'CURRENT_OPEN_WINDOW' and e.value = f.name and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 3, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and ik.logins = 'ALLOWED' and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and h.attr_tstamp is not null and h.attr_intv is not null) order by RUNTIME, CLSOID, PRI, WT DESC, OBJOID
8x6qfz2r732hwselect finishflag from pub_billaction where pk_billType = :1 and actiontype = :2
9539rk3kwp5b5select a.pk_checkflow, a.pk_billtype, a.billno, a.actiontype, a.senderman, c.user_name, a.ischeck, a.checkman, a.checknote, a.senddate, a.dealdate, a.messagenote, a.pk_corp, a.pk_businesstype, a.billid, a.priority, a.approvestatus, a.userobject, a.workflow_type from pub_workflownote a left outer join sm_user c on a.senderman = c.cuserid where a.checkman = :1 and ( a.approvestatus is null or a.approvestatus != 4 ) and a.receivedeleteflag = 'N' and a.approvestatus = 0 and ischeck = 'N' order by senddate desc
9cakzhc23v156select procmsg from tmp_bill_proc tmptab where exists ( select pk_proc from dap_finmsg where pk_proc = tmptab.pk_billtype and procmsg = tmptab.procmsg )
aj37st6bd0gyqbegin :n_Return_Number := nfsn_func_000(:1, :2, :3, :4, :5, :6); end;
as02f6azutjwtselect templateflag, templateid, operator, pk_corp, nodekey from pub_systemplate where funnode = :1 and tempstyle = :2 and ( templateflag = 'Y' or ( pk_org = :3 and nodekey = :4 and operator_type = 1 and operator = :5 ) )
ayd7gwk0296dtSELECT COUNT(*) FROM ALL_USERS WHERE USER_ID = :B1
b1wc53ddd6h3pselect audit$, options from procedure$ where obj#=:1
b2gg09hzxsuq9 select mean.doperatdate, mean.pk_busitype, busitype.businame, mean.cponderid, mean.ccustomerid, cubasdockh.custname ccustomername, mean.cinvoicecustid, cubasdockpkh.custname cinvoicecustname, mean.pk_org, salestru.vsalestruname orgname, salepreorder.careaflowid, defdocqylx.docname careaflowname, salepreorder.ccementflowid, defdocsnlx.docname ccementflowname, mean.pk_defdoc16, defdockslx.docname custtypename, mean.cinventoryid, invbasdoc.invcode cinvbasdocname, invbasdoc.invname cinventoryname, mean.nsuttle, mean.vcarnumber, mean.vbatchnumber, mean.vsaleorderid, salepreorder.bstaticflg, mean.norigtaxprice, mean.norigsummny, decode ( nvl ( nsuttle, 0 ), 0, null, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) ) /nsuttle ) norignetprice, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) ) noutafternum, mean.noutnum, mean.ntransprice, mean.ntransmny, mean.nwaitfreight, mean.ntotalinvoicenum, mean.nalreadytrannum, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) + nvl ( mean.ntransmny, 0 ) ) norigtaxmny, mean.cdeptid, deptdoc.deptname cdeptname, mean.cemployeeid, psndoc.psnname cemployeename, mean.cconsigncorpid, bdcorp.unitname cconsigncorpname, mean.creceiveaddressid, areacl.areaclname creceiveaddressname, mean.ctruecustomerid, cubasdocjbr.custname ctruecustomername, salepreorder.vnote, mean.ctransporttypeid, sendtype.sendname ctransporttypename, mean.ctransitcorpid, cubasdocysdw.custname ctransitco rpname, salepreorder.vbillno, mean.pk_so_meannc, salepreorderb.pk_saledispose_b, salepreorder.pk_saledispose_h, mean.vdef1, mean.vdef2, mean.vdef3, mean.vdef4, mean.vdef5, mean.vdef6, mean.vdef7, mean.vdef8, mean.vdef9, mean.vdef10, mean.vdef11, mean.vdef12, mean.vdef13, mean.vdef14, mean.vdef15, mean.vdef16, mean.vdef17, mean.vdef18, mean.vdef19, mean.vdef20, salepreorderb.nnum nordernum from so_meannc mean inner join so_salepreorder_b salepreorderb on mean.pk_saledispose_b = salepreorderb.pk_saledispose_b inner join so_salepreorder salepreorder on salepreorderb.pk_saledispose_h = salepreorder.pk_saledispose_h left outer join bd_busitype busitype on mean.pk_busitype = busitype.pk_busitype left outer join bd_cumandoc cumandockh on mean.ccustomerid = cumandockh.pk_cumandoc left outer join bd_cubasdoc cubasdockh on cumandockh.pk_cubasdoc = cubasdockh.pk_cubasdoc left outer join bd_cumandoc cumandockpkh on mean.cinvoicecustid = cumandockpkh.pk_cumandoc left outer join bd_cubasdoc cubasdockpkh on cumandockpkh.pk_cubasdoc = cubasdockpkh.pk_cubasdoc left outer join bd_salestru salestru on mean.pk_org = salestru.csalestruid left outer join bd_defdoc defdocqylx on salepreorder.careaflowid = defdocqylx.pk_defdoc left outer join bd_defdoc defdocsnlx on salepreorder.ccementflowid = defdocsnlx.pk_defdoc left outer join bd_defdoc defdockslx on mean.pk_defdoc16 = defdockslx.pk_defdoc left outer join bd_invmandoc invmandoc on invmandoc.pk_invmandoc = mean.cinventory id left outer join bd_invbasdoc invbasdoc on invbasdoc.pk_invbasdoc = invmandoc.pk_invbasdoc left outer join bd_deptdoc deptdoc on mean.cdeptid = deptdoc.pk_deptdoc left outer join bd_psndoc psndoc on mean.cemployeeid = psndoc.pk_psndoc left outer join bd_corp bdcorp on mean.cconsigncorpid = bdcorp.pk_corp left outer join bd_areacl areacl on mean.creceiveaddressid = areacl.pk_areacl left outer join bd_cumandoc cumandocjbr on mean.ctruecustomerid = cumandocjbr.pk_cumandoc left outer join bd_cubasdoc cubasdocjbr on cumandocjbr.pk_cubasdoc = cubasdocjbr.pk_cubasdoc left outer join bd_sendtype sendtype on sendtype.pk_sendtype = mean.ctransporttypeid left outer join bd_cubasdoc cubasdocysdw on cubasdocysdw.pk_cubasdoc = mean.ctransitcorpid where ( mean.doperatdate >= '2013-12-06' ) and ( mean.doperatdate <= '2013-12-06' ) and mean.dr = 0 and mean.pk_corp = '1131'
b6vxaxdx93w36select configflag, operator, a.classname aclassname, a.returntype areturntype, a.functionnote afunctionnote, a.method amethod, a.parameter aparameter, ysf, value, b.classname bclassname, b.functionnote bfunctionnote, b.method bmethod, b.parameter bparameter, errhintmsg, c.isbefore from pub_actionconstrict c inner join pub_function a on c.functionid = a.pk_function left outer join pub_function b on c.value = b.pk_function where ( pk_corp = :1 or pk_corp = '@@@@' ) and c.pk_billtype = :2 and actiontype = :3 and pk_businesstype = :4 and ( configflag = 1 or ( configflag = 2 and operator = :5 ) or ( configflag = 3 and operator in ( select pk_role from sm_user_role where cuserid = :6 and pk_corp = :7 ) ) ) order by c.sysindex
b7uay8bnq0d6b select mean.doperatdate, mean.pk_busitype, busitype.businame, mean.cponderid, mean.ccustomerid, cubasdockh.custname ccustomername, mean.cinvoicecustid, cubasdockpkh.custname cinvoicecustname, mean.pk_org, salestru.vsalestruname orgname, salepreorder.careaflowid, defdocqylx.docname careaflowname, salepreorder.ccementflowid, defdocsnlx.docname ccementflowname, mean.pk_defdoc16, defdockslx.docname custtypename, mean.cinventoryid, invbasdoc.invcode cinvbasdocname, invbasdoc.invname cinventoryname, mean.nsuttle, mean.vcarnumber, mean.vbatchnumber, mean.vsaleorderid, salepreorder.bstaticflg, mean.norigtaxprice, mean.norigsummny, decode ( nvl ( nsuttle, 0 ), 0, null, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) ) /nsuttle ) norignetprice, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) ) noutafternum, mean.noutnum, mean.ntransprice, mean.ntransmny, mean.nwaitfreight, mean.ntotalinvoicenum, mean.nalreadytrannum, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) + nvl ( mean.ntransmny, 0 ) ) norigtaxmny, mean.cdeptid, deptdoc.deptname cdeptname, mean.cemployeeid, psndoc.psnname cemployeename, mean.cconsigncorpid, bdcorp.unitname cconsigncorpname, mean.creceiveaddressid, areacl.areaclname creceiveaddressname, mean.ctruecustomerid, cubasdocjbr.custname ctruecustomername, salepreorder.vnote, mean.ctransporttypeid, sendtype.sendname ctransporttypename, mean.ctransitcorpid, cubasdocysdw.custname ctransitco rpname, salepreorder.vbillno, mean.pk_so_meannc, salepreorderb.pk_saledispose_b, salepreorder.pk_saledispose_h, mean.vdef1, mean.vdef2, mean.vdef3, mean.vdef4, mean.vdef5, mean.vdef6, mean.vdef7, mean.vdef8, mean.vdef9, mean.vdef10, mean.vdef11, mean.vdef12, mean.vdef13, mean.vdef14, mean.vdef15, mean.vdef16, mean.vdef17, mean.vdef18, mean.vdef19, mean.vdef20, salepreorderb.nnum nordernum from so_meannc mean inner join so_salepreorder_b salepreorderb on mean.pk_saledispose_b = salepreorderb.pk_saledispose_b inner join so_salepreorder salepreorder on salepreorderb.pk_saledispose_h = salepreorder.pk_saledispose_h left outer join bd_busitype busitype on mean.pk_busitype = busitype.pk_busitype left outer join bd_cumandoc cumandockh on mean.ccustomerid = cumandockh.pk_cumandoc left outer join bd_cubasdoc cubasdockh on cumandockh.pk_cubasdoc = cubasdockh.pk_cubasdoc left outer join bd_cumandoc cumandockpkh on mean.cinvoicecustid = cumandockpkh.pk_cumandoc left outer join bd_cubasdoc cubasdockpkh on cumandockpkh.pk_cubasdoc = cubasdockpkh.pk_cubasdoc left outer join bd_salestru salestru on mean.pk_org = salestru.csalestruid left outer join bd_defdoc defdocqylx on salepreorder.careaflowid = defdocqylx.pk_defdoc left outer join bd_defdoc defdocsnlx on salepreorder.ccementflowid = defdocsnlx.pk_defdoc left outer join bd_defdoc defdockslx on mean.pk_defdoc16 = defdockslx.pk_defdoc left outer join bd_invmandoc invmandoc on invmandoc.pk_invmandoc = mean.cinventory id left outer join bd_invbasdoc invbasdoc on invbasdoc.pk_invbasdoc = invmandoc.pk_invbasdoc left outer join bd_deptdoc deptdoc on mean.cdeptid = deptdoc.pk_deptdoc left outer join bd_psndoc psndoc on mean.cemployeeid = psndoc.pk_psndoc left outer join bd_corp bdcorp on mean.cconsigncorpid = bdcorp.pk_corp left outer join bd_areacl areacl on mean.creceiveaddressid = areacl.pk_areacl left outer join bd_cumandoc cumandocjbr on mean.ctruecustomerid = cumandocjbr.pk_cumandoc left outer join bd_cubasdoc cubasdocjbr on cumandocjbr.pk_cubasdoc = cubasdocjbr.pk_cubasdoc left outer join bd_sendtype sendtype on sendtype.pk_sendtype = mean.ctransporttypeid left outer join bd_cubasdoc cubasdocysdw on cubasdocysdw.pk_cubasdoc = mean.ctransitcorpid where ( mean.doperatdate >= '2013-12-08' ) and ( mean.doperatdate <= '2013-12-08' ) and mean.dr = 0 and mean.pk_corp = '1019'
b8gv77h3fb5c1 select mean.doperatdate, mean.pk_busitype, busitype.businame, mean.cponderid, mean.ccustomerid, cubasdockh.custname ccustomername, mean.cinvoicecustid, cubasdockpkh.custname cinvoicecustname, mean.pk_org, salestru.vsalestruname orgname, salepreorder.careaflowid, defdocqylx.docname careaflowname, salepreorder.ccementflowid, defdocsnlx.docname ccementflowname, mean.pk_defdoc16, defdockslx.docname custtypename, mean.cinventoryid, invbasdoc.invcode cinvbasdocname, invbasdoc.invname cinventoryname, mean.nsuttle, mean.vcarnumber, mean.vbatchnumber, mean.vsaleorderid, salepreorder.bstaticflg, mean.norigtaxprice, mean.norigsummny, decode ( nvl ( nsuttle, 0 ), 0, null, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) ) /nsuttle ) norignetprice, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) ) noutafternum, mean.noutnum, mean.ntransprice, mean.ntransmny, mean.nwaitfreight, mean.ntotalinvoicenum, mean.nalreadytrannum, ( nvl ( mean.norigsummny, 0 ) - nvl ( mean.noutnum, 0 ) + nvl ( mean.ntransmny, 0 ) ) norigtaxmny, mean.cdeptid, deptdoc.deptname cdeptname, mean.cemployeeid, psndoc.psnname cemployeename, mean.cconsigncorpid, bdcorp.unitname cconsigncorpname, mean.creceiveaddressid, areacl.areaclname creceiveaddressname, mean.ctruecustomerid, cubasdocjbr.custname ctruecustomername, salepreorder.vnote, mean.ctransporttypeid, sendtype.sendname ctransporttypename, mean.ctransitcorpid, cubasdocysdw.custname ctransitco rpname, salepreorder.vbillno, mean.pk_so_meannc, salepreorderb.pk_saledispose_b, salepreorder.pk_saledispose_h, mean.vdef1, mean.vdef2, mean.vdef3, mean.vdef4, mean.vdef5, mean.vdef6, mean.vdef7, mean.vdef8, mean.vdef9, mean.vdef10, mean.vdef11, mean.vdef12, mean.vdef13, mean.vdef14, mean.vdef15, mean.vdef16, mean.vdef17, mean.vdef18, mean.vdef19, mean.vdef20, salepreorderb.nnum nordernum from so_meannc mean inner join so_salepreorder_b salepreorderb on mean.pk_saledispose_b = salepreorderb.pk_saledispose_b inner join so_salepreorder salepreorder on salepreorderb.pk_saledispose_h = salepreorder.pk_saledispose_h left outer join bd_busitype busitype on mean.pk_busitype = busitype.pk_busitype left outer join bd_cumandoc cumandockh on mean.ccustomerid = cumandockh.pk_cumandoc left outer join bd_cubasdoc cubasdockh on cumandockh.pk_cubasdoc = cubasdockh.pk_cubasdoc left outer join bd_cumandoc cumandockpkh on mean.cinvoicecustid = cumandockpkh.pk_cumandoc left outer join bd_cubasdoc cubasdockpkh on cumandockpkh.pk_cubasdoc = cubasdockpkh.pk_cubasdoc left outer join bd_salestru salestru on mean.pk_org = salestru.csalestruid left outer join bd_defdoc defdocqylx on salepreorder.careaflowid = defdocqylx.pk_defdoc left outer join bd_defdoc defdocsnlx on salepreorder.ccementflowid = defdocsnlx.pk_defdoc left outer join bd_defdoc defdockslx on mean.pk_defdoc16 = defdockslx.pk_defdoc left outer join bd_invmandoc invmandoc on invmandoc.pk_invmandoc = mean.cinventory id left outer join bd_invbasdoc invbasdoc on invbasdoc.pk_invbasdoc = invmandoc.pk_invbasdoc left outer join bd_deptdoc deptdoc on mean.cdeptid = deptdoc.pk_deptdoc left outer join bd_psndoc psndoc on mean.cemployeeid = psndoc.pk_psndoc left outer join bd_corp bdcorp on mean.cconsigncorpid = bdcorp.pk_corp left outer join bd_areacl areacl on mean.creceiveaddressid = areacl.pk_areacl left outer join bd_cumandoc cumandocjbr on mean.ctruecustomerid = cumandocjbr.pk_cumandoc left outer join bd_cubasdoc cubasdocjbr on cumandocjbr.pk_cubasdoc = cubasdocjbr.pk_cubasdoc left outer join bd_sendtype sendtype on sendtype.pk_sendtype = mean.ctransporttypeid left outer join bd_cubasdoc cubasdocysdw on cubasdocysdw.pk_cubasdoc = mean.ctransitcorpid where ( mean.doperatdate >= '2013-12-09' ) and ( mean.doperatdate <= '2013-12-09' ) and mean.dr = 0 and mean.pk_corp = '1087'
bdv0rkkssq2jmSELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPF'
bj7xs3yz6g3ukselect pk, path, creator, isfolder, time, filelength from sm_pub_filesystem where path = :1 or path like :2
bwq4c63ng4j09 select distinct B.cinvbasid, A.vuserdef1, A.vuserdef2, A.vuserdef3, A.vuserdef4, A.vuserdef5, A.vuserdef6, A.vuserdef7, A.vuserdef8, A.vuserdef9, A.vuserdef10, A.cdispatcherid, A.cbizid, A.vnote, A.cwhsmanagerid, A.cdptid, A.cbilltypecode, B.cprojectid, B.cprojectphaseid, B.cfirsttype, B.cfirstbillbid, B.cfirstbillhid, B.ninassistnum, B.hsl, B.nplannedmny, B.castunitid, B.dbizdate, vbillcode, dbilldate, cproviderid, A.cgeneralhid, B.cgeneralbid, B.cinventoryid, B.vuserdef1, B.vuserdef2, B.vuserdef3, B.vuserdef4, B.vuserdef5, B.vuserdef6, B.vfree1, B.vfree2, B.vfree3, B.vfree4, B.vfree5, ninnum, naccountnum1, naccountmny, cwarehouseid, A.pk_corp, nmaterialmoney, cgeneralbb3, A.ts, B.ts, C.ts, cbiztype, vbatchcode, csourcebillhid, csourcebillbid, crowno, A.pk_calbody, npprice, npmoney, dzgdate, A.vuserdef11, A.vuserdef12, A.vuserdef13, A.vuserdef14, A.vuserdef15, A.vuserdef16, A.vuserdef17, A.vuserdef18, A.vuserdef19, A.vuserdef20, A.pk_defdoc1, A.pk_defdoc2, A.pk_defdoc3, A.pk_defdoc4, A.pk_defdoc5, A.pk_defdoc6, A.pk_defdoc7, A.pk_defdoc8, A.pk_defdoc9, A.pk_defdoc10, A.pk_defdoc11, A.pk_defdoc12, A.pk_defdoc13, A.pk_defdoc14, A.pk_defdoc15, A.pk_defdoc16, A.pk_defdoc17, A.pk_defdoc18, A.pk_defdoc19, A.pk_defdoc20, B.vuserdef7, B.vuserdef8, B.vuserdef9, B.vuserdef10, B.vuserdef11, B.vuserdef12, B.vuserdef13, B.vuserdef14, B.vuserdef15, B.vuserdef16, B.vuserdef17, B.vuserdef 18, B.vuserdef19, B.vuserdef20, B.pk_defdoc1, B.pk_defdoc2, B.pk_defdoc3, B.pk_defdoc4, B.pk_defdoc5, B.pk_defdoc6, B.pk_defdoc7, B.pk_defdoc8, B.pk_defdoc9, B.pk_defdoc10, B.pk_defdoc11, B.pk_defdoc12, B.pk_defdoc13, B.pk_defdoc14, B.pk_defdoc15, B.pk_defdoc16, B.pk_defdoc17, B.pk_defdoc18, B.pk_defdoc19, B.pk_defdoc20, B.cvendorid, bzgyfflag, nzgyfprice, nzgyfmoney, pk_invoicecorp, pk_purcorp, vfirstbillcode, iscalculatedinvcost, C.currencytypeid, noriginalnetprice, norgnettaxprice, noriginaltaxpricemny, noriginalcurmny, nexchangeotobrate, cfeeid, nfeemny, ccorrespondhid, ccorrespondbid, ccorrespondcode from ic_general_h A, ic_general_b B, ic_general_bb3 C, bd_stordoc S, bd_busitype BT where ( A.cbiztype = BT.pk_busitype or A.cbiztype is null ) and A.cwarehouseid = S.pk_stordoc and A.cgeneralhid = B.cgeneralhid and A.cgeneralhid = C.cgeneralhid and B.cgeneralbid = C.cgeneralbid and ( ( dbilldate <= '2013-11-30' ) and ( cproviderid in ( select pk_cumandoc from bd_cumandoc A, bd_cubasdoc B where A.pk_corp = '1046' and custcode = '03308250202' and A.pk_cubasdoc = B.pk_cubasdoc and ( custflag = '1' or custflag = '3' ) ) ) ) and nvl( B.flargess, 'N' ) = 'N' and BT.verifyrule not in ( 'V', 'N' ) and ( nvl( S.iscalculatedinvcost, 'N' ) = 'Y' or A.cwarehouseid is null ) and nvl( S.iscapitalstor, 'N' ) = 'N' and ( A.pk_corp = '1046' and A.pk_corp = B.pk_invoicecorp or A.pk_purcorp <> A.pk_corp and A.pk_purcorp = '1046' and A .pk_purcorp = B.pk_invoicecorp ) and ( cbilltypecode = '45' or cbilltypecode = '46' ) and A.dr = 0 and B.dr = 0 and ( A.fbillflag = 3 or A.fbillflag = 4 ) and upper ( bzgflag ) = 'Y' and naccountnum1 = 0.0 and nvl ( nfeesettletimes, 0 ) = 0 order by vbillcode, crowno
c6awqs517jpj0select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
c8kffcg7mg04tinsert into tmp_gl_rsvoucherpk select distinct ( gl_voucher.pk_voucher ) from gl_voucher, gl_detail where ( gl_voucher.pk_glorgbook = '000165100000000RTCXY' ) and ( ( ( gl_voucher.year = '2013' ) and ( gl_voucher.free1 >= '01' ) ) ) and ( ( ( gl_voucher.free1 <= '11' ) ) ) and ( gl_voucher.errmessage is null and ( gl_voucher.discardflag <> 'Y' ) or gl_voucher.errmessage is not null or ( gl_voucher.discardflag = 'Y' ) ) and ( gl_detail.pk_glorgbook = '000165100000000RTCXY' ) and ( ( ( gl_detail.yearv = '2013' ) and ( gl_detail.free6 >= '01' ) ) ) and ( ( ( gl_detail.free6 <= '11' ) ) ) and ( gl_detail.explanation like '%±£ÏÕ%' ) and gl_voucher.pk_voucher = gl_detail.pk_voucher
cd2zjpv26y5whselect a.pk_messageinfo, a.senderman, b.user_name, a.checkman, a.pk_corp, a.type, a.state, a.url, a.title, a.content, a.senddate, a.priority, a.dealdate, a.billid, a.billno, a.pk_billtype, a.pk_srcbilltype, a.pk_busitype, a.actiontype, a.titlecolor from pub_messageinfo a left outer join sm_user b on a.senderman = b.cuserid where ( ( checkman = :1 and a.type = 1 ) or ( a.type = - 1 and a.state <> 2 and ( a.pk_corp = :2 or a.pk_corp = '0001' ) ) ) and ( a.receivedeleteflag is null or a.receivedeleteflag = 'N' ) and a.state = 0 order by senddate desc
cn1gtsav2d5jhBEGIN BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; END;
cqgv56fmuj63xselect owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
cxscp7btdg0yaselect templateflag, templateid, operator, pk_corp, nodekey from pub_systemplate where funnode = :1 and tempstyle = :2 and ( templateflag = 'Y' or ( pk_org = :3 and nodekey is null and operator_type = 1 and operator = :4 ) )
d4632xbngx6gsselect distinct fbm_baseinfo.pk_baseinfo from fbm_baseinfo left outer join fbm_register on fbm_baseinfo.pk_baseinfo = fbm_register.pk_baseinfo where fbm_register.pk_register is null and nvl ( fbm_register.dr, 0 ) = 0 and nvl ( fbm_baseinfo.dr, 0 ) = 0
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
ds9csubu4dvnsSELECT * FROM pub_billbusiness WHERE pk_billtype = :1 AND pk_businesstype = :2 AND pk_corp = :3
ff9d4mydufrg3 SELECT DISTINCT head.burgency, head.capproverid, head.cbilltypecode, head.clastoperatorid, head.coperator, head.crequireappid, head.dapplydate, head.dauditdate, head.freqtypeflag, head.fstatusflag, head.iprintcount, head.pk_corp, head.pk_hdefdoc1, head.pk_hdefdoc10, head.pk_hdefdoc11, head.pk_hdefdoc12, head.pk_hdefdoc13, head.pk_hdefdoc14, head.pk_hdefdoc15, head.pk_hdefdoc16, head.pk_hdefdoc17, head.pk_hdefdoc18, head.pk_hdefdoc19, head.pk_hdefdoc2, head.pk_hdefdoc20, head.pk_hdefdoc3, head.pk_hdefdoc4, head.pk_hdefdoc5, head.pk_hdefdoc6, head.pk_hdefdoc7, head.pk_hdefdoc8, head.pk_hdefdoc9, head.taudittime, head.tlastmaketime, head.tmaketime, head.ts, head.vbillcode, head.vhdef1, head.vhdef10, head.vhdef11, head.vhdef12, head.vhdef13, head.vhdef14, head.vhdef15, head.vhdef16, head.vhdef17, head.vhdef18, head.vhdef19, head.vhdef2, head.vhdef20, head.vhdef3, head.vhdef4, head.vhdef5, head.vhdef6, head.vhdef7, head.vhdef8, head.vhdef9, head.vmemo FROM po_requireapp head INNER JOIN po_requireapp_b body ON ( head.crequireappid = body.crequireappid and body.dr = 0 ) LEFT OUTER JOIN po_requireapp_b body2 ON body2.csourcebid2 = '422X' and body2.csourcebid2 = body.crequireapp_bid and body2.dr = 0 and body2.creqcalbodyid = body.creqcalbodyid WHERE ( ( head.freqtypeflag = 1 ) and ( head.dapplydate <= '2013-12-09' ) and ( nvl ( body.bendgather, 'N' ) = 'N' ) ) and ( head.pk_corp = '1132' and head.fstatusflag = 1 AND ( head.f reqtypeflag = 0 OR ( head.freqtypeflag = 1 AND nvl( body.csourcetypecode, ' ' ) != '422X' ) ) AND nvl( body.bclose, 'N' ) = 'N' AND nvl( body.naccuoutnum, 0.0 ) < nvl( body.nnum, 0.0 ) AND body2.crequireapp_bid is null )
fy9ta5zgkwqmpSELECT count(*) FROM user_policies o WHERE o.object_name = :tablename AND (policy_name LIKE '%xdbrls%' OR policy_name LIKE '%$xd_%') AND o.function='CHECKPRIVRLS_SELECTPROPF'
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gpxg3p8snws57 SELECT DISTINCT zb.vouchid, zb.bbje, zb.ddhbbm, zb.djbh, zb.djdl, zb.djkjnd, zb.djkjqj, zb.djlxbm, zb.djrq, zb.djzt, zb.dr, zb.dwbm, zb.dyvouchid, zb.dzrq, zb.effectdate, zb.enduser, zb.fbje, zb.fj, zb.fktjbm, zb.inner_effect_date, zb.isonlinepay, zb.jszxzf, zb.kmbm, zb.lrr, zb.lybz, zb.officialprintdate, zb.officialprintuser, zb.pj_num, zb.pj_oid, zb.pzglh, zb.qcbz, zb.qrr, zb.scomment, zb.sfkr, zb.shkjnd, zb.shkjqj, zb.shr, zb.shrq, zb.shzd, zb.sxbz, zb.sxkjnd, zb.sxkjqj, zb.sxr, zb.sxrq, zb.ts, zb.xslxbm, zb.ybje, zb.yhqrkjnd, zb.yhqrkjqj, zb.yhqrr, zb.yhqrrq, zb.ywbm, zb.zdr, zb.zdrq, zb.zyx1, zb.zyx10, zb.zyx11, zb.zyx12, zb.zyx13, zb.zyx14, zb.zyx15, zb.zyx16, zb.zyx17, zb.zyx18, zb.zyx19, zb.zyx2, zb.zyx20, zb.zyx3, zb.zyx4, zb.zyx5, zb.zyx6, zb.zyx7, zb.zyx8, zb.zyx9, zb.zzzt, zb.zgyf, zb.isselectedpay, zb.zyx21, zb.zyx22, zb.zyx23, zb.zyx24, zb.zyx25, zb.zyx26, zb.zyx27, zb.zyx28, zb.zyx29, zb.zyx30, zb.sscause, zb.kskhyh, zb.lastshr, zb.spzt, zb.payman, zb.paydate, zb.settlenum, zb.isnetready, zb.ispaid, zb.isjszxzf, zb.isreded from cmp_busibill zb where exists ( select vouchid from cmp_busibill_b where zb.vouchid = cmp_busibill_b.vouchid and cmp_busibill_b.ddhh in ( '1029G41000000002LL0F' ) and cmp_busibill_b.dr = 0 and zb.dr = 0 )
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 1,076,275 298.29 32.17
CPU used when call started 1,074,167 297.70 32.10
CR blocks created 10,520 2.92 0.31
Cached Commit SCN referenced 1,440 0.40 0.04
Commit SCN cached 1 0.00 0.00
DB time 2,572,133 712.86 76.87
DBWR checkpoint buffers written 51,677 14.32 1.54
DBWR checkpoints 5 0.00 0.00
DBWR fusion writes 21,557 5.97 0.64
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 390 0.11 0.01
DBWR undo block writes 24,211 6.71 0.72
DFO trees parallelized 103 0.03 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 485 0.13 0.01
PX local messages sent 485 0.13 0.01
PX remote messages recv'd 821 0.23 0.02
PX remote messages sent 681 0.19 0.02
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 103 0.03 0.00
RowCR - row contention 565 0.16 0.02
RowCR attempts 77,834 21.57 2.33
RowCR hits 77,208 21.40 2.31
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 35 0.01 0.00
SQL*Net roundtrips to/from client 3,235,857 896.81 96.71
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 18,328 5.08 0.55
application wait time 1,749 0.48 0.05
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 18,221 5.05 0.54
branch node splits 5 0.00 0.00
buffer is not pinned count 231,353,048 64,118.76 6,914.11
buffer is pinned count 1,258,900,257 348,900.19 37,622.91
bytes received via SQL*Net from client 456,993,969 126,654.42 13,657.51
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 1,662,016,417 460,622.54 49,670.26
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 2,903,755 804.77 86.78
calls to kcmgas 327,214 90.69 9.78
calls to kcmgcs 14,600 4.05 0.44
change write time 1,985 0.55 0.06
cleanout - number of ktugct calls 19,080 5.29 0.57
cleanouts and rollbacks - consistent read gets 5,693 1.58 0.17
cleanouts only - consistent read gets 866 0.24 0.03
cluster key scan block gets 291,960 80.92 8.73
cluster key scans 115,766 32.08 3.46
cluster wait time 336,870 93.36 10.07
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 5,314 1.47 0.16
commit batch/immediate requested 5,314 1.47 0.16
commit cleanout failures: block lost 8,853 2.45 0.26
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 561 0.16 0.02
commit cleanout failures: cannot pin 21 0.01 0.00
commit cleanouts 234,912 65.11 7.02
commit cleanouts successfully completed 225,477 62.49 6.74
commit immediate performed 5,314 1.47 0.16
commit immediate requested 5,314 1.47 0.16
commit txn count during cleanout 23,503 6.51 0.70
concurrency wait time 22,293 6.18 0.67
consistent changes 393,122 108.95 11.75
consistent gets 553,707,906 153,458.38 16,547.86
consistent gets - examination 133,174,817 36,908.98 3,980.00
consistent gets direct 4,403 1.22 0.13
consistent gets from cache 553,703,491 153,457.15 16,547.73
current blocks converted for CR 104 0.03 0.00
cursor authentications 50,442 13.98 1.51
data blocks consistent reads - undo records applied 91,117 25.25 2.72
db block changes 1,829,482 507.04 54.68
db block gets 2,025,019 561.23 60.52
db block gets direct 247 0.07 0.01
db block gets from cache 2,024,772 561.16 60.51
deferred (CURRENT) block cleanout applications 105,611 29.27 3.16
dirty buffers inspected 38,792 10.75 1.16
enqueue conversions 4,656 1.29 0.14
enqueue deadlocks 0 0.00 0.00
enqueue releases 500,202 138.63 14.95
enqueue requests 500,203 138.63 14.95
enqueue timeouts 1 0.00 0.00
enqueue waits 4,304 1.19 0.13
exchange deadlocks 5 0.00 0.00
execute count 1,347,200 373.37 40.26
failed probes on index block reclamation 9 0.00 0.00
free buffer inspected 12,506,503 3,466.14 373.76
free buffer requested 12,221,437 3,387.13 365.24
gc CPU used by this session 247,744 68.66 7.40
gc blocks lost 0 0.00 0.00
gc cr block build time 355 0.10 0.01
gc cr block flush time 302 0.08 0.01
gc cr block receive time 6,749 1.87 0.20
gc cr block send time 364 0.10 0.01
gc cr blocks received 123,868 34.33 3.70
gc cr blocks served 112,416 31.16 3.36
gc current block flush time 54 0.01 0.00
gc current block pin time 2,390 0.66 0.07
gc current block receive time 549,717 152.35 16.43
gc current block send time 11,251 3.12 0.34
gc current blocks received 6,498,043 1,800.91 194.20
gc current blocks served 3,446,123 955.08 102.99
gc local grants 2,844,845 788.44 85.02
gc remote grants 2,717,569 753.17 81.22
gcs messages sent 17,507,482 4,852.14 523.22
ges messages sent 398,667 110.49 11.91
global enqueue get time 20,629 5.72 0.62
global enqueue gets async 51,090 14.16 1.53
global enqueue gets sync 670,865 185.93 20.05
global enqueue releases 708,990 196.49 21.19
heap block compress 20,379 5.65 0.61
hot buffers moved to head of LRU 6,351,930 1,760.42 189.83
immediate (CR) block cleanout applications 6,722 1.86 0.20
immediate (CURRENT) block cleanout applications 22,577 6.26 0.67
index crx upgrade (found) 135 0.04 0.00
index crx upgrade (positioned) 93,357 25.87 2.79
index fast full scans (full) 3,080 0.85 0.09
index fetch by key 60,003,354 16,629.74 1,793.23
index scans kdiixs1 14,153,700 3,922.65 422.99
leaf node 90-10 splits 137 0.04 0.00
leaf node splits 2,350 0.65 0.07
lob reads 2,184 0.61 0.07
lob writes 458 0.13 0.01
lob writes unaligned 451 0.12 0.01
logons cumulative 7,256 2.01 0.22
messages received 135,063 37.43 4.04
messages sent 134,551 37.29 4.02
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 418,612,647 116,017.16 12,510.46
opened cursors cumulative 1,069,814 296.50 31.97
parse count (failures) 175 0.05 0.01
parse count (hard) 248,427 68.85 7.42
parse count (total) 1,041,137 288.55 31.11
parse time cpu 152,746 42.33 4.56
parse time elapsed 199,594 55.32 5.96
physical read IO requests 4,220,861 1,169.80 126.14
physical read bytes 45,451,460,608 12,596,727.18 1,358,341.37
physical read total IO requests 4,318,810 1,196.94 129.07
physical read total bytes 47,874,805,248 13,268,349.40 1,430,764.33
physical read total multi block requests 110,956 30.75 3.32
physical reads 5,548,273 1,537.69 165.81
physical reads cache 5,518,406 1,529.41 164.92
physical reads cache prefetch 1,505,911 417.36 45.00
physical reads direct 29,868 8.28 0.89
physical reads direct (lob) 4,324 1.20 0.13
physical reads direct temporary tablespace 25,462 7.06 0.76
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 88,056 24.40 2.63
physical write bytes 1,253,195,776 347,319.21 37,452.43
physical write total IO requests 140,787 39.02 4.21
physical write total bytes 2,472,270,336 685,181.83 73,885.13
physical write total multi block requests 46,817 12.98 1.40
physical writes 152,978 42.40 4.57
physical writes direct 33,958 9.41 1.01
physical writes direct (lob) 160 0.04 0.00
physical writes direct temporary tablespace 33,708 9.34 1.01
physical writes from cache 119,020 32.99 3.56
physical writes non checkpoint 140,487 38.94 4.20
pinned buffers inspected 278 0.08 0.01
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 59 0.02 0.00
process last non-idle time 3,585 0.99 0.11
queries parallelized 103 0.03 0.00
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 3,357,276 930.46 100.33
recursive cpu usage 182,611 50.61 5.46
redo blocks written 701,656 194.46 20.97
redo buffer allocation retries 4 0.00 0.00
redo entries 956,375 265.06 28.58
redo log space requests 5 0.00 0.00
redo log space wait time 9 0.00 0.00
redo ordering marks 20,829 5.77 0.62
redo size 335,242,124 92,911.28 10,018.89
redo subscn max counts 3,655 1.01 0.11
redo synch time 3,259 0.90 0.10
redo synch writes 35,500 9.84 1.06
redo wastage 12,158,264 3,369.62 363.36
redo write time 4,225 1.17 0.13
redo writer latching time 8 0.00 0.00
redo writes 49,251 13.65 1.47
rollback changes - undo records applied 2,983 0.83 0.09
rollbacks only - consistent read gets 5,047 1.40 0.15
rows fetched via callback 54,673,006 15,152.45 1,633.93
session connect time 0 0.00 0.00
session cursor cache hits 260,586 72.22 7.79
session logical reads 555,733,564 154,019.78 16,608.40
session pga memory 4,057,476,272 1,124,516.59 121,259.86
session pga memory max 4,567,656,976 1,265,911.55 136,506.89
session uga memory 4,400,538,832 1,219,595.29 131,512.47
session uga memory max 8,198,866,832 2,272,289.76 245,027.55
shared hash latch upgrades - no wait 712,985 197.60 21.31
shared hash latch upgrades - wait 1,419 0.39 0.04
sorts (disk) 0 0.00 0.00
sorts (memory) 258,631 71.68 7.73
sorts (rows) 22,265,463 6,170.80 665.42
sql area evicted 243,483 67.48 7.28
sql area purged 175 0.05 0.01
summed dirty queue length 60,071 16.65 1.80
switch current to new buffer 16,817 4.66 0.50
table fetch by rowid 676,704,429 187,546.47 20,223.68
table fetch continued row 4,179,321 1,158.29 124.90
table scan blocks gotten 281,336,537 77,971.52 8,407.89
table scan rows gotten 8,511,648,645 2,358,976.24 254,375.20
table scans (direct read) 0 0.00 0.00
table scans (long tables) 260 0.07 0.01
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 243,933 67.61 7.29
total number of times SMON posted 10,084 2.79 0.30
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 5,314 1.47 0.16
transaction tables consistent read rollbacks 10 0.00 0.00
transaction tables consistent reads - undo records applied 1,504 0.42 0.04
undo change vector size 136,430,124 37,811.17 4,077.29
user I/O wait time 671,164 186.01 20.06
user calls 4,063,684 1,126.24 121.45
user commits 29,543 8.19 0.88
user rollbacks 3,918 1.09 0.12
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 112 0.03 0.00
workarea executions - optimal 214,370 59.41 6.41
write clones created in background 0 0.00 0.00
write clones created in foreground 4 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 14,599,798 14,687,508
opened cursors current 1,484 1,291
workarea memory allocated 86,271 1,301
logons current 189 174

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 1.00

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)
NNC_DATA03 2,340,440 649 1.48 1.11 7,153 2 902,560 0.95
NNC_DATA01 1,003,721 278 1.37 1.98 27,997 8 54,231 0.53
NNC_INDEX03 418,292 116 2.09 1.07 43,677 12 114,641 1.55
NNC_DATA02 359,917 100 1.70 1.00 155 0 28,554 1.57
NNC_INDEX02 80,443 22 1.68 1.02 74 0 425 2.02
SYSTEM 13,927 4 2.16 3.60 3,046 1 5,175 1.61
TEMP01 1,847 1 0.02 14.18 2,122 1 0 0.00
UNDOTBS1 1,051 0 1.86 1.00 2,497 1 2,809 0.09
USERS 654 0 0.72 1.00 883 0 0 0.00
SYSAUX 556 0 2.16 1.00 640 0 0 0.00
UNDOTBS2 110 0 0.18 1.00 2 0 396 0.56
I3V85 1 0 0.00 1.00 1 0 0 0.00
I3V9 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
I3V85 +NFSN_DATA/nfsnnc/datafile/i3v85.dbf 1 0 0.00 1.00 1 0 0 0.00
I3V9 +NFSN_DATA/nfsnnc/datafile/i3v9.dbf 1 0 0.00 1.00 1 0 0 0.00
NNC_DATA01 +NFSN_DATA/nfsnnc/datafile/nnc_data01.268.726867643 74,468 21 1.56 2.50 1,412 0 1,590 1.16
NNC_DATA01 +NFSN_DATA/nfsnnc/datafile/nnc_data01.275.745237203 138,641 38 1.54 2.60 1,293 0 1,114 0.88
NNC_DATA01 +NFSN_DATA/nfsnnc/datafile/nnc_data01.294.788039171 226,965 63 1.23 1.77 1,011 0 11,051 0.50
NNC_DATA01 +NFSN_DATA/nfsnnc/datafile/nnc_data01.296.804519807 109,772 30 1.34 1.77 1,160 0 6,383 0.69
NNC_DATA01 +NFSN_DATA/nfsnnc/datafile/nnc_data01.305.809343889 90,077 25 1.39 1.85 1,248 0 5,481 0.49
NNC_DATA01 +NFSN_DATA/nfsnnc/datafile/nnc_data01.306.817125077 139,957 39 1.40 1.78 2,172 1 10,253 0.44
NNC_DATA01 +NFSN_DATA/nfsnnc/datafile/nnc_data01.309.827229513 118,824 33 1.42 1.84 18,940 5 15,171 0.41
NNC_DATA01 +NFSN_DATA/nfsnnc/datafile/nnc_data01.dbf 105,017 29 1.22 1.99 761 0 3,188 0.75
NNC_DATA02 +NFSN_DATA/nfsnnc/datafile/nnc_data02.269.726867665 181,115 50 1.77 1.00 56 0 7,708 1.77
NNC_DATA02 +NFSN_DATA/nfsnnc/datafile/nnc_data02.277.745237437 99,554 28 1.76 1.01 15 0 12,708 1.53
NNC_DATA02 +NFSN_DATA/nfsnnc/datafile/nnc_data02.299.804535881 21,427 6 2.27 1.00 1 0 4,198 1.71
NNC_DATA02 +NFSN_DATA/nfsnnc/datafile/nnc_data02.301.805371049 57,821 16 1.19 1.00 83 0 3,940 1.21
NNC_DATA03 +NFSN_DATA/nfsnnc/datafile/nnc_data03.270.726867667 967,695 268 1.48 1.13 2,045 1 348,042 1.12
NNC_DATA03 +NFSN_DATA/nfsnnc/datafile/nnc_data03.276.745237411 301,666 84 1.91 1.32 1,807 1 5,040 0.97
NNC_DATA03 +NFSN_DATA/nfsnnc/datafile/nnc_data03.295.800622505 133,285 37 1.45 1.06 898 0 65,031 0.85
NNC_DATA03 +NFSN_DATA/nfsnnc/datafile/nnc_data03.298.804535699 311,987 86 1.27 1.04 752 0 152,199 0.81
NNC_DATA03 +NFSN_DATA/nfsnnc/datafile/nnc_data03.304.809343797 246,740 68 1.27 1.03 541 0 102,004 0.86
NNC_DATA03 +NFSN_DATA/nfsnnc/datafile/nnc_data03.307.817125357 379,067 105 1.44 1.01 1,110 0 230,244 0.87
NNC_INDEX02 +NFSN_DATA/nfsnnc/datafile/nnc_index02.272.726867675 40,166 11 1.78 1.03 14 0 105 1.90
NNC_INDEX02 +NFSN_DATA/nfsnnc/datafile/nnc_index02.278.745237461 20,136 6 1.83 1.02 2 0 134 2.16
NNC_INDEX02 +NFSN_DATA/nfsnnc/datafile/nnc_index02.297.804535575 1,132 0 2.39 1.02 2 0 118 1.86
NNC_INDEX02 +NFSN_DATA/nfsnnc/datafile/nnc_index02.302.805371155 19,009 5 1.25 1.01 56 0 68 2.21
NNC_INDEX03 +NFSN_DATA/nfsnnc/datafile/nnc_index03.262.785256503 16,821 5 1.98 1.03 1,926 1 2,551 1.45
NNC_INDEX03 +NFSN_DATA/nfsnnc/datafile/nnc_index03.265.786488593 64,287 18 2.32 1.07 7,284 2 19,768 1.72
NNC_INDEX03 +NFSN_DATA/nfsnnc/datafile/nnc_index03.266.786488339 63,901 18 2.26 1.06 7,223 2 19,445 1.67
NNC_INDEX03 +NFSN_DATA/nfsnnc/datafile/nnc_index03.273.726867677 92,377 26 2.04 1.08 7,467 2 26,480 1.51
NNC_INDEX03 +NFSN_DATA/nfsnnc/datafile/nnc_index03.279.745237485 71,419 20 1.94 1.09 4,013 1 15,643 1.50
NNC_INDEX03 +NFSN_DATA/nfsnnc/datafile/nnc_index03.303.809343329 43,913 12 2.07 1.06 7,776 2 14,793 1.43
NNC_INDEX03 +NFSN_DATA/nfsnnc/datafile/nnc_index03.308.817125513 47,586 13 2.01 1.05 4,209 1 13,622 1.46
NNC_INDEX03 +NFSN_DATA/nfsnnc/datafile/nnc_index03.310.830206685 17,988 5 2.03 1.03 3,779 1 2,339 1.53
SYSAUX +NFSN_DATA/nfsnnc/datafile/sysaux.257.726861805 556 0 2.16 1.00 640 0 0 0.00
SYSTEM +NFSN_DATA/nfsnnc/datafile/system.256.726861805 13,927 4 2.16 3.60 3,046 1 5,175 1.61
TEMP01 +NFSN_DATA/nfsnnc/tempfile/temp01.ora 935 0 0.02 13.79 1,066 0 0  
TEMP01 +NFSN_DATA/nfsnnc/tempfile/temp03.ora 912 0 0.01 14.59 1,056 0 0  
UNDOTBS1 +NFSN_DATA/nfsnnc/datafile/undotbs1.258.726861805 577 0 2.03 1.00 1,607 0 1,812 0.09
UNDOTBS1 +NFSN_DATA/nfsnnc/datafile/undotbs1.280.745237723 474 0 1.67 1.00 890 0 997 0.08
UNDOTBS2 +NFSN_DATA/nfsnnc/datafile/undotbs2.264.734390563 74 0 0.27 1.00 1 0 247 0.61
UNDOTBS2 +NFSN_DATA/nfsnnc/datafile/undotbs2.281.745237773 36 0 0.00 1.00 1 0 149 0.47
USERS +NFSN_DATA/nfsnnc/datafile/users.259.726861805 452 0 0.71 1.00 598 0 0 0.00
USERS +NFSN_DATA/nfsnnc/datafile/users.300.804535943 202 0 0.74 1.00 285 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 1,803,860 99 555,895,160 5,517,837 119,020 0 0 1,108,863


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 3 10186 70827 375951 4423680 375951  
E 0 2 6994 39634 311183 4423680 311183  

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,504 0.10 180,386 2.35 8,189,367,332
D 3,008 0.20 360,772 1.95 6,815,034,850
D 4,512 0.30 541,158 1.74 6,073,087,989
D 6,016 0.40 721,544 1.57 5,480,031,363
D 7,520 0.50 901,930 1.43 4,975,606,593
D 9,024 0.60 1,082,316 1.31 4,566,713,813
D 10,528 0.70 1,262,702 1.21 4,223,608,635
D 12,032 0.80 1,443,088 1.13 3,942,821,078
D 13,536 0.90 1,623,474 1.06 3,699,572,577
D 15,040 1.00 1,803,860 1.00 3,489,775,842
D 16,544 1.10 1,984,246 0.95 3,316,394,976
D 18,048 1.20 2,164,632 0.91 3,174,532,435
D 19,552 1.30 2,345,018 0.88 3,059,448,069
D 21,056 1.40 2,525,404 0.85 2,970,804,819
D 22,560 1.50 2,705,790 0.83 2,895,382,331
D 24,064 1.60 2,886,176 0.81 2,833,358,071
D 25,568 1.70 3,066,562 0.80 2,778,409,661
D 27,072 1.80 3,246,948 0.78 2,733,663,678
D 28,576 1.90 3,427,334 0.77 2,694,943,832
D 30,080 2.00 3,607,720 0.64 2,223,773,023

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
97.47 33,821 876

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,313 5,160 1,287.74 82.91 6.44 100.00 0.00 646,450
E 6,313 5,198 1,120.06 0.67 0.06 100.00 0.00 646,450

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 173,700 173,700 0 0
64K 128K 2,960 2,960 0 0
128K 256K 3,646 3,646 0 0
256K 512K 1,249 1,249 0 0
512K 1024K 28,234 28,234 0 0
1M 2M 3,664 3,664 0 0
2M 4M 448 444 4 0
4M 8M 341 290 51 0
8M 16M 184 129 55 0
16M 32M 30 30 0 0
32M 64M 5 3 2 0
64M 128M 2 2 0 0
128M 256M 1 1 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
789 0.13 14,502,651.42 6,611,449.59 69.00 1,622
1,578 0.25 14,502,651.42 5,826,280.43 71.00 686
3,157 0.50 14,502,651.42 5,816,530.19 71.00 393
4,735 0.75 14,502,651.42 5,815,224.95 71.00 286
6,313 1.00 14,502,651.42 5,540,627.16 72.00 150
7,576 1.20 14,502,651.42 1,890,371.84 88.00 93
8,838 1.40 14,502,651.42 1,890,366.08 88.00 48
10,101 1.60 14,502,651.42 1,890,366.08 88.00 39
11,363 1.80 14,502,651.42 1,890,361.07 88.00 0
12,626 2.00 14,502,651.42 1,890,361.07 88.00 0
18,939 3.00 14,502,651.42 1,890,361.07 88.00 0
25,252 4.00 14,502,651.42 1,890,361.07 88.00 0
37,878 6.00 14,502,651.42 1,890,361.07 88.00 0
50,504 8.00 14,502,651.42 1,890,361.07 88.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
1,840 0.59 371 34,725 6,966,214 0.84 1,848,294 3.26 586,067,014
2,160 0.69 685 47,352 7,371,198 0.89 1,443,310 2.55 593,317,131
2,480 0.79 1,004 60,636 7,647,862 0.93 1,166,646 2.06 595,279,802
2,800 0.90 1,322 74,304 7,961,678 0.97 852,830 1.51 596,562,549
3,120 1.00 1,641 87,085 8,248,314 1.00 566,194 1.00 597,509,579
3,440 1.10 1,960 99,999 8,465,187 1.03 349,321 0.62 598,236,972
3,760 1.21 2,279 112,648 8,673,772 1.05 140,736 0.25 598,816,090
4,080 1.31 2,598 125,254 8,840,991 1.07 1 0.00 599,289,394
4,400 1.41 2,917 138,172 9,030,039 1.09 1 0.00 599,705,196
4,720 1.51 3,236 151,237 9,205,445 1.12 1 0.00 600,085,816
5,040 1.62 3,555 164,586 9,348,859 1.13 1 0.00 600,423,590
5,360 1.72 3,874 177,446 9,476,437 1.15 1 0.00 600,738,148
5,680 1.82 4,193 190,622 9,587,556 1.16 1 0.00 601,031,629
6,000 1.92 4,502 203,824 9,697,855 1.18 1 0.00 601,312,870
6,320 2.03 4,821 216,078 9,835,642 1.19 1 0.00 601,583,366

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
32 0.10 0 0 0 0
64 0.20 0 0 0 0
96 0.30 0 0 0 0
128 0.40 0 0 0 0
160 0.50 0 0 0 0
192 0.60 0 0 0 0
224 0.70 0 0 0 0
256 0.80 0 0 0 0
288 0.90 0 0 0 0
320 1.00 0 0 0 0
352 1.10 0 0 0 0
384 1.20 0 0 0 0
416 1.30 0 0 0 0
448 1.40 0 0 0 0
480 1.50 0 0 0 0
512 1.60 0 0 0 0
544 1.70 0 0 0 0
576 1.80 0 0 0 0
608 1.90 0 0 0 0
640 2.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 1,105,507 1,122 1
undo block 3,110 0 0
segment header 21 0 13
1st level bmb 42 0 1
undo header 94 0 0
2nd level bmb 12 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 177 177 0 177 8 42.41
WF-AWR Flush 19 19 0 12 2 169.08
TO-Temp Object 4,135 4,135 0 1,343 1 0.44
TM-DML 100,164 100,166 0 1,406 1 0.41
HW-Segment High Water Mark 9,888 9,887 1 316 0 0.87
PS-PX Process Reservation 881 881 0 390 0 0.53
TT-Tablespace 6,563 6,563 0 214 0 0.46
FB-Format Block 465 465 0 232 0 0.40
CF-Controlfile Transaction 8,795 8,795 0 120 0 0.58
TX-Transaction (index contention) 97 97 0 57 0 0.53
TA-Instance Undo 24 24 0 24 0 0.58
TX-Transaction 45,700 45,714 0 7 0 1.57
US-Undo Segment 35 35 0 14 0 0.50
TX-Transaction (allocate ITL entry) 4 4 0 4 0 0.50
RO-Multiple Object Reuse (fast object reuse) 16 16 0 4 0 0.25
JS-Job Scheduler (job run lock - synchronize) 2 2 0 1 0 1.00
PI-Remote PX Process Spawn Status 1 1 0 1 0 1.00
UL-User-defined 1 1 0 1 0 1.00
PW-Buffer Cache PreWarm (flush prewarm buffers) 1 1 0 1 0 0.00
WL-Being Written Redo Log 1 1 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 27.63 54,639 1,289 14 19.6/32.4833333333333333333333333333333333333 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
09-Dec 11:04 3,038 6,137 148 13 23 0/0 0/0/0/0/0/0
09-Dec 10:54 3,135 8,342 71 12 20 0/0 0/0/0/0/0/0
09-Dec 10:44 3,970 7,216 187 14 27 0/0 0/0/0/0/0/0
09-Dec 10:34 4,690 7,579 1,105 13 29 0/0 0/0/0/0/0/0
09-Dec 10:24 4,229 7,651 1,289 12 32 0/0 0/0/0/0/0/0
09-Dec 10:14 3,675 7,202 688 12 22 0/0 0/0/0/0/0/0
09-Dec 10:04 4,889 10,512 86 13 20 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM allocation 28 0.00   0 0  
ASM db client latch 2,969 0.00   0 0  
ASM map headers 14 0.00   0 0  
ASM map load waiting list 4 0.00   0 0  
ASM map operation freelist 4,626 0.00   0 0  
ASM map operation hash table 9,254,856 0.00 0.00 0 0  
ASM network background latch 1,457 0.00   0 0  
AWR Alerted Metric Element list 24,621 0.00   0 0  
Consistent RBA 49,246 0.00   0 0  
FAL request queue 74 0.00   0 0  
FAL subheap alocation 74 0.00   0 0  
FIB s.o chain latch 6 0.00   0 0  
FOB s.o list latch 33,424 0.17 0.00 0 0  
JS broadcast add buf latch 1,432 0.00   0 0  
JS broadcast drop buf latch 1,433 0.00   0 0  
JS broadcast load blnc latch 1,326 0.00   0 0  
JS mem alloc latch 6 0.00   0 0  
JS queue access latch 6 0.00   0 0  
JS queue state obj latch 47,878 0.00   0 0  
JS slv state obj latch 12 0.00   0 0  
KCL gc element parent latch 67,263,384 0.06 0.01 0 10,908 0.11
KFK SGA context latch 6,528 0.00   0 0  
KFMD SGA 3,173 0.00   0 0  
KJC message pool free list 624,039 0.04 0.00 0 292,253 0.01
KJCT flow control latch 16,671,578 0.02 0.00 0 0  
KMG MMAN ready and startup request latch 1,202 0.00   0 0  
KSXR large replies 240 0.00   0 0  
KTF sga latch 24 0.00   0 1,206 0.00
KWQMN job cache list latch 307 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,202 0.00
OS process 21,000 0.00   0 0  
OS process allocation 15,187 0.35 0.00 0 0  
OS process: request allocation 13,965 0.49 0.00 0 0  
PL/SQL warning settings 22,903 0.00   0 0  
SGA IO buffer pool latch 40,008 0.00   0 40,008 0.00
SQL memory manager latch 1 0.00   0 1,201 0.00
SQL memory manager workarea list latch 336,839 0.00 0.00 0 0  
Shared B-Tree 131 0.00   0 0  
active checkpoint queue latch 27,876 0.30 0.00 0 0  
active service list 48,944 0.30 0.13 0 1,947 0.05
archive control 63 0.00   0 0  
archive process latch 1,351 0.00   0 0  
begin backup scn array 161 0.00   0 0  
business card 206 0.00   0 0  
cache buffer handles 95,672 0.01 0.00 0 0  
cache buffers chains 1,015,013,818 0.69 0.03 6 41,909,512 0.01
cache buffers lru chain 479,902 0.29 0.11 0 31,604,024 0.34
cache table scan latch 0     0 108,306 0.03
channel handle pool latch 25,776 0.23 0.00 0 0  
channel operations parent latch 2,874,326 0.04 0.00 0 0  
checkpoint queue latch 931,343 0.01 0.00 0 155,421 0.00
client/application info 36,201 0.00   0 0  
commit callback allocation 6,753 0.00   0 0  
compile environment latch 7,256 0.00   0 0  
dictionary lookup 834 0.00   0 0  
dml lock allocation 194,713 0.03 0.00 0 0  
dummy allocation 14,529 0.14 0.00 0 0  
enqueue hash chains 1,249,934 0.01 0.00 0 1,954 0.00
enqueues 947,774 0.05 0.00 0 0  
error message lists 503 0.00   0 0  
event group latch 6,975 0.00   0 0  
file cache latch 1,039 0.00   0 0  
gcs opaque info freelist 7,286,722 0.10 0.00 0 0  
gcs partitioned table hash 142,245,071 0.00 0.00 0 0  
gcs remaster request queue 30 3.33 2.00 0 0  
gcs remastering latch 35,686,651 0.00 4.01 0 0  
gcs resource freelist 7,664,082 0.02 0.00 0 2,705,494 0.02
gcs resource hash 55,704,696 0.19 0.27 1 169 0.00
gcs resource scan list 338 0.00   0 0  
gcs shadows freelist 4,952,988 0.00 0.00 0 4,494,568 0.00
ges caches resource lists 980,363 0.30 0.00 0 826,533 0.24
ges deadlock list 266,842 0.01 0.00 0 54 0.00
ges domain table 1,315,956 0.00   0 0  
ges enqueue table freelist 1,432,084 0.00 0.00 0 0  
ges group table 1,955,438 0.00 0.00 0 0  
ges process hash list 137,423 0.00   0 4 0.00
ges process parent latch 3,098,759 0.00 0.00 0 0  
ges process table freelist 13,965 0.19 0.00 0 0  
ges resource hash list 2,599,558 0.08 0.12 0 307,362 0.01
ges resource scan list 6,715 0.00   0 0  
ges resource table freelist 486,524 0.00 0.00 0 2 0.00
ges synchronous data 512 0.59 0.00 0 93,892 0.04
ges timeout list 51,072 0.00 0.00 0 53,178 0.00
global KZLD latch for mem in SGA 6,969 0.00   0 0  
hash table column usage latch 3,842 0.49 0.00 0 37,330,920 0.00
hash table modification latch 181 0.00   0 0  
job workq parent latch 0     0 4 0.00
job_queue_processes parameter latch 62 0.00   0 0  
kks stats 1,616,174 0.03 0.18 0 0  
kokc descriptor allocation latch 576 0.00   0 0  
ksuosstats global area 243 0.00   0 0  
ktm global data 10,882 0.00   0 0  
kwqbsn:qsga 130 0.00   0 0  
lgwr LWN SCN 51,481 0.04 0.00 0 0  
library cache 11,096,144 0.15 0.02 0 1,153,926 0.11
library cache load lock 21,434 0.00   0 0  
library cache lock 5,970,424 0.08 0.00 0 0  
library cache lock allocation 92,755 0.00 0.00 0 0  
library cache pin 2,331,619 0.05 0.00 0 4 0.00
library cache pin allocation 39,432 0.00 0.00 0 0  
list of block allocation 11,491 0.00   0 0  
loader state object freelist 7,540 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 108 0.00   0 109 0.00
message pool operations parent latch 25,801 0.05 0.00 0 0  
messages 640,962 0.06 0.00 0 0  
mostly latch-free SCN 55,914 6.62 0.00 0 0  
msg queue 4 0.00   0 4 0.00
multiblock read objects 1,852,541 0.03 0.00 0 0  
name-service memory objects 53,642 0.00   0 0  
name-service namespace bucket 50,670 0.00   0 0  
name-service pending queue 25,780 0.00   0 0  
name-service request 6 0.00   0 0  
name-service request queue 65,838 0.00   0 0  
ncodef allocation latch 118 0.00   0 0  
object queue header heap 155,477 0.00   0 45,379 0.00
object queue header operation 26,375,913 0.05 0.88 3 0  
object stats modification 9,908 0.01 0.00 0 0  
parallel query alloc buffer 3,910 0.00   0 0  
parallel query stats 589 0.00   0 0  
parallel txn reco latch 11,952 0.00   0 0  
parameter list 64,401 0.04 0.00 0 0  
parameter table allocation management 7,296 3.08 0.08 0 0  
post/wait queue 64,921 0.02 0.00 0 43,867 0.01
process allocation 37,108 0.13 0.84 0 6,973 0.03
process group creation 13,965 0.24 0.00 0 0  
process queue 1,636 0.00   0 0  
process queue reference 27,890 0.00 0.00 0 2,563 0.00
qmn task queue latch 771 10.89 0.02 0 0  
query server freelists 1,271 0.00   0 0  
query server process 1 0.00   0 1 0.00
queued dump request 18,030 0.00   0 0  
redo allocation 153,762 0.07 0.00 0 955,966 0.12
redo copy 0     0 956,473 0.30
redo writing 179,268 0.03 0.00 0 0  
resmgr group change latch 7,312 0.00   0 0  
resmgr:active threads 14,526 0.00   0 0  
resmgr:actses change group 7,251 0.00   0 0  
resmgr:free threads list 14,525 0.61 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 98,849,065 0.32 0.00 0 19,647 0.26
rules engine rule set statistics 100 0.00   0 0  
segmented array pool 4 0.00   0 0  
sequence cache 21,692 0.31 0.00 0 0  
session allocation 821,006 0.16 0.17 0 0  
session idle bit 8,379,832 0.00 0.00 0 0  
session state list latch 37,470 1.60 0.22 0 0  
session switching 118 0.00   0 0  
session timer 1,949 0.00   0 0  
shared pool 13,279,636 0.12 0.24 4 0  
shared pool simulator 13,989,625 0.01 0.13 1 0  
simulator hash latch 36,237,802 0.00 0.00 0 0  
simulator lru latch 0     0 34,806,815 1.08
slave class 14 0.00   0 0  
slave class create 19 5.26 1.00 0 0  
sort extent pool 46,295 0.14 0.00 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 2,128 0.00   0 0  
temp lob duration state obj allocation 36 0.00   0 0  
temporary table state object allocation 293 0.00   0 0  
threshold alerts latch 243 0.00   0 0  
transaction allocation 16,768 0.01 0.00 0 0  
transaction branch allocation 1,949 0.00   0 0  
undo global data 232,353 0.01 0.00 0 0  
user lock 27,923 1.29 0.02 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 1,015,013,818 6,975,755 180,057 6,809,549 0 0 0
row cache objects 98,849,065 315,481 79 315,406 0 0 0
gcs resource hash 55,704,696 104,873 28,523 81,404 0 0 0
KCL gc element parent latch 67,263,384 39,634 587 39,078 0 0 0
library cache 11,096,144 16,163 297 15,879 0 0 0
shared pool 13,279,636 16,148 3,824 12,349 0 0 0
object queue header operation 26,375,913 12,074 10,667 4,126 0 0 0
gcs opaque info freelist 7,286,722 7,379 6 7,373 0 0 0
library cache lock 5,970,424 4,684 1 4,683 0 0 0
KJCT flow control latch 16,671,578 3,324 3 3,321 0 0 0
ges caches resource lists 980,363 2,968 9 2,959 0 0 0
ges resource hash list 2,599,558 2,140 261 1,882 0 0 0
gcs resource freelist 7,664,082 1,816 2 1,814 0 0 0
shared pool simulator 13,989,625 1,470 194 1,277 0 0 0
cache buffers lru chain 479,902 1,372 145 1,231 0 0 0
session allocation 821,006 1,322 229 1,100 0 0 0
channel operations parent latch 2,874,326 1,069 1 1,068 0 0 0
simulator hash latch 36,237,802 1,013 2 1,011 0 0 0
session state list latch 37,470 600 134 466 0 0 0
multiblock read objects 1,852,541 555 1 554 0 0 0
kks stats 1,616,174 461 81 380 0 0 0
messages 640,962 374 1 373 0 0 0
user lock 27,923 360 7 353 0 0 0
gcs remastering latch 35,686,651 300 1,202 131 0 0 0
KJC message pool free list 624,039 247 1 246 0 0 0
parameter table allocation management 7,296 225 17 208 0 0 0
active service list 48,944 148 19 129 0 0 0
qmn task queue latch 771 84 2 82 0 0 0
process allocation 37,108 49 41 8 0 0 0
gcs remaster request queue 30 1 2 0 0 0 0
slave class create 19 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 1,799 540
KCL gc element parent latch kclliter 0 495 52
KCL gc element parent latch kclplz 0 408 311
KCL gc element parent latch kclzcl 0 170 487
KCL gc element parent latch kclnfnd 0 142 76
KCL gc element parent latch kclbla 0 59 1
KCL gc element parent latch kclulb 0 24 607
KCL gc element parent latch KCLUNLNK 0 17 896
KCL gc element parent latch kclrwrite 0 15 6
KCL gc element parent latch kclgcr 0 13 0
KCL gc element parent latch kclwrt 0 8 2
KCL gc element parent latch kclfwrite1 0 6 4
KCL gc element parent latch kclhngcbk1 0 6 0
KCL gc element parent latch kclprm 0 2 91
KCL gc element parent latch kclgrantlk 0 1 67
KCL gc element parent latch kclpto 0 1 0
KJC message pool free list kjcsmpav: allocate a msg buffer 0 1 1
KJCT flow control latch kjctcsnd: send normal message 0 3 1
active service list ksws_event: ksws event 0 89 87
active service list kswsasidlist: return list of service name 0 1 0
active service list kswssyis: find service entry 1 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 271,079 295,510
cache buffers chains kclcls_3 0 47,522 244
cache buffers chains kcbrls: kslbegin 0 1,935 3,611
cache buffers chains kcbgtcr: kslbegin shared 0 1,726 1,370
cache buffers chains kcbgtcr: fast path 0 1,050 2,191
cache buffers chains kcbzwb 0 906 21,162
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 296 312
cache buffers chains kclexpand 0 106 18
cache buffers chains kcbgcur: kslbegin 0 98 11
cache buffers chains kcbzib: multi-block read: nowait 0 76 0
cache buffers chains kcbzgb: scan from tail. nowait 0 69 0
cache buffers chains kclobj_1 0 57 0
cache buffers chains kcbgtcr 0 35 1
cache buffers chains kcbzib: finish free bufs 0 26 34
cache buffers chains kclwrt 0 20 0
cache buffers chains kcbget: pin buffer 0 13 0
cache buffers chains kclpred 0 9 0
cache buffers chains kclebs_1 0 7 2
cache buffers chains kclgrantlk_1 0 4 1
cache buffers chains kcbgcur: buf pinned 0 3 3
cache buffers chains kcbgkcbcr 0 3 313
cache buffers chains kclbla 0 3 0
cache buffers chains kcbbxsv 0 2 22
cache buffers chains kcbchg: kslbegin: call CR func 0 2 164
cache buffers chains kcbnew: new latch again 0 2 0
cache buffers chains kcbnlc 0 1 5
cache buffers chains kclcsr 0 1 7
cache buffers chains kclfbst_1 0 1 1
cache buffers chains kclfpdb 0 1 0
cache buffers chains kclobj 0 1 0
cache buffers chains kclrbast 0 1 39
cache buffers chains kclwcrs 0 1 8
cache buffers chains kclwlr 0 1 0
cache buffers lru chain kcbzgws 0 140 0
cache buffers lru chain kcbbxsv: move to being written 0 2 33
cache buffers lru chain kcbo_link_q 0 1 1
cache buffers lru chain kcbzgb: posted for free bufs 0 1 51
cache buffers lru chain kcbzib: move stale buffers 0 1 7
channel operations parent latch ksrapublish() 0 1 0
channel operations parent latch ksrsconsume() 0 1 1
cost function kzulrl 0 7 5
event range base latch No latch 0 2 2
gcs opaque info freelist kjbrgrant free opaque info 0 5 4
gcs opaque info freelist kjbrcvt save opaque info 0 1 2
gcs remaster request queue kjbdomchkreq 0 2 0
gcs remastering latch 59 0 1,253 0
gcs remastering latch 43 0 48 0
gcs remastering latch 69 0 7 0
gcs remastering latch 12 0 1 0
gcs resource freelist kjbralc add resource 0 1 2
gcs resource freelist kjbrfr free resource 0 1 0
gcs resource hash kjbcropen:affinity 0 12,160 3,705
gcs resource hash kjblocalfile_nolock 0 4,234 1,511
gcs resource hash kjbmpopen 0 3,554 2,397
gcs resource hash kjbrrcfwst 0 2,269 91
gcs resource hash kjbrrcres_99 0 1,426 122
gcs resource hash kjbmpclose 0 997 2,681
gcs resource hash kjbrdrmcvtq_98 0 783 164
gcs resource hash kjbcropen 0 752 3,718
gcs resource hash kjbmprlst: shadow 0 722 489
gcs resource hash kjbldrmrpst 0 592 646
gcs resource hash kclgrantlk_1 0 349 1,247
gcs resource hash kjbopen:affinity 0 245 315
gcs resource hash kjbmpcreatepi 0 147 12
gcs resource hash kjbassume 0 113 4,096
gcs resource hash kclzcl 0 76 6,748
gcs resource hash kjbopen 0 31 14
gcs resource hash kjbrwrdone reget 0 22 15
gcs resource hash kjbmdowncvt 0 20 18
gcs resource hash kclpdc 0 6 42
gcs resource hash kclshrshr 0 4 1
gcs resource hash kjbmpwrite 0 4 1
gcs resource hash kjbcrcomplete 0 3 216
gcs resource hash kjbmpconvert 0 3 39
gcs resource hash kjbrrcfwst_101 0 3 0
gcs resource hash kclfwrite1 0 2 56
gcs resource hash kclrwrite 0 2 34
gcs resource hash kclwrt 0 1 2
gcs resource hash kjbconvert 0 1 35
gcs resource hash kjbcrconvert 0 1 40
gcs resource hash kjblpast 0 1 53
ges resource hash list kjakcai: search for resp by resname 0 135 0
ges resource hash list kjrmas1: lookup master node 0 55 27
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 54 0
ges resource hash list kjucvl: lock convert request 0 9 83
ges resource hash list kjcvscn: remove from scan queue 0 6 0
ges resource hash list kjlrlr: remove lock from resource queue 0 2 132
ges resource table freelist kjruch: cached obj cleanup 0 8 0
ges resource table freelist kjrchc: cached obj cleanup 0 1 0
kks stats kks stats alloc/free 0 81 81
library cache kqlmbpil: parent 0 71 2
library cache kqlmbinv: parent 0 31 1
library cache kglpndl: child: after processing 0 16 8
library cache kgldti: 2child 0 9 7
library cache kglobpn: child: 0 9 49
library cache kglati 0 4 2
library cache kglukp: child 0 4 14
library cache kglLockCursor 0 3 23
library cache kglhdgn: child: 0 2 66
library cache kglpin 0 2 8
library cache kgldte: child 0 0 1 14
library cache kglivl: child 0 1 0
library cache kglobld 0 1 2
library cache lock kgllkdl: child: no lock handle 0 27 35
library cache lock kgllkal: child: multiinstance 0 1 0
library cache lock ksucallcbksafely: kqllhng 0 1 0
messages ksarcv 0 1 1
multiblock read objects kcbzib: normal mbr free 0 1 1
object queue header operation kclobj_1 0 11,912 6,003
object queue header operation kclobj_3 0 304 124
object queue header operation kcbw_unlink_q 0 106 4,575
object queue header operation kcbw_link_q 0 46 1,377
object queue header operation kclobj_2 0 11 19
object queue header operation kcbo_switch_cq 0 5 26
object queue header operation kcbo_ivbo 0 3 58
object queue header operation kcbo_swap_buf_bg 0 2 63
object queue header operation kcbo_switch_mq_bg 0 2 88
object queue header operation kcbo_switch_q_bg 0 2 49
parameter table allocation management ksp_param_table_free 0 17 17
process allocation ksucrp 0 28 0
process allocation ksudlp 0 7 23
process allocation ksufap: active procs 0 6 15
row cache objects kqreqd: reget 0 30 4
row cache objects kqrpre: find obj 0 9 51
row cache objects kqrso 0 6 6
row cache objects kqrbip 0 3 0
row cache objects kqreqd 0 3 11
row cache objects ksucallcbksafely: kqrhngc 0 2 0
row cache objects kqrigt 0 1 0
session allocation ksuxds: KSUSFCLC not set 0 199 119
session allocation ksucri 0 13 51
session allocation ksuxds: not user session 0 11 35
session allocation ksudlp 0 6 15
session state list latch kpseqd 0 122 5
session state list latch kpscad 0 12 117
shared pool kghalo 0 2,956 1,420
shared pool kghupr1 0 377 1,311
shared pool kghfrunp: alloc: wait 0 373 14
shared pool kghfrunp: clatch: nowait 0 99 0
shared pool kghalp 0 58 706
shared pool kghfrunp: clatch: wait 0 41 44
shared pool kghasp 0 30 68
shared pool kghfre 0 28 303
shared pool simulator kglsim_unpin_simhp 0 177 31
shared pool simulator kglsim_scan_lru: scan 0 9 86
shared pool simulator kglsim_unpin_simhp: fast path 0 6 64
shared pool simulator kglsim_chg_simhp_free 0 1 2
shared pool simulator kglsim_upd_newhp 0 1 11
simulator hash latch kcbsacc: lookup dba 0 2 2
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
NFSN NNC_DATA01 PUB_MESSAGEINFO   TABLE 92,070,000 16.57
NFSN NNC_DATA01 FBM_ENDORE   TABLE 70,193,984 12.63
NFSN NNC_DATA01 SO_MEANNC   TABLE 43,145,952 7.76
NFSN NNC_DATA01 SO_SALEPREORDER_B   TABLE 38,591,792 6.94
NFSN NNC_DATA01 NF_PRICEAUDIT_H   TABLE 32,774,480 5.90

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
NFSN NNC_DATA03 IC_GENERAL_B   TABLE 1,272,867 22.94
NCHR NNC_DATA01 WA_DATA   TABLE 610,421 11.00
NFSN NNC_DATA03 IC_GENERAL_H   TABLE 479,450 8.64
NFSN NNC_DATA03 GL_DETAIL   TABLE 354,379 6.39
NFSN NNC_DATA01 QC_CHECKBILL_B1   TABLE 244,838 4.41

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
NFSN NNC_DATA01 QDI_TEMPTABLES   TABLE 340 73.75
NFSN NNC_INDEX03 I_SM_OPERATELOG   INDEX 41 8.89
NFSN NNC_INDEX03 PK_SM_OPERATELOG   INDEX 12 2.60
IUFO NNC_INDEX03 PK_IUFO_MEAPUBDATA   INDEX 11 2.39
NFSN NNC_INDEX03 PK_SO_ARSUB   INDEX 10 2.17

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
NFSN NNC_INDEX03 I_SM_OPERATELOG   INDEX 4 100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYS SYSTEM COL$   TABLE 112 42.59
NFSN NNC_DATA01 QDI_PERFLOG   TABLE 27 10.27
NFSN NNC_DATA01 QDI_TEMPTABLES   TABLE 25 9.51
SYS SYSTEM TAB$   TABLE 25 9.51
SYS SYSTEM SUBCOLTYPE$   TABLE 18 6.84

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
NFSN NNC_DATA03 IC_GENERAL_B   TABLE 880,699 87.01
NFSN NNC_DATA01 PO_REQUIREAPP_B   TABLE 48,470 4.79
NFSN NNC_INDEX03 I_IC_GENERAL_B_13   INDEX 40,911 4.04
NFSN NNC_DATA02 BD_INVMANDOC   TABLE 28,268 2.79
NFSN NNC_DATA03 SO_SALEORDER_B   TABLE 5,423 0.54

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
NFSN NNC_DATA01 SO_MEANNC   TABLE 13,782 11.13
SYS SYSTEM OBJ$   TABLE 4,574 3.69
SYS SYSTEM I_VIEW1   INDEX 3,999 3.23
SYS SYSTEM TAB$   TABLE 3,792 3.06
NFSN NNC_DATA01 PO_ARRIVEORDER_B   TABLE 3,352 2.71

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
NFSN NNC_DATA01 PO_REQUIREAPP_B   TABLE 1,301,318 20.03
NFSN NNC_DATA03 IC_GENERAL_B   TABLE 869,380 13.38
NFSN NNC_DATA01 PO_PRICESETTLE_B   TABLE 790,110 12.16
NFSN NNC_DATA01 FBM_ACTION   TABLE 734,444 11.30
NFSN NNC_DATA01 QC_CHECKBILL_B1   TABLE 555,799 8.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 61 3.28 0   0 1
dc_database_links 13,942 0.00 0   0 1
dc_global_oids 1,318 1.67 0   0 16
dc_histogram_data 6,837,581 0.15 0   0 12,366
dc_histogram_defs 5,324,983 0.58 0   0 15,598
dc_objects 544,355 0.96 0   1,603 1,132
dc_profiles 6,972 0.00 0   0 1
dc_rollback_segments 26,701 0.00 0   0 500
dc_segments 2,458,125 0.12 0   224 2,457
dc_sequences 88 37.50 0   88 1
dc_tablespace_quotas 202 42.57 0   202 1
dc_tablespaces 6,409,124 0.00 0   0 13
dc_usernames 38,564 0.10 0   0 8
dc_users 7,054,432 0.00 0   0 48
outstanding_alerts 84 86.90 0   0 0

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 2 2 0
dc_global_oids 22 0 23
dc_histogram_defs 30,765 0 35,497
dc_object_ids 4,499 377 2,779
dc_objects 8,773 1,109 3,683
dc_segments 3,444 134 2,925
dc_sequences 175 23 9
dc_tablespace_quotas 404 80 7
dc_usernames 39 0 39
dc_users 19 0 19
outstanding_alerts 162 6 68

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 23,689 0.04 44,678 0.02 2 0
CLUSTER 347 0.29 560 0.54 2 0
INDEX 45 46.67 118 17.80 0 0
SQL AREA 1,054,299 42.99 2,101,041 34.44 18,719 381
TABLE/PROCEDURE 240,419 0.93 1,426,744 0.84 4,657 0
TRIGGER 43,794 0.00 45,702 0.00 0 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 560 1 1 1 0
INDEX 118 21 21 21 0
TABLE/PROCEDURE 527,273 5,421 2,926 3,307 299

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 1,056.83   5.50 7.04 56 69 192 192
  Freeable 130.63 0.00 1.11 2.17 19   118 118
  SQL 94.99 91.60 0.58 4.33 50 98 164 146
  PL/SQL 7.46 1.92 0.04 0.42 6 6 190 190
E Other 978.13   5.53 7.33 56 69 177 177
  Freeable 125.44 0.00 1.13 2.23 19   111 111
  SQL 9.43 6.46 0.06 0.14 1 42 149 129
  PL/SQL 7.23 1.72 0.04 0.44 6 6 175 175

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 15,770,583,040  
Fixed Size 2,122,472  
Redo Buffers 14,651,392  
Variable Size 5,687,479,576  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 96.00 96.00 0.00
shared ASH buffers 50.00 50.00 0.00
shared CCursor 246.15 238.33 -3.18
shared PCursor 159.99 152.74 -4.53
shared db_block_hash_buckets 90.00 90.00 0.00
shared free memory 195.70 207.76 6.16
shared gcs resources 390.64 390.64 0.00
shared gcs shadows 191.58 191.58 0.00
shared ges enqueues 41.85 41.85 0.00
shared ges resource 43.28 42.95 -0.76
shared kglsim heap 37.30 37.30 0.00
shared kglsim object batch 66.69 66.69 0.00
shared kzctxgjsi ksuseclid memor 316.41 316.41 0.00
shared library cache 150.11 144.15 -3.97
shared sql area 1,133.51 1,150.57 1.51
streams free memory 319.94 319.94 0.00
  buffer_cache 15,040.00 15,040.00 0.00
  fixed_sga 2.02 2.02 0.00
  log_buffer 13.97 13.97 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 88,243 0 0
QMON Coordinator 84,408 0 0

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

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 1,735,589 2,052,047 2043772 2043772
gcs_shadows 1,534,755 2,016,011 2043772 2043772


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_cursor_features_enabled 10   
audit_file_dest /oracle/admin/nfsnnc/adump   
background_dump_dest /oracle/admin/nfsnnc/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files +NFSN_DATA/nfsnnc/controlfile/current.260.726861859   
core_dump_dest /oracle/admin/nfsnnc/cdump   
db_block_size 8192   
db_cache_size 15770583040   
db_create_file_dest +NFSN_DATA   
db_domain      
db_file_multiblock_read_count 16   
db_name nfsnnc   
dispatchers (PROTOCOL=TCP) (SERVICE=nfsnncXDB)   
instance_number 1   
job_queue_processes 100   
local_listener LISTENERS_NFSNNC   
log_archive_dest_1 LOCATION=/arch1   
open_cursors 2000   
optimizer_dynamic_sampling 2   
optimizer_index_cost_adj 40   
pga_aggregate_target 6619660288   
processes 1500   
remote_listener LISTENERS_NFSNNC   
remote_login_passwordfile EXCLUSIVE   
service_names nfsnnc   
sga_max_size 21474836480   
sga_target 0   
shared_pool_size 3254779904   
spfile +NFSN_DATA/nfsnnc/spfilenfsnnc.ora   
streams_pool_size 335544320   
thread 1   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/admin/nfsnnc/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 14,906 4.13 0.45
acks for commit broadcast(logical) 41,296 11.45 1.23
broadcast msgs on commit(actual) 48,752 13.51 1.46
broadcast msgs on commit(logical) 49,249 13.65 1.47
broadcast msgs on commit(wasted) 18,729 5.19 0.56
broadcast on commit wait time(ms) 576 0.16 0.02
broadcast on commit waits 3,522 0.98 0.11
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 1,799,246 498.66 53.77
gcs ast xid 0 0.00 0.00
gcs blocked converts 88,039 24.40 2.63
gcs blocked cr converts 126,950 35.18 3.79
gcs compatible basts 9,974 2.76 0.30
gcs compatible cr basts (global) 14,692 4.07 0.44
gcs compatible cr basts (local) 3,546,415 982.88 105.99
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 17,927 4.97 0.54
gcs dbwr write request msgs 12,806 3.55 0.38
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 10,431 2.89 0.31
gcs immediate (null) converts 413,982 114.73 12.37
gcs immediate cr (compatible) converts 246 0.07 0.01
gcs immediate cr (null) converts 4,103,390 1,137.24 122.63
gcs indirect ast 1,952,841 541.22 58.36
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 8,223 2.28 0.25
gcs msgs process time(ms) 495,557 137.34 14.81
gcs msgs received 11,463,611 3,177.10 342.60
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 263 0.07 0.01
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 17 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 1 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 26 0.01 0.00
gcs side channel msgs actual 95,134 26.37 2.84
gcs side channel msgs logical 8,439,491 2,338.98 252.22
gcs stale cr 1 0.00 0.00
gcs undo cr 2,226 0.62 0.07
gcs write notification msgs 1,707 0.47 0.05
gcs writes refused 177 0.05 0.01
ges msgs process time(ms) 3,918 1.09 0.12
ges msgs received 295,066 81.78 8.82
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 0 0.00 0.00
global posts requested 0 0.00 0.00
global posts sent 0 0.00 0.00
implicit batch messages received 799,852 221.68 23.90
implicit batch messages sent 1,163,987 322.60 34.79
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 90,812 25.17 2.71
messages queue sent actual 2,401,190 665.48 71.76
messages queue sent logical 7,744,129 2,146.26 231.44
messages received actual 7,465,016 2,068.91 223.10
messages received logical 11,759,164 3,259.01 351.43
messages sent directly 4,427,074 1,226.95 132.31
messages sent indirectly 7,620,241 2,111.93 227.74
messages sent not implicit batched 1,237,115 342.86 36.97
messages sent pbatched 5,950,606 1,649.19 177.84
msgs causing lmd to send msgs 62,378 17.29 1.86
msgs causing lms(s) to send msgs 103,542 28.70 3.09
msgs received queue time (ms) 330,219 91.52 9.87
msgs received queued 11,758,383 3,258.80 351.41
msgs sent queue time (ms) 393,918 109.17 11.77
msgs sent queue time on ksxp (ms) 2,431,876 673.99 72.68
msgs sent queued 7,684,545 2,129.75 229.66
msgs sent queued on ksxp 7,625,539 2,113.39 227.89
process batch messages received 437,023 121.12 13.06
process batch messages sent 954,599 264.56 28.53


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 107,551
CURRENT Block Requests 5,548
Data Block Requests 107,551
Undo Block Requests 2,226
TX Block Requests 802
Current Results 107,910
Private results 3,179
Zero Results 1,329
Disk Read Results 527
Fail Results 154
Fairness Down Converts 19,874
Fairness Clears 0
Free GC Elements 0
Flushes 4,876
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 715
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 3,449,727 100.00 0.00 0.00 0.00 0.00
Flushes 485 51.34 48.45 0.21 0.00 0.00
Writes 21,572 10.46 79.78 7.97 0.89 0.89


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2 data block 119,008 95.19 4.73 0.08 6,484,058 97.92 0.01 2.07
2 Others 2,411 98.96 0.91 0.12 12,661 99.60 0.36 0.05
2 undo header 1,141 97.98 2.02 0.00 329 98.78 1.22 0.00
2 undo block 1,224 81.37 18.63 0.00 0      


Back to Top

End of Report