Re: AUTOEXTEND question

From: Tommy Cusan <saras008_2000_at_yahoo.com>
Date: 2000/05/25
Message-ID: <8gjgqd$aus$1@new-proxy.bscc.bls.com>#1/1

I think Oracle try to allocate or seek for the biggest extent in this case 10070 blocks in temp tablespace and it can't find it. Try to make the next extent bigger for temp tablespace so it will not allocate many extents that will reach the maxextents eventually.

Regards,
Tommy Cusan
Oracle DBA Support

Syltrem wrote in message <5IaX4.811$p7.7098_at_wagner.videotron.net>...
>Hello!
>
>Is there a way to know if a datafile AUTOEXTEND option is ON?
>
>Also, is it possible that even though autoextend is on, I end up getting
the
>message
>ORA-1652: unable to extend temp segment by 10070 in tablespace TEMP
>
>The fact that the tablespace has grown a lot (I don't yet know what the
>programmers do in there) makes me think that autoextend was on, but with
>this message I don't know anymore, and I can't check to make sure.
>
>Thanks!
>
>
>
>
Received on Thu May 25 2000 - 00:00:00 CDT