| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: sys.IDL_UB1$
I always wondered what DIANA stood for... :)
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: Diana_Duncan_at_ttpartners.com
Bill Pribyl
<bill_at_datacra To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
ft.com> cc:
Sent by: Fax to:
root_at_fatcity. Subject: Re: sys.IDL_UB1$
com
05/14/2001
06:10 PM
Please
respond to
ORACLE-L
"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
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Diana_Duncan_at_ttpartners.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:18:16 CDT
 |
 |