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
SELECT view_name
FROM dba_views
WHERE view_name LIKE '%SGA%';
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Dec 20 2006 - 20:36:40 CST
