RE: plsql_code_type native
From: Walker, Jed S <Jed_Walker_at_cable.comcast.com>
Date: Tue, 25 Sep 2012 16:04:37 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C6F4A75F1_at_COPDCEXMB08.cable.comcast.com>
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.
Date: Tue, 25 Sep 2012 16:04:37 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C6F4A75F1_at_COPDCEXMB08.cable.comcast.com>
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
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 Tue Sep 25 2012 - 11:04:37 CDT