Odder still, I get inconsistent results. megs_allocated is always
wrong, but megs_used is right when run against one tablespace, wrong
against another:
TABLESPACE_NAME MEGS_ALLOCATED MEGS_USED PCT
------------------------------ -------------- ---------- ----------
MEDIUM_DATA 361713 3616 1
Wrong!
select sum(bytes)/1048576 from dba_extents where tablespace_name =
'MEDIUM_DATA'
SUM(BYTES)/1048576
------------------
1808
TABLESPACE_NAME MEGS_ALLOCATED MEGS_USED PCT
------------------------------ -------------- ---------- ----------
SMALL_DATA 2783232 169.875 .01
Right!
1* select sum(bytes)/1048576 from dba_extents where tablespace_name =
'SMALL_DATA'
SQL> /
SUM(BYTES)/1048576
------------------
169.875
As for why the ALLOCATED value is wrong...I don't know, but at least
it's wrong consistently!
PB
--- "Bellow, Bambi" <[EMAIL PROTECTED]> wrote:
[snip]
>
> Also, note that both the allocated *and* used values are wrong...they
> should
> be
>
>
> TABLESPACE_NAME MEGS_ALLOCATED MEGS_USED PCT
> ------------------------------ -------------- ---------- ----------
> NAUAT 22924.25 11509 50
>
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
