| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Estimating User Load on the system
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.
------=_NextPartTM-000-367d1588-46ab-443f-83f9-fadf9e577b43 Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C34A8D.500B5C83"
------_=_NextPart_001_01C34A8D.500B5C83
Content-Type: text/plain;
charset="iso-8859-1"
Thanks, but I am _not_ looking for culprits ... and I will be collecting this data over a week so collecting traces is not an option. I have queries run by research dept that routinely scan millions of rows, multiple times a day ... EMC should be happy though ...
Thanks again
Raj
-----Original Message-----
From: Anil Sikri [mailto:asikri_oracledba_at_yahoo.com]
Sent: Monday, July 14, 2003 7:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Estimating User Load on the system
Hello folks,
Recently, I employed a similar approach in our test
database to figure out the problematic queries during
a certain load test. I used a logon trigger with just 2
statements :
alter session set max_dump_file_size =
unlimited;
alter session set sql_trace = true;
The init.ora had to be modified to set _public_trace_files =
true to allow the database userid used by the application
to be able to write to the user_dump_dest.
Regarding the specifics of the test, I coordinated with the
testers and created the trigger just before the load test
began and dropped it after the test was over. Of course, I
had to make sure that this load test was the only
application
running. There were around 90 trace files generated which
gave me much more information that I ever envisioned.
It showed that the connection pooling of the application
was implemented poorly since 90 files were generated
during a 1 hour load test. Also, I consolidated all the
trace
files into 1 huge trace file using a shell script and ran it
through TKPROF. The information obtained was priceless.
It not only provided the culprit queries, it also provided
the
amount was time being spent in the database out of a total
load test of 1 hour.
Just wanted to share it with you folks.
Let me know if you have any questions.
Anil
"Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
Thanks John ... this is precisely (the logoff trigger) is what I am in middle ot writing down ... except that I am taking everything from v$sesstat instead of selective stuff. I can then filter out what I don't need.
Raj
-----Original Message-----
From: John Kanagaraj [ mailto:john.kanagaraj_at_hds.com
<mailto:john.kanagaraj_at_hds.com> ]
Sent: Monday, July 14, 2003 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Estimating User Load on the system
Raj,
Assuming that these users will logoff normally (for the most cases), you could have a database level LOGOFF trigger that captures the following 'stats' from these sessions (out of v$MYSTAT):
CPU used by this session (Cpu time used) user commits (Number of transactions - figuratively!) physical reads + physical reads (direct, lob, etc.) + db block changes (former is reads, latter is the number of changes that would cause writes on
behalf of that process for Log, Undo and DBFile) session pga/uga memory max (Memory usage) SQL*Net roundtrips to/from client and dblink (Network usage)
Collect and summari! ze system wide (via STATSPACK) and for individual users
via LOGOFF just to compare.
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
Disappointment is inevitable, but Discouragement is optional!
employer or clients **
-----Original Message-----
Sent: Monday, July 14, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L
Thanks Dennis,
I have periodic (10 mins) snapshots taken of following views ...
Now, I really _can't_ use Statspack, because it tells me overall score. I need to compute the load put on system by a set list of users ... it is kind
of computation of possible charge back.
So, I have the underlying system stats. but I am having tough time to put them in perspective for management types. I'd like to show them %CPU usage, %IO load, %Memory being used ...
any ideas?
Raj
-----Original Message-----
< mailto:DWILLIAMS_at_LIFETOUCH.COM <mailto:DWILLIAMS_at_LIFETOUCH.COM> > ]
Sent: Monday, July 14, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L
Raj
I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that time. As Jared points out, the three components are CPU, I/O, and memory. For example, you may find that one of these target users is the high
CPU consumer from an Oracle perspective at a point in time. Now, if you discovered the system CPUs weren't being taxed at that time your conclusions
might be different than if you discovered the system CPUs were pegged at 100% at that time.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, July 14, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
Load on a system is in general comprised of three components: CPU, memory and IO.
If you have something in place to track those on a per user basis, then you're doing well. You might consider also tracking other users, so that you have a basis for comparison.
Jared
On Monday 14 July 2003 07:04, Jamadagni, Rajendra wrote: > I have been asked to compute the load put on the system by a 'select group
> of userids'. I know these users and have put something in place where I > sample periodically following > > 1. session stats > 2. session io > 3. system stats > 4. number of sessions > 5. v$transaction > > Am I missing something? Has anyone done this before? If so, what have you > computed ? > > TIA
>- ---- > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art !
-- Please see the official ORACLE-L FAQ: http://www.orafaq.netReceived on Mon Jul 14 2003 - 23:55:29 CDT
<http://www.orafaq.net/>
< http://www.orafaq.net <http://www.orafaq.net/> >
-- Author: Jared Still INET: jkstill_at_cybcon.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com/>
< http://www.fatcity.com <http://www.fatcity.com/> >
San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net
<http://www.orafaq.net/>
< http://www.orafaq.net <http://www.orafaq.net/> >
-- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com/>
< http://www.fatcity.com <http://www.fatcity.com/> >
San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net
<http://www.orafaq.net/>
-- Author: John Kanagaraj INET: john.kanagaraj_at_hds.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com/>
San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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). ********************************************************************This e-mail message is confidential, intended only for the named recipient(s) ab! ove and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2 _____ Do you Yahoo!? The New <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> Yahoo! Search - Faster. Easier. Bingo. ------_=_NextPart_001_01C34A8D.500B5C83 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4926.2500" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D018245304-15072003><FONT face=3DArial =
color=3D#0000ff=20 size=3D2>Thanks, but I am _not_ looking for culprits ... and I will be = collecting=20 this data over a week so collecting traces is not an option. I have = queries run=20 by research dept that routinely scan millions of rows, multiple times a = day ... EMC should be happy though ...</FONT></SPAN></DIV>
<DIV><SPAN class=3D018245304-15072003><FONT face=3DArial =
color=3D#0000ff=20 size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D018245304-15072003><FONT face=3DArial =
color=3D#0000ff size=3D2>Thanks=20 again</FONT></SPAN></DIV>
<DIV><SPAN class=3D018245304-15072003><FONT face=3DArial =
color=3D#0000ff=20 size=3D2>Raj</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20 size=3D2>-----Original Message-----<BR><B>From:</B> Anil Sikri=20 [mailto:asikri_oracledba_at_yahoo.com]<BR><B>Sent:</B> Monday, July 14, = 2003 7:59=20 PM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B> RE:=20 Estimating User Load on the system<BR><BR></FONT></DIV> <DIV>Hello folks,</DIV> =
<DIV> &=
nbsp; =20 Recently, I employed a similar approach in our test </DIV> =
<DIV> &=
nbsp; =20 database to figure out the problematic queries during</DIV> =
<DIV> &=
nbsp; =20 a certain load test. I used a logon trigger with just 2 </DIV> =
<DIV> &=
nbsp; =20 statements :</DIV> =
<DIV> &=
nbsp; &= nbsp; =20 alter session set max_dump_file_size =3D unlimited;</DIV> =
<DIV> &=
nbsp; &= nbsp; =20 alter session set sql_trace =3D true;</DIV> <DIV> </DIV> =
<DIV> &=
nbsp; =20 The init.ora had to be modified to set _public_trace_files =3D </DIV> =
<DIV> &=
nbsp; =20 true to allow the database userid used by the application</DIV> =
<DIV> &=
nbsp; =20 to be able to write to the user_dump_dest.</DIV> <DIV> </DIV> =
<DIV> &=
nbsp; =20 Regarding the specifics of the test, I coordinated with the </DIV> =
<DIV> &=
nbsp; =20 testers and created the trigger just before the load test </DIV> =
<DIV> &=
nbsp; =20 began and dropped it after the test was over. Of course, I </DIV> =
<DIV> &=
nbsp; =20 had to make sure that this load test was the only application</DIV> =
<DIV> &=
nbsp; =20 running. There were around 90 trace files generated which</DIV> =
<DIV> &=
nbsp; =20 gave me much more information that I ever envisioned.</DIV> =
<DIV> &=
nbsp; =20 It showed that the connection pooling of the application </DIV> =
<DIV> &=
nbsp; =20 was implemented poorly since 90 files were generated </DIV> =
<DIV> &=
nbsp; =20 during a 1 hour load test. Also, I consolidated all the trace</DIV> =
<DIV> &=
nbsp; =20 files into 1 huge trace file using a shell script and ran it</DIV> =
<DIV> &=
nbsp; =20 through TKPROF. The information obtained was priceless.</DIV> =
<DIV> &=
nbsp; =20 It not only provided the culprit queries, it also provided the</DIV> =
<DIV> &=
nbsp; =20 amount was time being spent in the database out of a total</DIV> =
<DIV> &=
nbsp; =20 load test of 1 hour.</DIV> <DIV> </DIV> =
<DIV> &=
nbsp; =20 Just wanted to share it with you folks.</DIV> =
<DIV> &=
nbsp; =20 Let me know if you have any questions.</DIV> <DIV> </DIV> <DIV>Anil</DIV> =
<DIV> &=
nbsp; =20 <BR><BR><B><I>"Jamadagni, Rajendra"=20 <Rajendra.Jamadagni_at_espn.com></I></B> wrote:</DIV> <DIV> <BLOCKQUOTE=20 style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff = 2px solid; WIDTH: 100%"> <META content=3D"MS Exchange Server version 5.5.2654.45" = name=3DGenerator> <P><FONT size=3D2>Thanks John ... this is precisely (the logoff = trigger) is=20 what I am in middle ot writing down ... except that I am taking = everything=20 from v$sesstat instead of selective stuff. I can then filter out = what I=20 don't need.</FONT></P> <P><FONT size=3D2>Raj</FONT> <BR><FONT=20 = size=3D2>---------------------------------------------------------------= -----------------</FONT>=20 <BR><FONT size=3D2>Rajendra dot Jamadagni at nospamespn dot = com</FONT>=20 <BR><FONT size=3D2>All Views expressed in this email are strictly=20 personal.</FONT> <BR><FONT size=3D2>QOTD: Any clod can have facts, = having an=20 opinion is an art !</FONT> </P><BR> <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT = size=3D2>From:=20 John Kanagaraj [<A=20 = href=3D"mailto:john.kanagaraj_at_hds.com">mailto:john.kanagaraj_at_hds.com</A>= ]</FONT>=20 <BR><FONT size=3D2>Sent: Monday, July 14, 2003 1:55 PM</FONT> =
<BR><FONT=20
size=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT=20 size=3D2>Subject: RE: Estimating User Load on the system</FONT> =
</P><BR>
<P><FONT size=3D2>Raj,</FONT> <BR><FONT size=3D2> </FONT> =
<BR><FONT=20
size=3D2>Assuming that these users will logoff normally (for the = most cases),=20 you</FONT> <BR><FONT size=3D2>could have a database level LOGOFF = trigger that=20 captures the following</FONT> <BR><FONT size=3D2>'stats' from these = sessions=20 (out of v$MYSTAT):</FONT> <BR><FONT size=3D2> </FONT> =
<BR><FONT=20
size=3D2>CPU used by this session (Cpu time used)</FONT> =
<BR><FONT=20
size=3D2>user commits (Number of transactions - = figuratively!)</FONT>=20 <BR><FONT size=3D2>physical reads + physical reads (direct, lob, = etc.) + db=20 block changes</FONT> <BR><FONT size=3D2>(former is reads, latter is = the number=20 of changes that would cause writes on</FONT> <BR><FONT = size=3D2>behalf of that=20 process for Log, Undo and DBFile)</FONT> <BR><FONT size=3D2>session = pga/uga=20 memory max (Memory usage)</FONT> <BR><FONT size=3D2>SQL*Net = roundtrips to/from=20 client and dblink (Network usage)</FONT> <BR><FONT = size=3D2> </FONT>=20 <BR><FONT size=3D2>Collect and summari! ze system wide (via = STATSPACK) and for=20 individual users</FONT> <BR><FONT size=3D2>via LOGOFF just to = compare.</FONT>=20 <BR><FONT size=3D2> </FONT> <BR><FONT size=3D2>John = Kanagaraj</FONT>=20 <BR><FONT size=3D2>Oracle Applications DBA</FONT> <BR><FONT = size=3D2>DBSoft=20 Inc</FONT> <BR><FONT size=3D2>(W): 408-970-7002</FONT> </P> <P><FONT size=3D2>Disappointment is inevitable, but Discouragement = is=20 optional!</FONT> </P> <P><FONT size=3D2>** The opinions and statements above are entirely = my own and=20 not those of my</FONT> <BR><FONT size=3D2>employer or clients = **</FONT>=20 </P><BR> <P><FONT size=3D2></FONT><BR><FONT size=3D2> -----Original=20 Message-----</FONT> <BR><FONT size=3D2>Sent: Monday, July 14, 2003 = 10:14=20 AM</FONT> <BR><FONT size=3D2>To: Multiple recipients of list = ORACLE-L</FONT>=20 </P><BR><BR> <P><FONT size=3D2>Thanks Dennis, </FONT></P> <P><FONT size=3D2>I have periodic (10 mins) snapshots taken of = following views=20 ... </FONT></P> <P><FONT size=3D2>1. gv$session </FONT><BR><FONT size=3D2>2. = gv$sesstat=20 </FONT><BR><FONT size=3D2>3. gv$transaction </FONT><BR><FONT = size=3D2>4.=20 gv$sess_io </FONT><BR><FONT size=3D2>5. gv$sysstat </FONT></P> <P><FONT size=3D2>Now, I really _can't_ use Statspack, because it = tells me=20 overall score. I</FONT> <BR><FONT size=3D2>need to compute the load = put on=20 system by a set list of users ... it is kind</FONT> <BR><FONT = size=3D2>of=20 computation of possible charge back.</FONT> </P> <P><FONT size=3D2>So, I have the underlying system stats. but I am = having=20 tough time to put</FONT> <BR><FONT size=3D2>them in perspective for = management=20 types. I'd like to show them %CPU usage,</FONT> <BR><FONT = size=3D2>%IO load,=20 %Memory being used ...</FONT> </P> <P><FONT size=3D2>any ideas? </FONT><BR><FONT size=3D2>Raj =
</FONT><BR><FONT=20
= size=3D2>---------------------------------------------------------------= -------------</FONT>=20 <BR><FONT size=3D2>---- </FONT><BR><FONT size=3D2>Rajendra dot = Jamadagni at=20 nospamespn dot com </FONT><BR><FONT size=3D2>All Views expressed in = this email=20 are strictly personal. </FONT><BR><FONT size=3D2>QOTD: Any clod can = have=20 facts, having an opinion is an art ! </FONT></P><BR> <P><FONT size=3D2>-----Original Message----- </FONT><BR><FONT = size=3D2><<A=20 = href=3D"mailto:DWILLIAMS_at_LIFETOUCH.COM">mailto:DWILLIAMS_at_LIFETOUCH.COM</= A>>=20 ] </FONT><BR><FONT size=3D2>Sent: Monday, July 14, 2003 12:49 PM=20 </FONT><BR><FONT size=3D2>To: Multiple recipients of list ORACLE-L=20 </FONT></P><BR> <P><FONT size=3D2>Raj </FONT><BR><FONT size=3D2> I'll = second Jared's=20 idea. Don Burleson in his book Oracle9i </FONT><BR><FONT=20 size=3D2>High-Performance Tuning with STATSPACK makes a strong = point that=20 looking at </FONT><BR><FONT size=3D2>system load must start with = the=20 underlying system. Any look at Oracle </FONT><BR><FONT = size=3D2>performance=20 must begin with an understanding of what the system load was at=20 </FONT><BR><FONT size=3D2>that time. As Jared points out, the three = components=20 are CPU, I/O, and </FONT><BR><FONT size=3D2>memory. For example, = you may find=20 that one of these target users is the high</FONT> </P> <P><FONT size=3D2>CPU consumer from an Oracle perspective at a = point in time.=20 Now, if you </FONT><BR><FONT size=3D2>discovered the system CPUs = weren't being=20 taxed at that time your conclusions</FONT> </P> <P><FONT size=3D2>might be different than if you discovered the = system CPUs=20 were pegged at </FONT><BR><FONT size=3D2>100% at that time. =
</FONT></P>
<P><FONT size=3D2>Dennis Williams </FONT><BR><FONT size=3D2>DBA, = 80%OCP, 100%=20 DBA </FONT><BR><FONT size=3D2>Lifetouch, Inc. </FONT><BR><FONT=20 size=3D2>dwilliams_at_lifetouch.com </FONT></P> <P><FONT size=3D2>-----Original Message----- </FONT><BR><FONT = size=3D2>Sent:=20 Monday, July 14, 2003 10:19 AM </FONT><BR><FONT size=3D2>To: = Multiple=20 recipients of list ORACLE-L </FONT></P><BR><BR> <P><FONT size=3D2>Load on a system is in general comprised of three = components: </FONT><BR><FONT size=3D2>CPU, memory and IO. =
</FONT></P>
<P><FONT size=3D2>If you have something in place to track those on = a per user=20 </FONT><BR><FONT size=3D2>basis, then you're doing well. You = might=20 consider also tracking </FONT><BR><FONT size=3D2>other users, so = that you have=20 a basis for comparison. </FONT></P> <P><FONT size=3D2>Jared </FONT></P> <P><FONT size=3D2>On Monday 14 July 2003 07:04, Jamadagni, Rajendra = wrote:=20 </FONT><BR><FONT size=3D2>> I have been asked to compute the = load put on=20 the system by a 'select group</FONT> </P> <P><FONT size=3D2>> of userids'. I know these users and have put = something=20 in place where I </FONT><BR><FONT size=3D2>> sample periodically = following=20 </FONT><BR><FONT size=3D2>> </FONT><BR><FONT size=3D2>> 1. = session stats=20 </FONT><BR><FONT size=3D2>> 2. session io </FONT><BR><FONT = size=3D2>> 3.=20 system stats </FONT><BR><FONT size=3D2>> 4. number of sessions=20 </FONT><BR><FONT size=3D2>> 5. v$transaction </FONT><BR><FONT = size=3D2>>=20 </FONT><BR><FONT size=3D2>> Am I missing something? Has anyone = done this=20 before? If so, what have you</FONT> </P> <P><FONT size=3D2>> computed ? </FONT><BR><FONT size=3D2>>=20 </FONT><BR><FONT size=3D2>> TIA </FONT><BR><FONT size=3D2>> = Raj=20 </FONT><BR><FONT size=3D2>> </FONT><BR><FONT=20 = size=3D2>---------------------------------------------------------------= ------------=20 </FONT><BR><FONT size=3D2>>- ---- </FONT><BR><FONT size=3D2>> = Rajendra dot=20 Jamadagni at nospamespn dot com </FONT><BR><FONT size=3D2>> All = Views=20 expressed in this email are strictly personal. </FONT><BR><FONT = size=3D2>>=20 QOTD: Any clod can have facts, having an opinion is an art ! =
</FONT></P>
<P><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Please see the = official ORACLE-L=20 FAQ: <A target=3D_blank=20 href=3D"http://www.orafaq.net/">http://www.orafaq.net</A></FONT> =
<BR><FONT=20
size=3D2><<A target=3D_blank=20 href=3D"http://www.orafaq.net/">http://www.orafaq.net</A>> = </FONT><BR><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Author: = Jared Still=20 </FONT><BR><FONT size=3D2> INET: jkstill_at_cybcon.com =
</FONT></P>
<P><FONT size=3D2>Fat City Network Services -- = 858-538-5051=20 <A target=3D_blank=20 href=3D"http://www.fatcity.com/">http://www.fatcity.com</A></FONT> =
<BR><FONT=20
size=3D2><<A target=3D_blank=20 = href=3D"http://www.fatcity.com/">http://www.fatcity.com</A>> =20 </FONT><BR><FONT size=3D2>San Diego,=20 California -- Mailing = list and web=20 hosting services </FONT><BR><FONT=20 = size=3D2>---------------------------------------------------------------= ------=20 </FONT><BR><FONT size=3D2>To REMOVE yourself from this mailing = list, send an=20 E-Mail message </FONT><BR><FONT size=3D2>to: ListGuru_at_fatcity.com = (note EXACT=20 spelling of 'ListGuru') and in </FONT><BR><FONT size=3D2>the = message BODY,=20 include a line containing: UNSUB ORACLE-L </FONT><BR><FONT = size=3D2>(or the=20 name of mailing list you want to be removed from). You may=20 </FONT><BR><FONT size=3D2>also send the HELP command for other = information=20 (like subscribing). </FONT><BR><FONT size=3D2>-- </FONT><BR><FONT=20 size=3D2>Please see the official ORACLE-L FAQ: <A target=3D_blank=20 href=3D"http://www.orafaq.net/">http://www.orafaq.net</A></FONT> =
<BR><FONT=20
size=3D2><<A target=3D_blank=20 href=3D"http://www.orafaq.net/">http://www.orafaq.net</A>> = </FONT><BR><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Author: = DENNIS WILLIAMS=20 </FONT><BR><FONT size=3D2> INET: DWILLIAMS_at_LIFETOUCH.COM =
</FONT></P>
<P><FONT size=3D2>Fat City Network Services -- = 858-538-5051=20 <A target=3D_blank=20 href=3D"http://www.fatcity.com/">http://www.fatcity.com</A></FONT> =
<BR><FONT=20
size=3D2><<A target=3D_blank=20 = href=3D"http://www.fatcity.com/">http://www.fatcity.com</A>> =20 </FONT><BR><FONT size=3D2>San Diego,=20 California -- Mailing = list and web=20 hosting services </FONT><BR><FONT=20 = size=3D2>---------------------------------------------------------------= ------=20 </FONT><BR><FONT size=3D2>To REMOVE yourself from this mailing = list, send an=20 E-Mail message </FONT><BR><FONT size=3D2>to: ListGuru_at_fatcity.com = (note EXACT=20 spelling of 'ListGuru') and in </FONT><BR><FONT size=3D2>the = message BODY,=20 include a line containing: UNSUB ORACLE-L </FONT><BR><FONT = size=3D2>(or the=20 name of mailing list you want to be removed from). You may=20 </FONT><BR><FONT size=3D2>also send the HELP command for other = information=20 (like subscribing). </FONT></P> <P><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Please see the = official ORACLE-L=20 FAQ: <A target=3D_blank=20 href=3D"http://www.orafaq.net/">http://www.orafaq.net</A></FONT> =
<BR><FONT=20
size=3D2>-- </FONT><BR><FONT size=3D2>Author: John Kanagaraj</FONT> =
<BR><FONT=20
size=3D2> INET: john.kanagaraj_at_hds.com</FONT> </P> <P><FONT size=3D2>Fat City Network Services -- = 858-538-5051=20 <A target=3D_blank=20 href=3D"http://www.fatcity.com/">http://www.fatcity.com</A></FONT> =
<BR><FONT=20
size=3D2>San Diego, = California --=20 Mailing list and web hosting services</FONT> <BR><FONT=20 = size=3D2>---------------------------------------------------------------= ------</FONT>=20 <BR><FONT size=3D2>To REMOVE yourself from this mailing list, send = an E-Mail=20 message</FONT> <BR><FONT size=3D2>to: ListGuru_at_fatcity.com (note = EXACT=20 spelling of 'ListGuru') and in</FONT> <BR><FONT size=3D2>the = message BODY,=20 include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT = size=3D2>(or the=20 name of mailing list you want to be removed from). You = may</FONT>=20 <BR><FONT size=3D2>also send the HELP command for other information = (like=20 subscribing).</FONT>=20 =
</P>********************************************************************=
This=20 e-mail message is confidential, intended only for the named = recipient(s) ab!=20 ove and may contain information that is privileged, attorney work = product or=20 exempt from disclosure under applicable law. If you have received = this=20 message in error, or are not the named recipient(s), please = immediately=20 notify corporate MIS at (860) 766-2000 and delete this e-mail = message from=20 your computer, Thank=20 = you.********************************************************************= *2<BR></BLOCKQUOTE></DIV> <P> <HR SIZE=3D1> Do you Yahoo!?<BR><A=20 = href=3D"http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com">= The New=20 Yahoo! Search</A> - Faster. Easier. Bingo.</BLOCKQUOTE></BODY></HTML> ------_=_NextPart_001_01C34A8D.500B5C83-- ------=_NextPartTM-000-367d1588-46ab-443f-83f9-fadf9e577b43
 |
 |