Wednesday, January 13, 2021

how to check if auto extend is on or off

set linesize 200 set pagesize 200 col tablespace_name format a20 col file_name format a50 select tablespace_name, file_name, round(bytes/1024/1024,2) Size_MB, round(bytes/1024/1024/1024,2) Size_GB, Autoextensible, round((increment_by*8192)/1024/1024,2) NEXT_increment_MB, round(maxbytes/1024/1024/1024,2) Max_GB from dba_data_files where tablespace_name='&TBS_in_CAPS' order by bytes;

No comments:

Post a Comment