Oracle foreground processes

Posted on 2012-12-28
Last Modified: 2013-01-07
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?
Question by:YZlat
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38728273
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'.

Expert Comment

ID: 38728608

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.
LVL 15

Accepted Solution

Franck Pachot earned 250 total points
ID: 38729213
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...
LVL 23

Expert Comment

ID: 38729492
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.
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

LVL 34

Expert Comment

by:Mark Geerlings
ID: 38730246
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.
LVL 35

Author Comment

ID: 38736405
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?
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38736438
>>Can anyone give a few examples of the foreground processes?

We sort of have already:  The user/app connections.
LVL 15

Assisted Solution

by:Franck Pachot
Franck Pachot earned 250 total points
ID: 38736608
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.

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now