performance tunning
Oracle performance, Oracle
Dear sir/mam,From last 2 weeks,ur database performance id very slow.plz guide me how to solve the problem.
i giving ddetails of spreports,it may be help to resolve the problems.
give me solutions as soon as possible.
STATSPACK report for
DB Name DB Id Instance Inst Num Release OPS Host
------------ ----------- ------------ -------- ----------- --- ------------
PROD 785005184 prod 1 8.1.7.2.1 NO DB
Snap Id Snap Time Sessions
------- ------------------ --------
Begin Snap: 320 15-Mar-08 09:51:58 257
End Snap: 321 15-Mar-08 10:19:57 257
Elapsed: 27.98 (mins)
Cache Sizes
21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)~
db_block_buffers: 131072 log_buffer: 2097152
db_block_size: 8192 shared_pool_size: 734003200
Load Profile
21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)~~ Per Second Per Transaction
--------------- ---------------
Redo size: 34,811.18 12,281.57
Logical reads: 90,594.22 31,962.11
Block changes: 233.27 82.30
Physical reads: 873.74 308.26
Physical writes: 37.77 13.33
User calls: 163.40 57.65
Parses: 97.22 34.30
Hard parses: 0.28 0.10
Sorts: 30.54 10.77
Logons: 0.31 0.11
Executes: 349.46 123.29
Transactions: 2.83
% Blocks changed per Read: 0.26 Recursive Call %: 83.58
Rollback per transaction %: 7.98 Rows per Sort: 31.02
Instance Efficiency Percentages (Target 100%)
21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)
Buffer Nowait %: 99.86 Redo NoWait %: 99.92
Buffer Hit %: 99.04 In-memory Sort %: 99.99
Library Hit %: 99.95 Soft Parse %: 99.71
Execute to Parse %: 72.18 Latch Hit %: 99.83
Parse CPU to Parse Elapsd %: 32.43 % Non-Parse CPU: 99.99
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 65.05 68.39
% SQL with executions>1: 75.77 76.54
% Memory for SQL w/exec>1: 67.44 68.87
Top 5 Wait Events
21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)21:47, 26 March 2008 (CDT)~~ Wait % Total
Event Waits Time (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
db file sequential read 284,318 2,419,469 44.54
db file scattered read 208,778 1,777,681 32.72
buffer busy waits 210,366 980,275 18.04
enqueue 549 166,214 3.06
log file sequential read 1,604 15,348 .28
-------------------------------------------------------------
�Wait Events for DB: PROD Instance: prod Snaps: 320 -321
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (cs) (ms) /txn
---------------------------- ------------ ---------- ----------- ------ ------
db file sequential read 284,318 0 2,419,469 85 59.7
db file scattered read 208,778 0 1,777,681 85 43.9
buffer busy waits 210,366 363 980,275 47 44.2
enqueue 549 538 166,214 3028 0.1
log file sequential read 1,604 0 15,348 96 0.3
file open 5,384 0 15,065 28 1.1
log file switch completion 157 137 14,722 938 0.0
latch free 5,824 5,317 10,771 18 1.2
db file parallel read 546 0 9,341 171 0.1
log file sync 3,726 0 8,605 23 0.8
direct path read 6,316 0 6,024 10 1.3
log file parallel write 5,544 0 2,851 5 1.2
db file parallel write 787 0 2,120 27 0.2
single-task message 752 7 1,436 19 0.2
direct path write (lob) 588 0 1,023 17 0.1
control file sequential read 269 0 609 23 0.1
direct path write 3,861 0 484 1 0.8
SQL*Net more data to client 13,353 0 176 0 2.8
control file parallel write 393 0 139 4 0.1
direct path read (lob) 585 0 40 1 0.1
SQL*Net break/reset to clien 803 0 33 0 0.2
file identify 8 0 21 26 0.0
refresh controlfile command 10 0 9 9 0.0
LGWR wait for redo copy 133 4 8 1 0.0
library cache pin 121 0 0 0 0.0
PX Deq: Join ACK 5 0 0 0 0.0
PX Deq: Execution Msg 4 0 0 0 0.0
log file single write 4 0 0 0 0.0
SQL*Net message from client 291,954 0 13,694,291 469 61.3
pipe get 5,782 5,115 1,920,309 3321 1.2
wakeup time manager 52 48 153,663 29551 0.0
PX Idle Wait 6 2 499 832 0.0
SQL*Net more data from clien 3,899 0 70 0 0.8
SQL*Net message to client 291,209 0 33 0 61.2
-------------------------------------------------------------
�Background Wait Events for DB: PROD Instance: prod Snaps: 320 -321
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (cs) (ms) /txn
---------------------------- ------------ ---------- ----------- ------ ------
log file sequential read 1,604 0 15,348 96 0.3
log file parallel write 5,544 0 2,851 5 1.2
file open 2,915 0 2,830 10 0.6
db file scattered read 216 0 2,147 99 0.0
db file parallel write 787 0 2,120 27 0.2
enqueue 4 3 1,076 2690 0.0
db file sequential read 138 0 916 66 0.0
control file sequential read 146 0 389 27 0.0
direct path read 2,023 0 380 2 0.4
control file parallel write 393 0 139 4 0.1
file identify 8 0 21 26 0.0
LGWR wait for redo copy 133 4 8 1 0.0
latch free 3 3 8 27 0.0
direct path write 315 0 0 0 0.1
log file single write 4 0 0 0 0.0
rdbms ipc message 19,885 1,343 735,096 370 4.2
pmon timer 1,332 1,332 157,361 1181 0.3
smon timer 5 5 153,601 ###### 0.0
-------------------------------------------------------------
�SQL ordered by Gets for DB: PROD Instance: prod Snaps: 320 -321
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
Buffer Gets Executions Gets per Exec % Total Hash Value
--------------- ------------ -------------- ------- ------------
61,762,863 591 104,505.7 40.6 1800166724
update mtl_material_transactions MMT set transaction_group_id=:
b0,last_update_date=sysdate ,last_updated_by=:b1,last_update_log
in=:b2,program_application_id=:b3,program_id=:b4,program_update_
date=sysdate where ((((costed_flag='N' and (TRUNC(transaction_d
ate)<TO_DATE(:b5,'YYYY/MM/DD') or ((:b6=0 and :b7=0) and (TRUNC(
38,072,223 5 7,614,444.6 25.0 423950914
BEGIN WF_ENGINE.BACKGROUNDCONCURRENT( :errbuf, :rc,:A0,:A1,:A2,:
A3,:A4,:A5); END;
38,050,175 5 7,610,035.0 25.0 1335613946
SELECT /*+ ORDERED USE_NL (WIASP WI WPAP WAP) INDEX
(WIASP WF_ITEM_ACTIVITY_STATUSES_N1) */WIASP.ROWID ROW_ID FRO
M WF_ITEM_ACTIVITY_STATUSES WIASP,WF_ITEMS WI,WF_PROCESS_ACTIVIT
IES WPAP,WF_ACTIVITIES WAP WHERE WIASP.ITEM_TYPE = :b1 AND WIA
SP.PROCESS_ACTIVITY = WPAP.INSTANCE_ID AND WPAP.ACTIVITY_ITEM_T
19,905,892 17 1,170,934.8 13.1 2556253448
SELECT Pv . vendor_id vendor_id , Pvsites . vendor_site_id vendo
r_site_id , msi . segment1 Item_Id , msi . description Item_Desc
, ploc . need_by_date Reqd_Date , ploc . quantity - ploc . quan
tity_received Reqd_Qty , pha . segment1 || ' - ' || pra . releas
e_num PO_Rel_Num , hla . name Ship_Loc , pv . vendor_name Vendor
4,729,247 1 4,729,247.0 3.1 169434303
SELECT ROW_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPD
ATED_BY,LAST_UPDATE_LOGIN,RECEIPT_NUM,RECEIPT_DATE,SUPPLIER,SUPP
LIER_SITE,SHIPMENT_NUM,SHIPPED_DATE,SHIP_TO_LOCATION,PACKING_SLI
P,FREIGHT_CARRIER_CODE,WAYBILL_AIRBILL_NUM,BILL_OF_LADING,NUM_OF
_CONTAINERS,RECEIVER,DISPLAYED_SOURCE_TYPE,COMMENTS,USSGL_TRANSA
3,578,223 21 170,391.6 2.4 2301127471
update /*+ RULE +*/ GL_BC_PACKETS BP set (BP.budget_approved
_balance,BP.actual_approved_balance,BP.encumbrance_approved_bala
nce,BP.budget_pending_balance,BP.actual_pending_balance,BP.encum
brance_pending_balance)=(select /*+ RULE +*/ sum(decode((PK.s
tatus_code||PK.actual_flag),'AB',(nvl(PK.accounted_dr,0)-nvl(PK.
2,210,959 590 3,747.4 1.5 2025459805
select TO_CHAR(TRUNC(min(transaction_date)),'YYYY/MM/DD') into :
b0 from mtl_material_transactions MMT ,mtl_interorg_parameters
MIP where ((((costed_flag='E' and organization_id=:b1) or ((((((
transaction_action_id=3 and transaction_source_type_id in (13,8)
) and primary_quantity>0) and organization_id=:b1) and transacti
1,150,346 590 1,949.7 0.8 308724594
select NVL(min(transaction_id),(-1)) into :b0 from mtl_material
_transactions MMT ,mtl_interorg_parameters MIP where ((((costed_
flag='E' and organization_id=:b1) or ((((((transaction_action_id
=3 and transaction_source_type_id in (13,8)) and primary_quantit
�SQL ordered by Gets for DB: PROD Instance: prod Snaps: 320 -321
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
Buffer Gets Executions Gets per Exec % Total Hash Value
--------------- ------------ -------------- ------- ------------
y>0) and organization_id=:b1) and transaction_cost is null ) and
1,114,032 3 371,344.0 0.7 3366543238
SELECT AREA_OFF,CUS_NUM,CUS_NAME,MODEL,SUM(QTY) FROM ( SELECT ho
u.name AS AREA_OFF, RAC.CUSTOMER_NUMBER AS CUS_NUM, SUBSTR(RAC
.CUSTOMER_NAME,1,15) AS CUS_NAME, SUBSTR(MSI.DESCRIPTION,1,10) A
S MODEL, SUM(NVL(RCTLA.QUANTITY_INVOICED,0)) AS QTY FROM RA_
CUSTOMER_TRX_ALL rcta, RA_CUSTOMER_TRX_LINES_ALL rctla, HR_OPE
1,027,054 1 1,027,054.0 0.7 2291644630
select status . meaning status , c . customer_name Name , c . cu
stomer_number Number_A , c . customer_id Customer_Id , nvl ( cp_
site . collector_id , cp_cust . collector_id ) Collector_Id , co
l . name Collector , su . site_use_id cp_site_use_id , su . loca
tion location from ar_lookups status , ar_collectors col , ar_cu
807,495 18 44,860.8 0.5 1912750385
INSERT INTO AP_INVOICE_DISTRIBUTIONS ( INVOICE_ID,RCV_TRANSACTIO
N_ID,DIST_MATCH_TYPE,DIST_CODE_COMBINATION_ID,INVOICE_DISTRIBUTI
ON_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,ACCOUNTING_DATE,PERIOD_NA
ME,SET_OF_BOOKS_ID,AMOUNT,BASE_AMOUNT,EXCHANGE_DATE,EXCHANGE_RAT
E,EXCHANGE_RATE_TYPE,DESCRIPTION,TYPE_1099,TAX_CODE_ID,POSTED_FL
724,110 21 34,481.4 0.5 3202149719
SELECT 'X' FROM QP_LIST_LINES A,QP_EVENT_PHASES B WHERE B.PRI
CING_EVENT_CODE = :b1 AND B.PRICING_PHASE_ID = A.PRICING_PHASE_
ID AND A.MODIFIER_LEVEL_CODE = 'LINE' AND ROWNUM = 1
716,861 1 716,861.0 0.5 2791866518
SELECT INVOICE_TYPE,VENDOR_NAME,VENDOR_NUMBER,VENDOR_SITE_CODE,I
NVOICE_DATE,INVOICE_NUM,INVOICE_CURRENCY_CODE,INVOICE_AMOUNT,GL_
DATE,PAYMENT_CURRENCY_CODE,PAYMENT_CROSS_RATE_DATE,PAYMENT_CROSS
_RATE_TYPE,PAY_CURR_INVOICE_AMOUNT,PAYMENT_CROSS_RATE,FREIGHT_AM
OUNT,DESCRIPTION,USSGL_TRANSACTION_CODE,PROJECT,TASK,EXPENDITURE
676,461 1 676,461.0 0.4 4284880499
SELECT pv . vendor_name c_vendor_name , upper ( pv . vendor_name
) c_upper_vendor_name , decode ( : SORT_BY_ALTERNATE , 'Y' , up
per ( pv . vendor_name_alt ) , upper ( pv . vendor_name ) ) c_so
rt_vendor_name , inv . invoice_num c_invoice_num , inv . invoice
-------------------------------------------------------------
�SQL ordered by Reads for DB: PROD Instance: prod Snaps: 320 -321
-> End Disk Reads Threshold: 1000
Physical Reads Executions Reads per Exec % Total Hash Value
--------------- ------------ -------------- ------- ------------
417,835 18 23,213.1 28.5 1912750385
INSERT INTO AP_INVOICE_DISTRIBUTIONS ( INVOICE_ID,RCV_TRANSACTIO
N_ID,DIST_MATCH_TYPE,DIST_CODE_COMBINATION_ID,INVOICE_DISTRIBUTI
ON_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,ACCOUNTING_DATE,PERIOD_NA
ME,SET_OF_BOOKS_ID,AMOUNT,BASE_AMOUNT,EXCHANGE_DATE,EXCHANGE_RAT
E,EXCHANGE_RATE_TYPE,DESCRIPTION,TYPE_1099,TAX_CODE_ID,POSTED_FL
194,563 21 9,264.9 13.3 1540374549
SELECT TAX_ID FROM JA_IN_PO_LINE_LOCATION_TAXES A WHERE 3 =
(SELECT COUNT(*) FROM JA_IN_PO_LINE_LOCATION_TAXES B WHERE A.
TAX_LINE_NO >= B.TAX_LINE_NO AND TAX_TYPE = 'TDS' AND LINE_FOC
US_ID = :b1 AND A.LINE_FOCUS_ID = B.LINE_FOCUS_ID ) AND TAX_TY
PE = 'TDS'
185,839 22 8,447.2 12.7 2708275724
SELECT TAX_ID FROM JA_IN_PO_LINE_LOCATION_TAXES A WHERE 2 =
(SELECT COUNT(*) FROM JA_IN_PO_LINE_LOCATION_TAXES B WHERE A.
TAX_LINE_NO >= B.TAX_LINE_NO AND TAX_TYPE = 'TDS' AND LINE_FOC
US_ID = :b1 AND A.LINE_FOCUS_ID = B.LINE_FOCUS_ID ) AND TAX_TY
PE = 'TDS'
158,131 1 158,131.0 10.8 1677220809
SELECT pv . vendor_name c_vendor_name , upper ( pv . vendor_name
) c_upper_vendor_name , decode ( : SORT_BY_ALTERNATE , 'Y' , up
per ( pv . vendor_name_alt ) , upper ( pv . vendor_name ) ) c_so
rt_vendor_name , inv . invoice_num c_invoice_num , inv . invoice
_date c_invoice_date , bat.batch_id c_batch_id , inv.invoice_a
156,364 1 156,364.0 10.7 4284880499
SELECT pv . vendor_name c_vendor_name , upper ( pv . vendor_name
) c_upper_vendor_name , decode ( : SORT_BY_ALTERNATE , 'Y' , up
per ( pv . vendor_name_alt ) , upper ( pv . vendor_name ) ) c_so
rt_vendor_name , inv . invoice_num c_invoice_num , inv . invoice
_date c_invoice_date , bat.batch_id c_batch_id , inv.invoice_a
143,878 6 23,979.7 9.8 360277607
SELECT distinct request_id FROM mrp_sales_order_updates WHER
E process_status = 3 AND request_id IS NOT NULL AND err
or_message IS NULL
129,104 18 7,172.4 8.8 1419627117
SELECT TAX_ID FROM JA_IN_PO_LINE_LOCATION_TAXES A WHERE 1 =
(SELECT COUNT(*) FROM JA_IN_PO_LINE_LOCATION_TAXES B WHERE A.
TAX_LINE_NO >= B.TAX_LINE_NO AND TAX_TYPE = 'TDS' AND LINE_FOC
US_ID = :b1 AND A.LINE_FOCUS_ID = B.LINE_FOCUS_ID ) AND TAX_TY
PE = 'TDS'
91,649 11 8,331.7 6.2 3507355427
SELECT RECEIPT_NUMBER,RCV_SHIPMENT_LINE_NUMBER,RCV_TRANSACTION_D
ATE,PO_NUMBER,PO_RELEASE_NUM,PO_LINE_NUMBER,PO_LINE_LOCATION_NUM
BER,CLOSED_CODE,CLOSED_REASON,INVENTORY_ORGANIZATION_CODE,ITEM_D
ESCRIPTION,SUPPLIER_ITEM_NUMBER,SHIP_TO_LOCATION,BUYER,BILL_OF_L
ADING,PACKING_SLIP,CONTAINER_NUM,WAYBILL_AIRBILL_NUM,SHIPPED_DAT
64,936 3 21,645.3 4.4 3366543238
�SQL ordered by Reads for DB: PROD Instance: prod Snaps: 320 -321
-> End Disk Reads Threshold: 1000
Physical Reads Executions Reads per Exec % Total Hash Value
--------------- ------------ -------------- ------- ------------
SELECT AREA_OFF,CUS_NUM,CUS_NAME,MODEL,SUM(QTY) FROM ( SELECT ho
u.name AS AREA_OFF, RAC.CUSTOMER_NUMBER AS CUS_NUM, SUBSTR(RAC
.CUSTOMER_NAME,1,15) AS CUS_NAME, SUBSTR(MSI.DESCRIPTION,1,10) A
S MODEL, SUM(NVL(RCTLA.QUANTITY_INVOICED,0)) AS QTY FROM RA_
CUSTOMER_TRX_ALL rcta, RA_CUSTOMER_TRX_LINES_ALL rctla, HR_OPE
55,677 1 55,677.0 3.8 1380483559
SELECT ORDER_NUMBER,ORDER_NUMBER VALUE, ORDER_NUMBER DESCRIPTION
, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y'),
NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL),
'J'), 0) FROM HSPPL.HSPPL_DSTNCT_ORD_NUM WHERE ( WAREHOUSE_ID =
:A0 AND ORDER_TYPE = :A1) AND 'Y' = 'Y' AND TO_DATE(:A20, 'J')
50,479 1 50,479.0 3.4 2851223284
SELECT ORDER_NUMBER,SOLD_TO,ORDER_TYPE,CUSTOMER_NUMBER,SOLD_TO_C
ONTACT,CUST_PO_NUMBER,VERSION_NUMBER,ORDERED_DATE,EXPIRATION_DAT
E,REQUEST_DATE,PRICE_LIST,PRICING_DATE,ACCOUNTING_RULE,INVOICING
_RULE,TERMS,SHIP_TO,SHIP_TO_LOCATION,SHIP_TO_ADDRESS1,SHIP_TO_AD
DRESS2,SHIP_TO_ADDRESS3,SHIP_TO_ADDRESS4,SHIP_TO_ADDRESS5,SHIP_T
50,075 1 50,075.0 3.4 561736712
SELECT ORDER_NUMBER,ORDER_NUMBER VALUE, ORDER_NUMBER DESCRIPTION
, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y'),
NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL),
'J'), 0) FROM HSPPL.HSPPL_DSTNCT_ORD_NUM WHERE ( WAREHOUSE_ID =
:A0 AND ORDER_TYPE = :A1) AND 'Y' = 'Y' AND TO_DATE(:A20, 'J')
27,746 1 27,746.0 1.9 2272132875
SELECT DISTINCT I.INVOICE_ID,I.INVOICE_NUM FROM AP_INVOICES I,
AP_INVOICE_DISTRIBUTIONS D WHERE D.INVOICE_ID = I.INVOICE_ID A
ND I.SET_OF_BOOKS_ID = :b1 AND I.INVOICE_DATE BETWEEN NVL(:b2,S
YSDATE - 75000 ) AND NVL(:b3,SYSDATE + 75000 ) AND (I.CREATED_B
Y = :b4 OR :b4 = -999 ) AND (I.BATCH_ID = :b6 OR :b6 = -1 ) AN
27,711 1 27,711.0 1.9 1249885372
SELECT ROWID,ROW_ID,RECEIPT_NUM,LINE_NUM,TO_SUBINVENTORY,DESTINA
-------------------------------------------------------------
�SQL ordered by Executions for DB: PROD Instance: prod Snaps: 320 -321
-> End Executions Threshold: 100
Executions Rows Processed Rows per Exec Hash Value
------------ ---------------- ---------------- ------------
61,384 61,384 1.0 3479258525
SELECT MANUFACTURING,TRADING FROM JA_IN_HR_ORGANIZATION_UNITS
WHERE ORGANIZATION_ID = :b1 AND LOCATION_ID = :b2
51,820 51,820 1.0 310195357
SELECT INVENTORY_ORGANIZATION_ID ORG FROM HR_LOCATIONS WHERE
LOCATION_ID = :b1
35,229 6,752 0.2 373737229
SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WH
ERE PROFILE_OPTION_ID = :b1 AND APPLICATION_ID = :b2 AND LEVEL
_ID = :b3 AND LEVEL_VALUE = :b4
31,488 4,709 0.1 4757731
SELECT WIA.TYPE,WIA.FORMAT FROM WF_ITEM_ATTRIBUTES WIA WHERE
WIA.ITEM_TYPE = :b1 AND WIA.NAME = :b2
19,375 16,663 0.9 4105851458
SELECT PROFILE_OPTION_ID,APPLICATION_ID,SITE_ENABLED_FLAG,APP_EN
ABLED_FLAG,RESP_ENABLED_FLAG,USER_ENABLED_FLAG,USER_CHANGEABLE_F
LAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :b1
AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE,SYSDA
TE) >= SYSDATE
16,200 16,198 1.0 1038430954
SELECT FPI.STATUS,FPI.INDUSTRY,FPI.PRODUCT_VERSION,FOU.ORACLE_US
ERNAME,FPI.TABLESPACE,FPI.INDEX_TABLESPACE,FPI.TEMPORARY_TABLESP
ACE,FPI.SIZING_FACTOR FROM FND_PRODUCT_INSTALLATIONS FPI,FND_O
RACLE_USERID FOU,FND_APPLICATION FA WHERE FPI.APPLICATION_ID =
FA.APPLICATION_ID AND FPI.ORACLE_ID = FOU.ORACLE_ID AND FA.APP
14,115 14,114 1.0 2539484203
SELECT COUNT(*) FROM FV_OPERATING_UNITS_ALL WHERE ORGANIZATIO
N_ID = NVL(:b1,0) AND ENABLED = 'Y'
13,786 0 0.0 1830909701
SELECT HOI.ORG_INFORMATION_CONTEXT,HOI.ORG_INFORMATION1 FROM H
R_ORGANIZATION_INFORMATION HOI WHERE HOI.ORG_INFORMATION_CONTEX
T = 'GHR_US_ORG_INFORMATION' AND HOI.ORGANIZATION_ID = :b1
13,186 13,183 1.0 4059714361
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#
,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N
VL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3
12,752 938 0.1 2622125724
SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WH
ERE PROFILE_OPTION_ID = :b1 AND APPLICATION_ID = :b2 AND LEVEL
_ID = 10003 AND LEVEL_VALUE = :b3 AND LEVEL_VALUE_APPLICATION_
ID = :b4
9,601 9,601 1.0 2972848306
SELECT LOCATION_ID FROM JA_IN_SUBINV_LOCATIONS_DTL WHERE ORGA
NIZATION_ID = :b1 AND SUB_INVENTORY_NAME = :b2
�SQL ordered by Executions for DB: PROD Instance: prod Snaps: 320 -321
-> End Executions Threshold: 100
Executions Rows Processed Rows per Exec Hash Value
------------ ---------------- ---------------- ------------
7,321 7,321 1.0 577235476
SELECT WA.TYPE,WA.RERUN,WA.COST,WA.ERROR_ITEM_TYPE,WA.ERROR_PROC
ESS,WA.EXPAND_ROLE,WA.FUNCTION,NVL(WA.FUNCTION_TYPE,'PL/SQL'),WA
.MESSAGE,WA.ITEM_TYPE,WA.EVENT_NAME,WA.DIRECTION,WPA.PERFORM_ROL
E,WPA.PERFORM_ROLE_TYPE,WPA.START_END FROM WF_PROCESS_ACTIVITI
ES WPA,WF_ACTIVITIES WA WHERE WPA.INSTANCE_ID = :b1 AND WPA.AC
6,660 6,660 1.0 2108922784
declare dummy boolean;begin fnd_profile.get_specific(:name, :use
rid, :respid, :applid, :val, dummy);end;
6,528 6,697 1.0 1473376610
select /*+ index (recom MRP_RECOMMENDATIONS_N1) +*/ DECODE(fi
rm_planned_type,1,TO_CHAR(firm_date,'j'),TO_CHAR(new_schedule_da
te,'j')) ,NVL(quantity_in_process,0) ,NVL(implemented_quantity,0
) ,DECODE(firm_planned_type,1,firm_quantity,new_order_quantity)
,transaction_id ,recom.rowid from mtl_parameters param ,mrp_re
5,612 5,531 1.0 1117347357
SELECT CURRENCY_CODE FROM GL_SETS_OF_BOOKS WHERE SET_OF_BOOKS
_ID = :b1
4,820 4,816 1.0 3969582653
SELECT WAT1.TO_PROCESS_ACTIVITY FROM WF_ACTIVITY_TRANSITIONS W
AT1 WHERE WAT1.FROM_PROCESS_ACTIVITY = :b1 AND (WAT1.RESULT_CO
DE IN ( :b2,:b3 ) OR (WAT1.RESULT_CODE = :b4 AND NOT EXISTS (
SELECT NULL FROM WF_ACTIVITY_TRANSITIONS WAT2 WHERE WAT2.FR
OM_PROCESS_ACTIVITY = :b1 AND WAT2.RESULT_CODE = :b2 ) ))
3,926 3,926 1.0 2151823199
SELECT WPA.PROCESS_ITEM_TYPE,WPA.PROCESS_NAME FROM WF_PROCESS_
ACTIVITIES WPA WHERE WPA.INSTANCE_ID = :b1
3,053 3,053 1.0 727490397
insert into mrp_schedule_consumptions(transaction_id,relief_type
,disposition_type,disposition_id,line_num,last_update_date,last_
updated_by,creation_date,created_by,last_update_login,order_date
,order_quantity,relief_quantity,schedule_date) values (:b0,:b1,:
b2,:b3,DECODE(:b2,3,:b5,2,:b5,5,:b5,6,:b5,7,:b5,8,:b5,null ),sys
3,053 3,053 1.0 1159631231
select TO_CHAR(TO_DATE(:b0),'j') into :b1 from dual
3,053 3,053 1.0 4118936712
update mrp_recommendations set implemented_quantity=:b0,quantit
y_in_process=:b1,last_update_date=sysdate ,last_updated_by=:b2 w
here rowid=:b3
2,959 2,959 1.0 885722162
(SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE UPPE
-------------------------------------------------------------
�SQL ordered by Sharable Memory for DB: PROD Instance: prod Snaps: 320 -321
-> End Sharable Memory Threshold: 1048576
Sharable Mem (b) Executions % Total Hash Value
---------------- ------------ ------- ------------
2,911,044 17 0.4 2556253448
SELECT Pv . vendor_id vendor_id , Pvsites . vendor_site_id vendo
r_site_id , msi . segment1 Item_Id , msi . description Item_Desc
, ploc . need_by_date Reqd_Date , ploc . quantity - ploc . quan
tity_received Reqd_Qty , pha . segment1 || ' - ' || pra . releas
e_num PO_Rel_Num , hla . name Ship_Loc , pv . vendor_name Vendor
1,617,624 14 0.2 2961866058
select * from rcv_vrc_txs_v where shipment_header_id = :1 order
by transaction_id
1,408,691 5 0.2 3001287621
SELECT ROW_ID,DEFAULT_TAX_EXEMPT_FLAG,APBA_INACTIVE_DATE,B
S_BATCH_SOURCE_NAME,TRX_NUMBER,SOA_AGREEMENT_NAME,RAB_BATCH_NAME
,RAC_BILL_TO_CUSTOMER_NAME,RAC_BILL_TO_CUSTOMER_NUM,RAA_BILL_TO_
CONCAT_ADDRESS,RAA_BILL_TO_ADDRESS1,RAA_BILL_TO_ADDRESS2,RAA_BIL
L_TO_ADDRESS3,RAA_BILL_TO_ADDRESS3_DB,RAA_BILL_TO_CITY,FT_BILL_T
1,408,053 3 0.2 3256840998
SELECT ROW_ID,DEFAULT_TAX_EXEMPT_FLAG,APBA_INACTIVE_DATE,BS_BATC
H_SOURCE_NAME,TRX_NUMBER,SOA_AGREEMENT_NAME,RAB_BATCH_NAME,RAC_B
ILL_TO_CUSTOMER_NAME,RAC_BILL_TO_CUSTOMER_NUM,RAA_BILL_TO_CONCAT
_ADDRESS,RAA_BILL_TO_ADDRESS1,RAA_BILL_TO_ADDRESS2,RAA_BILL_TO_A
DDRESS3,RAA_BILL_TO_ADDRESS3_DB,RAA_BILL_TO_CITY,FT_BILL_TO_COUN
1,151,810 6 0.1 1008904534
SELECT ROW_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPD
ATE_LOGIN,PO_RELEASE_FLAG,PO_NUM,LAST_UPDATED_BY,PRINT_COUNT,PRI
NTED_DATE,COMMENTS,REVISED_DATE,FROZEN_FLAG,USER_HOLD_FLAG,CANCE
L_FLAG,CLOSED_CODE,CLOSED_CODE_DSP,CLOSED_DATE,APPROVED_DATE,SHI
P_TO_LOCATION,SHIP_TO_LOCATION_ID,BILL_TO_LOCATION,BILL_TO_LOCAT
1,137,903 9 0.1 3462510090
SELECT 1 FROM SYS.DUAL WHERE EXISTS (SELECT NULL FROM WF
_USER_ROLES WHERE USER_ORIG_SYSTEM = :b1 AND USER_ORIG_SYSTEM_
ID = :b2 AND USER_NAME = :b3 AND ROLE_ORIG_SYSTEM = :b4 AND R
OLE_ORIG_SYSTEM_ID = :b5 AND ROLE_NAME = :b6 UNION ALL SELECT
NULL FROM WF_USER_ROLES WHERE USER_ORIG_SYSTEM = :b1 AND U
-------------------------------------------------------------
�Instance Activity Stats for DB: PROD Instance: prod Snaps: 320 -321
Statistic Total per Second per Trans
--------------------------------- ---------------- ------------ ------------
CPU used by this session 255,439 152.1 53.7
CPU used when call started 255,419 152.1 53.7
CR blocks created 14,221 8.5 3.0
DBWR buffers scanned 268,485 159.9 56.4
DBWR checkpoint buffers written 4,076 2.4 0.9
DBWR checkpoints 2 0.0 0.0
DBWR free buffers found 261,446 155.7 54.9
DBWR lru scans 953 0.6 0.2
DBWR make free requests 969 0.6 0.2
DBWR summed scan depth 268,485 159.9 56.4
DBWR transaction table writes 19 0.0 0.0
DBWR undo block writes 4,070 2.4 0.9
Parallel operations downgraded to 2 0.0 0.0
SQL*Net roundtrips to/from client 291,183 173.4 61.2
background checkpoints completed 0 0.0 0.0
background checkpoints started 1 0.0 0.0
background timeouts 1,389 0.8 0.3
branch node splits 1 0.0 0.0
buffer is not pinned count 91,837,758 54,697.9 19,297.7
buffer is pinned count 159,781,308 95,164.6 33,574.6
bytes received via SQL*Net from c 51,592,272 30,728.0 10,841.0
bytes sent via SQL*Net to client 63,158,051 37,616.5 13,271.3
calls to get snapshot scn: kcmgss 595,835 354.9 125.2
calls to kcmgas 9,895 5.9 2.1
calls to kcmgcs 1,811 1.1 0.4
change write time 298 0.2 0.1
cleanouts and rollbacks - consist 11,427 6.8 2.4
cleanouts only - consistent read 577 0.3 0.1
cluster key scan block gets 138,777 82.7 29.2
cluster key scans 64,242 38.3 13.5
commit cleanout failures: block l 647 0.4 0.1
commit cleanout failures: callbac 3 0.0 0.0
commit cleanout failures: cannot 2 0.0 0.0
commit cleanouts 31,495 18.8 6.6
commit cleanouts successfully com 30,843 18.4 6.5
consistent changes 153,039 91.2 32.2
consistent gets 149,622,515 89,114.1 31,439.9
current blocks converted for CR
cursor authentications 407 0.2 0.1
data blocks consistent reads - un 132,075 78.7 27.8
db block changes 391,659 233.3 82.3
db block gets 2,485,667 1,480.4 522.3
deferred (CURRENT) block cleanout 8,592 5.1 1.8
dirty buffers inspected 582 0.4 0.1
enqueue conversions 1,144 0.7 0.2
enqueue releases 49,454 29.5 10.4
enqueue requests 49,920 29.7 10.5
enqueue timeouts 459 0.3 0.1
enqueue waits 3 0.0 0.0
exchange deadlocks 0 0.0 0.0
execute count 586,745 349.5 123.3
free buffer inspected 31,661 18.9 6.7
free buffer requested 1,441,914 858.8 303.0
hot buffers moved to head of LRU 184,324 109.8 38.7
immediate (CR) block cleanout app 12,004 7.2 2.5
immediate (CURRENT) block cleanou 3,010 1.8 0.6
�Instance Activity Stats for DB: PROD Instance: prod Snaps: 320 -321
Statistic Total per Second per Trans
--------------------------------- ---------------- ------------ ------------
index fast full scans (full) 2 0.0 0.0
leaf node splits 324 0.2 0.1
logons cumulative 513 0.3 0.1
logons current
messages received 13,797 8.2 2.9
messages sent 13,797 8.2 2.9
no buffer to keep pinned count 44,750,234 26,652.9 9,403.3
no work - consistent read gets 43,176,550 25,715.6 9,072.6
opened cursors cumulative 81,233 48.4 17.1
opened cursors current
parse count (hard) 474 0.3 0.1
parse count (total) 163,225 97.2 34.3
parse time cpu 1,823 1.1 0.4
parse time elapsed 5,622 3.4 1.2
physical reads 1,467,007 873.7 308.3
physical reads direct 48,951 29.2 10.3
physical reads direct (lob) 588 0.4 0.1
physical writes 63,424 37.8 13.3
physical writes direct 51,210 30.5 10.8
physical writes direct (lob) 588 0.4 0.1
physical writes non checkpoint 61,758 36.8 13.0
pinned buffers inspected 30,206 18.0 6.4
prefetched blocks 924,045 550.4 194.2
prefetched blocks aged out before 170 0.1 0.0
process last non-idle time 10,583,522,324 6,303,467.7 2,223,896.3
recursive calls 1,396,189 831.6 293.4
recursive cpu usage 44,330 26.4 9.3
redo blocks written 120,433 71.7 25.3
redo buffer allocation retries 17 0.0 0.0
redo entries 200,642 119.5 42.2
redo log space requests 157 0.1 0.0
redo log space wait time 14,722 8.8 3.1
redo ordering marks 3 0.0 0.0
redo size 58,447,976 34,811.2 12,281.6
redo synch time 8,505 5.1 1.8
redo synch writes 4,012 2.4 0.8
redo wastage 1,388,140 826.8 291.7
redo write time 9,112 5.4 1.9
redo writer latching time 8 0.0 0.0
redo writes 5,537 3.3 1.2
rollback changes - undo records a 202 0.1 0.0
rollbacks only - consistent read 2,972 1.8 0.6
rows fetched via callback 18,324,352 10,913.9 3,850.5
session connect time 10,583,522,324 6,303,467.7 2,223,896.3
session cursor cache count 160 0.1 0.0
session cursor cache hits 109,191 65.0 22.9
session logical reads 152,107,696 90,594.2 31,962.1
session pga memory 1,551,486,672 924,054.0 326,011.1
session pga memory max 1,800,239,860 1,072,209.6 378,281.1
session uga memory 9,087,476 5,412.4 1,909.5
session uga memory max 496,959,492 295,985.4 104,425.2
sorts (disk) 7 0.0 0.0
sorts (memory) 51,263 30.5 10.8
sorts (rows) 1,590,389 947.2 334.2
summed dirty queue length 45 0.0 0.0
switch current to new buffer
�Instance Activity Stats for DB: PROD Instance: prod Snaps: 320 -321
Statistic Total per Second per Trans
--------------------------------- ---------------- ------------ ------------
table fetch by rowid 113,838,726 67,801.5 23,920.7
table fetch continued row 1,288,064 767.2 270.7
table scan blocks gotten 9,099,193 5,419.4 1,912.0
table scan rows gotten 186,130,117 110,857.7 39,111.2
table scans (long tables) 125 0.1 0.0
table scans (short tables) 500,155 297.9 105.1
total file opens 5,377 3.2 1.1
transaction rollbacks 4 0.0 0.0
transaction tables consistent rea 0 0.0 0.0
transaction tables consistent rea 0 0.0 0.0
user calls 274,356 163.4 57.7
user commits 4,379 2.6 0.9
user rollbacks 380 0.2 0.1
write clones created in foregroun 2 0.0 0.0
-------------------------------------------------------------
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
JAD
157,053 94 91.3 3.8 137 0 209,209 45.4
INVD
98,362 59 79.6 2.2 424 0 1,177 60.9
ARD
72,767 43 87.7 2.3 18 0 2,382 69.1
POD
46,056 27 78.1 3.3 388 0 7 65.7
APD
27,661 16 84.3 1.1 108 0 5 58.0
MRPD
19,821 12 54.4 7.3 269 0 0 0.0
WSHD
14,691 9 86.7 1.0 24 0 3,246 67.0
APPLSYSD
10,931 7 91.6 4.3 946 1 31 455.5
ARX
9,614 6 52.4 1.0 111 0 452 6.0
TEMP
4,826 3 5.3 9.8 4,163 2 117 51.5
SYSTEM
7,154 4 93.9 2.5 95 0 931 63.7
INVX
4,653 3 115.7 1.1 1,436 1 7 252.9
GLX
5,027 3 57.6 1.0 156 0 0 0.0
POX
4,706 3 91.8 1.1 390 0 0 0.0
GLD
4,663 3 106.3 1.0 112 0 7 110.0
APX
4,182 2 84.6 1.0 206 0 4 52.5
RBS
234 0 173.8 1.0 4,150 2 1 0.0
ONTD
3,938 2 72.3 3.6 52 0 0 0.0
WIPD
3,349 2 104.4 1.9 46 0 294 69.7
MRPX
1,017 1 79.8 1.0 1,712 1 1 0.0
APPLSYSX
1,834 1 100.9 1.0 820 0 4 140.0
TOOLS
1,399 1 81.7 1.0 285 0 0 0.0
HRX
1,604 1 85.8 1.0 1 0 0 0.0
JAX
1,309 1 109.5 1.0 284 0 1 0.0
BENX
1,383 1 86.0 1.0 1 0 0 0.0
QPD
1,240 1 35.7 4.7 1 0 0 0.0
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
ONTX
966 1 93.3 1.0 102 0 0 0.0
BOMD
814 0 83.5 2.7 10 0 0 0.0
PAX
587 0 71.2 1.0 1 0 0 0.0
JTFX
550 0 86.0 1.0 1 0 0 0.0
WSHX
402 0 86.1 1.1 76 0 6 123.3
AMSX
407 0 137.9 1.0 1 0 0 0.0
BOMX
402 0 101.1 1.0 5 0 2 30.0
OSMX
403 0 99.6 1.0 1 0 0 0.0
BIMX
395 0 103.4 1.0 1 0 0 0.0
CSX
348 0 99.7 1.0 1 0 0 0.0
IGSX
313 0 70.0 1.0 1 0 0 0.0
QPX
299 0 43.1 1.0 1 0 0 0.0
FAX
287 0 92.8 1.0 0 0 0 0.0
GRX
285 0 59.5 1.0 1 0 0 0.0
OKCX
285 0 95.4 1.0 1 0 0 0.0
OEX
284 0 79.8 1.0 1 0 0 0.0
CNX
277 0 102.8 1.0 1 0 0 0.0
XTRX
252 0 120.0 1.0 1 0 0 0.0
WIPX
203 0 114.8 1.0 48 0 0 0.0
PSBX
227 0 64.6 1.0 1 0 0 0.0
CZX
188 0 87.7 1.0 1 0 0 0.0
JLX
165 0 43.2 1.0 1 0 0 0.0
MSCX
155 0 54.0 1.0 1 0 0 0.0
PNX
150 0 105.0 1.0 1 0 0 0.0
ICXX
135 0 80.5 1.0 15 0 0 0.0
HRD
146 0 72.7 1.4 1 0 23 46.1
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
XNPX
136 0 81.8 1.0 1 0 0 0.0
XDPX
134 0 101.6 1.0 1 0 0 0.0
OTAX
124 0 56.0 1.0 1 0 0 0.0
PSPX
123 0 81.1 1.0 1 0 0 0.0
FVX
119 0 74.9 1.0 1 0 0 0.0
GMFX
118 0 66.4 1.0 1 0 0 0.0
FPTX
116 0 80.9 1.0 1 0 0 0.0
GMIX
107 0 66.1 1.0 1 0 0 0.0
GMLX
103 0 59.0 1.0 1 0 0 0.0
BSCX
100 0 99.9 1.0 1 0 0 0.0
CSFD
99 0 93.8 1.0 1 0 0 0.0
GMSX
99 0 92.5 1.0 1 0 0 0.0
HXTX
98 0 70.3 1.0 1 0 0 0.0
AMVX
91 0 122.0 1.0 1 0 0 0.0
HSPPL
90 0 114.4 6.5 2 0 0 0.0
ASOX
89 0 84.0 1.0 1 0 0 0.0
ECX
84 0 96.7 1.0 1 0 0 0.0
QAD
81 0 92.3 3.0 2 0 0 0.0
GMLD
81 0 60.0 1.0 1 0 0 0.0
AXX
80 0 107.6 1.0 1 0 0 0.0
IGIX
75 0 68.9 1.0 1 0 0 0.0
RGX
73 0 106.7 1.0 0 0 0 0.0
CSPX
71 0 83.7 1.0 1 0 0 0.0
OZFX
71 0 80.7 1.0 1 0 0 0.0
IGWX
68 0 60.1 1.0 1 0 0 0.0
GMPX
62 0 66.8 1.0 1 0 0 0.0
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
QAX
61 0 107.4 1.0 1 0 0 0.0
CSCX
59 0 70.8 1.0 1 0 0 0.0
WMSX
58 0 90.0 1.0 1 0 0 0.0
PVX
54 0 61.7 1.0 1 0 0 0.0
ALRX
52 0 131.5 1.0 0 0 0 0.0
ASOD
45 0 0.0 1.0 5 0 0 0.0
IEUX
49 0 56.7 1.0 1 0 0 0.0
ASGX
48 0 120.8 1.0 1 0 0 0.0
BISX
47 0 106.0 1.0 1 0 0 0.0
JTFD
43 0 74.9 1.0 1 0 0 0.0
IBYX
41 0 58.5 1.0 1 0 0 0.0
GMDD
39 0 71.5 1.0 1 0 0 0.0
IESX
39 0 80.0 1.0 1 0 0 0.0
MSDX
38 0 64.2 1.0 1 0 0 0.0
ENGX
37 0 58.4 1.0 1 0 0 0.0
IEBX
37 0 67.6 1.0 1 0 0 0.0
AKX
36 0 115.6 1.0 1 0 0 0.0
ICXD
32 0 75.6 1.4 5 0 0 0.0
IPAX
36 0 53.1 1.0 1 0 0 0.0
CEX
34 0 122.6 1.0 1 0 0 0.0
CZD
33 0 89.1 1.0 1 0 0 0.0
WSMX
33 0 76.4 1.0 1 0 0 0.0
GMDX
32 0 21.9 1.0 1 0 0 0.0
GMAX
31 0 73.2 1.0 1 0 0 0.0
BIXX
30 0 100.0 1.0 1 0 0 0.0
CRPX
30 0 94.3 1.0 1 0 0 0.0
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
PJMX
30 0 41.3 1.0 1 0 0 0.0
CCTX
29 0 114.8 1.0 1 0 0 0.0
CND
27 0 102.6 1.0 1 0 0 0.0
IBEX
27 0 92.2 1.0 1 0 0 0.0
IEXX
27 0 75.9 1.0 1 0 0 0.0
RLAX
25 0 69.6 1.0 1 0 0 0.0
SSPX
25 0 118.4 1.0 1 0 0 0.0
IGID
24 0 61.3 1.0 1 0 0 0.0
RLMX
24 0 78.8 1.0 1 0 0 0.0
BICX
23 0 69.6 1.0 1 0 0 0.0
CTXD
12 0 98.3 1.0 11 0 1 20.0
BILX
21 0 44.8 1.0 1 0 0 0.0
CSDX
21 0 43.3 1.0 1 0 0 0.0
IEMX
21 0 50.5 1.0 1 0 0 0.0
CUNX
20 0 36.5 1.0 1 0 0 0.0
ASGD
19 0 19.5 1.0 1 0 0 0.0
CSSX
19 0 66.3 1.0 1 0 0 0.0
GMPD
19 0 46.8 1.0 1 0 0 0.0
IEOX
19 0 63.2 1.0 1 0 0 0.0
VEAX
19 0 82.1 1.0 1 0 0 0.0
ASTX
17 0 68.8 1.0 1 0 0 0.0
JEX
17 0 18.2 1.0 1 0 0 0.0
OKSX
17 0 81.2 1.0 1 0 0 0.0
GMED
16 0 22.5 1.0 1 0 0 0.0
VEHX
16 0 29.4 1.0 1 0 0 0.0
XDPD
16 0 40.6 1.0 1 0 0 0.0
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
OKCD
15 0 77.3 1.0 1 0 0 0.0
AZX
14 0 87.1 1.0 1 0 0 0.0
XNCX
14 0 56.4 1.0 1 0 0 0.0
AXD
13 0 13.8 1.0 1 0 2 5.0
GMEX
13 0 18.5 1.0 1 0 0 0.0
IBAX
13 0 66.2 1.0 1 0 0 0.0
MSCD
13 0 17.7 1.0 1 0 0 0.0
AKD
12 0 24.2 1.0 1 0 0 0.0
GMID
12 0 30.0 1.0 1 0 0 0.0
IEMD
12 0 27.5 1.0 1 0 0 0.0
JGX
12 0 13.3 1.0 1 0 0 0.0
OED
11 0 3.6 1.0 2 0 0 0.0
PMIX
12 0 32.5 1.0 1 0 0 0.0
XNPD
12 0 52.5 1.0 1 0 0 0.0
BEND
11 0 22.7 1.0 1 0 0 0.0
CSRX
11 0 30.0 1.0 1 0 0 0.0
OKEX
11 0 7.3 1.0 1 0 0 0.0
FEMX
10 0 92.0 1.0 1 0 0 0.0
IBED
10 0 15.0 1.0 1 0 0 0.0
IBUD
10 0 32.0 1.0 1 0 0 0.0
PSAX
10 0 3.0 1.0 1 0 0 0.0
CRPD
9 0 0.0 1.0 1 0 0 0.0
CSRD
9 0 0.0 1.0 1 0 0 0.0
CUAD
9 0 0.0 1.0 1 0 0 0.0
CUAX
9 0 0.0 1.0 1 0 0 0.0
CUED
9 0 0.0 1.0 1 0 0 0.0
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
CUEX
9 0 0.0 1.0 1 0 0 0.0
CUFD
9 0 0.0 1.0 1 0 0 0.0
CUFX
9 0 0.0 1.0 1 0 0 0.0
CUID
9 0 0.0 1.0 1 0 0 0.0
CUIX
9 0 0.0 1.0 1 0 0 0.0
CUND
9 0 0.0 1.0 1 0 0 0.0
CUPD
9 0 0.0 1.0 1 0 0 0.0
CUPX
9 0 0.0 1.0 1 0 0 0.0
CUSD
9 0 0.0 1.0 1 0 0 0.0
CUSX
9 0 0.0 1.0 1 0 0 0.0
EAMD
9 0 0.0 1.0 1 0 0 0.0
EAMX
9 0 0.0 1.0 1 0 0 0.0
ENID
9 0 0.0 1.0 1 0 0 0.0
ENIX
9 0 0.0 1.0 1 0 0 0.0
FTED
9 0 0.0 1.0 1 0 0 0.0
GMAD
9 0 68.9 1.0 1 0 0 0.0
GMSD
9 0 0.0 1.0 1 0 0 0.0
HXTD
9 0 0.0 1.0 1 0 0 0.0
IESD
9 0 46.7 1.0 1 0 0 0.0
IEUD
9 0 0.0 1.0 1 0 0 0.0
IEXD
9 0 0.0 1.0 1 0 0 0.0
IGSD
9 0 0.0 1.0 1 0 0 0.0
IGWD
9 0 0.0 1.0 1 0 0 0.0
IPDD
9 0 0.0 1.0 1 0 0 0.0
IPDX
9 0 0.0 1.0 1 0 0 0.0
ITGD
9 0 0.0 1.0 1 0 0 0.0
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
ITGX
9 0 0.0 1.0 1 0 0 0.0
JGD
9 0 0.0 1.0 1 0 0 0.0
JLD
9 0 0.0 1.0 1 0 0 0.0
OKED
9 0 0.0 1.0 1 0 0 0.0
OKRD
9 0 0.0 1.0 1 0 0 0.0
OKRX
9 0 0.0 1.0 1 0 0 0.0
OZSX
9 0 0.0 1.0 1 0 0 0.0
PJMD
9 0 0.0 1.0 1 0 0 0.0
POSD
9 0 0.0 1.0 1 0 0 0.0
POSX
9 0 0.0 1.0 1 0 0 0.0
PSBD
9 0 0.0 1.0 1 0 0 0.0
PSPD
9 0 0.0 1.0 1 0 0 0.0
PVD
9 0 5.6 1.0 1 0 0 0.0
RHXD
9 0 0.0 1.0 1 0 0 0.0
RHXX
9 0 0.0 1.0 1 0 0 0.0
RLAD
9 0 0.0 1.0 1 0 0 0.0
SSPD
9 0 0.0 1.0 1 0 0 0.0
VEHD
9 0 0.0 1.0 1 0 0 0.0
ASLD
8 0 0.0 1.0 1 0 0 0.0
ASLX
8 0 0.0 1.0 1 0 0 0.0
BILD
8 0 0.0 1.0 1 0 0 0.0
BIXD
8 0 0.0 1.0 1 0 0 0.0
ENGD
8 0 0.0 1.0 1 0 0 0.0
FLMD
8 0 0.0 1.0 1 0 0 0.0
FLMX
8 0 0.0 1.0 1 0 0 0.0
FTEX
8 0 0.0 1.0 1 0 0 0.0
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
FVD
8 0 0.0 1.0 1 0 0 0.0
GMFD
8 0 37.5 1.0 1 0 0 0.0
HXCD
8 0 0.0 1.0 1 0 0 0.0
HXCX
8 0 0.0 1.0 1 0 0 0.0
IBAD
8 0 0.0 1.0 1 0 0 0.0
IBPD
8 0 0.0 1.0 1 0 0 0.0
IBPX
8 0 0.0 1.0 1 0 0 0.0
IBUX
8 0 0.0 1.0 1 0 0 0.0
IBYD
8 0 0.0 1.0 1 0 0 0.0
IEBD
8 0 0.0 1.0 1 0 0 0.0
IGCD
8 0 0.0 1.0 1 0 0 0.0
IGCX
8 0 0.0 1.0 1 0 0 0.0
IGFD
8 0 0.0 1.0 1 0 0 0.0
IGFX
8 0 0.0 1.0 1 0 0 0.0
IPAD
8 0 0.0 1.0 1 0 0 0.0
JED
8 0 0.0 1.0 1 0 0 0.0
MFGD
8 0 0.0 1.0 1 0 0 0.0
MFGX
8 0 0.0 1.0 1 0 0 0.0
MSDD
8 0 0.0 1.0 1 0 0 0.0
MSOD
8 0 0.0 1.0 1 0 0 0.0
MSOX
8 0 0.0 1.0 1 0 0 0.0
MSRD
8 0 0.0 1.0 1 0 0 0.0
MSRX
8 0 0.0 1.0 1 0 0 0.0
OTAD
8 0 0.0 1.0 1 0 0 0.0
OZFD
8 0 0.0 1.0 1 0 0 0.0
OZPD
8 0 0.0 1.0 1 0 0 0.0
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
OZPX
8 0 0.0 1.0 1 0 0 0.0
OZSD
8 0 0.0 1.0 1 0 0 0.0
PSAD
8 0 0.0 1.0 1 0 0 0.0
XLAX
8 0 7.5 1.0 1 0 0 0.0
AMSD
7 0 58.6 1.0 1 0 0 0.0
GRD
7 0 0.0 1.0 1 0 0 0.0
HRIX
7 0 72.9 1.0 1 0 0 0.0
PMID
7 0 0.0 1.0 1 0 0 0.0
RLMD
7 0 0.0 1.0 1 0 0 0.0
VEAD
7 0 0.0 1.0 1 0 0 0.0
XLAD
7 0 0.0 1.0 1 0 0 0.0
XNSX
7 0 40.0 1.0 1 0 0 0.0
AMVD
6 0 56.7 1.0 1 0 0 0.0
CSD
7 0 87.1 1.0 0 0 0 0.0
IEOD
6 0 0.0 1.0 1 0 0 0.0
FPTD
5 0 0.0 1.0 1 0 0 0.0
ASFD
4 0 0.0 1.0 1 0 0 0.0
ASFX
4 0 0.0 1.0 1 0 0 0.0
ASTD
4 0 0.0 1.0 1 0 0 0.0
CSFX
4 0 2.5 1.0 1 0 0 0.0
CSPD
4 0 0.0 1.0 1 0 0 0.0
OKXD
4 0 0.0 1.0 1 0 0 0.0
OKXX
4 0 0.0 1.0 1 0 0 0.0
OSMD
4 0 82.5 1.0 1 0 0 0.0
XNCD
4 0 0.0 1.0 1 0 0 0.0
XNMD
4 0 0.0 1.0 1 0 0 0.0
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
XNMX
4 0 0.0 1.0 1 0 0 0.0
XNSD
4 0 0.0 1.0 1 0 0 0.0
BICD
3 0 0.0 1.0 1 0 0 0.0
BIMD
3 0 0.0 1.0 1 0 0 0.0
CSCD
3 0 0.0 1.0 1 0 0 0.0
CSDD
3 0 0.0 1.0 1 0 0 0.0
CSSD
3 0 0.0 1.0 1 0 0 0.0
HRID
3 0 0.0 1.0 1 0 0 0.0
ISCD
3 0 0.0 1.0 1 0 0 0.0
ISCX
3 0 0.0 1.0 1 0 0 0.0
MED
3 0 0.0 1.0 1 0 0 0.0
MEX
3 0 0.0 1.0 1 0 0 0.0
OKSD
3 0 0.0 1.0 1 0 0 0.0
FIID
2 0 0.0 1.0 1 0 0 0.0
FIIX
2 0 0.0 1.0 1 0 0 0.0
MWAD
2 0 0.0 1.0 1 0 0 0.0
MWAX
2 0 0.0 1.0 1 0 0 0.0
OPID
2 0 0.0 1.0 1 0 0 0.0
OPIX
2 0 0.0 1.0 1 0 0 0.0
PAD
2 0 125.0 1.0 1 0 0 0.0
POAD
2 0 0.0 1.0 1 0 0 0.0
POAX
2 0 0.0 1.0 1 0 0 0.0
POMD
2 0 0.0 1.0 1 0 0 0.0
POMX
2 0 0.0 1.0 1 0 0 0.0
WMSD
2 0 0.0 1.0 1 0 0 0.0
WPSD
2 0 0.0 1.0 1 0 0 0.0
�Tablespace IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
WPSX
2 0 0.0 1.0 1 0 0 0.0
WSMD
2 0 0.0 1.0 1 0 0 0.0
ABMD
1 0 0.0 1.0 1 0 0 0.0
ABMX
1 0 0.0 1.0 1 0 0 0.0
BSCD
1 0 0.0 1.0 1 0 0 0.0
CED
1 0 0.0 1.0 1 0 0 0.0
EAAD
1 0 0.0 1.0 1 0 0 0.0
EAAX
1 0 0.0 1.0 1 0 0 0.0
EVMD
1 0 0.0 1.0 1 0 0 0.0
EVMX
1 0 0.0 1.0 1 0 0 0.0
FAD
2 0 40.0 1.0 0 0 0 0.0
FEMD
1 0 0.0 1.0 1 0 0 0.0
FRMD
1 0 0.0 1.0 1 0 0 0.0
FRMX
1 0 0.0 1.0 1 0 0 0.0
AZD
0 0 0.0 1 0 0 0.0
BISD
0 0 0.0 1 0 0 0.0
CCTD
1 0 50.0 1.0 0 0 0 0.0
ECD
0 0 0.0 1 0 0 0.0
ECXD
0 0 0.0 1 0 0 0.0
ECXX
0 0 0.0 1 0 0 0.0
PND
0 0 0.0 1 0 0 0.0
XTRD
0 0 0.0 1 0 0 0.0
-------------------------------------------------------------
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
ABMD E:\ORACLE\PRODDATA\ABMD01.DBF
1 0 0.0 1.0 1 0 0
ABMX E:\ORACLE\PRODDATA\ABMX01.DBF
1 0 0.0 1.0 1 0 0
AKD E:\ORACLE\PRODDATA\AKD01.DBF
12 0 24.2 1.0 1 0 0
AKX E:\ORACLE\PRODDATA\AKX01.DBF
36 0 115.6 1.0 1 0 0
ALRX E:\ORACLE\PRODDATA\ALRX01.DBF
52 0 131.5 1.0 0 0 0
AMSD E:\ORACLE\PRODDATA\AMSD01.DBF
7 0 58.6 1.0 1 0 0
AMSX E:\ORACLE\PRODDATA\AMSX01.DBF
407 0 137.9 1.0 1 0 0
AMVD E:\ORACLE\PRODDATA\AMVD01.DBF
6 0 56.7 1.0 1 0 0
AMVX E:\ORACLE\PRODDATA\AMVX01.DBF
91 0 122.0 1.0 1 0 0
APD E:\ORACLE\PRODDATA\APD01.DBF
5,477 3 77.0 1.0 6 0 0
E:\ORACLE\PRODDATA\APD02.DBF
4,348 3 90.5 1.0 4 0 0
E:\ORACLE\PRODDATA\APD03.DBF
7,225 4 77.9 1.3 90 0 5 58.0
F:\ORACLE\PRODDATA\AP04.DBF
6,367 4 88.8 1.1 3 0 0
F:\ORACLE\PRODDATA\APD05.DBF
4,244 3 91.4 1.0 5 0 0
APPLSYSD E:\ORACLE\PRODDATA\APPLSYSD01.DBF
3,033 2 89.2 3.9 93 0 13 43.8
E:\ORACLE\PRODDATA\APPLSYSD02.DBF
2,688 2 86.5 4.5 236 0 14 954.3
E:\ORACLE\PRODDATA\APPLSYSD03.DBF
968 1 106.2 4.3 51 0 0
E:\ORACLE\PRODDATA\APPLSYSD04.DBF
2,024 1 90.5 5.3 32 0 0
F:\ORACLE\PRODDATA\APPLSYSD05.DBF
1,649 1 68.7 3.9 489 0 3 0.0
G:\ORACLE\PRODDATA\APPLSYSD06.DBF
569 0 173.3 3.6 45 0 1 190.0
APPLSYSX E:\ORACLE\PRODDATA\APPLSYSX01.DBF
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
246 0 109.6 1.0 152 0 3 186.7
APPLSYSX E:\ORACLE\PRODDATA\APPLSYSX02.DBF
242 0 100.4 1.0 198 0 0
E:\ORACLE\PRODDATA\APPLSYSX03.DBF
856 1 90.3 1.0 205 0 0
E:\ORACLE\PRODDATA\APPLSYSX04.DBF
417 0 92.6 1.0 175 0 0
G:\ORACLE\PRODDATA\APPLSYSX05.DBF
73 0 245.6 1.0 90 0 1 0.0
APX E:\ORACLE\PRODDATA\APX01.DBF
892 1 91.8 1.0 39 0 0
E:\ORACLE\PRODDATA\APX02.DBF
1,697 1 80.1 1.0 60 0 0
F:\ORACLE\PRODDATA\APX03.DBF
1,515 1 82.0 1.0 71 0 2 85.0
G:\ORACLE\PRODDATA\APX04.DBF
78 0 147.8 1.0 36 0 2 20.0
ARD E:\ORACLE\PRODDATA\ARD01.DBF
30,947 18 92.5 2.2 3 0 509 87.7
F:\ORACLE\PRODDATA\ARD02.DBF
41,820 25 84.1 2.4 15 0 1,873 64.0
ARX E:\ORACLE\PRODDATA\ARX01.DBF
4,544 3 62.2 1.0 59 0 235 9.4
F:\ORACLE\PRODDATA\ARX02.DBF
5,006 3 41.0 1.0 48 0 217 2.2
G:\ORACLE\PRODDATA\ARX03.DBF
64 0 240.6 1.0 4 0 0
ASFD E:\ORACLE\PRODDATA\ASFD01.DBF
4 0 0.0 1.0 1 0 0
ASFX E:\ORACLE\PRODDATA\ASFX01.DBF
4 0 0.0 1.0 1 0 0
ASGD E:\ORACLE\PRODDATA\ASGD01.DBF
19 0 19.5 1.0 1 0 0
ASGX E:\ORACLE\PRODDATA\ASGX01.DBF
48 0 120.8 1.0 1 0 0
ASLD E:\ORACLE\PRODDATA\ASLD01.DBF
8 0 0.0 1.0 1 0 0
ASLX E:\ORACLE\PRODDATA\ASLX01.DBF
8 0 0.0 1.0 1 0 0
ASOD E:\ORACLE\PRODDATA\ASOD01.DBF
9 0 0.0 1.0 1 0 0
E:\ORACLE\PRODDATA\ASOD02.DBF
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
9 0 0.0 1.0 1 0 0
ASOD E:\ORACLE\PRODDATA\ASOD03.DBF
9 0 0.0 1.0 1 0 0
E:\ORACLE\PRODDATA\ASOD04.DBF
9 0 0.0 1.0 1 0 0
E:\ORACLE\PRODDATA\ASOD05.DBF
9 0 0.0 1.0 1 0 0
ASOX E:\ORACLE\PRODDATA\ASOX01.DBF
89 0 84.0 1.0 1 0 0
ASTD E:\ORACLE\PRODDATA\ASTD01.DBF
4 0 0.0 1.0 1 0 0
ASTX E:\ORACLE\PRODDATA\ASTX01.DBF
17 0 68.8 1.0 1 0 0
AXD E:\ORACLE\PRODDATA\AXD01.DBF
13 0 13.8 1.0 1 0 2 5.0
AXX E:\ORACLE\PRODDATA\AXX01.DBF
80 0 107.6 1.0 1 0 0
AZD E:\ORACLE\PRODDATA\AZD01.DBF
0 0 1 0 0
AZX E:\ORACLE\PRODDATA\AZX01.DBF
14 0 87.1 1.0 1 0 0
BEND E:\ORACLE\PRODDATA\BEND01.DBF
11 0 22.7 1.0 1 0 0
BENX E:\ORACLE\PRODDATA\BENX01.DBF
1,383 1 86.0 1.0 1 0 0
BICD E:\ORACLE\PRODDATA\BICD01.DBF
3 0 0.0 1.0 1 0 0
BICX E:\ORACLE\PRODDATA\BICX01.DBF
23 0 69.6 1.0 1 0 0
BILD E:\ORACLE\PRODDATA\BILD01.DBF
8 0 0.0 1.0 1 0 0
BILX E:\ORACLE\PRODDATA\BILX01.DBF
21 0 44.8 1.0 1 0 0
BIMD E:\ORACLE\PRODDATA\BIMD01.DBF
3 0 0.0 1.0 1 0 0
BIMX E:\ORACLE\PRODDATA\BIMX01.DBF
395 0 103.4 1.0 1 0 0
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
BISD E:\ORACLE\PRODDATA\BISD01.DBF
0 0 1 0 0
BISX E:\ORACLE\PRODDATA\BISX01.DBF
47 0 106.0 1.0 1 0 0
BIXD E:\ORACLE\PRODDATA\BIXD01.DBF
8 0 0.0 1.0 1 0 0
BIXX E:\ORACLE\PRODDATA\BIXX01.DBF
30 0 100.0 1.0 1 0 0
BOMD E:\ORACLE\PRODDATA\BOMD01.DBF
511 0 76.2 3.4 1 0 0
E:\ORACLE\PRODDATA\BOMD02.DBF
240 0 87.8 1.4 1 0 0
E:\ORACLE\PRODDATA\BOMD03.DBF
63 0 126.3 1.0 8 0 0
BOMX E:\ORACLE\PRODDATA\BOMX01.DBF
327 0 93.8 1.0 4 0 2 30.0
E:\ORACLE\PRODDATA\BOMX02.DBF
75 0 132.9 1.0 1 0 0
BSCD E:\ORACLE\PRODDATA\BSCD01.DBF
1 0 0.0 1.0 1 0 0
BSCX E:\ORACLE\PRODDATA\BSCX01.DBF
100 0 99.9 1.0 1 0 0
CCTD E:\ORACLE\PRODDATA\CCTD01.DBF
1 0 50.0 1.0 0 0 0
CCTX E:\ORACLE\PRODDATA\CCTX01.DBF
29 0 114.8 1.0 1 0 0
CED E:\ORACLE\PRODDATA\CED01.DBF
1 0 0.0 1.0 1 0 0
CEX E:\ORACLE\PRODDATA\CEX01.DBF
34 0 122.6 1.0 1 0 0
CND E:\ORACLE\PRODDATA\CND01.DBF
27 0 102.6 1.0 1 0 0
CNX E:\ORACLE\PRODDATA\CNX01.DBF
277 0 102.8 1.0 1 0 0
CRPD E:\ORACLE\PRODDATA\CRPD01.DBF
9 0 0.0 1.0 1 0 0
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
CRPX E:\ORACLE\PRODDATA\CRPX01.DBF
30 0 94.3 1.0 1 0 0
CSCD E:\ORACLE\PRODDATA\CSCD01.DBF
3 0 0.0 1.0 1 0 0
CSCX E:\ORACLE\PRODDATA\CSCX01.DBF
59 0 70.8 1.0 1 0 0
CSD E:\ORACLE\PRODDATA\CSD01.DBF
7 0 87.1 1.0 0 0 0
CSDD E:\ORACLE\PRODDATA\CSDD01.DBF
3 0 0.0 1.0 1 0 0
CSDX E:\ORACLE\PRODDATA\CSDX01.DBF
21 0 43.3 1.0 1 0 0
CSFD E:\ORACLE\PRODDATA\CSFD01.DBF
99 0 93.8 1.0 1 0 0
CSFX E:\ORACLE\PRODDATA\CSFX01.DBF
4 0 2.5 1.0 1 0 0
CSPD E:\ORACLE\PRODDATA\CSPD01.DBF
4 0 0.0 1.0 1 0 0
CSPX E:\ORACLE\PRODDATA\CSPX01.DBF
71 0 83.7 1.0 1 0 0
CSRD E:\ORACLE\PRODDATA\CSRD01.DBF
9 0 0.0 1.0 1 0 0
CSRX E:\ORACLE\PRODDATA\CSRX01.DBF
11 0 30.0 1.0 1 0 0
CSSD E:\ORACLE\PRODDATA\CSSD01.DBF
3 0 0.0 1.0 1 0 0
CSSX E:\ORACLE\PRODDATA\CSSX01.DBF
19 0 66.3 1.0 1 0 0
CSX E:\ORACLE\PRODDATA\CSX01.DBF
339 0 102.4 1.0 0 0 0
E:\ORACLE\PRODDATA\CSX02.DBF
9 0 0.0 1.0 1 0 0
CTXD E:\ORACLE\PRODDATA\CTXD01.DBF
8 0 72.5 1.0 4 0 0
E:\ORACLE\PRODDATA\CTXD02.DBF
4 0 150.0 1.0 7 0 1 20.0
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
CUAD E:\ORACLE\PRODDATA\CUAD01.DBF
9 0 0.0 1.0 1 0 0
CUAX E:\ORACLE\PRODDATA\CUAX01.DBF
9 0 0.0 1.0 1 0 0
CUED E:\ORACLE\PRODDATA\CUED01.DBF
9 0 0.0 1.0 1 0 0
CUEX E:\ORACLE\PRODDATA\CUEX01.DBF
9 0 0.0 1.0 1 0 0
CUFD E:\ORACLE\PRODDATA\CUFD01.DBF
9 0 0.0 1.0 1 0 0
CUFX E:\ORACLE\PRODDATA\CUFX01.DBF
9 0 0.0 1.0 1 0 0
CUID E:\ORACLE\PRODDATA\CUID01.DBF
9 0 0.0 1.0 1 0 0
CUIX E:\ORACLE\PRODDATA\CUIX01.DBF
9 0 0.0 1.0 1 0 0
CUND E:\ORACLE\PRODDATA\CUND01.DBF
9 0 0.0 1.0 1 0 0
CUNX E:\ORACLE\PRODDATA\CUNX01.DBF
20 0 36.5 1.0 1 0 0
CUPD E:\ORACLE\PRODDATA\CUPD01.DBF
9 0 0.0 1.0 1 0 0
CUPX E:\ORACLE\PRODDATA\CUPX01.DBF
9 0 0.0 1.0 1 0 0
CUSD E:\ORACLE\PRODDATA\CUSD01.DBF
9 0 0.0 1.0 1 0 0
CUSX E:\ORACLE\PRODDATA\CUSX01.DBF
9 0 0.0 1.0 1 0 0
CZD E:\ORACLE\PRODDATA\CZD01.DBF
33 0 89.1 1.0 1 0 0
CZX E:\ORACLE\PRODDATA\CZX01.DBF
188 0 87.7 1.0 1 0 0
EAAD E:\ORACLE\PRODDATA\EAAD01.DBF
1 0 0.0 1.0 1 0 0
EAAX E:\ORACLE\PRODDATA\EAAX01.DBF
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
1 0 0.0 1.0 1 0 0
EAMD E:\ORACLE\PRODDATA\EAMD01.DBF
9 0 0.0 1.0 1 0 0
EAMX E:\ORACLE\PRODDATA\EAMX01.DBF
9 0 0.0 1.0 1 0 0
ECD E:\ORACLE\PRODDATA\ECD01.DBF
0 0 1 0 0
ECX E:\ORACLE\PRODDATA\ECX01.DBF
84 0 96.7 1.0 1 0 0
ECXD E:\ORACLE\PRODDATA\ECXD01.DBF
0 0 1 0 0
ECXX E:\ORACLE\PRODDATA\ECXX01.DBF
0 0 1 0 0
ENGD E:\ORACLE\PRODDATA\ENGD01.DBF
8 0 0.0 1.0 1 0 0
ENGX E:\ORACLE\PRODDATA\ENGX01.DBF
37 0 58.4 1.0 1 0 0
ENID E:\ORACLE\PRODDATA\ENID01.DBF
9 0 0.0 1.0 1 0 0
ENIX E:\ORACLE\PRODDATA\ENIX01.DBF
9 0 0.0 1.0 1 0 0
EVMD E:\ORACLE\PRODDATA\EVMD01.DBF
1 0 0.0 1.0 1 0 0
EVMX E:\ORACLE\PRODDATA\EVMX01.DBF
1 0 0.0 1.0 1 0 0
FAD E:\ORACLE\PRODDATA\FAD01.DBF
2 0 40.0 1.0 0 0 0
FAX E:\ORACLE\PRODDATA\FAX01.DBF
287 0 92.8 1.0 0 0 0
FEMD E:\ORACLE\PRODDATA\FEMD01.DBF
1 0 0.0 1.0 1 0 0
FEMX E:\ORACLE\PRODDATA\FEMX01.DBF
10 0 92.0 1.0 1 0 0
FIID E:\ORACLE\PRODDATA\FIID01.DBF
2 0 0.0 1.0 1 0 0
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
FIIX E:\ORACLE\PRODDATA\FIIX01.DBF
2 0 0.0 1.0 1 0 0
FLMD E:\ORACLE\PRODDATA\FLMD01.DBF
8 0 0.0 1.0 1 0 0
FLMX E:\ORACLE\PRODDATA\FLMX01.DBF
8 0 0.0 1.0 1 0 0
FPTD E:\ORACLE\PRODDATA\FPTD01.DBF
5 0 0.0 1.0 1 0 0
FPTX E:\ORACLE\PRODDATA\FPTX01.DBF
116 0 80.9 1.0 1 0 0
FRMD E:\ORACLE\PRODDATA\FRMD01.DBF
1 0 0.0 1.0 1 0 0
FRMX E:\ORACLE\PRODDATA\FRMX01.DBF
1 0 0.0 1.0 1 0 0
FTED E:\ORACLE\PRODDATA\FTED01.DBF
9 0 0.0 1.0 1 0 0
FTEX E:\ORACLE\PRODDATA\FTEX01.DBF
8 0 0.0 1.0 1 0 0
FVD E:\ORACLE\PRODDATA\FVD01.DBF
8 0 0.0 1.0 1 0 0
FVX E:\ORACLE\PRODDATA\FVX01.DBF
119 0 74.9 1.0 1 0 0
GLD E:\ORACLE\PRODDATA\GLD01.DBF
1,518 1 90.6 1.1 4 0 7 110.0
E:\ORACLE\PRODDATA\GLD02.DBF
345 0 103.7 1.1 7 0 0
E:\ORACLE\PRODDATA\GLD03.DBF
554 0 98.8 1.0 1 0 0
F:\ORACLE\PRODDATA\GLD04.DBF
1,012 1 111.2 1.0 6 0 0
F:\ORACLE\PRODDATA\GLD05.DBF
998 1 100.9 1.0 18 0 0
G:\ORACLE\PRODDATA\GLD06.DBF
236 0 230.5 1.0 76 0 0
GLX E:\ORACLE\PRODDATA\GLX01.DBF
1,214 1 57.6 1.0 35 0 0
E:\ORACLE\PRODDATA\GLX02.DBF
963 1 46.6 1.0 21 0 0
E:\ORACLE\PRODDATA\GLX03.DBF
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
919 1 52.8 1.0 20 0 0
GLX E:\ORACLE\PRODDATA\GLX04.DBF
943 1 59.5 1.0 34 0 0
F:\ORACLE\PRODDATA\GLX05.DBF
952 1 59.8 1.0 24 0 0
G:\ORACLE\PRODDATA\GLX06.DBF
36 0 363.9 1.0 22 0 0
GMAD E:\ORACLE\PRODDATA\GMAD01.DBF
9 0 68.9 1.0 1 0 0
GMAX E:\ORACLE\PRODDATA\GMAX01.DBF
31 0 73.2 1.0 1 0 0
GMDD E:\ORACLE\PRODDATA\GMDD01.DBF
39 0 71.5 1.0 1 0 0
GMDX E:\ORACLE\PRODDATA\GMDX01.DBF
32 0 21.9 1.0 1 0 0
GMED E:\ORACLE\PRODDATA\GMED01.DBF
16 0 22.5 1.0 1 0 0
GMEX E:\ORACLE\PRODDATA\GMEX01.DBF
13 0 18.5 1.0 1 0 0
GMFD E:\ORACLE\PRODDATA\GMFD01.DBF
8 0 37.5 1.0 1 0 0
GMFX E:\ORACLE\PRODDATA\GMFX01.DBF
118 0 66.4 1.0 1 0 0
GMID E:\ORACLE\PRODDATA\GMID01.DBF
12 0 30.0 1.0 1 0 0
GMIX E:\ORACLE\PRODDATA\GMIX01.DBF
107 0 66.1 1.0 1 0 0
GMLD E:\ORACLE\PRODDATA\GMLD01.DBF
81 0 60.0 1.0 1 0 0
GMLX E:\ORACLE\PRODDATA\GMLX01.DBF
103 0 59.0 1.0 1 0 0
GMPD E:\ORACLE\PRODDATA\GMPD01.DBF
19 0 46.8 1.0 1 0 0
GMPX E:\ORACLE\PRODDATA\GMPX01.DBF
62 0 66.8 1.0 1 0 0
GMSD E:\ORACLE\PRODDATA\GMSD01.DBF
9 0 0.0 1.0 1 0 0
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
GMSX E:\ORACLE\PRODDATA\GMSX01.DBF
99 0 92.5 1.0 1 0 0
GRD E:\ORACLE\PRODDATA\GRD01.DBF
7 0 0.0 1.0 1 0 0
GRX E:\ORACLE\PRODDATA\GRX01.DBF
285 0 59.5 1.0 1 0 0
HRD E:\ORACLE\PRODDATA\HRD01.DBF
146 0 72.7 1.4 1 0 23 46.1
HRID E:\ORACLE\PRODDATA\HRID01.DBF
3 0 0.0 1.0 1 0 0
HRIX E:\ORACLE\PRODDATA\HRIX01.DBF
7 0 72.9 1.0 1 0 0
HRX E:\ORACLE\PRODDATA\HRX01.DBF
1,604 1 85.8 1.0 1 0 0
HSPPL E:\ORACLE\PRODDATA\HSPPL01.DBF
90 0 114.4 6.5 2 0 0
HXCD E:\ORACLE\PRODDATA\HXCD01.DBF
8 0 0.0 1.0 1 0 0
HXCX E:\ORACLE\PRODDATA\HXCX01.DBF
8 0 0.0 1.0 1 0 0
HXTD E:\ORACLE\PRODDATA\HXTD01.DBF
9 0 0.0 1.0 1 0 0
HXTX E:\ORACLE\PRODDATA\HXTX01.DBF
98 0 70.3 1.0 1 0 0
IBAD E:\ORACLE\PRODDATA\IBAD01.DBF
8 0 0.0 1.0 1 0 0
IBAX E:\ORACLE\PRODDATA\IBAX01.DBF
13 0 66.2 1.0 1 0 0
IBED E:\ORACLE\PRODDATA\IBED01.DBF
10 0 15.0 1.0 1 0 0
IBEX E:\ORACLE\PRODDATA\IBEX01.DBF
27 0 92.2 1.0 1 0 0
IBPD E:\ORACLE\PRODDATA\IBPD01.DBF
8 0 0.0 1.0 1 0 0
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
IBPX E:\ORACLE\PRODDATA\IBPX01.DBF
8 0 0.0 1.0 1 0 0
IBUD E:\ORACLE\PRODDATA\IBUD01.DBF
10 0 32.0 1.0 1 0 0
IBUX E:\ORACLE\PRODDATA\IBUX01.DBF
8 0 0.0 1.0 1 0 0
IBYD E:\ORACLE\PRODDATA\IBYD01.DBF
8 0 0.0 1.0 1 0 0
IBYX E:\ORACLE\PRODDATA\IBYX01.DBF
41 0 58.5 1.0 1 0 0
ICXD E:\ORACLE\PRODDATA\ICXD01.DBF
30 0 77.3 1.5 1 0 0
F:\ORACLE\PRODDATA\ICXD02.DBF
2 0 50.0 1.0 4 0 0
ICXX E:\ORACLE\PRODDATA\ICXX01.DBF
9 0 50.0 1.0 7 0 0
F:\ORACLE\PRODDATA\ICXX02.DBF
126 0 82.7 1.0 8 0 0
IEBD E:\ORACLE\PRODDATA\IEBD01.DBF
8 0 0.0 1.0 1 0 0
IEBX E:\ORACLE\PRODDATA\IEBX01.DBF
37 0 67.6 1.0 1 0 0
IEMD E:\ORACLE\PRODDATA\IEMD01.DBF
12 0 27.5 1.0 1 0 0
IEMX E:\ORACLE\PRODDATA\IEMX01.DBF
21 0 50.5 1.0 1 0 0
IEOD E:\ORACLE\PRODDATA\IEOD01.DBF
6 0 0.0 1.0 1 0 0
IEOX E:\ORACLE\PRODDATA\IEOX01.DBF
19 0 63.2 1.0 1 0 0
IESD E:\ORACLE\PRODDATA\IESD01.DBF
9 0 46.7 1.0 1 0 0
IESX E:\ORACLE\PRODDATA\IESX01.DBF
39 0 80.0 1.0 1 0 0
IEUD E:\ORACLE\PRODDATA\IEUD01.DBF
9 0 0.0 1.0 1 0 0
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
IEUX E:\ORACLE\PRODDATA\IEUX01.DBF
49 0 56.7 1.0 1 0 0
IEXD E:\ORACLE\PRODDATA\IEXD01.DBF
9 0 0.0 1.0 1 0 0
IEXX E:\ORACLE\PRODDATA\IEXX01.DBF
27 0 75.9 1.0 1 0 0
IGCD E:\ORACLE\PRODDATA\IGCD01.DBF
8 0 0.0 1.0 1 0 0
IGCX E:\ORACLE\PRODDATA\IGCX01.DBF
8 0 0.0 1.0 1 0 0
IGFD E:\ORACLE\PRODDATA\IGFD01.DBF
8 0 0.0 1.0 1 0 0
IGFX E:\ORACLE\PRODDATA\IGFX01.DBF
8 0 0.0 1.0 1 0 0
IGID E:\ORACLE\PRODDATA\IGID01.DBF
24 0 61.3 1.0 1 0 0
IGIX E:\ORACLE\PRODDATA\IGIX01.DBF
75 0 68.9 1.0 1 0 0
IGSD E:\ORACLE\PRODDATA\IGSD01.DBF
9 0 0.0 1.0 1 0 0
IGSX E:\ORACLE\PRODDATA\IGSX01.DBF
313 0 70.0 1.0 1 0 0
IGWD E:\ORACLE\PRODDATA\IGWD01.DBF
9 0 0.0 1.0 1 0 0
IGWX E:\ORACLE\PRODDATA\IGWX01.DBF
68 0 60.1 1.0 1 0 0
INVD E:\ORACLE\PRODDATA\INV04.DBF
3,440 2 81.9 3.3 26 0 56 28.4
E:\ORACLE\PRODDATA\INVD01.DBF
13,594 8 54.8 4.2 17 0 889 59.8
E:\ORACLE\PRODDATA\INVD02.DBF
2,375 1 88.5 2.2 8 0 11 128.2
E:\ORACLE\PRODDATA\INVD03.DBF
4,176 2 72.3 3.5 21 0 1 60.0
E:\ORACLE\PRODDATA\INVD14.DBF
11,732 7 61.5 1.3 37 0 22 22.3
F:\ORACLE\PRODDATA\INV06.DBF
2,127 1 95.6 2.2 3 0 0
F:\ORACLE\PRODDATA\INV07.DBF
�File IO Stats for DB: PROD Instance: prod Snaps: 320 -321
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
712 0 93.4 1.4 1 0 0
INVD F:\ORACLE\PRODDATA\INVD04.DBF
4,277 3 81.8 2.6 9 0 1 40.0