「Oracle 19c」Oracleの現在のセッション数とプロセス数を確認する
環境
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
A5:SQL Mk-2 2.17.1
構文
SELECT * FROM V$RESOURCE_LIMIT
WHERE RESOURCE_NAME = 'processes’
OR RESOURCE_NAME = 'sessions’;
Oracleの現在のセッション数とプロセス数を確認します。
使用例
SELECT
*
FROM
V$RESOURCE_LIMIT
WHERE
RESOURCE_NAME = 'processes'
OR RESOURCE_NAME = 'sessions';
SELECT
*
FROM
V$RESOURCE_LIMIT
WHERE
RESOURCE_NAME = 'processes'
OR RESOURCE_NAME = 'sessions';
SELECT
*
FROM
V$RESOURCE_LIMIT
WHERE
RESOURCE_NAME = 'processes'
OR RESOURCE_NAME = 'sessions';
実行結果
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE CON_ID
processes 64 95 320 320 0
sessions 79 116 504 504 0
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE CON_ID
processes 64 95 320 320 0
sessions 79 116 504 504 0
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE CON_ID processes 64 95 320 320 0 sessions 79 116 504 504 0