Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OT: Archiving not possible with SQL Server?
Jared is having a bad day.
: )
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: Jared Still [SMTP:jkstill_at_cybcon.com] Sent: Thursday, May 31, 2001 3:51 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT: Archiving not possible with SQL Server? Are you an idiot? Jared On Wednesday 30 May 2001 14:55, Gary Weber wrote:
> >>Guess what happens when a long running transaction marks
>
> the log near the end, and not too long afterward the log
> needs truncated? If memory serves, ( hasn't worked too well lately
:) the
> database
> will hang. It may just truncate back to the mark, and start from
> there, but you always have the possibility of another long
> transaction starting.<<
>
> HELP
>
> Gary Weber
> Senior DBA
> Charles Jones, LLC
> 609-530-1144, ext 5529
-- 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).
-- 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 31 2001 - 05:45:29 CDT
![]() |
![]() |