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

Hello Martin,

Have you confirmed the timings of shared vs. dedicated connection thru sqlplus session (not through application server OR webserver). Does sqlplus query execution timings still shows 1:30 minute and 1 hr respectively ?

I understand that tracing could be done, however, before you embark upon that exercise, a basic test via sqlplus would surely rule out middle tier (application server/web server) being the contributing factor.

-Rajeev

On Tue, Apr 22, 2008 at 11:23 AM, Martin Klier <usn_at_usn-it.de> wrote:
> Dear list,
>
> Is there a difference in executing a query in dedicated vs. shared
> server connection?
>
> The query plans are the same, but in shared server the query runs 1:30
> min, and in dedicated mode over an hour. This is repeatable every time,
> and affects many queries or inserts/merges as well.
>
> Am I missing something, or is there any know issue with that?
>
> Regards and thanks in advance
> Martin Klier
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> www.usn-it.de
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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