SQL*net message from client severly impact the Parse call of an insert statement

2003-12-31 Thread Hatzistavrou John
Dear All, I am faced with the following situation. Oracle 8.1.7.4. 64 bit , Solaris 8 There is a loader java process that when is executed against a test database(dwdsa)the response time is as expected to be. However when it is executed against the production instance (dwods) it is

RE: SQL*net message from client severly impact the Parse call of an insert statement

2003-12-31 Thread Stephane Faroult
John, These are just a couple of ideas coming to me (I haven't checked the attachments, answering to this through a web interface). First of all, having a _whole_ process much slowed by parsing proves, if nothing else, that you are doing too much of it. If it happened very few times you

Re: SQL*net message from client severly impact the Parse call of an

2003-12-31 Thread Jared Still
Sorry, you can't send binary attachments to this list. Jared On Tue, 2003-12-30 at 23:34, Hatzistavrou John wrote: Dear All, I am faced with the following situation. Oracle 8.1.7.4. 64 bit , Solaris 8 There is a loader java process that when is executed against a test