PLSQL Service Instances

InForm and Clinical One metadata and data loading use the PLSQL service. Oracle LSH installation automatically creates a service location with the database SID as its name and creates the PLSQL service under it in the Oracle LSH user interface with three service instances, which allows concurrent processing of three PL/SQL jobs.

In Oracle DMW, these jobs include:

• Loading metadata and data for InForm and Clinical One studies
• Executing a PL/SQL custom program for a transformation
• Executing a generated transformation
• Executing a validation check batch

Increase the number of PLSQL service instances to support the number of PL/SQL jobs you are likely to run concurrently. Oracle recommends a setting of 100.