Re: Simple Insert tuning

From: Ashish Lunawat <>
Date: Fri, 1 Dec 2017 07:42:52 +0800
Message-ID: <>

Check if both the environment has same indexes. Excessive Indexing does contribute to slow inserts and updates.


On Fri, Dec 1, 2017 at 6:49 AM, Norman Dunbar <> wrote:

> Evening Sanjay,
> I recently had a similar problem to work out for a friend who is a
> developer but doesn't/didn't have a dba to consult. His problem was an
> insert taking 2048 (spooky number) seconds to insert the first row, all the
> following rows were almost instant.
> A 10046, level 12 trace showed the problem was related to dynamic stats
> being gathered prior to the first EXEC of the insert. The stats were being
> gathered on various SYS objects. It appeared that the sys schema and
> dictionary stats were never gathered on his database. After gathering
> (both) the insert problem vanished.
> I fully agree with the other poster (sorry, forgot your name) who
> suggested tracing as the way to find out. It will show you exactly where
> Oracle spent its time.
> Good luck.
> Cheers,
> Norm.
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.

Received on Fri Dec 01 2017 - 00:42:52 CET

Original text of this message