I think the question is that is the flags show that there is a primary connection, but the session is not reading, not writing, and not waiting on a condition...then what's it doing?
I think that you find that the session is sleeping. If you run onstat -g ses <sid>, and look at the thread, it is likely to show "sleeping" - at least that's what I am seeing. The dbworker thread seems to be in that state, which makes sense.
------------------------------
Mike Walker
xDB Systems, Inc
www.xdbsystems.com------------------------------
Original Message:
Sent: Fri December 03, 2021 11:00 AM
From: John Smith
Subject: flags (onstat -g ses)
Yes
already checked, but i don"t where others flags are "-" !! there s only the 4th position "P" , so i'm wondering what is the session doing !!
------------------------------
John Smith
Original Message:
Sent: Fri December 03, 2021 10:45 AM
From: Paul Watson
Subject: flags (onstat -g ses)
Primary thread for the session
Original Message:
Sent: 12/3/2021 10:32:00 AM
From: John Smith
Subject: flags (onstat -g ses)
Hello
i have some sessions with status "running" and flags "---P---" , not doing or waiting for anything, other sessions are on "---PR--" (reading)
what does "---P---" mean please ?
Thanks
------------------------------
John Smith
------------------------------