Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> very slow inserts on new partition.

very slow inserts on new partition.

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Sun, 2 Jul 2006 11:52:27 +0300
Message-ID: <97b7fd2f0607020152r3624903bq9d773d2025113791@mail.gmail.com>


Hi list,

We manage our datawarehouse database on Oracle 9i Rel.2, hp-superdome machine. We have daily and monthly batch running from this database. There are about 20 tables which we used range parititon (partition by date column). We create a new partition every month. Whenever there is a new partition created and the job takes long time than the usual time, only the first day, and the subsequent dailsy, its performs on time. Is the same case every month on the first day of using new partition.
Can anyone come across this type of situation? Your valuable comments/suggestion are highly appreciated.

-- 
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g OCP DBA
Banque Saudi Fransi,
Saudi Arabia

I blog at :http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jul 02 2006 - 03:52:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US