Found one metalink hit:

<start>
The serial# in v$process is incremented each time a process slot is reused. It counts up from -128 to 127. That would account for negative numbers. The serial# in v$process would not be expected to match v$session.
<end>


M


>>> " (Frank Dodgers)" <oracledba-ezmlmshield-x91127057.[Email address protected] 08/18/04 03:45PM >>>
Just a shot in the dark but we noticed that there are serial#'s in v$process with negative values (e.g., -22) that do not have a corresponding entry in v$session. And, via glance we see that these processes are consuming most of the cpu. Any thoughts will be appreciated.


--
Thank You,
Frank Dodgers
Oracle & DB2 Certified
Evergreen Information Systems
-303-784-2322 Office
-303-674-0433 Home
-303-810-6625 Cell
frank.[Email address protected]


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page