Home » RDBMS Server » Networking and Gateways » Dedicated server connection (Oracle 11g)
Dedicated server connection [message #580663] Tue, 26 March 2013 13:20 Go to next message
ashwani0301
Messages: 44
Registered: March 2013
Location: Karnatka, Bangalore
Member
If my database server is running in Dedicated server mode ,
I have assigned permission to user,
that a user can create maxinum two sessions, suppose a user
creates two session , how many server process will be spawn by listener process ??? Shocked
Re: Dedicated server connection [message #580664 is a reply to message #580663] Tue, 26 March 2013 13:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
2

Regards
Michel
Re: Dedicated server connection [message #580670 is a reply to message #580664] Tue, 26 March 2013 14:18 Go to previous messageGo to next message
ashwani0301
Messages: 44
Registered: March 2013
Location: Karnatka, Bangalore
Member
How do we come to know that, two server processes have created ??

[Updated on: Tue, 26 March 2013 14:24]

Report message to a moderator

Re: Dedicated server connection [message #580671 is a reply to message #580670] Tue, 26 March 2013 14:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Query v$session.

Regards
Michel
Re: Dedicated server connection [message #580672 is a reply to message #580671] Tue, 26 March 2013 14:25 Go to previous messageGo to next message
ashwani0301
Messages: 44
Registered: March 2013
Location: Karnatka, Bangalore
Member
sorry I have just edited it
Re: Dedicated server connection [message #580673 is a reply to message #580672] Tue, 26 March 2013 14:28 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Join v$session and v$process.

Regards
Michel
Previous Topic: Network issue
Next Topic: Client and database Server on same machine
Goto Forum:
  


Current Time: Thu Nov 21 22:55:42 CST 2024