| 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 -> statpack feedback
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
------------ ----------- ------------ -------- ----------- ---
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
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
Avg
Total Wait
wait Waits
Event Waits Timeouts Time (cs)
(ms) /txn
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 usedby
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 usedby
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
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
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
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
Statistic Total per Second perTrans
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.19,156.6
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.10.3
Statistic Total per Second perTrans
index fast full scans (full) 0 0.0 0.0 leaf node splits 28 0.0 0.0 logons cumulative 332 0.20.4
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.214.5
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.22,259.4
table fetch by rowid 4,663,759 2,591.0 5,193.5 table fetch continued row 2,529 1.42.8
Statistic Total per Second perTrans
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
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
Tablespace
Av Av Av Av Buffer
Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits
Wt(ms)
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
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
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
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
Pct Avg
Pct
Get Get Slps
NoWait NoWait
Latch Name Requests Miss /Miss
Requests Miss
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
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
Child Get
Latch Name Num Requests Misses Sleeps
---------------------- ------ -------------- ----------- ----------
Spin &
Sleeps 1->4
-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 valueDifference
----------- ------------------------ -------------- --------------
-----------
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)
_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
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 Fri Jul 16 2004 - 13:05:21 CDT
 |
 |