Cursor lifetime.

[sveinn]

Delphi 5
DOA 3.4.4

To simplify tings let

 

[Marco Kalter]

Oracle Net does not immediately free cursors on the Server when it is closed on the Client. When a new cursor is opened within the same session, the old cursor will be closed. This saves network roundtrips for "close cursor" operations.

In other words, the cursor count on the server can lag the cursor count on the client for optimization purposes.

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