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

On 25 Mar 2006 00:59:05 -0800, "Spendius" <spendius_at_muchomail.com> 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

This is a free and volunteer forum. It is NO Metalink, so you can not expect people are going to try to reproduce your situation, especially as the questions *you* ask are often way too broad and too generic to be answered with similar generalizations other than 'It depends' If you are not on the latest patch, it may be a reason to upgrade, and you could of course have perused Metalink patch and upgrade releases notes to find out whether your issue is known and has been addressed.

Your complaints are unjustified.
If you have a SLA with fine clauses, your company needs to address whether proper support is in place.
If a customer refuses to upgrade, the problem can't be held against your company.

--
Sybrand Bakker, Senior Oracle DBA