DBA_ASSEMBLIES view tips

Oracle Tips by Burleson Consulting

DBA_ASSEMBLIES

<< Return to the index

Oracle 11g makes the following comments about the DBA_ASSEMBLIES table: "Description of all assemblies in the database"

Column description of the DBA_ASSEMBLIES view:

OWNER

Description of DBA_ASSEMBLIES.OWNER: "Owner of the assembly"

ASSEMBLY_NAME

Description of DBA_ASSEMBLIES.ASSEMBLY_NAME: "Name of the assembly"

FILE_SPEC

Description of DBA_ASSEMBLIES.FILE_SPEC: "Operating system file specification of the assembly"

SECURITY_LEVEL

Description of DBA_ASSEMBLIES.SECURITY_LEVEL: "The maximum security level of the assembly"

IDENTITY

Description of DBA_ASSEMBLIES.IDENTITY: "The identity of the assembly"

STATUS

Description of DBA_ASSEMBLIES.STATUS: "Status of the assembly"

DBA_ASSEMBLIES View Source

Oracle 11g's data dictionary defines the DBA_ASSEMBLIES view using the following source query:

select u.name,
o.name,
a.filespec,
decode(a.security_level, 0, 'SAFE', 1, 'EXTERNAL_1', 2, 'EXTERNAL_2',
3, 'EXTERNAL_3', 4, 'UNSAFE'),
a.identity,
decode(o.status, 0, 'N/A', 1, 'VALID', 'INVALID')
from sys."_CURRENT_EDITION_OBJ" o, sys.assembly$ a, sys.user$ u
where o.owner# = u.user#
and o.obj# = a.obj#

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books