Oracle Database Administration from Zero to Hero - Practice - Managing Tablespaces (Part 2 of 2)

The video tutorial covers managing Oracle database storage structures, focusing on tablespaces. It begins with connecting to the CDB as a sys user and retrieving default tablespaces. The tutorial then observes data files in the database, noting the limitations of certain views. It demonstrates retrieving data files using specific views and changing containers to access different data files. The video explains methods to display tablespace space usage, including using SQL Developer for a GUI-based approach. The tutorial emphasizes the importance of monitoring tablespace usage and concludes with a brief overview of future learning topics.

How can SQL Developer be used to display tablespace space usage?

Evaluate responses using AI:

OFF

What is the significance of monitoring tablespace usage for an ADBA?

Evaluate responses using AI:

OFF

What actions should be taken when a tablespace is about to be full?

Evaluate responses using AI:

OFF