Re: Huge Swap area being used despite having available ram (Solaris 8 , ora9.2.)

Comments inline below

"Mike Rowland via DBMonster.com" <forum_at_DBMonster.com> wrote in news:00122eef75d94cc3b288a30a576fe4ad_at_DBMonster.com:

> Hello.
> I am relatively new to Oracle as a DB, but we use Oracle 9i under the
> following conditions.
>
> A sun e6500 ten processor system is direct connected to a sunfire V240
> two processor system with 8 GB RAM.

HUH?
Which system is the database server system? How much RAM does the E6500 have?

What is "direct connected"?

What is running on the V240?

>
> Here is my problem. The V240 has high IO wait times when large numbers
> of processes are underway. The swap in use number goes through the
> roof when oracle is running and I still have some 60+% of system
> memory listed as free. I also cannot seem to increase the total SGA
> size beyond what it presently is without crashing oracle

Which processes doing what on the V240 are doing all the I/O?

What makes you conclude that a larger SGA is a solution to anything?

>
> My three questions are:
> 1) why is oracle using so much swap?

'Cuz it does. Why is this a concern of yours?

> 2) is there a way to tell oracle on solaris not to use swap (or at
> least curb its appetite for it)

NO. Let Solaris & Oracle be good neighbors & get out of their way.

> 3) how can I use more of the system ram (and hopefully decrease the
> use of swap)

Put users on the system the "free RAM" will get consumed. How long after starting Oracle?Solaris were these measurements taken? Received on Wed Mar 30 2005 - 09:44:42 CST