Re: Oracle8i mature?

Hallo Fred,

thanks for your reply.

Does this mean I have to shutdown the instance to cleanup s000's memory to be able to continue work? This is very bad as I would expect an automated recover of this process or a restart but not a "dead end" where no other shared servers get any jobs to do.

Martin

Fred Petillot wrote:
>
> Hello,
>
> 17302 may be a byproduct of having cursor_space_for_time set
> to TRUE. This is benign anyway, since processes report this O600
> while deconnecting.
>
> 17034 happens during the cleanout of an already dead session.
> There might be some previous information in the log as to how your
> s000 died.
>
> Martin Haltmayer wrote:
>
> > Hi all,
> >
> > we want to take live an Oracle8i 8.1.5 instance on Sun Solaris 2.6 for
> > Internet purposes. Just today we found one shared server s000
> > (multithreaded) eating one complete CPU but no other servers got any
> > task to do. (A few days ago we had an ORA-00600 [17034], [3837594460],
> > [0], [], [], [], [], [] regarding that shared server s000.) We had to
> > take down the instance as no other shared server got any request and we
> > were not able to do anything reasonable.
> >
> > Nearly every day (at various times) we find a few (three to four)
> > ORA-00600 [17302] messages regarding the job queue processes snp0 and
> > snp1.
> >
> > If I get this amount of ORA-00600 I am scared of unattended operation.
> > What is your experience regarding Oracle8i and continuous operation,
> > especially on Sun Solaris?
> >
> > I have the strong suspicion that 8.1.5 is neither mature nor stable.
> > Does anyone of any site that runs 8.1.5 in production?
> >
> > Any hints appreciated.
> >
> > Martin
>
> --
> +-------------------------------------+----------------------------+
> | Fred Petillot | fpetillo_at_fr.oracle.com |
> | Oracle France - Support Technique | +33 1 4762 8201 |
> | 65, rue des Trois Fontanot | +33 6 8089 5135 |
> | 92732 Nanterre Cedex | |
> +-------------------------------------+----------------------------+
Received on Thu Dec 23 1999 - 09:00:57 CST