OraFAQ Forum: SQL & PL/SQL » Insert statements

Home » SQL & PL/SQL » SQL & PL/SQL » Insert statements (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Insert statements [message #609828]

Wed, 12 March 2014 15:56

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi,

I have a scenario here.
. I have 4 insert statements inside an anonymous block. Order of execution of insert statements as below.

1. Insert into tablea select column_names from table1
2. Insert into tablea select column_names from table2
3. Insert into tablea select column_names from table3
4. Insert into tablea select column_names from table4
5. commit

If execute the anonymous block, it is taking more than 6 hours to execute.
But if I execute each select statements one by one, each select statement is taking maximum of 10 minutes to execute.

Is this due to memory issue?? What is the cause of the issue?? Please advise.

Please also note that the maximum records returned by each query is 10.

Regards,
SRK

Report message to a moderator