Urgent!!! V$sgsstat

[vinodkmg]

Hi All,
I wonder when i query my V$sgastat.I showing 2 values.Please let me know what is this,,,,Using Oracle 8i on Aix Unix.

Qurey:
select name,bytes from v$sgastat where name='db_block_buffers'

Output:
NAME BYTES
-------------------------- ---------
db_block_buffers 67108864
db_block_buffers 1114112

Please Let me know!!!

thanks,
Vinod Kumar.

[sanrak]

Hi Vinod

This will happen only from Oracle8 onwards. The smaller value in shared pool is basically an array of pointers to each block in db_block buffers. This is also called as a buffer header. This can be calculated as show below

size of db_block_buffers in shared pool = db_block_buffer_parameter * (size_of_C_pointer + size_of_one_buffer_header)

the two parameters are o/s dependent

Santhosh kumar
Certified Oracle DBA - 8i