Hold PeopleSoft Scheduled Process

Script to execute post refresh step in PeopleSoft to hold scheduled process

update PSPRCSRQST set runstatus=4 where runstatus=5;
update PSPRCSQUE set runstatus=4 where runstatus=5;

To find the HWM and kill sessions

Action Plan : Example
============

Kill session

select owner,table_name,num_rows,blocks from dba_tables where table_name='PS_CA_BI_PC_TA14';

result 0 and blocks above xxxx then have issue

alter table sysadm.PS_CA_BI_PC_TA14 enable row movement;
alter table sysadm.PS_CA_BI_PC_TA14 shrink space;
alter table sysadm.PS_CA_BI_PC_TA14 DISABLE row movement;

alter index sysadm.PSVIZCA_BI_PC_TA14 rebuild online;
alter index sysadm.PS_CA_BI_PC_TA14 rebuild online;

exec DBMS_STATS.GATHER_TABLE_STATS (ownname=> 'SYSADM', tabname=>'PS_CA_BI_PC_TA14', estimate_percent=>100, method_opt=> 'FOR ALL COLUMNS SIZE 254', DEGREE=> 8, cascade=>TRUE);