Re: standby databases and memory consumption

From: Nassyam Basha <nassyambasha_at_gmail.com>
Date: Tue, 7 Jan 2014 07:43:19 +0530
Message-Id: <DBB483E2-6A07-4BC3-ADB8-F412F64A80A3_at_gmail.com>

Before thinking of SGA/PGA, I would like to ask some questions

1. Have you configured ADG? - so that database uses for reporting purpose.
2. what is version ?

If the database is not using ADG/ database in mount and just performing recovery(MRP)... In this case there are no transactions or any reporting expected then you can start from minimum and later you can also refer to views such as v$sga_target_advice for optimal value so on and you can increase instance memory if only required.

Thanks,
Nassyam Basha

On Jan 7, 2014, at 5:06 AM, Maureen English <maureen.english_at_alaska.edu> wrote:

> Anyone willing to share what they set pga and sga values to for a standby database?
>
> We currently have ours set to the same as our primary databases, but are looking at
> finding what minimum values we can use for as long as the database is in standby mode.
>
> - Maureen
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 07 2014 - 03:13:19 CET