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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle From a Sybase DBA perspective

RE: Oracle From a Sybase DBA perspective

From: <Brian_P_MacLean_at_eFunds.Com>
Date: Fri, 29 Mar 2002 14:43:23 -0800
Message-ID: <F001.004370BA.20020329144323@fatcity.com>

You made me laugh. I have never worked with Sybase but have heard about this utility. Interesting to note though, we have "validate structure cascade" and several events to detect corruption, and also the dbms_repair package. But I don't put Oracle's detection and correction in the same league as Sybase's.

IMAOBICBW Brian P. MacLean
Oracle DBA, OCP8i

                                                                                                                           
                    Glenn Travis                                                                                           
                    <Glenn.Travis@       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>               
                    sas.com>             cc:                                                                               
                    Sent by:             Subject:     RE: Oracle From a Sybase DBA perspective                             
                    root_at_fatcity.c                                                                                         
                    om                                                                                                     
                                                                                                                           
                                                                                                                           
                    03/29/02 01:18                                                                                         
                    PM                                                                                                     
                    Please respond                                                                                         
                    to ORACLE-L                                                                                            
                                                                                                                           
                                                                                                                           




I've used Sybase (along with Ingres and Informix) in a DBA role in the past and the one thing about Oracle I can say is;

At least Oracle doesn't have an entire chapter in the manuals on corruption and how to detect, prevent and fix it. (see dbcc). To me, that is an admission of failure.

Our shop had to run dbccs every day to detect possible corruption of pages in the database, then run them again to be sure they were really there (this is in the manual), then run other dbccs to fix them. And who's bright idea was it to store the logfile as a table in the database?

> -----Original Message-----
> From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> Sent: Friday, March 29, 2002 1:43 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle From a Sybase DBA perspective
>
>
> Dear list,
>
> Feel like having a good rant? Need to take some frustrations
> out on lies, ignorance and misinformation?
>
> I received a document from a friend that live in both the Sybase
> and Oracle worlds. He was interested in my comments on it
> as he recognized it as a rant against Oracle that was full of
> misinformation.
>
> Oracle has it's problems, but if you want to rant about it's
> inadequacies, you should at least be accurate.
>
> Some of the things in here I can't address, such as the
> IEEE number formats.
>
> Others are just plain stupid.
>
> The writer claims to have spent 3 years with Oracle, but he's
> either lying or extraordinarily incompetent, I dunno which.
>
> Here's my proposal: I'm turning this document loose to the list.
> I was going to comment on it myself, but it's fairly lengthy, and I
> just don't have time to do it myself.
>
> Besides, I know that some of you relish such opportunities. :)
>
> It's in MS Word format. If you want to make comments about
> any section of the document, include your comments in blue
> font below that section.
>
> I will compile the comments, and send the annotated document
> back to my friend. He can distribute it to his Sybase DBA friends
> if he likes.
>
> I was kidding about the ranting. Please keep it objective and
> professional.
>
> Please include your name at the top of the document. Tell me if
> you want your name and email address included in the finished
> document.
>
> The document can be found at:
>
> http://www.cybcon.com/~jkstill/Oracle_from_a_Sybase_DBA.doc
>
> Thanks,
>
> Jared
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Glenn Travis
  INET: Glenn.Travis_at_sas.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Brian_P_MacLean_at_eFunds.Com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Mar 29 2002 - 16:43:23 CST

Original text of this message

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