Thanks to everyone who replied!
-Original Message-
Sent: Monday, May 14, 2001 6:31 PM
To: Multiple recipients of list ORACLE-L
Hi Jay,
Does anyone know what the SYS.IDL_UB1$ table is?
It suddenly grew to app. 100Meg in my Development database. I tried
searching on it on Ixora
Does anyone know what the SYS.IDL_UB1$ table is?
It suddenly grew to app. 100Meg in my Development database. I tried
searching on it on Ixora on Friday but as soon as I did my computer crashed.
Now that I'm back up I decided it might be safer to post here :).
Thanks in advance,
Jay Miller
Jay,
I think these tables deal with p-code chunks for pl/sql objects ... do you
have lots of server side code?
It is possible that you can truncate these tables, but then you'll have to
recompile ALL (including SYS/SYSTEM) owned packages and user packages. Not
recommended without help from OWS
I believe that table holds the PL/SQL source code.
[EMAIL PROTECTED] 05/14/01 03:30PM
Does anyone know what the SYS.IDL_UB1$ table is?
It suddenly grew to app. 100Meg in my Development database. I tried
searching on it on Ixora on Friday but as soon as I did my computer crashed.
Now that I'm
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
:
Sent by: Fax to:
root@fatcity.Subject: Re: sys.IDL_UB1
Hi Jay,
Does anyone know what the SYS.IDL_UB1$ table is?
It suddenly grew to app. 100Meg in my Development database. I tried
searching on it on Ixora on Friday but as soon as I did my
computer crashed.
Now that I'm back up I decided it might be safer to post here :).
Did you recently install