| 2 tables same rowcount different size [message #243635] |
Fri, 08 June 2007 02:43  |
Duke
Messages: 14
Registered: August 2006
|
Junior Member |
|
|
Hi there,
Hope you guys can help me out?
I have got 2 tables in 2 environments (production, acceptance)
They do not differ in row count or table structure, but they do differ in size.
In other words: 2 tables are identical however the size on disk is different. How do I optimize the tables?
Block size for both environment is 16k.
Thanks so much!
|
|
|
|
|
|
| Re: 2 tables same rowcount different size [message #243641 is a reply to message #243637] |
Fri, 08 June 2007 03:14  |
Duke
Messages: 14
Registered: August 2006
|
Junior Member |
|
|
| Michel Cadot wrote on Fri, 08 June 2007 02:56 | Define "optimize".
Regards
Michel
|
Reduce them in size.
I have found an article on that says space of deleted rows is not actually freed.
Therefore the following statements should do the trick:
alter table tablename move;
alter index index_table rebuild;
Have anybody used them, should I know more before I use these statements?
@Michel: thanks for your swift reply!
|
|
|
|
|
|
|
|
| Re: 2 tables same rowcount different size [message #243653 is a reply to message #243650] |
Fri, 08 June 2007 04:11 |
Duke
Messages: 14
Registered: August 2006
|
Junior Member |
|
|
| Brayan wrote on Fri, 08 June 2007 03:46 | Hi,
| Quote: | 2 tables are identical however the size on disk is different
|
Looks at the no. of extents allocated. Are they same?
Brayan
|
@Michel I did some more research there are no delete procedures performed on the table as far as I can see...
Therefore
@Brayant:
I executed this one
select EXTENTS from dba_segments where segment_name ='TABLE_NAME';
EXTENTS
----------------------
122
1 rows selected
EXTENTS
----------------------
660
1 rows selected
Where can I find more info about EXTENTS then?
Is it the correct way to retrieve the EXTENT parameter?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
