I am running 2 Oracle 7.3.4 databases on AIX (seperate databases but having database links to each other. Users have been complaining of slow response times. On doing some investigation I have found that there are 2 database files in each database which have the majority of I/O reads performed on them.
Looking at v$system_event the avg. figure for the db file sequential read is around 200 centisecs on both databases
I know what disk the filesystem containing the db files is on. Is there any further anlysis I could do to narrow the problem down further?