1 2 Previous Next 15 Replies Latest reply on Apr 12, 2012 4:25 PM by Balazs Papp Go to original post
      • 15. Re: System tablespace is 99% full
        Balazs Papp
        Enterprise Manager on the Tablespaces tab, shows how much of the allocated space is used
        the default tablespaces should come with datafiles with autoextend enabled and maxsize unlimited options (4M * block_size = typically 32 GB with 8K block size)

        if you want to know the REAL tablespace usage, check for the Tablespace Usage metrics: select * from dba_tablespace_usage_metrics (refreshed periodically, so does not provide realtime data, but its good enough);
        or use any other customized query that takes the maxsize of datafiles into calculation
        1 2 Previous Next