We are on a 8.1.5 DB on Compaq TRU64 UNIX:
There is a user, that ran a query at 8:14am, which ended a couple of minutes later, and then disconnected from the database.
Even now @ 9:11am, the query is showing up as ACTIVE, even though the user is not even connected to the database. It looks like the parallel processes (4) were never released...even the server processes are out there - not taking any CPU time though !!
Anyone seen this before.