Re: Newbie Oracle Development Question
Date: Mon, 24 May 2004 15:39:33 GMT
Message-ID: <VGosc.17196$hi6.1663959_at_attbi_s53>
"CGreg" <cgregory916_at_yahoo.com> wrote in message
news:fd693bab.0405240542.507d4f5d_at_posting.google.com...
> Hi, guys. I've run into a situation at work, just started not so long
> ago, and I'm trying to figure out what is going on behind the scenes.
> This place has the instance in question running in dedicated server
> mode. Well, it's the backend to a webapp that uses the same
> username/login to fulfill each of the 100's of users sql requests.
> That having been said, is the same dedicated server process handling
> ALL of the requests? If that's the case then would changing it to a
> MTS mode make any difference seeing as how the same username/login is
> used for each request? I'd appreciate anyone's help. Thank you.
No, each login has its own dedicated server process. MTS might make it worse. Good question though. You should be able to see each process on the server where Oracle is running or do a select * from v$session; and you will see seperate rows even though the username is the same. Jim Received on Mon May 24 2004 - 17:39:33 CEST