Is datafile autoextend logged anywhere ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Is datafile autoextend logged anywhere ?

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    When a datafile autoextends, does it get logged anywhere ?

    [Edited by khussain on 03-22-2002 at 09:02 AM]

  2. #2
    Join Date
    Dec 2001
    Posts
    221
    you can find it from the dictionary views v$datafile .
    The column create_bytes indicates the size in bytes at the time of creation and bytes - current size.

    Even you can check whether it is autoextensible from dba_data_files.



    Santosh Jadhav
    8i OCP DBA

  3. #3
    Join Date
    Mar 2002
    Posts
    6

    Re:

    keep in mind that all you want will be in dba_objects


  4. #4
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    What I want to know is when the datafile extended ?

  5. #5
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Since no one has replied, can I assume that it is not logged ?

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I've been watching this thread, because I personally could not find it either. Maybe jmodic or sambavan has an idea?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    I've been insvestigating it too and couldn't find anything.

    The only other thing that might be worth investigation would be to dump the controlfile and try to decypher its contents.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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