this looks like an oracle bug that could be resolved by granting some extra
privs -- search for ORA-10980 on MetaLink, there're a few articles that
might give you some insight
"joe bayer" <joebayerii(no-spam)@hotmail.com> wrote in message
news:aN7ob.46239$1C5.13013_at_nwrdny02.gnilink.net...
> We are using 9.2.0.2.0 on linux.
>
> One of our datawarehouse application will hang indefinately on
> dbms_mview.refresh. The trace file shows ORA-10980. The problem can be
> solved by issue "alter system flush shared_pool" each time before the
> refresh.
>
> Does anybody have the similiar experience?
>
> Thanks for your hlep.
>
>
Received on Thu Oct 30 2003 - 09:07:37 CST
