Home » RDBMS Server » Server Administration » virtual memory problem in window oracle database (window 2K, Oracle 8i)
virtual memory problem in window oracle database [message #294904] Sun, 20 January 2008 12:31 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Dear all,

we have a heavily used oracle database running under window2K server. The database version is 8i and since the application is certified for 8i only: management does not like to upgrade the database to 9i or 10G. The database size is less than 15GB. Lately we see a spike in the virtual memory and reaches close to 2GB and the database hang and we see the ORA-04030 message.

Any suggestion, help would be highly appreciated.

Thanks.
Re: virtual memory problem in window oracle database [message #294905 is a reply to message #294904] Sun, 20 January 2008 12:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First try to know why you reached this value.

Regards
Michel
Re: virtual memory problem in window oracle database [message #294910 is a reply to message #294904] Sun, 20 January 2008 16:29 Go to previous messageGo to next message
rkl1
Messages: 97
Registered: June 2005
Member
Thanks for the interest.However it is the classic chicken and egg problem. To be honest, we don't know why the virtual memory has been spiked lately since they have been no change to database or the window OS. We are looking for the solutions as how to tame the spike in virtual memory usage when we have plenty of physical memory still available.

Thanks.
Re: virtual memory problem in window oracle database [message #294929 is a reply to message #294904] Sun, 20 January 2008 22:31 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member

Please post full error message along with trace if any.This will indeed help forum members to understand your situation better.

Regards

Manjit Kumar [mkbhati]
Re: virtual memory problem in window oracle database [message #294932 is a reply to message #294910] Sun, 20 January 2008 23:10 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not a classic chicken and egg problem, you should know where you were in your code when the error raised.

Read http://www.orafaq.com/forum/mv/msg/95849/294695/102589/#msg_294695 and followings.

Regards
Michel

Previous Topic: May you clarify me more?
Next Topic: Flushing Shared Pool
Goto Forum:
  


Current Time: Mon Dec 05 15:06:37 CST 2016

Total time taken to generate the page: 0.19603 seconds