ORA-00074: no process has been specified ORACLE 报错 故障修复 远程处理

文档解释

ORA-00074: no process has been specified

Cause: No debug process has been specified.

Action: Specify a valid process.

ORA-00074: session cursor cache count of %s exceeds allowed maximum of %s

官方解释

常见案例

正常处理方法及步骤

1.重新调整合理大小

2.添加全局参数 “_cursor_obsolete_threshold ” 及 “_obsolete_low_threshold” 参数

3.查看其他参数：cursor_space_for_time、open_cursors、_cursor_copy_memcpy_enabled

4.进行更改：Alter session set cursor_space_for_time=true

5.增加服务器空间