Insert are very slow into a new partition

  Hi all,in our OLTP system, we have a table with more than 1 billion of rows partitioned into months for the last 10 years.

The table has a RANGE PARTITIONING on column TIMESTAMP, a LOCAL unique index on columns (TAG_ID, TIMESTAMP) and a Foreign Key for TAG_ID column.

CREATE TABLE MY_TABLE( TAG_ID  NUMBER(9)  NOT NULL, TIMESTAMP DATE NOT NULL, VALUE NUMBER, VALIDITY_FLAG  NUMBER(3), VARIANZA NUMBER(12,5) )

PARTITION BY RANGE (TIMESTAMP) (  

  PARTITION GEN_2001 VALUES LESS THAN (TO_DATE(' 2001-02-01 07:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')), 

  ...., 

  PARTITION GEN_2014 VALUES LESS THAN (TO_DATE(' 2014-02-01 07:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))