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: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 30 Oct 2004 08:37:02 -0700
Message-ID: <1099150563.315335@yasure>


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.

Time to go back to basics:

1. What operating system on what hardware?
2. What version (complete) and edition of Oracle?
3. What error messages are in the alert log?
4. What else is happening on the machine?
-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Oct 30 2004 - 10:37:02 CDT

Original text of this message

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