We have 5 TB of DB size with 1 DB and 4 Dialog instance.
RAM 32 GB IBM AIX + Oracle
SGA of 6 GB.
But most of the dialog WP are in sequential read status......there are more no. of records in each table but we have proper indexing.
Is there any other way to improve the performance other than table archiving to avoid many sequential reads...like which buffers I have to increase?