Financial Management - PSFT (MOSC)

MOSC Banner

INSERT INTO PS_BP_PRNT_TAO taking long time

edited May 6, 2014 12:13PM in Financial Management - PSFT (MOSC) 4 commentsAnswered

Hi experts.

This query is running from 9:30 am this morning and still going.

I'am not a Peoplesoft PRogrammer, but an Oracle Dba.

I checked the redo log sizing, The awrpt, The memory 12 gb for sga + 1 gb pga_aggregate_target. Server has 18 gb in server which only 4% is non-compromised.

The Sql Tuning Advisor is asking me to hit the "Implement" button :

Restructure SQL

SQLAn expensive cartesian product operation was found at line ID 15 of the execution plan.
Consider removing the disconnected table or view from this statement or add a join condition which refers to it.A cartesian product should be avoided whenever possible because it is an expensive operation and might produce a large amount of data.

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