oracle常用SQL语句_1

/*获取 Oracle 版本*/
SELECT VALUE
FROM v$system_parameter
 WHERE name = 'compatible';
 
/*在视图中查询并显示实际的 Oracle 连接*/
SELECT osuser,username,machine, program 
FROM v$session 
/*where machine = 'PC-20140604AMGV' */
ORDER BY osuser;
 
/*查询并显示连接 Oracle 的用户和用户的会话数量*/
SELECT username, COUNT (username) sessionCount
FROM v$session 
where username is not null
GROUP BY username
ORDER BY sessionCount DESC;