Author: Anton Kravchenko

How to get information from multiple PDBs

Not so long ago, I was faced with a request to collect information from several schemas located in multiple CDB databases. This can be done by connecting to each CDB, switching to a particular PDB, and retrieving the required information…

Read More >

Practical Tips For Moving Indexes Between Tablespaces

tablespaces

From time to time, a simple request to reorganize space in a tablespace leads to a more complex solution. Here’s how we moved  indexes between tablespaces.       A client requested we reduce the size of an Automatic Storage…

Read More >

Needles and Pins

Sometimes clients ask us to implement scripts that change objects in their schemes. In order to prevent the situation when these scripts hung just because some, or several, objects are pinned. Here are two simple procedures that can help to check what we will get during our maintenance.

Read More >