Re: getting the size of an oracle db

From: Alistair <alistair.thomson_at_sphinxcst.co.uk>
Date: Thu, 31 Jan 2002 17:08:53 -0000
Message-ID: <a3bthd$bqq$1@thorium.cix.co.uk>

Try

sql> select sum(bytes)/1024/1024"MB" from dba_data_files;

Alistair

"Marc Teufel" <mteufel_at_set-gmbh.com> wrote in message news:a3bpi2$4gu$1_at_set-gmbh.com...
> hi ng,
>
> just a little question. i need a sql-command wich gets the current size
(in
> MB or GB) of a database. i need a SQL cause i want to show the size in my
> vb-programm on a form (ODBC-Connection, in VB I use RDO) .
>
> many thanks for all your help (and sorry for my bad english ;-))
>
> With best wishes from Bavaria/Germany,
> Marc Teufel
>
>
>
Received on Thu Jan 31 2002 - 11:08:53 CST