Re: sqlplus shutdown "time-out"

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: gogala@xxxxxxxxxxxxx
  • Date: Tue, 19 Apr 2005 14:14:43 -0400

KG,
What about using on-logon trigger to set event 10165 in sessions so they can 
be easily 'aborted'? Any drawbacks to using this event?

Raj

On 04/19/2005 12:53:20 PM, K Gopalakrishnan wrote:
> 
> > There is a timeout for shutdown (I think starting from 9iR2) which
> > defaults to 60 minus. If the active calls (!) don't complete in that
> > time, the instance just updates the alertlog and doesn;t shutdown its
> > own. You need to shutdown abort.
> 
> > It is not documented btw :D
> 

-- 
------------------------------
select standard_disclaimer from company_requirements where category = 
'MANDATORY';

--
//www.freelists.org/webpage/oracle-l

Other related posts: