Oracle 12c DBMS_FEATURE_USAGE

Oracle DBMS_FEATURE_USAGE_REPORT Version 12.1.0.1

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Purpose

Produce feature usage reports in HTML and ASCII formats.

AUTHID

DEFINER

Dependencies

AWRRPT_HTML_TYPE	AWRRPT_TEXT_TYPE	DBMS_SWRF_REPORT_INTERNAL
AWRRPT_HTML_TYPE_TABLE	AWRRPT_TEXT_TYPE_TABLE	PLITBLM

Documented

First Available

10.2.0.1

Security Model

Owned by SYS with EXECUTE granted to the DBA role

Source

{ORACLE_HOME}/rdbms/admin/dbmsfus.sql

DISPLAY_HTML

Display Feature Usage Report in HTML Format

dbms_feature_usage_report.display_html(
l_dbid IN NUMBER DEFAULT NULL,
l_version IN VARCHAR2 DEFAULT NULL,
l_options IN NUMBER DEFAULT 0)
RETURN awrrpt_text_type_table PIPELINED;

spool c:\temp\usage_report.html

SELECT output
FROM TABLE(dbms_feature_usage_report.display_html);

spool off

DISPLAY_TEXT

Display Feature Usage Report in Text Format

dbms_feature_usage_report.display_text(
l_dbid IN NUMBER DEFAULT NULL,
l_version IN VARCHAR2 DEFAULT NULL,
l_options IN NUMBER DEFAULT 0)
RETURN awrrpt_html_type_table PIPELINED;

spool c:\temp\usage_report.txt

SELECT output
FROM TABLE(dbms_feature_usage_report.display_text);

spool off

Report Demo

Using dbfusrpi.sql

@?\rdbms\admin\dbfusrpi

Using dbfusrpt.sql

@?\rdbms\admin\dbfusrpt