MTS & Oracle 7.2 on NT
Date: 1996/04/27
Message-ID: <4ltfsp$fjj_at_goodnews.voicenet.com>#1/1
I'm a (still) aspiring DBA, trying to get a handle on Multi Threaded
Server. My system has been running for a little while, and people can
connect and all of that, but I will be seeing increasing amounts of
traffic in an OLTP-type application soon and since I've been reading
about MTS I thought I would take something that isn't exactly broken
(yet) and try to fix it....
Anyway:
I took my test database, which is running SQL*Net 2.2, and added the
MTS_* parameters mentioned in the Server Administrator's guide to it's
parameter file. I then restarted the database, expecting the DB to be
running with MTS. Maybe it is. Maybe it isn't. How can I tell?
If I do a "lsnrctl status" or a "lsnrctl services", I seem to get the
same displays as I did before, if I connect from a client on another
machine, "lsnrctl services" indicates that I started a dedicated
server process with my connect.
Did I miss something? Do I need to alter my sqlnet configuration with
Network Manager, somehow? Do I just not have a mental grip on how MTS
works?
Further, I will have one or two users that will be very active (lots
of near-continuous action) on the DB, as opposed the the low-intensity
OLTP application users. How can I have the high-intensity users
connect to a dedicated server process, and the low-intensity users
connect to a MTS-type of process?
-darin!