Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Max Extents question.
Are you sure that maxextents is for tablespace ?
This is part of default storege for all object created in this tablespace.
So the tables or something else in tablespace else doesn't allocate more
extents than maxextents by default (you can change this by storage clause of
the object which you create).
The size of tablespace is limitted only by size of all its files.
Regards
Przemek
The size of tablespace is limit
Użytkownik "Tony" <an100000_at_yahoo.com> napisał w wiadomości
news:a38d8i$ftq$1_at_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 - 08:14:18 CST