Re: SGA Utilization

From: amit <amit.shivpuri_at_gmail.com>
Date: 21 Dec 2006 18:17:40 -0800
Message-ID: <1166753860.874696.29880@80g2000cwy.googlegroups.com>

hi all,
thanks for valuable inputs.
the v$ views and statspack report is fine. All I want to know that, is there any dynamic performance view which can descirbe the total utilization and free sga size?

-thanks

Charles Hooper wrote:
> 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 - 20:17:40 CST