Wednesday, November 11, 2015

script to check database resource utilization history in oracle database

Please use the below view to find the resource history usage details with specific time frame.

select CURRENT_UTILIZATION,MAX_UTILIZATION,LIMIT_VALUE from DBA_HIST_RESOURCE_LIMIT where RESOURCE_NAME like '%processes%' and SNAP_ID='13011';

1 comment:

  1. Thank you so much for sharing about Resource Utilization. It is such a nice blog to read. Keep sharing it.

    ReplyDelete