Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
- From: "Rajeev Prabhakar" <rprabha01@xxxxxxxxx>
- To: usn@xxxxxxxxx
- Date: Fri, 25 Apr 2008 08:18:21 -0400
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@xxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
