Is datafile autoextend logged anywhere ?

**khussain** · 03-21-2002, 06:21 PM

When a datafile autoextends, does it get logged anywhere ?

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

**sjadhavdba** · 03-22-2002, 01:32 AM

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.

**thushara** · 03-22-2002, 05:36 AM

keep in mind that all you want will be in dba_objects

**khussain** · 03-22-2002, 10:11 AM

What I want to know is when the datafile extended ?

**khussain** · 03-22-2002, 04:33 PM

Since no one has replied, can I assume that it is not logged ?

**marist89** · 03-22-2002, 05:02 PM

I've been watching this thread, because I personally could not find it either. Maybe jmodic or sambavan has an idea?

**jmodic** · 03-22-2002, 05:47 PM

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.

Thread: Is datafile autoextend logged anywhere ?

Thread Tools

Display

Re:

Posting Permissions