How to check process and session in Oracle? How to check the resource limit of session and processes in Oracle?
Ezana Answered question 20/04/2023
- To check session and process limit from Oracle Startup:
1234567891011
--- For sessionsSQL>selectRESOURCE_NAME,CURRENT_UTILIZATION,MAX_UTILIZATION,LIMIT_VALUEfromv$resource_limitwhereresource_name ='sessions';RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALU------------------------------ ------------------- --------------- ----------sessions 121 506 6032---- For processesSQL>selectRESOURCE_NAME,CURRENT_UTILIZATION,MAX_UTILIZATION,LIMIT_VALUEfromv$resource_limitwhereresource_name ='processes';RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALU------------------------------ ------------------- --------------- ----------processes 173 527 4000SQL> - To check the history table of Resource Limit:
1
select*fromDBA_HIST_RESOURCE_LIMITwhereresource_namein('sessions','processes'); - And to query history of resource utilization with time:
12
selects.SNAP_ID,TO_CHAR(s.END_INTERVAL_TIME,'DD-MON HH24:MI:SS') Snapshottime,resource_name,current_utilization,max_utilization,limit_valuefromDBA_HIST_SNAPSHOT s, DBA_HIST_RESOURCE_LIMIT bwheres.snap_id = b.snap_idandresource_namein('sessions')orderby2;
Ezana Answered question 20/04/2023