dba_lmt_free_space
From: <admin_at_rbtron.com>
Date: Tue, 17 Mar 2009 16:01:48 -0700 (PDT)
Message-ID: <05da8722-8437-4dcf-a27d-d18b890c4e52_at_j8g2000yql.googlegroups.com>
Hi,
Date: Tue, 17 Mar 2009 16:01:48 -0700 (PDT)
Message-ID: <05da8722-8437-4dcf-a27d-d18b890c4e52_at_j8g2000yql.googlegroups.com>
Hi,
I am trying to see why there is a huge difference between these two sqls:
SQL>select sum(BLOCKS) fr from dba_lmt_free_space where file_id=8;
FR
257280
1 row selected.
QL>select sum(BLOCKS) fr from dba_free_space where file_id=8;
FR
1160448
1 row selected.
The file_id 8 is a datafile in an LMT tablespace ...
Thanx
-Ad
Received on Tue Mar 17 2009 - 18:01:48 CDT