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: LGWR's Writing Habits

RE: LGWR's Writing Habits

From: Garrity Ed R <Ed.R.Garrity_at_irs.gov>
Date: Wed, 13 Dec 2000 16:43:13 -0500
Message-Id: <10709.124503@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_01C0654D.B1A79150
Content-Type: text/plain;

        charset="iso-8859-1"

Hi Steve,

When I run your all_parameters.sql script the value for _log_io_size is 0. What is the affect of this as it relates to point 2 below? And why would oracle use this as the default value? I assume it is the default, I have never changed this or any other undocumented parameter. The database is a test database, version 8.1.6.1 on Solaris.

Thanks for all your input,
Ed

-----Original Message-----
From: Steve Adams [mailto:steve.adams_at_ixora.com.au] Sent: Wednesday, December 13, 2000 3:11 PM To: Multiple recipients of list ORACLE-L Subject: RE: LGWR's Writing Habits

Hi Gaja,

OK, I did read it as MIN. I retract my previous comment.

Nevertheless, although I don't have access to the source code, I am fairly sure
that it is a MIN, not a MAX.

  1. My testing demonstrates that under intensive redo generation without commits, the average LGWR write is just larger than 1/3 of the log buffer certainly for normal log buffer sizes. I have yet to repeat the test with a log buffer larger than 3M.
  2. Also, the unsolicited email that I got yesterday from the Oracle insider that I mentioned said: "I do have access to the source code and it tells LGWR to write every 3 seconds, 1/3 full or 1M which ever is less."

Maybe you could ask your friend to check again.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-----Original Message-----
Sent: Thursday, 14 December 2000 5:35
To: Steve Adams; Multiple recipients of list ORACLE-L

Hello Steve,

I don't think it has the opposite effect. The function is MAX not MIN. The condition for the 1/3rd full event that forces LGWR to write is when MAX(1 Mb., log_buffer/3) is true.

Here are some examples:

If log_buffer is 512K,
then

    MAX(1 Mb, 170.6K) = 1 Mb.
-- The 1/3rd full event will not kick in as log_buffer is 512K end if;

If log_buffer = 1Mb,
then

    MAX(1 Mb, 333.33K) = 1 Mb.
-- The 1/3rd full event will not kick in as log_buffer is 1 Mb. end if;

If log_buffer = 3 Mb.
then

    MAX(1 Mb, 1 Mb.) = 1 Mb.
-- The 1/3rd full event will kick in as 1/3rd of 3 Mb. is 1 Mb. end if;

If log_buffer = 6 Mb.
then

    MAX(1 Mb, 2 Mb.) = 2 Mb.
-- The 1/3rd full event will kick in as 1/3rd of 6 Mb. is 2 Mb. end if;

Hope that helps,

Gaja


Gaja Krishna Vaidyanatha
Director, Storage Management Products, Quest Software Inc. Office : (972)-304-1170, E-mail : gaja_at_quest.com

Author:Oracle Performance Tuning 101 by Osborne McGraw-Hill "Opinions and views expressed are my own and not of Quest"



Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

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_01C0654D.B1A79150
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.2653.12">
<TITLE>RE: LGWR's Writing Habits</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Hi Steve,</FONT>
</P>

<P><FONT SIZE=3D2>When I run your all_parameters.sql script the value =
for _log_io_size is 0.&nbsp; What is the affect of this as it relates =
to point 2 below?&nbsp; And why would oracle use this as the default =
value?&nbsp; I assume it is the default, I have never changed this or =
any other undocumented parameter.&nbsp; The database is a test =
database, version 8.1.6.1 on Solaris.</FONT></P>

