Re: Stuck on insert into a global temporary table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 5 Jan 2001 09:25:01 -0000
Message-ID: <978686501.18871.1.nnrp-02.9e984b29@news.demon.co.uk>

Naive question - but does your o/s support 32GB files ?

Apart from that, perhaps there is a problem mixing TEMPORARY TABLESPACES with AUTOEXTEND.

How about create the file at 1GB without AUTOEXTEND just to see if that isolates the problem.

Finally, when the system locks, check v$lock to see if there are any suspect locks. Look out for anything with a CTIME that matches (in seconds) the amount of time that the process has been stuck.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



roman_stangel_at_my-deja.com wrote in message <933rjv$t6u$1_at_nnrp1.deja.com>...


>Brian

>

>Thank you for your suggestions.  I have tried the configuration changes

>you suggested, but unfortunately it did not help.  In particular

>someone suggested to create the table space as follows:

>

>CREATE TEMPORARY TABLESPACE "IPWTEMPTS2"

>TEMPFILE '/home/oracle/u05/oradata/ORCL/IPWTEMPTS2.dbf' SIZE

>64M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE 32767M EXTENT MANAGEMENT

>LOCAL UNIFORM SIZE 256K;

>

>Roman

>

>

>Sent via Deja.com

>http://www.deja.com/

Received on Fri Jan 05 2001 - 03:25:01 CST