Re: LMT and Siebel/Peoplesoft?

I agree except on one point. LMT is not new to 8.1.7 and buggy? I have LMT on many high volume production databases, both OLTP and Data Warehouse and have never seen a problem.

Daniel Morgan

Nuno Souto wrote:

> Vikas Agnihotri doodled thusly:
>
> >I see that they have ~3000 tables and 13000 (yes, 13000) indexes. 80%
> >of the tables are empty to pretty small (~100K). The remaining range
> >from 1MB to 15MB.
>
> Peoplesoft has the bad habit of creating quite a few "temporary"
> tables. By this they mean:
>
> A) create a table at install time.
> B) fill it up with report or batch intermediate results (per user).
> C) do whatever needs to be done (per user).
> D) delete the inserted rows (per user).
>
> with the result that these things are murderous to manage in a
> conventional tablespace. For these using LMTs would definitely be an
> advantage, IMHO.
>
> For the rest, I couldn't be bothered. There isn't enough traffic on
> most of them to justify putting the lot on LMT. You're much better
> off splitting load across multiple tablespaces and being careful how
> you allocate them to different buffer caches.
>
> And given that LMT is relatively new in 8.1.7 (read: potentially
> buggy), I wouldn't go overboard anyway.
>
> As for a large number of extents (in the 100's) causing serious
> performance degradation: only in very abnormal circumstances. I'd
> look at other reasons.
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Mon Jan 21 2002 - 02:50:50 CST