Re: Question about shrinking sga_target.

From: joel garry <>
Date: Wed, 30 Apr 2008 08:40:08 -0700 (PDT)
Message-ID: <>

On Apr 29, 5:26 pm, Adam Sandler <> wrote:
> Hello,
> Today the database shutdown and I received error codes 01034 and
> 27101.  When I tried to restart and connect I got 00821.  The 00821
> was due to the specified value of sga_target was too small.  To get
> the database started, I created a pfile from the spfile, edited the
> pfile's sga_target line (specified more space; went from 320M to
> 640M), created a spfile from the pfile and started the database back
> up.
> I was able to start the database but now I want to put the sga_target
> back to the value where it has been for years.  When I did this from a
> command line it failed:
> alter system set sga_target=320M scope=both;
> ORA-02097: parameter cannot be modified because the specified value is
> invalid
> ORA-00827 could not shrink sga_target to specified value
> I'm stumped here... how can I set sga_target to a smaller value than
> the current setting?  Suggestions are greatly appreciated.
> Thanks!

Please state exact version. What is your sga_max_size?

00827, 00000, "could not shrink sga_target to specified value" // *Cause: Attempted to shrink the SGA to the specified value but did not
// succeed because the SGA components could not be shrunk as they
// were already at their minimum sizes. // *Action: Do not set sga_target to a value below the current value without
// first shrinking the individual SGA components.

Do you know what your other init parameters were for years?


-- is bogus.
 “So when he died, I was basically locked out of my own Web site.”
Apparantly UCAN't.
Received on Wed Apr 30 2008 - 10:40:08 CDT

Original text of this message