Link to home
Create AccountLog in
Avatar of YZlat
YZlatFlag for United States of America

asked on

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?
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

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'.
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.
ASKER CERTIFIED SOLUTION
Avatar of Franck Pachot
Franck Pachot
Flag of Switzerland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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.
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.
Avatar of YZlat

ASKER

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?
>>Can anyone give a few examples of the foreground processes?

We sort of have already:  The user/app connections.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account