Re: SGA Utilization

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 21 Dec 2006 13:29:17 -0800
Message-ID: <1166736557.202513.322890@79g2000cws.googlegroups.com>

amit wrote:
> Hi all,
>
> Please, can anyone put some light on how we can check the SGA
> utilzation.
>
> Scenario-
> --------------------
> Database: Oracle 9i
> SGA_MAX_SIZE: 2gb Initially
> Total SGA allocated size: 1gb Initially
>
> Now how can we check that out of 1GB how much SGA is getting utilitzed.
> If 1gb is sufficient or we need to increase the size.
>
> Thank
> amit

In SQLPLus, try:
SHOW SGA SQL> SHOW SGA You may see something like this:
Total System Global Area 1157627904 bytes

Fixed Size                  1290748 bytes
Variable Size             536874500 bytes
Database Buffers          612368384 bytes
Redo Buffers                7094272 bytes

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Thu Dec 21 2006 - 15:29:17 CST