From: kennedy-downwithspammersfamily@attbi.net   
      
   "CGreg"  wrote in message   
   news:fd693bab.0405240542.507d4f5d@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)