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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Create materialized view group hanging

RE: Create materialized view group hanging

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Thu, 26 Oct 2006 14:13:52 -0400
Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C0038A7946@usa0300ms03.na.xerox.net>


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
Received on Thu Oct 26 2006 - 13:13:52 CDT

Original text of this message

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