Manuel:$wgDBOracleDRCP

From mediawiki.org
This page is a translated version of the page Manual:$wgDBOracleDRCP and the translation is 12% complete.
Paramètres de la base de données: $wgDBOracleDRCP
Permet d'utiliser DRCP sur la connexion Oracle persistente s'il est à true.
Introduit dans la version :1.22.0 (Gerrit change 65279; git #I2be7120)
Retiré dans la version :1.34.0 (Gerrit change 522044; git #Iea948f7)
Valeurs autorisées :(boolean)
Valeur par défaut :false

Details

Avertissement Avertissement : This feature is currently experimental.

Set true to enable Oracle DCRP (supported from 11gR1 onward). To use this feature, set to true and use a datasource defined as POOLED (i.e. in tnsnames definition set server=pooled in connect_data block).

Starting from 11gR1 you can use DCRP (Database Resident Connection Pool) that maintains established sessions and reuses them on new connections.

Not completely tested, but it should fall back on normal connection in case the pool is full or the datasource is not configured as pooled.

And the other way around; using oci_pconnect on a non pooled datasource should produce a normal connection. When it comes to frequent shortlived DB connections like with MW Oracle tends to mess up. The problem is the driver connects to the database reasonably fast, but establishing a session takes time and resources. MW does not rely on session state (as it does not use features such as package variables) so establishing a valid session is in this case an unwanted overhead that just slows things down.

See also