Using the report name awrrpt_2_112311_112312.html AWR Report

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
APPDBC2699934982appdbc2210.2.0.4.0YESerpdb-m9k-d01

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:11231105-Dec-16 12:00:35498 29.7
End Snap:11231205-Dec-16 12:30:36496 29.7
Elapsed:  30.02 (mins)  
DB Time:  90.00 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 29,136M 29,136MStd Block Size: 8K
Shared Pool Size: 44,384M 44,384MLog Buffer: 33,792K

Load Profile

Per SecondPer Transaction
Redo size: 151,584.34 6,931.82
Logical reads: 209,295.30 9,570.89
Block changes: 565.05 25.84
Physical reads: 153.94 7.04
Physical writes: 116.04 5.31
User calls: 1,046.06 47.84
Parses: 249.37 11.40
Hard parses: 1.69 0.08
Sorts: 360.04 16.46
Logons: 0.61 0.03
Executes: 449.07 20.54
Transactions: 21.87 

% Blocks changed per Read: 0.27Recursive Call %: 28.76
Rollback per transaction %: 4.71Rows per Sort: 25.08

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.97In-memory Sort %: 100.00
Library Hit %: 99.65Soft Parse %: 99.32
Execute to Parse %: 44.47Latch Hit %: 99.91
Parse CPU to Parse Elapsd %: 99.77% Non-Parse CPU: 94.22

Shared Pool Statistics

BeginEnd
Memory Usage %: 67.63 68.41
% SQL with executions>1: 96.46 98.41
% Memory for SQL w/exec>1: 95.93 98.34

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  4,939  91.5 
enq: TX - row lock contention 498 220 442 4.1Application
db file sequential read 109,263 204 2 3.8User I/O
log file sync 37,287 61 2 1.1Commit
wait for scn ack 34,293 38 1 .7Other

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 7.01 0.32
Global Cache blocks served: 11.73 0.54
GCS/GES messages received: 79.73 3.65
GCS/GES messages sent: 94.47 4.32
DBWR Fusion writes: 0.14 0.01
Estd Interconnect traffic (KB) 183.93 

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

