Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate table and Internal Lock wait
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