RE: Anyone implented compiled PL/SQL?

From: Ellis R. Miller <sartre1_at_comcast.net>
Date: Wed, 28 Jul 2004 11:13:03 -0600
Message-ID: <AOEDLEKLOHPKBBLDFCLAKEGPDOAA.sartre1@comcast.net>

Good links.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Juan Carlos Reyes Pacheco
Sent: Wednesday, July 28, 2004 9:36 AM
To: oracle-l_at_freelists.org
Subject: Re: Anyone implented compiled PL/SQL?

http://www.oracle-base.com/articles/9i/PLSQLNativeCompilation9i.php http://www.dbspecialists.com/presentations/native_plsql.html  

Juan Carlos Reyes Pacheco
OCP
-------Original Message-------
 

From: oracle-l_at_freelists.org
Date: 07/28/04 10:46:08
To: oracle-l_at_freelists.org
Subject: Anyone implented compiled PL/SQL?  

Hi,
As part of our move to 9i, we're looking at various features, and I'm wondering about compiled PL/SQL. Does anyone have any experience with it? Any major issues or problems? Is there any gold at the end of the rainbow? (Does it actually provide noticeable performance improvement?)  

Thanks,  

-Mark
 

PS Oracle 9.2.0.5 (64-bit) on Solaris 8.  

--

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"On two occasions, I have been asked [by members of Parliament], "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
-- Charles Babbage (1791-1871)
   

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Jul 28 2004 - 10:56:32 CDT