Buffer access - local cache %: 99.97
Buffer access - remote cache %: 0.00
Buffer access - disk %: 0.03

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.2
Avg global cache cr block receive time (ms): 2.5
Avg global cache current block receive time (ms): 0.7
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.1
Global cache log flushes for cr blocks served %: 0.1
Avg global cache cr block flush time (ms): 0.0
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.1
Global cache log flushes for current blocks served %: 0.4
Avg global cache current block flush time (ms): 1.4

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.2
Avg message received queue time (ms): 0.2
Avg GCS message process time (ms): 0.1
Avg GES message process time (ms): 0.0
% of direct sent messages: 11.50
% of indirect sent messages: 64.55
% of flow controlled messages: 23.95


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 4,999.40 92.58
DB CPU 4,938.52 91.45
parse time elapsed 287.45 5.32
hard parse elapsed time 240.00 4.44
PL/SQL execution elapsed time 10.01 0.19
hard parse (sharing criteria) elapsed time 1.60 0.03
PL/SQL compilation elapsed time 0.63 0.01
connection management call elapsed time 0.48 0.01
sequence load elapsed time 0.42 0.01
failed parse elapsed time 0.13 0.00
repeated bind elapsed time 0.05 0.00
hard parse (bind mismatch) elapsed time 0.02 0.00
DB time 5,400.15  
background elapsed time 197.85  
background cpu time 139.19  

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 168,144 0.00 234 1 4.27
Application 929 48.44 220 237 0.02
Commit 37,287 0.00 61 2 0.95
Other 70,042 46.12 40 1 1.78
Network 1,755,928 0.00 40 0 44.57
System I/O 63,986 0.00 22 0 1.62
Cluster 20,928 0.00 15 1 0.53
Concurrency 7,045 0.14 1 0 0.18
Configuration 895 99.44 0 0 0.02

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
enq: TX - row lock contention 498 90.36 220 442 0.01
db file sequential read 109,263 0.00 204 2 2.77
log file sync 37,287 0.00 61 2 0.95
wait for scn ack 34,293 0.00 38 1 0.87
SQL*Net more data from client 72,714 0.00 34 0 1.85
read by other session 6,568 0.00 24 4 0.17
log file parallel write 38,440 0.00 14 0 0.98
SQL*Net more data to client 177,850 0.00 5 0 4.51
gc buffer busy 1,953 0.00 4 2 0.05
gc cr multi block request 1,567 0.06 4 3 0.04
db file parallel write 17,212 0.00 4 0 0.44
direct path read temp 23,728 0.00 3 0 0.60
control file sequential read 6,929 0.00 3 0 0.18
gc current block 2-way 7,085 0.00 3 0 0.18
gc cr grant 2-way 5,593 0.00 1 0 0.14
gc cr block busy 1,160 0.00 1 1 0.03
direct path read 2,163 0.00 1 1 0.05
direct path write temp 23,728 0.00 1 0 0.60
direct path write 2,667 0.00 1 0 0.07
SQL*Net message to client 1,505,364 0.00 1 0 38.21
control file parallel write 862 0.00 1 1 0.02
log file sequential read 272 0.00 1 2 0.01
gc current grant busy 786 0.00 0 1 0.02
gc cr block 2-way 1,046 0.00 0 0 0.03
gc current grant 2-way 1,678 0.00 0 0 0.04
IPC send completion sync 1,164 100.00 0 0 0.03
enq: WF - contention 10 0.00 0 37 0.00
latch: cache buffers chains 6,068 0.00 0 0 0.15
enq: PS - contention 655 0.00 0 0 0.02
CGS wait for IPC msg 17,652 100.00 0 0 0.45
latch free 18 0.00 0 12 0.00
row cache lock 686 0.00 0 0 0.02
os thread startup 2 0.00 0 98 0.00
enq: JQ - contention 409 0.00 0 0 0.01
SQL*Net break/reset to client 118 0.00 0 2 0.00
latch: shared pool 79 0.00 0 2 0.00
PX Deq: reap credit 10,889 93.89 0 0 0.28
enq: TM - contention 312 0.00 0 0 0.01
cursor: pin S wait on X 10 100.00 0 10 0.00
library cache lock 163 0.00 0 1 0.00
enq: CF - contention 126 0.00 0 1 0.00
log file switch completion 4 0.00 0 17 0.00
latch: library cache 4 0.00 0 17 0.00
DFS lock handle 89 0.00 0 0 0.00
reliable message 113 0.00 0 0 0.00
ksxr poll remote instances 4,161 75.75 0 0 0.11
db file scattered read 23 0.00 0 1 0.00
gc current block busy 12 0.00 0 2 0.00
db file parallel read 4 0.00 0 5 0.00
PX Deq Credit: send blkd 149 53.02 0 0 0.00
rdbms ipc reply 63 0.00 0 0 0.00
global enqueue expand wait 1 100.00 0 10 0.00
gcs log flush sync 25 0.00 0 0 0.00
Log archive I/O 269 0.00 0 0 0.01
gc current multi block request 47 0.00 0 0 0.00
PX Deq: Signal ACK 83 34.94 0 0 0.00
enq: FB - contention 9 0.00 0 1 0.00
undo segment extension 890 100.00 0 0 0.02
library cache pin 15 0.00 0 0 0.00
LGWR wait for redo copy 80 0.00 0 0 0.00
enq: RW - MV metadata contention 8 0.00 0 0 0.00
enq: TA - contention 6 0.00 0 0 0.00
enq: MS - contention 7 0.00 0 0 0.00
gc current grant congested 1 0.00 0 1 0.00
enq: TD - KTF dump entries 5 0.00 0 0 0.00
buffer busy waits 15 0.00 0 0 0.00
latch: session allocation 2 0.00 0 1 0.00
KJC: Wait for msg sends to complete 17 0.00 0 0 0.00
enq: HW - contention 1 0.00 0 1 0.00
enq: TT - contention 2 0.00 0 0 0.00
log file single write 2 0.00 0 0 0.00
enq: DR - contention 1 0.00 0 1 0.00
enq: US - contention 1 0.00 0 1 0.00
enq: MW - contention 1 0.00 0 0 0.00
enq: WL - contention 1 0.00 0 0 0.00
enq: IR - contention 1 0.00 0 0 0.00
latch: row cache objects 3 0.00 0 0 0.00
enq: UL - contention 1 0.00 0 0 0.00
enq: SR - contention 1 0.00 0 0 0.00
SQL*Net message from client 1,505,355 0.00 723,568 481 38.21
gcs remote message 1,107,594 92.21 28,080 25 28.12
jobq slave wait 6,069 45.48 14,050 2315 0.15
PX Idle Wait 1,761 65.08 3,386 1923 0.04
virtual circuit status 61 100.00 1,787 29297 0.00
Streams AQ: qmn slave idle wait 64 0.00 1,765 27578 0.00
Streams AQ: qmn coordinator idle wait 134 47.76 1,765 13172 0.00
DIAG idle wait 8,990 0.00 1,759 196 0.23
ges remote message 27,675 95.71 1,758 64 0.70
Streams AQ: waiting for time management or cleanup tasks 1 100.00 916 916349 0.00
PX Deq: Execution Msg 3,595 32.13 40 11 0.09
PX Deq: Msg Fragment 1,214 47.61 12 10 0.03
PX Deq: Join ACK 96 34.38 0 1 0.00
PX Deq: Parse Reply 85 38.82 0 0 0.00
PX Deq: Execute Reply 85 37.65 0 0 0.00
class slave wait 2 0.00 0 1 0.00
Streams AQ: RAC qmn coordinator idle wait 134 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 56,692 36.81 39 1 1.44
log file parallel write 38,440 0.00 14 0 0.98
db file parallel write 17,212 0.00 4 0 0.44
control file sequential read 5,344 0.00 2 0 0.14
control file parallel write 862 0.00 1 1 0.02
log file sequential read 272 0.00 1 2 0.01
os thread startup 2 0.00 0 98 0.00
enq: TM - contention 312 0.00 0 0 0.01
row cache lock 159 0.00 0 0 0.00
gc cr block 2-way 130 0.00 0 1 0.00
gc current block 2-way 48 0.00 0 0 0.00
Log archive I/O 269 0.00 0 0 0.01
gc current grant busy 20 0.00 0 0 0.00
gc current block busy 1 0.00 0 2 0.00
library cache lock 2 0.00 0 0 0.00
log file single write 2 0.00 0 0 0.00
direct path write 19 0.00 0 0 0.00
direct path read 20 0.00 0 0 0.00
rdbms ipc message 74,118 42.67 35,077 473 1.88
gcs remote message 1,107,602 92.21 28,080 25 28.12
Streams AQ: qmn slave idle wait 64 0.00 1,765 27578 0.00
Streams AQ: qmn coordinator idle wait 134 47.76 1,765 13172 0.00
DIAG idle wait 8,990 0.00 1,759 196 0.23
ges remote message 27,676 95.71 1,758 64 0.70
pmon timer 639 100.00 1,758 2751 0.02
smon timer 10 20.00 1,757 175721 0.00
Streams AQ: waiting for time management or cleanup tasks 1 100.00 916 916349 0.00
PX Deq: Join ACK 6 50.00 0 1 0.00
PX Deq: Parse Reply 6 50.00 0 0 0.00
PX Deq: Execute Reply 6 50.00 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 134 100.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 10,499
AVG_IDLE_TIME 169,491
AVG_IOWAIT_TIME 0
AVG_SYS_TIME 1,594
AVG_USER_TIME 8,848
BUSY_TIME 675,698
IDLE_TIME 10,851,506
IOWAIT_TIME 0
SYS_TIME 105,927
USER_TIME 569,771
LOAD 3
OS_CPU_WAIT_TIME 30,100
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 0
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES ###############
NUM_CPUS 64

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
eas 5,323.50 4,862.30 276,881 370,952,649
SYS$USERS 58.10 58.00 7 4,712,843
appdbc 18.90 18.50 10 1,828,621
SYS$BACKGROUND 0.00 0.00 449 61,148
appdbcXDB 0.00 0.00 0 0
eip 0.00 0.00 0 0
epm 0.00 0.00 0 0
mdbc2 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
eas 167392 23146 6798 76 0 0 1753081 3996
SYS$USERS 7 4 40 2 0 0 2614 1
appdbc 10 6 26 1 0 0 285 0
SYS$BACKGROUND 738 195 181 27 0 0 0 0
epm 0 0 0 0 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
889 888 0   16.47 7v3g8c1x2hdav   select * from ( select itemhea...
695 691 5,415 0.13 12.87 23z3nvmqbf4a0 JDBC Thin Client select h.boe_header_id, i.oid...
238 236 5 47.66 4.41 16df0g5jm988c   select * from ( select siebill...
235 235 2 117.29 4.34 0psy7dcupn0dk   select * from ( select itemhea...
220 0 33 6.67 4.07 afcvg0t1xrvrm JDBC Thin Client update FBP_SYNCH_REQUESTS set ...
165 165 139 1.18 3.05 0fyhmj0pms249   select * from ( select row_.*,...
152 152 57 2.66 2.81 1htm3vwdyav5t JDBC Thin Client SELECT boe_header_id FROM (SEL...
138 84 5 27.65 2.56 75v5ygwzwkq4j   select count(*) as col_0_0_ fr...
137 137 62 2.21 2.53 fg4tjgjct11fc   SELECT boe_header_id FROM (SEL...
106 47 11 9.67 1.97 b8tf22rmqzbhp   SELECT budget_item_id, budget_...
93 79 30 3.10 1.72 fncuwscyr5sdt   SELECT APPS.GET_CBM_QUERY_ID()...
85 85 47 1.81 1.58 7m2ja89w4tmz7   select * from ( select sieboeh...
72 70 8 9.04 1.34 fwhp91qtfcj15   select * from ( SELECT * FROM ...
71 68 30 2.37 1.32 675f4rv8w450b JDBC Thin Client SELECT /*+ INDEX(si SIE_INVOI...
70 70 31 2.25 1.29 49qdfrvj15xw0 JDBC Thin Client select * from ( select wfrbill...
60 60 140 0.43 1.11 arn705x45mu4q   select count(*) as col_0_0_ fr...

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
888 889 0   16.47 7v3g8c1x2hdav   select * from ( select itemhea...
691 695 5,415 0.13 12.87 23z3nvmqbf4a0 JDBC Thin Client select h.boe_header_id, i.oid...
236 238 5 47.25 4.41 16df0g5jm988c   select * from ( select siebill...
235 235 2 117.29 4.34 0psy7dcupn0dk   select * from ( select itemhea...
165 165 139 1.18 3.05 0fyhmj0pms249   select * from ( select row_.*,...
152 152 57 2.66 2.81 1htm3vwdyav5t JDBC Thin Client SELECT boe_header_id FROM (SEL...
137 137 62 2.21 2.53 fg4tjgjct11fc   SELECT boe_header_id FROM (SEL...
85 85 47 1.81 1.58 7m2ja89w4tmz7   select * from ( select sieboeh...
84 138 5 16.89 2.56 75v5ygwzwkq4j   select count(*) as col_0_0_ fr...
79 93 30 2.65 1.72 fncuwscyr5sdt   SELECT APPS.GET_CBM_QUERY_ID()...
70 70 31 2.25 1.29 49qdfrvj15xw0 JDBC Thin Client select * from ( select wfrbill...
70 72 8 8.69 1.34 fwhp91qtfcj15   select * from ( SELECT * FROM ...
68 71 30 2.26 1.32 675f4rv8w450b JDBC Thin Client SELECT /*+ INDEX(si SIE_INVOI...
60 60 140 0.43 1.11 arn705x45mu4q   select count(*) as col_0_0_ fr...
47 106 11 4.29 1.97 b8tf22rmqzbhp   SELECT budget_item_id, budget_...
0 220 33 0.00 4.07 afcvg0t1xrvrm JDBC Thin Client update FBP_SYNCH_REQUESTS set ...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
94,950,628 5,415 17,534.74 25.18 690.60 694.83 23z3nvmqbf4a0 JDBC Thin Client select h.boe_header_id, i.oid...
34,868,534 5 6,973,706.80 9.25 236.26 238.28 16df0g5jm988c   select * from ( select siebill...
22,443,160 62 361,986.45 5.95 136.81 136.81 fg4tjgjct11fc   SELECT boe_header_id FROM (SEL...
20,995,877 57 368,348.72 5.57 151.60 151.81 1htm3vwdyav5t JDBC Thin Client SELECT boe_header_id FROM (SEL...
11,884,514 0   3.15 888.22 889.28 7v3g8c1x2hdav   select * from ( select itemhea...
11,589,781 65 178,304.32 3.07 28.35 28.55 8b59ynskq5uvp   select count(*) as col_0_0_ fr...
11,395,526 8 1,424,440.75 3.02 69.51 72.35 fwhp91qtfcj15   select * from ( SELECT * FROM ...
10,859,648 30 361,988.27 2.88 67.92 71.23 675f4rv8w450b JDBC Thin Client SELECT /*+ INDEX(si SIE_INVOI...
8,489,528 139 61,075.74 2.25 164.56 164.56 0fyhmj0pms249   select * from ( select row_.*,...
7,661,008 30 255,366.93 2.03 79.36 93.15 fncuwscyr5sdt   SELECT APPS.GET_CBM_QUERY_ID()...
7,290,229 203 35,912.46 1.93 50.51 50.66 a5w368vyjr4w3   select count(cbmitemsum0_.RN) ...
6,895,908 5 1,379,181.60 1.83 84.44 138.25 75v5ygwzwkq4j   select count(*) as col_0_0_ fr...
6,053,858 32 189,183.06 1.61 18.03 18.03 ardmc4prf3u46 JDBC Thin Client select * from ( select fbpnoti...
5,904,370 140 42,174.07 1.57 59.71 59.72 arn705x45mu4q   select count(*) as col_0_0_ fr...
5,607,129 11 509,739.00 1.49 47.22 106.37 b8tf22rmqzbhp   SELECT budget_item_id, budget_...
5,607,127 11 509,738.82 1.49 44.62 44.65 0xw6f4jt502yy   SELECT count(*) from(select DI...
4,680,518 51,369 91.12 1.24 30.25 30.25 drq8bzdn6uujj   select fbpbillque0_.BOE_LINE_I...

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
166,450 5 33,290.00 60.02 236.26 238.28 16df0g5jm988c   select * from ( select siebill...
62,486 5 12,497.20 22.53 84.44 138.25 75v5ygwzwkq4j   select count(*) as col_0_0_ fr...
7,679 11 698.09 2.77 47.22 106.37 b8tf22rmqzbhp   SELECT budget_item_id, budget_...
4,251 30 141.70 1.53 79.36 93.15 fncuwscyr5sdt   SELECT APPS.GET_CBM_QUERY_ID()...
3,040 4 760.00 1.10 7.94 18.19 f2jpknrcu1v0w   SELECT budget_item_id, budget_...
1,719 38 45.24 0.62 16.17 24.35 82g517bmvd2a5   select * from ( select sieboeh...
805 11,881 0.07 0.29 0.90 0.91 grwydz59pu6mc   select text from view$ where r...
484 0   0.17 888.22 889.28 7v3g8c1x2hdav   select * from ( select itemhea...
372 174 2.14 0.13 0.87 1.03 1pjdxv73cgz8v   insert into CBM_INVOKE_SERVICE...
183 5,415 0.03 0.07 690.60 694.83 23z3nvmqbf4a0 JDBC Thin Client select h.boe_header_id, i.oid...

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
76,131 76,130 1.00 0.00 0.00 6mr0ub1d9dzrr   select * from ( SELECT a.dept_...
56,499 172,244 3.05 0.00 0.00 ccgsbyj4bsjqb   select ih.item_code, ih.item_...
51,369 3,928,905 76.48 0.00 0.00 drq8bzdn6uujj   select fbpbillque0_.BOE_LINE_I...
34,639 34,639 1.00 0.00 0.00 3puaqk8mgqbuf   update FBP_LOGINS set APP_ID=:...
33,638 33,638 1.00 0.00 0.00 abzzvu7hr5r8f   select fbplogins0_.LOGIN_ID as...
33,045 33,040 1.00 0.00 0.00 33g6811hm4t90 JDBC Thin Client BEGIN dbms_session.set_nls('NL...
27,747 27,745 1.00 0.00 0.00 cs8zn8sz9stnh   select fbpemploye0_.EMPLOYEE_I...
11,881 11,881 1.00 0.00 0.00 grwydz59pu6mc   select text from view$ where r...
5,415 78 0.01 0.13 0.13 23z3nvmqbf4a0 JDBC Thin Client select h.boe_header_id, i.oid...
5,268 38,219 7.25 0.00 0.00 5wxn1f0bb3kbn   select fbplookupv0_.LOOKUP_VAL...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
76,131 76,131 16.95 6mr0ub1d9dzrr   select * from ( SELECT a.dept_...
51,369 51,369 11.43 drq8bzdn6uujj   select fbpbillque0_.BOE_LINE_I...
34,641 34,639 7.71 3puaqk8mgqbuf   update FBP_LOGINS set APP_ID=:...
33,638 33,638 7.49 abzzvu7hr5r8f   select fbplogins0_.LOGIN_ID as...
33,053 33,045 7.36 33g6811hm4t90 JDBC Thin Client BEGIN dbms_session.set_nls('NL...
27,747 27,747 6.18 cs8zn8sz9stnh   select fbpemploye0_.EMPLOYEE_I...
11,881 11,881 2.64 grwydz59pu6mc   select text from view$ where r...
5,415 5,415 1.21 23z3nvmqbf4a0 JDBC Thin Client select h.boe_header_id, i.oid...
5,268 5,268 1.17 5wxn1f0bb3kbn   select fbplookupv0_.LOOKUP_VAL...
2,802 2,802 0.62 dma91xjnqwxpx   select frontuserf0_.FRONT_USER...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,740,806 3 0.01 davc0fj3jz03g   select * from ( select c.APPRO...
1,843,887 3 0.00 b24r1090nnc9s   SELECT BOV.EMPLOYEE_ID FROM WF...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
98 174 azyvr427cjshd   insert into SIE.SIE_BOE_NEED_H...
85 174 1pjdxv73cgz8v   insert into CBM_INVOKE_SERVICE...
38 1 8nffyd1kd7kf2   insert into CBM_ITEM_HEADERS (...
35 19 fxypbtnpk00a1   update CBM_ITEM_HEADERS set LA...
22 132 gqwm6054a2g60   select count(*) as col_0_0_ fr...

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
4.55 4.27 106.37 47.22 11 b8tf22rmqzbhp   SELECT budget_item_id, budget_...
3.46 4.86 71.23 67.92 30 675f4rv8w450b JDBC Thin Client SELECT /*+ INDEX(si SIE_INVOI...
1.90 1.38 138.25 84.44 5 75v5ygwzwkq4j   select count(*) as col_0_0_ fr...
0.39 1.61 24.35 16.17 38 82g517bmvd2a5   select * from ( select sieboeh...
0.32 0.21 151.81 151.60 57 1htm3vwdyav5t JDBC Thin Client SELECT boe_header_id FROM (SEL...
0.23 0.82 28.55 28.35 65 8b59ynskq5uvp   select count(*) as col_0_0_ fr...
0.11 0.12 85.24 85.21 47 7m2ja89w4tmz7   select * from ( select sieboeh...
0.07 0.41 18.19 7.94 4 f2jpknrcu1v0w   SELECT budget_item_id, budget_...
0.07 0.07 93.15 79.36 30 fncuwscyr5sdt   SELECT APPS.GET_CBM_QUERY_ID()...
0.06 3.50 1.71 1.53 132 gqwm6054a2g60   select count(*) as col_0_0_ fr...
0.05 0.01 694.83 690.60 5,415 23z3nvmqbf4a0 JDBC Thin Client select h.boe_header_id, i.oid...
0.05 0.30 16.59 16.34 178 23284mf8u9m29 JDBC Thin Client update UUM_USERINFO set DUTYDE...
0.05 0.07 69.66 69.66 31 49qdfrvj15xw0 JDBC Thin Client select * from ( select wfrbill...
0.04 0.30 14.39 14.11 34,639 3puaqk8mgqbuf   update FBP_LOGINS set APP_ID=:...
0.04 4.32 0.91 0.90 11,881 grwydz59pu6mc   select text from view$ where r...
0.04 0.02 238.28 236.26 5 16df0g5jm988c   select * from ( select siebill...
0.02 0.00 889.28 888.22 0 7v3g8c1x2hdav   select * from ( select itemhea...
0.01 0.23 4.92 4.79 56,499 ccgsbyj4bsjqb   select ih.item_code, ih.item_...
0.01 0.66 1.51 1.24 127 f3yj5day8x9t5   SELECT COUNT(*) FROM WFR_BOE_O...
0.01 1.89 0.37 0.34 2,412 016qgppt3kxpu   select sieboepaym0_.BOE_PAYMEN...
0.01 0.62 1.03 0.87 174 1pjdxv73cgz8v   insert into CBM_INVOKE_SERVICE...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
016qgppt3kxpu select sieboepaym0_.BOE_PAYMENT_ID as BOE1_917_, sieboepaym0_.LAST_UPDATE_DATE as LAST2_917_, sieboepaym0_.LAST_UPDATED_BY as LAST3_917_, sieboepaym0_.CREATION_DATE as CREATION4_917_, sieboepaym0_.CREATED_BY as CREATED5_917_, sieboepaym0_.LAST_UPDATE_LOGIN as LAST6_917_, sieboepaym0_.BOE_HEADER_ID as BOE7_917_, sieboepaym0_.BOE_LINE_ID as BOE8_917_, sieboepaym0_.SOURCE_BOE_HEADER_ID as SOURCE9_917_, sieboepaym0_.PAYMENT_TYPE_CODE as PAYMENT10_917_, sieboepaym0_.PAYMENT_AMOUNT as PAYMENT11_917_, sieboepaym0_.PAYMENT_MODE_CODE as PAYMENT12_917_, sieboepaym0_.PAYMENT_DATE as PAYMENT13_917_, sieboepaym0_.CURRENCY_CODE as CURRENCY14_917_, sieboepaym0_.APPLY_AMOUNT as APPLY15_917_, sieboepaym0_.PAYEE as PAYEE917_, sieboepaym0_.VENDOR_CODE as VENDOR17_917_, sieboepaym0_.VENDOR_NAME as VENDOR18_917_, sieboepaym0_.VENDOR_SITE_NAME as VENDOR19_917_, sieboepaym0_.BANK_NAME as BANK20_917_, sieboepaym0_.BANK_BRANCH_NAME as BANK21_917_, sieboepaym0_.BANK_ACCOUNT_NAME as BANK22_917_, sieboepaym0_.BANK_ACCOUNT_NUM as BANK23_917_, sieboepaym0_.BANK_ACCOUNT_TYPE as BANK24_917_, sieboepaym0_.COUNTRY as COUNTRY917_, sieboepaym0_.PROVINCE as PROVINCE917_, sieboepaym0_.CITY as CITY917_, sieboepaym0_.ADDRESS as ADDRESS917_, sieboepaym0_.DESCRIPTION as DESCRIP29_917_, sieboepaym0_.INVOICE_ID as INVOICE30_917_, sieboepaym0_.PAYMENT_STATUS as PAYMENT31_917_, sieboepaym0_.ATTRIBUTE_CATEGORY as ATTRIBUTE32_917_, sieboepaym0_.ATTRIBUTE1 as ATTRIBUTE33_917_, sieboepaym0_.A TTRIBUTE2 as ATTRIBUTE34_917_, sieboepaym0_.ATTRIBUTE3 as ATTRIBUTE35_917_, sieboepaym0_.ATTRIBUTE4 as ATTRIBUTE36_917_, sieboepaym0_.ATTRIBUTE5 as ATTRIBUTE37_917_, sieboepaym0_.ATTRIBUTE6 as ATTRIBUTE38_917_, sieboepaym0_.ATTRIBUTE7 as ATTRIBUTE39_917_, sieboepaym0_.ATTRIBUTE8 as ATTRIBUTE40_917_, sieboepaym0_.ATTRIBUTE9 as ATTRIBUTE41_917_, sieboepaym0_.ATTRIBUTE10 as ATTRIBUTE42_917_, sieboepaym0_.NUMERICAL_ATTRIBUTE1 as NUMERICAL43_917_, sieboepaym0_.NUMERICAL_ATTRIBUTE2 as NUMERICAL44_917_, sieboepaym0_.NUMERICAL_ATTRIBUTE3 as NUMERICAL45_917_, sieboepaym0_.NUMERICAL_ATTRIBUTE4 as NUMERICAL46_917_, sieboepaym0_.NUMERICAL_ATTRIBUTE5 as NUMERICAL47_917_, sieboepaym0_.NUMERICAL_ATTRIBUTE6 as NUMERICAL48_917_, sieboepaym0_.NUMERICAL_ATTRIBUTE7 as NUMERICAL49_917_, sieboepaym0_.NUMERICAL_ATTRIBUTE8 as NUMERICAL50_917_, sieboepaym0_.NUMERICAL_ATTRIBUTE9 as NUMERICAL51_917_, sieboepaym0_.NUMERICAL_ATTRIBUTE10 as NUMERICAL52_917_, sieboepaym0_.MEMO as MEMO917_, sieboepaym0_.ENABLED_FLAG as ENABLED54_917_, sieboepaym0_.VERSION_NUM as VERSION55_917_, sieboepaym0_.PRI_KEY as PRI56_917_, sieboepaym0_.FATHER_PRI_KEY as FATHER57_917_ from SIE_BOE_PAYMENTS sieboepaym0_ where sieboepaym0_.ENABLED_FLAG='Y' and (sieboepaym0_.PAYMENT_STATUS not in ('ÒѸ¶' , 'Y') or sieboepaym0_.PAYMENT_STATUS is null) and sieboepaym0_.BOE_HEADER_ID=:1
0fyhmj0pms249select * from ( select row_.*, rownum rownum_ from ( select mapinfo0_.rn as rn747_, mapinfo0_.ITEM_HEADER_ID as ITEM2_747_, mapinfo0_.ITEM_LINE_ID as ITEM3_747_, mapinfo0_.COMPANY_CODE as COMPANY4_747_, mapinfo0_.PROJECT_NUM as PROJECT5_747_, mapinfo0_.BUDGET_DEPT_CODE as BUDGET6_747_, mapinfo0_.BUDGET_ACCOUNT as BUDGET7_747_, mapinfo0_.ACTIVITY_CODE as ACTIVITY8_747_, mapinfo0_.BRAND_CODE as BRAND9_747_, mapinfo0_.USERGROUP_CODE as USERGROUP10_747_, mapinfo0_.PRODUCT_CODE as PRODUCT11_747_, mapinfo0_.CHANNEL_CODE as CHANNEL12_747_, mapinfo0_.STRATEGY_CODE as STRATEGY13_747_, mapinfo0_.ENABLED_FLAG as ENABLED14_747_, mapinfo0_.LAST_UPDATE_DATE as LAST15_747_, mapinfo0_.ITEM_BEGIN_DATE as ITEM16_747_, mapinfo0_.ITEM_END_DATE as ITEM17_747_ from BIS_MAPINFO_SITES_V mapinfo0_ where 1=1 and mapinfo0_.LAST_UPDATE_DATE>=:1 and mapinfo0_.LAST_UPDATE_DATE<=:2 and rownum<=:3 ) row_ where rownum <= :4) where rownum_ > :5
0psy7dcupn0dk select * from ( select itemheader3_.ITEM_CODE as col_0_0_, itemheader3_.ITEM_NAME as col_1_0_, itemheader3_.ITEM_HEADER_ID as col_2_0_, itemheader3_.ITEM_CLASS as col_3_0_, fbpemploye0_.EMPLOYEE_NAME as col_4_0_, hiberarchy1_.ELEMENT_VL_NAME as col_5_0_, itemheader3_.AMOUNT as col_6_0_, itemheader3_.AGIO_AMOUNT as col_7_0_, itemheader3_.COST_AMOUNT as col_8_0_, itemheader3_.ITEM_STATUS as col_9_0_, itemheader3_.CURRENCY_CODE as col_10_0_, itemheader3_.BEGIN_YEAR||'-'||itemheader3_.BEGIN_MONTH as col_11_0_, itemheader3_.END_YEAR||'-'||itemheader3_.END_MONTH as col_12_0_, itemheader3_.COST_ITEM_FLAG as col_13_0_, itemheader3_.FUND_AMOUNT as col_14_0_, cbmitemclo2_.WAY_AMOUNT_CG as col_15_0_, cbmitemclo2_.AMOUNT_CG as col_16_0_, cbmitemclo2_.WAY_AMOUNT_HT as col_17_0_, cbmitemclo2_.AMOUNT_HT as col_18_0_, cbmitemclo2_.ACTUAL_AMOUNT as col_19_0_, cbmitemclo2_.AMOUNT_CGKY as col_20_0_, cbmitemclo2_.AMOUNT_HTKY as col_21_0_, itemheader3_.INIT_DEPT_ID as col_22_0_, itemheader3_.PRINCIPAL_EMPLOYEE_ID as col_23_0_, itemheader3_.BEGIN_YEAR as col_24_0_, itemheader3_.BEGIN_MONTH as col_25_0_, itemheader3_.END_YEAR as col_26_0_, itemheader3_.END_MONTH as col_27_0_ from FBP_EMPLOYEES_TL fbpemploye0_, BAS_HIBERARCHY_ELEMENTS_V hiberarchy1_, CBM_ITEM_CLOSE_INFO_V cbmitemclo2_, CBM_ITEM_HEADERS itemheader3_ where itemheader3_.PRINCIPAL_EMPLOYEE_ID=fbpemploye0_.EMPLOYEE_ID and hiberarchy1_.HIBERARCHY_ELEMENT_ID=itemheader3_.INIT_DEPT_ID and itemheader3_.ITEM_HEAD ER_ID=cbmitemclo2_.ITEM_HEADER_ID and (exists (select 1 from CBM_ITEM_RELATIONS itemrelati4_ where itemrelati4_.ITEM_HEADER_ID=itemheader3_.ITEM_HEADER_ID and (itemrelati4_.RELATION_ID in (24002)) and (itemrelati4_.RELATION_ID in (select hiberarchy5_.HIBERARCHY_ELEMENT_ID from BAS_HIBERARCHY_ELEMENTS hiberarchy5_ where hiberarchy5_.PARENT_HIBERARCHY_ELEMENT_ID=:1)) and itemrelati4_.RELATION_TYPE=:2)) and (itemheader3_.ITEM_STATUS=:3 or itemheader3_.ITEM_STATUS=:4 or itemheader3_.ITEM_STATUS=:5) and (upper(itemheader3_.ITEM_CODE) like '%'||:6||'%') and hiberarchy1_.LANGUAGE=:7 and fbpemploye0_.LANGUAGE=:8 ) where rownum <= :9
0xw6f4jt502yy SELECT count(*) from(select DISTINCT budget_item_id, budget_item_code, budget_item_name, budget_item_class, dept_name, enabled_flag, DECODE(SUBSTR(TRIM(to_char((AMOUNT - NVL((SELECT (CASE WHEN CIH.COST_ITEM_FLAG = 'Y' THEN (SELECT SUM(CCD.AMOUNT + NVL(CCD.WAY_AMOUNT, 0)) FROM CBM_COST_DETAILS CCD WHERE CCD.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ccd.pre_document_num Is Null) ELSE (SELECT SUM(CED.AMOUNT + NVL(CED.WAY_AMOUNT, 0)) FROM CBM_EXECUTE_DETAILS CED WHERE CED.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ced.pre_document_num Is Null) END) FROM CBM_ITEM_HEADERS CIH WHERE CIH.ITEM_HEADER_ID = BUDGET_ITEM_ID), 0)), '999, 999, 999, 999, 999.00')), 0, 1), '.', '0' || TRIM(to_char((AMOUNT - NVL((SELECT (CASE WHEN CIH.COST_ITEM_FLAG = 'Y' THEN (SELECT SUM(CCD.AMOUNT + NVL(CCD.WAY_AMOUNT, 0)) FROM CBM_COST_DETAILS CCD WHERE CCD.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ccd.pre_document_num Is Null) ELSE (SELECT SUM(CED.AMOUNT + NVL(CED.WAY_AMOUNT, 0)) FROM CBM_EXECUTE_DETAILS CED WHERE CED.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ced.pre_document_num Is Null) END) FROM CBM_ITEM_HEADERS CIH WHERE CIH.ITEM_HEADER_ID = BUDGET_ITEM_ID), 0)), '999, 999, 999, 999, 999.00')), TRIM(to_char((AMOUNT - NVL((SELECT (CASE WHEN CIH.COST_ITEM_FLAG = 'Y' THEN (SELECT SUM(CCD.AMOUNT + NVL(CCD.WAY_AMOUNT, 0)) FROM CBM_COST_DETAILS CCD WHERE CCD.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ccd.pre_document_num Is Null) ELSE (SELECT SUM(CED.AMOUNT + NVL(CED.WAY_AMOUNT, 0)) FROM CBM_EXECUTE_DET AILS CED WHERE CED.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ced.pre_document_num Is Null) END) FROM CBM_ITEM_HEADERS CIH WHERE CIH.ITEM_HEADER_ID = BUDGET_ITEM_ID), 0)), '999, 999, 999, 999, 999.00'))) balance_budget_amount, d.cost_item_flag from BUDGET_NO_CONTRACT_ITEMS_V d where d.DEPT_ID in (SELECT FD.DEPT_ID FROM FBP.FBP_DEPTS FD WHERE FD.PARENT_DEPT_ID != 0 START WITH FD.DEPT_ID = 15705 CONNECT BY FD.DEPT_ID = PRIOR FD.PARENT_DEPT_ID) AND 1=1) n where ( budget_item_code like '%%' or budget_item_name like '%%' )
16df0g5jm988c select * from ( select siebilldet0_.BOE_LINE_ID as BOE1_349_, siebilldet0_.BOE_NUM as BOE2_349_, siebilldet0_.BOE_HEADER_ID as BOE3_349_, siebilldet0_.EMPLOYEE_ID as EMPLOYEE4_349_, siebilldet0_.EMPLOYEE_NUMBER as EMPLOYEE5_349_, siebilldet0_.EMPLOYEE_NAME as EMPLOYEE6_349_, siebilldet0_.BOE_DATE as BOE7_349_, siebilldet0_.BOE_TYPE_ID as BOE8_349_, siebilldet0_.BOE_TYPE_CODE as BOE9_349_, siebilldet0_.BOE_TYPE_NAME as BOE10_349_, siebilldet0_.BOE_STATUS as BOE11_349_, siebilldet0_.BOE_STATUS_NAME as BOE12_349_, siebilldet0_.APPLY_AMOUNT as APPLY13_349_, siebilldet0_.FINANCE_AUDIT_AMOUNT as FINANCE14_349_, siebilldet0_.EXPENSE_AMOUNT as EXPENSE15_349_, siebilldet0_.EXPENSE_TYPE as EXPENSE16_349_, siebilldet0_.EXPENSE_TYPE_NAME as EXPENSE17_349_, siebilldet0_.VENDOR_ID as VENDOR18_349_, siebilldet0_.VENDOR_NUMBER as VENDOR19_349_, siebilldet0_.VENDOR_NAME as VENDOR20_349_, siebilldet0_.COST_DEPT_ID as COST21_349_, siebilldet0_.COST_DEPT_CODE as COST22_349_, siebilldet0_.COST_DEPT_NAME as COST23_349_, siebilldet0_.CONTRACT_HEADER_ID as CONTRACT24_349_, siebilldet0_.CONTRACT_NUMBER as CONTRACT25_349_, siebilldet0_.CONTRACT_NAME as CONTRACT26_349_, siebilldet0_.BUDGET_ITEMS_CODE as BUDGET27_349_, siebilldet0_.BUDGET_ITEM_NAME as BUDGET28_349_, siebilldet0_.BOE_ABSTRACT as BOE29_349_, siebilldet0_.OPERATION_TYPE_ID as OPERATION30_349_, siebilldet0_.OPERATION_TYPE_CODE as OPERATION31_349_, siebilldet0_.OPERATION_TYPE_NAME as OPERATION32_349_, siebilld et0_.DUTY_DEPT_ID as DUTY33_349_, siebilldet0_.DUTY_DEPT_NAME as DUTY34_349_, siebilldet0_.ACCOUNT_ID as ACCOUNT35_349_, siebilldet0_.ACCOUNT_NAME as ACCOUNT36_349_, siebilldet0_.CUSTOMER_BRAND as CUSTOMER37_349_, siebilldet0_.CUSTOMER_BRAND_NAME as CUSTOMER38_349_, siebilldet0_.TASK_ID as TASK39_349_, siebilldet0_.TASK_NUMBER as TASK40_349_, siebilldet0_.TASK_NAME as TASK41_349_, siebilldet0_.IS_URGENT_FLAG as IS42_349_, siebilldet0_.ENABLED_FLAG as ENABLED43_349_, siebilldet0_.BH_ENALBED_FLAG as BH44_349_, siebilldet0_.CHECK_UNIT as CHECK45_349_, siebilldet0_.ORG_ID as ORG46_349_, siebilldet0_.ATTRIBUTE4 as ATTRIBUTE47_349_, siebilldet0_.ATTRIBUTE5 as ATTRIBUTE48_349_ from SIE_BILL_DETAIL_QUERY_V siebilldet0_ where siebilldet0_.ENABLED_FLAG='Y' and siebilldet0_.BH_ENALBED_FLAG='Y' and siebilldet0_.BOE_DATE>=:1 and siebilldet0_.BOE_DATE<=:2 and (exists (select 1 from FBP_REPORT_RIGHTS fbpreportr1_ where siebilldet0_.ORG_ID=fbpreportr1_.DEPT_ID and fbpreportr1_.RIGHT_TYPE='DEPT_HIERARCHY' and fbpreportr1_.EMPLOYEE_ID=:3)) order by siebilldet0_.BOE_HEADER_ID desc ) where rownum <= :4
1htm3vwdyav5tSELECT boe_header_id FROM (SELECT /*+ INDEX(si SIE_INVOICES_N3) */ si.boe_header_id FROM sie_invoices si, wfr_bill_status bs, sie_boe_headers h where si.boe_header_id = bs.boe_header_id and si.boe_header_id = h.boe_header_id AND si.import_failed_reason is null AND (si.imp_into_mis_flag is NULL OR si.imp_into_mis_flag = 'N') AND (si.sie_invoice_type != 'GL_VOUCHER' OR si.batch_number IS NOT NULL) AND bs.current_status = '300_HAS_APPROVED' and si.sie_invoice_type = 'GL_VOUCHER' and substr(nvl(bs.import_into_mis_flag, 'N'), 0, 1) <> 'I' and exists (select 1 from fbp.fbp_gl_import_unit u where u.check_unit = h.check_unit and u.process_type = :1) order by nvl(bs.attribute3, 0), h.last_approve_date) WHERE rownum < 6
1pjdxv73cgz8vinsert into CBM_INVOKE_SERVICE_lOG (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ENABLED_FLAG, INVOKE_DATE, INVOKE_TYPE, IN_CONTENT, OUT_CONTENT, SOURCE_SYSTEM, SOURCE_NUM, INVOKE_SERVICE_LOG_ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
23284mf8u9m29update UUM_USERINFO set DUTYDESC=:1, CHANGETIME=:2, CREATETIME= :3, LASTMODIFYTIME= :4, USERJOININDATE= :5, USERNATION=:6, USERRELIGION=:7, USERQUITDATE= :8, USERDN=:9, EMPLOYEE=:10, USERID=:11, FULLNAME=:12, OUID=:13, OUGUID=:14, WORKOUGUID=:15, REGION=:16, REGIONID=:17, COMPANY=:18, COMPANYID=:19, BRANCH=:20, BRANCHID=:21, DEPARTMENT=:22, DEPARTMENTID=:23, USERGROUP=:24, USERGROUPID=:25, HALL=:26, HALLID=:27, SALEPOINT=:28, SALEPOINTID=:29, TEAMS=:30, JOBTYPE=:31, USERTYPE=:32, WORKPHONE=:33, TELEPHONE=:34, EMAIL=:35, ADDRESS=:36, USERBIRTHDAY= :37, SEX=:38, TITLE=:39, SHORTMOBILE=:40, USERPOSILEVEL=:41, EMPLOYEECLASS=:42, USERGRADE=:43, CMCCACCOUNT=:44, ORDERID=:45 where EMPLOYEE =:46
23z3nvmqbf4a0select h.boe_header_id, i.oid from sie_boe_headers h, mas_trans_info i where h.boe_header_id = i.boe_header_id and exists (select 1 from wfr_bill_histories bh, wfr_bill_his_persons p where bh.wf_histories_id = p.wf_histories_id and bh.boe_header_id = h.boe_header_id and bh.pre_workflow_status = i.boe_status and p.operate_employee_id = :1 and bh.creation_date >= :2 and bh.creation_date < :3) and i.sync_flag = 'N' and i.employee_id = :4
33g6811hm4t90BEGIN dbms_session.set_nls('NLS_LANGUAGE', '''SIMPLIFIED CHINESE''') ; END;
3puaqk8mgqbufupdate FBP_LOGINS set APP_ID=:1, USER_ID=:2, USER_CODE=:3, USER_NAME=:4, LOGIN_TIME=:5, LOGIN_IP=:6, LOGOUT_TIME=:7, ACTIVE_TIME=:8 where LOGIN_ID=:9
49qdfrvj15xw0 select * from ( select wfrbillsta0_.BOE_HEADER_ID as BOE1_572_, wfrbillsta0_.LAST_UPDATE_DATE as LAST2_572_, wfrbillsta0_.LAST_UPDATED_BY as LAST3_572_, wfrbillsta0_.CREATION_DATE as CREATION4_572_, wfrbillsta0_.CREATED_BY as CREATED5_572_, wfrbillsta0_.LAST_UPDATE_LOGIN as LAST6_572_, wfrbillsta0_.ENABLED_FLAG as ENABLED7_572_, wfrbillsta0_.MEMO as MEMO572_, wfrbillsta0_.WF_DEFINIENS_ID as WF9_572_, wfrbillsta0_.CURRENT_NODE_ID as CURRENT10_572_, wfrbillsta0_.BUDGET_CONTROL_FLAG as BUDGET11_572_, wfrbillsta0_.TO_EXECUTED_NUM_FLAG as TO12_572_, wfrbillsta0_.CURRENT_STATUS as CURRENT13_572_, wfrbillsta0_.CURRENT_HIERARCHY_ID as CURRENT14_572_, wfrbillsta0_.APPROVED_DATE as APPROVED15_572_, wfrbillsta0_.ON_APPROVE_FLAG as ON16_572_, wfrbillsta0_.IMPORT_INTO_MIS_FLAG as IMPORT17_572_, wfrbillsta0_.HAS_EXECUTED_FLAG as HAS18_572_, wfrbillsta0_.EXECUTED_DATE as EXECUTED19_572_, wfrbillsta0_.RESPITE_FLAG as RESPITE20_572_, wfrbillsta0_.ATTRIBUTE1 as ATTRIBUTE21_572_, wfrbillsta0_.ATTRIBUTE2 as ATTRIBUTE22_572_, wfrbillsta0_.ATTRIBUTE3 as ATTRIBUTE23_572_, wfrbillsta0_.ATTRIBUTE4 as ATTRIBUTE24_572_, wfrbillsta0_.ATTRIBUTE5 as ATTRIBUTE25_572_, wfrbillsta0_.ATTRIBUTE6 as ATTRIBUTE26_572_, wfrbillsta0_.ATTRIBUTE7 as ATTRIBUTE27_572_, wfrbillsta0_.ATTRIBUTE8 as ATTRIBUTE28_572_, wfrbillsta0_.ATTRIBUTE9 as ATTRIBUTE29_572_, wfrbillsta0_.ATTRIBUTE10 as ATTRIBUTE30_572_, wfrbillsta0_.ATTRIBUTE_CATEGORY as ATTRIBUTE31_572_, wfrbillsta0_.HAS_VIDEO_INFO_FLAG a s HAS32_572_, wfrbillsta0_.OPERATION_TYPE_ID as OPERATION33_572_, wfrbillsta0_.FORM_TYPE as FORM34_572_, wfrbillsta0_.apply_employee_id as apply35_572_, wfrbillsta0_.APPLY_AMOUNT as APPLY36_572_, wfrbillsta0_.DEPT_ID as DEPT37_572_ from WFR.WFR_BILL_STATUS wfrbillsta0_ where wfrbillsta0_.CURRENT_STATUS in ('601_IMPORT_FINISH' , '320_IN_MIS_IMPORT' , '310_MIS_IMPORT_ERROR') order by TO_NUMBER(wfrbillsta0_.ATTRIBUTE8) DESC, wfrbillsta0_.LAST_UPDATE_DATE DESC ) where rownum <= :1
5wxn1f0bb3kbnselect fbplookupv0_.LOOKUP_VALUE_ID as LOOKUP1_653_, fbplookupv0_.LOOKUP_TYPE as LOOKUP2_653_, fbplookupv0_.LOOKUP_CODE as LOOKUP3_653_, fbplookupv0_.MEANING as MEANING653_, fbplookupv0_.DESCRIPTION as DESCRIPT5_653_, fbplookupv0_.ENABLED_FLAG as ENABLED6_653_ from FBP_LOOKUP_VALUES_V fbplookupv0_ where 1=1 and fbplookupv0_.LOOKUP_TYPE=:1
675f4rv8w450bSELECT /*+ INDEX(si SIE_INVOICES_N3) */ count(1) FROM sie_invoices si, wfr_bill_status bs, sie_boe_headers h where si.boe_header_id = bs.boe_header_id and si.boe_header_id = h.boe_header_id AND si.import_failed_reason is null AND (si.imp_into_mis_flag is NULL OR si.imp_into_mis_flag = 'N') AND (si.sie_invoice_type != 'GL_VOUCHER' OR si.batch_number IS NOT NULL) AND bs.current_status = '300_HAS_APPROVED' and si.sie_invoice_type = :1
6mr0ub1d9dzrrselect * from ( SELECT a.dept_id, a.parent_dept_id, a.dept_code, b.dept_name, b.dept_long_name FROM fbp_depts a, fbp_depts_tl b WHERE a.DEPT_ID = b.DEPT_ID AND b.LANGUAGE = USERENV('LANG')and a.DEPT_ID = :1 ) where rownum <= :2
75v5ygwzwkq4jselect count(*) as col_0_0_ from SIE_BILL_DETAIL_QUERY_V siebilldet0_ where siebilldet0_.ENABLED_FLAG='Y' and siebilldet0_.BH_ENALBED_FLAG='Y' and siebilldet0_.BOE_DATE>=:1 and siebilldet0_.BOE_DATE<=:2 and (exists (select 1 from FBP_REPORT_RIGHTS fbpreportr1_ where siebilldet0_.ORG_ID=fbpreportr1_.DEPT_ID and fbpreportr1_.RIGHT_TYPE='DEPT_HIERARCHY' and fbpreportr1_.EMPLOYEE_ID=:3))
7m2ja89w4tmz7 select * from ( select sieboehead0_.BOE_HEADER_ID as BOE1_317_, sieboehead0_.LAST_UPDATE_DATE as LAST2_317_, sieboehead0_.LAST_UPDATED_BY as LAST3_317_, sieboehead0_.CREATION_DATE as CREATION4_317_, sieboehead0_.CREATED_BY as CREATED5_317_, sieboehead0_.CREATED_BY_NAME as CREATED6_317_, sieboehead0_.CHECK_UNIT as CHECK7_317_, sieboehead0_.CREATED_BY_FULL_NAME as CREATED8_317_, sieboehead0_.LAST_UPDATE_LOGIN as LAST9_317_, sieboehead0_.EMPLOYEE_ID as EMPLOYEE10_317_, sieboehead0_.EMPLOYEE_NUMBER as EMPLOYEE11_317_, sieboehead0_.EMPLOYEE_NAME as EMPLOYEE12_317_, sieboehead0_.EMPLOYEE_FULL_NAME as EMPLOYEE13_317_, sieboehead0_.BOE_NUM as BOE14_317_, sieboehead0_.BOE_TYPE_ID as BOE15_317_, sieboehead0_.BOE_TYPE_CODE as BOE16_317_, sieboehead0_.BOE_TYPE_NAME as BOE17_317_, sieboehead0_.TRANSACTION_TYPE as TRANSAC18_317_, sieboehead0_.BOE_STATUS as BOE19_317_, sieboehead0_.BOE_STATUS_NAME as BOE20_317_, sieboehead0_.OPERATION_TYPE_ID as OPERATION21_317_, sieboehead0_.OPERATION_TYPE_NAME as OPERATION22_317_, sieboehead0_.BUDGET_ITEMS_CODE as BUDGET23_317_, sieboehead0_.BUDGET_ITEM_NAME as BUDGET24_317_, sieboehead0_.BOE_DATE as BOE25_317_, sieboehead0_.IS_URGENT_FLAG as IS26_317_, sieboehead0_.BOE_ABSTRACT as BOE27_317_, sieboehead0_.APPLY_AMOUNT as APPLY28_317_, sieboehead0_.FINANCE_AUDIT_AMOUNT as FINANCE29_317_, sieboehead0_.FA_ENABLED_FLAG as FA30_317_, sieboehead0_.ENABLED_FLAG as ENABLED31_317_, sieboehead0_.PAYMENT_STATUS_CODE as PAYMENT32_317_, sieboehead0_.RESERVED_BUDGET_FLAG as RESERVED33_317_, sieboehead0_.SALARY_FLAG as SALARY34_317_, sieboehead0_.TAX_AMOUNT as TAX35_317_, sieboehead0_.CLAIM_RESULT as CLAIM36_317_, sieboehead0_.DOCUMENT_AMOUNT as DOCUMENT37_317_, sieboehead0_.SOURCE as SOURCE317_, sieboehead0_.EMAIL as EMAIL317_, sieboehead0_.MOBILE_PHONE as MOBILE40_317_, sieboehead0_.BOE_DEPT_ID as BOE41_317_, sieboehead0_.DEPT_NAME as DEPT42_317_, sieboehead0_.CHECK_UNIT_NAME as CHECK43_317_, sieboehead0_.CREATED_NUMBER as CREATED44_317_, sieboehead0_.CREATED_NAME as CREATED45_317_ from SIE_BOE_HEADERS_QRY_COMMON_V sieboehead0_ where 1=1 and sieboehead0_.ENABLED_FLAG='Y' and (sieboehead0_.BOE_STATUS in ('100_BOE_DRAFT')) and sieboehead0_.CREATED_BY=:1 order by sieboehead0_.BOE_HEADER_ID DESC ) where rownum <= :2
7v3g8c1x2hdav select * from ( select itemheader3_.ITEM_CODE as col_0_0_, itemheader3_.ITEM_NAME as col_1_0_, itemheader3_.ITEM_HEADER_ID as col_2_0_, itemheader3_.ITEM_CLASS as col_3_0_, fbpemploye0_.EMPLOYEE_NAME as col_4_0_, hiberarchy1_.ELEMENT_VL_NAME as col_5_0_, itemheader3_.AMOUNT as col_6_0_, itemheader3_.AGIO_AMOUNT as col_7_0_, itemheader3_.COST_AMOUNT as col_8_0_, itemheader3_.ITEM_STATUS as col_9_0_, itemheader3_.CURRENCY_CODE as col_10_0_, itemheader3_.BEGIN_YEAR||'-'||itemheader3_.BEGIN_MONTH as col_11_0_, itemheader3_.END_YEAR||'-'||itemheader3_.END_MONTH as col_12_0_, itemheader3_.COST_ITEM_FLAG as col_13_0_, itemheader3_.FUND_AMOUNT as col_14_0_, cbmitemclo2_.WAY_AMOUNT_CG as col_15_0_, cbmitemclo2_.AMOUNT_CG as col_16_0_, cbmitemclo2_.WAY_AMOUNT_HT as col_17_0_, cbmitemclo2_.AMOUNT_HT as col_18_0_, cbmitemclo2_.ACTUAL_AMOUNT as col_19_0_, cbmitemclo2_.AMOUNT_CGKY as col_20_0_, cbmitemclo2_.AMOUNT_HTKY as col_21_0_, itemheader3_.INIT_DEPT_ID as col_22_0_, itemheader3_.PRINCIPAL_EMPLOYEE_ID as col_23_0_, itemheader3_.BEGIN_YEAR as col_24_0_, itemheader3_.BEGIN_MONTH as col_25_0_, itemheader3_.END_YEAR as col_26_0_, itemheader3_.END_MONTH as col_27_0_ from FBP_EMPLOYEES_TL fbpemploye0_, BAS_HIBERARCHY_ELEMENTS_V hiberarchy1_, CBM_ITEM_CLOSE_INFO_V cbmitemclo2_, CBM_ITEM_HEADERS itemheader3_ where itemheader3_.PRINCIPAL_EMPLOYEE_ID=fbpemploye0_.EMPLOYEE_ID and hiberarchy1_.HIBERARCHY_ELEMENT_ID=itemheader3_.INIT_DEPT_ID and itemheader3_.ITEM_HEAD ER_ID=cbmitemclo2_.ITEM_HEADER_ID and (exists (select 1 from CBM_ITEM_RELATIONS itemrelati4_ where itemrelati4_.ITEM_HEADER_ID=itemheader3_.ITEM_HEADER_ID and (itemrelati4_.RELATION_ID in (10300 , 29783 , 30173 , 10181 , 10189 , 10383 , 10600 , 21799 , 21800 , 10022 , 10193 , 10295 , 10169 , 11081 , 10230 , 10352 , 10027 , 23862 , 17436 , 10237 , 10243 , 10246 , 10413 , 10565 , 30174 , 28242 , 23482 , 19091 , 10292 , 10615 , 10002 , 10534 , 10581)) and (itemrelati4_.RELATION_ID in (select hiberarchy5_.HIBERARCHY_ELEMENT_ID from BAS_HIBERARCHY_ELEMENTS hiberarchy5_ where hiberarchy5_.PARENT_HIBERARCHY_ELEMENT_ID=:1)) and itemrelati4_.RELATION_TYPE=:2)) and (itemheader3_.ITEM_STATUS=:3 or itemheader3_.ITEM_STATUS=:4 or itemheader3_.ITEM_STATUS=:5) and (itemheader3_.ITEM_NAME like '%'||:6||'%') and hiberarchy1_.LANGUAGE=:7 and fbpemploye0_.LANGUAGE=:8 ) where rownum <= :9
82g517bmvd2a5 select * from ( select sieboehead0_.BOE_HEADER_ID as BOE1_690_, sieboehead0_.LAST_UPDATE_DATE as LAST2_690_, sieboehead0_.LAST_UPDATED_BY as LAST3_690_, sieboehead0_.CREATION_DATE as CREATION4_690_, sieboehead0_.CREATED_BY as CREATED5_690_, sieboehead0_.CREATED_BY_NAME as CREATED6_690_, sieboehead0_.CREATED_BY_FULL_NAME as CREATED7_690_, sieboehead0_.LAST_UPDATE_LOGIN as LAST8_690_, sieboehead0_.BOE_NUM as BOE9_690_, sieboehead0_.BOE_TYPE_ID as BOE10_690_, sieboehead0_.BOE_TYPE_CODE as BOE11_690_, sieboehead0_.BOE_TYPE_NAME as BOE12_690_, sieboehead0_.BOE_STATUS as BOE13_690_, sieboehead0_.BOE_STATUS_NAME as BOE14_690_, sieboehead0_.ORG_ID as ORG15_690_, sieboehead0_.OPERATION_TYPE_ID as OPERATION16_690_, sieboehead0_.EMPLOYEE_ID as EMPLOYEE17_690_, sieboehead0_.EMPLOYEE_NAME as EMPLOYEE18_690_, sieboehead0_.EMPLOYEE_FULL_NAME as EMPLOYEE19_690_, sieboehead0_.GRADE_NAME as GRADE20_690_, sieboehead0_.BOE_DATE as BOE21_690_, sieboehead0_.IS_URGENT_FLAG as IS22_690_, sieboehead0_.HAS_CONTRACT_FLAG as HAS23_690_, sieboehead0_.BOE_ABSTRACT as BOE24_690_, sieboehead0_.APPLY_AMOUNT as APPLY25_690_, sieboehead0_.PAYED_AMOUNT as PAYED26_690_, sieboehead0_.FINANCE_APPROVE_TYPE as FINANCE27_690_, sieboehead0_.FINANCE_AUDIT_AMOUNT as FINANCE28_690_, sieboehead0_.FA_ENABLED_FLAG as FA29_690_, sieboehead0_.CONTRACT_HEADER_ID as CONTRACT30_690_, sieboehead0_.CONTRACT_NAME as CONTRACT31_690_, sieboehead0_.VENDOR_ID as VENDOR32_690_, sieboehead0_.VENDOR_NAME as VENDOR33_690_, sieboehead0_.APPROVE_COMMENT as APPROVE34_690_, sieboehead0_.ENABLED_FLAG as ENABLED35_690_, sieboehead0_.BOE_PAYMENT_STATUS as BOE36_690_, sieboehead0_.SALARY_FLAG as SALARY37_690_, sieboehead0_.IS_INVOICE_REASON_RETURN as IS38_690_, sieboehead0_.SOURCE as SOURCE690_, sieboehead0_.DEBIT_NUM as DEBIT40_690_, sieboehead0_.PRI_KEY as PRI41_690_ from SIE_BOE_HEADERS_QRY_V sieboehead0_ where 1=1 and sieboehead0_.BOE_STATUS<>:1 and (sieboehead0_.BOE_DATE is not null) and (sieboehead0_.EMPLOYEE_ID=:2 or sieboehead0_.CREATED_BY=:3) order by sieboehead0_.BOE_DATE DESC ) where rownum <= :4
8b59ynskq5uvpselect count(*) as col_0_0_ from SIE_BOE_HEADERS_QRY_COMMON_V sieboehead0_ where 1=1 and sieboehead0_.ENABLED_FLAG='Y' and (sieboehead0_.BOE_STATUS in ('100_BOE_DRAFT')) and sieboehead0_.CREATED_BY=:1
8nffyd1kd7kf2 insert into CBM_ITEM_HEADERS (LAST_UPDATE_DATE, LAST_UPDATED_BY, OA_PRESENT_OPERATION_DATE, OA_PRESENT_OPERATION_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ENABLED_FLAG, OFFSET_FLAG, REMARK, ITEM_CODE, ITEM_NAME, COST_ITEM_FLAG, FUND_ITEM_FLAG, ITEM_CLASS, ITEM_SORT, ITEM_STATUS, PRINCIPAL_EMPLOYEE_ID, INIT_DEPT_ID, MANAGE_DEPT_ID, BEGIN_YEAR, END_YEAR, BEGIN_MONTH, END_MONTH, AGIO_ACCOUNT_ID, CURRENCY_CODE, AGIO_AMOUNT, COST_AMOUNT, FUND_AMOUNT, COST_TAX_AMOUNT, FUND_TAX_AMOUNT, AMOUNT, INTENTION, CONTENT, MEMO, DOCUMENT, SUBMIT_DATE, SUBMIT_BY, CLOSE_DATE, CLOSE_BY, REVOKE_DATE, REVOKE_BY, APPROVE_OVER_DATE, ADJSUT_COUNT, ITEM_ANALYSIS, ITEM_RECKONING, ITEM_CATEGORY, ITEM_SUMMARY_ID, CONFERENCE_SUMMARY_ID, REBACK_REASON, REJECT_TACHE, PAY_BEGIN_YEAR, PAY_BEGIN_MONTH, PAY_END_YEAR, PAY_END_MONTH, ITEM_SOURCE_FROM, COMMIT_SUC_FLAG, IS_OA, ITEM_TYPE, IS_COPY_YEAR, PROJECT_NUM, ITEM_HEADER_ID) 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)
a5w368vyjr4w3select count(cbmitemsum0_.RN) as col_0_0_ from CBM_ITEM_SUMMARYS_APPROVE_V cbmitemsum0_ where DYNAMIC_PARAMETER_PKG.set_number_parameter1(:1)=1
abzzvu7hr5r8fselect fbplogins0_.LOGIN_ID as LOGIN1_440_0_, fbplogins0_.APP_ID as APP2_440_0_, fbplogins0_.USER_ID as USER3_440_0_, fbplogins0_.USER_CODE as USER4_440_0_, fbplogins0_.USER_NAME as USER5_440_0_, fbplogins0_.LOGIN_TIME as LOGIN6_440_0_, fbplogins0_.LOGIN_IP as LOGIN7_440_0_, fbplogins0_.LOGOUT_TIME as LOGOUT8_440_0_, fbplogins0_.ACTIVE_TIME as ACTIVE9_440_0_ from FBP_LOGINS fbplogins0_ where fbplogins0_.LOGIN_ID=:1
afcvg0t1xrvrmupdate FBP_SYNCH_REQUESTS set LAST_UPDATE_DATE=:1, LAST_UPDATED_BY=:2, CREATION_DATE=:3, CREATED_BY=:4, LAST_UPDATE_LOGIN=:5, SYNCH_REQUEST_NUMBER=:6, SYNCH_TYPE=:7, START_DATE_ACTIVE=:8, END_DATE_ACTIVE=:9, REPEAT_FLAG=:10, REPEAT_INTERVAL=:11, MAX_REPEAT_TIME=:12, ACTIVE_PROC=:13, TOTAL_TIME=:14, FAIL_TIME=:15, STATUS=:16, LAST_RUN_TIME=:17, MEMO=:18, ENABLED_FLAG=:19, ATTRIBUTE1=:20, ATTRIBUTE2=:21, ATTRIBUTE3=:22, ATTRIBUTE4=:23, ATTRIBUTE5=:24, ATTRIBUTE6=:25, ATTRIBUTE7=:26, ATTRIBUTE8=:27, ATTRIBUTE9=:28, ATTRIBUTE10=:29 where SYNCH_REQUEST_ID=:30
ardmc4prf3u46select * from ( select fbpnotices0_.ID as ID927_, fbpnotices0_.FROM_USER_ID as FROM2_927_, fbpnotices0_.SUBMIT_USER_ID as SUBMIT3_927_, fbpnotices0_.BOE_HEADER_ID as BOE4_927_, fbpnotices0_.WORKFLOW_TAG as WORKFLOW5_927_, fbpnotices0_.TO_USER_ID as TO6_927_, fbpnotices0_.TEMPLATE_ID as TEMPLATE7_927_, fbpnotices0_.CONTENT as CONTENT927_, fbpnotices0_.STATUS as STATUS927_, fbpnotices0_.OPERATION_TYPE as OPERATION10_927_, fbpnotices0_.ATTRIBUTE1 as ATTRIBUTE11_927_, fbpnotices0_.ATTRIBUTE2 as ATTRIBUTE12_927_, fbpnotices0_.ATTRIBUTE3 as ATTRIBUTE13_927_, fbpnotices0_.ATTRIBUTE4 as ATTRIBUTE14_927_, fbpnotices0_.ATTRIBUTE5 as ATTRIBUTE15_927_, fbpnotices0_.IS_RUNING as IS16_927_, fbpnotices0_.NOTICE_TYPE as NOTICE17_927_, fbpnotices0_.memo as memo927_ from FBP_NOTICES_NEW fbpnotices0_ where 1=1 and fbpnotices0_.NOTICE_TYPE='3' and fbpnotices0_.STATUS=0 and (fbpnotices0_.TEMPLATE_ID<>'PROVISION' or fbpnotices0_.TEMPLATE_ID is null) and (fbpnotices0_.IS_RUNING is null or fbpnotices0_.IS_RUNING='N') order by fbpnotices0_.ID ) where rownum <= :1
arn705x45mu4qselect count(*) as col_0_0_ from BIS_MAPINFO_SITES_V mapinfo0_ where 1=1 and mapinfo0_.LAST_UPDATE_DATE>=:1 and mapinfo0_.LAST_UPDATE_DATE<=:2 and rownum<=:3
azyvr427cjshd insert into SIE.SIE_BOE_NEED_HEADERS (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, BOE_NUM, BOE_TYPE_ID, ORG_ID, CHECK_UNIT, OPERATION_TYPE_ID, EMPLOYEE_ID, BOE_DEPT_ID, BOE_DATE, EMAIL, MOBILE_PHONE, ACTION_DATE, PAYMENT_STATUS_CODE, IS_URGENT_FLAG, IS_PROJECT_FLAG, HAS_CONTRACT_FLAG, HAS_REVERSE_ACCRUED_FLAG, HAS_ACCESSORY_FLAG, IS_ACCRUED_FLAG, CURRENCY_CODE, CURRENCY_UNIT, EXCHANGE_RATE, REVERSE_ACCRUED_CODE, BOE_ABSTRACT, BP_NUMBER, BP_COUNT, CUSTOMER_BRAND, NET_ATTRIBUTE, OPERATION_ATTRIBUTE, ERRAND_TYPE_CODE, APPLY_AMOUNT, FINANCE_AUDIT_AMOUNT, MULTI_APPROAL_AMOUNT, BALANCE_AMOUNT, STRIKE_BALANCE_AMOUNT, CAV_AMOUNTS, USEABLE_AMOUNTS, FI_CHANGE_REASON, UNIFY_DEPT_ID, CONTRACT_HEADER_ID, VENDOR_ID, VENDOR_SITE_ID, PO_HEADER_ID, COST_DEPT_ID, CUSTOMER_ID, CUSTOMER_SITE_ID, TASK_ID, RECEIVABLES_TRX_ID, RECEIVABLES_ORG_ID, RECEIPT_METHOD_ID, RECEIPT_BANK_ACCOUNT_ID, ERP_ORG_ID, BRAND_ID, CUST_TRX_TYPE_ORG_ID, CUST_TRX_TYPE_ID, PROJECT_CODE, BUDGET_ITEMS_CODE, MIS_AMOUNT, STATUS_CHANGE_REASON, PAYMENT_FLAG, INVOICE_NUMBER, NEED_BILL_FLAG, SUBMIT_CANCEL_CODE, SUBMIT_CANCEL_REASON, CHECK_REOPEN_FLAG, FA_ENABLED_FLAG, PAYMENT_TYPE, REGION_CODE, PAY_HEADER_ID, BOE_CATEGORY_CODE, RECEIPT_TYPE_CODE, RECEIPT_CATEGORY_CODE, BILL_ACCEPTER, SOURCE, SOURCE_BOE_NUM, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7 , ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, NUMBER_ATTRIBUTE1, NUMBER_ATTRIBUTE2, NUMBER_ATTRIBUTE3, NUMBER_ATTRIBUTE4, NUMBER_ATTRIBUTE5, NUMBER_ATTRIBUTE6, NUMBER_ATTRIBUTE7, NUMBER_ATTRIBUTE8, NUMBER_ATTRIBUTE9, NUMBER_ATTRIBUTE10, NUMBER_ATTRIBUTE11, NUMBER_ATTRIBUTE12, NUMBER_ATTRIBUTE13, NUMBER_ATTRIBUTE14, NUMBER_ATTRIBUTE15, DATE_ATTRIBUTE1, DATE_ATTRIBUTE2, DATE_ATTRIBUTE3, DATE_ATTRIBUTE4, DATE_ATTRIBUTE5, DATE_ATTRIBUTE6, DATE_ATTRIBUTE7, DATE_ATTRIBUTE8, DATE_ATTRIBUTE9, DATE_ATTRIBUTE10, VERSION_NUM, ENABLED_FLAG, ASSET_FROM_ORG_ID, ASSET_TO_ORG_ID, ASSET_TO_DEPT_ID, DESCRIPTION, APPRAISE_PROJECT_CODE, CONSTRUCT_PROJECT_CODE, RESERVED_BUDGET_FLAG, LAST_APPROVE_DATE, LAST_APPROVER_ID, ACC_CM_AMOUNT, CM_ADD_AMOUNT, ACC_CM_PAY, PAY_UPDATE_FLAG, BOE_HEADER_ID) 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, :9 1, :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)
b24r1090nnc9sSELECT BOV.EMPLOYEE_ID FROM WFR_BOE_OPERATOR_V BOV WHERE BOV.AUTHORIZED_EMPLOYEE_NUMBER=:B2 AND BOV.BOE_HEADER_ID=:B1
b8tf22rmqzbhp SELECT budget_item_id, budget_item_code, dept_name, budget_item_name, budget_item_class, balance_budget_amount, cost_item_flag FROM (SELECT A.budget_item_id, A.budget_item_code, A.dept_name, A.budget_item_name, A.budget_item_class, A.balance_budget_amount, A.cost_item_flag, ROWNUM RN from(select DISTINCT budget_item_id, budget_item_code, budget_item_name, budget_item_class, dept_name, enabled_flag, DECODE(SUBSTR(TRIM(to_char((AMOUNT - NVL((SELECT (CASE WHEN CIH.COST_ITEM_FLAG = 'Y' THEN (SELECT SUM(CCD.AMOUNT + NVL(CCD.WAY_AMOUNT, 0)) FROM CBM_COST_DETAILS CCD WHERE CCD.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ccd.pre_document_num Is Null) ELSE (SELECT SUM(CED.AMOUNT + NVL(CED.WAY_AMOUNT, 0)) FROM CBM_EXECUTE_DETAILS CED WHERE CED.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ced.pre_document_num Is Null) END) FROM CBM_ITEM_HEADERS CIH WHERE CIH.ITEM_HEADER_ID = BUDGET_ITEM_ID), 0)), '999, 999, 999, 999, 999.00')), 0, 1), '.', '0' || TRIM(to_char((AMOUNT - NVL((SELECT (CASE WHEN CIH.COST_ITEM_FLAG = 'Y' THEN (SELECT SUM(CCD.AMOUNT + NVL(CCD.WAY_AMOUNT, 0)) FROM CBM_COST_DETAILS CCD WHERE CCD.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ccd.pre_document_num Is Null) ELSE (SELECT SUM(CED.AMOUNT + NVL(CED.WAY_AMOUNT, 0)) FROM CBM_EXECUTE_DETAILS CED WHERE CED.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ced.pre_document_num Is Null) END) FROM CBM_ITEM_HEADERS CIH WHERE CIH.ITEM_HEADER_ID = BUDGET_ITEM_ID), 0)), '999, 999, 999, 999, 999.00')), TRIM(to_char((AMOUNT - NVL((SELECT (C ASE WHEN CIH.COST_ITEM_FLAG = 'Y' THEN (SELECT SUM(CCD.AMOUNT + NVL(CCD.WAY_AMOUNT, 0)) FROM CBM_COST_DETAILS CCD WHERE CCD.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ccd.pre_document_num Is Null) ELSE (SELECT SUM(CED.AMOUNT + NVL(CED.WAY_AMOUNT, 0)) FROM CBM_EXECUTE_DETAILS CED WHERE CED.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ced.pre_document_num Is Null) END) FROM CBM_ITEM_HEADERS CIH WHERE CIH.ITEM_HEADER_ID = BUDGET_ITEM_ID), 0)), '999, 999, 999, 999, 999.00'))) balance_budget_amount, d.cost_item_flag from BUDGET_NO_CONTRACT_ITEMS_V d where d.DEPT_ID in (SELECT FD.DEPT_ID FROM FBP.FBP_DEPTS FD WHERE FD.PARENT_DEPT_ID != 0 START WITH FD.DEPT_ID = 15705 CONNECT BY FD.DEPT_ID = PRIOR FD.PARENT_DEPT_ID) AND 1=1) A where ( budget_item_code like '%%' or budget_item_name like '%%' ) and ROWNUM <= 10) m WHERE RN > 0
ccgsbyj4bsjqbselect ih.item_code, ih.item_name, fp.project_number, fp.project_name from sie_boe_lines bl, cbm_item_headers ih, fbp_projects_all fp where bl.boe_header_id=:1 and bl.budget_items_code = ih.item_code(+) and bl.project_code = fp.project_number(+)
cs8zn8sz9stnh select fbpemploye0_.EMPLOYEE_ID as EMPLOYEE1_349_0_, fbpemploye0_.LAST_UPDATE_DATE as LAST2_349_0_, fbpemploye0_.LAST_UPDATED_BY as LAST3_349_0_, fbpemploye0_.ERP_ORG_ID as ERP4_349_0_, fbpemploye0_.CREATION_DATE as CREATION5_349_0_, fbpemploye0_.CREATED_BY as CREATED6_349_0_, fbpemploye0_.LAST_UPDATE_LOGIN as LAST7_349_0_, fbpemploye0_.EMPLOYEE_NUMBER as EMPLOYEE8_349_0_, fbpemploye0_.EMPLOYEE_NAME as EMPLOYEE9_349_0_, fbpemploye0_.DEPT_ID as DEPT10_349_0_, fbpemploye0_.DEPT_NAME as DEPT11_349_0_, fbpemploye0_.DEPT_LONG_NAME as DEPT12_349_0_, fbpemploye0_.CO_CODE as CO13_349_0_, fbpemploye0_.JOB_ID as JOB14_349_0_, fbpemploye0_.JOB_NAME as JOB15_349_0_, fbpemploye0_.CHECK_UNIT as CHECK16_349_0_, fbpemploye0_.CHECK_UNIT_NAME as CHECK17_349_0_, fbpemploye0_.PROD_PROJECT_ID as PROD18_349_0_, fbpemploye0_.COST_DEPT_ID as COST19_349_0_, fbpemploye0_.COST_DEPT_NAME as COST20_349_0_, fbpemploye0_.CURRENT_CREDIT as CURRENT21_349_0_, fbpemploye0_.GRADE_NAME as GRADE22_349_0_, fbpemploye0_.PASSWORD as PASSWORD349_0_, fbpemploye0_.POSITION_LEVEL as POSITION24_349_0_, fbpemploye0_.POSITION_NAME as POSITION25_349_0_, fbpemploye0_.EMPLOYEE_TYPE as EMPLOYEE26_349_0_, fbpemploye0_.SOURCE_SYSTEM as SOURCE27_349_0_, fbpemploye0_.SHORT_NAME as SHORT28_349_0_, fbpemploye0_.EXCHANGE_PERSON_FLAG as EXCHANGE29_349_0_, fbpemploye0_.EMPLOYEE_GUID as EMPLOYEE30_349_0_, fbpemploye0_.SYNCH_FLAG as SYNCH31_349_0_, fbpemploye0_.IS_SYNCH_REQUIRED as IS32_349_0_, fbpemploye0 _.USE_OA_FLAG as USE33_349_0_, fbpemploye0_.USE_EMAIL_FLAG as USE34_349_0_, fbpemploye0_.USE_SMS_FLAG as USE35_349_0_, fbpemploye0_.REJECT_SMS_FLAG as REJECT36_349_0_, fbpemploye0_.MON_NOTICE_FLAG as MON37_349_0_, fbpemploye0_.TUE_NOTICE_FLAG as TUE38_349_0_, fbpemploye0_.WED_NOTICE_FLAG as WED39_349_0_, fbpemploye0_.THU_NOTICE_FLAG as THU40_349_0_, fbpemploye0_.FRI_NOTICE_FLAG as FRI41_349_0_, fbpemploye0_.SAT_NOTICE_FLAG as SAT42_349_0_, fbpemploye0_.SUN_NOTICE_FLAG as SUN43_349_0_, fbpemploye0_.START_HOUR as START44_349_0_, fbpemploye0_.START_MIN as START45_349_0_, fbpemploye0_.END_HOUR as END46_349_0_, fbpemploye0_.END_MIN as END47_349_0_, fbpemploye0_.OA_ADDRESS as OA48_349_0_, fbpemploye0_.PHONE as PHONE349_0_, fbpemploye0_.MOBILE_PHONE as MOBILE50_349_0_, fbpemploye0_.EMAIL_ADDRESS as EMAIL51_349_0_, fbpemploye0_.ATTRIBUTE_CATEGORY as ATTRIBUTE52_349_0_, fbpemploye0_.ATTRIBUTE1 as ATTRIBUTE53_349_0_, fbpemploye0_.ATTRIBUTE2 as ATTRIBUTE54_349_0_, fbpemploye0_.ATTRIBUTE3 as ATTRIBUTE55_349_0_, fbpemploye0_.ATTRIBUTE4 as ATTRIBUTE56_349_0_, fbpemploye0_.ATTRIBUTE5 as ATTRIBUTE57_349_0_, fbpemploye0_.ATTRIBUTE6 as ATTRIBUTE58_349_0_, fbpemploye0_.ATTRIBUTE7 as ATTRIBUTE59_349_0_, fbpemploye0_.ATTRIBUTE8 as ATTRIBUTE60_349_0_, fbpemploye0_.ATTRIBUTE9 as ATTRIBUTE61_349_0_, fbpemploye0_.ATTRIBUTE10 as ATTRIBUTE62_349_0_, fbpemploye0_.ENABLED_FLAG as ENABLED63_349_0_, fbpemploye0_.DEPT_CODE as DEPT64_349_0_, fbpemploye0_.PORTAL_VIP as PORTAL65 _349_0_, fbpemploye0_.IS_DISPLAY_HIS as IS66_349_0_, fbpemploye0_.PORTAL_LEAVE as PORTAL67_349_0_, fbpemploye0_.APPROVE_SMS_FLAG as APPROVE68_349_0_ from FBP_EMPLOYEES_V fbpemploye0_ where fbpemploye0_.EMPLOYEE_ID=:1
davc0fj3jz03g select * from ( select c.APPROVE_EMPLOYEE_ID, c.ITEM_CODE, c.ITEM_NAME, c.ITEM_HEADER_ID, c.EMPLOYEE_NAME, c.EMPLOYEE_ID, c.last_update_date , c.ITEM_CLASS, c.CURRENT_HIERARCHY_ID, c.HIBERELEID, c.ITEM_STATUS, c.OPERATION_TYPE_ID, decode(c.ITEM_CLASS, 'Type_ItemAdjust', (SELECT V.MEANING FROM FBP_LOOKUP_VALUES_V V, cbm_adjust_headers cih WHERE cih.adjust_status= V.LOOKUP_CODE AND cih.adjust_header_id=c.ITEM_HEADER_ID AND V.LOOKUP_TYPE = 'CBM_ITEM_STATES' ), (SELECT V.MEANING FROM FBP_LOOKUP_VALUES_V V, cbm_item_headers cih WHERE cih.item_status= V.LOOKUP_CODE AND cih.item_header_id=c.ITEM_HEADER_ID AND V.LOOKUP_TYPE = 'CBM_ITEM_STATES' )) item_status_name from( select chaa.APPROVE_EMPLOYEE_ID, chaa.ITEM_CODE, chaa.ITEM_NAME, chaa.ITEM_HEADER_ID, chaa.EMPLOYEE_NAME, chaa.EMPLOYEE_ID, nvl(to_char((select max(wbh.last_update_date) from wfr_bill_histories wbh where wbh.boe_header_id = chaa.ITEM_HEADER_ID), 'yyyy-mm-dd hh24:mi:ss'), to_char(chaa.LAST_UPDATE_DATE, 'yyyy-mm-dd hh24:mi:ss')) LAST_UPDATE_DATE, chaa.ITEM_CLASS, chaa.CURRENT_HIERARCHY_ID, chaa.HIBERELEID, chaa.ITEM_STATUS, chaa.OPERATION_TYPE_ID from CBM_HEADERS_APPROVE_AUTH_V chaa) C where DYNAMIC_PARAMETER_PKG.set_number_parameter1(:1)=1 ORDER BY last_update_date DESC ) where rownum <= :2
dma91xjnqwxpxselect frontuserf0_.FRONT_USER_ID as FRONT1_394_, frontuserf0_.LAST_UPDATE_DATE as LAST2_394_, frontuserf0_.LAST_UPDATED_BY as LAST3_394_, frontuserf0_.CREATION_DATE as CREATION4_394_, frontuserf0_.CREATED_BY as CREATED5_394_, frontuserf0_.LAST_UPDATE_LOGIN as LAST6_394_, frontuserf0_.ENABLED_FLAG as ENABLED7_394_, frontuserf0_.EMPLOYEE_ID as EMPLOYEE8_394_, frontuserf0_.UPLOAD_MODE as UPLOAD9_394_, frontuserf0_.SITE_ID as SITE10_394_, frontuserf0_.FTP_SITE as FTP11_394_, frontuserf0_.PORT as PORT394_, frontuserf0_.FTP_USER_NAME as FTP13_394_, frontuserf0_.FTP_PASSWORD as FTP14_394_, frontuserf0_.START_HOUR as START15_394_, frontuserf0_.START_MINUTE as START16_394_, frontuserf0_.END_HOUR as END17_394_, frontuserf0_.END_MINUTE as END18_394_, frontuserf0_.USER_PURVIEW as USER19_394_, frontuserf0_.EMPLOYEE_NAME as EMPLOYEE20_394_, frontuserf0_.EMPLOYEE_NUMBER as EMPLOYEE21_394_, frontuserf0_.ROOT_DIRECTORY as ROOT22_394_ from EID_FRONT_USER_FTP_V frontuserf0_ where frontuserf0_.ENABLED_FLAG='Y' and frontuserf0_.EMPLOYEE_NUMBER='1821900732' and frontuserf0_.SITE_ID=10020
drq8bzdn6uujjselect fbpbillque0_.BOE_LINE_ID as BOE1_659_, fbpbillque0_.BOE_HEADER_ID as BOE2_659_, fbpbillque0_.PROJECT_NUMBER as PROJECT3_659_, fbpbillque0_.PROJECT_NAME as PROJECT4_659_, fbpbillque0_.ITEM_CODE as ITEM5_659_, fbpbillque0_.ITEM_NAME as ITEM6_659_ from fbp_bill_query_projects_v fbpbillque0_ where 1=1 and fbpbillque0_.BOE_HEADER_ID=:1
f2jpknrcu1v0w SELECT budget_item_id, budget_item_code, dept_name, budget_item_name, budget_item_class, balance_budget_amount, cost_item_flag FROM (SELECT A.budget_item_id, A.budget_item_code, A.dept_name, A.budget_item_name, A.budget_item_class, A.balance_budget_amount, A.cost_item_flag, ROWNUM RN from(select DISTINCT budget_item_id, budget_item_code, budget_item_name, budget_item_class, dept_name, enabled_flag, DECODE(SUBSTR(TRIM(to_char((AMOUNT - NVL((SELECT (CASE WHEN CIH.COST_ITEM_FLAG = 'Y' THEN (SELECT SUM(CCD.AMOUNT + NVL(CCD.WAY_AMOUNT, 0)) FROM CBM_COST_DETAILS CCD WHERE CCD.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ccd.pre_document_num Is Null) ELSE (SELECT SUM(CED.AMOUNT + NVL(CED.WAY_AMOUNT, 0)) FROM CBM_EXECUTE_DETAILS CED WHERE CED.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ced.pre_document_num Is Null) END) FROM CBM_ITEM_HEADERS CIH WHERE CIH.ITEM_HEADER_ID = BUDGET_ITEM_ID), 0)), '999, 999, 999, 999, 999.00')), 0, 1), '.', '0' || TRIM(to_char((AMOUNT - NVL((SELECT (CASE WHEN CIH.COST_ITEM_FLAG = 'Y' THEN (SELECT SUM(CCD.AMOUNT + NVL(CCD.WAY_AMOUNT, 0)) FROM CBM_COST_DETAILS CCD WHERE CCD.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ccd.pre_document_num Is Null) ELSE (SELECT SUM(CED.AMOUNT + NVL(CED.WAY_AMOUNT, 0)) FROM CBM_EXECUTE_DETAILS CED WHERE CED.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ced.pre_document_num Is Null) END) FROM CBM_ITEM_HEADERS CIH WHERE CIH.ITEM_HEADER_ID = BUDGET_ITEM_ID), 0)), '999, 999, 999, 999, 999.00')), TRIM(to_char((AMOUNT - NVL((SELECT (C ASE WHEN CIH.COST_ITEM_FLAG = 'Y' THEN (SELECT SUM(CCD.AMOUNT + NVL(CCD.WAY_AMOUNT, 0)) FROM CBM_COST_DETAILS CCD WHERE CCD.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ccd.pre_document_num Is Null) ELSE (SELECT SUM(CED.AMOUNT + NVL(CED.WAY_AMOUNT, 0)) FROM CBM_EXECUTE_DETAILS CED WHERE CED.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID And ced.pre_document_num Is Null) END) FROM CBM_ITEM_HEADERS CIH WHERE CIH.ITEM_HEADER_ID = BUDGET_ITEM_ID), 0)), '999, 999, 999, 999, 999.00'))) balance_budget_amount, d.cost_item_flag from BUDGET_NO_CONTRACT_ITEMS_V d where d.DEPT_ID in (SELECT FD.DEPT_ID FROM FBP.FBP_DEPTS FD WHERE FD.PARENT_DEPT_ID != 0 START WITH FD.DEPT_ID = 56089 CONNECT BY FD.DEPT_ID = PRIOR FD.PARENT_DEPT_ID) AND 1=1) A where ( budget_item_code like '%%' or budget_item_name like '%%' ) and ROWNUM <= 10) m WHERE RN > 0
f3yj5day8x9t5SELECT COUNT(*) FROM WFR_BOE_OPERATOR_V BOV WHERE BOV.AUTHORIZED_EMPLOYEE_NUMBER=:B2 AND BOV.BOE_HEADER_ID=:B1
fg4tjgjct11fcSELECT boe_header_id FROM (SELECT /*+ INDEX(si SIE_INVOICES_N3) */ si.boe_header_id FROM sie_invoices si, wfr_bill_status bs, sie_boe_headers h where si.boe_header_id = bs.boe_header_id and si.sie_invoice_type = :1 AND si.import_failed_reason is null AND (si.imp_into_mis_flag is NULL OR si.imp_into_mis_flag = 'N') AND (si.sie_invoice_type != 'GL_VOUCHER' OR si.batch_number IS NOT NULL) AND bs.current_status = '300_HAS_APPROVED' and si.boe_header_id = h.boe_header_id order by h.last_approve_date) WHERE rownum < :2
fncuwscyr5sdt SELECT APPS.GET_CBM_QUERY_ID() RN, B.* FROM (SELECT ITEM_HEADER_ID, ITEM_LINE_ID, END_YEAR, BEGIN_YEAR, QUARTER, MONTH, BEGIN_MONTH, END_MONTH, BUDGET_TYPE, COMPANY_CODE, COMPANY_NAME, BUDGET_DEPT_CODE, BUDGET_DEPT_DESC, PROJECT_NUM, PROJECT_NAME, BUDGET_ACCOUNT, BUDGET_ACCOUNT_DESC, ACTIVITY_CODE, ACTIVITY_NAME, BRAND_CODE, BRAND_NAME, USERGROUP_CODE, USERGROUP_NAME, PRODUCT_CODE, PRODUCT_NAME, CHANNEL_CODE, CHANNEL_NAME, STRATEGY_CODE, STRATEGY_NAME, DIMENSION1, DIMENSION_DESC1, DIMENSION2, DIMENSION_DESC2, DIMENSION3, DIMENSION_DESC3, DIMENSION4, DIMENSION_DESC4, DIMENSION5, DIMENSION_DESC5, DIMENSION6, DIMENSION_DESC6, CONTROL_METHOD_DESC, ENABLED_FLAG, BUDGET_AMOUNT , FREEZE_AMOUNT, RESERVED_AMOUNT, USED_AMOUNT, BUDGET_AMOUNT - FREEZE_AMOUNT - RESERVED_AMOUNT AVAILABLE_AMOUNT, LAST_UPDATE_DATE, TAX_AMOUNT FROM (SELECT CIH.ITEM_HEADER_ID, CIL.ITEM_LINE_ID, CILL.YEAR END_YEAR, CILL.YEAR BEGIN_YEAR, (CASE WHEN CILL.MONTH <= 3 THEN 1 WHEN CILL.MONTH > 3 AND CILL.MONTH < 7 THEN 2 WHEN CILL.MONTH > 6 AND CILL.MONTH < 10 THEN 3 ELSE 4 END) QUARTER, CILL.MONTH MONTH, CILL.MONTH BEGIN_MONTH, CILL.MONTH END_MONTH, (CASE WHEN CIL.ITEM_CLASS = 'FUNDITEM' THEN 'F' WHEN CIL.ITEM_CLASS = 'COSTITEM' THEN 'C' ELSE CIL.ITEM_CLASS END) BUDGET_TYPE, (select o.company_code from FBP_organization_units_v o, FBP_CHECK_UNIT_CONTENTS u where o.org_id = u.erp_org_id and u.org_id =CDV.dept_id and rownum=1) COMPANY_CODE, (SELECT c.check_unit_name FROM FBP_CHECK_UNIT_CONTENTS_V c WHERE c.org_id =CDV.dept_id and rownum=1) COMPANY_NAME, DEV.DEPT_CODE BUDGET_DEPT_CODE, DEV.DEPT_NAME BUDGET_DEPT_DESC, CIH.ITEM_CODE PROJECT_NUM, CIH.ITEM_NAME PROJECT_NAME, BA.ACCOUNT_CODE BUDGET_ACCOUNT, BAT.ACCOUNT_NAME BUDGET_ACCOUNT_DESC, (SELECT BV.VALUE_CODE FROM BAS_VALUES BV WHERE BV.VALUE_ID = BC.SEGMENT2 AND BV.VALUE_SET_CODE = 'CMGD_SE_ACT' and rownum=1) ACTIVITY_CODE, (SELECT TL.VALUE_NAME FROM BAS_VALUES_TL TL, BAS_VALUES BV WHERE TL.VALUE_ID = BV.VALUE_ID AND BV.VALUE_ID = BC.SEGMENT2 AND BV.VALUE_SET_CODE = 'CMGD_SE_ACT' AND TL.LANGUAGE = USERENV('LANG') and rownum=1) ACTIVITY_NAME, (SELECT BV.VALUE_CODE FROM BAS_VALUES BV WHERE BV.VALUE_ID = BC.SEGMENT4 AND BV.VALUE_SET_CODE = 'CMGD_SE_PRO' and rownum=1) BRAND_CODE, (SELECT TL.VALUE_NAME FROM BAS_VALUES_TL TL, BAS_VALUES BV WHERE TL.VALUE_ID = BV.VALUE_ID AND BV.VALUE_ID = BC.SEGMENT4 AND BV.VALUE_SET_CODE = 'CMGD_SE_PRO' AND TL.LANGUAGE = USERENV('LANG') and rownum=1) BRAND_NAME, '' USERGROUP_CODE, '' USERGROUP_NAME, '' PRODUCT_ CODE, '' PRODUCT_NAME, '' CHANNEL_CODE, '' CHANNEL_NAME, (SELECT BV.VALUE_CODE FROM BAS_VALUES BV WHERE BV.VALUE_ID = BC.SEGMENT3 AND BV.VALUE_SET_CODE = 'CMGD_SE_STR' and rownum=1) STRATEGY_CODE, (SELECT TL.VALUE_NAME FROM BAS_VALUES_TL TL, BAS_VALUES BV WHERE TL.VALUE_ID = BV.VALUE_ID AND BV.VALUE_ID = BC.SEGMENT3 AND BV.VALUE_SET_CODE = 'CMGD_SE_STR' AND TL.LANGUAGE = USERENV('LANG') and rownum=1) STRATEGY_NAME, '' DIMENSION1, '' DIMENSION_DESC1, '' DIMENSION2, '' DIMENSION_DESC2, '' DIMENSION3, '' DIMENSION_DESC3, '' DIMENSION4, '' DIMENSION_DESC4, '' DIMENSION5, '' DIMENSION_DESC5, '' DIMENSION6, '' DIMENSION_DESC6, '' CONTROL_METHOD_DESC, 'Y' ENABLED_FLAG, CILL.AMOUNT BUDGET_AMOUNT, NVL((SELECT SUM(CIR.WAY_AMOUNT) FROM CBM_COST_DETAILS CIR WHE RE CIR.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID AND CIR.ITEM_LINE_ID = CIL.ITEM_LINE_ID AND CIR.MONTH = CILL.MONTH AND CIR.YEAR = CILL.YEAR AND CIR.Pre_Document_Num IS NULL), 0) FREEZE_AMOUNT, NVL((SELECT SUM(CIR.AMOUNT) FROM CBM_COST_DETAILS CIR WHERE CIR.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID AND CIR.ITEM_LINE_ID = CIL.ITEM_LINE_ID AND CIR.MONTH = CILL.MONTH AND CIR.YEAR = CILL.YEAR AND CIR.Pre_Document_Num IS NULL), 0) RESERVED_AMOUNT, '' USED_AMOUNT, CIH.LAST_UPDATE_DATE LAST_UPDATE_DATE, decode(cih.COST_ITEM_FLAG, 'Y', cih.COST_TAX_AMOUNT, cih.FUND_TAX_AMOUNT) TAX_AMOUNT FROM CBM_ITEM_HEADERS CIH, BAS_HIBERARCHY_ELEMENT_M_V HEV, CBM_ITEM_LINES CIL, BAS_ACCOUNTS_TL BAT, BAS_ACCOUNTS BA, BAS_COMBINATIONS BC, CBM_ITEM_RESS CILL, FBP_DEPTS_VL DEV, FBP_DEPTS_VL CDV WHERE CIL.ITEM_HEADER_ID = CIH.ITEM_HEADER_ID AND CIL.ITEM_LINE_ID = CILL.ITEM_LINE_ID AND CIL.DUTY_DEPT_ID = HEV.HIBERARCHY_ELEMENT_ID AND CIL.COMBINATION_ID = BC.COMBINATION_ID AND BAT.ACCOUNT_ID = BC.SEGMENT5 AND BAT.ACCOUNT_ID = BA.ACCOUNT_ID AND DEV.DEPT_ID = HEV.VALUE_ID AND DEV.PARENT_DEPT_ID = CDV.DEPT_ID and cil.duty_dept_id=hev.hiberarchy_element_id and bc.combination_id=cil.combination_id and bc.segment5=ba.account_id and ba.account_id=bat.account_id AND HEV.LANGUAGE = USERENV('LANG') AND BAT.LANGUAGE = USERENV('LANG') AND CILL.YEAR = :1) CC) B WHERE 1 = 1 and b.PROJECT_NUM=:2
fwhp91qtfcj15select * from ( SELECT * FROM Sie_Bill_Query_V s WHERE s.enabled_Flag ='Y' and s.boe_Date >= :1 and s.boe_Date <= :2 and exists (select 1 from Fbp_Report_Rights r where r.dept_Id = s.org_Id and r.right_Type = 'DEPT_HIERARCHY' and r.employee_Id = :3) order by s.boe_Header_Id desc ) where rownum <= :4
fxypbtnpk00a1update CBM_ITEM_HEADERS set LAST_UPDATE_DATE=:1, LAST_UPDATED_BY=:2, OA_PRESENT_OPERATION_DATE=:3, OA_PRESENT_OPERATION_ID=:4, CREATION_DATE=:5, CREATED_BY=:6, LAST_UPDATE_LOGIN=:7, ENABLED_FLAG=:8, OFFSET_FLAG=:9, REMARK=:10, ITEM_CODE=:11, ITEM_NAME=:12, COST_ITEM_FLAG=:13, FUND_ITEM_FLAG=:14, ITEM_CLASS=:15, ITEM_SORT=:16, ITEM_STATUS=:17, PRINCIPAL_EMPLOYEE_ID=:18, INIT_DEPT_ID=:19, MANAGE_DEPT_ID=:20, BEGIN_YEAR=:21, END_YEAR=:22, BEGIN_MONTH=:23, END_MONTH=:24, AGIO_ACCOUNT_ID=:25, CURRENCY_CODE=:26, AGIO_AMOUNT=:27, COST_AMOUNT=:28, FUND_AMOUNT=:29, COST_TAX_AMOUNT=:30, FUND_TAX_AMOUNT=:31, AMOUNT=:32, INTENTION=:33, CONTENT=:34, MEMO=:35, DOCUMENT=:36, SUBMIT_DATE=:37, SUBMIT_BY=:38, CLOSE_DATE=:39, CLOSE_BY=:40, REVOKE_DATE=:41, REVOKE_BY=:42, APPROVE_OVER_DATE=:43, ADJSUT_COUNT=:44, ITEM_ANALYSIS=:45, ITEM_RECKONING=:46, ITEM_CATEGORY=:47, ITEM_SUMMARY_ID=:48, CONFERENCE_SUMMARY_ID=:49, REBACK_REASON=:50, REJECT_TACHE=:51, PAY_BEGIN_YEAR=:52, PAY_BEGIN_MONTH=:53, PAY_END_YEAR=:54, PAY_END_MONTH=:55, ITEM_SOURCE_FROM=:56, COMMIT_SUC_FLAG=:57, IS_OA=:58, ITEM_TYPE=:59, IS_COPY_YEAR=:60, PROJECT_NUM=:61 where ITEM_HEADER_ID=:62
gqwm6054a2g60select count(*) as col_0_0_ from SIE_BOE_HEADERS_NEED_APPROVE_V sieboehead0_ where 1=1 and (sieboehead0_.BOE_NUM like :1) and sieboehead0_.BOE_STATUS<>'100_BOE_DRAFT' and (exists (select 1 from SIE_BOE_TRANS_APPROVER sieboetran1_ where sieboetran1_.BOE_HEADER_ID=sieboehead0_.BOE_HEADER_ID and sieboetran1_.NOW_APPROVER=:2))
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 515,753 286.29 13.09
CPU used when call started 511,270 283.80 12.98
CR blocks created 10,444 5.80 0.27
Cached Commit SCN referenced 52,674,635 29,239.35 1,337.09
Commit SCN cached 343 0.19 0.01
DB time 1,067,883 592.78 27.11
DBWR checkpoint buffers written 39,569 21.96 1.00
DBWR checkpoints 1 0.00 0.00
DBWR fusion writes 258 0.14 0.01
DBWR object drop buffers written 0 0.00 0.00
DBWR parallel query checkpoint buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 222 0.12 0.01
DBWR undo block writes 15,022 8.34 0.38
DFO trees parallelized 33 0.02 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 180 0.10 0.00
PX local messages sent 180 0.10 0.00
PX remote messages recv'd 2,413 1.34 0.06
PX remote messages sent 1,313 0.73 0.03
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 33 0.02 0.00
RowCR - row contention 42 0.02 0.00
RowCR attempts 4,092 2.27 0.10
RowCR hits 4,033 2.24 0.10
SMON posted for dropping temp segment 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 1 0.00 0.00
SQL*Net roundtrips to/from client 1,498,716 831.93 38.04
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 16,810 9.33 0.43
application wait time 22,033 12.23 0.56
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 12,323 6.84 0.31
branch node splits 1 0.00 0.00
buffer is not pinned count 163,545,107 90,782.84 4,151.42
buffer is pinned count 609,138,674 338,128.98 15,462.33
bytes received via SQL*Net from client 383,783,771 213,035.91 9,741.94
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 922,483,547 512,064.71 23,416.26
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 1,722,080 955.92 43.71
calls to kcmgas 99,900 55.45 2.54
calls to kcmgcs 6,943 3.85 0.18
change write time 616 0.34 0.02
cleanout - number of ktugct calls 17,144 9.52 0.44
cleanouts and rollbacks - consistent read gets 9,786 5.43 0.25
cleanouts only - consistent read gets 432 0.24 0.01
cluster key scan block gets 7,963 4.42 0.20
cluster key scans 1,211 0.67 0.03
cluster wait time 1,516 0.84 0.04
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 35 0.02 0.00
commit batch/immediate requested 35 0.02 0.00
commit cleanout failures: block lost 1 0.00 0.00
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 132 0.07 0.00
commit cleanout failures: cannot pin 6 0.00 0.00
commit cleanouts 74,002 41.08 1.88
commit cleanouts successfully completed 73,863 41.00 1.87
commit immediate performed 35 0.02 0.00
commit immediate requested 35 0.02 0.00
commit txn count during cleanout 1,942 1.08 0.05
concurrency wait time 107 0.06 0.00
consistent changes 449,094 249.29 11.40
consistent gets 376,332,671 208,899.86 9,552.80
consistent gets - examination 153,044,968 84,954.28 3,884.88
consistent gets direct 5,288 2.94 0.13
consistent gets from cache 376,327,367 208,896.91 9,552.67
current blocks converted for CR 0 0.00 0.00
cursor authentications 125 0.07 0.00
data blocks consistent reads - undo records applied 449,074 249.28 11.40
db block changes 1,017,935 565.05 25.84
db block gets 711,950 395.20 18.07
db block gets direct 2,882 1.60 0.07
db block gets from cache 709,068 393.60 18.00
deferred (CURRENT) block cleanout applications 53,373 29.63 1.35
dirty buffers inspected 131 0.07 0.00
enqueue conversions 2,770 1.54 0.07
enqueue deadlocks 0 0.00 0.00
enqueue releases 230,901 128.17 5.86
enqueue requests 231,003 128.23 5.86
enqueue timeouts 108 0.06 0.00
enqueue waits 1,594 0.88 0.04
exchange deadlocks 0 0.00 0.00
execute count 809,003 449.07 20.54
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 227,038 126.03 5.76
free buffer requested 153,607 85.27 3.90
gc CPU used by this session 12,942 7.18 0.33
gc blocks lost 0 0.00 0.00
gc cr block build time 25 0.01 0.00
gc cr block flush time 0 0.00 0.00
gc cr block receive time 605 0.34 0.02
gc cr block send time 178 0.10 0.00
gc cr blocks received 2,398 1.33 0.06
gc cr blocks served 19,322 10.73 0.49
gc current block flush time 1 0.00 0.00
gc current block pin time 1 0.00 0.00
gc current block receive time 695 0.39 0.02
gc current block send time 20 0.01 0.00
gc current blocks received 10,234 5.68 0.26
gc current blocks served 1,803 1.00 0.05
gc local grants 114,663 63.65 2.91
gc remote grants 7,622 4.23 0.19
gcs messages sent 165,173 91.69 4.19
ges messages sent 5,008 2.78 0.13
global enqueue get time 23,053 12.80 0.59
global enqueue gets async 715 0.40 0.02
global enqueue gets sync 956,177 530.77 24.27
global enqueue releases 955,370 530.32 24.25
heap block compress 15,854 8.80 0.40
hot buffers moved to head of LRU 1,234,517 685.27 31.34
immediate (CR) block cleanout applications 10,218 5.67 0.26
immediate (CURRENT) block cleanout applications 4,113 2.28 0.10
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 6,627 3.68 0.17
index fast full scans (direct read) 0 0.00 0.00
index fast full scans (full) 3,081 1.71 0.08
index fast full scans (rowid ranges) 0 0.00 0.00
index fetch by key 75,411,699 41,860.55 1,914.25
index scans kdiixs1 38,482,454 21,361.36 976.84
leaf node 90-10 splits 41 0.02 0.00
leaf node splits 109 0.06 0.00
lob reads 1,446 0.80 0.04
lob writes 1,795 1.00 0.05
lob writes unaligned 607 0.34 0.02
logons cumulative 1,098 0.61 0.03
messages received 58,230 32.32 1.48
messages sent 58,230 32.32 1.48
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 222,312,407 123,404.19 5,643.16
opened cursors cumulative 448,134 248.76 11.38
parse count (failures) 22 0.01 0.00
parse count (hard) 3,047 1.69 0.08
parse count (total) 449,236 249.37 11.40
parse time cpu 28,528 15.84 0.72
parse time elapsed 28,594 15.87 0.73
physical read IO requests 134,912 74.89 3.42
physical read bytes 2,271,813,632 1,261,069.19 57,667.56
physical read total IO requests 142,365 79.03 3.61
physical read total bytes 2,668,256,256 1,481,131.96 67,730.84
physical read total multi block requests 24,019 13.33 0.61
physical reads 277,321 153.94 7.04
physical reads cache 106,895 59.34 2.71
physical reads cache prefetch 45 0.02 0.00
physical reads direct 170,426 94.60 4.33
physical reads direct (lob) 2,143 1.19 0.05
physical reads direct temporary tablespace 166,096 92.20 4.22
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 44,707 24.82 1.13
physical write bytes 1,712,488,448 950,591.37 43,469.69
physical write total IO requests 86,294 47.90 2.19
physical write total bytes 2,327,288,832 1,291,863.12 59,075.74
physical write total multi block requests 55,149 30.61 1.40
physical writes 209,044 116.04 5.31
physical writes direct 168,998 93.81 4.29
physical writes direct (lob) 2,868 1.59 0.07
physical writes direct temporary tablespace 166,096 92.20 4.22
physical writes from cache 40,046 22.23 1.02
physical writes non checkpoint 189,194 105.02 4.80
pinned buffers inspected 0 0.00 0.00
prefetch clients - default 3 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 1,702 0.94 0.04
queries parallelized 33 0.02 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 760,779 422.30 19.31
recursive cpu usage 35,804 19.87 0.91
redo blocks written 569,426 316.08 14.45
redo buffer allocation retries 4 0.00 0.00
redo entries 553,166 307.06 14.04
redo log space requests 4 0.00 0.00
redo log space wait time 7 0.00 0.00
redo ordering marks 14,532 8.07 0.37
redo size 273,078,888 151,584.34 6,931.82
redo subscn max counts 2,361 1.31 0.06
redo synch time 6,323 3.51 0.16
redo synch writes 37,390 20.75 0.95
redo wastage 9,104,960 5,054.10 231.12
redo write time 2,231 1.24 0.06
redo writer latching time 0 0.00 0.00
redo writes 38,429 21.33 0.98
rollback changes - undo records applied 35 0.02 0.00
rollbacks only - consistent read gets 657 0.36 0.02
rows fetched via callback 12,975,795 7,202.78 329.38
session connect time 0 0.00 0.00
session cursor cache hits 367,335 203.91 9.32
session logical reads 377,045,071 209,295.30 9,570.89
session pga memory 77,326,987,424 42,923,715.39 1,962,862.99
session pga memory max 91,496,984,736 50,789,390.13 2,322,553.24
session uga memory ############### 78,689,244.12 3,598,388.52
session uga memory max 662,954,568 368,001.83 16,828.39
shared hash latch upgrades - no wait 58,544 32.50 1.49
shared hash latch upgrades - wait 9 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 648,613 360.04 16.46
sorts (rows) 16,267,801 9,030.15 412.94
sql area evicted 6 0.00 0.00
sql area purged 25 0.01 0.00
summed dirty queue length 223 0.12 0.01
switch current to new buffer 8,669 4.81 0.22
table fetch by rowid 311,213,529 172,752.64 7,899.82
table fetch continued row 1,070,210 594.07 27.17
table scan blocks gotten 55,298,931 30,696.08 1,403.70
table scan rows gotten 2,510,941,329 1,393,807.45 63,737.56
table scans (direct read) 0 0.00 0.00
table scans (long tables) 1 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 362,574 201.26 9.20
total number of times SMON posted 8 0.00 0.00
transaction lock background get time 0 0.00 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 35 0.02 0.00
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 115,394,900 64,054.97 2,929.18
user I/O wait time 23,336 12.95 0.59
user calls 1,884,469 1,046.06 47.84
user commits 37,541 20.84 0.95
user rollbacks 1,854 1.03 0.05
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 2 0.00 0.00
workarea executions - optimal 656,000 364.14 16.65
write clones created in background 0 0.00 0.00
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 3,255,027 3,257,577
opened cursors current 14,776 14,734
workarea memory allocated 4,367 958
logons current 498 496

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 2.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)
EAS_DATA_NEW 102,656 57 1.73 1.00 9,210 5 8,517 3.42
TEMP 23,728 13 4.30 7.00 23,731 13 0 0.00
EAS_DATA 6,364 4 3.51 1.00 7,105 4 9 0.00
DAT_HRMS 446 0 1.37 1.00 1,482 1 0 0.00
UNDOTBS2 0 0 0.00 0.00 1,288 1 7 0.00
SYSTEM 833 0 0.74 1.00 176 0 0 0.00
EAS_IND 313 0 5.02 1.00 655 0 0 0.00
USERS 178 0 4.55 1.17 699 0 0 0.00
SYSAUX 428 0 3.83 1.00 391 0 0 0.00
DAT_EVSAS 3 0 3.33 1.00 62 0 0 0.00
IDX_HRMS 2 0 0.00 1.00 2 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)
DAT_EVSAS /dev/vx/rdsk/racdg/datafile103 1 0 10.00 1.00 1 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile333 1 0 0.00 1.00 1 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile36 0 0     4 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile37 0 0     1 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile373 1 0 0.00 1.00 31 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile374 0 0     9 0 0 0.00
DAT_EVSAS /dev/vx/rdsk/racdg/datafile388 0 0     15 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile16 2 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile17 1 0 10.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile332 1 0 0.00 1.00 191 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile337 5 0 0.00 1.00 10 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile338 4 0 0.00 1.00 13 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile359 2 0 0.00 1.00 37 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile360 1 0 0.00 1.00 2 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile361 4 0 5.00 1.00 5 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile362 3 0 3.33 1.00 9 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile363 11 0 0.91 1.00 87 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile364 2 0 10.00 1.00 13 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile365 80 0 0.38 1.00 353 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile366 5 0 2.00 1.00 12 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile370 1 0 0.00 1.00 0 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile54 2 0 0.00 1.00 1 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile73 4 0 5.00 1.00 7 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile74 71 0 3.66 1.00 212 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile78 201 0 0.35 1.00 366 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile79 5 0 2.00 1.00 14 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile80 6 0 3.33 1.00 15 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile83 6 0 6.67 1.00 7 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile84 9 0 3.33 1.00 15 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile92 5 0 4.00 1.00 23 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile93 2 0 0.00 1.00 16 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile94 12 0 1.67 1.00 47 0 0 0.00
DAT_HRMS /dev/vx/rdsk/racdg/datafile95 1 0 10.00 1.00 26 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile01 261 0 2.30 1.00 46 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile05 154 0 3.51 1.00 20 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile07 246 0 2.52 1.00 33 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile08 349 0 1.52 1.00 28 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile09 243 0 2.26 1.00 28 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile10 217 0 2.49 1.04 17 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile100 60 0 5.17 1.00 469 0 2 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile104 141 0 4.47 1.00 298 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile108 106 0 4.43 1.00 124 0 1 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile11 243 0 2.43 1.00 37 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile113 33 0 3.64 1.00 53 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile116 23 0 3.91 1.00 6 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile119 51 0 3.92 1.00 45 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile120 39 0 3.33 1.00 6 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile121 43 0 3.72 1.00 29 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile122 2 0 0.00 1.00 14 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile125 4 0 2.50 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile126 3 0 3.33 1.00 2 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile127 5 0 4.00 1.00 44 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile128 10 0 3.00 1.00 37 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile129 8 0 5.00 1.00 3 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile130 3 0 3.33 1.00 7 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile132 5 0 6.00 1.00 1 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile133 8 0 8.75 1.00 5 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile134 1 0 10.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile136 7 0 2.86 1.00 5 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile137 5 0 2.00 1.00 5 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile300 5 0 0.00 1.00 0 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile301 0 0     4 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile302 2 0 0.00 1.00 3 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile303 5 0 4.00 1.00 7 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile306 1 0 0.00 1.00 2 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile307 34 0 5.00 1.00 122 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile308 43 0 2.79 1.00 90 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile309 43 0 4.42 1.00 18 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile310 37 0 3.78 1.00 128 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile311 35 0 3.43 1.00 26 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile312 20 0 4.50 1.00 30 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile313 45 0 2.89 1.00 57 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile314 60 0 1.83 1.00 26 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile315 70 0 4.14 1.00 64 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile316 83 0 5.18 1.00 32 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile317 78 0 7.05 1.00 79 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile318 81 0 4.69 1.01 36 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile319 121 0 4.63 1.00 47 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile320 81 0 4.07 1.00 53 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile321 86 0 5.47 1.00 85 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile334 123 0 5.20 1.00 258 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile335 100 0 4.80 1.00 67 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile336 36 0 2.50 1.00 71 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile340 29 0 4.14 1.00 124 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile343 113 0 2.83 1.00 46 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile344 51 0 5.69 1.00 42 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile345 37 0 3.51 1.00 36 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile346 167 0 4.73 1.00 107 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile347 92 0 3.37 1.00 123 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile348 70 0 5.00 1.00 35 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile349 123 0 4.55 1.00 133 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile350 472 0 2.37 1.00 33 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile351 52 0 2.88 1.00 19 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile352 21 0 2.86 1.00 30 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile353 40 0 3.50 1.00 103 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile354 7 0 5.71 1.00 8 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile355 13 0 3.85 1.00 23 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile356 34 0 4.71 1.00 62 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile357 22 0 4.09 1.00 76 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile358 19 0 4.74 1.00 35 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile377 11 0 1.82 1.00 17 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile383 286 0 4.44 1.00 620 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile384 303 0 3.53 1.00 632 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile385 196 0 5.26 1.00 660 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile386 78 0 5.51 1.00 843 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile390 2 0 0.00 1.00 7 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile391 4 0 5.00 1.00 18 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile392 4 0 0.00 1.00 12 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile55 238 0 1.85 1.00 24 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile75 117 0 3.16 1.00 28 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile76 90 0 3.33 1.00 25 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile87 29 0 4.14 1.00 72 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile88 31 0 4.19 1.03 37 0 0 0.00
EAS_DATA /dev/vx/rdsk/racdg/datafile99 154 0 4.81 1.00 408 0 6 0.00
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile409 6,352 4 1.67 1.00 285 0 416 2.84
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile410 5,187 3 1.58 1.00 307 0 394 3.07
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile411 5,910 3 1.54 1.00 208 0 416 2.88
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile412 5,472 3 1.68 1.00 568 0 349 3.90
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile413 4,489 2 1.89 1.00 397 0 351 3.28
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile414 3,903 2 2.17 1.00 395 0 404 3.76
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile415 3,077 2 2.19 1.00 415 0 293 3.28
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile416 3,287 2 2.20 1.00 236 0 443 3.48
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile417 3,794 2 1.89 1.00 627 0 438 3.36
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile418 4,055 2 1.85 1.00 424 0 470 3.11
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile419 4,087 2 1.83 1.00 167 0 402 3.61
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile420 3,288 2 2.02 1.00 120 0 482 2.95
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile421 2,899 2 2.37 1.00 155 0 362 3.34
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile422 5,952 3 1.83 1.00 776 0 426 3.52
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile423 4,169 2 2.17 1.00 376 0 442 3.80
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile424 5,993 3 1.81 1.00 836 0 443 3.48
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile425 6,809 4 1.59 1.00 555 0 553 3.62
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile426 7,720 4 1.24 1.00 866 0 398 3.64
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile427 8,178 5 1.34 1.00 829 0 449 3.72
EAS_DATA_NEW /dev/vx/rdsk/racdg/datafile428 8,035 4 1.51 1.00 668 0 586 3.67
EAS_IND /dev/vx/rdsk/racdg/datafile02 149 0 5.23 1.00 251 0 0 0.00
EAS_IND /dev/vx/rdsk/racdg/datafile06 164 0 4.82 1.00 404 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile329 1 0 0.00 1.00 1 0 0 0.00
IDX_HRMS /dev/vx/rdsk/racdg/datafile339 1 0 0.00 1.00 1 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile105 31 0 3.87 1.00 13 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile111 55 0 2.00 1.00 12 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile131 12 0 3.33 1.00 2 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile22 39 0 3.85 1.00 48 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile331 12 0 5.00 1.00 2 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile56 57 0 3.86 1.00 55 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile71 57 0 4.21 1.00 58 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile89 25 0 5.20 1.00 21 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/datafile90 39 0 4.87 1.00 30 0 0 0.00
SYSAUX /dev/vx/rdsk/racdg/sysaux01 101 0 3.76 1.00 150 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/appdbc_system03 37 0 1.35 1.00 35 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile328 104 0 0.29 1.00 3 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile341 0 0     1 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/datafile97 2 0 10.00 1.00 0 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system01 689 0 0.75 1.00 131 0 0 0.00
SYSTEM /dev/vx/rdsk/racdg/system02 1 0 0.00 1.00 6 0 0 0.00
TEMP /dev/vx/rdsk/racdg/datafile327 23,728 13 4.30 7.00 23,731 13 0  
UNDOTBS2 /dev/vx/rdsk/racdg/datafile380 0 0     1,033 1 1 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/datafile64 0 0     11 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/datafile65 0 0     13 0 0 0.00
UNDOTBS2 /dev/vx/rdsk/racdg/undotbs02a 0 0     231 0 6 0.00
USERS /dev/vx/rdsk/racdg/datafile106 2 0 5.00 1.00 85 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile115 7 0 4.29 1.00 90 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile117 5 0 6.00 1.00 64 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile139 2 0 5.00 1.00 62 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile21 7 0 2.86 1.00 59 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile330 18 0 5.00 1.00 93 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile342 49 0 2.65 1.63 62 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile382 71 0 5.49 1.00 121 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile91 2 0 5.00 1.00 0 0 0 0.00
USERS /dev/vx/rdsk/racdg/datafile96 7 0 5.71 1.00 47 0 0 0.00
USERS /dev/vx/rdsk/racdg/users01 8 0 6.25 1.00 16 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 3,494,499 100 376,977,184 106,914 40,060 0 0 8,535


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 5 4863 44184 947250 2138040 947250  
E 0 1 2179 28888 571013 2138040 571013  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 2,912 0.10 349,258 100.82 27,980,338,111
D 5,824 0.20 698,516 55.18 15,314,966,171
D 8,736 0.30 1,047,774 30.07 8,345,436,964
D 11,648 0.40 1,397,032 16.45 4,565,322,723
D 14,560 0.50 1,746,290 8.87 2,462,930,809
D 17,472 0.60 2,095,548 5.01 1,389,605,471
D 20,384 0.70 2,444,806 2.88 798,950,847
D 23,296 0.80 2,794,064 1.80 499,495,285
D 26,208 0.90 3,143,322 1.26 349,575,921
D 29,120 1.00 3,492,580 1.00 277,750,290
D 29,136 1.00 3,494,499 1.00 277,521,622
D 32,032 1.10 3,841,838 0.87 240,752,858
D 34,944 1.20 4,191,096 0.79 220,592,380
D 37,856 1.30 4,540,354 0.75 209,085,660
D 40,768 1.40 4,889,612 0.73 202,249,535
D 43,680 1.50 5,238,870 0.71 197,916,284
D 46,592 1.60 5,588,128 0.70 195,156,959
D 49,504 1.70 5,937,386 0.70 192,942,652
D 52,416 1.80 6,286,644 0.69 191,000,651
D 55,328 1.90 6,635,902 0.61 170,413,086
D 58,240 2.00 6,985,160 0.48 133,006,364

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
91.59 15,292 1,403

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 4,096 256 4,838.93 4.26 0.09 100.00 0.00 419,430
E 4,096 256 4,803.19 0.94 0.02 100.00 0.00 419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 645,066 645,066 0 0
64K 128K 624 624 0 0
128K 256K 116 116 0 0
256K 512K 4 4 0 0
512K 1024K 6,738 6,738 0 0
1M 2M 3,087 3,087 0 0
2M 4M 157 157 0 0
4M 8M 121 121 0 0
8M 16M 56 56 0 0
16M 32M 12 12 0 0
32M 64M 15 15 0 0
64M 128M 2 2 0 0
128M 256M 3 3 0 0
512M 1024M 2 0 2 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
512 0.13 11,027,343.28 5,511,953.16 67.00 102,052
1,024 0.25 11,027,343.28 5,287,246.86 68.00 94,805
2,048 0.50 11,027,343.28 3,046,816.97 78.00 58,701
3,072 0.75 11,027,343.28 1,769,690.29 86.00 27,070
4,096 1.00 11,027,343.28 292,426.94 97.00 0
4,915 1.20 11,027,343.28 228,621.66 98.00 0
5,734 1.40 11,027,343.28 224,617.47 98.00 0
6,554 1.60 11,027,343.28 219,271.43 98.00 0
7,373 1.80 11,027,343.28 206,190.85 98.00 0
8,192 2.00 11,027,343.28 202,336.84 98.00 0
12,288 3.00 11,027,343.28 137,021.98 99.00 0
16,384 4.00 11,027,343.28 32,166.18 100.00 0
24,576 6.00 11,027,343.28 20,515.22 100.00 0
32,768 8.00 11,027,343.28 20,515.22 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
8,816 0.20 4,566 130,307 15,094,900 0.98 633,916 2.17 1,173,069,317
13,264 0.30 9,015 183,875 15,290,984 0.99 437,832 1.50 1,173,587,217
17,712 0.40 13,466 250,703 15,340,787 0.99 388,029 1.33 1,173,734,856
22,160 0.50 17,906 334,336 15,370,447 1.00 358,369 1.23 1,173,832,068
26,608 0.60 22,369 435,594 15,387,577 1.00 341,239 1.17 1,173,924,401
31,056 0.70 26,811 495,342 15,406,379 1.00 322,437 1.10 1,174,004,486
35,504 0.80 31,250 541,389 15,419,167 1.00 309,649 1.06 1,174,065,845
39,952 0.90 35,711 586,548 15,429,159 1.00 299,657 1.03 1,174,111,521
44,400 1.00 40,157 682,022 15,436,949 1.00 291,867 1.00 1,174,146,259
48,848 1.10 44,603 791,862 15,438,888 1.00 289,928 0.99 1,174,176,854
53,296 1.20 49,046 889,097 15,442,542 1.00 286,274 0.98 1,174,199,737
57,744 1.30 53,491 937,546 15,444,883 1.00 283,933 0.97 1,174,220,108
62,192 1.40 57,936 977,429 15,445,926 1.00 282,890 0.97 1,174,238,437
66,640 1.50 62,377 1,017,605 15,446,656 1.00 282,160 0.97 1,174,253,451
71,088 1.60 66,821 1,062,659 15,473,865 1.00 254,951 0.87 1,174,268,144
75,536 1.70 71,266 1,107,866 15,474,450 1.00 254,366 0.87 1,174,282,476
79,984 1.80 75,708 1,162,869 15,477,369 1.00 251,447 0.86 1,174,296,528
84,432 1.90 80,151 1,221,282 15,484,708 1.00 244,108 0.84 1,174,309,562
88,880 2.00 88,880 1,530,195 15,485,852 1.00 242,964 0.83 1,174,326,049

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
18,432 0.25 21,627,815 11,702,112,818
36,864 0.50 5,679,318 389,140,730
55,296 0.75 5,292,233 293,173,775
73,728 1.00 5,202,746 277,521,559
92,160 1.25 5,161,644 270,555,768
110,592 1.50 5,142,394 283,599,281
129,024 1.75 5,116,380 186,494,488
147,456 2.00 5,103,895 186,494,488

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)
16 1.00 0 0 0 0
32 2.00 0 0 0 0
48 3.00 0 0 0 0
64 4.00 0 0 0 0
80 5.00 0 0 0 0
96 6.00 0 0 0 0
112 7.00 0 0 0 0
128 8.00 0 0 0 0
144 9.00 0 0 0 0
160 10.00 0 0 0 0
176 11.00 0 0 0 0
192 12.00 0 0 0 0
208 13.00 0 0 0 0
224 14.00 0 0 0 0
240 15.00 0 0 0 0
256 16.00 0 0 0 0
272 17.00 0 0 0 0
288 18.00 0 0 0 0
304 19.00 0 0 0 0
320 20.00 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

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

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 8,529 29 3
undo header 6 0 0
undo block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 47 46 0 45 225 5,007.33
WF-AWR Flush 19 19 0 10 0 38.20
PS-PX Process Reservation 802 801 1 653 0 0.56
JQ-Job Queue 564 457 107 409 0 0.61
TM-DML 42,640 42,640 0 306 0 0.40
CF-Controlfile Transaction 4,404 4,404 0 126 0 0.77
FB-Format Block 12 12 0 9 0 0.67
RW-Materialized View Flags (MV metadata contention) 23 23 0 8 0 0.50
TA-Instance Undo 6 6 0 6 0 0.50
TD-KTF map table enqueue (KTF dump entries) 4 4 0 4 0 0.50
TT-Tablespace 1,409 1,409 0 2 0 1.00
MS-Materialized View Refresh Log 13 13 0 7 0 0.14
DR-Distributed Recovery 1 1 0 1 0 1.00
HW-Segment High Water Mark 3,114 3,114 0 1 0 1.00
MW-MWIN Schedule 1 1 0 1 0 1.00
IR-Instance Recovery 2 2 0 1 0 0.00
SR-Synchronized Replication 2 2 0 1 0 0.00
UL-User-defined 2 2 0 1 0 0.00
US-Undo Segment 1 1 0 1 0 0.00
WL-Being Written Redo Log 1 1 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
4 14.71 40,473 1,903 12 5760/5760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
05-Dec 12:29 12,680 11,310 1,903 8 5,760 0/0 0/0/0/0/0/0
05-Dec 12:19 827 13,474 1,301 10 5,760 0/0 0/0/0/0/0/0
05-Dec 12:09 1,206 15,689 698 12 5,760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 1,213 0.00   0 0  
AWR Alerted Metric Element list 28,746 0.00   0 0  
Consistent RBA 38,441 0.00   0 0  
FAL request queue 39 0.00   0 0  
FAL subheap alocation 39 0.00   0 0  
FIB s.o chain latch 6 0.00   0 0  
FOB s.o list latch 861 0.00   0 0  
JS broadcast add buf latch 2,151 0.00   0 0  
JS broadcast drop buf latch 2,151 0.00   0 0  
JS broadcast load blnc latch 2,097 0.00   0 0  
JS mem alloc latch 2 0.00   0 0  
JS queue access latch 2 0.00   0 0  
JS queue state obj latch 125,820 0.00   0 0  
KCL gc element parent latch 327,882 0.00 0.00 0 257 0.00
KJC message pool free list 93,343 0.02 0.00 0 4,051 0.07
KJCT flow control latch 320,420 0.01 0.00 0 0  
KMG MMAN ready and startup request latch 601 0.00   0 0  
KTF sga latch 8 0.00   0 603 0.00
KWQMN job cache list latch 135 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 36 0.00
Memory Management Latch 0     0 601 0.00
OS process 294 0.00   0 0  
OS process allocation 795 0.00   0 0  
OS process: request allocation 186 0.00   0 0  
PL/SQL warning settings 34,858 0.00   0 0  
SGA IO buffer pool latch 23 0.00   0 23 0.00
SQL memory manager latch 175 1.14 1.00 0 599 0.17
SQL memory manager workarea list latch 472,238 0.00 0.00 0 0  
Shared B-Tree 67 0.00   0 0  
active checkpoint queue latch 22,124 0.04 0.00 0 0  
active service list 30,639 0.00   0 639 0.00
archive control 64 0.00   0 0  
archive process latch 680 0.00   0 0  
begin backup scn array 2,868 0.00   0 0  
business card 66 0.00   0 0  
cache buffer handles 446,967 0.02 0.00 0 0  
cache buffers chains 604,794,191 0.09 0.01 0 186,773 0.00
cache buffers lru chain 161,126 0.00 0.00 0 201,634 0.00
cache table scan latch 0     0 23 0.00
channel handle pool latch 192 0.00   0 0  
channel operations parent latch 191,063 0.00 0.00 0 0  
checkpoint queue latch 659,085 0.00 0.00 0 37,392 0.00
client/application info 3,113 0.00   0 0  
commit callback allocation 4 0.00   0 0  
compile environment latch 1,097 0.00   0 0  
constraint object allocation 4 0.00   0 0  
dml lock allocation 85,295 0.01 0.00 0 0  
dummy allocation 2,196 0.00   0 0  
enqueue hash chains 562,843 0.00 0.00 0 311 0.00
enqueues 399,818 0.01 0.00 0 0  
error message lists 159 0.00   0 0  
event group latch 92 0.00   0 0  
file cache latch 1,628 0.00   0 0  
gcs opaque info freelist 24,144 0.01 0.00 0 0  
gcs partitioned table hash 610,613 0.00   0 0  
gcs remastering latch 16,048 0.00   0 0  
gcs resource freelist 31,205 0.00   0 251 0.00
gcs resource hash 369,954 0.02 0.00 0 0  
gcs shadows freelist 602 0.00   0 1,418 0.00
ges caches resource lists 671,927 0.03 0.00 0 57,447 0.06
ges deadlock list 444 0.00   0 16 0.00
ges domain table 1,917,025 0.00 0.00 0 0  
ges enqueue table freelist 1,918,211 0.00 0.00 0 0  
ges group table 2,867,480 0.00 0.00 0 0  
ges process hash list 1,459 0.00   0 0  
ges process parent latch 3,835,620 0.00   0 0  
ges process table freelist 186 0.00   0 0  
ges resource hash list 2,837,441 0.01 0.00 0 38,274 0.00
ges resource scan list 244 0.00   0 0  
ges resource table freelist 74,258 0.00   0 0  
ges timeout list 566 0.00   0 780 0.00
global KZLD latch for mem in SGA 42 0.00   0 0  
global tx hash mapping 1,369 0.00   0 0  
hash table column usage latch 379 0.00   0 4,193,278 0.00
hash table modification latch 43 0.00   0 0  
internal temp table object number allocation latc 10 0.00   0 0  
job workq parent latch 0     0 786 0.00
job_queue_processes parameter latch 390 0.00   0 0  
kks stats 6,029 0.02 2.00 0 0  
kokc descriptor allocation latch 12 0.00   0 0  
ksuosstats global area 122 0.00   0 0  
ktm global data 12 0.00   0 0  
kwqbsn:qsga 66 0.00   0 0  
lgwr LWN SCN 38,680 0.01 0.00 0 0  
library cache 6,081,646 0.02 0.00 0 8,463 0.00
library cache load lock 30 0.00   0 0  
library cache lock 3,458,872 0.00 0.00 0 0  
library cache lock allocation 42,922 0.00   0 0  
library cache pin 2,576,927 0.01 0.00 0 0  
library cache pin allocation 8,395 0.00   0 0  
list of block allocation 1,627 0.00   0 0  
loader state object freelist 13,406 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 12 0.00   0 12 0.00
message pool operations parent latch 3,972 0.00   0 0  
messages 226,419 0.02 0.00 0 0  
mostly latch-free SCN 40,704 1.77 0.00 0 0  
multiblock read objects 4,320 0.00   0 0  
name-service memory objects 4,948 0.00   0 0  
name-service namespace bucket 18,581 0.00   0 0  
name-service pending queue 4,236 0.00   0 0  
name-service request queue 22,234 0.00   0 0  
ncodef allocation latch 30 0.00   0 0  
object queue header heap 89,107 0.00   0 1,259 0.00
object queue header operation 499,072 0.00 0.00 0 0  
object stats modification 1 0.00   0 0  
parallel query alloc buffer 5,508 0.00   0 0  
parallel query stats 711 0.00   0 0  
parallel txn reco latch 7,866 0.00   0 0  
parameter list 632 0.00   0 0  
parameter table allocation management 1,176 0.00   0 0  
post/wait queue 57,315 0.05 0.00 0 37,304 0.03
process allocation 16,010 0.01 0.50 0 91 1.10
process group creation 186 0.00   0 0  
process queue 2,085 0.00   0 0  
process queue reference 41,116 0.00 0.00 0 3,499 0.00
qmn task queue latch 256 0.00   0 0  
query server freelists 1,449 0.00   0 0  
queued dump request 8,989 0.00   0 0  
redo allocation 193,197 0.03 0.00 0 553,122 0.03
redo copy 0     0 553,173 0.02
redo writing 138,814 0.01 0.00 0 0  
resmgr group change latch 1,394 0.00   0 0  
resmgr:active threads 2,193 0.00   0 0  
resmgr:actses change group 735 0.00   0 0  
resmgr:free threads list 2,192 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 16,490,848 0.17 0.00 0 94 0.00
rules engine rule set statistics 100 0.00   0 0  
sequence cache 893,936 0.00 0.00 0 0  
session allocation 221,280 0.08 0.01 0 0  
session idle bit 3,887,285 0.00 0.00 0 0  
session state list latch 2,149 0.00   0 0  
session switching 30 0.00   0 0  
session timer 639 0.00   0 0  
shared pool 651,503 0.03 0.41 0 0  
shared pool sim alloc 16 0.00   0 0  
shared pool simulator 1,727,364 0.00 0.10 0 0  
simulator hash latch 24,952,909 0.00 0.00 0 0  
simulator lru latch 0     0 24,941,905 0.27
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 1,378 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 2,016 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
threshold alerts latch 353 0.00   0 0  
transaction allocation 20,139,110 0.36 0.00 0 0  
transaction branch allocation 1,962 0.00   0 0  
undo global data 154,432 0.00 0.00 0 0  
user lock 238 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 604,794,191 517,456 6,068 512,646 0 0 0
transaction allocation 20,139,110 73,081 7 73,074 0 0 0
row cache objects 16,490,848 27,701 3 27,698 0 0 0
library cache 6,081,646 1,168 4 1,164 0 0 0
shared pool 651,503 191 79 127 0 0 0
session allocation 221,280 167 2 165 0 0 0
shared pool simulator 1,727,364 50 5 45 0 0 0
SQL memory manager latch 175 2 2 0 0 0 0
process allocation 16,010 2 1 1 0 0 0
kks stats 6,029 1 2 0 0 0 0
slave class create 8 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 3 0
SQL memory manager latch qesmmIQueryRefreshBound 0 2 2
cache buffers chains kcbgtcr: kslbegin excl 0 39,769 41,912
cache buffers chains kclcls_3 0 3,519 231
cache buffers chains kcbrls: kslbegin 0 174 659
cache buffers chains kcbzwb 0 67 736
cache buffers chains kcbgtcr: fast path 0 14 10
cache buffers chains kcbgcur: kslbegin 0 3 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 1 1
cache buffers chains kcbget: pin buffer 0 1 0
cache buffers chains kcbzib: finish free bufs 0 1 1
kks stats kks stats alloc/free 0 2 2
library cache kglpndl: child: after processing 0 4 0
process allocation ksucrp 0 1 0
row cache objects kqreqd: reget 0 3 0
session allocation ksufap: active sessions 0 2 0
session idle bit ksupuc: clear busy 0 1 1
shared pool kghalo 0 75 5
shared pool kghupr1 0 4 68
shared pool simulator kglsim_unpin_simhp 0 3 0
shared pool simulator kglsim_unpin_simhp: fast path 0 2 5
slave class create ksvcreate 0 1 0
transaction allocation ktcxbr 0 7 7

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
WFR EAS_IND WFR_BILL_HISTORIES_PK   INDEX 49,806,768 13.21
SIE EAS_DATA_NEW SIE_INVOICES_N3   INDEX 44,987,072 11.93
WFR EAS_DATA_NEW WFR_BILL_HISTORIES   TABLE 25,791,632 6.84
WFR EAS_DATA_NEW WFR_BILL_STATUS   TABLE 22,328,048 5.92
CBMS EAS_DATA_NEW CBM_COST_DETAILS   TABLE 22,078,032 5.86

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
SIE EAS_DATA_NEW SIE_BOE_LINES   TABLE 62,195 22.43
CBMS EAS_DATA_NEW CBM_COST_DETAILS   TABLE 24,101 8.69
FBP EAS_DATA_NEW FBP_TASKS   TABLE 4,968 1.79
APPS EAS_DATA_NEW SYS_LOB0000392047C00013$$   LOB 1,930 0.70
CBMS EAS_DATA_NEW CBM_COST_DETAILS_N5   INDEX 1,852 0.67

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
FBP EAS_DATA FBP_LOGINS   TABLE 90 78.26
SYS SYSAUX WRH$_LATCH_MISSES_SUMMARY_PK 982_112240 INDEX PARTITION 4 3.48
SYS SYSAUX WRH$_LATCH_PK 982_112240 INDEX PARTITION 4 3.48
SYS SYSAUX WRH$_SYSSTAT_PK 982_112240 INDEX PARTITION 4 3.48
FBP EAS_DATA FBP_SYNCH_REQUESTS   TABLE 2 1.74

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
FBP EAS_DATA FBP_LOGINS   TABLE 8 100.00

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
CBMS EAS_DATA_NEW CBM_COST_DETAILS   TABLE 1,423 72.94
CBMS EAS_DATA_NEW CBM_COST_DETAILS_N5   INDEX 506 25.94
CBMS EAS_DATA_NEW CBM_EXECUTE_DETAILS   TABLE 22 1.13

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
WFR EAS_DATA_NEW WFR_BILL_STATUS   TABLE 995 41.49
SIE EAS_DATA SIE_BOE_HEADERS   TABLE 704 29.36
SIE EAS_DATA SIE_BOE_TRANS_APPROVER   TABLE 306 12.76
EVS DAT_EVSAS PK_VOUCHER_ID   INDEX 117 4.88
SYS SYSTEM JOB$   TABLE 57 2.38

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
SIE EAS_DATA_NEW SIE_BOE_LINES   TABLE 4,919 48.07
SYS SYSAUX SCHEDULER$_EVENT_LOG   TABLE 3,231 31.57
WFR EAS_IND WFR_BILL_HISTORIES_N1   INDEX 477 4.66
CBMS EAS_DATA_NEW CBM_COST_DETAILS   TABLE 411 4.02
SIE EAS_DATA_NEW SIE_BOE_LINES_N1   INDEX 254 2.48

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 31 6.45 0   0 1
dc_database_links 133 0.00 0   0 9
dc_global_oids 689 0.00 0   0 32
dc_histogram_data 1,271,357 0.00 0   0 11,096
dc_histogram_defs 347,998 0.01 0   0 5,904
dc_object_grants 48 0.00 0   0 51
dc_object_ids 1,338,151 0.00 0   0 1,698
dc_objects 38,906 0.02 0   4 1,517
dc_profiles 77 0.00 0   0 2
dc_rollback_segments 14,296 0.00 0   0 1,313
dc_segments 131,522 0.00 0   0 1,526
dc_sequences 454 0.44 0   454 82
dc_table_scns 329 0.00 0   8 21
dc_tablespaces 1,258,180 0.00 0   0 31
dc_usernames 23,287 0.00 0   0 69
dc_users 2,234,860 0.00 0   0 95
global database name 4 0.00 0   0 1
outstanding_alerts 161 99.38 0   0 1

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 2 2 0
dc_histogram_defs 36 0 0
dc_object_ids 4 0 0
dc_objects 18 0 0
dc_segments 1 0 0
dc_sequences 908 4 0
dc_table_scns 30 0 0
outstanding_alerts 319 160 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 157 0.00 36,474 0.00 0 0
CLUSTER 2 0.00 4 0.00 0 0
INDEX 1 0.00 11 0.00 0 0
SQL AREA 71,722 7.98 868,958 1.04 118 3
TABLE/PROCEDURE 137,785 0.00 1,665,057 0.00 8 0
TRIGGER 115 0.00 115 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 4 0 0 0 0
INDEX 11 0 0 0 0
TABLE/PROCEDURE 903,796 2 5 2 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 3,181.59   6.34 49.11 1,098 1,098 502 502
  PL/SQL 1,156.04 133.10 2.31 50.89 1,138 1,138 500 500
  Freeable 444.81 0.00 1.17 4.05 79   379 379
  SQL 56.87 33.76 0.12 0.78 17 499 465 357
E Other 3,167.72   6.34 49.16 1,097 1,097 500 500
  PL/SQL 1,157.13 133.17 2.32 51.04 1,139 1,139 498 498
  Freeable 425.75 0.00 1.19 4.15 79   359 359
  SQL 52.96 29.81 0.11 0.77 17 499 463 354

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 30,551,310,336  
Fixed Size 2,284,240  
Redo Buffers 34,603,008  
Variable Size 46,721,213,744  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 106.24 106.24 0.00
java joxlod exec hp 5.58 5.58 0.00
large PX msg pool 1.34 1.34 0.00
large free memory 30.66 30.66 0.00
shared CCursor 1,069.45 1,079.12 0.90
shared PCursor 1,207.01 1,212.10 0.42
shared free memory 14,366.65 14,019.96 -2.41
shared gcs resources 606.08 606.08 0.00
shared library cache 917.78 918.26 0.05
shared sql area 24,797.29 25,128.65 1.34
streams free memory 16.00 16.00 0.00
  buffer_cache 29,136.00 29,136.00 0.00
  fixed_sga 2.18 2.18 0.00
  log_buffer 33.00 33.00 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 Coordinator 64,936 0 0
QMON Slaves 62,962 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_shadows 2,913,837 3,445,231 3922305 3922305


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_optimizer_cost_based_transformation LINEAR   
audit_file_dest /oracle/admin/appdbc/adump   
audit_sys_operations TRUE   
audit_trail DB_EXTENDED   
background_dump_dest /oracle/admin/appdbc/bdump   
cluster_database TRUE   
cluster_database_instances 2   
cluster_interconnects 192.168.9.2   
compatible 10.2.0.3.0   
control_files /dev/vx/rdsk/racdg/control01, /dev/vx/rdsk/racdg/control02, /dev/vx/rdsk/racdg/control03   
core_dump_dest /oracle/admin/appdbc/cdump   
db_block_size 8192   
db_cache_size 1509949440   
db_domain      
db_file_multiblock_read_count 16   
db_files 400   
db_name appdbc   
db_recovery_file_dest      
db_recovery_file_dest_size 53687091200   
dispatchers (PROTOCOL=TCP) (SERVICE=appdbcXDB)   
instance_number 2   
java_pool_size 16777216   
job_queue_processes 20   
large_pool_size 16777216   
log_archive_dest_1 LOCATION=/arch_1   
max_dump_file_size 1024m   
open_cursors 600   
pga_aggregate_target 4294967296   
processes 2500   
remote_login_passwordfile EXCLUSIVE   
resource_limit TRUE   
service_names eip, epm, mdbc2, eas, appdbc   
sessions 2755   
sga_max_size 77309411328   
sga_target 77309411328   
shared_pool_size 2818572288   
spfile /dev/vx/rdsk/racdg/spfile   
streams_pool_size 16777216   
thread 2   
undo_management AUTO   
undo_retention 1800   
undo_tablespace UNDOTBS2   
user_dump_dest /oracle/admin/appdbc/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 591 0.33 0.02
acks for commit broadcast(logical) 656 0.36 0.02
broadcast msgs on commit(actual) 38,349 21.29 0.97
broadcast msgs on commit(logical) 38,426 21.33 0.98
broadcast msgs on commit(wasted) 709 0.39 0.02
broadcast on commit wait time(ms) 7,396 4.11 0.19
broadcast on commit waits 34,260 19.02 0.87
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 2 0.00 0.00
flow control messages sent 71 0.04 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 1,173 0.65 0.03
gcs ast xid 0 0.00 0.00
gcs blocked converts 4,809 2.67 0.12
gcs blocked cr converts 7,927 4.40 0.20
gcs compatible basts 24 0.01 0.00
gcs compatible cr basts (global) 42 0.02 0.00
gcs compatible cr basts (local) 11,317 6.28 0.29
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 155 0.09 0.00
gcs dbwr write request msgs 50 0.03 0.00
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 507 0.28 0.01
gcs immediate (null) converts 1,373 0.76 0.03
gcs immediate cr (compatible) converts 0 0.00 0.00
gcs immediate cr (null) converts 5,830 3.24 0.15
gcs indirect ast 3,992 2.22 0.10
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 15 0.01 0.00
gcs msgs process time(ms) 8,707 4.83 0.22
gcs msgs received 138,278 76.76 3.51
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 0 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 6,986 3.88 0.18
gcs side channel msgs logical 20,085 11.15 0.51
gcs stale cr 67,043 37.22 1.70
gcs undo cr 0 0.00 0.00
gcs write notification msgs 2 0.00 0.00
gcs writes refused 2 0.00 0.00
ges msgs process time(ms) 175 0.10 0.00
ges msgs received 5,353 2.97 0.14
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 904 0.50 0.02
implicit batch messages sent 8,176 4.54 0.21
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 39,260 21.79 1.00
messages queue sent actual 131,497 72.99 3.34
messages queue sent logical 146,928 81.56 3.73
messages received actual 137,668 76.42 3.49
messages received logical 143,646 79.74 3.65
messages sent directly 18,855 10.47 0.48
messages sent indirectly 105,805 58.73 2.69
messages sent not implicit batched 123,320 68.45 3.13
messages sent pbatched 74,392 41.29 1.89
msgs causing lmd to send msgs 2,004 1.11 0.05
msgs causing lms(s) to send msgs 67,904 37.69 1.72
msgs received queue time (ms) 33,085 18.37 0.84
msgs received queued 143,657 79.74 3.65
msgs sent queue time (ms) 10,742 5.96 0.27
msgs sent queue time on ksxp (ms) 33,657 18.68 0.85
msgs sent queued 146,949 81.57 3.73
msgs sent queued on ksxp 151,703 84.21 3.85
process batch messages received 40,437 22.45 1.03
process batch messages sent 71,315 39.59 1.81


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 11,549
CURRENT Block Requests 7,773
Data Block Requests 11,549
Undo Block Requests 0
TX Block Requests 4,757
Current Results 19,310
Private results 1
Zero Results 11
Disk Read Results 0
Fail Results 0
Fairness Down Converts 1,540
Fairness Clears 0
Free GC Elements 0
Flushes 13
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 14
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 1,803 100.00 0.00 0.00 0.00 0.00
Flushes 7 100.00 0.00 0.00 0.00 0.00
Writes 258 78.68 16.67 0.78 3.10 0.78


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 2,423 46.60 53.40 0.00 10,174 99.02 0.12 0.86
1 Others 9 100.00 0.00 0.00 49 100.00 0.00 0.00
1 undo header 8 100.00 0.00 0.00 2 50.00 50.00 0.00


Back to Top

End of Report Report written to awrrpt_2_112311_112312.html Prod:user=sys,db=appdbc SQL>