From oracle-l-bounce@freelists.org Thu Dec 8 12:13:27 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jB8IDRR1029183 for ; Thu, 8 Dec 2005 12:13:27 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jB8IDQAX029173 for ; Thu, 8 Dec 2005 12:13:26 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7671624ED90; Thu, 8 Dec 2005 13:13:19 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09605-06; Thu, 8 Dec 2005 13:13:19 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA87624F135; Thu, 8 Dec 2005 13:13:18 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 08 Dec 2005 13:13:18 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9B93024ED98 for ; Thu, 8 Dec 2005 13:13:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09612-04 for ; Thu, 8 Dec 2005 13:13:18 -0500 (EST) Received: from usscmail7.hds.com (usscmail7.hds.com [63.74.235.18]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3A82824F135 for ; Thu, 8 Dec 2005 13:13:18 -0500 (EST) Received: from mail.hds.com (usscmail8 [10.1.6.229]) by usscmail7.hds.com (8.11.7p1+Sun/8.11.5) with ESMTP id jB8IDHG24193; Thu, 8 Dec 2005 10:13:17 -0800 (PST) Received: from usscceb102.corp.hds.com (USSCCNETSLB08-VLAN4.hds.com [10.1.6.68]) by mail.hds.com (8.11.5-p0-rfc19719/8.11.5) with ESMTP id jB8IDHu16400; Thu, 8 Dec 2005 10:13:17 -0800 (PST) Received: from USSCCEVS101.corp.hds.com ([10.1.52.226]) by usscceb102.corp.hds.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 8 Dec 2005 10:13:17 -0800 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5FC23.0FA1D871" Subject: RE: system tablespace's extend Date: Thu, 8 Dec 2005 10:13:16 -0800 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: system tablespace's extend Thread-Index: AcX7znZFhBFb5aSOQ7mc5+MtqeYQsQAVFpiQ From: "John Kanagaraj" To: , X-OriginalArrivalTime: 08 Dec 2005 18:13:17.0194 (UTC) FILETIME=[0FF8B6A0:01C5FC23] X-archive-position: 29035 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: john.kanagaraj@hds.com Precedence: normal Reply-To: john.kanagaraj@hds.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Not scanned: please contact your Internet E-Mail Service Provider for details X-MailScanner-From: oracle-l-bounce@freelists.org ------_=_NextPart_001_01C5FC23.0FA1D871 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Yu, =20 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? =20 John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W) =20 Co-Author: Oracle Database 10g Insider Solutions http://www.samspublishing.com/title/0672327910 =20 ** 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Yu Fish Sent: Thursday, December 08, 2005 12:06 AM To: oracle-l@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.=20 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. ------_=_NextPart_001_01C5FC23.0FA1D871 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Yu,
 
This is on account of constant change to stored = procedures/packages. Is this database supporting an Oracle Apps (E = Business=20 Suite) applications or any other Stored code based ERP=20 application?
 
John Kanagaraj = <><
DB Soft=20 Inc
Phone: 408-970-7002 (W)
 
Co-Author: Oracle Database = 10g Insider=20 Solutions http://www.samspu= blishing.com/title/0672327910
 
** The opinions and facts = contained in=20 this message are entirely mine and do not reflect those of my employer = or=20 customers **


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

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

------_=_NextPart_001_01C5FC23.0FA1D871-- -- http://www.freelists.org/webpage/oracle-l