Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to tune SGA settings in Oracle 8i

How to tune SGA settings in Oracle 8i

From: Karsten Riedel <cdsla_at_camelot.de>
Date: Tue, 19 Feb 2002 15:07:09 +0100
Message-ID: <a4tm9f$mt2$1@lancelot.camelot.de> 





I have Oracle 8.1.6 on a machine with 1GB RAM. I'm running a server
application that has about 20 parallel ODBC connections to the database.
Nothing else is running on that machine.



What are the optomal settings for Shared Pool, Buffer Cache, Large Pool and
Java Pool? I guess I can keep Java Pool small because I'm using ODBC but I'm
not sure about the rest.



Thanks in advance



Karsten
Received on Tue Feb 19 2002 - 08:07:09 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US