数据库巡检时发现RAC节点2出现CPU使用率高的问题
top命令查看,占用CPU的都是ora_o00n进程
关于Onnn进程的描述:
Onnn - ASM Connection Pool Process
Maintains a connection to the ASM instance for metadata operations
Onnn slave processes are spawned on demand. These processes communicate with the ASM instance.
Represents the server side of a client/server connection.
These processes will appear the moment the instance is started, and will disappear after that.
Onnn
ASM的slave进程,有一组o00n的进程用于连接ASM实例,通过这个连接池数据库进程将发送指令给ASM实例,如,打开一个文件时,通过该连接池将打开文件的请求发送给ASM。该进程仅适用于到ASM的短连接。这些进程也会限制登录到ASM实例的短连接,防止过载。
Solution
- 在非业务高峰期时,可以kill掉Onnn进程,让其重新生成,kill掉Onnn进程不会影响数据库运行;
- 重启服务器。
参考以下文档
High Load On Server from Process Ora_onnn (Doc ID 1556564.1)