Jump to content
Esu X

How we could tuning top sql queries from AWR without using sql advisor?

Recommended Posts

How we could tuning top sql queries from AWR without using sql advisor? How to check for better execution plan? How to check if better sql profile/baseline should be used?
I would like to see an examples how to do it... thank you in advance.

Share this post


Link to post
Share on other sites

Hi Esu, 

You just asked questions that would take hundreds of pages to explain!

I would recommend my book, for a complete methodology on SQL tuning:

http://rampant-books.com/book_1001_oracle_sql_tuning.htm

I have tons of information on my site, just use my site search tool st the top of the left-hand bar:

http://www.dba-oracle.com/

I don’t use the SQL tuning advisor because a human can always do a better job.

The data from AWR is stored in tables, ready to extract:

http://www.dba-oracle.com/oracle10g_tuning/t_awr_sql.htm

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×