Re: create a view with parallel hint
From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 29 Mar 2008 05:51:39 -0700 (PDT)
Message-ID: <825122.95485.qm@web80608.mail.mud.yahoo.com>
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
Date: Sat, 29 Mar 2008 05:51:39 -0700 (PDT)
Message-ID: <825122.95485.qm@web80608.mail.mud.yahoo.com>
>> I can't change the tables parallelism,.. too much impact on the rest
>> of the system. Too risky.
>
> How about you change the table parallel degree right before you submit the
> report job and immediately change it to noparallel after it? You just need to
Correction to my message. If the query is running, attempting to change the table to noparallel would just hang on library cache lock. The same is true for its index.
Nobody has mentioned "alter session force parallel query". It works even though the table and index involved are noparallel and no hint exists in the SQL. If you can't inject this SQL to Crystal Reports, use a logon trigger, even temporarily.
Yong Huang
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Mar 29 2008 - 07:51:39 CDT