RE: system tablespace's extend

Yu,  

This is on account of constant change to stored procedures/packages. Is this database supporting an Oracle Apps (E Business Suite) applications or any other Stored code based ERP application?  

John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)  

Co-Author: Oracle Database 10g Insider Solutions http://www.samspublishing.com/title/0672327910  

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

  ---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yu Fish Sent: Thursday, December 08, 2005 12:06 AM To: oracle-l_at_freelists.org
Subject: system tablespace's extend

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