• The process scheduler has a job in posting status for a long time

Some time by someone posting a very large file –
We can check with following Query:

All process names that have file size over 1Mb, and have not gone to "success" status -- yet

SELECT C.OPRID,D.OPRDEFNDESC,A.PRCSINSTANCE, B.PRCSNAME, A.FILE_SIZE, B.DISTSTATUS,C.RUNSTATUS
FROM PS_CDM_FILE_LIST A, PS_CDM_LIST B, PSPRCSRQST C,PSOPRDEFN D
WHERE A.DTTM_CREATED > SYSDATE - 1
AND A. FILE_SIZE > 1048576
AND A.PRCSINSTANCE = B.PRCSINSTANCE
AND B.PRCSINSTANCE = C.PRCSINSTANCE
AND B.DISTSTATUS = '7'
AND RUNSTATUS = '14'
ORDER BY PRCSINSTANCE DESC, DTTM_CREATED DESC, FILE_SIZE DESC;

Once the prcsinstance is determined, use that to find the file in the log_output directory and user know they posted a file that was too large.

some time distribution agent processes not cleaning up after themselves

Kill all distribution agent processes (kill –9) and jobs are still posting, try updating the tables to get them to post

if noting happening bounce the scheduler and use ipcrmall (Peoplesoft delivers a script (it's stored in appserv directory):ipcrmall.sh)
[//home/oracle]cd $PS_HOME/appserv
[/product/psoft/appserv]ls -l | grep ipcrmall.sh -rwxr-xr-x 1 oracle dba 6281 Apr 18 2006 ipcrmall.sh
[/product/psoft/appserv]
to clear all memory segments

The process scheduler has processes in queued status PSPRCSRV process is hung up, kill it and it will restart Or, bounce the process scheduler