SV: plsql_code_type native
Date: Wed, 26 Sep 2012 07:00:36 +0000
Message-ID: <3967181ED595B445B1E39718204FD4BD13C3D2DE_at_SRVEXC5.dst.local>
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_at_freelists.org [mailto:oracle-l-bounce_at_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-lReceived on Wed Sep 26 2012 - 02:00:36 CDT