space in datafiles!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: space in datafiles!!

  1. #1
    Join Date
    Feb 2001
    Posts
    44
    Hi All,
    Can anybody tell me how to detemine how much space is remaining in a datafile?Which views should I check for this?
    Thanks

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    look on dba_data_files, you have blocks and used_blocks

  3. #3
    Join Date
    Feb 2001
    Posts
    123
    The free space in a data file can be obtained by getting bytes or blocks from dba_free_space, and linking to dba_data_files by the file_id column to get at the file name.

    HTH

    David.

  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    If you have OEM, you can view this information in Storage Manager.
    David Knight
    OCP DBA 8i, 9i, 10g

  5. #5
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    You may use this script also. You will need to change the substr values to collect the info you need.

    column PCT format 999.99

    select substr(b.tablespace_name, 1, 17) ts_name,
    substr(b.file_name, 21, 25) fname,
    b.bytes,
    sum(a.bytes) freebytes,
    100*sum(a.bytes)/b.bytes "PCT"
    from dba_free_space a,
    dba_data_files b
    where a.file_id = b.file_id
    group by b.tablespace_name, b.file_name, b.bytes
    order by b.tablespace_name, b.file_name;

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

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