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
 
re: ASM performance on storage RAID 1 or RAID 10 devices

re: ASM performance on storage RAID 1 or RAID 10 devices

2007-04-05       - By Peter Santos

 Back
Reply:     1     2  

-- --BEGIN PGP SIGNED MESSAGE-- --
Hash: SHA1

Guys,
  I'm wondering if any of you have had a chance to test ASM performance
  against a RAID 10 vs RAID 1 device.  This is the concern:

  ASM does 1 MB file extent stripping, and so does it make sense to use a raid
  device that is also stripped .. specially if the storage cannot strip with
  such large strip size?

  The question would be, does one get better IOPS and MB/s with ASM against
  a raid device that is just mirrored or a raid device that is mirrored and
stripped with
  a stripe size that is a multiple of 1MB?

  I spoke to an Oracle architect way back about this, and he said it doesn't
  really matter, but that if you can strip at the storage level, then you should!

  Does anyone have experience testing this? The IO workload that I'm concerned
with
  is lots of small random ios + large read-only sequential ios ?
  I'm familiar with Oracle's tool Orion for testing IO, but I'm wondering if
anyone has tested this out ?

  Any feedback is greatly appreciated!
  BTW, my environment is ( SuSe Enterprise 10 x86_64 + 10.2.0.3 + storage
(DS4400 Disk Systems (FAStT 700))

- -peter
-- --BEGIN PGP SIGNATURE-- --
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGFPwIoyy5QBCjoT0RAvxZAJ9uvdbaHjlOj3SxIdatPNi2jcVeCQCfZ2Zi
jocFhwvkvNIWNKAM/TCfNN0=
=CtIA
-- --END PGP SIGNATURE-- --

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