Re: Question about shrinking sga_target.
Date: Wed, 30 Apr 2008 08:40:08 -0700 (PDT)
On Apr 29, 5:26 pm, Adam Sandler <cor..._at_excite.com> wrote:
> 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
> 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
> 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.
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
// 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?
-- @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.htmlReceived on Wed Apr 30 2008 - 10:40:08 CDT