user not connecting showing up as ACTIVE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: user not connecting showing up as ACTIVE

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Question

    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.

  2. #2
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Never mind...I figured out the issue:

    there seems to be a glitch with the way the control is returned back to GUI SQL tools (like Toad's)... and Parallel Query processes

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