Urgent!!! V$sgsstat
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Urgent!!! V$sgsstat

  1. #1
    Join Date
    Aug 2000
    Posts
    87
    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.

  2. #2
    Join Date
    Nov 2000
    Posts
    25
    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
  •  


Click Here to Expand Forum to Full Width