Re:Oracle compilation

From: <dgoulet_at_vicr.com>
Date: Thu, 15 Mar 2001 13:17:16 -0800
Message-ID: <F001.002CE1EB.20010315124126@fatcity.com>

Majid,

    You've got a good part of it. The DB doesn't actually do a precompile & all that, but the idea is straight. In a nutshell Oracle:

1. checks the statement for syntax errors
2. checks to see if the objects (tables & views) exist
3. checks to see if you have access rights on the objects referenced
4. check to see if the column names are right
5. builds and evaluates the possible data access paths, it has to choose one and only one At this point we're into Pcode.
6. If you requested a 'group by' or 'order by' in the statement a temporary table will be created & the data buffered for a burst delivery OR else the data is sent record by record as they are qualified.

Dick Goulet

____________________Reply Separator____________________
Author: Majid Kazemi <Mkazemi_at_teranet.on.ca>
Date:       3/15/2001 12:02 PM

Hi guys:
I need some clarification on how Oracle complie a statement (sql or pl Sql).. I believe it first precompile then compile and finally execute. Also how Oracle will return the query result. Does it return it as a stream? Or it save it somewhere in ( example:a temp table ) before return it to client. Your help will highly be appreciated.

Thanks;
Majid Kazemi

--

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

Author: Majid Kazemi
  INET: Mkazemi_at_teranet.on.ca

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 Thu Mar 15 2001 - 15:17:16 CST