RE: RE: ORACLE VS. SYBASE
I'm guessing they woulda bought Sybase products and Oracle stock... :0) -Original Message- Sent: Wednesday, September 26, 2001 6:50 PM To: Multiple recipients of list ORACLE-L Humm, IMHO Larry was right. Reply Separator Author: "Miller; Jay" <[EMAIL PROTECTED]> Date: 9/26/2001 9:00 AM No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: ORACLE VS. SYBASE
Wall St. bought Sybase back then simply because it was faster. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, September 26, 2001 10:00 AM > No guarantees as to accuracy, but I heard this story about 7 years ago from > someone who said he was there. > > Apparently when the major Wall St. firms were deciding whether to go with > Oracle or Sybase they arranged to have both companies come in and do > presentations and say what special arrangements they'd be willing to offer. > > Sybase sent high level management who came with a list of features, > explained their policies and offered a substantial discount. > > Oracle sent Larry Ellison who told them Oracle didn't have to offer > discounts because it was obviously superior and anyone who bought Sybase was > an idiot. > > > They bought Sybase. > > > Jay Miller > > -Original Message- > Sent: Tuesday, September 25, 2001 9:40 AM > To: Multiple recipients of list ORACLE-L > > > > > -- Guy Hammond <[EMAIL PROTECTED]> > > > > That's about all I can be bothered to type for now. In summary, I would > > like to say that Sybase is a fine product for your grandmother to store > > her recipes in :0) > > Interesting to note that a good number of financial companies -- who > make a living off of fast, stable databases -- use Sybase. They tend > to prefer it for its combination of speed and cost of operation. None > of them store recipies on it that I know of, nor do they allow their > grandmothers access to the systems. > > -- > Steven Lembark 2930 W. Palmer > Workhorse Computing Chicago, IL 60647 > +1 800 762 1582 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Lembark > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Miller, Jay > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Greg Moore INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
-Original Message- Sent: Wednesday, September 26, 2001 12:01 PM To: Multiple recipients of list ORACLE-L No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: YTTRI Lisa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
Stick to delimited text files and you'll be fine. Gary Weber Senior DBA Charles Jones, LLC||Superior Information Services, LLC 609-530-1144, ext 5529 -Original Message- Miriam Sent: Wednesday, September 26, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Thanks to everyone that participated in this very informative, spirited and amusing discussion of these products, I'm wondering if we should go with MS server instead... Miriam -Original Message- Sent: Wednesday, September 26, 2001 1:01 PM To: Multiple recipients of list ORACLE-L No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Bryan, Miriam INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Gary Weber INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
Thanks to everyone that participated in this very informative, spirited and amusing discussion of these products, I'm wondering if we should go with MS server instead... Miriam -Original Message- Sent: Wednesday, September 26, 2001 1:01 PM To: Multiple recipients of list ORACLE-L No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Bryan, Miriam INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
No guarantees as to accuracy, but I heard this story about 7 years ago from someone who said he was there. Apparently when the major Wall St. firms were deciding whether to go with Oracle or Sybase they arranged to have both companies come in and do presentations and say what special arrangements they'd be willing to offer. Sybase sent high level management who came with a list of features, explained their policies and offered a substantial discount. Oracle sent Larry Ellison who told them Oracle didn't have to offer discounts because it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Miller, Jay INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
Ooops, I meant to say that a the article I was responding to was factually incorrect, not my own post :0) g -Original Message- Sent: Tuesday, September 25, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Hmm, quite a bit of this is factually incorrect, and may be based on a comparison between the latest Sybase and an older Oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: SQLMOD (Was RE: ORACLE VS. SYBASE)
SQLMOD ("SQL Module") is how DEC implemented 3GL access to DEC rdb. The
dev/programmer created a SQLMOD file that contained ALL SQL statements.
This module (file) was then "compiled" separately to create an object file.
The 3GL program then just needed to call the functions and procedures
defined in the SQLMOD, instead of having to worry about the mess of
pre-compiling and binding variables and the like.
A very simple way of implementing SQL in *ANY* 3GL language! If you think
about it, all the SQL calls are in the "compiled" SQLMOD that gets linked in
with the 3GL code to create the executable. So, as far as the 3GL is
concerned, the SQL calls are just another external call.
I think there is also a way to make the SQL more dynamic, but it's been too
long since I've actually worked with this stuff.
How's about an example?
Here's an excerpt from a SQLMOD file:
MODULE MY_SQL
LANGUAGE BASIC
PARAMETER COLONS
ALIAS MY_RDB_DB
DECLARE MY_RDB_DB ALIAS COMPILETIME filename 'my_rdb_db'
RUNTIME FILENAME 'MY_RDB_DB'
declare GET_TICKET_INFO cursor for
SELECT transaction_date,
crdt_card_stmnt_dt,
transaction_amount,
transaction_status,
tax,
ticket_penalty,
tt_id,
trav_doc_type_cd
FROM ttaction
WHERE (ttaction.ticket_id = :my_ticket_id AND
ttaction.transaction_status = :my_trans_status)
-- PROCEDURE section
procedure FETCH_TICKET_INFO
SQLCODE
:my_TICKET_TRANS RECORD FROM 'CDD_TRAVEL.RECORDS.TICKET_TRANSACTION' END
RECORD
:my_TICKET_TRANS_IND RECORD FROM
'CDD_TRAVEL.INDICATORS.RECORDS.TICKET_TRANSACTION_IND' END RECORD;
FETCH GET_TICKET_INFO
INTO :my_tt.transaction_dateindicator
:my_tt_ind.transaction_date_ind,
:my_tt.crdt_card_stmnt_dt indicator
:my_tt_ind.crdt_card_stmnt_dt_ind,
:my_tt.transaction_amount indicator
:my_tt_ind.transaction_amount_ind,
:my_tt.transaction_status indicator
:my_tt_ind.transaction_status_ind,
:my_tt.tax indicator :my_tt_ind.tax_ind,
:my_tt.ticket_penalty indicator
:my_tt_ind.ticket_penalty_ind,
:my_tt.tt_id indicator :my_tt_ind.tt_id_ind,
:my_tt.trav_doc_type_cdindicator
:my_tt_ind.trav_doc_type_cd_ind;
procedure ROLLBACK_TRANSACTION
SQLCODE;
ROLLBACK;
procedure COMMIT
SQLCODE;
COMMIT;
And here's a few sample calls from a BASIC program (remember, this is for
rdb on VMS!):
! open cursor
CALL OPEN_GET_TICKET_INFO( SQLCODE.L, TICKET_TRANS_REC::TICKET_ID, &
STAT.CODE.L )
IF SQLCODE.L <> 0 THEN
IF SQLCODE.L = SQLCODE_DEADLOCK OR SQLCODE.L = SQLCODE_LOCK_CONFLICT
THEN
ERROR.TEXT.S = "Record locked by another User."
!GOSUB GENERAL_ERROR
ELSE
SYS.STATUS.L = RDB$MESSAGE_VECTOR::RDB$LU_STATUS
CALL SQL$GET_ERROR_TEXT( ERROR.TEXT.S )
CALL ROLLBACK_TRANSACTION (SQLCODE.L)
CAUSE ERROR BAS$K_NOTBASIC
END IF
END IF
WHILE SQLCODE.L = 0
! fetch info
CALL FETCH_TICKET_INFO( SQLCODE.L, TICKET_TRANS_REC, TICKET_TRANS_IND_REC )
SELECT SQLCODE.L
CASE 0
! procede with data collection
GOSUB FILL_TICKET_DETAIL
GOSUB PUT_RECORD
CASE SQLCODE_EOS
! fall out of loop
CASE SQLCODE_DEADLOCK, SQLCODE_LOCK_CONFLICT
CALL ROLLBACK_TRANSACTION (SQLCODE.L)
ERROR.TEXT.S = "Record locked by another User."
VALID.DATA.B = FALSE.B
CASE ELSE
SYS.STATUS.L = RDB$MESSAGE_VECTOR::RDB$LU_STATUS
CALL SQL$GET_ERROR_TEXT( ERROR.TEXT.S )
CALL ROLLBACK_TRANSACTION (SQLCODE.L)
CAUSE ERROR BAS$K_NOTBASIC
END SELECT
NEXT ! while sqlcode.l = 0
! close cursor
CALL CLOSE_GET_TICKET_INFO ( SQLCODE.L )
IF SQLCODE.L <> 0 THEN
SYS.STATUS.L = RDB$MESSAGE_VECTOR::RDB$LU_STATUS
CALL SQL$GET_ERROR_TEXT( ERROR.TEXT.S )
CALL ROLLBACK_TRANSACTION (SQLCODE.L)
CAUSE ERROR BAS$K_NOTBASIC
END IF
If there's anybody from Oracle on this list :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tuesday, September 25, 2001 14:52
To: Multiple recipients of list ORACLE-L
Care to explain further, SQLMOD concept, for those
like me who have no idea what this is?
thx
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Californ
SQLMOD (Was RE: ORACLE VS. SYBASE)
Care to explain further, SQLMOD concept, for those like me who have no idea what this is? thx --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > So has Sybase FINALLY been able to implement > row-level locking? Our parent > company uses Sybase and even as far up as at least > version 11, locking was > only down to block-level. > > And since Oracle7, which was the direct result of > Oracle raping code from my > beloved DEC rdb, it's been a viable option for many > more companies. Now if > they'll only implement the absolutely wonderful > SQLMOD concept from rdb! > > My $.02 > > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
> The Financial community is owned by Sybase. Yeah, and the financial community was the most significant user base of the "Next" O/S too. Aren't these the same people responsible for the dot.com hype before the bubble burst? Didn't they say the new economy makes the old economy obsolete and that the "old rules" no longer apply? Yeah, they possess superior judgment. ;-) Steve Orr -Original Message- Sent: Tuesday, September 25, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Sybase is also very popular in the Minneapolis / St. Paul, MN area with hospitals and HMO's. FYI - there are about 175 companies in the area here using Oracle. My $0.02 worth, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -Original Message- Sent: Tuesday, September 25, 2001 10:55 AM To: Multiple recipients of list ORACLE-L I second that. The Financial community is owned by Sybase. Oracle is scoffed at...too slow...too pricey...too much fluff. Oh, and apparently, the DBAs have attitude, and you need to buy too many of them to keep the rusty garbage scow running. ;-) -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ken Janusz INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Orr, Steve INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
So has Sybase FINALLY been able to implement row-level locking? Our parent company uses Sybase and even as far up as at least version 11, locking was only down to block-level. And since Oracle7, which was the direct result of Oracle raping code from my beloved DEC rdb, it's been a viable option for many more companies. Now if they'll only implement the absolutely wonderful SQLMOD concept from rdb! My $.02 Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
The Fidelity Brokerage Services, LLC uses Oracle - that's were I have my stock portfolio. Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -Original Message- Sent: Tuesday, September 25, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Can you please list those companies? I may need to move some money around. >>> [EMAIL PROTECTED] 09/25/01 09:40AM >>> -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Gene Sais INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ken Janusz INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
Sybase is also very popular in the Minneapolis / St. Paul, MN area with hospitals and HMO's. FYI - there are about 175 companies in the area here using Oracle. My $0.02 worth, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -Original Message- Sent: Tuesday, September 25, 2001 10:55 AM To: Multiple recipients of list ORACLE-L I second that. The Financial community is owned by Sybase. Oracle is scoffed at...too slow...too pricey...too much fluff. Oh, and apparently, the DBAs have attitude, and you need to buy too many of them to keep the rusty garbage scow running. ;-) -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ken Janusz INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
We do remote installs of Oracle all the time. You need Exceed on your PC (full package, not just telnet and ftp). You need to set your DISPLAY variable and you need to start a window manager (I use dtwm on Solaris). Then you can run Oracle OUI (universal installer). This has worked fine. Make sure to start a window manager first otherwise you may get unpredictable behavior. Gerardo -Original Message- Sent: Monday, September 24, 2001 1:30 PM To: Multiple recipients of list ORACLE-L -- "Bryan, Miriam" <[EMAIL PROTECTED]> on 09/24/01 11:53:55 -0800 > In your opinion, which one is more robust, better? we need > replication and resource management. This comes down to a religious issue in many respects. Each of the databases does things the other doesn't; each does some things differently in ways that make some people [un]happy. I've flushed any use of Oracle until they dump the "Universal Installer" mainly because it makes getting the product up and running nearly impossible on my systems (try a remote install with it sometime). I'm also not happy that Oracle has replaced quite a few operational methods (e.g., analyze table, svrmgrl) with things that don't seem to work as well on my and other sites. Net resul that they took working methods out of service before the new ones were wrung out the point of production stability. One place to look for traceoffs is the Perl DBI mailing list archives. Even if you don't use DBI itself the list contains good descriptions of what problems people have with various databases. sl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Molina, Gerardo INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
Can you please list those companies? I may need to move some money around. >>> [EMAIL PROTECTED] 09/25/01 09:40AM >>> -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Gene Sais INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
I second that. The Financial community is owned by Sybase. Oracle is scoffed at...too slow...too pricey...too much fluff. Oh, and apparently, the DBAs have attitude, and you need to buy too many of them to keep the rusty garbage scow running. ;-) -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
arghh it's not the first time a mail I sent is being truncated or translated in funny
characters , it was the end of the mail.
I posted this not in the view to start flames (even if ...:) , but I found out that
people in this list have a long DB experience across several platform (contrary to me
poor little rookie) and I thought it could be really interesting to have their point
of view .
/Maya
-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Leith
Sent: Tuesday, September 25, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORACLE VS. SYBASE
Maya,
I'd be interested in seeing the rest of this mail (if there is more?). See
below, it looks like the tail of the message was cut off or corrupted?
Cheers
Mark
P.S. - Great post - I'm sure it will start some flames :P
-Original Message-
Sent: Tuesday, September 25, 2001 10:15
To: Multiple recipients of list ORACLE-L
See below a mail I received from Sybase oriented person :) Please argue it
maybe very interesting (original mail was Sybase vs Oracle:Why to go to
Sybase?)
/Maya
-
- Synonyms:
- Time datatype: Oracle seperates Time from Date. Sybase's datetime
datatype has both included in one, plus a whole suite of display styles
that can show the date/time in a multitude of
formats.>W±ëzØ¡÷r&9,B¶Ã §©Ê뢳ɢw Ѭ
éz»zf¢a´(È×ÂIêÇóßÎçQ_ÎçÓjpz
jX¢¹hû'×ëqdzóX¸¶ÄDCTLº»÷¢kÉXX¶Çu©1¨ëj ¸¬´k«¹ör+rr§¢×\
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).åy« ±ç
ê ~'"jS "Ä,PÛiÿü0ÂÚ}ª¢`.¶+1¬)éçz²
9É© w«¶·¦iÊ&«BÜzÜ(®D®øzÏ9óüçNuüçÎwó9Õ&§' &¥ú+&¹¹bpíz¹Þµ§ zË?1¨¥x ËlND0åDÊ«±é_~º&¶¬¨¥x%ËlzwZCY²Æ zÚ ËFº»j×"·'(z-xEÀ
;)zYb
.+-êîjwbØ^ë,j86"Énuæ¥w¢{Zx§CRP "Ä.í
éÚê ¨¥x%Ër¢ìÛhmêÞÞuúè.¬Ê,zwm
áÄ,÷(f§uú+¢Ø^®)ߢ¹¶*') ²æìr¸x
Re: ORACLE VS. SYBASE
On Tuesday 25 September 2001 02:15, Maya Kenner wrote: > > Sybase... > - 11.9.2 is beating Oracle's database in Tpc tests. See the TPC-C > tests at www.tpc.org and sort by Hardware Vendor. A recent TPC-C > benchmark of Sybase ASE 12.0..0.2 on Sun E-1 beat Oracle on > the same platform by 36%. (Cost per transaction (156,873 tpmC) was > $48.81 vs. Oracle's (115,395 tpmC) of $105.63). This is the fastest > TPC benchmark ever recorded (as of 12/2000) for a SMP environment. > TPC is not useful for comparing database vendors. So what if database X is faster than database Y in some specialized configuration? Very few customers will ever try to push the database that hard. We're all familiar with the phrase 'with flexibility comes complexity'. Well, Oracle is a very complex beast, capable of doing just about anything you wish it to do. It might be a little slower, it might be a little faster, who cares. As far as the $$ per transaction, the only possible purpose that serves is to catch the attention of bean counters. It's a phony number. $$ per transaction is as dependent on your organization as it is on the HW and SW. > - Sybase is far less Expensive than Oracle. Arbitrarily, Oracle charges > per megahertz on the CPU, a Universal Power Unit. UPU=number of processors > multiplied by processor speed, multiplied by $100 (the current price per > UPU). This has problems two ways; a PC chip works at far higher megahertz > speeds than a Sun Ultrachip, meaning a far more powerful server costs far > less than a PC-based server. Secondly, users are charged for capacity over > an entire server, even if Oracle is not the only software running. > Additional features are always additional cost in Oracle; Sybase builds in > all features to its entine. Sure it is. The Sybase feature set is nowhere near as rich as Oracle's. > - Oracle's Tech support is inferior compared to Sybase's. Online case > management and updating, instant reponse times. Actually, I've usually had pretty good success with Oracle Support. It's been a *long* time since I've actually had to open a TAR. > - Sybase is cheaper to administer, from a DBA standpoint. Mgrs report > that one Sybase DBA can do what 2-3 Oracle DBA's do. That's a crock. I've taken the Sybase classes. There just isn't as much to do, because it does less. Does spending all your time running dbcc count? > - Sybase's Customization and Tuning is simple (one text file contains > hundreds of database server options) compared to tuning Oracle. It is > far easier to administer, install, operate Sybase. Very easy to create > databases versus instances. Not true. Oracle is easier. Been there, done it. > > - Disaster Recovery; with inline backup utilities, Sybase can back itself > up on the fly w/o taking tablespaces offline. Replication server > creates a warm standby for 100% uptime. Oracle can do neither. Replication Server is indeed very powerful. However, you *will* need a consultant to set it up. Trust me, if you don't have a lot of experience with it, you'll make a mess. OK, out of time. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
And what about row level locking? Sybase was the first to implement stored procedures and triggers and Oracle was way behind on this. At that time Sybase was growing rapidly and gaining market share. It was also at that time that Sybase established itself with lots of custom apps being developed in the investment services niche. That was at a time of relatively moderate growth in the RDBMS market. Then things changed. The Client-server RDBMS market started growing rapidly and large ERP apps came to the fore. SAP, Peoplesoft, and the like ran on Oracle but not on Sybase. These software companies said they could not run their apps on Sybase because of its lack or row level locking. If that's the case then the lack of this one feature spelled the demise of a once strong database company. Since then Sybase' stock has plummeted and Oracle's has soared. The rest is history. Steve Orr -Original Message- Sent: Tuesday, September 25, 2001 5:30 AM To: Multiple recipients of list ORACLE-L Hmm, quite a bit of this is factually incorrect, and may be based on a comparison between the latest Sybase and an older Oracle. Firstly, yes, Oracle is way more expensive than Sybase. Funnily enough, this means that Oracle Corporation are financially rock-solid, and Sybase are on the verge of collapse. A database is for life, not just for Christmas. Oracle tech support is at least as good as Sybase's, but that depends on the level of support you are willing to pay for. I once worked for a client who reported a bug and had a new build of Oracle delivered to them on a gold CD the next morning. Oracle does have online case management and updating, via MetaLink. Sybase cheaper to administer? Yes, you just need to hire someone to run "dbcc" every couple of hours :0) You have to compare like with like: one man can row a boat across a lake, but the USS Nimitz has a crew of 6000. And if you want one text file containing hundreds of options, well we have init.ora for that. A Sybase database is not the same thing as an Oracle database, it's more like a schema, with a Sybase server being like an instance. There's one user database per server, and users are assigned to databases, just like the way we grant roles to users. This may make administration easier, but it also means you can't have multiple database instances tuned for different applications on the same hardware. The fact that Sybase runs threaded and Oracle runs as processes is neither here nor there. And Sybase manages memory "better", what does that mean? Quicker, uses less, can handle more, what? I don't understand the point about Oracle not cleaning up its temporary segments, of course it does. And Sybase shares its tempdb between all databases on the machine, whereas Oracle has one per instance. again making tuning and segregation of different applications impossible. Far better documentation? Yes, Sybooks was good in its day, but MetaLink/TechNet have caught up now. I guess it's a good thing that it's easy to unload data from Sybase, in the same way that it's easy to dump a CSV file from MS Access. The comment on disaster recovery is utter rubbish, of course Oracle can be backed up while fully online and handling transactions. You can use export, hot backup or RMAN. Oracle has powerful replication also, or you can use dblinks and AQs to move data back and forth between instances under programmatic control. Sybase can't. And later on backups, Oracle has a range of options for backups, RMAN, Legato, hotbackup, whatever. And, of course, there's no equivalent of "dbcc" in Oracle, we don't need it, since datablock corruption is not a daily occurrence for us... Sybase still does have a good presence in financial services, but that's mainly a legacy thing, lots of T-SQL already written, just like there's lots of COBOL already written. This is something to boast about? I think not. T-SQL is a pretty limited language for stored procedures, it cannot compare to PL/SQL. Every SELECT in Oracle is an implicit cursor, true, but that's because Oracle knows how to run cursors efficiently. Sybase never could, this is why Sybase programmers never use cursors, not because they're inherently a bad idea. We are multi-threaded, it's called MTS. Next he'll be claiming that Oracle can only take one connected client at a time! And finally, the killer: Sybase is similar to MSSQL. Enough said! That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) g -Original Message- Sent: Tuesday, September 25, 2001 10:15 AM To: Multiple recipients of list ORACLE-L See below a mail I received from Sybase oriented person :) Please argue it maybe very interesting (original mail was Sybase vs Oracle:Why to go to Sybase?) /Maya - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services
RE: ORACLE VS. SYBASE
Keep in mind when you say "cost of operation" that also means the cost of making a change including rewriting most of your custom code. I'm not privy to the decision making in financial companies but I assume a decision based on 'if it ain't broke don't fix it' would be different from one based on 'if we were starting fresh today'. Henry -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Henry Poras INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
-- Guy Hammond <[EMAIL PROTECTED]> > That's about all I can be bothered to type for now. In summary, I would > like to say that Sybase is a fine product for your grandmother to store > her recipes in :0) Interesting to note that a good number of financial companies -- who make a living off of fast, stable databases -- use Sybase. They tend to prefer it for its combination of speed and cost of operation. None of them store recipies on it that I know of, nor do they allow their grandmothers access to the systems. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
Hmm, quite a bit of this is factually incorrect, and may be based on a comparison between the latest Sybase and an older Oracle. Firstly, yes, Oracle is way more expensive than Sybase. Funnily enough, this means that Oracle Corporation are financially rock-solid, and Sybase are on the verge of collapse. A database is for life, not just for Christmas. Oracle tech support is at least as good as Sybase's, but that depends on the level of support you are willing to pay for. I once worked for a client who reported a bug and had a new build of Oracle delivered to them on a gold CD the next morning. Oracle does have online case management and updating, via MetaLink. Sybase cheaper to administer? Yes, you just need to hire someone to run "dbcc" every couple of hours :0) You have to compare like with like: one man can row a boat across a lake, but the USS Nimitz has a crew of 6000. And if you want one text file containing hundreds of options, well we have init.ora for that. A Sybase database is not the same thing as an Oracle database, it's more like a schema, with a Sybase server being like an instance. There's one user database per server, and users are assigned to databases, just like the way we grant roles to users. This may make administration easier, but it also means you can't have multiple database instances tuned for different applications on the same hardware. The fact that Sybase runs threaded and Oracle runs as processes is neither here nor there. And Sybase manages memory "better", what does that mean? Quicker, uses less, can handle more, what? I don't understand the point about Oracle not cleaning up its temporary segments, of course it does. And Sybase shares its tempdb between all databases on the machine, whereas Oracle has one per instance. again making tuning and segregation of different applications impossible. Far better documentation? Yes, Sybooks was good in its day, but MetaLink/TechNet have caught up now. I guess it's a good thing that it's easy to unload data from Sybase, in the same way that it's easy to dump a CSV file from MS Access. The comment on disaster recovery is utter rubbish, of course Oracle can be backed up while fully online and handling transactions. You can use export, hot backup or RMAN. Oracle has powerful replication also, or you can use dblinks and AQs to move data back and forth between instances under programmatic control. Sybase can't. And later on backups, Oracle has a range of options for backups, RMAN, Legato, hotbackup, whatever. And, of course, there's no equivalent of "dbcc" in Oracle, we don't need it, since datablock corruption is not a daily occurrence for us... Sybase still does have a good presence in financial services, but that's mainly a legacy thing, lots of T-SQL already written, just like there's lots of COBOL already written. This is something to boast about? I think not. T-SQL is a pretty limited language for stored procedures, it cannot compare to PL/SQL. Every SELECT in Oracle is an implicit cursor, true, but that's because Oracle knows how to run cursors efficiently. Sybase never could, this is why Sybase programmers never use cursors, not because they're inherently a bad idea. We are multi-threaded, it's called MTS. Next he'll be claiming that Oracle can only take one connected client at a time! And finally, the killer: Sybase is similar to MSSQL. Enough said! That's about all I can be bothered to type for now. In summary, I would like to say that Sybase is a fine product for your grandmother to store her recipes in :0) g -Original Message- Sent: Tuesday, September 25, 2001 10:15 AM To: Multiple recipients of list ORACLE-L See below a mail I received from Sybase oriented person :) Please argue it maybe very interesting (original mail was Sybase vs Oracle:Why to go to Sybase?) /Maya - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
Maya, I'd be interested in seeing the rest of this mail (if there is more?). See below, it looks like the tail of the message was cut off or corrupted? Cheers Mark P.S. - Great post - I'm sure it will start some flames :P -Original Message- Sent: Tuesday, September 25, 2001 10:15 To: Multiple recipients of list ORACLE-L See below a mail I received from Sybase oriented person :) Please argue it maybe very interesting (original mail was Sybase vs Oracle:Why to go to Sybase?) /Maya - - Synonyms: - Time datatype: Oracle seperates Time from Date. Sybase's datetime datatype has both included in one, plus a whole suite of display styles that can show the date/time in a multitude of formats.>W±ëzØ¡÷r&9,B¶Ã §©Ê뢳ɢw Ѭ éz»zf¢a´(È×ÂIêÇóßÎçQ_ÎçÓjpz jX¢¹hû'×ëqdzóX¸¶ÄDCTLº»÷¢kÉXX¶Çu©1¨ëj ¸¬´k«¹ör+rr§¢×\ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
See below a mail I received from Sybase oriented person :) Please argue it maybe very interesting (original mail was Sybase vs Oracle:Why to go to Sybase?) /Maya - Sybase... - 11.9.2 is beating Oracle's database in Tpc tests. See the TPC-C tests at www.tpc.org and sort by Hardware Vendor. A recent TPC-C benchmark of Sybase ASE 12.0..0.2 on Sun E-1 beat Oracle on the same platform by 36%. (Cost per transaction (156,873 tpmC) was $48.81 vs. Oracle's (115,395 tpmC) of $105.63). This is the fastest TPC benchmark ever recorded (as of 12/2000) for a SMP environment. - Sybase is far less Expensive than Oracle. Arbitrarily, Oracle charges per megahertz on the CPU, a Universal Power Unit. UPU=number of processors multiplied by processor speed, multiplied by $100 (the current price per UPU). This has problems two ways; a PC chip works at far higher megahertz speeds than a Sun Ultrachip, meaning a far more powerful server costs far less than a PC-based server. Secondly, users are charged for capacity over an entire server, even if Oracle is not the only software running. Additional features are always additional cost in Oracle; Sybase builds in all features to its entine. - Oracle's Tech support is inferior compared to Sybase's. Online case management and updating, instant reponse times. - Sybase is cheaper to administer, from a DBA standpoint. Mgrs report that one Sybase DBA can do what 2-3 Oracle DBA's do. - Sybase's Customization and Tuning is simple (one text file contains hundreds of database server options) compared to tuning Oracle. It is far easier to administer, install, operate Sybase. Very easy to create databases versus instances. - requires fewer system resources; Sybase's code runs within one operating system process, not dozens like Oracle. Sybase manages memory better. - more efficient use of tempdb. Oracle has a temporary workspace but does not clean itself up afterward like Sybase's tempdb. - has far better documentation. Sybooks is nicely organized and searchable. Oracle's is a nightmare. - Ease of data migrations both in and out of Sybase. Oracle has no tools to export data out of its Databases (except in native format). - Disaster Recovery; with inline backup utilities, Sybase can back itself up on the fly w/o taking tablespaces offline. Replication server creates a warm standby for 100% uptime. Oracle can do neither. - Reliability/Stability; Banks, Financial institutions, NYSE, Nasdaq, Amex all run Sybase. Sybase owns 90% of the financial industry. Oracle has a directory (/admin/cdumps) specifically made to collect core files! - Use of Transaction logs: Sybase has rollback and recovery transaction log features built into the same construct; each transaction only needs to be written to one place. Oracle must write transactions twice (once to the Rollback segment, once to the Redo log) because the recovery feature was never built into the main engine. Configuration is thus more difficult. I/O increases. - Backup capabilities; Sybase has builtin backup tools; Oracle depends on file system/3rd party backup solutions (a very difficult endeavor when your data devices are on raw disks; dependency on dd commands to do backups). In Sybase its one command; in Oracle its a three-day class. Hot Backup capability requires additional I/O overhead. Oracle backups work best doing "cold backups" (i.e., shutting down the server...how feasable is that in today's computing environment??). - SQL limitations: You cannot mix DDL inline with an if statement in Oracle. You cannot truncate a table in Oracle w/o removing its constraints. Data types not being IEEE compliant (causing cpu overhead as regular numbers are passed in and converted on the fly constantly). Every select statement is am implicit cursor in Oracle. - Engine limitations; one instance, one database. One client, one process. One sql*plus client can only take one batch of sql at a time. Everything in Oracle is single-threaded, not multi-threaded like Sybase. - Similarity to Microsoft SQL Server: relatively easy to transfer data from one to another (on account of their past shared code base). Also relatively straightforward to re-train MS Sql server admins for Sybase and vice versa. - "Features" in Oracle not in Sybase and rebuttals - Automatic database segment growth; I would argue that this is incredibly dangerous to allow to occur. Its easy to extend databases, not so much to fail them back. Now many Unix SA's would like an automatic disk growth feature for their users? - "Minus" clause to detect table differences. Re-writable with a simple "not exists" clause of a select statement. - Decode statement; previously emulated with complicated abs functions, but now (12.0+) easily emulated with case and coalesce statements. - larger varchar() capabilities (beyond 255 characters):
RE: ORACLE VS. SYBASE
I've gotten Oracle working with response files on 8.1.7 It does okay. -Original Message- Sent: Monday, September 24, 2001 1:30 PM To: Multiple recipients of list ORACLE-L -- "Bryan, Miriam" <[EMAIL PROTECTED]> on 09/24/01 11:53:55 -0800 > In your opinion, which one is more robust, better? we need > replication and resource management. This comes down to a religious issue in many respects. Each of the databases does things the other doesn't; each does some things differently in ways that make some people [un]happy. I've flushed any use of Oracle until they dump the "Universal Installer" mainly because it makes getting the product up and running nearly impossible on my systems (try a remote install with it sometime). I'm also not happy that Oracle has replaced quite a few operational methods (e.g., analyze table, svrmgrl) with things that don't seem to work as well on my and other sites. Net resul that they took working methods out of service before the new ones were wrung out the point of production stability. One place to look for traceoffs is the Perl DBI mailing list archives. Even if you don't use DBI itself the list contains good descriptions of what problems people have with various databases. sl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: John Lewis INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RE: ORACLE VS. SYBASE
Dick, I resent the statement that we are prejudiced just because we've invested a lot of effort, time and money into our oracle careers. We would advise the guy to go with oracle simply because oracle is the best RDBMS software that has ever been and shall ever be. Did I mention that oracle is bug free (but replete with features)? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 24, 2001 4:19 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:RE: ORACLE VS. SYBASE > > > Cute, but probably in the near future unless MicroSlop and/or > IBM beats them to > the punch. > > Anyway, that is a loaded question to toss into this pile of prejudiced > individuals, and yes I'm speaking about myself here too. > Personally I'd stay > with Oracle just because of the condition (financially that > is) of Sybase. It > may not be too far into the future when they are acquired by > someone else. > > Dick Goulet > > Reply Separator > Author: "Gary Weber" <[EMAIL PROTECTED]> > Date: 9/24/2001 12:06 PM > > Isn't Sybase owned by Oracle? Oh, not yet? > > Gary Weber > Senior DBA > Charles Jones, LLC > 609-530-1144, ext 5529 > > -Original Message- > Miriam > Sent: Monday, September 24, 2001 3:54 PM > To: Multiple recipients of list ORACLE-L > > > Hi list, hope you guys can help us decide this issue. > > We are a shop that 's currently running 2 MS SQL7 servers > 2 MS 2k Servers > 6 Sybase > 12.1.1 ASE servers > and 5 Oracle 8.1.7.1 > servers > The MS servers is used for time tracking and a helpdesk > database, Sybase is > used for our Online communities and a host of other things. Because of > Sybase's limitation and problems 3 years ago, Oracle was > supposed to be our > New Production System. The idea was to migrate all other > system to Oracle > and have a shop running under just one platform. Well, this > was over 3 years > ago and things have not progressed as expected(very long > story), We are > still running all three platforms. Sybase has come up with > new releases that > have addressed some of the issues we had against it , now we > don't know > which platform to keep(between Oracle and Sybase). In your > opinion, which > one is more robust, better? we need replication and resource > management. > > > TIA, > > Miriam Bryan > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bryan, Miriam > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Gary Weber > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTE
Re: ORACLE VS. SYBASE
-- "Bryan, Miriam" <[EMAIL PROTECTED]> on 09/24/01 11:53:55 -0800 > In your opinion, which one is more robust, better? we need > replication and resource management. This comes down to a religious issue in many respects. Each of the databases does things the other doesn't; each does some things differently in ways that make some people [un]happy. I've flushed any use of Oracle until they dump the "Universal Installer" mainly because it makes getting the product up and running nearly impossible on my systems (try a remote install with it sometime). I'm also not happy that Oracle has replaced quite a few operational methods (e.g., analyze table, svrmgrl) with things that don't seem to work as well on my and other sites. Net resul that they took working methods out of service before the new ones were wrung out the point of production stability. One place to look for traceoffs is the Perl DBI mailing list archives. Even if you don't use DBI itself the list contains good descriptions of what problems people have with various databases. sl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: ORACLE VS. SYBASE
Isn't Sybase owned by Oracle? Oh, not yet? Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Miriam Sent: Monday, September 24, 2001 3:54 PM To: Multiple recipients of list ORACLE-L Hi list, hope you guys can help us decide this issue. We are a shop that 's currently running 2 MS SQL7 servers 2 MS 2k Servers 6 Sybase 12.1.1 ASE servers and 5 Oracle 8.1.7.1 servers The MS servers is used for time tracking and a helpdesk database, Sybase is used for our Online communities and a host of other things. Because of Sybase's limitation and problems 3 years ago, Oracle was supposed to be our New Production System. The idea was to migrate all other system to Oracle and have a shop running under just one platform. Well, this was over 3 years ago and things have not progressed as expected(very long story), We are still running all three platforms. Sybase has come up with new releases that have addressed some of the issues we had against it , now we don't know which platform to keep(between Oracle and Sybase). In your opinion, which one is more robust, better? we need replication and resource management. TIA, Miriam Bryan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bryan, Miriam INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Gary Weber INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
