Re: plsql_code_type native
- From: Ilmar Kerm <ilmar.kerm@xxxxxxxxx>
- To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 Sep 2012 21:17:44 +0300
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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
