oracle in solaris consume lot of memory

**Rauf Sarwar** · Jun 27 '08, 05:08 PM

Re: oracle in solaris consume lot of memory

Originally posted by atalukdar1

Hi ,

>

I am facing performance problem in oracle , my oracle8.1.6 in solaris
8 consume 89 to 91% memory when i see from prstat -t command, can
anybody help me out to do some tuning so that i can release some
memory ,

>

regds,

>

Amitabh

Well... you can start by providing what is the total system memory and
what is the total SGA of your database?

Regards

/Rauf Sarwar

--
Posted via http://dbforums.com

**Ana C. Dent** · Jun 27 '08, 05:08 PM

Re: oracle in solaris consume lot of memory

atalukdar1 wrote:

Hi ,
>
>
>
I am facing performance problem in oracle , my oracle8.1.6 in solaris 8
consume 89 to 91% memory when i see from prstat -t command, can anybody
help me out to do some tuning so that i can release some memory ,

This will ALWAYS be the case when Oracle runs on Solaris after a short
period of time after a reboot & users are using the DB. It does NOT
matter how much RAM you put in the system or how small you make the
SGA.

Simply put "free memory" is a useless indicator of anything.
A better metric is the Page Scan rate;
where 0 is GREAT
and < 10 is perfectly acceptable
and < 100 should be of no concern
and 1000 users will like experience slow response time.

**chan01** · Jun 27 '08, 05:09 PM

Re: oracle in solaris consume lot of memory

atalukdar1 <member37251@db forums.comwrote in message news:<3294968.1 062071510@dbfor ums.com>...

Hi ,
I am facing performance problem in oracle , my oracle8.1.6 in solaris 8
consume 89 to 91% memory when i see from prstat -t command, can anybody
help me out to do some tuning so that i can release some memory ,
regds,
Amitabh

If you have a "top" utility on the server can you paste the "top"
output and your hardware and software configuration.

Thanks.

oracle in solaris consume lot of memory

oracle in solaris consume lot of memory

Comment

Comment

Comment