Re: How to check mts?

Re: How to check mts?

 

  

Jaimin,

The SERVER column in V$SESSION will show whether the
connection is shared (i.e. MTS) or dedicated.

HTH,

-- Anita

--- Jaimin Desai <[Email Address Removed] wrote:
> 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
>


__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
Oracle LazyDBA home page