RE: plsql_code_type native
- From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
- To: "jbeckstrom@xxxxxxxxx" <jbeckstrom@xxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>, oracle-db-l <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 25 Sep 2012 16:04:37 +0000
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
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
