Category Archives: oracle

* List each individual tablespace size: SET PAGESIZE 100 COLUMN size_in_mb FORMAT 999999 SELECT tablespace_name, SUM(bytes)/1024/1024 AS size_in_mb FROM dba_segments GROUP BY tablespace_name ORDER BY tablespace_name; * List tablespace usage for each user. * Set min_size_mb to limit the minimal … Continue reading →