Long Connection Active Time Affecting Performance (Doc ID 468474.1)

Last updated on MAY 03, 2023

Applies to:

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

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