Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IBM Debunks Oracle's MultiVersion Read Consistency ?

Re: IBM Debunks Oracle's MultiVersion Read Consistency ?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 9 May 2003 09:03:28 +0100
Message-ID: <3ebb60d1$0$10631$ed9e5944@reading.news.pipex.net>


"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3EBB118F.247D_at_yahoo.com...
> Mikito Harakiri wrote:
> >
> > "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> > news:3EBA7745.9FF23FF4_at_exxesolutions.com...
> > > 1. Demand for employees: A quick trip to dice.com, monster.com, and
> > > hotjobs.com indicates no erosion
> > > Worldwide: 997 jobs for DB2, 3786 for Oracle
> >
> > Cause oracle is 4 times more labor intensive?
> >
> > > 2. Demand for training materials: A quick trip to amazon.com,
> > > barnesandnoble.com, etc. indicate no erosion
> > > 226 books on DB2, 1095 on Oracle
> >
> > They have 4 times more unnecessary features?
> >
> > I've just waisted half a day researching why my database hangs. Printing
> > pstack indicated some semahores waiting, etc, etc. Finally 10046 trace
> > revealed that it waits me to manually switch archive log! I
unintentionally
> > turned on archive because I was not able to offline a tablespace without
> > turning archive log -- oracle error explicitly requred me to do so.
Unlike
> > other parameters, archiving mode is not listed in init.ora, but still
> > persists through database shutdown, who might expect it?
>
> There is always the "Concepts" manual...

I'm still chuckling at the idea of archive logging being an unnecessary feature....

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Fri May 09 2003 - 03:03:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US