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?
Oracle DatabaseUnix OS
Last Comment
Franck Pachot
8/22/2022 - Mon
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'.
Chakravarthi Ayyala
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.
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.
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?
slightwv (䄆 Netminder)
>>Can anyone give a few examples of the foreground processes?
We sort of have already: The user/app connections.
I would consider the connections to the database to be the foreground processes. I cannot think of what additional processes would be considered 'foreground'.