re:tablespace datafile sizes?

Peter,

I have previously used datafiles of 2G, with extents that use the whole file, without any problems.

Go for it.

Rgds
allan.webster_at_pancredit.com

> ----------
> From: Peter Chan[SMTP:chanp_at_nortel.ca]
> Posted At: Monday, June 01, 1998 5:00 PM
> Posted To: server
> Conversation: tablespace datafile sizes?
> Subject: tablespace datafile sizes?
>
> 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
> ====================================================================
>
Received on Tue Jun 02 1998 - 00:00:00 CEST