SGA query showing strange values

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