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: [EMAIL PROTECTED]
Bill Pribyl
<bill@datacra To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
ft.com> cc:
Sent by: Fax to:
root@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
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:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
