Re: Multiple v$session records for some v$process records

2006/10/27, Fowler, Kenneth R <Kenneth.R.Fowler_at_pfizer.com>:
>
>
> Hi,
>
>
> The question refers to Oracle 9.2.0.5 on Solaris 2.8. I noticed that in one
> database I look after we have multiple v$session records for some v$process
> records…

One of the common reasons could be autotrace on

SQL> set autotrace off
SQL> select sid, paddr from v$session where username = 'GINTS';

       SID PADDR
---------- --------

        34 59290338

1 row selected.

SQL> set autotrace on statistics
SQL> /        SID PADDR
---------- --------

        34 59290338
        44 59290338

2 rows selected.

Gints Plivna
http://www.gplivna.eu

--
http://www.freelists.org/webpage/oracle-l