Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newsfeed1.earthlink.net!newsfeed.earthlink.net!sjc70.webusenet.com!news.webusenet.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news2.calgary.shaw.ca.POSTED!not-for-mail X-Trace-PostClient-IP: 24.80.236.234 From: Peter Newsgroups: comp.databases.oracle.misc Subject: Re: Difference between dispatchers connections and sessions Organization: Bright Message-ID: References: X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 44 Date: Fri, 06 Jun 2003 07:25:45 GMT NNTP-Posting-Host: 24.69.255.232 X-Complaints-To: abuse@shaw.ca X-Trace: news2.calgary.shaw.ca 1054884345 24.69.255.232 (Fri, 06 Jun 2003 01:25:45 MDT) NNTP-Posting-Date: Fri, 06 Jun 2003 01:25:45 MDT Xref: core-easynews comp.databases.oracle.misc:98436 X-Received-Date: Fri, 06 Jun 2003 00:26:29 MST (news.easynews.com) On Fri, 06 Jun 2003 06:08:37 +0200, Sybrand Bakker wrote: >On Fri, 06 Jun 2003 03:12:58 GMT, Peter >wrote: > >>I have this dispatcher parameter that I like to set up. >>What is the difference between dispatcher connections and sessions? >>Are the sessions referring to user sessions? Are the connections >>actual connections to the instance? I need some clarifications. >> >>dispatchers="(protocol=tcp)(dispatchers=2)(pool=on)(connections=100)(sessions=200)" >> >> >>Thanks >> >> >> > >Again and again and again and again you are asking the obvious. >YES connections ARE the actual connection, as it DOES read in the >manual. >NO session aren't user sessions. The ESSENCE of SHARED SERVER is that >a SINGLE user session CAN and will be handled by MULTIPLE shared >servers on the database server. That's why it is also UNSUITED for >long running queries. > But then if I included the dispatchers and shared_servers parameters in my init file and then restart my instance and then run show parameter dispatchers and show parameter shared_servers it showed that both of these parameters were not even set. Why is that? How do I set them properly? did I miss something? Thanks