Usn's IT Blog

Did you ever wonder how to see whether your datafile is on autoextend or not, or monitor the autoextension to keep eyeballs on target? The Oracle EM is a simple tool for that, but some people do prefer the direct query.

See a little example to query or autoextend a datafile.

select * from dba_data_files where tablespace_name='USERS';

alter database datafile &datafilenumber AUTOEXTEND
        on next &increment maxsize &maxsize;

Take care
Usn