The best thing you can do for performance is split each file for oracle
onto different disks. Archive logs on one, data on another, indexes on
another, ctl files on another....
I was once told to optimize oracle the best possible way you would need 21
different disks....or course no one does that....
After you add the disk you can create the tablespaces on those disks and
then move tables with the "alter" command.
Have fun.
|---------+--------------------------------------------------------->
| | "Sathiya " |
| | <oracledba-ezmlmshield-x50714889.[Email Address Removed] | azyDBA.com> |
| | |
| | 09/30/2004 12:51 AM |
| | |
|---------+--------------------------------------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: |
| Subject: Indexes and Data on different Disk |
>------------------------------------------------------------------------------------------------------------------------------|
Dear All,
I have a query on the above subject. I am aware that
the performance of the database and queries will increase
if we keep the Index and data on different tablespaces.
I have two questions to this forum
1. My question is that if we keep index and data tablespace
(different datafiles) in two separate hard disk will the
performance increase !!!.
2. My Hardisk has limited diskspace and one of my tablespace
kept in one datafile is increasing as the number of transactions
got increased. Now Can i add one more datafile (that will be
placed in other drive / harddisk) to this tablespace
Thanks in advance
Regards
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
Oracle LazyDBA home page