This is not a permanent solution though. Take a look at patch 3314850, which fixes the issue. I am in Rochester, NY; a few hours drive from Toronto. When I visit Toronto the next time, I will claim my lunch then :-) -----Original Message----- From: Ranko Mosic [mailto:ranko.mosic@xxxxxxxxx] Sent: Thursday, October 26, 2006 1:58 PM To: Hameed, Amir Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Create materialized view group hanging Hi Amir, That did it. Thank you very much. If in Toronto area give me a ring - I am buying you lunch. Regards, Ranko On 10/26/06, Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote: > 9.2.06/Solaris 9. I'll try bounce. > > > On 10/26/06, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote: > > What is the DB version? We recently hit a bug with MV that caused > > deadlock on the "row cache lock" situation and we ended up bouncing > > the instance. We are 9.2.0.6 (64-bit)/Solaris9 > > > > -----Original Message----- > > From: oracle-l-bounce@xxxxxxxxxxxxx > > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ranko Mosic > > Sent: Thursday, October 26, 2006 1:33 PM > > To: oracle-l > > Subject: Create materialized view group hanging > > > > Hi, > > I am trying to create materialized view group with 28 views in there > > and dbms_refresh.make command is hanging. > > Same procedure was executed successfully in many other environments. > > Any ideas , suggestions ? > > > > -- > > Regards, > > Ranko Mosic > > Contract Senior Oracle DBA > > B. Eng, Oracle 10g, 9i Certified Database Professional > > Phone: 416-450-2785 > > email: mosicr@xxxxxxxxxx > > http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARan > > koMo > > sicMain.html > > -- > > //www.freelists.org/webpage/oracle-l > > > > > > > > > -- > Regards, > Ranko Mosic > Contract Senior Oracle DBA > B. Eng, Oracle 10g, 9i Certified Database Professional > Phone: 416-450-2785 > email: mosicr@xxxxxxxxxx > http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARanko > MosicMain.html > -- Regards, Ranko Mosic Contract Senior Oracle DBA B. Eng, Oracle 10g, 9i Certified Database Professional Phone: 416-450-2785 email: mosicr@xxxxxxxxxx http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMo sicMain.html -- //www.freelists.org/webpage/oracle-l