When a datafile autoextends, does it get logged anywhere ? [Edited by khussain on 03-22-2002 at 09:02 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.
Santosh Jadhav 8i OCP DBA
keep in mind that all you want will be in dba_objects
What I want to know is when the datafile extended ?
Since no one has replied, can I assume that it is not logged ?
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/ "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
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?
Forum Rules
Reply With Quote
Bookmarks