Hello,
Could you be se kind please and provide me with information what can be the reason for high amount of open cursors (v$open_cursors) + locks (v$db_object_cache) on these objects (table_1_FF_XXX)?
I am trying to create any test case but without success .
I realized that these cursors table_1_FF_XXX are connected to Data Dictionary tables KOT% and with TYPES
when I create TYPE the table arre used
CREATE TYPE A1.t_person_2 AS OBJECT ( name VARCHAR2(30), phone VARCHAR2(20) );
/
CREATE TABLE A1.contacts_2 ( contact A1.t_person_2, datum DATE );
3hv9tn9q98773 update "SYS"."KOTTD$" set SYS_NC_ROWINFO$ = :1 where SYS_NC_OID$ = :2
6ahyp2bd6hut3 insert into "SYS"."KOTTB$" (SYS_NC_OID$, SYS_NC_ROWINFO$) values(:1, :2 )
3k7qn6f8bcv09 insert into "SYS"."KOTAD$" (SYS_NC_OID$, SYS_NC_ROWINFO$) values(:1, :2 )
f4622x14j0w9g insert into "SYS"."KOTTD$" (SYS_NC_OID$, SYS_NC_ROWINFO$) values(:1, :2 )
16xta4pr8x3jk update "SYS"."KOTTB$" set SYS_NC_ROWINFO$ = :1 where SYS_NC_OID$ = :2
6ym173018pdft insert into "SYS"."KOTTBX$" (SYS_NC_OID$, SYS_NC_ROWINFO$) values(:1, :2 )
8svdabcrnq5mt update "SYS"."KOTTBX$" set SYS_NC_ROWINFO$ = :1 where SYS_NC_OID$ = :2
select to_number( '308', 'xxxx' ) from dual; 776
select to_number( '310', 'xxxx' ) from dual; 784
select to_number( '30c', 'xxxx' ) from dual; 780
select to_number( '300', 'xxxx' ) from dual; 768
select to_number( '304', 'xxxx' ) from dual; 772
select owner,object_name, object_type from dba_objects where object_id = 776; KOTAD$
select owner,object_name, object_type from dba_objects where object_id = 784; KOTTBX$
select owner,object_name, object_type from dba_objects where object_id = 780; KOTMD$
select owner,object_name, object_type from dba_objects where object_id = 768; KOTTD$
select owner,object_name, object_type from dba_objects where object_id = 772; KOTTB$
Thank you
Jan
