db_file%read
Hi All.
Please suggest me an appropriate action plan after below step what I have taken from RAC database 10.1.0.5.
Step1 :
SQL> SELECT SQL_ADDRESS, SQL_HASH_VALUE
FROM V$SESSION
WHERE EVENT LIKE 'db file%read'; 2 3
SQL_ADDRESS SQL_HASH_VALUE
---------------- --------------
C000000113A04518 3880674219
Step2:
SQL> SELECT row_wait_obj#
FROM V$SESSION
WHERE EVENT = 'db file scattered read';
2 3
ROW_WAIT_OBJ#
-------------
36188590
71807942
Step3:
SQL> SELECT row_wait_obj#
FROM V$SESSION
WHERE EVENT = 'db file scattered read';
2 3
ROW_WAIT_OBJ#
-------------
71807942
OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_TYPE ------------------------------ ------------------------------ ------------------------------ ------------------- MAN_E7 WLR_FAULT_DETAIL_FACT SEP122010 TABLE PARTITION Regards0