Execution time in SHARED SERVER vs. DEDICATED SERVER (RAC 10gR2)
- From: Martin Klier <usn@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 22 Apr 2008 17:23:29 +0200
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
Other related posts:
