Question on Oracle Dynamic View
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Question on Oracle Dynamic View

Hybrid View

  1. #1
    Join Date
    Feb 2014
    Posts
    2

    Lightbulb Question on Oracle Dynamic View

    Guys..

    Whenever a database is been brought into mounted state , still we can able to view some of the Oracle Dynamic View such as V$instance.etc but when a database enters into a Mount state the instance gets started and control file is opened. The control file is read (but it's contents are not validated ) plus data file is not yet open.Then How come still we are able to see the Dynamic View of the database in mount and no mount stage.

    Thanks in advance..

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    When you do a start up mount the only views that are available are c structures. Information that is provided by the pfile/spfile. When the database is in mount mode there are additional view available based on the information that is in the control file. At this time the existence of and contents of the control files are read and validated. i.e. are the control files corrupt. Then when you open the database the data and temp files are read and Oracle makes sure that all of the data and temp files are valid and in sync at the same SCN number. So most of what you said is true.

    c structures are data structures that don't rely on the data in the data files, hence they are considered to be statics and don't get stored with the data files.
    this space intentionally left blank

  3. #3
    Join Date
    Feb 2014
    Posts
    2
    Thanks for the clarification. Gandolf

    It really helped...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width