performance tunning

Tags:
Oracle
Oracle performance
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:ORACLEPRODDATAABMD01.DBF 1 0 0.0 1.0 1 0 0 ABMX E:ORACLEPRODDATAABMX01.DBF 1 0 0.0 1.0 1 0 0 AKD E:ORACLEPRODDATAAKD01.DBF 12 0 24.2 1.0 1 0 0 AKX E:ORACLEPRODDATAAKX01.DBF 36 0 115.6 1.0 1 0 0 ALRX E:ORACLEPRODDATAALRX01.DBF 52 0 131.5 1.0 0 0 0 AMSD E:ORACLEPRODDATAAMSD01.DBF 7 0 58.6 1.0 1 0 0 AMSX E:ORACLEPRODDATAAMSX01.DBF 407 0 137.9 1.0 1 0 0 AMVD E:ORACLEPRODDATAAMVD01.DBF 6 0 56.7 1.0 1 0 0 AMVX E:ORACLEPRODDATAAMVX01.DBF 91 0 122.0 1.0 1 0 0 APD E:ORACLEPRODDATAAPD01.DBF 5,477 3 77.0 1.0 6 0 0 E:ORACLEPRODDATAAPD02.DBF 4,348 3 90.5 1.0 4 0 0 E:ORACLEPRODDATAAPD03.DBF 7,225 4 77.9 1.3 90 0 5 58.0 F:ORACLEPRODDATAAP04.DBF 6,367 4 88.8 1.1 3 0 0 F:ORACLEPRODDATAAPD05.DBF 4,244 3 91.4 1.0 5 0 0 APPLSYSD E:ORACLEPRODDATAAPPLSYSD01.DBF 3,033 2 89.2 3.9 93 0 13 43.8 E:ORACLEPRODDATAAPPLSYSD02.DBF 2,688 2 86.5 4.5 236 0 14 954.3 E:ORACLEPRODDATAAPPLSYSD03.DBF 968 1 106.2 4.3 51 0 0 E:ORACLEPRODDATAAPPLSYSD04.DBF 2,024 1 90.5 5.3 32 0 0 F:ORACLEPRODDATAAPPLSYSD05.DBF 1,649 1 68.7 3.9 489 0 3 0.0 G:ORACLEPRODDATAAPPLSYSD06.DBF 569 0 173.3 3.6 45 0 1 190.0 APPLSYSX E:ORACLEPRODDATAAPPLSYSX01.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:ORACLEPRODDATAAPPLSYSX02.DBF 242 0 100.4 1.0 198 0 0 E:ORACLEPRODDATAAPPLSYSX03.DBF 856 1 90.3 1.0 205 0 0 E:ORACLEPRODDATAAPPLSYSX04.DBF 417 0 92.6 1.0 175 0 0 G:ORACLEPRODDATAAPPLSYSX05.DBF 73 0 245.6 1.0 90 0 1 0.0 APX E:ORACLEPRODDATAAPX01.DBF 892 1 91.8 1.0 39 0 0 E:ORACLEPRODDATAAPX02.DBF 1,697 1 80.1 1.0 60 0 0 F:ORACLEPRODDATAAPX03.DBF 1,515 1 82.0 1.0 71 0 2 85.0 G:ORACLEPRODDATAAPX04.DBF 78 0 147.8 1.0 36 0 2 20.0 ARD E:ORACLEPRODDATAARD01.DBF 30,947 18 92.5 2.2 3 0 509 87.7 F:ORACLEPRODDATAARD02.DBF 41,820 25 84.1 2.4 15 0 1,873 64.0 ARX E:ORACLEPRODDATAARX01.DBF 4,544 3 62.2 1.0 59 0 235 9.4 F:ORACLEPRODDATAARX02.DBF 5,006 3 41.0 1.0 48 0 217 2.2 G:ORACLEPRODDATAARX03.DBF 64 0 240.6 1.0 4 0 0 ASFD E:ORACLEPRODDATAASFD01.DBF 4 0 0.0 1.0 1 0 0 ASFX E:ORACLEPRODDATAASFX01.DBF 4 0 0.0 1.0 1 0 0 ASGD E:ORACLEPRODDATAASGD01.DBF 19 0 19.5 1.0 1 0 0 ASGX E:ORACLEPRODDATAASGX01.DBF 48 0 120.8 1.0 1 0 0 ASLD E:ORACLEPRODDATAASLD01.DBF 8 0 0.0 1.0 1 0 0 ASLX E:ORACLEPRODDATAASLX01.DBF 8 0 0.0 1.0 1 0 0 ASOD E:ORACLEPRODDATAASOD01.DBF 9 0 0.0 1.0 1 0 0 E:ORACLEPRODDATAASOD02.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:ORACLEPRODDATAASOD03.DBF 9 0 0.0 1.0 1 0 0 E:ORACLEPRODDATAASOD04.DBF 9 0 0.0 1.0 1 0 0 E:ORACLEPRODDATAASOD05.DBF 9 0 0.0 1.0 1 0 0 ASOX E:ORACLEPRODDATAASOX01.DBF 89 0 84.0 1.0 1 0 0 ASTD E:ORACLEPRODDATAASTD01.DBF 4 0 0.0 1.0 1 0 0 ASTX E:ORACLEPRODDATAASTX01.DBF 17 0 68.8 1.0 1 0 0 AXD E:ORACLEPRODDATAAXD01.DBF 13 0 13.8 1.0 1 0 2 5.0 AXX E:ORACLEPRODDATAAXX01.DBF 80 0 107.6 1.0 1 0 0 AZD E:ORACLEPRODDATAAZD01.DBF 0 0 1 0 0 AZX E:ORACLEPRODDATAAZX01.DBF 14 0 87.1 1.0 1 0 0 BEND E:ORACLEPRODDATABEND01.DBF 11 0 22.7 1.0 1 0 0 BENX E:ORACLEPRODDATABENX01.DBF 1,383 1 86.0 1.0 1 0 0 BICD E:ORACLEPRODDATABICD01.DBF 3 0 0.0 1.0 1 0 0 BICX E:ORACLEPRODDATABICX01.DBF 23 0 69.6 1.0 1 0 0 BILD E:ORACLEPRODDATABILD01.DBF 8 0 0.0 1.0 1 0 0 BILX E:ORACLEPRODDATABILX01.DBF 21 0 44.8 1.0 1 0 0 BIMD E:ORACLEPRODDATABIMD01.DBF 3 0 0.0 1.0 1 0 0 BIMX E:ORACLEPRODDATABIMX01.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:ORACLEPRODDATABISD01.DBF 0 0 1 0 0 BISX E:ORACLEPRODDATABISX01.DBF 47 0 106.0 1.0 1 0 0 BIXD E:ORACLEPRODDATABIXD01.DBF 8 0 0.0 1.0 1 0 0 BIXX E:ORACLEPRODDATABIXX01.DBF 30 0 100.0 1.0 1 0 0 BOMD E:ORACLEPRODDATABOMD01.DBF 511 0 76.2 3.4 1 0 0 E:ORACLEPRODDATABOMD02.DBF 240 0 87.8 1.4 1 0 0 E:ORACLEPRODDATABOMD03.DBF 63 0 126.3 1.0 8 0 0 BOMX E:ORACLEPRODDATABOMX01.DBF 327 0 93.8 1.0 4 0 2 30.0 E:ORACLEPRODDATABOMX02.DBF 75 0 132.9 1.0 1 0 0 BSCD E:ORACLEPRODDATABSCD01.DBF 1 0 0.0 1.0 1 0 0 BSCX E:ORACLEPRODDATABSCX01.DBF 100 0 99.9 1.0 1 0 0 CCTD E:ORACLEPRODDATACCTD01.DBF 1 0 50.0 1.0 0 0 0 CCTX E:ORACLEPRODDATACCTX01.DBF 29 0 114.8 1.0 1 0 0 CED E:ORACLEPRODDATACED01.DBF 1 0 0.0 1.0 1 0 0 CEX E:ORACLEPRODDATACEX01.DBF 34 0 122.6 1.0 1 0 0 CND E:ORACLEPRODDATACND01.DBF 27 0 102.6 1.0 1 0 0 CNX E:ORACLEPRODDATACNX01.DBF 277 0 102.8 1.0 1 0 0 CRPD E:ORACLEPRODDATACRPD01.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:ORACLEPRODDATACRPX01.DBF 30 0 94.3 1.0 1 0 0 CSCD E:ORACLEPRODDATACSCD01.DBF 3 0 0.0 1.0 1 0 0 CSCX E:ORACLEPRODDATACSCX01.DBF 59 0 70.8 1.0 1 0 0 CSD E:ORACLEPRODDATACSD01.DBF 7 0 87.1 1.0 0 0 0 CSDD E:ORACLEPRODDATACSDD01.DBF 3 0 0.0 1.0 1 0 0 CSDX E:ORACLEPRODDATACSDX01.DBF 21 0 43.3 1.0 1 0 0 CSFD E:ORACLEPRODDATACSFD01.DBF 99 0 93.8 1.0 1 0 0 CSFX E:ORACLEPRODDATACSFX01.DBF 4 0 2.5 1.0 1 0 0 CSPD E:ORACLEPRODDATACSPD01.DBF 4 0 0.0 1.0 1 0 0 CSPX E:ORACLEPRODDATACSPX01.DBF 71 0 83.7 1.0 1 0 0 CSRD E:ORACLEPRODDATACSRD01.DBF 9 0 0.0 1.0 1 0 0 CSRX E:ORACLEPRODDATACSRX01.DBF 11 0 30.0 1.0 1 0 0 CSSD E:ORACLEPRODDATACSSD01.DBF 3 0 0.0 1.0 1 0 0 CSSX E:ORACLEPRODDATACSSX01.DBF 19 0 66.3 1.0 1 0 0 CSX E:ORACLEPRODDATACSX01.DBF 339 0 102.4 1.0 0 0 0 E:ORACLEPRODDATACSX02.DBF 9 0 0.0 1.0 1 0 0 CTXD E:ORACLEPRODDATACTXD01.DBF 8 0 72.5 1.0 4 0 0 E:ORACLEPRODDATACTXD02.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:ORACLEPRODDATACUAD01.DBF 9 0 0.0 1.0 1 0 0 CUAX E:ORACLEPRODDATACUAX01.DBF 9 0 0.0 1.0 1 0 0 CUED E:ORACLEPRODDATACUED01.DBF 9 0 0.0 1.0 1 0 0 CUEX E:ORACLEPRODDATACUEX01.DBF 9 0 0.0 1.0 1 0 0 CUFD E:ORACLEPRODDATACUFD01.DBF 9 0 0.0 1.0 1 0 0 CUFX E:ORACLEPRODDATACUFX01.DBF 9 0 0.0 1.0 1 0 0 CUID E:ORACLEPRODDATACUID01.DBF 9 0 0.0 1.0 1 0 0 CUIX E:ORACLEPRODDATACUIX01.DBF 9 0 0.0 1.0 1 0 0 CUND E:ORACLEPRODDATACUND01.DBF 9 0 0.0 1.0 1 0 0 CUNX E:ORACLEPRODDATACUNX01.DBF 20 0 36.5 1.0 1 0 0 CUPD E:ORACLEPRODDATACUPD01.DBF 9 0 0.0 1.0 1 0 0 CUPX E:ORACLEPRODDATACUPX01.DBF 9 0 0.0 1.0 1 0 0 CUSD E:ORACLEPRODDATACUSD01.DBF 9 0 0.0 1.0 1 0 0 CUSX E:ORACLEPRODDATACUSX01.DBF 9 0 0.0 1.0 1 0 0 CZD E:ORACLEPRODDATACZD01.DBF 33 0 89.1 1.0 1 0 0 CZX E:ORACLEPRODDATACZX01.DBF 188 0 87.7 1.0 1 0 0 EAAD E:ORACLEPRODDATAEAAD01.DBF 1 0 0.0 1.0 1 0 0 EAAX E:ORACLEPRODDATAEAAX01.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:ORACLEPRODDATAEAMD01.DBF 9 0 0.0 1.0 1 0 0 EAMX E:ORACLEPRODDATAEAMX01.DBF 9 0 0.0 1.0 1 0 0 ECD E:ORACLEPRODDATAECD01.DBF 0 0 1 0 0 ECX E:ORACLEPRODDATAECX01.DBF 84 0 96.7 1.0 1 0 0 ECXD E:ORACLEPRODDATAECXD01.DBF 0 0 1 0 0 ECXX E:ORACLEPRODDATAECXX01.DBF 0 0 1 0 0 ENGD E:ORACLEPRODDATAENGD01.DBF 8 0 0.0 1.0 1 0 0 ENGX E:ORACLEPRODDATAENGX01.DBF 37 0 58.4 1.0 1 0 0 ENID E:ORACLEPRODDATAENID01.DBF 9 0 0.0 1.0 1 0 0 ENIX E:ORACLEPRODDATAENIX01.DBF 9 0 0.0 1.0 1 0 0 EVMD E:ORACLEPRODDATAEVMD01.DBF 1 0 0.0 1.0 1 0 0 EVMX E:ORACLEPRODDATAEVMX01.DBF 1 0 0.0 1.0 1 0 0 FAD E:ORACLEPRODDATAFAD01.DBF 2 0 40.0 1.0 0 0 0 FAX E:ORACLEPRODDATAFAX01.DBF 287 0 92.8 1.0 0 0 0 FEMD E:ORACLEPRODDATAFEMD01.DBF 1 0 0.0 1.0 1 0 0 FEMX E:ORACLEPRODDATAFEMX01.DBF 10 0 92.0 1.0 1 0 0 FIID E:ORACLEPRODDATAFIID01.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:ORACLEPRODDATAFIIX01.DBF 2 0 0.0 1.0 1 0 0 FLMD E:ORACLEPRODDATAFLMD01.DBF 8 0 0.0 1.0 1 0 0 FLMX E:ORACLEPRODDATAFLMX01.DBF 8 0 0.0 1.0 1 0 0 FPTD E:ORACLEPRODDATAFPTD01.DBF 5 0 0.0 1.0 1 0 0 FPTX E:ORACLEPRODDATAFPTX01.DBF 116 0 80.9 1.0 1 0 0 FRMD E:ORACLEPRODDATAFRMD01.DBF 1 0 0.0 1.0 1 0 0 FRMX E:ORACLEPRODDATAFRMX01.DBF 1 0 0.0 1.0 1 0 0 FTED E:ORACLEPRODDATAFTED01.DBF 9 0 0.0 1.0 1 0 0 FTEX E:ORACLEPRODDATAFTEX01.DBF 8 0 0.0 1.0 1 0 0 FVD E:ORACLEPRODDATAFVD01.DBF 8 0 0.0 1.0 1 0 0 FVX E:ORACLEPRODDATAFVX01.DBF 119 0 74.9 1.0 1 0 0 GLD E:ORACLEPRODDATAGLD01.DBF 1,518 1 90.6 1.1 4 0 7 110.0 E:ORACLEPRODDATAGLD02.DBF 345 0 103.7 1.1 7 0 0 E:ORACLEPRODDATAGLD03.DBF 554 0 98.8 1.0 1 0 0 F:ORACLEPRODDATAGLD04.DBF 1,012 1 111.2 1.0 6 0 0 F:ORACLEPRODDATAGLD05.DBF 998 1 100.9 1.0 18 0 0 G:ORACLEPRODDATAGLD06.DBF 236 0 230.5 1.0 76 0 0 GLX E:ORACLEPRODDATAGLX01.DBF 1,214 1 57.6 1.0 35 0 0 E:ORACLEPRODDATAGLX02.DBF 963 1 46.6 1.0 21 0 0 E:ORACLEPRODDATAGLX03.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:ORACLEPRODDATAGLX04.DBF 943 1 59.5 1.0 34 0 0 F:ORACLEPRODDATAGLX05.DBF 952 1 59.8 1.0 24 0 0 G:ORACLEPRODDATAGLX06.DBF 36 0 363.9 1.0 22 0 0 GMAD E:ORACLEPRODDATAGMAD01.DBF 9 0 68.9 1.0 1 0 0 GMAX E:ORACLEPRODDATAGMAX01.DBF 31 0 73.2 1.0 1 0 0 GMDD E:ORACLEPRODDATAGMDD01.DBF 39 0 71.5 1.0 1 0 0 GMDX E:ORACLEPRODDATAGMDX01.DBF 32 0 21.9 1.0 1 0 0 GMED E:ORACLEPRODDATAGMED01.DBF 16 0 22.5 1.0 1 0 0 GMEX E:ORACLEPRODDATAGMEX01.DBF 13 0 18.5 1.0 1 0 0 GMFD E:ORACLEPRODDATAGMFD01.DBF 8 0 37.5 1.0 1 0 0 GMFX E:ORACLEPRODDATAGMFX01.DBF 118 0 66.4 1.0 1 0 0 GMID E:ORACLEPRODDATAGMID01.DBF 12 0 30.0 1.0 1 0 0 GMIX E:ORACLEPRODDATAGMIX01.DBF 107 0 66.1 1.0 1 0 0 GMLD E:ORACLEPRODDATAGMLD01.DBF 81 0 60.0 1.0 1 0 0 GMLX E:ORACLEPRODDATAGMLX01.DBF 103 0 59.0 1.0 1 0 0 GMPD E:ORACLEPRODDATAGMPD01.DBF 19 0 46.8 1.0 1 0 0 GMPX E:ORACLEPRODDATAGMPX01.DBF 62 0 66.8 1.0 1 0 0 GMSD E:ORACLEPRODDATAGMSD01.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:ORACLEPRODDATAGMSX01.DBF 99 0 92.5 1.0 1 0 0 GRD E:ORACLEPRODDATAGRD01.DBF 7 0 0.0 1.0 1 0 0 GRX E:ORACLEPRODDATAGRX01.DBF 285 0 59.5 1.0 1 0 0 HRD E:ORACLEPRODDATAHRD01.DBF 146 0 72.7 1.4 1 0 23 46.1 HRID E:ORACLEPRODDATAHRID01.DBF 3 0 0.0 1.0 1 0 0 HRIX E:ORACLEPRODDATAHRIX01.DBF 7 0 72.9 1.0 1 0 0 HRX E:ORACLEPRODDATAHRX01.DBF 1,604 1 85.8 1.0 1 0 0 HSPPL E:ORACLEPRODDATAHSPPL01.DBF 90 0 114.4 6.5 2 0 0 HXCD E:ORACLEPRODDATAHXCD01.DBF 8 0 0.0 1.0 1 0 0 HXCX E:ORACLEPRODDATAHXCX01.DBF 8 0 0.0 1.0 1 0 0 HXTD E:ORACLEPRODDATAHXTD01.DBF 9 0 0.0 1.0 1 0 0 HXTX E:ORACLEPRODDATAHXTX01.DBF 98 0 70.3 1.0 1 0 0 IBAD E:ORACLEPRODDATAIBAD01.DBF 8 0 0.0 1.0 1 0 0 IBAX E:ORACLEPRODDATAIBAX01.DBF 13 0 66.2 1.0 1 0 0 IBED E:ORACLEPRODDATAIBED01.DBF 10 0 15.0 1.0 1 0 0 IBEX E:ORACLEPRODDATAIBEX01.DBF 27 0 92.2 1.0 1 0 0 IBPD E:ORACLEPRODDATAIBPD01.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:ORACLEPRODDATAIBPX01.DBF 8 0 0.0 1.0 1 0 0 IBUD E:ORACLEPRODDATAIBUD01.DBF 10 0 32.0 1.0 1 0 0 IBUX E:ORACLEPRODDATAIBUX01.DBF 8 0 0.0 1.0 1 0 0 IBYD E:ORACLEPRODDATAIBYD01.DBF 8 0 0.0 1.0 1 0 0 IBYX E:ORACLEPRODDATAIBYX01.DBF 41 0 58.5 1.0 1 0 0 ICXD E:ORACLEPRODDATAICXD01.DBF 30 0 77.3 1.5 1 0 0 F:ORACLEPRODDATAICXD02.DBF 2 0 50.0 1.0 4 0 0 ICXX E:ORACLEPRODDATAICXX01.DBF 9 0 50.0 1.0 7 0 0 F:ORACLEPRODDATAICXX02.DBF 126 0 82.7 1.0 8 0 0 IEBD E:ORACLEPRODDATAIEBD01.DBF 8 0 0.0 1.0 1 0 0 IEBX E:ORACLEPRODDATAIEBX01.DBF 37 0 67.6 1.0 1 0 0 IEMD E:ORACLEPRODDATAIEMD01.DBF 12 0 27.5 1.0 1 0 0 IEMX E:ORACLEPRODDATAIEMX01.DBF 21 0 50.5 1.0 1 0 0 IEOD E:ORACLEPRODDATAIEOD01.DBF 6 0 0.0 1.0 1 0 0 IEOX E:ORACLEPRODDATAIEOX01.DBF 19 0 63.2 1.0 1 0 0 IESD E:ORACLEPRODDATAIESD01.DBF 9 0 46.7 1.0 1 0 0 IESX E:ORACLEPRODDATAIESX01.DBF 39 0 80.0 1.0 1 0 0 IEUD E:ORACLEPRODDATAIEUD01.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:ORACLEPRODDATAIEUX01.DBF 49 0 56.7 1.0 1 0 0 IEXD E:ORACLEPRODDATAIEXD01.DBF 9 0 0.0 1.0 1 0 0 IEXX E:ORACLEPRODDATAIEXX01.DBF 27 0 75.9 1.0 1 0 0 IGCD E:ORACLEPRODDATAIGCD01.DBF 8 0 0.0 1.0 1 0 0 IGCX E:ORACLEPRODDATAIGCX01.DBF 8 0 0.0 1.0 1 0 0 IGFD E:ORACLEPRODDATAIGFD01.DBF 8 0 0.0 1.0 1 0 0 IGFX E:ORACLEPRODDATAIGFX01.DBF 8 0 0.0 1.0 1 0 0 IGID E:ORACLEPRODDATAIGID01.DBF 24 0 61.3 1.0 1 0 0 IGIX E:ORACLEPRODDATAIGIX01.DBF 75 0 68.9 1.0 1 0 0 IGSD E:ORACLEPRODDATAIGSD01.DBF 9 0 0.0 1.0 1 0 0 IGSX E:ORACLEPRODDATAIGSX01.DBF 313 0 70.0 1.0 1 0 0 IGWD E:ORACLEPRODDATAIGWD01.DBF 9 0 0.0 1.0 1 0 0 IGWX E:ORACLEPRODDATAIGWX01.DBF 68 0 60.1 1.0 1 0 0 INVD E:ORACLEPRODDATAINV04.DBF 3,440 2 81.9 3.3 26 0 56 28.4 E:ORACLEPRODDATAINVD01.DBF 13,594 8 54.8 4.2 17 0 889 59.8 E:ORACLEPRODDATAINVD02.DBF 2,375 1 88.5 2.2 8 0 11 128.2 E:ORACLEPRODDATAINVD03.DBF 4,176 2 72.3 3.5 21 0 1 60.0 E:ORACLEPRODDATAINVD14.DBF 11,732 7 61.5 1.3 37 0 22 22.3 F:ORACLEPRODDATAINV06.DBF 2,127 1 95.6 2.2 3 0 0 F:ORACLEPRODDATAINV07.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:ORACLEPRODDATAINVD04.DBF 4,277 3 81.8 2.6 9 0 1 40.0 F:ORACLEPRODDATAINVD05.DBF 4,152 2 88.3 2.9 29 0 63 35.7 F:ORACLEPRODDATAINVD08.DBF 2,174 1 77.8 4.5 5 0 0 F:ORACLEPRODDATAINVD09.DBF 1,448 1 90.3 2.9 5 0 1 0.0 F:ORACLEPRODDATAINVD10.DBF 11,329 7 51.5 1.2 3 0 56 93.2 F:ORACLEPRODDATAINVD11.DBF 2,840 2 72.6 5.2 11 0 54 57.6 F:ORACLEPRODDATAINVD12.DBF 9,896 6 78.8 1.5 3 0 0 F:ORACLEPRODDATAINVD13.DBF 16,985 10 84.2 1.0 6 0 0 G:ORACLEPRODDATAINVD14.DBF 4,539 3 178.2 1.1 163 0 8 31.3 G:ORACLEPRODDATAMRPD04.DBFF 1,087 1 174.3 1.2 34 0 5 248.0 G:ORACLEPRODDATAWIPD05.DBF 1,479 1 191.0 1.2 43 0 10 285.0 INVX E:ORACLEPRODDATAINVX01.DBF 947 1 64.1 1.5 167 0 1 240.0 E:ORACLEPRODDATAINVX02.DBF 1,235 1 75.7 1.0 252 0 2 65.0 E:ORACLEPRODDATAINVX03.DBF 755 0 78.8 1.0 289 0 2 90.0 F:ORACLEPRODDATAINVX04.DBF 363 0 116.1 1.0 158 0 0 F:ORACLEPRODDATAINVX05.DBF 355 0 118.2 1.0 177 0 0 F:ORACLEPRODDATAINVX06.DBF 349 0 111.9 1.0 231 0 0 G:ORACLEPRODDATAINVX07.DBF 649 0 310.5 1.2 162 0 2 610.0 IPAD E:ORACLEPRODDATAIPAD01.DBF 8 0 0.0 1.0 1 0 0 IPAX E:ORACLEPRODDATAIPAX01.DBF 36 0 53.1 1.0 1 0 0 IPDD E:ORACLEPRODDATAIPDD01.DBF 9 0 0.0 1.0 1 0 0 IPDX E:ORACLEPRODDATAIPDX01.DBF 9 0 0.0 1.0 1 0 0 ISCD E:ORACLEPRODDATAISCD01.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) -------------- ------- ------ ------- ------------ -------- ---------- ------ 3 0 0.0 1.0 1 0 0 ISCX E:ORACLEPRODDATAISCX01.DBF 3 0 0.0 1.0 1 0 0 ITGD E:ORACLEPRODDATAITGD01.DBF 9 0 0.0 1.0 1 0 0 ITGX E:ORACLEPRODDATAITGX01.DBF 9 0 0.0 1.0 1 0 0 JAD E:ORACLEPRODDATAJAD01.DBF 40,479 24 93.0 3.8 43 0 50,320 43.8 E:ORACLEPRODDATAJAD02.DBF 42,907 26 79.0 3.9 17 0 57,888 38.5 F:ORACLEPRODDATAJAD03.DBF 18,316 11 83.3 3.9 8 0 24,021 39.4 F:ORACLEPRODDATAJAD04.DBF 23,442 14 77.3 3.6 30 0 32,878 39.3 F:ORACLEPRODDATAJAD05.DBF 22,730 14 86.8 3.9 4 0 29,056 40.6 G:ORACLEPRODDATAJAD05.DBF 9,179 5 205.3 3.3 35 0 15,046 110.1 JAX E:ORACLEPRODDATAJAX01.DBF 206 0 75.6 1.0 49 0 1 0.0 E:ORACLEPRODDATAJAX02.DBF 236 0 88.3 1.0 41 0 0 E:ORACLEPRODDATAJAX03.DBF 226 0 73.8 1.0 34 0 0 F:ORACLEPRODDATAJAX04.DBF 246 0 82.2 1.0 76 0 0 F:ORACLEPRODDATAJAX05.DBF 187 0 108.8 1.0 35 0 0 G:ORACLEPRODDATAJAX06.DBF 208 0 238.9 1.0 49 0 0 JED E:ORACLEPRODDATAJED01.DBF 8 0 0.0 1.0 1 0 0 JEX E:ORACLEPRODDATAJEX01.DBF 17 0 18.2 1.0 1 0 0 JGD E:ORACLEPRODDATAJGD01.DBF 9 0 0.0 1.0 1 0 0 JGX E:ORACLEPRODDATAJGX01.DBF 12 0 13.3 1.0 1 0 0 JLD E:ORACLEPRODDATAJLD01.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) -------------- ------- ------ ------- ------------ -------- ---------- ------ JLX E:ORACLEPRODDATAJLX01.DBF 165 0 43.2 1.0 1 0 0 JTFD E:ORACLEPRODDATAJTFD01.DBF 43 0 74.9 1.0 1 0 0 JTFX E:ORACLEPRODDATAJTFX01.DBF 550 0 86.0 1.0 1 0 0 MED E:ORACLEPRODDATAMED01.DBF 3 0 0.0 1.0 1 0 0 MEX E:ORACLEPRODDATAMEX01.DBF 3 0 0.0 1.0 1 0 0 MFGD E:ORACLEPRODDATAMFGD01.DBF 8 0 0.0 1.0 1 0 0 MFGX E:ORACLEPRODDATAMFGX01.DBF 8 0 0.0 1.0 1 0 0 MRPD E:ORACLEPRODDATAMRPD01.DBF 3,933 2 51.0 7.4 27 0 0 E:ORACLEPRODDATAMRPD02.DBF 9,259 6 28.6 7.4 91 0 0 E:ORACLEPRODDATAMRPD03.DBF 4,923 3 63.1 6.9 13 0 0 G:ORACLEPRODDATAMRPD05.DBF 1,706 1 176.9 7.6 138 0 0 MRPX E:ORACLEPRODDATAMRPX01.DBF 284 0 86.4 1.0 560 0 0 E:ORACLEPRODDATAMRPX02.DBF 333 0 77.5 1.0 694 0 0 E:ORACLEPRODDATAMRPX03.DBF 400 0 77.1 1.0 458 0 1 0.0 MSCD E:ORACLEPRODDATAMSCD01.DBF 13 0 17.7 1.0 1 0 0 MSCX E:ORACLEPRODDATAMSCX01.DBF 155 0 54.0 1.0 1 0 0 MSDD E:ORACLEPRODDATAMSDD01.DBF 8 0 0.0 1.0 1 0 0 MSDX E:ORACLEPRODDATAMSDX01.DBF 38 0 64.2 1.0 1 0 0 MSOD E:ORACLEPRODDATAMSOD01.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) -------------- ------- ------ ------- ------------ -------- ---------- ------ MSOX E:ORACLEPRODDATAMSOX01.DBF 8 0 0.0 1.0 1 0 0 MSRD E:ORACLEPRODDATAMSRD01.DBF 8 0 0.0 1.0 1 0 0 MSRX E:ORACLEPRODDATAMSRX01.DBF 8 0 0.0 1.0 1 0 0 MWAD E:ORACLEPRODDATAMWAD01.DBF 2 0 0.0 1.0 1 0 0 MWAX E:ORACLEPRODDATAMWAX01.DBF 2 0 0.0 1.0 1 0 0 OED E:ORACLEPRODDATAOED01.DBF 3 0 13.3 1.0 1 0 0 E:ORACLEPRODDATAOED02.DBF 8 0 0.0 1.0 1 0 0 OEX E:ORACLEPRODDATAOEX01.DBF 284 0 79.8 1.0 1 0 0 OKCD E:ORACLEPRODDATAOKCD01.DBF 15 0 77.3 1.0 1 0 0 OKCX E:ORACLEPRODDATAOKCX01.DBF 285 0 95.4 1.0 1 0 0 OKED E:ORACLEPRODDATAOKED01.DBF 9 0 0.0 1.0 1 0 0 OKEX E:ORACLEPRODDATAOKEX01.DBF 11 0 7.3 1.0 1 0 0 OKRD E:ORACLEPRODDATAOKRD01.DBF 9 0 0.0 1.0 1 0 0 OKRX E:ORACLEPRODDATAOKRX01.DBF 9 0 0.0 1.0 1 0 0 OKSD E:ORACLEPRODDATAOKSD01.DBF 3 0 0.0 1.0 1 0 0 OKSX E:ORACLEPRODDATAOKSX01.DBF 17 0 81.2 1.0 1 0 0 OKXD E:ORACLEPRODDATAOKXD01.DBF 4 0 0.0 1.0 1 0 0 OKXX E:ORACLEPRODDATAOKXX01.DBF 4 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) -------------- ------- ------ ------- ------------ -------- ---------- ------ ONTD E:ORACLEPRODDATAONTD01.DBF 883 1 68.1 4.4 7 0 0 E:ORACLEPRODDATAONTD02.DBF 1,362 1 76.5 3.3 21 0 0 F:ORACLEPRODDATAONTD03.DBF 686 0 66.5 3.5 18 0 0 F:ORACLEPRODDATAONTD04.DBF 307 0 71.5 4.2 2 0 0 F:ORACLEPRODDATAONTD05.DBF 700 0 75.7 3.2 4 0 0 ONTX E:ORACLEPRODDATAONTX01.DBF 257 0 105.0 1.0 53 0 0 E:ORACLEPRODDATAONTX02.DBF 248 0 87.5 1.0 28 0 0 F:ORACLEPRODDATAONTX03.DBF 461 0 89.9 1.0 21 0 0 OPID E:ORACLEPRODDATAOPID01.DBF 2 0 0.0 1.0 1 0 0 OPIX E:ORACLEPRODDATAOPIX01.DBF 2 0 0.0 1.0 1 0 0 OSMD E:ORACLEPRODDATAOSMD01.DBF 4 0 82.5 1.0 1 0 0 OSMX E:ORACLEPRODDATAOSMX01.DBF 403 0 99.6 1.0 1 0 0 OTAD E:ORACLEPRODDATAOTAD01.DBF 8 0 0.0 1.0 1 0 0 OTAX E:ORACLEPRODDATAOTAX01.DBF 124 0 56.0 1.0 1 0 0 OZFD E:ORACLEPRODDATAOZFD01.DBF 8 0 0.0 1.0 1 0 0 OZFX E:ORACLEPRODDATAOZFX01.DBF 71 0 80.7 1.0 1 0 0 OZPD E:ORACLEPRODDATAOZPD01.DBF 8 0 0.0 1.0 1 0 0 OZPX E:ORACLEPRODDATAOZPX01.DBF 8 0 0.0 1.0 1 0 0 OZSD E:ORACLEPRODDATAOZSD01.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) -------------- ------- ------ ------- ------------ -------- ---------- ------ OZSX E:ORACLEPRODDATAOZSX01.DBF 9 0 0.0 1.0 1 0 0 PAD E:ORACLEPRODDATAPAD01.DBF 2 0 125.0 1.0 1 0 0 PAX E:ORACLEPRODDATAPAX01.DBF 587 0 71.2 1.0 1 0 0 PJMD E:ORACLEPRODDATAPJMD01.DBF 9 0 0.0 1.0 1 0 0 PJMX E:ORACLEPRODDATAPJMX01.DBF 30 0 41.3 1.0 1 0 0 PMID E:ORACLEPRODDATAPMID01.DBF 7 0 0.0 1.0 1 0 0 PMIX E:ORACLEPRODDATAPMIX01.DBF 12 0 32.5 1.0 1 0 0 PND E:ORACLEPRODDATAPND01.DBF 0 0 1 0 0 PNX E:ORACLEPRODDATAPNX01.DBF 150 0 105.0 1.0 1 0 0 POAD E:ORACLEPRODDATAPOAD01.DBF 2 0 0.0 1.0 1 0 0 POAX E:ORACLEPRODDATAPOAX01.DBF 2 0 0.0 1.0 1 0 0 POD E:ORACLEPRODDATAPOD01.DBF 20,099 12 78.5 1.6 77 0 4 95.0 E:ORACLEPRODDATAPOD02.DBF 8,630 5 75.2 3.3 306 0 3 26.7 E:ORACLEPRODDATAPOD03.DBF 4,985 3 72.8 6.6 4 0 0 F:ORACLEPRODDATAPOD04.DBF 12,342 7 81.6 4.6 1 0 0 POMD E:ORACLEPRODDATAPOMD01.DBF 2 0 0.0 1.0 1 0 0 POMX E:ORACLEPRODDATAPOMX01.DBF 2 0 0.0 1.0 1 0 0 POSD E:ORACLEPRODDATAPOSD01.DBF 9 0 0.0 1.0 1 0 0 POSX E:ORACLEPRODDATAPOSX01.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 POX E:ORACLEPRODDATAPOX01.DBF 1,343 1 102.3 1.1 102 0 0 E:ORACLEPRODDATAPOX02.DBF 2,011 1 87.3 1.1 173 0 0 F:ORACLEPRODDATAPOX03.DBF 1,024 1 88.3 1.1 88 0 0 F:ORACLEPRODDATAPOX04.DBF 328 0 86.7 1.3 27 0 0 PSAD E:ORACLEPRODDATAPSAD01.DBF 8 0 0.0 1.0 1 0 0 PSAX E:ORACLEPRODDATAPSAX01.DBF 10 0 3.0 1.0 1 0 0 PSBD E:ORACLEPRODDATAPSBD01.DBF 9 0 0.0 1.0 1 0 0 PSBX E:ORACLEPRODDATAPSBX01.DBF 227 0 64.6 1.0 1 0 0 PSPD E:ORACLEPRODDATAPSPD01.DBF 9 0 0.0 1.0 1 0 0 PSPX E:ORACLEPRODDATAPSPX01.DBF 123 0 81.1 1.0 1 0 0 PVD E:ORACLEPRODDATAPVD01.DBF 9 0 5.6 1.0 1 0 0 PVX E:ORACLEPRODDATAPVX01.DBF 54 0 61.7 1.0 1 0 0 QAD E:ORACLEPRODDATAQAD01.DBF 69 0 96.4 3.0 1 0 0 E:ORACLEPRODDATAQAD02.DBF 12 0 69.2 3.2 1 0 0 QAX E:ORACLEPRODDATAQAX01.DBF 61 0 107.4 1.0 1 0 0 QPD E:ORACLEPRODDATAQPD01.DBF 1,240 1 35.7 4.7 1 0 0 QPX E:ORACLEPRODDATAQPX01.DBF 299 0 43.1 1.0 1 0 0 RBS E:ORACLEPRODDATARBS01.DBF 36 0 63.1 1.0 1,268 1 0 F:ORACLEPRODDATARBS02.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) -------------- ------- ------ ------- ------------ -------- ---------- ------ 62 0 132.4 1.0 1,168 1 1 0.0 RBS G:ORACLEPRODDATARBS03.DBF 112 0 236.6 1.0 821 0 0 G:ORACLEPRODDATARBS04.DBF 24 0 153.3 1.0 893 1 0 RGX E:ORACLEPRODDATARGX01.DBF 73 0 106.7 1.0 0 0 0 RHXD E:ORACLEPRODDATARHXD01.DBF 9 0 0.0 1.0 1 0 0 RHXX E:ORACLEPRODDATARHXX01.DBF 9 0 0.0 1.0 1 0 0 RLAD E:ORACLEPRODDATARLAD01.DBF 9 0 0.0 1.0 1 0 0 RLAX E:ORACLEPRODDATARLAX01.DBF 25 0 69.6 1.0 1 0 0 RLMD E:ORACLEPRODDATARLMD01.DBF 7 0 0.0 1.0 1 0 0 RLMX E:ORACLEPRODDATARLMX01.DBF 24 0 78.8 1.0 1 0 0 SSPD E:ORACLEPRODDATASSPD01.DBF 9 0 0.0 1.0 1 0 0 SSPX E:ORACLEPRODDATASSPX01.DBF 25 0 118.4 1.0 1 0 0 SYSTEM E:ORACLEPRODDATASYSTEM01.DBF 1,410 1 90.9 2.5 15 0 184 80.2 E:ORACLEPRODDATASYSTEM02.DBF 1,521 1 95.4 2.5 14 0 228 65.7 E:ORACLEPRODDATASYSTEM03.DBF 1,527 1 98.6 2.6 15 0 255 62.0 E:ORACLEPRODDATASYSTEM04.DBF 1,423 1 95.7 2.4 29 0 147 52.6 E:ORACLEPRODDATASYSTEM05.DBF 1,273 1 87.7 2.5 22 0 117 51.5 TEMP F:ORACLEPRODDATATEMP01.DBF 4,826 3 5.3 9.8 4,163 2 117 51.5 TOOLS E:ORACLEPRODDATATOOLS01.DBF 554 0 81.2 1.0 111 0 0 E:ORACLEPRODDATATOOLS02.DBF 76 0 56.4 1.0 65 0 0 E:ORACLEPRODDATATOOLS03.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) -------------- ------- ------ ------- ------------ -------- ---------- ------ 769 0 84.6 1.0 109 0 0 VEAD E:ORACLEPRODDATAVEAD01.DBF 7 0 0.0 1.0 1 0 0 VEAX E:ORACLEPRODDATAVEAX01.DBF 19 0 82.1 1.0 1 0 0 VEHD E:ORACLEPRODDATAVEHD01.DBF 9 0 0.0 1.0 1 0 0 VEHX E:ORACLEPRODDATAVEHX01.DBF 16 0 29.4 1.0 1 0 0 WIPD E:ORACLEPRODDATAWIPD01.DBF 41 0 85.4 1.7 4 0 3 56.7 E:ORACLEPRODDATAWIPD02.DBF 933 1 95.8 1.8 4 0 69 57.5 E:ORACLEPRODDATAWIPD03.DBF 894 1 87.9 1.8 5 0 11 29.1 F:ORACLEPRODDATAWIPD04.DBF 494 0 87.2 1.8 0 0 32 36.6 G:ORACLEPRODDATAWIPD06.DBF 987 1 136.7 2.1 33 0 179 83.0 WIPX E:ORACLEPRODDATAWIPX01.DBF 50 0 94.8 1.0 20 0 0 E:ORACLEPRODDATAWIPX02.DBF 128 0 123.0 1.0 11 0 0 F:ORACLEPRODDATAWIPX03.DBF 25 0 112.8 1.0 17 0 0 WMSD E:ORACLEPRODDATAWMSD01.DBF 2 0 0.0 1.0 1 0 0 WMSX E:ORACLEPRODDATAWMSX01.DBF 58 0 90.0 1.0 1 0 0 WPSD E:ORACLEPRODDATAWPSD01.DBF 2 0 0.0 1.0 1 0 0 WPSX E:ORACLEPRODDATAWPSX01.DBF 2 0 0.0 1.0 1 0 0 WSHD E:ORACLEPRODDATAWSHD01.DBF 5,802 3 84.1 1.0 22 0 683 66.4 E:ORACLEPRODDATAWSHD02.DBF 3,971 2 84.1 1.0 1 0 852 63.3 F:ORACLEPRODDATAWSHD03.DBF 4,918 3 91.9 1.0 1 0 1,711 69.2 WSHX E:ORACLEPRODDATAWSHX01.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) -------------- ------- ------ ------- ------------ -------- ---------- ------ 85 0 68.8 1.4 29 0 1 190.0 WSHX E:ORACLEPRODDATAWSHX02.DBF 306 0 90.1 1.1 38 0 5 110.0 F:ORACLEPRODDATAWSHX03.DBF 11 0 109.1 1.0 9 0 0 WSMD E:ORACLEPRODDATAWSMD01.DBF 2 0 0.0 1.0 1 0 0 WSMX E:ORACLEPRODDATAWSMX01.DBF 33 0 76.4 1.0 1 0 0 XDPD E:ORACLEPRODDATAXDPD01.DBF 16 0 40.6 1.0 1 0 0 XDPX E:ORACLEPRODDATAXDPX01.DBF 134 0 101.6 1.0 1 0 0 XLAD E:ORACLEPRODDATAXLAD01.DBF 7 0 0.0 1.0 1 0 0 XLAX E:ORACLEPRODDATAXLAX01.DBF 8 0 7.5 1.0 1 0 0 XNCD E:ORACLEPRODDATAXNCD01.DBF 4 0 0.0 1.0 1 0 0 XNCX E:ORACLEPRODDATAXNCX01.DBF 14 0 56.4 1.0 1 0 0 XNMD E:ORACLEPRODDATAXNMD01.DBF 4 0 0.0 1.0 1 0 0 XNMX E:ORACLEPRODDATAXNMX01.DBF 4 0 0.0 1.0 1 0 0 XNPD E:ORACLEPRODDATAXNPD01.DBF 12 0 52.5 1.0 1 0 0 XNPX E:ORACLEPRODDATAXNPX01.DBF 136 0 81.8 1.0 1 0 0 XNSD E:ORACLEPRODDATAXNSD01.DBF 4 0 0.0 1.0 1 0 0 XNSX E:ORACLEPRODDATAXNSX01.DBF 7 0 40.0 1.0 1 0 0 XTRD E:ORACLEPRODDATAXTRD01.DBF 0 0 1 0 0 XTRX E:ORACLEPRODDATAXTRX01.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) -------------- ------- ------ ------- ------------ -------- ---------- ------ 252 0 120.0 1.0 1 0 0 ------------------------------------------------------------- �Buffer Pool Statistics for DB: PROD Instance: prod Snaps: 320 -321 -> Pools D: default pool, K: keep pool, R: recycle pool Free Write Buffer Buffer Consistent Physical Physical Buffer Complete Busy P Gets Gets Reads Writes Waits Waits Waits - ----------- ------------- ----------- ---------- ------- -------- ---------- D 1,460,613 50,039,214 1,435,895 11,683 0 0 212,828 ------------------------------------------------------------- Buffer wait Statistics for DB: PROD Instance: prod Snaps: 320 -321 -> ordered by wait time desc, waits desc Tot Wait Avg Class Waits Time (cs) Time (cs) ------------------ ----------- ---------- --------- data block 209,916 978,895 5 bitmap block 3 0 0 undo header 1 0 0 ------------------------------------------------------------- Enqueue activity for DB: PROD Instance: prod Snaps: 320 -321 -> ordered by waits desc, gets desc Enqueue Gets Waits ---------- ------------ ---------- TX 9,689 2 CF 28 1 ------------------------------------------------------------- �Rollback Segment Stats for DB: PROD Instance: prod Snaps: 320 -321 ->A high value for "Pct Waits" suggests more rollback segments may be required Trans Table Pct Undo Bytes RBS No Gets Waits Written Wraps Shrinks Extends ------ ------------ ------- --------------- -------- -------- -------- 0 6.0 0.00 0 0 0 0 2 2,010.0 0.00 1,620,938 2 0 0 3 2,616.0 0.00 2,523,740 3 0 0 4 705.0 0.00 795,054 1 0 0 5 1,924.0 0.00 1,256,936 1 0 0 6 3,377.0 0.00 4,860,058 5 0 0 7 1,731.0 0.00 1,467,696 2 0 0 8 413.0 0.00 75,450 0 0 0 9 2,838.0 0.00 2,115,354 2 0 0 10 4,445.0 0.00 11,548 0 0 0 11 1,890.0 0.00 1,007,182 1 0 0 12 766.0 0.00 497,182 0 0 0 13 636.0 0.00 250,990 0 0 0 14 1,806.0 0.00 938,144 1 0 0 15 1,171.0 0.00 526,052 1 0 0 16 2,797.0 0.00 2,169,632 3 0 0 17 1,696.0 0.00 870,760 1 0 0 ------------------------------------------------------------- �Rollback Segment Storage for DB: PROD Instance: prod Snaps: 320 -321 ->Optimal Size should be larger than Avg Active RBS No Segment Size Avg Active Optimal Size Maximum Size ------ --------------- --------------- --------------- --------------- 0 155,648 0 155,648 2 104,849,408 1,063,485 104,857,600 104,849,408 3 104,849,408 1,210,328 104,857,600 104,849,408 4 104,849,408 919,927 104,857,600 104,849,408 5 104,849,408 1,050,642 104,857,600 104,849,408 6 104,849,408 1,182,345 104,857,600 104,849,408 7 104,841,216 4,215,633 104,857,600 104,841,216 8 104,849,408 588,250 104,857,600 104,849,408 9 104,849,408 2,406,491 104,857,600 104,849,408 10 104,849,408 818,875 104,857,600 104,849,408 11 104,849,408 1,520,736 104,857,600 104,849,408 12 104,849,408 3,596,472 104,857,600 104,849,408 13 104,849,408 1,576,503 104,857,600 104,849,408 14 104,849,408 1,902,458 104,857,600 104,849,408 15 104,849,408 1,678,760 104,857,600 104,849,408 16 104,849,408 567,759 104,857,600 104,849,408 17 104,849,408 389,020 104,857,600 104,849,408 ------------------------------------------------------------- �Latch Activity for DB: PROD Instance: prod Snaps: 320 -321 ->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests ->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests ->"Pct Misses" for both should be very close to 0.0 Pct Avg Pct Get Get Slps NoWait NoWait Latch Name Requests Miss /Miss Requests Miss ----------------------------- -------------- ------ ------ ------------ ------ JOX SGA heap latch 456 0.0 0 Token Manager 3,209 0.0 0 active checkpoint queue latch 8,788 0.0 0 archive control 2 0.0 0 archive process latch 2 0.0 0 begin backup scn array 588 0.0 0 cache buffer handles 221,108 0.0 0.0 0 cache buffers chains 206,262,109 0.2 0.0 2,449,381 0.1 cache buffers lru chain 1,599,332 0.2 0.1 1,435,553 0.1 channel handle pool latch 567 0.0 0 channel operations parent lat 843 0.0 0 checkpoint queue latch 116,034 0.0 0.0 0 dictionary lookup 4 0.0 0 dml lock allocation 37,835 0.0 0 enqueue hash chains 100,984 0.0 0.0 0 enqueues 143,290 0.0 0.1 0 error message lists 2 0.0 0 event group latch 276 0.0 0 file number translation table 773 0.0 0 job_queue_processes parameter 25 0.0 0 ktm global data 5 0.0 0 kwqit: protect wakeup time 64 0.0 0 latch wait list 1,652 0.1 0.0 1,661 0.1 library cache 7,153,106 0.2 0.1 0 library cache load lock 361 0.0 0 list of block allocation 19,967 0.0 0 loader state object freelist 3,254 0.0 0 longop free list 85,340 0.0 0.0 0 messages 62,769 0.0 0.1 0 multiblock read objects 466,368 0.0 0.2 0 ncodef allocation latch 25 0.0 0 parallel query alloc buffer 24 0.0 0 parallel query stats 8 0.0 0 process allocation 276 0.0 276 0.0 process group creation 549 0.0 0 process queue 14 0.0 0 process queue reference 138 0.0 8 0.0 query server freelists 24 0.0 0 query server process 2 0.0 0 redo allocation 211,586 0.0 0.0 0 redo writing 36,680 0.1 0.0 0 row cache objects 647,146 0.1 0.0 0 sequence cache 22,200 0.0 0.0 0 session allocation 56,745 0.0 0.0 0 session idle bit 559,512 0.0 0.0 0 session switching 770 0.0 0 shared pool 246,503 0.0 0.1 0 sort extent pool 5,002 0.0 0 temp lob duration state obj a 148 0.0 0 temporary table state object 41 0.0 0 �Latch Activity for DB: PROD Instance: prod Snaps: 320 -321 ->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests ->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests ->"Pct Misses" for both should be very close to 0.0 Pct Avg Pct Get Get Slps NoWait NoWait Latch Name Requests Miss /Miss Requests Miss ----------------------------- -------------- ------ ------ ------------ ------ transaction allocation 31,706 0.0 0 transaction branch allocation 25 0.0 0 undo global data 109,196 0.0 0.0 0 user lock 2,024 0.0 0 ------------------------------------------------------------- �Latch Sleep breakdown for DB: PROD Instance: prod Snaps: 320 -321 -> ordered by misses desc Get Spin & Latch Name Requests Misses Sleeps Sleeps 1->4 -------------------------- -------------- ----------- ----------- ------------ cache buffers chains 206,262,109 343,711 3,414 340641/2747/ 304/19/0 library cache 7,153,106 16,277 2,114 14624/1266/3 13/74/0 cache buffers lru chain 1,599,332 2,605 236 2422/137/41/ 5/0 row cache objects 647,146 489 16 474/14/1/0/0 multiblock read objects 466,368 85 17 72/9/4/0/0 shared pool 246,503 54 3 51/3/0/0/0 redo writing 36,680 39 1 38/1/0/0/0 messages 62,769 15 2 13/2/0/0/0 enqueues 143,290 8 1 7/1/0/0/0 ------------------------------------------------------------- �Latch Miss Sources for DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, sleeps desc NoWait Waiter Latch Name Where Misses Sleeps Sleeps ------------------------ -------------------------- ------- ---------- ------- cache buffers chains kcbgtcr: kslbegin 0 2,650 2,764 cache buffers chains kcbrls: kslbegin 0 507 304 cache buffers chains kcbzwb 0 177 242 cache buffers chains kcbzib: finish free bufs 0 36 55 cache buffers chains kcbgcur: kslbegin 0 14 32 cache buffers chains kcbzgb: scan from tail. no 0 8 0 cache buffers chains kcbzib: multi-block read: 0 8 0 cache buffers chains kcbchg: kslbegin: bufs not 0 1 1 cache buffers lru chain kcbzgb: multiple sets nowa 0 148 0 cache buffers lru chain kcbbiop: lru scan 0 45 0 cache buffers lru chain kcbzar: KSLNBEGIN 0 43 220 enqueues ksqdel 0 1 0 library cache kglhdgn: child: 0 1,330 192 library cache kglget: child: KGLDSBRD 0 321 35 library cache kglget: child: KGLDSBYD 0 162 212 library cache kglpnal: child: before pro 0 78 373 library cache kglpnal: child: alloc spac 0 67 157 library cache kglpin 0 45 64 library cache kglpnp: child 0 28 450 library cache kglic 0 24 11 library cache kglupc: child 0 16 236 library cache kgllkdl: child: cleanup 0 15 10 library cache kglpnc: child 0 14 309 library cache kglhdgc: child: 0 4 3 library cache kglobpn: child: 0 4 0 library cache kglpnal: parent held, no p 0 2 0 library cache kgllkdl: child: free pin 0 2 236 library cache kglpndl: parent: purge 0 1 0 messages ksaamb: after wakeup 0 1 2 messages ksarcv: after wait 0 1 0 multiblock read objects kcbzib: MBRGET 0 9 9 multiblock read objects kcbzib: MBRFRE 0 8 8 redo writing kcrfsr 0 1 0 row cache objects kqrpre: find obj 0 15 14 row cache objects kqreqd: rel enqueue 0 1 0 shared pool kghalo 0 2 0 shared pool kghfen: not perm alloc cla 0 1 0 ------------------------------------------------------------- �Parent Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name Get Spin & Latch Name Requests Misses Sleeps Sleeps 1->4 ------------------------ -------------- ----------- ---------- ------------ enqueues 143,564 8 1 7/1/0/0/0 messages 64,602 16 1 15/1/0/0/0 multiblock read objects 461,409 84 16 72/8/4/0/0 redo writing 36,789 40 2 38/2/0/0/0 row cache objects 691,191 504 18 488/14/2/0/0 shared pool 251,069 59 5 54/5/0/0/0 ------------------------------------------------------------- �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- cache buffers chains 1009 16,667,502 9,001 51 8953/45/3/0/0 cache buffers chains 447 15,807,412 6,836 78 6762/71/2/1/0 cache buffers chains 59 15,731,001 1,538 31 1512/22/3/1/0 cache buffers chains 61 7,843,148 2,248 73 2185/55/7/1/0 cache buffers chains 453 3,515,422 8,720 79 8649/63/8/0/0 cache buffers chains 518 3,123,713 62,294 769 61562/696/35/ 1/0 cache buffers chains 332 2,849,680 291 2 289/2/0/0/0 cache buffers chains 305 2,750,081 464 4 460/4/0/0/0 cache buffers chains 944 2,648,653 1,549 12 1537/12/0/0/0 cache buffers chains 339 2,570,261 303 12 295/4/4/0/0 cache buffers chains 552 2,470,549 4,793 13 4782/9/2/0/0 cache buffers chains 599 2,292,059 1,930 16 1916/13/0/1/0 cache buffers chains 91 2,219,760 652 7 645/7/0/0/0 cache buffers chains 607 1,978,415 920 19 902/17/1/0/0 cache buffers chains 597 1,903,085 206 5 203/1/2/0/0 cache buffers chains 947 1,777,496 581 3 578/3/0/0/0 cache buffers chains 33 1,733,187 974 16 958/16/0/0/0 cache buffers chains 313 1,697,433 421 8 416/2/3/0/0 cache buffers chains 936 1,457,210 796 19 784/5/7/0/0 cache buffers chains 267 1,427,454 460 2 458/2/0/0/0 cache buffers chains 581 1,426,899 142 4 138/4/0/0/0 cache buffers chains 335 1,339,710 165 3 162/3/0/0/0 cache buffers chains 551 1,193,837 151 6 145/6/0/0/0 cache buffers chains 483 1,140,397 165 5 160/5/0/0/0 cache buffers chains 943 976,705 550 3 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 547/3/0/0/0 cache buffers chains 47 883,443 521 5 518/2/0/1/0 cache buffers chains 897 822,674 165 4 162/2/1/0/0 cache buffers chains 25 775,468 416 7 410/5/1/0/0 cache buffers chains 839 654,259 466 12 455/10/1/0/0 cache buffers chains 717 649,858 250 2 248/2/0/0/0 cache buffers chains 637 643,639 592 11 581/11/0/0/0 cache buffers chains 604 610,917 434 18 419/12/3/0/0 cache buffers chains 999 599,965 403 7 396/7/0/0/0 cache buffers chains 1019 485,739 510 26 489/18/1/2/0 cache buffers chains 956 464,274 501 2 499/2/0/0/0 cache buffers chains 409 438,196 609 28 582/26/1/0/0 cache buffers chains 137 434,159 226 5 222/3/1/0/0 cache buffers chains 958 433,045 149 1 148/1/0/0/0 cache buffers chains 250 425,857 488 23 470/13/5/0/0 cache buffers chains 109 417,464 451 25 431/15/5/0/0 cache buffers chains 1010 411,461 209 4 205/4/0/0/0 cache buffers chains 940 404,057 149 16 140/2/7/0/0 cache buffers chains 553 401,011 361 24 339/20/2/0/0 cache buffers chains 695 394,670 133 3 130/3/0/0/0 cache buffers chains 730 388,425 180 5 175/5/0/0/0 cache buffers chains 917 379,310 176 1 175/1/0/0/0 cache buffers chains 939 372,254 110 3 108/1/1/0/0 cache buffers chains 37 371,763 242 1 241/1/0/0/0 cache buffers chains 856 357,287 337 21 320/13/4/0/0 cache buffers chains 971 349,602 163 7 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 156/7/0/0/0 cache buffers chains 984 335,692 158 3 156/1/1/0/0 cache buffers chains 818 329,007 278 9 271/5/2/0/0 cache buffers chains 968 328,880 162 1 161/1/0/0/0 cache buffers chains 985 326,962 154 1 153/1/0/0/0 cache buffers chains 983 324,554 169 1 168/1/0/0/0 cache buffers chains 90 318,544 186 1 185/1/0/0/0 cache buffers chains 1003 308,904 172 1 171/1/0/0/0 cache buffers chains 975 307,793 194 7 187/7/0/0/0 cache buffers chains 992 305,723 149 2 147/2/0/0/0 cache buffers chains 1004 305,602 233 2 231/2/0/0/0 cache buffers chains 995 302,563 116 2 114/2/0/0/0 cache buffers chains 857 302,109 268 10 261/5/1/1/0 cache buffers chains 341 301,678 165 4 161/4/0/0/0 cache buffers chains 991 300,070 201 1 200/1/0/0/0 cache buffers chains 456 298,842 231 5 226/5/0/0/0 cache buffers chains 138 297,379 144 3 141/3/0/0/0 cache buffers chains 981 296,589 104 1 103/1/0/0/0 cache buffers chains 457 296,132 255 6 250/4/1/0/0 cache buffers chains 987 294,680 243 19 228/11/4/0/0 cache buffers chains 963 294,273 201 2 200/0/1/0/0 cache buffers chains 608 287,955 201 3 199/1/1/0/0 cache buffers chains 711 284,226 147 5 142/5/0/0/0 cache buffers chains 435 282,908 307 4 303/4/0/0/0 cache buffers chains 988 280,174 257 4 254/2/1/0/0 cache buffers chains 819 279,607 229 5 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 224/5/0/0/0 cache buffers chains 436 277,509 291 1 290/1/0/0/0 cache buffers chains 821 274,582 244 3 241/3/0/0/0 cache buffers chains 445 273,730 269 3 266/3/0/0/0 cache buffers chains 437 270,025 254 1 253/1/0/0/0 cache buffers chains 685 268,129 145 2 143/2/0/0/0 cache buffers chains 444 260,478 213 3 210/3/0/0/0 cache buffers chains 994 259,926 108 2 106/2/0/0/0 cache buffers chains 443 259,493 250 1 249/1/0/0/0 cache buffers chains 440 258,713 177 1 176/1/0/0/0 cache buffers chains 438 257,304 226 1 225/1/0/0/0 cache buffers chains 455 256,563 191 4 188/2/1/0/0 cache buffers chains 460 256,268 222 2 220/2/0/0/0 cache buffers chains 241 255,343 219 3 216/3/0/0/0 cache buffers chains 439 254,258 227 1 226/1/0/0/0 cache buffers chains 450 252,704 242 1 241/1/0/0/0 cache buffers chains 442 250,303 215 1 214/1/0/0/0 cache buffers chains 448 246,484 215 6 209/6/0/0/0 cache buffers chains 461 244,115 193 1 192/1/0/0/0 cache buffers chains 452 242,124 230 2 228/2/0/0/0 cache buffers chains 951 236,992 217 1 216/1/0/0/0 cache buffers chains 496 209,912 101 1 100/1/0/0/0 cache buffers chains 1 207,864 204 1 203/1/0/0/0 cache buffers chains 67 207,023 192 2 190/2/0/0/0 cache buffers chains 125 206,435 145 2 143/2/0/0/0 cache buffers chains 962 203,295 183 5 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 178/5/0/0/0 cache buffers chains 970 198,414 119 1 118/1/0/0/0 cache buffers chains 1022 198,199 183 1 182/1/0/0/0 cache buffers chains 598 193,939 121 3 118/3/0/0/0 cache buffers chains 148 192,444 232 3 229/3/0/0/0 cache buffers chains 1020 185,835 209 1 208/1/0/0/0 cache buffers chains 306 181,882 145 1 144/1/0/0/0 cache buffers chains 155 181,737 837 2 836/0/1/0/0 cache buffers chains 1024 176,516 186 1 185/1/0/0/0 cache buffers chains 51 175,554 175 1 174/1/0/0/0 cache buffers chains 520 175,081 76 1 75/1/0/0/0 cache buffers chains 11 169,335 181 5 176/5/0/0/0 cache buffers chains 66 161,797 245 7 238/7/0/0/0 cache buffers chains 926 161,012 161 1 160/1/0/0/0 cache buffers chains 325 159,672 133 1 132/1/0/0/0 cache buffers chains 1018 158,046 204 1 203/1/0/0/0 cache buffers chains 480 151,470 116 2 114/2/0/0/0 cache buffers chains 515 148,027 346 1 345/1/0/0/0 cache buffers chains 10 141,841 154 7 147/7/0/0/0 cache buffers chains 422 140,301 174 1 173/1/0/0/0 cache buffers chains 372 139,834 131 3 130/0/0/1/0 cache buffers chains 21 139,738 181 1 180/1/0/0/0 cache buffers chains 240 139,677 287 3 285/1/1/0/0 cache buffers chains 101 139,030 153 3 150/3/0/0/0 cache buffers chains 62 137,297 127 1 126/1/0/0/0 cache buffers chains 108 134,260 182 3 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 180/1/1/0/0 cache buffers chains 879 128,819 187 2 186/0/1/0/0 cache buffers chains 64 126,590 184 3 181/3/0/0/0 cache buffers chains 403 124,564 93 1 92/1/0/0/0 cache buffers chains 102 122,520 130 2 128/2/0/0/0 cache buffers chains 309 122,230 210 1 209/1/0/0/0 cache buffers chains 45 119,973 223 8 216/6/1/0/0 cache buffers chains 609 116,962 183 4 179/4/0/0/0 cache buffers chains 1017 116,570 205 9 197/7/1/0/0 cache buffers chains 1014 116,030 215 1 214/1/0/0/0 cache buffers chains 462 116,004 139 1 138/1/0/0/0 cache buffers chains 77 113,943 177 1 176/1/0/0/0 cache buffers chains 386 111,368 181 4 177/4/0/0/0 cache buffers chains 55 110,945 163 1 162/1/0/0/0 cache buffers chains 245 110,454 223 1 222/1/0/0/0 cache buffers chains 197 110,057 183 1 182/1/0/0/0 cache buffers chains 57 109,710 208 1 207/1/0/0/0 cache buffers chains 1012 109,162 189 1 188/1/0/0/0 cache buffers chains 29 108,376 181 2 179/2/0/0/0 cache buffers chains 41 107,380 221 2 219/2/0/0/0 cache buffers chains 132 107,372 198 2 196/2/0/0/0 cache buffers chains 19 106,615 145 1 144/1/0/0/0 cache buffers chains 913 104,434 139 2 137/2/0/0/0 cache buffers chains 342 104,323 166 1 165/1/0/0/0 cache buffers chains 929 104,196 174 3 172/1/1/0/0 cache buffers chains 79 103,390 164 2 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 162/2/0/0/0 cache buffers chains 133 102,940 163 1 162/1/0/0/0 cache buffers chains 144 102,877 158 5 153/5/0/0/0 cache buffers chains 899 102,637 151 1 150/1/0/0/0 cache buffers chains 314 101,825 165 8 159/5/0/1/0 cache buffers chains 32 101,709 188 1 187/1/0/0/0 cache buffers chains 221 101,108 180 3 177/3/0/0/0 cache buffers chains 92 101,102 220 1 219/1/0/0/0 cache buffers chains 27 99,122 138 4 136/1/0/1/0 cache buffers chains 585 98,876 122 1 121/1/0/0/0 cache buffers chains 915 98,870 133 1 132/1/0/0/0 cache buffers chains 726 98,780 155 1 154/1/0/0/0 cache buffers chains 887 98,591 113 1 112/1/0/0/0 cache buffers chains 68 98,458 157 2 155/2/0/0/0 cache buffers chains 107 98,430 154 3 152/1/1/0/0 cache buffers chains 577 97,711 116 1 115/1/0/0/0 cache buffers chains 378 97,641 141 1 140/1/0/0/0 cache buffers chains 42 97,278 278 8 270/8/0/0/0 cache buffers chains 52 96,137 156 1 155/1/0/0/0 cache buffers chains 260 95,852 154 3 152/1/1/0/0 cache buffers chains 433 95,624 209 13 201/6/0/2/0 cache buffers chains 75 95,239 208 2 207/0/1/0/0 cache buffers chains 26 94,599 124 1 123/1/0/0/0 cache buffers chains 479 93,695 93 1 92/1/0/0/0 cache buffers chains 567 93,651 96 1 95/1/0/0/0 cache buffers chains 296 92,960 133 2 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 131/2/0/0/0 cache buffers chains 324 92,838 137 3 135/1/1/0/0 cache buffers chains 875 92,694 177 1 176/1/0/0/0 cache buffers chains 868 91,348 170 4 166/4/0/0/0 cache buffers chains 918 91,041 183 7 176/7/0/0/0 cache buffers chains 238 89,763 131 8 124/6/1/0/0 cache buffers chains 719 89,709 158 1 157/1/0/0/0 cache buffers chains 180 89,680 131 3 128/3/0/0/0 cache buffers chains 925 89,659 167 1 166/1/0/0/0 cache buffers chains 919 89,533 241 1 240/1/0/0/0 cache buffers chains 171 89,139 229 1 228/1/0/0/0 cache buffers chains 194 88,485 164 1 163/1/0/0/0 cache buffers chains 167 88,310 139 4 135/4/0/0/0 cache buffers chains 315 88,149 170 1 169/1/0/0/0 cache buffers chains 97 88,096 126 3 123/3/0/0/0 cache buffers chains 532 87,868 107 6 102/4/1/0/0 cache buffers chains 242 87,805 214 1 213/1/0/0/0 cache buffers chains 297 87,726 759 5 755/3/1/0/0 cache buffers chains 700 86,849 102 1 101/1/0/0/0 cache buffers chains 816 86,795 93 1 92/1/0/0/0 cache buffers chains 661 86,710 153 1 152/1/0/0/0 cache buffers chains 93 86,432 192 2 190/2/0/0/0 cache buffers chains 762 85,986 156 2 154/2/0/0/0 cache buffers chains 239 85,319 140 4 136/4/0/0/0 cache buffers chains 219 84,737 157 3 154/3/0/0/0 cache buffers chains 784 84,659 111 7 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 104/7/0/0/0 cache buffers chains 867 84,584 161 2 159/2/0/0/0 cache buffers chains 174 83,761 213 1 212/1/0/0/0 cache buffers chains 210 82,834 140 2 138/2/0/0/0 cache buffers chains 192 82,413 145 2 143/2/0/0/0 cache buffers chains 199 82,320 214 10 205/8/1/0/0 cache buffers chains 257 81,899 215 1 214/1/0/0/0 cache buffers chains 920 81,781 209 3 206/3/0/0/0 cache buffers chains 921 81,523 209 1 208/1/0/0/0 cache buffers chains 17 81,491 140 3 138/1/1/0/0 cache buffers chains 873 81,482 152 7 146/5/1/0/0 cache buffers chains 373 81,337 165 6 159/6/0/0/0 cache buffers chains 708 81,118 159 2 158/0/1/0/0 cache buffers chains 869 81,094 147 5 142/5/0/0/0 cache buffers chains 878 80,875 146 1 145/1/0/0/0 cache buffers chains 922 80,465 229 1 228/1/0/0/0 cache buffers chains 198 80,355 194 6 188/6/0/0/0 cache buffers chains 713 80,244 140 1 139/1/0/0/0 cache buffers chains 458 79,927 162 1 161/1/0/0/0 cache buffers chains 70 79,837 130 1 129/1/0/0/0 cache buffers chains 379 79,749 110 4 108/0/2/0/0 cache buffers chains 273 79,749 126 2 124/2/0/0/0 cache buffers chains 809 79,495 106 2 105/0/1/0/0 cache buffers chains 725 79,209 155 3 153/1/1/0/0 cache buffers chains 244 78,934 192 1 191/1/0/0/0 cache buffers chains 128 78,716 214 5 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 209/5/0/0/0 cache buffers chains 183 78,713 174 10 168/2/4/0/0 cache buffers chains 222 78,327 152 1 151/1/0/0/0 cache buffers chains 535 78,271 94 2 92/2/0/0/0 cache buffers chains 610 78,264 134 2 132/2/0/0/0 cache buffers chains 769 78,136 152 1 151/1/0/0/0 cache buffers chains 141 77,923 121 1 120/1/0/0/0 cache buffers chains 391 77,577 96 1 95/1/0/0/0 cache buffers chains 884 77,252 100 7 96/1/3/0/0 cache buffers chains 277 77,119 155 1 154/1/0/0/0 cache buffers chains 349 76,578 158 1 157/1/0/0/0 cache buffers chains 720 76,486 187 1 186/1/0/0/0 cache buffers chains 780 76,360 89 2 87/2/0/0/0 cache buffers chains 774 76,282 125 1 124/1/0/0/0 cache buffers chains 704 75,999 153 6 147/6/0/0/0 cache buffers chains 136 75,936 169 3 166/3/0/0/0 cache buffers chains 274 75,787 130 2 129/0/1/0/0 cache buffers chains 865 75,546 162 5 158/3/1/0/0 cache buffers chains 323 75,501 113 2 111/2/0/0/0 cache buffers chains 166 75,301 149 4 145/4/0/0/0 cache buffers chains 885 74,686 66 1 65/1/0/0/0 cache buffers chains 904 74,342 170 1 169/1/0/0/0 cache buffers chains 370 74,133 155 9 148/5/2/0/0 cache buffers chains 864 73,472 124 1 123/1/0/0/0 cache buffers chains 340 73,245 118 1 117/1/0/0/0 cache buffers chains 348 73,142 167 7 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 161/5/1/0/0 cache buffers chains 529 73,040 135 1 134/1/0/0/0 cache buffers chains 732 73,014 250 2 248/2/0/0/0 cache buffers chains 357 72,472 155 3 152/3/0/0/0 cache buffers chains 702 72,460 99 9 94/1/4/0/0 cache buffers chains 225 72,160 138 1 137/1/0/0/0 cache buffers chains 223 72,102 140 1 139/1/0/0/0 cache buffers chains 861 70,535 140 1 139/1/0/0/0 cache buffers chains 412 70,466 143 5 138/5/0/0/0 cache buffers chains 346 70,374 139 2 137/2/0/0/0 cache buffers chains 262 69,971 132 2 130/2/0/0/0 cache buffers chains 892 69,798 121 4 117/4/0/0/0 cache buffers chains 358 69,611 150 1 149/1/0/0/0 cache buffers chains 353 69,567 188 1 187/1/0/0/0 cache buffers chains 380 69,351 96 1 95/1/0/0/0 cache buffers chains 779 69,328 111 7 105/5/1/0/0 cache buffers chains 301 69,122 130 9 126/0/3/1/0 cache buffers chains 614 69,106 147 2 146/0/1/0/0 cache buffers chains 768 68,942 139 1 138/1/0/0/0 cache buffers chains 786 68,571 113 1 112/1/0/0/0 cache buffers chains 281 68,557 174 7 169/3/2/0/0 cache buffers chains 387 67,963 125 8 119/4/2/0/0 cache buffers chains 831 67,733 81 3 79/1/1/0/0 cache buffers chains 814 67,159 98 1 97/1/0/0/0 cache buffers chains 291 66,568 173 1 172/1/0/0/0 cache buffers chains 870 66,370 164 4 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 160/4/0/0/0 cache buffers chains 763 66,273 152 5 147/5/0/0/0 cache buffers chains 295 65,566 184 4 181/2/1/0/0 cache buffers chains 181 65,287 119 6 116/0/3/0/0 cache buffers chains 270 65,272 173 1 172/1/0/0/0 cache buffers chains 298 65,232 145 1 144/1/0/0/0 cache buffers chains 737 65,184 150 1 149/1/0/0/0 cache buffers chains 344 65,007 130 2 128/2/0/0/0 cache buffers chains 838 63,837 139 1 138/1/0/0/0 cache buffers chains 228 63,458 132 1 131/1/0/0/0 cache buffers chains 880 63,423 161 9 154/5/2/0/0 cache buffers chains 367 63,397 114 5 110/3/1/0/0 cache buffers chains 327 62,510 139 2 137/2/0/0/0 cache buffers chains 639 62,112 105 8 100/2/3/0/0 cache buffers chains 706 61,510 152 1 151/1/0/0/0 cache buffers chains 285 60,242 113 2 111/2/0/0/0 cache buffers chains 376 59,839 180 1 179/1/0/0/0 cache buffers chains 343 59,788 159 2 158/0/1/0/0 cache buffers chains 465 59,094 110 1 109/1/0/0/0 cache buffers chains 544 59,012 135 2 133/2/0/0/0 cache buffers chains 690 58,474 136 2 134/2/0/0/0 cache buffers chains 329 58,434 172 2 170/2/0/0/0 cache buffers chains 754 58,348 175 1 174/1/0/0/0 cache buffers chains 692 58,308 146 10 138/6/2/0/0 cache buffers chains 733 58,285 233 9 229/0/3/1/0 cache buffers chains 788 57,840 164 3 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 161/3/0/0/0 cache buffers chains 669 57,578 144 1 143/1/0/0/0 cache buffers chains 351 57,279 194 1 193/1/0/0/0 cache buffers chains 759 57,275 135 4 131/4/0/0/0 cache buffers chains 679 56,980 123 3 120/3/0/0/0 cache buffers chains 721 56,820 156 1 155/1/0/0/0 cache buffers chains 709 56,515 129 13 121/3/5/0/0 cache buffers chains 516 56,502 101 3 98/3/0/0/0 cache buffers chains 770 56,321 138 1 137/1/0/0/0 cache buffers chains 724 56,271 142 2 140/2/0/0/0 cache buffers chains 662 56,165 187 8 181/4/2/0/0 cache buffers chains 428 55,730 128 1 127/1/0/0/0 cache buffers chains 659 55,485 174 1 173/1/0/0/0 cache buffers chains 699 54,528 109 2 108/0/1/0/0 cache buffers chains 475 54,324 101 2 99/2/0/0/0 cache buffers chains 777 53,823 153 2 151/2/0/0/0 cache buffers chains 418 53,720 97 1 96/1/0/0/0 cache buffers chains 360 53,592 143 1 142/1/0/0/0 cache buffers chains 715 53,383 185 5 180/5/0/0/0 cache buffers chains 734 53,304 163 12 156/2/5/0/0 cache buffers chains 677 52,901 130 1 129/1/0/0/0 cache buffers chains 712 52,578 128 1 127/1/0/0/0 cache buffers chains 688 52,569 133 1 132/1/0/0/0 cache buffers chains 419 52,498 107 1 106/1/0/0/0 cache buffers chains 559 52,381 114 6 109/4/1/0/0 cache buffers chains 561 52,045 104 1 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 103/1/0/0/0 cache buffers chains 539 52,032 75 4 71/4/0/0/0 cache buffers chains 755 51,907 183 2 182/0/1/0/0 cache buffers chains 666 51,082 114 2 113/0/1/0/0 cache buffers chains 657 50,996 91 1 90/1/0/0/0 cache buffers chains 855 50,478 195 3 192/3/0/0/0 cache buffers chains 701 50,230 100 3 98/1/1/0/0 cache buffers chains 682 50,184 151 2 149/2/0/0/0 cache buffers chains 670 49,834 118 9 111/5/2/0/0 cache buffers chains 852 49,486 115 2 113/2/0/0/0 cache buffers chains 753 49,439 135 3 132/3/0/0/0 cache buffers chains 756 49,054 171 3 168/3/0/0/0 cache buffers chains 664 48,056 110 2 108/2/0/0/0 cache buffers chains 463 47,613 131 2 129/2/0/0/0 cache buffers chains 824 46,928 150 1 149/1/0/0/0 cache buffers chains 415 46,672 105 2 103/2/0/0/0 cache buffers chains 537 46,398 99 5 94/5/0/0/0 cache buffers chains 687 46,132 132 1 131/1/0/0/0 cache buffers chains 660 46,122 157 7 151/5/1/0/0 cache buffers chains 434 45,945 181 2 180/0/1/0/0 cache buffers chains 676 45,675 122 2 121/0/1/0/0 cache buffers chains 499 45,670 152 1 151/1/0/0/0 cache buffers chains 481 45,630 97 1 96/1/0/0/0 cache buffers chains 847 44,310 186 1 185/1/0/0/0 cache buffers chains 420 43,864 128 1 127/1/0/0/0 cache buffers chains 545 43,825 121 1 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 120/1/0/0/0 cache buffers chains 548 43,662 93 2 92/0/1/0/0 cache buffers chains 454 42,858 163 1 162/1/0/0/0 cache buffers chains 853 42,653 134 1 133/1/0/0/0 cache buffers chains 568 42,495 102 1 101/1/0/0/0 cache buffers chains 843 41,934 135 1 134/1/0/0/0 cache buffers chains 497 41,667 129 14 122/0/7/0/0 cache buffers chains 524 41,287 102 2 101/0/1/0/0 cache buffers chains 596 40,708 137 1 136/1/0/0/0 cache buffers chains 546 39,284 114 1 113/1/0/0/0 cache buffers chains 626 38,785 89 1 88/1/0/0/0 cache buffers chains 549 38,690 102 1 101/1/0/0/0 cache buffers chains 486 38,641 101 1 100/1/0/0/0 cache buffers chains 593 36,991 150 1 149/1/0/0/0 cache buffers chains 793 35,698 86 2 85/0/1/0/0 cache buffers chains 642 35,312 119 1 118/1/0/0/0 cache buffers chains 509 35,084 115 4 111/4/0/0/0 cache buffers chains 495 34,831 96 2 95/0/1/0/0 cache buffers chains 547 34,606 122 1 121/1/0/0/0 cache buffers chains 650 33,559 140 1 139/1/0/0/0 cache buffers chains 643 33,140 104 3 102/1/1/0/0 cache buffers chains 644 31,637 112 1 111/1/0/0/0 cache buffers chains 641 30,901 138 1 137/1/0/0/0 cache buffers chains 647 30,636 112 7 106/5/1/0/0 cache buffers chains 645 29,617 100 1 99/1/0/0/0 cache buffers chains 621 29,026 151 1 �Child Latch Statistics DB: PROD Instance: prod Snaps: 320 -321 -> only latches with sleeps are shown -> ordered by name, gets desc Child Get Latch Name Num Requests Misses Sleeps ---------------------- ------ -------------- ----------- ---------- Spin & Sleeps 1->4 ------------- 150/1/0/0/0 cache buffers chains 606 27,594 145 5 140/5/0/0/0 cache buffers chains 622 26,580 146 1 145/1/0/0/0 cache buffers chains 487 26,189 109 1 108/1/0/0/0 cache buffers chains 470 25,028 101 2 99/2/0/0/0 cache buffers lru chai 4 399,980 666 47 626/33/7/0/0 cache buffers lru chai 2 397,259 647 52 604/34/9/0/0 cache buffers lru chai 3 394,723 628 65 587/22/15/4/0 cache buffers lru chai 1 394,295 614 46 576/30/8/0/0 library cache 2 2,075,911 5,333 540 4894/358/61/2 0/0 library cache 1 1,763,241 5,673 976 4927/551/160/ 35/0 library cache 3 1,295,489 1,766 228 1595/126/33/1 2/0 library cache 5 1,164,954 2,363 354 2091/204/54/1 4/0 library cache 4 1,052,138 1,594 166 1460/107/22/5 /0 ------------------------------------------------------------- �Dictionary Cache Stats for DB: PROD Instance: prod Snaps: 320 -321 ->"Pct Misses" should be very low (< 2% in most cases) ->"Cache Usage" is the number of cache entries being used ->"Pct SGA" is the ratio of usage to allocated size for that cache Get Pct Scan Pct Mod Final Pct Cache Requests Miss Requests Miss Req Usage SGA ---------------------- ------------ ------ -------- ----- -------- ------ ---- dc_constraints 24 50.0 0 24 13 57 dc_database_links 0 0 0 0 0 dc_files 8 0.0 0 0 419 99 dc_free_extents 13,705 0.0 0 0 2,741 100 dc_global_oids 219 0.0 0 0 22 71 dc_histogram_data 33 0.0 0 0 71 93 dc_histogram_data_valu 24 0.0 0 0 20 91 dc_histogram_defs 17,156 3.4 0 27 ###### 100 dc_object_ids 82,270 0.0 0 4 4,268 100 dc_objects 7,256 1.5 0 7 5,945 100 dc_outlines 0 0 0 0 0 dc_profiles 510 0.0 0 0 1 11 dc_rollback_segments 180 0.0 0 0 19 76 dc_segments 31,799 41.5 0 22 ###### 100 dc_sequence_grants 145 25.5 0 0 2,249 97 dc_sequences 496 0.6 0 481 147 99 dc_synonyms 2,419 0.9 0 1 1,130 100 dc_tablespace_quotas 82 0.0 0 19 24 83 dc_tablespaces 17,167 0.6 0 0 232 95 dc_used_extents 0 0 0 0 0 dc_user_grants 17,753 0.0 0 0 33 70 dc_usernames 3,608 0.0 0 0 62 97 dc_users 29,287 0.0 0 0 84 92 ifs_acl_cache_entries 0 0 0 0 0 ------------------------------------------------------------- Library Cache Activity for DB: PROD Instance: prod Snaps: 320 -321 ->"Pct Misses" should be very low Get Pct Pin Pct Invali- Namespace Requests Miss Requests Miss Reloads dations --------------- ------------ ------ -------------- ------ ---------- -------- SQL AREA 25,171 1.3 834,470 0.1 95 5 TABLE/PROCEDURE 165,162 0.1 1,361,690 0.0 2 0 BODY 27,541 0.1 27,515 0.1 0 0 TRIGGER 1,829 0.0 1,829 0.0 0 0 INDEX 1,104 0.2 1,104 0.4 0 0 CLUSTER 3 0.0 4 0.0 0 0 OBJECT 0 0 0 0 PIPE 3,379 0.8 3,859 0.7 0 0 ------------------------------------------------------------- �SGA Memory Summary for DB: PROD Instance: prod Snaps: 320 -321 SGA regions Size in Bytes ------------------------------ ---------------- Database Buffers 1,073,741,824 Fixed Size 75,804 Redo Buffers 2,105,344 Variable Size 800,579,584 ---------------- sum 1,876,502,556 ------------------------------------------------------------- SGA breakdown difference for DB: PROD Instance: prod Snaps: 320 -321 Pool Name Begin value End value Difference ----------- ------------------------ -------------- -------------- ----------- java pool free memory 11,423,744 11,423,744 0 java pool memory in use 9,547,776 9,547,776 0 large pool free memory 10,000,000 10,000,000 0 shared pool DML locks 1,200,000 1,200,000 0 shared pool KGFF heap 281,696 281,696 0 shared pool KGK heap 18,300 18,300 0 shared pool KQLS heap 27,848,184 28,021,872 173,688 shared pool PL/SQL DIANA 14,565,072 14,827,248 262,176 shared pool PL/SQL MPCODE 37,831,572 38,481,644 650,072 shared pool PLS non-lib hp 2,096 2,096 0 shared pool PX msg pool 71,144 71,144 0 shared pool PX subheap 2,928 2,928 0 shared pool State objects 1,186,608 1,186,608 0 shared pool db_block_buffers 17,825,792 17,825,792 0 shared pool db_block_hash_buckets 2,228,248 2,228,248 0 shared pool dictionary cache 16,594,788 20,120,840 3,526,052 shared pool enqueue_resources 2,304,000 2,304,000 0 shared pool event statistics per ses 3,801,200 3,801,200 0 shared pool fixed allocation callbac 960 960 0 shared pool free memory 268,987,368 243,303,508 -25,683,860 shared pool joxlod: in ehe 126,452 126,452 0 shared pool joxlod: in phe 187,836 187,836 0 shared pool joxs heap init 4,248 4,248 0 shared pool library cache 59,942,764 61,914,216 1,971,452 shared pool miscellaneous 5,612,228 5,746,668 134,440 shared pool pl/sql source 4,660 4,660 0 shared pool ruleset defini 745,392 745,392 0 shared pool sessions 2,382,380 2,382,380 0 shared pool sql area 304,194,048 323,162,800 18,968,752 shared pool table columns 93,692 94,756 1,064 shared pool table definiti 75,352 76,872 1,520 shared pool temporary tabl 8,936 3,580 -5,356 shared pool transactions 1,083,780 1,083,780 0 shared pool trigger defini 265,716 265,716 0 shared pool trigger inform 668 668 0 shared pool trigger source 812 812 0 shared pool type object de 107,832 107,832 0 db_block_buffers 1,073,741,824 1,073,741,824 0 fixed_sga 75,804 75,804 0 log_buffer 2,097,152 2,097,152 0 ------------------------------------------------------------- �init.ora Parameters for DB: PROD Instance: prod Snaps: 320 -321 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- _complex_view_merging TRUE _fast_full_scan_enabled FALSE _like_with_bind_as_equality TRUE _new_initial_join_orders TRUE _optimizer_mode_force TRUE _optimizer_undo_changes FALSE _or_expand_nvl_predicate TRUE _ordered_nested_loop TRUE _push_join_predicate TRUE _push_join_union_view TRUE _shared_pool_reserved_min_all 4100 _sort_elimination_cost_ratio 5 _sqlexec_progression_cost 2147483647 _system_trig_enabled TRUE _table_scan_cost_plus_one TRUE _trace_files_public TRUE _use_column_stats_for_functio TRUE aq_tm_processes 1 background_dump_dest d:oracleproddb8.1.7adminbdum compatible 8.1.7.2.1 control_files e:oracleproddatacntrl04.dbf, e db_block_buffers 131072 db_block_checksum TRUE db_block_lru_latches 4 db_block_size 8192 db_file_multiblock_read_count 8 db_files 512 db_name PROD dml_locks 10000 enqueue_resources 32000 hash_area_size 2097152 ifile d:oracleproddb8.1.7dbsifilec java_pool_size 20971520 job_queue_interval 90 large_pool_size 10000000 log_archive_dest_1 LOCATION=G:prodarchives log_archive_format PROD_%s.arc log_archive_start TRUE log_buffer 2097152 log_checkpoint_interval 100000 log_checkpoint_timeout 1200 log_checkpoints_to_alert TRUE max_dump_file_size 20480 max_enabled_roles 100 nls_comp BINARY nls_date_format DD-MON-RR nls_language american nls_numeric_characters ., nls_sort binary nls_territory america open_cursors 700 optimizer_features_enable 8.1.7 optimizer_max_permutations 2000 parallel_max_servers 2 parallel_min_servers 0 �init.ora Parameters for DB: PROD Instance: prod Snaps: 320 -321 End value Parameter Name Begin value (if different) ----------------------------- --------------------------------- -------------- processes 1000 query_rewrite_enabled TRUE remote_login_passwordfile EXCLUSIVE rollback_segments rbs01, rbs02, rbs03, rbs04, rbs05 row_locking always session_cached_cursors 200 shared_pool_reserved_size 73400320 shared_pool_size 734003200 sort_area_retained_size 65536 sort_area_size 2157152 timed_statistics TRUE user_dump_dest d:oracleproddb8.1.7adminudum utl_file_dir d:oracleproddb8.1.7plsqltemp ------------------------------------------------------------- End of Report regrads, ANJANI +91-9313692124

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following