Re: Multi-Threaded Server ?

From: Paul Drake <paled_at_home.com>
Date: Fri, 04 May 2001 01:36:32 GMT
Message-ID: <3AF20731.FB63609D@home.com>

Julien Reynier wrote:
>
> Hi,
>
> I use Windows NT 4 Server on a AMD Athlon 800 Mhz with 512 Mo of Ram and
> with only one client connected to Application Server which is connected
> to Oracle database I experiencing swap problem.
>
> When I use SQL Server 7 I experiencing no problem of swap.
>
> Maybe Oracle 8i database needs more Ram than SQL Server 7 one.
>
> Do you have any idea of the amount of RAM and swap to allocate to Oracle
> 8i ?
>

*You* must allocate the memory.
Give Oracle half the RAM for SGA, 1/4 for user connections, and leave the rest to NT for starters.
watch the page faults.

The settings are in the file
%ORACLE_BASE%\Admin\%ORACLE_SID%\pfile\init%ORACLE_SID%.ora e.g. D:\Oracle\Admin\DEV\pfile\initDEV.ora

examples:

db_block_size = 8192			# do not alter without re-creating the database
db_file_multiblock_read_count = 8	# 64 KB read size for NT/W2K for

FTS/IRS

db_block_buffers = 16384		# 128 MB - buffers
shared_pool_size = 67108864		#  64 MB - very small dev db - not many

packages.

sort_area_size = 4194304 # 4 MB - only 1 connection - no sorts to disk.
sort_area_retained_size = 1048576 # 1 MB

large_pool_size = 4194304		#   4 MB - use for rman and PQO
java_pool_size = 20971520		#  20 MB - default value - reduce if not

using java.

log_buffer = 1048576 # 1 MB

sqlplus> select * from v$sga;

sqlplus> select name,value from v$parameter where name like '%pool%';

hth,

Paul Received on Thu May 03 2001 - 20:36:32 CDT