EBS Customizations (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center