Find Total, Free & Utilized values of PROCESSES, SESSIONS & TRANSACTIONS
SQL command for standalone database. Click here to get sample output.
SET LINES 222
COL RESOURCE_NAME FOR A15
COL LIMIT_VALUE FOR A15
SELECT RESOURCE_NAME,CURRENT_UTILIZATION, LIMIT_VALUE - CURRENT_UTILIZATION as FREE_VALUE, LIMIT_VALUE
FROM V$RESOURCE_LIMIT
WHERE RESOURCE_NAME IN ('sessions','processes') ORDER BY RESOURCE_NAME;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
OR
SELECT RESOURCE_NAME,CURRENT_UTILIZATION, LIMIT_VALUE
FROM V$RESOURCE_LIMIT
WHERE RESOURCE_NAME IN ('sessions','processes','transactions') ORDER BY RESOURCE_NAME;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
SQL command for RAC database. Click here to get sample output.
SET LINES 222
COL RESOURCE_NAME FOR A15
COL LIMIT_VALUE FOR A15
SELECT INST_ID,RESOURCE_NAME,CURRENT_UTILIZATION, LIMIT_VALUE - CURRENT_UTILIZATION as FREE_VALUE, LIMIT_VALUE
FROM GV$RESOURCE_LIMIT
WHERE RESOURCE_NAME IN ('sessions','processes') ORDER BY INST_ID,RESOURCE_NAME;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
OR
SELECT INST_ID,RESOURCE_NAME,CURRENT_UTILIZATION, LIMIT_VALUE
FROM GV$RESOURCE_LIMIT
WHERE RESOURCE_NAME IN ('sessions','processes','transactions') ORDER BY INST_ID,RESOURCE_NAME;
prompt$$$$$$$**Welcome to DBsGuru!**Share Learn Grow**$$$$$$$
Click here for “How to increase Processes, Sessions and Transactions Initialization Parameters”
We always encourage the technical person to visit section SCRIPTS to get more daily usage SQL commands.
Hope so you like this SCRIPT!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to know more about our pursuit.
