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

  • From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
  • To: Kenneth.R.Fowler@xxxxxxxxxx
  • Date: Fri, 27 Oct 2006 22:04:52 +0300

2006/10/27, Fowler, Kenneth R <Kenneth.R.Fowler@xxxxxxxxxx>: 



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
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2006