Page History
...
- Verify that you have a valid Interpoint for PeopleSoft license.
- Open the PeopleSoft configuration file psappsrv.cfg (usually located in the
PT%version%\appserv\%domainName%
folder). IfEnableDBMonitoring=1
, proceed to step 7. Otherwise, proceed to step 3. - Disconnect all PeopleSoft users.
- Shut down all PeopleSoft application servers.
- Set the database monitoring parameter to TRUE:
EnableDBMonitoring=1
- Restart the PeopleSoft application servers.
- Connect to the database that PeopleSoft is installed on. Use the user that owns the PeopleSoft database.
To find out who owns this database, run the following query:
select owner from dba_objects where object_name = 'PSPRCSRQST';
The owner returned is the one who owns the PeopleSoft database. - Run the following SQL script:
create or replace trigger precise_psprcsrqst_register after update of runstatus on psprcsrqst for each row
when (new.runstatus = 7 and old.runstatus != 7) begin dbms_application_info.set_client_info(:new.oprid
||',,,'|| :new.prcsinstance || ',' || :new.prcsname
||',');
exception when others then null;
end;
/
Precise. Performance intelligence from click to storage. Learn more > >
...
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal
...