Database Options Section

Use this section for database-specific configuration options:

Parameter	Description
UseLocalOracleDB	Indicate whether the PeopleSoft database to which you are connecting is in a local Oracle System Identifier (SID). The default is 0, which indicates that the PS database to which you are connecting is remote. Note: For the Windows operating system, the parameter "UseLocalOracleDB" is not supported when using a 32 bit client connecting to a 64 bit database. See System and Server Administration: UseLocalOracleDB
EnableDBMonitoring	Add to the configuration file for database-level auditing. It is a required parameter. Use this option to view more information regarding the clients that are connected to a database server through the process scheduler server. For instance, with this enabled, you can view the client machine name or user ID that is associated with a particular connection. See System and Server Administration: EnableDBMonitoring.
EnableAEMonitoring	You must set the EnableAEMonitoring configuration setting to 1 to populate the MODULE and ACTION fields in V$SESSION and V$SQL views. By default, EnableAEMonitoring is set to 0 (disabled). To change the EnableAEMonitoring setting for an Application Server domain or a Process Scheduler domain, use the PSADMIN utility or manually modify the PSPRCS.CFG configuration file or the PSAPPSRV.CFG configuration file, then restart the respective servers.

Parameter

Description

UseLocalOracleDB

Indicate whether the PeopleSoft database to which you are connecting is in a local Oracle System Identifier (SID). The default is 0, which indicates that the PS database to which you are connecting is remote.

Note: For the Windows operating system, the parameter "UseLocalOracleDB" is not supported when using a 32 bit client connecting to a 64 bit database.

See System and Server Administration: UseLocalOracleDB

EnableDBMonitoring

Add to the configuration file for database-level auditing. It is a required parameter. Use this option to view more information regarding the clients that are connected to a database server through the process scheduler server. For instance, with this enabled, you can view the client machine name or user ID that is associated with a particular connection.

See System and Server Administration: EnableDBMonitoring.

EnableAEMonitoring

You must set the EnableAEMonitoring configuration setting to 1 to populate the MODULE and ACTION fields in V$SESSION and V$SQL views. By default, EnableAEMonitoring is set to 0 (disabled). To change the EnableAEMonitoring setting for an Application Server domain or a Process Scheduler domain, use the PSADMIN utility or manually modify the PSPRCS.CFG configuration file or the PSAPPSRV.CFG configuration file, then restart the respective servers.