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

Original text of this message