1 Reply Latest reply: Jul 30, 2012 12:19 AM by 742910 RSS

    Oracle DB OCI

    742910
      which OCI call consume time in DB--OCIStmtFetch, OCIStmtExecute?
      In our oralce DB, when I call a big SQL,OCIStmtExecute returned immediately, while OCIStmtFetch return after a long time.
      Is it behave correct? In MS SQL, executing Query needs much time.

      Thanks
      Phoebe
        • 1. Re: Oracle DB OCI
          742910
          Hi Experts,

          When running OCI in non-blocing mode,
          OCIStmtFetch consume a lot of time, while OCIStmtExecute does not.

          While in blocking mode,
          OCIStmtExecute consume a lot of time, while OCIStmtFetch does not.

          Is this opposite behavior correct in these two running mode?

          Thanks
          Phoebe