Re: SGA Utilization

From: T.T <tahart_at_videotron.ca>
Date: Thu, 21 Dec 2006 14:59:30 -0500
Message-ID: <GIBih.13565$kY5.37708@weber.videotron.net>

select table_name from dict where table_name like 'V%SGA%';
Run statspack and get informations about shared pool, buffer cache and other SGA structures. With these informations you can decide to increase the size or not.

Hope this will help.
Rachid
OCP DBA 9i/10g.

"amit" <amit.shivpuri_at_gmail.com> wrote in message news:1166664296.110890.62830_at_80g2000cwy.googlegroups.com...
> 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
>
Received on Thu Dec 21 2006 - 13:59:30 CST