Hi,

My Sun server has 4GB of memory with 2 900MHz CPU and running in Solaris 9 and act as a Oracle 9i 9.2.0.1.0 database server. Vendor has set the following Oracle memory usage:

shared pool 128MB
buffer cache 1008MB
large pool 32MB
java pool 32MB

May I know what's the rationale behind a such a low shared poll and such a high buffer cache? The DB needs to run 24X7 with over 100 users connected concurrently. Tks.