Recent content by gtswim

  1. G

    Returing cursor via a TOracleQuery slowness

    We have it working were we call an Oracle package and return the result set in a TOracleQuery. Only problem is it is very slow. There are about 15,000 rows to be returned. The first query (for the package itself) returns in about 30 seconds. The second query (for the cursor) takes over 1...
  2. G

    Session Pooling and RollbackOnDisconnect

    I noticed while testing that if pooling is set to spInternal and RollbackOnDisconnect is set to True that the LogOff procedure doesn't perform the rollback. If I set the pooling to spNone then LogOff does perform the rollback. That sounds backwards to me. I would think that it is imperative...
  3. G

    Oracle reboot gives error 03114

    We noticed that some applications would get Oracle error 03114 "Can not connect to Oracle" after a database server reboot. Here's what I found - let me know if any of these findings are off base. * DOA Session objects that do NOT use connection pooling are OK after a reboot. * If the DOA...
See more
Back
Top