Max Extents question.

From: Tony <an100000_at_yahoo.com>
Date: Wed, 30 Jan 2002 10:07:34 +0100
Message-ID: <a38d8i$ftq$1@news1.xs4all.nl>

Hi,

I have a statement that monitors the extents usage of Tablespaces. However when off-commenting the clause on the SYSTEM-tablespace: It appears that SYSTEMs extents-usage is far beyond 100% percent!

Howcome? Is the script wrong, or is the SYSTEM-tablespace behaving different than other tablespaces?

SELECT e.tablespace_name "Tablespace"
, COUNT(*) "Used extents"
, t.max_extents "Max extents"
, ROUND((COUNT(*) / t.max_extents), 2) * 100 "Pct extents used"
FROM dba_extents e, dba_tablespaces t
WHERE t.tablespace_name = e.tablespace_name -- AND t.tablespace_name <> 'SYSTEM'
GROUP BY e.tablespace_name, t.max_extents;

Tony,
Oracle DBA Received on Wed Jan 30 2002 - 03:07:34 CST