SNIPED status in V$SESSION?

From: <skubiszewski_at_Eisner.DECUS.Org>
Date: Tue, 1 Dec 1998 19:14:44 GMT
Message-ID: <F3Aw4K.H9E@news.decus.org>

What does the status SNIPED mean in V$SESSION?

Also, is there any way to associate the value of process (from V$SESSION) with the actual pid on the OS? I am seeing conflicting values.

For example:
USERNAME PROCESS STATUS
-------- ------- ------
JONES 9742:01 SNIPED
SMITH 9574:01 SNIPED The OS (Unix) shows pids for Oracle sessions as:

oracle  1522    1 11:14:03 ? 0:00 oracleSID (LOCAL=NO)
oracle  5172    1 Nov  9   ? 0:00 oracleSID (LOCAL=NO)
oracle  1363    1 09:27:05 ? 0:00 oracleSID (LOCAL=NO)

I wound up killing 1522, 5172 and 1363 because I could not distinguish who was who. This had the effect of killing the SMITH and JONES sessions in Oracle. I cannot explain why there are 3 Unix processes and 2 Oracle processes.

Any thoughts?

Rose Received on Tue Dec 01 1998 - 13:14:44 CST