Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003

    Unanswered: PMON do not activate at once to kill Server Process ?

    hello !

    In theory, if a connection from client and server is disconnected suddenly (ex: power-cut, out of network cable ...) then Proccess Monitor (PMON) will be activated after several seconds to free all resources of that client.

    But in practice, it' not correct, the Server Process that (exist on Oracle Server) serve for disconnected client process do not be killed immediately although I kill it by command "alter system kill session '8,13'". It's just killed after over 15 minutes.

    I don't know why PMON do not activate to kill it at once. and How to kill Server Process immediatly ?

    thanks !

    PS: Hope you understand my question

  2. #2
    Join Date
    Nov 2002
    did you set resource_limit=true in the init.ora file?, which is needed if you want to make use of kill session ...

    but as I figured out, killed sessions can be seen for some
    time even up to a couple of days in v$session

  3. #3
    Join Date
    Apr 2002
    California, USA

    Thumbs up

    Cleaning already KILLED session depends on the dead connection detection (DCD) in Oracle. How to setup this is explained Here

    Hope that helps,

    OCP - DBA
    Visit our Web Site

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts