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

Home -> Community -> Usenet -> c.d.o.server -> Fixed memory / Variable memory

Fixed memory / Variable memory

From: Sam Jordan <sjo_at_spin.ch>
Date: Mon, 03 May 1999 06:43:41 +0000
Message-ID: <372D459D.748D1844@spin.ch>


Hi

One important design issue for Oracle DB server is certainly to decide how to set the various parameters dealing with memory consumption. Some hints can be found in the Oracle manuals, but I have problems to find out, which memory buffers are fixed (shared between all sessions) and which are session-specific. The latter ones consume n * size memory, if n is the amount of sessions and size the size of the buffers, while the fixed memory buffers always has the same size.

Which parameters contribute most to the session-specific memory consumption? How can the average memory requirement of one Oracle session (resp. the corresponding process) be estimated?

Which memory buffers contribute most to good Oracle DB performance?

Are the values printed out by 'show sga' in svrmgrl all shared between sessions or are some of them allocated for each session? If the latter, which ones?

bye
--
Sam Jordan Received on Mon May 03 1999 - 01:43:41 CDT

Original text of this message

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