Total Memory Consumed

[lesstjm]

I have 15 databases on my server. This morning I had a problem because one of the databases could not open because there was not enough memory.

I have 8 gig

$ prtconf|head -2
System Configuration: Sun Microsystems sun4u
Memory size: 8192 Megabytes

$ uname -arv
SunOS cmpprd51 5.8 Generic_108528-23 sun4u sparc SUNW,Ultra-Enterprise

I reduced the size of some of the SGAs.

How do I determine the total memory that each database is consuming?

I used this query to start.

select sum(value)/1024/1024 from v$sga;

What else am I missing?

It is a oracle 8.1.7 database.

Thanks for your help.

[davey23uk]

show sga

and all of the pga

Also need to check your kernel parameters, see if they are set high enough

Are you running 32Bit or 64Bit oracle?

[lesstjm]

32 bit

[davey23uk]

well you are resticted to 1.75Gb SGA per database, did you confgure an SGA bigger than that