Database Administration (MOSC)

MOSC Banner

Hi , i'm trying to monitor resource group history in Resouce manager

edited Nov 27, 2014 10:03AM in Database Administration (MOSC) 1 commentAnswered

. But in not clear how to make it . What query i can use to monitor resource utilization during the night for consumer group ?

The field CONSUMED_CPU_TIME of the view DBA_HIST_RSRC_CONSUMER_GROUP. 

The result of CONSUMED_CPU_TIME grow every day but some day the result is less of the day before .

It calculate the cumulative cpu usage ,

In certain hour , in the night tipically , nobody of the resource group is working but the cpu consumed continue to grow .

I need to know how much CPU was consumed, how much time was spent during I/O, how much Mb was read in small requests and in large requests... by each consumer group during each hour of each past day (no only the last few sessions), but I'm not able to find a query that can give me such informations.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center