ORA-21779: duration not active

From: Anthony Ballo <anthony.ballo_at_onecall.com>
Date: Fri, 21 Oct 2011 10:57:35 -0700
Message-ID: <CAC6FEDC.1049C%anthony.ballo_at_onecall.com>

Does anyone have any clues on what causes these Alert Log errors?

Errors in file /u05/prod/bdump/prod2_smon_31452.trc: ORA-21779: duration not active
Errors in file /u05/prod/bdump/prod2_smon_31452.trc: ORA-21779: duration not active
Errors in file /u05/prod/bdump/prod2_smon_31452.trc: ORA-21779: duration not active
Errors in file /u05/prod/bdump/prod2_smon_31452.trc: ORA-21779: duration not active
Errors in file /u05/prod/bdump/prod2_smon_31452.trc: ORA-21779: duration not active
Errors in file /u05/prod/bdump/prod2_smon_31452.trc: ORA-21779: duration not active
Errors in file /u05/prod/bdump/prod2_smon_31452.trc: ORA-21779: duration not active
Errors in file /u05/prod/bdump/prod2_smon_31452.trc: ORA-21779: duration not active

From what I was able to gather online, the root cause of the problem is SMON that is not clearing up some transient types:

SELECT *
 FROM dba_types
 WHERE type_name LIKE 'SYS%=='

      AND length(type_name) = 29

But I don't understand why?

We have found that flushing the Shared Pool stops the error. It happens on occasion - about once a month it seems.

We are on: OEL, 10.2.0.4 in a 2-node RAC environment. These errors appeared on node 2.

Any other insight would be most helpful - thanks.

Anthony

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 21 2011 - 12:57:35 CDT