普通用户与DBA如何查询session ID
select
sys_context('USERENV','SID')
from dual;
select
sid
from
v$mystat
where
rownum <=1;
select
to_number(substr(dbms_session.unique_session_id,1,4),'XXXX') mysid
from dual;
select distinct
sid
from v$mystat;