| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: might be really old topic, but please take a look
Leslie,
Sybase is what SQL Server is built from, I think. I don't know much about Sybase, but I Know that SQL Server 7 only has one transaction log file (redo log file), that you have to back up regularly and truncate otherwise your database will freeze. In SQL server there is no such thing as an "archived log", you have to back up the transaction log's datafile to get your backup of transactions. This is just one example. Does Sybase support multiple log files? What about multiple archiving processes? That was a bit of a bottleneck in Oracle7 for us, and I had created the max number of redo log files. I can't imagine what it would be like with only one transaction log file... I am looking forward to our upgrade to 8.1.6., I am curious to see what multiple archiving processes can do.
Re. NT and UNIX, does Microsoft still sell NT? Here we could only by Windows2000 licenses.
: )
NT is good for small to medium databases that are not too mission critical, in my opinion, but from experience I much prefer UNIX.
I know you probably want numbers to compare, maybe you could ask DBAs how long their NT and UNIX servers have been running without interruption, and why they were brought down the last time...
Last I read on the 'net the new Windows versions will have new names. The personal software (read Win9x/ME stream plus NT Workstation) will be called WindowsXP, while the corporate operating systems (read: NT Server 4 and NT Dataserver) will be called Windows2002. I don't know when these new versions will be released, I think that for Windows2002 MS is aiming for 4th quarter of 2001 at this point. That is... this coming Autumn!
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
-----Original Message-----
From: Streeter, Lerone A LBX [SMTP:StreeLA2_at_HPD.Abbott.com]
Sent: Thursday, May 03, 2001 3:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: might be really old topic, but please take a
look
briefly:
our choice was oracle/NT, based mainly on division/corporate direction which
was based on the strengths of oracle. widely installed, industry leader,
robust platform.
NT was a no-brainer; the majority of our knowledge is NT. price and
complexity were considered also, even though you have more control
over
*nix, the price of boxii to run it on as well as the cost of
training and
associated learning curve made *nix an unattractive option.
our user base is small-to-medium so an NT solution should suffice,
if we
were larger or more widely dispersed or web based; we'd look harder
at *nix.
remember i said brief.
Lerone Streeter
System Analyst
Abbott LBG
StreeLA2_at_hpd.abbott.com
===========================================
-----Original Message-----
Sent: Thursday, May 03, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Oh, ha! that is an old one:
Oracle on Unix is the "only" choice.
No need to research at all! Just go out and buy one!
:)
Ross
p.s. give us more info, and you'll get a higher quality answer. GIGO
|| -----Original Message-----
|| From: Leslie Lu [mailto:leslie_y_lu_at_yahoo.com]
|| Sent: Thursday, May 03, 2001 1:37 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Q: might be really old topic, but please take a look
||
||
|| Probably this has been posed million times, but I
|| really like to know. We'll have a meeting about this
|| in our company, and I'd love to contribute someting.
|| Any idea on the following issue, any link, paper, etc,
|| will be greatly appreciated.
||
|| pros and cons of
||
|| 1. Oracle vs Sybase
||
|| 2. Unix vs NT
||
||
|| Leslie
||
|| __________________________________________________
|| Do You Yahoo!?
|| Yahoo! Auctions - buy the things you want at great prices
|| http://auctions.yahoo.com/
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Leslie Lu
|| INET: leslie_y_lu_at_yahoo.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: Streeter, Lerone A LBX
INET: StreeLA2_at_HPD.Abbott.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: Boivin, Patrice J INET: BoivinP_at_mar.dfo-mpo.gc.ca 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 Thu May 03 2001 - 13:19:24 CDT
 |
 |