Recursive SQl and LMT

[Sureshy]

Oracle 8i

Hi Friends,

I have a database running an application with poorly tuned sql statements which the vendor refuses to overhaul.

The poor sql results in thousands of buffer gets per execution. I have also noticed a lot of recursive sql.

If I were to convert my tablespaces to LMT, would this significantly reduce recursive sql to a point where a performance gain would be noticed ?

Thanks

Suresh

[jmodic]

I don't think you will notice very high reduction of recursive SQL just by switching to LMT. You will only eliminate the recursive SQLs that deal with extent (a)location. So unless your application allocates lot of new extents during its work, there will not be much difference.

[pando]

I think a good way to overcome badly SQL from application vendors is using stored outlines, forcing good executiion plans for those evil SQL stmts!

[Sureshy]

Thanks Folks..