DEAD processes - advice required
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DEAD processes - advice required

  1. #1
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346

    DEAD processes - advice required

    Hi,

    I'm using Oracle 9.2.0 on Win2K

    When I issue 'select * from x$ktuxe where ktuxecfl = 'DEAD';'

    I get 10 DEAD processes listed.

    The database will shutdown immediate and startup open okay, so all transactions will have been cleaned up.

    Questions.........

    What are these dead processes
    Why does SMON not clean them up on shutdown
    How do I get rid of them.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    In the server SQLNET.ora
    do the following


    Parameter: SQLNET.EXPIRE_TIME

    Format: SQLNET.EXPIRE_TIME = minutes

    Purpose: Sets an expiration time for Net8 sessions. The expiration time represents an interval that is specified in terms of minutes. The clock begins ticking when a connection is made. At the specified interval, Net8 verifies that the connection still exists. If the probe fails, the Net8 session is terminated.

    SQLNET.EXPIRE_TIME=10
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Thanks for that.

    I don't really want to time out our connections (it's related to the way our main application works).

    What I really need to know, is how to cleanly remove the DEAD sessions from the database table, without messing the DB up.

    Should SMON remove references to DEAD processes on shutdown ?

    Thanks in advance

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    KTUXECFL means transaction flag, DEAD means transactions to be recovered after instance failure so I guess sMON will recover them (deferred)
    Last edited by pando; 12-03-2002 at 11:21 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width