From oracle-l-bounce@freelists.org Sat Jan 8 04:13:08 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j08AD8f24086 for ; Sat, 8 Jan 2005 04:13:08 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j08AD8n24081 for ; Sat, 8 Jan 2005 04:13:08 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C3A5772C4CF; Sat, 8 Jan 2005 05:19:42 -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 21547-06; Sat, 8 Jan 2005 05:19:42 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5F27C72C08E; Sat, 8 Jan 2005 05:19:38 -0500 (EST) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Subject: RE: Used size of a datafile. Date: Sat, 8 Jan 2005 13:24:16 +0300 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Used size of a datafile. Thread-Index: AcT1a+x3awgImytpRIKywldFuhkApgAADscQ From: "Vinod Gopinath BMMI IS" To: "Jesper Haure Norrevang" Cc: X-archive-position: 14490 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: vinodg@BMMI.com.bh Precedence: normal Reply-To: vinodg@BMMI.com.bh X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Thanks Jesper. Vinod. -----Original Message----- From: Jesper Haure Norrevang [mailto:jhn.aida@cbs.dk]=20 Sent: Saturday, January 08, 2005 1:16 PM To: Vinod Gopinath BMMI IS Cc: oracle-l@freelists.org Subject: Re: Used size of a datafile. Vinod, select f.tablespace_name, f.file_name, sum(e.bytes) / 1024 / 1024 MB from dba_extents e, dba_data_files f where e.file_id =3D f.file_id group by f.tablespace_name, f.file_name order by f.tablespace_name, f.file_name; Regards Jesper Haure Norrevang ----- Original Message ----- From: Vinod Gopinath BMMI IS Date: Saturday, January 8, 2005 9:12 am Subject: Used size of a datafile. > Content-Type: text/plain; > charset=3D"us-ascii" > Content-Transfer-Encoding: quoted-printable > Group, > I have this query > <<<<=3D20 > select distinct substr(a.TABLESPACE_NAME,1,10) "T N", > substr(a.FILE_NAME,1,40) "F N", > sum(a.bytes/1024/1024) "Size (M)" > from dba_data_files a > group by a.TABLESPACE_NAME, a.FILE_NAME > order by 1,2 > >>>> > Gives me proper result, but I want to see how much of the space is > usedby each datafile. Which table should I refere for this query. > I know this has been asked many a times, but one more time. > TIA=3D20 > Vinod. >=20 >=20 >=20 >=20 > -- > http://www.freelists.org/webpage/oracle-l >=20 -- http://www.freelists.org/webpage/oracle-l