| MERGE Statement... TIME OUT error... hanged (merge 6) [message #404805] |
Sun, 24 May 2009 02:52  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
