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>


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

Original text of this message