Re: SNIPED status in V$SESSION?

From: Rick Henry <rhenry_at_ac-technologies.com>
Date: 01 Dec 1998 12:49:26 PST
Message-ID: <Pine.LNX.4.05.9812011248460.6730-100000@ensemble.ac-technologies.com>

SNIPED = session inactive, waiting on client.

HTH
Rick

On Tue, 1 Dec 1998 skubiszewski_at_Eisner.DECUS.Org wrote:

> 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 - 14:49:26 CST