Note: 16 dual-core CPUs
STATSPACK report for
DB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ --------
----------- ------- ------------
FELIX 1055146963 felix
1 9.2.0.4.0 NO neprod3
Snap Id
Snap Time
Sessions Curs/Sess Comment
------- ------------------ -------- --------- -------------------
Begin Snap:
49836 09-May-08 10:27:16 1,916 66.1
End
Snap: 49846 09-May-08
11:33:36 2,096 77.3
Elapsed:
66.33 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache:
3,312M
Std Block Size: 8K
Shared
Pool Size:
704M
Log Buffer:
6,144K
Load Profile
~~~~~~~~~~~~
Per Second Per Transaction
--------------- ---------------
Redo size: 1,428,804.57
10,930.47
Logical reads: 176,404.53
1,349.51
Block changes:
13,006.37
99.50
Physical reads:
4,354.84
33.31
Physical writes:
277.13
2.12
User calls:
11,075.77
84.73
Parses:
3,388.08
25.92
Hard parses:
23.52
0.18
Sorts: 1,288.18
9.85
Logons:
14.57
0.11
Executes:
7,420.79
56.77
Transactions:
130.72
% Blocks
changed per Read:
7.37 Recursive
Call %: 60.23
Rollback per
transaction %:
2.20
Rows per Sort:
83.32
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %:
99.87 Redo NoWait %: 100.00
Buffer Hit %: 97.54 In-memory Sort %: 100.00
Library Hit %: 99.73 Soft Parse %: 99.31
Execute to Parse
%: 54.34
Latch Hit %: 99.18
Parse CPU to Parse Elapsd %: 29.92 % Non-Parse CPU: 96.33
Shared Pool
Statistics Begin End
------ ------
Memory Usage %:
85.38 71.48
% SQL with executions>1:
61.35 72.22
% Memory
for SQL w/exec>1:
44.70 56.04
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~
% Total
Event
Waits Time (s)
Ela Time
-------------------------------------------- ------------
----------- --------
db file sequential read
7,144,334
78,974 56.19
log file sync
511,146
25,895 18.42
buffer busy waits
887,810 9,840 7.00
CPU time
9,835
7.00
db file scattered read
577,141 8,622 6.13
-------------------------------------------------------------
Wait Events for DB: FELIX Instance: felix
Snaps: 49836 -49846
-> s -
second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events
last)
Avg
Total Wait wait Waits
Event
Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ----------
---------- ------ --------
db file sequential read 7,144,334 0 78,974 11 13.7
log file sync
511,146 0 25,895 51 1.0
buffer busy waits 887,810 0 9,840 11 1.7
db file scattered read
577,141 0 8,622 15 1.1
PL/SQL lock timer
134 134 4,000 29849 0.0
db file parallel write
65,266 0 1,757 27 0.1
control file sequential read 121,433 0
466
4
0.2
latch free
229,768 105,363
254
1
0.4
log file sequential read
5,888 0 224 38 0.0
enqueue
6,328 10
218 34 0.0
library cache pin
228 38
115 504 0.0
async disk IO
11,537 0
107
9 0.0
log file switch completion
663 0
63
95
0.0
direct path read (lob)
11,548 0
43
4
0.0
control file parallel write 3,278 0
38
12
0.0
direct path write (lob)
10,717 0
27
2
0.0
direct path read
31,657 0
22
1
0.1
SQL*Net more data to client 1,419,749 0
20
0
2.7
direct path write
9,488 0
13
1
0.0
log buffer space
109
0 9 84 0.0
process startup
103
0 2 18 0.0
SQL*Net break/reset to clien 9,484 0
2
0
0.0
log file single write
92 0 1 15 0.0
log file parallel write
183,148
181,961
1
0
0.4
LGWR wait for redo copy
1,095 2 1 1 0.0
row cache lock
78
0 0 2 0.0
kksfbc child completion
6 6 0 10 0.0
library cache load lock
3 0 0 16 0.0
db file single write
6 0 0 4 0.0
undo segment extension
13,523
13,523
0
0
0.0
buffer deadlock
164
163 0 0 0.0
SQL*Net message from client 33,498,777 0 4,355,742 130 64.4
pipe get
89,856
57,466
243,001 2704 0.2
jobq slave wait
3,435
3,230
10,031 2920 0.0
SQL*Net message to client 33,498,933 0
20
0 64.4
SQL*Net more data from clien 72,511 0
6
0
0.1
-------------------------------------------------------------
Background Wait Events for DB: FELIX Instance: felix Snaps: 49836 -49846
-> ordered by wait time desc, waits desc (idle events
last)
Avg
Total Wait wait Waits
Event
Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ----------
---------- ------ --------
db file parallel write
65,267 0 1,757 27 0.1
log file sequential read
5,888 0
224
38
0.0
async disk IO
11,339 0
103
9 0.0
control file parallel write 3,266 0
38
12
0.0
control file sequential read 4,266 0
20
5
0.0
direct path read
31,397 0
19
1
0.1
db file scattered read
401 0 8 20 0.0
db file sequential read
495 0 4 9 0.0
direct path write
8,167 0 2 0 0.0
log file single write
92 0 1 15 0.0
log file parallel write 183,145 181,959 1 0 0.4
LGWR wait for redo copy
1,095 2 1 1 0.0
log buffer space
24
0 1 24 0.0
rdbms ipc reply
39
0 0 12 0.0
enqueue
8 1 0 54 0.0
latch free
6 1 0 0 0.0
buffer busy waits
4
0 0 0 0.0
rdbms ipc message
485,383 225,076 33,609 69 0.9
pmon timer
1,500
1,500
3,885 2590 0.0
smon timer
21 7 3,880
###### 0.0
-------------------------------------------------------------
SQL ordered by Gets for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL iabcudes
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
CPU
Elapsd
Buffer
Gets Executions Gets per Exec %Total Time (s)
Time (s) Hash Value
--------------- ------------ -------------- ------
-------- --------- ----------
145,908,620 444 328,623.0 20.8 784.79
4956.09 1945913086
Module: swMain.exe
select
rh.AGENCY_ID,sia.ALLOCATION_ID,rg.GUEST_TYPE,c.CLIENT_TYP
E from ship_inventory_alloc sia, res_header rh, res_guest
rg, cl
ient c where
rh.res_id=sia.allocation_owner_id and rh.res_id=r
g.res_id and rg.guest_seqn=1 and rg.client_id=c.client_id(+) an
d
sia.allocation_owner_type in ('FIT','OBJ FIT') and sia.ship_
102,867,884 120 857,232.4 14.7 737.93
4753.82 2806385527
SELECT prr.psgr_id, prr.rtg_req_seq, p.res_nr, prr.trav_wth_id
FROM psgr_rtg_req prr, psgr p, gnrc_itin WHERE prr.rtg_r
eq_sts = :b5 AND lst_nm <> 'TBA' -- temporary
fix for
ABC go
live
AND EXISTS (SELECT 'x'
FROM
psgr_voy
WHERE psgr_id = PRR.psgr_id
28,116,890 2,275 12,359.1 4.0 560.46 2034.60
14323837
Module: NeBatch.exe
select RECORD_ID, OWNER_TYPE, OWNER_ID, SECONDARY_ID,
TO_BE_SKIP
PED, INTPARAM1,
STRPARAM1, EXCEPTION_COUNT, EXCEPTION_ME
SSAGE, SOURCE_CODE,
EXTERNAL_USER_ID1, EXTERNAL_USER_ID2
,
CHANGE_SUBTYPE, SysDate as CURDATE, COMMENTS from
SAW.FUTURE_EVENTS FE where FE.SERVANT_ID = :1 and TIME_TO_P
18,940,889
839,740 22.6 2.7 46.55 5246.97 1169339146
Module: NeResObjects.exe
select t.TABLE_PREDICATE_ROW_ID, t.DATA_STR_ID,
sl.STR_TEXT, sl.
PARENT_ID, t.RULE_ID from SAW.COND_TABLE_PREDICATE_ROW t, SAW.C
OND_STR_LIB sl where TABLE_PREDICATE_ID = :1 and sl.STR_ID=t.D
ATA_STR_ID order by 1
18,453,239 11,327
1,629.1
2.6 119.33 775.20 1226881397
ROLLBACK
17,728,306
142,633 124.3 2.5 177.34 748.43
307322155
SELECT fgn.flgt_gnrc_id flgt_gnrc_id,
fgn.dep_cty_cd
|| '|' ||
fgn.arr_cty_cd
|| '|' ||
to_char(fgn.dep_dt, :b5)
|| '|' ||
fgn.carr_cd
|
| '|' ||
fgn.flgt_nr
|| '|'
12,446,179 1,985
6,270.1
1.8 36.40 111.93 424293946
Module: NeBatch.exe
SELECT sum(TRANS_AMOUNT) from ( select TRANS_ID,
decode(CURRENCY_CODE,
:b5, AMOUNT_ORIG_CURRENCY, TRANS_A
MOUNT/:b4) as TRANS_AMOUNT from
ACC_TRANS_DETAIL TD, A
CC_TRANS_TYPE TT, ACC_TRANS_STATUS TS where
SOURCE_ENTI
TY_ID in (select RES_ID from RES_HEADER where GROUP_ID =
:b6)
11,419,968
85
134,352.6
1.6 284.43 3848.07 396367933
Module: Airware.exe
SQL ordered by Gets for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL iabcudes
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
CPU
Elapsd
Buffer
Gets Executions Gets per Exec %Total Time (s)
Time (s) Hash Value
--------------- ------------ -------------- ------
-------- --------- ----------
begin AIR.PSGR_PNR_PKG.PUT_ALL_PSGR_ON_PNR_ITIN (P_CRS_CD
=> :P_
CRS_CD, P_RLOC => :P_RLOC, P_STATUS => :P_STATUS,
P_MSG => :P_MS
G); end;
10,806,216
1,406,305
7.7 1.5 21.49 2794.13 2421339181
Module: NeResObjects.exe
select td.TEMPLATE_RULE_ID, sl.RECORD_ID ,
sl.count_object_type,
sl.is_sell_stopped, sl.WARNING_LIMIT_ABS ,
sl.WARNING_LIM
IT_WGT
, sl.SELLING_LIMIT_ABS ,
sl.SELLING_LIMIT_WGT , sl.
WAITLIST_LIMIT_ABS , sl.WAITLIST_LIMIT_WGT from SAW.COND_RUL
E_TABLE rt, SAW.COND_RULE_TEMPLATE_DEF td,
SAW.PACKAGE_SELLING_L
10,026,922
1 10,026,922.0 1.4 142.52 452.34 1346230989
DECLARE job BINARY_INTEGER := :job; next_date DATE :=
:mydate;
broken BOOLEAN := FALSE; BEGIN
SWJ_AirwareGrpSend(job,next_date,
broken); :mydate := next_date; IF broken THEN :b := 1;
ELSE :b :
= 0; END IF; END;
9,465,534 1,160,640
8.2 1.3 49.59 88.43 1800287036
Module: Airware.exe
SELECT
COUNT(*) FROM BLK, LOC_SEG, LOC WHERE
BLK.BLK_ID =
:b1
AND BLK.BLK_ID
= LOC_SEG.BLK_ID
AND LOC.RLOC_ID
= LOC_SEG.RLOC_ID AND LOC.DT_TM_
CLSD IS NULL
9,465,527 1,160,640
8.2 1.3 36.77 42.74 1461679471
Module: Airware.exe
SELECT
COUNT(*) FROM BLK, LOC_SEG, LOC WHERE
BLK.BLK_ID =
:b1
AND BLK.BLK_ID
= LOC_SEG.BLK_ID
AND LOC.RLOC_ID
= LOC_SEG.RLOC_ID AND LOC.DT_TM_
CLSD IS NOT NULL
8,637,741 1,122
7,698.5
1.2 30.47 231.95 151754632
Module: NeBatch.exe
SELECT SW_ACCCOMMON.GETGRPINVTOTAL (:b1, :b2) -
SW_ACCCOMMON.GET
GRPINVPAID
(:b1, :b2),
SW_ACCCOMMON.GETGRPCOMPAID
(
:b1, null, :b2),
SW_ACCCOMMON.GETGRPCOMTOTAL (:b1, nu
ll) from dual
8,402,682 892
9,420.0
1.2 41.36 112.02 3466664315
Module: w3wp.exe
SELECT
ci.sort_day, ci.sort_seq,ci.DAY, ci.port, ci.operation,
ci.arrive, ci.depart, ci.comments
FROM abc_rv_combi
ned_itin_edoc ci
WHERE ci.guest_id = :b1
AND
( (ci.operation NOT LIKE
'FLIGHT%')
OR (
ci.operation LIKE 'FLIGHT%'
AND E
8,118,221 3,846
2,110.8
1.2 216.86 463.04 3291216920
Module: NeResObjects.exe
begin SAW.SW_SELL_LIMIT.CHECKREPROCQUEUEONEDIT
(P_OWNERTYPE => :
SQL ordered by Gets for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL iabcudes
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
CPU
Elapsd
Buffer
Gets Executions Gets per Exec %Total Time (s)
Time (s) Hash Value
--------------- ------------ -------------- ------
-------- --------- ----------
P_OWNERTYPE, P_OWNERID => :P_OWNERID); end;
8,039,853 3,047
2,638.6
1.1 210.54 421.70 381575659
Module: NeResObjects.exe
SELECT max(q.job_id) from SELL_LIMIT_REPROC_QUEUE q wh
ere q.status = 'COMMITTED'
5,474,230
6
912,371.7
0.8 48.50 80.14 1262332316
Module: Airware.exe
SELECT BLK.BLK_ID, BLK.INV_CLOS,
BLK.ITIN_ID,
-------------------------------------------------------------
SQL ordered by Reads for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Disk Reads Threshold: 1000
CPU
Elapsd
Physical
Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------
-------- --------- ----------
1,077,458
67
16,081.5
6.2 80.34 852.53 2952169585
Module: JDBC Thin Client
BEGIN ABCSAW.ABC_ESB_UTIL.DEL_NON_AMAD_EVENTS(:1); END;
1,077,437 67
16,081.1
6.2 80.26 852.19 1704610759
Module: JDBC Thin Client
SELECT record_id
--SELECT rh.res_id FROM
owner_event oe , res
_header
rh WHERE oe.change_subtype
= 'AMADEUS UPDATES' AND oe
.owner_id = rh.res_id AND rh.source_code != 'AMADEUS'
AND ROWNUM <= :b1
660,392
54
12,229.5
3.8 30.88 566.09 973811302
Module: NeBatch.exe
SELECT rownum, psgr_id FROM psgr WHERE ((psgr_id
= :b
2)
OR (:b2 IS NULL)) AND
((res_nr = :b1) OR (:b1
IS NULL))
463,437 444
1,043.8
2.7 784.79 4956.09 1945913086
Module: swMain.exe
select
rh.AGENCY_ID,sia.ALLOCATION_ID,rg.GUEST_TYPE,c.CLIENT_TYP
E from ship_inventory_alloc sia, res_header rh, res_guest
rg, cl
ient c where
rh.res_id=sia.allocation_owner_id and rh.res_id=r
g.res_id and rg.guest_seqn=1 and rg.client_id=c.client_id(+) an
d
sia.allocation_owner_type in ('FIT','OBJ FIT') and sia.ship_
426,278 839,740
0.5 2.5 46.55 5246.97 1169339146
Module: NeResObjects.exe
select t.TABLE_PREDICATE_ROW_ID, t.DATA_STR_ID,
sl.STR_TEXT, sl.
PARENT_ID, t.RULE_ID from SAW.COND_TABLE_PREDICATE_ROW t, SAW.C
OND_STR_LIB sl where TABLE_PREDICATE_ID = :1 and sl.STR_ID=t.D
ATA_STR_ID order by 1
218,119 1,406,305
0.2 1.3 21.49 2794.13 2421339181
Module: NeResObjects.exe
select td.TEMPLATE_RULE_ID, sl.RECORD_ID ,
sl.count_object_type,
sl.is_sell_stopped, sl.WARNING_LIMIT_ABS ,
sl.WARNING_LIM
IT_WGT
, sl.SELLING_LIMIT_ABS ,
sl.SELLING_LIMIT_WGT , sl.
WAITLIST_LIMIT_ABS , sl.WAITLIST_LIMIT_WGT from SAW.COND_RUL
E_TABLE rt, SAW.COND_RULE_TEMPLATE_DEF td,
SAW.PACKAGE_SELLING_L
201,995
2,275
88.8 1.2 560.46 2034.60
14323837
Module: NeBatch.exe
select RECORD_ID, OWNER_TYPE, OWNER_ID, SECONDARY_ID,
TO_BE_SKIP
PED, INTPARAM1,
STRPARAM1, EXCEPTION_COUNT, EXCEPTION_ME
SSAGE, SOURCE_CODE,
EXTERNAL_USER_ID1, EXTERNAL_USER_ID2
,
CHANGE_SUBTYPE, SysDate as CURDATE, COMMENTS from
SAW.FUTURE_EVENTS FE where FE.SERVANT_ID = :1 and TIME_TO_P
151,719
85
1,784.9
0.9 284.43 3848.07 396367933
Module: Airware.exe
begin AIR.PSGR_PNR_PKG.PUT_ALL_PSGR_ON_PNR_ITIN (P_CRS_CD
=> :P_
CRS_CD, P_RLOC => :P_RLOC, P_STATUS => :P_STATUS,
P_MSG => :P_MS
G); end;
SQL ordered by Reads for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical
Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------
-------- --------- ----------
128,518 164
783.6 0.7 57.12 3182.20 3880582655
Module: Airware.exe
SELECT 'x' FROM psgr_tran, rpt_operation WHERE psgr_
id
= :b3 AND rtg_req_seq
= :b2
AND rpt_operation.op_code = :b1 AND psgr_tran.rpt
_op_id
= rpt_operation.rpt_op_id AND comp_dt
IS NOT NULL
120,950
88,583
1.4 0.7 22.79 1669.36 364340444
Module: SQL*Plus
SELECT COUNT(1) FROM SAW.FAX_QUEUE WHERE ENTITY_ID = :b
2 AND TIME_STAMP >
:b1
AND ENTITY_TYPE = 'FIT'
AND
DOC_CODE = 'CONFIRMATION'
111,777 120
931.5 0.6 737.93 4753.82 2806385527
SELECT prr.psgr_id, prr.rtg_req_seq, p.res_nr, prr.trav_wth_id
FROM psgr_rtg_req prr, psgr p, gnrc_itin WHERE prr.rtg_r
eq_sts = :b5 AND lst_nm <> 'TBA' -- temporary
fix for
ABC go
live
AND EXISTS (SELECT 'x'
FROM
psgr_voy
WHERE psgr_id = PRR.psgr_id
101,536 1,403,502
0.1 0.6 10.65 1271.31 2589586491
Module: NeResObjects.exe
select t.TABLE_PREDICATE_ID, t.EFFECTIVE_FROM,
t.HEADER_STR_ID,
t.STDTYPES, t.ROW_SORT_ORDER, 0 from SAW.COND_TABLE_PREDICATE t
where
t.RULE_TABLE_ID = :1 and t.DEL_DATE is null and t.RULE_S
ESSION_ID is null order by 2
100,072
2,385
42.0 0.6 16.32 1654.93 292534056
Module: NeBatch.exe
delete from SAW.RES_INVOICE_ITEM where RES_ID = :1
85,625
13
6,586.5
0.5
6.85 121.10
2208614960
Module: Airware.exe
SELECT pit.psgr_id psgr_id,
pit.rtg_req_seq r
tg_req_seq,
pit.psgr_itin_seq psgr_itin_seq,
prr.nr_seats nr_seats,
prr.alloc_itin_id allo
c_itin_id FROM psgr_rtg_req prr,
psgr_itin
pit,
itin,
psgr -- Off_id added 03/05
84,330
2
42,165.0
0.5
7.78 1380.77
3713575954
Module: swMain.exe
select sum(AR_BALANCE) as TRANS_AMOUNT, DUE as DUE_DATE,
TRANS_S
TATUS_CLASS, CURRENCY_CODE from ( select TRANS_ID, AMOUNT_
ORIG_CURRENCY as AR_BALANCE, TRANS_STATUS_CLASS,
CURRENCY_CODE,
trunc(AR_AP_DUE_DATE, :1) as DUE from SAW.ACC_TRA
NS_DETAIL TD, SAW.ACC_TRANS_STATUS TS where DEST_ENTITY_ID
=
78,396
63
1,244.4
0.5
3.34
71.21 2782196245
Module: NeBatch.exe
DELETE FROM DBMS_LOCK_ALLOCATED WHERE EXPIRATION <
SYSDATE
77,629
12,523
6.2 0.4 4.91 100.45 1135226527
Module: NeBatch.exe
SQL ordered by Reads for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Disk Reads Threshold: 1000
CPU
Elapsd
Physical
Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------
-------- --------- ----------
begin :Result := SAW.SW_LOCK.ALLOCATE (P_LOCKNAME =>
:P_LOCKNAME
, P_EXPSECS => :P_EXPSECS); end;
69,772
5
13,954.4
0.4
3.28
60.25 137212106
Module: swMain.exe
select * from AM_ORDER_HEADER OH
where OH.AM_BOOKING_TYP
E=:b4 and
OH.ORD_STATUS_CODE <> :b3 and
nvl(OH.RES_ID,OH.GROUP_ID)=:b2 and CURRENCY_CODE <> :b1
-------------------------------------------------------------
SQL ordered by Executions for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Executions Threshold: 100
CPU per Elap
per
Executions
Rows Processed Rows
per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- -----------
---------- ----------
1,406,305 1,406,495
1.0
0.00 0.00 2421339181
Module: NeResObjects.exe
select td.TEMPLATE_RULE_ID, sl.RECORD_ID ,
sl.count_object_type,
sl.is_sell_stopped, sl.WARNING_LIMIT_ABS ,
sl.WARNING_LIM
IT_WGT
, sl.SELLING_LIMIT_ABS ,
sl.SELLING_LIMIT_WGT , sl.
WAITLIST_LIMIT_ABS , sl.WAITLIST_LIMIT_WGT from SAW.COND_RUL
E_TABLE rt, SAW.COND_RULE_TEMPLATE_DEF td,
SAW.PACKAGE_SELLING_L
1,403,502 1,205,657
0.9
0.00 0.00 2589586491
Module: NeResObjects.exe
select t.TABLE_PREDICATE_ID, t.EFFECTIVE_FROM,
t.HEADER_STR_ID,
t.STDTYPES, t.ROW_SORT_ORDER, 0 from SAW.COND_TABLE_PREDICATE t
where
t.RULE_TABLE_ID = :1 and t.DEL_DATE is null and t.RULE_S
ESSION_ID is null order by 2
1,160,640 1,160,640
1.0
0.00 0.00 1461679471
Module: Airware.exe
SELECT
COUNT(*) FROM BLK, LOC_SEG, LOC WHERE
BLK.BLK_ID =
:b1
AND BLK.BLK_ID
= LOC_SEG.BLK_ID
AND LOC.RLOC_ID
= LOC_SEG.RLOC_ID AND LOC.DT_TM_
CLSD IS NOT NULL
1,160,640 1,160,640
1.0
0.00 0.00 1800287036
Module: Airware.exe
SELECT
COUNT(*) FROM BLK, LOC_SEG, LOC WHERE
BLK.BLK_ID =
:b1
AND BLK.BLK_ID
= LOC_SEG.BLK_ID
AND LOC.RLOC_ID
= LOC_SEG.RLOC_ID AND LOC.DT_TM_
CLSD IS NULL
1,020,964 1,021,009
1.0
0.00 0.00 2574507342
Module: NeResObjects.exe
SELECT parent_id, str_text from COND_STR_LIB where
str_i
d=:b1
933,498 933,496
1.0
0.00 0.00 1307778841
select condition from cdef$ where rowid=:1
885,853 885,908
1.0
0.00 0.00 2063551844
Module: NeResObjects.exe
SELECT decode(IS_NULL,'Y',0,1) from VCS_TYPE_FIELD where ROW
_TYPE = :b2 and FIELD_NAME=:b1
868,762
0
0.0
0.00 0.00 3854393482
Module: NeResObjects.exe
SELECT Number_Value from VCS_ADDITIONAL_FIELD_VALUE where Ro
w_Type=:b3 and Field_Name=:b2 and Record_Id=:b1
839,740 4,750,043
5.7
0.00 0.01 1169339146
Module: NeResObjects.exe
select t.TABLE_PREDICATE_ROW_ID, t.DATA_STR_ID,
sl.STR_TEXT, sl.
PARENT_ID, t.RULE_ID from SAW.COND_TABLE_PREDICATE_ROW t, SAW.C
OND_STR_LIB sl where TABLE_PREDICATE_ID = :1 and sl.STR_ID=t.D
ATA_STR_ID order by 1
SQL ordered by Executions for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Executions Threshold: 100
CPU
per Elap per
Executions
Rows Processed Rows
per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- -----------
---------- ----------
533,796
3,711
0.0
0.00 0.00 1103423085
SELECT *
FROM
GTT_Itin_seg_tbl
WHERE rte_req_seq = :b4
AND
rte_req_leg_seq = :b3
AND dep_cty_cd
= :b2 AND
arr_cty_cd = :b1
507,448 507,446
1.0
0.00 0.00 1661451937
SELECT * from VARIABLE_VALUE where
VARIABLE_CODE = :b1
order by DATE_FROM
desc
367,647
0
0.0
0.00 0.00 1053795750
COMMIT
297,891 297,897
1.0
0.00 0.00 1917022609
Module: NeResObjects.exe
select SAW.VCS_COND_MAINT.getSTR( :1) from dual
268,471
6,226
0.0
0.00 0.00 3876246956
SELECT sched_seq FROM
GTT_Itin_seg_tbl
WHERE rte_req_seq
= :b4
AND rte_req_leg_seq
= :b3 AND ((vac_strt_cty_cd
= :b2 AND trnarnd_cty_cd = :b1) OR (trnarnd_cty_cd = :b2 A
ND vac_end_cty_cd = :b1)) GROUP BY sched_seq
261,424
303
0.0
0.00 0.00 542663187
SELECT sched_seq FROM
GTT_Itin_seg_tbl
WHERE rte_req_seq
= :b4
AND
rte_req_leg_seq = :b3
AND ((dep_cty_cd
= :b2
AND
trnarnd_cty_cd = :b1)
OR
(trnarnd_cty_cd = :b2 AND ar
r_cty_cd = :b1)) GROUP BY sched_seq
261,298 534,268 2.0 0.00
0.00 1044999867
SELECT sched_seq, sched_leg_seq, dep_cty_cd,
arr_cty_cd FROM
GTT_Itin_seg_tbl
WHERE rte_req_seq =
:b2 AND rte_req_le
g_seq = :b1
ORDER BY sched_seq, sched_leg_seq
247,238 247,230
1.0
0.00 0.00 2695447312
Module: NeResObjects.exe
SELECT
SAW.VCS_ADDITIONAL_FIELDS.Get_Num_Value('AGENCY','FINAL_P
AYMENT_DUE_DAYS_PRIOR',1) FINAL_PAYMENT_DUE_DAYS_PRIOR
FROM DUAL
174,164 172,987 1.0 0.00
0.00 2567587895
Module: Airware.exe
SELECT blk_key_mod_elm.elm_len,
blk_key_mod_elm.dta_typ
FROM
blk_key_mod_elm WHERE blk_key_mod_cd = :b2
AND blk_key_mod_seq = :b1
174,164 174,164
1.0
0.00 0.00 3348519628
Module: Airware.exe
SELECT SUM(elm_len) FROM BLK_KEY_MOD_ELM WHE
RE BLK_KEY_MOD_CD = :b2 AND
BLK_KEY_MOD_SEQ < :
b1
162,724 162,666
1.0 0.00 0.00 2041395724
Module: swMain.exe
select
RESULT_TYPE,RULE_NAME,ROW_TYPE_CODE,TEMPLATE_TYPE,TEMPLAT
SQL ordered by Executions for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Executions Threshold: 100
CPU per Elap
per
Executions
Rows Processed Rows
per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- -----------
---------- ----------
E_DEF,RTT_INF,RULE_PLAN_ID,ASSOC_SELL_LIM_ID from
SAW.COND_RULE_
TABLE where RULE_TABLE_ID = :1
154,684
0
0.0
0.00 0.00 2027887798
Module: NeResObjects.exe
select 1 from dual where exists (select 1 from
AM_PACKAGE
_ITEM where AM_PACKAGE_CODE=:b1)
152,488 152,489
1.0
0.00 0.00 1766278233
Module: NeResObjects.exe
select CABIN_ATTR_ID,EFF_SAIL_FROM,EFF_SAIL_TO from
SAW.CABIN_AT
TRIBUTE_LINK where RECORD_ID = :1
150,401 150,403
1.0
0.00
0.00 1543882401
Module: NeResObjects.exe
SELECT RECORD_ID FROM SAW.CABIN_CAT_GEN_LNK_CABIN_CAT WHERE SHI
P_CODE=:1 and CABIN_CATEGORY=:2
-------------------------------------------------------------
SQL ordered by Parse Calls for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Parse Calls Threshold: 1000
% Total
Parse
Calls Executions Parses Hash Value
------------ ------------ -------- ----------
1,406,802 1,406,305 10.43 2421339181
Module: NeResObjects.exe
select td.TEMPLATE_RULE_ID, sl.RECORD_ID ,
sl.count_object_type,
sl.is_sell_stopped, sl.WARNING_LIMIT_ABS ,
sl.WARNING_LIM
IT_WGT
, sl.SELLING_LIMIT_ABS ,
sl.SELLING_LIMIT_WGT , sl.
WAITLIST_LIMIT_ABS , sl.WAITLIST_LIMIT_WGT from SAW.COND_RUL
E_TABLE rt, SAW.COND_RULE_TEMPLATE_DEF td,
SAW.PACKAGE_SELLING_L
1,403,956
1,403,502 10.41
2589586491
Module: NeResObjects.exe
select t.TABLE_PREDICATE_ID, t.EFFECTIVE_FROM,
t.HEADER_STR_ID,
t.STDTYPES, t.ROW_SORT_ORDER, 0 from SAW.COND_TABLE_PREDICATE t
where
t.RULE_TABLE_ID = :1 and t.DEL_DATE is null and t.RULE_S
ESSION_ID is null order by 2
933,501
933,498
6.92 1307778841
select condition from cdef$ where rowid=:1
839,990
839,740
6.23 1169339146
Module: NeResObjects.exe
select t.TABLE_PREDICATE_ROW_ID, t.DATA_STR_ID,
sl.STR_TEXT, sl.
PARENT_ID, t.RULE_ID from SAW.COND_TABLE_PREDICATE_ROW t, SAW.C
OND_STR_LIB sl where TABLE_PREDICATE_ID = :1 and sl.STR_ID=t.D
ATA_STR_ID order by 1
297,988
297,891
2.21 1917022609
Module: NeResObjects.exe
select SAW.VCS_COND_MAINT.getSTR( :1) from dual
247,241
247,238
1.83 2695447312
Module: NeResObjects.exe
SELECT
SAW.VCS_ADDITIONAL_FIELDS.Get_Num_Value('AGENCY','FINAL_P
AYMENT_DUE_DAYS_PRIOR',1) FINAL_PAYMENT_DUE_DAYS_PRIOR
FROM DUAL
153,743
-350,150
1.14 1678244021
Module: NeResObjects.exe
select FD.ROW_TYPE, FD.DOMAIN_CODE, TR.CONSTRAINT_NAME from SE
A.VCS_FIELD_DOMAIN FD, SAW.VCS_ROW_TYPE RT, SAW.VCS_TABLE_REFS
TR
where
TR.TABLENAME_FROM = :1 and
TR.FIELDNAME_FROM = :2 a
nd
(TR.POSITION=(select MAX(T.POSITION) from VCS_TABLE_REFS T
where T.CONSTRAINT_NAME = TR.CONSTRAINT_NAME)) and RT.TABLE_NAM
150,404
150,401
1.12 1543882401
Module: NeResObjects.exe
SELECT RECORD_ID FROM SAW.CABIN_CAT_GEN_LNK_CABIN_CAT WHERE SHI
P_CODE=:1 and CABIN_CATEGORY=:2
149,733
152,488
1.11 1766278233
Module: NeResObjects.exe
select CABIN_ATTR_ID,EFF_SAIL_FROM,EFF_SAIL_TO from
SAW.CABIN_AT
TRIBUTE_LINK where RECORD_ID = :1
145,698
145,697
1.08 2274346585
SQL ordered by Parse Calls for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Parse Calls Threshold: 1000
% Total
Parse
Calls Executions Parses Hash Value
------------ ------------ -------- ----------
Module: NeResObjects.exe
SELECT HOUSEHOLD_ADDR_ID FROM SAW.HOUSEHOLD_ADDRESS WHERE HOUSE
HOLD_ID=:1 and COUNTRY_CODE=:2 and STATE_CODE=:3 and
IS_ADDRESS_
MAILING=:4
126,737
127,267
0.94 1531097321
Module: SwShipInvServer.exe
begin SAW.VCS_LOG_TRX.SETUSER (P_USER => :P_USER);
end;
114,370
114,362
0.85 3465892560
Module: NeBatch.exe
select * from SAW.RES_HEADER where RES_ID = :1
103,236
103,111
0.77 901725682
Module: swMain.exe
select column_name, column_caption, column_order,
is_asc_sort f
rom SAW.GRID_SORT_COLUMN where grid_id = :1
103,236
103,110
0.77 3889478502
Module: swMain.exe
select GROUPBY_ID, GROUPBY_NAME, GROUPBY_DEF from SAW.GRID_GROU
PBY where grid_id = :1
103,235
103,111
0.77 2184344072
Module: swMain.exe
select column_name, column_caption, column_size,
column_order f
rom SAW.GRID_LAYOUT_COLUMN where grid_id = :1
102,275
102,268
0.76 3836413133
Module: NeBatch.exe
select * from SAW.RES_GUEST where RES_ID = :1
98,653 98,647 0.73 76356805
Module: NeBatch.exe
select * from SAW.RES_PACKAGE where RES_ID = :1
94,349 94,351 0.70 1817930319
Module: swMain.exe
select t.TABLE_PREDICATE_ID, t.EFFECTIVE_FROM,
t.HEADER_STR_ID,
t.STDTYPES, t.ROW_SORT_ORDER, t.RULE_SESSION_ID from SAW.COND_
TABLE_PREDICATE t
where t.RULE_TABLE_ID = :1 and t.DEL_DATE is
null and
(t.RULE_SESSION_ID = :2 or t.RULE_SESSION_ID is null a
nd not
exists(select null from SAW.COND_SES_DEL_VIEWS dv where
89,225 89,185 0.66 228056360
Module: NeResObjects.exe
begin :Result := SAW.SW_RES_LOCK.REQUESTTABLE
(P_LOCK_NAME => :P
_LOCK_NAME, P_TABLENAME => :P_TABLENAME, P_TID =>
:P_TID); end;
83,224 83,223 0.62 3037024321
Module: SwSabreNet.exe
SELECT
SAW.VCS_ADDITIONAL_FIELDS.Get_Num_Value('AGENCY','FINAL_P
AYMENT_DUE_DAYS_PRIOR',1481) FINAL_PAYMENT_DUE_DAYS_PRIOR
FROM D
UAL
SQL ordered by Parse Calls for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Parse Calls Threshold: 1000
%
Total
Parse
Calls Executions Parses Hash Value
------------ ------------ -------- ----------
76,892 76,829 0.57 3463286135
Module: NeResObjects.exe
begin :Result := SAW.SW_RES_LOCK.RELEASE (P_LOCK_NAME
=> :P_LOCK
_NAME); end;
76,007 76,007 0.56 1092098374
SELECT
nvl(rtg_req_seq, 0) FROM grp_rte_req, alloc_
grp -- Off_id 02/10/01 WHERE alloc_grp.off_id = :b2
AND alloc_grp.grp_id =
:b1 AND alloc_gr
p.grp_id = grp_rte_req.grp_id AND rtg_req_seq = (SE
LECT max(rtg_req_seq)
FROM grp
73,266 74,899 0.54 2764688397
Module: SwSellLimServer.exe
select distinct tp.rule_table_id from
cond_table_predicat
e tp, cond_predicate_rules
prr
where
tp.t
able_predicate_id=prr.table_predicate_id and prr.rule_t
able_id= :b1
69,559 69,540 0.52 1170918207
Module: NeBatch.exe
select * from SAW.RES_GUEST_PARAM where GUEST_ID = :1
66,182 142,964 0.49 3836341036
Module: swMain.exe
select INVOICE_ITEM_TYPE,AMOUNT from SAW.RES_INVOICE_ITEM
where
RES_INVOICE_ITEM_ID = :1
-------------------------------------------------------------
SQL ordered by Sharable Memory for DB: FELIX Instance: felix Snaps: 49836 -49846
-> End Sharable Memory Threshold: 1048576
Sharable Mem (b)
Executions % Total Hash Value
---------------- ------------ ------- ------------
1,102,757
7
0.1 3326071994
Module: swMain.exe
EXPLAIN PLAN SET STATEMENT_ID='053076960001' INTO VCS_PLAN_TABL
E FOR select
t.Type,
TO_NUMBER(TO_CHAR(t.
PACKAGE_ID)) PACKAGE_ID,
t.ITIN_RECORD_ID ,
T
O_NUMBER(TO_CHAR(t.SEQ_NUM)) SEQ_NUM,
t.PACKAGE_TYPE ,
t.COMPONENT_TYPE ,
t.CAN_BE_EXCLUDED ,
-------------------------------------------------------------
Instance Activity Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
Statistic
Total per
Second per Trans
--------------------------------- ------------------
-------------- ------------
CPU used by this session
983,516
247.1 1.9
CPU used when call started
809,492 203.4 1.6
CR blocks created
231,344
58.1 0.4
Cached Commit SCN referenced
37,978,337 9,542.3
73.0
Commit SCN cached
83
0.0 0.0
DBWR buffers scanned
8,360,801
2,100.7 16.1
DBWR checkpoint buffers written
371,211
93.3 0.7
DBWR checkpoints
23
0.0 0.0
DBWR free buffers found
7,788,492 1,956.9
15.0
DBWR lru scans
49,828
12.5 0.1
DBWR make free requests
102,352
25.7 0.2
DBWR revisited being-written buff
1
0.0 0.0
DBWR summed scan depth
8,360,801
2,100.7 16.1
DBWR transaction table writes
708
0.2 0.0
DBWR undo block writes
276,571
69.5 0.5
SQL*Net roundtrips to/from client
33,340,837 8,377.1
64.1
SQL*Net roundtrips to/from dblink 0
0.0 0.0
active txn count during cleanout
506,422 127.2 1.0
background checkpoints completed
23
0.0 0.0
background checkpoints started
23
0.0 0.0
background timeouts
8,695
2.2 0.0
branch node splits
43
0.0 0.0
buffer is not pinned count
471,159,852 118,381.9
905.6
buffer is pinned count
1,149,917,901 288,924.1 2,210.3
bytes received via SQL*Net from c
5,126,310,109
1,288,017.6 9,853.4
bytes received via SQL*Net from d
0
0.0 0.0
bytes sent via SQL*Net to client
11,179,017,426
2,808,798.4
21,487.5
bytes sent via SQL*Net to dblink
0
0.0 0.0
calls to get snapshot scn: kcmgss
37,363,070 9,387.7 71.8
calls to kcmgas
1,610,666 404.7 3.1
calls to kcmgcs
140,805
35.4 0.3
change write time
12,575
3.2 0.0
cleanout - number of ktugct calls
349,270 87.8 0.7
cluster key scan block gets
1,189,361 298.8 2.3
cluster key scans
395,788
99.4 0.8
commit cleanout failures: block l
55,288 13.9 0.1
commit cleanout failures: buffer
107
0.0 0.0
commit cleanout failures: callbac
17,423
4.4 0.0
commit cleanout failures: cannot
5,127
1.3 0.0
commit cleanouts
3,792,068 952.8 7.3
commit cleanouts successfully com
3,714,124 933.2 7.1
commit txn count during cleanout
224,158 56.3 0.4
consistent changes
4,805,394
1,207.4 9.2
consistent gets
636,997,755
160,049.7
1,224.4
consistent gets - examination
197,393,136 49,596.3
379.4
current blocks converted for CR
518
0.1 0.0
cursor authentications
26,365
6.6 0.1
data blocks consistent reads - un
787,117 197.8 1.5
db block changes
51,765,364
13,006.4 99.5
db block gets
65,104,574 16,357.9
125.1
deferred (CURRENT) block cleanout
499,031 125.4 1.0
dirty buffers inspected
96,442
24.2 0.2
enqueue conversions
175,389
44.1 0.3
enqueue deadlocks
0
0.0 0.0
enqueue releases
20,950,603
5,264.0 40.3
enqueue requests
20,951,393
5,264.2 40.3
Instance Activity Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
Statistic
Total per
Second per Trans
--------------------------------- ------------------
-------------- ------------
enqueue timeouts
991
0.3 0.0
enqueue waits 6,249
1.6 0.0
exchange deadlocks
168
0.0 0.0
execute count
29,534,735 7,420.8
56.8
free buffer inspected
104,327
26.2 0.2
free buffer requested
18,303,223
4,598.8 35.2
hot buffers moved to head of LRU
5,930,183 1,490.0
11.4
immediate (CR) block cleanout app 221,397
55.6
0.4
immediate (CURRENT) block cleanou
630,302 158.4 1.2
index fast full scans (full)
6,422
1.6 0.0
index fetch by key
67,772,236
17,028.2 130.3
index scans kdiixs1
60,537,007
15,210.3 116.4
leaf node 90-10 splits
2,996
0.8 0.0
leaf node splits
14,258 3.6 0.0
logons cumulative
57,974
14.6 0.1
messages received
313,567
78.8 0.6
messages sent
313,568
78.8 0.6
no buffer to keep pinned count
0
0.0 0.0
no work - consistent read gets
381,368,108 95,821.1
733.0
opened cursors cumulative
13,293,858 3,340.2 25.6
parse count (failures)
131
0.0 0.0
parse count (hard)
93,612
23.5 0.2
parse count (total)
13,484,553
3,388.1 25.9
parse time cpu
36,135
9.1 0.1
parse time elapsed
120,767
30.3 0.2
physical reads
17,332,269 4,354.8
33.3
physical reads direct
39,456
9.9 0.1
physical reads direct (lob)
11,967
3.0 0.0
physical writes
1,102,963 277.1 2.1
physical writes direct
49,179
12.4 0.1
physical writes direct (lob)
15,091
3.8 0.0
physical writes non checkpoint
971,682 244.1 1.9
pinned buffers inspected 6,444
1.6 0.0
prefetched blocks
9,557,534
2,401.4 18.4
prefetched blocks aged out before
761
0.2 0.0
process last non-idle time ##################
############## ############
recursive calls
66,754,237 16,772.4
128.3
recursive cpu usage
390,462
98.1 0.8
redo blocks written
11,564,145 2,905.6
22.2
redo buffer allocation retries
673
0.2 0.0
redo entries
26,286,866 6,604.7
50.5
redo log space requests
792
0.2 0.0
redo log space wait time
6,490
1.6 0.0
redo ordering marks
3
0.0 0.0
redo size
5,686,642,184
1,428,804.6
10,930.5
redo synch time
2,652,297 666.4 5.1
redo synch writes
526,398 132.3 1.0
redo wastage
46,843,108 11,769.6
90.0
redo write time
383,216
96.3 0.7
redo writer latching time
64
0.0 0.0
redo writes
183,110
46.0 0.4
rollback changes - undo records a
7,632,718 1,917.8
14.7
rows fetched via callback
38,482,150 9,668.9
74.0
session connect time
################## ############## ############
session logical reads
702,090,038 176,404.5 1,349.5
session pga memory
667,756,832
167,778.1
1,283.5
Instance Activity Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
Statistic
Total per Second per Trans
--------------------------------- ------------------
-------------- ------------
session pga memory max
2,970,031,088 746,239.0 5,708.8
session uga memory
310,336,172,768
77,973,912.8
596,506.7
session uga memory max
16,076,672,648
4,039,365.0
30,901.5
shared hash latch upgrades - no w
53,392,971 13,415.3
102.6
shared hash latch upgrades - wait
1,697,533 426.5 3.3
sorts (disk)
0
0.0 0.0
sorts (memory)
5,126,951 1,288.2 9.9
sorts (rows)
427,179,575 107,331.6 821.1
summed dirty queue length
681,392 171.2 1.3
switch current to new buffer
445,244 111.9 0.9
table fetch by rowid
727,011,526 182,666.2 1,397.4
table fetch continued row
2,381,136 598.3 4.6
table scan blocks gotten
61,127,680 15,358.7
117.5
table scan rows gotten
3,843,792,038 965,776.9 7,388.3
table scans (long tables)
2,456
0.6 0.0
table scans (short tables)
3,779,800 949.7 7.3
transaction rollbacks
42,865
10.8 0.1
transaction tables consistent rea
368
0.1 0.0
transaction tables consistent rea
1,874,405 471.0 3.6
user calls
44,081,549 11,075.8
84.7
user commits
508,788 127.8 1.0
user rollbacks
11,468
2.9 0.0
workarea executions - onepass
4
0.0 0.0
workarea executions - optimal 6,327,189
1,589.8
12.2
write clones created in backgroun
5
0.0 0.0
write clones created in foregroun
2,230
0.6 0.0
-------------------------------------------------------------
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
UNDOTBS1
266,182 67 9.4 1.0 277,328 70 14,283 7.2
RESHEADER
495,815 125 7.2 1.8
1,741 0 28,474 7.5
CLIENT
433,718 109 13.0 7.8 1,513
0
60,198 17.1
AWPSGRTRAN
367,515 92 10.1 1.0 166
0 140,961 9.5
RESHISTTREEX01
325,349 82 7.9 1.0 388
0
0 0.0
ACCTRANDTL
288,904 73 16.2 1.0 1,439
0
11 15.5
AWTBSMALL02
269,667 68 10.9 4.2 6,810
2 212,516 9.6
IXMEDIUM08
194,723 49 11.3 1.0 7,104
2
27,119 12.1
TBSMALL02
127,931 32 10.2 2.5 68,749 17
441 3.2
IXMEDIUM05
162,391 41 10.7 1.0 6,667 2 27,010 9.9
RESGUEST
167,377 42 8.8 1.2 676
0
33,987 12.6
TBSMALL03
147,255 37 10.9 3.1 11,830
3
323 6.7
CONDRULETB
155,807 39 13.2 1.0 429
0
390 15.6
VCSLOGREC
145,096 36 15.3 13.7 1,804
0
1 0.0
CONDSTRLIB
145,364 37 12.2 1.0
51 0
915 13.1
TBMEDIUM02
140,409 35 9.3 1.6
4,372 1 73,311 8.5
AWPSGRHST
138,832 35 14.5 1.0 139
0
85,983 16.6
IXSMALL06
97,032 24 11.4 1.0 39,952 10
324 3.6
IXMEDIUM02
125,883 32 15.4 9.0 5,077
1
226 14.0
RESGUESTX01
130,814 33 8.8 1.0 105
0
742 9.2
IXMEDIUM04
111,723 28 12.6 1.0 9,397 2 715 9.5
RESPACKAGE
118,574 30 10.1 1.0 519
0
164 12.7
IXSMALL08
99,831 25 10.1 1.0 17,977
5
882 8.5
TBMEDIUM03
107,157 27 8.5 2.1
9,071 2 2,635 6.3
IXSMALL02
92,366 23 10.8 1.0 22,342
6
14 5.0
CONDPREDROWXF2
112,499 28 12.3 1.0
41 0
399 13.3
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
RESSHIPREQ
111,602 28 10.6 1.0 689
0
33 15.5
IXTINY03
67,354 17 11.9 1.0 40,438 10 3,521 0.3
FAXQUEUE
103,921 26 14.4 1.0 653
0
14 0.0
AWIXMEDIUM03
99,384 25 13.0 1.0 1,394
0
62,805 13.8
IXSMALL05
78,916 20 11.6 1.1 21,511
5
380 5.9
CONDPREDROW
99,377 25 12.8 1.0
60 0
367 15.9
TBSMALL01
77,742 20 11.2 6.2 21,251
5
1,977 11.4
AWIXSMALL02
91,463 23 10.7 1.0 7,285
2 111,689 7.5
IXMEDIUM03
86,974 22 13.6 1.0 10,911
3
202 8.8
AWIXSMALL03
87,855 22 12.5 1.0 8,882
2
25,776 8.5
IXMEDIUM07
79,728 20 12.0 1.0 13,825
3
2 20.0
IXSMALL07
60,846 15 13.3 1.0 23,286
6
249 1.4
RESINVITEMX09
44,234 11 16.4 1.0 37,286
9
105 14.0
IXMEDIUM01
61,245 15 11.8 1.0 17,496
4
198 14.6
VCSLOGRECX04
72,813 18 2.4 1.0
3,917 1 3 0.0
IXMEDIUM06
64,670 16 14.4 1.0 11,150
3
147 14.1
VCSLOGRECX01
68,516 17 9.7 1.0 865 0 7 0.0
TBSMALL04
62,304 16 9.7 1.6
3,877 1 7,434 10.0
CONDTABPRED
66,001 17 11.6 1.0
85 0
288 14.8
IXSMALL04
53,732 14 12.4 1.0 12,216
3
224 3.5
IXSMALL03
44,155 11 11.6 2.7 19,920
5
19 3.7
LOB01
33,124 8 7.9 1.0
25,390 6
58 0.9
RESINVITEMX10
28,618 7 15.7 1.0 27,059 7
107 14.9
IXSMALL01
37,374 9 12.7 1.0 17,721 4 1,431 7.8
RESPARAMX02
51,583 13 16.6 1.0 802
0
121 12.4
SYSTEM
44,213 11 10.4 3.1 6,659
2
580 12.4
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
AWTBMEDIUM02
50,271 13 17.9 9.6 400
0
55 12.5
PERFSTAT
42,354 11 15.7 1.1 2,007
1
0 0.0
TBTINY01
36,354 9 8.0 2.4
5,672 1
541 3.1
RESINVITEM
34,179 9 17.2 1.0 5,845 1
22 9.5
TBMEDIUM04
34,209 9 13.5 2.3 2,127 1
19 6.8
RESINVITEMX01
19,811 5 16.5 1.0 16,277 4
37 10.3
RESPARAM
32,314 8 16.7 1.0 905 0
121 16.0
HOUSEHLDADR
32,334 8 8.7 1.0 344 0 0 0.0
RESHISTVALX01
30,614 8 15.9 1.0 1,118 0
269 16.6
TBMEDIUM01
26,781 7 11.8 1.0 3,890 1
133 9.2
RESINVITEMXF3
27,168 7 17.0 1.0 2,009
1 17 11.8
PACKSELLUSAG
19,055 5 15.4 1.0 9,694 2
34 5.3
VCSLOGFLDX02
10,482 3 9.3 1.0
17,531 4
47 9.1
AWTBTINY02
17,966 5 7.4 1.8
3,942 1
262 8.1
RESHISTTRN
20,338 5 16.0 1.0 1,326 0
113 11.0
RESPROMO
19,402 5 16.0 1.0 2,219 1
178 14.4
ABCTBSMALL01
20,286 5 14.3
19.1 1,016
0 422 5.7
AWPSGRTRANX03
19,156 5 12.1 1.0 287 0 4,124 6.0
RESINVITEMX06
11,131 3 17.0 1.0 8,064 2 0 0.0
RESGPARAM
17,788 4 17.6 1.0 761 0
74 18.2
AWIXTINY02
11,621 3 10.0 1.0 6,273 2
72 10.1
ACCTRANDTLX02
16,783 4 15.7 1.0 678 0 18 6.7
RESINVITEMX07
9,423 2 17.2 1.0 7,670 2 0 0.0
AWPSGRITIN
16,619 4 16.4 4.2 229 0 5 2.0
RESEVENT
16,224 4 15.4 7.9 463 0 0 0.0
RESGPARAMXF2
16,315 4 17.1 1.0 265 0
81 14.4
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
RESCOMPO
13,648 3 16.9 1.0 2,712 1
20 18.0
RESCOMMDTL
13,150 3 16.1 1.0 2,312 1
22 13.2
ACCTRANDTLX04
14,695 4 15.5 1.0 713 0
12 5.0
RESHISTVAL
13,486 3 17.8 1.0 1,393 0
84 19.5
GLTRANS
14,200 4 6.4 1.0 518 0 0 0.0
RESINVITEMXF1
11,039 3 16.5 1.0 2,211 1 0 0.0
RESCOMPOCOS
10,843 3 15.2 1.0 1,796 0 0 0.0
ACCTRANDTLX05
12,064 3 16.4 1.0 440 0 1 10.0
RESPARAMX01
6,651 2 14.1
1.0 5,121
1
0 0.0
RESCOMPOX03
9,988 3 17.0 1.0 1,522 0
13 13.8
VCSLOGRECX02
6,123 2 16.6 1.0 4,542 1 3 6.7
RESINVITEMXF4
5,235 1 15.7 1.0 4,833 1 1 20.0
AWITINERR
8,478 2 17.9 1.0
84 0 0 0.0
TEMP
3,782 1 188.4 3.1 4,771 1 0 0.0
RESINVITEMXPK
6,175 2 16.3 1.0 2,294 1
14 0.0
AWPSGRITINS
8,069 2 16.9 1.0 242 0 0 0.0
HOUSEHLDPHN
7,777 2 17.2 1.0 266 0 0 0.0
RESGPARAMXF1
3,969 1 12.4 1.0 3,902 1 2 5.0
PACKSELLXPK
7,043 2 14.5 1.0 543 0
221 0.1
RESHISTVALX02
4,439 1
19.8
1.0
2,960 1 2 45.0
AWPSGRITINSX01
7,145 2 17.2 1.0 161 0 0 0.0
RESINVITEMX05
4,588 1 17.7 1.0 2,694 1 2 0.0
RESHISTTRNX01
4,610 1 16.5 1.0 2,665 1 2 5.0
RESPARAMXF1
3,556 1 10.9 1.0 3,694 1 0 0.0
RESINVITEMX08
4,758 1 18.3 1.0 2,473 1 0 0.0
AWPSGRITINSX03
7,054 2 17.3 1.0 147 0 0 0.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
RESPARAMXPK
6,776 2 15.4 1.0 309 0 0 0.0
RESINVITEMX03
4,441 1 17.7 1.0 2,580 1 0 0.0
RESINVITEMX02
4,370 1 18.1 1.0 2,648 1 1 0.0
RESCOMPOXF2
3,509 1 17.4 1.0 3,132 1 1 10.0
AWIXMEDIUM02
5,326 1 17.2 1.0 1,211 0
28 0.0
GRPINVHIS
6,283 2 15.0 1.0 214
0 0 0.0
ENTITYLINKIOT
6,110 2 15.1 1.0 314 0 0 0.0
RESINVITEMX04
3,682 1 18.0 1.0 2,690 1 0 0.0
RESCOMPOXF3
3,295 1 17.4 1.0 2,939 1 1 0.0
VCSLOGFLD
2,608 1 25.1 1.0 3,456 1
26 8.8
RESINVITEMXF2
3,501 1 17.7 1.0 2,408 1 3 0.0
GTBINFOERRSX01
3,526 1 16.4 1.0 2,279 1 0 0.0
GRPINVITEM
4,244 1 14.7 1.0 1,547 0 2 5.0
VCSLOGRECX03
3,251 1 16.3 1.0 2,480 1 0 0.0
RESCOMPOX02
3,433 1 17.5 1.0 2,217 1 0 0.0
ACCTRANDTLX06
4,780 1 17.1 1.0 486 0
42 10.5
ABCCCHISTX01
3,448 1 20.3 1.0 1,781 0 0 0.0
RESCOMPOX01
3,431 1 17.9 1.0 1,755 0 1 0.0
CONDTABPREDUQ
5,057 1 17.1 1.0
81 0 0 0.0
ACCTRANDTLX01
4,038 1 14.1 1.0 910 0 0 0.0
RESPROMOXPK
3,529 1 16.7 1.0 1,381 0 0 0.0
AWITINERRX01
4,355 1 17.5 1.0
82 0 0 0.0
RESHISTTREE
3,844 1 16.2 1.0 572 0 5 18.0
RESCOMPOXF1
2,371 1 17.0 1.0 1,664 0 2 15.0
TBSMALLONG01
3,733 1 11.5 1.0
13 0 0 0.0
RESPACKAGEX01
3,567 1 16.4 1.0 139 0 2 10.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
RESHISTTREEXPK
3,604 1 16.1 1.0
69 0 7 17.1
ABCCCHIST
1,097 0 30.1 1.0 2,518 1 3 6.7
CLIENTPRGRM
3,475 1 17.6 1.0
75 0 0 0.0
RESCOMPOXPK
1,812 0 17.8 1.0 1,693 0 2 0.0
VCSLGFLDX01
1,523 0 24.1 1.0 1,705 0
63 0.0
RESGPARAMX01
2,846 1 18.1 1.0 373 0 5 18.0
ABCTBSMALL02
2,868 1 10.7 14.5
13 0 0 0.0
RESINVCANCX04
2,695 1 16.8 1.0 132 0 0 0.0
ABCIXSMALL04
1,556 0 13.4 1.0 1,160 0 2 0.0
ACCTRANHIS
1,941 0 20.6 1.0 736 0 0 0.0
RESCOMMDTLXPK
1,249 0 18.3 1.0 1,216 0 0 0.0
ABCIXTINY02
2,187 1 14.1 1.0 258 0 0 0.0
GTBREQUEST
2,204 1 18.4 1.0 217 0 0 0.0
CLIENTX02
1,380 0 20.1 1.0 776 0 0 0.0
AWPSGRTRANX06
1,765 0 12.4 1.0 379 0 0 0.0
ABCTBTINY01
1,830 0 14.7 1.5 176 0 0 0.0
CLIENTX04
1,684 0 17.5 1.0 165 0 0 0.0
CLIENTX06
1,180 0 16.9 1.0 622 0 0 0.0
AWCRSTRANS
1,003 0 30.2 1.0 732 0 0 0.0
TOOLS
977
0 12.6 1.1 689
0 4 0.0
IMAGESTORE
1,582 0 12.3 1.4
39 0 0 0.0
ACCTRANHISX03
1,102 0 18.0 1.0 513 0 0 0.0
ABCDWTRGLOG
808
0 16.1 1.0 803 0 0 0.0
ABCCCSHPLOG
743
0 28.1 1.0 841 0 0 0.0
AWPSGRTRANX07
969
0 21.6 1.0 572 0 0 0.0
ABCIXSMALL03
1,383 0 13.9
1.0
28 0
0 0.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ACCTRANDTLX03
827
0 18.0 1.0 476 0 0 0.0
AWPSGRTRANX04
1,058 0 19.7 1.0 240 0 0 0.0
GRPINVHISFK
1,015 0 17.8 1.0 222 0 0 0.0
ABCGRINVITH
616
0 18.8 1.0 613 0 2 5.0
ABCIXMEDIUM04
494
0 20.9 1.0 703 0 1 0.0
GLTRANSX02
788
0 24.8 1.0 397 0 0 0.0
CONDPREDRULX01
1,077 0 19.6 1.0 100 0
12 8.3
HOUSEHOLD
716
0 19.8 1.2 446 0 0 0.0
GLTRANSX03
1,089 0 19.7 1.0
27 0 0 0.0
ABCIXSMALL02
605
0 20.9 1.0 511 0 0 0.0
ACCTRANHISX01
562
0 22.5 1.0 544 0 0 0.0
CONDSTRLIBX01
878
0 18.7 1.0 211 0 0 0.0
RESINVCANCX01
591
0 19.8 1.0 462 0 0 0.0
CONDPREDROWXF1
614
0 19.8 1.0 372 0 0 0.0
ABCIXSMALL05
801
0 16.4 1.0 163 0 0 0.0
ACCTRANHISX02
423
0 21.5 1.0 528 0 0 0.0
ABCDWTRGLOGX01
533
0 23.2 1.0 400 0 4 0.0
GTBINFOERRSX02
567
0 25.0 1.0 296 0 0 0.0
ACCTRANHISX04
490
0 21.8 1.0 364 0 0 0.0
VCSLOGRECXPK
465
0 33.5 1.0 383 0 3 0.0
RESGPARAMXPK
626
0 19.1 1.0 201 0 0 0.0
ACCTRANDTLX07
567
0 21.0 1.0 203 0 0 0.0
AWTKT
521
0 19.9 1.0 204 0 0 0.0
GTBINFOERRS
411
0 37.7 1.0 289 0 0 0.0
AWFLIAVAINVXPK
433
0 35.8 1.0 250 0
128 0.4
GTBINFOERRSXPK
408
0 26.7 1.0 252 0 1 0.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
AWFLIAVAINVX01
391
0 38.4 1.0 247 0
71 11.3
AWPSGRRTHSTX01
413
0 25.2 1.0 213 0 0 0.0
AWPSGRTRANX05
340
0 23.6 1.0 278 0 0 0.0
GLTRANSX01
393 0 26.1 1.0 208 0 0 0.0
ABCLOB02
468
0 65.3 1.0 117 0 0 0.0
ABCCCHISTX02
289
0 25.7 1.0 285 0 0 0.0
HOUSEHLDADRX01
307
0 25.2 1.0 262 0 0 0.0
RESINVCANCX02
402
0 22.1 1.0 155 0 0 0.0
RESINVCANC
373
0 30.4 1.0 174 0 0 0.0
GLTRANSX05
316
0 28.0 1.0 217 0 0 0.0
JOBSERRLOG
347
0 43.1 1.0 185 0 0 0.0
AWPSGRVYHST
393
0 20.8 1.0 134 0 0 0.0
AWPSGRRTHST
382
0 27.4 1.0 124 0 0 0.0
ABCCCSHPLOGX01
272
0 27.4 1.0 231 0 0 0.0
JOBSERRLOGX01
295 0 35.2 1.0 184
0
0 0.0
ABCIXTINY01
258
0 24.3 1.0 221 0 0 0.0
GLTRANSX09
265
0 29.1 1.0 196 0 0 0.0
CLIENTX01
267
0 24.0 1.0 192 0 0 0.0
GTBDOCHISTX01
307
0 24.2 1.0 152 0 0 0.0
CONDRULETBXF1
288
0 26.7 1.0 151 0 0 0.0
ABCTRVLOBP6
342
0 49.9 1.0
79 0 0 0.0
ABCTRVLOBP4
331
0 47.0 1.0
80 0 0 0.0
ABCTRVLOBP1
331
0 52.5 1.0
79 0 0 0.0
ABCTRVLOBP2
331
0 46.7 1.0
79 0 0 0.0
ABCTRVLOBP8
331
0 51.9 1.0
79 0 0 0.0
ABCTRVLOBP3
329 0 45.9 1.0
79 0 0 0.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ABCTRVLOBP5
329
0 47.1 1.0 79
0 0 0.0
ABCTRVLOBP7
329
0 46.0 1.0
79 0 0 0.0
RESINVCANCX03
263
0 22.9 1.0 135 0 0 0.0
GLTRANSX07
205
0 23.1 1.0 191 0 0 0.0
GLTRANSX06
224
0 34.3 1.0 171 0 0 0.0
ABCTBMEDIUM01
287
0 18.9 1.0 104 0 0 0.0
JOBSERRLOGX02
230
0 28.8 1.0 154 0 0 0.0
AWPSGRITINSXPK
333
0 30.1 1.0
45 0 0 0.0
GTBDOCQUEUE
241
0 29.5 1.0 137 0 0 0.0
GLTRANSX04
206
0 33.7 1.0 162 0 0 0.0
CONDPREDRULXPK
329
0 23.2 1.0
35 0 0 0.0
JOBSERRLOGXPK
197
0 32.1 1.0 145 0 0 0.0
AWITINFARE
248
0 31.7 1.0
88 0 0 0.0
CLIENTX03
195
0 27.7 1.0 138 0 0 0.0
GTBREQHIST
123
0 20.2 1.0 208 0 0 0.0
ABCGRPINVIH
262
0 69.4 1.0
66 0 0 0.0
AWITINERRX02
237
0 29.0 1.0
72 0 0 0.0
RESINVCANCXF1
184 0 23.9
1.0 116
0
0 0.0
RESARCLNKXF1
269
0 28.9 1.0
26 0 0 0.0
ABCDRSGRPHS
203
0 45.6 1.0
81 0 0 0.0
AWPSGRITINSX02
182
0 37.8 1.0
97 0 0 0.0
CONDTABPREDX02
177
0 31.1 1.0
98 0 0 0.0
CONDRULETBX02
164
0 30.1 1.0 105
0 0 0.0
CONDTABPREDX01
164
0 28.9 1.0 103 0 0 0.0
AWFLGTHST
214
0 36.0 1.0
51 0 0 0.0
CONDRULETBX01
205
0 31.1 1.0
59 0 0 0.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
GTBDOCHIST
168
0 25.4 1.0
93 0 0 0.0
ABCHISTPAYM
208
0 53.6 1.0
52 0 0 0.0
UNDOTBS2
207
0 61.6 1.0
53 0 0 0.0
AWITINERRX03
168
0 29.7 1.0
84 0
0 0.0
ACCFPRSUBD
111
0 33.1 1.0 139 0 0 0.0
RESHISTTRNX02
161
0 30.7 1.0
87 0 0 0.0
AWFLGTHSTXPK
164
0 40.8 1.0
78 0 0 0.0
RESHISTTRNXPK
155
0 29.5 1.0
76 0 0 0.0
AWFLGTHSTX01
157
0 38.3 1.0
68 0 0 0.0
CLIENTSPDAT
204
0 26.6 1.0
14 0 0 0.0
ABCCCHISTXPK
130
0 36.2 1.0
72 0 0 0.0
ACCTRANHISXPK
126
0 38.7 1.0
75 0 7 0.0
CLIENTPRGRMX01
142
0 27.7 1.0
58 0 0 0.0
ABCGRPINVIHX01
160
0 65.6 1.0
40 0 0 0.0
ABCDWBRULES
156
0 61.6 1.0
39 0 0 0.0
ABCVCSLGFLD
156
0 61.0 1.0
39 0 0 0.0
ABCVCSLGFLDX01
156
0 61.5 1.0
39 0 0 0.0
ACCREFCHECKL
91
0 25.6 1.0 101 0 0 0.0
RESARCLNK
159
0 28.4 1.0
23 0 0 0.0
AWLOB01
166
0 51.2 1.7
13 0 0 0.0
AWPSGRTRANX01
113
0 36.2 1.0
65 0 0 0.0
RESINVCANCXPK
102
0 29.9 1.0
75 0 0 0.0
ABCDRSGRPHSX01
118
0 46.7 1.0
56 0 0 0.0
ABCGRPINVIHX02
132
0 72.4 1.0
40 0 0 0.0
ACCFPRSUBDX01
110
0 34.5 1.0
57 0 0 0.0
RESHISTTREEX02
98
0 38.6 1.0
68 0 0 0.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
CONDRULETBXF2
111
0 38.9 1.0
51 0 0 0.0
INSUREXCHLOG
117
0 20.6 1.0
39 0 0 0.0
ABCCCSHPLOGX02
110
0 36.5 1.0
46 0 0 0.0
CONDPREDROWXN1
109
0 53.9 1.0
46 0 0 0.0
RESARCHIVE
136
0 36.5 1.9
15 0 0 0.0
AWPSGRTRANXPK
77
0 43.0 1.0
73 0 1 0.0
ABCDRSEDLOG
84 0 43.3
1.0
59 0
0 0.0
ABCECOMMTMP
117
0 79.4 1.0
26 0 0 0.0
GLTRANSXPK
81
0 57.5 1.0
60 0 0 0.0
AWJOBLOG
70
0 46.1 1.0
70 0 0 0.0
GRPROHSTXPK
74
0 48.9 1.0
65 0 0 0.0
SELLIMRPSQL
93
0 51.5 1.0
45 0 0 0.0
GLTRANSX08
108
0 51.4 1.0
27 0 0 0.0
GRPINVHISTXPK
82
0 46.0 1.0
53 0 0 0.0
ABCTBTINY02
121
0 40.2 2.3
13 0 0 0.0
CONDPREDROWXPK
88
0 55.2 1.0
44 0 0 0.0
ABCTRVLOGP4
105
0 36.5 1.0
26 0 0 0.0
SAWWARE2
105
0 47.0 1.0 26
0 0 0.0
GTBDOCQUEUEX01
92
0 41.6 1.0
32 0 0 0.0
ABCHISTPAYMX01
91
0 60.7 1.0
26 0 0 0.0
ACCFPRSUBDX02
72
0 48.3 1.0
42 0 0 0.0
ACCFPRSUBDXPK
71
0 42.7 1.0
41 0 0 0.0
AWPSGRTRANX02
68
0 45.9 1.0
43 0 0 0.0
AWSYSERR
85
0 43.6 1.0
23 0 5 14.0
ABCDRSGRPHSX04
77
0 44.0 1.0
29 0 0 0.0
RESARCLNKXPK
78
0 61.8 1.0
25 0 0 0.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
CLIENTX05
79
0 16.3 1.0
22 0 0 0.0
SELLIMRPSQLXPK
81
0 59.4 1.0
20 0 0 0.0
ABCDRSGRPHSXPK
74
0 58.9 1.0
25 0 0 0.0
AWRTGSTAT
69
0 50.7 1.0 26
0 0 0.0
ABCIXMEDIUM03
71
0 70.4 1.0
15 0 0 0.0
RESARCHIVEXN1
71
0 73.1 1.0
15 0 0 0.0
ABCDRSGRPHSX03
61
0 69.7 1.0
19 0 0 0.0
ABCIXMEDIUM02
52
0 78.5 1.0
28 0 0 0.0
AWTRACE
65
0 73.4 1.0
13 0 0 0.0
AWTRACEX01
65
0 73.4 1.0
13 0 0 0.0
AWTRACEXPK
65
0 73.4 1.0
13 0 0 0.0
LARGEWORK
65
0 70.6 1.0
13 0 0 0.0
ABCCCSETHIS
65
0 78.0 1.0
13 0 0 0.0
ABCDRSPRLOG
62
0 54.7 1.0
16 0 0 0.0
ABCFAXQUEUE
65
0 51.7 1.0
13 0 0 0.0
ABCMFREFUNDX01
65
0 73.4 1.0
13 0 0 0.0
ABCAIRWARE
63
0 62.9 1.0
14 0 0 0.0
ABCCLIENTWK
63
0 63.0 1.0
14 0 0 0.0
RESARCHIVEXN2
58
0 72.2 1.0
15 0 0 0.0
AWTBSMALLONG01
56
0 54.3 1.0
15 0 0 0.0
ABCDRSPRHIS
56 0 46.1
1.0
14 0
0 0.0
ABCRULTREXT
56
0 45.9 1.0
14 0 0 0.0
ABCSPMSERRL
55
0 29.1 1.0
13 0 0 0.0
ABCSPMSFLGT
55
0 29.1 1.0
13 0 0 0.0
OSMDATA
55
0 29.1 1.0
13 0 0 0.0
ABCDELPHERR
52
0 61.3 1.0
14 0 0 0.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ABCDWSMALL01
53
0 69.2 1.0
13 0 0 0.0
ABCFAX
52
0 61.5 1.0
14 0 0 0.0
AIRWARE
52
0 85.4 1.0
13 0 0 0.0
AWIXMEDIUM01
52
0 85.4 1.0
13 0 0 0.0
AWIXSMALL01
52
0 85.4 1.0
13 0 0 0.0
AWTBSMALL01
52
0 56.9 1.0
13 0 0 0.0
GRPOLDHSDTL
52
0 60.6 1.0
13 0 0 0.0
GTBPRINTBC
52
0 60.6 1.0
13 0 0 0.0
GTBREQTKIM
52
0 60.8 1.0
13 0 0 0.0
IXMEDIUM09
52
0 60.8 1.0
13 0 0 0.0
IXSMALL09
52
0 69.6 1.0
13 0 0 0.0
ABCAIRARCHIVE
52
0 60.2 1.0
13 0 0 0.0
ABCAPISPUPL
52 0 81.2 1.0
13 0 0 0.0
ABCAPISUPL
52
0 81.3 1.0
13 0 0 0.0
ABCCLEARERR
51
0 63.3 1.0
14 0 0 0.0
ABCCLIENTAU
52
0 81.3 1.0
13 0 0 0.0
ABCCLTYPREO
51
0 62.7 1.0
14 0 0 0.0
ABCCMTCRDRESA
51
0 62.7 1.0
14 0 0 0.0
ABCCRSTRNDT
52
0 79.2 1.0
13 0 0 0.0
ABCCRSTRNDTX01
52
0 79.0 1.0
13 0 0 0.0
ABCCRSTRNDTXPK
52
0 79.0 1.0
13 0 0 0.0
ABCCRSTRNHD
52
0 79.4 1.0
13 0 0 0.0
ABCCRSTRNHDX01
52
0 79.4 1.0
13 0 0 0.0
ABCCRSTRNHDX02
52 0 79.4 1.0
13 0 0 0.0
ABCCRSTRNHDXPK
52
0 79.2 1.0
13 0 0 0.0
ABCDRSGRPHSARC
52
0 57.1 1.0
13 0 0 0.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ABCDWBRULESX01
52
0 70.2 1.0
13 0 0 0.0
ABCDWBRULESX03
52
0 70.0 1.0
13 0 0 0.0
ABCDWIXMEDIUM1
52
0 85.4 1.0
13 0 0 0.0
ABCDWPRICNG
52
0 70.2 1.0
13 0 0 0.0
ABCFIDELIOSHIP
52
0 60.8 1.0
13 0 0 0.0
ABCFIPSDETL
52
0 70.2 1.0
13 0 0 0.0
ABCFIPSDETLXPK
52
0 70.2 1.0
13 0 0 0.0
ABCGRPINVIHXPK
52
0 81.2 1.0
13 0 0 0.0
ABCIXMEDIUM01
52
0 70.2 1.0
13 0 0 0.0
ABCIXSMALL01
52
0 70.2 1.0
13 0 0 0.0
ABCMFCCHIST
52
0 79.0 1.0
13 0 0 0.0
ABCMFCCHISTX01
52
0 79.0 1.0
13 0 0 0.0
ABCMFCCHISTX02
52
0 78.8 1.0
13 0 0 0.0
ABCMFCCHISTX03
52
0 78.8 1.0
13 0 0 0.0
ABCMFCCHISTXPK
52
0 78.8 1.0
13 0 0 0.0
ABCMFREFUND
52
0 85.2 1.0
13 0 0 0.0
ABCSPMSEPO
52
0 57.1 1.0
13 0 0 0.0
ABCSPMSGUES
52
0 78.1 1.0
13 0 0 0.0
ABCTBMEDIUM02
52
0 52.5 1.0
13 0 0 0.0
ABCTBMEDIUM03
52
0 52.3 1.0
13 0 0 0.0
ABCTRVLOGP1
52
0 57.1 1.0 13
0 0 0.0
ABCTRVLOGP2
52
0 57.1 1.0
13 0 0 0.0
ABCTRVLOGP3
52
0 57.1 1.0
13 0 0 0.0
ABCTRVLOGP5
52
0 57.1 1.0
13 0 0 0.0
ABCTRVLOGP6
52
0 57.1 1.0
13 0 0 0.0
ABCTRVLOGP7
52
0 57.1 1.0
13 0 0 0.0
Tablespace IO Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ABCTRVLOGP8
52
0 57.1 1.0
13 0 0 0.0
ABCVCSLGREC
52 0 79.4 1.0
13 0
0 0.0
ABCVCSLGRECX01
52
0 79.4 1.0
13 0 0 0.0
ABCVCSLGRECX02
52
0 78.8 1.0
13 0 0 0.0
ABCVCSLGRECX03
52
0 78.8 1.0
13 0 0 0.0
ABCVCSLGRECX04
52
0 52.5 1.0
13 0 0 0.0
ABCVCSLGRECXPK
52
0 52.5 1.0
13
0 0 0.0
ABCWORK
52
0 56.0 1.0
13 0 0 0.0
PREVSTATS
52
0 78.8 1.0
13 0 0 0.0
SAWWEBIDX
52
0 78.5 1.0
13 0 0 0.0
SAWWEBTBL
52
0 78.7 1.0
13 0 0 0.0
TBSMALL05
52
0 79.0 1.0
13 0 0 0.0
TMPGLTRANSU
52 0 56.0 1.0
13 0 0 0.0
TMPGLTRANSUXPK
52
0 55.8 1.0
13 0 0 0.0
SURVEYHEADR
17
0 75.9 1.0
15 0 0 0.0
FOGLIGHT
13
0 94.6 1.0
13 0 0 0.0
ABCCONVER
13
0 94.6 1.0
13 0 0 0.0
SAWWARE
13
0 93.8 1.0
13 0 0 0.0
SURVEYDATA
13
0 93.8 1.0
13 0 0 0.0
TBMEDIUM05
13
0 94.6 1.0
13 0 0 0.0
TBTINY02
13
0 94.6 1.0
13 0 0 0.0
USERS
13
0 94.6 1.0
13 0 0 0.0
-------------------------------------------------------------
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ACCFPRSUBD
/u03/oracle/data/felixaccfprsubd01.dbf
111
0 33.1 1.0 139 0 0
ACCFPRSUBDX01
/u03/oracle/data/felixaccfprsubdx0101.dbf
110
0 34.5 1.0
57 0 0
ACCFPRSUBDX02
/u03/oracle/data/felixaccfprsubdx0201.dbf
72
0 48.3 1.0
42 0 0
ACCFPRSUBDXPK
/u03/oracle/data/felixaccfprsubdxpk01.dbf
71
0 42.7 1.0
41 0 0
ACCREFCHECKL
/u03/oracle/data/felixaccrefcheckl01.dbf
91
0 25.6 1.0 101 0 0
ACCTRANDTL
/u03/oracle/data/felixacctrandtl01.dbf
178,555 45 16.2 1.0 467
0
8 13.8
/u03/oracle/data/felixacctrandtl02.dbf
110,349 28 16.1 1.0 972
0
3 20.0
ACCTRANDTLX01
/u03/oracle/data/felixacctrandtl0101.dbf
4,038 1 14.1 1.0 910 0 0
ACCTRANDTLX02
/u03/oracle/data/felixacctrandtlx0201.dbf
16,783 4 15.7 1.0 678 0
18 6.7
ACCTRANDTLX03
/u03/oracle/data/felixacctrandtlx0301.dbf
827
0 18.0 1.0 476 0 0
ACCTRANDTLX04
/u03/oracle/data/felixacctrandtlx0401.dbf
14,695 4 15.5 1.0 713 0
12 5.0
ACCTRANDTLX05
/u03/oracle/data/felixacctrandtlx0501.dbf
12,064 3 16.4 1.0 440 0 1 10.0
ACCTRANDTLX06
/u03/oracle/data/felixacctrandtlx0601.dbf
4,780 1 17.1 1.0 486 0
42 10.5
ACCTRANDTLX07
/u03/oracle/data/felixacctrandtlx0701.dbf
567
0 21.0 1.0 203 0 0
ACCTRANHIS
/u03/oracle/data/felixacctranhis01.dbf
663
0 18.7 1.0 618 0 0
/u03/oracle/data/felixacctranhis02.dbf
505
0 19.4 1.0
86 0 0
/u03/oracle/data/felixacctranhis03.dbf
174
0 38.3 1.0
15 0 0
/u03/oracle/data/felixacctranhis04.dbf
599
0 18.6 1.0
17 0 0
ACCTRANHISX01
/u03/oracle/data/felixacctranhisx0101.dbf
163
0 34.2 1.0 128 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ACCTRANHISX01
/u03/oracle/data/felixacctranhisx0102.dbf
399 0 17.8 1.0 416
0
0
ACCTRANHISX02
/u03/oracle/data/felixacctranhisx0201.dbf
150
0 28.1 1.0 159 0 0
/u03/oracle/data/felixacctranhisx0202.dbf
273
0 17.9 1.0 369 0 0
ACCTRANHISX03
/u03/oracle/data/felixacctranhisx0301.dbf
1,102 0 18.0 1.0 513 0 0
ACCTRANHISX04 /u03/oracle/data/felixacctranhisx0401.dbf
490
0 21.8 1.0 364 0 0
ACCTRANHISXPK
/u03/oracle/data/felixacctranhisxpk01.dbf
126
0 38.7 1.0
75 0 7 0.0
AIRWARE
/u03/oracle/data/felixairware01.dbf
52
0 85.4 1.0
13 0 0
AWCRSTRANS
/u03/oracle/data/felixawcrstrans01.dbf
340
0 26.1 1.0 315
0 0
/u03/oracle/data/felixawcrstrans02.dbf
195
0 29.1 1.0 128 0 0
/u03/oracle/data/felixawcrstrans03.dbf
173
0 29.6 1.0 136 0 0
/u03/oracle/data/felixawcrstrans04.dbf
145
0 30.6 1.0 114 0 0
/u03/oracle/data/felixawcrstrans05.dbf
68 0 47.4 1.0
14 0 0
/u03/oracle/data/felixawcrstrans06.dbf
82
0 36.1 1.0
25 0 0
AWFLGTHST
/u03/oracle/data/felixawflgthst01.dbf
214
0 36.0 1.0
51 0 0
AWFLGTHSTX01
/u03/oracle/data/felixawflgthstx0101.dbf
157
0 38.3 1.0
68 0 0
AWFLGTHSTXPK
/u03/oracle/data/felixawflgthstxpk01.dbf
164
0 40.8 1.0
78 0 0
AWFLIAVAINVX01
/u03/oracle/data/felixawfliavainvx0101.dbf
170
0 37.2 1.0 143 0
51 1.0
/u03/oracle/data/felixawfliavainvx0102.dbf
114
0 39.4 1.0
48 0
20 37.5
/u03/oracle/data/felixawfliavainvx0103.dbf
107
0 39.2 1.0
56 0 0
AWFLIAVAINVXPK
/u03/oracle/data/felixawfliavainvxpk01.dbf
133
0 42.8 1.0
73 0 1 20.0
/u03/oracle/data/felixawfliavainvxpk02.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
174
0 31.0 1.0 101 0
108 0.3
AWFLIAVAINVXPK
/u03/oracle/data/felixawfliavainvxpk03.dbf
126
0 34.9 1.0
76 0
19 0.0
AWITINERR
/u03/oracle/data/felixawitinerr01.dbf
4,262 1 18.3 1.0 63 0 0
/u03/oracle/data/felixawitinerr02.dbf
4,216 1 17.5 1.0
21 0 0
AWITINERRX01
/u03/oracle/data/felixawitinerrx0101.dbf
4,355 1 17.5 1.0
82 0 0
AWITINERRX02
/u03/oracle/data/felixawitinerrx0201.dbf
237
0 29.0 1.0
72 0 0
AWITINERRX03
/u03/oracle/data/felixawitinerrx0301.dbf
168 0 29.7 1.0
84 0 0
AWITINFARE
/u03/oracle/data/felixawitinfare01.dbf
248
0 31.7 1.0
88 0 0
AWIXMEDIUM01
/u03/oracle/data/felixawixmedium0101.dbf
52
0 85.4 1.0
13 0 0
AWIXMEDIUM02
/u03/oracle/data/felixawixmedium0201.dbf
2,240 1 17.5 1.0 688 0
25 0.0
/u03/oracle/data/felixawixmedium0202.dbf
3,086 1 17.0 1.0 523 0 3 0.0
AWIXMEDIUM03
/u03/oracle/data/felixawixmedium0301.dbf
49,606 12 12.7 1.0 732
0
29,673 13.8
/u03/oracle/data/felixawixmedium0302.dbf
49,778 13 13.2 1.0 662
0
33,132 13.8
AWIXSMALL01
/u03/oracle/data/felixawixsmall0101.dbf
52
0 85.4 1.0
13 0 0
AWIXSMALL02
/u03/oracle/data/felixawixsmall0201.dbf
39,927 10 11.4 1.0 2,952
1
36,323 8.0
/u03/oracle/data/felixawixsmall0202.dbf
51,536 13 10.2 1.0 4,333
1
75,366 7.3
AWIXSMALL03
/u03/oracle/data/felixawixsmall0301.dbf
42,888 11 12.2 1.0 4,543
1
21,235 8.4
/u03/oracle/data/felixawixsmall0302.dbf
44,967 11 12.7 1.0 4,339
1
4,541 8.9
AWIXTINY02
/u03/oracle/data/felixawixtiny0201.dbf
11,621 3 10.0 1.0 6,273 2
72 10.1
AWJOBLOG
/u03/oracle/data/felixawjoblog01.dbf
70
0 46.1 1.0
70 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
AWLOB01
/u03/oracle/data/felixawlob0101.dbf
166
0 51.2 1.7
13 0 0
AWPSGRHST
/u03/oracle/data/felixawpsgrhst01.dbf
138,832 35 14.5 1.0 139
0
85,983 16.6
AWPSGRITIN
/u03/oracle/data/felixawpsgritin01.dbf
16,619 4 16.4 4.2 229 0 5 2.0
AWPSGRITINS
/u03/oracle/data/felixawpsgritins01.dbf
8,069 2 16.9 1.0 242 0 0
AWPSGRITINSX01
/u03/oracle/data/felixawpsgritinsx0101.dbf
7,145 2 17.2 1.0 161 0 0
AWPSGRITINSX02
/u03/oracle/data/felixawpsgritinsx0201.dbf
182
0 37.8 1.0
97 0 0
AWPSGRITINSX03
/u03/oracle/data/felixawpsgritinsx0301.dbf
7,054 2 17.3 1.0 147 0 0
AWPSGRITINSXPK
/u03/oracle/data/felixawpsgritinsxpk01.dbf
333
0 30.1 1.0
45 0 0
AWPSGRRTHST
/u03/oracle/data/felixawpsgrrthst01.dbf
382 0 27.4
1.0 124
0
0
AWPSGRRTHSTX01
/u03/oracle/data/felixawpsgrrthstx0101.dbf
413
0 25.2 1.0 213 0 0
AWPSGRTRAN
/u03/oracle/data/felixawpsgrtran01.dbf
367,515 92 10.1 1.0 166
0 140,961 9.5
AWPSGRTRANX01
/u03/oracle/data/felixawpsgrtranx0101.dbf
113
0 36.2 1.0
65 0 0
AWPSGRTRANX02
/u03/oracle/data/felixawpsgrtranx0201.dbf
68
0 45.9 1.0
43 0 0
AWPSGRTRANX03
/u03/oracle/data/felixawpsgrtranx0301.dbf
19,156 5 12.1 1.0 287 0 4,124 6.0
AWPSGRTRANX04
/u03/oracle/data/felixawpsgrtranx0401.dbf
1,058 0 19.7 1.0 240 0 0
AWPSGRTRANX05
/u03/oracle/data/felixawpsgrtranx0501.dbf
340
0 23.6 1.0 278 0 0
AWPSGRTRANX06
/u03/oracle/data/felixawpsgrtranx0601.dbf
1,765 0 12.4 1.0 379 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
AWPSGRTRANX07
/u03/oracle/data/felixawpsgrtranx0701.dbf
969
0 21.6 1.0 572 0 0
AWPSGRTRANXPK
/u03/oracle/data/felixawpsgrtranxpk01.dbf
77
0 43.0 1.0
73 0 1 0.0
AWPSGRVYHST
/u03/oracle/data/felixawpsgrvyhst01.dbf
393
0 20.8 1.0 134
0
0
AWRTGSTAT
/u03/oracle/data/felixawrtgstat01.dbf
69
0 50.7 1.0
26 0 0
AWSYSERR
/u03/oracle/data/felixawsyserr01.dbf
85
0 43.6 1.0
23 0 5 14.0
AWTBMEDIUM02
/u03/oracle/data/felixawtbmedium0201.dbf
24,976 6 17.8 9.5 167 0
28 16.1
/u03/oracle/data/felixawtbmedium0202.dbf
25,295 6 18.0 9.7 233 0
27 8.9
AWTBSMALL01
/u03/oracle/data/felixawtbsmall0101.dbf
52
0 56.9 1.0
13 0 0
AWTBSMALL02
/u03/oracle/data/felixawtbsmall0201.dbf
134,305 34 11.0 4.5 3,616
1
97,931 9.6
/u03/oracle/data/felixawtbsmall0202.dbf
135,362 34 10.7 4.0 3,194
1 114,585 9.7
AWTBSMALLONG01
/u03/oracle/data/felixawtbsmallong0101.dbf
56
0 54.3 1.0
15 0 0
AWTBTINY02
/u03/oracle/data/felixawtbtiny0201.dbf
17,966 5 7.4 1.8
3,942 1
262 8.1
AWTKT
/u03/oracle/data/felixawtkt01.dbf
521
0 19.9 1.0 204 0 0
AWTRACE
/u03/oracle/data/felixawtrace01.dbf
65 0 73.4 1.0
13 0 0
AWTRACEX01
/u03/oracle/data/felixawtracex0101.dbf
65
0 73.4 1.0
13 0 0
AWTRACEXPK
/u03/oracle/data/felixawtracexpk01.dbf
65
0 73.4 1.0
13 0 0
CLIENT
/u03/oracle/data/felixclient01.dbf
285,516 72 13.3 8.6 355
0
39,500 17.0
/u03/oracle/data/felixclient02.dbf
148,202 37 12.2 6.3 1,158
0
20,698 17.4
CLIENTPRGRM
/u03/oracle/data/felixclientprgrm01.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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,475 1 17.6 1.0
75 0 0
CLIENTPRGRMX01
/u03/oracle/data/felixclientprgrmx0101.dbf
142
0 27.7 1.0
58 0 0
CLIENTSPDAT
/u03/oracle/data/felixclientspdat01.dbf
204
0 26.6 1.0
14 0 0
CLIENTX01
/u03/oracle/data/felixclientx0101.dbf
267
0 24.0 1.0 192 0 0
CLIENTX02
/u03/oracle/data/felixclientx0201.dbf
1,380 0 20.1 1.0 776 0 0
CLIENTX03
/u03/oracle/data/felixclientx0301.dbf
195
0 27.7 1.0 138 0 0
CLIENTX04
/u03/oracle/data/felixclientx0401.dbf
1,684 0 17.5 1.0 165 0 0
CLIENTX05 /u03/oracle/data/felixclientx0501.dbf
79
0 16.3 1.0
22 0 0
CLIENTX06
/u03/oracle/data/felixclientx0601.dbf
1,180 0 16.9 1.0 622 0 0
CONDPREDROW
/u03/oracle/data/felixcondpredrow01.dbf
99,377 25 12.8 1.0
60 0
367 15.9
CONDPREDROWXF1
/u03/oracle/data/felixcondpredrowxf101.dbf
614
0 19.8 1.0 372
0 0
CONDPREDROWXF2
/u03/oracle/data/felixcondpredrowxf201.dbf
112,499 28 12.3 1.0
41 0
399 13.3
CONDPREDROWXN1
/u03/oracle/data/felixcondpredrowxn101.dbf
109
0 53.9 1.0
46 0 0
CONDPREDROWXPK
/u03/oracle/data/felixcondpredrowxpk01.dbf
88
0 55.2 1.0
44 0 0
CONDPREDRULX01
/u03/oracle/data/felixcondpredrulx0101.dbf
1,077 0 19.6 1.0 100 0
12 8.3
CONDPREDRULXPK
/u03/oracle/data/felixcondpredrulxpk01.dbf
329
0 23.2 1.0
35 0 0
CONDRULETB
/u03/oracle/data/felixcondruletb01.dbf
155,807 39 13.2 1.0 429
0
390 15.6
CONDRULETBX01
/u03/oracle/data/felixcondruletbx0101.dbf
205
0 31.1 1.0
59 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
CONDRULETBX02
/u03/oracle/data/felixcondruletbx0201.dbf
164
0 30.1 1.0 105 0 0
CONDRULETBXF1
/u03/oracle/data/felixcondruletbxf101.dbf
288
0 26.7 1.0 151 0 0
CONDRULETBXF2
/u03/oracle/data/felixcondruletbxf201.dbf
111
0 38.9 1.0
51 0 0
CONDSTRLIB
/u03/oracle/data/felixcondstrlib01.dbf
145,364 37 12.2 1.0
51 0 915 13.1
CONDSTRLIBX01
/u03/oracle/data/felixcondstrlibx0101.dbf
878
0 18.7 1.0 211 0 0
CONDTABPRED
/u03/oracle/data/felixcondtabpred01.dbf
66,001 17 11.6 1.0
85 0
288 14.8
CONDTABPREDUQ
/u03/oracle/data/felixcondtabpreduq01.dbf
5,057 1 17.1 1.0
81 0 0
CONDTABPREDX01
/u03/oracle/data/felixcondtabpredx0101.dbf
164 0 28.9 1.0 103 0 0
CONDTABPREDX02
/u03/oracle/data/felixcondtabpredx0201.dbf
177
0 31.1 1.0
98 0 0
ENTITYLINKIOT
/u03/oracle/data/felixentitylinkiot01.dbf
6,110 2 15.1 1.0 314 0 0
FAXQUEUE
/u03/oracle/data/felixfaxqueue01.dbf
103,921 26 14.4 1.0 653
0
14 0.0
FOGLIGHT /u03/oracle/data/felixfoglight01.dbf
13
0 94.6 1.0
13 0 0
GLTRANS
/u03/oracle/data/felixgltrans01.dbf
1,114 0 4.7 1.0
25 0 0
/u03/oracle/data/felixgltrans02.dbf
77
0 57.8 1.0
18 0 0
/u03/oracle/data/felixgltrans03.dbf
1,939 0 2.3 1.0
16 0 0
/u03/oracle/data/felixgltrans04.dbf
260
0 21.0 1.0 238 0 0
/u03/oracle/data/felixgltrans05.dbf
44
0 37.3 1.0
13 0 0
/u03/oracle/data/felixgltrans06.dbf
1,268 0 4.9 1.0
15 0 0
/u03/oracle/data/felixgltrans07.dbf
157
0 31.3 1.0 14
0 0
/u03/oracle/data/felixgltrans08.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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,863 0 3.7 1.0
13 0 0
GLTRANS
/u03/oracle/data/felixgltrans09.dbf
1,156 0 5.4 1.0
15 0 0
/u03/oracle/data/felixgltrans10.dbf
614
0 12.4 1.0
14 0 0
/u03/oracle/data/felixgltrans11.dbf
1,762 0 7.1 1.0
71 0 0
/u03/oracle/data/felixgltrans12.dbf
633
0 9.0 1.0
14 0 0
/u03/oracle/data/felixgltrans13.dbf
2,573 1 3.7 1.0
18 0 0
/u03/oracle/data/felixgltrans14.dbf
207
0 28.8 1.0
19 0 0
/u03/oracle/data/felixgltrans15.dbf
533
0 6.9 1.0
15 0 0
GLTRANSX01
/u03/oracle/data/felixgltransx0101.dbf
291
0 22.5 1.0 155 0 0
/u03/oracle/data/felixgltransx0102.dbf
102
0 36.1 1.0
53 0 0
GLTRANSX02
/u03/oracle/data/felixgltransx0201.dbf
419
0 24.7 1.0 228 0 0
/u03/oracle/data/felixgltransx0202.dbf
369
0 24.8 1.0 169 0 0
GLTRANSX03
/u03/oracle/data/felixgltransx0301.dbf
547
0 23.2 1.0
13 0 0
/u03/oracle/data/felixgltransx0302.dbf
542
0 16.1 1.0
14 0 0
GLTRANSX04
/u03/oracle/data/felixgltransx0401.dbf
109
0 31.4 1.0
81 0 0
/u03/oracle/data/felixgltransx0402.dbf
97
0 36.4 1.0
81 0 0
GLTRANSX05
/u03/oracle/data/felixgltransx0501.dbf
89
0 43.0 1.0
31 0 0
/u03/oracle/data/felixgltransx0502.dbf
227
0 22.1 1.0 186 0 0
GLTRANSX06
/u03/oracle/data/felixgltransx0601.dbf
66
0 53.9 1.0
13 0 0
/u03/oracle/data/felixgltransx0602.dbf
158
0 26.1 1.0 158 0 0
GLTRANSX07
/u03/oracle/data/felixgltransx0701.dbf
205
0 23.1 1.0 191 0 0
GLTRANSX08
/u03/oracle/data/felixgltransx0801.dbf
52
0 56.2 1.0
13 0 0
/u03/oracle/data/felixgltransx0802.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
56
0 47.0 1.0
14 0 0
GLTRANSX09
/u03/oracle/data/felixgltransx0901.dbf
150
0 27.5 1.0 120 0 0
/u03/oracle/data/felixgltransx0902.dbf
115
0 31.2 1.0
76 0 0
GLTRANSXPK
/u03/oracle/data/felixgltransxpk01.dbf
25
0 55.6 1.0
29 0 0
/u03/oracle/data/felixgltransxpk02.dbf
56
0 58.4 1.0
31 0 0
GRPINVHIS
/u03/oracle/data/felixgrpinvhis01.dbf
6,283 2 15.0 1.0 214 0 0
GRPINVHISFK
/u03/oracle/data/felixgrpinvhisfk01.dbf
1,015 0 17.8 1.0 222 0 0
GRPINVHISTXPK
/u03/oracle/data/felixgrpinvhistxpk01.dbf
82
0 46.0 1.0
53 0 0
GRPINVITEM
/u03/oracle/data/felixgrpinvitem01.dbf
4,244 1 14.7 1.0
1,547 0 2 5.0
GRPOLDHSDTL
/u03/oracle/data/felixgrpoldhsdtl01.dbf
52
0 60.6 1.0
13 0 0
GRPROHSTXPK
/u03/oracle/data/felixgrprohstxpk01.dbf
74
0 48.9 1.0
65 0 0
GTBDOCHIST
/u03/oracle/data/felixgtbdochist01.dbf
168
0 25.4 1.0
93 0 0
GTBDOCHISTX01
/u03/oracle/data/felixgtbdochistx0101.dbf
307
0 24.2 1.0 152 0 0
GTBDOCQUEUE
/u03/oracle/data/felixgtbdocqueue01.dbf
241
0 29.5 1.0 137 0 0
GTBDOCQUEUEX01
/u03/oracle/data/felixgtbdocqueuex0101.dbf
92
0 41.6 1.0
32 0 0
GTBINFOERRS
/u03/oracle/data/felixgtbinfoerrs01.dbf
177
0 36.0 1.0 143 0 0
/u03/oracle/data/felixgtbinfoerrs02.dbf
98
0 38.5 1.0
59 0 0
/u03/oracle/data/felixgtbinfoerrs03.dbf
136
0 39.3 1.0
87 0 0
GTBINFOERRSX01
/u03/oracle/data/felixgtbinfoerrsx0101.dbf
1,741 0 15.5 1.0 1,185 0 0
/u03/oracle/data/felixgtbinfoerrsx0102.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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,785 0 17.3 1.0 1,094 0 0
GTBINFOERRSX02 /u03/oracle/data/felixgtbinfoerrsx0201.dbf
303
0 25.3 1.0 140 0 0
/u03/oracle/data/felixgtbinfoerrsx0202.dbf
264
0 24.5 1.0 156 0 0
GTBINFOERRSXPK
/u03/oracle/data/felixgtbinfoerrsxpk01.dbf
408
0 26.7 1.0 252 0 1 0.0
GTBPRINTBC
/u03/oracle/data/felixgtbprintbc01.dbf
52
0 60.6 1.0 13
0 0
GTBREQHIST
/u03/oracle/data/felixgtbreqhist01.dbf
123
0 20.2 1.0 208 0 0
GTBREQTKIM
/u03/oracle/data/felixgtbreqtkim01.dbf
52
0 60.8 1.0
13 0 0
GTBREQUEST
/u03/oracle/data/felixgtbrequest01.dbf
2,204 1 18.4 1.0 217 0 0
HOUSEHLDADR
/u03/oracle/data/felixhousehldadr01.dbf
32,334 8 8.7 1.0 344 0 0
HOUSEHLDADRX01
/u03/oracle/data/felixhousehldadrx0101.dbf
307
0 25.2 1.0 262 0 0
HOUSEHLDPHN
/u03/oracle/data/felixhousehldphn01.dbf
7,777 2 17.2 1.0 266 0 0
HOUSEHOLD
/u03/oracle/data/felixhousehold01.dbf
716
0 19.8 1.2 446 0 0
IMAGESTORE /u03/oracle/data/feliximagestore01.dbf
1,337 0 11.8 1.5
24 0 0
/u03/oracle/data/feliximagestore02.dbf
245
0 15.2 1.0
15 0 0
INSUREXCHLOG
/u03/oracle/data/felixinsurexchlog01.dbf
117
0 20.6 1.0
39 0 0
IXMEDIUM01
/u03/oracle/data/felixixmedium0101.dbf
30,136 8 11.6 1.0 6,784 2 67 11.5
/u03/oracle/data/felixixmedium0102.dbf
31,109 8 12.0 1.0 10,712 3
131 16.2
IXMEDIUM02
/u03/oracle/data/felixixmedium0201.dbf
68,243 17 15.0 8.5 2,698
1
149 12.6
/u03/oracle/data/felixixmedium0202.dbf
57,640 14 15.7 9.5 2,379
1
77 16.6
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
IXMEDIUM03
/u03/oracle/data/felixixmedium0301.dbf
37,723 9 14.0 1.0 5,688 1
67 9.4
/u03/oracle/data/felixixmedium0302.dbf
49,251 12 13.2 1.0 5,223
1
135 8.5
IXMEDIUM04
/u03/oracle/data/felixixmedium0401.dbf
58,270 15 12.6 1.0 3,598
1
457 7.0
/u03/oracle/data/felixixmedium0402.dbf
53,453 13 12.6 1.0 5,799
1
258 13.9
IXMEDIUM05
/u03/oracle/data/felixixmedium0501.dbf
94,683 24 10.2 1.0 3,776
1
12,792 9.8
/u03/oracle/data/felixixmedium0502.dbf
67,708 17 11.5 1.0 2,891
1
14,218 10.0
IXMEDIUM06
/u03/oracle/data/felixixmedium0601.dbf
32,453 8 14.0 1.0 5,915 1
79 14.6
/u03/oracle/data/felixixmedium0602.dbf
32,217 8 14.7 1.0 5,235 1
68 13.5
IXMEDIUM07
/u03/oracle/data/felixixmedium0701.dbf
37,851 10 12.2 1.0 6,608
2
1 40.0
/u03/oracle/data/felixixmedium0702.dbf
41,877 11 11.9 1.0 7,217
2
1 0.0
IXMEDIUM08
/u03/oracle/data/felixixmedium0801.dbf
93,207 23 11.7 1.1 3,829
1
12,730 12.8
/u03/oracle/data/felixixmedium0802.dbf
101,516 26 10.9 1.0 3,275
1 14,389 11.4
IXMEDIUM09
/u03/oracle/data/felixixmedium0901.dbf
52
0 60.8 1.0
13 0 0
IXSMALL01
/u03/oracle/data/felixixsmall0101.dbf
18,510 5 12.7 1.0 9,772 2 1,157 6.0
/u03/oracle/data/felixixsmall0102.dbf
18,864 5 12.8 1.0 7,949 2
274 15.4
IXSMALL02 /u03/oracle/data/felixixsmall0201.dbf
42,309 11 11.2 1.0 7,960
2
7 4.3
/u03/oracle/data/felixixsmall0202.dbf
50,057 13 10.4 1.0 14,382
4
7 5.7
IXSMALL03
/u03/oracle/data/felixixsmall0301.dbf
23,926 6 12.3 3.9 7,689 2
13 5.4
/u03/oracle/data/felixixsmall0302.dbf
20,229 5 10.8 1.4 12,231 3 6 0.0
IXSMALL04
/u03/oracle/data/felixixsmall0401.dbf
53,732 14 12.4 1.0 12,216
3
224 3.5
IXSMALL05
/u03/oracle/data/felixixsmall0501.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
78,916 20 11.6 1.1 21,511
5
380 5.9
IXSMALL06
/u03/oracle/data/felixixsmall0601.dbf
97,032 24 11.4 1.0 39,952 10
324 3.6
IXSMALL07
/u03/oracle/data/felixixsmall0701.dbf
37,059 9 13.0 1.0 14,821 4
113 2.2
/u03/oracle/data/felixixsmall0702.dbf
23,787 6 13.9 1.0 8,465 2
136 0.7
IXSMALL08
/u03/oracle/data/felixixsmall0801.dbf
39,552 10 10.0 1.0 8,317
2
515 8.4
/u03/oracle/data/felixixsmall0802.dbf
60,279 15 10.1 1.0 9,660
2
367 8.7
IXSMALL09
/u03/oracle/data/felixixsmall0901.dbf
52
0 69.6 1.0
13 0 0
IXTINY03
/u03/oracle/data/felixixtiny0301.dbf
67,354 17 11.9 1.0 40,438 10 3,521 0.3
JOBSERRLOG
/u03/oracle/data/felixjobserrlog01.dbf
171
0 34.1 1.0 121 0 0
/u03/oracle/data/felixjobserrlog02.dbf
52
0 81.3 1.0
13 0 0
/u03/oracle/data/felixjobserrlog03.dbf
124
0 39.4 1.0
51 0 0
JOBSERRLOGX01
/u03/oracle/data/felixjobserrlogx0101.dbf
93
0 45.6 1.0
59 0 0
/u03/oracle/data/felixjobserrlogx0102.dbf
202
0 30.4 1.0 125 0 0
JOBSERRLOGX02
/u03/oracle/data/felixjobserrlogx0201.dbf
230
0 28.8 1.0 154
0 0
JOBSERRLOGXPK
/u03/oracle/data/felixjobserrlogxpk01.dbf
197
0 32.1 1.0 145 0 0
LARGEWORK
/u03/oracle/data/felixlargework01.dbf
65
0 70.6 1.0
13 0 0
LOB01
/u03/oracle/data/felixlob0101.dbf
33,124 8 7.9 1.0
25,390 6
58 0.9
ABCAIRARCHIVE
/u03/oracle/data/felixABCairarchive01.dbf
52
0 60.2 1.0
13 0 0
ABCAIRWARE
/u03/oracle/data/felixABCairware01.dbf
63
0 62.9 1.0
14 0 0
ABCAPISPUPL
/u03/oracle/data/felixABCapispupl01.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
52
0 81.2 1.0
13 0 0
ABCAPISUPL
/u03/oracle/data/felixABCapisupl01.dbf
52
0 81.3 1.0
13 0 0
ABCCCHIST
/u03/oracle/data/felixABCcchist01.dbf
566
0 18.3 1.0
2,352 1 2 0.0
/u03/oracle/data/felixABCcchist02.dbf
84
0 56.5 1.0
13 0 0
/u03/oracle/data/felixABCcchist03.dbf
175
0 37.8 1.0 111 0 1 20.0
/u03/oracle/data/felixABCcchist04.dbf
82
0 43.0 1.0
14 0 0
/u03/oracle/data/felixABCcchist05.dbf
116
0 42.2 1.0
13 0 0
/u03/oracle/data/felixABCcchist06.dbf
74
0 39.3 1.0
15 0 0
ABCCCHISTX01
/u03/oracle/data/felixABCcchistx0101.dbf
3,448 1 20.3 1.0 1,781 0 0
ABCCCHISTX02
/u03/oracle/data/felixABCcchistx0201.dbf
289
0 25.7 1.0 285
0 0
ABCCCHISTXPK
/u03/oracle/data/felixABCcchistxpk01.dbf
130
0 36.2 1.0
72 0 0
ABCCCSETHIS
/u03/oracle/data/felixABCccsethis01.dbf
65
0 78.0 1.0
13 0 0
ABCCCSHPLOG
/u03/oracle/data/felixABCccshplog01.dbf
587
0 18.9 1.0 801 0 0
/u03/oracle/data/felixABCccshplog02.dbf
52 0 70.2
1.0
13 0
0
/u03/oracle/data/felixABCccshplog03.dbf
52
0 57.3 1.0
13 0 0
/u03/oracle/data/felixABCccshplog04.dbf
52
0 60.8 1.0
14 0 0
ABCCCSHPLOGX01
/u03/oracle/data/felixABCccshplogx0101.dbf
272
0 27.4 1.0 231 0 0
ABCCCSHPLOGX02 /u03/oracle/data/felixABCccshplogx0201.dbf
110
0 36.5 1.0
46 0 0
ABCCLEARERR
/u03/oracle/data/felixABCclearerr01.dbf
51
0 63.3 1.0
14 0 0
ABCCLIENTAU
/u03/oracle/data/felixABCclientau01.dbf
52
0 81.3 1.0
13 0 0
ABCCLIENTWK
/u03/oracle/data/felixABCclientwk01.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
63
0 63.0 1.0
14 0 0
ABCCLTYPREO
/u03/oracle/data/felixABCcltypreo01.dbf
51
0 62.7 1.0
14 0 0
ABCCMTCRDRESA
/u03/oracle/data/felixABCcmtcrdresa01.dbf
51
0 62.7 1.0
14 0 0
ABCCONVER
/u03/oracle/data/felixABCconver01.dbf
13
0 94.6 1.0
13 0 0
ABCCRSTRNDT
/u03/oracle/data/felixABCcrstrndt01.dbf
52
0 79.2 1.0
13 0 0
ABCCRSTRNDTX01
/u03/oracle/data/felixABCcrstrndtx0101.dbf
52
0 79.0 1.0
13 0 0
ABCCRSTRNDTXPK
/u03/oracle/data/felixABCcrstrndtxpk01.dbf
52
0 79.0 1.0
13 0 0
ABCCRSTRNHD
/u03/oracle/data/felixABCcrstrnhd01.dbf
52
0 79.4 1.0
13 0 0
ABCCRSTRNHDX01
/u03/oracle/data/felixABCcrstrnhdx0101.dbf
52
0 79.4 1.0 13
0 0
ABCCRSTRNHDX02
/u03/oracle/data/felixABCcrstrnhdx0201.dbf
52
0 79.4 1.0
13 0 0
ABCCRSTRNHDXPK
/u03/oracle/data/felixABCcrstrnhdxpk01.dbf
52
0 79.2 1.0
13 0 0
ABCDELPHERR
/u03/oracle/data/felixABCdelpherr01.dbf
52
0 61.3 1.0
14 0 0
ABCDRSEDLOG
/u03/oracle/data/felixABCdrsedlog01.dbf
84
0 43.3 1.0
59 0 0
ABCDRSGRPHS
/u03/oracle/data/felixABCdrsgrphs01.dbf
138
0 39.7 1.0
68 0 0
/u03/oracle/data/felixABCdrsgrphs02.dbf
65
0 58.2 1.0
13 0 0
ABCDRSGRPHSARC
/u03/oracle/data/felixABCdrsgrphsarc01.dbf
52
0 57.1 1.0
13 0 0
ABCDRSGRPHSX01
/u03/oracle/data/felixABCdrsgrphsx0101.dbf
118
0 46.7 1.0
56 0 0
ABCDRSGRPHSX03
/u03/oracle/data/felixABCdrsgrphsx0301.dbf
61
0 69.7 1.0
19 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ABCDRSGRPHSX04
/u03/oracle/data/felixABCdrsgrphsx0401.dbf
77
0 44.0 1.0
29 0 0
ABCDRSGRPHSXPK
/u03/oracle/data/felixABCdrsgrphsxpk01.dbf
74
0 58.9 1.0
25 0 0
ABCDRSPRHIS
/u03/oracle/data/felixABCdrsprhis01.dbf
56
0 46.1 1.0
14 0 0
ABCDRSPRLOG
/u03/oracle/data/felixABCdrsprlog01.dbf
62
0 54.7 1.0
16 0 0
ABCDWBRULES
/u03/oracle/data/felixABCdwbrules01.dbf
52
0 70.2 1.0
13 0 0
/u03/oracle/data/felixABCdwbrules02.dbf
52
0 57.3 1.0
13 0 0
/u03/oracle/data/felixABCdwbrules03.dbf
52
0 57.3 1.0
13 0 0
ABCDWBRULESX01
/u03/oracle/data/felixABCdwbrulesx0101.dbf
52
0 70.2 1.0
13 0 0
ABCDWBRULESX03
/u03/oracle/data/felixABCdwbrulesx0301.dbf
52
0 70.0 1.0
13 0 0
ABCDWIXMEDIUM1
/u03/oracle/data/felixABCdwixmedium101.dbf
52
0 85.4 1.0
13 0 0
ABCDWPRICNG
/u03/oracle/data/felixABCdwpricng01.dbf
52
0 70.2 1.0
13 0 0
ABCDWSMALL01
/u03/oracle/data/felixABCdwsmall0101.dbf
53
0 69.2 1.0
13 0 0
ABCDWTRGLOG
/u03/oracle/data/felixABCdwtrglog01.dbf
808
0 16.1 1.0 803 0 0
ABCDWTRGLOGX01
/u03/oracle/data/felixABCdwtrglogx0101.dbf
533
0 23.2 1.0 400 0 4 0.0
ABCECOMMTMP
/u03/oracle/data/felixABCecommtmp01.dbf
65
0 78.0 1.0
13 0 0
/u03/oracle/data/felixABCecommtmp02.dbf
52
0 81.2 1.0
13 0 0
ABCFAX
/u03/oracle/data/felixABCfax01.dbf
52
0 61.5 1.0
14 0 0
ABCFAXQUEUE
/u03/oracle/data/felixABCfaxqueue01.dbf
65
0 51.7 1.0
13 0 0
ABCFIDELIOSHIP
/u03/oracle/data/felixABCfidelioship01.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
52
0 60.8 1.0
13 0 0
ABCFIPSDETL
/u03/oracle/data/felixABCfipsdetl01.dbf
52
0 70.2 1.0
13 0 0
ABCFIPSDETLXPK
/u03/oracle/data/felixABCfipsdetlxpk01.dbf
52
0 70.2 1.0
13 0
0
ABCGRINVITH
/u03/oracle/data/felixABCgrinvith01.dbf
616
0 18.8 1.0 613 0 2 5.0
ABCGRPINVIH
/u03/oracle/data/felixABCgrpinvih01.dbf
52
0 81.3 1.0
13 0 0
/u03/oracle/data/felixABCgrpinvih02.dbf
52
0 78.5 1.0
13 0 0
/u03/oracle/data/felixABCgrpinvih03.dbf
52
0 70.2 1.0
13 0 0
/u03/oracle/data/felixABCgrpinvih04.dbf
52
0 57.1 1.0
13 0 0
/u03/oracle/data/felixABCgrpinvih05.dbf
54
0 60.0 1.0
14 0 0
ABCGRPINVIHX01
/u03/oracle/data/felixABCgrpinvihx0101.dbf
52
0 81.2 1.0
13 0 0
/u03/oracle/data/felixABCgrpinvihx0102.dbf
52
0 70.2 1.0
13 0 0
/u03/oracle/data/felixABCgrpinvihx0103.dbf
56
0 47.0 1.0
14 0 0
ABCGRPINVIHX02
/u03/oracle/data/felixABCgrpinvihx0201.dbf
52
0 81.2 1.0
13 0 0
/u03/oracle/data/felixABCgrpinvihx0202.dbf
26
0 80.8 1.0
13 0
0
/u03/oracle/data/felixABCgrpinvihx0203.dbf
54
0 60.0 1.0
14 0 0
ABCGRPINVIHXPK
/u03/oracle/data/felixABCgrpinvihxpk01.dbf
52
0 81.2 1.0
13 0 0
ABCHISTPAYM
/u03/oracle/data/felixABChistpaym01.dbf
52
0 52.5 1.0
13 0 0
/u03/oracle/data/felixABChistpaym02.dbf
52
0 52.5 1.0
13 0 0
/u03/oracle/data/felixABChistpaym03.dbf
52
0 52.5 1.0
13 0 0
/u03/oracle/data/felixABChistpaym04.dbf
52
0 56.9 1.0
13 0 0
ABCHISTPAYMX01
/u03/oracle/data/felixABChistpaymx0101.dbf
52
0 52.5 1.0
13 0 0
/u03/oracle/data/felixABChistpaymx0102.dbf
39
0 71.5 1.0
13 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ABCIXMEDIUM01
/u03/oracle/data/felixABCixmedium0101.dbf
52
0 70.2 1.0
13 0 0
ABCIXMEDIUM02
/u03/oracle/data/felixABCixmedium0201.dbf
52
0 78.5 1.0
28 0 0
ABCIXMEDIUM03
/u03/oracle/data/felixABCixmedium0301.dbf
71
0 70.4 1.0
15 0 0
ABCIXMEDIUM04 /u03/oracle/data/felixABCixmedium0401.dbf
494
0 20.9 1.0 703 0 1 0.0
ABCIXSMALL01
/u03/oracle/data/felixABCixsmall0101.dbf
52
0 70.2 1.0
13 0 0
ABCIXSMALL02
/u03/oracle/data/felixABCixsmall0201.dbf
605
0 20.9 1.0 511 0 0
ABCIXSMALL03
/u03/oracle/data/felixABCixsmall0301.dbf
1,383 0 13.9 1.0 28
0 0
ABCIXSMALL04
/u03/oracle/data/felixABCixsmall0401.dbf
1,556 0 13.4 1.0 1,160 0 2 0.0
ABCIXSMALL05
/u03/oracle/data/felixABCixsmall0501.dbf
801
0 16.4 1.0 163 0 0
ABCIXTINY01
/u03/oracle/data/felixABCixtiny0101.dbf
258
0 24.3 1.0 221 0 0
ABCIXTINY02
/u03/oracle/data/felixABCixtiny0201.dbf
2,187 1 14.1 1.0 258 0 0
ABCLOB02
/u03/oracle/data/felixABClob0201.dbf
52
0 70.2 1.0
13 0 0
/u03/oracle/data/felixABClob0202.dbf
39
0 71.3 1.0
13 0 0
/u03/oracle/data/felixABClob0203.dbf
52
0 70.2 1.0
13 0 0
/u03/oracle/data/felixABClob0204.dbf
52
0 69.6 1.0
13 0 0
/u03/oracle/data/felixABClob0205.dbf
52
0 60.8 1.0
13 0 0
/u03/oracle/data/felixABClob0206.dbf
52
0 78.1 1.0
13 0 0
/u03/oracle/data/felixABClob0207.dbf
65
0 54.2 1.0
13 0 0
/u03/oracle/data/felixABClob0208.dbf
52
0 60.4 1.0
13 0 0
/u03/oracle/data/felixABClob0209.dbf
52
0 57.1 1.0
13 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ABCMFCCHIST
/u03/oracle/data/felixABCmfcchist01.dbf
52
0 79.0 1.0
13 0 0
ABCMFCCHISTX01
/u03/oracle/data/felixABCmfcchistx0101.dbf
52
0 79.0 1.0
13 0 0
ABCMFCCHISTX02 /u03/oracle/data/felixABCmfcchistx0201.dbf
52
0 78.8 1.0
13 0 0
ABCMFCCHISTX03
/u03/oracle/data/felixABCmfcchistx0301.dbf
52
0 78.8 1.0
13 0 0
ABCMFCCHISTXPK
/u03/oracle/data/felixABCmfcchistxpk01.dbf
52
0 78.8 1.0
13 0 0
ABCMFREFUND
/u03/oracle/data/felixABCmfrefund01.dbf
52
0 85.2 1.0 13
0 0
ABCMFREFUNDX01
/u03/oracle/data/felixABCmfrefundx0101.dbf
65
0 73.4 1.0
13 0 0
ABCRULTREXT
/u03/oracle/data/felixABCrultrext01.dbf
56
0 45.9 1.0
14 0 0
ABCSPMSEPO
/u03/oracle/data/felixABCspmsepo01.dbf
52
0 57.1 1.0
13 0 0
ABCSPMSERRL
/u03/oracle/data/felixABCspmserrl01.dbf
55
0 29.1 1.0
13 0 0
ABCSPMSFLGT
/u03/oracle/data/felixABCspmsflgt01.dbf
55
0 29.1 1.0
13 0 0
ABCSPMSGUES
/u03/oracle/data/felixABCspmsgues01.dbf
52
0 78.1 1.0
13 0 0
ABCTBMEDIUM01
/u03/oracle/data/felixABCtbmedium0101.dbf
287
0 18.9 1.0 104 0 0
ABCTBMEDIUM02 /u03/oracle/data/felixABCtbmedium0201.dbf
52
0 52.5 1.0
13 0 0
ABCTBMEDIUM03
/u03/oracle/data/felixABCtbmedium0301.dbf
52
0 52.3 1.0
13 0 0
ABCTBSMALL01
/u03/oracle/data/felixABCtbsmall0101.dbf
20,286 5 14.3 19.1 1,016 0
422 5.7
ABCTBSMALL02
/u03/oracle/data/felixABCtbsmall0201.dbf
2,868 1 10.7 14.5
13 0
0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ABCTBTINY01 /u03/oracle/data/felixABCtbtiny0101.dbf
1,830 0 14.7 1.5 176 0 0
ABCTBTINY02
/u03/oracle/data/felixABCtbtiny0201.dbf
121
0 40.2 2.3
13 0 0
ABCTRVLOBP1
/u03/oracle/data/felixABCtrvlobp101.dbf
52
0 60.6 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp102.dbf
52
0 57.3 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp103.dbf
52
0 61.0 1.0
14 0 0
/u03/oracle/data/felixABCtrvlobp104.dbf
65
0 75.2 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp105.dbf
55
0 29.1 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp106.dbf
55 0 28.7 1.0
13 0 0
ABCTRVLOBP2
/u03/oracle/data/felixABCtrvlobp201.dbf
52
0 57.3 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp202.dbf
52
0 57.3 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp203.dbf
52
0 61.0 1.0
14 0 0
/u03/oracle/data/felixABCtrvlobp204.dbf
65
0 48.8 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp205.dbf
55
0 28.9 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp206.dbf
55
0 28.7 1.0
13 0 0
ABCTRVLOBP3
/u03/oracle/data/felixABCtrvlobp301.dbf
52
0 57.3 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp302.dbf
52
0 57.3 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp303.dbf
52
0 61.0 1.0
14 0 0
/u03/oracle/data/felixABCtrvlobp304.dbf
52
0 52.5 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp305.dbf
55
0 29.1 1.0 13
0 0
/u03/oracle/data/felixABCtrvlobp306.dbf
66
0 24.7 1.0
13 0 0
ABCTRVLOBP4
/u03/oracle/data/felixABCtrvlobp401.dbf
52
0 57.3 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp402.dbf
52
0 57.3 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp403.dbf
52 0 60.8 1.0
14 0
0
/u03/oracle/data/felixABCtrvlobp404.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
54
0 60.0 1.0
14 0 0
ABCTRVLOBP4
/u03/oracle/data/felixABCtrvlobp405.dbf
55
0 28.9 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp406.dbf
66
0 24.5 1.0
13 0 0
ABCTRVLOBP5
/u03/oracle/data/felixABCtrvlobp501.dbf
52
0 57.1 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp502.dbf
52
0 57.5 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp503.dbf
52
0 61.2 1.0
14 0 0
/u03/oracle/data/felixABCtrvlobp504.dbf
52
0 60.6 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp505.dbf
55
0 28.9 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp506.dbf
66
0 24.4 1.0
13 0 0
ABCTRVLOBP6
/u03/oracle/data/felixABCtrvlobp601.dbf
52
0 57.1 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp602.dbf
65
0 54.9 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp603.dbf
52
0 61.2 1.0
14 0 0
/u03/oracle/data/felixABCtrvlobp604.dbf
52
0 79.4 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp605.dbf
55
0 28.9 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp606.dbf
66
0 24.4 1.0
13 0 0
ABCTRVLOBP7
/u03/oracle/data/felixABCtrvlobp701.dbf
52
0 57.1 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp702.dbf
52
0 56.9 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp703.dbf
52
0 61.2 1.0
14 0 0
/u03/oracle/data/felixABCtrvlobp704.dbf
52 0 60.2 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp705.dbf
55
0 28.9 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp706.dbf
66
0 20.0 1.0
13 0 0
ABCTRVLOBP8
/u03/oracle/data/felixABCtrvlobp801.dbf
52
0 57.1 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp802.dbf
52
0 56.7 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp803.dbf
52
0 61.2 1.0
14 0 0
/u03/oracle/data/felixABCtrvlobp804.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
65
0 75.2 1.0
13 0 0
ABCTRVLOBP8
/u03/oracle/data/felixABCtrvlobp805.dbf
55
0 29.1 1.0
13 0 0
/u03/oracle/data/felixABCtrvlobp806.dbf
55 0 28.7
1.0
13 0
0
ABCTRVLOGP1
/u03/oracle/data/felixABCtrvlogp101.dbf
52
0 57.1 1.0
13 0 0
ABCTRVLOGP2
/u03/oracle/data/felixABCtrvlogp201.dbf
52
0 57.1 1.0
13 0 0
ABCTRVLOGP3
/u03/oracle/data/felixABCtrvlogp301.dbf
52
0 57.1 1.0
13 0 0
ABCTRVLOGP4
/u03/oracle/data/felixABCtrvlogp401.dbf
52
0 57.1 1.0
13 0 0
/u03/oracle/data/felixABCtrvlogp402.dbf
53
0 16.2 1.0
13 0 0
ABCTRVLOGP5
/u03/oracle/data/felixABCtrvlogp501.dbf
52
0 57.1 1.0
13 0 0
ABCTRVLOGP6
/u03/oracle/data/felixABCtrvlogp601.dbf
52
0 57.1 1.0
13 0 0
ABCTRVLOGP7
/u03/oracle/data/felixABCtrvlogp701.dbf
52
0 57.1 1.0
13 0 0
ABCTRVLOGP8
/u03/oracle/data/felixABCtrvlogp801.dbf
52
0 57.1 1.0
13 0 0
ABCVCSLGFLD
/u03/oracle/data/felixABCvcslgfld01.dbf
52
0 78.1 1.0
13 0 0
/u03/oracle/data/felixABCvcslgfld02.dbf
52 0 52.5 1.0
13 0 0
/u03/oracle/data/felixABCvcslgfld03.dbf
52
0 52.5 1.0
13 0 0
ABCVCSLGFLDX01
/u03/oracle/data/felixABCvcslgfldx0101.dbf
52
0 79.4 1.0
13 0 0
/u03/oracle/data/felixABCvcslgfldx0102.dbf
52
0 52.5 1.0
13 0 0
/u03/oracle/data/felixABCvcslgfldx0103.dbf
52
0 52.5 1.0
13 0 0
ABCVCSLGREC
/u03/oracle/data/felixABCvcslgrec01.dbf
52
0 79.4 1.0
13 0 0
ABCVCSLGRECX01
/u03/oracle/data/felixABCvcslgrecx0101.dbf
52
0 79.4 1.0
13 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
ABCVCSLGRECX02
/u03/oracle/data/felixABCvcslgrecx0201.dbf
52
0 78.8 1.0
13 0 0
ABCVCSLGRECX03
/u03/oracle/data/felixABCvcslgrecx0301.dbf
52
0 78.8 1.0
13 0 0
ABCVCSLGRECX04
/u03/oracle/data/felixABCvcslgrecx0401.dbf
52
0 52.5 1.0
13 0 0
ABCVCSLGRECXPK
/u03/oracle/data/felixABCvcslgrecxpk01.dbf
52
0 52.5 1.0
13 0 0
ABCWORK
/u03/oracle/data/felixABCwork01.dbf
52
0 56.0 1.0
13 0 0
OSMDATA
/u03/oracle/data/felixosmdata01.dbf
55
0 29.1 1.0
13 0 0
PACKSELLUSAG
/u03/oracle/data/felixpacksellusag01.dbf
19,055 5 15.4 1.0 9,694 2
34 5.3
PACKSELLXPK
/u03/oracle/data/felixpacksellxpk01.dbf
7,043 2 14.5 1.0 543 0
221 0.1
PERFSTAT
/u03/oracle/data/felixperfstat01.dbf
17,263 4 15.2 1.1 772
0 0
/u03/oracle/data/felixperfstat02.dbf
15,582 4 16.1 1.1 830 0 0
/u03/oracle/data/felixperfstat03.dbf
9,509 2 15.8 1.1 405 0 0
PREVSTATS
/u03/oracle/data/felixprevstats01.dbf
52
0 78.8 1.0
13 0 0
RESARCHIVE
/u03/oracle/data/felixresarchive01.dbf
136
0 36.5 1.9
15 0 0
RESARCHIVEXN1
/u03/oracle/data/felixresarchivexn101.dbf
71
0 73.1 1.0
15 0 0
RESARCHIVEXN2
/u03/oracle/data/felixresarchivexn201.dbf
58
0 72.2 1.0
15 0 0
RESARCLNK
/u03/oracle/data/felixresarclnk01.dbf
159
0 28.4 1.0
23 0 0
RESARCLNKXF1
/u03/oracle/data/felixresarclnkxf101.dbf
269
0 28.9 1.0
26 0 0
RESARCLNKXPK
/u03/oracle/data/felixresarclnkxpk01.dbf
78
0 61.8 1.0
25 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
RESCOMMDTL
/u03/oracle/data/felixrescommdtl01.dbf
13,150 3 16.1 1.0 2,312 1
22 13.2
RESCOMMDTLXPK
/u03/oracle/data/felixrescommdtlxpk01.dbf
1,249 0 18.3 1.0 1,216 0 0
RESCOMPO /u03/oracle/data/felixrescompo01.dbf
13,648 3 16.9 1.0 2,712 1
20 18.0
RESCOMPOCOS
/u03/oracle/data/felixrescompocos01.dbf
10,843 3 15.2 1.0 1,796 0 0
RESCOMPOX01
/u03/oracle/data/felixrescompox0101.dbf
3,431 1 17.9 1.0 1,755 0 1 0.0
RESCOMPOX02
/u03/oracle/data/felixrescompox0201.dbf
3,433 1 17.5 1.0 2,217
1 0
RESCOMPOX03
/u03/oracle/data/felixrescompox0301.dbf
9,988 3 17.0 1.0 1,522 0
13 13.8
RESCOMPOXF1
/u03/oracle/data/felixrescompoxf101.dbf
2,371 1 17.0 1.0 1,664 0 2 15.0
RESCOMPOXF2
/u03/oracle/data/felixrescompoxf201.dbf
3,509 1 17.4 1.0 3,132 1 1 10.0
RESCOMPOXF3
/u03/oracle/data/felixrescompoxf301.dbf
3,295 1 17.4 1.0 2,939 1 1 0.0
RESCOMPOXPK
/u03/oracle/data/felixrescompoxpk01.dbf
820
0 17.7 1.0 913 0 2 0.0
/u03/oracle/data/felixrescompoxpk02.dbf
992
0 17.9 1.0 780 0 0
RESEVENT
/u03/oracle/data/felixresevent01.dbf
16,224 4 15.4 7.9 463 0 0
RESGPARAM
/u03/oracle/data/felixresgparam01.dbf
8,109 2 17.9 1.0 151 0
35 17.4
/u03/oracle/data/felixresgparam02.dbf
9,679 2 17.4 1.0 610 0
39 19.0
RESGPARAMX01
/u03/oracle/data/felixresgparamx0101.dbf
1,330 0 18.6 1.0 166 0 1 10.0
/u03/oracle/data/felixresgparamx0102.dbf
1,516 0 17.6 1.0 207 0 4 20.0
RESGPARAMXF1
/u03/oracle/data/felixresgparamxf101.dbf
1,313 0 13.8 1.0 1,232 0 1 0.0
/u03/oracle/data/felixresgparamxf102.dbf
2,656 1 11.7 1.0 2,670 1 1 10.0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
RESGPARAMXF2
/u03/oracle/data/felixresgparamxf201.dbf
16,315 4 17.1 1.0 265 0
81 14.4
RESGPARAMXPK
/u03/oracle/data/felixresgparamxpk01.dbf
626
0 19.1 1.0 201 0 0
RESGUEST
/u03/oracle/data/felixresguest01.dbf
167,377 42 8.8 1.2 676
0
33,987 12.6
RESGUESTX01
/u03/oracle/data/felixresguestx0101.dbf
130,814 33 8.8 1.0 105
0
742 9.2
RESHEADER
/u03/oracle/data/felixresheader01.dbf
495,815 125 7.2 1.8
1,741 0 28,474 7.5
RESHISTTREE
/u03/oracle/data/felixreshisttree01.dbf
3,844 1 16.2 1.0 572 0 5 18.0
RESHISTTREEX01
/u03/oracle/data/felixreshisttreex0101.dbf
325,349 82 7.9 1.0 388
0
0
RESHISTTREEX02
/u03/oracle/data/felixreshisttreex0201.dbf
98
0 38.6 1.0
68 0 0
RESHISTTREEXPK
/u03/oracle/data/felixreshisttreexpk01.dbf
3,604 1 16.1
1.0
69 0
7 17.1
RESHISTTRN
/u03/oracle/data/felixreshisttrn01.dbf
9,506 2 16.3 1.0
13 0
47 11.9
/u03/oracle/data/felixreshisttrn02.dbf
10,832 3 15.9 1.0 1,313 0
66 10.3
RESHISTTRNX01
/u03/oracle/data/felixreshisttrnx0101.dbf
4,610 1 16.5 1.0 2,665 1 2 5.0
RESHISTTRNX02
/u03/oracle/data/felixreshisttrnx0201.dbf
161
0 30.7 1.0
87 0 0
RESHISTTRNXPK
/u03/oracle/data/felixreshisttrnxpk01.dbf
155
0 29.5 1.0
76 0 0
RESHISTVAL
/u03/oracle/data/felixreshistval01.dbf
1,222 0 18.2 1.0
13 0 7 17.1
/u03/oracle/data/felixreshistval02.dbf
828
0 20.8 1.0 13
0 6 20.0
/u03/oracle/data/felixreshistval03.dbf
1,018 0 18.6 1.0
13 0 6 13.3
/u03/oracle/data/felixreshistval04.dbf
742
0 21.1 1.0
13 0 3 13.3
/u03/oracle/data/felixreshistval05.dbf
1,377 0 17.6 1.0
13 0 5 26.0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
RESHISTVAL
/u03/oracle/data/felixreshistval06.dbf
2,636 1 15.0
1.0 1,260
0 12 17.5
/u03/oracle/data/felixreshistval07.dbf
1,049 0 18.1 1.0
13 0 5 16.0
/u03/oracle/data/felixreshistval08.dbf
833
0 19.6 1.0
13 0 4 27.5
/u03/oracle/data/felixreshistval09.dbf
1,219 0 17.9 1.0
14 0 7 14.3
/u03/oracle/data/felixreshistval10.dbf
1,376 0 17.3 1.0
14 0 9 21.1
/u03/oracle/data/felixreshistval11.dbf
1,186 0 18.2 1.0
14 0
20 23.0
RESHISTVALX01
/u03/oracle/data/felixreshistvalx0101.dbf
4,819 1 15.3 1.0
18 0
35 18.3
/u03/oracle/data/felixreshistvalx0102.dbf
5,561 1 16.5 1.0
16
0 48 16.3
/u03/oracle/data/felixreshistvalx0103.dbf
5,466 1 16.3 1.0
17 0
57 15.8
/u03/oracle/data/felixreshistvalx0104.dbf
4,765 1 15.5 1.0
13 0
47 17.0
/u03/oracle/data/felixreshistvalx0105.dbf
5,567 1 16.0 1.0 610 0
57 15.8
/u03/oracle/data/felixreshistvalx0106.dbf
4,436 1 15.7 1.0 444 0
25 17.6
RESHISTVALX02
/u03/oracle/data/felixreshistvalx0201.dbf
612
0 19.9 1.0
1,011 0 2 45.0
/u03/oracle/data/felixreshistvalx0202.dbf
580
0 23.3 1.0 211 0 0
/u03/oracle/data/felixreshistvalx0203.dbf
543
0 21.3 1.0
192
0 0
/u03/oracle/data/felixreshistvalx0204.dbf
555
0 23.5 1.0 272 0 0
/u03/oracle/data/felixreshistvalx0205.dbf
736
0 19.2 1.0 343 0 0
/u03/oracle/data/felixreshistvalx0206.dbf
1,413 0 16.6 1.0 931 0 0
RESINVCANC
/u03/oracle/data/felixresinvcanc01.dbf
156 0 29.4 1.0
63 0 0
/u03/oracle/data/felixresinvcanc02.dbf
217
0 31.1 1.0 111 0 0
RESINVCANCX01
/u03/oracle/data/felixresinvcancx0101.dbf
591
0 19.8 1.0 462 0 0
RESINVCANCX02
/u03/oracle/data/felixresinvcancx0201.dbf
402
0 22.1 1.0 155 0 0
RESINVCANCX03 /u03/oracle/data/felixresinvcancx0301.dbf
263
0 22.9 1.0 135 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
RESINVCANCX04
/u03/oracle/data/felixresinvcancx0401.dbf
2,695 1 16.8 1.0 132 0 0
RESINVCANCXF1
/u03/oracle/data/felixresinvcancxf101.dbf
184
0 23.9 1.0 116 0 0
RESINVCANCXPK
/u03/oracle/data/felixresinvcancxpk01.dbf
102
0 29.9 1.0
75 0 0
RESINVITEM
/u03/oracle/data/felixresinvitem01.dbf
16,729 4 17.5 1.0 2,810 1
10 10.0
/u03/oracle/data/felixresinvitem02.dbf
17,450 4 16.9 1.0 3,035 1
12 9.2
RESINVITEMX01
/u03/oracle/data/felixresinvitemx0101.dbf
19,811 5 16.5 1.0 16,277 4
37 10.3
RESINVITEMX02
/u03/oracle/data/felixresinvitemx0201.dbf
2,333 1 18.5 1.0 1,396 0 0
/u03/oracle/data/felixresinvitemx0202.dbf
2,037 1 17.6 1.0 1,252 0 1 0.0
RESINVITEMX03
/u03/oracle/data/felixresinvitemx0301.dbf
2,160 1 17.8 1.0 1,260 0 0
/u03/oracle/data/felixresinvitemx0302.dbf
2,281 1 17.6 1.0 1,320 0 0
RESINVITEMX04
/u03/oracle/data/felixresinvitemx0401.dbf
1,575 0 18.0 1.0 1,117 0 0
/u03/oracle/data/felixresinvitemx0402.dbf
2,107 1 18.0 1.0 1,573 0 0
RESINVITEMX05
/u03/oracle/data/felixresinvitemx0501.dbf
1,912 0 17.5 1.0 990 0 0
/u03/oracle/data/felixresinvitemx0502.dbf
2,676 1 17.8 1.0 1,704 0 2 0.0
RESINVITEMX06
/u03/oracle/data/felixresinvitemx0601.dbf
5,580 1 17.3 1.0 4,152 1 0
/u03/oracle/data/felixresinvitemx0602.dbf
5,551 1 16.7 1.0 3,912 1 0
RESINVITEMX07
/u03/oracle/data/felixresinvitemx0701.dbf
4,525 1 17.2 1.0 3,764 1 0
/u03/oracle/data/felixresinvitemx0702.dbf
4,898 1 17.1 1.0 3,906 1 0
RESINVITEMX08
/u03/oracle/data/felixresinvitemx0801.dbf
2,254 1 18.8 1.0 1,195 0 0
/u03/oracle/data/felixresinvitemx0802.dbf
2,504 1 17.8 1.0 1,278 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
RESINVITEMX09
/u03/oracle/data/felixresinvitemx0901.dbf
44,234 11 16.4 1.0 37,286
9
105 14.0
RESINVITEMX10
/u03/oracle/data/felixresinvitemx1001.dbf
28,618 7 15.7 1.0 27,059 7
107 14.9
RESINVITEMXF1
/u03/oracle/data/felixresinvitemxf101.dbf
11,039 3 16.5 1.0 2,211 1 0
RESINVITEMXF2
/u03/oracle/data/felixresinvitemxf201.dbf
3,501 1 17.7 1.0 2,408 1 3 0.0
RESINVITEMXF3
/u03/oracle/data/felixresinvitemxf301.dbf
27,168 7 17.0 1.0 2,009 1
17 11.8
RESINVITEMXF4 /u03/oracle/data/felixresinvitemxf401.dbf
5,235 1 15.7 1.0 4,833 1 1 20.0
RESINVITEMXPK
/u03/oracle/data/felixresinvitemxpk01.dbf
3,208 1 16.1 1.0 1,172 0 9 0.0
/u03/oracle/data/felixresinvitemxpk02.dbf
2,967 1 16.4 1.0 1,122 0 5 0.0
RESPACKAGE
/u03/oracle/data/felixrespackage01.dbf
118,574 30 10.1 1.0 519 0
164 12.7
RESPACKAGEX01
/u03/oracle/data/felixrespackagex0101.dbf
3,567 1 16.4 1.0 139 0 2 10.0
RESPARAM
/u03/oracle/data/felixresparam01.dbf
32,314 8 16.7 1.0 905 0
121 16.0
RESPARAMX01
/u03/oracle/data/felixresparamx0101.dbf
6,651 2 14.1 1.0 5,121 1 0
RESPARAMX02
/u03/oracle/data/felixresparamx0201.dbf
25,111 6 16.6 1.0 189 0
40 15.0
/u03/oracle/data/felixresparamx0202.dbf
26,472 7 16.5 1.0 613 0
81 11.1
RESPARAMXF1
/u03/oracle/data/felixresparamxf101.dbf
3,556 1 10.9 1.0 3,694 1 0
RESPARAMXPK
/u03/oracle/data/felixresparamxpk01.dbf
6,776 2 15.4 1.0 309
0 0
RESPROMO
/u03/oracle/data/felixrespromo01.dbf
19,402 5 16.0 1.0 2,219 1
178 14.4
RESPROMOXPK
/u03/oracle/data/felixrespromoxpk01.dbf
3,529 1 16.7 1.0 1,381 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
RESSHIPREQ
/u03/oracle/data/felixresshipreq01.dbf
111,602 28 10.6 1.0 689
0
33 15.5
SAWWARE
/u03/oracle/data/felixseaware01.dbf
13
0 93.8 1.0
13 0 0
SAWWARE2
/u03/oracle/data/felixseaware201.dbf
52
0 78.3 1.0
13 0 0
/u03/oracle/data/felixseaware202.dbf
53
0 16.2 1.0
13 0 0
SAWWEBIDX
/u03/oracle/data/felixseawebidx01.dbf
52
0 78.5 1.0
13 0 0
SAWWEBTBL
/u03/oracle/data/felixseawebtbl01.dbf
52
0 78.7 1.0
13 0 0
SELLIMRPSQL
/u03/oracle/data/felixsellimrpsql01.dbf
41
0 43.9 1.0
32 0 0
/u03/oracle/data/felixsellimrpsql02.dbf
52
0 57.5 1.0
13 0 0
SELLIMRPSQLXPK
/u03/oracle/data/felixsellimrpsqlxpk01.dbf
81
0 59.4 1.0
20 0 0
SURVEYDATA
/u03/oracle/data/felixsurveydata01.dbf
13
0 93.8 1.0
13 0 0
SURVEYHEADR
/u03/oracle/data/felixsurveyheadr01.dbf
17
0 75.9 1.0
15 0 0
SYSTEM
/u03/oracle/data/felixsystem01.dbf
44,213 11 10.4 3.1 6,659
2
580 12.4
TBMEDIUM01
/u03/oracle/data/felixtbmedium0101.dbf
26,781 7 11.8 1.0 3,890 1
133 9.2
TBMEDIUM02
/u03/oracle/data/felixtbmedium0201.dbf
140,409 35 9.3 1.6
4,372 1 73,311 8.5
TBMEDIUM03
/u03/oracle/data/felixtbmedium0301.dbf
107,157 27 8.5 2.1
9,071 2 2,635 6.3
TBMEDIUM04
/u03/oracle/data/felixtbmedium0401.dbf
17,925 5 13.6 2.2 656 0 9 7.8
/u03/oracle/data/felixtbmedium0402.dbf
16,284 4 13.5 2.3 1,471
0 10 6.0
TBMEDIUM05
/u03/oracle/data/felixtbmedium0501.dbf
13
0 94.6 1.0
13 0 0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
TBSMALL01
/u03/oracle/data/felixtbsmall0101.dbf
77,742 20 11.2 6.2 21,251
5
1,977 11.4
TBSMALL02
/u03/oracle/data/felixtbsmall0201.dbf
127,931 32 10.2 2.5 68,749 17
441 3.2
TBSMALL03
/u03/oracle/data/felixtbsmall0301.dbf
147,255 37
10.9
3.1
11,830 3
323 6.7
TBSMALL04
/u03/oracle/data/felixtbsmall0401.dbf
62,304 16 9.7 1.6
3,877 1 7,434 10.0
TBSMALL05
/u03/oracle/data/felixtbsmall0501.dbf
52
0 79.0 1.0
13 0 0
TBSMALLONG01
/u03/oracle/data/felixtbsmallong0101.dbf
3,733 1 11.5 1.0
13 0 0
TBTINY01
/u03/oracle/data/felixtbtiny0101.dbf
36,354 9 8.0 2.4
5,672 1
541 3.1
TBTINY02
/u03/oracle/data/felixtbtiny0201.dbf
13
0 94.6 1.0
13 0 0
TEMP
/u03/oracle/data/felixtemp01.dbf
3,782 1 188.4 3.1 4,771 1 0
TMPGLTRANSU
/u03/oracle/data/felixtmpgltransu01.dbf
52
0 56.0 1.0
13 0 0
TMPGLTRANSUXPK
/u03/oracle/data/felixtmpgltransuxpk01.dbf
52
0 55.8 1.0
13 0 0
TOOLS
/u03/oracle/data/felixtools01.dbf
977
0 12.6 1.1 689 0 4 0.0
UNDOTBS1
/u03/oracle/data/felixundotbs101.dbf
72,851 18 8.8 1.0
92,967 23 2,874 6.4
/u03/oracle/data/felixundotbs102.dbf
68,480 17 10.4 1.0 58,384 15 2,715 8.2
/u03/oracle/data/felixundotbs103.dbf
72,445 18 9.5 1.0
66,830 17 5,529 6.8
/u03/oracle/data/felixundotbs104.dbf
52,406 13 8.8 1.0
59,147 15 3,165 7.5
UNDOTBS2
/u03/oracle/data/felixundotbs201.dbf
52
0 70.2 1.0
13 0 0
/u03/oracle/data/felixundotbs202.dbf
52
0 56.7 1.0
13 0 0
/u03/oracle/data/felixundotbs203.dbf
52
0 56.5 1.0
13 0 0
/u03/oracle/data/felixundotbs204.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
51
0 62.9 1.0
14 0 0
USERS
/u03/oracle/data/felixusers01.dbf
13
0 94.6 1.0
13 0 0
VCSLGFLDX01
/u03/oracle/data/felixvcslgfldx0101.dbf
70 0 38.3 1.0
13 0 0
/u03/oracle/data/felixvcslgfldx0102.dbf
70
0 38.3 1.0
13 0 0
/u03/oracle/data/felixvcslgfldx0103.dbf
70
0 38.4 1.0
14 0 0
/u03/oracle/data/felixvcslgfldx0104.dbf
69
0 44.1 1.0
13 0 0
/u03/oracle/data/felixvcslgfldx0105.dbf
56
0 28.9 1.0
13 0 0
/u03/oracle/data/felixvcslgfldx0106.dbf
66
0 55.9 1.0
13 0 0
/u03/oracle/data/felixvcslgfldx0107.dbf
68
0 54.7 1.0
13 0 0
/u03/oracle/data/felixvcslgfldx0108.dbf
56
0 28.6 1.0
13 0
0
/u03/oracle/data/felixvcslgfldx0109.dbf
69
0 24.5 1.0
13 0 0
/u03/oracle/data/felixvcslgfldx0110.dbf
929
0 14.3 1.0
1,587 0
63 0.0
VCSLOGFLD
/u03/oracle/data/felixvcslogfld01.dbf
54
0 54.1 1.0
13 0 0
/u03/oracle/data/felixvcslogfld02.dbf
67
0 57.2 1.0
14 0 0
/u03/oracle/data/felixvcslogfld03.dbf
68
0 56.2 1.0
13 0 1 20.0
/u03/oracle/data/felixvcslogfld04.dbf
67
0 57.3 1.0
14 0 2 15.0
/u03/oracle/data/felixvcslogfld05.dbf
66
0 58.0 1.0
13 0 0
/u03/oracle/data/felixvcslogfld06.dbf
68
0 56.2 1.0
13 0 0
/u03/oracle/data/felixvcslogfld07.dbf
59
0 52.9 1.0
16 0 0
/u03/oracle/data/felixvcslogfld08.dbf
1,633 0 15.3 1.0 2,001 1
21 8.1
/u03/oracle/data/felixvcslogfld09.dbf
332
0 18.5 1.0
1,317 0 2 5.0
/u03/oracle/data/felixvcslogfld10.dbf
53
0 60.0 1.0
14 0 0
/u03/oracle/data/felixvcslogfld11.dbf
70
0 48.9 1.0
14 0 0
/u03/oracle/data/felixvcslogfld12.dbf
71
0 38.2 1.0
14 0 0
VCSLOGFLDX02
/u03/oracle/data/felixvcslogfldx0201.dbf
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
426
0 13.1 1.0 368 0 5 14.0
VCSLOGFLDX02
/u03/oracle/data/felixvcslogfldx0202.dbf
451
0 15.1 1.0 336 0
12 11.7
/u03/oracle/data/felixvcslogfldx0203.dbf
896
0 13.2 1.0 543 0 3 6.7
/u03/oracle/data/felixvcslogfldx0204.dbf
966
0 11.7 1.0 575 0 2 25.0
/u03/oracle/data/felixvcslogfldx0205.dbf
4,881 1 6.9 1.0 8,888 2
15 4.0
/u03/oracle/data/felixvcslogfldx0206.dbf
1,918 0 8.8 1.0
4,572 1 3 10.0
/u03/oracle/data/felixvcslogfldx0207.dbf
890
0 11.5 1.0
2,236 1 7 8.6
/u03/oracle/data/felixvcslogfldx0208.dbf
54
0 16.3 1.0
13 0 0
VCSLOGREC
/u03/oracle/data/felixvcslogrec01.dbf
37,238 9 15.5 15.4
14 0 0
/u03/oracle/data/felixvcslogrec02.dbf
42,134 11 14.7 13.7 1,762
0
1 0.0
/u03/oracle/data/felixvcslogrec03.dbf
37,147 9 15.5 15.3
14 0 0
/u03/oracle/data/felixvcslogrec04.dbf
28,577 7 15.8 9.4
14 0 0
VCSLOGRECX01
/u03/oracle/data/felixvcslogrecx0101.dbf
17,354 4 9.9 1.0
17 0 0
/u03/oracle/data/felixvcslogrecx0102.dbf
16,680 4 10.1 1.0 215 0 1 0.0
/u03/oracle/data/felixvcslogrecx0103.dbf
17,517 4 9.3 1.0 479 0 4 0.0
/u03/oracle/data/felixvcslogrecx0104.dbf
16,965 4 9.4 1.0 154
0 2 0.0
VCSLOGRECX02
/u03/oracle/data/felixvcslogrecx0201.dbf
2,016 1 15.9 1.0 1,498 0 2 10.0
/u03/oracle/data/felixvcslogrecx0202.dbf
1,935 0 17.0 1.0 1,312 0 0
/u03/oracle/data/felixvcslogrecx0203.dbf
2,172 1 17.0 1.0 1,732 0 1 0.0
VCSLOGRECX03 /u03/oracle/data/felixvcslogrecx0301.dbf
1,207 0 16.6 1.0 932 0 0
/u03/oracle/data/felixvcslogrecx0302.dbf
1,284 0 15.2 1.0 1,077 0 0
/u03/oracle/data/felixvcslogrecx0303.dbf
760
0 17.7 1.0 471 0 0
VCSLOGRECX04
/u03/oracle/data/felixvcslogrecx0401.dbf
16,829 4 2.6 1.0
1,049 0 1 0.0
/u03/oracle/data/felixvcslogrecx0402.dbf
17,947 5 2.5 1.0
1,378 0 2 0.0
File IO Stats for DB: FELIX Instance: felix
Snaps: 49836 -49846
->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)
-------------- ------- ------ ------- ------------
-------- ---------- ------
VCSLOGRECX04
/u03/oracle/data/felixvcslogrecx0403.dbf
19,022 5 2.3 1.0 615 0 0
/u03/oracle/data/felixvcslogrecx0404.dbf
19,015 5 2.3 1.0 875 0 0
VCSLOGRECXPK
/u03/oracle/data/felixvcslogrecxpk01.dbf
295
0 22.0 1.0 341 0 3 0.0
/u03/oracle/data/felixvcslogrecxpk02.dbf
51
0 63.1 1.0
14 0 0
/u03/oracle/data/felixvcslogrecxpk03.dbf
59
0 55.6 1.0
14 0 0
/u03/oracle/data/felixvcslogrecxpk04.dbf
60
0 43.3 1.0
14 0 0
-------------------------------------------------------------
Buffer Pool Statistics for DB: FELIX Instance: felix Snaps: 49836 -49846
-> Standard block size Pools D: default, K:
keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k,
16k, 32k
Free Write Buffer
Number of Cache Buffer Physical Physical
Buffer Complete
Busy
P Buffers Hit %
Gets
Reads
Writes Waits Waits Waits
--- ---------- ----- ----------- ----------- ----------
------- -------- ------
D 297,750 97.3 484,403,798
13,204,506 1,010,435 0 0
655,655
K 75,430 99.9 209,420,320 303,089 26,347 0
0 81,233
R 37,715 52.6 7,948,680
3,765,565
1,606 0 0 201,134
-------------------------------------------------------------
Instance Recovery Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
-> B: Begin snapshot, E: End snapshot
Targt
Estd
Log File Log Ckpt Log Ckpt
MTTR MTTR Recovery Actual Target Size Timeout Interval
(s) (s) Estd IOs Redo Blks Redo Blks Redo
Blks Redo Blks Redo Blks
- ----- ----- ---------- ---------- ---------- ----------
---------- ----------
B
105 18 21784 461836 460800 460800 1353714
E
105 19 25020 463910 460800 460800 1138798
-------------------------------------------------------------
Buffer Pool Advisory for DB: FELIX Instance: felix End Snap: 49846
-> Only rows with estimated physical reads >0 are
displayed
-> ordered by Block Size, Buffers For Estimate
Size for Size Buffers for Est Physical Estimated
P
Estimate (M) Factr Estimate Read Factor Physical Reads
--- ------------ ----- ---------------- -------------
------------------
R
32 .1
3,970 1.44
18,237,819
K
64 .1
7,940 438.04
448,333,921
R
64 .2
7,940 1.42
18,019,590
R
96 .3
11,910 1.41
17,779,325
K
128 .2
15,880 317.34
324,795,434
R
128 .4
15,880 1.31
16,546,306
R
160 .5
19,850 1.12
14,149,658
K
192 .3
23,820 224.50
229,777,253
R
192 .6
23,820 1.06
13,462,471
R
224 .7
27,790 1.04
13,176,997
D
240 .1
29,775 4.28
498,316,761
K
256 .4
31,760 143.30
146,673,569
R
256 .8
31,760 1.02
12,916,394
R
288 .9
35,730 1.01
12,733,817
R
304 1.0
37,715 1.00
12,654,050
K
320 .5
39,700 94.45 96,673,967
R
320 1.1
39,700 0.99
12,575,017
R
352 1.2
43,670 0.98
12,423,313
K
384 .6
47,640 48.58
49,726,575
R
384 1.3
47,640 0.97
12,293,775
R
416 1.4
51,610 0.96
12,196,506
K
448 .7
55,580 23.99
24,552,037
R
448 1.5
55,580 0.96
12,102,921
R
480 1.6
59,550 0.95
12,017,973
D
480 .2
59,550 3.22
374,171,430
K
512 .8
63,520 9.56 9,784,980
R
512 1.7
63,520 0.94
11,938,537
R
544 1.8
67,490 0.94
11,862,714
K
576 .9
71,460 2.00 2,051,694
R
576 1.9
71,460 0.93 11,790,432
K
608 1.0
75,430 1.00 1,023,508
R
608 2.0
75,430 0.93
11,718,797
K
640 1.1
79,400 0.48
492,544
R
640 2.1
79,400 0.92
11,656,402
K
704 1.2
87,340 0.18
179,709
D
720 .3
89,325 2.46
285,897,914
K
768 1.3
95,280 0.03
29,363
K
832 1.4 103,220 0.02
23,517
K
896 1.5 111,160 0.02
23,517
K
960 1.6 119,100 0.02
23,517
D
960 .4
119,100 1.98
229,886,873
K 1,024 1.7 127,040 0.02
23,517
K 1,088 1.8 134,980 0.02
23,517
K 1,152 1.9 142,920 0.02
23,517
D 1,200 .5 148,875 1.66
193,520,924
K 1,216 2.0 150,860 0.02
23,517
K 1,280 2.1 158,800 0.02
23,517
D 1,440 .6 178,650 1.46
169,322,566
D 1,680 .7 208,425 1.30
151,740,242
D 1,920 .8 238,200 1.18
137,516,281
D 2,160 .9 267,975 1.08
125,908,637
D 2,400 1.0 297,750 1.00
116,358,957
D 2,640 1.1 327,525 0.93
108,275,353
Buffer Pool Advisory for DB: FELIX Instance: felix End Snap: 49846
-> Only rows with estimated physical reads >0 are
displayed
-> ordered by Block Size, Buffers For Estimate
Size for Size Buffers for Est Physical Estimated
P
Estimate (M) Factr Estimate Read Factor Physical Reads
--- ------------ ----- ---------------- -------------
------------------
D 2,880 1.2 357,300 0.87
101,254,801
D 3,120 1.3 387,075 0.82
95,499,697
D 3,360 1.4 416,850 0.78
90,509,974
D 3,600 1.5 446,625 0.74
86,261,831
D 3,840 1.6 476,400 0.71
82,550,424
D 4,080 1.7 506,175 0.68 79,420,388
D 4,320 1.8 535,950 0.66
76,728,206
D 4,560 1.9 565,725 0.64
74,331,147
D 4,800 2.0 595,500 0.62
72,053,901
-------------------------------------------------------------
Buffer wait Statistics for DB: FELIX Instance: felix Snaps: 49836 -49846
-> ordered by wait time desc, waits desc
Tot Wait Avg
Class
Waits Time (s) Time
(ms)
------------------ ----------- ---------- ---------
data block
918,663
9,712
11
undo block
13,800 100
7
1st level bmb
40 0
4
2nd level bmb
23 0
6
segment header
6 0
8
undo header
491 0
0
-------------------------------------------------------------
PGA Aggr Target Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
-> B: Begin snap E: End snap (rows dentified with B or E contain data
which
is absolute i.e. not diffed over the interval)
-> PGA cache hit % - percentage of W/A (WorkArea) data
processed only in-memory
-> Auto PGA Target - actual workarea memory target
-> W/A PGA Used - amount of memory used for all Workareas
(manual + auto)
-> %PGA W/A Mem - percentage of PGA memory allocated to
workareas
-> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem
Mgmt
-> %Man W/A Mem - percentage of workarea memory under manual
control
PGA Cache Hit % W/A MB Processed Extra W/A MB
Read/Written
--------------- ----------------
-------------------------
99.5 102,809
465
%PGA %Auto %Man
PGA
Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A
Global Mem
Target(M)
Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
- --------- --------- ---------- ---------- ------ ------
------ ----------
B
2,000 542 2,511.0
119.4 4.8 100.0 .0
102,400
E
2,000 187 3,114.6
189.3 6.1 100.0 .0
23,235
-------------------------------------------------------------
PGA Aggr Target Histogram for DB: FELIX Instance: felix Snaps: 49836 -49846
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass
Execs
------- ------- -------------- ------------- ------------
------------
8K
16K
6,239,075
6,239,075
0
0
16K
32K 49,331
49,331
0
0
32K
64K 6,606
6,606
0
0
64K 128K 4,033
4,033
0
0
128K 256K
292
292
0
0
256K 512K
173
173
0
0
512K 1024K 18,186
18,186
0
0
1M
2M 6,458
6,458
0
0
2M
4M
713
713
0
0
4M
8M
445
445
0
0
8M
16M
15
15
0
0
16M
32M
375
374
1
0
32M
64M
2
2
0
0
64M 128M
2
0
2
0
256M 512M
1
0
1
0
-------------------------------------------------------------
PGA Memory Advisory for DB: FELIX Instance: felix End Snap: 49846
-> When using Auto Memory Mgmt, minimally choose a
pga_aggregate_target value
where
Estd PGA Overalloc Count is 0
Estd Extra Estd
PGA Estd PGA
PGA Target Size W/A
MB W/A MB Read/ Cache Overalloc
Est
(MB) Factr
Processed Written to Disk Hit % Count
---------- ------- ---------------- ----------------
-------- ----------
250 0.1 389,949.5
22,464.1
95.0
2,639
500 0.3 389,949.5
22,464.1
95.0
2,639
1,000
0.5 389,949.5
13,958.8
97.0 587
1,500
0.8 389,949.5 7,645.0 98.0 186
2,000
1.0 389,949.5
174.1 100.0 0
2,400
1.2 389,949.5
174.1
100.0 0
2,800
1.4 389,949.5
174.1
100.0 0
3,200
1.6 389,949.5
174.1
100.0 0
3,600
1.8 389,949.5
174.1
100.0 0
4,000
2.0 389,949.5
174.1
100.0 0
6,000
3.0 389,949.5
174.1
100.0 0
8,000
4.0 389,949.5
174.1
100.0 0
12,000
6.0 389,949.5
174.1
100.0 0
16,000
8.0 389,949.5
174.1
100.0 0
-------------------------------------------------------------
Enqueue activity for DB: FELIX Instance: felix
Snaps: 49836 -49846
-> Enqueue stats gathered prior to 9i should not be
compared with 9i data
-> ordered by Wait Time desc, Waits desc
Avg Wt Wait
Eq Requests Succ Gets Failed Gets Waits Time (ms) Time (s)
-- ------------ ------------ ----------- -----------
------------- ------------
TX 648,109 648,327 29
5,987 34.09
204
UL 12,941
12,816 125 5 2,510.40
13
HW 20,962
20,953 9
183 21.46
4
SQ 14,054
14,054 0 66
27.88
2
CF 2,498
2,496 1 4
130.25
1
TM
2,994,048
2,994,138 0 1
387.00
0
US
21
21
0 3
23.00
0
-------------------------------------------------------------
Rollback Segment Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->A high value for "Pct Waits" suggests more
rollback segments may be required
->RBS stats may not be accurate between begin and end
snaps when using Auto Undo
managment,
as RBS may be dynamically created and dropped as needed
Trans Table Pct Undo Bytes
RBS No Gets Waits Written
Wraps Shrinks Extends
------ -------------- ------- --------------- --------
-------- --------
0
37.0 0.00
1,428 0
0 0
1
134,012.0
0.00
130,238,536 2
2
0
2
78,194.0
0.00
98,530,610 15 3 8
3
61,961.0
0.01
64,539,958 10 4 3
4
60,569.0
0.01
83,102,836 12 5 3
5
51,227.0
0.00
59,349,168 8
0
4
6
43,053.0
0.00
45,257,576 6
1
1
7
39,703.0
0.00
53,019,716 7
0
1
8
39,659.0
0.00
55,169,950 23 0 2
9
43,223.0
0.00
63,716,334 11 0 5
10 35,313.0 0.00 38,662,232 17
0 0
11
38,087.0
0.00
67,190,512 22 0 1
12
38,978.0
0.00
39,636,746 5
0
1
13
38,049.0
0.00
54,177,402 15 0 1
14
35,805.0
0.00
31,179,824 13 0 0
15
37,772.0
0.00
48,217,772 15 0 2
16
39,104.0
0.00
43,155,738 13 0 0
17 42,667.0 0.00 63,230,766
9 0 5
18
37,185.0
0.00
38,452,706 6
0
1
19
36,028.0
0.00
44,578,902 9
0
1
20
37,896.0
0.00
33,280,426 8
0
0
21
36,767.0
0.00
33,152,906 5
0
1
22
36,676.0
0.00
30,554,142 7
0
0
23
35,913.0
0.00
32,109,106 30 0 0
24
40,930.0
0.00
64,484,288 11 0 5
25
37,350.0
0.00
48,483,458 35 0 3
26
36,234.0
0.00
48,087,862 53 0 53
37
161,880.0
0.00
235,336,528 35 0 35
-------------------------------------------------------------
Rollback Segment Storage for DB: FELIX Instance: felix Snaps: 49836 -49846
->Optimal Size should be larger than Avg Active
RBS No
Segment Size Avg Active Optimal Size Maximum Size
------ --------------- --------------- ---------------
---------------
0 385,024
0
385,024
1 1,748,099,072 40,236,467
2,061,623,296
2
805,429,248 12,555,782
913,432,576
3
442,621,952 7,614,241
499,245,056
4
352,444,416 9,279,313
503,439,360
5 285,335,552
9,536,012
285,335,552
6
284,286,976 7,736,909
334,618,624
7
212,983,808 7,188,040
212,983,808
8
220,323,840 4,611,909
220,323,840
9
249,683,968 11,754,610
249,683,968
10
202,498,048 4,154,675
202,498,048
11
267,509,760 4,216,143
267,509,760
12
184,672,256 7,097,565
184,672,256
13
216,129,536 4,605,214
216,129,536
14
193,060,864 3,759,757
193,060,864
15
186,769,408 5,675,100
186,769,408
16
218,226,688 4,073,567
218,226,688
17
226,615,296 9,013,784
226,615,296
18
192,012,288 7,840,409
201,449,472
19
188,866,560 6,497,596
188,866,560
20
232,906,752 6,823,459
232,906,752
21
185,720,832 6,351,952
185,720,832
22
192,012,288 7,420,372
192,012,288
23
180,346,880 1,790,355
180,346,880
24
257,941,504 7,001,949
257,941,504
25
233,824,256 2,946,647
233,824,256
26
66,052,096 1,151,470 66,052,096
37
395,304,960 7,898,537
395,304,960
-------------------------------------------------------------
Undo Segment Summary for DB: FELIX Instance: felix Snaps: 49836 -49846
-> Undo segment block stats:
-> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
-> eS - expired Stolen,
eR - expired
Released, eU -
expired reUsed
Undo
Undo Num Max Qry Max Tx Snapshot Out of uS/uR/uU/
TS#
Blocks
Trans Len (s) Concurcy Too Old Space eS/eR/eU
---- -------------- ---------- -------- ----------
-------- ------ -------------
1 287,484 ########## 7,531
8 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
-> ordered by Time desc
Undo
Num Max Qry Max
Tx Snap Out of uS/uR/uU/
End Time Blocks Trans Len (s) Concy Too Old Space eS/eR/eU
------------ ------------ -------- ------- --------
------- ------ -------------
09-Oct 11:37 33,659 ######## 1,372 7 0 0 0/0/0/0/0/0
09-Oct 11:27 33,938 ######## 1,152 7 0 0 0/0/0/0/0/0
09-Oct 11:17 39,855 ######## 1,080 8 0 0 0/0/0/0/0/0
09-Oct 11:07 65,539 ######## 2,344 4 0 0 0/0/0/0/0/0
09-Oct 10:57 40,519 ######## 7,531 6 0 0 0/0/0/0/0/0
09-Oct 10:47 38,576 ######## 6,968 6 0 0 0/0/0/0/0/0
09-Oct 10:37 35,398 ######## 6,368 5 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity for DB: FELIX Instance: felix
Snaps: 49836 -49846
->"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 Wait
Pct
Get Get Slps Time
NoWait NoWait
Latch
Requests
Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------
------ ------------ ------
Consistent RBA
183,166 0.0
0
0
FAL request queue
46 0.0 0
0
FIB s.o chain latch
382 0.0
0
0
FOB s.o list latch
471,656
0.1 0.0 0
0
JOX SGA heap latch
35,810 0.0
0
0
SQL memory manager latch
6 0.0
0 1,271 0.0
SQL memory manager worka 705,237 0.0 0.0 0
0
active checkpoint queue 135,645 0.0 0.0 0
1 0.0
alert log latch 92 0.0
0
0
archive control
58,037 0.1 0.0 0
0
archive process latch
217 0.5 0.0 0
0
begin backup scn array
14,346 0.0
0
0
cache buffer handles
1,492,665
0.0 0.0 0
0
cache buffers chains 1,359,579,054 1.2 0.0 0 28,336,594 0.0
cache buffers lru chain 2,383,371 0.1 0.0 0 27,507,080 0.1
channel handle pool latc 115,633 0.1 0.0 0
0
channel operations paren 176,392 0.0 0.0 0
0
checkpoint queue latch 20,350,012 0.0 0.0 0 1,038,638 0.0
child cursor hash table 890,809 0.0 0.0 0
0
commit callback allocati 14,769 0.0
0
0
dml lock allocation
5,724,690
0.5 0.0 0
0
dummy allocation
115,781
0.0 0.0 0
0
enqueue hash chains
42,083,548
0.3 0.0 0
0
enqueues
47,351,939 0.8 0.0 0
0
event group latch
57,906 0.0
0
0
global tx hash mapping
62,771 0.0
0
0
hash table column usage
2,229 0.1 0.0 0 16,332,497 0.0
hash table modification
1 0.0
0
0
job workq parent latch 0
0 144 11.8
job_queue_processes para
254 0.0
0
0
ktm global data
49 0.0
0
0
lgwr LWN SCN
183,242 0.0 0.0 0
0
library cache
234,429,774
0.5 0.0 5 292,280 8.5
library cache load lock 58,654 0.0 0.0 0
0
library cache pin
150,811,901
0.1 0.0 0
0
library cache pin alloca 67,422,178 0.0 0.0
0
0
list of block allocation 136,749 0.0 0.0 0
0
loader state object free 44,634 0.0 0.0 0
0
longop free list parent
3,301 0.0 0.0 0 226 0.0
messages
1,410,593 0.0 0.0 0
0
mostly latch-free SCN
186,393
0.5 0.0 0
0
multiblock read objects 1,561,877 0.0 0.0 0 0
ncodef allocation latch
71 0.0
0
0
object stats modificatio 2,336 0.0
0
0
post/wait queue
340,950 0.0 0.0 0 511,681 0.0
process allocation
57,906 0.1 0.0 0
57,898 0.0
process group creation 115,633 0.0 0.0 0
0
redo allocation
26,652,339
0.3 0.0 0
0
redo copy
0
0 26,286,324 0.0
redo writing
688,810 0.0 0.0 0
0
Latch Activity for DB: FELIX Instance: felix
Snaps: 49836 -49846
->"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 Wait
Pct
Get Get Slps Time
NoWait NoWait
Latch
Requests
Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------
------ ------------ ------
resmgr group change latc 17,196,564 0.0 0.0 0
0
resmgr:actses active lis 115,783 0.0 0.0 0
0
resmgr:actses change gro 57,767 0.0
0
0
resmgr:actses change sta 1,629 0.0
0
0
resmgr:resource group CP 2,290,487 1.2 0.0 0
0
resmgr:schema config 17,137,268 0.0 0.0 0
1,497 0.2
row cache enqueue latch 85,881,645 0.6 0.0 0
0
row cache objects
86,780,037
0.3 0.0 0
16,649 0.6
sequence cache
1,533,238
0.0 0.0 0
0
session allocation
26,745,318
1.2 0.3 43
0
session idle bit
100,592,028
0.0 0.0 0
0
session switching
71 0.0
0
0
session timer
1,500 0.0
0
0
shared java pool
280 0.0
0
0
shared pool
91,301,755 0.3 0.0 5
0
sim partition latch
0
0 8,481 0.0
simulator hash latch 41,409,986 0.0 0.0 0 0
simulator lru latch
1,610,321
0.0 0.0 0 197,386 1.8
sort extent pool
68,218 0.0 0.0 0
0
temp lob duration state
19 0.0
0
0
temporary table state ob
707 0.0
0
0
trace latch
168 0.0
0
0
transaction allocation 124,895 0.0 0.0 0
0
transaction branch alloc 62,842 0.0 0
0
undo global data
3,076,895
0.0 0.0 0
2 0.0
user lock
246,784 0.1 0.0 0
0
-------------------------------------------------------------
Latch Sleep breakdown for DB: FELIX Instance: felix Snaps: 49836 -49846
-> ordered by misses desc
Get
Spin &
Latch Name
Requests
Misses
Sleeps Sleeps 1->4
-------------------------- -------------- -----------
----------- ------------
cache buffers chains 1,359,579,054 16,969,684 107,582 0/0/0/0/0
library cache
234,429,774 1,073,806 4,553
1069565/3983
/220/38/0
enqueues
47,351,939
363,400 2
363398/2/0/0
/0
session allocation
26,745,318 329,719 107,984 221805/10784
5/68/1/0
shared pool
91,301,755
281,809
10,773 271875/9167/
704/63/0
row cache objects
86,780,037
225,428
3 225425/3/0/0
/0
library cache pin allocati 67,422,178 28,534 15
28519/15/0/0
/0
resmgr:resource group CPU 2,290,487 27,607
2 27605/2/0/0/
0
dml lock allocation
5,724,690
26,763
2 26761/2/0/0/
0
session idle bit
100,592,028 9,189 58 0/0/0/0/0
cache buffers lru chain 2,383,371
1,214
13 1201/13/0/0/
0
FOB s.o list latch
471,656 380 6
374/6/0/0/0
user lock
246,784
287 3
284/3/0/0/0
channel handle pool latch 115,633 64
1 0/0/0/0/0
process allocation
57,906 44 1
43/1/0/0/0
-------------------------------------------------------------
Latch Miss Sources for DB: FELIX Instance: felix Snaps: 49836 -49846
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait
Waiter
Latch Name
Where
Misses
Sleeps Sleeps
------------------------ --------------------------
------- ---------- --------
FOB s.o list latch ksfdfol02
0 6 6
cache buffers chains kcbgtcr: kslbegin excl 0 71,374 56,698
cache buffers chains kcbzwb
0
13,575 3,122
cache buffers chains kcbrls: kslbegin
0
9,108 21,082
cache buffers chains kcbgtcr: fast path
0
5,862 18,337
cache buffers chains kcbgtcr: kslbegin shared
0
3,523 3,475
cache buffers chains kcbchg: kslbegin: bufs not 0 1,826 1,718
cache buffers chains kcbchg: kslbegin: call CR
0
126
876
cache buffers chains kcbgcur: kslbegin 0
70
39
cache buffers chains kcbget: pin buffer
0 63 27
cache buffers chains kcbzgb: scan from tail. no 0
62 0
cache buffers chains kcbzib: finish free bufs
0
29 3
cache buffers chains kcbget: exchange rls
0 21 4
cache buffers chains kcbzib: multi-block read:
0
14 0
cache buffers chains kcbibr
0 8 1
cache buffers chains kcbget: exchange
0 6 5
cache buffers chains kcbgtcr
0 6 0
cache buffers chains kcbnlc
0 5 34
cache buffers chains kcbbic2
0 4 0
cache buffers chains kcbcge
0 3 62
cache buffers chains kcbnew
0 2 0
cache buffers chains kcbbxsv
0 1 0
cache buffers lru chain kcbzgb: multiple sets nowa 3,686 11 0
cache buffers lru chain kcbbiop: lru scan
451
2 1
channel handle pool latc ksrchdelete()
0
1 0
cost function
kzulrl
0 3 2
dml lock allocation ktaidm
0 2 0
enqueues
ksqgel: create enqueue 0 1 4
enqueues
ksqies
0 1 2
library cache
kgllkdl: child: cleanup 0
578
227
library cache
kgldte: child 0
0 392 745
library cache
kglupc: child
0 291 573
library cache
kglpndl: child: before pro 0 285 405
library cache
kglpnc: child
0 230 1,008
library cache
kglic
0 218 46
library cache
kglhdgn: child:
0 207 771
library cache
kglpin: child: heap proces 0 167 83
library cache
kglpndl: child: after proc 0 121 32
library cache
kglpnp: child
0 110 271
library cache
kglidp: child
0 94 0
library cache kglhdgc:
child:
0 83 159
library cache
kglobpn: child:
0 52 71
library cache
kglhdiv: child
0 29 0
library cache
kglget: child: KGLDSBRD 0 6 14
library cache
kgldti: 2child
0 5 6
library cache
kglpin
0 2 5
library cache
kglget: child: KGLDSBYD 0 1 12
library cache
kglhdiv0: child
0 1 0
library cache
kglobld
0 1 4
library cache pin alloca kglpnal
0 8 2
library cache pin alloca kgllkdl
0 7 12
process allocation ksucrp
0 1 0
resmgr:resource group CP kgkprrnxt
0
2 2
Latch Miss Sources for DB: FELIX Instance: felix Snaps: 49836 -49846
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait
Waiter
Latch Name
Where
Misses
Sleeps Sleeps
------------------------ --------------------------
------- ---------- --------
row cache objects kqrpfl: not dirty
0 1 0
session allocation ksucri
0
64,478 94,382
session allocation ksuxds: not user session
0
32,885 9,779
session allocation ksufap: active sessions 0 8,037 153
session allocation ksuprc
0
1,385 1,765
session allocation ksudlc
0 533 877
session allocation ksucrp
0 450 607
session allocation ksudlp
0
190
306
session allocation ksuxds: KSUSFCLC not set
0
26
114
session idle bit ksupuc: set
busy
0 30 22
session idle bit ksupuc: clear
busy
0 18 26
session idle bit ksuxds
0 10 10
shared pool
kghfrunp: alloc: wait
0
5,731
357
shared pool
kghupr1
0
4,154 9,685
shared pool
kghfrunp: clatch: wait 0 1,352 121
shared pool
kghalo
0 745 505
shared pool
kghfrunp: clatch: nowait 0
330 0
shared pool
kghfre
0 73 127
shared pool
kghalp
0 51 71
shared pool
kghfen: not perm alloc cla 0 18 22
shared pool
kghfru
0
1 6
-------------------------------------------------------------
Dictionary Cache Stats for DB: FELIX Instance: felix Snaps: 49836 -49846
->"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
Cache
Requests Miss Reqs Miss Reqs Usage
------------------------- ------------ ------ -------
----- -------- ----------
dc_global_oids
4 50.0 0
0
2
dc_histogram_defs
2,649,529
0.8
0
0
4,112
dc_object_ids
19,727,396
0.0
0
0
2,769
dc_objects
700,181 0.6 0
1
2,182
dc_profiles
58,357 0.0 0 0 4
dc_rollback_segments
15,332 0.0 0
6 401
dc_segments
3,119,004 0.1 0
0
2,510
dc_sequences
47,486 0.5 0
47,486 74
dc_tablespace_quotas
228 9.6 0
57 16
dc_tablespaces
10,889,185
0.0
0
0 74
dc_user_grants
398,431 0.1 0
0
123
dc_usernames
1,033,749
0.0
0
1 153
dc_users
4,971,117 0.0 0
80
305
-------------------------------------------------------------
Library Cache Activity for DB: FELIX Instance: felix Snaps: 49836 -49846
->"Pct Misses" should be very low
Get Pct
Pin Pct
Invali-
Namespace
Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------
---------- --------
BODY
232,050
0.0
232,092
0.1 100 0
CLUSTER
960 1.5
987 2.8 0 0
INDEX
1,660 5.6
1,660 5.6 0 0
JAVA DATA
2 0.0
7,248 0.0 0 0
PIPE
83,070 0.2
115,908
0.1 0 0
SQL AREA
12,727,892
0.5
62,158,226
0.3
24,181 5,692
TABLE/PROCEDURE 5,202,421 0.1 14,528,413 0.2 17,845 0
TRIGGER
356,043
0.1
356,062
0.4
1,156 0
-------------------------------------------------------------
SGA Memory Summary for DB: FELIX Instance: felix Snaps: 49836 -49846
SGA regions
Size in Bytes
------------------------------ ----------------
Database Buffers
3,472,883,712
Fixed Size
749,392
Redo Buffers
6,565,888
Variable Size
1,442,840,576
----------------
sum
4,923,039,568
-------------------------------------------------------------
SGA breakdown difference for DB: FELIX Instance: felix Snaps: 49836 -49846
Pool
Name
Begin value End value % Diff
------ ------------------------------ ----------------
---------------- -------
java
free memory
42,946,560 42,913,792 -0.08
java
memory in use
7,385,088 7,417,856 0.44
large free
memory
268,435,456 268,435,456 0.00
shared 1M buffer
1,056,768 1,056,768 0.00
shared Checkpoint queue
41,963,520
41,963,520 0.00
shared DML lock
2,912,872 2,912,872 0.00
shared FileIdentificatonBlock
1,153,752 1,153,752 0.00
shared FileOpenBlock
16,270,720
17,016,928 4.59
shared KGK heap
33,368
33,368 0.00
shared KGLS heap
13,103,376 12,603,632 -3.81
shared KGSK scheduler
3,296,968
3,364,440 2.05
shared KGSKI schedule
13,576
13,576 0.00
shared KQR L PO
5,758,488
5,535,944 -3.86
shared KQR M PO
4,521,728 4,309,128 -4.70
shared KQR S SO
113,856
57,520 -49.48
shared KQR X PO
15,488
15,488 0.00
shared KSXR pending messages que
853,952 853,952 0.00
shared KSXR receive buffers
1,034,000 1,034,000 0.00
shared MTTR advisory
895,552 895,552 0.00
shared PL/SQL DIANA
3,610,528 3,357,312 -7.01
shared PL/SQL MPCODE
11,186,880
10,666,640 -4.65
shared PLS non-lib hp
2,088
2,088 0.00
shared SEQ S.O.
792,720 792,720 0.00
shared Temporary Tables State Ob
1,292,328 1,292,328 0.00
shared UNDO INFO HASH
193,760 193,760 0.00
shared UNDO INFO SEGMENTED ARRAY
1,080,072 1,080,072 0.00
shared branch
1,963,256 1,963,256 0.00
shared channel handle
1,300,960
1,300,960 0.00
shared character set object
292,408
292,408 0.00
shared constraints
1,371,144 1,371,144 0.00
shared db_block_hash_buckets
22,848,144 22,848,144 0.00
shared db_files
241,560 241,560 0.00
shared db_handles
5,800,000 5,800,000 0.00
shared dictionary cache
3,229,952
3,229,952 0.00
shared dummy
448,864 448,864 0.00
shared enqueue
9,126,208 9,126,208 0.00
shared enqueue resources
2,195,408
2,203,696 0.38
shared enqueue_hash
530,160 530,160 0.00
shared errors
1,363,264 1,300,672 -4.59
shared event statistics per sess
61,832,160 61,832,160 0.00
shared fixed allocation callback
2,160
2,160 0.00
shared free memory
164,377,128
320,605,816 95.04
shared joxlod: in ehe
412,136 413,256 0.27
shared joxs heap init
4,240
4,240 0.00
shared krvxrr
253,056 253,056 0.00
shared ksm_file2sga region
148,800
148,800 0.00
shared ktlbk state objects
3,245,480 3,245,480 0.00
shared library cache
172,008,296
182,025,456
5.82
shared log_buffer
204,832 204,832 0.00
shared message pool freequeue
925,160 925,160 0.00
shared messages 1,040,000
1,040,000 0.00
shared miscellaneous
30,011,512
35,664,304 18.84
shared network connections
60,720
60,720 0.00
shared obj htab chunk
655,872 655,872 0.00
SGA breakdown difference for DB: FELIX Instance: felix Snaps: 49836 -49846
Pool
Name
Begin value End value % Diff
------ ------------------------------ ----------------
---------------- -------
shared parameters
400,128 368,264 -7.96
shared processes
6,400,000 6,400,000 0.00
shared qmps connections
2,334,120
2,334,120 0.00
shared replication session stats
1,673,520 1,673,520 0.00
shared session param values
52,108,376 56,835,616 9.07
shared sessions
14,885,520 14,885,520 0.00
shared set_descriptor_array
206,848
206,848 0.00
shared sim memory hea
3,479,400
3,479,400 0.00
shared sim trace entries
1,572,864
1,572,864 0.00
shared sql area
411,772,224 234,112,264 -43.15
shared table definiti
61,728
35,976 -41.72
shared temporary tabl
1,424,848
1,865,864 30.95
shared trace buffer 19,513,344 21,200,896 8.65
shared trace events array
80,000
80,000 0.00
shared transaction
9,964,968 9,964,968 0.00
shared trigger defini
169,344 124,224 -26.64
shared trigger inform
5,272
4,928 -6.53
shared trigger source
3,144
3,464 10.18
shared txncallback
968,584 968,584 0.00
buffer_cache
3,472,883,712
3,472,883,712
0.00
fixed_sga
749,392 749,392 0.00
log_buffer
6,554,624 6,554,624 0.00
-------------------------------------------------------------
init.ora Parameters for DB: FELIX Instance: felix Snaps: 49836 -49846
End value
Parameter Name
Begin value
(if different)
-----------------------------
--------------------------------- --------------
_b_tree_bitmap_plans FALSE
_db_block_hash_latches 32768
_db_file_noncontig_mblock_rea 1
_ignore_desc_in_index TRUE
_library_cache_advice FALSE
aq_tm_processes
0
background_dump_dest /u99/oracle/felix/bdump
compatible
9.2.0.0.0
control_files
/u11/oracle/data/felixcontrol01.ct
core_dump_dest
/u99/oracle/felix/cdump
db_block_size
8192
db_cache_size
2516582400
db_file_multiblock_read_count 32
db_files
1024
db_keep_cache_size
637534208
db_name
felix
db_recycle_cache_size 318767104
db_writer_processes 4
dml_locks
15000
fast_start_mttr_target 300
hash_join_enabled
TRUE
instance_name
felix
java_pool_size
50331648
job_queue_processes 93
large_pool_size
268435456
log_archive_dest_1
location=/u99/oracle/felix/archive
log_archive_format felixarch_%t_%s.arc
log_archive_start
TRUE
log_buffer
6291456
max_dump_file_size
50M
max_enabled_roles
50
nls_date_format
YYYY/MM/DD
open_cursors
705
open_links
4
open_links_per_instance 4
optimizer_index_caching 90
optimizer_index_cost_adj 15
parallel_max_servers 0
parallel_threads_per_cpu 0
pga_aggregate_target 2097152000
processes
5000
query_rewrite_enabled TRUE
remote_login_passwordfile EXCLUSIVE
resource_limit
TRUE
resource_manager_plan normal_plan
shared_pool_size
738197504
sort_area_retained_size 524288
sort_area_size
524288
star_transformation_enabled FALSE
timed_statistics
TRUE
undo_management
AUTO
undo_retention
10800
undo_tablespace
UNDOTBS1
user_dump_dest
/u99/oracle/felix/udump
utl_file_dir
/u99/oracle/output, /u99/felixdata
init.ora Parameters for DB: FELIX Instance: felix Snaps: 49836 -49846
End value
Parameter Name
Begin value
(if different)
-----------------------------
--------------------------------- --------------
workarea_size_policy AUTO
-------------------------------------------------------------
End of Report