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:[EMAIL PROTECTED]]
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
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
> -----Original Message-----
> From: Bruce A. Bergman [mailto:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).