Welcome Guest
(
Log In
|
Register
)
Oracle DBA Forums
>
Oracle
>
Oracle Forum
List all process description
Options
paulogervasio
View Member Profile
Feb 9 2012, 09:52 AM
Post
#1
Advanced Member
Group: Members
Posts: 68
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.
paulogervasio
View Member Profile
Feb 9 2012, 12:27 PM
Post
#2
Advanced Member
Group: Members
Posts: 68
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.
burleson
View Member Profile
Feb 9 2012, 02:34 PM
Post
#3
Advanced Member
Group: Members
Posts: 10,373
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
paulogervasio
View Member Profile
Feb 9 2012, 08:13 PM
Post
#4
Advanced Member
Group: Members
Posts: 68
Joined: 5-August 11
From: Brazil
Member No.: 45,669
Ok. Thanks!
« Next Oldest
·
Oracle Forum
·
Next Newest »
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
Forum Home
Search
Help
Oracle
|-- Oracle Forum
Display Mode:
Standard
·
Switch to: Linear+
·
Switch to: Outline
Track this topic
·
Email this topic
·
Print this topic
·
Subscribe to this forum
Lo-Fi Version
Time is now: 25th May 2013 - 06:03 PM
Powered By
IP.Board
2.3.6 © 2013
IPS, Inc
.