Getting Resource Limits in Oracle Database

Share via:

set linesize 140 pagesize 100
select resource_name,current_utilization,limit_value from gv$resource_limit order by 1;

 

Sample Output:

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (13 votes, average: 4.92 out of 5)
Loading...

Add Comment