Re: sql history

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 5 Apr 2005 19:11:27 +0200
Message-ID: <4252c69f$0$702$626a14ce@news.free.fr>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message de news:rfg551tf1mvqocd20hdgug75vu94uku04d_at_4ax.com...
| On Tue, 5 Apr 2005 18:21:20 +0200, "Michel Cadot"
| <micadot{at}altern{dot}org> wrote:
|
| >
| >This is not SQL history, this is cached SQL that is all the queries in the cache.
| >You can't "clean" that.
|
| alter system flush_shared_pool?
|
|
| --
| Sybrand Bakker, Senior Oracle DBA

Yes i hesitated to add "(unless you flush the shared pool)" but i thought it was not very well advised to suggest such a solution.

Regards
Michel Cadot Received on Tue Apr 05 2005 - 12:11:27 CDT