Re: Sybase vs Oracle - which is better?

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.

>
>
> >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
> :-)
Received on Sun Nov 22 1998 - 00:00:00 CST