Homepage DBA-MAN


Featured Post

Managing Database Instances (part 4)

Managing Initialization-Parameter Files Oracle uses initialization-parameter files to store information about initialization parameters use...

Salah Quddomi 8 Mar, 2023

Latest Posts

Managing Database Instances (part 4)

Managing Initialization-Parameter Files Oracle uses initialization-parameter files to store information about initialization parameters use...

Salah Quddomi 8 Mar, 2023

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...

Salah Quddomi 8 Mar, 2023

Managing Database Instances (part 2)

Shutting Down an Oracle Instance Just as with starting the database, several options as well as a variety of interfaces are available for da...

Salah Quddomi 8 Mar, 2023

Managing Database Instances (part 1)

Starting Up an Oracle Instance Two special connection account authorizations are available for startup and shutdown:  SYSDBA authorization i...

Salah Quddomi 8 Mar, 2023

Oracle Database Architecture (Part 04)

Oracle Storage Structures A-The Physical Structure : The physical storage structures include three types of files (Critical files that make ...

Salah Quddomi 27 Feb, 2023

Oracle Database Architecture (Part 03)

Oracle Background Process : A - Required Oracle background processes by the Oracle instance (found in all Oracle instances) : Database Wr...

Salah Quddomi 24 Feb, 2023

Oracle Database Architecture (Part 02)

Oracle Instance consists of Oracle’s main memory structure, called the system global area (SGA, also known as shared global area) and severa...

Salah Quddomi 20 Feb, 2023