Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: used space

Re: used space

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 04 Apr 2001 09:27:05 +0100 (BST)
Message-ID: <PYE*2ARSo@news.chiark.greenend.org.uk>

Ralf Zwanziger <goldensurfer_at_gmx.de> wrote:
>How can I find out the used space of a datafile? The v$datafile view
>only shows the total size of the datafile.

dba_free_space or user_free_space will give the amount of free space.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/
Received on Wed Apr 04 2001 - 03:27:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US