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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 8 May 2008 16:17:43 +0100
Message-ID: <7765c8970805080817r70f1ed8rcfa09888a3426fb8@mail.gmail.com>


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_at_usn-it.de>:

> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 08 2008 - 10:17:43 CDT

Original text of this message