Re: Zeroising v$ views

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Thu, 01 Mar 2001 09:30:11 GMT
Message-ID: <3a9e13cd.1964019@news-server>

On Wed, 28 Feb 2001 23:47:59 -0000, "Andy Kent" <andykent.bristol.DontSpamMe_at_virgin.net> wrote:

>I want to see the effects of improvements we are making to indexing etc in
>v$sqlarea but without having to mess around comparing to old figures;
>however, it's a 24x7 system ...
>

Make your own snapshot of values at start time, then at end time, subtract the two. Kinda like what utlbstat and utlestat do. The volumes involved are piddly, it's worth it.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Thu Mar 01 2001 - 03:30:11 CST