Hi, guys
thanks for replies!
There are 2 session which hanging since last Saturday, they are locking sys objects, and when I trying to execute:

ANALYZE TABLE sys.view$ DELETE STATISTICS;
ANALYZE TABLE sys.user$ DELETE STATISTICS;
ANALYZE TABLE sys.cdef$ DELETE STATISTICS;
ANALYZE TABLE sys.con$ DELETE STATISTICS;
ANALYZE TABLE sys.com$ DELETE STATISTICS;
ANALYZE TABLE sys.typed_view$ DELETE STATISTICS;
ANALYZE TABLE sys.dependency$ DELETE STATISTICS;
ANALYZE TABLE sys.obj$ DELETE STATISTICS;
ANALYZE TABLE sys.sql_version$ DELETE STATISTICS;
ANALYZE TABLE sys.FET$ DELETE STATISTICS;
ANALYZE TABLE sys.UET$ DELETE STATISTICS;this

Any of this statements is hanging.

Is there any other way to kill session in MTS? My dispatcher takes up to 95% CPU, but I can not kill that process, becuase of it will effect on other sessions.

That statement does not really kill session, it is marked for kill several days.

alter system kill session '10,30136';
ORA-00031: session marked for kill

Thanks for any advice.

Originally posted by jbeckstrom
Check if you have stats on the "sys" objects, if so delete the stats.