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
nawshot
Messages: 12
Registered: May 2007
Junior Member
hi,

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.

regards
NAW.
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
BlackSwan
Messages: 22515
Registered: January 2009
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
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: Mon Jul 28 14:39:17 CDT 2014

Total time taken to generate the page: 0.09802 seconds