I killed a spid earlier - it's command is currently KILLED/ROLLBACK and has been for a very long time. (couple hours, plus)
the cputime and disk i/o are very minimal and haven't changed at all, subsequent attempts to kill the spid return this:
spid 1: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0 seconds.
but, status is RUNNABLE
and certain retrievals are actually blocked by this spid
very important, please advise as soon as possible