Re: create a view with parallel hint
From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 28 Mar 2008 07:56:01 -0700 (PDT)
Message-ID: <869900.18031.qm@web80608.mail.mud.yahoo.com>
Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs
Date: Fri, 28 Mar 2008 07:56:01 -0700 (PDT)
Message-ID: <869900.18031.qm@web80608.mail.mud.yahoo.com>
> I can't change the tables parallelism,.. too much impact on the rest
> of the system. Too risky.
Tony,
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 fool the CBO into thinking the table is paralleled during parsing. The impact would be limited to the SQLs freshly parsed during that few second window (so they also thought the table was parallel), as well as causing some hard parses later for other SQLs (but they get the original plans).
Not directly related to this. If you pull a lot of data across wire, make sure you increase arraysize (Fetch Buffer Size in ODBC). It makes dramatic improvement.
Yong Huang
Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 28 2008 - 09:56:01 CDT