How do i know my tablespace is filled up and has no more extents to allocate
From: Subrahmanyam Arya <avsrk_at_mailcity.com>
Date: 9 May 2003 07:35:41 -0700
Message-ID: <25c1993e.0305090635.1125b328_at_posting.google.com>
Date: 9 May 2003 07:35:41 -0700
Message-ID: <25c1993e.0305090635.1125b328_at_posting.google.com>
Dear oracle gurus,
How do i know my tablespace is filled up and has no more extents to
allocate ?? which data dictionary views should i be querying and
exactly what attributes i should be looking for ??? Is it recommended
that i use PCTINCREASE to some thing other than zero and something low
so that free extents are automatically coalesced.
-thx,