在知识库中专注阅读，并随时返回相关工具与课程
大家好，这里是 DBA 学习之路，专注于提升数据库运维效率。 @TOC目录 最近有朋友问，如何查看 Oracle 数据库当前安装了哪些功能组件，以及这些功能的特性是否被实际使用了？乍一听，这个问题不简单。于是我在 MOS 上查找了一些资料，整理出一套完整的方法，希望对大家有所帮助。 作为DBA，您是否遇到过这些困惑： - 数据库安装了哪些功能组件？ - 这些组件是否真的被业务使用？ - 如何避免为
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程大家好，这里是 DBA 学习之路，专注于提升数据库运维效率。
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
最近有朋友问，如何查看 Oracle 数据库当前安装了哪些功能组件，以及这些功能的特性是否被实际使用了？乍一听，这个问题不简单。于是我在 MOS 上查找了一些资料，整理出一套完整的方法，希望对大家有所帮助。
作为DBA，您是否遇到过这些困惑：
本文将带您全面掌握 Oracle 功能组件的检查方法，助你实现：
这些方法可以帮助 DBA 全面了解 Oracle 数据库中功能组件的安装及使用情况，尤其在许可证合规性检查中非常有用。
检查数据库版本：
1SQL> select banner from v$version;23BANNER4--------------------------------------------------------------------------------5Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production企业版与标准版功能差异显著，建议先确认版本：
📌 官方文档参考：Database Licensing Information
可以通过 DBA_REGISTRY 视图查看当前数据库中已安装的功能组件：
参考如下查询结果：
1COL comp_id FORMAT A122COL version FORMAT A103COL comp_name FORMAT A404COL status FORMAT A105SET pages 306SELECT SUBSTR(comp_id,1,12) AS comp_id,7 status,8 SUBSTR(version,1,10) AS version,9 SUBSTR(comp_name,1,40) AS comp_name10FROM dba_registry11ORDER BY 1, 2;1213COMP_ID STATUS VERSION COMP_NAME14------------ ---------- ---------- ----------------------------------------15APS VALID 19.0.0.0.0 OLAP Analytic Workspace16CATALOG VALID 19.0.0.0.0 Oracle Database Catalog Views17CATJAVA VALID 19.0.0.0.0 Oracle Database Java Packages18CATPROC VALID 19.0.0.0.0 Oracle Database Packages and Types19CONTEXT VALID 19.0.0.0.0 Oracle Text20DV VALID 19.0.0.0.0 Oracle Database Vault21JAVAVM VALID 19.0.0.0.0 JServer JAVA Virtual Machine22OLS VALID 19.0.0.0.0 Oracle Label Security23ORDIM VALID 19.0.0.0.0 Oracle Multimedia24OWM VALID 19.0.0.0.0 Oracle Workspace Manager25RAC OPTION OFF 19.0.0.0.0 Oracle Real Application Clusters26SDO VALID 19.0.0.0.0 Spatial27XDB VALID 19.0.0.0.0 Oracle XML Database28XML VALID 19.0.0.0.0 Oracle XDK29XOQ VALID 19.0.0.0.0 Oracle OLAP API这些组件是在数据库安装之初进行选择安装的，无法禁用，与是否使用也无关，非必要情况下也不建议去卸载。
DBA_FEATURE_USAGE_STATISTICS 是 Oracle 提供的关键数据字典视图，用于跟踪数据库功能使用情况（从数据库上次启动开始，每 7 天采样一次），非常适用于许可证合规性管理和容量规划。
一键查看当前已启用特性：
1SQL> ALTER SESSION SET nls_date_format = 'dd-mon-yy hh24:mi:ss';2SET lines 2222 pages 10003COL name FOR a604COL currently_used FOR a55COL last_usage_date FOR a2067SELECT name, currently_used, last_usage_date, description8FROM dba_feature_usage_statistics9WHERE currently_used = 'TRUE';
这个视图的数据更新机制如下：
DBMS_FEATURE_USAGE_INTERNAL 包进行强制刷新；可通过以下方式 Trace MMON 的行为，深入了解 Oracle 的采样逻辑：
1SQL> BEGIN2 dbms_monitor.serv_mod_act_trace_enable(3 service_name => 'SYS$BACKGROUND',4 module_name => 'MMON_SLAVE',5 action_name => 'Auto-DBFUS Action');6END;7/89SQL> ALTER SESSION SET "_swrf_test_action" = 28;1011SQL> ALTER SESSION SET EVENTS 'immediate trace name mmon_test level 6';然后通过命令提取 trace 文件中的 SQL：
1grep -A 1 "sqlid='" $ORACLE_BASE/diag/rdbms/<db_name>/<instance>/trace/<file>.trc | grep -v "sqlid='"Trace 中会显示大量底层采样 SQL，例如：
1SELECT name, inst_chk_method, inst_chk_logic, usg_det_method, usg_det_logic2FROM wri$_dbu_feature_metadata mt, wri$_dbu_feature_usage fu3WHERE mt.name = fu.name4 AND fu.dbid = :dbid5 AND fu.version = :version;通过这些采样 SQL，Oracle 能够自动判断哪些功能被使用，例如：
上述这些组件的收费情况可以参考文章：
比如其中部分功能特性的收费情况：
大家可以根据自己的数据库版本以及功能特性使用情况，完全可以大致预估出来费用了。
很多人关心数据库组件的使用情况，通过上述方式可能无法精确查询，针对这个问题，我也整理了一些检查组件是否被使用的方法。
检查当前数据库是否使用 Text 组件：
1SQL> SET pages 999 lines 120 trimout ON trimspool ON2COL objdep format a55 hea "Object Name (Type)"3COL refr format a35 hea "Object Reference (Type)"45SELECT OWNER||'.'||name||' ('||decode(TYPE, 'MATERIALIZED VIEW', 'MV', 'DIMENSION', 'DIM', 'EVALUATION CONTXT', 'EVALCTXT', 'PACKAGE BODY', 'PKGBDY', 'CUBE.DIMENSION', 'CUBE.DIM', TYPE)||')' objdep,6 referenced_owner||'.'||referenced_name||' ('||decode(referenced_type, 'EVALUATION CONTXT', 'EVALCTXT', 'NON-EXISTENT CONTXT', 'NO-EXIST', 'PACKAGE BODY', 'PKGBDY', 'CUBE.DIMENSION', 'CUBE.DIM', referenced_type)||')' refr7FROM dba_dependencies8WHERE referenced_OWNER ='CTXSYS'9 AND OWNER NOT IN ('PUBLIC', 'CTXSYS', 'SYS')10ORDER BY 1;如果需要卸载 Oracle Text，可以参考下方步骤：
1conn / as sysdba2@?/ctx/admin/catnoctx.sql3drop procedure sys.validate_context;检查当前数据库是否使用 Workspace Manager：
1SQL> REM srdc_owm_usage.sql - collect Oracle Workspace Manager usage2define SRDCNAME='OWM_USAGE'3SET MARKUP HTML ON PREFORMAT ON4set TERMOUT off FEEDBACK off VERIFY off TRIMSPOOL on HEADING off5COLUMN SRDCSPOOLNAME NOPRINT NEW_VALUE SRDCSPOOLNAME6select 'SRDC_'||upper('&&SRDCNAME')||'_'||upper(instance_name)||'_'||7 to_char(sysdate,'YYYYMMDD_HH24MISS') SRDCSPOOLNAME from v$instance;8set TERMOUT on MARKUP html preformat on9REM10spool &&SRDCSPOOLNAME..htm11select '+----------------------------------------------------+' from dual12union all13select '| Diagnostic-Name: '||'&&SRDCNAME' from dual14union all15select '| Timestamp: '||16 to_char(systimestamp,'YYYY-MM-DD HH24:MI:SS TZH:TZM') from dual17union all18select '| Machine: '||host_name from v$instance19union all20select '| Version: '||version from v$instance21union all22select '| DBName: '||name from v$database23union all24select '| Instance: '||instance_name from v$instance25union all26select '+----------------------------------------------------+' from dual27/28set HEADING on MARKUP html preformat off29REM === -- end of standard header -- ===30select comp_name,version,status from dba_registry where comp_id = 'OWM' ;31select table_name,owner,state from DBA_WM_VERSIONED_TABLES;3233select workspace, parent_workspace, owner, freeze_status, resolve_status from dba_workspaces;34select version, parent_version, workspace from ALL_VERSION_HVIEW;35spool off;36exit执行结果：
如果是安装未使用则显示以上结果。
卸载 Workspace Manager 组件：
1-- sys 用户执行2SQL> @$ORACLE_HOME/rdbms/admin/owmuinst.plb检查当前数据库是否使用 Spatial：
1SQL> col owner format a122col table_name format a353col column_name format a254select owner, table_name, column_name5from dba_tab_columns6where data_type = 'SDO_GEOMETRY'7and owner != 'MDSYS';89no rows selected如果数据库中不存在包含 SDO_GEOMETRY 列的表，则表示该数据库未使用 Spatial 功能。
卸载 Spatial 的步骤如下：
1conn / as sysdba23-- 检查组件是否被使用4set pages 2005col owner for a206col table_name for a307col column_name for a258select owner, table_name, column_name9from dba_tab_columns10where data_type = 'SDO_GEOMETRY'11and owner != 'MDSYS'12order by 1,2,3;1314-- 如果被使用，则需要先清理对象15-- drop Spatial indexes16set pagesize 017spool DropIndexes.sql18select 'drop index ' || owner || '.' || index_name ||';'19from dba_indexes where ityp_name = 'SPATIAL_INDEX';20spool off2122@DropIndexes.sql2324-- drop Spatial tables25set pagesize 026spool DropTables.sql27select 'drop table '|| owner ||'.'|| table_name||';'28from dba_tab_columns29where data_type = 'SDO_GEOMETRY'30and owner != 'MDSYS';31spool off3233@DropTables.sql3435-- 清空回收站36purge dba_recyclebin;3738-- remove Semantic support39@?/md/admin/semremov.sql4041-- drop MDSYS user42drop user MDSYS cascade;4344-- 一键卸载(多租户环境下也可以)，oracle 用户下执行，不在 sqlplus 执行：45[oracle@emcc:/home/oracle]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -e -u SYS -r -b SDO_deinst -d $ORACLE_HOME/md/admin deinssdo.sql46catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/SDO_deinst_catcon_2719568.lst]4748catcon::set_log_file_base_path: catcon: See [/home/oracle/SDO_deinst*.log] files for output generated by scripts4950catcon::set_log_file_base_path: catcon: See [/home/oracle/SDO_deinst_*.lst] files for spool files, if any5152Enter Password: 53catcon.pl: completed successfully5455-- drop all remaining public synonyms created for Spatial56set pagesize 057set feed off lines 120 trimout on trimspool on58spool dropsyn.sql59select 'drop public synonym "' || synonym_name || '";' from dba_synonyms where table_owner='MDSYS';60spool off;61@dropsyn.sql6263-- drop related user64drop user mddata cascade;65-- Only created as of release 11g:66drop user spatial_csw_admin_usr cascade;67drop user spatial_wfs_admin_usr cascade;注意
IMPORTANT NOTE: Spatial will still appear in V$OPTION but this is expected behavior as explained in Note:273573.1 - Removed Spatial Option But Spatial Still Appears In V$Option
检查当前数据库是否使用 XDB：
1SQL> define SRDCNAME='XDB_USAGE_CHECK'2set pagesize 200 verify off sqlprompt "" term off entmap off echo off3set markup html on spool on4COLUMN SRDCSPOOLNAME NOPRINT NEW_VALUE SRDCSPOOLNAME5select 'SRDC_'||upper('&&SRDCNAME')||'_'||upper(instance_name)||'_'||6 to_char(sysdate,'YYYYMMDD_HH24MISS') SRDCSPOOLNAME from v$instance;7spool &&SRDCSPOOLNAME..htm8select 'Diagnostic-Name: ' || '&&SRDCNAME' as "SRDC COLLECTION HEADER" from dual9union all10select 'Time: ' || to_char(systimestamp, 'YYYY-MM-DD HH24MISS TZHTZM' ) from dual11union all12select 'Machine: ' || host_name from v$instance13union all14select 'Version: '|| version from v$instance15union all16select 'DBName: '||name from v$database17union all18select 'Instance: '||instance_name from v$instance19/20set serveroutput on21alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS'22/2324define LOWTHRESHOLD=1025define MIDTHRESHOLD=6226define VERBOSE=TRUE2728set veri off;29set feedback off;30REM === -- end of standard header -- ===31set lines 150 trimspool on pages 50000 long 100000 tab off32set serveroutput on33set HEADING on MARKUP html preformat off34declare35 --define cursors36 --check for version37 cursor c_ver is select version from v$instance;38 --check for invalids owned by XDB39 cursor c_inval is select * from dba_objects where status='INVALID' and OWNER in ('SYS','XDB');40 -- Check status of other database features41 cursor c_feat is select comp_name,status,version from dba_registry;42 --check for xml type tables43 cursor c_xml_tabs is select owner,storage_type,count(*) "TOTAL" from dba_xml_tables group by owner,storage_type;44 --check for xml type colmns45 cursor c_xml_tab_cols is select owner,storage_type,count(*) "TOTAL" from dba_xml_tab_cols group by owner,storage_type;46 --check for xml type views47 cursor c_xml_vw is select owner,count(*) "TOTAL" from dba_xml_views group by owner;48 --check for xml type Indexes49 cursor c_xml_idx is select index_owner,type,count(*) "TOTAL" from dba_xml_indexes group by index_owner,type;50 --check for API's bbuilt with XML API's51 cursor c_api is select owner,name,type from dba_dependencies where referenced_name in52 (select object_name from dba_objects53 where object_name like 'DBMS_XML%' or object_name like 'DBMS_XSL%')54 and TYPE !='SYNONYM' and owner !='SYS';55 --check for registered Schemas56 cursor c_xml_schemas is select owner,count(*) "TOTAL" from dba_xml_schemas group by owner;57 --check for user defined resources in the repository58 cursor c_res is select distinct (a.username) "USER",count (r.xmldata) "TOTAL"59 from dba_users a, xdb.xdb$resource r60 where sys_op_rawtonum (extractvalue (value(r),'/Resource/OwnerID/text()')) =a.USER_ID group by a.username;61 -- check xdbconfig.xml values62 cursor c_config is select value(x).GETROOTELEMENT() NODENAME, extractValue(value(x),'/*') NODEVALUE63 from table(xmlsequence(extract(xdburitype('/xdbconfig.xml').getXML(),'//*[text()]'))) x;64 --check for Network ACLs65 cursor c_net_acls is select host, nvl(trim(lower_port),'NULL') l_port, nvl(trim(upper_port),'NULL') u_port from dba_network_acls;66 --define variables for fetching data from cursors67 v_ver c_ver%ROWTYPE;68 v_inval c_inval%ROWTYPE;69 v_feat c_feat%ROWTYPE;70 v_xml_tabs c_xml_tabs%ROWTYPE;71 v_xml_tab_cols c_xml_tab_cols%ROWTYPE;72 v_xml_vw c_xml_vw%rowtype;73 v_xml_idx c_xml_idx%rowtype;74 v_api c_api%rowtype;75 v_c_net_acls c_net_acls%rowtype;76 v_xml_schemas c_xml_schemas%rowtype;77 v_res c_res%ROWTYPE;78 v_config c_config%rowtype;79 -- Static variables80 v_errcode NUMBER := 0;81 v_errmsg varchar2(50) := ' ';82 l_dad_names DBMS_EPG.varchar2_table;83 --stylesheet for xdbconfig.xml reading84 v_style clob :='';85begin86 open c_ver;87 fetch c_ver into v_ver;88 --check minimum XDB requirements89 if v_ver.version like '9.%' or v_ver.version like '10.%' then90 DBMS_OUTPUT.PUT_LINE('!!!!!!!!!!!!! UNSUPPORTED VERSION !!!!!!!!!!!!!');91 DBMS_OUTPUT.PUT_LINE('Minimun version is 11.2.0.4. actual version is: '||v_ver.version);92 end if;93 DBMS_OUTPUT.PUT_LINE('############# Status/Version #############');94 DBMS_OUTPUT.PUT_LINE('XDB Status is: '||dbms_registry.status('XDB')||' at version '||dbms_registry.version('XDB'));95 if v_ver.version != dbms_registry.version('XDB') then96 DBMS_OUTPUT.PUT_LINE('Database is at version '||v_ver.version||' XDB is at version '||dbms_registry.version('XDB'));97 end if;98 --Check Status. If invalid, gather invalid objects list and check for usage. If valid, simply check for usage99 if dbms_registry.status('XDB') != 'VALID' then100 DBMS_OUTPUT.PUT_LINE('############# Invalid Objects #############');101 open c_inval;102 loop103 fetch c_inval into v_inval;104 DBMS_OUTPUT.PUT_LINE('Type: '||v_inval.object_type||' '||v_inval.owner||'.'||v_inval.object_name);105 exit when c_inval%NOTFOUND;106 end loop;107 close c_inval;108 end if;109 -- Check XDBCONFIG.XML paramareters110 DBMS_OUTPUT.PUT_LINE('############# OTHER DATABASE FEATURES #############');111 open c_feat;112 loop113 fetch c_feat into v_feat;114 exit when c_feat%NOTFOUND;115 if c_feat%rowcount >0 then116 DBMS_OUTPUT.PUT_LINE(v_feat.comp_name||' is '||v_feat.status||' at version '||v_feat.version);117 else DBMS_OUTPUT.PUT_LINE('No Data Found');118 end if;119 end loop;120 close c_feat;121 -- Check XDBCONFIG.XML paramareters122 DBMS_OUTPUT.PUT_LINE('############# XDBCONFIG INFORMATION #############');123 open c_config;124 loop125 fetch c_config into v_config;126 exit when c_config%NOTFOUND;127 if c_config%rowcount >0 then128 DBMS_OUTPUT.PUT_LINE(v_config.NODENAME||'= = = '||v_config.NODEVALUE);129 else DBMS_OUTPUT.PUT_LINE('No Data Found');130 end if;131 end loop;132 close c_config;133 -- Check if they have any xmltype tables or columns and if they are schema based, clob or binary134 DBMS_OUTPUT.PUT_LINE('############# XMLTYPE Tables #############');135 open c_xml_tabs;136 loop137 fetch c_xml_tabs into v_xml_tabs;138 exit when c_xml_tabs%NOTFOUND;139 DBMS_OUTPUT.PUT_LINE(v_xml_tabs.owner||' has '||v_xml_tabs.TOTAL||' XMLTYPE TABLES stored as '||v_xml_tabs.storage_type);140 end loop;141 close c_xml_tabs;142 DBMS_OUTPUT.PUT_LINE('############# XMLTYPE Columns #############');143 open c_xml_tab_cols;144 loop145 fetch c_xml_tab_cols into v_xml_tab_cols;146 exit when c_xml_tab_cols%NOTFOUND;147 if c_xml_tab_cols%rowcount > 0 then148 DBMS_OUTPUT.PUT_LINE(v_xml_tab_cols.owner||' has '||v_xml_tab_cols.TOTAL||' XMLTYPE Columns stored as ' ||v_xml_tab_cols.storage_type);149 else DBMS_OUTPUT.PUT_LINE('No Data Found');150 end if;151 end loop;152 close c_xml_tab_cols;153 DBMS_OUTPUT.PUT_LINE('############# XMLTYPE Views #############');154 open c_xml_vw;155 loop156 fetch c_xml_vw into v_xml_vw;157 exit when c_xml_vw%NOTFOUND;158 if c_xml_vw%rowcount > 0 then159 DBMS_OUTPUT.PUT_LINE(v_xml_vw.owner||' has '||v_xml_vw.TOTAL||' XMLTYPE Views');160 else DBMS_OUTPUT.PUT_LINE('No Data Found');161 end if;162 end loop;163 close c_xml_vw;164 DBMS_OUTPUT.PUT_LINE('############# XMLTYPE INDEXES #############');165 open c_xml_idx;166 loop167 fetch c_xml_idx into v_xml_idx;168 exit when c_xml_idx%NOTFOUND;169 if c_xml_idx%rowcount > 0 then170 DBMS_OUTPUT.PUT_LINE(v_xml_idx.index_owner||' has '||v_xml_idx.TOTAL||' XMLTYPE Indexes of type '||v_xml_idx.type);171 else DBMS_OUTPUT.PUT_LINE('No Data Found');172 end if;173 end loop;174 close c_xml_idx;175 DBMS_OUTPUT.PUT_LINE('############# Items built with XML API''s #############');176 open c_api;177 loop178 fetch c_api into v_api;179 exit when c_api%NOTFOUND;180 if c_api%rowcount > 0 then181 DBMS_OUTPUT.PUT_LINE(v_api.type||' '||v_api.owner||'.'||v_api.name);182 else DBMS_OUTPUT.PUT_LINE('No Data Found');183 end if;184 end loop;185 close c_api;186 DBMS_OUTPUT.PUT_LINE('############# XML SCHEMAS #############');187 open c_xml_schemas;188 loop189 fetch c_xml_schemas into v_xml_schemas;190 exit when c_xml_schemas%NOTFOUND;191 if c_xml_schemas%rowcount >0 then192 DBMS_OUTPUT.PUT_LINE(v_xml_schemas.owner||' has '||v_xml_schemas.TOTAL||' registered.');193 else DBMS_OUTPUT.PUT_LINE('No Data Found');194 end if;195 end loop;196 close c_xml_schemas;197 -- Check for repository resources198 DBMS_OUTPUT.PUT_LINE('############# Repository Resources #############');199 open c_res;200 loop201 fetch c_res into v_res;202 exit when c_res%NOTFOUND;203 if c_res%rowcount >0 then204 DBMS_OUTPUT.PUT_LINE(v_res.USER||' has '||v_res.TOTAL||' resources.');205 else DBMS_OUTPUT.PUT_LINE('No Data Found');206 end if;207 end loop;208 close c_res;209 -- Check Network ACLS210 DBMS_OUTPUT.PUT_LINE('############# Network ACLs Configured #############');211 open c_net_acls;212 loop213 fetch c_net_acls into v_c_net_acls;214 if c_net_acls%rowcount >0 then215 DBMS_OUTPUT.PUT_LINE(v_c_net_acls.host||' has network acls configured for ports '||v_c_net_acls.l_port||' through '|| v_c_net_acls.u_port);216 else DBMS_OUTPUT.PUT_LINE('No Data Found');217 end if;218 exit when c_net_acls%NOTFOUND;219 end loop;220 close c_net_acls;221 --Check DAD configuration to see if DBMS_EPG is being used222 DBMS_OUTPUT.put_line('############# DBMS_EPG DAD USAGE #############');223 DBMS_EPG.GET_DAD_LIST (l_dad_names);224 FOR i IN 1 .. l_dad_names.count LOOP225 DBMS_OUTPUT.put_line(l_dad_names(i));226 END LOOP;227 close c_ver;228EXCEPTION229WHEN no_data_found THEN230 DBMS_OUTPUT.PUT_LINE('No Data Found');231WHEN others THEN232 v_errcode := sqlcode;233 v_errmsg := SUBSTR(sqlerrm, 1, 50);234 DBMS_OUTPUT.PUT_LINE('ERROR: '||v_errcode||': ' || v_errmsg);235end;236/237--End XDB health and usage check238SET SERVEROUTPUT OFF239Rem===========================================================================================================================================240spool off241set markup html off spool off242set sqlprompt "SQL> " term on echo off243PROMPT244PROMPT245PROMPT REPORT GENERATED : &SRDCSPOOLNAME..htm246set verify on echo on247Rem===========================================================================================================================================248exit;检查结果很长，这里截取一段：
11GR2 卸载 XDB 步骤：
1-- 卸载 XDB2SQL> spool xdb_removal.log3set echo on;45connect / as sysdba6shutdown immediate;7startup8@?/rdbms/admin/catnoqm.sql9@?/rdbms/admin/catproc.sql10@?/rdbms/admin/utlrp.sql1112set pagesize 100013col owner format a814col object_name format a351516select owner, object_name, object_type, status17from dba_objects18where status = 'INVALID' and owner = 'SYS';1920spool off;2122-- 清理 XDB 相关的无效对象23SQL> connect / as sysdba2425-- Make XDB Dummy views26start ?/rdbms/admin/catxdbdv.sql2728-- update Data Pump related objects and KU$_ views2930start ?/rdbms/admin/dbmsmeta.sql31start ?/rdbms/admin/dbmsmeti.sql32start ?/rdbms/admin/dbmsmetu.sql33start ?/rdbms/admin/dbmsmetb.sql34start ?/rdbms/admin/dbmsmetd.sql35start ?/rdbms/admin/dbmsmet2.sql36start ?/rdbms/admin/catmeta.sql37start ?/rdbms/admin/prvtmeta.plb38start ?/rdbms/admin/prvtmeti.plb39start ?/rdbms/admin/prvtmetu.plb40start ?/rdbms/admin/prvtmetb.plb41start ?/rdbms/admin/prvtmetd.plb42start ?/rdbms/admin/prvtmet2.plb43start ?/rdbms/admin/catmet2.sql4445REM Check to verify that all components are valid46select COMP_ID, COMP_NAME, VERSION, STATUS from dba_registry;4748COMP_ID COMP_NAME VERSION STATUS49------- ------------------------------------ ------------ --------50CONTEXT Oracle Text 11.2.0.2.0 VALID51EXF Oracle Expression Filter 11.2.0.2.0 VALID52OWM Oracle Workspace Manager 11.2.0.2.0 VALID53CATALOG Oracle Database Catalog Views 11.2.0.2.0 VALID54CATPROC Oracle Database Packages and Types 11.2.0.2.0 VALID55RAC Oracle Real Application Clusters 11.2.0.2.0 VALID56JAVAVM JServer JAVA Virtual Machine 11.2.0.2.0 VALID57XML Oracle XDK 11.2.0.2.0 VALID58CATJAVA Oracle Database Java Packages 11.2.0.2.0 VALID59609 rows selected.6162select count(*) from dba_objects where status = 'INVALID'; -- no rows6364 COUNT(*)65---------66 0从 Oracle 12.1 版本开始，XDB 组件已经无法卸载，是必备组件。
检查当前数据库是否使用 OLAP：
1SQL> select VALUE from v$OPTION where PARAMETER = 'OLAP';23VALUE4----------------------------------------------------------------5TRUE67SQL> col owner format a1089SQL> col aw_name format a201011SQL> select owner, aw_name from dba_aws;1213OWNER AW_NAME14-------------------- ------------------------------15SYS AWREPORT16SYS AWXML17SYS AWMD18SYS AWCREATE10G19SYS EXPRESS20SYS AWCREATE如果都是 SYS 用户的对象，就说明没有使用 OLAP 组件。
卸载 OLAP：
1[oracle@emcc:/home/oracle]$ chopt disable olap23Writing to /u01/app/oracle/product/19.3.0/db/install/disable_olap_2025-06-04_16-11-48PM.log...4/usr/bin/make -f /u01/app/oracle/product/19.3.0/db/rdbms/lib/ins_rdbms.mk olap_off ORACLE_HOME=/u01/app/oracle/product/19.3.0/db5/usr/bin/make -f /u01/app/oracle/product/19.3.0/db/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/19.3.0/db删除 OLAPSYS 用户：
1SQL> drop user OLAPSYS cascade;2@?/rdbms/admin/utlrp.sql检查当前数据库是否使用 OJVM：
1SQL> SELECT version, status FROM dba_registry WHERE comp_id='JAVAVM';23VERSION STATUS4------------------------------ --------------------------------------------519.0.0.0.0 VALID67SQL> select * from gv$java_patching_status;89no rows selected1011SQL> select count(*) from x$kglob where KGLOBTYP = 29 OR KGLOBTYP = 56;1213 COUNT(*)14----------15 13131617SQL> select inst_id, name, con_id from gv$java_services order by name, con_id, inst_id;1819no rows selected2021SQL> col service_name format a2022col username format a2023col program format a2024set num 825select sess.service_name, sess.username,sess.program, count(*)26from27v$session sess,28dba_users usr,29x$kgllk lk,30x$kglob31where kgllkuse=saddr32and kgllkhdl=kglhdadr33and kglobtyp in (29,56)34and sess.user# = usr.user_id35and usr.oracle_maintained = 'N'36group by sess.service_name, sess.username, sess.program37order by sess.service_name, sess.username, sess.program;3839no rows selected检查当前数据库是否使用 APEX：
1SQL> select workspace, workspace_id from apex_workspaces;2select workspace, view_date, seconds_ago from apex_workspace_activity_log卸载 APEX 步骤：
1SQL> @?/apex/apxremov.sql如果你是 DBA，尤其在做合规性审核、数据库功能优化或迁移评估，这些内容一定对你有帮助。欢迎关注和分享！
参考资料：