RE: Re: oracle docs do say # of extents effect performance

2003-06-20 Thread Mercadante, Thomas F
I think with LMT's now, it is irrelevant. I still think you need to know approx. how big the table is going to be, and place it in the correct LMT. By this I mean that you may have different LMT's with different uniform extent sizes. A very large table should be placed in the largest LMT tablespa

Re: Re: oracle docs do say # of extents effect performance

2003-06-20 Thread rgaffuri
ok, so should the number of extents in a table be considered in table design? there are alot of .pdfs and people on this listserv that say it is irrelevant? > > From: Rachel Carmichael <[EMAIL PROTECTED]> > Date: 2003/06/20 Fri PM 02:44:52 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PR

Re: RE: oracle docs do say # of extents effect performance

2003-06-20 Thread rgaffuri
i understand, but alot of people have posted here that its ok to have smaller extents anyway. who is correct? or am i missing something? > > From: "Richard Ji" <[EMAIL PROTECTED]> > Date: 2003/06/20 Fri PM 02:00:11 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: R