How to see information for each datafiles Posted by Unknown on October 05, 2016 Get link Facebook X Pinterest Email Other Apps SET LINESIZE 200 COLUMN file_name FORMAT A70 SELECT file_id, file_name, ROUND(bytes/1024/1024/1024) AS size_gb, ROUND(maxbytes/1024/1024/1024) AS max_size_gb, autoextensible, increment_by, status FROM dba_data_files ORDER BY file_name; Comments
Comments