Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SGA_MAX_SIZE and SGA_TARGET in Oracle 10G

prajithparanDec 13 2007 — edited Dec 18 2007

We have the following H/W with Solaris 9
SPARC-IV 16 CPUs
32GB RAM
128GB swap

What is the optimal size of sga_target and sga_max_size that can be configured for a heavy batch processing oracle server. Nothing runs except oracle in the above server.

We have currently 3GB SGA size , however our heavy queries are very slow.
We have huge updates on tables with more than 200Millions rows.
Do we need to have JAVA_POOL if the java stored procedure are NOT used.
However we are connecting to this database using JDBC also.

Moreover ASM is enabled in this server.

You expert suggetions are always welcome.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 15 2008

Added on Dec 13 2007

#general-database-discussions

27 comments

6,131 views