Re: Strange error when resizing MEMORY_TARGET
From: Stefano Cislaghi <s.cislaghi_at_gmail.com>
Date: Tue, 15 Jan 2013 08:21:00 +0100
Message-ID: <CAFsgGrycb8o_eye3Aw=EZpLqc77JrVN=W7jR=XXOvFnM5BJj0g_at_mail.gmail.com>
On 15 January 2013 08:15, De DBA <dedba_at_tpg.com.au> wrote:
> ORA-00846
Hi Tony,
this is a known behaviour. Check your v$memory_resize_ops . You should see that the sum of sga and pga is greater than 16gb. This is the reason of the message. Oracle needs in fact to decrease memory. For more info, if you have MoS access, check also note: 452512.1 and 139783.1
Date: Tue, 15 Jan 2013 08:21:00 +0100
Message-ID: <CAFsgGrycb8o_eye3Aw=EZpLqc77JrVN=W7jR=XXOvFnM5BJj0g_at_mail.gmail.com>
On 15 January 2013 08:15, De DBA <dedba_at_tpg.com.au> wrote:
> ORA-00846
Hi Tony,
this is a known behaviour. Check your v$memory_resize_ops . You should see that the sum of sga and pga is greater than 16gb. This is the reason of the message. Oracle needs in fact to decrease memory. For more info, if you have MoS access, check also note: 452512.1 and 139783.1
Ste
-- http://www.stefanocislaghi.eu The SQLServerAgent service depends on the MSSQLServer service, which has failed due to the following error: The operation completed successfully. -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 15 2013 - 08:21:00 CET