Curated Video
Oracle Database Administration from Zero to Hero - Using Database Links (Part 2 of 2)
In this video, we will continue our discussion on using database links. You will learn how to create database links, use them in synonyms, and understand using Global Name as a Loopback Database Link. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Using Database Links (Part 1 of 2)
In this video, we will explore the usage of database links. You will learn about database links, their types, and users, as well as understand naming database links. This clip is from the chapter "Managing Database Connectivity" of the...
Curated Video
Oracle Database Administration from Zero to Hero - Configuring Oracle Network Environment (Part 4 of 4)
In this video, we will conclude our discussion on configuring the Oracle network environment. You will learn how to use the Listener Control Utility and register database services in the listener. This clip is from the chapter "Managing...
Curated Video
Oracle Database Administration from Zero to Hero - Using Password File Authentication
In this video, you will learn about password file authentication. You will understand the concept, create a password file, set the REMOTE_LOGIN_PASSWORDFILE parameter, explore the relationship between OS authentication and password file...
Curated Video
Oracle Database Administration from Zero to Hero - Applying the Principle of Least Privileges
In this video, we will discuss the importance of applying the Principle of Least Privileges in Oracle databases. You will understand the concept and best practices for granting minimal privileges to users. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Querying Container Data Objects
In this video, we will focus on querying container data objects. You will learn how to query container data objects, set CONTAINER_DATA attributes for a common user, obtain information about CONTAINER_DATA attributes in a multitenant...
Curated Video
Oracle Database Administration from Zero to Hero - Managing User Profiles (Part 2 of 2)
In this video, we will continue our exploration of managing user profiles. You will learn how to enable password complexity verification functions, obtain information about user passwords and profiles, implement gradual password rollover...
Curated Video
Oracle Database Administration from Zero to Hero - Managing User Privileges (Part 1 of 2)
In this video, we will delve into managing user privileges. You will understand the difference between system and user privileges and learn how to manage system privileges. This clip is from the chapter "Managing Database Users and...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Database Users (Part 1 of 2)
In this video, you will learn about managing database users. You will understand the concepts of database users and schemas and explore predefined accounts in Oracle. This clip is from the chapter "Managing Database Users and Security"...
Curated Video
Oracle Database Administration from Zero to Hero - Using Table Compression (Part 2 of 2)
In this video, we will continue our discussion on table compression. You will learn about advanced compression techniques, obtain information about compression used in a database, and understand the Oracle Hybrid Columnar Compression...
Curated Video
Oracle Database Administration from Zero to Hero - Using Table Compression (Part 1 of 2)
In this video, we will explore the usage of table compression techniques. You will learn about basic compression and how to describe and apply it to optimize storage space. This clip is from the chapter "Managing Database Segments" of...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Using Deferred Segment Creation
In this practice video, we will gain hands-on experience with deferred segment creation in an Oracle database. You will examine the behavior of deferred segment creation and understand its impact on segment management. This clip is from...
Curated Video
Oracle Database Administration from Zero to Hero - Using Deferred Segment Creation
In this video, we will delve into the concept of deferred segment creation. You will understand how to leverage deferred segment creation to optimize space utilization and materialize database segments efficiently. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Shrinking Segments (Part 2 of 2)
In this video, we will continue our exploration of shrinking segments. You will learn how to shrink database segments, deallocate unused space, and move a table from its current location to improve segment utilization. This clip is from...
Curated Video
Oracle Database Administration from Zero to Hero - Shrinking Segments (Part 1 of 2)
In this video, you will learn about shrinking segments. You will understand the ROWID pseudocolumn and segment defragmentation, which are essential for optimizing storage space utilization. This clip is from the chapter "Managing...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Undo Data (Part 3 of 3)
In this video, we will further discuss managing undo data. You will learn how to enable undo guarantee, enable temporary undo, and choose between shared or local undo modes. This clip is from the chapter "Managing Oracle Database...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Resumable Space Allocation (Part 2 of 2)
In this video, we will continue our discussion on managing resumable space allocation. You will learn about operations that can be made resumable, setting the resumable space allocation timeout interval, using triggers to control...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Data Files
In this video, we will focus on managing data files within an Oracle database. You will learn how to resize data files, alter data file availability, rename and relocate data files, and drop a data file. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Database Storage Structures
In this video, we will focus on database storage structures. You will learn how to describe different database storage structures and specify the database standard block size. This clip is from the chapter "Managing Oracle Database...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Database Memory (Part 2 of 2)
In this practice video, you will continue exploring database memory management by implementing Automatic Shared Memory Management (ASMM) on srv1. You will practice configuring and fine-tuning shared memory components using ASMM. This...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Database Memory (Part 2 of 2)
In this video, we will further explore database memory management techniques. You will learn how to enable manual shared memory management, monitor the automatic memory management, and tune memory using advisors. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Database Memory (Part 1 of 2)
In this video, we will focus on managing database memory. You will learn how to enable Automatic Memory Management (AMM) and leverage the Automatic Shared Memory Management (ASMM) feature. This clip is from the chapter "Managing Oracle...
Curated Video
Oracle Database Administration from Zero to Hero - Database Memory Concepts (Part 2 of 2)
In this video, we will continue exploring database memory concepts. We will cover the shared pool, large pool, and redo log buffer, and understand how different application types impact the allocation of memory in the database. This clip...
Curated Video
Oracle Database Administration from Zero to Hero - Database Memory Concepts (Part 1 of 2)
In this video, we will delve into the database memory concepts. You will learn about the database buffer cache and its significance in optimizing database performance. This clip is from the chapter "Managing Oracle Database Components"...