RE: Rollback segments offline on database restart

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Wed, 12 Jul 2000 15:45:38 -0400
Message-Id: <10556.111865@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_01BFEC39.C4ECE760
Content-Type: text/plain;

charset="iso-8859-1"

I agree that to have all rollback segments listed in the rollback_segments parameter is a thing to do but if one does not want to have all 25 rollback listed it is possible to put them online in login trigger (8i). Didn't try it myself but should work.

Alex Hillman

-----Original Message-----
From: Gaja Krishna Vaidyanatha [mailto:gajav_at_yahoo.com] Sent: Wednesday, July 12, 2000 2:28 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Rollback segments offline on database restart

Barry,

The term "private" or "public" is relevant to an instance not to a transaction and is "configuration independent". Which means that I can create both public and private rollback segments in both OPS and non-OPS configurations. The term "private" is definitely not an OPS-only term. When rollback segments are created by default without any keywords, they are created as "private" rollback segments. Even in a non-OPS environment "normal" rollback segments created, are "private". The key characteristic of a "private" rollback segment is that, if you don't put in in the init.ora, it will not automatically come online.

It is only when "public" rollback segments are required, that the keyword - PUBLIC is used. The use of public rollback segments was originally devised many years ago for OPS configurations with many many instances (e.g. the n-Cube platform could theoritically support 512 nodes, hence theoritically 512 instances). Instead of having to configure a rollback segment init.ora parameter for each of the 512 instances, the idea was to use public rollback segments, so that each instance could bring online, a set of rollback segments from the "public pool", purely based on the ratio of : (transactions/transactions_per_rollback_segment)

But for most "normal" OPS configurations, the number of instances are not that much (2-8 maybe), so using private rollback segments (default) and configuring the rollback_segment parameter for each of the init.oras was not a big deal. In fact using private rollback segments facilitates better management and localization of these objects.

Hope that helps,

Gaja.

barry botuck <botes_at_hq.idt.net> wrote:
> Gaja:
> Are you discussing ops?
> .. I thought that the term private rollback segment is an
> oracle parallel
> server concept ONLY,
>
> Barry
>
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of
> Gaja Krishna
> Vaidyanatha
> Sent: Tuesday, July 11, 2000 1:26 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Rollback segments offline on database restart
>
> Mariana,
>
> One should probably always choose option #1 , as #2 is
> dependent
> on the ratio :
> (transactions/transactions_per_rollback_segment).
> What this means, is that if the value of transations=100 and
> transactions_per_rollback_segment=4, then the total number of
> rollback segments (public and private) that Oracle will bring
> online on startup, will not exceed 25.
>
> So, rather than going and fiddling with those 2 parameters to
> make things work, it should be preferred to just create all
> rollback segments as "private" and put their names in the list
> of values in the rollback_segments parameter. It must also be
> noted here that the number of "actual transactions per
> rollback
> segment" has nothing to do with the
> transactions_per_rollback_segment parameter. The number of
> actual transactions per rollback segment is O-S and
> db_block_size dependent.
>
> Best Regards,
>
> Gaja.
>
> --- "Galleri, Mariana" <MGalleri_at_uniFON.com.ar> wrote:
> >
> > Ravi,
> >
> > You have two options.
> >
> > 1- You have to use rollback_segments parameter and list out
> > all(more than
> > 25) segments
> > there, or
> > 2- You can create public rollback segments and you don't
> need
> > to use
> > rollback_segments parameter
> >
> > Regards.
> >
> >
> > -----Mensaje original-----
> > De: Ravi Babu [mailto:lravibabu_at_hotmail.com]
> > Enviado el: Martes 11 de Julio de 2000 10:45
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Rollback segments offline on database restart
> >
> >
> > Hello,
> > I have created 25 rollback segments. Now whenever i restart
> > the database few
> >
> > rollback segments are offline. To one procedure i have
> > assigened one
> > rollback segment with the help of 'set transaction use
> ....'.
> > Now whenever
> > the database is restarted around 5-7 rollback segments are
> > offline, which i
> > manually have to set it online again. How to get this thing
> > done. Do i have
> > to use rollback_segments parameter and list out all(more
> than
> > 25) segments
> > there?
> > Please help.
> > Ravi.
> >
> >
>

> > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com
> >
> > --
> > Author: Ravi Babu
> > INET: lravibabu_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).
> > --
> > Author: Galleri, Mariana
> > INET: MGalleri_at_uniFON.com.ar
> >
> > 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).
>
>
> =====
> Gaja Krishna Vaidyanatha
> Director, I-O Management Products
> Quest Software Inc.
> (972)-304-1170
> gajav_at_yahoo.com
>
> "Opinions and views expressed are my own and not of Quest"
>
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> --
> Author: Gaja Krishna Vaidyanatha
> INET: gajav_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).
>
> --
> Author: barry botuck
> INET: botes_at_hq.idt.net
>
> 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).

Gaja Krishna Vaidyanatha
Director, I-O Management Products
Quest Software Inc.
(972)-304-1170
gajav_at_yahoo.com

"Opinions and views expressed are my own and not of Quest"

Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

-- 
Author: Gaja Krishna Vaidyanatha
  INET: gajav_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).

------_=_NextPart_001_01BFEC39.C4ECE760
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: Rollback segments offline on database restart</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>I agree that to have all rollback segments listed in =
the rollback_segments parameter is a thing to do but if one does not =
want to have all 25 rollback listed it is possible to put them online =
in login trigger (8i). Didn't try it myself but should work.</FONT></P>

