Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SGAPAD
The SGAPAD size is directly related to the pagefile quota requirements.
If you raise the SGAPAD, then you must raise the pagefile quota the same
amount. Note that this is a virtual memory specification, and does NOT
consume more physical memory. [Nor do you need to increase the size of the
system pagefile(s), since the SGAPAD allocates addresses using
"demand-
zero" pages.] Make sure that the sysgen parameter VIRTUALPAGECNT is big
enough; if it is smaller than your pagefile quota, then it will be the
limiting
value.
Connecting using TWO-TASK means that the client side does NOT have the
SGAPAD
addresses in it's address space; the SGA is only mapped on the database
server
side. Only the pagefile quota for the network server process(es) need to be
raised when increasing SGAPAD.
The SGA size is directly related to the working set quota requirements.
If you raise the SGA size, you should raise working set quotas the same
amount.
Note that this is a physical memory specification, but that multiple
processes
share the SAME global pages. Make sure that the SYSGEN parameter WSMAX is
big
enough; if it is smaller than your working set quotas, then it will provide
the
limiting value.
Working set quotas and pagefile quotas are specified for interactive
processes
by the User Authorization File, managed by the AUTHORIZE facility.
Background
processes get their values from the PQL SYSGEN parameters under Oracle6, and
have their quotas automatically calculated under Oracle7. In any case,
defining PQL logicals prior to starting the database will allow you to
directly
specify the quotas used for the background processes. Remember that one
VAX/VMS page is 512 bytes, or half
a KB. You can use ANALYZE/SYSTEM and SHOW PROCESS commands to see the
quotas
for currently running processes. The ACCOUNTING facility can give you peak
working set and virtual sizes for processes which have already exited. If
you
have difficulty starting Oracle, examining the ACCOUNTING log will tell you
if
you are running out of some type of process quota.
Received on Sat Nov 21 1998 - 14:53:05 CST