Ways of Identify High Load ot top SQL

There is various ways by which we can identify high load or top sql statements. The ways are listed below.

1)Automatic Database Diagnostic Monitor (ADDM)

2)Automatic Workload Repository(AWR)

3)V$SQL view

4)Custom Workload

5)SQL Trace

If you want to know the sql to identify high load sqls then the following post will help you.

http://arjudba.blogspot.com/2008/09/how-to-find-top-sql-through-queries.html

Related Documents
http://arjudba.blogspot.com/2008/08/how-to-invoke-collect-and-run-awr-and.html

http://arjudba.blogspot.com/2008/09/how-to-find-top-sql-through-queries.html

http://arjudba.blogspot.com/2008/08/difference-or-advantage-between-awr-and.html