-
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.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|