[Tablespace file 찾기] # select file_name, bytes/1024/1024 MB from dba_data_files where tablespace_name='NTSS_IDX'; [Tablespace name 찾기] # select tablespace_name from dba_tablespaces; [Tablespace, size 확인] # select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name; [Tablespace size 변경] # alter database datafile 'E:\ORA92\MARS\NTSSDATA01.DBF' resize 2000m; [Tablespac..

[테이블스페이스 사용량 조회 최신쿼리] SELECT substr(a.tablespace_name,1,30) tablespace, round(sum(a.total1)/1024/1024,1) "TotalMB", round(sum(a.total1)/1024/1024,1)-round(sum(a.sum1)/1024/1024,1) "UsedMB", round(sum(a.sum1)/1024/1024,1) "FreeMB", round((round(sum(total1)/1024/1024,1)-round(sum(a.sum1)/1024/1024,1))/round(sum(a.total1)/1024/1024,1)*100,2) "Used%" FROM (select tablespace_name, 0 total1, sum(bytes..