Gene - Are you using uniform extents by any chance? Just thought it wouldn't hurt to ask. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED]
-----Original Message----- Sent: Monday, November 12, 2001 3:51 PM To: Multiple recipients of list ORACLE-L Deepak, thanks for the input. I have double-checked the pctincrease and it is set to 0 on all tables in my schema. Regarding the rounding up of the number of blocks, that would have explained if the extents were larger than my next extents size. As it now, my block size is 8K. The next extent - 512K - is 64blocks. The extents size are either 2 or 3 blocks only. Gene --- Deepak Thapliyal <[EMAIL PROTECTED]> wrote: > check the value of pctincrease for your table from > user_tables/dba_tables. note that the default > pctincrease for tablespace is 50. my guess > pctincrease > value fo your table is non-zero > > alternatively, the size might be attributed to the > fact that oracle rounds the number of blocks that > make > up the extent. i forget what that is .. my tired > brain > cells tell me that its something like 5 blocks or so > . > > > Deepak > > > > --- Gene Gurevich <[EMAIL PROTECTED]> wrote: > > Hi. > > > > I have two tables in my database. They both have > > the NEXT_EXTENT set to 512K for a long time. Yet > > all the extents for these tables are either 16 > > or 24K. I have checked the next extent sessing > once > > and again and it has always shown 512K. The tables > > are not being truncated. Why would Oracle create > > the new extents with different size? Is there any > > other > > place I need to check? > > > > thanks for any input > > > > Gene > > > > ===== > > > > > > __________________________________________________ > > Do You Yahoo!? > > Find a job, post your resume. > > http://careers.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Gene Gurevich > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __________________________________________________ > Do You Yahoo!? > Find a job, post your resume. > http://careers.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Deepak Thapliyal > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
