Re: %USED, %FREE in TABLESPACES

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 18 Sep 2002 22:58:31 +0200
Message-ID: <r6qhou48nc2menisu8rl8t89porpjurgtr@4ax.com>

On Wed, 18 Sep 2002 22:30:29 +0200, cava123 <cava123_at_noos.fr> wrote:

>How to get information about volume USED in the TS ? (insert it into STATS)
>(USER_EXTENTS, USER_SEGMENTS can help but I dont know how to. I make a desc for
>each of those tables and didnt see information about Volume USED).
>PS : for the day column I can insert sysdate.

The volume used is the sum of bytes used for the individual segments.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Sep 18 2002 - 15:58:31 CDT