WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
VIS279835501VIS109-Sep-10 05:0911.2.0.1.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
bur834-66Solaris[tm] OE (64-bit) 32 16 4 128.00

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1109-Sep-10 05:47:0826 1.5
End Snap:1309-Sep-10 08:00:045467 62.8
Elapsed:  132.93 (mins)  
DB Time:  2,003.10 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 10,080M 9,888MStd Block Size: 8K
Shared Pool Size: 4,000M 4,000MLog Buffer: 67,784K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 15.1 0.0 0.00 0.00
DB CPU(s): 10.7 0.0 0.00 0.00
Redo size: 2,535,459.6 3,860.1  
Logical reads: 107,904.0 164.3  
Block changes: 16,407.4 25.0  
Physical reads: 63.6 0.1  
Physical writes: 207.1 0.3  
User calls: 7,840.4 11.9  
Parses: 4,300.4 6.6  
Hard parses: 1.0 0.0  
W/A MB processed: 22.3 0.0  
Logons: 1.4 0.0  
Executes: 21,150.6 32.2  
Rollbacks: 79.5 0.1  
Transactions: 656.9   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97Redo NoWait %: 100.00
Buffer Hit %: 99.94In-memory Sort %: 100.00
Library Hit %: 100.17Soft Parse %: 99.98
Execute to Parse %: 79.67Latch Hit %: 99.05
Parse CPU to Parse Elapsd %: 96.84% Non-Parse CPU: 97.65

Shared Pool Statistics

BeginEnd
Memory Usage %: 37.74 75.84
% SQL with executions>1: 40.34 92.61
% Memory for SQL w/exec>1: 46.80 90.02

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 85,356 71.02 
log file sync3,142,49838,4641232.00Commit
library cache: mutex X1,047,6541,49211.24Concurrency
SQL*Net break/reset to client801,59670610.59Application
latch: row cache objects134,33723620.20Concurrency

Host CPU (CPUs: 32 Cores: 16 Sockets: 4)

