Summary of Oracle component series

 

The Oracle component information can be viewed through V $ option and dba_registry:

 

-- View v $ option:

V $ option displaysoracle Database options and features. typically, although not always, optionsmust be separately licensed, whereas features come with the product and areenabled based on the product that is running (Standard Edition, parameter iseedition, and so on ).

 

SQL> select * from V $ option;

 

Parameter Value

------------------------------------------------------

Partitioning true

Objects true

Real Application Clusters false

Advanced Replication true

Bit-mapped indexes true

Connection multiplexing true

Connection Pooling true

Database queuing true

Incremental backup and recovery true

Instead-of triggers true

Parallel backup and recovery true

 

Parameter Value

------------------------------------------------------

Parallel Execution true

Parallel load true

Point-in-time tablespace recovery true

Fine-grained access control true

Proxy authentication/authorization true

Change Data Capture true

Plan stability true

Online Index build true

Coalesce index true

Managed standby true

Materialized View rewrite true

 

Parameter Value

------------------------------------------------------

Materialized View warehouse refresh true

Database Resource Manager true

Spatial true

Automatic Storage Management false

Export transportable tablespaces true

Transparent application failover true

Fast-start fault recovery true

Sample scan true

Duplexed backups true

Java true

OLAP window functions true

 

Parameter Value

------------------------------------------------------

Block Media recovery true

Fine-grained auditing true

Application role true

Enterprise user security true

Oracle Data guard true

Oracle Label Security false

OLAP true

Basic compression true

Join index true

Trial recovery true

Data Mining true

 

Parameter Value

------------------------------------------------------

Online redefinition true

Streams capture true

File mapping true

Block change tracking true

Flashback table true

Flashback database true

Transparent Data Encryption true

Backup encryption true

Unused block compression true

Oracle Database Vault false

Result cache true

 

Parameter Value

------------------------------------------------------

SQL Plan Management true

Securefiles encryption true

Real application testing true

Flashback data archive true

DICOM true

Active Data guard true

Server flash cache true

Advanced compression true

Xstream true

Deferred segment creation true

 

65 rows selected.

 

SQL>

 

-- View dba_registry:

SQL> select comp_id, comp_name fromdba_registry;

 

Comp_id comp_name

-------------------------------------------------

Owb

Apex Oracle Application Express

Em Oracle Enterprise Manager

Amd olap catalog

SDO spatial

Ordim Oracle multimedia

XDB Oracle XML Database

Context Oracle Text

Exf Oracle Expression Filter

RUL Oracle Rules Manager

Owm Oracle Workspace Manager

 

Comp_id comp_name

-------------------------------------------------

Catalog Oracle Database catalog views

Catproc Oracle database packages and types

JavaVM jserver Java Virtual Machine

XML Oracle xdk

Catjava Oracle Database Java packages

Aps olap analytic Workspace

Xoq Oracle OLAP API

 

18 rows selected.

 

 

For these components, MOS has the following articles:

Oracle 8i/9i/10g/11g component (components) Description

Http://blog.csdn.net/tianlesoftware/article/details/5937382

 

The link for rebuilding some components is as follows:

 

Invalid of the OLAP catalog component after Oracle 9i upgrade

Http://blog.csdn.net/tianlesoftware/article/details/5937372

 

Oracle OLAP Component Reconstruction

Http://blog.csdn.net/tianlesoftware/article/details/7321333

 

Oracle XDB component reconstruction description

Http://blog.csdn.net/tianlesoftware/article/details/7323139

 

 

Oracle ORA-31000: Resource 'HTTP: // xmlns.oracle.com/xdb/acl.xsd' is not an XDB schema Solution

Http://blog.csdn.net/tianlesoftware/article/details/7323193

 

Oracle JavaVM component reload description

Http://blog.csdn.net/tianlesoftware/article/details/7334414

 

Oracle Spatial Component Description

Http://blog.csdn.net/tianlesoftware/article/details/7334440

 

 

Oracle Text Component Description

Http://blog.csdn.net/tianlesoftware/article/details/7334639

 

Oracle datamining Component Description

Http://blog.csdn.net/tianlesoftware/article/details/7336775

 

Oracle xdk Component Description

Http://blog.csdn.net/tianlesoftware/article/details/7337205

 

Oracleworkspace Manager Component Description

Http://blog.csdn.net/tianlesoftware/article/details/7339652

 

Oracle rulesmanager and Oracle Expression Filter components

Http://blog.csdn.net/tianlesoftware/article/details/7339939

 

Oracleenterprise Manager Component Description

Http://blog.csdn.net/tianlesoftware/article/details/7339962

 

 

Different components correspond to different users, as shown in the following table:

 

Outln: theaccount that supports plan stability. plan stability prevents certain databaseenvironment changes from affecting the performance characteristics ofapplications by preserving execution plans in stored outlines. outln actsas a role to centrally manage metadata associated with stored outlines.

 

 

 

 

 

 

Bytes -------------------------------------------------------------------------------------------------------

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Skype: tianlesoftware

Email: tianlesoftware@gmail.com

Blog: http://www.tianlesoftware.com

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

LinkedIn: http://cn.linkedin.com/in/tianlesoftware

 

 

------- Add a group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, reject the application ----

Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 dba5 group: 142216823

Dba6 group: 158654907 dba7 group: 172855474 DBA group: 104207940