DEAD processes - advice required

[Horace]

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.

[jlakhani]

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

[Horace]

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

[pando]

KTUXECFL means transaction flag, DEAD means transactions to be recovered after instance failure so I guess sMON will recover them (deferred)