查看Oracle和MySQL的连接数及会话数

Oracle

--查看系统当前进程的连接数
SELECT
    COUNT(*) AS processCounts 
FROM
    v$process;

--查看系统当前会话的连接数
SELECT
    COUNT(*) AS sessionCounts 
FROM
    v$session;

--查看当前Oracle中正在执行的sql语句——即查询Oracle进程的SQL
SELECT
    t1.program,
    t1.MACHINE,
    t1.OSUSER,
    t1.USERNAME,
    t2.spid,
    t3.sql_text,
    t3.SQL_ID
FROM
    v$session t1, v$process t2, v$sqlarea t3
WHERE
    1 = 1
    AND t1.paddr = t2.addr
    AND t1.sql_hash_value = t3.hash_value
    AND t1.username IS NOT NULL;

MySQL

SELECT
    *
FROM
    information_schema.PROCESSLIST
WHERE
    1 = 1
    AND info IS NOT NULL;