Slow Inserts and Huge Memory Consumption On Tables With Triggers in 11g (Doc ID 557459.1)

Last updated on APRIL 06, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.


Symptoms

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.

Changes

Upgraded from 9i (32 bit) to 11g (64 bit)

Cause

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