Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!newsfeed.telusplanet.net!newsfeed.telus.net!sjc70.webusenet.com!news.webusenet.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: counting remaining extents on tablespaces Date: Mon, 07 Jul 2003 19:44:29 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 31 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:237072 On 7 Jul 2003 08:50:27 -0700, amanclark@yahoo.co.uk (amani) wrote: >Hello, > >I'm a newbie and am having trouble configuring my tablespaces on an >8.1.7 database running on server 2003. They are working for now but i >would like to monitor the total amount of remaining extents per >tablespace, preferably via the Performance manager. > >Unfortunately i can't seem to find a suitable datasource in the user >defined charts and will have no real sql scripting skills for another >month. Any help would be greatly appreciated in either finding a user >defined datasource or some alternative? > >Cheers > >Amani Sorry to say so, but the output would be pretty meaningless. If you are using LMTs (which you should) just divide the amount of free space by the uniform allocation size, and you have the number of extents. If you are using DMTs (which you shouldn't) you should be aware the allocation mechanism is perfectly capable of cutting one extent into two. So again the only useful measure is the total amount of free space. Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address