INSERT INTO PS_BP_PRNT_TAO taking long time
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
SQL | An 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. |