Thanx for reply,

Two tables you mentioned are showing records. Is there
any way I can know that my users are connecting to
dispatcher first? and not server directly.

v$circuit table specifies that only i.e vitual circuit
btw users through dispatcher to servers.

Not showing any thing.

Thanx,
BFN,
Jaimin.


--- "James C. Sy"
<cscjcs.ISTC.DLSU-[Email Address Removed] wrote: >
Hi, I think you should have records in V$DISPATCHER
> and
> V$SHARED_SERVER if MTS is up and running... Your
> parameters
> in initorcl.ora seem fine to me. Have you already
> bounced
> the instance? HTH
>
> Regards,
>
> James
>
> > Hi guru's,
> >
> > I have test database oracle 8 on windows NT.
> > I have added following MTS parameters in
> initorcl.ora
> > parameter file.
> >
> > mts_listener_address = "(ADDRESS = (PROTOCOL =
> > TCP)(HOST = 172.16.4.42)(PORT = 1521))"
> > mts_service = "ORAC"
> > mts_dispatchers = "(PROTOCOL = TCP)(HOST =
> > 172.16.4.42)(dispatchers=4)"
> > mts_max_dispatchers = 10
> > mts_servers = 2
> > mts_max_servers = 4
> >
> > How do I check Whether MTS is working fine.
> B'cause in
> > v$session "server" column shows "DEDICATED".
> > Also v$circuit table has no rows.
> >
> > Is there something I m missing?
> >
> >
> > BFN,
> > Jaimin.
> >
> >
>
____________________________________________________________
> > Do You Yahoo!?
> > Send a newsletter, share photos & files, conduct
> polls, organize chat events. Visit
> http://in.groups.yahoo.com
> >
> > --------
> > Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] > To subscribe: send a blank email to
> oracledba-[Email Address Removed] > Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> >
> >
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>

____________________________________________________________
Do You Yahoo!?
Send a newsletter, share photos & files, conduct polls, organize chat events. Visit http://in.groups.yahoo.com
Oracle LazyDBA home page