deleting 1 million records using a cursor
I want to delete records in a table(table_one) which has about 1.1 million records. I have another table(table_two) with 80 thousands records that I use as a criteria for deleting. Here is my cursor that I am using but it takes more than 3 hours and still not completed.
declare
cursor cur_delete is
select col_a from table_two;
begin
for i in cur_delete loop
delete from table_one
where col_aa = i.col_a;
end loop;
end;
/
What other methods can I use. Thank you in advance.