Day: September 22, 2022

Blocking sessions are a problem for the DBA which occur when a session issues an insert, update or delete command that changes a row. When the change occurs, the row is locked until the session either commits the change, rolls the change back or the user logs off the system.  Show Active Session: We can … Read more

Automatic Workload Repository (AWR) is a licensed feature that allows information to be recorded on a database for multiple purposes including detection and elimination of performance issues. AWR reports are an extremely useful diagnostic tool for the determination of the potential cause of database wide performance issues. Typically when a performance issue is detected, you … Read more