Fragmentation [message #419918] |
Wed, 26 August 2009 03:18 |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
Any idea why this values are same even after i reorg this big table ?
SCOTT:MYDB> select table_name,round((blocks*8),2)||'kb' "size"
2 from dba_tables
3 where table_name = 'MY_LARGE_TABLE';
MY_LARGE_TABLE 1231904kb
SCOTT:MYDB> select table_name,round((num_rows*avg_row_len/1024),2)||'kb' "size"
2 from dba_tables
3 where table_name = 'MY_LARGE_TABLE';
MY_LARGE_TABLE 438496.52kb
SCOTT:MYDB> select bytes/1024 from dba_segments
2 where owner='SCOTT' and segment_name='MY_LARGE_TABLE';
2059264
[Updated on: Wed, 26 August 2009 03:26] Report message to a moderator
|
|
|
Re: Fragmentation [message #419968 is a reply to message #419918] |
Wed, 26 August 2009 05:31 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
This prove that reorganizing your table is just a waste of time.
Who say they must change?
Regards
Michel
|
|
|