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: Usual meaning of "size" of a database

Re: Usual meaning of "size" of a database

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 6 Feb 2004 10:37:01 -0000
Message-ID: <40236e4d$0$10333$ed9e5944@reading.news.pipex.net>


volume of redo/day anyone?

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message
news:40236738$1$4249$afc38c87_at_news.optusnet.com.au...

> "Rick Denoire" <100.17706_at_germanynet.de> wrote in message
> news:2eg520h49jks8re0uc4dt7f9b4t51q22t0_at_4ax.com...
>
> >
> > So what is the usual method to report the size of a database,
> > according to your experience?
>
> Varies enormously. If someone asks for the "data" size,
> I add up table size.
>
> If it is schema size, I add all used space in data + index.
>
> If it is total db space usage I add up all data file sizes,
> including redo, undo, temp, etc.
>
> But that's me. I've seen guys running DB2 environments who added
> the db size AND the backup sizes. To make their dbs look larger.
> Somehow, it reminded me of socks...
>
>
> --
> Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au.nospam
>
>
Received on Fri Feb 06 2004 - 04:37:01 CST

Original text of this message

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