ORA-21779: duration not active

ORA-21779: duration not active

出现提示：

ORA-21779: duration not active
ORA-06512: at line 1
Sun Oct 21 16:53:41 2012
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl2_smon_8872.trc:
ORA-21779: duration not active
ORA-06512: at line 1
Sun Oct 21 16:53:51 2012
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl2_smon_8872.trc:
ORA-21779: duration not active
ORA-06512: at line 1
Sun Oct 21 16:53:55 2012

 

By admin ( October 31, 2011 at 9:42 pm) · Filed underOracle Errors, drop type,Duration not active,ORA-21779

Duration is the amount of time a object is in memory. If an object in memory is accessed and its duration 
is inactive state or not found then the ORA-21779 message is returned.

Each memory chunk is associated with a duration. This allows clients to automatically free all memory 
associated with a duration (at the end of the duration). The duration determines the heap that is 
used to allocate the memory.

The allocation duration is set when an object is created with OCIObjectNew(), and the pin duration is set
when an object is pinned with OCIObjectPin(). The datatype of the duration value is OCIDuration.

When an object reaches the end of its allocation duration, it is automatically deleted and its memory can
be reused. The pin duration indicates when an object's memory can be reused, and memory is reused when 
the cache is full.

There are various predefined types of durations supported on memory and context management calls.

OCI_DURATION_CALL. The duration of this operation is that of a callout.

OCI_DURATION_STATEMENT. The duration of this operation is the external row source.

OCI_DURATION_SESSION. The duration of this operation is the user session.

OCI_DURATION_PROCESS. The duration of this is agent process.


-- Following error messages generated in alert log file.

Mon Oct 31 09:24:15 2011
Errors in file /home/oradump/DEMODB2/bdump/DEMODB2_smon_21279.trc:
ORA-21779: duration not active
ORA-06512: at line 1
Mon Oct 31 09:24:25 2011
Errors in file /home/oradump/DEMODB2/bdump/DEMODB2_smon_21279.trc:
ORA-21779: duration not active
ORA-06512: at line 1

-- Check the trace file for more details.

[oracle@demoapp2 bdump]$ more /home/oradump/DEMODB2/bdump/DEMODB2_smon_21279.trc
/home/oradump/DEMODB2/bdump/DEMODB2_smon_21279.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /home/app/oracle/product/10.2.0/db_1
System name:    Linux
Node name:      demoapp2.euro1.247realmedia.com
Release:        2.6.18-274.3.1.el5
Version:        #1 SMP Fri Aug 26 18:49:02 EDT 2011
Machine:        x86_64
Instance name: DEMODB2
Redo thread mounted by this instance: 2
Oracle process number: 22
Unix process pid: 21279, image: oracle@demoapp2.euro1.247realmedia.com (SMON)

*** 2011-10-31 08:11:08.837
*** SERVICE NAME:(SYS$BACKGROUND) 2011-10-31 08:11:08.836
*** SESSION ID:(641.1) 2011-10-31 08:11:08.836
         Drop transient type:   SYSTPr+jtbKLnBvzgQAEKD8lNoQ==
*** 2011-10-31 08:11:08.837
SMON: following errors trapped and ignored:
ORA-21779: duration not active
ORA-06512: at line 1
         Drop transient type:   SYSTPr+jtbKLnBvzgQAEKD8lNoQ==
*** 2011-10-31 08:11:09.878
SMON: following errors trapped and ignored:
ORA-21779: duration not active
ORA-06512: at line 1
         Drop transient type:   SYSTPr+jtbKLnBvzgQAEKD8lNoQ==
*** 2011-10-31 08:11:10.921

[Refer Metalink Note 'SMON: Following Errors Trapped And Ignored ORA-21779 [ID 988663.1]' for details solution]

Alternate option is to drop the transient type from the database if they are not belongs 
to SYS/SYSTEM Users.

set pagesize 65
set linesize 190
col OWNER format A12
col OBJECT_NAME format A35
col SUBOBJECT_NAME format A5
select * from dba_objects where object_name like 'SYSTP%' order by CREATED ;

SYS> drop type SCOTT."SYSTPr+jtbKPSBvzgQAEKD8lNoQ==" ;

Type dropped.

SYS>

Source:
ID 1084474.1 - What Does Error "ORA-21779: duration not active" mean? 
ID 988663.1 - SMON: Following Errors Trapped And Ignored ORA-21779 [ID 988663.1].