Re: tablespace datafile sizes?

Peter,

You can definitely create a datafile > 1G. Some things to remember are:

    How long will it take to recover that file from your backups.     Can the disk handle that amount of I/O expected.     Make it a multiple of your other db files - in case you need to maneuver files due to I/O bottlenecks.

If these situations can't be met, you may want to look at Oracle Striping.

We create 4GB files(on striped volumes) as our max primarily because restore of the files must be kept to a minimum.

Hope this helps,
Joe Lieto
Redwood Solutions

In article <3572D030.35BE_at_nortel.ca>,
  Peter Chan <chanp_at_nortel.ca> wrote:
>
> I read in an oracle performance tuning book that a datafile for a given
> tablespace should not exceed 500M, is that a good rule of thumb?
>
> Or can we make the tablespace 1G if necessary?
>
> Because I have a table that has grown to 500M and beyond and I would
> like to recreate it with an initial extent that would encompass the
> whole table, but a tables initial extent should not exceed the size of a
> tablespace datafile.
>
> So if I create a tablespace datafile that is 1G, then I could fit the
> entire table into the initial extent.
>
> Thanks a bunch!
> --
> ====================================================================
> PETER CHAN, Northern Telecom
> PHONE: (613) 763-9096 FAX: (613) 763-4408 EMAIL: chanp_at_nortel.ca
> ====================================================================
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 02 1998 - 00:00:00 CDT