| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Throwing extents problem
Tony Adolph wrote:
>
> Hello All,
>
> A strange problem (I think)....
>
> I have the following errors in my alert log (note the extent size):
>
> Fri Oct 22 09:34:48 1999
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__SESSID by
> 704 in tablespace PINX00
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__SESSID by
> 1535 in tablespace PINX00
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__SESSID by
> 1849 in tablespace PINX00
> Fri Oct 22 09:35:46 1999
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by
> 849 in tablespace PINX00
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by
> 4100 in tablespace PINX00
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by
> 4100 in tablespace PINX00
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by
> 1839 in tablespace PINX00
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by
> 1849 in tablespace PINX00
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by
> 1849 in tablespace PINX00
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by
> 1849 in tablespace PINX00
> ORA-1654: unable to extend index PIN.I_EVENT_SESSION_DIALUP__TERMID by
> 1849 in tablespace PINX00
>
> In tablespace PINX00 I have bucket loads of contiguous space:
>
> Freespace where
> Tablespace Number of extents extent >= 16 MB Biggest
> Name >= 16 MB (useful freespace) free extent
> -------------- ----------------- ------------------ -----------
> PINX00 1 467.67 467.67
>
> Next extent size for this index is 4M and it has unlimited max extents.
>
> I have manually allocated a 4M extent without error.
>
> Why am I getting this error and why is it trying to throw an extent
> that doesn't match the next_extent size for this object??
>
> Any help much appreciated.
> Cheers
> Tony Adolph
>
> PS Ora 7.3.4 NT4
Would you happen to have a pct_increase value that is not 0? If so, how many extents are in the index? If pct_increase is set to the default of 50% and if you have an initial of 4M and a next of 4M then Extent #1 will be 4M, Extent 2 will be 4M, Extent #3 will be 6M, Extent #4 will be 9M, Extent #5 will be 14M, etc.
The extent value shown in the error message is never correct. I suppose that oracle has some reason for showing the value it does, but I have never found the value to be useful.
One thing you might try is turning autoextend on for the datafile.
Another thing to try is rebuilding the index. Make sure you have pct_increase set to 0.
......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ............................................................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... ......................................................... .........................................................Received on Fri Oct 22 1999 - 09:15:08 CDT
 |
 |