Exporting Data in Parallel
I recently had a customer that needed to export data from a huge table to a different machine in csv format very fast. The Database was Standard Edition 2 (SE2) so there was no Parallel Query Option to use.
PL/SQL script: Check a Oracle View
This PL/SQL script can be used to find issues with Oracle Views. For example it shows data type conversions being done that could result in an sub optimal plan.
PL/SQL script: Empty schema
This PL/SQL script can be used to remove all objects of one ore more schemas. This might be used in preparation of an DataPump import.
PL/SQL script: Resizing Oracle Redo Logs
This PL/SQL script can be used to resize Oracle Redo Logfiles. All existing logfile members of all groups will be resized to a specific size.