OraFAQ Forum: Server Administration » Oracle process ORACLE.EXE (P00,P001... P024

Home » RDBMS Server » Server Administration » Oracle process ORACLE.EXE (P00,P001... P024 (Oracle 10.2.0.4 AIX 6L )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle process ORACLE.EXE (P00,P001... P024 [message #493134]

Sat, 05 February 2011 06:37

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hello,

While monitoring the database in pick hours, i traced number of ORACLE.EXE (P00,P001... P024).. in active session.

Reading some docs. i came to find to these are parallel process.

Shall you please let me help in finding which session is causing these sessions.

Regards,
Jay vardhan

Report message to a moderator

Re: Oracle process ORACLE.EXE (P00,P001... P024 [message #493147 is a reply to message #493134]

Sat, 05 February 2011 09:09

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

select s.qcsid user_session, p.sid parallel_session, p.server_name
from v$px_session s, v$px_process p
where p.sid = s.sid
order by 1, 2;

Regards
Michel

Report message to a moderator

Re: Oracle process ORACLE.EXE (P00,P001... P024 [message #493148 is a reply to message #493147]

Sat, 05 February 2011 09:14

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Thanks Michel,

For the query. I will do the further study to dig out the issue.

Thanks & Regards,
Jay vardhan

Report message to a moderator

Previous Topic:	Control file
Next Topic:	TNS-01150 The address of the specified listener name is incorrect (2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 01:14:18 CDT 2024