<P><FONT SIZE=3D2>Thanks for all your input,</FONT>
<BR><FONT SIZE=3D2>Ed</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Steve Adams [<A =
HREF=3D"mailto:steve.adams_at_ixora.com.au">mailto:steve.adams_at_ixora.com.au=
</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, December 13, 2000 3:11 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: LGWR's Writing Habits</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hi Gaja,</FONT>
</P>

<P><FONT SIZE=3D2>OK, I did read it as MIN. I retract my previous =
comment.</FONT>
</P>

<P><FONT SIZE=3D2>Nevertheless, although I don't have access to the =
source code, I am fairly sure</FONT>
<BR><FONT SIZE=3D2>that it is a MIN, not a MAX.</FONT>
</P>

<P><FONT SIZE=3D2>1) My testing demonstrates that under intensive redo =
generation without commits,</FONT>
<BR><FONT SIZE=3D2>the average LGWR write is just larger than 1/3 of =
the log buffer certainly for</FONT>
<BR><FONT SIZE=3D2>normal log buffer sizes. I have yet to repeat the =
test with a log buffer larger</FONT>
<BR><FONT SIZE=3D2>than 3M.</FONT>
</P>

<P><FONT SIZE=3D2>2) Also, the unsolicited email that I got yesterday =
from the Oracle insider that</FONT>
<BR><FONT SIZE=3D2>I mentioned said: &quot;I do have access to the =
source code and it tells LGWR to</FONT>
<BR><FONT SIZE=3D2>write every 3 seconds, 1/3 full or 1M which ever is =
less.&quot;</FONT>
</P>

<P><FONT SIZE=3D2>Maybe you could ask your friend to check =
again.</FONT>
</P>

<P><FONT SIZE=3D2>@&nbsp;&nbsp; Regards,</FONT>
<BR><FONT SIZE=3D2>@&nbsp;&nbsp; Steve Adams</FONT>
<BR><FONT SIZE=3D2>@&nbsp;&nbsp; <A HREF=3D"http://www.ixora.com.au/" =
TARGET=3D"_blank">http://www.ixora.com.au/</A></FONT>
<BR><FONT SIZE=3D2>@&nbsp;&nbsp; <A =
HREF=3D"http://www.christianity.net.au/" =
TARGET=3D"_blank">http://www.christianity.net.au/</A></FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, 14 December 2000 5:35</FONT>
<BR><FONT SIZE=3D2>To: Steve Adams; Multiple recipients of list =
ORACLE-L</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hello Steve,</FONT>
</P>

<P><FONT SIZE=3D2>I don't think it has the opposite effect. The =
function is MAX</FONT>
<BR><FONT SIZE=3D2>not MIN. The condition for the 1/3rd full event that =
forces LGWR</FONT>
<BR><FONT SIZE=3D2>to write is when MAX(1 Mb., log_buffer/3) is =
true.</FONT>
</P>

<P><FONT SIZE=3D2>Here are some examples:</FONT>
</P>

<P><FONT SIZE=3D2>If log_buffer is 512K,</FONT>
<BR><FONT SIZE=3D2>then</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; MAX(1 Mb, 170.6K) =3D 1 =
Mb.</FONT>
<BR><FONT SIZE=3D2>-- The 1/3rd full event will not kick in as =
log_buffer is 512K</FONT>
<BR><FONT SIZE=3D2>end if;</FONT>
</P>

<P><FONT SIZE=3D2>If log_buffer =3D 1Mb,</FONT>
<BR><FONT SIZE=3D2>then</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; MAX(1 Mb, 333.33K) =3D 1 =
Mb.</FONT>
<BR><FONT SIZE=3D2>-- The 1/3rd full event will not kick in as =
log_buffer is 1 Mb.</FONT>
<BR><FONT SIZE=3D2>end if;</FONT>
</P>

<P><FONT SIZE=3D2>If log_buffer =3D 3 Mb.</FONT>
<BR><FONT SIZE=3D2>then</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; MAX(1 Mb, 1 Mb.) =3D 1 Mb.</FONT>
<BR><FONT SIZE=3D2>-- The 1/3rd full event will kick in as 1/3rd of 3 =
Mb. is 1 Mb.</FONT>
<BR><FONT SIZE=3D2>end if;</FONT>
</P>

