DBA_TYPE_METHODS view tips

Oracle Tips by Burleson Consulting

DBA_TYPE_METHODS

<< Return to the index

Oracle 11g makes the following comments about the DBA_TYPE_METHODS table: "Description of methods of all types in the database"

Related notes on DBA_TYPE_METHODS:

Column description of the DBA_TYPE_METHODS view:

OWNER

Description of DBA_TYPE_METHODS.OWNER: "Owner of the type"

TYPE_NAME

Description of DBA_TYPE_METHODS.TYPE_NAME: "Name of the type"

METHOD_NAME

Description of DBA_TYPE_METHODS.METHOD_NAME: "Name of the method"

METHOD_NO

Description of DBA_TYPE_METHODS.METHOD_NO: "Method number for distinguishing overloaded method (not to be used as ID number)"

METHOD_TYPE

Description of DBA_TYPE_METHODS.METHOD_TYPE: "Type of the method"

PARAMETERS

Description of DBA_TYPE_METHODS.PARAMETERS: "Number of parameters to the method"

RESULTS

Description of DBA_TYPE_METHODS.RESULTS: "Number of results returned by the method"

FINAL

Description of DBA_TYPE_METHODS.FINAL: "Is the method final ?"

INSTANTIABLE

Description of DBA_TYPE_METHODS.INSTANTIABLE: "Is the method instantiable ?"

OVERRIDING

Description of DBA_TYPE_METHODS.OVERRIDING: "Is the method overriding a supertype method ?"

INHERITED

Description of DBA_TYPE_METHODS.INHERITED: "Is the method inherited from the supertype ?"

DBA_TYPE_METHODS View Source

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

select u.name, o.name, m.name, m.method#,
decode(bitand(m.properties, 512), 512, 'MAP',
decode(bitand(m.properties, 2048), 2048, 'ORDER', 'PUBLIC')),
m.parameters#, m.results,
decode(bitand(m.properties, 8), 8, 'NO', 'YES'),
decode(bitand(m.properties, 65536), 65536, 'NO', 'YES'),
decode(bitand(m.properties, 131072), 131072, 'YES', 'NO'),
decode(bitand(nvl(m.xflags,0), 1), 1, 'YES', 'NO')
from sys.user$ u, sys."_CURRENT_EDITION_OBJ" o, sys.method$ m
where o.owner# = u.user#
and o.type# <> 10 -- must not be invalid
and o.oid$ = m.toid
and o.subname IS NULL -- get the latest version only

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