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: shutdown hang

RE: shutdown hang

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Fri, 26 May 2000 15:55:50 -0400
Message-Id: <10509.106916@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFC74C.64A82F70
Content-Type: text/plain;

        charset="iso-8859-1"

Could you please provide more info about this class? Who is offering it, how long, how much, schedule, agenda etc.

Alex Hillman

-----Original Message-----
From: Madhavan Amruthur [mailto:mad012000_at_hotmail.com] Sent: Thursday, May 25, 2000 12:15 PM
To: Multiple recipients of list ORACLE-L Subject: RE: shutdown hang

Hi Rachel,
I went to the internal classes taught by Scott in Feb and he is just great. He keeps the interest (after lunch) from dwindling and at the end of the 4 seminars, I became more dangerous than ever with all the information he provided.

Regards,
Madhavan
IBM Corporation Webserver Div

>From: "Rachel Carmichael" <carmichr_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: shutdown hang
>Date: Wed, 24 May 2000 17:54:50 -0800
>
>
>
>According to the internals class I am taking (and the instructor, Scott
>Gossett, is one of the best), rollback takes about as long as it took from
>the start of the transaction to when you started the rollback.
>
>The reason is:
>
>to make the original changes to the blocks, Oracle builds change vectors
>which get applied to the blocks (rollback segment header block, undo block
>and data block). When you rollback, you build similar change vectors to
>change things back...... Why you ask? Well, Oracle is building entries in
>the rollback segment to be able to rollback the rollback if a problem
>happens in the middle. Yes, I know that sounds strange, but when have we
>ever understood what Oracle is doing and why? <G>
>
>So you are doing as much work to rollback as you did to get to that point.
>
>This class rocks. And is making my head hurt... there is SO much to learn!
>
>Rachel
>
>
>>From: Ari D Kaplan <akaplan_at_interaccess.com>
>>Reply-To: ORACLE-L_at_fatcity.com
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>Subject: RE: shutdown hang
>>Date: Wed, 24 May 2000 13:46:26 -0800
>>
>>It depends on how large the 120,000 rows are. If there is a LONG column or
>>200 columns, etc. it could take an hour or so. If it is a "typical" table,
>>say 15 columns, then 120,000 rows should take about a minute.
>>
>>With other tables, as Winnie has said, can take hours or more.
>>
>>-Ari Kaplan
>>Independent Oracle DBA Consultant
>>
>><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>><-> For 370+ Oracle tips, visit: <->
>><-> <->
>><-> www.arikaplan.com <->
>><-> <->
>><-> email: akaplan_at_interaccess.com <->
>><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>>
>>
>>On Wed, 24 May 2000 Winnie_Liu_at_infonet.com wrote:
>>
>> >
>> > Teresa,
>> >
>> > I don't think I can answer your question staight. I have seen tables
>>that
>> > had been locked for minutes, hours to about 1 day.
>> >
>> > Any other DBA have similar experience that can shared with Teresa?
>> >
>> > Winnie
>> >
>> >
>> >
>> >
>> >
>> > "Southerland, Teresa" <tsouther_at_indiana.edu> on 05/24/2000 01:15:30 PM
>> >
>> > Please respond to ORACLE-L_at_fatcity.com
>> >
>> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> > cc: (bcc: Winnie Liu/HQ/ISC)
>> >
>> >
>> >
>> >
>> >
>> > Winnie,
>> >
>> > I have an off the wall question. If there was a transaction running
>>that
>> > executed 120,000 rows and had to rollback without shut down to the
>> > database,
>> > what kind of time frame would this take?
>> >
>> > Thanks,
>> >
>> > Teresa
>> >
>> > -----Original Message-----
>> > Sent: Friday, May 19, 2000 1:16 PM
>> > To: Multiple recipients of list ORACLE-L
>> >
>> >
>> >
>> > Joan,
>> >
>> > The reaon is that in your first startup, Oracle does NOT clean up
>> > everything yet. It opened the database for you to use, but still
>>cleaning
>> > up the processes inthe background. Those clean up may take any time
>>from
>> > minutes to days (from some Oracle guru in Oracle corporation).
>> >
>> > If you are looking at the alert.log file after those startup, you
>>should
>> > see something like
>> >
>> > SMON: enabling cache recovery
>> > SMON: enabling tx recovery
>> >
>> > The database is up and running fine, but SMON is doing the recovery at
>>the
>> > background.
>> >
>> > Until you see the words:
>> >
>> > SMON: disabling cache recovery
>> > SMON: disabling tx recovery
>> >
>> > The recovery done by SMON is not done yet. This process may take hours
>>and
>> > days if you are temporary segments is huge and there are a lot of clean
>>up
>> > need to be done by SMON.
>> >
>> > When you do a shutdown immediate, since you are asking Oracle to
>>shutdown
>> > the database cleanly. SMON had to finish that job before shutting down
>>the
>> > database. Those hours/days will then add to your shutdown time.
>> >
>> > So the best method for me (which I also get from Oracle) is to do a
>> > shutdown abort and then a startup and wait for the SMON recovery to be
>> > finished in the background.
>> >
>> > There are a few events that you can set to free up SMON from performing
>> > those daily activities and concentrate on the recovery. If you are
>> > interested, I will send them to you.
>> >
>> > Hope it makes more sense now.
>> >
>> > Winnie
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > Joan Hsieh <jhsieh_at_infonet.tufts.edu> on 05/19/2000 07:28:05 AM
>> >
>> > Please respond to ORACLE-L_at_fatcity.com
>> >
>> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> > cc: (bcc: Winnie Liu/HQ/ISC)
>> >
>> >
>> >
>> >
>> >
>> > Winnie,
>> >
>> > I did shutdown abort and startup (took 20 min.) What concerns me is
>> > after startup, I did shutdown immediate again. It hangs (more than one
>> > hour and didn't comeback) NOBODY on the system. My question is the
>>first
>> > startup should clean up everything, why shutdown immediate hangs after?
>> >
>> > Thanks,
>> >
>> > Joan
>> >
>> > ORACLE-L_at_fatcity.com wrote:
>> > >
>> > > It is perfectly normal. But if I were you, I will shutdown abort and
>> > > startup again (oracle is actually cleaning up the processes in the
>> > > background, they are doing the same job as if you issue the shutdown
>> > > immediate). At least the database is up and running while Oracle did
>>the
>> > > cleaning.
>> > >
>> > > My worst nightmare is to wait for 14 hours for it to get cleaned up.
>> > >
>> > > Winnie
>> > >
>> > > Joan Hsieh <jhsieh_at_infonet.tufts.edu> on 05/18/2000 02:19:39 PM
>> > >
>> > > Please respond to ORACLE-L_at_fatcity.com
>> > >
>> > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> > > cc: (bcc: Winnie Liu/HQ/ISC)
>> > >
>> > > Hi List,
>> > >
>> > > One of the developers deleted more than 120,000 rows on a small
>> > > database. In the middle of the session, he killed the
>>process.(because
>> > > hang) I did shutdown abort and startup again (waited a while whitout
>> > > problem) and want to shutdown immediate and startup over again. This
>> > > time shutdown immediate hangs. Is this normal (waiting rollback)?
>>I've
>> > > been hang here for over one hours now.
>> > >
>> > > Thanks in advance,
>> > >
>> > > Joan
>> > > --
>> > > Author: Joan Hsieh
>> > > INET: jhsieh_at_infonet.tufts.edu
>> > >
>> > > 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).
>> > >
>> > > --
>> > > Author:
>> > > INET: Winnie_Liu_at_infonet.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).
>> > --
>> > Author: Joan Hsieh
>> > INET: jhsieh_at_infonet.tufts.edu
>> >
>> > 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).
>> >
>> >
>> >
>> >
>> >
>> >
>> > --
>> > Author:
>> > INET: Winnie_Liu_at_infonet.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).
>> > --
>> > Author: Southerland, Teresa
>> > INET: tsouther_at_indiana.edu
>> >
>> > 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).
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > --
>> > Author:
>> > INET: Winnie_Liu_at_infonet.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).
>> >
>>
>>--
>>Author: Ari D Kaplan
>> INET: akaplan_at_interaccess.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).
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.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).



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
-- 
Author: Madhavan Amruthur
  INET: mad012000_at_hotmail.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).

