Oracle Database - Background Process

Card Puncher Data Processing

About

Persistent processes that make up an instance.

This background processes are started from Linux/Windows with the help of only one binary executable program named oracle.

The background process are then threads of the oracle executable.

A background process is defined as any process that is listed in VPROCESS and has a non-null value in the pname column.

Configuration

See the PROCESSES parameter

How to get the Oracle process?

On Linux

ps -u oracle -f
UID        PID  PPID  C STIME TTY          TIME CMD
---------------------------------------------------------------
oracle   29608     1  0 15:52 ?        00:00:00 ora_pmon_oel11g
oracle   29610     1  0 15:52 ?        00:00:00 ora_vktm_oel11g
oracle   29614     1  0 15:52 ?        00:00:00 ora_gen0_oel11g
oracle   29616     1  0 15:52 ?        00:00:00 ora_diag_oel11g
oracle   29618     1  0 15:52 ?        00:00:00 ora_dbrm_oel11g
oracle   29620     1  0 15:52 ?        00:00:00 ora_psp0_oel11g
oracle   29622     1  0 15:52 ?        00:00:00 ora_dia0_oel11g
oracle   29624     1  2 15:52 ?        00:00:02 ora_mman_oel11g
oracle   29626     1  0 15:52 ?        00:00:00 ora_dbw0_oel11g
oracle   29628     1  0 15:52 ?        00:00:00 ora_lgwr_oel11g
oracle   29630     1  0 15:52 ?        00:00:00 ora_ckpt_oel11g
oracle   29632     1  0 15:52 ?        00:00:00 ora_smon_oel11g
oracle   29634     1  0 15:52 ?        00:00:00 ora_reco_oel11g
oracle   29636     1  0 15:52 ?        00:00:00 ora_mmon_oel11g
oracle   29638     1  0 15:52 ?        00:00:00 ora_mmnl_oel11g
oracle   29640     1  0 15:52 ?        00:00:00 ora_d000_oel11g
oracle   29642     1  0 15:52 ?        00:00:00 ora_s000_oel11g
---------------------------------------------------------------

On Windows

pslist oracle
pslist -d oracle

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - Database Writer Process (DBWn)

Database writer process (DBWn) is a background process that writes buffers in the database buffer cache to data files. Modified or new data is not necessarily written to a datafile immediately. To reduce...
Oracle Database One Instance By Database
Oracle Database - Instance (Database Start-up)

When you start a database, an instance is created. An instance is comprised of: a memory area called the System Global Area (SGA) and Oracle background processes. The memory and processes of an...
Card Puncher Data Processing
Oracle Database - Memory manager (MMAN)

Memory manager is a background process.
Oracle Database Connection Manager
Oracle Database - Oracle Connection Manager

Oracle Connection Manager is a gateway through which client connection requests are sent either to the next hop or directly to the database server. Clients who relay connection requests through an Oracle...
Card Puncher Data Processing
Oracle Database - PMON process

A process monitor database process that performs process recovery when a user process fails. PMON is responsible for cleaning up the cache and freeing resources that the process was using. PMON also checks...
Card Puncher Data Processing
Oracle Database - Trace File (.trc)

Trace File are trace (or dump) file that Oracle Database creates to help you diagnose and resolve operating problems. Each server and background process writes to a trace file. When a process detects...
Timesten   Cache Grid Relation With Oracle And Tt Database
Timesten - Cache Grid

A TimesTen cache grid provides a means to horizontally scale out cache groups across multiple systems with: read and write data consistency across the TimesTen databases and predictable latency for...



Share this page:
Follow us:
Task Runner