set lines 300 col RESOURCE_NAME format a30 select RESOURCE_NAME,CURRENT_UTILIZATION,MAX_UTILIZATION,INITIAL_ALLOCATION,LIMIT_VALUE from v$resource_limit where resource_name in ('processes','sessions'); RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE ------------------------------ ------------------- --------------- ---------------------- --------------- processes 1498 1500 1500 1500 sessions 1511 1517 2272 2272Documented for Oracle 19c here
Minimalistic Oracle contains a collection of practical examples from my encounters with Oracle technologies. When relevant, I also write about other technologies, like Linux or PostgreSQL. Many of the posts starts with "how to" since they derive directly from my own personal experience. My goal is to provide simple examples, so that they can be easily adapted to other situations.
Monday, June 26, 2023
How to show current utilization of sessions, processes and other important settings for a database
Example:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment