Connection Pooling for PHP based website using Oracle 11g database

database-tuningoracle-11g

I am using Oracle 11g database server and now I am getting to see that OCI's persistent connection isn't much of a use, and a new connection is created anyway when a new user accesses the page. I would like to have a pool of connections which are used, and no new connections are not created. I came across DRCP (database resident connection pooling), but I am unable to understand how to set the number of connections that can be created per server.

Questions

From the documentation available on the Oracle website, I can set the minimum and maximum number of pooled servers, but where would I be setting the number of connections??
Has anyone worked with Oracle 11g's database resident connection pooling?
If the database servers are unix boxes, can we do any ODBC connection pooling??

Best Answer

where would I be setting the number of connections?

You can specify the min and max number of connections in the pool using

SQL>execute dbms_connection_pool.configure_pool(null, minsize=>10, maxsize=>100);

If the database servers are unix boxes, can we do any ODBC connection pooling?

I'm not quite sure why you're asking this. You can take advantage of DRCP via OCI in PHP, as long as you have the Oracle 11g client. Just specify your connection string like myhost.dom.com:1521/sales:POOLED and make your connections using oci_pconnect().

Here's a few resources that may be of help:

Related Solutions

Windows – Asynch Descriptor Resize explanation

Just so there is some sort of answer to this, here is some information I have found.

On MOS there is a document called "High Numbers of 'Asynch Descriptor Resize' Wait Events Seen" (Doc ID 1273748.1) This seems to indicate that the problem is really another wait event slowing the system down and in turn causing these, so they aren't really the source wait event.

Oracle-L has a thread on the wait event, but no mention of it on Windows.

OakTable has some interesting info on the problem, and says,

...the resize apparently sucks on Linux. Perhaps that’s why other ports also suffer and have seen the same wait event.

Oracle 11G Can’t create database from template

The last two entries have unbalanced parenthesis. You're not closing the top-level parens.

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = Test)
    )
  )              -- add this
med =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = med)
    )
  )              -- add this

(Don't add the comments though.)

Might be a good idea to be consistent with casing everywhere (even though I'm not sure it actually matters). If you call your database TEST, put TEST everywhere, not Test in some places and TEST in others.

Best Answer

Related Solutions

Windows – Asynch Descriptor Resize explanation

Oracle 11G Can’t create database from template

Related Question