Check if both the environment has same indexes. Excessive Indexing does
contribute to slow inserts and updates.
-A
On Fri, Dec 1, 2017 at 6:49 AM, Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
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.
