I am asking your knowledge to help me found out what is the process O00n used for in Oracle 10g? Since Saturday evening, I have a process named O000 taking a lot of charge on a RAC instance and I'd like to know how to investigate and solve this issue. In fact at that time I had to recreate a new tablespace and just after launching the command CREATE TABLESPACE I realized that I had made a syntax mistake. So instead of waiting for oracle to through me an oracle error, I did CTRL + C, not good but I did it, I was using SQLPlus. Since then I have this process O000 taking a lot of charge on this instance.
I have been looking everywhere for info, on metalink on the net but nothing explaining what is this process used for.
I hope you will be able to help.
They are processes to allow connections to the ASM instance. Your issue sounds like this bug to me: "ora_o00n Process High CPU Usage in 188.8.131.52 [ID 1459376.1]"
https://support.oracle.com/epmos/faces/ ... =1459376.1
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests