Re: Sybase vs Oracle - which is better?

In article <3653AB73.D5366F5A_at_worldnet.att.net>,   jabuhl_at_worldnet.att.net wrote:
> Sybase comes with a nice set of stored procedures for checking system
> tables and monitoring....Oracle has none.
>

Yes but with a limited set. Trying to build your own is a nightmare.

> Sybase has the capability to do temp tables owned by a session. I think
> there a bit of a bitch to manage in Oracle.
>
> Sybase, generally speaking, is easier to administer.

Talk about back, recovery, logs ...

>
> As for row level locking... I have never worked on a system in 10 years
> where that was necessary.
 

> The whole Oracle architecture seems a tad primitive.
>
> joe
>
> Karl Zdero wrote:
>
> > The usual techie debate continues,
> > Is Sybase better than Oracle or is Oracle better than Sybase?
> >
> > When it comes to benchmarks, the www.sybase.com site says that Sybase
> > holds the world record, but www.oracle.com says it holds the record. I
> > see in www.tpc.org that the fastest tpc is with Oracle!
> >
> > Now apart from benchmarks, what makes either database better?
> >
> > I like Oracle as I've used it the most, heres why.
> > + sqlplus is superior than isql, at least I can check return error
> > codes.
> > + PL/SQL is more powerful than TRANSACT/SQL
> > + I can see qll SQL activity for a particular session (SQLAREA),
> > can't do it in Sybase?
> > + Oracle comes standard with many utilities, whereas Sybase doesn't
> > + Oracle has more options with triggers than Sybase. e.g. per row
> > triggers and per statement
> > (In Sybase you must write a cursor loop to action a multiple row
> > insert for example)
> > + Monitors are standard with Oracle. (Sybase dont think so)
> > + Row level locking been for years in Oracle, only recently in
> > Sybase.
> > + Oracle can select data from another database on another server
> > (dblink) Can Sybase?
>
>

--
Denny Koovakattu

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own