DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Block Size

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    hi,

    Given the statistic reports about the number of extents, Initial , Next is it possible to find the number of blocks in the extent.

    How else do we find the number of blocks for each extent?
    Badrianth

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Divide extent size with block size, what you get z no of blocks.
    Right ?
    Reddy,Sam

  3. #3
    Join Date
    Jan 2001
    Posts
    642
    yeah!,
    I just wanted to know if any of the V$.. tables gives it?

    badrianth

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    There is a blocks column in these views. I Guess thats what you wanted.

    DBA_EXTENTS
    DBA_SEGMENTS
    Reddy,Sam

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