Ads block
Showing posts with label Oracle Database. Show all posts
Showing posts with label Oracle Database. Show all posts
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 »
