Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
Date: Tue, 22 Apr 2008 17:23:29 +0200
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
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