Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can the resource utilization of a database USER be monitored?

743431Nov 15 2010 — edited Nov 15 2010

Hi,

I would like to know that is it possible to get the resource utilization details of a particular user say SCOTT from the database.

I found that querying the view V$RESOURCE_LIMIT gives me the RESOURCE_NAME it's CURRENT_UTILIZATION, MAX_UTILIZATION, INITIAL_ALLOCATION and the LIMIT_VALUE for the database as a whole.

My requirement is to get the specific values for the RESOURCE_NAME for a specific user.

Thanks in advance

DG

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2010

Added on Nov 15 2010

#database, #general-database-discussions, #oracle

4 comments

175 views