I figured out that Resource Manager Feature is not enabled in Oracle Express Edition (XE).
I write this information here, because I could not have found any feature list whether XE supports Resource Manager feature at first.
In order to understand, if XE supports, I tried to create resource plan and resource plan directive and I got the below error.
BEGIN
SYS.DBMS_RESOURCE_MANAGER.clear_pending_area();
SYS.DBMS_RESOURCE_MANAGER.create_pending_area();
SYS.DBMS_RESOURCE_MANAGER.create_plan(
plan=>'sample',
comment=>'');
SYS.DBMS_RESOURCE_MANAGER.submit_pending_area();
END;
/
ORA-00439: feature not enabled: Database resource manager
ORA-06512: at "SYS.DBMS_RMIN", line 63
ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 111
ORA-06512: at line 5
Further, internal resource plan is enabled:
select * from v$rsrc_plan;
ID NAME IS_TO CPU INS PARALLEL_SERVERS_ACTIVE PARALLEL_SERVERS_TOTAL PARALLEL_EXECUTION_MANAGED
--------- -------------------------------- ----- --- --- ----------------------- ---------------------- --------------------------------
1 INTERNAL_PLAN_XE TRUE ON OFF 0 0 OFF
After googling around, I found that full feature list supported could have been found from below document:
Oracle Database Express Edition Licensing Information
http://docs.oracle.com/cd/E17781_01/license.112/e18068/toc.htm
So I will look for Licensing Information of any release from now on.
Subscribe to:
Post Comments (Atom)
Windows (powershell) counterparts of Linux commands
You may find Windows mostly powershell equivalent of frequently used Linux commands here. I will update this post, with newer ones by the ti...
5 comments:
Your way of describing the whole thing in this article is genuinely pleasant, all be able to without difficulty understand it, Thanks a lot.
Compete the excellent good article, I read few posts in this particular website and i also conceive that the
weblog is rattling interesting and contains lots of good info.
Yes! Finally something about www.
Your team could have possession of the ball but you never know when that possession will be lost and your team
must transition to defense. Winning is obviously the name of the game in big-time college football, but Saban and his teams focus on the process.
Lacrosse website that a big name college coach prefers multi-sport athletes.
Football is definitely a sport that requires a combination of skills and athletic ability.
Hello, the whole thing is going well here and ofcourse every one is sharing facts, that's genuinely excellent, keep up writing.
Post a Comment