Re: My table is hanging!

There isn't really a lot to go on in your description, although it is unusual to see the 'index block split' waitstate (how long did this persist for, was it indefinite).

One possibility is that you need to increase the value of INITRANS on the table (and possibly on its indexes).

By waving my hands and burbling for a few minutes I could invent a sort of deadlock (which ought to be detected) on ITLs is happening but not being detected when an index block splits.

--

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

Dicky wrote in message <7od6dr$iet$1_at_imsp009a.netvigator.com>...
>Hi, everybody. I'm new to AIX Oracle 7.3.4 SP. I found one of my table
was
>being locked by a normal "insert & update" process and could not remove
this
>process in a normal way. Furthermore, I got a message "index block split"
>from event field in the v$session_wait table.
>
>This problem can be reproduced -- once I'm fixed the problem by rebuilding
>its indexes, this problem will occur again after 2-3 weeks run. Anyone
can
>tell me what wrongs I get?
>
>Thanks in advance.
>
>
>
Received on Fri Aug 06 1999 - 02:55:26 CDT