Re: exec STATSPACK.SNAP renders ORA-03113

Hi,

I'm hitting the same problem here. Statspack just stopped working today. I killed after 20 minutes, all the time near 100% CPU. After several runs I gave up.
It freeze here

INSERT into stats$latch

          ( snap_id
          , dbid
          , instance_number
          , name
          , latch#
    , level#
          , gets
          , misses
          , sleeps
          , immediate_gets
          , immediate_mi

But i'm on 9i

Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production PL/SQL Release 9.0.1.0.0 - Production
CORE 9.0.1.0.0 Production
TNS for Compaq Tru64 UNIX: Version 9.0.1.0.0 - Production NLSRTL Version 9.0.1.0.0 - Production

Any suggestions welcome.

PS: We don't have access to metalink

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<3faac8a5$0$3790$afc38c87_at_news.optusnet.com.au>...
> "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 Mon Dec 01 2003 - 15:25:07 CST