Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql history
"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
![]() |
![]() |