1. I would like to know how to find SQL statements that are not performing well. Is there any script for this.
2. Is re-allocating indexes from one tablespace to another at the same time rebuilding them relieve space on the original tablespace.
3. If I perform a full database export and import will it compress the database and give me some good performance?