Re: How can I tell if my SGA fits into the physical memory?

>I do not have a monitoring tool on the OS level. I have
> databases running in HP, Sun and Windows platform.

Why not? If you have access to the server to install Oracle, then you have access to the tools you'll need to see if your SGA size (coupled with other server processes) is inducing swapping. On HP and Sun, look at the 'sar' command. In Windows, look at the Performance Monitor tool.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"