RE: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
- From: <krish.hariharan@xxxxxxxxxxxx>
- To: <usn@xxxxxxxxx>, "'Yong Huang'" <yong321@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Apr 2008 16:09:31 -0600
I missed that mark completely - I interpreted the 1:30 to mean an hour 30
and missed the "1:30 min" in the original post. I have generally seen that
behaviour only when you have a lot of requests coming in and it takes a
while to create the process and consequently the shared server tends to be
substantially faster.
I would think that there would be other symptoms, should this be the case -
a simple sqlplus session should take a long while to create and execute as
well. Or high CPU utilization in the dedicated server mode vs shared.
The other aspect that could be factoring in with a shared server is
connection pooling and multiplexing which from what I remember kicks in when
you are in Shared Server mode with connections coming in from the same node.
... a long shot
-Krish
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Martin Klier
Sent: Wednesday, April 23, 2008 11:49 AM
To: Yong Huang; oracle-l
Subject: Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC
10gR2)
Hi,
Yong Huang schrieb:
> Execution in shared server is even faster than dedicated? Not the other
way
> around?
No, shared is faster, dedicated is factors of 10 slower. Other way round
I wouldn't have messed around, nobody wants to execute this statements
in shared server mode - we found out about shared mode "by accident"
when we tried this from our web server and it was faster there.
> What're the major wait events for the session in both cases?
90% of the time: CPU. In shared mode for seconds, in dedicated mode for
hours. ADDM via Grid Control didn't find anything smelly.
Any ideas out of that? I am stumped at the moment :(
Thanks
Martin
--
Usn's IT Blog for Linux, Oracle, Asterisk
www.usn-it.de
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
