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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: sqlplus shutdown "time-out"

Re: sqlplus shutdown "time-out"

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 19 Apr 2005 14:14:43 -0400
Message-ID: <9177895d0504191114485bbe13@mail.gmail.com>


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';

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 19 2005 - 14:18:55 CDT

Original text of this message

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