Category: Database Scripts

Frequently used Tablespace Queries

Published December 21, 2015 By Brijesh Gogia

Below are some of the simple but frequently used database tablespace related queries used by DBAs:

Check Temporary tablespace temp files size

set lines 132
col FILE_NAME format a60
select TABLESPACE_NAME,FILE_NAME,BYTES/1024/1024,AUTOEXTENSIBLE,MAXBYTES/1024/1024 from dba_temp_files;