Re: What is difference between processes and sessions?

An Oracle database running on a server consists of several background processes :

lgwr (log writer)
dbwr (database writer)
pmon (process monitor)
smon (session monitor)
reco (recovery)
ckpt (checkpoint)

Moreover, each time a user connects hence starts a new session, a new process is created. A session can be therefore considered as a particular type of process.

The best way to view the list of processes related to your database (including background processes and session processes) is, if your DB is running on an UNIX machine :

ps -ef | grep oracle

ora_pmon_xxxx
ora_lgwr_xxxx
ora_dbwr_xxxx
ora_ckpt_xxxx
ora_smon_xxxx
ora_reco_xxxx

are the background processes ;

oraclexxxx

are the session processes.

Violin <violin.hsiao_at_mail.pouchen.com.tw> a écrit dans l'article <38872a95.6177562_at_172.16.7.5>...
> Hello,
>
> In INITxxxx.ORA there are two parameter processes and sessions.
> What is differenece?
> Need some explanation.
>
> Best Regards.
>
> Violin.
> violin.hsiao_at_mail.pouchen.com.tw
>
Received on Wed Jan 19 2000 - 04:45:57 CST