Re: Killed database sessions

Hello Guys,

The conclusions drawn by all of you are correct. There is one way around this :

1. It is better always to kill the OS shadow process, which would then cause PMON to cleanup the entries and resources held by this shadow.
2. Next the above is true if the entries that need to be cleaned up is small enough, so to ensure that PMON gets his act together, there is one parameter in the init.ora you can tweak

cleanup_rollback_entries

The default value for this is 20, but if txns are long and numerous increasing this will alleviate some of your frustrations.

Set it to something like , 50

Hope this helps,

Manoj Appully Received on Wed Mar 05 1997 - 00:00:00 CST