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

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle killed session still holding locks

Re: oracle killed session still holding locks

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Sun, 31 Oct 2004 13:08:27 +0100
Message-ID: <cm009u$v2k$2@news4.zwoll1.ov.home.nl>


Jean wrote:

>>shutdown abort comes to mind.
>>

>
>
> yes but there are 700 users on the db working and only 10 users want to
> access that table
> i'm very afraid of this ... It's the second time i have this in one month.
> The first time i've made the shutdown abort cause shutdown immediate
> didn't shutdown after 1hour.
> I don't know how to react because the application need 24/7 avalaibility.
> the application was on sybase without any problem at first and now we
> migrated to oracle (for support)
> i'm disapointed but i'll open a case.
> i don't think it's the good way to shutdown abort each time i've got this
> error, and i have no good explanation for my boss.
>

Hm - sounds like an application setting (unnecessary) locks, because it wasn't written with Oracle in mind...

-- 

Regards,
Frank van Bortel
Received on Sun Oct 31 2004 - 06:08:27 CST

Original text of this message

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