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
slimani
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 8.1.7.4.0 - 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 !
Mohamed
  • Attachment: scripts.zip
    (Size: 2.42KB, Downloaded 131 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
DreamzZ
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
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Memory size: 49152 Megabytes


49G.

How comes?

Hai check out your init.ora and specify less size there.
Previous Topic: ORA-01031: insufficient privileges when trying to connect as sysdba
Next Topic: installing two oracle_home
Goto Forum:
  


Current Time: Mon Dec 05 06:33:41 CST 2016

Total time taken to generate the page: 0.10183 seconds