Re: SLA 1500-euro fine because of CREATE MVIEW locks...

Spendius wrote:
> Hi,
> Ten days ago I asked what goes on when you create a mat. view
> (*even* without building it) and why so many locks suddenly
> appear THAT DON'T LOOK RELATED to your mview creation, yet
> are systematic, and why it makes so many sessions hang. All
> answers I got was stuff kind of "you'd better go to 10g" - which
> was not really helpful (and no worries: migrations's planned this
> year -anyway can you swear that heavy create mview-related
> locks have gone off in 10g ??-).
> My boss just told me the customers required our company to
> pay them a €1500 fine because of the 10-minute downtime the
> applications endured... (which of course he wasn't very glad about)
>
> Spendius

Did you ever read metalink Notes: 258252.1 258021.1 ? blablalbla query rewrite?

jg

--
@home.com is bogus.
DB function failed with error number 1146
Table 'dizwell2_joom1.jos_session' doesn't exist SQL=SELECT session_id
FROM jos_session WHERE session_id = MD5(
'7954004385e1a24d3e95e0f1a289dec7' )