Hi All,
Since last few days I am facing huge no of processes problem while no of sessions are less.
There are a lot of processes which does not belong to any session.

select * from v$session has 24 rows

select * from v$process has 232 rows. (some time 700 while sessions only 24)

SQL> select addr from v$process
2 minus
3 select paddr from v$session;

ADDR
--------
2C27B7B0
2C27D418
2C27D740
2C27DA68
2C27DD90
2C27E0B8
2C27E3E0
2C27E708
2C27EA30
2C27ED58
2C27F080
2C27F3A8
....................
...................
.....................
220 rows

Why these ADDR exsists when corrosponding session PADDR are no more?

Thanks

Rakesh

Oracle LazyDBA home page