bug - 10.2 faster than 11.2+ for pl/sql block execution

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 11 Jun 2013 06:32:05 -0700

A rather interesting bug appeared in the 'Oracle Support HOT Topics' today.
Bug 16913821 : PLSQL BLOCK EXECUTION SIGNIFICANTLY SLOWER ON 11.2 THAN ON
10.2

Complete with test case.

If an app moves from 10.2 to 11.2 database, this is a another
facet for consideration if the app appears slow in testing.


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com


--
//www.freelists.org/webpage/oracle-l


Other related posts: