Hi,

The server has 8GB of RAM. How much of this is allocated to the application and how much to the UNIX file cache? You have to remember that apart from SGA you need to keep aside some memry for the PGA components.

After taking out all other component assignment see how much you are left with. I would then assign sufficient memory to shared pool and rest to the buffers. Monitor your buffer quality, SQL pinhit ratio, redo buffer quality and fine tune the memory assignment to SGA components. Eventhough the table is 100MB, the reads will depend on the application. May be you will read 50MB out of the 100MB based on the selection criterion. So leave that table management in SGA to ORACLE rather than pinning the entire 100MB in SGA and thus making other queries suffer.

Hope this helps.

Baliga