Re: exec STATSPACK.SNAP renders ORA-03113

"Wilson Guerrero-Coltters" <[EMAIL PROTECTED]> wrote in message

> > 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
>
> It is perfectly legal, if that's what you mean.

No, I didn't mean that. I meant 'does it matter, or is this just a personal
self-education thing?"

> For what I know it is licensed, it just don't have support contract.
>
> I've been looking for more information related to this issue.
>
> I got ora-03113 when I do a select from v$latch, a core file is
> generated.
> Also have problems with v$latch_children.
>
> Appart from having to apply a patch, do you have any idea why this
> problem
> is produced? I mean, why there was  no problem until yesterday?

I honestly haven't a clue. The bug might not even be what's affecting you.
It just happened to fit what another poster wrote about. And I just had a
quick look at Metalink to see if anything was mentioned about his problems.
I'm certainly no expert. Without a support contract, you'll not be able to
discuss these sorts of issues with people that (usually) are. Unless you
strike it lucky here.

No chance of upgrading to 9.2, I suppose? It's a much better version than
9.0.1 ever was in any case...

Regards
HJR