ORA-21779: duration not active

From: Anthony Ballo <anthony.ballo@xxxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 21 Oct 2011 10:57:35 -0700

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

Follow-Ups:

Re: ORA-21779: duration not active
From: Grzegorz Goryszewski

References:
- Re: Database link usage per object?
  - From: Karl Arao

ORA-21779: duration not active

Other related posts: