oracle-19c
-
What is Multitenant architecture in Oracle Database?
Oracle Multitenant is a database architecture that allows multiple databases to be installed and managed within a single Oracle Database instance. This architecture is designed to improve resource utilization, management, and security. In a multitenant database, each database is called a pluggable database (PDB). A PDB is a self-contained database that can be created, copied,… Continue reading
-
What is Automatic Query Quarantine in Oracle 19c?
Automatic Query Quarantine is a new feature in Oracle Database 19c that helps to protect your database from runaway queries. A runaway query is a query that consumes an excessive amount of system resources, such as CPU, memory, or I/O. When a runaway query is detected, Resource Manager can terminate the query. However, if the… Continue reading
-
What is difference between oracle 12c and 19c?
Oracle 19c is the successor to Oracle 12c, and it offers a number of new features and enhancements. Some of the key differences between the two versions include: These are just a few of the key differences between Oracle 12c and Oracle 19c. For a more complete list of features and enhancements, please refer to… Continue reading
-
Data Recovery Advisor in Oracle 19c
Data Recovery Advisor (DRA) is a new feature in Oracle 19c that helps you to diagnose and recover from data failures. DRA can automatically detect data corruption, analyze the impact of the corruption, and recommend repair options. DRA can also automatically repair data corruption, if you choose to do so. DRA is a powerful tool… Continue reading
-
Oracle 19c Important Parameters for Performance
Oracle Database 19c is a powerful and scalable database platform that can be used to support a wide variety of workloads. However, in order to achieve optimal performance, it is important to configure the database properly. One way to do this is to set the appropriate initialization parameters. The following are some of the most… Continue reading
About Me
Database Administrator
Categories