mm

I am Layadhar Duppati, having 12 Years of experience in Database Administration. I love to travel, learn new things. I love to learn new technologies. Have exposure on various domains Automotive, Retail, Banking. Always on Production Critical Mission.

Share this post

Getting Resource Limits in Oracle Database

in Oracle DB Admin
Share via:
Post Views: 0

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...

You might also like...

Add Comment