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
>>> [EMAIL PROTECTED] 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
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: McGill, Wayne L
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
