Anyone implented compiled PL/SQL?

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 28 Jul 2004 10:47:49 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09660C5A@bosmail00.bos.il.pqe>

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

---

Received on Wed Jul 28 2004 - 09:44:51 CDT