Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sql history

Re: sql history

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 5 Apr 2005 18:21:20 +0200
Message-ID: <4252bae0$0$13225$626a14ce@news.free.fr>

"Tom" <mail_at_yahoo.com> a écrit dans le message de news:d2tddt$q9j$1_at_ss405.t-com.hr...
| I'm using SQL analyzer and I have many queries in the history. I would like
| to clean it, because easier finding and manipulating running queries. How do
| I reset SQL history??
| I found view's
| v$sqlarea
| v$sqltext
| v$sql
| and analyze them (looking for targeted tables) but system tables can not be
| truncated or deleted...
| restarting database server will solve my problem (those tables will be
| reset) but our server is very live, so this option is refused...
|
| any idea??
| Thanks
|
|

This is not SQL history, this is cached SQL that is all the queries in the cache. You can't "clean" that.

Regards
Michel Cadot Received on Tue Apr 05 2005 - 11:21:20 CDT

Original text of this message

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