RE: sys.IDL_UB1$
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 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 Dev/2000 or load up *lots* of new procedures / packages? Not surprising this happened on a development database - AFAIK this SYS owned table stores pieces of the source and is subject to *lots* of chained rows... John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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).
RE: sys.IDL_UB1$
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 ... Here is Oracle Technical note . pre Doc ID: Note:43018.1 Type: FAQ Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 30-APR-1998 Last Revision Date: 30-APR-1998 Introduction: = The Designer/2000 User Installation Guide (UIG) describes an 'optional' step to alter the storage parameters of SYS tables: IDL_UB1$ and IDL_UB2$. Occasionally, we take calls from customers who misunderstand why this step is optional and why it is mentioned in the UIG at all. Sometimes we also have to check these tables during certain installation problems, and this article is intended to give a brief overview of what these tables are used for and how you can check the current storage parameters of them. Alter Table Storage Parameters == alter table IDL_UB1$ pctfree 0 pctused 50 storage (next 500K pctincrease 0); alter table IDL_UB2$ pctfree 0 pctused 50 storage (next 500K pctincrease 0); Overview Of Tables == These alter storage statements should reduce the amount of space being used to store the Designer/2000 PL/SQL packages in the SYSTEM tablespace. However, if the users are also going to create their own PL/SQL packages and procedures on the database, then these storage values may have to be reviewed to ensure there is sufficient space for them. NOTE: these tables and their corresponding views are meant for kernel internal usage only and should NOT be queried by users! Checking Storage Values === col segment_name format a8 col sum(bytes) format 99 col sum(blocks) format col extents format col next_extent format col max_extents format col pct_increase format 999 select segment_name, sum(bytes), sum(blocks), extents, next_extent, max_extents, pct_increase from dba_segments wheresegment_name like 'IDL_UB%' group by segment_name,extents, initial_extent, next_extent, max_extents, pct_increase; Example Output == SEGMENT SUM(BYTES) SUM(BLOCKS) EXTENTS NEXT_EXTENT MAX_EXTENTS PCT_INCREASE --- -- --- --- --- --- IDL_UB1$ 105256960 51395 28 5242880 1210 IDL_UB2$ 26808320 13090 14 5242880 1210 /pre __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! * This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra 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).
Re: sys.IDL_UB1$
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 back up I decided it might be safer to post here :). Thanks in advance, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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).
Re: sys.IDL_UB1$
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=FORp_id=58586.996 http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=1021102.6p_showHeader=1p_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: [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).
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: [EMAIL PROTECTED] Bill Pribyl bill@datacraTo: 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=FORp_id=58586.996 http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=1021102.6p_showHeader=1p_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).
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 Dev/2000 or load up *lots* of new procedures / packages? Not surprising this happened on a development database - AFAIK this SYS owned table stores pieces of the source and is subject to *lots* of chained rows... John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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).