RE: Re-setting V$tables
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <mgogala@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Oct 2006 21:12:24 -0400
V$SQL - alter system flush shared_pool; ;-) (Of course, only works for
non-pinned SQL.)
V$SESSTAT/V$SYSSTAT - I don't think it's possible.
I did read, in a presentation from Anjo, I think, that it's possible to
reset stats on disk I/O...but damned if I can remember how....I'll see
if I can find it......
Found it! From Anjo's "San Stories" available as PDF on
http://www.oaktable.net/ , exec dbms_system.kcfrms will reset stats
shown in: V$FILESTAT, V$TEMPSTAT, and V$SESSION_EVENT for I/O related
events.
I think you're out of luck for V$SESSTAT/V$SYSSTAT....
Hope that helps,
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
There is nothing so useless as doing efficiently that which shouldn't be
done at all. -Peter F. Drucker, 1909-2005
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala
Sent: Tuesday, October 10, 2006 9:01 PM
To: oracle-l
Subject: Re-setting V$tables
Does anybody know how to reset s$sesstat, v$sysstat and v$sql without
restarting the database?
--
Mladen Gogala
http://www.mladen-gogala.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
