Re: Can multithreaded server and dedicated server be in one instance?

From: I.A. Saez <_at_tue.nl>
Date: Mon, 16 Oct 2000 07:44:59 +0200
Message-ID: <39EA95DB.6F12DC6B@tue.nl>

Dave,

If you are using Oracle 8.1.6 on a OpenVMS system then you have to use a mix of mts and dedicated servers. Long running applications like reports will take a lot longer to finish in mts mode. 400 % longer is "normal". We discovered this problem in Oracle 7.3.4 and Oracle support told us the bug still exists in 8.1.6. As work-around we did difined an alias connect string in which the connection is dedicated. We had to adapt some db_links and applications (minor changes though).
Short connections find benefit in using mts. Especially on an OpenVMS environment where process creation is expensive. This is an example of a tnsnames.ora file with an alias:

################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world

# Date..........: 08-SEP-00 12:43:22

################

datab_dedicated.tue.nl =
  (DESCRIPTION =

        (ADDRESS =


          (COMMUNITY = TCP.world)

          (PROTOCOL = TCP)

          (Host = machine.tue.nl)

          (Port = 1566)

        )
      (CONNECT_DATA =
        (SID = OWISDB)
           (SERVER = DEDICATED)
           (GLOBAL_NAME = datab.tue.nl)
      )

  )

kind regards,

Ivan
Dave A wrote:

> 
> I have seen this term *plonk* and *plonker* all over the place, could
> someone define it for me?(yeah, I know it has nothing to do with Oracle)
> And thank you everyone for your response.  Perhaps my follow up question
> should be has anyone experienced any significant problems or bugs using MTS?
> I've never used it before.  Of course I will check Metalink and read the
> documentation, but your experiences are valuable as well. The Oracle version
> will be 8.1.6.2
> --
> Dave A
> 
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:39e83771_at_news.iprimus.com.au...
> > You're quite right, of course, and I'm a plonker.
> >
> > Clearly, an incoming cold front and associated brain storms.
> >
> > My apologies for the error (and the slipped mind)
> >
> > Regards
> > HJR
> > --
> > --------------------------------------------------------------------------
> > Opinions expressed are my own, and not those of Oracle Corporation
> > Oracle DBA Resources:               http://www.geocities.com/howardjr2000
> > --------------------------------------------------------------------------
> >
> > <sybrandb_at_my-deja.com> wrote in message

 news:8s93gd$6c3$1_at_nnrp1.deja.com...

> > > You are correct
> > > either add (server=dedicated) after (port=)
> > > or include
> > > use_dedicated_server=true
> > > in sqlnet.ora
> > >
> > > Regards,
> > >
> > > Sybrand Bakker, Oracle DBA
> > >
> > >
> > >
> > >
> > > In article <8s8p2p$1i21_at_imsp212.netvigator.com>,
> > >   "kcwang" <kcwang_at_unitechnetworks.com> wrote:
> > > > If your database is configured as MTS, all default incoming requests

 will be
> > > > dispatches to MTS except the requests that specified it wants a  dedicated

> > > > connection. you should be able to specify this in the tnsnames.ora...
> > > > correct me if I am wrong..
> > > >
> > > > Howard J. Rogers <howardjr_at_www.com> wrote in message
> > > > news:39e7e1b5$1_at_news.iprimus.com.au...
> > > > > Different instances.  Not possible any other way
> > > > > Regards
> > > > > HJR
> > > > > --
> > > > > --------------------------------------------------------------------

---

> > > > > Opinions expressed are my own, and not those of Oracle Corporation > > > > > Oracle DBA Resources:
 http://www.geocities.com/howardjr2000

> > > > > --------------------------------------------------------------------

---

> > > > >
> > > > > "Dave A" <dave_and_vanna_at_hotmail.com> wrote in message
> > > > > news:sufnd4e3p24r0b_at_corp.supernews.com...
> > > > > > Hi,
> > > > > >
> > > > > > I have a database with 2 schemas.  One schema supports web users

 and
 gets
> > > > > > about 10 connections per second. The other schema supports an  app that
 has
> > > > > > 70-100 persistent connections. I would like the web users to  connect to
 MTS
> > > > > > and others to have a dedicated server. If this possible or do I  need to

> > > > > > move the web users to a separate instance?
> > > > > >
> > > > > > --
> > > > > > Dave A
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > > --
> > > Sybrand Bakker, Oracle DBA
> > >
> > > All standard disclaimers apply
> > > ------------------------------------------------------------------------
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >

Received on Mon Oct 16 2000 - 00:44:59 CDT