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

From: Martin Klier <usn_at_usn-it.de>
Date: Tue, 22 Apr 2008 17:23:29 +0200
Message-ID: <480E02F1.7020006@usn-it.de>

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 Received on Tue Apr 22 2008 - 10:23:29 CDT

This message: [ Message body ]
Next message: Hemant K Chitale: "Re: <URGENT> How do I recover when the UNDO tablespace data file is corrupt? </URGENT>"
Previous message: Yong Huang: "Re: enq HW - contention waits"
Next in thread: krish.hariharan_at_quasardb.com: "RE: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)"
Reply: krish.hariharan_at_quasardb.com: "RE: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)"
Reply: ��: "Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)"
Maybe reply: Martin Klier: "Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)"
Reply: Rajeev Prabhakar: "Re: Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message