Access Violations with Oracle 10g. - 06/15/07 04:38 AM
Some of the applications I maintain have started getting random Access Violations since we migrated the Oracle database over to 10g (from 8i). The AVs only seem to occur when the application is either writing to or reading from the Oracle database.
The errors don't happen consistently, but they do sometimes occur more frequently than other times. I'm not certain but I suspect it may be an issue with the load on the Oracle server. Sometimes one application gets a streaming error when it tries to stream data from the database. And there was a case last week where the applications stopped responding altogether. It turned out that the DBAs were running a system job on the server that was chewing up all of the resources.
So my question is, if the application is trying to access the database and the server doesn't respond, is this likely to cause AVs? Could AVs occur if the connection is lost? Does DOA try to automatically reconnect if a connection is lost, or is there something I need to do to reconnect?
I'm just trying to determine if the problem is with my apps or if it's at the server end.
Delphi 7, DOA 4.0.7.1.
Thanks.
Regards,
Steve
The errors don't happen consistently, but they do sometimes occur more frequently than other times. I'm not certain but I suspect it may be an issue with the load on the Oracle server. Sometimes one application gets a streaming error when it tries to stream data from the database. And there was a case last week where the applications stopped responding altogether. It turned out that the DBAs were running a system job on the server that was chewing up all of the resources.
So my question is, if the application is trying to access the database and the server doesn't respond, is this likely to cause AVs? Could AVs occur if the connection is lost? Does DOA try to automatically reconnect if a connection is lost, or is there something I need to do to reconnect?
I'm just trying to determine if the problem is with my apps or if it's at the server end.
Delphi 7, DOA 4.0.7.1.
Thanks.
Regards,
Steve