| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 8.1.7.0 :join with parallel and big sort
Can you help me?
I have a query , where i join a big partitioned table with 2 smaller tables
using hash join and sort group by.
I want to use to read the big partitioned table with parallel-option to get
better performance.
But i havn't any performance benefits running with parallel or without parallel!!
On Metalink i found Doc-id 212644.995 with following information: run the explain plan and confirm there is no PARALLEL_FROM_SERIAL , they are big bottlenecks.
Do you know something about such problems with parallel? Have you also problems with parallel and big sorts?
Thank for any help!!
Best regards,
Brigitte T¨¹rk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Brigitte.Tuerk_at_kaufhof.de
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Aug 20 2002 - 07:38:21 CDT
 |
 |