Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-4030

Re: ORA-4030

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sun, 23 Feb 2003 23:16:45 +1000
Message-ID: <sF26a.54112$jM5.136291@newsfeeds.bigpond.com>


"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:srrc5vcde59o0j42jtkts0jdbiv9l2h8vj_at_4ax.com...
> On 21 Feb 2003 16:13:07 GMT, Chuck <chuckh_at_softhome.net> wrote:
>

<snip>

> Your Oracle process gets way too much memory. You shouldn't allocate
> more than one third of physical memory. Allocating more will result in
> excessive paging. Also by design of the Winblows O/S no process will
> get more than 2G *ever*, even if you have Advanced Server installed.
>

Hi Sybrand,

*Ever* is probably too strong an expression as there are ways to get past this limit, you can get to 3G easy enough but going any higher comes at a questionable cost.

But it is still possible.

Cheers

Richard Received on Sun Feb 23 2003 - 07:16:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US