General developer forum

Hello James,

First of all I would like to say sorry because my answer is not to give you a solution. The thing is that replying your thread was the unique way I had to be in touch with you.

I have migrated from moodle 1.9 to moodle 2.3 both with oracle 10g and the performance has been seriously degradated and one of the things I have decided to try is to use persisten connections to the database. Searching in forums I have read the following thread:

"https://moodle.org/mod/forum/discuss.php?d=143376"

where you says that you have configured your OCI8 to improve performance using persistent connections. If you don´t mind I would like to ask you to show me that configuration. I would appreciate it very much because I am alone in the project. The version of oci8 is 1.4.6 and it is for Oracle 11g (we have decided to install this version because we´ll update from 10g to 11g soon). The configuration I have set is:
oci8.connection_class    no value    
oci8.default_prefetch    100    
oci8.events    Off    
oci8.max_persistent    -1    
oci8.old_oci_close_semantics    
oci8.persistent_timeout    -1    
oci8.ping_interval    60    
oci8.privileged_connect    Off    
oci8.statement_cache_size        100

Thanks in advance