My Oracle Support Banner

Long Connection Active Time Affecting Performance (Doc ID 468474.1)

Last updated on AUGUST 01, 2024

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.