Load Average BeginLoad Average End%User%System%WIO%Idle
0.26 20.59 31.0 5.1 0.0 63.9
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
34.0 94.4 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 131,072.0 131,072.0
SGA use (MB): 14,336.0 14,336.0
PGA use (MB): 129.4 63,448.5
% Host Mem used for SGA+PGA: 11.04 59.34

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
DB CPU85,355.8071.02
sql execute elapsed time66,770.3655.56
PL/SQL execution elapsed time24,280.3420.20
parse time elapsed2,210.881.84
Java execution elapsed time1,412.181.17
repeated bind elapsed time184.240.15
connection management call elapsed time155.110.13
hard parse elapsed time19.260.02
sequence load elapsed time5.600.00
failed parse elapsed time4.640.00
PL/SQL compilation elapsed time1.750.00
hard parse (sharing criteria) elapsed time0.620.00
hard parse (bind mismatch) elapsed time0.060.00
DB time120,186.00 
background elapsed time6,556.84 
background cpu time1,757.53 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME288,055 
AVG_IDLE_TIME510,999 
AVG_SYS_TIME40,351 
AVG_USER_TIME247,443 
BUSY_TIME9,225,963 
IDLE_TIME16,360,330 
SYS_TIME1,299,700 
USER_TIME7,926,263 
LOAD021
OS_CPU_WAIT_TIME471,400 
VM_IN_BYTES6,406,144 
PHYSICAL_MEMORY_BYTES137,438,953,472 
NUM_CPUS32 
NUM_CPU_CORES16 
NUM_CPU_SOCKETS4 
TCP_RECEIVE_SIZE_DEFAULT49,152 
TCP_RECEIVE_SIZE_MAX1,048,576 
TCP_SEND_SIZE_DEFAULT49,152 
TCP_SEND_SIZE_MAX1,048,576 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
09-Sep 05:47:080.26     
09-Sep 07:00:3216.8518.8015.942.8681.200.00
09-Sep 08:00:0420.5957.3949.577.8342.610.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  85,356 71.02
Commit3,142,498038,4641232.00
Concurrency1,551,74501,78711.49
Application801,600070610.59
User I/O292,342031110.26
Network62,089,303029200.24
Other325,451981500.01
Configuration3,72516920.01
System I/O2,5760110.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
log file sync3,142,498038,464120.6032.00
library cache: mutex X1,047,65401,49210.201.24
SQL*Net break/reset to client801,596070610.150.59
latch: row cache objects134,337023620.030.20
SQL*Net message to client61,024,4610192011.650.16
db file scattered read48,277019140.010.16
SQL*Net more data from client672,94308200.130.07
db file sequential read83,43506210.020.05
Disk file operations I/O145,76002500.030.02
db file parallel read8,89002020.000.02
SQL*Net more data to client391,89901800.070.02
buffer busy waits201,40201700.040.01
cursor: pin S wait on X665016240.000.01
latch: cache buffers chains149,62801100.030.01
library cache load lock2,0520950.000.01
local write wait2,9910720.000.01
read by other session2,9850620.000.01
enq: TX - contention2,3830620.000.00
undo segment extension64293460.000.00
enq: HW - contention2,7910310.000.00
kksfbc child completion65783390.000.00
enq: US - contention5990240.000.00
enq: TX - index contention3,3640210.000.00
log file switch (private strand flush incomplete)6802290.000.00
asynch descriptor resize316,291100200.060.00
control file sequential read2,5760110.000.00
latch: In memory undo latch7,8990100.000.00
cursor: pin S3,1940100.000.00
row cache lock7350110.000.00
wait list latch free7601100.000.00
latch free9520110.000.00
library cache lock1400020.000.00
SGA: allocation forcing component growth600470.000.00
enq: FB - contention4060010.000.00
latch: session allocation2430010.000.00
buffer deadlock3,421100000.000.00
latch: enqueue hash chains1970010.000.00
cursor: mutex S482100000.000.00
latch: redo allocation2300000.000.00
latch: cache buffer handles1690010.000.00
latch: undo global data1420010.000.00
latch: shared pool1910000.000.00
enq: SQ - contention1110010.000.00
enq: TX - row lock contention400130.000.00
enq: TX - allocate ITL entry1120000.000.00
latch: object queue header operation1780000.000.00
L1 validation367070.000.00
latch: call allocation650000.000.00
latch: messages160000.000.00
direct path read40010.000.00
latch: cache buffers lru chain90000.000.00
SQL*Net message from client61,019,657027,074,03844411.65 
jobq slave wait16,1771008,0815000.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
log file parallel write1,475,90105,09030.2877.62
db file parallel write246,260021410.053.26
os thread startup302017570.000.26
control file sequential read12,92001010.000.16
latch free2,33901040.000.15
db file scattered read3,2220820.000.11
control file parallel write3,8640410.000.06
LGWR wait for redo copy56,2770300.010.04
reliable message9,2770200.000.03
db file sequential read2,3230110.000.02
SQL*Net more data from client10,7200100.000.02
latch: row cache objects2070150.000.01
rdbms ipc reply9,2570100.000.01
SQL*Net more data to client10,7200000.000.01
direct path read880040.000.01
Disk file operations I/O5,8790000.000.01
latch: redo allocation2600000.000.00
log file sync600100.000.00
asynch descriptor resize11,098100000.000.00
direct path write620010.000.00
SQL*Net message to client26,7260000.010.00
ADR block file read360010.000.00
latch: object queue header operation2170000.000.00
buffer busy waits3060000.000.00
wait list latch free100100.000.00
latch: redo writing130010.000.00
library cache: mutex X2740000.000.00
latch: checkpoint queue latch150000.000.00
log file sequential read40010.000.00
latch: messages100000.000.00
ADR block file write100000.000.00
latch: cache buffers lru chain220000.000.00
latch: call allocation50000.000.00
rdbms ipc message917,7984112,7771230.18 
Streams AQ: qmn slave idle wait2,407015,94966260.00 
DIAG idle wait14,71710014,71810000.00 
smon timer1,32207,97960350.00 
Space Manager: slave idle wait1,5961007,97749980.00 
Streams AQ: qmn coordinator idle wait2,628437,97530340.00 
pmon timer4,350597,70717720.00 
SQL*Net message from client37,451010230.01 
class slave wait360000.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read3686.1 5.68.3    
ADR block file write10100.0       
ADR file lock12100.0       
Disk file operations I/O152K99.9.1.0.0.0   
L1 validation333.3   66.7   
LGWR wait for redo copy56.5K99.7.2.0.0.0.0  
SGA: allocation forcing component growth6      100.0 
SQL*Net break/reset to client804.9K61.933.14.0.8.2.0.0.0
SQL*Net message to client61.3M100.0.0.0.0.0 .0 
SQL*Net more data from client686.7K95.64.2.1.1.0.0.0 
SQL*Net more data to client404K99.9.1.0.0    
asynch descriptor resize329.1K100.0.0      
buffer busy waits202.9K99.5.4.1.0.0.0  
buffer deadlock345999.5.3.1.1.1   
control file parallel write387395.32.3.4.5.7.5.3 
control file sequential read15.5K97.41.1.2.1.9.1.1 
cursor: mutex S48694.04.9.8 .2   
cursor: pin S324293.64.51.1.7.2   
cursor: pin S wait on X665    61.825.712.5 
db file parallel read890283.92.8.4.411.31.0.2 
db file parallel write247.2K89.09.0.5.4.5.4.2 
db file scattered read51.5K10.223.234.030.31.1.7.6 
db file sequential read86K97.9.8.2.2.4.3.2 
direct path read9266.33.33.39.813.03.31.1 
direct path write6293.54.8   1.6  
enq: FB - contention40790.27.12.5.2    
enq: HW - contention281374.51.921.02.4.2   
enq: SQ - contention11190.19.9      
enq: TX - allocate ITL entry11297.3 .9.9.9   
enq: TX - contention240310.718.168.52.7.0   
enq: TX - index contention339488.42.56.32.4.3.0.1 
enq: TX - row lock contention425.0    75.0  
enq: US - contention59929.519.720.219.49.02.0.2 
kksfbc child completion6423.4     76.6 
latch free330325.811.539.515.27.5.5.0 
latch: In memory undo latch793299.6.3.0.1    
latch: cache buffer handles16991.15.93.0     
latch: cache buffers chains150.8K99.5.4.1.0.0.0  
latch: cache buffers lru chain31100.0       
latch: call allocation70100.0       
latch: checkpoint queue latch1593.36.7      
latch: enqueue hash chains19982.913.12.02.0    
latch: messages2688.511.5      
latch: object queue header operation39798.51.0.3 .3   
latch: redo allocation49590.77.71.4 .2   
latch: redo writing1687.512.5      
latch: row cache objects134.6K56.913.616.09.43.9.1  
latch: session allocation24483.614.3.8 .8.4  
latch: shared pool19392.76.7.5     
latch: undo global data14286.67.04.22.1    
library cache load lock205241.714.514.815.77.84.01.5 
library cache lock14075.77.110.04.3.7 2.1 
library cache pin2100.0       
library cache: mutex X1054.7K52.020.820.45.41.2.2.0 
local write wait300029.227.333.87.11.6.8.2 
log file parallel write1479.8K39.012.723.618.43.61.61.1 
log file sequential read450.025.025.0     
log file single write4100.0       
log file switch (private strand flush incomplete)68  2.98.810.326.551.5 
log file sync3149.7K9.87.715.426.421.011.28.4 
os thread startup302      100.0 
rdbms ipc reply929099.7.2  .0   
read by other session298559.35.614.618.52.0.1.1 
reliable message931096.92.9.0.0.1.1.0 
row cache lock73674.013.96.14.51.4.1  
undo segment extension64854.2 .2 37.27.9.6 
wait list latch free71    100.0   
DIAG idle wait14.7K      100.0 
SQL*Net message from client61.3M2.937.633.59.83.82.97.51.9
Space Manager: slave idle wait1600       100.0
Streams AQ: qmn coordinator idle wait26316.28.130.311.9.0  43.4
Streams AQ: qmn slave idle wait23814.8 .2.3.1  94.7
class slave wait36100.0       
jobq slave wait16.2K .0.0  .099.9 
pmon timer435538.6.6.4.4.4.3.359.1
rdbms ipc message919.1K55.713.014.48.12.71.21.53.4
smon timer13311.7.4.2.51.31.029.565.5

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
SGA: allocation forcing component growth6 83.316.7     
SQL*Net break/reset to client270100.0.0.0.0.0.0.0.0
SQL*Net message to client1100.0  .0    
SQL*Net more data from client17100.0.0.0.0.0   
control file parallel write1199.7.2.1.0    
control file sequential read1599.9.1.0.0    
cursor: pin S wait on X8387.58.02.11.5.8.2  
db file parallel read2099.8.2.0.0    
db file parallel write46999.8.1.0.0    
db file scattered read30299.4.3.2.1.0   
db file sequential read13999.8.1.0.0    
direct path read198.91.1      
enq: TX - index contention299.9.1      
enq: US - contention199.8.2      
kksfbc child completion4923.476.6      
latch free1100.0.0      
library cache load lock3098.5.7.7.0    
library cache lock397.92.1      
library cache: mutex X176100.0.0.0     
local write wait799.8.2.0.0    
log file parallel write15.7K98.9.8.2.0.0   
log file switch (private strand flush incomplete)3548.551.5      
log file sync265.1K91.66.21.8.4.0   
os thread startup302 70.229.8     
read by other session299.9.0.0     
reliable message1100.0.0      
undo segment extension499.4.2.2.2.2   

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
SQL*Net break/reset to client10100.0.0      

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
VIS119,35484,768478856,488
SYS$USERS25341180
SYS$BACKGROUND0028380

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
VIS 291397311000062046365292
SYS$USERS 926047000120
SYS$BACKGROUND 11594101100180000

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
8,219.4435,6550.236.8499.420.14f7g96xjhudpzt hxc.selfservice.timecard.server.TimecardAM BEGIN HXC_TIMECARD.CREATE_TIME...
8,175.44648,1070.016.8099.400.0467mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
7,104.2723,4300.305.9199.470.061kjhvys1sd1sg ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
4,521.7959,8650.083.7699.470.02aaw4na3kmdfkq JDBC Thin Client DECLARE l_result varchar2(1); ...
2,772.4359,8580.052.3199.930.001wr32ytknh1u9 JDBC Thin Client SELECT P.PID, S.PROCESS, P.SER...
2,720.09472,0500.012.2699.840.031rd31t40r4fu5 JDBC Thin Client BEGIN fnd_global.bless_next_in...
2,163.85153,6650.011.80100.810.00chkkj84y3mv9s ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
1,951.26864,4800.001.6299.640.007ujfmgb1j83a3 JDBC Thin Client BEGIN FND_AOLJ_UTIL.SET_NLS_CO...
1,875.7063,2230.031.5699.210.04bqf04xkudk4zt JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.crea...
1,824.01117,2980.021.52100.750.009pammshaxxyx0 ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
1,806.9260,0180.031.5099.340.09dt2vdh82d4hrb JDBC Thin Client BEGIN :1 := FND_WEB_SEC.valida...
1,761.38213,1200.011.47100.020.00gmvh826nm09vj ap.oie.server.WebExpensesAM SELECT * FROM (SELECT AP_WEB_D...
1,706.4923,4330.071.4299.850.01dcrschgcxcbkn ap.oie.server.WebExpensesAM begin AP_WEB_EXPENSE_WF.APVALI...
1,521.3035,6350.041.2799.640.03g22cn4nvvn83b hxc.selfservice.timecard.server.TimecardAM begin HXC_APPROVAL_WF_PKG.proc...
1,414.0610,240,8290.001.1899.740.00dawf7hvg1ym94 JDBC Thin Client select V.PROFILE_OPTION_VALUE ...
1,250.08902,7970.001.0494.700.08f1v2hmt6qbkyc fnd.sso.login.server.MainLoginPageAM begin fnd_session_management.P...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
8,171.9035,6550.239.578,219.4499.420.14f7g96xjhudpzt hxc.selfservice.timecard.server.TimecardAM BEGIN HXC_TIMECARD.CREATE_TIME...
8,126.76648,1070.019.528,175.4499.400.0467mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
7,066.8223,4300.308.287,104.2799.470.061kjhvys1sd1sg ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
4,497.8859,8650.085.274,521.7999.470.02aaw4na3kmdfkq JDBC Thin Client DECLARE l_result varchar2(1); ...
2,770.3959,8580.053.252,772.4399.930.001wr32ytknh1u9 JDBC Thin Client SELECT P.PID, S.PROCESS, P.SER...
2,715.69472,0500.013.182,720.0999.840.031rd31t40r4fu5 JDBC Thin Client BEGIN fnd_global.bless_next_in...
2,181.35153,6650.012.562,163.85100.810.00chkkj84y3mv9s ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
1,944.29864,4800.002.281,951.2699.640.007ujfmgb1j83a3 JDBC Thin Client BEGIN FND_AOLJ_UTIL.SET_NLS_CO...
1,860.8763,2230.032.181,875.7099.210.04bqf04xkudk4zt JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.crea...
1,837.66117,2980.022.151,824.01100.750.009pammshaxxyx0 ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
1,794.9560,0180.032.101,806.9299.340.09dt2vdh82d4hrb JDBC Thin Client BEGIN :1 := FND_WEB_SEC.valida...
1,761.81213,1200.012.061,761.38100.020.00gmvh826nm09vj ap.oie.server.WebExpensesAM SELECT * FROM (SELECT AP_WEB_D...
1,704.0123,4330.072.001,706.4999.850.01dcrschgcxcbkn ap.oie.server.WebExpensesAM begin AP_WEB_EXPENSE_WF.APVALI...
1,515.8935,6350.041.781,521.3099.640.03g22cn4nvvn83b hxc.selfservice.timecard.server.TimecardAM begin HXC_APPROVAL_WF_PKG.proc...
1,410.4110,240,8290.001.651,414.0699.740.00dawf7hvg1ym94 JDBC Thin Client select V.PROFILE_OPTION_VALUE ...
1,183.82902,7970.001.391,250.0894.700.08f1v2hmt6qbkyc fnd.sso.login.server.MainLoginPageAM begin fnd_session_management.P...
1,095.5871,6610.021.281,097.2799.850.0099p2syxffrkt0 hxc.selfservice.timecard.server.TimecardAM BEGIN hxc_timecard_utilities.g...
917.3017,162,1020.001.07914.01100.360.000wmwsjy9kd92f ICM@bur93-223 (TNS V1-V3) SELECT PROFILE_OPTION_ID, APPL...
909.3417,8190.051.07911.4799.770.02bnk32fdswwqrz hxc.selfservice.timecard.server.TimecardAM begin HXC_APPROVAL_WF_PKG.crea...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
17.2359,3840.005.37137.1489.0612.56bqzutt5g7maz0 JDBC Thin Client select distinct furg.responsib...
11.4535,6550.003.578,219.4499.420.14f7g96xjhudpzt hxc.selfservice.timecard.server.TimecardAM BEGIN HXC_TIMECARD.CREATE_TIME...
8.8623,9640.002.7639.5783.2622.39adaqz510gq8qf ap.oie.server.HomePageAM SELECT * FROM (SELECT AI.DESCR...
8.821,012,4680.002.7585.4393.9610.3291hakq9n36htp hxc.selfservice.timecard.server.TimecardAM SELECT TEXT_VALUE FROM WF_ITEM...
4.8847,7930.001.52637.0999.040.772sdhb2dg1chcv ap.oie.server.WebExpensesAM BEGIN AP_WEB_OA_MAINFLOW_PKG.G...
4.1523,4300.001.297,104.2799.470.061kjhvys1sd1sg ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
3.22648,1070.001.008,175.4499.400.0467mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
2.3082,4770.000.72642.8397.180.363vy5h9xkfv1s5 hxc.selfservice.timecard.server.TimecardAM INSERT INTO WF_ITEM_ATTRIBUTE_...
1.5660,0180.000.491,806.9299.340.09dt2vdh82d4hrb JDBC Thin Client BEGIN :1 := FND_WEB_SEC.valida...
1.2270,7670.000.3842.88115.962.84cm5vu20fhtnq1   select /*+ connect_by_filterin...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
160,553,92223,4306,852.4918.667,104.2799.470.061kjhvys1sd1sg ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
143,924,57935,6554,036.5916.728,219.4499.420.14f7g96xjhudpzt hxc.selfservice.timecard.server.TimecardAM BEGIN HXC_TIMECARD.CREATE_TIME...
88,345,340648,107136.3110.278,175.4499.400.0467mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
65,544,90582,477794.717.62642.8397.180.363vy5h9xkfv1s5 hxc.selfservice.timecard.server.TimecardAM INSERT INTO WF_ITEM_ATTRIBUTE_...
65,418,47610,240,8296.397.601,414.0699.740.00dawf7hvg1ym94 JDBC Thin Client select V.PROFILE_OPTION_VALUE ...
51,304,08417,162,1022.995.96914.01100.360.000wmwsjy9kd92f ICM@bur93-223 (TNS V1-V3) SELECT PROFILE_OPTION_ID, APPL...
45,675,29035,6351,281.755.311,521.3099.640.03g22cn4nvvn83b hxc.selfservice.timecard.server.TimecardAM begin HXC_APPROVAL_WF_PKG.proc...
43,847,51713,635,2903.225.10572.8599.880.017qs7fx89194u1 ICM@bur93-223 (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
26,610,68123,4331,135.613.091,706.4999.850.01dcrschgcxcbkn ap.oie.server.WebExpensesAM begin AP_WEB_EXPENSE_WF.APVALI...
24,026,959153,665156.362.792,163.85100.810.00chkkj84y3mv9s ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
21,050,419472,05044.592.452,720.0999.840.031rd31t40r4fu5 JDBC Thin Client BEGIN fnd_global.bless_next_in...
17,339,979117,298147.832.011,824.01100.750.009pammshaxxyx0 ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
15,735,70759,865262.851.834,521.7999.470.02aaw4na3kmdfkq JDBC Thin Client DECLARE l_result varchar2(1); ...
15,566,38817,819873.581.81911.4799.770.02bnk32fdswwqrz hxc.selfservice.timecard.server.TimecardAM begin HXC_APPROVAL_WF_PKG.crea...
14,776,40663,223233.721.721,875.7099.210.04bqf04xkudk4zt JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.crea...
14,602,78817,836818.731.70841.6099.940.015025fda07dapq hxc.selfservice.timecard.server.TimecardAM BEGIN PA_OTC_API.VALIDATE_OTC_...
13,512,90171,661188.571.571,097.2799.850.0099p2syxffrkt0 hxc.selfservice.timecard.server.TimecardAM BEGIN hxc_timecard_utilities.g...
12,695,42217,817712.551.48562.5899.720.00cygumhvsq65t2 hxc.selfservice.timecard.server.TimecardAM begin HXC_APPROVAL_WF_PKG.is_a...
12,069,75247,793252.541.40637.0999.040.772sdhb2dg1chcv ap.oie.server.WebExpensesAM BEGIN AP_WEB_OA_MAINFLOW_PKG.G...
12,055,309902,79713.351.401,250.0894.700.08f1v2hmt6qbkyc fnd.sso.login.server.MainLoginPageAM begin fnd_session_management.P...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
33,42759,3840.566.59137.1489.0612.56bqzutt5g7maz0 JDBC Thin Client select distinct furg.responsib...
8,83647,7930.181.74637.0999.040.772sdhb2dg1chcv ap.oie.server.WebExpensesAM BEGIN AP_WEB_OA_MAINFLOW_PKG.G...
7,97023,9640.331.5739.5783.2622.39adaqz510gq8qf ap.oie.server.HomePageAM SELECT * FROM (SELECT AI.DESCR...
7,9181,012,4680.011.5685.4393.9610.3291hakq9n36htp hxc.selfservice.timecard.server.TimecardAM SELECT TEXT_VALUE FROM WF_ITEM...
5,37735,6550.151.068,219.4499.420.14f7g96xjhudpzt hxc.selfservice.timecard.server.TimecardAM BEGIN HXC_TIMECARD.CREATE_TIME...
3,71923,4300.160.737,104.2799.470.061kjhvys1sd1sg ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
2,73760,0180.050.541,806.9299.340.09dt2vdh82d4hrb JDBC Thin Client BEGIN :1 := FND_WEB_SEC.valida...
2,2876,0900.380.4511.2591.279.35bjdg2u92k6m94 per.selfservice.common.server.CommonAM SELECT * FROM (select /*+ inde...
1,9066083.130.380.8724.1288.42cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
1,6161,9600.820.321.0342.7065.513ktacv9r56b51   select owner#, name, namespace...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
7,9677,96723,9640.330.004.89adaqz510gq8qf ap.oie.server.HomePageAM SELECT * FROM (SELECT AI.DESCR...
3,3983,39835,6550.100.002.08f7g96xjhudpzt hxc.selfservice.timecard.server.TimecardAM BEGIN HXC_TIMECARD.CREATE_TIME...
3,0023,00247,7930.060.001.842sdhb2dg1chcv ap.oie.server.WebExpensesAM BEGIN AP_WEB_OA_MAINFLOW_PKG.G...
2,6312,63121,315.500.001.61gjm43un5cy843   SELECT SUM(USED), SUM(TOTAL) F...
1,7531,7536082.880.001.08cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
1,5161,51623,4300.060.000.931kjhvys1sd1sg ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A...
1,3471,34760,0180.020.000.83dt2vdh82d4hrb JDBC Thin Client BEGIN :1 := FND_WEB_SEC.valida...
58158159,3840.010.000.36bqzutt5g7maz0 JDBC Thin Client select distinct furg.responsib...
537537648,1070.000.000.3367mmmbx5hb3p0 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V...
5125126080.840.000.31ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
17,162,10216,918,6260.99914.01100.360.000wmwsjy9kd92f ICM@bur93-223 (TNS V1-V3) SELECT PROFILE_OPTION_ID, APPL...
13,635,2902,881,9420.21572.8599.880.017qs7fx89194u1 ICM@bur93-223 (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
10,240,8293,917,4050.381,414.0699.740.00dawf7hvg1ym94 JDBC Thin Client select V.PROFILE_OPTION_VALUE ...
1,757,5031,756,6941.00721.1499.390.0314knmm0z37a0q fnd.sso.login.server.MainLoginPageAM declare val varchar2(256);begi...
1,658,3201,658,8311.0072.5299.960.01ba54gdcfdgutp hxc.selfservice.timecard.server.TimecardAM SELECT LAST_UPDATE_DATE FROM H...
1,012,468989,4880.9885.4393.9610.3291hakq9n36htp hxc.selfservice.timecard.server.TimecardAM SELECT TEXT_VALUE FROM WF_ITEM...
994,012878,1660.88242.0899.490.00fw6u054ccjgpv ap.oie.server.WebExpensesAM SELECT * FROM (SELECT erp.PARA...
944,05100.00113.8199.660.0040k4g30f23x24 ap.oie.server.WebExpensesAM SELECT * FROM (SELECT PolicyVi...
943,72000.0093.70100.860.0020wnd5y5xjzpk ap.oie.server.WebExpensesAM SELECT ExpAttendeeEO.REPORT_LI...
943,68800.0091.26100.680.00cmxq1hvy8crz7 ap.oie.server.WebExpensesAM SELECT ExpAttendeeEO.REPORT_LI...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
2,482,72513,635,2907.247qs7fx89194u1 ICM@bur93-223 (TNS V1-V3) SELECT PROFILE_OPTION_VALUE FR...
895,81117,162,1022.610wmwsjy9kd92f ICM@bur93-223 (TNS V1-V3) SELECT PROFILE_OPTION_ID, APPL...
402,382401,2971.1745bqm8u3kj5hv ap.oie.server.HomePageAM BEGIN FUN_RULE_PUB.SET_INSTANC...
401,451400,6321.17a6u3yjca29nqc sqlplus@bur834-66 (TNS V1-V3) declare m_stmt varchar2(512); ...
400,194401,4291.173972rvxu3knn3 sqlplus@bur834-66 (TNS V1-V3) delete from sdo_geor_ddl__tabl...
236,597871,9150.69g3g74r6wnrv0h ap.oie.server.WebExpensesAM SELECT * FROM (SELECT parent_t...
191,627191,6380.56f2sn773bcyrj6 ap.oie.server.WebExpensesAM /* $Header: ValueSet.java 120....
164,703684,0780.482060dmj8nhqdb hxc.selfservice.timecard.server.TimecardAM SELECT EMPLOYEE_ID FROM FND_US...
164,468164,4770.48g2qs4xk48vcwy ap.oie.server.WebExpensesAM select to_char(CODE_COMBINATIO...
164,451164,4550.481v818hwxjxy58 ap.oie.server.WebExpensesAM select FND_FLEX_VALUES_VL.FLEX...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0wmwsjy9kd92fSELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE
14knmm0z37a0qdeclare val varchar2(256);begin :1 := fnd_session_management.GETSESSIONATTRIBUTEVALUE(:2, :3);end;
1kjhvys1sd1sgBEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.OASubmitWorkflow(p_report_header_id => :1, p_preparer_id => :2, p_employee_id => :3, p_invoice_number => :4, p_reimb_curr => :5, p_cost_center => :6, p_purpose => :7, p_approver_id => :8, p_week_end_date => :9, p_workflow_appr_flag => :10, p_msg_count => :11);END;
1rd31t40r4fu5BEGIN fnd_global.bless_next_init('FND_PERMIT_0006'); FND_GLOBAL.APPS_INITIALIZE( user_id=>:1 , resp_id=>:2 , resp_appl_id=>:3 , security_group_id=>:4 , server_id=>:5);END;
1v818hwxjxy58select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND ( ((1=1) AND /* GL_COA_BS_TAG */ (GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y') ) )) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3
1wr32ytknh1u9SELECT P.PID, S.PROCESS, P.SERIAL#, P.SPID FROM V$PROCESS P, V$SESSION S WHERE S.AUDSID = USERENV('SESSIONID') AND S.PADDR = P.ADDR
2060dmj8nhqdbSELECT EMPLOYEE_ID FROM FND_USER WHERE USER_ID = :B1
20wnd5y5xjzpkSELECT ExpAttendeeEO.REPORT_LINE_ID, ExpAttendeeEO.EMPLOYEE_FLAG, ExpAttendeeEO.EMPLOYEE_ID, ExpAttendeeEO.ATTENDEE_TYPE, ExpAttendeeEO.NAME, ExpAttendeeEO.TITLE, ExpAttendeeEO.EMPLOYER, ExpAttendeeEO.EMPLOYER_ADDRESS, ExpAttendeeEO.ORG_ID, ExpAttendeeEO.LAST_UPDATE_DATE, ExpAttendeeEO.LAST_UPDATED_BY, ExpAttendeeEO.CREATION_DATE, ExpAttendeeEO.CREATED_BY, ExpAttendeeEO.LAST_UPDATE_LOGIN, ExpAttendeeEO.ATTENDEE_LINE_ID, ExpAttendeeEO.TAX_ID FROM OIE_ATTENDEES_ALL ExpAttendeeEO WHERE :1 = ExpAttendeeEO.REPORT_LINE_ID AND EMPLOYEE_FLAG = 'N'
2sdhb2dg1chcvBEGIN AP_WEB_OA_MAINFLOW_PKG.GetEmployeeInfo(p_employee_id => :1, p_employee_name => :2, p_employee_num => :3, p_cost_center => :4, p_is_project_enabled => :5, p_default_reimb_currency_code => :6, p_is_cc_enabled => :7, p_max_num_segments => :8, p_userId => :9);END;
3972rvxu3knn3delete from sdo_geor_ddl__table$$
3ktacv9r56b51select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3vy5h9xkfv1s5INSERT INTO WF_ITEM_ATTRIBUTE_VALUES ( ITEM_TYPE, ITEM_KEY, NAME, TEXT_VALUE, NUMBER_VALUE, DATE_VALUE ) SELECT :B1 , :B2 , WIA.NAME, WIA.TEXT_DEFAULT, WIA.NUMBER_DEFAULT, WIA.DATE_DEFAULT FROM WF_ITEM_ATTRIBUTES WIA WHERE WIA.ITEM_TYPE = :B1
40k4g30f23x24SELECT * FROM (SELECT PolicyViolationEO.REPORT_HEADER_ID, PolicyViolationEO.DISTRIBUTION_LINE_NUMBER, PolicyViolationEO.VIOLATION_NUMBER, PolicyViolationEO.VIOLATION_TYPE, PolicyViolationEO.VIOLATION_DATE, PolicyViolationEO.ALLOWABLE_AMOUNT, PolicyViolationEO.ORG_ID, PolicyViolationEO.CREATION_DATE, PolicyViolationEO.CREATED_BY, PolicyViolationEO.LAST_UPDATE_DATE, PolicyViolationEO.LAST_UPDATED_BY, PolicyViolationEO.LAST_UPDATE_LOGIN, PolicyViolationEO.FUNC_CURRENCY_ALLOWABLE_AMT, PolicyViolationEO.EXCEEDED_AMOUNT FROM AP_POL_VIOLATIONS_ALL PolicyViolationEO) QRSLT WHERE REPORT_HEADER_ID = :1 AND DISTRIBUTION_LINE_NUMBER = :2
45bqm8u3kj5hvBEGIN FUN_RULE_PUB.SET_INSTANCE_CONTEXT(P_RULE_OBJECT_NAME => :1, P_APPLICATION_SHORT_NAME => :2, P_INSTANCE_LABEL => :3, P_ORG_ID => :4 );END;
5025fda07dapqBEGIN PA_OTC_API.VALIDATE_OTC_DATA (p_operation => :1); END;
67mmmbx5hb3p0BEGIN :1 := FND_AOLJ_UTIL.is_Valid_ICX(:2, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, true);:19 := fnd_session_management.g_enc_key;:20 := fnd_session_management.g_mac_key;:21 := fnd_session_management.g_proxy_user_id; :22 := fnd_session_management.g_mode_code; END;
7qs7fx89194u1SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL
7ujfmgb1j83a3BEGIN FND_AOLJ_UTIL.SET_NLS_CONTEXT( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13);END;
91hakq9n36htpSELECT TEXT_VALUE FROM WF_ITEM_ATTRIBUTE_VALUES WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
99p2syxffrkt0BEGIN hxc_timecard_utilities.get_time_periods (p_resource_id => :1 , p_resource_type => :2 , p_rec_period_start_date => :3 , p_period_type => :4 , p_duration_in_days => :5 , p_current_date => :6 , p_num_past_entries => :7 , p_num_future_entries => :8 , p_num_past_days => :9 , p_num_future_days => :10 , p_hire_date => :11 , p_show_existing_timecard => :12 , p_first_empty_period => :13 , p_periods => :14 ); END;
9pammshaxxyx0 BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.validateReceiptLine(employee_id => :1, template_id => :2, summary_start_date => :3, reimbursement_currency_code => :4, reimbursement_currency_name => :5, multi_currency_flag => :6, override_approver_name => :7, number_max_flexfield => :8, start_date => :9, end_date => :10, days => :11, daily_amount => :12, receipt_amount => :13, rate => :14, amount => :15, parameter_id => :16, currency_code => :17, merchant => :18, merchantDoc => :19, taxReference => :20, taxRegNumber => :21, taxPayerId => :22, supplyCountry => :23, itemizeId => :24, cCardTrxnId => :25, group_value => :26, justification => :27, receipt_missing_flag => :28, validation_required => :29, taxOverrideFlag => :30, project_number => :31, task_number => :32, project_name => :33, task_name => :34, attribute1 => :35, attribute2 => :36, attribute3 => :37, attribute4 => :38, attribute5 => :39, attribute6 => :40, attribute7 => :41, attribute8 => :42, attribute9 => :43, attribute10 => :44, attribute11 => :45, attribute12 => :46, attribute13 => :47, attribute14 => :48, attribute15 => :49, p_IsSessionTaxEnabled => :50, p_IsSessionProjectEnabled => :51, p_calculate_amt_index => :52, p_calculated_receipt_amount => :53, p_return_status => :54, p_msg_count => :5 5, p_msg_data => :56, p_userId => :57, award_number => :58, p_cost_center => :59, p_template_name => :60 , p_purpose => :61 , p_override_approver_id => :62, p_last_update_date => :63 , receipt_cost_center => :64 , p_transaction_currency_type => :65, p_inverse_rate_flag => :66, p_report_header_id => :67, p_category_code => :68, p_nFreeBreakfasts1 => :69, p_nFreeBreakfasts2 => :70, p_nFreeBreakfasts3 => :71, p_nFreeLunches1 => :72, p_nFreeLunches2 => :73, p_nFreeLunches3 => :74, p_nFreeDinners1 => :75, p_nFreeDinners2 => :76, p_nFreeDinners3 => :77, p_nFreeAccommodations1 => :78, p_nFreeAccommodations2 => :79, p_nFreeAccommodations3 => :80, p_location => :81, p_dailyDistance => :82, p_tripDistance => :83, p_mileageRate => :84, p_vehicleCategory => :85, p_vehicleType => :86, p_fuelType => :87, p_numberPassengers => :88, p_default_currency_code => :89, p_default_exchange_rate_type => :90, p_header_attribute_category => :91, p_header_attribute1 => :92, p_header_attribute2 => :93, p_header_attribute3 => :94, p_header_attribute4 => :95, p_header_attribute5 => :96, p_header_attribute6 => :97, p_header_attribute7 => :98, p_header_attribute8 => :99, p_header_attribute9 => :100, p_header_attribute10 => :101, p_header_attribute11 => :102, p_header_attribute12 => :103, p_header_attribute13 => :104, p_header_attribute14 => :105, p_he ader_attribute15 => :106, p_receipt_index => :107, p_passenger_rate_used => :108, p_license_plate_number => :109, p_destination_from => :110, p_destination_to => :111, p_distance_unit_code => :112, p_addon_rates => :113, p_report_line_id => :114, p_itemization_parent_id => :115, p_daily_breakup_id => :116, p_start_date => :117, p_end_date => :118, p_amount => :119, p_number_of_meals => :120, p_meals_amount => :121, p_breakfast_flag => :122, p_lunch_flag => :123, p_dinner_flag => :124, p_accommodation_amount => :125, p_accommodation_flag => :126, p_hotel_name => :127, p_night_rate_type => :128, p_night_rate_amount => :129, p_pdm_rate => :130, p_rate_type_code => :131, p_pdm_breakup_dest_id => :132, p_pdm_destination_id => :133, p_dest_start_date => :134, p_dest_end_date => :135, p_location_id => :136, p_cust_meals_amount => :137, p_cust_accommodation_amount => :138, p_cust_night_rate_amount => :139, p_cust_pdm_rate => :140, p_vat_code => :141, p_emp_attendee_count => :142, p_nonemp_attendee_count => :143);END;
a6u3yjca29nqcdeclare m_stmt varchar2(512); begin m_stmt:='delete from sdo_geor_ddl__table$$'; EXECUTE IMMEDIATE m_stmt; EXCEPTION WHEN OTHERS THEN NULL; end;
aaw4na3kmdfkqDECLARE l_result varchar2(1); BEGIN l_result := FND_AOLJ_UTIL.convertGuestSession(:1, :2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); :21 := l_result;END;
adaqz510gq8qf SELECT * FROM (SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME F ULL_NAME , DECODE(AI.CANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID FROM AK_WEB_USER_SEC_ATTR_VALUES A, PO_VENDORS PV, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO(+) AND AI.INVOICE_TYPE_LOOKUP_CODE||'' = 'EXPENSE REPORT' AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND PV.EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :1 AND P.PERSON_ID = PV.EMPLOYEE_ID AND PV.VENDOR_ID = AI.VENDOR_ID AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_A MOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL) UNION SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)), FND_CURRENCY_CACHE.GET_FORMAT_MAS K (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAME , DECODE(AI.CANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID FROM AK_WEB_USER_SEC_ATTR_VALUES A, PO_VENDORS PV, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO(+) AND AI.INVOICE_TYPE_LOOKUP_CODE||'' in ('STANDARD', 'MIXED', 'PAYMENT REQUEST') AND AI.SOURCE IN ('SelfService', 'Both Pay', 'CREDIT CARD') AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AI.PAID_ ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :2 AND P.PERSON_ID = AI.PAID_ON_BEHALF_EMPLOYEE_ID AND PV.VENDOR_ID = AI.VENDOR_ID AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL) UNION ALL SELECT AERH.DESCRIPTION PURPOSE, AERH.DEFAULT_CURRENCY_CODE CURRENCY_CODE, AERH.WEEK_END_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AERH.INVOICE_NUM REPORT_NUMBER, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) ||' '|| AERH.DEFAULT_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) REPORT_TOTAL, PER_EMPLOYEE.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, PER_EMPLOYEE.FULL_NAME FULL_NAME, NVL(AERH.expense_status_code, AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, 'Y', 'N')) STATUS_CODE, AERH.source SOURCE, NVL (PER_APPROVER.full_name, AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AE RH.report_header_id, AERH.expense_status_code)) CURRENT_APPROVER, ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, 0 VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, DECODE(AERH.expense_current_approver_id, -99999, 'AMEMultipleApprovers', decode(PER_APPROVER.full_name, null, 'CurrentApproverName', 'AMESingleApprover')) CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), -1 INVOICE_ID FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X PER_EMPLOYEE, PER_PEOPLE_X PER_APPROVER WHERE AERH.VOUCHNO +0 =0 AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AERH.EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :3 AND PER_EMPLOYEE.PERSON_ID = AERH.EMPLOYEE_ID AND (AERH.Source <> 'NonValidatedWebExpense' OR AERH.Workflow_approved_flag IS NULL) AND AERH.expense_current_approver_id = PER_APPROVER.person_id (+) AND AERH.SOURCE <> 'Both Pay' UNION SELECT AERH.DESCRIPTION PURPOSE, AERH.DEFAULT_CURRENCY_CODE CURRENCY_CODE, AERH.WEEK_END_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AERH.INVOICE_NUM REPORT_NUMBER, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_C URRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) ||' '|| AERH.DEFAULT_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(nvl(AERH.AMT_DUE_CCARD_COMPANY+AERH.AMT_DUE_EMPLOYEE+nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), AERH.TOTAL), FND_CURRENCY_CACHE.GET_FORMAT_MASK (AERH.DEFAULT_CURRENCY_CODE, 30)) REPORT_TOTAL, PER_EMPLOYEE.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, PER_EMPLOYEE.FULL_NAME FULL_NAME, NVL(AERH.expense_status_code, AP_WEB_OA_ACTIVE_PKG.GetReportStatusCode(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, 'Y', 'N')) STATUS_CODE, AERH.source SOURCE, NVL (PER_APPROVER.full_name, AP_WEB_OA_ACTIVE_PKG.GetCurrentApprover(AERH.Source, AERH.Workflow_approved_flag, AERH.report_header_id, AERH.expense_status_code)) CURRENT_APPROVER, ROUND(NVL(sysdate - AERH.EXPENSE_LAST_STATUS_DATE, sysdate - AERH.LAST_UPDATE_DATE)) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, 0 VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, DECODE(AERH.expense_current_approver_id, -99999, 'AMEMultipleApprovers', decode(PER_APPROVER.full_name, null, 'CurrentApproverName', 'AMESingleApprover')) CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), -1 INVOICE_ID FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPL E_X PER_EMPLOYEE, PER_PEOPLE_X PER_APPROVER WHERE AERH.VOUCHNO +0=0 AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AERH.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :4 AND PER_EMPLOYEE.PERSON_ID = PAID_ON_BEHALF_EMPLOYEE_ID AND AERH.EMPLOYEE_ID IS NULL AND (AERH.Source <> 'NonValidatedWebExpense' OR AERH.Workflow_approved_flag IS NULL) AND AERH.expense_current_approver_id = PER_APPROVER.person_id (+) AND AERH.SOURCE <> 'Both Pay' UNION ALL /* This select is for invoice imported reports by contingent workers */ SELECT AI.DESCRIPTION PURPOSE, AI.INVOICE_CURRENCY_CODE CURRENCY_CODE, AI.INVOICE_DATE REPORT_DATE, AERH.REPORT_SUBMITTED_DATE REPORT_SUBMITTED_DATE, AI.INVOICE_NUM REPORT_NUMBER, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) ||' '|| AI.INVOICE_CURRENCY_CODE REPORT_TOTAL_CURRENCY, TO_CHAR(decode(nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.A MT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0), 0, decode(AI.CANCELLED_DATE, null, APS.GROSS_AMOUNT, AERH.TOTAL), nvl(AI.AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_CCARD_COMPANY) + nvl(AI.AMT_DUE_EMPLOYEE, AERH.AMT_DUE_EMPLOYEE) + nvl(AERH.MAXIMUM_AMOUNT_TO_APPLY, 0)) , FND_CURRENCY_CACHE.GET_FORMAT_MASK (AI.INVOICE_CURRENCY_CODE, 30)) REPORT_TOTAL, P.PERSON_ID EMPLOYEE_ID, AERH.REPORT_HEADER_ID REPORT_HEADER_ID, P.FULL_NAME FULL_NAME , DECODE(AI.CANCELLED_DATE, null, nvl(aerh.expense_status_code, DECODE(APS.GROSS_AMOUNT , 0, 'PAID', decode(AI.Payment_status_flag, 'Y', 'PAID', 'N', 'INVOICED', 'P', 'PARPAID', NULL))), 'CANCELLED') STATUS_CODE, AERH.source SOURCE, NULL CURRENT_APPROVER, ROUND(sysdate - AI.LAST_UPDATE_DATE) DAYS_SINCE_ACTIVITY, AERH.RECEIPTS_STATUS RECEIPTS_STATUS_CODE, AERH.HOLDING_REPORT_HEADER_ID, AI.VENDOR_ID VENDOR_ID, AERH.AMT_DUE_CCARD_COMPANY AMT_DUE_CCARD_COMPANY, AERH.AMT_DUE_EMPLOYEE AMT_DUE_EMPLOYEE, 'CurrentApproverName' CURRENT_APPROVER_SWITCHER, to_char(AERH.LAST_UPDATE_DATE, 'DD-MON-RRRR HH:MI:SS'), AI.INVOICE_ID INVOICE_ID FROM AK_WEB_USER_SEC_ATTR_VALUES A, AP_INVOICES AI, AP_EXPENSE_REPORT_HEADERS AERH, PER_PEOPLE_X P, AP_PAYMENT_SCHEDULES APS WHERE AI.INVOICE_ID= APS.INVOICE_ID AND AI.INVOICE_ID = AERH.VOUCHNO(+) AND AI.INVOICE_TYPE_LOOKUP_CODE||'' = 'EXPENSE REPORT' AND A.ATTRIBUTE_CODE = 'ICX_HR_PERSON_ID' AND AI.PAID_ON_BEHALF_EMPLOYEE_ID = A.NUMBER_VALUE AND A.WEB_USER_ID = :5 AND P.PERSON_ID = AI.PAID_ON_BEHALF_EMPLOYEE_ID AND AP_WEB_DB_HR_INT_PKG.IsPersonCwk(AI.PAID_ON_BEHALF_EMPLOYEE_ID)='Y' AND DECODE (AI.PAYMENT_STATUS_FLAG, 'Y', sysdate - AI.LAST_UPDATE_DATE, decode(APS.GROSS_AMOUNT , 0 , sysdate - AI.LAST_UPDATE_DATE, 0) ) <= 30 AND (AERH.SOURCE <> 'Both Pay' OR AERH.REPORT_HEADER_ID IS NULL)) QRSLT ORDER BY REPORT_SUBMITTED_DATE DESC
ba54gdcfdgutpSELECT LAST_UPDATE_DATE FROM HXC_PREF_HIERARCHIES WHERE PREF_HIERARCHY_ID = :B1
bjdg2u92k6m94SELECT * FROM (select /*+ index(psv.pai PAY_ACTION_INFORMATION_N2)*/ gross_earnings, pretax_deductions, taxes, after_tax_deductions, net_pay, action_information_category, taxable_benefits, gross_pay, row_label from pay_ac_emp_sum_action_info_v psv where action_context_id = :1 and action_information_category = decode( :2 , null, action_information_category, :3)) QRSLT ORDER BY row_label
bnk32fdswwqrzbegin HXC_APPROVAL_WF_PKG.create_appl_period_info (:v1, :v2, :v3, :v4, :v5); end;
bqf04xkudk4ztBEGIN :1 := FND_AOLJ_UTIL.createSession(:2, :3, :4, NULL, 'Y', TRUE, TRUE, NULL, NULL, NULL, NULL, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22);:23 := fnd_session_management.g_enc_key;:24 := fnd_session_management.g_mac_key;END;
bqzutt5g7maz0select distinct furg.responsibility_id, furg.responsibility_application_id, furg.security_group_id, furg.start_date, furg.end_date from fnd_user_resp_groups furg, fnd_responsibility fr where furg.user_id = :1 and furg.responsibility_id = fr.responsibility_id and furg.responsibility_application_id = fr.application_id and furg.start_date <= sysdate and (furg.end_date is null or furg.end_date >= sysdate) and fr.start_date <= sysdate and (fr.end_date is null or fr.end_date >= sysdate) order by furg.responsibility_id, furg.responsibility_application_id, furg.security_group_id
chkkj84y3mv9s BEGIN fnd_msg_pub.initialize;AP_WEB_OA_MAINFLOW_PKG.validateReceiptLine(employee_id => :1, template_id => :2, summary_start_date => :3, reimbursement_currency_code => :4, reimbursement_currency_name => :5, multi_currency_flag => :6, override_approver_name => :7, number_max_flexfield => :8, start_date => :9, end_date => :10, days => :11, daily_amount => :12, receipt_amount => :13, rate => :14, amount => :15, parameter_id => :16, currency_code => :17, merchant => :18, merchantDoc => :19, taxReference => :20, taxRegNumber => :21, taxPayerId => :22, supplyCountry => :23, itemizeId => :24, cCardTrxnId => :25, group_value => :26, justification => :27, receipt_missing_flag => :28, validation_required => :29, taxOverrideFlag => :30, project_number => :31, task_number => :32, project_name => :33, task_name => :34, attribute1 => :35, attribute2 => :36, attribute3 => :37, attribute4 => :38, attribute5 => :39, attribute6 => :40, attribute7 => :41, attribute8 => :42, attribute9 => :43, attribute10 => :44, attribute11 => :45, attribute12 => :46, attribute13 => :47, attribute14 => :48, attribute15 => :49, p_IsSessionTaxEnabled => :50, p_IsSessionProjectEnabled => :51, p_calculate_amt_index => :52, p_calculated_receipt_amount => :53, p_return_status => :54, p_msg_count => : 55, p_msg_data => :56, p_userId => :57, award_number => :58, p_cost_center => :59, p_template_name => :60 , p_purpose => :61 , p_override_approver_id => :62, p_last_update_date => :63, receipt_cost_center => :64, p_transaction_currency_type => :65, p_inverse_rate_flag => :66, p_report_header_id => :67, p_category_code => :68, p_nFreeBreakfasts1 => :69, p_nFreeBreakfasts2 => :70, p_nFreeBreakfasts3 => :71, p_nFreeLunches1 => :72, p_nFreeLunches2 => :73, p_nFreeLunches3 => :74, p_nFreeDinners1 => :75, p_nFreeDinners2 => :76, p_nFreeDinners3 => :77, p_nFreeAccommodations1 => :78, p_nFreeAccommodations2 => :79, p_nFreeAccommodations3 => :80, p_location => :81, p_dailyDistance => :82, p_tripDistance => :83, p_mileageRate => :84, p_vehicleCategory => :85, p_vehicleType => :86, p_fuelType => :87, p_numberPassengers => :88, p_default_currency_code => :89, p_default_exchange_rate_type => :90, p_header_attribute_category => :91, p_header_attribute1 => :92, p_header_attribute2 => :93, p_header_attribute3 => :94, p_header_attribute4 => :95, p_header_attribute5 => :96, p_header_attribute6 => :97, p_header_attribute7 => :98, p_header_attribute8 => :99, p_header_attribute9 => :100, p_header_attribute10 => :101, p_header_attribute11 => :102, p_header_attribute12 => :103, p_header_attribute13 => :104, p_header_attribute14 => :105, p_head er_attribute15 => :106, p_receipt_index => :107, p_passenger_rate_used => :108, p_license_plate_number => :109, p_destination_from => :110, p_destination_to => :111, p_distance_unit_code => :112, p_report_line_id => :113, p_itemization_parent_id => :114, p_cust_meals_amount => :115, p_cust_accommodation_amount => :116, p_cust_night_rate_amount => :117, p_cust_pdm_rate => :118, p_emp_attendee_count => :119, p_nonemp_attendee_count => :120 , p_vat_code => :121);END;
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cmxq1hvy8crz7SELECT ExpAttendeeEO.REPORT_LINE_ID, ExpAttendeeEO.EMPLOYEE_FLAG, ExpAttendeeEO.EMPLOYEE_ID, ExpAttendeeEO.ATTENDEE_TYPE, ExpAttendeeEO.NAME, ExpAttendeeEO.TITLE, ExpAttendeeEO.EMPLOYER, ExpAttendeeEO.EMPLOYER_ADDRESS, ExpAttendeeEO.ORG_ID, ExpAttendeeEO.LAST_UPDATE_DATE, ExpAttendeeEO.LAST_UPDATED_BY, ExpAttendeeEO.CREATION_DATE, ExpAttendeeEO.CREATED_BY, ExpAttendeeEO.LAST_UPDATE_LOGIN, ExpAttendeeEO.ATTENDEE_LINE_ID, ExpAttendeeEO.TAX_ID FROM OIE_ATTENDEES_ALL ExpAttendeeEO WHERE :1 = ExpAttendeeEO.REPORT_LINE_ID AND EMPLOYEE_FLAG = 'Y'
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
cygumhvsq65t2begin HXC_APPROVAL_WF_PKG.is_appr_required (:v1, :v2, :v3, :v4, :v5); end;
dawf7hvg1ym94select V.PROFILE_OPTION_VALUE from FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V where O.PROFILE_OPTION_NAME = :1 and V.LEVEL_ID = :2 and O.START_DATE_ACTIVE <= SYSDATE and nvl(O.END_DATE_ACTIVE, SYSDATE) >= SYSDATE and O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID and O.APPLICATION_ID = V.APPLICATION_ID and V.LEVEL_VALUE = :3
dcrschgcxcbknbegin AP_WEB_EXPENSE_WF.APVALIDATEEXPENSEREPORT (:v1, :v2, :v3, :v4, :v5); end;
dt2vdh82d4hrbBEGIN :1 := FND_WEB_SEC.validate_login(:2, :3); END;
f1v2hmt6qbkycbegin fnd_session_management.PUTSESSIONATTRIBUTEVALUE(:1, :2, :3);end;
f2sn773bcyrj6/* $Header: ValueSet.java 120.7.12010000.6 2009/03/17 07:22:48 vsoolapa ship $ */ select enabled_flag FLEX_ENABLED_FLAG , trunc(start_date_active) FLEX_START_DATE , trunc(end_date_active) FLEX_END_DATE , trunc(SysDate) FLEX_SYSDATE , summary_flag FLEX_SUMMARY_FLAG , compiled_value_attributes FLEX_COMPILED_VALUE_ATTRIBUTES , description FLEX_DESCRIPTION from fnd_flex_values_vl where (fnd_flex_values_vl.flex_value_set_id = :1) and flex_value = :2
f7g96xjhudpztBEGIN HXC_TIMECARD.CREATE_TIMECARD (P_VALIDATE => :1 , P_BLOCKS => :2 , P_ATTRIBUTES => :3 , P_DEPOSIT_MODE => :4 , P_TEMPLATE => :5 , P_ITEM_TYPE => :6 , P_APPROVAL_PRC => :7 , P_LOCK_ROWID => :8 , P_TIMECARD_ID => :9 , P_TIMECARD_OVN => :10 , P_MESSAGES => :11 , P_CLA_SAVE => :12 ); END;
fw6u054ccjgpvSELECT * FROM (SELECT erp.PARAMETER_ID AS PARAMETER_ID, nvl(erp.WEB_FRIENDLY_PROMPT, erp.PROMPT) AS WEB_PROMPT, erp.PROMPT AS PROMPT, erp.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(erp.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(erp.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, erp.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(erp.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, erp.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, erp.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, erp.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, erp.COMPANY_POLICY_ID, erp.CATEGORY_CODE, erp.END_DATE, erp.ITEMIZATION_REQUIRED_FLAG, erp.ITEMIZATION_ALL_FLAG, erp.RECEIPT_REQUIRED_FLAG, erp.data_capture_rule_id, tax.name as tax_code, tax.tax_id FROM AP_EXPENSE_REPORT_PARAMS erp, AP_TAX_CODES tax where erp.vat_code = tax.name(+) and 'Y' = tax.WEB_ENABLED_FLAG(+)) QRSLT WHERE PARAMETER_ID = :1
g22cn4nvvn83bbegin HXC_APPROVAL_WF_PKG.process_appl_periods (:v1, :v2, :v3, :v4, :v5); end;
g2qs4xk48vcwyselect to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 = :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMENT5 = :FND_BIND6)
g3g74r6wnrv0h SELECT * FROM (SELECT parent_type.expense_report_id as parent_expense_report_id, parent_type.parameter_id as parent_expense_type_id, child_type.PARAMETER_ID AS child_expense_type_id, nvl(child_type.WEB_FRIENDLY_PROMPT, child_type.PROMPT) AS WEB_PROMPT, child_type.PROMPT AS PROMPT, child_type.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(child_type.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(child_type.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, child_type.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(child_type.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, child_type.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, child_type.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, child_type.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, child_type.COMPANY_POLICY_ID, child_type.CATEGORY_CODE, child_type.END_DATE, child_type.ITEMIZATION_REQUIRED_FLAG, child_type.ITEMIZATION_ALL_FLAG, child_type.RECEIPT_REQUIRED_FLAG, child_type.data_capture_rule_id FROM AP_EXPENSE_REPORT_PARAMS parent_type, AP_EXPENSE_REPORT_PARAMS child_type, AP_POL_ITEMIZATIONS api WHERE parent_type.itemization_all_flag = 'N' AND api.parameter_id = parent_type.parameter_id AND child_type.parameter_id = api.itemization_parameter_id AND child_type.CATEGORY_CODE != 'PER_DIEM' AND child_type.CATEG ORY_CODE != 'MILEAGE' AND ('RO' = :1 or trunc(sysdate) <= trunc(nvl(child_type.END_DATE, sysdate)) + nvl(fnd_profile.value('AP_WEB_POLICY_GRACE_PERIOD'), 0)) UNION ALL SELECT parent_type.expense_report_id as parent_expense_report_id, parent_type.parameter_id as parent_expense_type_id, child_type.PARAMETER_ID AS child_expense_type_id, nvl(child_type.WEB_FRIENDLY_PROMPT, child_type.PROMPT) AS WEB_PROMPT, child_type.PROMPT AS PROMPT, child_type.REQUIRE_RECEIPT_AMOUNT AS REQUIRE_RECEIPT_AMOUNT, nvl(child_type.prompt, 'ITEM') AS ITEM_DESCRIPTION, nvl(child_type.line_type_lookup_code, 'ITEM') AS LINE_TYPE_LOOKUP_CODE, child_type.CARD_EXP_TYPE_LOOKUP_CODE AS CARD_EXP_TYPE_LOOKUP_CODE, nvl(child_type.JUSTIFICATION_REQUIRED_FLAG, 'N') AS JUSTIFICATION_REQUIRED, child_type.CALCULATE_AMOUNT_FLAG AS CALCULATE_AMOUNT_FLAG, child_type.AMOUNT_INCLUDES_TAX_FLAG AS AMOUNT_INCLUDES_TAX_FLAG, child_type.PA_EXPENDITURE_TYPE AS PA_EXPENDITURE_TYPE, child_type.COMPANY_POLICY_ID, child_type.CATEGORY_CODE, child_type.END_DATE, child_type.ITEMIZATION_REQUIRED_FLAG, child_type.ITEMIZATION_ALL_FLAG, child_type.RECEIPT_REQUIRED_FLAG, child_type.data_capture_rule_id FROM AP_EXPENSE_REPORT_PARAMS parent_type, AP_EXPENSE_REPORT_PARAMS child_type WHERE parent_type.itemization_all_flag = 'Y' -- Include Expense Type if it either belongs to the requested Template -- or if it is marked as "Viewable From All Tempaltes AND (child_type.expense_report_id = parent_type.expense_report_id OR child_type.web_enabled_flag = 'Y') AND child_type.CATEGORY_CODE != 'PER_DIEM' AND child_type.CATEGORY_CODE != 'MILEAGE' AND ('RO' = :2 or trunc(sysdate) <= trunc(nvl(child_type.END_DATE, sysdate)) + nvl(fnd_profile.value('AP_WEB_POLICY_GRACE_PERIOD'), 0))) QRSLT WHERE PARENT_EXPENSE_TYPE_ID = :3 ORDER BY WEB_PROMPT
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gjm43un5cy843SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME)
gmvh826nm09vj SELECT * FROM (SELECT AP_WEB_DB_CCARD_PKG.GetLocation(merchant_city , merchant_province_state) AS LOCATION, ApCreditCardTrxnsAll.TRX_ID, ApCreditCardTrxnsAll.CARD_PROGRAM_ID, ApCreditCardTrxnsAll.TRANSACTION_DATE, ApCreditCardTrxnsAll.TRANSACTION_AMOUNT, ApCreditCardTrxnsAll.BILLED_AMOUNT, ApCreditCardTrxnsAll.POSTED_CURRENCY_CODE, ApCreditCardTrxnsAll.BILLED_CURRENCY_CODE, ApCreditCardTrxnsAll.MERCHANT_NAME1, ApCreditCardTrxnsAll.MERCHANT_CITY, ApCreditCardTrxnsAll.MERCHANT_PROVINCE_STATE, ApCreditCardTrxnsAll.MERCHANT_COUNTRY, ApCreditCardTrxnsAll.FOLIO_TYPE, ApCreditCardTrxnsAll.CATEGORY, ApCreditCardTrxnsAll.REPORT_HEADER_ID, ApCreditCardTrxnsAll.COMPANY_PREPAID_INVOICE_ID, ApCreditCardTrxnsAll.EXPENSED_AMOUNT, CreditCardEO.CARD_ID, nvl(ApCreditCardTrxnsAll.BILLED_DATE, ApCreditCardTrxnsAll.POSTED_DATE) BILLED_DATE, ApCreditCardTrxnsAll.HOTEL_ROOM_AMOUNT, ApCreditCardTrxnsAll.HOTEL_TELEPHONE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_ROOM_TAX, ApCreditCardTrxnsAll.HOTEL_BAR_AMOUNT, ApCreditCardTrxnsAll.HOTEL_MOVIE_AMOUNT, ApCreditCardTrxnsAll.HOTEL_GIFT_SHOP_AMOUNT, ApCreditCardTrxnsAll.HOTEL_LAUNDRY_AMOUNT, ApCreditCardTrxnsAll.HOTEL_HEALTH_AMOUNT, ApCreditCardTrxnsAll.HOTEL_RESTAURANT_AMOUNT, ApCreditCardTrxnsAll.HOTEL_BUSINESS_AMOUNT, ApCreditCardTrxnsAll.HOTEL_PARKING_AMOUNT, ApCreditCardTrxnsAll.HOTEL_ROOM_SERVICE_AMOUNT, A pCreditCardTrxnsAll.HOTEL_TIP_AMOUNT, ApCreditCardTrxnsAll.HOTEL_MISC_AMOUNT, ApCreditCardTrxnsAll.PAYMENT_DUE_FROM_CODE, ApCreditCardTrxnsAll.POSTED_DATE, ApCreditCardTrxnsAll.AIR_TICKET_NUMBER, TRUNC(sysdate - POSTED_DATE) as Age, decode(REPORT_HEADER_ID, null, 'N', 'Y') as selected, decode(apcp.auto_itemize_enabled_flag, 'Y', decode(folio_type, null, 'N', ApCreditCardTrxnsAll.TRXN_DETAIL_FLAG), 'N') , decode(apcp.auto_itemize_enabled_flag, 'Y', decode(folio_type, null, 'N', decode(ApCreditCardTrxnsAll.TRXN_DETAIL_FLAG, 'Y', 'Y', AP_WEB_CREDIT_CARD_PKG.HAS_DETAILED_TRXN(ApCreditCardTrxnsAll.trx_id) ) ), 'N') as level2or3_detail_flag, ApCreditCardTrxnsAll.DESCRIPTION FROM AP_CREDIT_CARD_TRXNS ApCreditCardTrxnsAll, AP_CARDS CreditCardEO, AP_CARD_PROGRAMS apcp WHERE ApCreditCardTrxnsAll.validate_code = 'Y' AND CreditCardEO.CARD_PROGRAM_ID = apcp.card_program_id AND ApCreditCardTrxnsAll.payment_flag <> 'Y' AND ApCreditCardTrxnsAll.billed_amount is not null AND ApCreditCardTrxnsAll.billed_currency_code = :1 AND CreditCardEO.card_id = :2 AND ApCreditCardTrxnsAll.payment_due_from_code = :3 AND ApCreditCardTrxnsAll.CARD_PROGRAM_ID = CreditCardEO.CARD_PROGRAM_ID AND ApCreditCardTrxnsAll.CARD_ID = CreditCardEO.CARD_ID AND (nvl(ApCreditCardTrxnsAll.CATEGORY, 'BUSINESS') not in ('DISPUTED', 'CREDIT', 'MATCHED', 'DEACTIVATED')) AND trunc(nvl(ApCreditCardTrxnsAll.trx_available_date, TO_DATE('01-01-1952 00:00:00', 'DD-MM-YYYY HH2 4:MI:SS'))) <= trunc(sysdate)) QRSLT WHERE (report_header_id is null OR report_header_id = :4) ORDER BY age desc

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count39,5224.960.01
Batched IO (full) vector count00.000.00
Batched IO block miss count155,50519.500.03
Batched IO buffer defrag count50.000.00
Batched IO double miss count2,1950.280.00
Batched IO same unit count95,90012.020.02
Batched IO single block count30,2303.790.01
Batched IO vector block count28,1463.530.01
Batched IO vector read count11,4571.440.00
Block Cleanout Optim referenced3,2580.410.00
CCursor + sql area evicted00.000.00
CPU used by this session7,717,693967.671.47
CPU used when call started7,673,951962.181.46
CR blocks created1,650,135206.900.31
Cached Commit SCN referenced1,891,369237.150.36
Commit SCN cached317,39439.800.06
DB time12,350,2201,548.512.36
DBWR checkpoint buffers written1,644,169206.150.31
DBWR checkpoints20.000.00
DBWR transaction table writes20,6012.580.00
DBWR undo block writes1,006,669126.220.19
HSC Heap Segment Block Changes26,652,5763,341.785.09
Heap Segment Array Inserts224,12428.100.04
Heap Segment Array Updates84,93610.650.02
IMU CR rollbacks182,13222.840.03
IMU Flushes587,49273.660.11
IMU Redo allocation size697,959,35287,512.25133.23
IMU commits2,309,140289.530.44
IMU contention32,9694.130.01
IMU ktichg flush14,0741.760.00
IMU pool not allocated2,894,854362.970.55
IMU recursive-transaction flush1,0220.130.00
IMU undo allocation size5,094,919,048638,816.31972.55
IMU- failed to get a private strand10,8201.360.00
Number of read IOs issued40.000.00
RowCR - row contention28,7993.610.01
RowCR attempts32,062,4874,020.096.12
RowCR hits33,120,6484,152.776.32
SMON posted for undo segment shrink1,2120.150.00
SQL*Net roundtrips to/from client61,274,5377,682.7911.70
active txn count during cleanout3,301,263413.920.63
application wait time70,8048.880.01
background checkpoints completed20.000.00
background checkpoints started20.000.00
background timeouts41,1635.160.01
branch node splits8160.100.00
buffer is not pinned count553,073,20869,345.99105.57
buffer is pinned count471,950,31559,174.5590.09
bytes received via SQL*Net from client9,526,507,8851,194,462.271,818.48
bytes sent via SQL*Net to client11,795,175,8161,478,914.692,251.54
calls to get snapshot scn: kcmgss157,469,96119,744.0630.06
calls to kcmgas7,994,9191,002.431.53
calls to kcmgcs21,136,8612,650.204.03
cell physical IO interconnect bytes39,586,420,2244,963,464.677,556.52
change write time78,0489.790.01
cleanout - number of ktugct calls2,446,741306.780.47
cleanouts and rollbacks - consistent read gets1,572,197197.130.30
cleanouts only - consistent read gets278,29834.890.05
cluster key scan block gets37,9914.760.01
cluster key scans32,5124.080.01
commit batch performed26,3683.310.01
commit batch requested26,3683.310.01
commit batch/immediate performed32,2214.040.01
commit batch/immediate requested32,2214.040.01
commit cleanout failures: block lost241,57930.290.05
commit cleanout failures: buffer being written370.000.00
commit cleanout failures: callback failure66,3868.320.01
commit cleanout failures: cannot pin30,6993.850.01
commit cleanouts13,128,7291,646.122.51
commit cleanouts successfully completed12,790,0331,603.652.44
commit immediate performed5,8530.730.00
commit immediate requested5,8530.730.00
commit txn count during cleanout1,020,763127.990.19
concurrency wait time181,35322.740.03
consistent changes17,953,4972,251.063.43
consistent gets710,833,73489,126.48135.69
consistent gets - examination390,490,01848,960.8274.54
consistent gets direct190.000.00
consistent gets from cache710,835,08189,126.64135.69
consistent gets from cache (fastpath)255,455,81832,029.8248.76
cursor authentications1,4970.190.00
data blocks consistent reads - undo records applied16,304,0892,044.263.11
db block changes130,858,48116,407.4324.98
db block gets149,857,37818,789.5728.61
db block gets direct4880.060.00
db block gets from cache149,858,38318,789.7028.61
db block gets from cache (fastpath)30,751,2803,855.695.87
deferred (CURRENT) block cleanout applications3,345,835419.510.64
dirty buffers inspected1,4160.180.00
doubling up with imu segment30.000.00
enqueue conversions31,0733.900.01
enqueue releases11,990,5231,503.412.29
enqueue requests11,998,5301,504.412.29
enqueue timeouts70.000.00
enqueue waits9,8381.230.00
exchange deadlocks3,4590.430.00
execute count168,688,27121,150.6432.20
failed probes on index block reclamation10.000.00
file io service time00.000.00
file io wait time486,944,55661,054.5892.95
free buffer inspected933,772117.080.18
free buffer requested4,271,658535.590.82
heap block compress847,064106.210.16
hot buffers moved to head of LRU588,03873.730.11
immediate (CR) block cleanout applications1,850,537232.030.35
immediate (CURRENT) block cleanout applications1,272,257159.520.24
index crx upgrade (positioned)220.000.00
index crx upgrade (prefetch)20.000.00
index fetch by key157,115,32319,699.5929.99
index scans kdiixs199,017,92512,415.1718.90
java call heap collected bytes876,904,128109,948.88167.39
java call heap collected count9,590,7991,202.521.83
java call heap gc count5,7720.720.00
java call heap live object count1,5430.190.00
java call heap live object count max1,5430.190.00
java call heap live size91,82411.510.02
java call heap live size max91,82411.510.02
java call heap object count5,085,175637.590.97
java call heap object count max5,085,175637.590.97
java call heap total size9,175,0401,150.391.75
java call heap total size max32,768,0004,108.556.25
java call heap used size461,862,30457,909.6988.16
java call heap used size max461,862,41657,909.7088.16
java session heap live size1,025,638,400128,597.63195.78
java session heap live size max1,025,638,400128,597.63195.78
java session heap used size1,025,638,400128,597.63195.78
java session heap used size max1,025,638,400128,597.63195.78
leaf node 90-10 splits8,3701.050.00
leaf node splits165,34520.730.03
lob reads580.010.00
lob writes23,6662.970.00
lob writes unaligned23,6662.970.00
logons cumulative11,1701.400.00
max cf enq hold time3120.040.00
messages received1,739,268218.070.33
messages sent1,739,267218.070.33
min active SCN optimization applied on CR5,0760.640.00
no work - consistent read gets241,461,00530,275.1146.09
non-idle wait count130,636,06916,379.5424.94
non-idle wait time4,715,786591.280.90
opened cursors cumulative144,630,81718,134.2527.61
parse count (describe)320.000.00
parse count (failures)5,9920.750.00
parse count (hard)7,6850.960.00
parse count (total)34,298,2854,300.426.55
parse time cpu200,73925.170.04
parse time elapsed207,29025.990.04
physical read IO requests163,04020.440.03
physical read bytes4,155,760,640521,061.79793.28
physical read total IO requests179,18622.470.03
physical read total bytes4,415,498,240553,628.48842.86
physical read total multi block requests00.000.00
physical reads507,29563.610.10
physical reads cache503,96463.190.10
physical reads cache prefetch358,28444.920.07
physical reads direct3,3310.420.00
physical reads direct (lob)80.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup322,50340.440.06
physical write IO requests248,15631.110.05
physical write bytes13,529,440,2561,696,361.992,582.59
physical write total IO requests2,266,750284.210.43
physical write total bytes35,170,916,8644,409,835.556,713.66
physical write total multi block requests83,60810.480.02
physical writes1,651,543207.080.32
physical writes direct1,1200.140.00
physical writes direct (lob)540.010.00
physical writes direct temporary tablespace00.000.00
physical writes from cache1,650,423206.940.32
physical writes non checkpoint1,369,164171.670.26
pinned buffers inspected1370.020.00
pinned cursors current10,6771.340.00
prefetch warmup blocks aged out before use105,50613.230.02
prefetched blocks aged out before use860.010.00
process last non-idle time1,284,033,610160,996.00245.10
recursive calls280,626,25235,185.7753.57
recursive cpu usage2,789,186349.720.53
redo blocks checksummed by FG (exclusive)7,732,050969.471.48
redo blocks written41,902,9545,253.928.00
redo buffer allocation retries1100.010.00
redo entries60,966,2597,644.1311.64
redo log space requests1230.020.00
redo log space wait time1970.020.00
redo ordering marks858,600107.650.16
redo size20,221,715,0882,535,459.583,860.06
redo size for direct writes3,7480.470.00
redo subscn max counts1,416,773177.640.27
redo synch time3,878,905486.350.74
redo synch writes3,244,779406.840.62
redo wastage534,070,01266,963.31101.95
redo write time518,90365.060.10
redo writes1,478,660185.400.28
rollback changes - undo records applied155,56519.510.03
rollbacks only - consistent read gets38,0904.780.01
root node splits300.000.00
rows fetched via callback65,574,0668,221.8712.52
session connect time1,284,026,399160,995.10245.10
session cursor cache hits113,620,65814,246.1021.69
session logical reads860,595,279107,904.03164.28
shared hash latch upgrades - no wait58,085,8927,282.9811.09
shared hash latch upgrades - wait324,45440.680.06
sorts (memory)20,379,1252,555.203.89
sorts (rows)75,759,7229,498.9814.46
sql area evicted00.000.00
sql area purged60.000.00
summed dirty queue length3,4310.430.00
switch current to new buffer631,61479.190.12
table fetch by rowid396,692,88349,738.5575.72
table fetch continued row70,6138.850.01
table scan blocks gotten17,703,9392,219.773.38
table scan rows gotten654,682,65882,086.08124.97
table scans (short tables)7,862,879985.871.50
temp space allocated (bytes)3,645,898,752457,133.77695.95
total cf enq hold time2,7570.350.00
total number of cf enq holders3020.040.00
total number of times SMON posted1,3250.170.00
transaction rollbacks32,2204.040.01
undo change vector size7,169,761,600898,966.321,368.61
user I/O wait time32,1264.030.01
user calls62,531,2067,840.3511.94
user commits4,604,346577.310.88
user rollbacks634,36379.540.12
workarea executions - optimal10,282,1241,289.201.96
write clones created in background2,9940.380.00
write clones created in foreground1750.020.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max266,468,11269,042,377,736
session cursor cache count4,182834,025
session uga memory146,042,324,496800,594,888,752
opened cursors current40343,532
workarea memory allocated01,770
logons current265,467
session uga memory max143,491,58454,650,353,096
session pga memory182,582,03261,110,897,992

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)20.90

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR1M0.01.00012520G251.932.56847760.07
DBWR0M0.000M12.6G31.071.618940 
Buffer Cache Reads3.8G20.02.4936320M0.000M145.7K1.42
Others247M2.02.030969180M1.45.02256820K0.29
Direct Reads26M0.42.0032594M0.06.0005010 
Direct Writes0M0.000M4M0.02.0005010 
Streams AQ0M0.000M0M0.000M170.71
TOTAL:4.1G22.47.52798732.8G284.534.21098165.7K1.29

Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Log File0M0.000M20G251.952.569090.75 
Data File3.9G20.40.49664212.6G30.621.617811.45 
Control File243M1.95.030468181M1.46.0226940.25 
Temp File9M0.12.00112846M0.55.0057670.27 
TOTAL:4.1G22.47.52823832.8G284.584.215371.34 

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR 0M0.000M20G251.952.5690980.38
LGWR (Log File) 0M0.000M20G251.952.5690980.38
DBWR 0M0.000M12.6G31.091.620070 
DBWR (Data File) 0M0.000M12.6G31.091.620070 
Buffer Cache Reads 3.8G20.02.4935070M0.000M136.8K1.40
Buffer Cache Reads (Data File) 3.8G20.02.4935070M0.000M136.8K1.40
Others 247M2.02.030969180M1.45.02256816.1K0.26
Others (Control File) 242M1.94.030342180M1.45.02256815.5K0.25
Others (Data File) 5M0.08.0006260M0.010M6430.58
Streams AQ 0M0.000M0M0.000M170.71
Streams AQ (Data File) 0M0.000M0M0.000M170.71
TOTAL: 4.1G22.05.52447732.8G284.494.21174152.9K1.28

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
APPS_TS_TX_DATA 109,047141.593.0991,0801190,5150.09
APPS_UNDOTS1 1,04100.621.00104,1221346,3770.07
APPS_TS_TX_IDX 15,65221.753.3837,469566,1720.09
APPS_TS_SUMMARY 17,34522.293.731,5190282.14
SYSTEM 11,85110.832.1999201880.27
APPS_TS_SEED 3,34801.693.962,30102,8451.70
TEMP1 98200.791.004,363110.00
SYSAUX 2,25301.364.281,215000.00
APPS_TS_INTERFACE 43300.421.051,69606,0110.09
APPS_TS_ARCHIVE 6301.112.901,44202,2910.19
APPS_TS_QUEUES 16500.301.2195405970.10
APPS_TS_MEDIA 5600.001.0014000.00
APPS_TS_NOLOGGING 3200.001.008000.00
IAS_META 3600.832.282000.00
CWMLITE 2800.001.004000.00
DCM 2600.001.004000.00
GEOR_TBS 2400.001.004000.00
APPS_CALCLIP 1600.001.008000.00
APPS_TS_DISCO 1200.001.006000.00
B2B_RT 1400.001.002000.00
BAM 1400.001.002000.00
CTXSYS 1400.001.002000.00
OLTS_BATTRSTORE 1400.001.002000.00
OLTS_CT_STORE 1400.001.002000.00
OLTS_DEFAULT 1400.001.002000.00
OLTS_SVRMGSTORE 1400.001.002000.00
OPMOR 1400.001.002000.00
ORABPEL 1400.001.002000.00
APPS_TS_TOOLS 1200.001.002000.00
B2B_DT 1200.001.002000.00
B2B_IDX 1200.001.002000.00
B2B_LOB 1200.001.002000.00
DISCO_PTM5_CACHE 1200.001.002000.00
DISCO_PTM5_META 1200.001.002000.00
DSGATEWAY_TAB 1200.001.002000.00
HTMLDB 1200.001.002000.00
MTR 1200.001.002000.00
NOETIX 1200.001.002000.00
NON_APPS_TS_DATA 1200.001.002000.00
OCATS 1200.001.002000.00
ODM_DATA 1200.001.002000.00
OLTS_ATTRSTORE 1200.001.002000.00
OWAPUB 1200.001.002000.00
PORTAL 1200.001.002000.00
PORTAL_DOC 1200.001.002000.00
PORTAL_IDX 1200.001.002000.00
PORTAL_LOG 1200.001.002000.00
RE 1200.001.002000.00
SYNCSERVER 1200.001.002000.00
UDDISYS_TS 1200.001.002000.00
WCRSYS_TS 1200.001.002000.00
XDB 1200.001.002000.00
APPS_OMO 400.001.002000.00
APPS_TS_DISCO_OLAP 400.001.002000.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)
APPS_CALCLIP/oracle/data/apps_calclip.dbf 400.001.002000.00
APPS_CALCLIP/oracle/data/apps_calclip1.dbf 400.001.002000.00
APPS_CALCLIP/oracle/data/apps_calclip2.dbf 400.001.002000.00
APPS_CALCLIP/oracle/data/apps_calclip3.dbf 400.001.002000.00
APPS_OMO/oracle/data/omo1.dbf 400.001.002000.00
APPS_TS_ARCHIVE/oracle/data/archive1.dbf 6301.112.901,44202,2910.19
APPS_TS_DISCO/oracle/data/disco1.dbf 400.001.002000.00
APPS_TS_DISCO/oracle/data/disco2.dbf 400.001.002000.00
APPS_TS_DISCO/oracle/data/disco3.dbf 400.001.002000.00
APPS_TS_DISCO_OLAP/oracle/data/disco_drake1.dbf 400.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interfac27.dbf 400.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interfac28.dbf 5301.131.4227906040.10
APPS_TS_INTERFACE/oracle/data/apps_ts_interfac29.dbf 2500.401.0026506330.09
APPS_TS_INTERFACE/oracle/data/apps_ts_interfac30.dbf 1400.001.0022105850.15
APPS_TS_INTERFACE/oracle/data/apps_ts_interfac31.dbf 2802.141.0017205730.07
APPS_TS_INTERFACE/oracle/data/apps_ts_interfac32.dbf 3000.331.0016006110.11
APPS_TS_INTERFACE/oracle/data/apps_ts_interfac33.dbf 2500.401.0013806380.08
APPS_TS_INTERFACE/oracle/data/apps_ts_interfac34.dbf 2100.481.0010505800.05
APPS_TS_INTERFACE/oracle/data/apps_ts_interfac35.dbf 1901.051.009005620.12
APPS_TS_INTERFACE/oracle/data/apps_ts_interfac36.dbf 1700.001.007605970.13
APPS_TS_INTERFACE/oracle/data/apps_ts_interface.dbf 2100.001.008205870.03
APPS_TS_INTERFACE/oracle/data/apps_ts_interface1.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface10.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface11.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface12.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface13.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface14.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface15.dbf 800.001.0014030.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface16.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface17.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface18.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface19.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface2.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface20.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface21.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface22.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface23.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface24.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface25.dbf 600.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface26.dbf 1000.001.00440380.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface3.dbf 800.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface4.dbf 800.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface5.dbf 800.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface6.dbf 800.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface7.dbf 800.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface8.dbf 800.001.002000.00
APPS_TS_INTERFACE/oracle/data/apps_ts_interface9.dbf 800.001.002000.00
APPS_TS_MEDIA/oracle/data/media1.dbf 800.001.002000.00
APPS_TS_MEDIA/oracle/data/media2.dbf 800.001.002000.00
APPS_TS_MEDIA/oracle/data/media3.dbf 800.001.002000.00
APPS_TS_MEDIA/oracle/data/media4.dbf 800.001.002000.00
APPS_TS_MEDIA/oracle/data/media5.dbf 800.001.002000.00
APPS_TS_MEDIA/oracle/data/media6.dbf 800.001.002000.00
APPS_TS_MEDIA/oracle/data/media7.dbf 800.001.002000.00
APPS_TS_NOLOGGING/oracle/data/nologging1.dbf 800.001.002000.00
APPS_TS_NOLOGGING/oracle/data/nologging2.dbf 800.001.002000.00
APPS_TS_NOLOGGING/oracle/data/nologging3.dbf 800.001.002000.00
APPS_TS_NOLOGGING/oracle/data/nologging4.dbf 800.001.002000.00
APPS_TS_QUEUES/oracle/data/queues1.dbf 900.001.00380240.00
APPS_TS_QUEUES/oracle/data/queues10.dbf 900.001.00340350.00
APPS_TS_QUEUES/oracle/data/queues11.dbf 3600.831.972160540.00
APPS_TS_QUEUES/oracle/data/queues12.dbf 1201.671.001400460.00
APPS_TS_QUEUES/oracle/data/queues13.dbf 1100.001.00950430.00
APPS_TS_QUEUES/oracle/data/queues2.dbf 1100.001.00740480.00
APPS_TS_QUEUES/oracle/data/queues3.dbf 1100.001.00670450.00
APPS_TS_QUEUES/oracle/data/queues4.dbf 1100.001.00550400.25
APPS_TS_QUEUES/oracle/data/queues5.dbf 1100.001.00560470.21
APPS_TS_QUEUES/oracle/data/queues6.dbf 1100.001.00530510.20
APPS_TS_QUEUES/oracle/data/queues7.dbf 1100.001.00450590.00
APPS_TS_QUEUES/oracle/data/queues8.dbf 1100.001.00440570.35
APPS_TS_QUEUES/oracle/data/queues9.dbf 1100.001.00370480.21
APPS_TS_SEED/oracle/data/reference1.dbf 9601.563.97820522.69
APPS_TS_SEED/oracle/data/reference10.dbf 9701.654.22760741.76
APPS_TS_SEED/oracle/data/reference11.dbf 11001.914.501070801.88
APPS_TS_SEED/oracle/data/reference12.dbf 37101.643.8515801931.76
APPS_TS_SEED/oracle/data/reference13.dbf 19001.744.1713301061.89
APPS_TS_SEED/oracle/data/reference14.dbf 17201.513.7612501062.17
APPS_TS_SEED/oracle/data/reference15.dbf 14801.624.0713401171.71
APPS_TS_SEED/oracle/data/reference16.dbf 13402.014.5512201051.24
APPS_TS_SEED/oracle/data/reference17.dbf 11902.024.341130761.97
APPS_TS_SEED/oracle/data/reference18.dbf 11801.863.991050892.70
APPS_TS_SEED/oracle/data/reference19.dbf 10801.674.20880982.35
APPS_TS_SEED/oracle/data/reference2.dbf 12001.754.539001091.38
APPS_TS_SEED/oracle/data/reference20.dbf 12601.594.248901092.29
APPS_TS_SEED/oracle/data/reference21.dbf 11901.934.55930820.73
APPS_TS_SEED/oracle/data/reference22.dbf 11401.674.078401242.18
APPS_TS_SEED/oracle/data/reference23.dbf 12301.714.339101121.96
APPS_TS_SEED/oracle/data/reference24.dbf 12603.894.528401031.94
APPS_TS_SEED/oracle/data/reference25.dbf 11701.543.899301262.06
APPS_TS_SEED/oracle/data/reference3.dbf 11601.554.086901011.29
APPS_TS_SEED/oracle/data/reference4.dbf 10701.594.176801192.10
APPS_TS_SEED/oracle/data/reference5.dbf 10101.884.84570882.05
APPS_TS_SEED/oracle/data/reference6.dbf 9901.523.885901421.90
APPS_TS_SEED/oracle/data/reference7.dbf 9401.493.765401181.78
APPS_TS_SEED/oracle/data/reference8.dbf 21700.411.006503230.25
APPS_TS_SEED/oracle/data/reference9.dbf 10601.604.27620931.83
APPS_TS_SUMMARY/oracle/data/summary1.dbf 1,13702.523.69105060.00
APPS_TS_SUMMARY/oracle/data/summary10.dbf 1,12302.813.8589000.00
APPS_TS_SUMMARY/oracle/data/summary11.dbf 1,19802.423.6682000.00
APPS_TS_SUMMARY/oracle/data/summary12.dbf 1,17502.543.79115000.00
APPS_TS_SUMMARY/oracle/data/summary13.dbf 1,17002.153.721000160.00
APPS_TS_SUMMARY/oracle/data/summary14.dbf 1,15802.063.81124010.00
APPS_TS_SUMMARY/oracle/data/summary15.dbf 1,10702.073.90109000.00
APPS_TS_SUMMARY/oracle/data/summary2.dbf 1,18702.113.58103000.00
APPS_TS_SUMMARY/oracle/data/summary3.dbf 1,13702.233.7078000.00
APPS_TS_SUMMARY/oracle/data/summary4.dbf 1,10802.183.75101000.00
APPS_TS_SUMMARY/oracle/data/summary5.dbf 1,14202.633.81106000.00
APPS_TS_SUMMARY/oracle/data/summary6.dbf 1,15102.073.7899000.00
APPS_TS_SUMMARY/oracle/data/summary7.dbf 1,15702.293.7799070.00
APPS_TS_SUMMARY/oracle/data/summary8.dbf 1,19402.363.631020130.00
APPS_TS_SUMMARY/oracle/data/summary9.dbf 1,20101.993.58107000.00
APPS_TS_TOOLS/oracle/data/apps_ts_tools01.dbf 1200.001.002000.00
APPS_TS_TX_DATA/oracle/data/tx_data1.dbf 6600.761.6214608970.10
APPS_TS_TX_DATA/oracle/data/tx_data10.dbf 1,34101.442.911,29201,1070.08
APPS_TS_TX_DATA/oracle/data/tx_data11.dbf 1,47301.743.141,39801,3000.10
APPS_TS_TX_DATA/oracle/data/tx_data12.dbf 1,44701.843.201,38608240.08
APPS_TS_TX_DATA/oracle/data/tx_data13.dbf 1,44501.483.201,40209470.13
APPS_TS_TX_DATA/oracle/data/tx_data14.dbf 7100.991.5814201,0390.09
APPS_TS_TX_DATA/oracle/data/tx_data15.dbf 1,35001.422.891,30109450.03
APPS_TS_TX_DATA/oracle/data/tx_data16.dbf 1,22801.453.141,30308370.06
APPS_TS_TX_DATA/oracle/data/tx_data17.dbf 1,27301.543.091,26401,2830.05
APPS_TS_TX_DATA/oracle/data/tx_data18.dbf 7100.561.3813009760.08
APPS_TS_TX_DATA/oracle/data/tx_data19.dbf 1,27101.573.051,21301,2230.11
APPS_TS_TX_DATA/oracle/data/tx_data2.dbf 1,46301.803.161,36909710.07
APPS_TS_TX_DATA/oracle/data/tx_data20.dbf 5905.421.2215508460.04
APPS_TS_TX_DATA/oracle/data/tx_data21.dbf 1,47301.363.181,38901,0830.07
APPS_TS_TX_DATA/oracle/data/tx_data22.dbf 1,50201.503.001,35101,4000.06
APPS_TS_TX_DATA/oracle/data/tx_data23.dbf 6200.811.4414501,0310.09
APPS_TS_TX_DATA/oracle/data/tx_data24.dbf 1,37101.302.841,32101,2010.03
APPS_TS_TX_DATA/oracle/data/tx_data25.dbf 6200.811.4413101,0350.09
APPS_TS_TX_DATA/oracle/data/tx_data26.dbf 6300.481.2114009870.15
APPS_TS_TX_DATA/oracle/data/tx_data27.dbf 1,30701.622.921,29301,1230.12
APPS_TS_TX_DATA/oracle/data/tx_data28.dbf 1,32501.462.921,30601,2190.04
APPS_TS_TX_DATA/oracle/data/tx_data29.dbf 1,32701.522.931,31001,4440.08
APPS_TS_TX_DATA/oracle/data/tx_data3.dbf 6100.661.4313909480.14
APPS_TS_TX_DATA/oracle/data/tx_data30.dbf 1,31201.572.961,27501,0130.03
APPS_TS_TX_DATA/oracle/data/tx_data31.dbf 1,26001.543.081,26907200.06
APPS_TS_TX_DATA/oracle/data/tx_data32.dbf 1,42901.323.241,40701,0120.14
APPS_TS_TX_DATA/oracle/data/tx_data33.dbf 1,35601.732.851,28401,1900.04
APPS_TS_TX_DATA/oracle/data/tx_data34.dbf 1,29701.492.961,28901,0280.08
APPS_TS_TX_DATA/oracle/data/tx_data35.dbf 7400.811.6919401,1560.04
APPS_TS_TX_DATA/oracle/data/tx_data36.dbf 6801.181.4013101,1160.05
APPS_TS_TX_DATA/oracle/data/tx_data37.dbf 5900.681.4713201,0110.06
APPS_TS_TX_DATA/oracle/data/tx_data38.dbf 5700.531.4713201,3040.08
APPS_TS_TX_DATA/oracle/data/tx_data39.dbf 20501.022.4239201,3990.14
APPS_TS_TX_DATA/oracle/data/tx_data4.dbf 6000.671.6513209420.07
APPS_TS_TX_DATA/oracle/data/tx_data40.dbf 6900.581.3926808870.05
APPS_TS_TX_DATA/oracle/data/tx_data41.dbf 7301.231.5120409940.07
APPS_TS_TX_DATA/oracle/data/tx_data42.dbf 7401.621.5320603,4390.11
APPS_TS_TX_DATA/oracle/data/tx_data43.dbf 1,52701.403.221,44001,1070.06
APPS_TS_TX_DATA/oracle/data/tx_data44.dbf 1,50901.573.301,43307800.19
APPS_TS_TX_DATA/oracle/data/tx_data45.dbf 1,45101.473.281,43901,0560.08
APPS_TS_TX_DATA/oracle/data/tx_data46.dbf 1,43601.733.341,44901,1730.15
APPS_TS_TX_DATA/oracle/data/tx_data47.dbf 1,47601.663.221,47201,3540.14
APPS_TS_TX_DATA/oracle/data/tx_data48.dbf 1,53101.673.111,40801,2420.10
APPS_TS_TX_DATA/oracle/data/tx_data49.dbf 1,49501.733.191,46801,1360.05
APPS_TS_TX_DATA/oracle/data/tx_data5.dbf 5502.001.4915808140.07
APPS_TS_TX_DATA/oracle/data/tx_data50.dbf 1,46301.413.231,43901,2180.07
APPS_TS_TX_DATA/oracle/data/tx_data51.dbf 1,43301.623.271,39801,0160.06
APPS_TS_TX_DATA/oracle/data/tx_data52.dbf 1,33901.283.021,33009630.07
APPS_TS_TX_DATA/oracle/data/tx_data53.dbf 1,50001.413.131,40601,1050.12
APPS_TS_TX_DATA/oracle/data/tx_data54.dbf 1,49901.513.151,39708050.17
APPS_TS_TX_DATA/oracle/data/tx_data55.dbf 1,48101.723.151,45401,1060.23
APPS_TS_TX_DATA/oracle/data/tx_data56.dbf 1,53401.543.201,46807320.19
APPS_TS_TX_DATA/oracle/data/tx_data57.dbf 1,54801.893.311,51701,3000.05
APPS_TS_TX_DATA/oracle/data/tx_data58.dbf 1,61401.753.271,50901,3590.06
APPS_TS_TX_DATA/oracle/data/tx_data59.dbf 1,74701.633.321,50307690.07
APPS_TS_TX_DATA/oracle/data/tx_data6.dbf 6100.661.2114706810.10
APPS_TS_TX_DATA/oracle/data/tx_data60.dbf 4,67910.641.031,46901,2080.04
APPS_TS_TX_DATA/oracle/data/tx_data61.dbf 2,15001.603.011,46909900.15
APPS_TS_TX_DATA/oracle/data/tx_data62.dbf 2,14101.463.111,50608400.11
APPS_TS_TX_DATA/oracle/data/tx_data63.dbf 2,06401.443.321,48008760.17
APPS_TS_TX_DATA/oracle/data/tx_data64.dbf 2,21701.803.271,41901,0570.07
APPS_TS_TX_DATA/oracle/data/tx_data65.dbf 2,21101.663.301,45701,4770.05
APPS_TS_TX_DATA/oracle/data/tx_data66.dbf 2,06501.633.351,50901,0060.08
APPS_TS_TX_DATA/oracle/data/tx_data67.dbf 2,05401.853.391,55508020.15
APPS_TS_TX_DATA/oracle/data/tx_data68.dbf 2,16301.773.201,48901,0610.19
APPS_TS_TX_DATA/oracle/data/tx_data69.dbf 2,06801.823.411,42301,1140.19
APPS_TS_TX_DATA/oracle/data/tx_data7.dbf 1,33901.702.931,31001,1710.08
APPS_TS_TX_DATA/oracle/data/tx_data70.dbf 2,12001.793.401,46701,0740.07
APPS_TS_TX_DATA/oracle/data/tx_data71.dbf 2,12501.613.371,45001,2150.12
APPS_TS_TX_DATA/oracle/data/tx_data72.dbf 2,06902.033.371,50201,1170.11
APPS_TS_TX_DATA/oracle/data/tx_data73.dbf 2,08001.713.441,47801,1230.09
APPS_TS_TX_DATA/oracle/data/tx_data74.dbf 2,05401.623.301,46401,2000.08
APPS_TS_TX_DATA/oracle/data/tx_data75.dbf 2,12301.763.181,43108970.18
APPS_TS_TX_DATA/oracle/data/tx_data76.dbf 2,18101.673.321,47709670.09
APPS_TS_TX_DATA/oracle/data/tx_data77.dbf 2,11601.673.381,51101,3240.08
APPS_TS_TX_DATA/oracle/data/tx_data78.dbf 2,17501.673.281,47401,2410.06
APPS_TS_TX_DATA/oracle/data/tx_data79.dbf 2,14901.923.241,46209700.07
APPS_TS_TX_DATA/oracle/data/tx_data8.dbf 5800.521.2414408530.12
APPS_TS_TX_DATA/oracle/data/tx_data80.dbf 2,04301.813.411,43201,2280.13
APPS_TS_TX_DATA/oracle/data/tx_data81.dbf 2,10501.713.351,52101,1550.11
APPS_TS_TX_DATA/oracle/data/tx_data82.dbf 2,09501.683.321,38808920.08
APPS_TS_TX_DATA/oracle/data/tx_data83.dbf 2,13601.763.291,47108800.07
APPS_TS_TX_DATA/oracle/data/tx_data9.dbf 6400.471.2014601,1840.06
APPS_TS_TX_IDX/oracle/data/tx_idx1.dbf 17401.724.191780200.50
APPS_TS_TX_IDX/oracle/data/tx_idx10.dbf 23002.653.4164301,1610.11
APPS_TS_TX_IDX/oracle/data/tx_idx11.dbf 25701.753.0662001,3870.01
APPS_TS_TX_IDX/oracle/data/tx_idx12.dbf 18401.794.09820270.74
APPS_TS_TX_IDX/oracle/data/tx_idx13.dbf 18803.034.071050380.00
APPS_TS_TX_IDX/oracle/data/tx_idx14.dbf 18402.014.15830160.00
APPS_TS_TX_IDX/oracle/data/tx_idx15.dbf 26101.573.2364301,5940.07
APPS_TS_TX_IDX/oracle/data/tx_idx16.dbf 19901.763.78960560.00
APPS_TS_TX_IDX/oracle/data/tx_idx17.dbf 25601.413.1856101,0970.14
APPS_TS_TX_IDX/oracle/data/tx_idx18.dbf 25901.473.1457001,3720.09
APPS_TS_TX_IDX/oracle/data/tx_idx19.dbf 25401.423.2155701,2130.10
APPS_TS_TX_IDX/oracle/data/tx_idx2.dbf 26001.543.0655601,5680.11
APPS_TS_TX_IDX/oracle/data/tx_idx20.dbf 18601.994.151160300.33
APPS_TS_TX_IDX/oracle/data/tx_idx21.dbf 19101.883.941350430.00
APPS_TS_TX_IDX/oracle/data/tx_idx22.dbf 24601.753.2755601,4030.13
APPS_TS_TX_IDX/oracle/data/tx_idx23.dbf 24601.463.2362701,3150.08
APPS_TS_TX_IDX/oracle/data/tx_idx24.dbf 24202.073.2861802,2360.12
APPS_TS_TX_IDX/oracle/data/tx_idx25.dbf 24701.463.3058501,3070.09
APPS_TS_TX_IDX/oracle/data/tx_idx26.dbf 27101.403.1053901,2620.08
APPS_TS_TX_IDX/oracle/data/tx_idx27.dbf 22702.253.4852001,1980.07
APPS_TS_TX_IDX/oracle/data/tx_idx28.dbf 25001.563.2755001,2730.06
APPS_TS_TX_IDX/oracle/data/tx_idx29.dbf 24101.783.2964901,6360.08
APPS_TS_TX_IDX/oracle/data/tx_idx3.dbf 24401.763.0960601,2370.09
APPS_TS_TX_IDX/oracle/data/tx_idx30.dbf 24901.733.1761601,2440.11
APPS_TS_TX_IDX/oracle/data/tx_idx31.dbf 24001.753.2364001,4340.03
APPS_TS_TX_IDX/oracle/data/tx_idx32.dbf 23801.973.2265801,0930.12
APPS_TS_TX_IDX/oracle/data/tx_idx33.dbf 23401.583.1548101,3530.08
APPS_TS_TX_IDX/oracle/data/tx_idx34.dbf 22901.533.1449001,1830.09
APPS_TS_TX_IDX/oracle/data/tx_idx35.dbf 58901.322.961,25101,6430.19
APPS_TS_TX_IDX/oracle/data/tx_idx36.dbf 44101.363.111,18602140.37
APPS_TS_TX_IDX/oracle/data/tx_idx37.dbf 23201.904.495030660.00
APPS_TS_TX_IDX/oracle/data/tx_idx38.dbf 33501.703.401,13001,2500.14
APPS_TS_TX_IDX/oracle/data/tx_idx39.dbf 29901.673.511,01601,1730.04
APPS_TS_TX_IDX/oracle/data/tx_idx4.dbf 23901.803.9151101130.44
APPS_TS_TX_IDX/oracle/data/tx_idx40.dbf 31002.523.511,03801,1260.11
APPS_TS_TX_IDX/oracle/data/tx_idx41.dbf 30401.973.3392101,2080.07
APPS_TS_TX_IDX/oracle/data/tx_idx42.dbf 29302.013.4396802,7140.09
APPS_TS_TX_IDX/oracle/data/tx_idx43.dbf 27801.693.5394801,0280.08
APPS_TS_TX_IDX/oracle/data/tx_idx44.dbf 27102.513.4386701,2080.09
APPS_TS_TX_IDX/oracle/data/tx_idx45.dbf 29201.783.2788301,3410.09
APPS_TS_TX_IDX/oracle/data/tx_idx46.dbf 27201.803.3495201,1320.06
APPS_TS_TX_IDX/oracle/data/tx_idx47.dbf 26301.833.2787601,0690.14
APPS_TS_TX_IDX/oracle/data/tx_idx48.dbf 28501.753.2982803,4180.08
APPS_TS_TX_IDX/oracle/data/tx_idx49.dbf 25001.603.1872201,2700.06
APPS_TS_TX_IDX/oracle/data/tx_idx5.dbf 16201.914.361820130.00
APPS_TS_TX_IDX/oracle/data/tx_idx50.dbf 24401.483.3275701,0740.03
APPS_TS_TX_IDX/oracle/data/tx_idx51.dbf 25101.393.2069601,2620.08
APPS_TS_TX_IDX/oracle/data/tx_idx52.dbf 25301.583.2574501,1560.07
APPS_TS_TX_IDX/oracle/data/tx_idx53.dbf 26301.443.0866201,1030.07
APPS_TS_TX_IDX/oracle/data/tx_idx54.dbf 27601.783.1264101,6350.08
APPS_TS_TX_IDX/oracle/data/tx_idx55.dbf 25401.503.3759501,1640.14
APPS_TS_TX_IDX/oracle/data/tx_idx56.dbf 24601.503.3567101,2050.15
APPS_TS_TX_IDX/oracle/data/tx_idx57.dbf 22901.703.5662701,3330.11
APPS_TS_TX_IDX/oracle/data/tx_idx58.dbf 25501.533.1861701,3060.08
APPS_TS_TX_IDX/oracle/data/tx_idx59.dbf 22901.663.4159801,2060.11
APPS_TS_TX_IDX/oracle/data/tx_idx6.dbf 26602.443.0664701,1460.09
APPS_TS_TX_IDX/oracle/data/tx_idx60.dbf 24002.173.3555601,2790.12
APPS_TS_TX_IDX/oracle/data/tx_idx61.dbf 25701.403.1458101,2730.12
APPS_TS_TX_IDX/oracle/data/tx_idx62.dbf 25101.673.1959801,1700.05
APPS_TS_TX_IDX/oracle/data/tx_idx7.dbf 16602.174.342310170.00
APPS_TS_TX_IDX/oracle/data/tx_idx8.dbf 18701.713.842060330.00
APPS_TS_TX_IDX/oracle/data/tx_idx9.dbf 18301.693.941790280.00
APPS_UNDOTS1/oracle/data/undo.dbf 12700.551.0013,77126,2490.05
APPS_UNDOTS1/oracle/data/undo2.dbf 12900.621.0014,71426,3380.06
APPS_UNDOTS1/oracle/data/undo3.dbf 14700.681.0014,39926,4210.08
APPS_UNDOTS1/oracle/data/undo4.dbf 17900.611.0015,44627,1530.07
APPS_UNDOTS1/oracle/data/undo5.dbf 13400.601.0015,39026,7150.07
APPS_UNDOTS1/oracle/data/undo6.dbf 16100.561.0015,25426,8970.06
APPS_UNDOTS1/oracle/data/undo7.dbf 16400.731.0015,14826,6040.06
B2B_DT/oracle/data/b2b_dt.dbf 1200.001.002000.00
B2B_IDX/oracle/data/b2b_idx.dbf 1200.001.002000.00
B2B_LOB/oracle/data/b2b_lob.dbf 1200.001.002000.00
B2B_RT/oracle/data/b2b_rt.dbf 1400.001.002000.00
BAM/oracle/data/bam.dbf 1400.001.002000.00
CTXSYS/oracle/data/ctx1.dbf 1400.001.002000.00
CWMLITE/oracle/data/cwmlite01.dbf 1400.001.002000.00
CWMLITE/oracle/data/cwmlite02.dbf 1400.001.002000.00
DCM/oracle/data/dcm.dbf 1400.001.002000.00
DCM/oracle/data/dcm1.dbf 1200.001.002000.00
DISCO_PTM5_CACHE/oracle/data/discopltc1.dbf 1200.001.002000.00
DISCO_PTM5_META/oracle/data/discopltm1.dbf 1200.001.002000.00
DSGATEWAY_TAB/oracle/data/oss_sys01.dbf 1200.001.002000.00
GEOR_TBS/oracle/data/apps_ts_spatial.dbf 1200.001.002000.00
GEOR_TBS/oracle/data/geor_tbs02.dbf 1200.001.002000.00
HTMLDB/oracle/data/htmldb.dbf 1200.001.002000.00
IAS_META/oracle/data/ias_meta01.dbf 3600.832.282000.00
MTR/oracle/data/opmtr01.dbf 1200.001.002000.00
NOETIX/oracle/data/noetix.dbf 1200.001.002000.00
NON_APPS_TS_DATA/oracle/data/non_apps_data1.dbf 1200.001.002000.00
OCATS/oracle/data/oca.dbf 1200.001.002000.00
ODM_DATA/oracle/data/odm.dbf 1200.001.002000.00
OLTS_ATTRSTORE/oracle/data/attrs1_oid.dbf 1200.001.002000.00
OLTS_BATTRSTORE/oracle/data/battrs1_oid.dbf 1400.001.002000.00
OLTS_CT_STORE/oracle/data/gcats1_oid.dbf 1400.001.002000.00
OLTS_DEFAULT/oracle/data/gdefault1_oid.dbf 1400.001.002000.00
OLTS_SVRMGSTORE/oracle/data/svrmg1_oid.dbf 1400.001.002000.00
OPMOR/oracle/data/opmor01.dbf 1400.001.002000.00
ORABPEL/oracle/data/orabpel.dbf 1400.001.002000.00
OWAPUB/oracle/data/owa1.dbf 1200.001.002000.00
PORTAL/oracle/data/portal.dbf 1200.001.002000.00
PORTAL_DOC/oracle/data/ptldoc.dbf 1200.001.002000.00
PORTAL_IDX/oracle/data/ptlidx.dbf 1200.001.002000.00
PORTAL_LOG/oracle/data/ptllog.dbf 1200.001.002000.00
RE/oracle/data/opre01.dbf 1200.001.002000.00
SYNCSERVER/oracle/data/mobile01.dbf 1200.001.002000.00
SYSAUX/oracle/data/sysaux01.dbf 1,43101.173.73924000.00
SYSAUX/oracle/data/sysaux02.dbf 82201.705.22291000.00
SYSTEM/oracle/data/sys1.dbf 1,07500.852.43101061.67
SYSTEM/oracle/data/sys10.dbf 1,48800.761.981150240.42
SYSTEM/oracle/data/sys11.dbf 1,09900.882.3210010.00
SYSTEM/oracle/data/sys2.dbf 1,01900.892.445090.00
SYSTEM/oracle/data/sys3.dbf 88300.651.63500141.43
SYSTEM/oracle/data/sys4.dbf 73101.163.0631000.00
SYSTEM/oracle/data/sys5.dbf 90000.671.82162010.00
SYSTEM/oracle/data/sys6.dbf 1,05700.661.80111000.00
SYSTEM/oracle/data/sys7.dbf 1,00500.842.1584000.00
SYSTEM/oracle/data/sys8.dbf 1,35800.842.3031001320.08
SYSTEM/oracle/data/sys9.dbf 1,23600.992.3113010.00
TEMP1/oracle/data/temp1_01.dbf 10200.691.0033200 
TEMP1/oracle/data/temp1_02.dbf 7700.521.0025400 
TEMP1/oracle/data/temp1_03.dbf 7800.901.0026100 
TEMP1/oracle/data/temp1_04.dbf 6500.771.0020500 
TEMP1/oracle/data/temp1_05.dbf 9000.561.0029800 
TEMP1/oracle/data/temp1_06.dbf 12900.541.0038700 
TEMP1/oracle/data/temp1_07.dbf 9800.611.0053100 
TEMP1/oracle/data/temp1_08.dbf 5800.691.0038400 
TEMP1/oracle/data/temp1_09.dbf 4801.881.00374010.00
TEMP1/oracle/data/temp1_10.dbf 6000.671.0039000 
TEMP1/oracle/data/temp1_11.dbf 7201.811.0044700 
TEMP1/oracle/data/temp1_12.dbf 10500.671.0050000 
UDDISYS_TS/oracle/data/uddisys01.dbf 1200.001.002000.00
WCRSYS_TS/oracle/data/wcrsys01.dbf 1200.001.002000.00
XDB/oracle/data/xdb01.dbf 1200.001.002000.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D1,218,387100857,860,717503,9101,646,58200215,418

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00001,640,2410

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B0342297893397383033973830    
E01778677223994479451474339738309451474   

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D9600.101181.568641448.00
D1,9200.192371.256931353.00
D2,8800.293551.206661338.00
D3,8400.394731.176471328.00
D4,8000.495911.136281317.00
D5,7600.587101.116141309.00
D6,7200.688281.086001301.00
D7,6800.789461.065871294.00
D8,6400.871,0651.035731286.00
D9,6000.971,1831.015591279.00
D9,8881.001,2181.005541276.00
D10,5601.071,3010.995481272.00
D11,5201.171,4190.995461272.00
D12,4801.261,5380.985461272.00
D13,4401.361,6560.985461272.00
D14,4001.461,7740.985461272.00
D15,3601.551,8930.985461272.00
D16,3201.652,0110.985461272.00
D17,2801.752,1290.985461272.00
D18,2401.842,2480.985461272.00
D19,2001.942,3660.985461272.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00178,0590

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)
B10,2409,138129.370.000.000.000.001,048,570
E10,24064063,448.540.580.00100.000.001,048,570

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K9,974,8349,974,83400
64K128K3,2323,23200
128K256K2,5312,53100
256K512K2200
512K1024K162,153162,15300
1M2M26,93926,93900

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 CountEstd Time
1,2800.13178,242.98813.41100.0096511,650,406
2,5600.25178,242.98803.67100.0095611,649,772
5,1200.50178,242.98803.67100.0094111,649,772
7,6800.75178,242.98796.50100.0092211,649,306
10,2401.00178,242.980.00100.0089411,597,481
12,2881.20178,242.980.00100.0086611,597,481
14,3361.40178,242.980.00100.0084511,597,481
16,3841.60178,242.980.00100.0082411,597,481
18,4321.80178,242.980.00100.0080111,597,481
20,4802.00178,242.980.00100.0077511,597,481
30,7203.00178,242.980.00100.0062211,597,481
40,9604.00178,242.980.00100.0044311,597,481
61,4406.00178,242.980.00100.00011,597,481
81,9208.00178,242.980.00100.00011,597,481

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 (K)
3,2000.79855,5811,245,0621.002,2121.0083,568
3,6160.9015410,0071,245,0621.002,2121.00149,861
4,0321.0015410,0071,245,0621.002,2121.00149,861
4,4481.1015410,0071,245,0621.002,2121.00149,861
4,8641.2115410,0071,245,0621.002,2121.00149,861
5,2801.3115410,0071,245,0621.002,2121.00149,861
5,6961.4115410,0071,245,0621.002,2121.00149,861
6,1121.5215410,0071,245,0621.002,2121.00149,861
6,5281.6215410,0071,245,0621.002,2121.00149,861
6,9441.7215410,0071,245,0621.002,2121.00149,861
7,3601.8315410,0071,245,0621.002,2121.00149,861
7,7761.9315410,0071,245,0621.002,2121.00149,861
8,1922.0315410,0071,245,0621.002,2121.00149,861

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,3760.38120,317701,665
7,1680.50120,293654,784
8,9600.63120,270621,368
10,7520.75120,271606,905
12,5440.88120,260579,696
14,3361.00120,231554,150
16,1281.13120,238552,543
17,9201.25120,253552,543
19,7121.38120,257552,543
21,5041.50120,260552,543
23,2961.63120,276552,543
25,0881.75120,279552,543
26,8801.88120,284552,543
28,6722.00120,299552,543

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)
320.500000
641.000000
961.500000
1282.000000
1602.500000
1923.000000
2243.500000
2564.000000
2884.500000
3205.000000
3525.500000
3846.000000
4166.500000
4487.000000
4807.500000
5128.000000
5448.500000
5769.000000
6089.500000
64010.000000

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
960.431529,8931.002,2211.0021,858
1280.5782479,8931.002,2211.00104,707
1600.7182479,8931.002,2211.00104,707
1920.8682479,8931.002,2211.00104,707
2241.0082479,8931.002,2211.00104,707
2561.1482479,8931.002,2211.00104,707
2881.2982479,8931.002,2211.00104,707
3201.4382479,8931.002,2211.00104,707
3521.5782479,8931.002,2211.00104,707
3841.7182479,8931.002,2211.00104,707
4161.8682479,8931.002,2211.00104,707
4482.0082479,8931.002,2211.00104,707
4802.1482479,8931.002,2211.00104,707

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block160,936200
undo block38,92620
undo header7,54810
segment header4,14900
1st level bmb3,65700
2nd level bmb6200
system undo block1801
system undo header8700
extent map400
file header block100

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction 4,844,6494,841,00902,38762.38
HW-Segment High Water Mark 141,752141,74562,79531.01
TX-Transaction (index contention) 3,4193,41903,36420.66
US-Undo Segment 4,1814,181059923.69
FB-Format Block 18,81418,814040600.62
SQ-Sequence Cache 7,6557,655011100.59
TX-Transaction (row lock contention) 4404013.25
TX-Transaction (allocate ITL entry) 115115011200.35

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
21,005.884,630,3741,9501,48230/46.10/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
09-Sep 07:55118,111545,0891,818901430/00/0/0/0/0/0
09-Sep 07:45119,401544,5491,950995460/00/0/0/0/0/0
09-Sep 07:35117,616539,1551,8331,108440/00/0/0/0/0/0
09-Sep 07:25118,541544,9081,8661,292440/00/0/0/0/0/0
09-Sep 07:15121,013548,5681,4691,474380/00/0/0/0/0/0
09-Sep 07:05102,064467,4881,6301,482400/00/0/0/0/0/0
09-Sep 06:5596,019445,4051,9251,376460/00/0/0/0/0/0
09-Sep 06:4579,602363,1461,7491,208430/00/0/0/0/0/0
09-Sep 06:3560,511279,5061,8311,047450/00/0/0/0/0/0
09-Sep 06:2542,481200,8441,573822400/00/0/0/0/0/0
09-Sep 06:1524,650119,392966562300/00/0/0/0/0/0
09-Sep 06:055,78231,6981,566248400/00/0/0/0/0/0
09-Sep 05:55866269593300/00/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
AQ deq hash table latch20.00 00 
ASM db client latch24,2590.00 00 
ASM map operation hash table20.00 00 
ASM network state latch2070.00 00 
AWR Alerted Metric Element list538,0190.00 00 
Change Notification Hash table latch2,6430.00 00 
Consistent RBA1,476,9330.010.0000 
DML lock allocation12,782,7400.040.0100 
Event Group Locks11,0280.00 00 
FOB s.o list latch183,9140.060.0300 
File State Object Pool Parent Latch20.00 00 
IPC stats buffer allocation latch20.00 00 
In memory undo latch18,204,3950.060.7713,928,0020.57
JOX SGA heap latch861,1020.010.0002,3310.00
JS Sh mem access200.00 00 
JS queue access latch20.00 00 
JS queue state obj latch48,0600.00 00 
JS slv state obj latch5340.00 00 
KFC FX Hash Latch20.00 00 
KFC Hash Latch20.00 00 
KFCL LE Freelist20.00 00 
KGNFS-NFS:SHM structure20.00 00 
KGNFS-NFS:SVR LIST20.00 00 
KJC message pool free list20.00 00 
KJCT flow control latch20.00 00 
KMG MMAN ready and startup request latch2,6810.00 00 
KMG resize request state object freelist120.00 00 
KTF sga latch480.00 02,6610.00
KWQMN job cache list latch10.00 00 
KWQP Prop Status1,0020.00 00 
KWQS pqsubs latch23,3420.00 00 
KWQS pqueue ctx latch23,4860.451.0500 
Locator state objects pool parent latch20.00 00 
Lsod array latch20.00 00 
MQL Tracking Latch0  01580.00
Memory Management Latch750.00 02,6750.00
Memory Queue40.00 00 
Memory Queue Message Subscriber #120.00 00 
Memory Queue Message Subscriber #220.00 00 
Memory Queue Message Subscriber #320.00 00 
Memory Queue Message Subscriber #420.00 00 
Memory Queue Subscriber20.00 00 
MinActiveScn Latch430.00 00 
Mutex20.00 00 
Mutex Stats20.00 00 
NLS data objects666.671.0000 
OS process24,7820.00 00 
OS process allocation20,4790.000.0000 
OS process: request allocation16,6110.00 00 
PL/SQL warning settings2,614,8240.250.0000 
PX hash array latch20.00 00 
Policy Hash Table Latch100.00 00 
QMT20.00 00 
Real-time plan statistics latch1320.00 00 
SGA blob parent20.00 00 
SGA bucket locks20.00 00 
SGA heap locks20.00 00 
SGA pool locks20.00 00 
SQL memory manager latch20.00 02,6360.00
SQL memory manager workarea list latch6,971,4470.010.0000 
Shared B-Tree52,2850.010.0000 
Streams Generic20.00 00 
Testing20.00 00 
Token Manager20.00 00 
WCR: sync20.00 00 
Write State Object Pool Parent Latch20.00 00 
X$KSFQP20.00 00 
XDB NFS Security Latch20.00 00 
XDB unused session pool20.00 00 
XDB used session pool20.00 00 
active checkpoint queue latch259,5600.260.0100 
active service list65,8170.110.5905,2440.15
begin backup scn array670.00 00 
bq:time manger info latch2850.00 00 
buffer pool140.00 00 
bufq statistics20.00 00 
business card20.00 00 
cache buffer handles15,918,6570.290.0000 
cache buffers chains1,676,733,2990.440.02114,501,2890.23
cache buffers lru chain3,621,4350.040.0207,554,8330.12
cache table scan latch0  05,5130.05
call allocation440,0910.120.1400 
cas latch20.00 00 
change notification client cache latch20.00 00 
channel handle pool latch18,2030.020.0000 
channel operations parent latch197,8650.000.0000 
checkpoint queue latch9,554,0000.010.0101,750,2270.00
client/application info2,398,1690.030.0500 
compile environment latch11,1680.00 00 
corrupted undo seg latch497,8890.010.0000 
cp cmon/server latch20.00 00 
cp pool latch20.00 00 
cp server hash latch20.00 00 
cp sga latch2070.00 00 
cvmap freelist lock20.00 00 
deferred cleanup latch2070.00 00 
dml lock allocation1,1530.00 00 
done queue latch20.00 00 
dummy allocation16,9010.140.0000 
enqueue hash chains23,975,2340.480.0000 
enqueues1,431,8200.220.0000 
fifth spare latch20.00 00 
file cache latch56,3110.000.0000 
flashback copy20.00 00 
gc element20.00 00 
gcs commit scn state20.00 00 
gcs partitioned table hash20.00 00 
gcs pcm hashed value bucket hash20.00 00 
gcs resource freelist20.00 00 
gcs resource hash20.00 00 
gcs resource scan list20.00 00 
gcs shadows freelist20.00 00 
ges domain table20.00 00 
ges enqueue table freelist20.00 00 
ges group table20.00 00 
ges process hash list20.00 00 
ges process parent latch20.00 00 
ges resource hash list20.00 00 
ges resource scan list20.00 00 
ges resource table freelist20.00 00 
ges value block free list20.00 00 
global KZLD latch for mem in SGA10,7240.020.0000 
global ctx hash table latch3,382,3720.330.0000 
global tx hash mapping20.00 00 
granule operation20.00 00 
hash table column usage latch1,9260.00 0198,9290.00
hash table modification latch2050.00 00 
heartbeat check20.00 00 
internal temp table object number allocation latch240.00 00 
intra txn parallel recovery20.00 00 
io pool granule metadata list20.00 00 
job workq parent latch1460.00 01442.78
job_queue_processes free list latch2880.00 00 
job_queue_processes parameter latch1,8780.00 00 
k2q lock allocation20.00 00 
kcbtsemkid latch20.00 00 
kdlx hb parent latch20.00 00 
kgb parent20.00 00 
kks stats2,9920.00 00 
kokc descriptor allocation latch976,4740.900.0000 
ksfv messages20.00 00 
kss move lock740.00 00 
ksuosstats global area5380.00 00 
ksv allocation latch3510.00 00 
ksv class latch1460.00 00 
ksv msg queue latch20.00 00 
ksz_so allocation latch16,6110.00 00 
ktm global data2,4760.00 00 
kwqbsn:qsga4,9030.490.0000 
lgwr LWN SCN1,479,4320.020.0100 
list of block allocation303,5870.020.0000 
loader state object freelist4,4000.00 00 
lob segment dispenser latch20.00 00 
lob segment hash table latch280.00 00 
lob segment query latch20.00 00 
lock DBA buffer during media recovery20.00 00 
logical standby cache20.00 00 
logminer context allocation40.00 00 
logminer work area20.00 00 
longop free list parent20.00 00 
mapped buffers lru chain20.00 00 
message pool operations parent latch28,0060.00 00 
messages4,773,8400.410.0000 
mostly latch-free SCN1,530,6382.080.0100 
msg queue latch20.00 00 
multiblock read objects127,0660.010.0000 
name-service namespace bucket20.00 00 
ncodef allocation latch2070.00 00 
object queue header heap2,173,3870.000.07082,3700.01
object queue header operation19,877,4560.040.05023,6250.08
object stats modification115,7610.010.0000 
parallel query alloc buffer1,0540.00 00 
parallel query stats20.00 00 
parameter list99,9990.040.0000 
parameter table management23,5420.020.2000 
peshm20.00 00 
pesom_free_list20.00 00 
pesom_hash_node20.00 00 
post/wait queue2,365,6620.070.0103,197,2670.46
process allocation16,9130.080.86011,0240.02
process group creation16,6110.00 00 
process queue20.00 00 
process queue reference20.00 00 
qmn task queue latch8,75027.871.00100 
query server freelists20.00 00 
queued dump request260.00 00 
queuing load statistics20.00 00 
recovery domain hash list20.00 00 
redo allocation12,948,7540.700.01060,710,7351.22
redo copy20.00 060,819,1990.24
redo writing5,221,3330.020.0100 
resmgr group change latch26,1810.000.0000 
resmgr:active threads16,9010.00 00 
resmgr:actses change group10,9060.00 00 
resmgr:actses change state20.00 00 
resmgr:free threads list16,8990.140.0000 
resmgr:plan CPU method20.00 00 
resmgr:resource group CPU method20.00 00 
resmgr:schema config20.00 00 
resmgr:session queuing20.00 00 
rm cas latch20.00 00 
row cache objects317,097,1864.760.012370 
rules engine aggregate statistics23,3440.280.0000 
rules engine evaluation context statistics10.00 00 
rules engine rule set statistics70,2310.210.0000 
rules engine rule statistics23,3420.010.0000 
second spare latch20.00 00 
sequence cache6,007,5590.130.0000 
session allocation30,439,2410.390.00010,150,0190.03
session idle bit134,915,0540.080.0000 
session queue latch20.00 00 
session state list latch59,8050.410.8600 
session switching28,1340.00 00 
session timer4,3500.00 00 
shared pool16,120,5770.190.0100 
shared pool sim alloc2780.00 00 
shared pool simulator12,3720.010.0000 
sim partition latch20.00 00 
simulator hash latch45,046,3430.000.0000 
simulator lru latch1,256,9930.100.02043,589,6930.32
sort extent pool233,9990.040.0000 
space background state object latch220.00 00 
space background task latch5,8970.00 05,3200.00
state object free list40.00 00 
statistics aggregation6720.00 00 
tablespace key chain20.00 00 
temp lob duration state obj allocation290.00 00 
temporary table state object allocation2,1250.00 00 
test excl. parent l020.00 00 
test excl. parent2 l020.00 00 
third spare latch20.00 00 
threshold alerts latch1,5390.00 00 
trace latch5,4860.00 00 
transaction allocation663,6270.020.0000 
undo global data29,181,8020.100.01019,8880.16
virtual circuit buffers20.00 00 
virtual circuit holder20.00 00 
virtual circuit queues20.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
row cache objects317,097,18615,093,976135,50514,972,262
cache buffers chains1,676,733,2997,316,576158,1877,163,727
session allocation30,439,241117,261245117,017
enqueue hash chains23,975,234114,199198114,002
session idle bit134,915,054102,683317102,373
redo allocation12,948,75490,86350890,373
cache buffer handles15,918,65746,05817545,889
mostly latch-free SCN1,530,63831,89121131,686
shared pool16,120,57731,09019930,897
undo global data29,181,80229,72340429,615
messages4,773,84019,6342619,608
In memory undo latch18,204,39510,5988,1802,704
kokc descriptor allocation latch976,4748,790358,758
object queue header operation19,877,4568,5493998,154
sequence cache6,007,5597,691157,677
DML lock allocation12,782,7405,071345,038
enqueues1,431,8203,15943,155
qmn task queue latch8,7502,4392,442160
post/wait queue2,365,6621,645141,631
checkpoint queue latch9,554,0001,340151,325
simulator lru latch1,256,9931,311211,290
cache buffers lru chain3,621,4351,297321,266
redo writing5,221,3331,240141,226
SQL memory manager workarea list latch6,971,4477571756
client/application info2,398,16973440694
active checkpoint queue latch259,5606854681
call allocation440,09152573455
simulator hash latch45,046,3433431342
lgwr LWN SCN1,479,4323262324
session state list latch59,80524621164
FOB s.o list latch183,9141163113
KWQS pqueue ctx latch23,48610611114
active service list65,817734332
object queue header heap2,173,38715114
process allocation16,91314122
parameter table management23,542514
NLS data objects6440

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
DML lock allocationktaiam02622
DML lock allocationktaidm0812
FOB s.o list latchksfd_allfob033
In memory undo latchktiFlush: child05,1411,771
In memory undo latchkticmt: child02,0171,579
In memory undo latchktichg: child01,2783,471
In memory undo latchktiFlushMe0200207
In memory undo latchkturbk0591,691
In memory undo latchktiBRacquire0420
In memory undo latchktiTxnPoolFree0259
In memory undo latchktbgfc0739
In memory undo latchktiFlushTopTxn023
KWQS pqueue ctx latchkwqspqcbkf: updatepqs0115115
NLS data objectsklcslod044
SQL memory manager workarea list latchqesmmIRegisterWorkArea:2011
active checkpoint queue latchkcbbacq: scan active checkpoints044
active service listkswslogon: session login03122
active service listkswsite: service iterator0204
active service listkswslogon: session logout044
cache buffer handleskcbzgs0112120
cache buffer handleskcbzfs06355
cache buffers chainskcbchg1: kslbegin: bufs not pinned075,85667,629
cache buffers chainskcbgtcr: fast path073,3967,563
cache buffers chainskcbgtcr: fast path (cr pin)039,2539,141
cache buffers chainskcbgtcr_2030,72437,411
cache buffers chainskcbget: pin buffer018,80812,027
cache buffers chainskcbgcur_208,0582,298
cache buffers chainskcbgcur: fast path (shr)04,1221,270
cache buffers chainskcbzwb03,2932,083
cache buffers chainskcbrls_102,43918,152
cache buffers chainskcbrls_201,72553,278
cache buffers chainskcbchg1: kslbegin: call CR func01,25834,235
cache buffers chainskcbgcur_509731,755
cache buffers chainskcbnlc09061,645
cache buffers chainskcbget: exchange rls06852,927
cache buffers chainskcbget: exchange05315,238
cache buffers chainskcbgtcr: kslbegin excl0378604
cache buffers chainskcbzgb: scan from tail. nowait02560
cache buffers chainskcbgkcbcr0102518
cache buffers chainskcbesc: escalate07415
cache buffers chainskcbgtcr: kslbegin shared05343
cache buffers chainskcbnew: new latch again0341
cache buffers chainskcbcge0281,566
cache buffers chainskcbgcur_60219
cache buffers chainskcbbxsv01912
cache buffers chainskcb_is_private09351
cache buffers chainskcbbic2050
cache buffers chainskcbzpbuf051,390
cache buffers chainskcbgcur_40411
cache buffers chainskcbso1: set no access04329
cache buffers chainskcbget_1032
cache buffers chainskcb_commit02376
cache buffers chainskcbzibmlt: prewarm reads: nowait get020
cache buffers chainskcb_post_apply: kcbhq6201180
cache buffers chainskcb_pre_apply: kcbhq6101845
cache buffers chainskcbzibmlt: multi-block read: nowait010
cache buffers lru chainkcbzgws0280
cache buffers lru chainkcbbic20222
cache buffers lru chainkcbgtcr:CR Scan:KCBRSKIP_1020
call allocationksuxds0681
call allocationksuprc0442
call allocationksudlc : rec call0127
channel handle pool latchksrchconnect()022
checkpoint queue latchkcbkubc_40128
checkpoint queue latchkcbbwthc: thread checkpoint buffers037
client/application infoksuinfos_cinfo0278278
client/application infoksuinfos_modact021
enqueue hash chainsksqgtl3013488
enqueue hash chainsksqrcl062110
enqueue hash chainsksqcmi: get hash chain latch after wait020
enqueuesksqgel: create enqueue033
enqueuesksqdel011
kokc descriptor allocation latchkokcdlt: regular free02716
kokc descriptor allocation latchkokcdlt: allocation0819
lgwr LWN SCNkcs0230140
messagesksaamb: after wakeup02320
messagesksarcv035
mostly latch-free SCNkcslcu30197213
mostly latch-free SCNkcs024020
object queue header heapkcbo_check_flist010
object queue header operationkcbo_ivbo0394102
object queue header operationkcbo_switch_q_bg0140162
object queue header operationkcbo_switch_mq_bg0105183
object queue header operationkcbo_sw_buf04138
object queue header operationkcbo_link_q03744
object queue header operationkcbo_unlink_q02231
object queue header operationkcbo_check_flist05121
object queue header operationkcbo_switch_cq0257
parameter table managementksp_param_table_free010
post/wait queuekslpstevent:get061
post/wait queueksliwat:add:nowait040
post/wait queuekslpstevent:reget034
post/wait queueksliwat:add:wait010
process allocationksucrp:10110
process allocationksudlp014
qmn task queue latchkwqmnmvtsks: delay to ready list01,6150
qmn task queue latchkwqmngettsk: get task08042,431
qmn task queue latchkwqmndntsk: task done but retry0160
redo allocationkcrfw_redo_gen: redo allocation 104370
redo allocationkcrfw_redo_gen: redo allocation 3022240
redo allocationkcrfw_redo_gen: redo allocation 20160
redo allocationkcrfw_redo_write: before write01494
redo allocationkcrfw_post: more space012168
redo allocationkcrf_pvt_strand_bind056
redo allocationkcrf_pvt_strand_unbind010
redo allocationkcrfwnf:2010
redo writingkcrfwcr059
redo writingkcrfw_post: rba scn pair040
redo writingkcrfw_cal_target_rba021
redo writingkcrfrsn012
redo writingkcrfwnf: new logfile010
redo writingkcrfws: outside the loop011
row cache objectskqrpre: find obj059,89045,676
row cache objectskqreqd: reget040,33542,076
row cache objectskqreqd033,76646,095
row cache objectskqrso01,4061,416
row cache objectskqrcmt: while loop03788
row cache objectskqrpup01632
row cache objectskqrcmt: clear flag01358
row cache objectskqrget01227
row cache objectskqrpre: init complete0822
sequence cachekdnssd0131
sequence cachekdnnxt: cached seq010
sequence cachekdnss0114
session allocationksucri_int : licensing0127133
session allocationksuxds_int0106100
session allocationksucri_int : SSO070
session allocationksuxds0512
session idle bitksupuc: set busy0184124
session idle bitksupuc: clear busy099191
session idle bitksuxds06331
session state list latchkpseqd01797
session state list latchkpscad03010
session state list latchkpseqa02193
shared poolkghupr10104127
shared poolkghalo06643
shared poolkghfre02729
shared poolkghalp010
shared poolkghfnd: min scan010
simulator hash latchkcbsacc: lookup dba011
simulator lru latchkcbs_simulate: simulate set0120
simulator lru latchkcbs_simbufseq0719
simulator lru latchkcbs_shrink_pool020
undo global dataktumof: KSLBEGIN02970
undo global dataktusmous_online_undoseg03244
undo global dataktudba: KSLBEGIN03122
undo global dataktuswr_30151
undo global dataktusmupst: KSLBEGIN011317
undo global dataktudnx:child0811
undo global datakturax060
undo global dataktucof: at start030
undo global dataktubnd:child010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglpin1 422,049,5410
Library Cachekglpndl1 9515,013,8260
Library Cachekglhdgn2 10614,430,6430
Library Cachekglpnal1 904,086,2170
Library Cachekgllkdl1 85918,0720
Library CachekglIsOwnerVersionable 121291,9220
Library Cachekglget2 286,4592
Cursor Pinkksfbc [KKSCHLFSP2]18,5230
Library Cachekglhdgh1 6412,5581
Library Cachekglobpn1 7110,1550
Cursor PinkksLockDelete [KKSCHLPIN6]4,3930
Cursor StatkkocsStoreBindAwareStats [KKSSTALOC8]4,3120
Library Cachekglhdgn1 623,3480
Cursor Pinkkslce [KKSCHLPIN2]1,891-10
Cursor Pinkksfbc [KKSCHLPIN1]1,7590
Library Cachekgllkc1 579390
Cursor Pinkksxsccmp [KKSCHLPIN5]2260
Library Cachekglllal3 111980
Library Cachekgllldl2 112620
Cursor ParentkkscsAddChildNode [KKSPRTLOC34]270
Cursor ParentkkscsPruneChild [KKSPRTLOC35]210
Library Cachekglllal1 109170
Library Cachekglini1 32160
Library Cachekglnti1 46110
hash tablekkshListChanged [KKSHBKLOC9]80
Library Cachekglati1 4540
Library Cachekglpnck1 8840
Library Cachekgldtin1 4220
Library Cachekglobld1 7520
Library Cachekglkep1 1210
hash tablekkscsSearchChildList [KKSHBKLOC2]10
hash tablekkshGetNextChild [KKSHBKLOC1]10

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
APPLSYSAPPS_TS_TX_IDXFND_PROFILE_OPTION_VALUES_U1 INDEX74,324,2888.64
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX64,940,9447.55
APPLSYSAPPS_TS_SEEDFND_PROFILE_OPTIONS_U2 INDEX62,697,4247.29
APPLSYSAPPS_TS_SEEDFND_PROFILE_OPTIONS TABLE31,129,9843.62
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE17,219,5202.00

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
APAPPS_TS_TX_DATAAP_CREDIT_CARD_TRXNS_ALL TABLE234,54746.23
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX4,2200.83
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE3,6230.71
APPLSYSAPPS_TS_SEEDFND_USER TABLE1,2320.24
ICXAPPS_TS_TX_IDXICX_SESSION_ATTRIBUTES_U1 INDEX5150.10

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
APAPPS_TS_TX_DATAAP_CREDIT_CARD_TRXNS_ALL TABLE79,42548.72
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX4,1932.57
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE3,6232.22
APPLSYSAPPS_TS_SEEDFND_USER TABLE2440.15
APAPPS_TS_INTERFACEAP_EXPENSE_REPORT_HEADERS_ALL TABLE1500.09

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
APAPPS_TS_TX_DATAAP_CREDIT_CARD_TRXNS_ALL TABLE79,42548.72
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX4,1932.57
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE3,6232.22
APPLSYSAPPS_TS_SEEDFND_USER TABLE2440.15
APAPPS_TS_INTERFACEAP_EXPENSE_REPORT_HEADERS_ALL TABLE1500.09

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
APAPPS_TS_TX_DATAAP_CREDIT_CARD_TRXNS_ALL TABLE121,6017.36
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX97,2885.89
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE70,5514.27
ICXAPPS_TS_TX_IDXICX_SESSION_ATTRIBUTES_U1 INDEX29,7421.80
ICXAPPS_TS_TX_IDXICX_TRANSACTIONS_U2 INDEX24,6341.49

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
APAPPS_TS_TX_DATAAP_CREDIT_CARD_TRXNS_ALL TABLE71,20528.69
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX6,4982.62
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE5,4462.19
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX4,1301.66
ICXAPPS_TS_TX_IDXICX_SESSION_ATTRIBUTES_U1 INDEX2,7941.13

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX15,074,75223.36
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE13,279,24820.58
APAPPS_TS_TX_IDXAP_EXP_REPORT_DISTS_N1 INDEX3,794,3365.88
HXCAPPS_TS_TX_IDXHXC_TIME_ATTRIBUTE_USAGES_FK2 INDEX3,733,1045.79
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX3,181,4564.93

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX1,60651.08
APPLSYSAPPS_TS_TX_IDXWF_NOTIFICATIONS_ATTR_PK INDEX2598.24
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N4 INDEX2116.71
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N3 INDEX2066.55
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_PKWF_ITEM4INDEX PARTITION1514.80

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX11398.26
HXCAPPS_TS_TX_IDXHXC_TIME_BUILDING_BLOCKS_FK2 INDEX10.87
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX10.87

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
APPLSYSAPPS_TS_TX_DATAWF_ITEM_ATTRIBUTE_VALUES TABLE73,77445.86
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ATTRIBUTE_VALUES_PK INDEX32,06819.93
APPLSYSAPPS_TS_TX_IDXWF_ITEM_ACTIVITY_STATUSES_N1 INDEX7,1784.46
APPLSYSAPPS_TS_TX_IDXWF_NOTIFICATIONS_ATTR_PK INDEX7,0364.37
ICXAPPS_TS_TX_DATAICX_SESSIONS TABLE5,9723.71

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control1540.650 52
dc_files6320.000 0316
dc_global_oids6,902,2920.000 077
dc_histogram_data3,7215.910 0714
dc_histogram_defs27,84517.570 08,268
dc_object_grants39019.740 0126
dc_objects7,118,1390.050 06,517
dc_profiles10,8680.000 01
dc_rollback_segments2,595,4500.020 3,4391,495
dc_segments86,6993.900 19,7055,198
dc_sequences7,5460.300 7,54633
dc_tablespaces3,842,9640.000 056
dc_users120,241,9120.000 0147
global database name16,1790.000 01
kqlsubheap_object1100.000 01
outstanding_alerts6830.150 354


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
APP CONTEXT7,078,4390.007,078,6780.0000
BODY643,1640.0475,699,034-0.0000
CLUSTER2040.00480.0000
DBLINK21,4520.000 00
EDITION10,8930.0021,7610.0000
INDEX2705.562306.5200
QUEUE5,0050.0228,6790.0200
RULESET23,3440.0023,3440.0100
SCHEMA26,6440.060 00
SQL AREA2,282,1770.28173,673,227-0.335,9836
SUBSCRIPTION1,2940.081,2940.1500
TABLE/PROCEDURE7,573,0400.0580,658,0800.0010
TRIGGER431,9240.001,424,9740.0000


Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache10,080.009,888.009,888.0010,144.006SHR/IMM
KEEP buffer cache0.000.000.000.000STA/
PGA Target10,240.0010,240.0010,240.0010,240.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target14,336.0014,336.0014,336.0014,336.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool32.00224.0032.00224.006GRO/IMM
large pool32.0032.000.0032.000GRO/IMM
shared pool4,000.004,000.004,000.004,000.000STA/
streams pool64.0064.000.0064.000GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

ComponentMin Size (Mb)Max Size (Mb)Avg Size (Mb)Re- SizesGrowsShrinks
DEFAULT buffer cache9,888.0010,048.009,968.00606
java pool64.00224.00144.00660

Back to Memory Statistics
Back to Top

Memory Resize Ops

StartEla (s)ComponentOper Typ/ModInit Size (M)DeltaTarget DeltaFinal (M)Sta
09/09 06:00:110bufcacheSHR/IMM10,080-32 10,048COM
09/09 06:00:110bufcacheSHR/IMM10,048-32 10,016COM
09/09 06:00:110bufcacheSHR/IMM10,016-32 9,984COM
09/09 06:00:110bufcacheSHR/IMM9,984-32 9,952COM
09/09 06:00:110bufcacheSHR/IMM9,952-32 9,920COM
09/09 06:00:111bufcacheSHR/IMM9,920-32 9,888COM
09/09 06:00:111javaGRO/IMM19232 224COM
09/09 06:00:110javaGRO/IMM16032 192COM
09/09 06:00:110javaGRO/IMM12832 160COM
09/09 06:00:110javaGRO/IMM9632 128COM
09/09 06:00:110javaGRO/IMM6432 96COM
09/09 06:00:110javaGRO/IMM3232 64COM

Back to 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
BOther94.45 3.636.3231312626
 Freeable33.690.003.744.2111 99
 SQL0.790.150.070.07031210
 PL/SQL0.460.400.020.06002626
EOther22,525.59 4.121.7436365,4675,467
 PL/SQL18,658.8214,042.933.412.7914145,4675,467
 JAVA15,688.2415,668.653.180.14474,9304,930
 Freeable4,459.310.000.880.7118 5,0795,079
 SQL2,279.7879.030.420.424165,4535,449

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers10,569,646,08010,368,319,488
Fixed Size2,162,640 
Redo Buffers69,410,816 
Variable Size4,328,521,7764,529,848,368

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javaJOXLE 12.10 
javafree memory32.00211.60561.26
largePX msg pool0.470.470.00
largefree memory31.5331.530.00
sharedASH buffers50.0050.000.00
sharedFileOpenBlock 185.21 
sharedKKSSP 1,094.58 
sharedKTI-UNDO118.22118.220.00
sharedSQLA 60.79 
shareddb_block_hash_buckets89.0089.000.00
shareddbktb: trace buffer125.00125.000.00
sharedevent statistics per sess195.80195.800.00
sharedfree memory2,490.34966.53-61.19
sharedksunfy : SSO free list182.25182.250.00
sharedparameter table block 100.19 
sharedprivate strands235.47235.470.00
sharedtransaction43.1143.110.00
streamsfree memory63.9963.990.00
 buffer_cache10,080.009,888.00-1.90
 fixed_sga2.062.060.00
 log_buffer66.2066.200.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonForeground CPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Coordinator0909 05:36:109.480.000.00
QMON Slaves0909 05:36:209.350.020.00

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 Capture Rate

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

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

Queue NameEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
APPLSYS.WF_CONTROL(418370) 00.0000.0000.00 

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

RuleEvalsNo-SQL Eval%SQL ExecsCPU(s)Ela(s)Eval /SecSQL per EvalEla(s) per EvalCPU(s) per EvalReloads
*APPLSYS.WF_DEFERRED_R 23,4260.0008.218.690.000.000.000.001
SYS.ALERT_QUE_R 30.0000.000.000.000.000.000.000

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
*APPLSYS.WF_DEFERRED(418413) 23,42600.000.0046.620.000.0027.26
SYSMAN.MGMT_TASK_Q(418513) 1321320.000.000.060.220.000.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
*APPLSYS.WF_DEFERRED(418413) 1.650.000.00 
SYSMAN.MGMT_TASK_Q(418513) 0.020.020.000.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
*WF_DEFERRED(1)/APPLSYS.WF_DEFERRED 23,426001.650.000.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
000000

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_b_tree_bitmap_plansFALSE  
_fast_full_scan_enabledFALSE  
_index_join_enabledFALSE  
_like_with_bind_as_equalityTRUE  
_optimizer_autostats_jobFALSE  
_sort_elimination_cost_ratio5  
_sqlexec_progression_cost2147483647  
_system_trig_enabledTRUE  
_trace_files_publicTRUE  
aq_tm_processes1  
compatible11.2.0  
control_files/oracle/data/cntrl01.dbf, /oracle/data/cntrl02.dbf, /oracle/data/cntrl03.dbf  
cursor_sharingEXACT  
db_block_checkingFALSE  
db_block_checksumTRUE  
db_block_size8192  
db_file_multiblock_read_count8  
db_files512  
db_nameVIS  
diagnostic_dest/oracle/11.2.0/admin/VIS_M5K_db  
dml_locks10000  
filesystemio_optionssetall  
hash_area_size524288  
ifile/oracle/11.2.0/dbs/VIS_M5K_db_ifile.ora  
java_jit_enabledFALSE  
job_queue_processes2  
local_listenerVIS_LOCAL  
log_buffer64487424  
log_checkpoint_timeout1200  
log_checkpoints_to_alertTRUE  
max_dump_file_size20480  
nls_compbinary  
nls_date_formatDD-MON-RR  
nls_languageamerican  
nls_length_semanticsBYTE  
nls_numeric_characters.,  
nls_sortbinary  
nls_territoryamerica  
olap_page_pool_size4194304  
open_cursors5000  
optimizer_secure_view_mergingFALSE  
parallel_max_servers8  
parallel_min_servers0  
pga_aggregate_target10737418240  
plsql_code_typeINTERPRETED  
plsql_optimize_level2  
processes8000  
query_rewrite_enabledtrue  
remote_login_passwordfileEXCLUSIVE  
sec_case_sensitive_logonFALSE  
session_cached_cursors5000  
sessions16000  
sga_target15032385536  
shared_pool_reserved_size419430400  
shared_pool_size4194304000  
sort_area_size262144  
timed_statisticsTRUE  
undo_managementAUTO  
undo_tablespaceAPPS_UNDOTS1  
utl_file_dir/usr/tmp, /usr/tmp, /oracle/11.2.0/appsutil/outbound/VIS_M5K_db, /usr/tmp  
workarea_size_policyAUTO  


Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report