Re: SIZE of database including all tables.

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Sat, 20 Jan 2001 10:43:40 -0500
Message-Id: <10747.127215@fatcity.com>

This query gives size of database which is online or up. You can change either your env/SID and obtain size of other databases on same system or using dblinks to check size of online databases on same system or on other systems.

Regards
Rafiq

From: bipin sahani <bipinsahani_at_yahoo.co.in> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Re: SIZE of database including all tables. Date: Fri, 19 Jan 2001 22:20:20 -0800

Thankx Mohammad ,
For your prompt reply.
Is there any query which wil give me the size of database which is ONLINE

Thankx and regards
Bipin
--- Mohammad Rafiq <rafiq9857_at_hotmail.com> wrote: > Bipin,
>
> You may use this script :
>
>
>
> set pagesize 0 linesize 255 heading off feedback off
> SELECT 'The database size is '|| ( (df.sum + rd.sum)
> / ( 1024
> * 1024) )
> || 'Mbg excluding INI, password and control
> files'
> FROM
> (SELECT SUM(bytes) sum FROM sys.dba_data_files) df,
> (SELECT SUM(bytes * members) sum FROM v$log) rd;
> set pagesize 24 heading on feedback on
>
>
> Regards
> Rafiq
>
>
> Reply-To: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> Date: Fri, 19 Jan 2001 04:15:25 -0800
>
> Thankx Raj,
> Can there a way by which I know total size of
> database
> Including system tables as well.User_extents does
> not
> include system tables.And I don't have sqldba prompt
> to query on dba_segmets.
>
> Thankx and regards
> Bipin
> --- Raj Gopalan <raj.gopalan_at_netdecisions.co.uk>
> wrote: > user_extents.
> >
> > -----Original Message-----
> > Sent: 19 January 2001 10:15
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi all,
> > Is there any way to know the size of table in a
> > database.
> > If my table is having 25 columns and 100000 rows
> > By querying any table can I know size of this
> table
> >
> > Thankx and regards
> > Bipin
> >
> >
>

> > Do You Yahoo!?
> > Get your free @yahoo.co.in address at
> > http://mail.yahoo.co.in
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: =?iso-8859-1?q?bipin=20sahani?=
> > INET: bipinsahani_at_yahoo.co.in
> >
> > Fat City Network Services -- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>

> > To REMOVE yourself from this mailing list, send
> an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing:
> UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Raj Gopalan
> > INET: raj.gopalan_at_netdecisions.co.uk
> >
> > Fat City Network Services -- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>

> Do You Yahoo!?
> Get your free @yahoo.co.in address at
> http://mail.yahoo.co.in
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?bipin=20sahani?=
> INET: bipinsahani_at_yahoo.co.in
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>

> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>

> Get your FREE download of MSN Explorer at
> http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Mohammad Rafiq
> INET: rafiq9857_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>

Do You Yahoo!?
Get your free @yahoo.co.in address at http://mail.yahoo.co.in

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?bipin=20sahani?=
   INET: bipinsahani_at_yahoo.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Sat Jan 20 2001 - 09:43:40 CST