Re: How to reduce memory consumption?
Date: Fri, 21 Mar 2008 12:07:29 -0700 (PDT)
Message-ID: <fed3d6f3-2b66-490c-94be-ac8c3c7f087f@q78g2000hsh.googlegroups.com>
On Mar 21, 2:39 pm, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> On Mar 21, 1:37 pm, gnewsgroup <gnewsgr..._at_gmail.com> wrote:
>
> > I am new to Oracle.
>
> > I just installed Oracle11g enterprise edition on my Windows XP Sp2
> > system. My computer is a Pentium 4, 2.20GHz with 1G memory.
>
> > If the Oracle service is running, it consumes around 400M memory, and
> > as a result, my computer becomes barely usable.
>
> > I only need to practice / play with Oracle 11g, so I am wondering if
> > it is possible to greatly reduce its memory consumption and yet still
> > let me play with it happily.
>
> > Thank you.
>
> The parameters SGA_TARGET and PGA_AGGREGATE_TARGET help control the
> amount of memory used by Oracle - what values are specified for those
> parameters? If you are able to connect to the database using
> SQL*Plus, type the following:
> SHOW PARAMETER SGA_TARGET
> SHOW PARAMETER PGA_AGGREGATE_TARGET
>
> 400MB is a fairly small memory footprint for an Oracle database. You
> might be able to specify a value as small as 200M for the SGA_TARGET
> and 50M for the PGA_AGGREGATE_TARGET.
>
> Make certain that you have excluded the Oracle binary and data files
> from virus scans, as real-time scans of the data files could kill
> system performance. 2GB of memory is reasonably inexpensive upgrade
> for most computers, so you might want to consider that upgrade.
>
> Charles Hooper
> IT Manager/Oracle DBA
> K&M Machine-Fabricating, Inc.
OK, after I changed the memory settings for SGA_TARGET and PGA_AGGREGATE_TARGET, I ran shutdown and then issued startup and I got this:
SQL> startup
ORACLE instance started.
Total System Global Area 431038464 bytes
Fixed Size 1333676 bytes Variable Size 297797204 bytes Database Buffers 125829120 bytes Redo Buffers 6078464 bytesDatabase mounted.
Database opened.
SQL> Does it look right given the new settings?
Thank you. Received on Fri Mar 21 2008 - 14:07:29 CDT