OracleOracle data block recovery
Recovering corrupted data blocks in Oracle Database is an essential technique to preserve data integrity without having to restore the…
OracleOracle DBMS_SCHEDULER vs DBMS_JOB: a single package to manage, pause, and monitor jobs
Introduction Many Oracle environments run two scheduling mechanisms side by side: DBMS_SCHEDULER (modern) and DBMS_JOB (legacy). Each has its own…
OracleOracle storage structures
How does Oracle store data? The Oracle Database storage structure is designed to be highly efficient and flexible, allowing large…
OracleOracle Database startup/shutdown phases
Starting the Oracle database instance Before users can connect to a database instance, a database administrator must start the database…
OracleViews in Oracle
Views are a very useful resource in relational databases: they let you create logical representations of the data stored in…
OracleHow to use hints in Oracle?
The super dictionary of Oracle hints When you work with Oracle, an important part of optimizing SQL query performance is…
OracleHow to create an Oracle 19c database in silent mode
Creating a single instance CDB database in silent mode After installing the database management system (DBMS), the next step is…
OracleHow to install Oracle Database 19c on Oracle Linux
Oracle Database 19c on Oracle Linux 7.9 in silent mode To install Oracle Database 19c, the operating system must be…
OracleUnderstanding the execution plan in Oracle: how to improve your SQL query performance (part 1)
The power of SQL and the performance challenge One of the great advantages of SQL is its declarative nature. That…
![[SCRIPT] – showplan.sql](https://furushima.com.br/wp-content/uploads/2025/01/SQL.png)
Oracle[SCRIPT] – showplan.sql
How do you know which part of the plan your query is spending the most time on?