Hi,
We are running DB 12.1.0.2.0 on solaris 5.11.
We find that 12C DB PLSQL takes more time to remove an element from an array than 11g,
Example:
FOR i IN t_array.first.. t_array.last LOOP
..
..
..
t_array.delete(i); -- delete an element
END LOOP;
It takes at least 4 seconds to complete the whole loop in 12C when processing 135880 records. In 11g, it takes less than 1 second to process the same number of records.
I wonder if anybody have this kind of issue.