Database Administration (MOSC)

MOSC Banner

Resource Manager doen't work

edited Nov 14, 2014 10:00AM in Database Administration (MOSC) 5 commentsAnswered

Hello gurus.

I'm trying to enable the Oracle Resource Manager through Enterprise Manager. The configuration seems very easy, but It doesn't do what I think It should.

I have a Consumer Group called LIMITA_SESIONES and inside it the user PRUEBA

And after that I've created a Resource Plan with Maximum Number of Active Sesions = 1 for the Group LIMITA_SESIONES.

So I think I would not be able to log into Oracle twice with the user PRUEBA, but I can.

>sqlplus prueba/***

SQL*Plus: Release 10.2.0.5.0 - Production on Jue Nov 6 14:08:49 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to:....

Actually I'm trying to limit the CPU usage to some users, but It doesn't seems to work either, that's why I'm trying to limit the number of active sessions firts, because I think I'm missing something.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center