Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: might be really old topic, but please take a look

Re: might be really old topic, but please take a look

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 03 May 2001 13:22:29 -0700
Message-ID: <F001.002F9142.20010503132155@fatcity.com>

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: 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: Jared Still
  INET: jkstill_at_cybcon.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).
Received on Thu May 03 2001 - 15:22:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US