Avatar of YZlat
YZlat
Flag 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?
Oracle DatabaseUnix OS

Avatar of undefined
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.
ASKER CERTIFIED SOLUTION
Franck Pachot

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
David VanZandt

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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Mark Geerlings

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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Franck Pachot

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.