Oracle Session disconnected (ORA03114)

[paolo]

Hi everybody
whe have same program that use doa 4.0.7.1 with delphi2005
The the DB is Oracle 10G is and the client is Oracle 10GR2
The program run for several minutes and then disconnect the session with the message "Oracle Session disconnected (ORA03114)"

How we can solve our problem?
Thanks in advance
Paolo Conzon

 

[Marco Kalter]

ORA-03114 usually means that the Oracle Server process for the current session has crashed. Can you check if a user trace dump file exist on the database server that corresponds to this ORA-03114 error? Usually you will see an ORA-00600 error here, with some error codes that may help us find the cause of the problem. If it does, can you send it to me?

 

[paolo]

Hi Marco
I've seen a case of crash:
Before the program raise the error 29409 and then raise the ora-3114

I've solved by setting "optimize=false" in Toraclequery and Toracledataset

(I've readed the helen's post "Problem with ORA-24909")

Now the program seems running correctly
(I pry....

Ciao,
Paolo