Re: How to check mts?

Re: How to check mts?

 

  

I am sorry but I am not familiar with the V$CIRCUIT object.
From where are your users connecting? If they are connecting
from the same machine as the Oracle instance, your TCP dispatcher
may not be used because Oracle may either use the IPC or
BEQ adapter to connect to the instance. If they are connecting
via TCP protocol from client PCs, one factor (I can think of) that
will cause ORACLE not to use the MTS is that the tnsnames.ora of
your client PCs have the (SRVR=DEDICATED) parameter, which
automatically forces SQL*NET to use a DEDICATED connection. HTH

Regards,

James

> 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 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 LazyDBA home page