Multitenant

SQLs slow in 19c

Issue We patched our Oracle databases to 19.9 and this issue started. Some of our SQLs were slow and started taking longer to execute. We did not see this issue in an earlier release of 19c. Here is a pattern...

How to rename a PDB in 19c

Let's look at how to rename a PDB in 19c. The steps are the same as 12c. Per Oracle note referenced below, you must have the ALTER DATABASE privilege, either granted commonly or granted locally in the PDB. You must also have the RESTRICTED SESSION privilege, either...

Latest posts

Removing Oracle Application Express (APEX) on 19c database fails

Oracle APEX Release 21.1.0 was released on May 12, 2021. My 19c Oracle Database came with Oracle...
- Advertisement -

SQLs slow in 19c

Issue We patched our Oracle databases to 19.9 and this issue started. Some of...

Steps to remove OEM Agent

Recently I migrated all targets (Cluster, Databases, Instances, ASM, etc) and their jobs to a 13c OEM...

Must read

- Advertisement -

You might also likeRELATED
Recommended to you

SQLs slow in 19c

Issue We patched our...