<P><FONT SIZE=3D2>If log_buffer =3D 6 Mb.</FONT>
<BR><FONT SIZE=3D2>then</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; MAX(1 Mb, 2 Mb.) =3D 2 Mb.</FONT>
<BR><FONT SIZE=3D2>-- The 1/3rd full event will kick in as 1/3rd of 6 =
Mb. is 2 Mb.</FONT>
<BR><FONT SIZE=3D2>end if;</FONT>
</P>

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

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

<P><FONT SIZE=3D2>--- Steve Adams &lt;steve.adams_at_ixora.com.au&gt; =
wrote:</FONT>
<BR><FONT SIZE=3D2>&gt; Hi Gaja,</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Have another look at that MAX, and you'll see =
that it has the</FONT>
<BR><FONT SIZE=3D2>&gt; opposite effect to</FONT>
<BR><FONT SIZE=3D2>&gt; what you claim. That is, the 1/3 threshold is =
effective</FONT>
<BR><FONT SIZE=3D2>&gt; *below* that threshold,</FONT>
<BR><FONT SIZE=3D2>&gt; not *above* it.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; @&nbsp;&nbsp; Regards,</FONT>
<BR><FONT SIZE=3D2>&gt; @&nbsp;&nbsp; Steve Adams</FONT>
<BR><FONT SIZE=3D2>&gt; @&nbsp;&nbsp; <A =
HREF=3D"http://www.ixora.com.au/" =
TARGET=3D"_blank">http://www.ixora.com.au/</A></FONT>
<BR><FONT SIZE=3D2>&gt; @&nbsp;&nbsp; <A =
HREF=3D"http://www.christianity.net.au/" =
TARGET=3D"_blank">http://www.christianity.net.au/</A></FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; -----Original Message-----</FONT>
<BR><FONT SIZE=3D2>&gt; From: Gaja Krishna Vaidyanatha [<A =
HREF=3D"mailto:gajav_at_yahoo.com">mailto:gajav_at_yahoo.com</A>]</FONT>
<BR><FONT SIZE=3D2>&gt; Sent: Thursday, 14 December 2000 3:45</FONT>
<BR><FONT SIZE=3D2>&gt; To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>&gt; Subject: LGWR's Writing Habits</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Hello everyone,</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; A couple of days ago I had posted a response to =
someone's</FONT>
<BR><FONT SIZE=3D2>&gt; query</FONT>
<BR><FONT SIZE=3D2>&gt; about copy latches and in that discussion I had =
mentioned that</FONT>
<BR><FONT SIZE=3D2>&gt; the 1/3 full event of the redo log buffer will =
really not</FONT>
<BR><FONT SIZE=3D2>&gt; 'kick</FONT>
<BR><FONT SIZE=3D2>&gt; in' unless log_buffer is set to at least 1Mb. I =
must confess</FONT>
<BR><FONT SIZE=3D2>&gt; that the number here is actually 3Mb and not =
1Mb as posted</FONT>
<BR><FONT SIZE=3D2>&gt; before. I apologize for that typo.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; However, the fact remains that from Oracle8, =
LGWR will not be</FONT>
<BR><FONT SIZE=3D2>&gt; posted by the 1/3rd full event of the redo log =
buffer, unless</FONT>
<BR><FONT SIZE=3D2>&gt; there are at least 1 Mb worth of redo entries =
in the</FONT>
<BR><FONT SIZE=3D2>&gt; log_buffer.</FONT>
<BR><FONT SIZE=3D2>&gt; In my previous posting, I said that for this to =
occur the</FONT>
<BR><FONT SIZE=3D2>&gt; log_buffer should be sized at least 1 Mb, but =
that number is</FONT>
<BR><FONT SIZE=3D2>&gt; actually even higher - 3 Mb.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; And the rationale behind that stems from the =
events on which</FONT>
<BR><FONT SIZE=3D2>&gt; LGWR writes to disk. They are as =
follows:</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; 1) Every 3 secs (independent of DBWR, yes this =
has been proven</FONT>
<BR><FONT SIZE=3D2>&gt; to be true by testing and looking up the source =
code).</FONT>
<BR><FONT SIZE=3D2>&gt; 2) On a Commit.</FONT>
<BR><FONT SIZE=3D2>&gt; 3) When DBWR posts LGWR to write. (This is to =
make sure that</FONT>
<BR><FONT SIZE=3D2>&gt; the</FONT>
<BR><FONT SIZE=3D2>&gt; redo entires are written before 'dirty' blocks =
are written to</FONT>
<BR><FONT SIZE=3D2>&gt; disk).</FONT>
<BR><FONT SIZE=3D2>&gt; 4) On checkpoints.</FONT>
<BR><FONT SIZE=3D2>&gt; 5) When the log_buffer is 1/3rd full, but =
subject to the</FONT>
<BR><FONT SIZE=3D2>&gt; following formula MAX(1 Mb., log_buffer/3), =
i.e., at least 1</FONT>
<BR><FONT SIZE=3D2>&gt; Mb</FONT>
<BR><FONT SIZE=3D2>&gt; of redo entries need to be there, for the 1/3 =
event to occur.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Now let's think about this for a minute. =
Realistically the</FONT>
<BR><FONT SIZE=3D2>&gt; need</FONT>
<BR><FONT SIZE=3D2>&gt; for the 1/3rd full event is not that critical, =
as events 1-4</FONT>
<BR><FONT SIZE=3D2>&gt; will take care of getting the redo entries down =
to disk. And</FONT>
<BR><FONT SIZE=3D2>&gt; this in no way will cause more 'log buffer =
space' waits than</FONT>
<BR><FONT SIZE=3D2>&gt; what the system is already experiencing.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; To make doubly sure that I was not 'under the =
influence', I</FONT>
<BR><FONT SIZE=3D2>&gt; called a very good friend of mine at Oracle, =
and had him check</FONT>
<BR><FONT SIZE=3D2>&gt; the source code for 8.0.5, and he corroborated =
my claim. We</FONT>
<BR><FONT SIZE=3D2>&gt; are</FONT>
<BR><FONT SIZE=3D2>&gt; doing some further digging, to determine =
whether 'all' or</FONT>
<BR><FONT SIZE=3D2>&gt; 'one'</FONT>
<BR><FONT SIZE=3D2>&gt; of the redo copy latches are used to protect =
the buffer, while</FONT>
<BR><FONT SIZE=3D2>&gt; 'flushing' the entire contents of the =
log_buffer. There are 2</FONT>
<BR><FONT SIZE=3D2>&gt; references to this (one mentioning 1 copy latch =
and the other</FONT>
<BR><FONT SIZE=3D2>&gt; mentioning all copy latches) and we will get to =
the bottom of</FONT>
<BR><FONT SIZE=3D2>&gt; that and I will then post our findings.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; End of technical stuff;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; =
********************************************************</FONT>
<BR><FONT SIZE=3D2>&gt; Begin non-technical stuff;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; When I originally posted that the 1/3rd full =
event has changed</FONT>
<BR><FONT SIZE=3D2>&gt; in functionality in Oracle8, it was termed as a =
'ludicrous</FONT>
<BR><FONT SIZE=3D2>&gt; suggestion'. Now, that comment may have gone =
'just a bit too</FONT>
<BR><FONT SIZE=3D2>&gt; far' to my personal comfort, as it was directed =
against me</FONT>
<BR><FONT SIZE=3D2>&gt; 'point blank'. I just could not hit the 'delete =
key' on that</FONT>
<BR><FONT SIZE=3D2>&gt; one.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; In light of all the 'country of origin' and =
'ethnic</FONT>
<BR><FONT SIZE=3D2>&gt; background'</FONT>
<BR><FONT SIZE=3D2>&gt; stuff that has gone through our list in the =
past couple of</FONT>
<BR><FONT SIZE=3D2>&gt; days,</FONT>
<BR><FONT SIZE=3D2>&gt; I humbly urge all of us to exercise some =
caution in our</FONT>
<BR><FONT SIZE=3D2>&gt; communications. This is an forum where we =
cannot guage the</FONT>
<BR><FONT SIZE=3D2>&gt; poster's feelings, hence we need to make sure =
that we are</FONT>
<BR><FONT SIZE=3D2>&gt; sensitive to the reader's feelings.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; While it is absolutely OK to question the =
contents of a</FONT>
<BR><FONT SIZE=3D2>&gt; posting,</FONT>
<BR><FONT SIZE=3D2>&gt; please do it in a manner that is 'amicable'. =
After all, we are</FONT>
<BR><FONT SIZE=3D2>&gt; human beings first, aside of our ethnic, =
cultural, religious</FONT>
<BR><FONT SIZE=3D2>&gt; and</FONT>
<BR><FONT SIZE=3D2>&gt; political backgrounds. Let's try to respect =
thatm core fact.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; When I met Jared approx. 3 years ago at an =
IOUG-A conference,</FONT>
<BR><FONT SIZE=3D2>&gt; we</FONT>
<BR><FONT SIZE=3D2>&gt; talked about creating an Oracle listserv to =
'share relevant</FONT>
<BR><FONT SIZE=3D2>&gt; and</FONT>
<BR><FONT SIZE=3D2>&gt; accurate information'. I don't think Jared or =
any one of us,</FONT>
<BR><FONT SIZE=3D2>&gt; would want this to become 'electronic =
battleground' for food</FONT>
<BR><FONT SIZE=3D2>&gt; fights or to be a forum to 'force and assert =
one's technical</FONT>
<BR><FONT SIZE=3D2>&gt; or</FONT>
<BR><FONT SIZE=3D2>&gt; personal ego'.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; This list today has a few thousand individuals =
from all</FONT>
<BR><FONT SIZE=3D2>&gt; corners</FONT>
<BR><FONT SIZE=3D2>&gt; of the world, and all of us contribute to the =
best of our</FONT>
<BR><FONT SIZE=3D2>&gt; abilities. Let's continue the great technical =
content exchange</FONT>
<BR><FONT SIZE=3D2>&gt; that we have had and let's do that with =
'respect for the</FONT>
<BR><FONT SIZE=3D2>&gt; reader'. Thanks for your patience, tolerance =
and technical</FONT>
<BR><FONT SIZE=3D2>&gt; prowess.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; End non-technical stuff;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; =
********************************************************</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Seasons Greetings,</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;</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, Storage Management Products, Quest =
Software Inc.</FONT>
<BR><FONT SIZE=3D2>&gt; Office : (972)-304-1170, E-mail : =
gaja_at_quest.com</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; Author:Oracle Performance Tuning 101 by Osborne =
McGraw-Hill</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; Yahoo! Shopping - Thousands of Stores. Millions =
of Products.</FONT>
<BR><FONT SIZE=3D2>&gt; <A HREF=3D"http://shopping.yahoo.com/" =
TARGET=3D"_blank">http://shopping.yahoo.com/</A></FONT>
<BR><FONT SIZE=3D2>&gt; --</FONT>
<BR><FONT SIZE=3D2>&gt; Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.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>
</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, Storage Management Products, Quest =
Software Inc.</FONT>
<BR><FONT SIZE=3D2>Office : (972)-304-1170, E-mail : =
gaja_at_quest.com</FONT>
</P>

<P><FONT SIZE=3D2>Author:Oracle Performance Tuning 101 by Osborne =
McGraw-Hill</FONT>
<BR><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>Yahoo! Shopping - Thousands of Stores. Millions of =
Products.</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://shopping.yahoo.com/" =
TARGET=3D"_blank">http://shopping.yahoo.com/</A></FONT>
</P>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Steve Adams</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: steve.adams_at_ixora.com.au</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 Dec 13 2000 - 15:43:13 CST

Original text of this message

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