Free Space of datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Free Space of datafile

  1. #1
    Join Date
    Feb 2001
    Posts
    10

    Exclamation


    Dear Friends

    I am having 10 Datafiles and these datafiles are attached with 3 Tablespace, 7 in the Main Tablespace and others are with Index tablespace.

    Whenever I am seeing the space of the datafile in the DBA_DATA_FILES, it is showing all 10 datafiles, But whenever i am seeing Used Space of each datafile through the DBA_FREE_SPACE, then status of 2 Datafiles are not coming in the DBA_FREE_SPACE, Only Query show the 8 datafiles.

    Can anyone tell me, How I can see the space of these 2 files and why it is not showing in the DBA_FREE_SPACE table.


    Thanks in advance.

    Sandeep

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    What is the status of the files in DBA_DATA_FILES?

    Is it possible that the two that are not showing in DBA_FREE_SPACE have a different status? Just a guess.

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

  3. #3
    Join Date
    Feb 2001
    Posts
    10

    Dear Sir,

    Status for all datafiles are AVAILABLE in DBA_DATA_FILES.


    Thanks

    Sandeep

  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Sorry about that.

    What is the status of the files in V$DATAFILE? Could 2 of them be OFFLINE?

    David Knight
    OCP DBA 8i, 9i, 10g

  5. #5
    Join Date
    Jun 2001
    Posts
    15
    those two files might be 100% full and then they won't show up in dba_free_space

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