I'd forgot about the transaction log.
And what happens when you start a long running transaction
near the end of the log?
As I recall, you are in trouble.
Jared
On Thursday 03 May 2001 12:21, Boivin, Patrice J wrote:
> 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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>
> -----Original Message-----
> From: Streeter, Lerone A LBX [SMTP:[EMAIL PROTECTED]]
> 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
> [EMAIL PROTECTED]
> ===========================================
> -----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:[EMAIL PROTECTED]]
> || 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: [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: Streeter, Lerone A LBX
> 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: 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).
