Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: usn@xxxxxxxxx
- Date: Thu, 8 May 2008 16:17:43 +0100
well the format block enqueue ("enq: fb contention") is related to grabbing
new blocks in ASSM tablespaces, during an insert operation for example. It
might be a good idea at this point to find out what the 'query' is that you
are actually doing and if it is happening in parallel etc. Incidentally are
both of these queries on the one system, or is one PROD and one UAT?
Niall
2008/5/8 Martin Klier <usn@xxxxxxxxx>:
> Hi,
>
> sorry for the waiting time, but there has been some mess around.
>
> 조동욱 schrieb:
> > 10046 trace(above level 8) and/or 10053 trace would be a good start
> point.
> > If nothing valuable is found by comparison, next step would be searching
> > metalink.
>
> There IS a difference in tracing on events 10046 and 10053 level 8 each
> between shared and dedicated. So far: Good hint!
>
> In dedicated (where the statement(s) are slow) there are lots of wait
> events "fb contention".
>
> What can I do about that?
>
> Regards
> Martin
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> www.usn-it.de
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
