SQL queries performance issue

1. At first enable the trace, at the beginning of the sqls.
2. Then check the trace file.
3. Using tkprof create the output file.
4. According to explain plan check the elapsed time for each query.
5. Then tune them

Please find the below methods for finding one of the query which is taking longer time in the batch script.

Methods :-
1) Put the dbms_output after each of the SQL query.
2) Create a logfile using the tkprof utility.
3) Best Method is take the AWR(Automatic Workload Repository) report from the database and find the particular query which is taking longer time to execute.