What is process O00n used for?

All posts relating to Oracle database administration.

Moderator: Tim...

Posts: 13
Joined: Thu Oct 27, 2011 10:53 am

What is process O00n used for?

Postby patrick196901 » Mon Dec 17, 2012 3:27 pm

Hi Tim,

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.



Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: What is process O00n used for?

Postby Tim... » Mon Dec 17, 2012 5:30 pm


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 [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
OakTable Member
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

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 1 guest