Re: Question about shrinking sga_target.

On Apr 29, 5:26 pm, Adam Sandler <cor..._at_excite.com> 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?

jg

--
@home.com is bogus.
 “So when he died, I was basically locked out of my own Web site.”
Apparantly UCAN't.  http://www.signonsandiego.com/news/business/20080429-9999-1b29ucan.html