Oracle-L: Re: Dbf Files, Mount Points and Oracle 7

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 01 Nov 2002 12:29:00 -0800
Message-ID: <F001.004FA551.20021101122900@fatcity.com>

I have my tables, indexes, system, etc. on different mount points. That was suggested by several of the gurus when I was getting ready to move to new servers.

Ruth

Original Message ----- From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Friday, November 01, 2002 2:54 PM Subject: RE: Dbf Files, Mount Points and Oracle 7

--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, ...?
1. No. In fact, there are all kinds of reasons NOT to keep them on one mount point. Everything from Speed to Safety. When I built our 7.3.4 database I used 64 mount points.
2. Yes. You can split a tablespace up all over the place. Just put the different data files on different mount points.
3. No. In fact, I prefer doing this. Maintenance is a lot easier.
4. No..... but who knows about 10 because its not here yet.

-----Original Message-----

Sent: Friday, November 01, 2002 1:14 PM To: Multiple recipients of list ORACLE-L

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:

Is there any reason to keep all the tablespaces on one mount point?
I know about keeping table data and indexes in different tablespaces but can they also be on different mount points?
Any reason for not putting my 1 large temp-table into its own tablespace?
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: Kevin Lange
    INET: kgel_at_ppoone.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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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 Fri Nov 01 2002 - 14:29:00 CST