Re: Oracle8i mature?

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                |                            |
+-------------------------------------+----------------------------+