Re: Runaway shadow processes (HP9000)

In article <D7EvIB.DoC_at_eskimo.com>, lparsons_at_eskimo.com (Lee Parsons) writes: .
.
> The first best answer is to upgrade to Sqlnet V2.2 not V2.1.
>
> 2.1 supports termination of orphan shadow tasks
> (processes that are idle and have lost their clients)
>
> 2.2 should support killing of runaway shadow processes
> (these processes are orphans that are consuming CPU)

You will need to set your $ORACLE_HOME/network/admin/sqlnet.ora file and modfy the following line from
sqlnet.expire_time = 2147483647
to
sqlnet.expire_time = <new minutes>

You will also need to set this on your PC as well and if the values are different, SQL*Net will negotiate an agreed value.

ta
tony

-- 
 _____       ________ / ___ |Tony Jambu, Database Consultant
  /_  _        /_ __ /      |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_(  |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559
 \_______/                  |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905