RE: Oracle's ASSM
- To: <kevinc@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Sep 2005 10:55:35 -0400
Kevin,
Yes TAF only works for selects, which is 75% of the database
activity on the manufacturing floor(robot cells) and no their not smart
enough to reconnect never mind resubmit. They currently stop on error
which then causes a "line down" and a lot of damanagement attention.
LONGGGGGG story on why the application is not smart enough to handle
errors, mostly it's a political thing. Namely the developers should not
have to handle errors because errors should not occur and if they do
it's a database issue & the DBA needs to fix it & do something to make
sure it does not happen again. Believe it or not that was promogulated
by someone, no longer here, suggesting that they use Access as the
database of choice!!
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Tuesday, September 13, 2005 10:47 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle's ASSM
We're thinking of moving from dedicated database instances,
with the plethora of management problems associated therein to a couple
of RAC environments for fault tolerance (IE server failure) and load
balancing among the servers as the basics. Oracle is telling us that
ASM or OMF whichever you like is a mandatory part thereof.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
And what we are trying to tell you is that these are not
synonyms.
OMF works in any filesystem AND inside ASM. ASM automatically
manages
the contents of raw partitions (or large files on NAS).
ASM is mandatory for only 1 product, Standard Edition One(SE1) The
SE1 product
is limited to a total of 4 processors CLUSTERWIDE.
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
