Re: Memory minimums
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: "Blanchard, William G" <William.Blanchard@xxxxxxxxxxxxx>
- Date: Mon, 18 Oct 2010 17:08:54 -0400
Well...I've got one 11.2 database that looks like this:
SQL> sho parameter target
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
pga_aggregate_target big integer 64M
sga_target big integer 88M
SQL> sho sga
Total System Global Area 92274688 bytes
Fixed Size 2081888 bytes
Variable Size 75500448 bytes
Database Buffers 8388608 bytes
Redo Buffers 6303744 bytes
But don't ask me why.
On Mon, Oct 18, 2010 at 4:49 PM, Blanchard, William G <
William.Blanchard@xxxxxxxxxxxxx> wrote:
> I am trying to squeeze a new database onto a server but it isn’t working
> (which precipitated the email). My initial thought was 1GB but I seem to
> remember 512M was sufficient for 10g (or was that 9i) but I couldn’t find
> anything that specifically said “the absolute minimum to install an oracle
> database is x”.
>
>
>
>
>
> WGB
>
>
>
> *From:* andyklock@xxxxxxxxx [mailto:andyklock@xxxxxxxxx] *On Behalf Of *Andy
> Klock
> *Sent:* Monday, October 18, 2010 3:46 PM
> *To:* Blanchard, William G
> *Subject:* Re: Memory minimums
>
>
>
> That's not an easy question because it all depends on how your database is
> going to be used. Per the install guide, I believe 11.1 says "at least
> 1GB". So that would imply just to install a database you need "at least"
> one gigabyte. If your database is not doing very much that may be plenty.
> I've seen some very small 11g database operating just fine with 1GB SGA.
> However, I've also seen some databases that require a minimum of 64GB.
>
> On Mon, Oct 18, 2010 at 3:14 PM, Blanchard, William G <
> William.Blanchard@xxxxxxxxxxxxx> wrote:
>
> Greetings listers,
>
>
>
> I searched metalink and google but couldn’t find an answer to this
> question. What is the minimum allowed for SGA and PGA in an 11.1 database?
>
>
>
>
>
> Thank you,
>
>
>
> WGB
>
> _____________
>
> The information contained in this message is proprietary and/or
> confidential. If you are not the intended recipient, please: (i) delete the
> message and all copies; (ii) do not disclose, distribute or use the message
> in any manner; and (iii) notify the sender immediately. In addition, please
> be aware that any message addressed to our domain is subject to archiving
> and review by persons other than the intended recipient. Thank you.
> _____________
>
>
> _____________
>
> The information contained in this message is proprietary and/or
> confidential. If you are not the intended recipient, please: (i) delete the
> message and all copies; (ii) do not disclose, distribute or use the message
> in any manner; and (iii) notify the sender immediately. In addition, please
> be aware that any message addressed to our domain is subject to archiving
> and review by persons other than the intended recipient. Thank you.
> _____________
>
Other related posts:
