Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate table and Internal Lock wait

Re: Truncate table and Internal Lock wait

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 22 Oct 1999 20:56:00 +0100
Message-ID: <940622257.1911.0.nnrp-04.9e984b29@news.demon.co.uk>

You don't happen to be running 64-bit HP-UX and Oracle 8.0.5 ?

--

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

lryan23_at_my-deja.com wrote in message <7uqema$d14$1_at_nnrp1.deja.com>...
>An application developer is runnning a process which truncates a work
>table. The process is running slow due to internal locking during the
>truncate. There are 10 instanaces of this process, all running
>truncates on 10 different work tables in the same tablespace.
>
>Any suggestions as to why / how to fix, a large amount of internal lock
>waits due to truncating? Is there a configuration parameter which I
>should investigate?
>
>Thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Oct 22 1999 - 14:56:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US