Overview of the awrinfo.sql script and its purpose within Oracle databases.

This script is used to gather information and generate reports on various aspects of the Automatic Workload Repository (AWR), which is a built-in Oracle feature that collects and stores performance-related data for the purpose of monitoring and diagnosing database performance issues. Key points from your description: Overall, the awrinfo.sql script serves as a valuable tool […]

Difference Between SQL Profiles and SQL Plan Baselines

SQL Profiles: SQL Plan Baselines: Interactions and When to Use: In conclusion, SQL Profiles enhance the optimizer’s decision-making process by providing additional information without restricting plan selection, while SQL Plan Baselines offer controlled and consistent performance by confining the choice of plans. The presence of a SQL Profile alongside a SQL plan baseline can affect […]

Oracle Flex ASM

Oracle Flex ASM is a feature introduced in Oracle Database 12c Release 2 (12.2) that enhances the flexibility and scalability of the Automatic Storage Management (ASM) storage solution. ASM is a volume manager and file system specifically designed for Oracle databases, providing simplified management of database files and automatic striping and mirroring of data for […]

Oracle 19c new features over Oracle 12c

Oracle 19c introduced several new features and enhancements over Oracle 12c for database administrators. Here are some key features: These are just some of the new features and enhancements introduced in Oracle 19c over Oracle 12c. It’s important to note that Oracle regularly releases patch sets and updates, so there may be additional features and […]