Jul 7 2008, 03:45 AM
I am not really a specialist in SQL tuning and currently
covering the DBA who seems to be away today. We have some
queries which are consuming a lot of i/o and memory.
I understand I can upload a statspack report for analysis and
recommendations and was wondering whether there was something
similar where I can upload a SQL statement and it will provide recommendations
on how best to tune the query or suggestions:
Your help will be much appreciated
Jul 7 2008, 07:20 AM
oracle version? os?
Jul 7 2008, 07:51 AM
on 10g (and higher) is possible for gathering statistic use ADDM
(Automatic Database Diagnostic Monitor) available in OEM.
(without install STATSPACK)
Jul 7 2008, 09:19 AM
Thanks for you info, but this is not what I really want.
I am after a site or similar where I can paste the copy of a SQL statement and the tool/program and it will provide a recommendqtion of whqt to do with the statement. I mean if you are not specialised in SQL tuning, but need to improve the execution of the statement how can you do this in a simple way. We now have a way to upload statspack reports, saving you endless hours, hopefully there is something similar for SQL statements. ADDM and OEM do not do this
Jul 7 2008, 12:53 PM
"a site or similar where I can paste the copy of a SQL statement and the tool/program and it will provide a recommendqtion of whqt to do with the statement. "
I've never heard of one.
SQL tuning depends on dictionary statistics, the external I/O system, and many other things besides the SQL statement itself.
Here is a list of the step of SQL tuning:http://www.dba-oracle.com/art_sql_tune.htm
Jul 9 2008, 07:40 AM
without sounding condesending, still not getting the correct feedback.
Without knowing much about Oracle Perf, I can generate a statspack report,
upload that report and recieve recommendations, based on the values in my statspack.
I was hoping that there is something similar for SQL statements which run for a length
of time. I do not want to relearn SQL (time issue) as I am only standing in for the official
DBA who returns on Monday.
I would have expected that there is a tool, which takes the statement and makes
recommendations on the efficiency and resource cost of the code.
Jul 9 2008, 07:56 AM
"I was hoping that there is something similar for SQL statements "
No, there is not.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here