Curated Video
Oracle Database Administration from Zero to Hero - Managing Roles (Part 2 of 2)
In this video, we will continue our discussion on managing roles. You will learn how to use password-protected roles, understand the usage of the PUBLIC role, drop roles, obtain information about granted privileges and roles, and follow...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Roles (Part 1 of 2)
In this video, we will explore the usage of roles in managing database users. You will understand the purpose of using roles, list predefined roles, and learn how to create and use roles. This clip is from the chapter "Managing Database...
Curated Video
Oracle Database Administration from Zero to Hero - Managing User Privileges (Part 2 of 2)
In this video, we will continue our discussion on managing user privileges. You will learn how to manage object privileges and understand the cascading effects in system and object privileges. This clip is from the chapter "Managing...
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 2 of 2)
In this video, we will continue our exploration of managing database users. You will learn how to create a database user with database authentication, convert a user to a schema-only account, manage tablespace quotas for 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 - 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 - Practice - Shrinking Segments
In this practice video, you will learn by doing. You will create a testing table, intentionally make it fragmented, and then practice shrinking the segments to reclaim unused space. This clip is from the chapter "Managing Database...
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 Undo Data (Part 2 of 3)
In this video, we will continue exploring the management of undo data. You will learn how to tune undo data and leverage the undo advisor for performance optimization. This clip is from the chapter "Managing Oracle Database Components"...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Undo Data (Part 1 of 3)
In this video, we will dive into managing undo data within an Oracle Database. You will learn about the benefits of undo, tasks involved in undo space management, and setting undo management parameters and retention. This clip is from...
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 Resumable Space Allocation (Part 1 of 2)
In this video, we will explore the concept of resumable space allocation. You will learn how to describe resumable space allocation, enable it, and understand its benefits. This clip is from the chapter "Managing Oracle Database...
Curated Video
Oracle Database Administration from Zero to Hero - Practice - Managing Data Files
In this practice video, you will implement various tasks involved in managing data files in Oracle databases. You will practice relocating data files online and offline and removing unavailable data files from a container. This clip is...
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 - Practice - Managing Tablespaces (Part 1 of 2)
In this practice video, you will gain hands-on experience managing Oracle database storage structures, specifically tablespaces. You will examine segments, extents, and data blocks and practice managing tablespaces. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Tablespaces (Part 4 of 4)
In this video, we will further discuss the management of tablespaces. You will learn how to alter tablespace availability, make tablespaces read-only or read-write, and assign specific quota on tablespaces to users. This clip is from the...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Tablespaces (Part 3 of 4)
In this video, we will continue exploring the management of tablespaces. You will learn how to enlarge tablespaces, drop tablespaces, create or move tables into tablespaces, and create Bigfile tablespaces. This clip is from the chapter...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Tablespaces (Part 2 of 4)
In this video, we will delve into managing tablespaces. You will learn about Oracle-Managed Files (OMF), how to enable them, and how to obtain information about tablespaces. This clip is from the chapter "Managing Oracle Database...
Curated Video
Oracle Database Administration from Zero to Hero - Managing Tablespaces (Part 1 of 4)
In this video, we will cover the management of tablespaces. You will learn about different types of tablespaces and gain knowledge on creating permanent tablespaces. This clip is from the chapter "Managing Oracle Database Components" of...
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...