Oracle-L: RE: performance impact

From: Kevin Toepke <ktoepke_at_rlcarriers.com>
Date: Mon, 28 Apr 2003 13:56:48 -0800
Message-ID: <F001.0058ACD8.20030428135648@fatcity.com>

Roger

Once you make sure that your hardware setup can handle files >2G, the size of the datafiles shouldn't matter, performance wise.

What you should do is split your application tables by size and use. Keep small, infrequently updated tables in on tablepace, highly volitile tables in another set (by size)and your large (history) tables in another set.

If you are using partitioning for windowing your data, I think it is a good idea to keep each table partition on a separate tablespace/datafile. It makes space management a bit easier as you can make the older, read-only, tablespaces read-only.

Kevin

-----Original Message-----
Sent: Monday, April 28, 2003 5:02 PM
To: Multiple recipients of list ORACLE-L

For a 400 GB tablespace, which one is better?

200 2GB datafiles
100 4GB datafiles
50 8GB datafiles
25 16GB datafiles

[64-bit Oracle 9i on Solaris 9]

Thanks,
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>

This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Roger Xu
  INET: roger_xu_at_dp7uptx.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: Kevin Toepke
  INET: ktoepke_at_rlcarriers.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Mon Apr 28 2003 - 16:56:48 CDT