 | | | very slow inserts on new partition. | very slow inserts on new partition. 2006-07-02 - By Alex Gorbachev
Back
Just a wild guess - check if there are nightly jobs to collect statistics.
Best thing is to trace your batch in the first day and any other day - this
way you can surely compare execution plans and where it spends it time. If
the batch is only thing running on the system than statspack reports can be
also fine.
2006/7/2, Syed Jaffar Hussain <sjaffarhussain@(protected)>:
>
> 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
>
>
>
--
Best regards,
Alex Gorbachev
http://blog.oracloid.com
Just a wild guess - check if there are nightly jobs to collect statistics.<br
>Best thing is to trace your batch in the first day and any other day - this way
you can surely compare execution plans and where it spends it time. If the
batch is only thing running on the system than statspack reports can be also
fine.
<br><br><div><span class="gmail_quote">2006/7/2, Syed Jaffar Hussain <<a
href="mailto:sjaffarhussain@(protected)">sjaffarhussain@(protected)</a>>:</span>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204)
; margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi list,<br><br>We manage our datawarehouse database on Oracle 9i Rel.2, hp
-superdome machine.<br>We have daily and monthly batch running from this
database.<br>There are about 20 tables which we used range parititon (partition
by
<br>date column). We create a new partition every month. Whenever there is<br>a
new partition created and the job takes long time than the usual<br>time, only
the first day, and the subsequent dailsy, its performs on<br>time. Is the same
case every month on the first day of using new
<br>partition.<br>Can anyone come across this type of situation?<br>Your
valuable comments/suggestion are highly appreciated.<br><br>--<br>Best Regards,
<br>Syed Jaffar Hussain<br>8i,9i & 10g OCP DBA<br>Banque Saudi Fransi,
<br>Saudi Arabia<br><br>I blog at :<a href="http://jaffardba.blogspot.com/"
>http://jaffardba.blogspot.com/</a><br><a href="http://www.oracle.com/technology
/community/oracle_ace/ace1.html#hussain">http://www.oracle.com/technology
/community/oracle_ace/ace1.html#hussain
</a><br>-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
-- ---- ---<br>"Winners don't do different things. They do things
differently."<br>--<br><a href="http://www.freelists.org/webpage/oracle-l"
>
http://www.freelists.org/webpage/oracle-l</a><br><br><br></blockquote></div><br
><br clear="all"><br>-- <br>Best regards,<br>Alex Gorbachev<br><br><a href="http
://blog.oracloid.com">http://blog.oracloid.com</a>
|
|
|