Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: statpack feedback
Hello Azar,
Most of the waits on you system is caused by full table scans:
Top 5 Wait Events
~~~~~~~~~~~~~~~~ Wait % Total Event Waits Time (cs) WtTime
db file scattered read 32,338 14,715 84.98 db file sequential read 6,554 1,1116.42
It would make sense to concentrate and optimize top four " Physical Reads" SQL (unless this amount of heavy reads is expected and acceptable).
Physical Reads Executions Reads per Exec % Total Hash Value
--------------- ------------ -------------- ------- ------------
156,646 46 3,405.3 68.8 3933377930 SELECT DISTINCT UP.PARTY_NUMBER, CUST.CUST_ACCOUNT_ID CUSTOMER_ID , CUST.ACCOUNT_NUMBER TAXPAYER# , P.PARTY_NAME TAXPAYER_NAME, CU ST.ACCOUNT_NAME ACCOUNT_DBA, CUST.ACCOUNT_NUMBER||' - '|| DECODE (CUST.ACCOUNT_NAME,NULL,substr(P.PARTY_NAME,1,40), P.PARTY_NAME| |' / '||substr(CUST.ACCOUNT_NAME,1,40)) TAXPAYER, CUST.CUSTOMER_
55,059 16 3,441.2 24.2 3491314623 SELECT DISTINCT CUSTOMER_ID FROM CTOX_TP_ADJUSTED_REPORT_LINES ARL,CTOX_TP_REPORT_LINES RL,CTOX_SA_SUBACCOUNTS SA,CTOX_TP_PERI OD_REPORTS PR WHERE ((PR.ORIGINAL_DLN = :b1 AND PR.ORIG_DLN_FI SCAL_YEAR = :b2 ) OR (ARL.RL_RL_ID IS NOT NULL AND ARL.ADJ_BY_ DLN = :b1 AND ARL.FISCAL_YEAR = :b2 )) AND SA.SA_ID = PR.SA_SA_
45,633 16 2,852.1 20.0 2190151225 SELECT DISTINCT CUSTOMER_ID FROM CTOX_TP_INPROCESS_ADJ_RPT_LIN E ARL,CTOX_TP_INPROCESS_REPORT_LINES RL,CTOX_SA_SUBACCOUNTS SA,X OTC_TP_INPROCESS_HOG_REPORTS PR WHERE ((PR.DLN = :b1 AND PR.DL N_FISCAL_YEAR = :b2 ) OR (ARL.IRL_IRL_ID IS NOT NULL AND ARL.A DJ_BY_DLN = :b1 AND ARL.FISCAL_YEAR = :b2 )) AND SA.SA_ID = PR.
31,812 3 10,604.0 14.0 3312537587 SELECT T.PERM_PRINT_ID PRINT_ID, T.BATCH_ID , T.S AAX_REFERENCE_NUMBER AB_CNTY, T.ABLE_REQ, --T.SAAX_ID SA AX_ID, --T.SA_ID SA_ID, DISP_AREA, CUST_ID, EFF_DATE, --EXP_DATE, --NVL(CALC_EXP_ DATE, 'NON-EXPIRING') CALC_EXP, calc_exp_date CALC_EXP,
Please, let me know if any additional information would be helpful.
Regards,
Ron
Support
DBA Infopower LLC
http://www.dbainfopower.com
"Azar" <consult_me_1st_at_yahoo.com> wrote in message news:5fec53f1.0407161005.2351a0e3_at_posting.google.com...
> Hi guys, > I am pasting a copy of a statspack report. Just need some feedback on > what you all see in it. I am running on solaris 2..8, APPS 11.5.8 with > 8.1.7.4. My box has has 3Gig of ram and 6x400 CPU';s. thamks. snap is > for for 30 min interval. > STATSPACK report for > > DB Name DB Id Instance Inst Num Release OPS Host > ------------ ----------- ------------ -------- ----------- --- > ------------ > HOGWILD 1991282407 HOGWILD 1 8.1.7.4.0 NO > trough > > Snap Id Snap Time Sessions > ------- ------------------ -------- > Begin Snap: 753 16-Jul-04 11:00:00 112 > End Snap: 754 16-Jul-04 11:30:00 112 > Elapsed: 30.00 (mins) > > Cache Sizes > ~~~~~~~~~~ > db_block_buffers: 50000 log_buffer: > 10485760 > db_block_size: 8192 shared_pool_size: > 681574400 > > Load Profile > ~~~~~~~~~~~ Per Second Per > Transaction > --------------- > --------------- > Redo size: 3,552.23 > 7,120.29 > Logical reads: 4,719.26 > 9,459.53 > Block changes: 24.89 > 49.90 > Physical reads: 126.57 > 253.71 > Physical writes: 46.10 > 92.40 > User calls: 55.70 > 111.65 > Parses: 9.17 > 18.37 > Hard parses: 0.08 > 0.15 > Sorts: 23.03 > 46.16 > Logons: 0.18 > 0.37 > Executes: 46.72 > 93.64 > Transactions: 0.50 > > % Blocks changed per Read: 0.53 Recursive Call %: 64.42 > Rollback per transaction %: 7.46 Rows per Sort: 48.95 > > Instance Efficiency Percentages (Target 100%) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Buffer Nowait %: 100.00 Redo NoWait %: 100.00 > Buffer Hit %: 97.32 In-memory Sort %: 99.98 > Library Hit %: 99.89 Soft Parse %: 99.18 > Execute to Parse %: 80.38 Latch Hit %: 99.87 > Parse CPU to Parse Elapsd %: 94.85 % Non-Parse CPU: 98.88 > > Shared Pool Statistics Begin End > ------ ------ > Memory Usage %: 91.87 91.94 > % SQL with executions>1: 17.45 18.13 > % Memory for SQL w/exec>1: 27.52 28.84 > > Top 5 Wait Events > ~~~~~~~~~~~~~~~~ Wait > % Total > Event Waits Time (cs) > Wt Time > -------------------------------------------- ------------ ------------ > ------- > db file scattered read 32,338 14,715 > 84.98 > db file sequential read 6,554 1,111 > 6.42 > control file sequential read 3,552 442 > 2.55 > enqueue 2 372 > 2.15 > log file sync 783 208 > 1.20 > ------------------------------------------------------------- > Wait Events for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > -> 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 scattered read 32,338 0 14,715 > 5 36.0 > db file sequential read 6,554 0 1,111 > 2 7.3 > control file sequential read 3,552 0 442 > 1 4.0 > enqueue 2 1 372 > 1860 0.0 > log file sync 783 0 208 > 3 0.9 > control file parallel write 640 0 174 > 3 0.7 > latch free 150 121 69 > 5 0.2 > log file parallel write 4,718 1 56 > 0 5.3 > file open 3,214 0 47 > 0 3.6 > single-task message 11 0 41 > 37 0.0 > SQL*Net more data to client 2,278 0 29 > 0 2.5 > direct path read 8,283 0 17 > 0 9.2 > SQL*Net break/reset to clien 230 0 10 > 0 0.3 > LGWR wait for redo copy 857 0 9 > 0 1.0 > direct path write 5,365 0 8 > 0 6.0 > db file parallel write 490 0 4 > 0 0.5 > refresh controlfile command 10 0 4 > 4 0.0 > db file single write 2 0 0 > 0 0.0 > SQL*Net message from client 102,478 0 8,834,956 > 862 114.1 > wakeup time manager 56 56 171,448 > 30616 0.1 > SQL*Net more data from clien 279 0 2,144 > 77 0.3 > SQL*Net message to client 102,474 0 28 > 0 114.1 > ------------------------------------------------------------- > Background Wait Events for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > -> ordered by wait time desc, waits desc (idle events last) > > > Avg > Total Wait > wait Waits > Event Waits Timeouts Time (cs) > (ms) /txn > ---------------------------- ------------ ---------- ----------- > ------ ------ > control file parallel write 640 0 174 > 3 0.7 > log file parallel write 4,718 1 56 > 0 5.3 > file open 3,103 0 42 > 0 3.5 > control file sequential read 117 0 31 > 3 0.1 > LGWR wait for redo copy 857 0 9 > 0 1.0 > db file parallel write 490 0 4 > 0 0.5 > db file sequential read 3 0 1 > 3 0.0 > latch free 1 1 1 > 10 0.0 > direct path read 1,971 0 0 > 0 2.2 > direct path write 377 0 0 > 0 0.4 > db file single write 2 0 0 > 0 0.0 > rdbms ipc message 8,548 4,680 1,807,602 > 2115 9.5 > smon timer 6 6 184,327 > ###### 0.0 > pmon timer 584 584 179,836 > 3079 0.7 > ------------------------------------------------------------- > SQL ordered by Gets for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > -> 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 > --------------- ------------ -------------- ------- ------------ > 5,209,149 46 113,242.4 61.3 3933377930 > SELECT DISTINCT P.PARTY_NUMBER, CUST.CUST_ACCOUNT_ID CUSTOMER_ID > , CUST.ACCOUNT_NUMBER TAXPAYER# , P.PARTY_NAME TAXPAYER_NAME, CU > ST.ACCOUNT_NAME ACCOUNT_DBA, CUST.ACCOUNT_NUMBER||' - '|| DECODE > (CUST.ACCOUNT_NAME,NULL,substr(P.PARTY_NAME,1,40), P.PARTY_NAME| > |' / '||substr(CUST.ACCOUNT_NAME,1,40)) TAXPAYER, CUST.CUSTOMER_ > > 2,282,174 2,250 1,014.3 26.9 1305020311 > SELECT DISTINCT FEB.EVENT,DC.BLOCK_NAME,DECODE(BUILT_IN,'SET_BLO > CK_PROPERTY',0,10) + DECODE(PROPERTY_CODE,79,1,1401,2,1402,3,150 > 8,4,80,5,183,6,28,7,0) SORT_CODE,DC.ITEM_NAME ITEM_NAME,DC.PROP > ERTY_CODE,DECODE(FC.CCFC_ID, NULL ,DC.VALUE_CODE,FC.VALUE_CODE) > PROPERTY_VALUE_CODE,FEB.BUILT_IN,CTOX_CC_PKG.GET_VALUE_TYPE(DC.P > > 203,840 15,680 13.0 2.4 885722162 > (SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE UPPE > R(OPTION_NAME) = UPPER(:b1) ) UNION (SELECT STATUS_FLAG FROM I > GI_GCC_GL_FA_INST_OPS WHERE UPPER(OPTION_NAME) = UPPER(:b1) ) > > 164,502 57 2,886.0 1.9 238087931 > select t.schema, t.name, t.flags, q.name from system.aq$_queue_t > ables t, sys.aq$_queue_table_affinities aft, system.aq$_que > ues q where aft.table_objno = t.objno and aft.owner_instance = : > 1 and q.table_objno = t.objno and q.usage = 0 and b > itand(t.flags, 4+16+32+64+128+256) = 0 for update of t.name, aft > > 91,140 1 91,140.0 1.1 3376831664 > BEGIN statspack.snap; END; > > 86,629 1 86,629.0 1.0 872649315 > SELECT CTOX.CTOX_TP_EDIT_RPTS_PKG.CHECK_REPORT_CREDIT(0.00,9678, > 'INPROCESS') FROM DUAL > > 86,607 1 86,607.0 1.0 3144460300 > SELECT PAYDIS.PD_ID FROM CTOX_RP_PAYMENT_DESIGNATIONS PAYDES,X > OTC_RP_PAYMENT_DISTRIBUTIONS PAYDIS,CTOX_RP_PAYMENTS PAYM WHERE > PAYDIS.P_P_ID = PAYM.P_ID AND PAYDES.PD_PD_ID = PAYDIS.PD_ID > AND PAYMENT_TYPE_CODE = 'RECEIPT' AND EXISTS (SELECT 'X' FRO > M CTOX_TP_INPROCESS_HOG_REPORTS INP WHERE INP.IPR_ID = :b1 AND > > 82,478 1 82,478.0 1.0 625421128 > INSERT INTO STATS$SQLTEXT ( HASH_VALUE,TEXT_SUBSET,PIECE,SQL_TEX > T,ADDRESS,COMMAND_TYPE,LAST_SNAP_ID ) SELECT ST1.HASH_VALUE,SS. > TEXT_SUBSET,ST1.PIECE,ST1.SQL_TEXT,ST1.ADDRESS,ST1.COMMAND_TYPE, > SS.SNAP_ID FROM V$SQLTEXT ST1,STATS$SQL_SUMMARY SS WHERE SS.S > NAP_ID = :b1 AND SS.DBID = :b2 AND SS.INSTANCE_NUMBER = :b3 A > > 60,000 16 3,750.0 0.7 3491314623 > SELECT DISTINCT CUSTOMER_ID FROM CTOX_TP_ADJUSTED_REPORT_LINES > ARL,CTOX_TP_REPORT_LINES RL,CTOX_SA_SUBACCOUNTS SA,CTOX_TP_PERI > OD_REPORTS PR WHERE ((PR.ORIGINAL_DLN = :b1 AND PR.ORIG_DLN_FI > SQL ordered by Gets for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > -> 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 > --------------- ------------ -------------- ------- ------------ > SCAL_YEAR = :b2 ) OR (ARL.RL_RL_ID IS NOT NULL AND ARL.ADJ_BY_ > DLN = :b1 AND ARL.FISCAL_YEAR = :b2 )) AND SA.SA_ID = PR.SA_SA_ > > 43,360 16 2,710.0 0.5 2190151225 > SELECT DISTINCT CUSTOMER_ID FROM CTOX_TP_INPROCESS_ADJ_RPT_LIN > E ARL,CTOX_TP_INPROCESS_REPORT_LINES RL,CTOX_SA_SUBACCOUNTS SA,X > OTC_TP_INPROCESS_HOG_REPORTS PR WHERE ((PR.DLN = :b1 AND PR.DL > N_FISCAL_YEAR = :b2 ) OR (ARL.IRL_IRL_ID IS NOT NULL AND ARL.A > DJ_BY_DLN = :b1 AND ARL.FISCAL_YEAR = :b2 )) AND SA.SA_ID = PR. > > 40,010 1 40,010.0 0.5 2160325339 > select count(customer_id) from CTOX.CTOX_addresses_v > > 32,288 11,057 2.9 0.4 2924380235 > SELECT PROFILE_OPTION_ID,APPLICATION_ID FROM FND_PROFILE_OPTIO > NS WHERE PROFILE_OPTION_NAME = UPPER(:b1) AND START_DATE_ACTIV > E <= SYSDATE AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE > > 30,032 133 225.8 0.4 1632606114 > SELECT FUNCTION_NAME,TL.USER_FUNCTION_NAME FROM FND_FORM F,FND > _FORM_FUNCTIONS_TL TL,FND_FORM_FUNCTIONS FF WHERE F.FORM_NAME = > :b1 AND FF.TYPE = 'FORM' AND F.FORM_ID = FF.FORM_ID AND TL.F > UNCTION_ID = FF.FUNCTION_ID AND ROWNUM < 10 ORDER BY LENGTH(FUN > CTION_NAME) > > 27,360 2,736 10.0 0.3 3460529092 > select t.name, (select owner_instance from sys.aq$_queue_table_ > affinities where table_objno = t.objno) from system.aq$_queue > _tables t where t.name = :1 and t.schema = :2 for update skip lo > cked > > 23,281 10 2,328.1 0.3 2103844211 > SELECT LOOKUP_CODE,ATTRIBUTE1 VALUE, DESCRIPTION DESCRIPTION, NV > L('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 AR_LOOKUPS AR_LOOKUPS WHERE (LOOKUP_TYPE = 'OTC_2002_N > AICS_CROSS_REFERENCE' AND ENABLED_FLAG = 'Y' AND ATTRIBUTE1 <> ' > > 21,123 11 1,920.3 0.2 2838017588 > select parent_owner,parent_name,parent_link_name,parent_type,par > ent_timestamp,property from ora_kglr7_dependencies where owner=: > 1 and name=:2 and type=:3 and obj#=:4 order by order_number > > 20,976 598 35.1 0.2 3207237114 > SELECT COUNT(*) FROM FND_DESCR_FLEX_COLUMN_USAGES U,FND_DESCR_ > FLEX_CONTEXTS C WHERE U.APPLICATION_ID = :b1 AND U.DESCRIPTIVE > > ------------------------------------------------------------- > SQL ordered by Reads for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > -> End Disk Reads Threshold: 1000 > > Physical Reads Executions Reads per Exec % Total Hash Value > --------------- ------------ -------------- ------- ------------ > 156,646 46 3,405.3 68.8 3933377930 > SELECT DISTINCT P.PARTY_NUMBER, CUST.CUST_ACCOUNT_ID CUSTOMER_ID > , CUST.ACCOUNT_NUMBER TAXPAYER# , P.PARTY_NAME TAXPAYER_NAME, CU > ST.ACCOUNT_NAME ACCOUNT_DBA, CUST.ACCOUNT_NUMBER||' - '|| DECODE > (CUST.ACCOUNT_NAME,NULL,substr(P.PARTY_NAME,1,40), P.PARTY_NAME| > |' / '||substr(CUST.ACCOUNT_NAME,1,40)) TAXPAYER, CUST.CUSTOMER_ > > 55,059 16 3,441.2 24.2 3491314623 > SELECT DISTINCT CUSTOMER_ID FROM CTOX_TP_ADJUSTED_REPORT_LINES > ARL,CTOX_TP_REPORT_LINES RL,CTOX_SA_SUBACCOUNTS SA,CTOX_TP_PERI > OD_REPORTS PR WHERE ((PR.ORIGINAL_DLN = :b1 AND PR.ORIG_DLN_FI > SCAL_YEAR = :b2 ) OR (ARL.RL_RL_ID IS NOT NULL AND ARL.ADJ_BY_ > DLN = :b1 AND ARL.FISCAL_YEAR = :b2 )) AND SA.SA_ID = PR.SA_SA_ > > 45,633 16 2,852.1 20.0 2190151225 > SELECT DISTINCT CUSTOMER_ID FROM CTOX_TP_INPROCESS_ADJ_RPT_LIN > E ARL,CTOX_TP_INPROCESS_REPORT_LINES RL,CTOX_SA_SUBACCOUNTS SA,X > OTC_TP_INPROCESS_HOG_REPORTS PR WHERE ((PR.DLN = :b1 AND PR.DL > N_FISCAL_YEAR = :b2 ) OR (ARL.IRL_IRL_ID IS NOT NULL AND ARL.A > DJ_BY_DLN = :b1 AND ARL.FISCAL_YEAR = :b2 )) AND SA.SA_ID = PR. > > 31,812 3 10,604.0 14.0 3312537587 > SELECT T.PERM_PRINT_ID PRINT_ID, T.BATCH_ID , T.S > AAX_REFERENCE_NUMBER AB_CNTY, T.ABLE_REQ, --T.SAAX_ID SA > AX_ID, --T.SA_ID SA_ID, DISP_AREA, > CUST_ID, EFF_DATE, --EXP_DATE, --NVL(CALC_EXP_ > DATE, 'NON-EXPIRING') CALC_EXP, calc_exp_date CALC_EXP, > > 9,116 4 2,279.0 4.0 1231343536 > SELECT C.CUSTOMER_NAME,C.LAST_NAME,C.FIRST_NAME,C.ADDRESS1,C.CIT > Y,C.STATE,C.POSTAL_CODE,C.COUNTRY,C.CUSTOMER_NUMBER,C.ORG_PER_NU > MBER,C.STATUS,C.IDENTIFYING_FLAG,C.TAX_REG_NUMBER,C.TAXPAYER_ID, > C.REFERENCE,C.TYPE,C.CATEGORY,C.CLASS,C.SIC_CODE,C.ADDRESS2,C.AD > DRESS3,C.ADDRESS4,C.COUNTY,C.PROVINCE,C.PARTY_SITE_NUMBER,C.CUST > > 5,744 5 1,148.8 2.5 3346258844 > SELECT DISTINCT 'X' FROM RA_CUSTOMERS C WHERE C.TAX_REFERENCE > = :b1 AND C.CUSTOMER_ID != NVL(:b2,0) > > 5,469 1 5,469.0 2.4 872649315 > SELECT CTOX.CTOX_TP_EDIT_RPTS_PKG.CHECK_REPORT_CREDIT(0.00,9678, > 'INPROCESS') FROM DUAL > > 5,469 1 5,469.0 2.4 3144460300 > SELECT PAYDIS.PD_ID FROM CTOX_RP_PAYMENT_DESIGNATIONS PAYDES,X > OTC_RP_PAYMENT_DISTRIBUTIONS PAYDIS,CTOX_RP_PAYMENTS PAYM WHERE > PAYDIS.P_P_ID = PAYM.P_ID AND PAYDES.PD_PD_ID = PAYDIS.PD_ID > AND PAYMENT_TYPE_CODE = 'RECEIPT' AND EXISTS (SELECT 'X' FRO > M CTOX_TP_INPROCESS_HOG_REPORTS INP WHERE INP.IPR_ID = :b1 AND > > 4,587 2 2,293.5 2.0 3205630571 > UPDATE CTOX_tr_applications SET A_ID=:1,CUSTOMER_ID=:2,ATTRIBUTE > _CATEGORY=:3,ATTRIBUTE1=:4,ATTRIBUTE2=:5,ATTRIBUTE3=:6,ATTRIBUTE > 4=:7,ATTRIBUTE5=:8,ATTRIBUTE6=:9,ATTRIBUTE7=:10,ATTRIBUTE8=:11,A > TTRIBUTE9=:12,ATTRIBUTE10=:13,CREATED_BY=:14,CREATION_DATE=:15,L > SQL ordered by Reads for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > -> End Disk Reads Threshold: 1000 > > Physical Reads Executions Reads per Exec % Total Hash Value > --------------- ------------ -------------- ------- ------------ > AST_UPDATED_BY=:16,LAST_UPDATE_DATE=:17,LAST_UPDATE_LOGIN=:18,DL > > 4,586 2 2,293.0 2.0 1497973868 > UPDATE CTOX_TP_REPORT_LINES SET ADJ_REASON_CODE='1',ADJ_BY_DLN=: > b1,FISCAL_YEAR=:b2,LAST_UPDATED_BY=:b3,LAST_UPDATE_DATE=:b4,LAST > _UPDATE_LOGIN=:b5 WHERE NVL(ADJ_BY_DLN,-1) = :b6 AND NVL(FISCAL > _YEAR,-1) = :b7 AND PR_PR_ID IN (SELECT PR_ID FROM CTOX.CTOX_ > TP_PERIOD_REPORTS PR,CTOX.CTOX_TP_FORMS F WHERE PR.F_F_ID = F.F > > 3,765 3 1,255.0 1.7 3468291295 > SELECT C.CUSTOMER_ID, C.TAXPAYER_ID, C.TAX_REFERENCE, C.CUSTOMER > _NAME, C.ATTRIBUTE_CATEGORY, C.CUSTOMER_NUMBER FROM AR_CUSTOMERS > _ALL_V C WHERE c.taxpayer_id is not null and C.CUSTOMER_ID != :1 > ORDER BY C.CUSTOMER_NAME > > 3,084 1 3,084.0 1.4 3376831664 > BEGIN statspack.snap; END; > > 2,279 2 1,139.5 1.0 3511068989 > SELECT PARTY_NUMBER, CUSTOMER_ID, ACCOUNT_NUMBER TAXPAYER# , TAX > PAYER_NAME, ACCOUNT_NAME ACCOUNT_DBA, ACCOUNT_NUMBER||' - '|| ta > xpayer_NAME TAXPAYER, CATEGORY, TAXPAYER_ID , NULL LOC_DBA_NAME, > CONCATENATED_ADDRESS, BUSINESS_END_DATE FROM CTOX_tr_taxpayer_v > WHERE PARTY_NAME LIKE NVL('%'||:1||'%',PARTY_NAME) AND account_ > > 1,536 1 1,536.0 0.7 2064955574 > INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID,DBID,INSTANCE_NUMBER,TEX > T_SUBSET,SHARABLE_MEM,SORTS,MODULE,LOADED_VERSIONS,EXECUTIONS,LO > ADS,INVALIDATIONS,PARSE_CALLS,DISK_READS,BUFFER_GETS,ROWS_PROCES > SED,ADDRESS,HASH_VALUE,VERSION_COUNT ) SELECT :b1,:b2,:b3,SUBST > RB(SQL_TEXT,1,31),SHARABLE_MEM,SORTS,MODULE,LOADED_VERSIONS,EXEC > > 1,536 1 1,536.0 0.7 3337740287 > INSERT INTO STATS$SQL_STATISTICS ( SNAP_ID,DBID,INSTANCE_NUMBER, > TOTAL_SQL,TOTAL_SQL_MEM,SINGLE_USE_SQL,SINGLE_USE_SQL_MEM ) SEL > ECT :b1,:b2,:b3,COUNT(1),SUM(SHARABLE_MEM),SUM(DECODE(EXECUTIONS > ,1,1,0)),SUM(DECODE(EXECUTIONS,1,SHARABLE_MEM,0)) FROM V$SQLXS > > > ------------------------------------------------------------- > SQL ordered by Executions for DB: HOGWILD Instance: HOGWILD Snaps: > 753 -754 > -> End Executions Threshold: 100 > > Executions Rows Processed Rows per Exec Hash Value > ------------ ---------------- ---------------- ------------ > 15,680 15,680 1.0 885722162 > (SELECT STATUS_FLAG FROM IGI_GCC_INSTALLED_OPTIONS WHERE UPPE > R(OPTION_NAME) = UPPER(:b1) ) UNION (SELECT STATUS_FLAG FROM I > GI_GCC_GL_FA_INST_OPS WHERE UPPER(OPTION_NAME) = UPPER(:b1) ) > > 11,057 10,028 0.9 2924380235 > SELECT PROFILE_OPTION_ID,APPLICATION_ID FROM FND_PROFILE_OPTIO > NS WHERE PROFILE_OPTION_NAME = UPPER(:b1) AND START_DATE_ACTIV > E <= SYSDATE AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE > > 7,385 1,491 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 > > 6,701 6,701 1.0 945682231 > SELECT VALUE_TYPE FROM CTOX_CC_PROPERTY_VALUES WHERE PROPERTY > _CODE = :b1 > > 3,315 3,315 1.0 162763920 > SELECT '/shared/' || NAME || '/' || :b1 FROM V$DATABASE > > 2,736 2,736 1.0 3460529092 > select t.name, (select owner_instance from sys.aq$_queue_table_ > affinities where table_objno = t.objno) from system.aq$_queue > _tables t where t.name = :1 and t.schema = :2 for update skip lo > cked > > 2,607 97 0.0 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 > > 2,488 2,488 1.0 1872558334 > SELECT COUNT(*) FROM FND_FORM_FUNCTIONS WHERE FUNCTION_NAME = > :b1 AND PARAMETERS LIKE '%CC_PARAMETER%' > > 2,294 2,294 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 > > 2,250 6,536 2.9 1305020311 > SELECT DISTINCT FEB.EVENT,DC.BLOCK_NAME,DECODE(BUILT_IN,'SET_BLO > CK_PROPERTY',0,10) + DECODE(PROPERTY_CODE,79,1,1401,2,1402,3,150 > 8,4,80,5,183,6,28,7,0) SORT_CODE,DC.ITEM_NAME ITEM_NAME,DC.PROP > ERTY_CODE,DECODE(FC.CCFC_ID, NULL ,DC.VALUE_CODE,FC.VALUE_CODE) > PROPERTY_VALUE_CODE,FEB.BUILT_IN,CTOX_CC_PKG.GET_VALUE_TYPE(DC.P > > 2,240 2,240 1.0 1456599813 > SELECT COUNT(*) FROM igc_cc_routing_ctrls WHERE org_id = 0 > > SQL ordered by Executions for DB: HOGWILD Instance: HOGWILD Snaps: > 753 -754 > -> End Executions Threshold: 100 > > Executions Rows Processed Rows per Exec Hash Value > ------------ ---------------- ---------------- ------------ > 2,237 2,237 1.0 3594210869 > SELECT DISTINCT EVENT FROM CTOX.CTOX_CC_FORM_EVENT_BUILTINS W > HERE ENABLED_FLAG = 'Y' AND (EVENT = :b1 OR EVENT LIKE 'SPECI > AL%' ) > > 2,233 0 0.0 988596303 > SELECT STATUS FROM PSA_IMPLEMENTATION_ALL WHERE ORG_ID = :b1 > AND PSA_FEATURE = :b2 > > 641 641 1.0 2108922784 > declare dummy boolean;begin fnd_profile.get_specific(:name, :use > rid, :respid, :applid, :val, dummy);end; > > 604 604 1.0 2727637107 > BEGIN FND_FLEX_VAL_UTIL.GET_SERVER_GLOBAL( :p_char_in, > :x_char_out, :x_error, :x_message); END; > > 598 598 1.0 3207237114 > SELECT COUNT(*) FROM FND_DESCR_FLEX_COLUMN_USAGES U,FND_DESCR_ > FLEX_CONTEXTS C WHERE U.APPLICATION_ID = :b1 AND U.DESCRIPTIVE > _FLEXFIELD_NAME = :b2 AND C.APPLICATION_ID = U.APPLICATION_ID > AND C.DESCRIPTIVE_FLEXFIELD_NAME = U.DESCRIPTIVE_FLEXFIELD_NAME > AND C.DESCRIPTIVE_FLEX_CONTEXT_CODE = U.DESCRIPTIVE_FLEX_CONTEX > > 585 435 0.7 3151396991 > update FND_CONCURRENT_QUEUES Q set SLEEP_SECONDS=:b0,Target_Nod > e=NVL(Target_Node,:b1),MAX_PROCESSES=DECODE(CONTROL_CODE,'D',0,' > E',0,'T',0,'X',0,'R',Decode(Running_processes,0,:b2,0),Decode(En > abled_Flag,'N',0,Decode(Manager_Type,2,Decode(:b2,0,0,1),4,1,5,1 > ,6,1,:b2))),Control_Code=Decode(Control_Code,'R',Decode(Running_ > > 570 570 1.0 1187539904 > Select S.SERVICE_HANDLE, S.CARTRIDGE_HANDLE, Q.CONTEXT_BUFFER, > Q.SERVICE_PARAMETERS, S.DEVELOPER_PARAMETERS, '', '', S.ENV_F > ILE_NAME, SMQ.DIAGNOSTIC_LEVEL, Q.DIAGNOSTIC_LEVEL, DECODE(S > .ALLOW_RCG, 'Y', Q.RESOURCE_CONSUMER_GROUP, ''), ALLOW_MULTIPL > E_PROC_INSTANCE, ALLOW_MULTIPLE_PROC_NODE, MIGRATE_ON_FAILURE, > > 422 422 1.0 3733404988 > BEGIN FND_FLEX_VAL_UTIL.FLEX_DATE_CONVERTER( :p_vs_format > _type, :p_tz_direction, :p_input_mask, :p_i > nput, :p_output_mask, :x_output, :x_error, > :x_message); END; > > 416 2,525 6.1 912060593 > SELECT ' ' || OPERATOR || ' ' OPERATOR,OPERATOR_TYPE FROM XO > TC_CC_OPERATORS ORDER BY SEQUENCE > > 362 6 0.0 1623015130 > Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag > > ------------------------------------------------------------- > Instance Activity Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > > Statistic Total per Second per > Trans > --------------------------------- ---------------- ------------ > ------------ > CPU used by this session 72,465 40.3 > 80.7 > CPU used when call started 72,463 40.3 > 80.7 > CR blocks created 1,048 0.6 > 1.2 > DBWR buffers scanned 0 0.0 > 0.0 > DBWR checkpoint buffers written 1,141 0.6 > 1.3 > DBWR checkpoints 0 0.0 > 0.0 > DBWR free buffers found 0 0.0 > 0.0 > DBWR lru scans 0 0.0 > 0.0 > DBWR make free requests 0 0.0 > 0.0 > DBWR summed scan depth 0 0.0 > 0.0 > DBWR transaction table writes 12 0.0 > 0.0 > DBWR undo block writes 306 0.2 > 0.3 > Parallel operations downgraded to 0 0.0 > 0.0 > SQL*Net roundtrips to/from client 102,328 56.9 > 114.0 > background checkpoints completed 1 0.0 > 0.0 > background checkpoints started 0 0.0 > 0.0 > background timeouts 4,800 2.7 > 5.4 > branch node splits 0 0.0 > 0.0 > buffer is not pinned count 9,206,994 5,115.0 > 10,252.8 > buffer is pinned count 5,650,266 3,139.0 > 6,292.1 > bytes received via SQL*Net from c 20,835,137 11,575.1 > 23,201.7 > bytes sent via SQL*Net to client 23,960,030 13,311.1 > 26,681.6 > calls to get snapshot scn: kcmgss 98,420 54.7 > 109.6 > calls to kcmgas 6,487 3.6 > 7.2 > calls to kcmgcs 164 0.1 > 0.2 > change write time 199 0.1 > 0.2 > cleanouts and rollbacks - consist 363 0.2 > 0.4 > cleanouts only - consistent read 101 0.1 > 0.1 > cluster key scan block gets 4,498 2.5 > 5.0 > cluster key scans 291 0.2 > 0.3 > commit cleanout failures: block l 130 0.1 > 0.1 > commit cleanout failures: callbac 0 0.0 > 0.0 > commit cleanout failures: cannot 0 0.0 > 0.0 > commit cleanouts 10,973 6.1 > 12.2 > commit cleanouts successfully com 10,843 6.0 > 12.1 > consistent changes 1,441 0.8 > 1.6 > consistent gets 8,222,624 4,568.1 > 9,156.6 > current blocks converted for CR > cursor authentications 83 0.1 > 0.1 > data blocks consistent reads - un 1,441 0.8 > 1.6 > db block changes 44,806 24.9 > 49.9 > db block gets 272,038 151.1 > 302.9 > deferred (CURRENT) block cleanout 4,568 2.5 > 5.1 > dirty buffers inspected 0 0.0 > 0.0 > enqueue conversions 75 0.0 > 0.1 > enqueue releases 19,534 10.9 > 21.8 > enqueue requests 19,652 10.9 > 21.9 > enqueue timeouts 135 0.1 > 0.2 > enqueue waits 1 0.0 > 0.0 > exchange deadlocks 0 0.0 > 0.0 > execute count 84,088 46.7 > 93.6 > free buffer inspected 3 0.0 > 0.0 > free buffer requested 148,594 82.6 > 165.5 > hot buffers moved to head of LRU 2,567 1.4 > 2.9 > immediate (CR) block cleanout app 464 0.3 > 0.5 > immediate (CURRENT) block cleanou 253 0.1 > 0.3 > Instance Activity Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > > Statistic Total per Second per > Trans > --------------------------------- ---------------- ------------ > ------------ > index fast full scans (full) 0 0.0 > 0.0 > leaf node splits 28 0.0 > 0.0 > logons cumulative 332 0.2 > 0.4 > logons current > messages received 5,132 2.9 > 5.7 > messages sent 5,132 2.9 > 5.7 > no buffer to keep pinned count 0 0.0 > 0.0 > no work - consistent read gets 2,993,270 1,662.9 > 3,333.3 > opened cursors cumulative 13,024 7.2 > 14.5 > opened cursors current > parse count (hard) 136 0.1 > 0.2 > parse count (total) 16,497 9.2 > 18.4 > parse time cpu 810 0.5 > 0.9 > parse time elapsed 854 0.5 > 1.0 > physical reads 227,831 126.6 > 253.7 > physical reads direct 83,576 46.4 > 93.1 > physical reads direct (lob) 0 0.0 > 0.0 > physical writes 82,971 46.1 > 92.4 > physical writes direct 81,847 45.5 > 91.1 > physical writes non checkpoint 82,459 45.8 > 91.8 > pinned buffers inspected 0 0.0 > 0.0 > prefetched blocks 105,315 58.5 > 117.3 > prefetched blocks aged out before 0 0.0 > 0.0 > process last non-idle time 108,999,436,713 ############ > ############ > recursive calls 181,543 100.9 > 202.2 > recursive cpu usage 19,806 11.0 > 22.1 > redo blocks written 15,800 8.8 > 17.6 > redo buffer allocation retries 0 0.0 > 0.0 > redo entries 22,766 12.7 > 25.4 > redo log space requests 0 0.0 > 0.0 > redo log space wait time 0 0.0 > 0.0 > redo ordering marks 0 0.0 > 0.0 > redo size 6,394,020 3,552.2 > 7,120.3 > redo synch time 211 0.1 > 0.2 > redo synch writes 816 0.5 > 0.9 > redo wastage 1,255,192 697.3 > 1,397.8 > redo write time 1,190 0.7 > 1.3 > redo writer latching time 9 0.0 > 0.0 > redo writes 4,718 2.6 > 5.3 > rollback changes - undo records a 35 0.0 > 0.0 > rollbacks only - consistent read 831 0.5 > 0.9 > rows fetched via callback 2,108,427 1,171.4 > 2,347.9 > session connect time 108,999,436,713 ############ > ############ > session cursor cache count 106 0.1 > 0.1 > session cursor cache hits 7,090 3.9 > 7.9 > session logical reads 8,494,662 4,719.3 > 9,459.5 > session pga memory 1,129,090,092 627,272.3 > 1,257,338.6 > session pga memory max 1,167,813,700 648,785.4 > 1,300,460.7 > session uga memory 18,621,968 10,345.5 > 20,737.2 > session uga memory max 206,614,200 114,785.7 > 230,082.6 > sorts (disk) 8 0.0 > 0.0 > sorts (memory) 41,445 23.0 > 46.2 > sorts (rows) 2,028,933 1,127.2 > 2,259.4 > switch current to new buffer > table fetch by rowid 4,663,759 2,591.0 > 5,193.5 > table fetch continued row 2,529 1.4 > 2.8 > Instance Activity Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > > Statistic Total per Second per > Trans > --------------------------------- ---------------- ------------ > ------------ > table scan blocks gotten 536,236 297.9 > 597.1 > table scan rows gotten 22,503,687 12,502.1 > 25,059.8 > table scans (long tables) 109 0.1 > 0.1 > table scans (short tables) 53,180 29.5 > 59.2 > total file opens 3,214 1.8 > 3.6 > 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 100,260 55.7 > 111.7 > user commits 831 0.5 > 0.9 > user rollbacks 67 0.0 > 0.1 > write clones created in foregroun 0 0.0 > 0.0 > ------------------------------------------------------------- > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > ARD > 20,878 12 3.3 2.8 68 0 0 > 0.0 > CTOXD > 17,512 10 5.0 4.8 66 0 0 > 0.0 > TEMP > 7,647 4 37.4 10.7 7,142 4 0 > 0.0 > TOOLS > 213 0 12.5 5.0 164 0 0 > 0.0 > RBS > 11 0 163.6 1.0 319 0 0 > 0.0 > ARX > 97 0 20.9 1.0 160 0 0 > 0.0 > CTOXX > 62 0 30.6 1.0 146 0 0 > 0.0 > APPLSYSD > 35 0 81.1 1.0 97 0 0 > 0.0 > APPLSYSX > 30 0 94.3 1.0 90 0 0 > 0.0 > SYSTEM > 87 0 96.1 1.0 27 0 0 > 0.0 > ICXX > 4 0 307.5 1.0 16 0 0 > 0.0 > ICXD > 4 0 315.0 1.8 8 0 0 > 0.0 > EGOX > 10 0 85.0 1.0 1 0 0 > 0.0 > AMFD > 9 0 100.0 1.0 1 0 0 > 0.0 > AMFX > 9 0 100.0 1.0 1 0 0 > 0.0 > BILD > 9 0 56.7 1.0 1 0 0 > 0.0 > BILX > 9 0 53.3 1.0 1 0 0 > 0.0 > BNED > 9 0 100.0 1.0 1 0 0 > 0.0 > BNEX > 9 0 98.9 1.0 1 0 0 > 0.0 > CSMD > 9 0 95.6 1.0 1 0 0 > 0.0 > CSMX > 9 0 94.4 1.0 1 0 0 > 0.0 > DDDD > 9 0 92.2 1.0 1 0 0 > 0.0 > DDDX > 9 0 91.1 1.0 1 0 0 > 0.0 > DOMD > 9 0 88.9 1.0 1 0 0 > 0.0 > DOMX > 9 0 88.9 1.0 1 0 0 > 0.0 > EGOD > 9 0 86.7 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > IBAD > 9 0 70.0 1.0 1 0 0 > 0.0 > IBAX > 9 0 70.0 1.0 1 0 0 > 0.0 > IBCD > 9 0 88.9 1.0 1 0 0 > 0.0 > IBCX > 9 0 86.7 1.0 1 0 0 > 0.0 > IBED > 9 0 67.8 1.0 1 0 0 > 0.0 > IBEX > 9 0 66.7 1.0 1 0 0 > 0.0 > IBPD > 9 0 60.0 1.0 1 0 0 > 0.0 > IBPX > 9 0 57.8 1.0 1 0 0 > 0.0 > IBUD > 9 0 67.8 1.0 1 0 0 > 0.0 > IBUX > 9 0 65.6 1.0 1 0 0 > 0.0 > IBYD > 9 0 64.4 1.0 1 0 0 > 0.0 > IBYX > 9 0 58.9 1.0 1 0 0 > 0.0 > OKLD > 9 0 85.6 1.0 1 0 0 > 0.0 > OKLX > 9 0 84.4 1.0 1 0 0 > 0.0 > OKOD > 9 0 113.3 1.0 1 0 0 > 0.0 > OKOX > 9 0 111.1 1.0 1 0 0 > 0.0 > OKRD > 9 0 111.1 1.0 1 0 0 > 0.0 > OKRX > 9 0 108.9 1.0 1 0 0 > 0.0 > ONTD > 9 0 81.1 1.0 1 0 0 > 0.0 > PJID > 9 0 82.2 1.0 1 0 0 > 0.0 > PJIX > 9 0 80.0 1.0 1 0 0 > 0.0 > POND > 9 0 76.7 1.0 1 0 0 > 0.0 > PONX > 9 0 76.7 1.0 1 0 0 > 0.0 > POSD > 9 0 110.0 1.0 1 0 0 > 0.0 > POSX > 9 0 107.8 1.0 1 0 0 > 0.0 > QOTD > 9 0 73.3 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > QOTX > 9 0 71.1 1.0 1 0 0 > 0.0 > QPD > 9 0 82.2 1.0 1 0 0 > 0.0 > QPX > 9 0 81.1 1.0 1 0 0 > 0.0 > QRMD > 9 0 71.1 1.0 1 0 0 > 0.0 > QRMX > 9 0 68.9 1.0 1 0 0 > 0.0 > RLMD > 9 0 77.8 1.0 1 0 0 > 0.0 > RLMX > 9 0 77.8 1.0 1 0 0 > 0.0 > VEAD > 9 0 75.6 1.0 1 0 0 > 0.0 > VEAX > 9 0 75.6 1.0 1 0 0 > 0.0 > WSHD > 9 0 73.3 1.0 1 0 0 > 0.0 > WSHX > 9 0 71.1 1.0 1 0 0 > 0.0 > XNID > 9 0 104.4 1.0 1 0 0 > 0.0 > XNIX > 9 0 104.4 1.0 1 0 0 > 0.0 > AKD > 8 0 97.5 1.0 1 0 0 > 0.0 > AKX > 8 0 97.5 1.0 1 0 0 > 0.0 > AXD > 8 0 100.0 1.0 1 0 0 > 0.0 > AXX > 8 0 98.8 1.0 1 0 0 > 0.0 > BIXD > 9 0 51.1 1.0 0 0 0 > 0.0 > GMED > 8 0 121.3 1.0 1 0 0 > 0.0 > GMEX > 8 0 118.8 1.0 1 0 0 > 0.0 > GMFD > 8 0 115.0 1.0 1 0 0 > 0.0 > GMFX > 8 0 113.8 1.0 1 0 0 > 0.0 > GMLD > 8 0 112.5 1.0 1 0 0 > 0.0 > GMLX > 8 0 110.0 1.0 1 0 0 > 0.0 > GMPD > 8 0 116.3 1.0 1 0 0 > 0.0 > GMPX > 8 0 115.0 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > GRD > 8 0 108.8 1.0 1 0 0 > 0.0 > GRX > 8 0 105.0 1.0 1 0 0 > 0.0 > IGID > 8 0 152.5 1.0 1 0 0 > 0.0 > IGIX > 8 0 151.3 1.0 1 0 0 > 0.0 > IMCD > 8 0 151.3 1.0 1 0 0 > 0.0 > IMCX > 8 0 150.0 1.0 1 0 0 > 0.0 > IMTD > 8 0 146.3 1.0 1 0 0 > 0.0 > IMTX > 8 0 143.8 1.0 1 0 0 > 0.0 > IPDD > 8 0 143.8 1.0 1 0 0 > 0.0 > IPDX > 8 0 143.8 1.0 1 0 0 > 0.0 > ITGD > 8 0 138.8 1.0 1 0 0 > 0.0 > ITGX > 8 0 136.3 1.0 1 0 0 > 0.0 > JTMD > 8 0 133.8 1.0 1 0 0 > 0.0 > JTMX > 8 0 133.8 1.0 1 0 0 > 0.0 > JTSD > 8 0 131.3 1.0 1 0 0 > 0.0 > JTSX > 8 0 131.3 1.0 1 0 0 > 0.0 > MSRD > 8 0 131.3 1.0 1 0 0 > 0.0 > MSRX > 8 0 127.5 1.0 1 0 0 > 0.0 > OKBD > 8 0 126.3 1.0 1 0 0 > 0.0 > OKBX > 8 0 125.0 1.0 1 0 0 > 0.0 > OKID > 8 0 123.8 1.0 1 0 0 > 0.0 > OKIX > 8 0 122.5 1.0 1 0 0 > 0.0 > ONTX > 8 0 88.8 1.0 1 0 0 > 0.0 > PMID > 8 0 102.5 1.0 1 0 0 > 0.0 > PMIX > 8 0 101.3 1.0 1 0 0 > 0.0 > XLAD > 8 0 97.5 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > XLAX > 8 0 93.8 1.0 1 0 0 > 0.0 > BIVD > 7 0 197.1 1.0 1 0 0 > 0.0 > BIVX > 7 0 197.1 1.0 1 0 0 > 0.0 > BIXX > 8 0 52.5 1.0 0 0 0 > 0.0 > CSED > 7 0 194.3 1.0 1 0 0 > 0.0 > CSEX > 7 0 194.3 1.0 1 0 0 > 0.0 > CSID > 7 0 192.9 1.0 1 0 0 > 0.0 > CSIX > 7 0 191.4 1.0 1 0 0 > 0.0 > CSLD > 7 0 190.0 1.0 1 0 0 > 0.0 > CSLX > 7 0 188.6 1.0 1 0 0 > 0.0 > CUED > 7 0 184.3 1.0 1 0 0 > 0.0 > CUEX > 7 0 182.9 1.0 1 0 0 > 0.0 > CUGD > 7 0 180.0 1.0 1 0 0 > 0.0 > CUGX > 7 0 178.6 1.0 1 0 0 > 0.0 > EAMD > 7 0 177.1 1.0 1 0 0 > 0.0 > EAMX > 7 0 175.7 1.0 1 0 0 > 0.0 > ENID > 7 0 172.9 1.0 1 0 0 > 0.0 > ENIX > 7 0 174.3 1.0 1 0 0 > 0.0 > FPTD > 7 0 135.7 1.0 1 0 0 > 0.0 > FPTX > 7 0 134.3 1.0 1 0 0 > 0.0 > FTED > 7 0 172.9 1.0 1 0 0 > 0.0 > FTEX > 7 0 171.4 1.0 1 0 0 > 0.0 > GMAD > 7 0 131.4 1.0 1 0 0 > 0.0 > GMAX > 7 0 130.0 1.0 1 0 0 > 0.0 > GMDD > 7 0 132.9 1.0 1 0 0 > 0.0 > GMDX > 7 0 132.9 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > GMID > 7 0 137.1 1.0 1 0 0 > 0.0 > GMIX > 7 0 137.1 1.0 1 0 0 > 0.0 > IECD > 7 0 170.0 1.0 1 0 0 > 0.0 > IECX > 7 0 165.7 1.0 1 0 0 > 0.0 > IEOD > 7 0 135.7 1.0 1 0 0 > 0.0 > IEOX > 7 0 132.9 1.0 1 0 0 > 0.0 > XDPD > 7 0 141.4 1.0 1 0 0 > 0.0 > XDPX > 7 0 138.6 1.0 1 0 0 > 0.0 > XNCD > 7 0 150.0 1.0 1 0 0 > 0.0 > XNCX > 7 0 148.6 1.0 1 0 0 > 0.0 > XNMD > 7 0 154.3 1.0 1 0 0 > 0.0 > XNMX > 7 0 151.4 1.0 1 0 0 > 0.0 > XNPD > 7 0 145.7 1.0 1 0 0 > 0.0 > XNPX > 7 0 142.9 1.0 1 0 0 > 0.0 > XNSD > 7 0 147.1 1.0 1 0 0 > 0.0 > XNSX > 7 0 145.7 1.0 1 0 0 > 0.0 > AHLD > 6 0 230.0 1.0 1 0 0 > 0.0 > AHLX > 6 0 230.0 1.0 1 0 0 > 0.0 > AHMD > 6 0 226.7 1.0 1 0 0 > 0.0 > AHMX > 6 0 223.3 1.0 1 0 0 > 0.0 > AMSD > 6 0 168.3 1.0 1 0 0 > 0.0 > AMSX > 6 0 168.3 1.0 1 0 0 > 0.0 > AMVD > 6 0 186.7 1.0 1 0 0 > 0.0 > AMVX > 6 0 186.7 1.0 1 0 0 > 0.0 > ASFD > 6 0 176.7 1.0 1 0 0 > 0.0 > ASFX > 6 0 176.7 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > ASLD > 6 0 248.3 1.0 1 0 0 > 0.0 > ASLX > 6 0 245.0 1.0 1 0 0 > 0.0 > ASPD > 6 0 221.7 1.0 1 0 0 > 0.0 > ASPX > 6 0 216.7 1.0 1 0 0 > 0.0 > ASTD > 6 0 185.0 1.0 1 0 0 > 0.0 > ASTX > 6 0 181.7 1.0 1 0 0 > 0.0 > BICD > 6 0 190.0 1.0 1 0 0 > 0.0 > BICX > 6 0 188.3 1.0 1 0 0 > 0.0 > BIMD > 6 0 190.0 1.0 1 0 0 > 0.0 > BIMX > 6 0 190.0 1.0 1 0 0 > 0.0 > CSPD > 6 0 175.0 1.0 1 0 0 > 0.0 > CSPX > 6 0 175.0 1.0 1 0 0 > 0.0 > CUAD > 6 0 256.7 1.0 1 0 0 > 0.0 > CUAX > 6 0 253.3 1.0 1 0 0 > 0.0 > CUND > 6 0 261.7 1.0 1 0 0 > 0.0 > CUNX > 6 0 260.0 1.0 1 0 0 > 0.0 > FVD > 6 0 253.3 1.0 1 0 0 > 0.0 > FVX > 6 0 251.7 1.0 1 0 0 > 0.0 > IESD > 6 0 186.7 1.0 1 0 0 > 0.0 > IESX > 6 0 186.7 1.0 1 0 0 > 0.0 > MED > 6 0 196.7 1.0 1 0 0 > 0.0 > MEX > 6 0 195.0 1.0 1 0 0 > 0.0 > OKXD > 6 0 173.3 1.0 1 0 0 > 0.0 > OKXX > 6 0 171.7 1.0 1 0 0 > 0.0 > PVD > 6 0 236.7 1.0 1 0 0 > 0.0 > PVX > 6 0 233.3 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > CSCD > 5 0 242.0 1.0 1 0 0 > 0.0 > CSCX > 5 0 242.0 1.0 1 0 0 > 0.0 > CSDD > 5 0 242.0 1.0 1 0 0 > 0.0 > CSDX > 5 0 238.0 1.0 1 0 0 > 0.0 > CSFD > 5 0 236.0 1.0 1 0 0 > 0.0 > CSFX > 5 0 224.0 1.0 1 0 0 > 0.0 > CSSD > 5 0 222.0 1.0 1 0 0 > 0.0 > CSSX > 5 0 220.0 1.0 1 0 0 > 0.0 > CUFD > 5 0 294.0 1.0 1 0 0 > 0.0 > CUFX > 5 0 292.0 1.0 1 0 0 > 0.0 > CUID > 5 0 300.0 1.0 1 0 0 > 0.0 > CUIX > 5 0 296.0 1.0 1 0 0 > 0.0 > CUPD > 5 0 294.0 1.0 1 0 0 > 0.0 > CUPX > 5 0 294.0 1.0 1 0 0 > 0.0 > CUSD > 5 0 290.0 1.0 1 0 0 > 0.0 > CUSX > 5 0 290.0 1.0 1 0 0 > 0.0 > HRID > 5 0 258.0 1.0 1 0 0 > 0.0 > HRIX > 5 0 252.0 1.0 1 0 0 > 0.0 > IGCD > 5 0 310.0 1.0 1 0 0 > 0.0 > IGCX > 5 0 308.0 1.0 1 0 0 > 0.0 > IGFD > 5 0 314.0 1.0 1 0 0 > 0.0 > IGFX > 5 0 312.0 1.0 1 0 0 > 0.0 > IGSD > 5 0 316.0 1.0 1 0 0 > 0.0 > IGSX > 5 0 316.0 1.0 1 0 0 > 0.0 > IGWD > 5 0 326.0 1.0 1 0 0 > 0.0 > IGWX > 5 0 320.0 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > IPAD > 5 0 306.0 1.0 1 0 0 > 0.0 > IPAX > 5 0 304.0 1.0 1 0 0 > 0.0 > ISCD > 5 0 248.0 1.0 1 0 0 > 0.0 > ISCX > 5 0 244.0 1.0 1 0 0 > 0.0 > OKCD > 5 0 242.0 1.0 1 0 0 > 0.0 > OKCX > 5 0 242.0 1.0 1 0 0 > 0.0 > OKSD > 5 0 218.0 1.0 1 0 0 > 0.0 > OKSX > 5 0 216.0 1.0 1 0 0 > 0.0 > OPID > 5 0 260.0 1.0 1 0 0 > 0.0 > OPIX > 5 0 258.0 1.0 1 0 0 > 0.0 > POAD > 5 0 258.0 1.0 1 0 0 > 0.0 > POAX > 5 0 258.0 1.0 1 0 0 > 0.0 > PSAD > 5 0 308.0 1.0 1 0 0 > 0.0 > PSAX > 5 0 304.0 1.0 1 0 0 > 0.0 > CND > 4 0 330.0 1.0 1 0 0 > 0.0 > CNX > 4 0 327.5 1.0 1 0 0 > 0.0 > FIID > 4 0 300.0 1.0 1 0 0 > 0.0 > FIIX > 4 0 297.5 1.0 1 0 0 > 0.0 > GMSD > 4 0 377.5 1.0 1 0 0 > 0.0 > GMSX > 4 0 372.5 1.0 1 0 0 > 0.0 > HXCD > 4 0 405.0 1.0 1 0 0 > 0.0 > HXCX > 4 0 400.0 1.0 1 0 0 > 0.0 > HXTD > 4 0 415.0 1.0 1 0 0 > 0.0 > HXTX > 4 0 410.0 1.0 1 0 0 > 0.0 > INVD > 4 0 310.0 1.0 1 0 0 > 0.0 > INVX > 4 0 307.5 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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 > 4 0 397.5 1.0 1 0 0 > 0.0 > JAX > 4 0 392.5 1.0 1 0 0 > 0.0 > JED > 4 0 387.5 1.0 1 0 0 > 0.0 > JEX > 4 0 387.5 1.0 1 0 0 > 0.0 > JGD > 4 0 387.5 1.0 1 0 0 > 0.0 > JGX > 4 0 387.5 1.0 1 0 0 > 0.0 > JLD > 4 0 385.0 1.0 1 0 0 > 0.0 > JLX > 4 0 382.5 1.0 1 0 0 > 0.0 > MWAD > 4 0 307.5 1.0 1 0 0 > 0.0 > MWAX > 4 0 305.0 1.0 1 0 0 > 0.0 > OED > 4 0 325.0 1.0 1 0 0 > 0.0 > OEX > 4 0 320.0 1.0 1 0 0 > 0.0 > OSMD > 4 0 335.0 1.0 1 0 0 > 0.0 > OSMX > 4 0 330.0 1.0 1 0 0 > 0.0 > OTAD > 4 0 402.5 1.0 1 0 0 > 0.0 > OTAX > 4 0 397.5 1.0 1 0 0 > 0.0 > POMD > 4 0 327.5 1.0 1 0 0 > 0.0 > POMX > 4 0 325.0 1.0 1 0 0 > 0.0 > PSBD > 4 0 382.5 1.0 1 0 0 > 0.0 > PSBX > 4 0 382.5 1.0 1 0 0 > 0.0 > PSPD > 4 0 370.0 1.0 1 0 0 > 0.0 > PSPX > 4 0 367.5 1.0 1 0 0 > 0.0 > WMSD > 4 0 315.0 1.0 1 0 0 > 0.0 > WMSX > 4 0 312.5 1.0 1 0 0 > 0.0 > WPSD > 4 0 312.5 1.0 1 0 0 > 0.0 > WPSX > 4 0 312.5 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > WSMD > 4 0 302.5 1.0 1 0 0 > 0.0 > WSMX > 4 0 300.0 1.0 1 0 0 > 0.0 > ABMD > 3 0 416.7 1.0 1 0 0 > 0.0 > ABMX > 3 0 416.7 1.0 1 0 0 > 0.0 > BEND > 3 0 480.0 1.0 1 0 0 > 0.0 > BENX > 3 0 476.7 1.0 1 0 0 > 0.0 > BSCD > 3 0 420.0 1.0 1 0 0 > 0.0 > BSCX > 3 0 413.3 1.0 1 0 0 > 0.0 > CED > 3 0 430.0 1.0 1 0 0 > 0.0 > CEX > 3 0 430.0 1.0 1 0 0 > 0.0 > EAAD > 3 0 426.7 1.0 1 0 0 > 0.0 > EAAX > 3 0 423.3 1.0 1 0 0 > 0.0 > EVMD > 3 0 413.3 1.0 1 0 0 > 0.0 > EVMX > 3 0 410.0 1.0 1 0 0 > 0.0 > FEMD > 3 0 406.7 1.0 1 0 0 > 0.0 > FEMX > 3 0 403.3 1.0 1 0 0 > 0.0 > FLMD > 3 0 496.7 1.0 1 0 0 > 0.0 > FLMX > 3 0 493.3 1.0 1 0 0 > 0.0 > FRMD > 3 0 426.7 1.0 1 0 0 > 0.0 > FRMX > 3 0 426.7 1.0 1 0 0 > 0.0 > HRD > 3 0 486.7 1.0 1 0 0 > 0.0 > HRX > 3 0 486.7 1.0 1 0 0 > 0.0 > MSCD > 3 0 496.7 1.0 1 0 0 > 0.0 > MSCX > 3 0 490.0 1.0 1 0 0 > 0.0 > MSDD > 3 0 503.3 1.0 1 0 0 > 0.0 > MSDX > 3 0 503.3 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > MSOD > 3 0 496.7 1.0 1 0 0 > 0.0 > MSOX > 3 0 496.7 1.0 1 0 0 > 0.0 > OKED > 3 0 490.0 1.0 1 0 0 > 0.0 > OKEX > 3 0 490.0 1.0 1 0 0 > 0.0 > PAD > 3 0 400.0 1.0 1 0 0 > 0.0 > PAX > 3 0 396.7 1.0 1 0 0 > 0.0 > PJMD > 3 0 513.3 1.0 1 0 0 > 0.0 > PJMX > 3 0 503.3 1.0 1 0 0 > 0.0 > PND > 3 0 436.7 1.0 1 0 0 > 0.0 > PNX > 3 0 433.3 1.0 1 0 0 > 0.0 > QAD > 3 0 426.7 1.0 1 0 0 > 0.0 > QAX > 3 0 426.7 1.0 1 0 0 > 0.0 > RHXD > 3 0 490.0 1.0 1 0 0 > 0.0 > RHXX > 3 0 490.0 1.0 1 0 0 > 0.0 > SSPD > 3 0 486.7 1.0 1 0 0 > 0.0 > SSPX > 3 0 483.3 1.0 1 0 0 > 0.0 > APD > 2 0 590.0 1.0 1 0 0 > 0.0 > APX > 2 0 585.0 1.0 1 0 0 > 0.0 > AZD > 2 0 600.0 1.0 1 0 0 > 0.0 > AZX > 2 0 595.0 1.0 1 0 0 > 0.0 > BISD > 2 0 590.0 1.0 1 0 0 > 0.0 > BISX > 2 0 590.0 1.0 1 0 0 > 0.0 > BOMD > 2 0 715.0 1.0 1 0 0 > 0.0 > BOMX > 2 0 720.0 1.0 1 0 0 > 0.0 > CCTX > 2 0 620.0 1.0 1 0 0 > 0.0 > CRPD > 2 0 695.0 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > CRPX > 2 0 700.0 1.0 1 0 0 > 0.0 > CZD > 2 0 690.0 1.0 1 0 0 > 0.0 > CZX > 2 0 685.0 1.0 1 0 0 > 0.0 > ECD > 2 0 615.0 1.0 1 0 0 > 0.0 > ECX > 2 0 615.0 1.0 1 0 0 > 0.0 > ECXD > 2 0 620.0 1.0 1 0 0 > 0.0 > ECXX > 2 0 610.0 1.0 1 0 0 > 0.0 > ENGD > 2 0 715.0 1.0 1 0 0 > 0.0 > ENGX > 2 0 715.0 1.0 1 0 0 > 0.0 > IEBD > 2 0 730.0 1.0 1 0 0 > 0.0 > IEBX > 2 0 730.0 1.0 1 0 0 > 0.0 > MFGD > 2 0 720.0 1.0 1 0 0 > 0.0 > MFGX > 2 0 715.0 1.0 1 0 0 > 0.0 > MRPD > 2 0 710.0 1.0 1 0 0 > 0.0 > MRPX > 2 0 710.0 1.0 1 0 0 > 0.0 > POD > 2 0 590.0 1.0 1 0 0 > 0.0 > POX > 2 0 580.0 1.0 1 0 0 > 0.0 > RLAD > 2 0 685.0 1.0 1 0 0 > 0.0 > RLAX > 2 0 680.0 1.0 1 0 0 > 0.0 > VEHD > 2 0 680.0 1.0 1 0 0 > 0.0 > VEHX > 2 0 680.0 1.0 1 0 0 > 0.0 > WIPD > 2 0 695.0 1.0 1 0 0 > 0.0 > WIPX > 2 0 695.0 1.0 1 0 0 > 0.0 > XTRD > 2 0 600.0 1.0 1 0 0 > 0.0 > XTRX > 2 0 595.0 1.0 1 0 0 > 0.0 > ALRD > 1 0 ###### 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > ALRX > 1 0 ###### 1.0 1 0 0 > 0.0 > ASGD > 1 0 ###### 1.0 1 0 0 > 0.0 > ASGX > 1 0 ###### 1.0 1 0 0 > 0.0 > ASOD > 1 0 ###### 1.0 1 0 0 > 0.0 > ASOX > 1 0 ###### 1.0 1 0 0 > 0.0 > CCTD > 1 0 ###### 1.0 1 0 0 > 0.0 > CSD > 1 0 ###### 1.0 1 0 0 > 0.0 > CSRD > 1 0 ###### 1.0 1 0 0 > 0.0 > CSRX > 1 0 ###### 1.0 1 0 0 > 0.0 > CSX > 1 0 ###### 1.0 1 0 0 > 0.0 > CTXD > 1 0 ###### 1.0 1 0 0 > 0.0 > FAD > 1 0 ###### 1.0 1 0 0 > 0.0 > FAX > 1 0 ###### 1.0 1 0 0 > 0.0 > GLD > 1 0 ###### 1.0 1 0 0 > 0.0 > GLX > 1 0 ###### 1.0 1 0 0 > 0.0 > IEMD > 1 0 ###### 1.0 1 0 0 > 0.0 > IEMX > 1 0 ###### 1.0 1 0 0 > 0.0 > IEUD > 1 0 ###### 1.0 1 0 0 > 0.0 > IEUX > 1 0 ###### 1.0 1 0 0 > 0.0 > IEXD > 1 0 ###### 1.0 1 0 0 > 0.0 > IEXX > 1 0 ###### 1.0 1 0 0 > 0.0 > JTFD > 1 0 ###### 1.0 1 0 0 > 0.0 > JTFX > 1 0 ###### 1.0 1 0 0 > 0.0 > OWAPUB > 1 0 ###### 1.0 1 0 0 > 0.0 > OZFD > 1 0 ###### 1.0 1 0 0 > 0.0 > OZFX > 1 0 ###### 1.0 1 0 0 > 0.0 > Tablespace IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > OZPD > 1 0 ###### 1.0 1 0 0 > 0.0 > OZPX > 1 0 ###### 1.0 1 0 0 > 0.0 > OZSD > 1 0 ###### 1.0 1 0 0 > 0.0 > OZSX > 1 0 ###### 1.0 1 0 0 > 0.0 > RGD > 1 0 ###### 1.0 1 0 0 > 0.0 > RGX > 1 0 ###### 1.0 1 0 0 > 0.0 > ------------------------------------------------------------- > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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 /u02/oradata/HOGWILD/abmd01.dbf > 3 0 416.7 1.0 1 0 0 > > ABMX /u02/oradata/HOGWILD/abmx01.dbf > 3 0 416.7 1.0 1 0 0 > > AHLD /u02/oradata/HOGWILD/ahld01.dbf > 6 0 230.0 1.0 1 0 0 > > AHLX /u02/oradata/HOGWILD/ahlx01.dbf > 6 0 230.0 1.0 1 0 0 > > AHMD /u02/oradata/HOGWILD/ahmd01.dbf > 6 0 226.7 1.0 1 0 0 > > AHMX /u02/oradata/HOGWILD/ahmx01.dbf > 6 0 223.3 1.0 1 0 0 > > AKD /u02/oradata/HOGWILD/akd01.dbf > 8 0 97.5 1.0 1 0 0 > > AKX /u02/oradata/HOGWILD/akx01.dbf > 8 0 97.5 1.0 1 0 0 > > ALRD /u02/oradata/HOGWILD/alrd01.dbf > 1 0 ###### 1.0 1 0 0 > > ALRX /u02/oradata/HOGWILD/alrx01.dbf > 1 0 ###### 1.0 1 0 0 > > AMFD /u02/oradata/HOGWILD/amfd01.dbf > 9 0 100.0 1.0 1 0 0 > > AMFX /u02/oradata/HOGWILD/amfx01.dbf > 9 0 100.0 1.0 1 0 0 > > AMSD /u02/oradata/HOGWILD/amsd01.dbf > 6 0 168.3 1.0 1 0 0 > > AMSX /u02/oradata/HOGWILD/amsx01.dbf > 6 0 168.3 1.0 1 0 0 > > AMVD /u02/oradata/HOGWILD/amvd01.dbf > 6 0 186.7 1.0 1 0 0 > > AMVX /u02/oradata/HOGWILD/amvx01.dbf > 6 0 186.7 1.0 1 0 0 > > APD /u02/oradata/HOGWILD/apd01.dbf > 2 0 590.0 1.0 1 0 0 > > APPLSYSD /u02/oradata/HOGWILD/applsysd01.dbf > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > 19 0 67.4 1.1 66 0 0 > APPLSYSD /u02/oradata/HOGWILD/applsysd02.dbf > 16 0 97.5 1.0 31 0 0 > > APPLSYSX /u02/oradata/HOGWILD/applsysx01.dbf > 16 0 78.1 1.0 50 0 0 > /u02/oradata/HOGWILD/applsysx02.dbf > 14 0 112.9 1.0 40 0 0 > > APX /u02/oradata/HOGWILD/apx01.dbf > 2 0 585.0 1.0 1 0 0 > > ARD /u02/oradata/HOGWILD/ard01.dbf > 20,878 12 3.3 2.8 68 0 0 > > ARX /u02/oradata/HOGWILD/arx01.dbf > 97 0 20.9 1.0 160 0 0 > > ASFD /u02/oradata/HOGWILD/asfd01.dbf > 6 0 176.7 1.0 1 0 0 > > ASFX /u02/oradata/HOGWILD/asfx01.dbf > 6 0 176.7 1.0 1 0 0 > > ASGD /u02/oradata/HOGWILD/asgd01.dbf > 1 0 ###### 1.0 1 0 0 > > ASGX /u02/oradata/HOGWILD/asgx01.dbf > 1 0 ###### 1.0 1 0 0 > > ASLD /u02/oradata/HOGWILD/asld01.dbf > 6 0 248.3 1.0 1 0 0 > > ASLX /u02/oradata/HOGWILD/aslx01.dbf > 6 0 245.0 1.0 1 0 0 > > ASOD /u02/oradata/HOGWILD/asod01.dbf > 1 0 ###### 1.0 1 0 0 > > ASOX /u02/oradata/HOGWILD/asox01.dbf > 1 0 ###### 1.0 1 0 0 > > ASPD /u02/oradata/HOGWILD/aspd01.dbf > 6 0 221.7 1.0 1 0 0 > > ASPX /u02/oradata/HOGWILD/aspx01.dbf > 6 0 216.7 1.0 1 0 0 > > ASTD /u02/oradata/HOGWILD/astd01.dbf > 6 0 185.0 1.0 1 0 0 > > ASTX /u02/oradata/HOGWILD/astx01.dbf > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > 6 0 181.7 1.0 1 0 0 > > AXD /u02/oradata/HOGWILD/axd01.dbf > 8 0 100.0 1.0 1 0 0 > > AXX /u02/oradata/HOGWILD/axx01.dbf > 8 0 98.8 1.0 1 0 0 > > AZD /u02/oradata/HOGWILD/azd01.dbf > 2 0 600.0 1.0 1 0 0 > > AZX /u02/oradata/HOGWILD/azx01.dbf > 2 0 595.0 1.0 1 0 0 > > BEND /u02/oradata/HOGWILD/bend01.dbf > 3 0 480.0 1.0 1 0 0 > > BENX /u02/oradata/HOGWILD/benx01.dbf > 3 0 476.7 1.0 1 0 0 > > BICD /u02/oradata/HOGWILD/bicd01.dbf > 6 0 190.0 1.0 1 0 0 > > BICX /u02/oradata/HOGWILD/bicx01.dbf > 6 0 188.3 1.0 1 0 0 > > BILD /u02/oradata/HOGWILD/bild01.dbf > 9 0 56.7 1.0 1 0 0 > > BILX /u02/oradata/HOGWILD/bilx01.dbf > 9 0 53.3 1.0 1 0 0 > > BIMD /u02/oradata/HOGWILD/bimd01.dbf > 6 0 190.0 1.0 1 0 0 > > BIMX /u02/oradata/HOGWILD/bimx01.dbf > 6 0 190.0 1.0 1 0 0 > > BISD /u02/oradata/HOGWILD/bisd01.dbf > 2 0 590.0 1.0 1 0 0 > > BISX /u02/oradata/HOGWILD/bisx01.dbf > 2 0 590.0 1.0 1 0 0 > > BIVD /u02/oradata/HOGWILD/bivd01.dbf > 7 0 197.1 1.0 1 0 0 > > BIVX /u02/oradata/HOGWILD/bivx01.dbf > 7 0 197.1 1.0 1 0 0 > > BIXD /u02/oradata/HOGWILD/bixd01.dbf > 9 0 51.1 1.0 0 0 0 > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > > BIXX /u02/oradata/HOGWILD/bixx01.dbf > 8 0 52.5 1.0 0 0 0 > > BNED /u02/oradata/HOGWILD/bned01.dbf > 9 0 100.0 1.0 1 0 0 > > BNEX /u02/oradata/HOGWILD/bnex01.dbf > 9 0 98.9 1.0 1 0 0 > > BOMD /u02/oradata/HOGWILD/bomd01.dbf > 2 0 715.0 1.0 1 0 0 > > BOMX /u02/oradata/HOGWILD/bomx01.dbf > 2 0 720.0 1.0 1 0 0 > > BSCD /u02/oradata/HOGWILD/bscd01.dbf > 3 0 420.0 1.0 1 0 0 > > BSCX /u02/oradata/HOGWILD/bscx01.dbf > 3 0 413.3 1.0 1 0 0 > > CCTD /u02/oradata/HOGWILD/cctd01.dbf > 1 0 ###### 1.0 1 0 0 > > CCTX /u02/oradata/HOGWILD/cctx01.dbf > 2 0 620.0 1.0 1 0 0 > > CED /u02/oradata/HOGWILD/ced01.dbf > 3 0 430.0 1.0 1 0 0 > > CEX /u02/oradata/HOGWILD/cex01.dbf > 3 0 430.0 1.0 1 0 0 > > CND /u02/oradata/HOGWILD/cnd01.dbf > 4 0 330.0 1.0 1 0 0 > > CNX /u02/oradata/HOGWILD/cnx01.dbf > 4 0 327.5 1.0 1 0 0 > > CRPD /u02/oradata/HOGWILD/crpd01.dbf > 2 0 695.0 1.0 1 0 0 > > CRPX /u02/oradata/HOGWILD/crpx01.dbf > 2 0 700.0 1.0 1 0 0 > > CSCD /u02/oradata/HOGWILD/cscd01.dbf > 5 0 242.0 1.0 1 0 0 > > CSCX /u02/oradata/HOGWILD/cscx01.dbf > 5 0 242.0 1.0 1 0 0 > > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > CSD /u02/oradata/HOGWILD/csd01.dbf > 1 0 ###### 1.0 1 0 0 > > CSDD /u02/oradata/HOGWILD/csdd01.dbf > 5 0 242.0 1.0 1 0 0 > > CSDX /u02/oradata/HOGWILD/csdx01.dbf > 5 0 238.0 1.0 1 0 0 > > CSED /u02/oradata/HOGWILD/csed01.dbf > 7 0 194.3 1.0 1 0 0 > > CSEX /u02/oradata/HOGWILD/csex01.dbf > 7 0 194.3 1.0 1 0 0 > > CSFD /u02/oradata/HOGWILD/csfd01.dbf > 5 0 236.0 1.0 1 0 0 > > CSFX /u02/oradata/HOGWILD/csfx01.dbf > 5 0 224.0 1.0 1 0 0 > > CSID /u02/oradata/HOGWILD/csid01.dbf > 7 0 192.9 1.0 1 0 0 > > CSIX /u02/oradata/HOGWILD/csix01.dbf > 7 0 191.4 1.0 1 0 0 > > CSLD /u02/oradata/HOGWILD/csld01.dbf > 7 0 190.0 1.0 1 0 0 > > CSLX /u02/oradata/HOGWILD/cslx01.dbf > 7 0 188.6 1.0 1 0 0 > > CSMD /u02/oradata/HOGWILD/csmd01.dbf > 9 0 95.6 1.0 1 0 0 > > CSMX /u02/oradata/HOGWILD/csmx01.dbf > 9 0 94.4 1.0 1 0 0 > > CSPD /u02/oradata/HOGWILD/cspd01.dbf > 6 0 175.0 1.0 1 0 0 > > CSPX /u02/oradata/HOGWILD/cspx01.dbf > 6 0 175.0 1.0 1 0 0 > > CSRD /u02/oradata/HOGWILD/csrd01.dbf > 1 0 ###### 1.0 1 0 0 > > CSRX /u02/oradata/HOGWILD/csrx01.dbf > 1 0 ###### 1.0 1 0 0 > > CSSD /u02/oradata/HOGWILD/cssd01.dbf > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > 5 0 222.0 1.0 1 0 0 > > CSSX /u02/oradata/HOGWILD/cssx01.dbf > 5 0 220.0 1.0 1 0 0 > > CSX /u02/oradata/HOGWILD/csx01.dbf > 1 0 ###### 1.0 1 0 0 > > CTXD /u02/oradata/HOGWILD/ctxd01.dbf > 1 0 ###### 1.0 1 0 0 > > CUAD /u02/oradata/HOGWILD/cuad01.dbf > 6 0 256.7 1.0 1 0 0 > > CUAX /u02/oradata/HOGWILD/cuax01.dbf > 6 0 253.3 1.0 1 0 0 > > CUED /u02/oradata/HOGWILD/cued01.dbf > 7 0 184.3 1.0 1 0 0 > > CUEX /u02/oradata/HOGWILD/cuex01.dbf > 7 0 182.9 1.0 1 0 0 > > CUFD /u02/oradata/HOGWILD/cufd01.dbf > 5 0 294.0 1.0 1 0 0 > > CUFX /u02/oradata/HOGWILD/cufx01.dbf > 5 0 292.0 1.0 1 0 0 > > CUGD /u02/oradata/HOGWILD/cugd01.dbf > 7 0 180.0 1.0 1 0 0 > > CUGX /u02/oradata/HOGWILD/cugx01.dbf > 7 0 178.6 1.0 1 0 0 > > CUID /u02/oradata/HOGWILD/cuid01.dbf > 5 0 300.0 1.0 1 0 0 > > CUIX /u02/oradata/HOGWILD/cuix01.dbf > 5 0 296.0 1.0 1 0 0 > > CUND /u02/oradata/HOGWILD/cund01.dbf > 6 0 261.7 1.0 1 0 0 > > CUNX /u02/oradata/HOGWILD/cunx01.dbf > 6 0 260.0 1.0 1 0 0 > > CUPD /u02/oradata/HOGWILD/cupd01.dbf > 5 0 294.0 1.0 1 0 0 > > CUPX /u02/oradata/HOGWILD/cupx01.dbf > 5 0 294.0 1.0 1 0 0 > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > > CUSD /u02/oradata/HOGWILD/cusd01.dbf > 5 0 290.0 1.0 1 0 0 > > CUSX /u02/oradata/HOGWILD/cusx01.dbf > 5 0 290.0 1.0 1 0 0 > > CZD /u02/oradata/HOGWILD/czd01.dbf > 2 0 690.0 1.0 1 0 0 > > CZX /u02/oradata/HOGWILD/czx01.dbf > 2 0 685.0 1.0 1 0 0 > > DDDD /u02/oradata/HOGWILD/dddd01.dbf > 9 0 92.2 1.0 1 0 0 > > DDDX /u02/oradata/HOGWILD/dddx01.dbf > 9 0 91.1 1.0 1 0 0 > > DOMD /u02/oradata/HOGWILD/domd01.dbf > 9 0 88.9 1.0 1 0 0 > > DOMX /u02/oradata/HOGWILD/domx01.dbf > 9 0 88.9 1.0 1 0 0 > > EAAD /u02/oradata/HOGWILD/eaad01.dbf > 3 0 426.7 1.0 1 0 0 > > EAAX /u02/oradata/HOGWILD/eaax01.dbf > 3 0 423.3 1.0 1 0 0 > > EAMD /u02/oradata/HOGWILD/eamd01.dbf > 7 0 177.1 1.0 1 0 0 > > EAMX /u02/oradata/HOGWILD/eamx01.dbf > 7 0 175.7 1.0 1 0 0 > > ECD /u02/oradata/HOGWILD/ecd01.dbf > 2 0 615.0 1.0 1 0 0 > > ECX /u02/oradata/HOGWILD/ecx01.dbf > 2 0 615.0 1.0 1 0 0 > > ECXD /u02/oradata/HOGWILD/ecxd01.dbf > 2 0 620.0 1.0 1 0 0 > > ECXX /u02/oradata/HOGWILD/ecxx01.dbf > 2 0 610.0 1.0 1 0 0 > > EGOD /u02/oradata/HOGWILD/egod01.dbf > 9 0 86.7 1.0 1 0 0 > > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > EGOX /u02/oradata/HOGWILD/egox01.dbf > 10 0 85.0 1.0 1 0 0 > > ENGD /u02/oradata/HOGWILD/engd01.dbf > 2 0 715.0 1.0 1 0 0 > > ENGX /u02/oradata/HOGWILD/engx01.dbf > 2 0 715.0 1.0 1 0 0 > > ENID /u02/oradata/HOGWILD/enid01.dbf > 7 0 172.9 1.0 1 0 0 > > ENIX /u02/oradata/HOGWILD/enix01.dbf > 7 0 174.3 1.0 1 0 0 > > EVMD /u02/oradata/HOGWILD/evmd01.dbf > 3 0 413.3 1.0 1 0 0 > > EVMX /u02/oradata/HOGWILD/evmx01.dbf > 3 0 410.0 1.0 1 0 0 > > FAD /u02/oradata/HOGWILD/fad01.dbf > 1 0 ###### 1.0 1 0 0 > > FAX /u02/oradata/HOGWILD/fax01.dbf > 1 0 ###### 1.0 1 0 0 > > FEMD /u02/oradata/HOGWILD/femd01.dbf > 3 0 406.7 1.0 1 0 0 > > FEMX /u02/oradata/HOGWILD/femx01.dbf > 3 0 403.3 1.0 1 0 0 > > FIID /u02/oradata/HOGWILD/fiid01.dbf > 4 0 300.0 1.0 1 0 0 > > FIIX /u02/oradata/HOGWILD/fiix01.dbf > 4 0 297.5 1.0 1 0 0 > > FLMD /u02/oradata/HOGWILD/flmd01.dbf > 3 0 496.7 1.0 1 0 0 > > FLMX /u02/oradata/HOGWILD/flmx01.dbf > 3 0 493.3 1.0 1 0 0 > > FPTD /u02/oradata/HOGWILD/fptd01.dbf > 7 0 135.7 1.0 1 0 0 > > FPTX /u02/oradata/HOGWILD/fptx01.dbf > 7 0 134.3 1.0 1 0 0 > > FRMD /u02/oradata/HOGWILD/frmd01.dbf > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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 426.7 1.0 1 0 0 > > FRMX /u02/oradata/HOGWILD/frmx01.dbf > 3 0 426.7 1.0 1 0 0 > > FTED /u02/oradata/HOGWILD/fted01.dbf > 7 0 172.9 1.0 1 0 0 > > FTEX /u02/oradata/HOGWILD/ftex01.dbf > 7 0 171.4 1.0 1 0 0 > > FVD /u02/oradata/HOGWILD/fvd01.dbf > 6 0 253.3 1.0 1 0 0 > > FVX /u02/oradata/HOGWILD/fvx01.dbf > 6 0 251.7 1.0 1 0 0 > > GLD /u02/oradata/HOGWILD/gld01.dbf > 1 0 ###### 1.0 1 0 0 > > GLX /u02/oradata/HOGWILD/glx01.dbf > 1 0 ###### 1.0 1 0 0 > > GMAD /u02/oradata/HOGWILD/gmad01.dbf > 7 0 131.4 1.0 1 0 0 > > GMAX /u02/oradata/HOGWILD/gmax01.dbf > 7 0 130.0 1.0 1 0 0 > > GMDD /u02/oradata/HOGWILD/gmdd01.dbf > 7 0 132.9 1.0 1 0 0 > > GMDX /u02/oradata/HOGWILD/gmdx01.dbf > 7 0 132.9 1.0 1 0 0 > > GMED /u02/oradata/HOGWILD/gmed01.dbf > 8 0 121.3 1.0 1 0 0 > > GMEX /u02/oradata/HOGWILD/gmex01.dbf > 8 0 118.8 1.0 1 0 0 > > GMFD /u02/oradata/HOGWILD/gmfd01.dbf > 8 0 115.0 1.0 1 0 0 > > GMFX /u02/oradata/HOGWILD/gmfx01.dbf > 8 0 113.8 1.0 1 0 0 > > GMID /u02/oradata/HOGWILD/gmid01.dbf > 7 0 137.1 1.0 1 0 0 > > GMIX /u02/oradata/HOGWILD/gmix01.dbf > 7 0 137.1 1.0 1 0 0 > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > > GMLD /u02/oradata/HOGWILD/gmld01.dbf > 8 0 112.5 1.0 1 0 0 > > GMLX /u02/oradata/HOGWILD/gmlx01.dbf > 8 0 110.0 1.0 1 0 0 > > GMPD /u02/oradata/HOGWILD/gmpd01.dbf > 8 0 116.3 1.0 1 0 0 > > GMPX /u02/oradata/HOGWILD/gmpx01.dbf > 8 0 115.0 1.0 1 0 0 > > GMSD /u02/oradata/HOGWILD/gmsd01.dbf > 4 0 377.5 1.0 1 0 0 > > GMSX /u02/oradata/HOGWILD/gmsx01.dbf > 4 0 372.5 1.0 1 0 0 > > GRD /u02/oradata/HOGWILD/grd01.dbf > 8 0 108.8 1.0 1 0 0 > > GRX /u02/oradata/HOGWILD/grx01.dbf > 8 0 105.0 1.0 1 0 0 > > HRD /u02/oradata/HOGWILD/hrd01.dbf > 3 0 486.7 1.0 1 0 0 > > HRID /u02/oradata/HOGWILD/hrid01.dbf > 5 0 258.0 1.0 1 0 0 > > HRIX /u02/oradata/HOGWILD/hrix01.dbf > 5 0 252.0 1.0 1 0 0 > > HRX /u02/oradata/HOGWILD/hrx01.dbf > 3 0 486.7 1.0 1 0 0 > > HXCD /u02/oradata/HOGWILD/hxcd01.dbf > 4 0 405.0 1.0 1 0 0 > > HXCX /u02/oradata/HOGWILD/hxcx01.dbf > 4 0 400.0 1.0 1 0 0 > > HXTD /u02/oradata/HOGWILD/hxtd01.dbf > 4 0 415.0 1.0 1 0 0 > > HXTX /u02/oradata/HOGWILD/hxtx01.dbf > 4 0 410.0 1.0 1 0 0 > > IBAD /u02/oradata/HOGWILD/ibad01.dbf > 9 0 70.0 1.0 1 0 0 > > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > IBAX /u02/oradata/HOGWILD/ibax01.dbf > 9 0 70.0 1.0 1 0 0 > > IBCD /u02/oradata/HOGWILD/ibcd01.dbf > 9 0 88.9 1.0 1 0 0 > > IBCX /u02/oradata/HOGWILD/ibcx01.dbf > 9 0 86.7 1.0 1 0 0 > > IBED /u02/oradata/HOGWILD/ibed01.dbf > 9 0 67.8 1.0 1 0 0 > > IBEX /u02/oradata/HOGWILD/ibex01.dbf > 9 0 66.7 1.0 1 0 0 > > IBPD /u02/oradata/HOGWILD/ibpd01.dbf > 9 0 60.0 1.0 1 0 0 > > IBPX /u02/oradata/HOGWILD/ibpx01.dbf > 9 0 57.8 1.0 1 0 0 > > IBUD /u02/oradata/HOGWILD/ibud01.dbf > 9 0 67.8 1.0 1 0 0 > > IBUX /u02/oradata/HOGWILD/ibux01.dbf > 9 0 65.6 1.0 1 0 0 > > IBYD /u02/oradata/HOGWILD/ibyd01.dbf > 9 0 64.4 1.0 1 0 0 > > IBYX /u02/oradata/HOGWILD/ibyx01.dbf > 9 0 58.9 1.0 1 0 0 > > ICXD /u02/oradata/HOGWILD/icxd01.dbf > 4 0 315.0 1.8 8 0 0 > > ICXX /u02/oradata/HOGWILD/icxx01.dbf > 4 0 307.5 1.0 16 0 0 > > IEBD /u02/oradata/HOGWILD/iebd01.dbf > 2 0 730.0 1.0 1 0 0 > > IEBX /u02/oradata/HOGWILD/iebx01.dbf > 2 0 730.0 1.0 1 0 0 > > IECD /u02/oradata/HOGWILD/iecd01.dbf > 7 0 170.0 1.0 1 0 0 > > IECX /u02/oradata/HOGWILD/iecx01.dbf > 7 0 165.7 1.0 1 0 0 > > IEMD /u02/oradata/HOGWILD/iemd01.dbf > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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 ###### 1.0 1 0 0 > > IEMX /u02/oradata/HOGWILD/iemx01.dbf > 1 0 ###### 1.0 1 0 0 > > IEOD /u02/oradata/HOGWILD/ieod01.dbf > 7 0 135.7 1.0 1 0 0 > > IEOX /u02/oradata/HOGWILD/ieox01.dbf > 7 0 132.9 1.0 1 0 0 > > IESD /u02/oradata/HOGWILD/iesd01.dbf > 6 0 186.7 1.0 1 0 0 > > IESX /u02/oradata/HOGWILD/iesx01.dbf > 6 0 186.7 1.0 1 0 0 > > IEUD /u02/oradata/HOGWILD/ieud01.dbf > 1 0 ###### 1.0 1 0 0 > > IEUX /u02/oradata/HOGWILD/ieux01.dbf > 1 0 ###### 1.0 1 0 0 > > IEXD /u02/oradata/HOGWILD/iexd01.dbf > 1 0 ###### 1.0 1 0 0 > > IEXX /u02/oradata/HOGWILD/iexx01.dbf > 1 0 ###### 1.0 1 0 0 > > IGCD /u02/oradata/HOGWILD/igcd01.dbf > 5 0 310.0 1.0 1 0 0 > > IGCX /u02/oradata/HOGWILD/igcx01.dbf > 5 0 308.0 1.0 1 0 0 > > IGFD /u02/oradata/HOGWILD/igfd01.dbf > 5 0 314.0 1.0 1 0 0 > > IGFX /u02/oradata/HOGWILD/igfx01.dbf > 5 0 312.0 1.0 1 0 0 > > IGID /u02/oradata/HOGWILD/igid01.dbf > 8 0 152.5 1.0 1 0 0 > > IGIX /u02/oradata/HOGWILD/igix01.dbf > 8 0 151.3 1.0 1 0 0 > > IGSD /u02/oradata/HOGWILD/igsd01.dbf > 5 0 316.0 1.0 1 0 0 > > IGSX /u02/oradata/HOGWILD/igsx01.dbf > 5 0 316.0 1.0 1 0 0 > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > > IGWD /u02/oradata/HOGWILD/igwd01.dbf > 5 0 326.0 1.0 1 0 0 > > IGWX /u02/oradata/HOGWILD/igwx01.dbf > 5 0 320.0 1.0 1 0 0 > > IMCD /u02/oradata/HOGWILD/imcd01.dbf > 8 0 151.3 1.0 1 0 0 > > IMCX /u02/oradata/HOGWILD/imcx01.dbf > 8 0 150.0 1.0 1 0 0 > > IMTD /u02/oradata/HOGWILD/imtd01.dbf > 8 0 146.3 1.0 1 0 0 > > IMTX /u02/oradata/HOGWILD/imtx01.dbf > 8 0 143.8 1.0 1 0 0 > > INVD /u02/oradata/HOGWILD/invd01.dbf > 4 0 310.0 1.0 1 0 0 > > INVX /u02/oradata/HOGWILD/invx01.dbf > 4 0 307.5 1.0 1 0 0 > > IPAD /u02/oradata/HOGWILD/ipad01.dbf > 5 0 306.0 1.0 1 0 0 > > IPAX /u02/oradata/HOGWILD/ipax01.dbf > 5 0 304.0 1.0 1 0 0 > > IPDD /u02/oradata/HOGWILD/ipdd01.dbf > 8 0 143.8 1.0 1 0 0 > > IPDX /u02/oradata/HOGWILD/ipdx01.dbf > 8 0 143.8 1.0 1 0 0 > > ISCD /u02/oradata/HOGWILD/iscd01.dbf > 5 0 248.0 1.0 1 0 0 > > ISCX /u02/oradata/HOGWILD/iscx01.dbf > 5 0 244.0 1.0 1 0 0 > > ITGD /u02/oradata/HOGWILD/itgd01.dbf > 8 0 138.8 1.0 1 0 0 > > ITGX /u02/oradata/HOGWILD/itgx01.dbf > 8 0 136.3 1.0 1 0 0 > > JAD /u02/oradata/HOGWILD/jad01.dbf > 4 0 397.5 1.0 1 0 0 > > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > JAX /u02/oradata/HOGWILD/jax01.dbf > 4 0 392.5 1.0 1 0 0 > > JED /u02/oradata/HOGWILD/jed01.dbf > 4 0 387.5 1.0 1 0 0 > > JEX /u02/oradata/HOGWILD/jex01.dbf > 4 0 387.5 1.0 1 0 0 > > JGD /u02/oradata/HOGWILD/jgd01.dbf > 4 0 387.5 1.0 1 0 0 > > JGX /u02/oradata/HOGWILD/jgx01.dbf > 4 0 387.5 1.0 1 0 0 > > JLD /u02/oradata/HOGWILD/jld01.dbf > 4 0 385.0 1.0 1 0 0 > > JLX /u02/oradata/HOGWILD/jlx01.dbf > 4 0 382.5 1.0 1 0 0 > > JTFD /u02/oradata/HOGWILD/jtfd01.dbf > 1 0 ###### 1.0 1 0 0 > > JTFX /u02/oradata/HOGWILD/jtfx01.dbf > 1 0 ###### 1.0 1 0 0 > > JTMD /u02/oradata/HOGWILD/jtmd01.dbf > 8 0 133.8 1.0 1 0 0 > > JTMX /u02/oradata/HOGWILD/jtmx01.dbf > 8 0 133.8 1.0 1 0 0 > > JTSD /u02/oradata/HOGWILD/jtsd01.dbf > 8 0 131.3 1.0 1 0 0 > > JTSX /u02/oradata/HOGWILD/jtsx01.dbf > 8 0 131.3 1.0 1 0 0 > > MED /u02/oradata/HOGWILD/med01.dbf > 6 0 196.7 1.0 1 0 0 > > MEX /u02/oradata/HOGWILD/mex01.dbf > 6 0 195.0 1.0 1 0 0 > > MFGD /u02/oradata/HOGWILD/mfgd01.dbf > 2 0 720.0 1.0 1 0 0 > > MFGX /u02/oradata/HOGWILD/mfgx01.dbf > 2 0 715.0 1.0 1 0 0 > > MRPD /u02/oradata/HOGWILD/mrpd01.dbf > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > 2 0 710.0 1.0 1 0 0 > > MRPX /u02/oradata/HOGWILD/mrpx01.dbf > 2 0 710.0 1.0 1 0 0 > > MSCD /u02/oradata/HOGWILD/mscd01.dbf > 3 0 496.7 1.0 1 0 0 > > MSCX /u02/oradata/HOGWILD/mscx01.dbf > 3 0 490.0 1.0 1 0 0 > > MSDD /u02/oradata/HOGWILD/msdd01.dbf > 3 0 503.3 1.0 1 0 0 > > MSDX /u02/oradata/HOGWILD/msdx01.dbf > 3 0 503.3 1.0 1 0 0 > > MSOD /u02/oradata/HOGWILD/msod01.dbf > 3 0 496.7 1.0 1 0 0 > > MSOX /u02/oradata/HOGWILD/msox01.dbf > 3 0 496.7 1.0 1 0 0 > > MSRD /u02/oradata/HOGWILD/msrd01.dbf > 8 0 131.3 1.0 1 0 0 > > MSRX /u02/oradata/HOGWILD/msrx01.dbf > 8 0 127.5 1.0 1 0 0 > > MWAD /u02/oradata/HOGWILD/mwad01.dbf > 4 0 307.5 1.0 1 0 0 > > MWAX /u02/oradata/HOGWILD/mwax01.dbf > 4 0 305.0 1.0 1 0 0 > > OED /u02/oradata/HOGWILD/oed01.dbf > 4 0 325.0 1.0 1 0 0 > > OEX /u02/oradata/HOGWILD/oex01.dbf > 4 0 320.0 1.0 1 0 0 > > OKBD /u02/oradata/HOGWILD/okbd01.dbf > 8 0 126.3 1.0 1 0 0 > > OKBX /u02/oradata/HOGWILD/okbx01.dbf > 8 0 125.0 1.0 1 0 0 > > OKCD /u02/oradata/HOGWILD/okcd01.dbf > 5 0 242.0 1.0 1 0 0 > > OKCX /u02/oradata/HOGWILD/okcx01.dbf > 5 0 242.0 1.0 1 0 0 > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > > OKED /u02/oradata/HOGWILD/oked01.dbf > 3 0 490.0 1.0 1 0 0 > > OKEX /u02/oradata/HOGWILD/okex01.dbf > 3 0 490.0 1.0 1 0 0 > > OKID /u02/oradata/HOGWILD/okid01.dbf > 8 0 123.8 1.0 1 0 0 > > OKIX /u02/oradata/HOGWILD/okix01.dbf > 8 0 122.5 1.0 1 0 0 > > OKLD /u02/oradata/HOGWILD/okld01.dbf > 9 0 85.6 1.0 1 0 0 > > OKLX /u02/oradata/HOGWILD/oklx01.dbf > 9 0 84.4 1.0 1 0 0 > > OKOD /u02/oradata/HOGWILD/okod01.dbf > 9 0 113.3 1.0 1 0 0 > > OKOX /u02/oradata/HOGWILD/okox01.dbf > 9 0 111.1 1.0 1 0 0 > > OKRD /u02/oradata/HOGWILD/okrd01.dbf > 9 0 111.1 1.0 1 0 0 > > OKRX /u02/oradata/HOGWILD/okrx01.dbf > 9 0 108.9 1.0 1 0 0 > > OKSD /u02/oradata/HOGWILD/oksd01.dbf > 5 0 218.0 1.0 1 0 0 > > OKSX /u02/oradata/HOGWILD/oksx01.dbf > 5 0 216.0 1.0 1 0 0 > > OKXD /u02/oradata/HOGWILD/okxd01.dbf > 6 0 173.3 1.0 1 0 0 > > OKXX /u02/oradata/HOGWILD/okxx01.dbf > 6 0 171.7 1.0 1 0 0 > > ONTD /u02/oradata/HOGWILD/ontd01.dbf > 9 0 81.1 1.0 1 0 0 > > ONTX /u02/oradata/HOGWILD/ontx01.dbf > 8 0 88.8 1.0 1 0 0 > > OPID /u02/oradata/HOGWILD/opid01.dbf > 5 0 260.0 1.0 1 0 0 > > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > OPIX /u02/oradata/HOGWILD/opix01.dbf > 5 0 258.0 1.0 1 0 0 > > OSMD /u02/oradata/HOGWILD/osmd01.dbf > 4 0 335.0 1.0 1 0 0 > > OSMX /u02/oradata/HOGWILD/osmx01.dbf > 4 0 330.0 1.0 1 0 0 > > OTAD /u02/oradata/HOGWILD/otad01.dbf > 4 0 402.5 1.0 1 0 0 > > OTAX /u02/oradata/HOGWILD/otax01.dbf > 4 0 397.5 1.0 1 0 0 > > OWAPUB /u02/oradata/HOGWILD/owad01.dbf > 1 0 ###### 1.0 1 0 0 > > OZFD /u02/oradata/HOGWILD/ozfd01.dbf > 1 0 ###### 1.0 1 0 0 > > OZFX /u02/oradata/HOGWILD/ozfx01.dbf > 1 0 ###### 1.0 1 0 0 > > OZPD /u02/oradata/HOGWILD/ozpd01.dbf > 1 0 ###### 1.0 1 0 0 > > OZPX /u02/oradata/HOGWILD/ozpx01.dbf > 1 0 ###### 1.0 1 0 0 > > OZSD /u02/oradata/HOGWILD/ozsd01.dbf > 1 0 ###### 1.0 1 0 0 > > OZSX /u02/oradata/HOGWILD/ozsx01.dbf > 1 0 ###### 1.0 1 0 0 > > PAD /u02/oradata/HOGWILD/pad01.dbf > 3 0 400.0 1.0 1 0 0 > > PAX /u02/oradata/HOGWILD/pax01.dbf > 3 0 396.7 1.0 1 0 0 > > PJID /u02/oradata/HOGWILD/pjid01.dbf > 9 0 82.2 1.0 1 0 0 > > PJIX /u02/oradata/HOGWILD/pjix01.dbf > 9 0 80.0 1.0 1 0 0 > > PJMD /u02/oradata/HOGWILD/pjmd01.dbf > 3 0 513.3 1.0 1 0 0 > > PJMX /u02/oradata/HOGWILD/pjmx01.dbf > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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 503.3 1.0 1 0 0 > > PMID /u02/oradata/HOGWILD/pmid01.dbf > 8 0 102.5 1.0 1 0 0 > > PMIX /u02/oradata/HOGWILD/pmix01.dbf > 8 0 101.3 1.0 1 0 0 > > PND /u02/oradata/HOGWILD/pnd01.dbf > 3 0 436.7 1.0 1 0 0 > > PNX /u02/oradata/HOGWILD/pnx01.dbf > 3 0 433.3 1.0 1 0 0 > > POAD /u02/oradata/HOGWILD/poad01.dbf > 5 0 258.0 1.0 1 0 0 > > POAX /u02/oradata/HOGWILD/poax01.dbf > 5 0 258.0 1.0 1 0 0 > > POD /u02/oradata/HOGWILD/pod01.dbf > 2 0 590.0 1.0 1 0 0 > > POMD /u02/oradata/HOGWILD/pomd01.dbf > 4 0 327.5 1.0 1 0 0 > > POMX /u02/oradata/HOGWILD/pomx01.dbf > 4 0 325.0 1.0 1 0 0 > > POND /u02/oradata/HOGWILD/pond01.dbf > 9 0 76.7 1.0 1 0 0 > > PONX /u02/oradata/HOGWILD/ponx01.dbf > 9 0 76.7 1.0 1 0 0 > > POSD /u02/oradata/HOGWILD/posd01.dbf > 9 0 110.0 1.0 1 0 0 > > POSX /u02/oradata/HOGWILD/posx01.dbf > 9 0 107.8 1.0 1 0 0 > > POX /u02/oradata/HOGWILD/pox01.dbf > 2 0 580.0 1.0 1 0 0 > > PSAD /u02/oradata/HOGWILD/psad01.dbf > 5 0 308.0 1.0 1 0 0 > > PSAX /u02/oradata/HOGWILD/psax01.dbf > 5 0 304.0 1.0 1 0 0 > > PSBD /u02/oradata/HOGWILD/psbd01.dbf > 4 0 382.5 1.0 1 0 0 > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > > PSBX /u02/oradata/HOGWILD/psbx01.dbf > 4 0 382.5 1.0 1 0 0 > > PSPD /u02/oradata/HOGWILD/pspd01.dbf > 4 0 370.0 1.0 1 0 0 > > PSPX /u02/oradata/HOGWILD/pspx01.dbf > 4 0 367.5 1.0 1 0 0 > > PVD /u02/oradata/HOGWILD/pvd01.dbf > 6 0 236.7 1.0 1 0 0 > > PVX /u02/oradata/HOGWILD/pvx01.dbf > 6 0 233.3 1.0 1 0 0 > > QAD /u02/oradata/HOGWILD/qad01.dbf > 3 0 426.7 1.0 1 0 0 > > QAX /u02/oradata/HOGWILD/qax01.dbf > 3 0 426.7 1.0 1 0 0 > > QOTD /u02/oradata/HOGWILD/qotd01.dbf > 9 0 73.3 1.0 1 0 0 > > QOTX /u02/oradata/HOGWILD/qotx01.dbf > 9 0 71.1 1.0 1 0 0 > > QPD /u02/oradata/HOGWILD/qpd01.dbf > 9 0 82.2 1.0 1 0 0 > > QPX /u02/oradata/HOGWILD/qpx01.dbf > 9 0 81.1 1.0 1 0 0 > > QRMD /u02/oradata/HOGWILD/qrmd01.dbf > 9 0 71.1 1.0 1 0 0 > > QRMX /u02/oradata/HOGWILD/qrmx01.dbf > 9 0 68.9 1.0 1 0 0 > > RBS /u02/oradata/HOGWILD/rbs01.dbf > 2 0 620.0 1.0 277 0 0 > /u02/oradata/HOGWILD/rbs02.dbf > 9 0 62.2 1.0 42 0 0 > > RGD /u02/oradata/HOGWILD/rgd01.dbf > 1 0 ###### 1.0 1 0 0 > > RGX /u02/oradata/HOGWILD/rgx01.dbf > 1 0 ###### 1.0 1 0 0 > > RHXD /u02/oradata/HOGWILD/rhxd01.dbf > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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 490.0 1.0 1 0 0 > > RHXX /u02/oradata/HOGWILD/rhxx01.dbf > 3 0 490.0 1.0 1 0 0 > > RLAD /u02/oradata/HOGWILD/rlad01.dbf > 2 0 685.0 1.0 1 0 0 > > RLAX /u02/oradata/HOGWILD/rlax01.dbf > 2 0 680.0 1.0 1 0 0 > > RLMD /u02/oradata/HOGWILD/rlmd01.dbf > 9 0 77.8 1.0 1 0 0 > > RLMX /u02/oradata/HOGWILD/rlmx01.dbf > 9 0 77.8 1.0 1 0 0 > > SSPD /u02/oradata/HOGWILD/sspd01.dbf > 3 0 486.7 1.0 1 0 0 > > SSPX /u02/oradata/HOGWILD/sspx01.dbf > 3 0 483.3 1.0 1 0 0 > > SYSTEM /u02/oradata/HOGWILD/system01.dbf > 14 0 92.1 1.0 5 0 0 > /u02/oradata/HOGWILD/system02.dbf > 11 0 110.0 1.0 7 0 0 > /u02/oradata/HOGWILD/system03.dbf > 11 0 113.6 1.0 2 0 0 > /u02/oradata/HOGWILD/system04.dbf > 10 0 123.0 1.0 8 0 0 > /u02/oradata/HOGWILD/system05.dbf > 3 0 383.3 1.0 2 0 0 > /u02/oradata/HOGWILD/system06.dbf > 17 0 58.8 1.0 1 0 0 > /u02/oradata/HOGWILD/system07.dbf > 10 0 63.0 1.0 1 0 0 > /u02/oradata/HOGWILD/system08.dbf > 11 0 54.5 1.0 1 0 0 > > TEMP /u02/oradata/HOGWILD/temp01.dbf > 7,040 4 38.3 10.6 6,524 4 0 > /u02/oradata/HOGWILD/temp02.dbf > 607 0 26.9 12.0 618 0 0 > > TOOLS /u02/oradata/HOGWILD/toolsd01.dbf > 213 0 12.5 5.0 164 0 0 > > VEAD /u02/oradata/HOGWILD/vead01.dbf > 9 0 75.6 1.0 1 0 0 > > VEAX /u02/oradata/HOGWILD/veax01.dbf > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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 75.6 1.0 1 0 0 > > VEHD /u02/oradata/HOGWILD/vehd01.dbf > 2 0 680.0 1.0 1 0 0 > > VEHX /u02/oradata/HOGWILD/vehx01.dbf > 2 0 680.0 1.0 1 0 0 > > WIPD /u02/oradata/HOGWILD/wipd01.dbf > 2 0 695.0 1.0 1 0 0 > > WIPX /u02/oradata/HOGWILD/wipx01.dbf > 2 0 695.0 1.0 1 0 0 > > WMSD /u02/oradata/HOGWILD/wmsd01.dbf > 4 0 315.0 1.0 1 0 0 > > WMSX /u02/oradata/HOGWILD/wmsx01.dbf > 4 0 312.5 1.0 1 0 0 > > WPSD /u02/oradata/HOGWILD/wpsd01.dbf > 4 0 312.5 1.0 1 0 0 > > WPSX /u02/oradata/HOGWILD/wpsx01.dbf > 4 0 312.5 1.0 1 0 0 > > WSHD /u02/oradata/HOGWILD/wshd01.dbf > 9 0 73.3 1.0 1 0 0 > > WSHX /u02/oradata/HOGWILD/wshx01.dbf > 9 0 71.1 1.0 1 0 0 > > WSMD /u02/oradata/HOGWILD/wsmd01.dbf > 4 0 302.5 1.0 1 0 0 > > WSMX /u02/oradata/HOGWILD/wsmx01.dbf > 4 0 300.0 1.0 1 0 0 > > XDPD /u02/oradata/HOGWILD/xdpd01.dbf > 7 0 141.4 1.0 1 0 0 > > XDPX /u02/oradata/HOGWILD/xdpx01.dbf > 7 0 138.6 1.0 1 0 0 > > XLAD /u02/oradata/HOGWILD/xlad01.dbf > 8 0 97.5 1.0 1 0 0 > > XLAX /u02/oradata/HOGWILD/xlax01.dbf > 8 0 93.8 1.0 1 0 0 > > XNCD /u02/oradata/HOGWILD/xncd01.dbf > 7 0 150.0 1.0 1 0 0 > File IO Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->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) > -------------- ------- ------ ------- ------------ -------- ---------- > ------ > > XNCX /u02/oradata/HOGWILD/xncx01.dbf > 7 0 148.6 1.0 1 0 0 > > XNID /u02/oradata/HOGWILD/xnid01.dbf > 9 0 104.4 1.0 1 0 0 > > XNIX /u02/oradata/HOGWILD/xnix01.dbf > 9 0 104.4 1.0 1 0 0 > > XNMD /u02/oradata/HOGWILD/xnmd01.dbf > 7 0 154.3 1.0 1 0 0 > > XNMX /u02/oradata/HOGWILD/xnmx01.dbf > 7 0 151.4 1.0 1 0 0 > > XNPD /u02/oradata/HOGWILD/xnpd01.dbf > 7 0 145.7 1.0 1 0 0 > > XNPX /u02/oradata/HOGWILD/xnpx01.dbf > 7 0 142.9 1.0 1 0 0 > > XNSD /u02/oradata/HOGWILD/xnsd01.dbf > 7 0 147.1 1.0 1 0 0 > > XNSX /u02/oradata/HOGWILD/xnsx01.dbf > 7 0 145.7 1.0 1 0 0 > > CTOXD /u02/oradata/HOGWILD/CTOXd01.dbf > 17,512 10 5.0 4.8 66 0 0 > > CTOXX /u02/oradata/HOGWILD/CTOXx01.dbf > 62 0 30.6 1.0 146 0 0 > > XTRD /u02/oradata/HOGWILD/xtrd01.dbf > 2 0 600.0 1.0 1 0 0 > > XTRX /u02/oradata/HOGWILD/xtrx01.dbf > 2 0 595.0 1.0 1 0 0 > > ------------------------------------------------------------- > Buffer Pool Statistics for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > -> 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 148,417 5,852,677 144,077 1,141 0 0 > 0 > ------------------------------------------------------------- > > > > > > Enqueue activity for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > -> ordered by waits desc, gets desc > > Enqueue Gets Waits > ---------- ------------ ---------- > TX 6,487 1 > ------------------------------------------------------------- > Rollback Segment Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->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 7.0 0.00 0 0 0 0 > 1 1,941.0 0.00 240,914 0 0 0 > 2 2,283.0 0.00 244,320 0 0 0 > 3 2,948.0 0.00 287,990 0 0 0 > 4 2,068.0 0.00 180,090 0 0 0 > 5 2,036.0 0.00 217,040 1 0 0 > 6 1,634.0 0.00 141,034 0 0 0 > 7 2,981.0 0.00 552,464 1 0 0 > ------------------------------------------------------------- > Rollback Segment Storage for DB: HOGWILD Instance: HOGWILD Snaps: > 753 -754 > ->Optimal Size should be larger than Avg Active > > RBS No Segment Size Avg Active Optimal Size Maximum Size > ------ --------------- --------------- --------------- --------------- > 0 155,648 0 155,648 > 1 42,590,208 555,591 41,943,040 42,590,208 > 2 42,590,208 606,527 41,943,040 42,590,208 > 3 42,590,208 2,833,457 41,943,040 42,590,208 > 4 42,590,208 1,493,797 41,943,040 42,590,208 > 5 42,590,208 555,591 41,943,040 42,590,208 > 6 42,590,208 498,995 41,943,040 42,590,208 > 7 42,590,208 498,995 41,943,040 42,590,208 > ------------------------------------------------------------- > Latch Activity for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > ->"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 215 0.0 > 0 > Token Manager 872 0.0 > 102 0.0 > active checkpoint queue latch 3,997 0.5 0.0 > 0 > cache buffer handles 1,310 0.0 > 0 > cache buffers chains 14,955,729 0.1 0.0 > 261,210 0.0 > cache buffers lru chain 170,109 0.0 0.0 > 145,609 0.0 > channel handle pool latch 55 0.0 > 0 > channel operations parent lat 82 0.0 > 0 > checkpoint queue latch 43,109 0.1 0.0 > 0 > dml lock allocation 23,233 0.0 > 0 > enqueue hash chains 39,263 0.0 0.0 > 0 > enqueues 43,580 0.0 0.0 > 0 > event group latch 27 0.0 > 0 > file number translation table 98 0.0 > 0 > job_queue_processes parameter 28 0.0 > 0 > ktm global data 6 0.0 > 0 > kwqit: protect wakeup time 56 0.0 > 0 > latch wait list 101 2.0 0.0 > 92 0.0 > library cache 939,857 0.1 0.1 > 1,025 0.1 > library cache load lock 142 0.0 > 0 > list of block allocation 12,932 0.0 > 0 > loader state object freelist 74 0.0 > 0 > longop free list 641 0.0 > 0 > messages 27,660 0.2 0.0 > 0 > multiblock read objects 72,436 0.0 0.0 > 0 > ncodef allocation latch 28 0.0 > 0 > process allocation 27 0.0 > 27 0.0 > process group creation 52 0.0 > 0 > redo allocation 32,319 0.2 0.0 > 0 > redo writing 22,607 0.4 0.0 > 0 > row cache objects 92,988 0.0 0.2 > 0 > sequence cache 1,325 0.0 > 0 > session allocation 13,820 0.0 > 0 > session idle bit 202,835 0.0 0.0 > 0 > session switching 243 0.0 > 0 > shared pool 93,398 0.0 0.3 > 0 > sort extent pool 1,163 0.0 > 0 > transaction allocation 17,352 0.0 0.0 > 0 > transaction branch allocation 28 0.0 > 0 > undo global data 21,729 0.0 > 0 > user lock 380 0.0 > 0 > ------------------------------------------------------------- > Latch Sleep breakdown for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > -> ordered by misses desc > > Get > Spin & > Latch Name Requests Misses Sleeps > Sleeps 1->4 > -------------------------- -------------- ----------- ----------- > ------------ > cache buffers chains 14,955,729 20,678 26 > 20653/24/1/0 > /0 > library cache 939,857 1,025 106 > 938/68/19/0/ > 0 > redo writing 22,607 88 1 > 87/1/0/0/0 > redo allocation 32,319 63 2 > 61/2/0/0/0 > shared pool 93,398 40 12 > 35/0/3/2/0 > row cache objects 92,988 13 3 > 11/1/1/0/0 > ------------------------------------------------------------- > Latch Miss Sources for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > -> 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 26 > 26 > library cache kglhdgn: child: 0 70 > 16 > library cache kglget: child: KGLDSBRD 0 15 > 0 > library cache kglpnp: child 0 5 > 17 > library cache kglpnal: child: alloc spac 0 4 > 4 > library cache kglget: child: KGLDSBYD 0 3 > 2 > library cache kglhdgc: child: 0 2 > 1 > library cache kglpnal: child: before pro 0 1 > 29 > redo allocation kcrfwr: redo allocation 0 1 > 1 > redo allocation kcrfwi: before write 0 1 > 0 > redo writing kcrfwi: after write 0 1 > 0 > row cache objects kqrpre: find obj 0 3 > 2 > shared pool kghfrunp: alloc: clatch no 0 12 > 0 > shared pool kghfrunp: clatch: nowait 0 6 > 0 > ------------------------------------------------------------- > Parent Latch Statistics DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > -> only latches with sleeps are shown > -> ordered by name > > Get Spin > & > Latch Name Requests Misses Sleeps Sleeps > 1->4 > ------------------------ -------------- ----------- ---------- > ------------ > redo allocation 32,672 64 2 > 62/2/0/0/0 > redo writing 22,832 90 1 > 89/1/0/0/0 > row cache objects 93,290 13 3 > 11/1/1/0/0 > shared pool 94,217 40 12 > 35/0/3/2/0 > ------------------------------------------------------------- > Child Latch Statistics DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > -> 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 164 2,045,452 20,463 26 > 20438/24/1/0/ > 0 > library cache 5 262,451 479 38 > 447/26/6/0/0 > library cache 7 137,583 198 26 > 176/18/4/0/0 > library cache 2 136,226 160 18 > 145/12/3/0/0 > library cache 6 131,904 180 26 > 160/14/6/0/0 > library cache 4 113,873 89 9 > 82/5/2/0/0 > library cache 1 92,854 95 7 > 88/7/0/0/0 > library cache 3 71,668 47 4 > 43/4/0/0/0 > ------------------------------------------------------------- > Dictionary Cache Stats for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->"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 0 0 0 > 0 0 > dc_database_links 0 0 0 > 0 0 > dc_files 1 0.0 0 0 > 371 99 > dc_free_extents 0 0 0 > 182 94 > dc_global_oids 214 0.0 0 0 > 430 96 > dc_histogram_data 0 0 0 > 41 89 > dc_histogram_data_valu 0 0 0 > 18 95 > dc_histogram_defs 2,371 0.1 0 0 > ###### 100 > dc_object_ids 16,596 0.1 0 0 > ###### 100 > dc_objects 2,569 1.3 0 0 > ###### 100 > dc_outlines 0 0 0 > 0 0 > dc_profiles 100 0.0 0 0 > 1 11 > dc_rollback_segments 120 0.0 0 0 > 11 65 > dc_segments 3,979 0.0 0 3 > ###### 100 > dc_sequence_grants 27 0.0 0 0 > 536 88 > dc_sequences 180 0.0 0 172 > 87 99 > dc_synonyms 376 3.2 0 0 > 544 99 > dc_tablespace_quotas 16 0.0 0 4 > 16 73 > dc_tablespaces 243 0.0 0 0 > 370 100 > dc_used_extents 0 0 0 > 1 1 > dc_user_grants 1,026 0.0 0 0 > 29 67 > dc_usernames 756 0.0 0 0 > 174 99 > dc_users 3,017 0.0 0 0 > 187 98 > ifs_acl_cache_entries 0 0 0 > 0 0 > ------------------------------------------------------------- > > > Library Cache Activity for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > ->"Pct Misses" should be very low > > Get Pct Pin Pct > Invali- > Namespace Requests Miss Requests Miss Reloads > dations > --------------- ------------ ------ -------------- ------ ---------- > -------- > SQL AREA 5,201 2.2 106,094 0.2 17 > 0 > TABLE/PROCEDURE 82,544 0.0 184,570 0.0 2 > 0 > BODY 5,904 0.0 5,883 0.0 0 > 0 > TRIGGER 557 1.3 557 1.3 0 > 0 > INDEX 1,680 0.0 1,680 0.0 0 > 0 > CLUSTER 0 0 0 > 0 > OBJECT 0 0 0 > 0 > PIPE 0 0 0 > 0 > ------------------------------------------------------------- > SGA Memory Summary for DB: HOGWILD Instance: HOGWILD Snaps: 753 -754 > > SGA regions Size in Bytes > ------------------------------ ---------------- > Database Buffers 409,600,000 > Fixed Size 73,888 > Redo Buffers 10,502,144 > Variable Size 751,656,960 > ---------------- > sum 1,171,832,992 > ------------------------------------------------------------- > > > SGA breakdown difference for DB: HOGWILD Instance: HOGWILD Snaps: > 753 -754 > > Pool Name Begin value End value > Difference > ----------- ------------------------ -------------- -------------- > ----------- > java pool free memory 46,858,240 46,858,240 > 0 > java pool memory in use 3,145,728 3,145,728 > 0 > shared pool DML locks 1,200,000 1,200,000 > 0 > shared pool KGFF heap 247,328 247,328 > 0 > shared pool KGK heap 17,012 17,012 > 0 > shared pool KQLS heap 191,974,044 189,984,332 > -1,989,712 > shared pool PL/SQL DIANA 4,261,708 4,293,536 > 31,828 > shared pool PL/SQL MPCODE 13,382,856 13,480,684 > 97,828 > shared pool PLS non-lib hp 2,096 2,096 > 0 > shared pool State objects 770,520 770,520 > 0 > shared pool db_block_buffers 6,800,000 6,800,000 > 0 > shared pool db_block_hash_buckets 931,096 931,096 > 0 > shared pool dictionary cache 173,661,932 173,683,000 > 21,068 > shared pool enqueue_resources 2,304,000 2,304,000 > 0 > shared pool event statistics per ses 2,777,600 2,777,600 > 0 > shared pool fixed allocation callbac 1,280 1,280 > 0 > shared pool free memory 57,029,104 56,571,416 > -457,688 > shared pool joxlod: in ehe 59,384 59,384 > 0 > shared pool joxlod: in phe 5,955,436 5,955,436 > 0 > shared pool joxlod: init P 370,256 370,256 > 0 > shared pool joxs heap init 4,248 4,248 > 0 > shared pool ktlbk state objects 376,640 376,640 > 0 > shared pool library cache 70,479,328 70,918,532 > 439,204 > shared pool miscellaneous 3,379,984 3,425,780 > 45,796 > shared pool partitioning d 588,712 588,712 > 0 > shared pool pl/sql source 4,160 4,160 > 0 > shared pool ruleset defini 404,588 404,588 > 0 > shared pool sessions 1,724,800 1,724,800 > 0 > shared pool sql area 160,676,512 162,487,776 > 1,811,264 > shared pool table columns 658,856 653,984 > -4,872 > shared pool table definiti 48,212 49,364 > 1,152 > shared pool transactions 784,960 784,960 > 0 > shared pool trigger defini 191,404 195,536 > 4,132 > shared pool trigger inform 940 940 > 0 > shared pool type object de 543,300 543,300 > 0 > db_block_buffers 409,600,000 409,600,000 > 0 > fixed_sga 73,888 73,888 > 0 > log_buffer 10,485,760 10,485,760 > 0 > ------------------------------------------------------------- > init.ora Parameters for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > > End > value > Parameter Name Begin value (if > different) > ----------------------------- --------------------------------- > -------------- > O7_DICTIONARY_ACCESSIBILITY TRUE > _complex_view_merging TRUE > _fast_full_scan_enabled FALSE > _filesystemio_options directIO > _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 0 > _system_trig_enabled TRUE > _table_scan_cost_plus_one TRUE > _trace_files_public TRUE > _use_column_stats_for_functio TRUE > always_anti_join NESTED_LOOPS > always_semi_join NESTED_LOOPS > aq_tm_processes 1 > background_dump_dest /u02/admin/HOGWILD/bdump > compatible 8.1.7 > control_files /u00/oradata/HOGWILD/cntrl01.dbf, > core_dump_dest /u02/admin/HOGWILD/cdump > cursor_sharing EXACT > cursor_space_for_time FALSE > db_block_buffers 50000 > db_block_checking FALSE > db_block_checksum FALSE > db_block_lru_latches 6 > db_block_size 8192 > db_file_multiblock_read_count 8 > db_files 500 > db_name HOGWILD > db_writer_processes 6 > dml_locks 10000 > enqueue_resources 32000 > hash_area_size 2097152 > ifile ?/dbs/ifilecbo.ora > java_pool_size 50000000 > job_queue_interval 90 > job_queue_processes 6 > log_archive_dest /re01/archive/HOGWILD > log_archive_format arch_HOGWILD_%S.arc > log_archive_start TRUE > log_buffer 10485760 > log_checkpoint_interval 100000 > log_checkpoint_timeout 1200 > log_checkpoints_to_alert TRUE > max_dump_file_size 10240 > max_enabled_roles 100 > nls_comp binary > nls_date_format DD-MON-RR > init.ora Parameters for DB: HOGWILD Instance: HOGWILD Snaps: 753 > -754 > > End > value > Parameter Name Begin value (if > different) > ----------------------------- --------------------------------- > -------------- > nls_language american > nls_numeric_characters ., > nls_sort binary > nls_territory america > open_cursors 500 > optimizer_features_enable 8.1.7 > optimizer_max_permutations 2000 > optimizer_mode CHOOSE > optimizer_percent_parallel 0 > parallel_max_servers 12 > parallel_min_servers 0 > processes 400 > query_rewrite_enabled TRUE > rollback_segments rbs01, rbs02, rbs03, rbs04, rbs05 > row_locking always > session_cached_cursors 200 > sessions 800 > shared_pool_reserved_size 68157440 > shared_pool_size 681574400 > sort_area_size 1048576 > sql_trace FALSE > timed_statistics TRUE > user_dump_dest /u02/admin/HOGWILD/udump > utl_file_dir /shared/HOGWILD/export, /shared/PR > ------------------------------------------------------------- > > End of ReportReceived on Sat Jul 17 2004 - 19:34:18 CDT