Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespace Design
Design tablespaces with more files of smaller size (2Gb is a nice size). Use this rule unless the number of datafiles in the database will get unmanageable. You describe a 15Gb database that will grow to 25Gb in a year -- this is not a large database, stick with 2Gb or smaller datafiles.
The advantage of smaller datafiles comes with backup/recovery. In the event that a single datafile needs recovery, a smaller datafile can be recovered more quickly than a larger datafile.
Kevin Kennedy
First Point Energy Corporation
If you take RAC out of Oracle you get OLE! What can this mean?
-----Original Message-----
Sent: Wednesday, August 28, 2002 1:13 AM
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).
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). Received on Wed Aug 28 2002 - 14:58:37 CDT
![]() |
![]() |