| mohamed riaz |
Posted: Apr 23, 2008 11:07:25 AM |
Total Post: 95
Joined: Sep, 2006
|
Can anyone post me the steps for tuning SQL query when that query is slow?
|
|
|
 GOPU |
| Posted: Apr 23, 2008 11:38:01 PM |  |
|
Total Post: 333
Joined: Apr, 2008
|
Hi,
for tuning the query we have to do the followings.
1.Gather the statistics and rebuild the indexes
2.If the transaction table is very updating then reset the high water mark.
3.Check indexes are there or not.If it is there and its not working properly then find out why.
4.If the database is warehousing then try to partition table and materialized view.
Gopu
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: Apr 24, 2008 12:23:02 AM | |
|
Total Post: 127
Joined: Apr, 2008
|
To tuning quarry you can do the following:
1. gather the table statistics.
2. Trace the execution plane of your quarry ( to see how visit : http://sharear.blogspot.com/2007/04/enable-autotrace.html )
3. if you have index on tables, ensure those are used or create new index
4. rebuild existing index.
|
|
|
|
|
| Murtuja |
| Posted: Apr 24, 2008 02:49:28 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
http://www.dba-oracle.com/art_sql_tune.htm
HTH
|
|
|
|
|
| mohamed riaz |
| Posted: Apr 24, 2008 09:46:07 AM | |
|
Total Post: 95
Joined: Sep, 2006
|
Thanks for the reply. but when the SQL query is slow as a DBA what are the actions we have to take?
|
|
|
|
|
| Murtuja |
| Posted: Apr 26, 2008 09:56:42 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi Mohamed,
Have you read from all the links which I have provided you?
There is no alternative of reading in Oracle DBA world. If you want to learn anything then you need to read lot of documentation.
Please don't get me wrong, You can really get benefit from my advice.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
