Home » RDBMS Server » Server Administration » Oracle is consuming all available memory
Oracle is consuming all available memory [message #260244] Fri, 17 August 2007 14:58 Go to next message
Messages: 1
Registered: August 2007
Location: Morocco
Junior Member

Hi everyDBA !
I got a problem with my Oracle DBMS Server. Once i start the server and users begin to connect, the system user 'oracle' consumes the whole resources in the machine. I need some help please. here i provide you with some technical information :

1. Oracle version : Oracle8i Enterprise Edition Release - 64bit Production
2. OS : SunOS 5.8 Generic_117350-35 sun4u sparc SUNW,Sun-Fire
3. Memory size: 49152 Megabytes
4. My init file : see attachment
5. A "prstat -a" command output : see attachment

Thanks !
  • Attachment: scripts.zip
    (Size: 2.42KB, Downloaded 134 times)
Re: Oracle is consuming all available memory [message #260249 is a reply to message #260244] Fri, 17 August 2007 15:23 Go to previous messageGo to next message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
You using Dedicated mode or Shared Server mode?
How much users connected to database?
Whats the DMLs rate?
Re: Oracle is consuming all available memory [message #260348 is a reply to message #260244] Sat, 18 August 2007 22:13 Go to previous message
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Memory size: 49152 Megabytes


How comes?

Hai check out your init.ora and specify less size there.
Previous Topic: Security patches for Oracle 9208.
Next Topic: instance recovery....
Goto Forum:

Current Time: Mon Aug 21 16:46:00 CDT 2017

Total time taken to generate the page: 0.04401 seconds