Dedicated or Shared Sessions?
544217Dec 5 2007 — edited Dec 9 2007I have a 10g SE1 + ASM running in Windows 2003 ES with 4GB RAM with /3GB switch and 7TB JBOD storage. Our custom data mining applications access this database from a grid of 15 servers. Application architecture uses a mixture of hibernate, roll-your-own connection pooling in Java, and daemons with dedicated sessions. In all, we typically have 200 sessions but only 3 to 9 are active at any given moment. Individual queries and transactions range from sub-second to 3 hours in duration.
I’ve run the system with MTS and in dedicated server mode; it runs either way. I have never tried tweaking multiple shared_servers, dispatchers or circuits.
Right now it seems to run fine with 200 dedicated sessions, but it does gobble up a lot of unused PGA memory for the inactive sessions.
In our situation, what is the best configuration, MTS, or shared, or dedicated, and why?