Find HWM and Tunning

 Action Plan :

============

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);