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
 
ASM Risk / Rewards

ASM Risk / Rewards

2007-09-01       - By -not available-

 Back
Alex and others,

I was a lucky guy to meet with ASM for the first time 3 years ago on a non-RAC
environment on Windows2003 and I was surprised how it worked well. Although we
had only 3 mirrored disks the response time for single-block I/O was about 5ms
and there were about 400 users connected to the system. The I/O was really
evenly spread across all 3 disks.

I have another WORA installation - a 2-node RAC which is in production now for
more than one year. It is a Windows2003 + 10.2.0.1 standard edition + RAC + ASM
and a small storage array. I'm now administering that WORA installation more
than a year and we had a lot of funny problems on this RAC, but there were no
ASM related problems. I never had to do something on ASM level except startup
/shutdown and some manual archivelog purging. The disk I/O response times are
here normal as well.

So don't think I am a Windows fan. My personal belief is that Windows is good
only for my laptop. But my experience with ASM either on Windows or Unix/Linux
is very good so far.

Regards, Joze

-- --Original Message-- --
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On
Behalf Of Alex Gorbachev
Sent: 1. september 2007 0:02
To: oracle-l
Subject: Re: ASM Risk / Rewards

Repost due to over-quoting...

Interesting. Thanks Niall.
Also thanks to Chris for his reply.
Has anyone else on the list used ASM on Windows?


On 8/31/07, Niall Litchfield <niall.litchfield@(protected)> wrote:
> ASM is a requirement for SE RAC. Consequently any SE RAC customers on
> windows will be using ASM. When I was working for them the CPA applications
> for the Audit Commission (
> http://www.audit-commission.gov.uk/cpa/index.asp) were
> hosted on just such a RAC database, though that may have changed since.
>
> ASM worked just fine - this would have been 10.1.0.2 or 10.1.0.3 from memory
> - so even relatively early ASM was pretty good. I wouldn't personally have
> gone with ASM at that early stage if I'd had a choice, so take my comments
> above as an endorsement.
>
> As far as popularity of the platform goes, last I saw Windows users
> accounted for about 30-40% of Oracle's DBMS customers (by number not value).
> It wouldn't suprise me at all if windows+asm is rather more prevalent than
> (say) hpux+asm.
>
> cheers
>
> Niall



--
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l