一時表領域確認用SQL

・一時表領域情報簡易確認SQL

set line 250
set pages 1000
col tablespace_name for a10
col file_name for a60
col autoextensible for a5
select 
	tablespace_name,
	file_name,
	bytes/1024/1024 as "size(MB)",
	autoextensible
from dba_temp_files;