Re: Truncate table and Internal Lock wait

Sorry about the delay - I've been unable to connect for a week.

I believe this is a known bug in this port, not sure of the details but it may be
associated with an SGA larger than 1.7 Gb.

You may find it is quicker to delete all rows than truncate the table. (One of the features of truncate is that it flushes all of the table's blocks to disc before truncating and I think the code to do this carries the critical error).

You might try fiddling with the value of db_block_lru_latches to see if this makes any differences.

--

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

lryan23_at_my-deja.com wrote in message <7v8gnm$2d2$1_at_nnrp1.deja.com>...
>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 ?
>> >
Received on Sat Oct 30 1999 - 04:41:36 CDT