0、数据库参数属性col PROPERTY_NAME format a25col PROPERTY_VALUE format a30col DESCRIPTION format a100select * from database_properties; select * from v$version; 1、求当前会话的SID，SERIAL#SELECT Sid, Serial# FROM V$sessionWHERE Audsid = Sys_Context('USERENV', 'SESSIONID'); 2、查询session的OS进程IDSELECT p.Spid "OS Thread