进行了2次会话,发现同一个连接上PADDR 是相同的,而SPID是不同的。
不知道这2者有什么关系?
[oracle@node ~]$ sqlplus u01/oracle
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 5 21:35:03 2011
Copyright (c) 1982, 2005, Oracle.All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> set line 120
select a.username,a.sid,a.serial#,server,spid,paddr,a.status
from v$session a
join v$process b
on a.paddr=b.addr
5where a.username='U01';
USERNAMESID
SERIAL# SERVERSPID
PADDRSTATUS
------------------------ ---------- ---------- --------- ------------ -------- --------
U01
145
271
DEDICATED 29438
2C21B254ACTIVE
SQL> disconnect
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> conn u01/oracle
Connected.
select a.username,a.sid,a.serial#,server,spid,paddr,a.status
from v$session a
join v$process b
on a.paddr=b.addr
5where a.username='U01';
USERNAME
SID
SERIAL#
SERVERSPID
PADDRSTATUS
------------------------------ ---------- ---------- --------- ------------ -------- --------
U01
145
273
DEDICATED 29439
2C21B254 ACTIVE
|