3 Replies Latest reply: Sep 15, 2011 4:10 PM by cj RSS

    Speed up oci8 connections

    884377
      Is there a way of speeding up oci8 connections?
        • 1. Re: Speed up oci8 connections
          cj
          From what baseline configuration?
          Check the tips in http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html
          If you aren't using persistent connections, use them. If DB host server memory is an issue, use DRCP: http://www.oracle.com/technetwork/topics/php/whatsnew/php-scalability-ha-twp-128842.pdf
          • 2. Re: Speed up oci8 connections
            884377
            Thanks for that post. DRCP looks like it would help unfortunately my DEV environment is on 10g so I can't test at the moment. The production instance is 11g so when I move to that environment I will test and report back the results so others can benefit.
            • 3. Re: Speed up oci8 connections
              cj
              If it helps, the free Oracle XE 11gR2 edition is available. It supports DRCP.
              See http://blogs.oracle.com/opal/entry/oracle_11_2_xe_with