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?