oracle
-
Oracle 19c Snapshot Backup
Oracle 19c introduces a new feature called snapshot backup. Snapshot backups are a type of backup that creates a point-in-time copy of the database without affecting the availability of the database. This makes snapshot backups ideal for disaster recovery and data protection. Snapshot backups offer a number of advantages over traditional full or incremental backups.… Continue reading
-
Oracle 19c New Features : The SQL diagnostics and repair tools
Oracle Database 19c introduces a number of new features for diagnosing and repairing SQL statements. These features can help you to identify and resolve performance problems, as well as to improve the reliability of your SQL statements. The following are some of the new SQL diagnostics and repair tools in Oracle 19c: These new tools… Continue reading
-
Oracle 19c New Features : Hybrid Partitioned Tables
Oracle Database 19c introduces a new type of table called Hybrid Partitioned Tables. Hybrid Partitioned Tables allow you to store data in both internal and external storage. This can be a great way to improve the performance of your queries and reduce the amount of storage space required. Internal partitions are stored in the Oracle… Continue reading
-
Oracle 19c New Features:Memoptimized Rowstore
Memoptimized Rowstore in Oracle 19c Oracle Database 19c introduces a new storage format called Memoptimized Rowstore. Memoptimized Rowstore is a hybrid storage format that combines the benefits of both traditional rowstore and columnstore. Memoptimized Rowstore is designed for applications that require high performance for both OLTP and OLAP workloads. It is particularly well-suited for applications… Continue reading
-
Oracle 19c New Features: Automatic Indexing
Oracle Database 19c introduces a new feature called Automatic Indexing. Automatic Indexing is a feature that automatically creates, maintains, and drops indexes for you. This can help you to improve the performance of your queries without having to manually create and maintain indexes. Automatic Indexing works by analyzing your workload and identifying opportunities to create… Continue reading
-
Oracle 19c New Features: Support for Machine Learning
Oracle Database 19c is the latest version of Oracle’s flagship database product. It introduces a number of new features and enhancements, including support for machine learning. Machine learning is a powerful technology that can be used to automate tasks, improve decision-making, and discover new insights from data. Oracle Database 19c makes it easy to use… Continue reading
-
Oracle 19c New Features: Support for In-Memory Data
Oracle Database 19c is the latest version of Oracle’s flagship database product. It introduces a number of new features and enhancements, including support for in-memory data. In-memory data is a key technology for modern applications. It can be used to improve performance, scalability, and agility. Oracle Database 19c makes it easy to store and process… Continue reading
-
Oracle 19c Architecture
Oracle Database 19c is a relational database management system (RDBMS) developed by Oracle Corporation. It is the latest version of Oracle Database, and it offers a number of new features and enhancements over previous versions. One of the key features of Oracle Database 19c is its support for Real Application Clusters (RAC). RAC is a… Continue reading
-
Tuning the PGA in Oracle Database
PGA is a memory area that is allocated to each Oracle Database session. It is used to store session-specific data, such as SQL statements, cursors, and temporary tables. The PGA can be a bottleneck if it is not properly tuned. This can lead to performance problems, such as slow query execution, high CPU usage, and… Continue reading
-
How to Set Up CDB/PDB in Oracle Database
Oracle Database 12c introduced a new architecture called Multitenant, which allows multiple independent databases to be run within a single Oracle Database instance. This architecture is known as Container Database (CDB) and Pluggable Database (PDB). A CDB is a single Oracle Database instance that can contain multiple PDBs. A PDB is a self-contained database that… Continue reading
About Me
Database Administrator
Categories