v)In which Tablespace should the scripts be executed ?
The script connects as SYSDBA and creates tables in SYS's default TS SYSTEM.Before running the script create a New TS for this purpose and change SYS's default TS to this new one.
Ater finishing running the both the scripts change once again SYS's default TS to SYSTEM.
Steps in gathering statistics
1)While first executing the UTLBSTAT script from the above path already mentioned....
2)The script creates BEGIN and END tables and takes the snapshot of data from the dynamic performance tables(V$xxx) to collect initial statistics and stores these in the BEGIN tables.
Steps in Ending statistics gathering
1)Execute the UTLESTAT as mentioned from the above path.
2)The script takes a new snapshot of data from the dynamic performace tables (V$xxx) to collect final statistics and stores these in the END tables.
3)The script creates DIFFERENCE tables where it stores the values of the substraction of the results of the initial statisctics from the final statistics.
4)The script drops all the temporary views and tables.
5)The script generates a report by selecting the data from the DIFFERENCE tables.
Based on the Report.txt file information you can understand which areas the tuning is required .