Long Connection Active Time Affecting Performance (Doc ID 468474.1)

Last updated on MAY 17, 2017

Applies to:

Oracle WebCenter Content - Version 7.5.1 to 10.1.3.5.0 [Release Stellent to 10gR3]
Information in this document applies to any platform.

Symptoms

The Content Server is very slow in responding.  The following information on the System Audit Information page shows that it is taking a long time to run some queries on the Oracle database.

Recent audit messages
Id: SchemaPublisher.1 csDBConnectionActiveTimeReport(342) Action executed
SELECT DISTINCT child.dDocType, child.dDescription, child.dGif FROM DocTypes child
Long execution starting at 10/11/07 11:46 AM for 342 (secs)
Long connection active time at 10/11/07 11:46 AM for 342 (secs)

Id: index update work.13 csDBConnectionActiveTimeReport(163) Action executed
UPDATE Revisions
SET dIndexerState = ' '
WHERE dIndexerState = 'A'
Long execution starting at 10/11/07 11:46 AM for 163 (secs)
Long connection active time at 10/11/07 11:46 AM for 163 (secs)

Id: index update work.17 csDBConnectionActiveTimeReport(523) Action executed
UPDATE Revisions
SET dIndexerState = ' '
WHERE dIndexerState = 'A'
Long execution starting at 10/11/07 11:38 AM for 523 (secs)
Long connection active time at 10/11/07 11:38 AM for 523 (secs)

Id: SchemaPublisher.14 csDBConnectionActiveTimeReport(522) Action executed
SELECT DISTINCT child.dDocType, child.dDescription, child.dGif FROM DocTypes child
Long execution starting at 10/11/07 11:31 AM for 522 (secs)
Long connection active time at 10/11/07 11:31 AM for 522 (secs)

Id: index update work.6 csDBConnectionActiveTimeReport(523) Action executed
UPDATE Revisions
SET dIndexerState = ' '
WHERE dIndexerState = 'A'
Long execution starting at 10/11/07 11:14 AM for 523 (secs)
Long connection active time at 10/11/07 11:14 AM for 523 (secs)

Id: SchemaPublisher.4 csDBConnectionActiveTimeReport(522) Action executed
SELECT DISTINCT child.dDocType, child.dDescription, child.dGif FROM DocTypes child
Long execution starting at 10/11/07 11:14 AM for 522 (secs)
Long connection active time at 10/11/07 11:14 AM for 522 (secs)

Id: Scheduled System Events.3 csDBConnectionActiveTimeReport(522) Action executed
SELECT DISTINCT Revisions.dRevClassID
FROM WorkflowDocuments, Revisions
WHERE WorkflowDocuments.dDocName=Revisions.dDocName
AND Revisions.dStatus<>'DELETED'
AND WorkflowDocuments.dWfDocState='INPROCESS'
Long execution starting at 10/11/07 11:10 AM for 522 (secs)
Long connection active time at 10/11/07 11:10 AM for 522 (secs)

Id: index update work.10 State: In Transaction csDBConnectionActiveTimeReport(61) Action executed
UPDATE Revisions SET dIndexerState = 'A'
WHERE dRevClassID = 310
AND (dIndexerState in (' ', 'Y') OR dIndexerState is null)
AND (dID <= 269971 OR dStatus = 'DELETED' OR dReleaseState in ('R', 'U', 'I', 'D'))
Long execution starting at 10/11/07 5:14 AM for 60 (secs)

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