Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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
![]() |
![]() |