Work in progres.
With the article Tuning SGA Oracle database, I describe the functionality of the Oracle database SGA created. The SGA of the Oracle database is the area of RAM that is used by the Oracle database and allocated during the startup phase. More specifically, nomount is allocated during the startup phase. Read more…
The Oracle Multitenant Database Architecture is designed to host multiple “PLUGGABLE DATABASE” PDB databases within a single CDB “CONTAINER DATABASE” container instance.The architecture of the CDB instance maintains more PDBs within it, using the same set of processes and the same SGA (System Global Area).Instead for the system components (control Read more…
In the article “Export and import with Data Pump,” I present the main methods for migrating data from one database to another. One of the best solutions for migrating a database is through export and import with Data Pump. This tool was introduced in Oracle 10g, and compared to the Read more…