Re: SGA query showing strange values

If you look into more detail you will see that also the dictionary cache, the library cache and the sql are changed. The size of the shared pool is fixed, however it use, and the size of it's 'sub'pools are dynamic. You are looking at dynamic, actual data, so it is not strange they have changed. When you in the future you observe this behavior you could look into v$db_object_cache and v$sqlarea to see what is actually happening. AFAIK there is no known bug, and this perfectly normal.

Hth,

Sybrand Bakker, Oracle DBA

"jchiappa" <jchiappaNOjcSPAM_at_bbvabrasil.com.br.invalid> wrote in message news:0eecd1d6.1532df8f_at_usw-ex0105-034.remarq.com...
> In my prod machine (IBM risc model F50, 2 processors, 1 Gb RAM,
> with Oracle 7.3.4.5), querying the SGA with the v$sgastat view
> I'm receiving some strange results, mainly with the free memory
> column :
>
> sys_at_prod::SQL>select name, bytes from v$sgastat where name in
> ('db_block_buffers', 'log_buffer','dictionary cache',
> 'sql area','library cache', 'free memory')
> NAME BYTES
> -------------------------- ----------
> free memory 4294924108
> db_block_buffers 90112000
> log_buffer 1048576
> log_buffer 16384
> dictionary cache 6690500
> library cache 56047572
> sql area 50874164
>
> 7 rows selected.
>
> with the same sessions in memory, some time later :
>
> NAME BYTES
> -------------------------- ----------
> free memory 102076
> db_block_buffers 90112000
> log_buffer 1048576
> log_buffer 16384
> dictionary cache 6802824
> library cache 69757772
> sql area 37960916
>
>
> Are these number reliable ? Is there any knowed bug in these v$
> view ?
>
> My relevant db parameters are :
>
> db_block_buffers 22000
> db_block_checksum FALSE
> db_block_size 4096
> db_block_checkpoint_batch 8
> db_block_lru_statistics FALSE
> db_block_lru_extended_statistics 0
> db_block_lru_latches 4
> db_files 20
> db_file_simultaneous_writes 8
> db_file_multiblock_read_count 16
> gc_db_locks 100
> dblink_encrypt_login FALSE
> db_domain WORLD
> db_name prod
> db_writers 4
> shared_pool_size 130000000
> shared_pool_reserved_size 13000000
> shared_pool_reserved_min_alloc 5000
> log_buffer 1048576
> log_checkpoint_interval 9999999
> log_checkpoint_timeout 0
> log_block_checksum FALSE
> log_small_entry_max_size 80
> log_simultaneous_copies 4
> log_files 40
> log_checkpoints_to_alert FALSE
> delayed_logging_block_cleanouts TRUE
>
> []s
> Chiappa
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Fri Aug 11 2000 - 00:00:00 CDT