| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Next extent problem
Gene - Are you using uniform extents by any chance? Just thought it wouldn't
hurt to ask.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----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 <deepakthapliyal_at_yahoo.com>
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 <g_u_r_e_v_i_c_h_at_yahoo.com> 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: g_u_r_e_v_i_c_h_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: g_u_r_e_v_i_c_h_at_yahoo.com 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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM 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: ListGuru_at_fatcity.com (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).Received on Mon Nov 12 2001 - 16:28:10 CST
 |
 |