Performance Issue With DELETE Operations On PL/SQL TABLES And COLLECTIONS

(Doc ID 2401035.1)

Last updated on MAY 28, 2018

Applies to:

PL/SQL - Version 12.1.0.2 and later
Oracle Solaris on SPARC (64-bit)

Symptoms

Performance issue in 12c(12.1.0.2) while using DELETE operations on PLSQL types inside PLSQL package while same code working fine in 11g(11.2.0.4).
12c it's taking 4 seconds while 11g it's taking 1 seconds.
This Issue is platform specific and happening only on Solaris.

 

 

Changes

 None.

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