Home » SQL & PL/SQL » Client Tools » MERGE Statement... TIME OUT error... hanged (merge 6)
MERGE Statement... TIME OUT error... hanged (merge 6) [message #404805] Sun, 24 May 2009 02:52 Go to next message
Messages: 12
Registered: May 2007
Junior Member

In merge statement, in USING i have a select statement which has join of 4 tables, say TAB_1, TAB_2, TAB_3, TAB_4. TAB1 HAS 13,514,477 records. TAB_2 has 1,000,000 records. TAB_3, TAB4 are smaller tables. This select statement will pull all the records from TAB_1. takes 11 secs to executed separately in TOAD.

PROBLEM: When this procedure is executed i TOAD in debug mode, it says TIME OUT and getting hanged. If executed separetely it doesnt throw any error but goes on running without any error.

I tried using ROWNUM in select st. for 10000 rows this merge is working fine. But for 100,000 rows it is saying time out and getting hanged.

So doubt is whether there is a limitation of rows in merge statement or is there any work around for this in DB level.

Re: MERGE Statement... TIME OUT error... hanged (merge 6) [message #404813 is a reply to message #404805] Sun, 24 May 2009 07:24 Go to previous message
Messages: 25568
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Previous Topic: echo on slow with large stored procedure
Next Topic: exporting tables
Goto Forum:

Current Time: Wed Aug 16 23:02:46 CDT 2017

Total time taken to generate the page: 0.32521 seconds