--进程视图
v$process
--会话视图
v$session
v$mystat
v$sql
v$transaction
v$lock
v$transaction.ADDR=v$lock.ADDR
v$lock.SID=v$session.SID
v$session.SQL_ID=v$sql.SQL_ID
v$session.PADDR=v$process.SPID
查看有哪些进程
[oracle@orale ~]$ ps -ef |grep LOCAL |grep -v grep
oracle 4245 4202 0 09:18 ? 00:00:02 oraclemypl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4298 1 0 09:20 ? 00:00:00 oraclemypl (LOCAL=NO)
当连接oracle后会自动分配一个会话号
--查当前会话号
SQL> select distinct sid from v$mystat;
SID
----------
SQL> select a.spid from v$process a ,v$session b where a.addr=b.paddr and b.sid
in (select sid from v$mystat where rownum=1);
SPID
---------------
v$process
--会话视图
v$session
v$mystat
v$sql
v$transaction
v$lock
v$transaction.ADDR=v$lock.ADDR
v$lock.SID=v$session.SID
v$session.SQL_ID=v$sql.SQL_ID
v$session.PADDR=v$process.SPID
查看有哪些进程
[oracle@orale ~]$ ps -ef |grep LOCAL |grep -v grep
oracle 4245 4202 0 09:18 ? 00:00:02 oraclemypl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 4298 1 0 09:20 ? 00:00:00 oraclemypl (LOCAL=NO)
当连接oracle后会自动分配一个会话号
--查当前会话号
SQL> select distinct sid from v$mystat;
SID
----------
17
SQL> select a.spid from v$process a ,v$session b where a.addr=b.paddr and b.sid
in (select sid from v$mystat where rownum=1);
SPID
---------------