size of datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: size of datafile

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    HI

    I need help.
    I the size of my datafile has increase and I do not know which datafile's size has increased how to find that, please let me know if anyone has idea.

    Thanking You
    Shailendra

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    select file_name, bytes from dba_data_files

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    you can check the current size of the files from dba_data_files but you will not know ehich file has increased in size unless have past reports on datafile size.
    Check the autoextend settings for your datafiles.

    Sanjay

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