RE: ORA-4030

From: Tim Onions <tim.onions_at_speechmachines.com>
Date: Mon, 9 Feb 2004 11:29:32 -0000
Message-ID: <A90A3AC3D202D311909A0090271E4C8103210525@smcorps0002.smcorp.speechmachines.com>

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 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_at_yahoo.com] Sent: 07 February 2004 00:25
To: oracle-l_at_freelists.org
Subject: Re: ORA-4030

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_at_freelists.org 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


-----------------------------------------------------------------

Received on Mon Feb 09 2004 - 05:29:32 CST