ORA-4030 2004-02-09 - By Tim Onions
Back
Also, if using indirect buffer, /3GB/PAE switches etc watch out for what the
operating system loses as Oracle gains memory. We have used this method to
successfully get around ORA-4030 (See http://ORA-4030.ora-code.com) type errors but now have to watch "system
paged pool" memory (one of the things Win2k shrinks to allow the /3Gb to
work, usually it is but it only now gets 192Mb) - we can now suffer from the
inability to copy large files around (eg archive redo logs, datafile
backups) when the system paged pool is running short of memory.
T?
-- --Original Message-- --
From: Carol Spencer [mailto:spence_slc@(protected)]
Sent: 07 February 2004 00:25
To: oracle-l@(protected)
Subject: Re: ORA-4030 (See http://ORA-4030.ora-code.com)
Because each dedicated connection (thread) has a reserved stack size of 1M,
the actual virtual memory reserved by Oracle is larger than the memory you
are probably watching. Check the virtual memory for the oracle process in
task manager (in the Processes tab, select the "Virtual Memory" column from
the View), or use PerfMon and select the process object for oracle,
selecting virtual memory.
You may see it near 3GB, causing new memory allocations to fail. (Also,
make sure that you do have a 2GB page file.)
If you have quite a few connections, using orastack will often allow you
more connections (in addition to adjusting pga_aggregate_target or sort/hash
area sizes). Using indirect data buffers, as suggested, is also a
possibility, but don't forget that you have to reserve an Window size (the
default is 1GB), so you really don't get all that lower memory for PGA
(shared pool and log will also be in the lower memory).
Regards, Carol Spencer
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
