Oracle foreground processes

YZlat
YZlat used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

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'.
Chakravarthi AyyalaDatabase Administrator

Commented:
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.
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.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

David VanZandtOracle Database Administrator III

Commented:
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.
Mark GeerlingsDatabase Administrator

Commented:
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.

Author

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?
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>Can anyone give a few examples of the foreground processes?

We sort of have already:  The user/app connections.
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial