Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help, ORA-10980

Help, ORA-10980

From: joe bayer <joebayerii(no-spam)_at_hotmail.com>
Date: Thu, 30 Oct 2003 12:49:10 GMT
Message-ID: <aN7ob.46239$1C5.13013@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 - 06:49:10 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US