How to use Oracle Connection pooling using PHP?

Question

I am using PHP with Oracle Database 12c and i want to implement connection pooling for improve my application performance Can you help me please ?

well, i tried this example workwiththebest.intraway.com/blog-post/…, but it's showing TNS error only when i put this :POOLED string after service name — Jafor Iqbal
– Jafor Iqbal, Commented May 21, 2020 at 10:16

Christopher Jones · Accepted Answer · 2020-05-22 11:47:45Z

1

Check the Database Resident Connection Pooling (DRCP) chapter of Oracle's free The Underground PHP and Oracle Manual.

First determine if you need DRCP. I assume you are already using persistent oci_pconnect() calls, which is the first thing to do to improve connection performance.

Like any pool, DRCP is a shared resource so there is some overhead and you need to make sure that connections are not held open which would block other users. If you're not running out of memory on the DB server host, I would suggest not using it.

If you decide to try it, the basic steps are:

start the pool, something like

SQL> execute dbms_connection_pool.start_pool()

update your php.ini and set a connection class:
```
oci8.connection_class = MYPHPAPP
```

Use a pooled connect string like

$c = oci_pconnect('myuser', 'mypassword', 'myhost/sales:POOLED');

or

$c = oci_pconnect('myuser', 'mypassword', 'salespool');

where the connect alias is in a tnsnames.ora file:

salespool=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=myhost.dom.com)
  (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales)
(SERVER=POOLED)))

edited May 22, 2020 at 11:47

answered May 21, 2020 at 22:56

Christopher Jones

11.1k7 gold badges32 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jafor Iqbal Over a year ago

currently, I am using "oci_connect", So if oci_pconnect is better than oci_connect than should I change it to oci_pcoonect first instead of connection pooling technique?

Jafor Iqbal Over a year ago

Just letting you know my DB server configuration is very good enough.

Christopher Jones Over a year ago

Yes, use oci_pconnect() first. Make sure that your number of mid-tier PHP processes is as small as possible (don't oversize the number), since each will now keep a DB connection open. Each of these will take some memory on the DB host.

Collectives™ on Stack Overflow

How to use Oracle Connection pooling using PHP?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related