amit wrote:
> 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.
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 Thu Dec 21 2006 - 21:22:26 CST
