Re: Shutdown hangon.

Forgetting about how Oracle is and isn't supposed to work for a second, I agree that the database will unnecesarily wait a *long* time to shut down immediate when it doesn't appear to have to. I have noticed this under 8i, not sure if it has happened under 7.

In any event, the reason is always some bozo that is logged in and has been for quite some time. They usually aren't doing anything. The last time it happened to me, it was a business objects user that had been logged in for 4 days without having done anything.

I kill -9 ed his OS process and the database went down right away.

I have also noticed under 8i that when a session takes out a lock and does not commit that I cannot release the lock by killing the session in Oracle, the session will be marked for kill, but the next day it is still there.

--
Dave A


"Jörg Brüwer" <bruewerj_at_cci.de> wrote in message
news:39F927F5.C73B32E6_at_cci.de...


> shutdown immediate rolls back user transactions, but it didn't kill user

> sessions.

> so it waits still so long, if all user are disconnected. Try this if you

 can:


>

> startup the database;

> login in sqlplus as any user on another task;

> login as internal on another task and shutdown immediate;

>     -> the task of internal will wait for the user in sqlplus. it waits

 for the


> time when

>     the user querie a question. if the user did nothing, and stand only in

 the


> shell of

>     sqlplus, the shutdown process will wait.

>

>

> have fun in this adventure !!

> joerg

>

>

>

> David Wang schrieb:

>

> > Dear all,

> >

> > Yesterday, When I use the command -- shutdown immediate, the database is

> > hangon for more than one hour. The database is very small even 100MB.

> > Although I stop it by manually stop the basic service using the service

 icon


> > in the control pane, I would like to know what is the reason and whether

 it


> > will be damaged to my database, the following content is abstract from

 the


> > trace file. Thanks for any responce to help me understand this trace

 file


> > and the question I metioned,

> >

> > "

> > Dump file D:\orant\RDBMS80\trace\ORA01844.TRC

> > Thu Oct 26 08:27:59 2000

> > ORACLE V8.0.5.0.0 - Production vsnsta=0

> > vsnsql=c vsnxtr=3

> > Windows NT V5.0, OS V8.147, CPU type 586

> > Oracle8 Release 8.0.5.0.0 - Production

> > PL/SQL Release 8.0.5.0.0 - Production

> > Windows NT V5.0, OS V8.147, CPU type 586

> > Instance name: orcl

> >

> > Redo thread mounted by this instance: 1

> >

> > Oracle process number: 17

> >

> > pid: 734

> >

> > *** SESSION ID:(15.13) 2000.10.26.08.27.58.997

> > SHUTDOWN: waiting for active calls to complete.

> > *** 2000.10.26.08.33.02.954

> > SHUTDOWN: waiting for active calls to complete.

> > "

>