Re: system tablespace's extend

Hi,

    This table is used to store PL/SQL and view source code. By chance, does your system include a process to dynamically create views or PL/SQL objects?

    A query like the following may help track down the culprit:

	SELECT *
		FROM   (SELECT   owner
	               , object_name
	               , object_id
	               , created
	        FROM     dba_objects, (SELECT DISTINCT obj#
	                               FROM            SYS.idl_ub1$)
	        WHERE    obj# = object_id
	        ORDER BY created DESC)
	WHERE  ROWNUM < 100;

Cheers,
Tim

> Hi folks:
> I am coming up with a strange problem.
> my system tablespace keep on increasing every day by 100M.
> and i query the v$dba_segments ,then i found this table: IDL_UB1$ size is
> 15031091200bytes.
> it have got 114679 extents.
> BTW,my sytem data file's size is almost the same as IDL_UB1$.
> Can some one throw some light on it,that would be appreciate.
>

--
http://www.freelists.org/webpage/oracle-l