DB Admin: Used, auto and max space of datafile/s of given tablespace in Gb

Given tablespace used, auto and max in GB

set lines 200
set pagesize 150
break on report
compute sum of mbytes on report
col file_name format a70
select
file_id,
file_name,
bytes/1024/1024/1024 CURRENT_USED_GB,
autoextensible,
maxbytes/1024/1024/1024 CAN_GROW_TO_MAX_GB
from
dba_data_files
where
tablespace_name=upper('&Tbs_Name');

Sample output:

March 4, 2014 В· Sanjay В· No Comments
Posted in: 1. DB Admin, 3. All Scripts

Leave a Reply

You must be logged in to post a comment.