Create SQL Plan Baselines for High Resource Intensive SQL's from AWR - 12C

=>   Identify SNAP ID's for the interval Here I am collecting resource intensive SQL's ran on a week from Monday (12-SEP-22) to F...

Read the full lesson

OCI VMDB System : Upgrade Database from 12c to 19c using dbcli

Environment : OCI VMDB System OS             : Oracle Linux 7 Note          : dbcli commands should be run as ROOT user =>  Obtain Pre-Au...

Read the full lesson

AWR Comparison Report

The awrddrpt.sql SQL script generates a report that compares performance attributes and configuration settings between two selected time per...

Read the full lesson

OCI VMDB System : Delete old Oracle Home post database upgrade using dbcli

After the database upgrade from 12c to 19c, you will find two Oracle Homes on the server. Follow below steps to delete 12c oracle home =>...

Read the full lesson

OCI VMDB System : Apply GI PSU using dbcli

Environment : OCI VMDB System OS : Oracle Linux 7 => dbcli commands should be run as root user. => Update dcs client and agent  [root@...

Read the full lesson