| 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: faq broke? -- Other options
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_01C34FB7.6334CCC0
Content-Type: text/plain
There was an astTom article in the latest issue of Oracle magazine that went over how to do this (I don't think it was specific to 9i) and then went on to explain why you WOULDN"T want to do this.
-----Original Message-----
From: Hallas, John, Tech Dev [mailto:John.Hallas_at_gb.vodafone.co.uk]
Sent: Monday, July 21, 2003 10:54 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: faq broke? -- Other options
Good point Rich.
I am sure I saw a post recently from Cary Millsap which shows how you could
flush the buffers out with an alter system command (9i only) - to save
restarting the database when running performance trials
I have searched for it everywhere to no avail
So if anybody recalls what it was please let me know (I assume it is
undocumented as I cannot find anything in the manual)
Thnaks
John
-----Original Message-----
Sent: 21 July 2003 15:45
To: Multiple recipients of list ORACLE-L
Hey Bruce,
Any possibility of making the bodies of the FatCity archived messages searchable, instead of just the subject? That's the only reason why I even bother with the orafaq search.
Thanks,
Rich
Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
> -----Original Message-----
> From: Bruce A. Bergman [mailto:bruceb_at_fatcity.com]
> Sent: Saturday, July 19, 2003 2:49 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: faq broke? -- Other options
>
>
> Don't think that the only searchable archives are on orafaq.
> Fat City has the definitive archives that date back to the
> start of the list here. You should consider using the
> archives here as well.
>
> You can find them here: http://www.listguru.com
>
> thanks,
> bruce
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.com Fat City Network Services -- 858-538-5051 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 -- Author: Hallas, John, Tech Dev INET: John.Hallas_at_gb.vodafone.co.uk Fat City Network Services -- 858-538-5051 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). ------_=_NextPart_001_01C34FB7.6334CCC0 Content-Type: text/html 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=3Dus-ascii"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: faq broke? -- Other options</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>There was an astTom article in the latest issue of = Oracle magazine that went over how to do this (I don't think it was = specific to 9i) and then went on to explain why you WOULDN"T want = to do this.</FONT></P> <BR> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Hallas, John, Tech Dev [<A = HREF=3D"mailto:John.Hallas_at_gb.vodafone.co.uk">mailto:John.Hallas_at_gb.voda= fone.co.uk</A>] </FONT> <BR><FONT SIZE=3D2>Sent: Monday, July 21, 2003 10:54 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: faq broke? -- Other options</FONT> </P> <P><FONT SIZE=3D2>Good point Rich.</FONT> <BR><FONT SIZE=3D2>I am sure I saw a post recently from Cary Millsap = which shows how you could flush the buffers out with an alter system = command (9i only) - to save restarting the database when running = performance trials</FONT></P> <P><FONT SIZE=3D2>I have searched for it everywhere to no avail</FONT> <BR><FONT SIZE=3D2>So if anybody recalls what it was please let me know = (I assume it is undocumented as I cannot find anything in the = manual)</FONT></P> <P><FONT SIZE=3D2>Thnaks</FONT> </P> <P><FONT SIZE=3D2>John</FONT> <BR><FONT SIZE=3D2> </FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>Sent: 21 July 2003 15:45</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <P><FONT SIZE=3D2>Hey Bruce,</FONT> </P> <P><FONT SIZE=3D2>Any possibility of making the bodies of the FatCity = archived messages</FONT> <BR><FONT SIZE=3D2>searchable, instead of just the subject? = That's the only reason why I even</FONT> <BR><FONT SIZE=3D2>bother with the orafaq search.</FONT> </P> <P><FONT SIZE=3D2>Thanks,</FONT> <BR><FONT SIZE=3D2>Rich</FONT> </P> <P><FONT SIZE=3D2>Rich = Jesse &= nbsp; &= nbsp; System/Database Administrator</FONT> <BR><FONT = SIZE=3D2>rjesse_at_qtiworld.com &n= bsp; Quad/Tech = Inc, Sussex, WI USA</FONT> </P> <BR> <P><FONT SIZE=3D2>> -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> From: Bruce A. Bergman [<A = HREF=3D"mailto:bruceb_at_fatcity.com">mailto:bruceb_at_fatcity.com</A>]</FONT>= <BR><FONT SIZE=3D2>> Sent: Saturday, July 19, 2003 2:49 PM</FONT> <BR><FONT SIZE=3D2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>> Subject: Re: faq broke? -- Other options</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Don't think that the only searchable archives = are on orafaq. </FONT> <BR><FONT SIZE=3D2>> Fat City has the definitive archives that date = back to the </FONT> <BR><FONT SIZE=3D2>> start of the list here. You should = consider using the </FONT> <BR><FONT SIZE=3D2>> archives here as well.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> You can find them here: <A = HREF=3D"http://www.listguru.com" = TARGET=3D"_blank">http://www.listguru.com</A></FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> thanks,</FONT> <BR><FONT SIZE=3D2>> bruce</FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.net" = TARGET=3D"_blank">http://www.orafaq.net</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Jesse, Rich</FONT> <BR><FONT SIZE=3D2> INET: Rich.Jesse_at_qtiworld.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- = 858-538-5051 <A HREF=3D"http://www.fatcity.com" = TARGET=3D"_blank">http://www.fatcity.com</A></FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Mailing list = and web hosting services</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= ------</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information = (like subscribing).</FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.net" = TARGET=3D"_blank">http://www.orafaq.net</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Hallas, John, Tech Dev</FONT> <BR><FONT SIZE=3D2> INET: John.Hallas_at_gb.vodafone.co.uk</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- = 858-538-5051 <A HREF=3D"http://www.fatcity.com" = TARGET=3D"_blank">http://www.fatcity.com</A></FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Mailing list = and web hosting services</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= ------</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Mon Jul 21 2003 - 13:39:15 CDT
 |
 |