Renaming a database in Oracle may seem like a daunting task, but with the help of the NID utility, it can be a relatively simple process. In this guide, we will walk you through the steps of renaming a database in Oracle using the NID utility, from shutting down the database to modifying the necessary … Read more
In this episode of Ask Tom TV, we will explore the concept of Direct Path Read in Oracle databases. Direct Path Read is a feature that allows the database to read data directly from disk and pass it directly to the process for processing, bypassing the buffer cache. This is particularly useful when dealing with … Read more
Welcome to this tutorial on Oracle DBA, where we will explore the process of finding and killing sessions in an Oracle database using SQL Developer. Sessions in Oracle consist of connections to the database by users from specific processes. Killing a session is necessary when the session becomes large and slows down the database. In … Read more
In this article, we will discuss the For Your Action (FYA) workflow in Oracle Workflow. As you may know, there are two types of workflows in Oracle Notifications: For Your Information (FYI) and For Your Action (FYA) notifications. The FYI notifications do not require any response and do not have any buttons for approval or … Read more
Introduction In this article, we will discuss the different types of concurrent managers in Oracle EBS R12. To effectively manage the concurrent managers, we can use the Concurrent Manager Administrator screen. We will explore the various types of concurrent managers and their roles in Oracle EBS R12. Internal Concurrent Manager (ICM) The Internal Concurrent Manager, … Read more
Oracle RAC 12c R1 rolling apply PSU patch demo Introduction In this article, we will be discussing how to install a Patch Set Update (PSU) on Oracle Real Application Clusters (RAC) 12c. A PSU is an update patch that helps keep your Oracle database system up to date and secure. We will provide a detailed … Read more
In this article, we will discuss the step-by-step process of starting and stopping the Oracle database server on Windows. By following these instructions, you will be able to effectively manage your Oracle database and ensure its smooth operation. So, let’s get started! Starting and Stopping Oracle Database To start and stop the Oracle database, we … Read more
Introduction Oracle Database is a powerful and widely used database management system that provides robust features and functionalities for enterprise applications. In this article, we will be discussing the new features introduced in Oracle Database 12cR1 and 12cR2, and how these enhancements have made it even more powerful and efficient. Oracle Database 12cR1: A Game … Read more
In this article, we will explore the process of performing backup, restore, and recovery activities in Oracle 12c, specifically using the RMAN (Recovery Manager) tool. We will be working with two databases, namely “prod” and “test_underscore.” Our action plan involves taking a backup of the prod database, dropping the database, and then restoring it from … Read more
In this article, we will delve into the world of Oracle Advanced Security in Oracle Database 12c and explore the features and functions of data redaction. As a product manager for Oracle Advanced Security, I will guide you through a comprehensive demo that showcases the capabilities of data redaction and how it can be implemented … Read more