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

Thread: dba_blocks?

  1. 12-03-2002, 11:00 PM #1
    yls177
    yls177 is offline Senior Member
    Join Date
    Oct 2002
    Posts
    391

    dba_blocks?

    hi, in oracle, we have dba_
    1) tablespace
    2) segment
    3) extent

    but we dont have this dba_block?

    just want to see the relationship and the mapping...
    Reply With Quote Reply With Quote
  2. 12-04-2002, 12:04 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What information in particular would you like to see about the blocks?
    The block mapping can be seen in DBA_EXTENTS it shows starting block_id of the extent and size of the extent in blocks. Other block level parameters like PCTFREE and PCTUSED can be seen in object views like DBA_TABLES, DBA_INDEXES.


    Sanjay
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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