Re: sys.IDL

From: Bill Pribyl <bill_at_datacraft.com>
Date: Mon, 14 May 2001 14:03:32 -0700
Message-ID: <F001.00303070.20010514141027@fatcity.com>

"Miller, Jay" wrote:

> Does anyone know what the SYS.IDL_UB1$ table is?
>
> It suddenly grew to app. 100Meg in my Development database.

Someone probably loaded (or generated) a ton of PL/SQL into the database.

Although I've never attempted a truncate on these tables, some Metalink sources claim that doing so might work. See
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=58586.996

http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=1021102.6&p_showHeader=1&p_showHelp=1

IDL_UB1$ is one of four tables that hold compiled PL/SQL code:

    IDL_UB1$
    IDL_CHAR$
    IDL_UB2$
    IDL_SB4$

As to what is actually inside these tables, here's a related extract from the PL/SQL docs:

"PL/SQL is based on the programming language Ada. As a result, PL/SQL uses a variant of Descriptive Intermediate Attributed Notation for Ada (DIANA), which is a tree-structured intermediate language. It is defined using a meta-notation called Interface Definition Language (IDL). DIANA provides for communication internal to compilers and other tools.

"At compile time, PL/SQL source code is translated into machine-readable m-code. Both the DIANA and m-code for a procedure or package are stored in the database. At run time, they are loaded into the shared (memory) pool. The DIANA is used to compile dependent procedures; the m-code is simply executed."

These four tables hold the DIANA and the so-code m-code. I think "m-code" is short for machine-dependent byte code but there is a sizable machine-indenpendent part as well. If you have a look at sql.bsq, you can see that Oracle documents the "type" column of these tables as follows:

> part number not null,
> /* part: 0 = diana, 1 = portable pcode, 2 = machine-dependent pcode
> */

Good luck
Bill

http://www.datacraft.com/ http://plnet.org/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pribyl
  INET: bill_at_datacraft.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 Mon May 14 2001 - 16:03:32 CDT

Re: sys.IDL_UB1$