oracle 集合查询语句,Oracle数据库维护常用SQL语句集合

1、求当前会话的SID，SERIAL#

SELECT Sid, Serial#

FROM V$session

WHERE Audsid = Sys_Context('USERENV', 'SESSIONID');

2、查询session的OS进程ID

SELECT p.Spid "OS Thread", http://www.doczj.com/doc/b33a422a915f804d2b16c1ff.html "Name-User", s.Program, s.Sid, s.Serial#, s.Osuser, s.Machine

FROM V$process p, V$session s, V$bgprocess b

WHERE p.Addr = s.Paddr

AND p.Addr = b.Paddr

And (s.sid=&1 or p.spid=&1)

UNION ALL

SELECT p.Spid "OS Thread", http://www.doczj.com/doc/b33a422a915f804d2b16c1ff.htmlername "Name-User", s.Program, s.Sid,

s.Serial#, s.Osuser, s.Machine

FROM V$process p, V$session s

WHERE p.Addr = s.Paddr

And (s.sid=&1 or p.spid=&1)

AND http://www.doczj.com/doc/b33a422a915f804d2b16c1ff.htmlername IS NOT NULL;

3、根据sid查看对应连接正在运行的sql

SELECT /*+ PUSH_SUBQ */

Command_Type, Sql_Text, Sharable_Mem, Persistent_Mem, Runtime_Mem, Sorts, Version_Count, Loaded_Versions, Open_Versions, Users_Opening, Executions, Users_Executing, Loads, First_Load_Time, Invalidations, Parse_Calls,