On Tue, 2005-12-06 at 15:43 -0800, Joe Slagel wrote:
> Hi Tim & Folks,
>
> We've found a interesting problem when inserting multiple rows into a
> table containing two CLOB columns. The second execute() hangs and
> Oracle never responds. The execute() hangs only when the character
> sizes of the two strings are larger than 4000 characters each, and even
> then not always. Code is below which demonstrates problem. Any clues as
> to whether this is in the DBD layer or in Oracle?
>
A few questions:
* Can you reproduce this in SQL*Plus or PL/SQL? If so, then
you have a problem with the database, possibly a bug.
* Have you traced the session via 10046 to see exactly what
the session is doing?
* Have you checked v$sesstat to see what the session is waiting on?
select
s.username username,
e.event event,
s.sid,
e.p1text,
e.p1,
e.p2text,
e.p2,
e.wait_time,
e.seconds_in_wait,
e.state
from v$session s, v$session_wait e
where s.username is not null
and s.sid = e.sid
and s.username like upper('&uusername')
order by s.username, upper(e.event)
This should help determine if the problem is in the db or somewhere
else.
HTH
Jared
