Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
ORA 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA 01722 invalid number
 
More logical RAID drives on one controller?

More logical RAID drives on one controller?

2007-03-05       - By Bi iat Radovan

 Back
Reply:     1     2  


Hello,
This is not entirely related to the Oracle on SLES but I hope it is ok to ask.
We have a data warehouse with two main fact tables. They are partitioned and
have their own tablespaces. As the server was setup all database files are on
one RAID logical drive. The server is IBM ML350 with ServeRAID 6M two channel
RAID controller with disk array connected to it.
The application is supplied by a third party. The two fact tables are usually
accessed by full scan in certain partition or partition range.
I was thinking about adding another 3 physical drives and create another
logical drive with RAID 5. Then move the two fact tables with their tablespaces
there.
My question is, is it going to help me to lower the IO contention even it is on
the one controller ?
I truly appreciate any feedback.
Thank you,
Radek
--
Radovan Biciste
Czech Republic

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting