Locally Managed vs Dictionary managed tablespaces

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 2 Nov 2001 09:17:17 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA72D5362@lnewton.leeds.lfs.co.uk>

Howard,

call me an idiot if you like - everybody else does, but don't you have two columns the same in that query ?
PCT_FULL and PCT_UTIL are the same. Of course, I am probably missing something glaringly obvious .....

	ROUND((SUM(TOTAL_MB)-SUM(FREE_MB))/SUM(TOTAL_MB)*100) PCT_FULL,
	ROUND((SUM(TOTAL_MB)-SUM(FREE_MB))/SUM(MAX_MB)*100) PCT_UTIL

I use the same query - since I stole it from your web site - but without the PCT_UTIL column on the end.

Regards,
Norman.

Norman Dunbar			EMail:	Norman.Dunbar_at_LFS.co.uk
Database/Unix administrator	Phone:	0113 289 6265
				Fax:	0113 289 3146
Lynx Financial Systems Ltd.	URL:	http://www.Lynx-FS.com


------------------------------------------------------------------------

Received on Fri Nov 02 2001 - 03:17:17 CST