Skip to Main Content
  • Questions

  • how to identify whether the database run as a shared server mode

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, ezio.

Asked: September 18, 2015 - 5:48 am UTC

Last updated: September 21, 2015 - 4:19 am UTC

Version: oracle 9i

Viewed 1000+ times

You Asked

Hi:
I mentioned this days that my server's cpu utilization is very high,the top process is ora_d00_$ORACLE_SID that is a shared server process.
So i want to know whether my database run as a shared server and how to close it.
1.the value of shared_servers is 1.
2.the value of dispatchers is '(PROTOCOL=TCP) (SERVICE=mescpXDB)'

THX

and Chris said...

If the value of shared_servers is greater than 0, then you're in shared server mode.

To disable it, just set the value to 0.

For further information, read:

http://docs.oracle.com/cd/B10501_01/server.920/a96521/manproc.htm#ADMIN005

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

ezio, September 18, 2015 - 10:00 am UTC

Thanks for answer.
As i said above,the cpu utilization is high of this process,is there any idea to troubleshoot it.just like v$session etc.
at last,the shared pool of my database 1G, the db_cache is 1G,sga is 3.5G. the session count is less than 100. Can you give a suggestion whether should i use the shared server mode.


Chris Saxon
September 21, 2015 - 4:19 am UTC

From the database, you could trace the session using dbms_monitor
From the OS, you could use truss, strace or Dtrace.

My observation has been shared server mode is used only in very exceptional cases, where you have potentially thousands of database connections. Most applications nowadays dont need it, because their connection pooling is doing in the middle tier, or if they dont support it, via universal connection pooling.

Some Oracle facilities use shared server mode (some xmldb and apex via epg and the like) because they are serving browser clients directly, but other than that, I'd be suprised if you need it.

Hope this helps.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.