------_=_NextPart_001_01BFC74C.64A82F70
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: shutdown hang</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>Could you please provide more info about this class? Who is offering it, how long, how much, schedule, agenda etc.</FONT>
</P>

<P><FONT SIZE=2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Madhavan Amruthur [<A HREF="mailto:mad012000_at_hotmail.com">mailto:mad012000_at_hotmail.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, May 25, 2000 12:15 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RE: shutdown hang</FONT>
</P>
<BR>

<P><FONT SIZE=2>Hi Rachel,</FONT>
<BR><FONT SIZE=2>I went to the internal classes taught by Scott in Feb and he is just great. </FONT>
<BR><FONT SIZE=2>He keeps the interest (after lunch) from dwindling and at the end of the 4 </FONT>
<BR><FONT SIZE=2>seminars, I became more dangerous than ever with all the information he </FONT>
<BR><FONT SIZE=2>provided.</FONT>
</P>

<P><FONT SIZE=2>Regards,</FONT>
<BR><FONT SIZE=2>Madhavan</FONT>
<BR><FONT SIZE=2>IBM Corporation Webserver Div</FONT>
</P>
<BR>

<P><FONT SIZE=2>&gt;From: &quot;Rachel Carmichael&quot; &lt;carmichr_at_hotmail.com&gt;</FONT>
<BR><FONT SIZE=2>&gt;Reply-To: ORACLE-L_at_fatcity.com</FONT>
<BR><FONT SIZE=2>&gt;To: Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=2>&gt;Subject: RE: shutdown hang</FONT>
<BR><FONT SIZE=2>&gt;Date: Wed, 24 May 2000 17:54:50 -0800</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;According to the internals class I am taking (and the instructor, Scott</FONT>
<BR><FONT SIZE=2>&gt;Gossett, is one of the best), rollback takes about as long as it took from</FONT>
<BR><FONT SIZE=2>&gt;the start of the transaction to when you started the rollback.</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;The reason is:</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;to make the original changes to the blocks, Oracle builds change vectors</FONT>
<BR><FONT SIZE=2>&gt;which get applied to the blocks (rollback segment header block, undo block</FONT>
<BR><FONT SIZE=2>&gt;and data block). When you rollback, you build similar change vectors to</FONT>
<BR><FONT SIZE=2>&gt;change things back...... Why you ask? Well, Oracle is building entries in</FONT>
<BR><FONT SIZE=2>&gt;the rollback segment to be able to rollback the rollback if a problem</FONT>
<BR><FONT SIZE=2>&gt;happens in the middle. Yes, I know that sounds strange, but when have we</FONT>
<BR><FONT SIZE=2>&gt;ever understood what Oracle is doing and why? &lt;G&gt;</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;So you are doing as much work to rollback as you did to get to that point.</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;This class rocks. And is making my head hurt... there is SO much to learn!</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;Rachel</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;From: Ari D Kaplan &lt;akaplan_at_interaccess.com&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;Reply-To: ORACLE-L_at_fatcity.com</FONT>
<BR><FONT SIZE=2>&gt;&gt;To: Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;Subject: RE: shutdown hang</FONT>
<BR><FONT SIZE=2>&gt;&gt;Date: Wed, 24 May 2000 13:46:26 -0800</FONT>
<BR><FONT SIZE=2>&gt;&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;It depends on how large the 120,000 rows are. If there is a LONG column or</FONT>
<BR><FONT SIZE=2>&gt;&gt;200 columns, etc. it could take an hour or so. If it is a &quot;typical&quot; table,</FONT>
<BR><FONT SIZE=2>&gt;&gt;say 15 columns, then 120,000 rows should take about a minute.</FONT>
<BR><FONT SIZE=2>&gt;&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;With other tables, as Winnie has said, can take hours or more.</FONT>
<BR><FONT SIZE=2>&gt;&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;-Ari Kaplan</FONT>
<BR><FONT SIZE=2>&gt;&gt;Independent Oracle DBA Consultant</FONT>
<BR><FONT SIZE=2>&gt;&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;&lt;-&gt; For 370+ Oracle tips, visit:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;-&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;&lt;-&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;-&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;&lt;-&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; www.arikaplan.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;-&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;&lt;-&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;-&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;&lt;-&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; email: akaplan_at_interaccess.com&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;-&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;&lt;-&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;On Wed, 24 May 2000 Winnie_Liu_at_infonet.com wrote:</FONT>
<BR><FONT SIZE=2>&gt;&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Teresa,</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; I don't think I can answer your question staight. I have seen tables</FONT>
<BR><FONT SIZE=2>&gt;&gt;that</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; had been locked for minutes, hours to about 1 day.</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Any other DBA have similar experience that can shared with Teresa?</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Winnie</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &quot;Southerland, Teresa&quot; &lt;tsouther_at_indiana.edu&gt; on 05/24/2000 01:15:30 PM</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Please respond to ORACLE-L_at_fatcity.com</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; To:&nbsp;&nbsp; Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; cc:&nbsp;&nbsp;&nbsp; (bcc: Winnie Liu/HQ/ISC)</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Winnie,</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; I have an off the wall question.&nbsp; If there was a transaction running</FONT>
<BR><FONT SIZE=2>&gt;&gt;that</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; executed 120,000 rows and had to rollback without shut down to the</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; database,</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; what kind of time frame would this take?</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Thanks,</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Teresa</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; -----Original Message-----</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Sent: Friday, May 19, 2000 1:16 PM</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Joan,</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; The reaon is that in your first startup, Oracle does NOT clean up</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; everything yet. It opened the database for you to use, but still</FONT>
<BR><FONT SIZE=2>&gt;&gt;cleaning</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; up the processes inthe background. Those clean up may take any time </FONT>
<BR><FONT SIZE=2>&gt;&gt;from</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; minutes to days (from some Oracle guru in Oracle corporation).</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; If you are looking at the alert.log file after those startup, you </FONT>
<BR><FONT SIZE=2>&gt;&gt;should</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; see something like</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; SMON: enabling cache recovery</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; SMON: enabling tx recovery</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; The database is up and running fine, but SMON is doing the recovery at</FONT>
<BR><FONT SIZE=2>&gt;&gt;the</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; background.</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Until you see the words:</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; SMON: disabling cache recovery</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; SMON: disabling tx recovery</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; The recovery done by SMON is not done yet. This process may take hours</FONT>
<BR><FONT SIZE=2>&gt;&gt;and</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; days if you are temporary segments is huge and there are a lot of clean</FONT>
<BR><FONT SIZE=2>&gt;&gt;up</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; need to be done by SMON.</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; When you do a shutdown immediate, since you are asking Oracle to</FONT>
<BR><FONT SIZE=2>&gt;&gt;shutdown</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; the database cleanly. SMON had to finish that job before shutting down</FONT>
<BR><FONT SIZE=2>&gt;&gt;the</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; database. Those hours/days will then add to your shutdown time.</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; So the best method for me (which I also get from Oracle) is to do a</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; shutdown abort and then a startup and wait for the SMON recovery to be</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; finished in the background.</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; There are a few events that you can set to free up SMON from performing</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; those daily activities and concentrate on the recovery. If you are</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; interested, I will send them to you.</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Hope it makes more sense now.</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Winnie</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Joan Hsieh &lt;jhsieh_at_infonet.tufts.edu&gt; on 05/19/2000 07:28:05 AM</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Please respond to ORACLE-L_at_fatcity.com</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; To:&nbsp;&nbsp; Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; cc:&nbsp;&nbsp;&nbsp; (bcc: Winnie Liu/HQ/ISC)</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Winnie,</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; I did shutdown abort and startup (took 20 min.) What concerns me is</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; after startup, I did shutdown immediate again. It hangs (more than one</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; hour and didn't comeback) NOBODY on the system. My question is the </FONT>
<BR><FONT SIZE=2>&gt;&gt;first</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; startup should clean up everything, why shutdown immediate hangs after?</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Thanks,</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Joan</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; ORACLE-L_at_fatcity.com wrote:</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; It is perfectly normal. But if I were you, I will shutdown abort and</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; startup again (oracle is actually cleaning up the processes in the</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; background, they are doing the same job as if you issue the shutdown</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; immediate). At least the database is up and running while Oracle did</FONT>
<BR><FONT SIZE=2>&gt;&gt;the</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; cleaning.</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; My worst nightmare is to wait for 14 hours for it to get cleaned up.</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; Winnie</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; Joan Hsieh &lt;jhsieh_at_infonet.tufts.edu&gt; on 05/18/2000 02:19:39 PM</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; Please respond to ORACLE-L_at_fatcity.com</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; To:&nbsp;&nbsp; Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; cc:&nbsp;&nbsp;&nbsp; (bcc: Winnie Liu/HQ/ISC)</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; Hi List,</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; One of the developers deleted more than 120,000 rows on a&nbsp; small</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; database. In the middle of the session, he killed the </FONT>
<BR><FONT SIZE=2>&gt;&gt;process.(because</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; hang) I did shutdown abort and startup again (waited a while whitout</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; problem) and want to shutdown immediate and startup over again. This</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; time shutdown immediate hangs. Is this normal (waiting rollback)? </FONT>
<BR><FONT SIZE=2>&gt;&gt;I've</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; been hang here for over one hours now.</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; Thanks in advance,</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; Joan</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; --</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; Author: Joan Hsieh</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;&nbsp;&nbsp; INET: jhsieh_at_infonet.tufts.edu</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing </FONT>
<BR><FONT SIZE=2>&gt;&gt;Lists</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; --------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; (or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; --</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; Author:</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;&nbsp;&nbsp; INET: Winnie_Liu_at_infonet.com</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing </FONT>
<BR><FONT SIZE=2>&gt;&gt;Lists</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; --------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; (or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; &gt; also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; --</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Author: Joan Hsieh</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;&nbsp;&nbsp; INET: jhsieh_at_infonet.tufts.edu</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; --------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; (or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; --</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Author:</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;&nbsp;&nbsp; INET: Winnie_Liu_at_infonet.com</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; --------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; (or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; --</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Author: Southerland, Teresa</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;&nbsp;&nbsp; INET: tsouther_at_indiana.edu</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; --------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; (or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; --</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Author:</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;&nbsp;&nbsp; INET: Winnie_Liu_at_infonet.com</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; --------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; (or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt; also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>&gt;&gt; &gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;--</FONT>
<BR><FONT SIZE=2>&gt;&gt;Author: Ari D Kaplan</FONT>
<BR><FONT SIZE=2>&gt;&gt;&nbsp;&nbsp; INET: akaplan_at_interaccess.com</FONT>
<BR><FONT SIZE=2>&gt;&gt;</FONT>
<BR><FONT SIZE=2>&gt;&gt;Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>&gt;&gt;San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>&gt;&gt;--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt;&gt;To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>&gt;&gt;to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>&gt;&gt;the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt;&gt;(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>&gt;&gt;also send the HELP command for other information (like subscribing).</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;________________________________________________________________________</FONT>
<BR><FONT SIZE=2>&gt;Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;--</FONT>
<BR><FONT SIZE=2>&gt;Author: Rachel Carmichael</FONT>
<BR><FONT SIZE=2>&gt;&nbsp; INET: carmichr_at_hotmail.com</FONT>
<BR><FONT SIZE=2>&gt;</FONT>
<BR><FONT SIZE=2>&gt;Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>&gt;San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>&gt;--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>&gt;To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>&gt;to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>&gt;the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt;(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>&gt;also send the HELP command for other information (like subscribing).</FONT>
</P>

<P><FONT SIZE=2>________________________________________________________________________</FONT>
<BR><FONT SIZE=2>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com</FONT>
</P>

<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Madhavan Amruthur</FONT>
<BR><FONT SIZE=2>&nbsp; INET: mad012000_at_hotmail.com</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
Received on Fri May 26 2000 - 14:55:50 CDT

Original text of this message

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