| Physical Reads & Logical Reads [message #575045] |
Fri, 18 January 2013 07:55  |
 |
gatetec
Messages: 28
Registered: December 2012
|
Junior Member |
|
|
The applications are running very slow due to high I/O, it seems.
From AWR Report, I see certain TS and Objects are busy and have high I/O.
How do you find out the right settings to get optimal I/O?, and how do you find the causes and their possible solutions?
These questions seem too broad, but I want to get the starting point.
Segments by Logical Reads
Total Logical Reads: 1,780,465,045
Captured Segments account for 88.0% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
V500 I_A_MEDIUM XPKFILL_PRINT_ORD_HX INDEX 407,518,016 22.89
V500 I_R_SMALL XPKGL_ALIAS INDEX 299,203,312 16.80
V500 D_R_SMALL GL_ALIAS TABLE 296,386,688 16.65
V500 D_A_SMALL PFT_EVENT_OCCUR_LOG TABLE 129,661,968 7.28
V500 D_R_MEDIUM FREQUENCY_SCHEDULE TABLE 65,614,048 3.69
Segments by Physical Reads
Total Physical Reads: 3,691,333
Captured Segments account for 71.6% of Total
Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
V500 D_ENCOUNTER0077 ENCOUNTER TABLE 1,478,710 40.06
V500 D_A_MEDIUM ENCNTR_INFO TABLE 362,832 9.83
V500 D_CLINICAL_EVE1333 CLINICAL_EVENT TABLE 270,950 7.34
V500 I_CLINICAL_EVE1333 XIE24CLINICAL_EVENT INDEX 49,230 1.33
V500 D_PERSON4859 PERSON TABLE 47,121 1.28
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