<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Gaja Krishna Vaidyanatha [<A =
HREF=3D"mailto:gajav_at_yahoo.com">mailto:gajav_at_yahoo.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, July 12, 2000 2:28 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Rollback segments offline on database =
restart</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Barry,</FONT>
</P>

<P><FONT SIZE=3D2>The term &quot;private&quot; or &quot;public&quot; is =
relevant to an instance not to</FONT>
<BR><FONT SIZE=3D2>a transaction and is &quot;configuration =
independent&quot;.&nbsp; Which means</FONT>
<BR><FONT SIZE=3D2>that I can create both public and private rollback =
segments in</FONT>
<BR><FONT SIZE=3D2>both OPS and non-OPS configurations.&nbsp; The term =
&quot;private&quot; is</FONT>
<BR><FONT SIZE=3D2>definitely not an OPS-only term.&nbsp; When rollback =
segments are</FONT>
<BR><FONT SIZE=3D2>created by default without any keywords, they are =
created as</FONT>
<BR><FONT SIZE=3D2>&quot;private&quot; rollback segments.&nbsp; Even in =
a non-OPS environment</FONT>
<BR><FONT SIZE=3D2>&quot;normal&quot; rollback segments created, are =
&quot;private&quot;.&nbsp; The key</FONT>
<BR><FONT SIZE=3D2>characteristic of a &quot;private&quot; rollback =
segment is that, if you</FONT>
<BR><FONT SIZE=3D2>don't put in in the init.ora, it will not =
automatically come</FONT>
<BR><FONT SIZE=3D2>online.</FONT>
</P>

<P><FONT SIZE=3D2>It is only when &quot;public&quot; rollback segments =
are required, that</FONT>
<BR><FONT SIZE=3D2>the keyword - PUBLIC is used.&nbsp; The use of =
public rollback</FONT>
<BR><FONT SIZE=3D2>segments was originally devised many years ago for =
OPS</FONT>
<BR><FONT SIZE=3D2>configurations with many many instances (e.g. the =
n-Cube</FONT>
<BR><FONT SIZE=3D2>platform could theoritically support 512 nodes, =
hence</FONT>
<BR><FONT SIZE=3D2>theoritically 512 instances).&nbsp; Instead of =
having to configure a</FONT>
<BR><FONT SIZE=3D2>rollback segment init.ora parameter for each of the =
512</FONT>
<BR><FONT SIZE=3D2>instances, the idea was to use public rollback =
segments, so that</FONT>
<BR><FONT SIZE=3D2>each instance could bring online, a set of rollback =
segments</FONT>
<BR><FONT SIZE=3D2>from the &quot;public pool&quot;, purely based on =
the ratio of :</FONT>
<BR><FONT =
SIZE=3D2>(transactions/transactions_per_rollback_segment)</FONT>
</P>

<P><FONT SIZE=3D2>But for most &quot;normal&quot; OPS configurations, =
the number of</FONT>
<BR><FONT SIZE=3D2>instances are not that much (2-8 maybe), so using =
private</FONT>
<BR><FONT SIZE=3D2>rollback segments (default) and configuring the =
rollback_segment</FONT>
<BR><FONT SIZE=3D2>parameter for each of the init.oras was not a big =
deal.&nbsp; In fact</FONT>
<BR><FONT SIZE=3D2>using private rollback segments facilitates better =
management</FONT>
<BR><FONT SIZE=3D2>and localization of these objects.</FONT>
</P>

<P><FONT SIZE=3D2>Hope that helps,</FONT>
</P>

<P><FONT SIZE=3D2>Gaja.</FONT>
</P>

<P><FONT SIZE=3D2>--- barry botuck &lt;botes_at_hq.idt.net&gt; =
wrote:</FONT>
<BR><FONT SIZE=3D2>&gt; Gaja:</FONT>
<BR><FONT SIZE=3D2>&gt; Are you discussing ops?</FONT>
<BR><FONT SIZE=3D2>&gt; .. I thought that the term private rollback =
segment&nbsp; is an</FONT>
<BR><FONT SIZE=3D2>&gt; oracle parallel</FONT>
<BR><FONT SIZE=3D2>&gt; server concept ONLY,</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Barry</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>&gt; From: root_at_fatcity.com [<A =
HREF=3D"mailto:root_at_fatcity.com">mailto:root_at_fatcity.com</A>] On Behalf =
Of</FONT>
<BR><FONT SIZE=3D2>&gt; Gaja Krishna</FONT>
<BR><FONT SIZE=3D2>&gt; Vaidyanatha</FONT>
<BR><FONT SIZE=3D2>&gt; Sent: Tuesday, July 11, 2000 1:26 PM</FONT>
<BR><FONT SIZE=3D2>&gt; To:&nbsp;&nbsp; Multiple recipients of list =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RE: =
Rollback segments offline on database restart</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Mariana,</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; One should probably always choose option #1 , =
as #2 is</FONT>
<BR><FONT SIZE=3D2>&gt; dependent</FONT>
<BR><FONT SIZE=3D2>&gt; on the ratio :</FONT>
<BR><FONT SIZE=3D2>&gt; =
(transactions/transactions_per_rollback_segment).</FONT>
<BR><FONT SIZE=3D2>&gt; What this means, is that if the value of =
transations=3D100 and</FONT>
<BR><FONT SIZE=3D2>&gt; transactions_per_rollback_segment=3D4, then the =
total number of</FONT>
<BR><FONT SIZE=3D2>&gt; rollback segments (public and private) that =
Oracle will bring</FONT>
<BR><FONT SIZE=3D2>&gt; online on startup, will not exceed 25.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; So, rather than going and fiddling with those 2 =
parameters to</FONT>
<BR><FONT SIZE=3D2>&gt; make things work, it should be preferred to =
just create all</FONT>
<BR><FONT SIZE=3D2>&gt; rollback segments as &quot;private&quot; and =
put their names in the list</FONT>
<BR><FONT SIZE=3D2>&gt; of values in the rollback_segments =
parameter.&nbsp; It must also be</FONT>
<BR><FONT SIZE=3D2>&gt; noted here that the number of &quot;actual =
transactions per</FONT>
<BR><FONT SIZE=3D2>&gt; rollback</FONT>
<BR><FONT SIZE=3D2>&gt; segment&quot; has nothing to do with the</FONT>
<BR><FONT SIZE=3D2>&gt; transactions_per_rollback_segment =
parameter.&nbsp; The number of</FONT>
<BR><FONT SIZE=3D2>&gt; actual transactions per rollback segment is O-S =
and</FONT>
<BR><FONT SIZE=3D2>&gt; db_block_size dependent.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Best Regards,</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Gaja.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; --- &quot;Galleri, Mariana&quot; =
&lt;MGalleri_at_uniFON.com.ar&gt; wrote:</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Ravi,</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; You have two options.</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; 1- You have to use rollback_segments =
parameter and list out</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; all(more than</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; 25) segments</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; there, or</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; 2- You can create public rollback segments =
and you don't</FONT>
<BR><FONT SIZE=3D2>&gt; need</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; to use</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; rollback_segments parameter</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Regards.</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; -----Mensaje original-----</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; De: Ravi Babu [<A =
HREF=3D"mailto:lravibabu_at_hotmail.com">mailto:lravibabu_at_hotmail.com</A>]<=
/FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Enviado el: Martes 11 de Julio de 2000 =
10:45</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Para: Multiple recipients of list =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Asunto: Rollback segments offline on =
database restart</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Hello,</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; I have created 25 rollback segments. Now =
whenever i restart</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; the database few</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; rollback segments are offline. To one =
procedure i have</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; assigened one</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; rollback segment with the help of 'set =
transaction use</FONT>
<BR><FONT SIZE=3D2>&gt; ....'.</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Now whenever</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; the database is restarted around 5-7 =
rollback segments are</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; offline, which i</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; manually have to set it online again. How =
to get this thing</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; done. Do i have</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; to use rollback_segments parameter and =
list out all(more</FONT>
<BR><FONT SIZE=3D2>&gt; than</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; 25) segments</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; there?</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Please help.</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Ravi.</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT =
SIZE=3D2>_______________________________________________________________=
_________</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Get Your Private, Free E-mail from MSN =
Hotmail at</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; <A HREF=3D"http://www.hotmail.com" =
TARGET=3D"_blank">http://www.hotmail.com</A></FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; --</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Author: Ravi Babu</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;&nbsp;&nbsp; INET: =
lravibabu_at_hotmail.com</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Fat City Network =
Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858)</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; 538-5051</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access /</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Mailing Lists</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; To REMOVE yourself from this mailing list, =
send an E-Mail</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; message</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; to: ListGuru_at_fatcity.com (note EXACT =
spelling of 'ListGuru')</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; and in</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; the message BODY, include a line =
containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; (or the name of mailing list you want to =
be removed from).</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; You may</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; also send the HELP command for other =
information (like</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; subscribing).</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; --</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Author: Galleri, Mariana</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;&nbsp;&nbsp; INET: =
MGalleri_at_uniFON.com.ar</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Fat City Network =
Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858)</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; 538-5051</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access /</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; Mailing Lists</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; To REMOVE yourself from this mailing list, =
send an E-Mail</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; message</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; to: ListGuru_at_fatcity.com (note EXACT =
spelling of 'ListGuru')</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; and in</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; the message BODY, include a line =
containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; (or the name of mailing list you want to =
be removed from).</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; You may</FONT>
<BR><FONT SIZE=3D2>&gt; &gt; also send the HELP command for other =
information (like</FONT>
<BR><FONT SIZE=3D2>&gt; subscribing).</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; =3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>&gt; Gaja Krishna Vaidyanatha</FONT>
<BR><FONT SIZE=3D2>&gt; Director, I-O Management Products</FONT>
<BR><FONT SIZE=3D2>&gt; Quest Software Inc.</FONT>
<BR><FONT SIZE=3D2>&gt; (972)-304-1170</FONT>
<BR><FONT SIZE=3D2>&gt; gajav_at_yahoo.com</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; &quot;Opinions and views expressed are my own =
and not of Quest&quot;</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; =
__________________________________________________</FONT>
<BR><FONT SIZE=3D2>&gt; Do You Yahoo!?</FONT>
<BR><FONT SIZE=3D2>&gt; Get Yahoo! Mail - Free email you can access =
from anywhere!</FONT>
<BR><FONT SIZE=3D2>&gt; <A HREF=3D"http://mail.yahoo.com/" =
TARGET=3D"_blank">http://mail.yahoo.com/</A></FONT>
<BR><FONT SIZE=3D2>&gt; --</FONT>
<BR><FONT SIZE=3D2>&gt; Author: Gaja Krishna Vaidyanatha</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp; INET: gajav_at_yahoo.com</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
(858) 538-5051&nbsp; FAX: (858)</FONT>
<BR><FONT SIZE=3D2>&gt; 538-5051</FONT>
<BR><FONT SIZE=3D2>&gt; San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access /</FONT>
<BR><FONT SIZE=3D2>&gt; Mailing Lists</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>&gt; To REMOVE yourself from this mailing list, send =
an E-Mail</FONT>
<BR><FONT SIZE=3D2>&gt; message</FONT>
<BR><FONT SIZE=3D2>&gt; to: ListGuru_at_fatcity.com (note EXACT spelling =
of 'ListGuru')</FONT>
<BR><FONT SIZE=3D2>&gt; and in</FONT>
<BR><FONT SIZE=3D2>&gt; the message BODY, include a line containing: =
UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; (or the name of mailing list you want to be =
removed from). </FONT>
<BR><FONT SIZE=3D2>&gt; You may</FONT>
<BR><FONT SIZE=3D2>&gt; also send the HELP command for other =
information (like</FONT>
<BR><FONT SIZE=3D2>&gt; subscribing).</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; -- </FONT>
<BR><FONT SIZE=3D2>&gt; Author: barry botuck</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp; INET: botes_at_hq.idt.net</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; Fat City Network Services&nbsp;&nbsp;&nbsp; -- =
(858) 538-5051&nbsp; FAX: (858)</FONT>
<BR><FONT SIZE=3D2>&gt; 538-5051</FONT>
<BR><FONT SIZE=3D2>&gt; San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access /</FONT>
<BR><FONT SIZE=3D2>&gt; Mailing Lists</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>&gt; To REMOVE yourself from this mailing list, send =
an E-Mail</FONT>
<BR><FONT SIZE=3D2>&gt; message</FONT>
<BR><FONT SIZE=3D2>&gt; to: ListGuru_at_fatcity.com (note EXACT spelling =
of 'ListGuru')</FONT>
<BR><FONT SIZE=3D2>&gt; and in</FONT>
<BR><FONT SIZE=3D2>&gt; the message BODY, include a line containing: =
UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; (or the name of mailing list you want to be =
removed from). </FONT>
<BR><FONT SIZE=3D2>&gt; You may</FONT>
<BR><FONT SIZE=3D2>&gt; also send the HELP command for other =
information (like</FONT>
<BR><FONT SIZE=3D2>subscribing).</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2>Gaja Krishna Vaidyanatha</FONT>
<BR><FONT SIZE=3D2>Director, I-O Management Products</FONT>
<BR><FONT SIZE=3D2>Quest Software Inc. </FONT>
<BR><FONT SIZE=3D2>(972)-304-1170</FONT>
<BR><FONT SIZE=3D2>gajav_at_yahoo.com</FONT>
</P>

<P><FONT SIZE=3D2>&quot;Opinions and views expressed are my own and not =
of Quest&quot;</FONT>
</P>

<P><FONT =
SIZE=3D2>__________________________________________________</FONT>
<BR><FONT SIZE=3D2>Do You Yahoo!?</FONT>
<BR><FONT SIZE=3D2>Get Yahoo! Mail - Free email you can access from =
anywhere!</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://mail.yahoo.com/" =
TARGET=3D"_blank">http://mail.yahoo.com/</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Gaja Krishna Vaidyanatha</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: gajav_at_yahoo.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =

Received on Wed Jul 12 2000 - 14:45:38 CDT