Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
Date: Fri, 25 Apr 2008 08:18:21 -0400
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.
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