Re: Oracle file overhead question

From: Tom <tph_at_rmi.net>
Date: 1998/09/29
Message-ID: <slrn710mvs.f4d.tph@shell.rmi.net>#1/1

In article <6uoc40$ia7$1_at_nnrp1.dejanews.com>, doshis_at_my-dejanews.com wrote:
>All,
>
> If you have a datafile = 100M you can not give 100M as your initial extent
>due to overhead.

Isn't that just a pain in the ass?

Here's a little Perl script that'll do it for you:

---

#!/bin/perl

$datafile_size = $ARGV[$#ARGV];
print "$datafile_size\n";

$total_size = $datafile_size + ($datafile_size>>2) * abs(cos($datafile_size)) +

        ($datafile_size>>4) * log($datafile_size); print "$total_size\n";

---

Save it as "overhead", and run it like this:

% overhead 100
149.188992923121

So, the 100M datafile requires 149.2M for the initial datafile size. It seems excessive, but it works. I got this by sending email to the Online Oracle Help Desk. It's an experimental program developed at a university, but it seems to work pretty well. Send email to oracle_at_cs.indiana.edu; put "tellme" in the subject, and your question in the body of the message.

>How to estimate/calculate overhead?

I have a feeling this'll go right overhead, IYKWIM, AIDTYD.

> any help appreciated in advance.
> thankx for yr time.

Always happy to help.

> Shailesh Doshi
> DBA
DBA? Doing Business As what?

-- 
Tom "Tom" Harrington ----- tph@rmi.net ----- http://rainbow.rmi.net/~tph
                         use Perl || die;
Cookie's Revenge:  ftp://ftp.rmi.net/pub2/tph/cr/cookies-revenge.sit.hqx

Received on Tue Sep 29 1998 - 00:00:00 CDT