Managing Database Instances (part 3)
Oracle Database Metadata An Oracle Database contains two types of metadata views: Data dictionary views Dynamic performance views The SYS us...
Oracle Database Metadata An Oracle Database contains two types of metadata views: Data dictionary views Dynamic performance views The SYS us...
Shutting Down an Oracle Instance Just as with starting the database, several options as well as a variety of interfaces are available for da...
Starting Up an Oracle Instance Two special connection account authorizations are available for startup and shutdown: SYSDBA authorization i...
Oracle Storage Structures A-The Physical Structure : The physical storage structures include three types of files (Critical files that make ...
Oracle Background Process : A - Required Oracle background processes by the Oracle instance (found in all Oracle instances) : Database Wr...
Oracle Instance consists of Oracle’s main memory structure, called the system global area (SGA, also known as shared global area) and severa...
The Oracle server architecture can be described in three categories: Server processes that communicate with users processes and interact wit...