Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle & Swap?

Re: Oracle & Swap?

From: srivenu <srivenu_at_hotmail.com>
Date: 26 Aug 2002 22:18:01 -0700
Message-ID: <1a68177.0208262118.3af33b9a@posting.google.com>


Well do you see a lot of swapping going on when you are running Oracle ?
try vmstat -S 1 10
Obviously i think you see a lot of pageins when you startup an Oracle instance. (And you may see swapouts if your system is short of memory) But later on when the system stabilizes, do you see a lot swapping activity ?
What did you mean when you said that Oracle is using 1 GB of swap ? On Solaris, SWAP includes your PHYSICAL MEMORY + DISK SPACE you configured for SWAP.
You can try this.

1)give swap -s command
2)startup the Oracle Instance
3)give swap -s command again

the difference in the USED space you see in commands 3 and 1 should be roughly equal to your SGA. Received on Tue Aug 27 2002 - 00:18:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US