Performance - EBS (MOSC)

MOSC Banner

One concurrent program running for long time

edited Oct 23, 2012 10:09AM in Performance - EBS (MOSC) 5 commentsAnswered
Hi,
One concurrent program running for long time and i have generated tkporf , Below is the sql which is taking for long time.But when we check explain plan , cost is very low.
 db file sequential read is very high.How to tune this query for :

APPS : 11.5.10.2
Db : 10.2.0.2

SELECT /*+ optimizer_features_enable('9.2.0') */ PHA.VENDOR_ID, 
  PHA.VENDOR_SITE_ID, PHA.PO_HEADER_ID, PHA.SEGMENT1 PO_NUMBER, 
  NVL(PLL.NEED_BY_DATE,PLL.PROMISED_DATE) PO_DATE, PHA.CLOSED_CODE, 
  SUM(NVL(PLL.QUANTITY_RECEIVED,0)-NVL(PLD.QUANTITY_BILLED,0)) AMOUNT, 
  PHA.ATTRIBUTE1, PHA.ATTRIBUTE2, PHA.ATTRIBUTE3, PHA.ATTRIBUTE4, 

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center