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

From: Martin Klier <>
Date: Thu, 08 May 2008 15:42:29 +0200
Message-ID: <>


sorry for the waiting time, but there has been some mess around.

> 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?


Usn's IT Blog for Linux, Oracle, Asterisk

Received on Thu May 08 2008 - 08:42:29 CDT

Original text of this message