Slow Inserts and Huge Memory Consumption On Tables With Triggers in 11g
Last updated on APRIL 06, 2015
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
Updates get progressively slower in 11g, whereas in 9i there is no problem.
The first updates go very quickly and after that the system seems to halt in 11g.
9i Win32 machine has a few Page Faults/sec, but 11g Win64 machine has many Page Faults/sec.
Virtual memory paging grows over time.
Upgraded from 9i (32 bit) to 11g (64 bit)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms