Ads block
Wait events in AWR
In an Oracle AWR (Automatic Workload Repository) report , wait events indicate where database sessions spend time while not executing. These are crucial for i…
Read more »
Monitor Active and Pending Transactions and Parallel Queries
Find active transactions in oracle database: col name format a10 col username format a8 col osuser format a8 col start_time format a17 col status format a12 tt…
Read more »
SQL Profile
Creating a SQL Profile in Oracle is a common method used to influence the optimizer to choose a better execution plan without changing the SQL text. A SQL Pr…
Read more »
Analyzing AWR (Automatic Workload Repository)
Reading an AWR (Automatic Workload Repository) report in Oracle can help DBAs analyze database performance over a specified time period. The AWR report capt…
Read more »
Fixing Execution Plans
To C heck if the execution plan of an Oracle query has changed and how to fix (stabilize or restore) it , you can follow a step-by-step process. This include…
Read more »
