Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > question about ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 16461 of 16960
Post > Topic >>

question about process column in v$session

by alexhguerra@[EMAIL PROTECTED] Apr 23, 2008 at 09:01 PM

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 do***entation 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
 




 2 Posts in Topic:
question about process column in v$session
alexhguerra@[EMAIL PROTEC  2008-04-23 21:01:21 
Re: question about process column in v$session
sybrandb <sybrandb@[EM  2008-04-24 05:03:37 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 5:48:53 CDT 2008.