Re: getting size of a oracle db
From: Wojan <dontwantspam_at_yahoo.com>
Date: Tue, 05 Feb 2002 23:00:34 GMT
Message-ID: <muZ78.27156$Ri2.81285_at_rwcrnsc54>
Date: Tue, 05 Feb 2002 23:00:34 GMT
Message-ID: <muZ78.27156$Ri2.81285_at_rwcrnsc54>
"Marc Teufel" <mteufel_at_set-gmbh.com> wrote in message
news:a3bpj8$4h2$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
>
>
Hmmm. I guess you would have to add up the size of all the datafiles? Try this: SELECT Sum((bytes/1024)/1024) MB FROM DBA_DATA_FILES
Hope this helps!
-- ************************************ Scott Wojan wojanware.com Check out our wysiwyg html editor: http://www.wojanware.com/pls/wojanware/productinfo Forward it to a friend and get 20% off the price!Received on Wed Feb 06 2002 - 00:00:34 CET