What are the different types of tablespaces available in Oracle Database & their purpose?

 In an Oracle database, tablespaces are fundamental to how data is organized and managed. They act as logical containers for storing various types of data. Here's a breakdown of the key tablespace types: 

1. SYSTEM Tablespace

• Purpose: This is the most crucial tablespace. It houses the data dictionary, which contains metadata about the entire database. This includes information about users, tables, indexes, and other database objects.

What is the purpose of using tablespaces in Oracle Database?

Tablespaces serve several crucial purposes in Oracle databases, all contributing to better organization, performance, and manageability. Here's a breakdown of the key reasons for using them:   

Logical Data Organization: Tablespaces provide a logical layer of abstraction between the physical datafiles and the database objects (tables, indexes, etc.). This allows you to organize data logically, grouping related objects together.  For example, you might have a tablespace for application data, another for user data, and another for indexes. This logical separation simplifies management and makes it easier to understand the structure of your data. 

What are tablespaces in Oracle Database?

 In Oracle Database, a tablespace is a fundamental unit of logical storage. Think of it as a container that holds data for your database objects, such as tables, indexes, and other data. Here's a breakdown of what they are and why they're important:   

How do you determine the optimal SGA value for a given workload?

How to configure System Global Area (SGA) for your Oracle database? How do you know how much shared memory you need to provide to your database? 

Determining the optimal SGA size for a given workload is a crucial aspect of Oracle database performance tuning. It involves a combination of analysis, testing, and iterative adjustments. Here's a breakdown of the process:

Detailed Explanation to SGA Components in Oracle Database

What is the role & impact of different SGA components? 

The System Global Area (SGA) is a crucial memory area in Oracle databases, shared by all server processes and background processes.  It holds data and control information for a single database instance, significantly impacting performance.  Efficient management of the SGA is essential for optimal database operation. Here's a more detailed look at its components:

What are the main components of the SGA in Oracle Database 19c?

The System Global Area (SGA) in Oracle Database 19c is a crucial memory area that stores data and control information for a single Oracle Database instance. It's shared by all server and background processes. Here are the main components:

Relocate a PDB from SOURCE to TARGET CDB

How to relocate a pluggable database (PDB) from 1 Container database (CDB) to another CDB?

This article talk about PDB relocation i.e. simply migrating and attaching a PDB from 1 CDB to another CDB. The process is almost similar to a normal PDB clone but since we are migrating a DB here so there are variations as well.

For this exercise, I am using Oracle 19c, with 2 CDBs named CDB1, running on 2 separate VMs. Here is the simple picture,