Re: system tablespace's extend
- From: oracle-l@xxxxxxxxxxxxxxxxxx
- To: mr.fishyu@xxxxxxxxx
- Date: Thu, 8 Dec 2005 05:42:11 -0500 (EST)
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.
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
