Newbie Oracle Development Question

[CGreg]

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.

[Jim Kennedy]

Re: Newbie Oracle Development Question


"CGreg" <cgregory916@ya hoo.comwrote in message
news:fd693bab.0 405240542.507d4 f5d@posting.goo gle.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