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 >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 >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 >