FND-CP-ESP: Child: exec:: No such file or directory

There could be 2 reasons this error could arise,

1. No Proper Symbolic link created or
    To resolve this create a Symbolic Link as below, without the file extension

    ln –s $FND_TOP/bin/fndcpesr $XXXX_TOP/bin/XXXXXXX

    XXXX – Custom TOP Name
    XXXXXXX – Executable name of the Program

2. The PROG File that’s created might have accidentally converted to DOS due to File Copy Mode.
 
    To resolve this, Convert the File to UNIX fileformat as below,
    dos2unix <FileName>.txt

Print This Post

SQL Tuning Advisor

The SQL Tuning Advisor analyses high-volume SQL statements and offers tuning recommendations. The SQL Tuning Advisor provides advice in the form of precise SQL actions for tuning the SQL statements along with their expected performance benefits.

Open a New SQL Worksheet and prepare the SQL for which you want to run the SQL Tuning Advisor for and Press Ctrl + F12 or the icon

The output would be as below with the recommendations,

Statistics: In this analysis, objects with stale or missing statistics are identified and appropriate recommendations are made to remedy the problem.

SQL Profile: In this section,  SQL Tuning advisor recommends to improve the execution plan by the generation of a SQL Profile, which is the optimized plan to be used for that SQL

Indexes: This recommends whether the SQL statement might benefit from an index. If necessary, new indexes that can significantly enhance query performances are identified and recommended.

Restructure SQL:  In this analysis, relevant suggestions are made to restructure the selected SQL statements for improved performance.

In order to run the SQL Tuning advisor, user needs to have ‘ADVISOR’ and ADMINISTER SQL TUNING SET privilege.


Print This Post