Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |