From: Niels Jespersen <NJN@dst.dk>
To: "'JBECKSTROM@gcrta.org'" <JBECKSTROM@gcrta.org>, oracle-l-freelists
 <oracle-l@freelists.org>
Subject: SV: plsql_code_type native
Thread-Topic: plsql_code_type native
Date: Wed, 26 Sep 2012 07:00:36 +0000
Message-ID: <3967181ED595B445B1E39718204FD4BD13C3D2DE@SRVEXC5.dst.local>
References: <506192850200000B004F2C66@groupwise.gcrta.org>
In-Reply-To: <506192850200000B004F2C66@groupwise.gcrta.org>
Accept-Language: da-DK, en-US
Content-Language: da-DK
Content-type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: NJN@dst.dk

We did, when we migrated from 10.2.0.5 on HP-UX to 11.2.0.2 on Win2008r2 x64. We also compiled all sys-objects natively. 

The goal was to improve cpu-performance a bit without spending any real effort. 
Performance does improve on cpu-intensive tasks, but not noticeably. 
Issues, we have had a few ORA-0600 involving execution across databaselinks where caller/callee have different plsql_code_type.

Would we make the same choice today, probably not, I do not think it is worth the effort with the plentiful cpu-power you get from modern hardware today.

regards
Niels Jespersen


-----Oprindelig meddelelse-----
Fra: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] På vegne af Jeffrey Beckstrom
Sendt: 25. september 2012 17:16
Til: oracle-l-freelists; oracle-db-l
Emne: 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


Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113


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


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