Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)

From: Martin Klier <usn@xxxxxxxxx>
To: Yong Huang <yong321@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 23 Apr 2008 19:48:57 +0200

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

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
From: krish.hariharan

Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)

Other related posts: