Re: Truncate table and Internal Lock wait

Jonathan,

I eagerly wait your response, and any issues of running on 64-bit HP-UX and oracle 8.0.5.

Thanks,
Laud

In article <7v1m9l$35p$1_at_nnrp1.deja.com>,   lryan23_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 27 1999 - 22:42:45 CDT