471,092 Members | 1,542 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

oracle in solaris consume lot of memory


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
--
Posted via http://dbforums.com
Jul 19 '05 #1
3 3966

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
Jul 19 '05 #2
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.

Jul 19 '05 #3
atalukdar1 <me*********@dbforums.com> wrote in message news:<32****************@dbforums.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.
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by jayPLEASEtylerNOwilliamsSPAM | last post: by
4 posts views Thread by susmita_ganguly | last post: by
reply views Thread by Subhodini Fernandes | last post: by
35 posts views Thread by English Teacher | last post: by
20 posts views Thread by antonberg1 | last post: by
1 post views Thread by kenneth.s.chan | last post: by
2 posts views Thread by Michael Shilokovsky | last post: by
3 posts views Thread by atalukdar1 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.