| Diff between blocks in DBA_TABLES/DBA_SEGMENTS [message #59535] |
Tue, 02 December 2003 01:39 |
ora
Messages: 47
Registered: June 2002
|
Member |
|
|
Hi Frank,
I m sorry i couldn't sent u the output due to some reason but here it is what u want.
Well as per or discussion i want to know abt the difference between "blocks" column in dba_tables and dba_segments views.
According to me sum of blocks + sum of empty_blocks in dba_tables should be equal to sum of blocks in dba_segments but it's not u can see here :
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Dec 3 02:16:36 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
repadm@STAGING> set lines 120
repadm@STAGING> analyze table tpol compute statistics
2 /
Table analyzed.
repadm@STAGING> select sum(blocks) + sum(empty_blocks) from dba_tables where table_name='TPOL';
SUM(BLOCKS)+SUM(EMPTY_BLOCKS)
-----------------------------
96
repadm@STAGING> select sum(blocks) from dba_segments where segment_name='TPOL';
SUM(BLOCKS)
-----------
25768
repadm@STAGING>
Now can anybody tell me the diff between them.
Waiting for ur replies.
Thanx in advance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
