Oracle-L: RE: SQL Query

From: Paul Baumgartel <treegarden_at_yahoo.com>
Date: Fri, 14 Nov 2003 11:19:33 -0800
Message-ID: <F001.005D6B10.20031114111933@fatcity.com>

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!

"Bellow, Bambi" <bbellow_at_chi.navtech.com> 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: treegarden_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Fri Nov 14 2003 - 13:19:33 CST