A series of scripts that I commonly use - feel free to use them as you see fit.
They are, of course, subject to the limitations that they are supplied "as is" without any warranty, expressed or otherwise. Essentially you use them at your own risk and it would be sensible that you check that they function in a manner you require, on a non production system, before you use them in anger.
| Script | Description |
|---|---|
| mgmt_p_get_max_compression_order.prc | A procedure used to determine the optimal ordering of data within a table to gain maximum segment compression. |
| mgmt_r_check_pel.sql | A script used to check a source table and a target table prior to an EXCHANGE PARTITION - useful for identifying reasons why a source will not exchange to the target. |
| get_query_progress.sql | A script used to check where a query has got to in it's execution. |