High I/O

Hi Jeff:

I think I am missing something, I know which file is having high I/O. How can I find Which object access caused that High I/O OR Which process caused that High I/O? With the V$filestat I am unable to get that information.

Thanks,
vbadba

Hi,

If you have found the file,check the tablespace associated to it.Once tablespace is indetified,check the objects on that tablespace from dba_segments.

Find if tables involved are doing full tables scans.

You may have a look at V$SEGMENT_STATISTICS like:

select OWNER, OBJECT_NAME, SUBOBJECT_NAME, TABLESPACE_NAME, OBJECT_TYPE, STATISTIC_NAME, VALUE
from V$SEGMENT_STATISTICS s1
where s1.owner != 'SYS' and s1.STATISTIC# = 3
order by value desc

Quote:

---

Originally posted by mike9
You may have a look at V$SEGMENT_STATISTICS like:

select OWNER, OBJECT_NAME, SUBOBJECT_NAME, TABLESPACE_NAME, OBJECT_TYPE, STATISTIC_NAME, VALUE
from V$SEGMENT_STATISTICS s1
where s1.owner != 'SYS' and s1.STATISTIC# = 3
order by value desc

---

Hi Mike:

I could not find V$SEGMENT_STATISTICS. Is this available in 8i?

Thanks,
vbadba