Hi all,
11.2.0.3
Redhat 5
I am going through architecture stuff and what i know is for one session connecting to database one dedicated server process is allocated.hence for each session there will be one process id on OS and one SID on oracle
But when i establish single connection from sql developer i see two process id and two sid. Can somebody through light on this.
oracle 5847 1 0 Sep25 ? 00:00:02 ora_i104_dev
oracle 5851 1 0 Sep25 ? 00:00:02 ora_i105_dev
oracle 5855 1 0 Sep25 ? 00:00:02 ora_i106_dev
oracle 5859 1 0 Sep25 ? 00:00:01 ora_i107_dev
oracle 5863 1 0 Sep25 ? 00:00:01 ora_i108_dev
oracle 5867 1 0 Sep25 ? 00:00:01 ora_i109_dev
oracle 5871 1 0 Sep25 ? 00:00:01 ora_i10a_dev
oracle 5875 1 0 Sep25 ? 00:00:01 ora_i10b_dev
oracle 5879 1 0 Sep25 ? 00:00:01 ora_i10c_dev
oracle 5883 1 0 Sep25 ? 00:00:01 ora_i10d_dev
oracle 5887 1 0 Sep25 ? 00:00:01 ora_i10e_dev
oracle 5891 1 0 Sep25 ? 00:00:01 ora_i10f_dev
oracle 5895 1 0 Sep25 ? 00:00:01 ora_i10g_dev
oracle 5962 1 0 Sep25 ? 00:00:02 ora_smco_dev
oracle 22034 1 0 01:33 ? 00:00:00 /u01/app/oracle/product/11.2.0.3/db1/bin/tnslsnr listener -inherit
root 22132 3202 0 01:37 ? 00:00:00 sshd: oracle [priv]
oracle 22136 22132 0 01:38 ? 00:00:00 sshd: oracle@pts/1
oracle 22137 22136 0 01:38 pts/1 00:00:00 -bash
root 22162 3202 0 01:38 ? 00:00:00 sshd: oracle [priv]
oracle 22166 22162 0 01:38 ? 00:00:00 sshd: oracle@pts/2
oracle 22167 22166 0 01:38 pts/2 00:00:00 -bash
oracle 22189 22167 0 01:38 pts/2 00:00:00 sqlplus as sysdba
oracle 22192 22189 0 01:38 ? 00:00:00 oracledev (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 22228 1 0 01:40 ? 00:00:01 oracledev (LOCAL=NO)
oracle 22234 1 0 01:40 ? 00:00:04 oracledev (LOCAL=NO) (***** This is from the sqldeveloper********)
root 22697 3202 0 02:19 ? 00:00:00 sshd: oracle [priv]
oracle 22702 22697 0 02:19 ? 00:00:00 sshd: oracle@pts/3
oracle 22703 22702 0 02:19 pts/3 00:00:00 -bash
oracle 22795 1 0 02:23 ? 00:00:00 ora_w000_dev
oracle 22865 1 0 02:29 ? 00:00:00 ora_j000_dev
oracle 22869 1 0 02:29 ? 00:00:00 ora_j001_dev
oracle 22872 22703 0 02:30 pts/3 00:00:00 ps -eaf
oracle 22873 22703 0 02:30 pts/3 00:00:00 grep ora
As from above there are two process id for oracledev after i connected from sqldeveloper.While local connection for same schema from OS spawns only single Process.