nvision process is running longer after DB Upgrade to 11.2.0.3
edited Jun 14, 2013 10:38PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 5 commentsAnswered
Hi,
We have recently upgraded Oracle Database Version 11.2.0.3 from 10.2.0.4. After the upgrade handful SQLs started running longer. We addressed them by using Oracle Hints for Optimizer in SQLs except 2. Those 2 SQLs are getting executed from nVision. These nVisions are Tree-based and SQLs are getting generated dynamically. Is there any way to pass hint thru SQL Select statement or Alter session (alter session set optimizer_features_enable=10.2.0.4) during run time of nvison reports?
SQL for the nvision:
SELECT A.ACCOUNT,
SUM(A.POSTED_BASE_AMT)
FROM PS_LEDGER A,
PSTREESELECT10 L2,
PSTREESELECT10 L
WHERE A.LEDGER ='HCR'
AND A.FISCAL_YEAR=2012
0