Before performing this I have done the following.
INSERT /*+ append parallel(auto) */ INTO INTERFACE_ST SELECT * FROM INTERFACE_STORE;
Still my insert is taking 30 mins.
ALTER SESSION SET PARALLEL_DEGREE_POLICY = AUTO; ALTER SESSION ENABLE PARALLEL DML;
user9077483 wrote:Why are you asking me? I didn't ask you to run that. Please read my post and provide the required information.
After executed my insert I have given the following statement it's not returned any rows.
select sid, qcsid, degree, req_degree from v$px_session order by qcsid;
How to proceed.
Please help me.
user9077483 wrote:We will when you provide the information asked for.
I am inserting 20 million records.
Compared to direct insertion in the table using DB LINK is taking long time.
Please help me how to improve the performance.
INSERT /*+ append parallel(auto) */ INTO MAIL_LOG@db_apsp t select * from mail_log;
Thanks in advance.