Refresh Portlet Producer Takes Very Long Time (Doc ID 1577395.1)

Last updated on AUGUST 23, 2013

Applies to:

Oracle WebCenter Portal - Version 11.1.1.6.5 and later
Information in this document applies to any platform.

Symptoms

In WebCenter Portal 11.1.1.6.5, when a registered Portlet Producer service is refreshed in the Enterprise Management (EM) console, the web browser will not response for more than 20 minutes. Meanwhile database server reports high CPU utilization.

The issue can be reproduced at will executing the following steps in sequence:
1. go to EM Console (http://....:7001/em)
2. Navigate as follows: In the tree view of left pane, click on WebCenter / Portal / Spaces / webcenter(11.1.1.4.0)
3. In the WebCenter Portal drop down menu: Click on Service Settings / Service Configurations/ Portlet Producers.
This will display a list of all the Portlet Producers registered in WebCenter Spaces.
4. Click 'Refresh' button to refresh the one of the Portlet Producers.
Note, in tihs case, the Portlet Producer that is being refreshed serves about 438 portlets

AWR reports that 3 SQLs are executed excessively.

CPU Time (s)      Executions
659.93                    1,823,632  
select MDS_PATHS.PATH_FULLNAME, MDS_PATHS.PATH_TYPE, MDS_PATHS.PATH_GUID, MDS_PATHS.PATH_DOC_ELEM_NSURI, MDS_PATHS.PATH_DOC_ELEM_NAME, MDS_PATHS.ENTERPRISE_ID from MDS_PATHS MDS_PATHS where MDS_PATHS.PATH_PARTITION_ID=:1 AND MDS_PATHS.PATH_HIGH_CN IS NULL AND MDS_PATHS.ENTERPRISE_ID=0 AND MDS_PATHS.PATH_TYPE='DOCUMENT' AND ( MDS_PATHS.PATH_FULLNAME like :2 escape '\' AND MDS_PATHS.PATH_NAME =:3 )

CPU Time (s)      Executions
534.79                    2,752,244
begin :con := MDS_INTERNAL_COMMON.VPDREADPOLICY(:sn, :on); end;

CPU Time (s)      Executions
430.67                   914,068
select MDS_PATHS.PATH_FULLNAME, MDS_PATHS.PATH_TYPE, MDS_PATHS.PATH_GUID, MDS_PATHS.PATH_DOC_ELEM_NSURI, MDS_PATHS.PATH_DOC_ELEM_NAME, MDS_PATHS.ENTERPRISE_ID from MDS_PATHS MDS_PATHS where MDS_PATHS.PATH_PARTITION_ID=:1 AND MDS_PATHS.PATH_HIGH_CN IS NULL AND MDS_PATHS.ENTERPRISE_ID=0 AND MDS_PATHS.PATH_TYPE='DOCUMENT' AND ( MDS_PATHS.PATH_FULLNAME like :2 escape '\' AND MDS_PATHS.PATH_NAME like :3 escape '\')

Similar behavior is observed in WebCenter Portal 11.1.1.7.0 but slightly different symptoms.  The AWR does not report "SQL:  MDS_INTERNAL_COMMON.VPDREADPOLICY(:sn, :on);". However, two new top SQLs reported

Elapsed Time (s) Executions  Elapsed Time per Exec (s)  %Total %CPU %IO SQL Id SQL Module SQL Text
112.64       742,203          0.00 20.17 111.21 0.00
select MDS_PATHS.PATH_FULLNAME, MDS_PATHS.PATH_TYPE, MDS_PATHS.PATH_GUID, MDS_PATHS.PATH_DOC_ELEM_NSURI, MDS_PATHS.PATH_DOC_ELEM_NAME, MDS_PATHS.ENTERPRISE_ID from MDS_PATHS MDS_PATHS where MDS_PATHS.PATH_PARTITION_ID=:1 AND MDS_PATHS.PATH_HIGH_CN IS NULL AND MDS_PATHS.ENTERPRISE_ID=0 AND MDS_PATHS.PATH_TYPE='DOCUMENT' AND (( MDS_PATHS.PATH_FULLNAME like :2 escape '\' AND MDS_PATHS.PATH_NAME =:3 ) OR ( MDS_PATHS.PATH_FULLNAME like :4 escape '\' AND MDS_PATHS.PATH_NAME =:5 ) OR ( MDS_PATHS.PATH_FULLNAME like :6 escape '\' AND MDS_PATHS.PATH_NAME =:7 ) OR ( MDS_PATHS.PATH_FULLNAME like :8 escape '\' AND MDS_PATHS.PATH_NAME =:9 ))

Elapsed Time (s) Executions  Elapsed Time per Exec (s)  %Total %CPU %IO SQL Id SQL Module SQL Text
66.28                             388,053            0.00 11.86 112.25 0.00
select MDS_PATHS.PATH_FULLNAME, MDS_PATHS.PATH_TYPE, MDS_PATHS.PATH_GUID, MDS_PATHS.PATH_DOC_ELEM_NSURI, MDS_PATHS.PATH_DOC_ELEM_NAME, MDS_PATHS.ENTERPRISE_ID from MDS_PATHS MDS_PATHS where MDS_PATHS.PATH_PARTITION_ID=:1 AND MDS_PATHS.PATH_HIGH_CN IS NULL AND MDS_PATHS.ENTERPRISE_ID=0 AND MDS_PATHS.PATH_TYPE='DOCUMENT' AND (( MDS_PATHS.PATH_FULLNAME like :2 escape '\' AND MDS_PATHS.PATH_NAME like :3 escape '\') OR ( MDS_PATHS.PATH_FULLNAME like :4 escape '\' AND MDS_PATHS.PATH_NAME like :5 escape '\') OR ( MDS_PATHS.PATH_FULLNAME like :6 escape '\' AND MDS_PATHS.PATH_NAME like :7 escape '\') OR ( MDS_PATHS.PATH_FULLNAME like :8 escape '\' AND MDS_PATHS.PATH_NAME like :9 escape '\'))

 

Changes

 None. Just refresh an already registered Portlet Producer.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms