Re: Truncate table and Internal Lock wait

From: <lryan23_at_my-deja.com>
Date: Mon, 25 Oct 1999 13:34:45 GMT
Message-ID: <7v1m9l$35p$1@nnrp1.deja.com>

Exactly!!!!

In article <940622257.1911.0.nnrp-04.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 25 1999 - 08:34:45 CDT