SQL> select tablespace_name,sum(bytes/1024/1024) from dba_data_files group by
tablespace_name;
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
USERDATA 100
SYSAUX 200
UNDOTBS 100
SYSTEM 200
For finding the size of temp tablespace?
SQL> select tablespace_name,sum(bytes/1024/1024) from dba_temp_files group by tablespace_name;
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ -------------------
TEMPX 100
tablespace_name;
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
USERDATA 100
SYSAUX 200
UNDOTBS 100
SYSTEM 200
For finding the size of temp tablespace?
SQL> select tablespace_name,sum(bytes/1024/1024) from dba_temp_files group by tablespace_name;
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ -------------------
TEMPX 100
No comments:
Post a Comment