reorganizing the entire tablespace

[mooks]

Hi

There is tablespace fragmentation in my database? What is the best way to tune this without affecting current transcations in the database?

Thank you

[gandolf989]

Can you create a new tablespace, preferably locally managed. and then do online moves of the tables/indexes during periods of low use. You could try to schedule the moves via a batch job, and do it over several nights.

[mooks]

I have tried to add a new datafile.. do you think it will helps too?

[kris123]

honey, tablespaces always get fragmented and it does not always mean
it will degrade performance

[mooks]

Ok thanks deary Will continue to monitor... However, the additional datafile helps in the space management of the tablespace.

[kris123]

Just let it autoextend my luv so u wont be bothered by it ne more

[abhaysk]

follow what gandolf989's said..

btw, kris123..

Originally posted by kris123
honey

Originally posted by kris123
my luv

Looks like u wana flirt with DBAs?

[davey23uk]

Originally posted by kris123
honey, tablespaces always get fragmented and it does not always mean
it will degrade performance

rubbish, LMT's *never* get fragmented

[kris123]

Originally posted by abhaysk
follow what gandolf989's said..

btw, kris123..





Looks like u wana flirt with DBAs?

NAH...my mom always calls me by that, and she is not flirting

[kris123]

Originally posted by davey23uk
rubbish, LMT's *never* get fragmented

Hun, AFAIK, if a tablespace is full of segments and is not contiguous
it is fragmented