Truncate table and Internal Lock wait

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:42:02 CDT