RE: Create materialized view group hanging

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_at_gmail.com] Sent: Thursday, October 26, 2006 1:58 PM To: Hameed, Amir
Cc: oracle-l_at_freelists.org
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_at_gmail.com> wrote:
> 9.2.06/Solaris 9. I'll try bounce.
>
>
> On 10/26/06, Hameed, Amir <Amir.Hameed_at_xerox.com> 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_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org] 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_at_rogers.com
> > http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARan
> > koMo
> > sicMain.html
> > --
> > http://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_at_rogers.com
> http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARanko
> MosicMain.html
>

--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMo
sicMain.html
--
http://www.freelists.org/webpage/oracle-l