Loading ...
Sorry, an error occurred while loading the content.

Types of Metadata Views in Oracle 10g

Expand Messages
  • m arju
    Visit http://arjudba.blogspot.com/2008/04/types-of-metadata-views-in-oracle-10g.html Types of Metadata Views in Oracle 10g Metadata indicates data about the
    Message 1 of 1 , Jun 30 2:56 AM
    • 0 Attachment
      Visit http://arjudba.blogspot.com/2008/04/types-of-metadata-views-in-oracle-10g.html

      Types of Metadata Views in Oracle 10g
      Metadata indicates data about the database. As a DBA we need frequently
      access the metadata in oracle database. There are two types of metadata
      views.

      1)Data dictionary views.
      2)Dynamic performance views.

      Comparison between these Two:

      A)Data dictionary views have names that begin with DBA_,ALL_, and USER_.Dynamic performance views have names that begin with V$.

      B)The
      DBA_ views are available only when the database is open and
      running.Some V$ views are available even when the database is not fully
      open and running.

      http://arjudba.blogspot.com/2008/04/types-of-metadata-views-in-oracle-10g.html


      __________________________________________________________
      Not happy with your email address?.
      Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.