Concurrent Program running for a long duration due to an Insert statement
Hi,
We have a PL/SQL procedure based concurrent program.
In this package, we are populating data from a custom view into a custom table. I am using the following command:
INSERT into TABLE_A(COL_A,COL_B,COL_C) SELECT VAL_A,VAL_B,VAL_C FROM VIEW_A;
Previously COL_C was not populated. The program completed in less than 2 mins.
Now when I try to populate the column COL_C, it takes a long duration. (More than 1 hour). In order to test, I hard-coded the third value to USD instead of fetching from the view. Even then it takes more than an hour.