Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2715
  • Last Modified:

Oracle foreground processes

Can someone give me some examples of the most important Oracle foreground processes?

For example some of the Oracle background processes are DBWR, LGWR,  PMON and SMON.

What about foreground processes?
0
YZlat
Asked:
YZlat
2 Solutions
 
slightwv (䄆 Netminder) Commented:
Where did you come across that term in relation to Oracle databases?

I would consider the connections to the database to be the foreground processes.  I cannot think of what additional processes would be considered 'foreground'.
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
YZlat:

In addtion to what slightwv posted above, one example i could think of an dm/dw processes that will be started for data pump operations?
Not sure whether you are asking about them.
0
 
Franck PachotCommented:
Hi,
As foreground processes are those that serve your user sessions, the most important one is the one for your most important session. No one are mandatory for the database. But your application needs them...
Regards,
Franck.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
DavidSenior Oracle Database AdministratorCommented:
I was surprised that a Google search actually showed foreground references -- such as the ones already explained.  How about this answer:  they are the remaining processes that are not considered background.
0
 
Mark GeerlingsDatabase AdministratorCommented:
There are no foreground processes for Oracle on the database server, because Oracle just uses background processes on the database server.  On your client or application server, there can be foreground processes for user interaction with the database.
0
 
YZlatAuthor Commented:
The term came from my superviser. He told me to look into background and foreground processes.

Can anyone give a few examples of the foreground processes?
0
 
slightwv (䄆 Netminder) Commented:
>>Can anyone give a few examples of the foreground processes?

We sort of have already:  The user/app connections.
0
 
Franck PachotCommented:
Hi,
Select * from V$PROCESS where BACKGROUND is null will give you all foreground processes.
You have nothing to monitor about them: the oracle pmon background process is doing that for you.
Regards,
Franck.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now