Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problem while execuitng query using DB Link.
On Mar 28, 10:30 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> mahesh wrote:
> > Hi while executing this dblink query the toad is hangs so please tell
> > me ia there anything wrong with this query
>
> > INSERT INTO DEST_DUPLI_MESS..._at_ltsb.us.oracle.com
> > (TXN_ID,COUNTRY_CODE,TXN_SOURCE,DEST_CODE,IN_TIME,DUPLI_MESSAGE_ID,MESSAGE)
> > (SELECT
> > TXN_ID,COUNTRY_CODE,TXN_SOURCE,DEST_CODE,IN_TIME,DUPLI_MESSAGE_ID,MESSAGE
> > FROM DEST_DUPLI_MESSAGE WHERE TXN_ID IN (SELECT TXN_ID FROM TEMP))
>
> Try executing the same query in SQL*Plus. If it does not hang, then the
> problem is with Toad.
>
> If it still hangs in SQL*Plus, then the INSERT statement is most likely
> waiting on something. You'll have to look at the wait events to see what
> it is waiting on.
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> d...@nospam.peasland.nethttp://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com
You may also want to look at how long the SELECT query takes to complete (without running the insert) and how many rows it returns. Received on Wed Mar 28 2007 - 10:48:31 CDT