Re: plsql_code_type native

From: Ilmar Kerm <ilmar.kerm_at_gmail.com>
Date: Tue, 25 Sep 2012 21:17:44 +0300
Message-ID: <CAKnHwtfdcYW45tBP6qVZO+=Wj1Rh_91rDWbfwThNKkV72KxTHQ_at_mail.gmail.com>

One issue I've seen is:
Bug 10269503 : ALTER PACKAGE COMPILE IN NATIVE COMPILATION RAISES ORA-600

Described in:
DataPump Import (IMPDP) Fails With Error ORA-600 [ktcdso-1] [ID 1441524.1] Natively compiling a package that refers to objects across a database link to a lower version causes ORA-600 [ktcdso-1] / ORA-600 [17285].

Ilmar

On Tue, Sep 25, 2012 at 7:04 PM, Walker, Jed S <Jed_Walker_at_cable.comcast.com> wrote:
> We set it to assist with performance, though I don't recall if we had an performance testing or results. We did run into a big issue (I believe it was introduced in 11.2.0.2) where it no longer cleaned up /dev/shm thus causing outages.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom
> Sent: Tuesday, September 25, 2012 9:16 AM
> To: oracle-l-freelists; oracle-db-l
> Subject: plsql_code_type native
>
> For those of you that have set plsql_code_type to native, I have a few questions:
> - Why did you set the parameter
> - Was there a noticeable change in performance
> - Did you have any issues as a result of the change

-- 
Ilmar Kerm
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 25 2012 - 13:17:44 CDT