how to free and used space in individual data files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: how to free and used space in individual data files

  1. #1
    Join Date
    Apr 2009
    Posts
    48

    how to free and used space in individual data files

    Hi all,

    how to know free space and used space in individual database files by sql quer or command not from oracle enterprise manager.please can any body tell me query.quick response will higly appreciated.thanks a lot in advance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    look at dba_free_space

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    allocated space can see in - dba_data_files
    free space can see in - dba_free_space

    so you need write a join query to get what you want. If you have no time to write a query google for it.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  4. #4
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Quote Originally Posted by vnktummala View Post
    allocated space can see in - dba_data_files
    free space can see in - dba_free_space

    so you need write a join query to get what you want. If you have no time to write a query google for it.

    Thanks,
    allocated space in dba_extents.
    free space in dba_free_space.
    total space in dba_data_files.
    lucky

  5. #5
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Hi Maha,

    I mean to say total size of the each datafile in dba_data_files. Anyway, thanks for correcting me.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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