Shadow Process

[Former Member]

Hi

On my test box i have following: -

6 dialog work process

3 update process

2 update2 process

1 enqueue process

1 spool work process

2 Background Process

I read somewhere that for each R/3 work process u have correspond oracle shadow process in oracle which takes request from R/3 work process...

but whn i looked into ST04 -> Detailed Analysis -> Oracle Sessions

It shows me only 8 Shadow process

Please put some light on this issue.& How shadow work process works in R/3 System.

[Former Member · Accepted solution]

Oracle clients (that are programs using the oracle database) will not directly access the database files. They will initiate their database connection connecting to the ORACLE-Listener using tcp/ip communication.

The listener will create a so called Shadow process which then will connect to the Oracle Client program. Every database access of the Oracle Client is done through the shadow process.

There are alternativ communication methods (shared memory, pipe), SAP default is tcp/ip.

There are alternativ server configurations (dedicated server - each Oracle Client has it's own shadow process - shared server - several Oracle Clients will share one Oracle shadow process), SAP default is dedicated server.

On Windows we have a little different architecture: The shadow process is implemented in form of a shadow thread in the Oracle Service process.

in terms of SAP standard configuration, each workprocess, r3trans, tp, br*.exe has it's own shadow process / thread.

you can have a look at ST04, V$session for more information about which shadow process is serving which oracle client.

hope this helps.

regards

Peter

[Former Member · Accepted solution]

Thanks Peter

For such a valuable Information

I understand very well but it would be very helpful to me if u relate with the following example: -

Hi

On my test box i have following: -

6 dialog work process

3 update process

2 update2 process

1 enqueue process

1 spool work process

2 Background Process

I read somewhere that for each R/3 work process u have correspond oracle shadow process in oracle which takes request from R/3 work process...

but whn i looked into ST04 -> Detailed Analysis -> Oracle Sessions

It shows me only 8 Shadow process

Please put some light on this issue.& How shadow work process works in R/3 System.

[Former Member · Accepted solution]

HI Peter

Send me some more links to clear the picture of Shadow Process

As I come to know about Shadow Process but still i m unable to relate with the example.

for example i have 6 dialog work process,1 enqueue work process, 2 update work process, and all others executables like brtools, tp etc.

How many shadow process will be there on oracle (RDBMS Layer)

Thanks

[Former Member · Accepted solution]

This is the result (NW 2004s sr2), ST04n - detailed analysis - additional functions - display V$/GV$ Views and Values.

I don't think that any view will provide you with more information

Peter

[code]22.06.2007 Dynamic List Display 1

-

---

V$SESSION

-

---

Session address

SID

Sess. no.

Audit. SID

Process Address

ORA userID

Username

Command

Sess. ownr

State obj.

Lock addr.

Sess.Stat.

Servertype

Schema UID

Schemauser

OS UID

OS process

Serv.Name

Terminal

OS program name

Sess. type

SQL Statement ID

SQL hash

Prv.SQL ID

Prv.SQLhas

Module

Module hash

Action

Act. hash

Client inf

Fix.Table

RowWaitObj

DatafileID

Block ID

ROWID

Logontime

Last call

PDML_ENABL

Failov.Typ

Failover m

Failover

Res.Grp.

PDML stat.

PDDL stat

PQ status

Queue d.

Client ID

-

---

000007FF946587A0	61	3	211.717	000007FF945E74F8	26	SAPSR3	0	2.147.483.644			INACTIVE	DEDICATED	26	SAPSR3	NT5\SAPServiceNX0	3304:2972	NT5\WSI64163	WSI64163	disp+work.EXE	USER	0000000000000000	0	000007FF9074F5E0	1.246.922.211	disp+work.EXE	0		0	0	124	1-	0	0	0	22:-J:UN	1.957	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF94659C00	62	8	211.719	000007FF945E7D20	26	SAPSR3	0	2.147.483.644			INACTIVE	DEDICATED	26	SAPSR3	NT5\SAPServiceNX0	4660:3568	NT5\WSI64163	WSI64163	disp+work.EXE	USER	0000000000000000	0	000007FF9074F5E0	1.246.922.211	disp+work.EXE	0		0	0	124	1-	0	0	0	22:-J:UN	1.957	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF9465B060	63	2	211.713	000007FF945E64A8	26	SAPSR3	0	2.147.483.644			INACTIVE	DEDICATED	26	SAPSR3	NT5\SAPServiceNX0	4416:5860	NT5\WSI64163	WSI64163	disp+work.EXE	USER	0000000000000000	0	000007FF8FF90C38	3.957.147.849	SWNCCOLL	315.067.868	68	2.958.910.877	0	199	1-	0	0	0	22:-J:UN	1.454	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF9465C4C0	64	7	211.714	000007FF945E6CD0	26	SAPSR3	0	2.147.483.644			INACTIVE	DEDICATED	26	SAPSR3	NT5\SAPServiceNX0	5296:252	NT5\WSI64163	WSI64163	disp+work.EXE	USER	0000000000000000	0	000007FF9039FE40	641.251.005	SAPMSSY2	1.117.148.001	704	30.057.621	0	940	1-	0	0	0	22:-J:UN	740	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF9465D920	65	15	211.720	000007FF945E8548	26	SAPSR3	0	2.147.483.644			INACTIVE	DEDICATED	26	SAPSR3	NT5\SAPServiceNX0	5112:5096	NT5\WSI64163	WSI64163	disp+work.EXE	USER	0000000000000000	0	000007FF9074F5E0	1.246.922.211	disp+work.EXE	0		0	0	133	1-	0	0	0	22:-J:UN	1.957	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF9465ED80	66	7	211.711	000007FF945E5C80	26	SAPSR3	0	2.147.483.644			INACTIVE	DEDICATED	26	SAPSR3	NT5\SAPServiceNX0	4576:2524	NT5\WSI64163	WSI64163	disp+work.EXE	USER	0000000000000000	0	000007FF9074F5E0	1.246.922.211	disp+work.EXE	0		0	0	98	1-	0	0	0	22:-J:UN	1.957	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF946601E0	67	3	211.708	000007FF945E5458	26	SAPSR3	0	2.147.483.644			INACTIVE	DEDICATED	26	SAPSR3	NT5\SAPServiceNX0	5132:5392	NT5\WSI64163	WSI64163	disp+work.EXE	USER	0000000000000000	0	000007FF9039FE40	641.251.005	SAPMSSY2	1.117.148.001	704	30.057.621	0	6.326	49.589	11	107.205	0	22:-J:UN	20	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF94663F00	70	1	0	000007FF945E4C30	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2644	WSI64062	WSI64062	ORACLE.EXE (q001)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		49	1-	0	0	0	22:-J:UN	2.044	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF946667C0	72	10	211.706	000007FF945E33B8	26	SAPSR3	3	2.147.483.644			ACTIVE	DEDICATED	26	SAPSR3	NT5\SAPServiceNX0	4268:472	NT5\WSI64163	WSI64163	disp+work.EXE	USER	000007FF8E0E71D8	702.282.949	000007FF90953DB0	1.386.279.685	SAPLSTD8	2.312.801.962	33790	412.748.451	0	6.335	49.846	8	151.492	0	22:-J:UN	0	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF94667C20	73	9	4.294.967.295	000007FF945E3BE0	0	SYS	0	2.147.483.644			INACTIVE	DEDICATED	0	SYS	NT5\ofsuser	1752:2556	NT5\WSI64062	WSI64062	resrcmon.exe	USER	0000000000000000	0	000007FF90A54A48	4.144.549.743	resrcmon.exe	0		0		6.326	1-	0	0	0	22:-J:UN	18	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF94669080	74	2	0	000007FF945E4408	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2704	WSI64062	WSI64062	ORACLE.EXE (q000)	BACKGROUND	000007FF91ACB538	3.393.152.264	0000000000000000	0		0		0		49	1-	0	0	0	22:-J:UN	2.044	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF9466B940	76	1	0	000007FF945E2368	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	1504	WSI64062	WSI64062	ORACLE.EXE (QMNC)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.053	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF9466E200	78	13	211.704	000007FF945E2B90	26	SAPSR3	0	2.147.483.644			INACTIVE	DEDICATED	26	SAPSR3	NT5\SAPServiceNX0	5440:4284	NT5\WSI64163	WSI64163	disp+work.EXE	USER	0000000000000000	0	000007FF8F9E6400	3.866.745.156	SSFALRTEXP	3.183.728.855	114	3.881.667.982	0	5.921	9.987	11	2.882	0	22:-J:UN	37	NO	NONE	NONE	NO		DISABLED	ENABLED	ENABLED	0
000007FF94671F20	81	3	0	000007FF945E1B40	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2004	WSI64062	WSI64062	ORACLE.EXE (ARC1)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.056	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF94673380	82	3	0	000007FF945E1318	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2288	WSI64062	WSI64062	ORACLE.EXE (ARC0)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.056	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF94678500	86	1	0	000007FF945DFAA0	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2008	WSI64062	WSI64062	ORACLE.EXE (MMNL)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF94679960	87	1	0	000007FF945DF278	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2796	WSI64062	WSI64062	ORACLE.EXE (MMON)	BACKGROUND	000007FF91ACB538	3.393.152.264	0000000000000000	0		0		0		37	1-	0	0	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF9467ADC0	88	1	0	000007FF945DEA50	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2280	WSI64062	WSI64062	ORACLE.EXE (CJQ0)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	5.065	1	11.057	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF9467C220	89	1	0	000007FF945DE228	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2112	WSI64062	WSI64062	ORACLE.EXE (RECO)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF9467D680	90	1	0	000007FF945DDA00	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2612	WSI64062	WSI64062	ORACLE.EXE (SMON)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1	255	3	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF9467EAE0	91	1	0	000007FF945DD1D8	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	1112	WSI64062	WSI64062	ORACLE.EXE (CKPT)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF9467FF40	92	1	0	000007FF945DC9B0	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2868	WSI64062	WSI64062	ORACLE.EXE (LGWR)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF946813A0	93	1	0	000007FF945DC188	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2240	WSI64062	WSI64062	ORACLE.EXE (DBW0)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF94682800	94	1	0	000007FF945DB960	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	1928	WSI64062	WSI64062	ORACLE.EXE (MMAN)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF94683C60	95	1	0	000007FF945DB138	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2896	WSI64062	WSI64062	ORACLE.EXE (PSP0)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0
000007FF946850C0	96	1	0	000007FF945DA910	0		0	2.147.483.644			ACTIVE	DEDICATED	0	SYS	SYSTEM	2920	WSI64062	WSI64062	ORACLE.EXE (PMON)	BACKGROUND	0000000000000000	0	0000000000000000	0		0		0		0	1-	0	0	0	22:-J:UN	2.064	NO	NONE	NONE	NO		DISABLED	DISABLED	DISABLED	0

-

---

[/code]

[Former Member]

Are you using Windows?

[Former Member]

Yes i m using Windows server 2003

[Former Member]

Actually

I m unable to find my ans from that notes.

actually wt i know abt orcale that oracle has server session which act as a mediator between user process and oracle background process.

another work for sever process is to read from you datafile and put into database buffer cache.

now let me relate this to SAP. For each sap r/3 work process you have correspond shadow process in oracle.

how u'll going to decide abt how much shadow process u want?

we can say the oracle server process (if i talk abt oracle only) is same as the shadow process in oracle while using SAP.

Thanks

[former_member204746]

check SAP note 830576 if using Oracle 10g to know what values you must use for SESSIONS and PROCESSES.