| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> 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 Report
Received on Sat Jul 17 2004 - 19:34:18 CDT
 |
 |