Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> List all process description
paulogervasio
post Feb 9 2012, 09:52 AM
Post #1


Advanced Member
***

Group: Members
Posts: 69
Joined: 5-August 11
From: Brazil
Member No.: 45,669



Hi, are there a table/view that lists all process with description like the DICT does for the data dictionary views?

I wanna know for example the description of J001 or Q001 process for example.

Thanks.
Paulo.
Go to the top of the page
 
+Quote Post
paulogervasio
post Feb 9 2012, 12:27 PM
Post #2


Advanced Member
***

Group: Members
Posts: 69
Joined: 5-August 11
From: Brazil
Member No.: 45,669



QUOTE (paulogervasio @ Feb 9 2012, 12:52 PM) *
Hi, are there a table/view that lists all process with description as the DICT does for the data dictionary views?


I wanna know for example the description of J001 or Q001 process for example.

Thanks.
Paulo.

Go to the top of the page
 
+Quote Post
burleson
post Feb 9 2012, 02:34 PM
Post #3


Advanced Member
***

Group: Members
Posts: 11,328
Joined: 26-January 04
Member No.: 13



Hi Paulo,

>> I wanna know for example the description of J001 or Q001 process for example.

Those are EDXTRERNAL: to Oracle (like that don;t appear in Windows).

Hence, you would need to use my pages to find these:

http://www.dba-oracle.com/t_background_processes.htm

However, Oracle has a list of these process that he is currently running:

CODE
select * from v$session where type ='BACKGROUND';


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
paulogervasio
post Feb 9 2012, 08:13 PM
Post #4


Advanced Member
***

Group: Members
Posts: 69
Joined: 5-August 11
From: Brazil
Member No.: 45,669



Ok. Thanks! smile.gif
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 28th July 2014 - 11:23 AM