TOracleEvent

[Jonas Malmsten]

When using TOracleEvent to handle alert messages everything seems to go very slow.

I use Delphi 5, DOA 3.4 and Oracle 8.0.6. When initialising my app I call

OracleEvent.Start.

After this each query I issue (even simple select queries that don't trigger anything that sends alert messages) takes about 50 times as long to run as compared to the exact same program code but without calling OracleEvent.Start.

Apart from that everything is slow the oracle event if functioning and handling event properly and everything.

I don't have any connection problems as discussed in previous messages. Connecting to the server is fast.

Our server is some big unix box that I've never seen, but I can guarantee that it is not server performance that causes this problem

.

 

[Marco Kalter]

I think you, your DBA, or your UNIX system administrator should check what is going on on the server when the TOracleEvent is started. Maybe there is some problem with the dbms_alert or dbms_pipe package. I don't really have an explanation.

------------------
Marco Kalter
Allround Automations