Re: Why are my queries getting stuck?

Hi.

 Try executing your statement in SQL*Plus :  set timing on
 set autotrace on
 DELETE ....  Look at execution plan of the statement.  Check if you defined index on ( listname, id ) and  is it used.

 Good luck. Michael.

In article <7nq6ga$3oo$1_at_news1.bu.edu>,   tasos_at_csa.bu.edu (Anastasios Kotsikonas) wrote:
>
> Using 8.05 under Linux thru Java... a simple update:
>
> delete from lw_digests where listname='test2' and id=1
>
> (and of course others) never return and a timeout exception
> is thrown:
>
> java.sql.SQLException: ORA-01013: user requested cancel of current
operation
>
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:181)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:631)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7
(TTC7Protocol.java:1221)
> at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch
(TTC7Protocol.java:657)
> at oracle.jdbc.driver.OracleStatement.doExecuteOther
(OracleStatement.java:770)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithBatch
(OracleStatement.java:812)
> at oracle.jdbc.driver.OracleStatement.doExecute
(OracleStatement.java:1154)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1177)
> at oracle.jdbc.driver.OracleStatement.executeUpdate
(OracleStatement.java:1203)
> at lwdb.LWTxn.ExecuteUpdate(LWTxn.java:166)
> at lwdb.LWTxn.ExecuteUpdate(LWTxn.java:147)
> at lwdb.LWDigest.DBUpdate(LWDigest.java:1131)
> at lwdb.LWDigest.DeleteById(LWDigest.java:967)
> at lwd.cos.email.listDigest.send(listDigest.java:217)
> at lwd.listDigester.Begin(listDigester.java:198)
> at lwd.dispatch.WorkerThread.run(WorkerThread.java:246)
>
> I specify the timeout:
>
> stmt.setQueryTimeout(60*1000); // 60 seconds
> int res = stmt.executeUpdate (sql);
>
> but do I time out?
>
> thanks
>
> tasos
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jul 31 1999 - 08:04:04 CDT