Re: Memory recommendations for Oracle 8i

Answers embedded.

VampireD wrote:

> First off, 512Mb for NT and 1Gb for Solaris is off the wall.
>
> 1. Solaris takes less memory
> 2. No where have you mentioned what the database is doing. So how can
> you make a recommendation based strictly off OS?
>
> Considerations that detirmine memory:
>
> Alot of reporting being done? (Memory sorts instead of disk sorts)

Mostly OLTP. Reporting is secondary. Some work is done via a remote DB link.

>
> Alot of procedures? (Pinning procedures in memory)

Not a lot of procedures. Less than 50.

>
> How many instances on the database (Each instance takes memory for
 

> shared pool, block buffers, and processes)

1 instance.

>
> How large is block buffers/shared pool going to do be

Shared pool 10M. Probably (not sure yet) default for block buffers.

>
> Alot of java? Java has a seperate pool of memory to consider

None.

>
> Size of PL/SQL / Java procedures? Are they mostly going to be pinned?

Mostly pretty small. None planned to be pinned at the moment unless I identify some that are used quite frequently.

>
> How many users? Each users uses 1Mb min to as much as 30Mb or more

+100

>
> Development box? Staging box? Production Box?

Production.

>
> Using shared dispatchers or dedicated processes?

Shared.

>
>
> I believe both Solaris and NT recommend 128Mb to run oracle.
>
> 64Mb(OS) + 16MbxInstances + Shared Pool + Large Pool + Java Pool +
> Block Buffers + Shared Pool + Pinned Procedures + 1-30Mb+ / user + many
> other factors.
>
> Out of this, there is very little that is really OS concern. Of course
> you have hardware limitation between how much memory UNIX and how much
> NT can handle, but both of them are generally at least able to handle
> 4Gb right now. So really those estimates are rather null in void when
> it comes down to what really detirmines this. And I left a bit of
> stuff out.
>
Received on Fri Oct 06 2000 - 20:08:33 CDT