Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
- From: Yong Huang <yong321@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 9 May 2008 09:14:47 -0700 (PDT)
> In dedicated (where the statement(s) are slow) there are lots of wait
> events "fb contention".
>
> What can I do about that?
>
> Regards
> Martin
If dedicated config has FB contention while the shared server config has none
or little, it probably has to do with the Oracle PID of the process
(v$process.pid, not spid). That's something I never thought of! I think we can
do an experiment to verify. And to make the shared server behave the same as
dedicated, we can try event 10258 to let shared servers round robin (see "Force
session to migrate to a new shared server" at
http://yong321.freeshell.org/oranotes/SharedServerConfig.txt)
Your tablespace is ASSM? If my hypothesis correct, I think space allocation
using non-ASSM would still show the same difference between dedicated and
shared config if you have multiple freelists for the table you insert into
(just no FB contention, maybe HW instead).
Yong Huang
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--
//www.freelists.org/webpage/oracle-l
Other related posts:
