Run an onstat -g ath and look at the line for the thread (tid in the onstat -g ses <sid> report). You should see something like this:
1520 4a8b10d0 46bfb388 1 cond wait netnorm 8cpu sqlexec
This is an "sqlexec" thread, the main processing thread for a session. The status is "cond wait netnorm" that means that the thread is waiting for a network connected client to tell it what to do. It has finished whatever it was doing. Either it is between SQL statements waiting for the client to execute another, or it is in the middle of returning a large data set and waiting for the client to FETCH again. I don't remember the details of what the output looks like for a shared memory connection.
If the session is no longer there, which happens, for example, when a Windows app is close using the big "X" and doesn't trap that and close the connection to the database, the session will go away once the OS destroys the network connection when it times out. To get faster timeouts (they can take up to an hour on some OS's) set the keepalive setting in your SQLHOSTS file. Shared memory connections never timeout, but they also don't tend to hang when the client exits or crashes.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Fri December 03, 2021 12:31 PM
From: Andreas Legner
Subject: flags (onstat -g ses)
That's the same set of flags as in 'onstat -u' I'd say.
For a session having multiple threads (PDQ), the 'P' thread would be the primary (sqlexec) one.
------------------------------
Andreas Legner
Original Message:
Sent: Fri December 03, 2021 10:32 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
------------------------------