Re: exec STATSPACK.SNAP renders ORA-03113

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:e4flqv4tqacnmv4a6rj3dbct1ll5km3cg4_at_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).

The more you say, the more it sounds like you're encountering this bug. Something to do with taking latches (you can read about it on metalink).

Want the bad news? The workaround I saw was "don't run statspack on affected systems" and "fixed in 9i (backported to 9.0.1"... which rather sounds like it *hasn't* been back-ported to 8.1.7.

Regards
HJR Received on Thu Nov 06 2003 - 16:18:06 CST