About

Martin Klier

usn-it.de

Oracle: Query/Monitoring autoextend of datafiles

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

Oracle: Change (default) TEMP and UNDO tablespace to bigfile tablespaces
Oracle IMPDP: Wildcard hacking

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.