9.3.2 PLSQL Service Instances for InForm Metadata and Data Loading and PL/SQL Jobs

InForm 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 an InForm study
• 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.