Home > tips > Oracle Database Express Edition Licensing Information

Oracle Database Express Edition Licensing Information


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.

Advertisements
  1. April 10, 2013 at 6:44 am

    Your way of describing the whole thing in this article is genuinely pleasant, all be able to without difficulty understand it, Thanks a lot.

  2. May 1, 2013 at 2:15 am

    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.

  3. September 9, 2014 at 3:41 am

    Yes! Finally something about www.

  4. October 4, 2014 at 5:24 am

    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.

  5. October 4, 2014 at 8:36 am

    Hello, the whole thing is going well here and ofcourse every one is sharing facts, that’s genuinely excellent, keep up writing.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Don Charisma

because anything is possible with Charisma

Carol no Mundo!

Aventuras de uma intercambista a trabalho pelo mundo!

Blog do PHP

Oracle DBA for rookies!

nimaidba

Welcome to the world of Oracle with me....

Tech

News and reviews from the world of gadgets, gear, apps and the web

WordPress.com

WordPress.com is the best place for your personal blog or business site.

Gurcan Orhan's ODI and DWH Blog

Some words about Oracle Data Integrator and Data Warehousing.

%d bloggers like this: