Re: New to Oracle 9i...Increasing SGA parameters.

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Wed, 14 Jul 2004 22:47:43 -0700 (PDT)
Message-ID: <20040715054743.13379.qmail@web20426.mail.yahoo.com>

• Denham Eva <EVAD_at_TFMC.co.za> wrote:
  > Hello Folks,
  >
  > Once again very confused about what is going on.
  > After some rtfming I am no clearer on how to adjust
  > and manipulate the
  > SGA or Oracle 9i's memory handling.
  > Does anyone have a good resource on the net which
  > follows a by example
  > format to explaining how to increase memory and its
  > parameters?
  >
  

9.2, right?
I never installed 9.0.1, so I'm entirely unqualified to comment on it, and won't.

how about nuking the entire deal and selecting a % of physical memory for oracle to allocate?
it involves the least amount of thinking. for a single database instance, give it half.

if not, try these:

shared_pool + java_pool + large_pool + log_buffer + db_cache_size <= sga_max_size

pga_aggregate_target does not intersect with sga_max_size.

sga_max_size + pga_aggregate_target <<
max(process_limit, physical_memory - OS overhead).

follow me so far?

in 8.1.7, the db_block_buffers was in db_blocks (e.g. 8192 bytes) not in bytes (K, M, G)

in 9.2, db_cache_size is in bytes (or K, M, G).

that may be the disconnect that is causing you grief.

a 4 MB buffer cache sounds familiar of a 7.3.3 db created by the dbca just past the missing link, with autoextend set at a single block (4 KB) on datafiles by default.

4 MB is the smallest chunk size that can be allocated. logon to crucial.com, grab yourself 1 GB of mem and start cranking with a 16 MB chunk size.

we've come so far, and yet ...

Pd

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 15 2004 - 00:44:38 CDT