你这个是不是装了什么监控或者自动化运维的工具？
TOPSQL全是这种：

SELECT NULL AS table_cat, o.owner AS table_schem, o.object_name AS table_name, o.object_type AS table_type, NULL AS remarks FROM all_objects o WHERE o.owner LIKE :1 ESCAPE '/' AND o.object_name LIKE :2 ESCAPE '/' AND o.object_type IN ('xxx', 'TABLE') ORDER BY table_type, table_schem, table_name

select SCN, OPERATION_CODE, SEG_TYPE, TIMESTAMP, XID, ROW_ID, SQL_REDO, CSF, RBASQN, RBABLK, RBABYTE, TABLE_NAME, SEG_OWNER, DATA_OBJ#, RS_ID, SSN, XIDSQN from V$LOGMNR_CONTENTS WHERE OPERATION_CODE in (1, 2, 3, 5, 6, 7, 36)

DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN auto_add_datafile; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

...
复制

先把这类原因找到，再就是你这个系统I/O也不太好，%WIO 7.6。

topsql里面都是监控类sql吧，先搞掉吧
cpu、io资源用尽，内存耗尽、严重抖动，基本都是指向这类sql