Re: create a view with parallel hint

  • From: Yong Huang <yong321@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 28 Mar 2008 07:56:01 -0700 (PDT)

> 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
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

Yong Huang

Never miss a thing.  Make Yahoo your home page.

Other related posts: