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?
data block wait is highest
In v$sysstat, do u see high dirty buffers inspected , increase DBWR processes.
v$system_event : db_file_sequential_read is highest, did u see high ebough buffer busy waits and buffer deadlocks.
Increase Freelists .
Also in V$latch_children , check for cache buffer chains , are sleeps divide properly on all chains, if no get ADDR of that chain.
group by dbarfil,dbablk
Get the block(s) with high counts
and from dba_extents , get the object name.