question about process column in v$session
From: <alexhguerra_at_uol.com.br>
Date: Wed, 23 Apr 2008 21:01:21 -0700 (PDT)
Message-ID: <7137a01d-aafa-47da-878b-9013ad183393@x35g2000hsb.googlegroups.com>
4735492
860:3016
488:4048
4444398
1392:3672
Date: Wed, 23 Apr 2008 21:01:21 -0700 (PDT)
Message-ID: <7137a01d-aafa-47da-878b-9013ad183393@x35g2000hsb.googlegroups.com>
Hello
Im trying to use the column 'process' in v$session but the information returned showed numbers in different formats and made me confused. Is there any documentation about how this data is formatted (hex,octal,...) for each platform? So far, what i most need now is to make a correlation between a script being ran on sqlplus and the oracle process serving it. (the sqlplus process is executed by a cron schedulle in the same server where SRDBMS is running - AIX )
Here's a sample of a snapshot from v$session having some pids in a strange format
3708:2240 3140:2432 2272:2452 3776:3028 3712:3308 1412:2544
4735492
3268:1564 1412:2560 2560:116 3140:2432
860:3016
488:4048
7052:2016 3688:956 2200:2092
4444398
1392:3672
Thanks Received on Wed Apr 23 2008 - 23:01:21 CDT