Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
REFRN23389

DBA_SERVER_REGISTRY

DBA_SERVER_REGISTRY displays information about all server components in the database that are loaded into the component registry.

Column Datatype NULL Description
COMP_ID VARCHAR2(30) NOT NULL Component identifier
COMP_NAME VARCHAR2(255)   Component name
VERSION VARCHAR2(30)   Component version loaded
STATUS VARCHAR2(11)   Component status:
  • INVALID

  • VALID

  • LOADING

  • LOADED

  • UPGRADING

  • UPGRADED

  • DOWNGRADING

  • DOWNGRADED

  • REMOVING

  • REMOVED

MODIFIED VARCHAR2(20)   Time when the component was last modified
CONTROL VARCHAR2(30) NOT NULL User that created the component entry
SCHEMA VARCHAR2(30) NOT NULL User that contains the objects for the component
PROCEDURE VARCHAR2(61)   Validation procedure
STARTUP VARCHAR2(8)   Indicates whether the component requires a startup after the upgrade (REQUIRED) or not
PARENT_ID VARCHAR2(30)   Parent component identifier

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF