Re: Truncate table and Internal Lock wait

Do you happen to know the bug number on this one? I called oracle support and they were unable to find a corresponding bug for this.

Thanks,
Laud
In article <941277137.2824.0.nnrp-02.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> 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 ?
> >> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 03 1999 - 08:40:19 CST