Re: Oracle Memory usage
From: Ken Johnson <ken.johnson_at_mail.tapestry.com>
Date: 1996/06/01
Message-ID: <31B090DB.16C5_at_mail.tapestry.com>#1/1
Date: 1996/06/01
Message-ID: <31B090DB.16C5_at_mail.tapestry.com>#1/1
Binh Pham wrote:
>
> We have a Sparc 1000E with 256Meg RAM. How do I find out:
> 1) How much memory currently being allocated solely to Oracle?
> 2) How much is being allocated to SGA?
> 3) How much memory or average currently being used by the whole system?
I can't help you with 1 & 3, but for #2: SELECT * FROM V$SGA; (or SELECT SUM(value) from V$SGA; ) This will tell you how much of memory each component (or the whole thing) of the SGA has allocated to it. You probably want to check your Sparc Manuals/Man-Pages for 1&3.
-- ------------------------------------------------- Ken Johnson - Technical Consultant Tapestry Computing, Inc. http://www.tapestry.comReceived on Sat Jun 01 1996 - 00:00:00 CEST