Re: How to find Memory available to Oracle.?

From: DJ <nospamplease_at_goaway.com>
Date: Sat, 11 Oct 2003 11:23:55 +0100
Message-ID: <3TQhb.130$Cf.1339@newsfep4-glfd.server.ntli.net>

"Newbie" <learning_still_at_hotmail.com> wrote in message news:6093c29e.0310110137.235937f3_at_posting.google.com...
> Hi,
>
> How do i find the amount of memory available to the Oracle Instance ?
>
> I read that from 9i onwards, we can set oracle memory config.
> parameters to use the max memory available to the instance, which in
> turn is almost equiv to the amount of RAM minus the mem needed by OS
> to run smoothly.
>
> So, how do i find the amount of mem consumed by OS or how much
> available to the instance??
>
> TIA
show sga will tell you how much memory has been assigned to the instance

ask your sys admin about how much memory your server has Received on Sat Oct 11 2003 - 05:23:55 CDT