Re: Shared global area for an instance

From: David Kim <Kimba_at_HK.Super.NET>
Date: 1996/02/15
Message-ID: <4fueo2$bdh_at_tst.hk.super.net>#1/1

Vinod,

Try running these 2 sqlplus scripts.
They both selects information from v$sgastat.

sga1.sql

select * from v$sgastat
/

sga2.sql

compute sum of bytes on sga_type
break on sga_type skip 1
column sga_type heading 'SGA Portion'

select decode(name, 'fixed_sga','Fixed Size',

		        'db_block_buffers', 'Database Buffers',
                                   'log_buffer', 'Redo Buffers',
                                   'Variables Size') sga_type,
           name, bytes

from v$sgastat
order by decode(name, 'fixed_sga','Fixed Size',

		        'db_block_buffers', 'Database Buffers',
                                   'log_buffer', 'Redo Buffers',
                                   'Variables Size')

/

select * from v$sga
/

Hope this helps.

David Kim

Senior Oracle Consultant

email kimba_at_HK.Super.Net

vinodb_at_sdt.com (Vinod Bidarkoppa) wrote:

>How can I check how much real memory is allocated to my instance? and
>how can I rectify that?
 

>Is it unusual to run 3 instances on a machine with 64 MB of ram. I am
>getting below par performance on one of my instance and the pouplator
>program times out and disconnects with the mainframe since the uploads are
>taking time.

>Vinod
 

>email: vinodb_at_sdt.com
Received on Thu Feb 15 1996 - 00:00:00 CET