Re: Dbf Files, Mount Points and Oracle 7

Wayne,
 I don't know about Otacle 10,11 etc.
The direction you are going in in the questions are correct. 1> NO. If you spread the I/O aceoss differnet disks it would eliminate disk contention
2>YES . See question 1.
3>None that I can see if you need a large table for TEMP. Doing a lot of sorts????
4>I have 7.3.4 with one spindle for data and indexes and also 8.1.7 with one spindle for data and one for indexes. Having more spindles makes managing the database easier if there is a spindle failure. I only wish I could get 15 - 20 spindles..
 You can "move " the datafiles to the new disks if you want rather than creating the datafiles and moving the table data, if your data and table layout allow.
Good luck
Ron
ROR mª¿ªm
>>> McGillWL_at_navair.navy.mil 11/01/02 02:13PM >>>
I am part-time DBA for an Oracle system that for reasons beyond our control is frozen at 7.3.4, at least for the immediate future. I am having some problems and I think I know how to correct them but I am asking the old-timers to dust off their brains to tell me if my proposals are O.K.

It started when I noticed that one of the tables had gone into 2 extents. Normally when this happens, I (in a nutshell), make a copy of the table with larger storage parameters. But for this table, I get the following error message:

  ORA-01658: unable to create INITIAL extent for segment

             in tablespace ORA_DATA1

I also noticed that this system has 3 mount points. When I look at the capacity of the disks, the first is always 89 percent full and the other two are 1 percent. This is because all the DBF files for tablespaces were created on the first mount point. So all the other two have are small control and redo-log files.

So what I would like to do to fix all of this is to move some of the tablespaces onto the other 2 mount points. I would also like to create a couple of new tablespaces, one to store two large application-related tables and another to store a large table that gets dropped and recreated everyday (a local copy of data from an external system).

So my questions are:

1. Is there any reason to keep all the tablespaces on one mount point?
2. I know about keeping table data and indexes in different tablespaces but can they also be on different mount points?
3. Any reason for not putting my 1 large temp-table into its own tablespace?
4. If I can do all of this, will anything significantly change in Oracle 8, 9, 10, ...?

I have read different manuals and references but I have not seen anything that indicates that I cannot do what I am proposing. I have tried this solution on a test 8.1.6 database and everything seems to be working.

TIA, Wayne
McGillWL_at_naviar.navy.mil

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: McGill, Wayne L
  INET: McGillWL_at_navair.navy.mil 

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.com
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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