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.

How to see grid like backup report with SQL

In order to see the backup status historically from database side, you may check below SQL. I used in 11.2.0.2.

SELECT b.session_key,
b.session_recid,
b.session_stamp,
b.command_id,
b.status,
b.start_time,
b.END_TIME,
b.time_taken_display,
b.input_type,
b.output_device_type,
b.input_bytes_display,
b.output_bytes_display,
b.output_bytes_per_sec_display
FROM V$RMAN_BACKUP_JOB_DETAILS b
WHERE (b.start_time > to_date('04.12.2011 19:00','dd.mm.yyyy hh24:mi'))
order by b.start_time desc;