Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SGA_MAX_SIZE
On Tue, 4 Jan 2005 21:19:32 +0100, "zeb" <spam_at_nowhere.com> wrote:
>Hi,
>
>If I increase SGA_MAX_SIZE, and don't use it ( DB_CACHE_SIZE and others
>unchanged )
>Is this memory allocated by oracle, at startup, and not available for other
>processes ?
>
>Thanks in advance
>
>Oracle 9.2.0.5
>AIX 5.1
>
The SGA is allocated in virtual memory. This means if the memory is
unused, it will be paged out, and consumed by other processes.
It is not allocated at startup, unless you set pre_page_sga and/or
lock_sga. Whether those parameters apply to your situation is O/S
dependent.
-- Sybrand Bakker, Senior Oracle DBAReceived on Tue Jan 04 2005 - 16:06:43 CST