Hi Ron, > -----Original Message----- > From: Reidy, Ron [mailto:[EMAIL PROTECTED] > Sent: 23 September 2004 15:16 > To: Tristan Greaves; [EMAIL PROTECTED] > Cc: Tim Bunce > Subject: RE: DBD::Oracle and ORA-600 [16365] errors > > This is a known bug with MTS. It is not anything to do with > DDB::Oracle. If you take all of the SQL statements in your > program(s) and execute them in the same manner as an on-line > app would execute them, you would most likely encounter the > same problem.
Thanks, it is nice to have some independent verification of the problem, even if Oracle are pointing the finger everywhere except at themselves! > As for not using MTS, you could most likely persuade your DBA > to give you a TNS address which makes a dedicated connection. Our application typically runs 200+ simultaneous connections to the database (via the wonders of mod_perl and the load on the web servers). Then there are various batch scripts, TOAD users etc. Basically, the database would run out of servers and fail, and there was only so far we could "up" the number of servers before we ran out of memory. And the box is pretty beefy! So, MTS was the ideal solution, apart from this crash issue :-/ Tris.
