Re: Oracle's ASSM
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: kevinc@xxxxxxxxxxxxx
- Date: Tue, 13 Sep 2005 18:15:40 +0100
small correction and small expansion - doesn't invalidate kevin's general
point at all.
On 9/13/05, oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>
wrote:
>
> ASM is mandatory for only 1 product, Standard Edition One(SE1) The
> SE1 product
> is limited to a total of 4 processors CLUSTERWIDE.
Not strictly correct, though given polyserve's market an understandable
error. ASM is mandatory for RAC on either Standard Edition or Standard
Edition 1. It's Standard Edition that has the 4 processor limit, SEOne which
was originally going to be for single CPU boxes - hence the name - has a
limit of 2 processors. 1=2 returns true in this case. In addition you have
to be talking about 10g. RAC is only available as an added cost option for
9i Enterprise Edition (unless you have a site license - but then according
to Oracle those don't exist).
Oh and to add confusion to the mix you can only license SE on machines that
have a capacity of 4 processors clusterwide - even if they only have 4
installed on an 8 proc box it has to be EE (or more likely a compelling
cheaper alternative RDBMS that won't bill you for imaginary hardware.)
Are you really sure you need RAC to properly respond to server
> failure?
> Why not just a fast hot failover scenario? Yes, RAC has TAF, but
> TAF
> only works for SELECT statements. If your middle tier is smart
> enough to
> "reconnect and resubmit" when a SQL failure is due to server
> disconnect,
> failover might be sufficient as it is for many IT shops.
>
>
> Kevin Closson
> Chief Architect
> Oracle Database Solutions
> PolyServe
> http://www.polyserve.com/products.php
>
>
>
>
>
>
>
> This poses a number of problems. First of which is damanagement which
> wants a change control form every time a data file does an auto extend.
> And a number of tablespaces that we don not want extending because we
> put data therein that is to be archived off to CDROM, consequently it's
> necessary for the process loading these tablespaces to error out every
> once in a while. Now I've never been an advocate of anything new that
> Oracle pops out of the factory until it's had some filed experience,
> read that as Not in it's first version. And I'm very skeptical of not
> knowing what is in what tablespace, especially when a hot disk pops up.
> We've used stripping and raid in the past with some really undesirable
> side effects, like mass writes taking forever and having to add more
> devices than we have to extend a mount point, and the resulting device
> additions to all of our Business Continuation Volumes. Basically trying
> that again is a definite no-no around here. True everyone says disk is
> cheap, unless you don't have them available.
>
> ________________________________
>
> From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx]
> Sent: Tuesday, September 13, 2005 3:28 AM
> To: Goulet, Dick
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: Re: Oracle's ASSM
>
>
> On 9/12/05, Goulet, Dick <DGoulet@xxxxxxxx> wrote:
>
> Quick question, is anyone out there using Oracle's
> Automated System
> Storage Management software for production databases?
>
>
>
> I think you mean ASM - Automatic Storage Management, not ASSM
> - Automatic Segment Space Management. ASM is the one with a different
> instance to manage physical storage of data. If you do mean this then
> yes we are using it in RAC environment (10gSE so its mandated). Seems
> to work reasonably well so far.
>
>
>
> Not the
> tablespace level stuff, but the create a mount point &
> let Oracle decide
> the file names, etc...
>
>
>
> technically wouldn't that be Oracle Managed Files or OMF? You
> can do this on a plain file system quite simply since (IIRC 9i Release
> 1).
>
>
>
> I'm interested in knowing if your using it with
> a single instance database or a RAC system or both.
>
>
> See above.
>
>
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified DBA
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
> <http://www.niall.litchfield.dial.pipex.com>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Other related posts:
