View Issue Details

IDProjectCategoryView StatusLast Update
0020533mantisbtdb oraclepublic2016-02-11 16:00
Reportertrungdn Assigned Toatrol  
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionno change required 
Product Version1.3.0-rc.1 
Summary0020533: Mantis has very slow response when use oracle database
Description

Mantis has very slow response when use oracle database.

I was use Xdebug tool to debug and it show that every page loading, the db_connect function was called and take a lot of time. (pls see more details at image in attachment)

How can I resolve this issue?

Additional Information

Oracle 10g an 11g

TagsNo tags attached.
Attached Files
Oracle_connect_issue.JPG (75,172 bytes)   
Oracle_connect_issue.JPG (75,172 bytes)   

Activities

trungdn

trungdn

2016-01-20 11:03

reporter   ~0052338

This issue was resolved by use pool connect

cproensa

cproensa

2016-01-20 12:51

developer   ~0052339

This issue was resolved by use pool connect

Hello trungdn, can you explain exactly which options were changed to solve the issue?
I was about to suggest you reviewing the parameter:
$g_use_persistent_connections

atrol

atrol

2016-01-21 01:45

developer   ~0052342

I assume that trungdn is talking about Oracle Resident Connection Pooling
http://docs.oracle.com/database/121/ADMIN/manproc.htm#ADMIN12350