Native Compiled Files For PL/SQL on 11.2.0.3 are Significantly Larger Than 10g or 11.2.0.2 (Doc ID 1490982.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 11.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 30-Apr-2014***

Symptoms

When using Native Compilation for PL/SQL objects there is a significant difference in file sizes on 11.2.0.3 when compared to 10g or even 11.2.0.2.

With 11.2.0.3, the file sizes produce could be 10 times the size of previous versions. This can cause Database outages due swap space.

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