Re: a heated discussion between Development Team & "a" DBA: reorg or not to reog

Joel Garry wrote:

> There are unsupported methods of not having to do the database
> recreation, but if terms like FET$ don't mean anything to you, I
> wouldn't recommend them. In fact, even if they do mean something to
> you, better to fix the actual problem.
>

If you just look into the file, you'll see there's a clear mark; do not touch this, and: safe to touch this. I've done it several times; nothing wrong with it, as long as you know which ones to alter.
Having a blown db like in this case, it's pretty easy to find which of the tables have been hit hard.

And to the OP, I have seen you responding "no LMT's" several times, but no justification.

Just recreated a temp tablespace with temp files, LMT, uniformly segmented in 8.1.6, and the app response time went down to less than 2 secs from about 15 secs. Resized from 16GB (!) to 1GB in three files, too. What more reasons do you need for LMT?!?

-- 
Regards,
Frank van Bortel