Re: Sybase vs Oracle - which is better?

In article <3658A4C7.EF178B08_at_worldnet.att.net>,   jabuhl_at_worldnet.att.net wrote:
>
>
> Fuzzy wrote:
>
> >
> >
> > Crap. Never heard of the DBMS packages?
>
> They perform work.I have never seen an Oracle package produces result sets
> to the user.
> What are they? I'll try them.something like "sp_who" that generates a list
> of all users connected to the database
> and others that allow general interogation of the dictionary tables by
> executing a command. Not writing scripts.
>

  You can use dbms_output to get the results back. You can write scripts which give you the info. you require and execute it with @filename.sql . Can you do something of this sort without connecting to isql everytime and passing the filename with the -i option. Also Sybase doesnot have anything equal to spool <filename> . A combination of these makes administration easier.

> >
> >
> > >Sybase has the capability to do temp tables owned by a session. I think
> > >there a bit of a bitch to manage in Oracle.
> >
> > True, though it can be done
> >
> > >Sybase, generally speaking, is easier to administer.
> >
> > Bzzzz. One of the WORST features of Sybase is linear logging - which
> > needs GUESS-WORK to administer!
>
> True. But it can be done. But I find the rest of it easier. Oracles
> environment is cumbersome.
> During my last years experience my database has locked, crashed and and had
> runaway processess only a few times.
> But when it has it never leaves anything in the alert log. Sybase always
> was able to get something to the log before it ate it.
>
> >
> >
> > >As for row level locking... I have never worked on a system in 10 years
> > >where that was necessary.
> >
> > I can think of extreme situations, but I think your right that
> > generally it shouldn't be an issue.
> >
> > >The whole Oracle architecture seems a tad primitive.
> >
> > Mmm, I'd prefer to think of it as different.
> >
> > Ciao
> > Fuzzy
> > :-)
>
>

--
Denny Koovakattu

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