Re: exec STATSPACK.SNAP renders ORA-03113

"Wilson Guerrero-Coltters" <wcoltters_at_yahoo.com> wrote in message news:ff6f1d30.0312011325.3c4906f2_at_posting.google.com...
> 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

Well, you're on the initial release of Oracle 9i Release 1, and although the bug-fix has been back-ported to 9.0.1 (according to Metalink, anyway), that certainly will require the application of a patch before you get the benefit. From memory, I believe they're up to 9.0.1.0.4.

> Any suggestions welcome.
>
> PS: We don't have access to metalink

Er, well, then you're stuffed. Because patches can only be gotten from Metalink as far as I know. Presumably this isn't a licensed system, then?

Regards
HJR Received on Mon Dec 01 2003 - 15:56:44 CST