Oracle-L: RE: Tablespace Design

From: <Long.Nguyen_at_csiro.au>
Date: Wed, 28 Aug 2002 16:13:24 -0800
Message-ID: <F001.004C21EC.20020828161324@fatcity.com>

Hi Pawan,

Having smaller files

easier to move a db file to diffrent drives if required
quicker to recover a single file if necessary

Having larger files

easier to manage due to smaller no. of files

My personal choice: I am comforatble with file size around 5GB.

Long

-----Original Message-----
Sent: Wednesday, 28 August 2002 6:13 PM
To: Multiple recipients of list ORACLE-L

Hi DBA gurus,

One of the application is going live .At presenr data is 15GB and will grow more by 10 GB in year time. What is the right approach of tablespace design having more files of smaller size(10 files of 2 GB ) or less file of bigger size (3 files of 8 gb ). No tables in this application is partitioned all the files will be on a single disk I am Orcale 8.1.7 on Win 2K.

2) Following is output of my v$waitstat . Kinly give som suggestions

CLASS                   COUNT       TIME
------------------ ---------- ----------
data block              46251          0
sort block                  0          0
save undo block             0          0
segment header             15          0
save undo header            0          0
free list                   0          0
extent map                  0          0
bitmap block                0          0
bitmap index block          0          0
unused                      0          0
system undo header          0          0
system undo block           0          0
undo header              1225          0
undo block                 55          0

Regards
Pawan Dalmia

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Pawan Dalmia
INET: Pawan.Dalmia_at_orange.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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.com
--

Author:
INET: Long.Nguyen_at_csiro.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------