Home » RDBMS Server » Server Administration » Fragmentation (
Fragmentation [message #419918] Wed, 26 August 2009 03:18 Go to next message
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';

[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 Go to previous message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This prove that reorganizing your table is just a waste of time.
Who say they must change?

Previous Topic: DBMS_STATS.GATHER_STATS fails
Next Topic: PMON failed to acquire latch, see PMON dump
Goto Forum:

Current Time: Sun Jul 23 16:05:30 CDT 2017

Total time taken to generate the page: 0.09900 seconds