Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:pl/sql is INTERPRETED?

Re:pl/sql is INTERPRETED?

From: <dgoulet_at_vicr.com>
Date: Tue, 30 Apr 2002 06:08:31 -0800
Message-ID: <F001.00453364.20020430060831@fatcity.com>


Lisa,

    It is both true & false at the same time. Obviously any anonymous blocks you submit to the database are fully interpreted. PL/SQL that you store in the database as procedures, functions, and packages get partially compiled into a p-code. This makes the code ready for execution, but retains a modular design so that if your DBA reloads catproc your code is not totally destroyed. Where I think PL/SQL buys us a lot of performance is in reducing the communications outside of the database that is otherwise needed. There's no JDBC driver or other miscellaneous mess (like SQL*Net) required. It's all handled inside the kernel. Now the bad part about PL/SQL that Java handles better is platform independence. You can run Java on your client, the apps server or database without a problem. PL/SQL on the other hand must be run in the database.

Dick Goulet

____________________Reply Separator____________________
Author: "Koivu; Lisa" <lisa.koivu_at_efairfield.com>
Date:       4/29/2002 2:52 PM

Can this be true? How can this be? If it's optimized to manipulate data within the database, how can it be fast if it's interpreted (like that slow poke, Java)?

I see this on Connor's website www.oracledba.co.uk under explicit/implicit cursors, under pl/sql. What on earth?

Can someone elaborate, namely, Connor?? Please help me understand this... My "green" may be showing, but my gosh.

Lisa Koivu
Oracle Database Baby Oven
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063

--

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

Author: Koivu, Lisa
  INET: lisa.koivu_at_efairfield.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

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

Author:
  INET: dgoulet_at_vicr.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 30 2002 - 09:08:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US