Re: exec STATSPACK.SNAP renders ORA-03113

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Thu, 06 Nov 2003 23:10:04 +0100
Message-ID: <e4flqv4tqacnmv4a6rj3dbct1ll5km3cg4@4ax.com>

"Howard J. Rogers" <hjr_at_dizwell.com> wrote:

>Well, alright then. How about bug 1834952??

I will go after it right now.

I found out the space is definitely not the problem. When I tried "exec statspack.snap" again today, the session got hung during an insert into stats$sysstat from a system view (something like X_$KU????? (don't remember, I am not at office now).

I am so angry not to be able to use statspack here. I need to measure the effect of my tuning actions. For example, today I changed a kernel parameter (on the fly) which usually has a default value that effectively throttles I/O (ufs_HW), but I have no proof that anything runs faster now.

>Don't know if it's back-ported to 8.1.7.4, but it might be.

The bug or the solution? :-)

Thanks
Rick Denoire Received on Thu Nov 06 2003 - 16:10:04 CST