Re: 8.1.7 Enterprise memory limit?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 1 Sep 2003 07:32:28 +0200
Message-ID: <vl5o85onavpa85@corp.supernews.com>

"lakshmanan_k" <hvgtlakshvmanan_k_at_yahoo.com> wrote in message news:3309301.1062389521_at_dbforums.com...
>
> Hello,
>
> On a Windows 2000-advanced server with 8gb RAM, for an Oracle 8.1.7.4
> installation, can I use the following parameters/approach.
>
> 1. use /PAE switch
>
> 2. AWE_WINDOW_MEMORY to 1 gb (or I can leave the registry as it IS,
> without creating this key, since 1 GB is the default).
>
> 3. Set use_indirect_buffers=true in init.ora
>
> 4. Use max of 4.5 gb for my db_blocks (allowing 500 mb for any
> overheads).
>
>
>
> Is this correct.
>
> Regards
>
> Lakshmanan, K
>
> hvgtlakshvmanan_k_at_yahoo.com
>
>
> --
> Remove hvgt and the v before manan to reply
>
>
> Posted via http://dbforums.com

No, it isn't
But above all, you should read up on Oracle architecture on NT/Win2k, and/or completely revise your application and/or truly learn Oracle. 4.5 Gb for db_block_buffers is utterly ridiculous.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon Sep 01 2003 - 00:32:28 CDT