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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re-setting V$tables

Re: Re-setting V$tables

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Wed, 11 Oct 2006 09:43:10 +0200
Message-ID: <486b2b610610110043t6c85e076o479a2425d02bffa5@mail.gmail.com>


And actually, as your application happily uses dbms_application_info - why not create your own wrapper around it that the app can call, that turns sql trace on and off for the modules you're interested in ?

Stefan

On 10/11/06, Mladen Gogala <mgogala_at_verizon.net> wrote:
>
> Does anybody know how to reset s$sesstat, v$sysstat and v$sql without
> restarting
> the database?
>
> --
> Mladen Gogala
> http://www.mladen-gogala.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 11 2006 - 02:43:10 CDT

Original text of this message

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