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

Thread: size of datafile

  1. 10-19-2002, 06:53 AM #1
    shailendra
    shailendra is offline Senior Member
    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
    Reply With Quote Reply With Quote
  2. 10-19-2002, 07:27 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    select file_name, bytes from dba_data_files
    Reply With Quote Reply With Quote
  3. 10-20-2002, 09:42 PM #3
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    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
    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