Re: How do i know my tablespace is filled up and has no more extents to allocate

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 12 May 2003 00:40:56 -0700
Message-ID: <a20d28ee.0305112340.2fc597d5_at_posting.google.com>

avsrk_at_mailcity.com (Subrahmanyam Arya) wrote in message news:<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,
> avsrk

dba_free_space will show you how much space there is left. pctincrease > 0 usually causes more problems than it solves. Leave it alone.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Mon May 12 2003 - 09:40:56 CEST

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: EXP-00056: ORACLE error 1017 encountered"
Previous message: Vaughan Mc Carthy: "ORA-06502: PL/SQL: numeric or value error: character to number conversion error"
In reply to: Subrahmanyam Arya: "How do i know my tablespace is filled up and has no more extents to allocate"
In reply to Subrahmanyam Arya: "How do i know my tablespace is filled up and has no more extents to allocate"
Next in thread: Sybrand Bakker: "Re: EXP-00056: ORACLE error 1017 encountered"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message